using DevExpress.Drawing.Internal.Fonts.Interop;
|
using DevExpress.Utils.DirectXPaint;
|
using DevExpress.XtraEditors;
|
using Gs.DevApp.Entity;
|
using Gs.DevApp.ToolBox;
|
using Newtonsoft.Json;
|
using Newtonsoft.Json.Linq;
|
using System;
|
using System.Collections.Generic;
|
using System.ComponentModel;
|
using System.Data;
|
using System.Drawing;
|
using System.Linq;
|
using System.Text;
|
using System.Threading.Tasks;
|
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);
|
}
|
}
|
}
|
}
|
