/// <summary> /// 得到一个对象实体 /// </summary> public Mod_TSP_CAST_PLAN_LOG GetModel(string C_ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select C_ID,C_CCM_ID,C_CCM_CODE,N_GROUP,N_TOTAL_WGT,N_ZJCLS,N_ZJCLZL,N_MLZL,N_SORT,C_STL_GRD,N_PRODUCE_TIME,N_JSCN,C_BY1,C_BY2,C_BY3,C_RH,C_DFP_HL,C_HL,C_XM,N_ORDER_LS,D_DFPHL_START_TIME,D_DFPHL_END_TIME,D_KP_START_TIME,D_KP_END_TIME,D_HL_START_TIME,D_HL_END_TIME,D_PLAN_KY_TIME,C_PLAN_ROLL,D_ZZ_START_TIME,D_ZZ_END_TIME,D_XM_START_TIME,D_XM_END_TIME,C_STD_CODE,C_SLAB_TYPE,C_STL_GRD_TYPE,C_PROD_NAME,C_PROD_KIND,N_DFP_HL_TIME,N_HL_TIME,N_XM_TIME,N_GG,N_CCM_TIME,C_TJ_REMARK,C_TL,N_RH,N_TL,N_GZSL,C_REMARK,N_XM,N_DHL,N_HL,N_STATUS,D_P_START_TIME,D_P_END_TIME,N_DFP_RZ,N_RZP_RZ,C_RH_SFJS,C_TZ_REMARK,C_LOG_ID,C_LOG_REMARK,C_LOG_EMP,D_LOG_DT,C_LOG_IP from TSP_CAST_PLAN_LOG "); strSql.Append(" where C_ID=:C_ID "); OracleParameter[] parameters = { new OracleParameter(":C_ID", OracleDbType.Varchar2, 100) }; parameters[0].Value = C_ID; Mod_TSP_CAST_PLAN_LOG model = new Mod_TSP_CAST_PLAN_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_TSP_CAST_PLAN_LOG model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Mod_TSP_CAST_PLAN_LOG model) { return(dal.Add(model)); }
/// <summary> /// 得到一个对象实体 /// </summary> public Mod_TSP_CAST_PLAN_LOG DataRowToModel(DataRow row) { Mod_TSP_CAST_PLAN_LOG model = new Mod_TSP_CAST_PLAN_LOG(); if (row != null) { if (row["C_ID"] != null) { model.C_ID = row["C_ID"].ToString(); } if (row["C_CCM_ID"] != null) { model.C_CCM_ID = row["C_CCM_ID"].ToString(); } if (row["C_CCM_CODE"] != null) { model.C_CCM_CODE = row["C_CCM_CODE"].ToString(); } if (row["N_GROUP"] != null && row["N_GROUP"].ToString() != "") { model.N_GROUP = decimal.Parse(row["N_GROUP"].ToString()); } if (row["N_TOTAL_WGT"] != null && row["N_TOTAL_WGT"].ToString() != "") { model.N_TOTAL_WGT = decimal.Parse(row["N_TOTAL_WGT"].ToString()); } if (row["N_ZJCLS"] != null && row["N_ZJCLS"].ToString() != "") { model.N_ZJCLS = decimal.Parse(row["N_ZJCLS"].ToString()); } if (row["N_ZJCLZL"] != null && row["N_ZJCLZL"].ToString() != "") { model.N_ZJCLZL = decimal.Parse(row["N_ZJCLZL"].ToString()); } if (row["N_MLZL"] != null && row["N_MLZL"].ToString() != "") { model.N_MLZL = decimal.Parse(row["N_MLZL"].ToString()); } if (row["N_SORT"] != null && row["N_SORT"].ToString() != "") { model.N_SORT = decimal.Parse(row["N_SORT"].ToString()); } if (row["C_STL_GRD"] != null) { model.C_STL_GRD = row["C_STL_GRD"].ToString(); } if (row["N_PRODUCE_TIME"] != null && row["N_PRODUCE_TIME"].ToString() != "") { model.N_PRODUCE_TIME = decimal.Parse(row["N_PRODUCE_TIME"].ToString()); } if (row["N_JSCN"] != null && row["N_JSCN"].ToString() != "") { model.N_JSCN = decimal.Parse(row["N_JSCN"].ToString()); } if (row["C_BY1"] != null) { model.C_BY1 = row["C_BY1"].ToString(); } if (row["C_BY2"] != null) { model.C_BY2 = row["C_BY2"].ToString(); } if (row["C_BY3"] != null) { model.C_BY3 = row["C_BY3"].ToString(); } if (row["C_RH"] != null) { model.C_RH = row["C_RH"].ToString(); } if (row["C_DFP_HL"] != null) { model.C_DFP_HL = row["C_DFP_HL"].ToString(); } if (row["C_HL"] != null) { model.C_HL = row["C_HL"].ToString(); } if (row["C_XM"] != null) { model.C_XM = row["C_XM"].ToString(); } if (row["N_ORDER_LS"] != null && row["N_ORDER_LS"].ToString() != "") { model.N_ORDER_LS = decimal.Parse(row["N_ORDER_LS"].ToString()); } if (row["D_DFPHL_START_TIME"] != null && row["D_DFPHL_START_TIME"].ToString() != "") { model.D_DFPHL_START_TIME = DateTime.Parse(row["D_DFPHL_START_TIME"].ToString()); } if (row["D_DFPHL_END_TIME"] != null && row["D_DFPHL_END_TIME"].ToString() != "") { model.D_DFPHL_END_TIME = DateTime.Parse(row["D_DFPHL_END_TIME"].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["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["D_PLAN_KY_TIME"] != null && row["D_PLAN_KY_TIME"].ToString() != "") { model.D_PLAN_KY_TIME = DateTime.Parse(row["D_PLAN_KY_TIME"].ToString()); } if (row["C_PLAN_ROLL"] != null) { model.C_PLAN_ROLL = row["C_PLAN_ROLL"].ToString(); } if (row["D_ZZ_START_TIME"] != null && row["D_ZZ_START_TIME"].ToString() != "") { model.D_ZZ_START_TIME = DateTime.Parse(row["D_ZZ_START_TIME"].ToString()); } if (row["D_ZZ_END_TIME"] != null && row["D_ZZ_END_TIME"].ToString() != "") { model.D_ZZ_END_TIME = DateTime.Parse(row["D_ZZ_END_TIME"].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["C_STD_CODE"] != null) { model.C_STD_CODE = row["C_STD_CODE"].ToString(); } if (row["C_SLAB_TYPE"] != null) { model.C_SLAB_TYPE = row["C_SLAB_TYPE"].ToString(); } if (row["C_STL_GRD_TYPE"] != null) { model.C_STL_GRD_TYPE = row["C_STL_GRD_TYPE"].ToString(); } if (row["C_PROD_NAME"] != null) { model.C_PROD_NAME = row["C_PROD_NAME"].ToString(); } if (row["C_PROD_KIND"] != null) { model.C_PROD_KIND = row["C_PROD_KIND"].ToString(); } if (row["N_DFP_HL_TIME"] != null && row["N_DFP_HL_TIME"].ToString() != "") { model.N_DFP_HL_TIME = decimal.Parse(row["N_DFP_HL_TIME"].ToString()); } if (row["N_HL_TIME"] != null && row["N_HL_TIME"].ToString() != "") { model.N_HL_TIME = decimal.Parse(row["N_HL_TIME"].ToString()); } if (row["N_XM_TIME"] != null && row["N_XM_TIME"].ToString() != "") { model.N_XM_TIME = decimal.Parse(row["N_XM_TIME"].ToString()); } if (row["N_GG"] != null && row["N_GG"].ToString() != "") { model.N_GG = decimal.Parse(row["N_GG"].ToString()); } if (row["N_CCM_TIME"] != null && row["N_CCM_TIME"].ToString() != "") { model.N_CCM_TIME = decimal.Parse(row["N_CCM_TIME"].ToString()); } if (row["C_TJ_REMARK"] != null) { model.C_TJ_REMARK = row["C_TJ_REMARK"].ToString(); } if (row["C_TL"] != null) { model.C_TL = row["C_TL"].ToString(); } if (row["N_RH"] != null && row["N_RH"].ToString() != "") { model.N_RH = decimal.Parse(row["N_RH"].ToString()); } if (row["N_TL"] != null && row["N_TL"].ToString() != "") { model.N_TL = decimal.Parse(row["N_TL"].ToString()); } if (row["N_GZSL"] != null && row["N_GZSL"].ToString() != "") { model.N_GZSL = decimal.Parse(row["N_GZSL"].ToString()); } if (row["C_REMARK"] != null) { model.C_REMARK = row["C_REMARK"].ToString(); } if (row["N_XM"] != null && row["N_XM"].ToString() != "") { model.N_XM = decimal.Parse(row["N_XM"].ToString()); } if (row["N_DHL"] != null && row["N_DHL"].ToString() != "") { model.N_DHL = decimal.Parse(row["N_DHL"].ToString()); } if (row["N_HL"] != null && row["N_HL"].ToString() != "") { model.N_HL = decimal.Parse(row["N_HL"].ToString()); } if (row["N_STATUS"] != null && row["N_STATUS"].ToString() != "") { model.N_STATUS = decimal.Parse(row["N_STATUS"].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_DFP_RZ"] != null && row["N_DFP_RZ"].ToString() != "") { model.N_DFP_RZ = decimal.Parse(row["N_DFP_RZ"].ToString()); } if (row["N_RZP_RZ"] != null && row["N_RZP_RZ"].ToString() != "") { model.N_RZP_RZ = decimal.Parse(row["N_RZP_RZ"].ToString()); } if (row["C_RH_SFJS"] != null) { model.C_RH_SFJS = row["C_RH_SFJS"].ToString(); } if (row["C_TZ_REMARK"] != null) { model.C_TZ_REMARK = row["C_TZ_REMARK"].ToString(); } if (row["C_LOG_ID"] != null) { model.C_LOG_ID = row["C_LOG_ID"].ToString(); } if (row["C_LOG_REMARK"] != null) { model.C_LOG_REMARK = row["C_LOG_REMARK"].ToString(); } if (row["C_LOG_EMP"] != null) { model.C_LOG_EMP = row["C_LOG_EMP"].ToString(); } if (row["D_LOG_DT"] != null && row["D_LOG_DT"].ToString() != "") { model.D_LOG_DT = DateTime.Parse(row["D_LOG_DT"].ToString()); } if (row["C_LOG_IP"] != null) { model.C_LOG_IP = row["C_LOG_IP"].ToString(); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Mod_TSP_CAST_PLAN_LOG model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TSP_CAST_PLAN_LOG("); strSql.Append("C_ID,C_CCM_ID,C_CCM_CODE,N_GROUP,N_TOTAL_WGT,N_ZJCLS,N_ZJCLZL,N_MLZL,N_SORT,C_STL_GRD,N_PRODUCE_TIME,N_JSCN,C_BY1,C_BY2,C_BY3,C_RH,C_DFP_HL,C_HL,C_XM,N_ORDER_LS,D_DFPHL_START_TIME,D_DFPHL_END_TIME,D_KP_START_TIME,D_KP_END_TIME,D_HL_START_TIME,D_HL_END_TIME,D_PLAN_KY_TIME,C_PLAN_ROLL,D_ZZ_START_TIME,D_ZZ_END_TIME,D_XM_START_TIME,D_XM_END_TIME,C_STD_CODE,C_SLAB_TYPE,C_STL_GRD_TYPE,C_PROD_NAME,C_PROD_KIND,N_DFP_HL_TIME,N_HL_TIME,N_XM_TIME,N_GG,N_CCM_TIME,C_TJ_REMARK,C_TL,N_RH,N_TL,N_GZSL,C_REMARK,N_XM,N_DHL,N_HL,N_STATUS,D_P_START_TIME,D_P_END_TIME,N_DFP_RZ,N_RZP_RZ,C_RH_SFJS,C_TZ_REMARK,C_LOG_ID,C_LOG_REMARK,C_LOG_EMP,D_LOG_DT,C_LOG_IP)"); strSql.Append(" values ("); strSql.Append(":C_ID,:C_CCM_ID,:C_CCM_CODE,:N_GROUP,:N_TOTAL_WGT,:N_ZJCLS,:N_ZJCLZL,:N_MLZL,:N_SORT,:C_STL_GRD,:N_PRODUCE_TIME,:N_JSCN,:C_BY1,:C_BY2,:C_BY3,:C_RH,:C_DFP_HL,:C_HL,:C_XM,:N_ORDER_LS,:D_DFPHL_START_TIME,:D_DFPHL_END_TIME,:D_KP_START_TIME,:D_KP_END_TIME,:D_HL_START_TIME,:D_HL_END_TIME,:D_PLAN_KY_TIME,:C_PLAN_ROLL,:D_ZZ_START_TIME,:D_ZZ_END_TIME,:D_XM_START_TIME,:D_XM_END_TIME,:C_STD_CODE,:C_SLAB_TYPE,:C_STL_GRD_TYPE,:C_PROD_NAME,:C_PROD_KIND,:N_DFP_HL_TIME,:N_HL_TIME,:N_XM_TIME,:N_GG,:N_CCM_TIME,:C_TJ_REMARK,:C_TL,:N_RH,:N_TL,:N_GZSL,:C_REMARK,:N_XM,:N_DHL,:N_HL,:N_STATUS,:D_P_START_TIME,:D_P_END_TIME,:N_DFP_RZ,:N_RZP_RZ,:C_RH_SFJS,:C_TZ_REMARK,:C_LOG_ID,:C_LOG_REMARK,:C_LOG_EMP,:D_LOG_DT,:C_LOG_IP)"); OracleParameter[] parameters = { new OracleParameter(":C_ID", OracleDbType.Varchar2, 100), new OracleParameter(":C_CCM_ID", OracleDbType.Varchar2, 100), new OracleParameter(":C_CCM_CODE", OracleDbType.Varchar2, 100), new OracleParameter(":N_GROUP", OracleDbType.Decimal, 4), new OracleParameter(":N_TOTAL_WGT", OracleDbType.Decimal, 15), new OracleParameter(":N_ZJCLS", OracleDbType.Decimal, 4), new OracleParameter(":N_ZJCLZL", OracleDbType.Decimal, 4), new OracleParameter(":N_MLZL", OracleDbType.Decimal, 15), new OracleParameter(":N_SORT", OracleDbType.Decimal, 10), new OracleParameter(":C_STL_GRD", OracleDbType.Varchar2, 500), new OracleParameter(":N_PRODUCE_TIME", OracleDbType.Decimal, 15), new OracleParameter(":N_JSCN", OracleDbType.Decimal, 4), new OracleParameter(":C_BY1", OracleDbType.Varchar2, 100), new OracleParameter(":C_BY2", OracleDbType.Varchar2, 100), new OracleParameter(":C_BY3", OracleDbType.Varchar2, 100), new OracleParameter(":C_RH", OracleDbType.Varchar2, 100), new OracleParameter(":C_DFP_HL", OracleDbType.Varchar2, 100), new OracleParameter(":C_HL", OracleDbType.Varchar2, 100), new OracleParameter(":C_XM", OracleDbType.Varchar2, 100), new OracleParameter(":N_ORDER_LS", OracleDbType.Decimal, 4), new OracleParameter(":D_DFPHL_START_TIME", OracleDbType.Date), new OracleParameter(":D_DFPHL_END_TIME", OracleDbType.Date), new OracleParameter(":D_KP_START_TIME", OracleDbType.Date), new OracleParameter(":D_KP_END_TIME", OracleDbType.Date), new OracleParameter(":D_HL_START_TIME", OracleDbType.Date), new OracleParameter(":D_HL_END_TIME", OracleDbType.Date), new OracleParameter(":D_PLAN_KY_TIME", OracleDbType.Date), new OracleParameter(":C_PLAN_ROLL", OracleDbType.Varchar2, 100), new OracleParameter(":D_ZZ_START_TIME", OracleDbType.Date), new OracleParameter(":D_ZZ_END_TIME", OracleDbType.Date), new OracleParameter(":D_XM_START_TIME", OracleDbType.Date), new OracleParameter(":D_XM_END_TIME", OracleDbType.Date), new OracleParameter(":C_STD_CODE", OracleDbType.Varchar2, 500), new OracleParameter(":C_SLAB_TYPE", OracleDbType.Varchar2, 100), new OracleParameter(":C_STL_GRD_TYPE", OracleDbType.Varchar2, 100), new OracleParameter(":C_PROD_NAME", OracleDbType.Varchar2, 100), new OracleParameter(":C_PROD_KIND", OracleDbType.Varchar2, 100), new OracleParameter(":N_DFP_HL_TIME", OracleDbType.Decimal, 10), new OracleParameter(":N_HL_TIME", OracleDbType.Decimal, 10), new OracleParameter(":N_XM_TIME", OracleDbType.Decimal, 10), new OracleParameter(":N_GG", OracleDbType.Decimal, 10), new OracleParameter(":N_CCM_TIME", OracleDbType.Decimal, 10), new OracleParameter(":C_TJ_REMARK", OracleDbType.Varchar2, 500), new OracleParameter(":C_TL", OracleDbType.Varchar2, 100), new OracleParameter(":N_RH", OracleDbType.Decimal, 5), new OracleParameter(":N_TL", OracleDbType.Decimal, 5), new OracleParameter(":N_GZSL", OracleDbType.Decimal, 5), new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 1000), new OracleParameter(":N_XM", OracleDbType.Decimal, 5), new OracleParameter(":N_DHL", OracleDbType.Decimal, 5), new OracleParameter(":N_HL", OracleDbType.Decimal, 5), new OracleParameter(":N_STATUS", OracleDbType.Decimal, 5), new OracleParameter(":D_P_START_TIME", OracleDbType.Date), new OracleParameter(":D_P_END_TIME", OracleDbType.Date), new OracleParameter(":N_DFP_RZ", OracleDbType.Decimal, 5), new OracleParameter(":N_RZP_RZ", OracleDbType.Decimal, 5), new OracleParameter(":C_RH_SFJS", OracleDbType.Varchar2, 10), new OracleParameter(":C_TZ_REMARK", OracleDbType.Varchar2, 1000), new OracleParameter(":C_LOG_ID", OracleDbType.Varchar2, 50), new OracleParameter(":C_LOG_REMARK", OracleDbType.Varchar2, 500), new OracleParameter(":C_LOG_EMP", OracleDbType.Varchar2, 50), new OracleParameter(":D_LOG_DT", OracleDbType.Date), new OracleParameter(":C_LOG_IP", OracleDbType.Varchar2, 100) }; parameters[0].Value = model.C_ID; parameters[1].Value = model.C_CCM_ID; parameters[2].Value = model.C_CCM_CODE; parameters[3].Value = model.N_GROUP; parameters[4].Value = model.N_TOTAL_WGT; parameters[5].Value = model.N_ZJCLS; parameters[6].Value = model.N_ZJCLZL; parameters[7].Value = model.N_MLZL; parameters[8].Value = model.N_SORT; parameters[9].Value = model.C_STL_GRD; parameters[10].Value = model.N_PRODUCE_TIME; parameters[11].Value = model.N_JSCN; parameters[12].Value = model.C_BY1; parameters[13].Value = model.C_BY2; parameters[14].Value = model.C_BY3; parameters[15].Value = model.C_RH; parameters[16].Value = model.C_DFP_HL; parameters[17].Value = model.C_HL; parameters[18].Value = model.C_XM; parameters[19].Value = model.N_ORDER_LS; parameters[20].Value = model.D_DFPHL_START_TIME; parameters[21].Value = model.D_DFPHL_END_TIME; parameters[22].Value = model.D_KP_START_TIME; parameters[23].Value = model.D_KP_END_TIME; parameters[24].Value = model.D_HL_START_TIME; parameters[25].Value = model.D_HL_END_TIME; parameters[26].Value = model.D_PLAN_KY_TIME; parameters[27].Value = model.C_PLAN_ROLL; parameters[28].Value = model.D_ZZ_START_TIME; parameters[29].Value = model.D_ZZ_END_TIME; parameters[30].Value = model.D_XM_START_TIME; parameters[31].Value = model.D_XM_END_TIME; parameters[32].Value = model.C_STD_CODE; parameters[33].Value = model.C_SLAB_TYPE; parameters[34].Value = model.C_STL_GRD_TYPE; parameters[35].Value = model.C_PROD_NAME; parameters[36].Value = model.C_PROD_KIND; parameters[37].Value = model.N_DFP_HL_TIME; parameters[38].Value = model.N_HL_TIME; parameters[39].Value = model.N_XM_TIME; parameters[40].Value = model.N_GG; parameters[41].Value = model.N_CCM_TIME; parameters[42].Value = model.C_TJ_REMARK; parameters[43].Value = model.C_TL; parameters[44].Value = model.N_RH; parameters[45].Value = model.N_TL; parameters[46].Value = model.N_GZSL; parameters[47].Value = model.C_REMARK; parameters[48].Value = model.N_XM; parameters[49].Value = model.N_DHL; parameters[50].Value = model.N_HL; parameters[51].Value = model.N_STATUS; parameters[52].Value = model.D_P_START_TIME; parameters[53].Value = model.D_P_END_TIME; parameters[54].Value = model.N_DFP_RZ; parameters[55].Value = model.N_RZP_RZ; parameters[56].Value = model.C_RH_SFJS; parameters[57].Value = model.C_TZ_REMARK; parameters[58].Value = model.C_LOG_ID; parameters[59].Value = model.C_LOG_REMARK; parameters[60].Value = model.C_LOG_EMP; parameters[61].Value = model.D_LOG_DT; parameters[62].Value = model.C_LOG_IP; int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }