/// <summary> /// 得到一个对象实体 /// </summary> public Mod_TPC_ORDER_SEQ GetModel(string C_ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select C_ID,C_ORD_ID,C_STD_ID,N_ORD_WGT,N_REMAIN_WGT,C_CCM_NO,C_CCM_DESC,C_PLANT_ID,C_PLANT_DESC,C_SLAB_SIZE,C_SLAB_LENGTH,N_SLAB_WGT,C_MATRL_NO,C_MATRL_NAME,C_MATRL_GRP_ID,C_MEASURE_TYPE,C_RECEIVE_TYPE,C_RECEIVE_EMP,C_RECEIVE_TIME,C_MATRL_NO_SLAB,C_MATRL_NAME_SLAB,C_MATRL_GRP_ID_SLAB,D_SMS_START,D_SMS_END,D_SRO_START,D_SRO_END,D_FIN_START,D_FIN_END,C_CLOSE_REASON,C_CLOSE_EMP,C_CLOSE_TIME,N_ORD_WGT_SCALE,N_SPEC_WIDTH,N_SPEC_HIGTH,C_CTRL_NO_LG,C_CTRL_NO_ZG,C_LG_CTRL_EMP,C_LG_CTRL_TIME,C_ZG_CTRL_EMP,C_ZG_CTRL_TIME,C_DESIGN_NO,C_ZG_BZ_EMP,C_ZG_BZ_TIME,C_ZG_SH_EMP,C_ZG_SH_TIME,N_REMAIN_SLAB_WGT,C_PC_ISSH,N_ZG_WGT,D_ZG_DATE,N_LG_WGT,D_LG_DATE,N_ZGDDL_WGT,D_ZGDDL_DATE,N_LGDDL_WGT,D_LGDDL_DATE,D_ZG_DATE_B,D_LG_DATE_B,C_MATRL_GRP_NAME,C_MATRL_GRP_NAME_SLAB,D_PLAN_PRODUCT_DATE,C_PLAN_PRODUCT_USER,D_PLAN_PRODUCT_MOD_TIME,C_PLAN_PRODUCT_STATE,D_PLAN_PRODUCT_SH_DATE,C_PLAN_PRODUCT_SH_USER,C_FINISH_TYPE,N_JSCL_WGT,N_STATUS,C_REMARK,C_EMP_ID,D_MOD_DT from TPC_ORDER_SEQ "); strSql.Append(" where C_ID=:C_ID "); OracleParameter[] parameters = { new OracleParameter(":C_ID", OracleDbType.Varchar2, 100) }; parameters[0].Value = C_ID; Mod_TPC_ORDER_SEQ model = new Mod_TPC_ORDER_SEQ(); 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 Mod_TPC_ORDER_SEQ DataRowToModel(DataRow row) { Mod_TPC_ORDER_SEQ model = new Mod_TPC_ORDER_SEQ(); if (row != null) { if (row["C_ID"] != null) { model.C_ID = row["C_ID"].ToString(); } if (row["C_ORD_ID"] != null) { model.C_ORD_ID = row["C_ORD_ID"].ToString(); } if (row["C_STD_ID"] != null) { model.C_STD_ID = row["C_STD_ID"].ToString(); } if (row["N_ORD_WGT"] != null && row["N_ORD_WGT"].ToString() != "") { model.N_ORD_WGT = decimal.Parse(row["N_ORD_WGT"].ToString()); } if (row["N_REMAIN_WGT"] != null && row["N_REMAIN_WGT"].ToString() != "") { model.N_REMAIN_WGT = decimal.Parse(row["N_REMAIN_WGT"].ToString()); } if (row["C_CCM_NO"] != null) { model.C_CCM_NO = row["C_CCM_NO"].ToString(); } if (row["C_CCM_DESC"] != null) { model.C_CCM_DESC = row["C_CCM_DESC"].ToString(); } if (row["C_PLANT_ID"] != null) { model.C_PLANT_ID = row["C_PLANT_ID"].ToString(); } if (row["C_PLANT_DESC"] != null) { model.C_PLANT_DESC = row["C_PLANT_DESC"].ToString(); } if (row["C_SLAB_SIZE"] != null) { model.C_SLAB_SIZE = row["C_SLAB_SIZE"].ToString(); } if (row["C_SLAB_LENGTH"] != null) { model.C_SLAB_LENGTH = row["C_SLAB_LENGTH"].ToString(); } if (row["N_SLAB_WGT"] != null && row["N_SLAB_WGT"].ToString() != "") { model.N_SLAB_WGT = decimal.Parse(row["N_SLAB_WGT"].ToString()); } if (row["C_MATRL_NO"] != null) { model.C_MATRL_NO = row["C_MATRL_NO"].ToString(); } if (row["C_MATRL_NAME"] != null) { model.C_MATRL_NAME = row["C_MATRL_NAME"].ToString(); } if (row["C_MATRL_GRP_ID"] != null) { model.C_MATRL_GRP_ID = row["C_MATRL_GRP_ID"].ToString(); } if (row["C_MEASURE_TYPE"] != null) { model.C_MEASURE_TYPE = row["C_MEASURE_TYPE"].ToString(); } if (row["C_RECEIVE_TYPE"] != null) { model.C_RECEIVE_TYPE = row["C_RECEIVE_TYPE"].ToString(); } if (row["C_RECEIVE_EMP"] != null) { model.C_RECEIVE_EMP = row["C_RECEIVE_EMP"].ToString(); } if (row["C_RECEIVE_TIME"] != null) { model.C_RECEIVE_TIME = row["C_RECEIVE_TIME"].ToString(); } if (row["C_MATRL_NO_SLAB"] != null) { model.C_MATRL_NO_SLAB = row["C_MATRL_NO_SLAB"].ToString(); } if (row["C_MATRL_NAME_SLAB"] != null) { model.C_MATRL_NAME_SLAB = row["C_MATRL_NAME_SLAB"].ToString(); } if (row["C_MATRL_GRP_ID_SLAB"] != null) { model.C_MATRL_GRP_ID_SLAB = row["C_MATRL_GRP_ID_SLAB"].ToString(); } if (row["D_SMS_START"] != null && row["D_SMS_START"].ToString() != "") { model.D_SMS_START = DateTime.Parse(row["D_SMS_START"].ToString()); } if (row["D_SMS_END"] != null && row["D_SMS_END"].ToString() != "") { model.D_SMS_END = DateTime.Parse(row["D_SMS_END"].ToString()); } if (row["D_SRO_START"] != null && row["D_SRO_START"].ToString() != "") { model.D_SRO_START = DateTime.Parse(row["D_SRO_START"].ToString()); } if (row["D_SRO_END"] != null && row["D_SRO_END"].ToString() != "") { model.D_SRO_END = DateTime.Parse(row["D_SRO_END"].ToString()); } if (row["D_FIN_START"] != null && row["D_FIN_START"].ToString() != "") { model.D_FIN_START = DateTime.Parse(row["D_FIN_START"].ToString()); } if (row["D_FIN_END"] != null && row["D_FIN_END"].ToString() != "") { model.D_FIN_END = DateTime.Parse(row["D_FIN_END"].ToString()); } if (row["C_CLOSE_REASON"] != null) { model.C_CLOSE_REASON = row["C_CLOSE_REASON"].ToString(); } if (row["C_CLOSE_EMP"] != null) { model.C_CLOSE_EMP = row["C_CLOSE_EMP"].ToString(); } if (row["C_CLOSE_TIME"] != null) { model.C_CLOSE_TIME = row["C_CLOSE_TIME"].ToString(); } if (row["N_ORD_WGT_SCALE"] != null && row["N_ORD_WGT_SCALE"].ToString() != "") { model.N_ORD_WGT_SCALE = decimal.Parse(row["N_ORD_WGT_SCALE"].ToString()); } if (row["N_SPEC_WIDTH"] != null && row["N_SPEC_WIDTH"].ToString() != "") { model.N_SPEC_WIDTH = decimal.Parse(row["N_SPEC_WIDTH"].ToString()); } if (row["N_SPEC_HIGTH"] != null && row["N_SPEC_HIGTH"].ToString() != "") { model.N_SPEC_HIGTH = decimal.Parse(row["N_SPEC_HIGTH"].ToString()); } if (row["C_CTRL_NO_LG"] != null) { model.C_CTRL_NO_LG = row["C_CTRL_NO_LG"].ToString(); } if (row["C_CTRL_NO_ZG"] != null) { model.C_CTRL_NO_ZG = row["C_CTRL_NO_ZG"].ToString(); } if (row["C_LG_CTRL_EMP"] != null) { model.C_LG_CTRL_EMP = row["C_LG_CTRL_EMP"].ToString(); } if (row["C_LG_CTRL_TIME"] != null) { model.C_LG_CTRL_TIME = row["C_LG_CTRL_TIME"].ToString(); } if (row["C_ZG_CTRL_EMP"] != null) { model.C_ZG_CTRL_EMP = row["C_ZG_CTRL_EMP"].ToString(); } if (row["C_ZG_CTRL_TIME"] != null) { model.C_ZG_CTRL_TIME = row["C_ZG_CTRL_TIME"].ToString(); } if (row["C_DESIGN_NO"] != null) { model.C_DESIGN_NO = row["C_DESIGN_NO"].ToString(); } if (row["C_ZG_BZ_EMP"] != null) { model.C_ZG_BZ_EMP = row["C_ZG_BZ_EMP"].ToString(); } if (row["C_ZG_BZ_TIME"] != null) { model.C_ZG_BZ_TIME = row["C_ZG_BZ_TIME"].ToString(); } if (row["C_ZG_SH_EMP"] != null) { model.C_ZG_SH_EMP = row["C_ZG_SH_EMP"].ToString(); } if (row["C_ZG_SH_TIME"] != null) { model.C_ZG_SH_TIME = row["C_ZG_SH_TIME"].ToString(); } if (row["N_REMAIN_SLAB_WGT"] != null && row["N_REMAIN_SLAB_WGT"].ToString() != "") { model.N_REMAIN_SLAB_WGT = decimal.Parse(row["N_REMAIN_SLAB_WGT"].ToString()); } if (row["C_PC_ISSH"] != null) { model.C_PC_ISSH = row["C_PC_ISSH"].ToString(); } if (row["N_ZG_WGT"] != null && row["N_ZG_WGT"].ToString() != "") { model.N_ZG_WGT = decimal.Parse(row["N_ZG_WGT"].ToString()); } if (row["D_ZG_DATE"] != null && row["D_ZG_DATE"].ToString() != "") { model.D_ZG_DATE = DateTime.Parse(row["D_ZG_DATE"].ToString()); } if (row["N_LG_WGT"] != null && row["N_LG_WGT"].ToString() != "") { model.N_LG_WGT = decimal.Parse(row["N_LG_WGT"].ToString()); } if (row["D_LG_DATE"] != null && row["D_LG_DATE"].ToString() != "") { model.D_LG_DATE = DateTime.Parse(row["D_LG_DATE"].ToString()); } if (row["N_ZGDDL_WGT"] != null && row["N_ZGDDL_WGT"].ToString() != "") { model.N_ZGDDL_WGT = decimal.Parse(row["N_ZGDDL_WGT"].ToString()); } if (row["D_ZGDDL_DATE"] != null && row["D_ZGDDL_DATE"].ToString() != "") { model.D_ZGDDL_DATE = DateTime.Parse(row["D_ZGDDL_DATE"].ToString()); } if (row["N_LGDDL_WGT"] != null && row["N_LGDDL_WGT"].ToString() != "") { model.N_LGDDL_WGT = decimal.Parse(row["N_LGDDL_WGT"].ToString()); } if (row["D_LGDDL_DATE"] != null && row["D_LGDDL_DATE"].ToString() != "") { model.D_LGDDL_DATE = DateTime.Parse(row["D_LGDDL_DATE"].ToString()); } if (row["D_ZG_DATE_B"] != null && row["D_ZG_DATE_B"].ToString() != "") { model.D_ZG_DATE_B = DateTime.Parse(row["D_ZG_DATE_B"].ToString()); } if (row["D_LG_DATE_B"] != null && row["D_LG_DATE_B"].ToString() != "") { model.D_LG_DATE_B = DateTime.Parse(row["D_LG_DATE_B"].ToString()); } if (row["C_MATRL_GRP_NAME"] != null) { model.C_MATRL_GRP_NAME = row["C_MATRL_GRP_NAME"].ToString(); } if (row["C_MATRL_GRP_NAME_SLAB"] != null) { model.C_MATRL_GRP_NAME_SLAB = row["C_MATRL_GRP_NAME_SLAB"].ToString(); } if (row["D_PLAN_PRODUCT_DATE"] != null && row["D_PLAN_PRODUCT_DATE"].ToString() != "") { model.D_PLAN_PRODUCT_DATE = DateTime.Parse(row["D_PLAN_PRODUCT_DATE"].ToString()); } if (row["C_PLAN_PRODUCT_USER"] != null) { model.C_PLAN_PRODUCT_USER = row["C_PLAN_PRODUCT_USER"].ToString(); } if (row["D_PLAN_PRODUCT_MOD_TIME"] != null && row["D_PLAN_PRODUCT_MOD_TIME"].ToString() != "") { model.D_PLAN_PRODUCT_MOD_TIME = DateTime.Parse(row["D_PLAN_PRODUCT_MOD_TIME"].ToString()); } if (row["C_PLAN_PRODUCT_STATE"] != null) { model.C_PLAN_PRODUCT_STATE = row["C_PLAN_PRODUCT_STATE"].ToString(); } if (row["D_PLAN_PRODUCT_SH_DATE"] != null && row["D_PLAN_PRODUCT_SH_DATE"].ToString() != "") { model.D_PLAN_PRODUCT_SH_DATE = DateTime.Parse(row["D_PLAN_PRODUCT_SH_DATE"].ToString()); } if (row["C_PLAN_PRODUCT_SH_USER"] != null) { model.C_PLAN_PRODUCT_SH_USER = row["C_PLAN_PRODUCT_SH_USER"].ToString(); } if (row["C_FINISH_TYPE"] != null) { model.C_FINISH_TYPE = row["C_FINISH_TYPE"].ToString(); } if (row["N_JSCL_WGT"] != null && row["N_JSCL_WGT"].ToString() != "") { model.N_JSCL_WGT = decimal.Parse(row["N_JSCL_WGT"].ToString()); } if (row["N_STATUS"] != null && row["N_STATUS"].ToString() != "") { model.N_STATUS = decimal.Parse(row["N_STATUS"].ToString()); } if (row["C_REMARK"] != null) { model.C_REMARK = row["C_REMARK"].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()); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Mod_TPC_ORDER_SEQ model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Mod_TPC_ORDER_SEQ model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TPC_ORDER_SEQ("); strSql.Append("C_ORD_ID,C_STD_ID,N_ORD_WGT,N_REMAIN_WGT,C_CCM_NO,C_CCM_DESC,C_PLANT_ID,C_PLANT_DESC,C_SLAB_SIZE,C_SLAB_LENGTH,N_SLAB_WGT,C_MATRL_NO,C_MATRL_NAME,C_MATRL_GRP_ID,C_MEASURE_TYPE,C_RECEIVE_TYPE,C_RECEIVE_EMP,C_RECEIVE_TIME,C_MATRL_NO_SLAB,C_MATRL_NAME_SLAB,C_MATRL_GRP_ID_SLAB,D_SMS_START,D_SMS_END,D_SRO_START,D_SRO_END,D_FIN_START,D_FIN_END,C_CLOSE_REASON,C_CLOSE_EMP,C_CLOSE_TIME,N_ORD_WGT_SCALE,N_SPEC_WIDTH,N_SPEC_HIGTH,C_CTRL_NO_LG,C_CTRL_NO_ZG,C_LG_CTRL_EMP,C_LG_CTRL_TIME,C_ZG_CTRL_EMP,C_ZG_CTRL_TIME,C_DESIGN_NO,C_ZG_BZ_EMP,C_ZG_BZ_TIME,C_ZG_SH_EMP,C_ZG_SH_TIME,N_REMAIN_SLAB_WGT,C_PC_ISSH,N_ZG_WGT,D_ZG_DATE,N_LG_WGT,D_LG_DATE,N_ZGDDL_WGT,D_ZGDDL_DATE,N_LGDDL_WGT,D_LGDDL_DATE,D_ZG_DATE_B,D_LG_DATE_B,C_MATRL_GRP_NAME,C_MATRL_GRP_NAME_SLAB,D_PLAN_PRODUCT_DATE,C_PLAN_PRODUCT_USER,D_PLAN_PRODUCT_MOD_TIME,C_PLAN_PRODUCT_STATE,D_PLAN_PRODUCT_SH_DATE,C_PLAN_PRODUCT_SH_USER,C_FINISH_TYPE,N_JSCL_WGT,N_STATUS,C_REMARK,C_EMP_ID,D_MOD_DT)"); strSql.Append(" values ("); strSql.Append(":C_ORD_ID,:C_STD_ID,:N_ORD_WGT,:N_REMAIN_WGT,:C_CCM_NO,:C_CCM_DESC,:C_PLANT_ID,:C_PLANT_DESC,:C_SLAB_SIZE,:C_SLAB_LENGTH,:N_SLAB_WGT,:C_MATRL_NO,:C_MATRL_NAME,:C_MATRL_GRP_ID,:C_MEASURE_TYPE,:C_RECEIVE_TYPE,:C_RECEIVE_EMP,:C_RECEIVE_TIME,:C_MATRL_NO_SLAB,:C_MATRL_NAME_SLAB,:C_MATRL_GRP_ID_SLAB,:D_SMS_START,:D_SMS_END,:D_SRO_START,:D_SRO_END,:D_FIN_START,:D_FIN_END,:C_CLOSE_REASON,:C_CLOSE_EMP,:C_CLOSE_TIME,:N_ORD_WGT_SCALE,:N_SPEC_WIDTH,:N_SPEC_HIGTH,:C_CTRL_NO_LG,:C_CTRL_NO_ZG,:C_LG_CTRL_EMP,:C_LG_CTRL_TIME,:C_ZG_CTRL_EMP,:C_ZG_CTRL_TIME,:C_DESIGN_NO,:C_ZG_BZ_EMP,:C_ZG_BZ_TIME,:C_ZG_SH_EMP,:C_ZG_SH_TIME,:N_REMAIN_SLAB_WGT,:C_PC_ISSH,:N_ZG_WGT,:D_ZG_DATE,:N_LG_WGT,:D_LG_DATE,:N_ZGDDL_WGT,:D_ZGDDL_DATE,:N_LGDDL_WGT,:D_LGDDL_DATE,:D_ZG_DATE_B,:D_LG_DATE_B,:C_MATRL_GRP_NAME,:C_MATRL_GRP_NAME_SLAB,:D_PLAN_PRODUCT_DATE,:C_PLAN_PRODUCT_USER,:D_PLAN_PRODUCT_MOD_TIME,:C_PLAN_PRODUCT_STATE,:D_PLAN_PRODUCT_SH_DATE,:C_PLAN_PRODUCT_SH_USER,:C_FINISH_TYPE,:N_JSCL_WGT,:N_STATUS,:C_REMARK,:C_EMP_ID,:D_MOD_DT)"); OracleParameter[] parameters = { new OracleParameter(":C_ORD_ID", OracleDbType.Varchar2, 100), new OracleParameter(":C_STD_ID", OracleDbType.Varchar2, 100), new OracleParameter(":N_ORD_WGT", OracleDbType.Decimal, 15), new OracleParameter(":N_REMAIN_WGT", OracleDbType.Decimal, 15), new OracleParameter(":C_CCM_NO", OracleDbType.Varchar2, 100), new OracleParameter(":C_CCM_DESC", OracleDbType.Varchar2, 100), new OracleParameter(":C_PLANT_ID", OracleDbType.Varchar2, 100), new OracleParameter(":C_PLANT_DESC", OracleDbType.Varchar2, 100), new OracleParameter(":C_SLAB_SIZE", OracleDbType.Varchar2, 100), new OracleParameter(":C_SLAB_LENGTH", OracleDbType.Varchar2, 100), new OracleParameter(":N_SLAB_WGT", OracleDbType.Decimal, 15), new OracleParameter(":C_MATRL_NO", OracleDbType.Varchar2, 16), new OracleParameter(":C_MATRL_NAME", OracleDbType.Varchar2, 100), new OracleParameter(":C_MATRL_GRP_ID", OracleDbType.Varchar2, 100), new OracleParameter(":C_MEASURE_TYPE", OracleDbType.Varchar2, 100), new OracleParameter(":C_RECEIVE_TYPE", OracleDbType.Varchar2, 2), new OracleParameter(":C_RECEIVE_EMP", OracleDbType.Varchar2, 100), new OracleParameter(":C_RECEIVE_TIME", OracleDbType.Varchar2, 100), new OracleParameter(":C_MATRL_NO_SLAB", OracleDbType.Varchar2, 16), new OracleParameter(":C_MATRL_NAME_SLAB", OracleDbType.Varchar2, 100), new OracleParameter(":C_MATRL_GRP_ID_SLAB", OracleDbType.Varchar2, 100), new OracleParameter(":D_SMS_START", OracleDbType.Date), new OracleParameter(":D_SMS_END", OracleDbType.Date), new OracleParameter(":D_SRO_START", OracleDbType.Date), new OracleParameter(":D_SRO_END", OracleDbType.Date), new OracleParameter(":D_FIN_START", OracleDbType.Date), new OracleParameter(":D_FIN_END", OracleDbType.Date), new OracleParameter(":C_CLOSE_REASON", OracleDbType.Varchar2, 200), new OracleParameter(":C_CLOSE_EMP", OracleDbType.Varchar2, 100), new OracleParameter(":C_CLOSE_TIME", OracleDbType.Varchar2, 100), new OracleParameter(":N_ORD_WGT_SCALE", OracleDbType.Decimal, 15), new OracleParameter(":N_SPEC_WIDTH", OracleDbType.Decimal, 15), new OracleParameter(":N_SPEC_HIGTH", OracleDbType.Decimal, 15), new OracleParameter(":C_CTRL_NO_LG", OracleDbType.Varchar2, 500), new OracleParameter(":C_CTRL_NO_ZG", OracleDbType.Varchar2, 100), new OracleParameter(":C_LG_CTRL_EMP", OracleDbType.Varchar2, 100), new OracleParameter(":C_LG_CTRL_TIME", OracleDbType.Varchar2, 100), new OracleParameter(":C_ZG_CTRL_EMP", OracleDbType.Varchar2, 100), new OracleParameter(":C_ZG_CTRL_TIME", OracleDbType.Varchar2, 100), new OracleParameter(":C_DESIGN_NO", OracleDbType.Varchar2, 100), new OracleParameter(":C_ZG_BZ_EMP", OracleDbType.Varchar2, 100), new OracleParameter(":C_ZG_BZ_TIME", OracleDbType.Varchar2, 100), new OracleParameter(":C_ZG_SH_EMP", OracleDbType.Varchar2, 100), new OracleParameter(":C_ZG_SH_TIME", OracleDbType.Varchar2, 100), new OracleParameter(":N_REMAIN_SLAB_WGT", OracleDbType.Decimal, 15), new OracleParameter(":C_PC_ISSH", OracleDbType.Varchar2, 1), new OracleParameter(":N_ZG_WGT", OracleDbType.Decimal, 10), new OracleParameter(":D_ZG_DATE", OracleDbType.Date), new OracleParameter(":N_LG_WGT", OracleDbType.Decimal, 10), new OracleParameter(":D_LG_DATE", OracleDbType.Date), new OracleParameter(":N_ZGDDL_WGT", OracleDbType.Decimal, 10), new OracleParameter(":D_ZGDDL_DATE", OracleDbType.Date), new OracleParameter(":N_LGDDL_WGT", OracleDbType.Decimal, 10), new OracleParameter(":D_LGDDL_DATE", OracleDbType.Date), new OracleParameter(":D_ZG_DATE_B", OracleDbType.Date), new OracleParameter(":D_LG_DATE_B", OracleDbType.Date), new OracleParameter(":C_MATRL_GRP_NAME", OracleDbType.Varchar2, 100), new OracleParameter(":C_MATRL_GRP_NAME_SLAB", OracleDbType.Varchar2, 100), new OracleParameter(":D_PLAN_PRODUCT_DATE", OracleDbType.Date), new OracleParameter(":C_PLAN_PRODUCT_USER", OracleDbType.Varchar2, 8), new OracleParameter(":D_PLAN_PRODUCT_MOD_TIME", OracleDbType.Date), new OracleParameter(":C_PLAN_PRODUCT_STATE", OracleDbType.Varchar2, 8), new OracleParameter(":D_PLAN_PRODUCT_SH_DATE", OracleDbType.Date), new OracleParameter(":C_PLAN_PRODUCT_SH_USER", OracleDbType.Varchar2, 8), new OracleParameter(":C_FINISH_TYPE", OracleDbType.Varchar2, 8), new OracleParameter(":N_JSCL_WGT", OracleDbType.Decimal, 10), new OracleParameter(":N_STATUS", OracleDbType.Decimal, 1), new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 500), new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 100), new OracleParameter(":D_MOD_DT", OracleDbType.Date) }; parameters[0].Value = model.C_ORD_ID; parameters[1].Value = model.C_STD_ID; parameters[2].Value = model.N_ORD_WGT; parameters[3].Value = model.N_REMAIN_WGT; parameters[4].Value = model.C_CCM_NO; parameters[5].Value = model.C_CCM_DESC; parameters[6].Value = model.C_PLANT_ID; parameters[7].Value = model.C_PLANT_DESC; parameters[8].Value = model.C_SLAB_SIZE; parameters[9].Value = model.C_SLAB_LENGTH; parameters[10].Value = model.N_SLAB_WGT; parameters[11].Value = model.C_MATRL_NO; parameters[12].Value = model.C_MATRL_NAME; parameters[13].Value = model.C_MATRL_GRP_ID; parameters[14].Value = model.C_MEASURE_TYPE; parameters[15].Value = model.C_RECEIVE_TYPE; parameters[16].Value = model.C_RECEIVE_EMP; parameters[17].Value = model.C_RECEIVE_TIME; parameters[18].Value = model.C_MATRL_NO_SLAB; parameters[19].Value = model.C_MATRL_NAME_SLAB; parameters[20].Value = model.C_MATRL_GRP_ID_SLAB; parameters[21].Value = model.D_SMS_START; parameters[22].Value = model.D_SMS_END; parameters[23].Value = model.D_SRO_START; parameters[24].Value = model.D_SRO_END; parameters[25].Value = model.D_FIN_START; parameters[26].Value = model.D_FIN_END; parameters[27].Value = model.C_CLOSE_REASON; parameters[28].Value = model.C_CLOSE_EMP; parameters[29].Value = model.C_CLOSE_TIME; parameters[30].Value = model.N_ORD_WGT_SCALE; parameters[31].Value = model.N_SPEC_WIDTH; parameters[32].Value = model.N_SPEC_HIGTH; parameters[33].Value = model.C_CTRL_NO_LG; parameters[34].Value = model.C_CTRL_NO_ZG; parameters[35].Value = model.C_LG_CTRL_EMP; parameters[36].Value = model.C_LG_CTRL_TIME; parameters[37].Value = model.C_ZG_CTRL_EMP; parameters[38].Value = model.C_ZG_CTRL_TIME; parameters[39].Value = model.C_DESIGN_NO; parameters[40].Value = model.C_ZG_BZ_EMP; parameters[41].Value = model.C_ZG_BZ_TIME; parameters[42].Value = model.C_ZG_SH_EMP; parameters[43].Value = model.C_ZG_SH_TIME; parameters[44].Value = model.N_REMAIN_SLAB_WGT; parameters[45].Value = model.C_PC_ISSH; parameters[46].Value = model.N_ZG_WGT; parameters[47].Value = model.D_ZG_DATE; parameters[48].Value = model.N_LG_WGT; parameters[49].Value = model.D_LG_DATE; parameters[50].Value = model.N_ZGDDL_WGT; parameters[51].Value = model.D_ZGDDL_DATE; parameters[52].Value = model.N_LGDDL_WGT; parameters[53].Value = model.D_LGDDL_DATE; parameters[54].Value = model.D_ZG_DATE_B; parameters[55].Value = model.D_LG_DATE_B; parameters[56].Value = model.C_MATRL_GRP_NAME; parameters[57].Value = model.C_MATRL_GRP_NAME_SLAB; parameters[58].Value = model.D_PLAN_PRODUCT_DATE; parameters[59].Value = model.C_PLAN_PRODUCT_USER; parameters[60].Value = model.D_PLAN_PRODUCT_MOD_TIME; parameters[61].Value = model.C_PLAN_PRODUCT_STATE; parameters[62].Value = model.D_PLAN_PRODUCT_SH_DATE; parameters[63].Value = model.C_PLAN_PRODUCT_SH_USER; parameters[64].Value = model.C_FINISH_TYPE; parameters[65].Value = model.N_JSCL_WGT; parameters[66].Value = model.N_STATUS; parameters[67].Value = model.C_REMARK; parameters[68].Value = model.C_EMP_ID; parameters[69].Value = model.D_MOD_DT; int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Mod_TPC_ORDER_SEQ model) { return(dal.Add(model)); }