bug

lu

3 天以前 9702c6a4dc358c7bff2eb18c8426229a0140e34a

 DevApp/Gs.DevApp/DevFrm/Sys/Frm_Config.cs

@@ -42,6 +42,25 @@
            //其它出库单仓管员
            sb.Append(" insert into [dbo].[MES_CONFIG](guid,parameter,parameterValue,remark) ");
            sb.Append(" values(newid(),'" + lb_qtckdcgy.Text.Trim() + "','" + txt_qtckdcgy.Text.Trim() + "','" + layoutControlItem6.Text.Trim() + "')");
            //采购退货申请采购员
            sb.Append(" insert into [dbo].[MES_CONFIG](guid,parameter,parameterValue,remark) ");
            sb.Append(" values(newid(),'" + lb_cgthsqcgy.Text.Trim() + "','" + txt_cgthsqcgy.Text.Trim() + "','" + layoutControlItem12.Text.Trim() + "')");
            //生产退料超%则要计划审核，即批准
            sb.Append(" insert into [dbo].[MES_CONFIG](guid,parameter,parameterValue,remark) ");
            sb.Append(" values(newid(),'" + lb_sctlbfb.Text.Trim() + "','" + txt_sctlbfb.Text.Trim() + "','" + layoutControlItem14.Text.Trim() + "')");
            //销售员
            sb.Append(" insert into [dbo].[MES_CONFIG](guid,parameter,parameterValue,remark) ");
            sb.Append(" values(newid(),'" + lb_FSalesManId.Text.Trim() + "','" + txt_FSalesManId.Text.Trim() + "','" + layoutControlItem16.Text.Trim() + "')");
            //齐套入库
            sb.Append(" insert into [dbo].[MES_CONFIG](guid,parameter,parameterValue,remark) ");
            sb.Append(" values(newid(),'" + lb_qtRk.Text.Trim() + "','" + txt_qtRk.Text.Trim() + "','" + layoutControlItem18.Text.Trim() + "')");
            //颜色
            sb.Append(" insert into [dbo].[MES_CONFIG](guid,parameter,parameterValue,remark) ");
            sb.Append(" values(newid(),'" + lb_colorFinish.Text.Trim() + "','" + txt_colorFinish.Text.Trim() + "','" + layoutControlItem20.Text.Trim() + "')");
            sb.Append(" insert into [dbo].[MES_CONFIG](guid,parameter,parameterValue,remark) ");
            sb.Append(" values(newid(),'" + lb_colorIng.Text.Trim() + "','" + txt_colorIng.Text.Trim() + "','" + layoutControlItem21.Text.Trim() + "')");
            sb.Append(" insert into [dbo].[MES_CONFIG](guid,parameter,parameterValue,remark) ");
            sb.Append(" values(newid(),'" + lb_color.Text.Trim() + "','" + txt_color.Text.Trim() + "','" + layoutControlItem22.Text.Trim() + "')");
            var _obj = new
            {
                sql = sb.ToString(),
@@ -112,6 +131,37 @@
                            txt_qtckdcgy.Text = row["parameterValue"].ToString();
                            continue;
                        }
                        if (row["remark"].ToString() == layoutControlItem12.Text)
                        {
                            txt_cgthsqcgy.Text = row["parameterValue"].ToString();
                            continue;
                        }
                        if (row["remark"].ToString() == layoutControlItem14.Text)
                        {
                            txt_sctlbfb.Text = row["parameterValue"].ToString();
                            continue;
                        }
                        if (row["remark"].ToString() == layoutControlItem18.Text)
                        {
                            txt_qtRk.Text = row["parameterValue"].ToString();
                            continue;
                        }

                        if (row["remark"].ToString() == layoutControlItem20.Text)
                        {
                            txt_colorFinish.Text = row["parameterValue"].ToString();
                            continue;
                        }
                        if (row["remark"].ToString() == layoutControlItem21.Text)
                        {
                            txt_colorIng.Text = row["parameterValue"].ToString();
                            continue;
                        }
                        if (row["remark"].ToString() == layoutControlItem22.Text)
                        {
                            txt_color.Text = row["parameterValue"].ToString();
                            continue;
                        }
                    }
                }
                else