/// <summary> /// 得到一个对象实体 /// </summary> public Mod_TRC_ROLL_WGD_LOG GetModel(string C_PLAN_ID, int type) { StringBuilder strSql = new StringBuilder(); strSql.Append("select C_ID,C_STA_ID,C_PLANT,C_STOVE,C_BATCH_NO,C_PLAN_ID,N_QUA_PRODUCE,N_WGT_PRODUCE,D_MOD_DT,C_ROLL_STATE,C_FUR_TYPE,C_REMARK,N_STATUS,C_STD_CODE,C_STL_GRD,C_SPEC,D_PRODUCE_DATE,C_PRODUCE_EMP_ID,C_PRODUCE_SHIFT,C_PRODUCE_GROUP,C_SX,C_PCLX,C_MAIN_ID,C_SCX_NC,C_PACK,C_FREE_TERM,C_FREE_TERM2,C_AREA,C_ZPDJBZ,N_SCRF,C_MRSX,D_PRODUCE_DATE_B,D_PRODUCE_DATE_E,C_MAT_CODE,C_MAT_DESC from TRC_ROLL_WGD_LOG "); strSql.Append(" where C_PLAN_ID=:C_PLAN_ID "); OracleParameter[] parameters = { new OracleParameter(":C_PLAN_ID", OracleDbType.Varchar2, 100) }; parameters[0].Value = C_PLAN_ID; Mod_TRC_ROLL_WGD_LOG model = new Mod_TRC_ROLL_WGD_LOG(); DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Mod_TRC_ROLL_WGD_LOG model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Mod_TRC_ROLL_WGD_LOG model) { return(dal.Add(model)); }
public string WgdBackHandler(DataRow dr) { string result = "1"; try { Mod_TRC_ROLL_WGD_LOG modelLog = new Mod_TRC_ROLL_WGD_LOG(); modelLog.C_ID = Guid.NewGuid().ToString(); modelLog.C_STA_ID = dr["C_STA_ID"].ToString(); modelLog.C_STOVE = dr["C_STOVE"].ToString(); modelLog.C_BATCH_NO = dr["C_BATCH_NO"].ToString(); modelLog.C_PLAN_ID = dr["C_PLAN_ID"].ToString(); modelLog.N_QUA_PRODUCE = decimal.Parse(dr["N_QUA_PRODUCE"].ToString()); modelLog.N_WGT_PRODUCE = decimal.Parse(dr["N_WGT_PRODUCE"].ToString()); modelLog.N_STATUS = 3; modelLog.C_STD_CODE = dr["C_STD_CODE"].ToString(); modelLog.C_STL_GRD = dr["C_STL_GRD"].ToString(); modelLog.C_SPEC = dr["C_SPEC"].ToString(); modelLog.C_MAIN_ID = dr["C_MAIN_ID"].ToString(); modelLog.D_PRODUCE_DATE_B = DateTime.Parse(dr["D_PRODUCE_DATE_B"].ToString()); modelLog.D_PRODUCE_DATE_E = DateTime.Parse(dr["D_PRODUCE_DATE_E"].ToString()); modelLog.C_PRODUCE_SHIFT = dr["C_PRODUCE_SHIFT"].ToString(); modelLog.C_PRODUCE_GROUP = dr["C_PRODUCE_GROUP"].ToString(); modelLog.C_PRODUCE_EMP_ID = RV.UI.UserInfo.userID; modelLog.D_MOD_DT = DateTime.Now; modelLog.D_PRODUCE_DATE = DateTime.Parse(dr["D_PRODUCE_DATE"].ToString()); modelLog.C_FREE_TERM = dr["C_FREE_TERM"].ToString(); modelLog.C_FREE_TERM2 = dr["C_FREE_TERM2"].ToString(); modelLog.C_PACK = dr["C_PACK"].ToString(); modelLog.C_AREA = dr["C_AREA"].ToString(); modelLog.C_PCLX = dr["C_PCLX"].ToString(); wgdDalLog.Add(modelLog); TransactionHelper.BeginTransaction(); if (!wgdDal.UpdateRollStatus(modelLog.C_MAIN_ID, 0)) { TransactionHelper.RollBack(); return("0"); } //if (!wgdDal.Delete(dr["C_ID"].ToString())) //{ // TransactionHelper.RollBack(); // return "0"; //} //if (!wgdItemDal.Delete(dr["C_ID"].ToString())) //{ // TransactionHelper.RollBack(); // return "0"; //} if (dal_TRC_WARM_FURNACE.UpdateWarmFurnaceRolleState(dr["C_MAIN_ID"].ToString(), 2, 3) == 0) { TransactionHelper.RollBack(); return("0"); } TransactionHelper.Commit(); } catch (Exception e) { TransactionHelper.RollBack(); return("0"); } return(result); }
private void AddLog(string stove, string batchNo, string planID, int num, decimal wgt, string grd, string spec, string std, string id, string staID, DateTime start, DateTime end, string shift, string group, Mod_TRC_ROLL_WGD model, Mod_TRP_PLAN_ROLL_ITEM planM, DataTable dt) { Mod_TRC_ROLL_WGD_LOG modelLog = new Mod_TRC_ROLL_WGD_LOG(); modelLog.C_ID = Guid.NewGuid().ToString(); modelLog.C_STA_ID = staID; modelLog.C_STOVE = stove; modelLog.C_BATCH_NO = batchNo; modelLog.C_PLAN_ID = planID; modelLog.N_QUA_PRODUCE = num; modelLog.N_WGT_PRODUCE = wgt; modelLog.N_STATUS = 2; modelLog.C_STD_CODE = std; modelLog.C_STL_GRD = grd; modelLog.C_SPEC = spec; modelLog.C_MAIN_ID = id; modelLog.D_PRODUCE_DATE_B = start; modelLog.D_PRODUCE_DATE_E = end; modelLog.C_PRODUCE_SHIFT = shift; modelLog.C_PRODUCE_GROUP = group; modelLog.C_PRODUCE_EMP_ID = RV.UI.UserInfo.userID; modelLog.D_MOD_DT = DateTime.Now; modelLog.D_PRODUCE_DATE = model.D_PRODUCE_DATE_B; modelLog.C_FREE_TERM = planM.C_FREE_TERM; modelLog.C_FREE_TERM2 = planM.C_FREE_TERM2; modelLog.C_PACK = planM.C_PACK; modelLog.C_AREA = planM.C_AREA; modelLog.C_PCLX = planM.C_PCLX; modelLog.C_MAT_CODE = planM.C_MAT_CODE; modelLog.C_MAT_DESC = planM.C_MAT_NAME; wgdDalLog.Add(modelLog); if (dt != null && dt.Rows.Count > 0) { Mod_TRC_ROLL_WGD_ITEM_LOG itemM = new Mod_TRC_ROLL_WGD_ITEM_LOG(); itemM.C_MAIN_ID = model.C_MAIN_ID; itemM.C_ROLL_WGD_ID = model.C_ID; itemM.C_BATCH_NO = batchNo; itemM.N_STATUS = 2; itemM.C_STL_GRD = model.C_STL_GRD; itemM.C_STD_CODE = model.C_STD_CODE; itemM.C_SPEC = model.C_SPEC; itemM.C_MAT_CODE = planM.C_MAT_CODE; itemM.C_MAT_DESC = planM.C_MAT_NAME; itemM.C_ZYX1 = planM.C_FREE_TERM; itemM.C_ZYX2 = planM.C_FREE_TERM2; itemM.C_BZYQ = model.C_PACK; itemM.C_SALE_AREA = model.C_AREA; wgdItemDalLog.Add(itemM); foreach (DataRow item in dt.Rows) { Mod_TRC_ROLL_WGD_ITEM_LOG itemMM = new Mod_TRC_ROLL_WGD_ITEM_LOG(); itemMM.C_MAIN_ID = model.C_MAIN_ID; itemMM.C_ROLL_WGD_ID = model.C_ID; itemMM.C_BATCH_NO = batchNo; itemMM.N_STATUS = 2; itemMM.C_STL_GRD = item["钢种"].ToString(); itemMM.C_STD_CODE = item["执行标准"].ToString(); itemMM.C_SPEC = item["规格"].ToString(); itemMM.C_MAT_CODE = item["物料编码"].ToString(); itemMM.C_MAT_DESC = item["物料名称"].ToString(); itemMM.C_ZYX1 = item["自由项1"].ToString(); itemMM.C_ZYX2 = item["自由项2"].ToString(); itemMM.C_BZYQ = model.C_PACK; itemMM.C_SALE_AREA = model.C_AREA; wgdItemDalLog.Add(itemMM); } } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Mod_TRC_ROLL_WGD_LOG model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TRC_ROLL_WGD_LOG("); strSql.Append("C_STA_ID,C_PLANT,C_STOVE,C_BATCH_NO,C_PLAN_ID,N_QUA_PRODUCE,N_WGT_PRODUCE,D_MOD_DT,C_ROLL_STATE,C_FUR_TYPE,C_REMARK,N_STATUS,C_STD_CODE,C_STL_GRD,C_SPEC,D_PRODUCE_DATE,C_PRODUCE_EMP_ID,C_PRODUCE_SHIFT,C_PRODUCE_GROUP,C_SX,C_PCLX,C_MAIN_ID,C_SCX_NC,C_PACK,C_FREE_TERM,C_FREE_TERM2,C_AREA,C_MRSX,D_PRODUCE_DATE_B,D_PRODUCE_DATE_E,C_MAT_CODE,C_MAT_DESC)"); strSql.Append(" values ("); strSql.Append(":C_STA_ID,:C_PLANT,:C_STOVE,:C_BATCH_NO,:C_PLAN_ID,:N_QUA_PRODUCE,:N_WGT_PRODUCE,:D_MOD_DT,:C_ROLL_STATE,:C_FUR_TYPE,:C_REMARK,:N_STATUS,:C_STD_CODE,:C_STL_GRD,:C_SPEC,:D_PRODUCE_DATE,:C_PRODUCE_EMP_ID,:C_PRODUCE_SHIFT,:C_PRODUCE_GROUP,:C_SX,:C_PCLX,:C_MAIN_ID,:C_SCX_NC,:C_PACK,:C_FREE_TERM,:C_FREE_TERM2,:C_AREA,:C_MRSX,:D_PRODUCE_DATE_B,:D_PRODUCE_DATE_E,:C_MAT_CODE,:C_MAT_DESC)"); OracleParameter[] parameters = { new OracleParameter(":C_STA_ID", OracleDbType.Varchar2, 100), new OracleParameter(":C_PLANT", OracleDbType.Varchar2, 100), new OracleParameter(":C_STOVE", OracleDbType.Varchar2, 100), new OracleParameter(":C_BATCH_NO", OracleDbType.Varchar2, 100), new OracleParameter(":C_PLAN_ID", OracleDbType.Varchar2, 100), new OracleParameter(":N_QUA_PRODUCE", OracleDbType.Int32, 15), new OracleParameter(":N_WGT_PRODUCE", OracleDbType.Int32, 15), new OracleParameter(":D_MOD_DT", OracleDbType.Date), new OracleParameter(":C_ROLL_STATE", OracleDbType.Int32, 15), new OracleParameter(":C_FUR_TYPE", OracleDbType.Varchar2, 100), new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 500), new OracleParameter(":N_STATUS", OracleDbType.Int32, 15), new OracleParameter(":C_STD_CODE", OracleDbType.Varchar2, 100), new OracleParameter(":C_STL_GRD", OracleDbType.Varchar2, 100), new OracleParameter(":C_SPEC", OracleDbType.Varchar2, 100), new OracleParameter(":D_PRODUCE_DATE", OracleDbType.Date), new OracleParameter(":C_PRODUCE_EMP_ID", OracleDbType.Varchar2, 100), new OracleParameter(":C_PRODUCE_SHIFT", OracleDbType.Varchar2, 100), new OracleParameter(":C_PRODUCE_GROUP", OracleDbType.Varchar2, 100), new OracleParameter(":C_SX", OracleDbType.Varchar2, 10), new OracleParameter(":C_PCLX", OracleDbType.Varchar2, 10), new OracleParameter(":C_MAIN_ID", OracleDbType.Varchar2, 100), new OracleParameter(":C_SCX_NC", OracleDbType.Varchar2, 100), new OracleParameter(":C_PACK", OracleDbType.Varchar2, 100), new OracleParameter(":C_FREE_TERM", OracleDbType.Varchar2, 300), new OracleParameter(":C_FREE_TERM2", OracleDbType.Varchar2, 300), new OracleParameter(":C_AREA", OracleDbType.Varchar2, 100), new OracleParameter(":C_MRSX", OracleDbType.Varchar2, 100), new OracleParameter(":D_PRODUCE_DATE_B", OracleDbType.Date), new OracleParameter(":D_PRODUCE_DATE_E", OracleDbType.Date), new OracleParameter(":C_MAT_CODE", OracleDbType.Varchar2, 100), new OracleParameter(":C_MAT_DESC", OracleDbType.Varchar2, 100) }; parameters[0].Value = model.C_STA_ID; parameters[1].Value = model.C_PLANT; parameters[2].Value = model.C_STOVE; parameters[3].Value = model.C_BATCH_NO; parameters[4].Value = model.C_PLAN_ID; parameters[5].Value = model.N_QUA_PRODUCE; parameters[6].Value = model.N_WGT_PRODUCE; parameters[7].Value = model.D_MOD_DT; parameters[8].Value = model.C_ROLL_STATE; parameters[9].Value = model.C_FUR_TYPE; parameters[10].Value = model.C_REMARK; parameters[11].Value = model.N_STATUS; parameters[12].Value = model.C_STD_CODE; parameters[13].Value = model.C_STL_GRD; parameters[14].Value = model.C_SPEC; parameters[15].Value = model.D_PRODUCE_DATE; parameters[16].Value = model.C_PRODUCE_EMP_ID; parameters[17].Value = model.C_PRODUCE_SHIFT; parameters[18].Value = model.C_PRODUCE_GROUP; parameters[19].Value = model.C_SX; parameters[20].Value = model.C_PCLX; parameters[21].Value = model.C_MAIN_ID; parameters[22].Value = model.C_SCX_NC; parameters[23].Value = model.C_PACK; parameters[24].Value = model.C_FREE_TERM; parameters[25].Value = model.C_FREE_TERM2; parameters[26].Value = model.C_AREA; parameters[27].Value = model.C_MRSX; parameters[28].Value = model.D_PRODUCE_DATE_B; parameters[29].Value = model.D_PRODUCE_DATE_E; parameters[30].Value = model.C_MAT_CODE; parameters[31].Value = model.C_MAT_DESC; int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Mod_TRC_ROLL_WGD_LOG DataRowToModel(DataRow row) { Mod_TRC_ROLL_WGD_LOG model = new Mod_TRC_ROLL_WGD_LOG(); if (row != null) { if (row["C_ID"] != null) { model.C_ID = row["C_ID"].ToString(); } if (row["C_STA_ID"] != null) { model.C_STA_ID = row["C_STA_ID"].ToString(); } if (row["C_PLANT"] != null) { model.C_PLANT = row["C_PLANT"].ToString(); } if (row["C_STOVE"] != null) { model.C_STOVE = row["C_STOVE"].ToString(); } if (row["C_BATCH_NO"] != null) { model.C_BATCH_NO = row["C_BATCH_NO"].ToString(); } if (row["C_PLAN_ID"] != null) { model.C_PLAN_ID = row["C_PLAN_ID"].ToString(); } if (row["N_QUA_PRODUCE"] != null && row["N_QUA_PRODUCE"].ToString() != "") { model.N_QUA_PRODUCE = decimal.Parse(row["N_QUA_PRODUCE"].ToString()); } if (row["N_WGT_PRODUCE"] != null && row["N_WGT_PRODUCE"].ToString() != "") { model.N_WGT_PRODUCE = decimal.Parse(row["N_WGT_PRODUCE"].ToString()); } if (row["D_MOD_DT"] != null && row["D_MOD_DT"].ToString() != "") { model.D_MOD_DT = DateTime.Parse(row["D_MOD_DT"].ToString()); } if (row["C_ROLL_STATE"] != null && row["C_ROLL_STATE"].ToString() != "") { model.C_ROLL_STATE = decimal.Parse(row["C_ROLL_STATE"].ToString()); } if (row["C_FUR_TYPE"] != null) { model.C_FUR_TYPE = row["C_FUR_TYPE"].ToString(); } if (row["C_REMARK"] != null) { model.C_REMARK = row["C_REMARK"].ToString(); } if (row["N_STATUS"] != null && row["N_STATUS"].ToString() != "") { model.N_STATUS = decimal.Parse(row["N_STATUS"].ToString()); } if (row["C_STD_CODE"] != null) { model.C_STD_CODE = row["C_STD_CODE"].ToString(); } if (row["C_STL_GRD"] != null) { model.C_STL_GRD = row["C_STL_GRD"].ToString(); } if (row["C_SPEC"] != null) { model.C_SPEC = row["C_SPEC"].ToString(); } if (row["D_PRODUCE_DATE"] != null && row["D_PRODUCE_DATE"].ToString() != "") { model.D_PRODUCE_DATE = DateTime.Parse(row["D_PRODUCE_DATE"].ToString()); } if (row["C_PRODUCE_EMP_ID"] != null) { model.C_PRODUCE_EMP_ID = row["C_PRODUCE_EMP_ID"].ToString(); } if (row["C_PRODUCE_SHIFT"] != null) { model.C_PRODUCE_SHIFT = row["C_PRODUCE_SHIFT"].ToString(); } if (row["C_PRODUCE_GROUP"] != null) { model.C_PRODUCE_GROUP = row["C_PRODUCE_GROUP"].ToString(); } if (row["C_SX"] != null) { model.C_SX = row["C_SX"].ToString(); } if (row["C_PCLX"] != null) { model.C_PCLX = row["C_PCLX"].ToString(); } if (row["C_MAIN_ID"] != null) { model.C_MAIN_ID = row["C_MAIN_ID"].ToString(); } if (row["C_SCX_NC"] != null) { model.C_SCX_NC = row["C_SCX_NC"].ToString(); } if (row["C_PACK"] != null) { model.C_PACK = row["C_PACK"].ToString(); } if (row["C_FREE_TERM"] != null) { model.C_FREE_TERM = row["C_FREE_TERM"].ToString(); } if (row["C_FREE_TERM2"] != null) { model.C_FREE_TERM2 = row["C_FREE_TERM2"].ToString(); } if (row["C_AREA"] != null) { model.C_AREA = row["C_AREA"].ToString(); } if (row["C_ZPDJBZ"] != null) { model.C_ZPDJBZ = row["C_ZPDJBZ"].ToString(); } if (row["N_SCRF"] != null && row["N_SCRF"].ToString() != "") { model.N_SCRF = decimal.Parse(row["N_SCRF"].ToString()); } if (row["C_MRSX"] != null) { model.C_MRSX = row["C_MRSX"].ToString(); } if (row["D_PRODUCE_DATE_B"] != null && row["D_PRODUCE_DATE_B"].ToString() != "") { model.D_PRODUCE_DATE_B = DateTime.Parse(row["D_PRODUCE_DATE_B"].ToString()); } if (row["D_PRODUCE_DATE_E"] != null && row["D_PRODUCE_DATE_E"].ToString() != "") { model.D_PRODUCE_DATE_E = DateTime.Parse(row["D_PRODUCE_DATE_E"].ToString()); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Mod_TRC_ROLL_WGD_LOG model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update TRC_ROLL_WGD_LOG set "); strSql.Append("C_STA_ID=:C_STA_ID,"); strSql.Append("C_PLANT=:C_PLANT,"); strSql.Append("C_STOVE=:C_STOVE,"); strSql.Append("C_BATCH_NO=:C_BATCH_NO,"); strSql.Append("C_PLAN_ID=:C_PLAN_ID,"); strSql.Append("N_QUA_PRODUCE=:N_QUA_PRODUCE,"); strSql.Append("N_WGT_PRODUCE=:N_WGT_PRODUCE,"); strSql.Append("D_MOD_DT=:D_MOD_DT,"); strSql.Append("C_ROLL_STATE=:C_ROLL_STATE,"); strSql.Append("C_FUR_TYPE=:C_FUR_TYPE,"); strSql.Append("C_REMARK=:C_REMARK,"); strSql.Append("N_STATUS=:N_STATUS,"); strSql.Append("C_STD_CODE=:C_STD_CODE,"); strSql.Append("C_STL_GRD=:C_STL_GRD,"); strSql.Append("C_SPEC=:C_SPEC,"); strSql.Append("D_PRODUCE_DATE=:D_PRODUCE_DATE,"); strSql.Append("C_PRODUCE_EMP_ID=:C_PRODUCE_EMP_ID,"); strSql.Append("C_PRODUCE_SHIFT=:C_PRODUCE_SHIFT,"); strSql.Append("C_PRODUCE_GROUP=:C_PRODUCE_GROUP,"); strSql.Append("C_SX=:C_SX,"); strSql.Append("C_PCLX=:C_PCLX,"); strSql.Append("C_MAIN_ID=:C_MAIN_ID,"); strSql.Append("C_SCX_NC=:C_SCX_NC,"); strSql.Append("C_PACK=:C_PACK,"); strSql.Append("C_FREE_TERM=:C_FREE_TERM,"); strSql.Append("C_FREE_TERM2=:C_FREE_TERM2,"); strSql.Append("C_AREA=:C_AREA,"); strSql.Append("C_ZPDJBZ=:C_ZPDJBZ,"); strSql.Append("N_SCRF=:N_SCRF,"); strSql.Append("C_MRSX=:C_MRSX,"); strSql.Append("D_PRODUCE_DATE_B=:D_PRODUCE_DATE_B,"); strSql.Append("D_PRODUCE_DATE_E=:D_PRODUCE_DATE_E"); strSql.Append("C_MAT_CODE=:C_MAT_CODE,"); strSql.Append("C_MAT_DESC=:C_MAT_DESC"); strSql.Append(" where C_ID=:C_ID "); OracleParameter[] parameters = { new OracleParameter(":C_STA_ID", OracleDbType.Varchar2, 100), new OracleParameter(":C_PLANT", OracleDbType.Varchar2, 100), new OracleParameter(":C_STOVE", OracleDbType.Varchar2, 100), new OracleParameter(":C_BATCH_NO", OracleDbType.Varchar2, 100), new OracleParameter(":C_PLAN_ID", OracleDbType.Varchar2, 100), new OracleParameter(":N_QUA_PRODUCE", OracleDbType.Int32, 15), new OracleParameter(":N_WGT_PRODUCE", OracleDbType.Int32, 15), new OracleParameter(":D_MOD_DT", OracleDbType.Date), new OracleParameter(":C_ROLL_STATE", OracleDbType.Int32, 15), new OracleParameter(":C_FUR_TYPE", OracleDbType.Varchar2, 100), new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 500), new OracleParameter(":N_STATUS", OracleDbType.Int32, 15), new OracleParameter(":C_STD_CODE", OracleDbType.Varchar2, 100), new OracleParameter(":C_STL_GRD", OracleDbType.Varchar2, 100), new OracleParameter(":C_SPEC", OracleDbType.Varchar2, 100), new OracleParameter(":D_PRODUCE_DATE", OracleDbType.Date), new OracleParameter(":C_PRODUCE_EMP_ID", OracleDbType.Varchar2, 100), new OracleParameter(":C_PRODUCE_SHIFT", OracleDbType.Varchar2, 100), new OracleParameter(":C_PRODUCE_GROUP", OracleDbType.Varchar2, 100), new OracleParameter(":C_SX", OracleDbType.Varchar2, 10), new OracleParameter(":C_PCLX", OracleDbType.Varchar2, 10), new OracleParameter(":C_MAIN_ID", OracleDbType.Varchar2, 100), new OracleParameter(":C_SCX_NC", OracleDbType.Varchar2, 100), new OracleParameter(":C_PACK", OracleDbType.Varchar2, 100), new OracleParameter(":C_FREE_TERM", OracleDbType.Varchar2, 300), new OracleParameter(":C_FREE_TERM2", OracleDbType.Varchar2, 300), new OracleParameter(":C_AREA", OracleDbType.Varchar2, 100), new OracleParameter(":C_ZPDJBZ", OracleDbType.Varchar2, 100), new OracleParameter(":N_SCRF", OracleDbType.Int32, 4), new OracleParameter(":C_MRSX", OracleDbType.Varchar2, 10), new OracleParameter(":D_PRODUCE_DATE_B", OracleDbType.Date), new OracleParameter(":D_PRODUCE_DATE_E", OracleDbType.Date), new OracleParameter(":C_MAT_CODE", OracleDbType.Varchar2, 100), new OracleParameter(":C_MAT_DESC", OracleDbType.Varchar2, 100), new OracleParameter(":C_ID", OracleDbType.Varchar2, 100) }; parameters[0].Value = model.C_STA_ID; parameters[1].Value = model.C_PLANT; parameters[2].Value = model.C_STOVE; parameters[3].Value = model.C_BATCH_NO; parameters[4].Value = model.C_PLAN_ID; parameters[5].Value = model.N_QUA_PRODUCE; parameters[6].Value = model.N_WGT_PRODUCE; parameters[7].Value = model.D_MOD_DT; parameters[8].Value = model.C_ROLL_STATE; parameters[9].Value = model.C_FUR_TYPE; parameters[10].Value = model.C_REMARK; parameters[11].Value = model.N_STATUS; parameters[12].Value = model.C_STD_CODE; parameters[13].Value = model.C_STL_GRD; parameters[14].Value = model.C_SPEC; parameters[15].Value = model.D_PRODUCE_DATE; parameters[16].Value = model.C_PRODUCE_EMP_ID; parameters[17].Value = model.C_PRODUCE_SHIFT; parameters[18].Value = model.C_PRODUCE_GROUP; parameters[19].Value = model.C_SX; parameters[20].Value = model.C_PCLX; parameters[21].Value = model.C_MAIN_ID; parameters[22].Value = model.C_SCX_NC; parameters[23].Value = model.C_PACK; parameters[24].Value = model.C_FREE_TERM; parameters[25].Value = model.C_FREE_TERM2; parameters[26].Value = model.C_AREA; parameters[27].Value = model.C_ZPDJBZ; parameters[28].Value = model.N_SCRF; parameters[29].Value = model.C_MRSX; parameters[30].Value = model.D_PRODUCE_DATE_B; parameters[31].Value = model.D_PRODUCE_DATE_E; parameters[32].Value = model.C_MAT_CODE; parameters[33].Value = model.C_MAT_DESC; parameters[34].Value = model.C_ID; int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }