/// <summary> /// 增加一条数据 /// </summary> public bool Add_Trans(Mod_TRP_PLAN_ITEM_TEST model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TRP_PLAN_ITEM_TEST("); strSql.Append("C_PLAN_ROLL_ID,N_STATUS,C_INITIALIZE_ITEM_ID,C_ORDER_NO,N_WGT,C_MAT_CODE,C_MAT_NAME,C_TECH_PROT,C_SPEC,C_STL_GRD,C_STD_CODE,N_USER_LEV,N_STL_GRD_LEV,N_ORDER_LEV,C_QUALIRY_LEV,D_NEED_DT,D_DELIVERY_DT,D_DT,C_LINE_DESC,C_LINE_CODE,D_P_START_TIME,D_P_END_TIME,N_PROD_TIME,N_SORT,N_ROLL_PROD_WGT,C_ROLL_PROD_EMP_ID,C_STL_ROL_DT,N_PROD_WGT,N_WARE_WGT,N_WARE_OUT_WGT,N_FLAG,N_ISSUE_WGT,C_CUST_NO,C_CUST_NAME,C_SALE_CHANNEL,C_PACK,C_DESIGN_NO,N_GROUP_WGT,C_STA_ID,D_START_TIME,D_END_TIME,C_EMP_ID,N_ROLL_WGT,N_MACH_WGT,C_CAST_NO,C_INITIALIZE_ID,C_FREE_TERM,C_FREE_TERM2,C_AREA,C_PCLX,C_SFHL,D_HL_START_TIME,D_HL_END_TIME,C_SFHL_D,D_DHL_START_TIME,D_DHL_END_TIME,C_SFKP,D_KP_START_TIME,D_KP_END_TIME,C_SFXM,D_XM_START_TIME,D_XM_END_TIME,N_UPLOADSTATUS,C_MATRL_CODE_SLAB,C_MATRL_NAME_SLAB,C_SLAB_SIZE,N_SLAB_LENGTH,N_SLAB_PW,D_CAN_ROLL_TIME,C_ROUTE,N_DIAMETER,C_XM_YQ,N_JRL_WD,N_JRL_SJ,C_STL_GRD_SLAB,C_STD_CODE_SLAB)"); strSql.Append(" values ("); strSql.Append(":C_PLAN_ROLL_ID,:N_STATUS,:C_INITIALIZE_ITEM_ID,:C_ORDER_NO,:N_WGT,:C_MAT_CODE,:C_MAT_NAME,:C_TECH_PROT,:C_SPEC,:C_STL_GRD,:C_STD_CODE,:N_USER_LEV,:N_STL_GRD_LEV,:N_ORDER_LEV,:C_QUALIRY_LEV,:D_NEED_DT,:D_DELIVERY_DT,:D_DT,:C_LINE_DESC,:C_LINE_CODE,:D_P_START_TIME,:D_P_END_TIME,:N_PROD_TIME,:N_SORT,:N_ROLL_PROD_WGT,:C_ROLL_PROD_EMP_ID,:C_STL_ROL_DT,:N_PROD_WGT,:N_WARE_WGT,:N_WARE_OUT_WGT,:N_FLAG,:N_ISSUE_WGT,:C_CUST_NO,:C_CUST_NAME,:C_SALE_CHANNEL,:C_PACK,:C_DESIGN_NO,:N_GROUP_WGT,:C_STA_ID,:D_START_TIME,:D_END_TIME,:C_EMP_ID,:N_ROLL_WGT,:N_MACH_WGT,:C_CAST_NO,:C_INITIALIZE_ID,:C_FREE_TERM,:C_FREE_TERM2,:C_AREA,:C_PCLX,:C_SFHL,:D_HL_START_TIME,:D_HL_END_TIME,:C_SFHL_D,:D_DHL_START_TIME,:D_DHL_END_TIME,:C_SFKP,:D_KP_START_TIME,:D_KP_END_TIME,:C_SFXM,:D_XM_START_TIME,:D_XM_END_TIME,:N_UPLOADSTATUS,:C_MATRL_CODE_SLAB,:C_MATRL_NAME_SLAB,:C_SLAB_SIZE,:N_SLAB_LENGTH,:N_SLAB_PW,:D_CAN_ROLL_TIME,:C_ROUTE,:N_DIAMETER,:C_XM_YQ,:N_JRL_WD,:N_JRL_SJ,:C_STL_GRD_SLAB,:C_STD_CODE_SLAB)"); OracleParameter[] parameters = { new OracleParameter(":C_PLAN_ROLL_ID", OracleDbType.Varchar2, 100), new OracleParameter(":N_STATUS", OracleDbType.Decimal, 1), new OracleParameter(":C_INITIALIZE_ITEM_ID", OracleDbType.Varchar2, 100), new OracleParameter(":C_ORDER_NO", OracleDbType.Varchar2, 100), new OracleParameter(":N_WGT", OracleDbType.Decimal, 15), new OracleParameter(":C_MAT_CODE", OracleDbType.Varchar2, 100), new OracleParameter(":C_MAT_NAME", OracleDbType.Varchar2, 100), new OracleParameter(":C_TECH_PROT", OracleDbType.Varchar2, 100), new OracleParameter(":C_SPEC", OracleDbType.Varchar2, 100), new OracleParameter(":C_STL_GRD", OracleDbType.Varchar2, 100), new OracleParameter(":C_STD_CODE", OracleDbType.Varchar2, 100), new OracleParameter(":N_USER_LEV", OracleDbType.Decimal, 5), new OracleParameter(":N_STL_GRD_LEV", OracleDbType.Decimal, 5), new OracleParameter(":N_ORDER_LEV", OracleDbType.Decimal, 5), new OracleParameter(":C_QUALIRY_LEV", OracleDbType.Varchar2, 100), new OracleParameter(":D_NEED_DT", OracleDbType.Date), new OracleParameter(":D_DELIVERY_DT", OracleDbType.Date), new OracleParameter(":D_DT", OracleDbType.Date), new OracleParameter(":C_LINE_DESC", OracleDbType.Varchar2, 100), new OracleParameter(":C_LINE_CODE", OracleDbType.Varchar2, 100), new OracleParameter(":D_P_START_TIME", OracleDbType.Date), new OracleParameter(":D_P_END_TIME", OracleDbType.Date), new OracleParameter(":N_PROD_TIME", OracleDbType.Decimal, 5), new OracleParameter(":N_SORT", OracleDbType.Decimal, 5), new OracleParameter(":N_ROLL_PROD_WGT", OracleDbType.Decimal, 5), new OracleParameter(":C_ROLL_PROD_EMP_ID", OracleDbType.Varchar2, 100), new OracleParameter(":C_STL_ROL_DT", OracleDbType.Varchar2, 100), new OracleParameter(":N_PROD_WGT", OracleDbType.Decimal, 5), new OracleParameter(":N_WARE_WGT", OracleDbType.Decimal, 5), new OracleParameter(":N_WARE_OUT_WGT", OracleDbType.Decimal, 5), new OracleParameter(":N_FLAG", OracleDbType.Decimal, 5), new OracleParameter(":N_ISSUE_WGT", OracleDbType.Decimal, 5), new OracleParameter(":C_CUST_NO", OracleDbType.Varchar2, 100), new OracleParameter(":C_CUST_NAME", OracleDbType.Varchar2, 100), new OracleParameter(":C_SALE_CHANNEL", OracleDbType.Varchar2, 100), new OracleParameter(":C_PACK", OracleDbType.Varchar2, 100), new OracleParameter(":C_DESIGN_NO", OracleDbType.Varchar2, 100), new OracleParameter(":N_GROUP_WGT", OracleDbType.Decimal, 5), new OracleParameter(":C_STA_ID", OracleDbType.Varchar2, 100), new OracleParameter(":D_START_TIME", OracleDbType.Date), new OracleParameter(":D_END_TIME", OracleDbType.Date), new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 100), new OracleParameter(":N_ROLL_WGT", OracleDbType.Decimal, 5), new OracleParameter(":N_MACH_WGT", OracleDbType.Decimal, 15), new OracleParameter(":C_CAST_NO", OracleDbType.Varchar2, 100), new OracleParameter(":C_INITIALIZE_ID", 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_PCLX", OracleDbType.Varchar2, 10), new OracleParameter(":C_SFHL", OracleDbType.Varchar2, 10), new OracleParameter(":D_HL_START_TIME", OracleDbType.Date), new OracleParameter(":D_HL_END_TIME", OracleDbType.Date), new OracleParameter(":C_SFHL_D", OracleDbType.Varchar2, 10), new OracleParameter(":D_DHL_START_TIME", OracleDbType.Date), new OracleParameter(":D_DHL_END_TIME", OracleDbType.Date), new OracleParameter(":C_SFKP", OracleDbType.Varchar2, 10), new OracleParameter(":D_KP_START_TIME", OracleDbType.Date), new OracleParameter(":D_KP_END_TIME", OracleDbType.Date), new OracleParameter(":C_SFXM", OracleDbType.Varchar2, 10), new OracleParameter(":D_XM_START_TIME", OracleDbType.Date), new OracleParameter(":D_XM_END_TIME", OracleDbType.Date), new OracleParameter(":N_UPLOADSTATUS", OracleDbType.Decimal, 1), new OracleParameter(":C_MATRL_CODE_SLAB", OracleDbType.Varchar2, 100), new OracleParameter(":C_MATRL_NAME_SLAB", OracleDbType.Varchar2, 100), new OracleParameter(":C_SLAB_SIZE", OracleDbType.Varchar2, 100), new OracleParameter(":N_SLAB_LENGTH", OracleDbType.Decimal, 15), new OracleParameter(":N_SLAB_PW", OracleDbType.Decimal, 15), new OracleParameter(":D_CAN_ROLL_TIME", OracleDbType.Date), new OracleParameter(":C_ROUTE", OracleDbType.Varchar2, 100), new OracleParameter(":N_DIAMETER", OracleDbType.Decimal, 4), new OracleParameter(":C_XM_YQ", OracleDbType.Varchar2, 1000), new OracleParameter(":N_JRL_WD", OracleDbType.Decimal, 10), new OracleParameter(":N_JRL_SJ", OracleDbType.Decimal, 10), new OracleParameter(":C_STL_GRD_SLAB", OracleDbType.Varchar2, 100), new OracleParameter(":C_STD_CODE_SLAB", OracleDbType.Varchar2, 100) }; parameters[0].Value = model.C_PLAN_ROLL_ID; parameters[1].Value = model.N_STATUS; parameters[2].Value = model.C_INITIALIZE_ITEM_ID; parameters[3].Value = model.C_ORDER_NO; parameters[4].Value = model.N_WGT; parameters[5].Value = model.C_MAT_CODE; parameters[6].Value = model.C_MAT_NAME; parameters[7].Value = model.C_TECH_PROT; parameters[8].Value = model.C_SPEC; parameters[9].Value = model.C_STL_GRD; parameters[10].Value = model.C_STD_CODE; parameters[11].Value = model.N_USER_LEV; parameters[12].Value = model.N_STL_GRD_LEV; parameters[13].Value = model.N_ORDER_LEV; parameters[14].Value = model.C_QUALIRY_LEV; parameters[15].Value = model.D_NEED_DT; parameters[16].Value = model.D_DELIVERY_DT; parameters[17].Value = model.D_DT; parameters[18].Value = model.C_LINE_DESC; parameters[19].Value = model.C_LINE_CODE; parameters[20].Value = model.D_P_START_TIME; parameters[21].Value = model.D_P_END_TIME; parameters[22].Value = model.N_PROD_TIME; parameters[23].Value = model.N_SORT; parameters[24].Value = model.N_ROLL_PROD_WGT; parameters[25].Value = model.C_ROLL_PROD_EMP_ID; parameters[26].Value = model.C_STL_ROL_DT; parameters[27].Value = model.N_PROD_WGT; parameters[28].Value = model.N_WARE_WGT; parameters[29].Value = model.N_WARE_OUT_WGT; parameters[30].Value = model.N_FLAG; parameters[31].Value = model.N_ISSUE_WGT; parameters[32].Value = model.C_CUST_NO; parameters[33].Value = model.C_CUST_NAME; parameters[34].Value = model.C_SALE_CHANNEL; parameters[35].Value = model.C_PACK; parameters[36].Value = model.C_DESIGN_NO; parameters[37].Value = model.N_GROUP_WGT; parameters[38].Value = model.C_STA_ID; parameters[39].Value = model.D_START_TIME; parameters[40].Value = model.D_END_TIME; parameters[41].Value = model.C_EMP_ID; parameters[42].Value = model.N_ROLL_WGT; parameters[43].Value = model.N_MACH_WGT; parameters[44].Value = model.C_CAST_NO; parameters[45].Value = model.C_INITIALIZE_ID; parameters[46].Value = model.C_FREE_TERM; parameters[47].Value = model.C_FREE_TERM2; parameters[48].Value = model.C_AREA; parameters[49].Value = model.C_PCLX; parameters[50].Value = model.C_SFHL; parameters[51].Value = model.D_HL_START_TIME; parameters[52].Value = model.D_HL_END_TIME; parameters[53].Value = model.C_SFHL_D; parameters[54].Value = model.D_DHL_START_TIME; parameters[55].Value = model.D_DHL_END_TIME; parameters[56].Value = model.C_SFKP; parameters[57].Value = model.D_KP_START_TIME; parameters[58].Value = model.D_KP_END_TIME; parameters[59].Value = model.C_SFXM; parameters[60].Value = model.D_XM_START_TIME; parameters[61].Value = model.D_XM_END_TIME; parameters[62].Value = model.N_UPLOADSTATUS; parameters[63].Value = model.C_MATRL_CODE_SLAB; parameters[64].Value = model.C_MATRL_NAME_SLAB; parameters[65].Value = model.C_SLAB_SIZE; parameters[66].Value = model.N_SLAB_LENGTH; parameters[67].Value = model.N_SLAB_PW; parameters[68].Value = model.D_CAN_ROLL_TIME; parameters[69].Value = model.C_ROUTE; parameters[70].Value = model.N_DIAMETER; parameters[71].Value = model.C_XM_YQ; parameters[72].Value = model.N_JRL_WD; parameters[73].Value = model.N_JRL_SJ; parameters[74].Value = model.C_STL_GRD_SLAB; parameters[75].Value = model.C_STD_CODE_SLAB; int rows = TransactionHelper.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Mod_TRP_PLAN_ITEM_TEST DataRowToModel(DataRow row) { Mod_TRP_PLAN_ITEM_TEST model = new Mod_TRP_PLAN_ITEM_TEST(); if (row != null) { if (row["C_ID"] != null) { model.C_ID = row["C_ID"].ToString(); } if (row["C_PLAN_ROLL_ID"] != null) { model.C_PLAN_ROLL_ID = row["C_PLAN_ROLL_ID"].ToString(); } if (row["N_STATUS"] != null && row["N_STATUS"].ToString() != "") { model.N_STATUS = decimal.Parse(row["N_STATUS"].ToString()); } if (row["C_INITIALIZE_ITEM_ID"] != null) { model.C_INITIALIZE_ITEM_ID = row["C_INITIALIZE_ITEM_ID"].ToString(); } if (row["C_ORDER_NO"] != null) { model.C_ORDER_NO = row["C_ORDER_NO"].ToString(); } if (row["N_WGT"] != null && row["N_WGT"].ToString() != "") { model.N_WGT = decimal.Parse(row["N_WGT"].ToString()); } if (row["C_MAT_CODE"] != null) { model.C_MAT_CODE = row["C_MAT_CODE"].ToString(); } if (row["C_MAT_NAME"] != null) { model.C_MAT_NAME = row["C_MAT_NAME"].ToString(); } if (row["C_TECH_PROT"] != null) { model.C_TECH_PROT = row["C_TECH_PROT"].ToString(); } if (row["C_SPEC"] != null) { model.C_SPEC = row["C_SPEC"].ToString(); } if (row["C_STL_GRD"] != null) { model.C_STL_GRD = row["C_STL_GRD"].ToString(); } if (row["C_STD_CODE"] != null) { model.C_STD_CODE = row["C_STD_CODE"].ToString(); } if (row["N_USER_LEV"] != null && row["N_USER_LEV"].ToString() != "") { model.N_USER_LEV = decimal.Parse(row["N_USER_LEV"].ToString()); } if (row["N_STL_GRD_LEV"] != null && row["N_STL_GRD_LEV"].ToString() != "") { model.N_STL_GRD_LEV = decimal.Parse(row["N_STL_GRD_LEV"].ToString()); } if (row["N_ORDER_LEV"] != null && row["N_ORDER_LEV"].ToString() != "") { model.N_ORDER_LEV = decimal.Parse(row["N_ORDER_LEV"].ToString()); } if (row["C_QUALIRY_LEV"] != null) { model.C_QUALIRY_LEV = row["C_QUALIRY_LEV"].ToString(); } if (row["D_NEED_DT"] != null && row["D_NEED_DT"].ToString() != "") { model.D_NEED_DT = DateTime.Parse(row["D_NEED_DT"].ToString()); } if (row["D_DELIVERY_DT"] != null && row["D_DELIVERY_DT"].ToString() != "") { model.D_DELIVERY_DT = DateTime.Parse(row["D_DELIVERY_DT"].ToString()); } if (row["D_DT"] != null && row["D_DT"].ToString() != "") { model.D_DT = DateTime.Parse(row["D_DT"].ToString()); } if (row["C_LINE_DESC"] != null) { model.C_LINE_DESC = row["C_LINE_DESC"].ToString(); } if (row["C_LINE_CODE"] != null) { model.C_LINE_CODE = row["C_LINE_CODE"].ToString(); } if (row["D_P_START_TIME"] != null && row["D_P_START_TIME"].ToString() != "") { model.D_P_START_TIME = DateTime.Parse(row["D_P_START_TIME"].ToString()); } if (row["D_P_END_TIME"] != null && row["D_P_END_TIME"].ToString() != "") { model.D_P_END_TIME = DateTime.Parse(row["D_P_END_TIME"].ToString()); } if (row["N_PROD_TIME"] != null && row["N_PROD_TIME"].ToString() != "") { model.N_PROD_TIME = decimal.Parse(row["N_PROD_TIME"].ToString()); } if (row["N_SORT"] != null && row["N_SORT"].ToString() != "") { model.N_SORT = decimal.Parse(row["N_SORT"].ToString()); } if (row["N_ROLL_PROD_WGT"] != null && row["N_ROLL_PROD_WGT"].ToString() != "") { model.N_ROLL_PROD_WGT = decimal.Parse(row["N_ROLL_PROD_WGT"].ToString()); } if (row["C_ROLL_PROD_EMP_ID"] != null) { model.C_ROLL_PROD_EMP_ID = row["C_ROLL_PROD_EMP_ID"].ToString(); } if (row["C_STL_ROL_DT"] != null) { model.C_STL_ROL_DT = row["C_STL_ROL_DT"].ToString(); } if (row["N_PROD_WGT"] != null && row["N_PROD_WGT"].ToString() != "") { model.N_PROD_WGT = decimal.Parse(row["N_PROD_WGT"].ToString()); } if (row["N_WARE_WGT"] != null && row["N_WARE_WGT"].ToString() != "") { model.N_WARE_WGT = decimal.Parse(row["N_WARE_WGT"].ToString()); } if (row["N_WARE_OUT_WGT"] != null && row["N_WARE_OUT_WGT"].ToString() != "") { model.N_WARE_OUT_WGT = decimal.Parse(row["N_WARE_OUT_WGT"].ToString()); } if (row["N_FLAG"] != null && row["N_FLAG"].ToString() != "") { model.N_FLAG = decimal.Parse(row["N_FLAG"].ToString()); } if (row["N_ISSUE_WGT"] != null && row["N_ISSUE_WGT"].ToString() != "") { model.N_ISSUE_WGT = decimal.Parse(row["N_ISSUE_WGT"].ToString()); } if (row["C_CUST_NO"] != null) { model.C_CUST_NO = row["C_CUST_NO"].ToString(); } if (row["C_CUST_NAME"] != null) { model.C_CUST_NAME = row["C_CUST_NAME"].ToString(); } if (row["C_SALE_CHANNEL"] != null) { model.C_SALE_CHANNEL = row["C_SALE_CHANNEL"].ToString(); } if (row["C_PACK"] != null) { model.C_PACK = row["C_PACK"].ToString(); } if (row["C_DESIGN_NO"] != null) { model.C_DESIGN_NO = row["C_DESIGN_NO"].ToString(); } if (row["N_GROUP_WGT"] != null && row["N_GROUP_WGT"].ToString() != "") { model.N_GROUP_WGT = decimal.Parse(row["N_GROUP_WGT"].ToString()); } if (row["C_STA_ID"] != null) { model.C_STA_ID = row["C_STA_ID"].ToString(); } if (row["D_START_TIME"] != null && row["D_START_TIME"].ToString() != "") { model.D_START_TIME = DateTime.Parse(row["D_START_TIME"].ToString()); } if (row["D_END_TIME"] != null && row["D_END_TIME"].ToString() != "") { model.D_END_TIME = DateTime.Parse(row["D_END_TIME"].ToString()); } if (row["C_EMP_ID"] != null) { model.C_EMP_ID = row["C_EMP_ID"].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["N_ROLL_WGT"] != null && row["N_ROLL_WGT"].ToString() != "") { model.N_ROLL_WGT = decimal.Parse(row["N_ROLL_WGT"].ToString()); } if (row["N_MACH_WGT"] != null && row["N_MACH_WGT"].ToString() != "") { model.N_MACH_WGT = decimal.Parse(row["N_MACH_WGT"].ToString()); } if (row["C_CAST_NO"] != null) { model.C_CAST_NO = row["C_CAST_NO"].ToString(); } if (row["C_INITIALIZE_ID"] != null) { model.C_INITIALIZE_ID = row["C_INITIALIZE_ID"].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_PCLX"] != null) { model.C_PCLX = row["C_PCLX"].ToString(); } if (row["C_SFHL"] != null) { model.C_SFHL = row["C_SFHL"].ToString(); } if (row["D_HL_START_TIME"] != null && row["D_HL_START_TIME"].ToString() != "") { model.D_HL_START_TIME = DateTime.Parse(row["D_HL_START_TIME"].ToString()); } if (row["D_HL_END_TIME"] != null && row["D_HL_END_TIME"].ToString() != "") { model.D_HL_END_TIME = DateTime.Parse(row["D_HL_END_TIME"].ToString()); } if (row["C_SFHL_D"] != null) { model.C_SFHL_D = row["C_SFHL_D"].ToString(); } if (row["D_DHL_START_TIME"] != null && row["D_DHL_START_TIME"].ToString() != "") { model.D_DHL_START_TIME = DateTime.Parse(row["D_DHL_START_TIME"].ToString()); } if (row["D_DHL_END_TIME"] != null && row["D_DHL_END_TIME"].ToString() != "") { model.D_DHL_END_TIME = DateTime.Parse(row["D_DHL_END_TIME"].ToString()); } if (row["C_SFKP"] != null) { model.C_SFKP = row["C_SFKP"].ToString(); } if (row["D_KP_START_TIME"] != null && row["D_KP_START_TIME"].ToString() != "") { model.D_KP_START_TIME = DateTime.Parse(row["D_KP_START_TIME"].ToString()); } if (row["D_KP_END_TIME"] != null && row["D_KP_END_TIME"].ToString() != "") { model.D_KP_END_TIME = DateTime.Parse(row["D_KP_END_TIME"].ToString()); } if (row["C_SFXM"] != null) { model.C_SFXM = row["C_SFXM"].ToString(); } if (row["D_XM_START_TIME"] != null && row["D_XM_START_TIME"].ToString() != "") { model.D_XM_START_TIME = DateTime.Parse(row["D_XM_START_TIME"].ToString()); } if (row["D_XM_END_TIME"] != null && row["D_XM_END_TIME"].ToString() != "") { model.D_XM_END_TIME = DateTime.Parse(row["D_XM_END_TIME"].ToString()); } if (row["N_UPLOADSTATUS"] != null && row["N_UPLOADSTATUS"].ToString() != "") { model.N_UPLOADSTATUS = decimal.Parse(row["N_UPLOADSTATUS"].ToString()); } if (row["C_MATRL_CODE_SLAB"] != null) { model.C_MATRL_CODE_SLAB = row["C_MATRL_CODE_SLAB"].ToString(); } if (row["C_MATRL_NAME_SLAB"] != null) { model.C_MATRL_NAME_SLAB = row["C_MATRL_NAME_SLAB"].ToString(); } if (row["C_SLAB_SIZE"] != null) { model.C_SLAB_SIZE = row["C_SLAB_SIZE"].ToString(); } if (row["N_SLAB_LENGTH"] != null && row["N_SLAB_LENGTH"].ToString() != "") { model.N_SLAB_LENGTH = decimal.Parse(row["N_SLAB_LENGTH"].ToString()); } if (row["N_SLAB_PW"] != null && row["N_SLAB_PW"].ToString() != "") { model.N_SLAB_PW = decimal.Parse(row["N_SLAB_PW"].ToString()); } if (row["D_CAN_ROLL_TIME"] != null && row["D_CAN_ROLL_TIME"].ToString() != "") { model.D_CAN_ROLL_TIME = DateTime.Parse(row["D_CAN_ROLL_TIME"].ToString()); } if (row["C_ROUTE"] != null) { model.C_ROUTE = row["C_ROUTE"].ToString(); } if (row["N_DIAMETER"] != null && row["N_DIAMETER"].ToString() != "") { model.N_DIAMETER = decimal.Parse(row["N_DIAMETER"].ToString()); } if (row["C_XM_YQ"] != null) { model.C_XM_YQ = row["C_XM_YQ"].ToString(); } if (row["N_JRL_WD"] != null && row["N_JRL_WD"].ToString() != "") { model.N_JRL_WD = decimal.Parse(row["N_JRL_WD"].ToString()); } if (row["N_JRL_SJ"] != null && row["N_JRL_SJ"].ToString() != "") { model.N_JRL_SJ = decimal.Parse(row["N_JRL_SJ"].ToString()); } if (row["C_STL_GRD_SLAB"] != null) { model.C_STL_GRD_SLAB = row["C_STL_GRD_SLAB"].ToString(); } if (row["C_STD_CODE_SLAB"] != null) { model.C_STD_CODE_SLAB = row["C_STD_CODE_SLAB"].ToString(); } } return(model); }