MES-WEB-API.git

			@@ -1,4 +1,5 @@
			using Newtonsoft.Json.Linq;
			using Newtonsoft.Json;
			using Newtonsoft.Json.Linq;
			using Pub_Class;
			using System;
			using System.Collections;
			@@ -12,11 +13,9 @@
			public class Xt_BillTypeController : ApiController
			{
			public DBUtility.ClsPub.Enum_BillStatus BillStatus;

			private json objJsonResult = new json();
			SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
			DataSet ds;


			/// <summary>
			/// 返回单据类型列表
			@@ -29,32 +28,43 @@
			{
			try
			{
			List<object> columnNameList = new List<object>();
			if (sWhere == null \|\| sWhere.Equals(""))
			{
			ds = oCN.RunProcReturn("select * from h_v_Xt_BillTypeList " + sWhere, "h_v_Xt_BillTypeList");
			ds = oCN.RunProcReturn("select * from h_v_Xt_BillTypeList " + sWhere+ " order by hitemid desc", "h_v_Xt_BillTypeList");
			}
			else
			{
			string sql1 = "select * from h_v_Xt_BillTypeList where 1 = 1 ";
			string sql = sql1 + sWhere;
			string sql = sql1 + sWhere+ " order by hitemid desc";
			ds = oCN.RunProcReturn(sql, "h_v_Xt_BillTypeList");
			}
			if (ds == null \|\| ds.Tables[0].Rows.Count == 0)

			//添加列名
			foreach (DataColumn col in ds.Tables[0].Columns)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "没有返回任何记录！";
			objJsonResult.data = null;
			return objJsonResult;
			Type dataType = col.DataType;
			string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}";
			columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//获取到DataColumn列对象的列名
			}
			else
			{
			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "Sucess！";
			objJsonResult.data = ds.Tables[0];
			return objJsonResult;
			}

			//if (ds.Tables[0].Rows.Count != 0 \|\| ds != null)
			//{
			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "Sucess！";
			objJsonResult.data = ds.Tables[0];
			objJsonResult.list = columnNameList;
			return objJsonResult;
			//}
			//else
			//{
			//objJsonResult.code = "0";
			//objJsonResult.count = 0;
			//objJsonResult.Message = "无数据";
			//objJsonResult.data = null;
			//return objJsonResult;
			//}
			}
			catch (Exception e)
			{
			@@ -65,7 +75,6 @@
			return objJsonResult;
			}
			}


			/// <summary>
			/// 单据类型列表修改方法
			@@ -134,7 +143,6 @@
			[HttpPost]
			public object AddBill1([FromBody] JObject oMain)
			{

			try
			{
			var _value = oMain["oMain"].ToString();
			@@ -157,8 +165,6 @@
			string HViewName = list[0].HViewName;
			string HRightName = list[0].HRightName;



			//若MAINDI重复则重新获取
			oCN.BeginTran();
			//主表
			@@ -192,7 +198,6 @@
			}
			}


			/// <summary>
			/// 新增单据-保存按钮
			///参数：string sql。
			@@ -208,11 +213,7 @@
			string msg1 = _value.ToString();
			//反序列化
			msg1 = "[" + msg1.ToString() + "]";



			List<BillType> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<BillType>>(msg1);

			long HItemID = list[0].HItemID;
			string HNumber = list[0].HNumber;
			string HName = list[0].HName;
			@@ -222,13 +223,9 @@
			string HViewName = list[0].HViewName;
			string HRightName = list[0].HRightName;






			//若MAINDI重复则重新获取
			oCN.BeginTran();

			//主表
			oCN.RunProc("Insert Into Xt_BillType " +
			"(HNumber,HName,HTemplate,HHeadTable" +
			@@ -256,7 +253,86 @@
			}
			}


			/// <summary>
			/// 单据删除
			///参数：string HInterID。
			///返回值：object。
			/// </summary>
			[Route("YS_ReceiveBill/delete_Test1")]
			[HttpGet]
			public object deleteYS_ReceiveBill(long HItemID)
			{
			try
			{
			//若MAINDI重复则重新获取
			oCN.BeginTran();
			//主表
			oCN.RunProc("delete from Xt_BillType Where HItemID =" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo);
			oCN.Commit();
			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "删除单据成功！";
			//objJsonResult.data = null;
			return objJsonResult;
			}
			catch (Exception e)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "Exception！" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}

			//
			#region 单据类型金蝶同步
			[Route("Xt_BillType/SaveXt_BillTypeListApi")]
			[HttpPost]
			public object SaveXt_BillTypeListApi([FromBody] JObject msg)
			{
			try
			{
			var _value = msg["model"].ToString();
			LogService.Write("单据类型:" + _value);
			SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
			ListModels oListModels = new ListModels();
			List<Model.ClsXt_BillType_Model> lsmain = new List<Model.ClsXt_BillType_Model>();
			lsmain = oListModels.getObjectByJson_Xt_BillType(_value);
			string sql = string.Empty;
			//保存
			oCN.BeginTran();
			sql = $"delete Xt_BillType where HItemID = {lsmain[0].HItemID}";
			oCN.RunProc(sql);
			//sql = "set identity_insert Xt_BillType on";
			//oCN.RunProc(sql);

			LogService.Write("单据类型:" + $@"insert into Xt_BillType(HBilltypeID,HNumber,HName,HTemplate,HHeadTable,HEntryTable,HViewName,HRightName)
			values('{lsmain[0].HBilltypeID}','{lsmain[0].HNumber}','{lsmain[0].HName}','{lsmain[0].HTemplate}','{lsmain[0].HHeadTable}','{lsmain[0].HEntryTable}','{lsmain[0].HViewName}','{lsmain[0].HRightName}' )");

			oCN.RunProc($@"insert into Xt_BillType(HBilltypeID,HNumber,HName,HTemplate,HHeadTable,HEntryTable,HViewName,HRightName)
			values('{lsmain[0].HBilltypeID}','{lsmain[0].HNumber}','{lsmain[0].HName}','{lsmain[0].HTemplate}','{lsmain[0].HHeadTable}','{lsmain[0].HEntryTable}','{lsmain[0].HViewName}','{lsmain[0].HRightName}' )", ref DBUtility.ClsPub.sExeReturnInfo);
			//修改上级为非末级代码
			sql = "set identity_insert Xt_BillType off";
			oCN.RunProc(sql);
			oCN.Commit();

			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "保存成功！";
			objJsonResult.data = 1;
			return objJsonResult;
			}
			catch (Exception e)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "保存失败！" + e.ToString();
			objJsonResult.data = 1;
			return objJsonResult;
			}
			}
			#endregion

			}
			}