Exemplo n.º 1
0
        /// <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);
            }
        }
Exemplo n.º 2
0
 /// <summary>
 /// 更新一条数据
 /// </summary>
 public bool Update(Mod_TSP_CAST_PLAN_LOG model)
 {
     return(dal.Update(model));
 }
Exemplo n.º 3
0
 /// <summary>
 /// 增加一条数据
 /// </summary>
 public bool Add(Mod_TSP_CAST_PLAN_LOG model)
 {
     return(dal.Add(model));
 }
Exemplo n.º 4
0
        /// <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);
        }
Exemplo n.º 5
0
        /// <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);
            }
        }