~yxj/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;
			@@ -19,6 +20,45 @@
			SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
			DataSet ds;

			/// <summary>
			/// 根据基础资料ID 查找记录
			///参数：string sql。
			///返回值：object。
			/// </summary>
			[Route("Cg_POInStockBill/cx")]
			[HttpGet]
			public object cx(long HInterID)
			{
			try
			{

			ds = oCN.RunProcReturn("select * from h_v_IF_POInStockBillList where hmainid=" + HInterID, "h_v_IF_POInStockBillList");
			if (ds == null \|\| ds.Tables[0].Rows.Count == 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "false！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			else
			{
			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;
			}
			}

			/// <summary>
			/// 返回收料通知单列表
			@@ -67,8 +107,247 @@
			return objJsonResult;
			}
			}
			/// <summary>
			/// 保存按钮
			///参数：string sql。
			///返回值：object。
			/// </summary>
			[Route("Cg_POInStockBill/ModifyByID")]
			[HttpPost]
			public object ModifyByID([FromBody] JObject oMain)
			{
			try
			{
			DAL.ClsGy_Warehouse_Ctl oDept = new DAL.ClsGy_Warehouse_Ctl();
			DAL.ClsGy_Warehouse_View oDeptHlp = new DAL.ClsGy_Warehouse_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();
			//反序列化
			msg2 = "[" + msg2.ToString() + "]";
			List<Warehouse> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Warehouse>>(msg2);

			long HItemID = list[0].HItemID;
			string HNumber = list[0].HNumber;
			string HName = list[0].HName;
			string HHelpCode = list[0].HHelpCode;
			string HShortNumber = list[0].HShortNumber;
			long HParentID = list[0].HParentID;
			long HLevel = list[0].HLevel;
			bool HEndFlag = list[0].HEndFlag;
			bool HStopflag = list[0].HStopflag;
			string HRemark = list[0].HRemark;
			string HBarCode = list[0].HBarCode;
			long HEmpID = list[0].HEmpID;
			string HAddress = list[0].HAddress;
			string HPhone = list[0].HPhone;
			long HUSEORGID = list[0].HUSEORGID;
			string HUpDater = list[0].HUpDater;

			////判断权限
			//if (!ClsPub.Security_Log(msg5, 1, false, 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;
			//}
			//保存
			//保存完毕后处理
			if (HItemID == 0)
			{
			oCN.BeginTran();
			oCN.RunProc("Insert into Gy_Warehouse " +
			" (HNumber,HName,HHelpCode,HShortNumber,HParentID" +
			",HLevel,HEndFlag,HStopflag,HRemark,HEmpID,HAddress,HPhone,HUSEORGID) " +
			" Values('" + HNumber + "','" + HName + "','" + HHelpCode + "','" + HShortNumber + "'," + HParentID.ToString() +
			"," + HLevel.ToString() + "," + Convert.ToString(HEndFlag ? 1 : 0) + "," + Convert.ToString(HStopflag ? 1 : 0) + ",'" + HRemark + "'," + HEmpID.ToString() + ",'" + HAddress + "','" + HPhone + "','" + HUSEORGID + "')", ref DBUtility.ClsPub.sExeReturnInfo);
			//修改上级为非末级代码
			oCN.RunProc("Update Gy_Warehouse set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo);
			oCN.Commit();
			}
			else
			{
			//若MAINDI重复则重新获取
			oCN.BeginTran();
			//主表
			oCN.RunProc("Update Gy_Warehouse set " +
			" HNumber='" + HNumber + "'" +
			",HName='" + HName + "'" +
			",HShortNumber='" + HShortNumber + "'" +
			",HHelpCode='" + HHelpCode + "'" +
			",HLevel=" + HLevel.ToString() +
			",HParentID=" + HParentID.ToString() +
			",HEndflag=" + Convert.ToString(HEndFlag ? 1 : 0) +
			",HStopflag=" + Convert.ToString(HStopflag ? 1 : 0) +
			",HEmpID=" + HEmpID.ToString() +
			",HAddress='" + HAddress + "'" +
			",HPhone='" + HPhone + "'" +
			",HUSEORGID='" + HUSEORGID + "'" +
			",HUpdater='" + HUpDater + "'" +
			",HUpdateDate= getdate()" +
			",HRemark= '" + HRemark + "' Where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo);
			//修改子项目代码
			//oCN.RunProc("exec h_p_Gy_UpdateNumber Gy_Warehouse,'" + HNumber + ".','" + this.HOldNumber + ".'", ref DBUtility.ClsPub.sExeReturnInfo);
			//将上级为非末级
			oCN.RunProc("Update Gy_Warehouse set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo);
			//
			oCN.Commit();
			}
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "保存成功！";
			//WebAPIController.Add_Log("送货单下推", UserName, "生成送货单");
			objJsonResult.data = 1;
			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("Cg_POInStockBill/DeltetPOInStockBill")]
			[HttpGet]
			public object DeltetPOInStockBill(string HInterID)
			{
			try
			{
			//先删除金蝶数据
			objJsonResult = DeleteKingDee(HInterID);
			if (objJsonResult.code == "0")
			return objJsonResult;

			oCN.BeginTran();
			oCN.RunProc("Delete From Cg_POInStockBillMain where HInterID = " + HInterID);
			oCN.RunProc("Delete From Cg_POInStockBillSub where HInterID = " + HInterID);
			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.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}

			/// <summary>
			/// 反审核
			/// </summary>
			[Route("Cg_POInStockBill/DeAuditPOInStockBill")]
			[HttpGet]
			public object DeAuditPOInStockBill(string HInterID)
			{
			try
			{
			//先删除金蝶数据
			objJsonResult = DeleteKingDee(HInterID);
			if (objJsonResult.code == "0")
			return objJsonResult;

			oCN.BeginTran();
			oCN.RunProc("update Cg_POInStockBillMain set HERPBillNO='',HERPInterID = 0 ,HBillStatus =5 where HInterID = " + HInterID);
			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.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			//审核删除删除金蝶数据库对应收料通知到数据
			public json DeleteKingDee(string hinterid)
			{
			string sql = string.Format("select HinterID,HERPBillNO,HERPInterID from Cg_POInStockBillMain where HERPInterID>0 and hinterid in (" + hinterid + ")");
			DataTable dt = oCN.RunProcReturn(sql, "deleteDt").Tables[0];
			if (dt.Rows.Count > 0)
			{
			foreach (DataRow dr in dt.Rows)
			{
			var sJson = new
			{
			Numbers = dr["HERPBillNO"].ToString(),
			Ids = ""
			};
			var loginRet = InvokeHelper.Login();
			var isSuccess = JObject.Parse(loginRet)["LoginResultType"].Value<int>();
			if (isSuccess == 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "操作失败,金蝶账号登录异常。" + loginRet;
			objJsonResult.data = null;
			return objJsonResult;
			}

			var result = InvokeHelper.Delete("PUR_ReceiveBill", JsonConvert.SerializeObject(sJson));
			//LogService.Write(result);
			if (JObject.Parse(result)["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper() != "TRUE")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "对应金蝶收料通知单删除失败！" + result;
			objJsonResult.data = null;
			return objJsonResult;
			}

			}
			}
			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "Sucess！";
			objJsonResult.data = null;
			return objJsonResult;
			}

			//
			}