bug

lu

2 天以前 09f8d9f072aa048787beb0112267be0bdf0c2423

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
using Gs.DevApp.Entity;
using Gs.DevApp.ToolBox;
using Newtonsoft.Json;
using Newtonsoft.Json.Linq;
using System;
using System.Data;
using System.Windows.Forms;
 
namespace Gs.DevApp.DevFrm.Sys
{
    public partial class Frm_Config : DevExpress.XtraEditors.XtraForm
    {
        public Frm_Config()
        {
            InitializeComponent();
            btnSave.Click += BtnSave_Click;
            getModel();
        }
 
        /// <summary>
        ///  保存配置
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        /// <exception cref="NotImplementedException"></exception>
        private void BtnSave_Click(object sender, EventArgs e)
        {
            System.Text.StringBuilder sb = new System.Text.StringBuilder();
            sb.Append(" delete from MES_CONFIG");
            //其它入库单验收员
            sb.Append(" insert into [dbo].[MES_CONFIG](guid,parameter,parameterValue,remark) ");
            sb.Append(" values(newid(),'" + lb_qtrkdysy.Text.Trim() + "','" + txt_qtrkdysy.Text.Trim() + "','" + layoutControlItem1.Text.Trim() + "')");
            //其它入库单仓管员
            sb.Append(" insert into [dbo].[MES_CONFIG](guid,parameter,parameterValue,remark) ");
            sb.Append(" values(newid(),'" + lb_qtrkdcgy.Text.Trim() + "','" + txt_qtrkdcgy.Text.Trim() + "','" + layoutControlItem2.Text.Trim() + "')");
            //齐套
            sb.Append(" insert into [dbo].[MES_CONFIG](guid,parameter,parameterValue,remark) ");
            sb.Append(" values(newid(),'" + lb_qtkg.Text.Trim() + "','" + txt_qtkg.Checked + "','" + layoutControlItem3.Text.Trim() + "')");
            //其它出库单领料人
            sb.Append(" insert into [dbo].[MES_CONFIG](guid,parameter,parameterValue,remark) ");
            sb.Append(" values(newid(),'" + lb_qtckdllr.Text.Trim() + "','" + txt_qtckdllr.Text.Trim() + "','" + layoutControlItem5.Text.Trim() + "')");
            //其它出库单仓管员
            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() + "')");
            var _obj = new
            {
                sql = sb.ToString(),
            };
            try
            {
                var strJson = UtilityHelper.HttpPost("", "MesConfig/SetModel",
                    JsonConvert.SerializeObject(_obj));
                var _rtn = UtilityHelper.ReturnToDynamic(strJson);
                if (_rtn.rtnCode > 0)
                {
                    MsgHelper.ShowInformation("提示：" + _rtn.rtnMsg);
                }
                else
                {
                    MsgHelper.ShowError("提示：" + _rtn.rtnMsg);
                }
            }
            catch (Exception ex)
            {
                DialogResult = DialogResult.Cancel;
                MsgHelper.ShowError("提示：" + ex.Message);
            }
        }
 
        private void getModel()
        {
            var _obj = new
            {
            };
            try
            {
                string strJson = UtilityHelper.HttpPost("", "MesConfig/GetModel", JsonConvert.SerializeObject(_obj));
                ReturnModel<dynamic> _rtn = ToolBox.UtilityHelper.ReturnToDynamic(strJson);
                if (_rtn.rtnCode > 0)
                {
                    JObject _job = JObject.Parse(strJson);
                    JArray array = new JArray();
                    foreach (var a in _job["rtnData"]["list"])
                    {
                        array.Add(a);
                    }
                    DataTable dt = JsonConvert.DeserializeObject<DataTable>(array.ToString());
                    foreach (DataRow row in dt.Rows)
                    {
                        if (row["remark"].ToString() == layoutControlItem1.Text)
                        {
                            txt_qtrkdysy.Text = row["parameterValue"].ToString();
                            continue;
                        }
                        if (row["remark"].ToString() == layoutControlItem2.Text)
                        {
                            txt_qtrkdcgy.Text = row["parameterValue"].ToString();
                            continue;
                        }
                        if (row["remark"].ToString() == layoutControlItem3.Text)
                        {
                            txt_qtkg.Checked = UtilityHelper.ToCheck(row["parameterValue"].ToString());
                            continue;
                        }
                        if (row["remark"].ToString() == layoutControlItem5.Text)
                        {
                            txt_qtckdllr.Text = row["parameterValue"].ToString();
                            continue;
                        }
                        if (row["remark"].ToString() == layoutControlItem6.Text)
                        {
                            txt_qtckdcgy.Text = row["parameterValue"].ToString();
                            continue;
                        }
                    }
                }
                else
                    ToolBox.MsgHelper.ShowError("提示：" + _rtn.rtnMsg);
            }
            catch (Exception ex)
            {
                ToolBox.MsgHelper.ShowError("提示：" + ex.Message);
            }
        }
    }
}