~yxj/MES-WEB-API.git

			@@ -149,15 +149,16 @@
			//反序列化
			msg1 = "[" + msg1.ToString() + "]";
			DAL.ClsGy_WorkCenter_Ctl oDept = new DAL.ClsGy_WorkCenter_Ctl();
			DAL.ClsGy_WorkCenter_View oDeptHlp = new DAL.ClsGy_WorkCenter_View();
			List<Gy_WorkCenter> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Gy_WorkCenter>>(msg1);
			long HItemID = list[0].HItemID.ToString() == "" ? 0 : list[0].HItemID;
			long HItemID = list[0].HItemID ;
			string HNumber = list[0].HNumber;
			string HName = list[0].HName;
			string HShortNumber = list[0].HShortNumber;
			long HParentID = list[0].HParentID;
			string HHelpCode = list[0].HHelpCode;
			string HRemark = list[0].HRemark;
			string HStopflag = list[0].HStopflag=="True"?"1":"0";
			bool HStopflag = list[0].HStopflag;
			string HUseFlag = list[0].HUseFlag;
			var HWorkTimes = list[0].HWorkTimes;
			var HQty = list[0].HQty;
			@@ -184,7 +185,7 @@
			",HDeptNumber,HWorkTimes,HQty" +
			",HLevel,HEndFlag,HStopflag,HRemark,HDeptID,HBarCodeForBase" +
			",HProcID,HDayMoney) " +
			" Values('" + HNumber + "','" + HName + "','" + HHelpCode + "','" + HShortNumber + "'," + HItemID.ToString() +
			" Values('" + HNumber + "','" + HName + "','" + HHelpCode + "','" + HShortNumber + "'," + HParentID.ToString() +
			",'" + HDeptNumber + "'," + HWorkTimes + "," + HQty +
			",'" + HLevel.ToString() + "'," + HEndFlag + "," + HStopflag +
			",'" + HRemark + "'," + HDeptID + ",'" + HBarCodeForBase + "','" + HProcID + "'," + HDayMoney + ")";
			@@ -212,39 +213,50 @@
			}
			}
			/// <summary>
			/// 修改单据-保存按钮
			/// 保存按钮
			///参数：string sql。
			///返回值：object。
			/// </summary>
			[Route("Gy_WorkCenter/EditBill")]
			[Route("Gy_WorkCenter/ModifyByID")]
			[HttpPost]
			public object EditBill([FromBody] JObject oMain)
			public object ModifyByID([FromBody] JObject oMain)
			{
			try
			{
			DAL.ClsGy_WorkCenter_Ctl oDept = new DAL.ClsGy_WorkCenter_Ctl();
			DAL.ClsGy_WorkCenter_View oDeptHlp = new DAL.ClsGy_WorkCenter_View();

			var _value = oMain["oMain"].ToString();
			string msg1 = _value.ToString();
			string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
			string msg2 = sArray[0].ToString();
			//string msg3 = sArray[1].ToString();
			//string msg4 = sArray[2].ToString();
			//string msg5 = sArray[3].ToString();
			//反序列化
			msg1 = "[" + msg1.ToString() + "]";
			DAL.ClsGy_WorkCenter_Ctl oDept = new DAL.ClsGy_WorkCenter_Ctl();
			List<Gy_WorkCenter> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Gy_WorkCenter>>(msg1);
			msg2 = "[" + msg2.ToString() + "]";
			List<Gy_WorkCenter> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Gy_WorkCenter>>(msg2);

			long HItemID = list[0].HItemID;
			string HNumber = list[0].HNumber;
			string HName = list[0].HName;
			string HShortNumber = list[0].HNumber;
			string HShortNumber = list[0].HShortNumber;
			string HDeptNumber = list[0].HDeptNumber;
			long HParentID = list[0].HParentID;
			string HHelpCode = list[0].HHelpCode;
			string HRemark = list[0].HRemark;
			string HStopflag = list[0].HStopflag;
			bool HStopflag = list[0].HStopflag;
			bool HEndFlag = list[0].HStopflag;
			string HUseFlag = list[0].HUseFlag;
			var HQty = list[0].HQty;
			var HBarCodeForBase = list[0].HBarCodeForBase;
			var HDayMoney = list[0].HDayMoney;
			var HDeptID = list[0].HDeptID;
			var HProcID = list[0].HProcID;
			var HLevel = list[0].HLevel;
			var HWorkTimes = list[0].HWorkTimes;

			//判断权限
			////判断权限
			//if (!ClsPub.Security_Log(msg5, 1, true, msg4))
			//{
			// objJsonResult.code = "0";
			@@ -253,6 +265,7 @@
			// objJsonResult.data = null;
			// return objJsonResult;
			//}

			//if (!DBUtility.ClsPub.AllowNumber(HNumber))
			//{
			// objJsonResult.code = "0";
			@@ -261,6 +274,7 @@
			// objJsonResult.data = null;
			// return objJsonResult;
			//}

			//if (oDept.HavSameNumber(HItemID, HNumber))
			//{
			// objJsonResult.code = "0";
			@@ -269,31 +283,52 @@
			// objJsonResult.data = null;
			// return objJsonResult;
			//}
			//若MAINDI重复则重新获取
			oCN.BeginTran();
			//主表
			oCN.RunProc("Update Gy_WorkCenter set " +
			" HNumber='" + HNumber + "'" +
			",HName='" + HName + "'" +
			",HShortNumber='" + HShortNumber + "'" +
			",HHelpCode='" + HHelpCode + "'" +
			",HParentID=" + HParentID +
			",HStopflag='" + HStopflag + "'" +
			",HRemark= '" + HRemark + "'"+
			",HDeptID=" + HDeptID +
			",HQty=" + HQty +
			",HWorkTimes=" + HWorkTimes +
			",HBarCodeForBase='" + HBarCodeForBase + "' Where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo);
			//修改子项目代码
			//oCN.RunProc("exec h_p_Gy_UpdateNumber Gy_WorkCenter,'" + HNumber + ".','" + this.HOldNumber + ".'", ref DBUtility.ClsPub.sExeReturnInfo);
			//将上级为非末级
			oCN.RunProc("Update Gy_WorkCenter set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo);
			//
			oCN.Commit();
			objJsonResult.code = "1";
			//保存
			//保存完毕后处理
			if (HItemID == 0)
			{
			oCN.BeginTran();
			oCN.RunProc("Insert into Gy_WorkCenter " +
			" (HNumber,HName,HHelpCode,HShortNumber,HParentID" +
			",HDeptNumber,HWorkTimes,HQty" +
			",HLevel,HEndFlag,HStopflag,HRemark,HDeptID,HBarCodeForBase" +
			",HProcID,HDayMoney) " +
			" Values('" + HNumber + "','" + HName + "','" + HHelpCode + "','" + HShortNumber + "'," + HParentID.ToString() +
			",'" + HDeptNumber + "'," + HWorkTimes + "," + HQty +
			"," + HLevel.ToString() + "," + Convert.ToString(HEndFlag ? 1 : 0) + "," + Convert.ToString(HStopflag ? 1 : 0) +
			",'" + HRemark + "'," + HDeptID + ",'" + HBarCodeForBase + "'," + HProcID + "," + HDayMoney + ")", ref DBUtility.ClsPub.sExeReturnInfo);
			//修改上级为非末级代码
			oCN.RunProc("Update Gy_WorkCenter set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo);
			oCN.Commit();
			}
			else
			{
			//若MAINDI重复则重新获取
			oCN.BeginTran();
			oCN.RunProc("Update Gy_WorkCenter set " +
			" HNumber='" + HNumber + "'" +
			",HName='" + HName + "'" +
			",HShortNumber='" + HShortNumber + "'" +
			",HHelpCode='" + HHelpCode + "'" +
			",HParentID=" + HParentID +
			",HStopflag='" + HStopflag + "'" +
			",HRemark= '" + HRemark + "'" +
			",HDeptID=" + HDeptID +
			",HQty=" + HQty +
			",HWorkTimes=" + HWorkTimes +
			",HBarCodeForBase='" + HBarCodeForBase + "' Where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo);
			//修改子项目代码
			//oCN.RunProc("exec h_p_Gy_UpdateNumber Gy_WorkCenter,'" + HNumber + ".','" + this.HOldNumber + ".'", ref DBUtility.ClsPub.sExeReturnInfo);
			//将上级为非末级
			oCN.RunProc("Update Gy_WorkCenter set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo);

			oCN.Commit();
			}
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "修改单据成功！";
			//objJsonResult.data = null;
			objJsonResult.Message = "保存成功！";
			//WebAPIController.Add_Log("送货单下推", UserName, "生成送货单");
			objJsonResult.data = 1;
			return objJsonResult;
			}
			catch (Exception e)
			@@ -306,6 +341,191 @@
			return objJsonResult;
			}
			}
			///// <summary>
			///// 修改单据-保存按钮
			/////参数：string sql。
			/////返回值：object。
			///// </summary>
			//[Route("Gy_WorkCenter/EditBill")]
			//[HttpPost]
			//public object EditBill([FromBody] JObject oMain)
			//{
			// try
			// {
			// var _value = oMain["oMain"].ToString();
			// string msg1 = _value.ToString();
			// //反序列化
			// msg1 = "[" + msg1.ToString() + "]";
			// DAL.ClsGy_WorkCenter_Ctl oDept = new DAL.ClsGy_WorkCenter_Ctl();
			// List<Gy_WorkCenter> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Gy_WorkCenter>>(msg1);

			//long HItemID = list[0].HItemID;
			//string HNumber = list[0].HNumber;
			//string HName = list[0].HName;
			//string HShortNumber = list[0].HNumber;
			//long HParentID = list[0].HParentID;
			//string HHelpCode = list[0].HHelpCode;
			//string HRemark = list[0].HRemark;
			//string HStopflag = list[0].HStopflag;
			//string HUseFlag = list[0].HUseFlag;
			//var HQty = list[0].HQty;
			//var HBarCodeForBase = list[0].HBarCodeForBase;
			//var HDayMoney = list[0].HDayMoney;
			//var HDeptID = list[0].HDeptID;
			//var HWorkTimes = list[0].HWorkTimes;

			// //判断权限
			// //if (!ClsPub.Security_Log(msg5, 1, true, msg4))
			// //{
			// // objJsonResult.code = "0";
			// // objJsonResult.count = 0;
			// // objJsonResult.Message = "没有找到该功能模块！";
			// // objJsonResult.data = null;
			// // return objJsonResult;
			// //}
			// //if (!DBUtility.ClsPub.AllowNumber(HNumber))
			// //{
			// // objJsonResult.code = "0";
			// // objJsonResult.count = 0;
			// // objJsonResult.Message = "代码中不能出现连续‘.’并且首位末位不能为‘.’！";
			// // objJsonResult.data = null;
			// // return objJsonResult;
			// //}
			// //if (oDept.HavSameNumber(HItemID, HNumber))
			// //{
			// // objJsonResult.code = "0";
			// // objJsonResult.count = 0;
			// // objJsonResult.Message = "代码重复！";
			// // objJsonResult.data = null;
			// // return objJsonResult;
			// //}
			// //若MAINDI重复则重新获取
			// oCN.BeginTran();
			// //主表
			// oCN.RunProc("Update Gy_WorkCenter set " +
			// " HNumber='" + HNumber + "'" +
			// ",HName='" + HName + "'" +
			// ",HShortNumber='" + HShortNumber + "'" +
			// ",HHelpCode='" + HHelpCode + "'" +
			// ",HParentID=" + HParentID +
			// ",HStopflag='" + HStopflag + "'" +
			// ",HRemark= '" + HRemark + "'"+
			// ",HDeptID=" + HDeptID +
			// ",HQty=" + HQty +
			// ",HWorkTimes=" + HWorkTimes +
			// ",HBarCodeForBase='" + HBarCodeForBase + "' Where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo);
			// //修改子项目代码
			// //oCN.RunProc("exec h_p_Gy_UpdateNumber Gy_WorkCenter,'" + HNumber + ".','" + this.HOldNumber + ".'", ref DBUtility.ClsPub.sExeReturnInfo);
			// //将上级为非末级
			// oCN.RunProc("Update Gy_WorkCenter set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo);
			// //
			// 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;
			// }
			//}
			/// <summary>
			/// 工作中心删除功能
			/// </summary>
			/// <returns></returns>
			[Route("DeltetGy_WorkCenter")]
			[HttpGet]
			public object DeltetGy_WorkCenter(string HItemID)
			{
			DataSet ds;
			DataSet ds1;
			//string ModRightNameCheck = "Sc_ProcessReport_check";
			try
			{
			//删除权限
			//if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 1, true, CurUserName))
			//{
			// objJsonResult.code = "0";
			// objJsonResult.count = 0;
			// objJsonResult.Message = "审核失败！无权限！";
			// objJsonResult.data = null;
			// return objJsonResult;
			//}

			SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
			if (string.IsNullOrWhiteSpace(HItemID))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "HItemID为空！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			oCN.BeginTran();//开始事务
			ds = oCN.RunProcReturn("select * from Gy_WorkCenter where HItemID=" + HItemID, "Gy_WorkCenter");
			if (ds == null \|\| ds.Tables[0].Rows.Count == 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "没有数据，无法删除！";
			objJsonResult.data = null;
			return objJsonResult; ;
			}
			//var HStopflag = Convert.ToBoolean(ds.Tables[0].Rows[0]["HStopflag"]);
			//if (HStopflag)
			//{
			// oCN.RollBack();//回滚事务
			// objJsonResult.code = "0";
			// objJsonResult.count = 0;
			// objJsonResult.Message = "数据已删除无法再次删除！";
			// objJsonResult.data = null;
			// return objJsonResult;
			//}
			ds1 = oCN.RunProcReturn("Select HItemID from Gy_WorkCenter Where HParentID='" + HItemID + "'", " Gy_WorkCenter");
			if (ds1.Tables[0].Rows.Count != 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "此项目存在子项目，不能删除！";
			objJsonResult.data = null;
			return objJsonResult;
			}

			string HUseFlag = Convert.ToString(ds.Tables[0].Rows[0]["HUseFlag"]);
			if (HUseFlag == "已使用")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "此项目已使用，不能删除！";
			objJsonResult.data = null;
			return objJsonResult;
			}

			oCN.RunProc("delete from Gy_WorkCenter where HItemID=" + HItemID);
			oCN.Commit();//提交事务
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "* 数据删除成功！";
			objJsonResult.data = null;
			return objJsonResult; ;

			}
			catch (Exception e)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "删除失败！" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			/// <summary>
			/// 工作中心列表修改按钮方法
			///参数：string sql。