예제 #1
0
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public Mod_TQC_SLAB_COMMUTE GetModel_Interface_Trans(string C_MASTER_ID, string C_GP_BEFORE_ID, string C_GP_AFTER_ID)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select C_ID,C_SLAB_MAIN_ID,C_STA_ID,C_STOVE,N_WGT,N_LEN,C_STL_GRD_BEFORE,C_STD_CODE_BEFORE,C_SPEC_BEFORE,C_MAT_CODE_BEFORE,C_MAT_DESC_BEFORE,D_COMMUTE_DATE,C_STL_GRD_AFTER,C_STD_CODE_AFTER,C_SPEC_AFTER,C_MAT_CODE_AFTER,C_MAT_DESC_AFTER,C_REASON_DEPMT_ID,C_REASON_DEPMT_DESC,C_EMP_ID,C_REMARK,N_STATUS,C_SCUTCHEON,C_MASTER_ID,C_GP_BEFORE_ID,C_GP_AFTER_ID,C_GP_TYPE,C_ZYX1_BEFORE,C_ZYX2_BEFORE,C_ZYX1_AFTER,C_ZYX2_AFTER ,C_JUDGE_LEV_BP_BEFORE,C_JUDGE_LEV_BP_AFTER,C_BATCH_NO,C_COMMUTE_REASON  from TQC_SLAB_COMMUTE ");
            strSql.Append(" where C_MASTER_ID=:C_MASTER_ID ");
            strSql.Append(" and C_GP_BEFORE_ID=:C_GP_BEFORE_ID ");
            strSql.Append(" and C_GP_AFTER_ID=:C_GP_AFTER_ID ");
            OracleParameter[] parameters =
            {
                new OracleParameter(":C_MASTER_ID",    OracleDbType.Varchar2, 100),
                new OracleParameter(":C_GP_BEFORE_ID", OracleDbType.Varchar2, 100),
                new OracleParameter(":C_GP_AFTER_ID",  OracleDbType.Varchar2, 100)
            };
            parameters[0].Value = C_MASTER_ID;
            parameters[1].Value = C_GP_BEFORE_ID;
            parameters[2].Value = C_GP_AFTER_ID;
            Mod_TQC_SLAB_COMMUTE model = new Mod_TQC_SLAB_COMMUTE();
            DataSet ds = TransactionHelper.Query(strSql.ToString(), parameters);

            if (ds.Tables[0].Rows.Count > 0)
            {
                return(DataRowToModel(ds.Tables[0].Rows[0]));
            }
            else
            {
                return(null);
            }
        }
예제 #2
0
        /// <summary>
        /// 修改标牌
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btn_XGBP_Click(object sender, EventArgs e)
        {
            try
            {
                DataRow dr = gv_GPSJ.GetDataRow(gv_GPSJ.FocusedRowHandle);
                if (dr == null)
                {
                    return;
                }
                if (string.IsNullOrEmpty(imgcbo_BPLX.Text))
                {
                    MessageBox.Show("标牌不能为空!");
                    return;
                }


                if (DialogResult.No == MessageBox.Show("是否确认修改标牌,炉号为:'" + dr["C_STOVE"].ToString() + "'", "提示"))
                {
                    return;
                }

                DataTable            dt  = bll_slab.GetList_stove(dr["C_STOVE"].ToString()).Tables[0];
                Mod_TQC_SLAB_COMMUTE mod = new Mod_TQC_SLAB_COMMUTE();

                mod.C_SLAB_MAIN_ID      = dt.Rows[0]["C_ID"].ToString();
                mod.C_STA_ID            = dt.Rows[0]["C_STA_ID"].ToString();
                mod.C_STOVE             = dt.Rows[0]["C_STOVE"].ToString();
                mod.N_WGT               = Convert.ToDecimal(dt.Rows[0]["N_WGT"].ToString());
                mod.N_LEN               = Convert.ToDecimal(dt.Rows[0]["N_LEN"].ToString());
                mod.C_STL_GRD_BEFORE    = dt.Rows[0]["C_STL_GRD"].ToString();
                mod.C_STD_CODE_BEFORE   = dt.Rows[0]["C_STD_CODE"].ToString();
                mod.C_SPEC_BEFORE       = dt.Rows[0]["C_SPEC"].ToString();
                mod.C_MAT_CODE_BEFORE   = dt.Rows[0]["C_MAT_CODE"].ToString();
                mod.C_MAT_DESC_BEFORE   = dt.Rows[0]["C_MAT_NAME"].ToString();
                mod.D_COMMUTE_DATE      = RV.UI.ServerTime.timeNow();
                mod.C_GP_TYPE           = "修改标牌";
                mod.C_SCUTCHEON         = imgcbo_BPLX.Text;
                mod.C_REASON_DEPMT_ID   = imgcbo_ZRDW.EditValue?.ToString();
                mod.C_REASON_DEPMT_DESC = imgcbo_ZRDW.Text;
                mod.C_EMP_ID            = RV.UI.UserInfo.UserID;
                mod.C_REMARK            = txt_Remark.Text;

                if (bll_commute.Add(mod))
                {
                    bll_slab.Update_Stove(imgcbo_BPLX.Text.Trim(), dr["C_STOVE"].ToString());
                }
                Common.UserLog.AddLog(strMenuName, this.Name, this.Text, "钢坯修改标牌");//添加操作日志

                btn_Query_Click(null, null);
                btn_Query1_Click(null, null);
                ClearContent.ClearFlowLayoutPanel(panelControl4.Controls);
                MessageBox.Show("修改成功!");
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
예제 #3
0
 /// <summary>
 /// 更新一条数据
 /// </summary>
 public bool Update(Mod_TQC_SLAB_COMMUTE model)
 {
     return(dal.Update(model));
 }
예제 #4
0
 /// <summary>
 /// 增加一条数据
 /// </summary>
 public bool Add(Mod_TQC_SLAB_COMMUTE model)
 {
     return(dal.Add(model));
 }
예제 #5
0
        /// <summary>
        /// 钢坯改判
        /// </summary>
        /// <param name="row">选中的数据</param>
        /// <param name="strGrd">钢种</param>
        /// <param name="strStdCode">执行标准</param>
        /// <param name="strMatCode">物料编码</param>
        /// <param name="strMatName">物料描述</param>
        /// <param name="strZrdwID">责任单位代码</param>
        /// <param name="strZrdwName">责任代为描述</param>
        /// <param name="strPDDJ">判定等级</param>
        /// <param name="strRemark">备注</param>
        /// <param name="strUrl">地址</param>
        /// <param name="strZYX1">自由项1</param>
        /// <param name="strZYX2">自由项2</param>
        /// <param name="strGPYY">改判原因</param>
        /// <param name="strLen">定尺</param>
        /// <returns></returns>
        public string GP_Slab(string strs, string strGrd, string strStdCode, string strMatCode, string strMatName, string strZrdwID, string strZrdwName, string strPDDJ, string strRemark, string strUrl, string strZYX1, string strZYX2, string strGPYY, string strLen)
        {
            string result = "1";

            try
            {
                Dal_TSC_SLAB_MAIN          dal_slab      = new Dal_TSC_SLAB_MAIN();
                Dal_TQC_SLAB_COMMUTE       dal_commute   = new Dal_TQC_SLAB_COMMUTE();
                Dal_Interface_NC_SLAB_KC4N dal_interface = new Dal_Interface_NC_SLAB_KC4N();
                Dal_TPB_LGGYK     dalTpbLggyk            = new Dal_TPB_LGGYK();
                Dal_TMO_ORDER     dalTmoOrder            = new Dal_TMO_ORDER();
                Dal_TQD_DESIGN    dalDesign      = new Dal_TQD_DESIGN();
                Dal_TB_STD_CONFIG dalTbStdConfig = new Dal_TB_STD_CONFIG();

                TransactionHelper.BeginTransaction();

                string   strUserID          = RV.UI.UserInfo.userID;
                DateTime time               = RV.UI.ServerTime.timeNow();
                string   stove              = "";
                string   max_C_MASTER_ID    = "";
                string   max_C_GP_BEFORE_ID = "";
                string   max_C_GP_AFTER_ID  = "";
                string   slabCode           = "";
                string   strLGJH            = "";
                string   strDesignNo        = dalDesign.Get_Design_No(strStdCode, strGrd);
                if (string.IsNullOrEmpty(strDesignNo))
                {
                    return("改判失败,没有找到对应的执行标准信息!");
                }
                string[] strs_Slab_ID = strs.Substring(0, strs.Length - 1).Split(',');

                //Mod_TSC_SLAB_MAIN modSlabMain = dal_slab.GetModel(strs_Slab_ID[0]);
                //Mod_TPB_LGGYK modLggyk = dalTpbLggyk.GetModel_Trans(modSlabMain.C_LGJH);

                //if (modLggyk == null)
                //{
                //    TransactionHelper.RollBack();
                //    return "改判失败,获取炼钢记号时错误!";
                //}

                //DataTable dtLGJH = dalTpbLggyk.Get_LGJH(modLggyk.C_BOF_TYPE, modLggyk.C_LF_TYPE, modLggyk.C_RH_TYPE, modLggyk.C_CASTER_TYPE, strStdCode, strGrd).Tables[0];

                //if (dtLGJH.Rows.Count > 1)
                //{
                //    TransactionHelper.RollBack();
                //    return "标准:" + strStdCode + ";钢种:" + strGrd + "找到多个炼钢记号,请核查!";
                //}
                //else if (dtLGJH.Rows.Count == 0)
                //{
                //    TransactionHelper.RollBack();
                //    return "标准:" + strStdCode + ";钢种:" + strGrd + "没有找到炼钢记号!";
                //}

                //strLGJH = dtLGJH.Rows[0]["C_STEEL_SIGN"].ToString();



                DataTable dt = dal_commute.GetList_max().Tables[0];
                max_C_MASTER_ID    = dt.Rows[0]["C_MASTER_ID"].ToString();
                max_C_GP_BEFORE_ID = dt.Rows[0]["C_GP_BEFORE_ID"].ToString();
                max_C_GP_AFTER_ID  = dt.Rows[0]["C_GP_AFTER_ID"].ToString();

                if (string.IsNullOrEmpty(max_C_MASTER_ID))
                {
                    max_C_MASTER_ID = "GPsj" + RV.UI.ServerTime.timeNow().ToString("yyMMdd00001");
                }
                else
                {
                    max_C_MASTER_ID = "GPsj" + (Convert.ToInt64(max_C_MASTER_ID) + 1).ToString();
                }
                if (string.IsNullOrEmpty(max_C_GP_BEFORE_ID))
                {
                    max_C_GP_BEFORE_ID = "GPpq" + RV.UI.ServerTime.timeNow().ToString("yyMMdd00001");
                }
                else
                {
                    max_C_GP_BEFORE_ID = "GPpq" + (Convert.ToInt64(max_C_GP_BEFORE_ID) + 1).ToString();
                }
                if (string.IsNullOrEmpty(max_C_GP_AFTER_ID))
                {
                    max_C_GP_AFTER_ID = "GPph" + RV.UI.ServerTime.timeNow().ToString("yyMMdd00001");
                }
                else
                {
                    max_C_GP_AFTER_ID = "GPph" + (Convert.ToInt64(max_C_GP_AFTER_ID) + 1).ToString();
                }
                Bll_TB_MATRL_MAIN bll_matrl = new Bll_TB_MATRL_MAIN();

                for (int i = 0; i < strs_Slab_ID.Length; i++)
                {
                    Mod_TSC_SLAB_MAIN mod_slab = dal_slab.GetModel(strs_Slab_ID[i]);
                    stove = mod_slab.C_STOVE;
                    if (mod_slab != null)
                    {
                        Mod_TB_MATRL_MAIN mod_matrl = bll_matrl.GetModel(strMatCode);
                        stove    = mod_slab.C_STOVE;
                        slabCode = mod_slab.C_SLABWH_CODE;
                        Mod_TQC_SLAB_COMMUTE mod = new Mod_TQC_SLAB_COMMUTE();
                        mod.C_STA_ID              = mod_slab.C_STA_DESC;
                        mod.C_STOVE               = mod_slab.C_STOVE;
                        mod.C_BATCH_NO            = mod_slab.C_BATCH_NO;
                        mod.N_WGT                 = mod_slab.N_WGT;
                        mod.N_LEN                 = mod_slab.N_LEN;
                        mod.C_STL_GRD_BEFORE      = mod_slab.C_STL_GRD;
                        mod.C_STD_CODE_BEFORE     = mod_slab.C_STD_CODE;
                        mod.C_SPEC_BEFORE         = mod_slab.C_SPEC;
                        mod.C_MAT_CODE_BEFORE     = mod_slab.C_MAT_CODE;
                        mod.C_MAT_DESC_BEFORE     = mod_slab.C_MAT_NAME;
                        mod.C_ZYX1_BEFORE         = mod_slab.C_ZYX1;
                        mod.C_ZYX2_BEFORE         = mod_slab.C_ZYX2;
                        mod.C_JUDGE_LEV_BP_BEFORE = mod_slab.C_MAT_TYPE;
                        mod.D_COMMUTE_DATE        = RV.UI.ServerTime.timeNow();
                        mod.C_STL_GRD_AFTER       = strGrd;
                        mod.C_STD_CODE_AFTER      = strStdCode;
                        mod.C_SPEC_AFTER          = mod_matrl.C_SLAB_SIZE;
                        mod.C_MAT_CODE_AFTER      = strMatCode;
                        mod.C_MAT_DESC_AFTER      = strMatName;
                        mod.C_REASON_DEPMT_ID     = strZrdwID;
                        mod.C_REASON_DEPMT_DESC   = strZrdwName;
                        mod.C_EMP_ID              = RV.UI.UserInfo.UserID;
                        mod.C_REMARK              = strRemark;
                        mod.C_MASTER_ID           = max_C_MASTER_ID;
                        mod.C_GP_BEFORE_ID        = max_C_GP_BEFORE_ID;
                        mod.C_GP_AFTER_ID         = max_C_GP_AFTER_ID;
                        mod.C_ZYX1_AFTER          = strZYX1;
                        mod.C_ZYX2_AFTER          = strZYX2;
                        mod.C_JUDGE_LEV_BP_AFTER  = strPDDJ;
                        mod.C_COMMUTE_REASON      = strGPYY;
                        if (dal_commute.Add_Trans(mod))
                        {
                            if (!dal_slab.Update_Trans(mod_slab.C_ID, mod_slab.C_BATCH_NO, strGrd, strStdCode, strMatCode, strMatName, mod_matrl.C_SLAB_SIZE, max_C_MASTER_ID, max_C_GP_BEFORE_ID, max_C_GP_AFTER_ID, strLGJH, strPDDJ, strZYX1, strZYX2, strGPYY, strLen, strDesignNo))
                            {
                                TransactionHelper.RollBack();
                                return("改判失败,请检查修改后的内容!");
                            }
                        }
                        else
                        {
                            TransactionHelper.RollBack();
                            return("改判失败,添加改判记录时错误!");
                        }
                    }
                }
                string interface_nc = dal_interface.SendXml_GP(strUrl, max_C_MASTER_ID, max_C_GP_BEFORE_ID, max_C_GP_AFTER_ID, slabCode);
                if (interface_nc != "1")
                {
                    TransactionHelper.RollBack();
                    return(interface_nc);
                }
                TransactionHelper.Commit();
            }
            catch (Exception ex)
            {
                TransactionHelper.RollBack();
                return(ex.Message);
            }

            return(result);
        }
예제 #6
0
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public Mod_TQC_SLAB_COMMUTE DataRowToModel(DataRow row)
        {
            Mod_TQC_SLAB_COMMUTE model = new Mod_TQC_SLAB_COMMUTE();

            if (row != null)
            {
                if (row["C_ID"] != null)
                {
                    model.C_ID = row["C_ID"].ToString();
                }
                if (row["C_SLAB_MAIN_ID"] != null)
                {
                    model.C_SLAB_MAIN_ID = row["C_SLAB_MAIN_ID"].ToString();
                }
                if (row["C_STA_ID"] != null)
                {
                    model.C_STA_ID = row["C_STA_ID"].ToString();
                }
                if (row["C_STOVE"] != null)
                {
                    model.C_STOVE = row["C_STOVE"].ToString();
                }
                if (row["N_WGT"] != null && row["N_WGT"].ToString() != "")
                {
                    model.N_WGT = decimal.Parse(row["N_WGT"].ToString());
                }
                if (row["N_LEN"] != null && row["N_LEN"].ToString() != "")
                {
                    model.N_LEN = decimal.Parse(row["N_LEN"].ToString());
                }
                if (row["C_STL_GRD_BEFORE"] != null)
                {
                    model.C_STL_GRD_BEFORE = row["C_STL_GRD_BEFORE"].ToString();
                }
                if (row["C_STD_CODE_BEFORE"] != null)
                {
                    model.C_STD_CODE_BEFORE = row["C_STD_CODE_BEFORE"].ToString();
                }
                if (row["C_SPEC_BEFORE"] != null)
                {
                    model.C_SPEC_BEFORE = row["C_SPEC_BEFORE"].ToString();
                }
                if (row["C_MAT_CODE_BEFORE"] != null)
                {
                    model.C_MAT_CODE_BEFORE = row["C_MAT_CODE_BEFORE"].ToString();
                }
                if (row["C_MAT_DESC_BEFORE"] != null)
                {
                    model.C_MAT_DESC_BEFORE = row["C_MAT_DESC_BEFORE"].ToString();
                }
                if (row["D_COMMUTE_DATE"] != null && row["D_COMMUTE_DATE"].ToString() != "")
                {
                    model.D_COMMUTE_DATE = DateTime.Parse(row["D_COMMUTE_DATE"].ToString());
                }
                if (row["C_STL_GRD_AFTER"] != null)
                {
                    model.C_STL_GRD_AFTER = row["C_STL_GRD_AFTER"].ToString();
                }
                if (row["C_STD_CODE_AFTER"] != null)
                {
                    model.C_STD_CODE_AFTER = row["C_STD_CODE_AFTER"].ToString();
                }
                if (row["C_SPEC_AFTER"] != null)
                {
                    model.C_SPEC_AFTER = row["C_SPEC_AFTER"].ToString();
                }
                if (row["C_MAT_CODE_AFTER"] != null)
                {
                    model.C_MAT_CODE_AFTER = row["C_MAT_CODE_AFTER"].ToString();
                }
                if (row["C_MAT_DESC_AFTER"] != null)
                {
                    model.C_MAT_DESC_AFTER = row["C_MAT_DESC_AFTER"].ToString();
                }
                if (row["C_REASON_DEPMT_ID"] != null)
                {
                    model.C_REASON_DEPMT_ID = row["C_REASON_DEPMT_ID"].ToString();
                }
                if (row["C_REASON_DEPMT_DESC"] != null)
                {
                    model.C_REASON_DEPMT_DESC = row["C_REASON_DEPMT_DESC"].ToString();
                }
                if (row["C_EMP_ID"] != null)
                {
                    model.C_EMP_ID = row["C_EMP_ID"].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_SCUTCHEON"] != null)
                {
                    model.C_SCUTCHEON = row["C_SCUTCHEON"].ToString();
                }
                if (row["C_MASTER_ID"] != null)
                {
                    model.C_MASTER_ID = row["C_MASTER_ID"].ToString();
                }
                if (row["C_GP_BEFORE_ID"] != null)
                {
                    model.C_GP_BEFORE_ID = row["C_GP_BEFORE_ID"].ToString();
                }
                if (row["C_GP_AFTER_ID"] != null)
                {
                    model.C_GP_AFTER_ID = row["C_GP_AFTER_ID"].ToString();
                }
                if (row["C_GP_TYPE"] != null)
                {
                    model.C_GP_TYPE = row["C_GP_TYPE"].ToString();
                }
                if (row["C_ZYX1_BEFORE"] != null)
                {
                    model.C_ZYX1_BEFORE = row["C_ZYX1_BEFORE"].ToString();
                }
                if (row["C_ZYX2_BEFORE"] != null)
                {
                    model.C_ZYX2_BEFORE = row["C_ZYX2_BEFORE"].ToString();
                }
                if (row["C_ZYX1_AFTER"] != null)
                {
                    model.C_ZYX1_AFTER = row["C_ZYX1_AFTER"].ToString();
                }
                if (row["C_ZYX2_AFTER"] != null)
                {
                    model.C_ZYX2_AFTER = row["C_ZYX2_AFTER"].ToString();
                }
                if (row["C_JUDGE_LEV_BP_BEFORE"] != null)
                {
                    model.C_JUDGE_LEV_BP_BEFORE = row["C_JUDGE_LEV_BP_BEFORE"].ToString();
                }
                if (row["C_JUDGE_LEV_BP_AFTER"] != null)
                {
                    model.C_JUDGE_LEV_BP_AFTER = row["C_JUDGE_LEV_BP_AFTER"].ToString();
                }
                if (row["C_BATCH_NO"] != null)
                {
                    model.C_BATCH_NO = row["C_BATCH_NO"].ToString();
                }
                if (row["C_COMMUTE_REASON"] != null)
                {
                    model.C_COMMUTE_REASON = row["C_COMMUTE_REASON"].ToString();
                }
            }
            return(model);
        }
예제 #7
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public bool Add(Mod_TQC_SLAB_COMMUTE model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into TQC_SLAB_COMMUTE(");
            strSql.Append(" C_SLAB_MAIN_ID,C_STA_ID,C_STOVE,N_WGT,N_LEN,C_STL_GRD_BEFORE,C_STD_CODE_BEFORE,C_SPEC_BEFORE,C_MAT_CODE_BEFORE,C_MAT_DESC_BEFORE,D_COMMUTE_DATE,C_STL_GRD_AFTER,C_STD_CODE_AFTER,C_SPEC_AFTER,C_MAT_CODE_AFTER,C_MAT_DESC_AFTER,C_REASON_DEPMT_ID,C_REASON_DEPMT_DESC,C_EMP_ID,C_REMARK,N_STATUS,C_SCUTCHEON,C_MASTER_ID,C_GP_BEFORE_ID,C_GP_AFTER_ID,C_GP_TYPE,C_ZYX1_BEFORE,C_ZYX2_BEFORE,C_ZYX1_AFTER,C_ZYX2_AFTER,C_JUDGE_LEV_BP_BEFORE,C_JUDGE_LEV_BP_AFTER,C_BATCH_NO,C_COMMUTE_REASON)");
            strSql.Append(" values (");
            strSql.Append(" :C_SLAB_MAIN_ID,:C_STA_ID,:C_STOVE,:N_WGT,:N_LEN,:C_STL_GRD_BEFORE,:C_STD_CODE_BEFORE,:C_SPEC_BEFORE,:C_MAT_CODE_BEFORE,:C_MAT_DESC_BEFORE,:D_COMMUTE_DATE,:C_STL_GRD_AFTER,:C_STD_CODE_AFTER,:C_SPEC_AFTER,:C_MAT_CODE_AFTER,:C_MAT_DESC_AFTER,:C_REASON_DEPMT_ID,:C_REASON_DEPMT_DESC,:C_EMP_ID,:C_REMARK,:N_STATUS,:C_SCUTCHEON,:C_MASTER_ID,:C_GP_BEFORE_ID,:C_GP_AFTER_ID,:C_GP_TYPE,:C_ZYX1_BEFORE,:C_ZYX2_BEFORE,:C_ZYX1_AFTER,:C_ZYX2_AFTER,:C_JUDGE_LEV_BP_BEFORE,:C_JUDGE_LEV_BP_AFTER,:C_BATCH_NO,:C_COMMUTE_REASON)");
            OracleParameter[] parameters =
            {
                new OracleParameter(":C_SLAB_MAIN_ID",        OracleDbType.Varchar2, 100),
                new OracleParameter(":C_STA_ID",              OracleDbType.Varchar2, 100),
                new OracleParameter(":C_STOVE",               OracleDbType.Varchar2, 100),
                new OracleParameter(":N_WGT",                 OracleDbType.Decimal,   15),
                new OracleParameter(":N_LEN",                 OracleDbType.Decimal,   15),
                new OracleParameter(":C_STL_GRD_BEFORE",      OracleDbType.Varchar2, 100),
                new OracleParameter(":C_STD_CODE_BEFORE",     OracleDbType.Varchar2, 100),
                new OracleParameter(":C_SPEC_BEFORE",         OracleDbType.Varchar2, 100),
                new OracleParameter(":C_MAT_CODE_BEFORE",     OracleDbType.Varchar2, 100),
                new OracleParameter(":C_MAT_DESC_BEFORE",     OracleDbType.Varchar2, 100),
                new OracleParameter(":D_COMMUTE_DATE",        OracleDbType.Date),
                new OracleParameter(":C_STL_GRD_AFTER",       OracleDbType.Varchar2, 100),
                new OracleParameter(":C_STD_CODE_AFTER",      OracleDbType.Varchar2, 100),
                new OracleParameter(":C_SPEC_AFTER",          OracleDbType.Varchar2, 100),
                new OracleParameter(":C_MAT_CODE_AFTER",      OracleDbType.Varchar2, 100),
                new OracleParameter(":C_MAT_DESC_AFTER",      OracleDbType.Varchar2, 100),
                new OracleParameter(":C_REASON_DEPMT_ID",     OracleDbType.Varchar2, 100),
                new OracleParameter(":C_REASON_DEPMT_DESC",   OracleDbType.Varchar2, 100),
                new OracleParameter(":C_EMP_ID",              OracleDbType.Varchar2, 100),
                new OracleParameter(":C_REMARK",              OracleDbType.Varchar2, 500),
                new OracleParameter(":N_STATUS",              OracleDbType.Decimal,    1),
                new OracleParameter(":C_SCUTCHEON",           OracleDbType.Varchar2, 100),
                new OracleParameter(":C_MASTER_ID",           OracleDbType.Varchar2, 100),
                new OracleParameter(":C_GP_BEFORE_ID",        OracleDbType.Varchar2, 100),
                new OracleParameter(":C_GP_AFTER_ID",         OracleDbType.Varchar2, 100),
                new OracleParameter(":C_GP_TYPE",             OracleDbType.Varchar2, 100),
                new OracleParameter(":C_ZYX1_BEFORE",         OracleDbType.Varchar2, 100),
                new OracleParameter(":C_ZYX2_BEFORE",         OracleDbType.Varchar2, 100),
                new OracleParameter(":C_ZYX1_AFTER",          OracleDbType.Varchar2, 100),
                new OracleParameter(":C_ZYX2_AFTER",          OracleDbType.Varchar2, 100),
                new OracleParameter(":C_JUDGE_LEV_BP_BEFORE", OracleDbType.Varchar2, 100),
                new OracleParameter(":C_JUDGE_LEV_BP_AFTER",  OracleDbType.Varchar2, 100),
                new OracleParameter(":C_BATCH_NO",            OracleDbType.Varchar2, 100),
                new OracleParameter(":C_COMMUTE_REASON",      OracleDbType.Varchar2, 200)
            };
            parameters[0].Value  = model.C_SLAB_MAIN_ID;
            parameters[1].Value  = model.C_STA_ID;
            parameters[2].Value  = model.C_STOVE;
            parameters[3].Value  = model.N_WGT;
            parameters[4].Value  = model.N_LEN;
            parameters[5].Value  = model.C_STL_GRD_BEFORE;
            parameters[6].Value  = model.C_STD_CODE_BEFORE;
            parameters[7].Value  = model.C_SPEC_BEFORE;
            parameters[8].Value  = model.C_MAT_CODE_BEFORE;
            parameters[9].Value  = model.C_MAT_DESC_BEFORE;
            parameters[10].Value = model.D_COMMUTE_DATE;
            parameters[11].Value = model.C_STL_GRD_AFTER;
            parameters[12].Value = model.C_STD_CODE_AFTER;
            parameters[13].Value = model.C_SPEC_AFTER;
            parameters[14].Value = model.C_MAT_CODE_AFTER;
            parameters[15].Value = model.C_MAT_DESC_AFTER;
            parameters[16].Value = model.C_REASON_DEPMT_ID;
            parameters[17].Value = model.C_REASON_DEPMT_DESC;
            parameters[18].Value = model.C_EMP_ID;
            parameters[19].Value = model.C_REMARK;
            parameters[20].Value = model.N_STATUS;
            parameters[21].Value = model.C_SCUTCHEON;
            parameters[22].Value = model.C_MASTER_ID;
            parameters[23].Value = model.C_GP_BEFORE_ID;
            parameters[24].Value = model.C_GP_AFTER_ID;
            parameters[25].Value = model.C_GP_TYPE;
            parameters[26].Value = model.C_ZYX1_BEFORE;
            parameters[27].Value = model.C_ZYX2_BEFORE;
            parameters[28].Value = model.C_ZYX1_AFTER;
            parameters[29].Value = model.C_ZYX2_AFTER;
            parameters[30].Value = model.C_JUDGE_LEV_BP_BEFORE;
            parameters[31].Value = model.C_JUDGE_LEV_BP_AFTER;
            parameters[32].Value = model.C_BATCH_NO;
            parameters[33].Value = model.C_COMMUTE_REASON;
            int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);

            if (rows > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }