在CIMES中调用存储过程

页面

 

 

调用步骤

 

 

DataTable dtResult = null;
CustomDataAgent TODB_con = DBCenter.Create(AppSetting.ManufacturingDatabaseConnection);
string strSql = string.Empty;
var procedure = TODB_con.GetStoredProcedure("sp_TO_25G_Grade_Function");
procedure.AddInParameter("@FunctionType", DbType.String, FuntionType);
procedure.AddInParameter("@Lot", DbType.String, Lot);
procedure.AddInParameter("@Box", DbType.String, Box);
TODB_con.ExecuteStoredProcedure(procedure);
TODB_con.ExecuteStoredProcedure(procedure, out dtResult);