using Newtonsoft.Json;
|
using Newtonsoft.Json.Linq;
|
using System;
|
using System.Collections.Generic;
|
using System.Data;
|
using System.Linq;
|
using System.Web;
|
using System.Web.Http;
|
using WebAPI.Models;
|
namespace WebAPI.Controllers.BaseSet
|
{
|
public class Xt_grdAlignment_WMESController : ApiController
|
{
|
private json objJsonResult = new json();
|
public DataSet ds = new DataSet();
|
public WebServer webserver = new WebServer();
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
|
grdAlignment omdelMian = new grdAlignment();
|
List<grdAlignmentSub> omdelsub = new List<grdAlignmentSub>();
|
|
|
#region 隐藏列设置 列表
|
[Route("Xt_grdAlignment_WMES/grdAlignmentWMESList")]
|
[HttpGet]
|
public object grdAlignmentWMESList(string HModName, string user)
|
{
|
try
|
{
|
ds = oCN.RunProcReturn("select * from Xt_grdAlignment_WMES where HModName='" + HModName + "' and HUserName='" + user + "'", "Xt_grdAlignment_WMES");
|
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "Sucess！";
|
objJsonResult.data = ds.Tables[0];
|
return objJsonResult;
|
}
|
catch (Exception e)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "Exception！" + e.ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
#endregion
|
|
#region 隐藏列设置 添加/修改
|
public class grdAlignment
|
{
|
public string HFixCols;
|
public string HFontSize;
|
public string HHeadTextHeight;
|
public string HTextHeight;
|
public string HSortFlag;
|
public string HSelTotal;
|
public string HColumnWidth;
|
|
}
|
public class grdAlignmentSub
|
{
|
public string ColumnName;
|
public bool IsHide;
|
public string Alignment;
|
}
|
|
[Route("Xt_grdAlignment_WMES/AddgrdAlignmentWMES")]
|
[HttpPost]
|
public object AddgrdAlignmentWMES([FromBody] JObject sMainSub)
|
{
|
var _value = sMainSub["sMainSub"].ToString();
|
string msg1 = _value.ToString();
|
oCN.BeginTran();
|
//保存主表
|
objJsonResult = AddBillMain(msg1);
|
if (objJsonResult.code == "0")
|
{
|
oCN.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = objJsonResult.Message;
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
oCN.Commit();
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "新增单据成功！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
public json AddBillMain(string msg1)
|
{
|
string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
|
string msg2 = sArray[0].ToString();
|
string msg3 = sArray[1].ToString();
|
string HModName = sArray[2].ToString();
|
int OperationType = int.Parse(sArray[3].ToString());//数据类型 1添加 3修改
|
string user = sArray[4].ToString();
|
try
|
{
|
|
|
omdelMian = Newtonsoft.Json.JsonConvert.DeserializeObject<grdAlignment>(msg2);
|
omdelsub = Newtonsoft.Json.JsonConvert.DeserializeObject<List<grdAlignmentSub>>(msg3);
|
|
var HGridString = "";
|
for (int i = 0; i < omdelsub.Count; i++)
|
{
|
HGridString += $"{(i+1)}|{(omdelsub[i].IsHide == true ? 1 : 0)}|{omdelsub[i].Alignment},";
|
}
|
HGridString = HGridString.Substring(0, HGridString.Length - 1);
|
|
oCN.RunProc("Delete from Xt_grdAlignment_WMES where HUserName='" + user + "' and HModName='" + HModName + "' ");
|
oCN.RunProc("insert into Xt_grdAlignment_WMES (HUserName,HModName,HGridString,HFixCols" +
|
",HFontSize,HHeadTextHeight,HTextHeight,HSortFlag,HSelTotal,HColumnWidth" +
|
") values('" + user + "','" + HModName + "','" + HGridString + "'," + (omdelMian.HFixCols == "" ? "0" : omdelMian.HFixCols) +
|
"," + (omdelMian.HFontSize == "" ? "0" : omdelMian.HFontSize) + ",0" +
|
",0,'" + omdelMian.HSortFlag + "','" + omdelMian.HSelTotal + "'" +
|
","+ (omdelMian.HColumnWidth == "" ? "0" : omdelMian.HColumnWidth) + ")");
|
|
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = null;
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
catch (Exception e)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "Exception！" + e.ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
|
#endregion
|
}
|
}
|
