~yxj/MES-WEB-API.git

			@@ -26,7 +26,7 @@
			/// </summary>
			[Route("Gy_Department/list")]
			[HttpGet]
			public object list(string sWhere,string user,string Organization)
			public object list(string sWhere, string user, string Organization)
			{
			try
			{
			@@ -75,8 +75,6 @@
			return objJsonResult;
			}
			}


			/// <summary>
			/// 根据基础资料ID 查找记录
			///参数：string sql。
			@@ -122,7 +120,7 @@
			/// <returns></returns>
			[Route("DeltetGy_Department")]
			[HttpGet]
			public object DeltetGy_Department(string HItemID,string user)
			public object DeltetGy_Department(string HItemID, string user)
			{
			DataSet ds;
			DataSet ds1;
			@@ -334,15 +332,11 @@
			oCN.RunProc("Insert Into Gy_Department " +
			"(HNumber,HShortNumber,HName,HParentID" +
			",HLevel,HEndFlag,HRemark,HStopFlag,HUseFlag" +
			",HCREATEORGID,HUSEORGID,HBarCode,HCreator" +
			",HUpdater,HChecker,HDeleteMan" +
			",HSecManagerID,HCreateDate" +
			",HCREATEORGID,HUSEORGID" +
			") " +
			" values('" + HNumber + "','" + HShortNumber + "','" + HName + "',0" +
			",'',0,'" + HRemark + "',0,''" +
			"," + HCreateOrgID + "," + HUseOrgID + ",'" + HBarCode + "','" + HCreator + "'" +
			",'" + HUpdater + "','" + HChecker + "','" + HDeleteMan + "'" +
			"," + HSecManagerID + ", getdate()" +
			"," + HCreateOrgID + "," + HUseOrgID + "" +
			") ");
			//修改上级为非末级代码
			oCN.RunProc("Update Gy_Department set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo);
			@@ -400,7 +394,7 @@
			}
			//反序列化
			msg2 = msg2.Replace("\\", "");
			msg2 = msg2.Replace("\n", "");
			msg2 = msg2.Replace("\n", "");
			msg2 = "[" + msg2.ToString() + "]";
			List<Department> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Department>>(msg2);

			@@ -506,7 +500,7 @@
			}
			catch (Exception e)
			{
			oCN.RollBack();
			//oCN.RollBack();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "Exception！" + e.Message;
			@@ -601,8 +595,51 @@
			}
			}

			[Route("Gy_Department/SaveGy_DepartmentListApi")]
			[HttpPost]
			public object SaveGy_DepartmentListApi([FromBody] JObject oMain)
			{
			try
			{
			var model = oMain["model"].ToString();
			//反序列化
			model = "[" + model + "]";
			List<Department> lsmain = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Department>>(model);
			string sql = string.Empty;
			oCN.BeginTran();
			sql = $"delete Gy_Department where HItemID = {lsmain[0].HItemID}";
			oCN.RunProc(sql);
			sql = "set identity_insert Gy_Department on";
			oCN.RunProc(sql);
			//主表
			oCN.RunProc("Insert Into Gy_Department " +
			"(HItemID,HNumber,HShortNumber,HName,HParentID" +
			",HLevel,HEndFlag,HRemark,HStopFlag,HUseFlag" +
			",HCREATEORGID,HUSEORGID"+
			") " +
			" values('" + lsmain[0].HItemID + "','" + lsmain[0].HNumber + "','" + lsmain[0].HShortNumber + "','" + lsmain[0].HName + "',0" +
			",'',0,'" + lsmain[0].HRemark + "',0,''" +
			"," + lsmain[0].HCreateOrgID + "," + lsmain[0].HUseOrgID + "" +
			") ");
			sql = "set identity_insert Gy_Department off";
			oCN.RunProc(sql);
			oCN.Commit();
			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "新增单据成功！";
			//objJsonResult.data = null;
			return objJsonResult;
			}
			catch (Exception e)
			{
			oCN.RollBack();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "Exception！" + e.Message;
			objJsonResult.data = null;
			return objJsonResult;
			}
			}


			//
			}
			}