MES-WEB-API.git

			@@ -1,5 +1,6 @@
			ï»¿using DBUtility;
			using Model;
			using Newtonsoft.Json;
			using Newtonsoft.Json.Linq;
			using System;
			using System.Collections.Generic;
			@@ -10,7 +11,7 @@
			using WebAPI.Models;


			namespace WebAPI.Controllers.ä»åç®¡ç.é¢æåè´§
			namespace WebAPI.Controllers
			{
			public class Kf_MateOutRequestBillController : ApiController
			{
			@@ -18,6 +19,7 @@
			private json objJsonResult = new json();
			public DataSet ds = new DataSet();
			public SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
			Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter();

			public string HManagerID { get; private set; }

			@@ -28,6 +30,7 @@
			{
			try
			{
			List<object> columnNameList = new List<object>(); //å®ä¹å£°æåé ï¼æéè¿ new List<object>()åå»ºç å®ä¾ï¼èµå¼ç»åé
			////å¤ææ¯å¦ææ¥è¯¢æé
			//if (!DBUtility.ClsPub.Security_Log("Kf_MoveMateRequestBill_Query", 1, false, user))
			//{
			@@ -48,11 +51,18 @@
			string sql = sql1 + sWhere + " order by hmainid desc";
			ds = oCn.RunProcReturn(sql, "h_v_IF_MateOutRequestBillList");
			}
			foreach (DataColumn col in ds.Tables[0].Columns)//éådsä¸ç¬¬ä¸ä¸ªè¡¨ï¼Tables[0]ï¼çææåï¼Columnsï¼æ¯æ¬¡å¾ªç¯ä¸ï¼colåéä¼ææå½ååçå¼ç¨
			{
			Type dataType = col.DataType; //è·åå½åæ°æ®ç±»åä¼ å¥ èªå®ä¹åédatadataType
			string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; //åç¬¦ä¸²æ¼æ¥ // å°åååæ°æ®ç±»åä¿¡æ¯æ¼æ¥æä¸ä¸ªJSONæ ¼å¼çåç¬¦ä¸²
			columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//è·åå°DataColumnåå¯¹è±¡çåå
			}

			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "Sucessï¼";
			objJsonResult.data = ds.Tables[0];
			objJsonResult.data = ds.Tables[0];//ä»£ç å°ç¬¬ä¸ä¸ªDataTableï¼ç´¢å¼ä¸º0ï¼èµå¼ç»objJsonResultçdataå±æ§
			objJsonResult.list = columnNameList;//å°columnNameListèµå¼ç»objJsonResultçlistå±æ§
			return objJsonResult;
			}
			catch (Exception ex)
			@@ -148,6 +158,16 @@
			string HCloseDate = mainList[0].HCloseDate;
			string HICCard = mainList[0].HICCard;
			string HSUPPLYType = mainList[0].HSUPPLYType;//åææ¹å¼

			//è¿è¡ ä¼è®¡æé´ ç»è´¦ çå¤æåæ§å¶
			string s = "";
			int sYear = 0;
			int sPeriod = 0;
			if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(HDate, ref sYear, ref sPeriod, ref s) == false)
			{
			objJsonResult.Message = s;
			return objJsonResult;
			}

			ds = oCn.RunProcReturn("select * from h_v_IF_MateOutRequestBillList where hmainid=" + HInterID + " and åæ®å·='" + HBillNo + "'", "h_v_IF_MateOutRequestBillList");

			@@ -248,8 +268,13 @@
			}

			string sql = $@"Insert into Kf_MateOutRequestBillSub
			(HInterID,HEntryID,HDate,HRemark,HMTONo,HMaterID,HUnitID,HBatchNO,HWHID,HSPID,HQtyMust,HQty,HRelationQty,HRelationMoney,HPrice,HMoney,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HICMOInterID,HICMOEntryID,HICMOBillNo,HPOOrderInterID,HPOOrderEntryID,HPOOrderBillNo)
			values({HInterID},{NewHEntryID},getdate(),'{oSub.HRemark}','{oSub.HMTONo}',{oSub.HMaterID},{oSub.HUnitID},'{oSub.HBatchNO}',{oSub.HWHID},{oSub.HSPID},{oSub.HQtyMust},{(oSub.HQty == null ? 0 : oSub.HQty)},{oSub.HRelationQty},{oSub.HRelationMoney},{oSub.HPrice},{oSub.HMoney},{oSub.HSourceInterID},{oSub.HSourceEntryID},'{oSub.HSourceBillNo}','{oSub.HSourceBillType}',{oSub.HICMOInterID},{oSub.HICMOEntryID},'{oSub.HICMOBillNo}',{oSub.HPOOrderInterID},{oSub.HPOOrderEntryID},'{oSub.HPOOrderBillNo}')";
			(HInterID,HEntryID,HDate,HRemark,HMTONo,HMaterID,HUnitID,HBatchNO,HWHID,HSPID,HQtyMust,HQty,HRelationQty,
			HRelationMoney,HPrice,HMoney,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HICMOInterID,HICMOEntryID,
			HICMOBillNo,HPOOrderInterID,HPOOrderEntryID,HPOOrderBillNo)
			values({HInterID},{NewHEntryID},getdate(),'{oSub.HRemark}','{oSub.HMTONo}',{oSub.HMaterID},{oSub.HUnitID},
			'{oSub.HBatchNO}',{oSub.HWHID},{oSub.HSPID},{oSub.HQtyMust},{(oSub.HQty == null ? 0 : oSub.HQty)},{oSub.HRelationQty},{oSub.HRelationMoney},
			{oSub.HPrice},{oSub.HMoney},{oSub.HSourceInterID},{oSub.HSourceEntryID},'{oSub.HSourceBillNo}','{oSub.HSourceBillType}',{oSub.HICMOInterID},
			{oSub.HICMOEntryID},'{oSub.HICMOBillNo}',{oSub.HPOOrderInterID},{oSub.HPOOrderEntryID},'{oSub.HPOOrderBillNo}')";

			oCn.RunProc(sql);
			}
			@@ -273,6 +298,17 @@
			{
			try
			{
			//è¿è¡ ä¼è®¡æé´ ç»è´¦ çå¤æåæ§å¶
			string s = "";
			int sYear = 0;
			int sPeriod = 0;
			DateTime HDate = DateTime.Now;
			if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(HDate, ref sYear, ref sPeriod, ref s) == false)
			{
			objJsonResult.Message = s;
			return objJsonResult;
			}

			oCn.BeginTran();
			oCn.RunProc("Delete From Kf_MateOutRequestBillMain where HInterID = " + HInterID);
			oCn.RunProc("Delete From Kf_MateOutRequestBillSub where HInterID = " + HInterID);
			@@ -294,5 +330,258 @@
			}
			}


			#region æ ¹æ®åæ®å·ï¼åæ¥çäº§åæéç¥å(é¢ç¨ç³è¯·å)
			[Route("Kf_MateOutRequestBillController/GetKf_MateOutRequestBill_Sync_Json")]
			[HttpGet]
			public json GetKf_MateOutRequestBill_Sync_Json(string HBillNo, string HBillType)
			{
			try
			{
			//è·åç³»ç»åæ°
			string sql = string.Empty;
			string sErrMsg = "";
			if (oSystemParameter.ShowBill(ref sErrMsg) == true)
			{
			//ç³»ç»åæ°æ¯å¦ä¸ºç§æäºæ¨¡å¼,Nä¸ºå¬æäºæ¨¡å¼ï¼Yä¸ºç§æäºæ¨¡å¼
			//ç§æäºæ¨¡å¼ï¼éè¿è°ç¨åå¨è¿ç¨è¿è¡åæ¥
			if (oSystemParameter.omodel.WMS_CloudMode.ToUpper() == "Y")
			{
			ds = oCn.RunProcReturn("exec h_p_IFCLD_ERPSourceBillToLocal_MateOutRequest '" + HBillNo + "'", "h_p_IFCLD_ERPSourceBillToLocal_MateOutRequest");
			if (ds == null \|\| ds.Tables[0].Rows.Count == 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "åæ®åæ¥åçéè¯¯ï¼";
			objJsonResult.data = null;
			return objJsonResult;
			}
			else
			{
			if (DBUtility.ClsPub.isLong(ds.Tables[0].Rows[0]["HBack"]) == 2)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);
			objJsonResult.data = null;
			return objJsonResult;
			}
			else
			{
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "åæ®åæ¥æåï¼";
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			}
			//å¬æäºæ¨¡å¼ï¼éè¿è°ç¨WEBAPIæ¹å¼è¿è¡åæ¥
			else if (oSystemParameter.omodel.WMS_CloudMode.ToUpper() == "N")
			{
			//å¤æéè¶äºæ¯å¦ç»å½æå
			var loginRet = InvokeHelper.Login();
			var isSuccess = JObject.Parse(loginRet)["LoginResultType"].Value<int>();
			//å¤ææ¯å¦ç»å½æå
			if (isSuccess <= 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "åæ¥å¤±è´¥ï¼éè¶äºç»å¥ä¸æåï¼è¯·ç¡®è®¤Cçéç½®æä»¶æè®¾ç½®éè¶äºå¯¹åºç½åãè´¦å¥ãç»å½ç¨æ·ãç»å½å¯ç æ¯å¦æ£ç¡®ï¼";
			objJsonResult.data = null;
			return objJsonResult;
			}

			var json = new
			{
			CreateOrgId = 0,
			Number = HBillNo,
			Id = ""
			};
			//æ¥ç è·åæ°æ®
			var _result = InvokeHelper.View("PRD_ISSUEMTRNOTICE", JsonConvert.SerializeObject(json));
			var _saveObj = JObject.Parse(_result);
			//å¤æéè¶äºæ°æ®æ¯å¦è·åæå
			if (_saveObj["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper() != "TRUE")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "éè¶äºçäº§åæéç¥åè·åå¤±è´¥ï¼" + _result;
			objJsonResult.data = null;
			return objJsonResult;
			}

			oCn.BeginTran();
			//æ ¹æ®åæ®å·å é¤æ¬å°çäº§åæéç¥åä¸å¯¹åºåæ®
			oCn.RunProc("Delete b from Kf_MateOutRequestBillMain a inner join Kf_MateOutRequestBillSub b on a.HInterID=b.HInterID where a.HBillNo = '" + HBillNo + "'", ref DBUtility.ClsPub.sExeReturnInfo);
			oCn.RunProc("Delete from Kf_MateOutRequestBillMain where HBillNo = '" + HBillNo + "'", ref DBUtility.ClsPub.sExeReturnInfo);

			//ä¸»è¡¨æ°æ®èµå¼
			var MainData = new
			{
			HInterID = DBUtility.ClsPub.isLong(_saveObj["Result"]["Result"]["Id"]),
			HBillNo = DBUtility.ClsPub.isStrNull(_saveObj["Result"]["Result"]["BillNo"]),
			HBillType = "1214",
			HBillSubType = "1214",
			HDate = DBUtility.ClsPub.isDate(_saveObj["Result"]["Result"]["Date"]),
			HBillStatus = DBUtility.ClsPub.isLong(_saveObj["Result"]["Result"]["ApproverId_Id"]) == 0 ? 1 : 2,
			HInnerBillNo = DBUtility.ClsPub.isStrNull(_saveObj["Result"]["Result"]["BillNo"]),
			HRemark = "CLDå¯¼å¥",
			HEmpID = 0,
			HManagerID = 0,
			HSecManagerID = 0,
			HKeeperID = 0,
			HDeptID = DBUtility.ClsPub.isLong(_saveObj["Result"]["Result"]["WorkShopId_Id"]),
			HExplanation = "",
			HICCard = "",
			HSUPPLYType = DBUtility.ClsPub.isStrNull(_saveObj["Result"]["Result"]["IssueType"]),
			HPRDORGID = DBUtility.ClsPub.isLong(_saveObj["Result"]["Result"]["PrdOrgId_Id"]),
			HMaker = DBUtility.ClsPub.isStrNull(_saveObj["Result"]["Result"]["CreatorId"]["Name"]),
			HMakeDate = DBUtility.ClsPub.isDate(_saveObj["Result"]["Result"]["CreateDate"]),
			HChecker = DBUtility.ClsPub.isLong(_saveObj["Result"]["Result"]["ApproverId_Id"]) == 0 ? "" : DBUtility.ClsPub.isStrNull(_saveObj["Result"]["Result"]["ApproverId"]["Name"]),
			HCheckDate = DBUtility.ClsPub.isDate(_saveObj["Result"]["Result"]["ApproveDate"]),
			HUpDater = DBUtility.ClsPub.isLong(_saveObj["Result"]["Result"]["ModifierId_Id"]) == 0 ? "" : DBUtility.ClsPub.isStrNull(_saveObj["Result"]["Result"]["ModifierId"]["Name"]),
			HUpDateDate = DBUtility.ClsPub.isDate(_saveObj["Result"]["Result"]["ModifyDate"]),
			HDeleteMan = DBUtility.ClsPub.isLong(_saveObj["Result"]["Result"]["CANCELER_Id"]) == 0 ? "" : DBUtility.ClsPub.isStrNull(_saveObj["Result"]["Result"]["CANCELER"]["Name"]),
			HDeleteDate = DBUtility.ClsPub.isDate(_saveObj["Result"]["Result"]["CancelDate"]),
			};
			//åå¥ä¸»è¡¨
			sql = $@"Insert into Kf_MateOutRequestBillMain
			(HInterID,HYear,HPeriod,HBillType,HBillSubType,HDate
			,HBillNo,HBillStatus,HInnerBillNo,HRemark
			,HEmpID,HManagerID,HSecManagerID,HKeeperID,HDeptID
			,HExplanation,HICCard,HSUPPLYType,HPRDORGID
			,HMaker,HMakeDate
			,HChecker,HCheckDate
			,HUpDater,HUpDateDate
			,HDeleteMan,HDeleteDate)
			Values({MainData.HInterID},year('{MainData.HDate}'),month('{MainData.HDate}'),'{MainData.HBillType}','{MainData.HBillSubType}','{MainData.HDate}'
			,'{MainData.HBillNo}',{MainData.HBillStatus},'{MainData.HInnerBillNo}','{MainData.HRemark}'
			, {MainData.HEmpID},{MainData.HManagerID},{MainData.HSecManagerID},{MainData.HKeeperID},{MainData.HDeptID}
			,'{MainData.HExplanation}','{MainData.HICCard}','{MainData.HSUPPLYType}',{MainData.HPRDORGID}
			,'{MainData.HMaker}','{MainData.HMakeDate}'
			,'{MainData.HChecker}',case when '{MainData.HCheckDate}' = '1900/1/1 0:00:00' then NULL else '{MainData.HCheckDate}' end
			,'{MainData.HUpDater}',case when '{MainData.HUpDateDate}' = '1900/1/1 0:00:00' then NULL else '{MainData.HUpDateDate}' end
			,'{MainData.HDeleteMan}',case when '{MainData.HDeleteDate}' = '1900/1/1 0:00:00' then NULL else '{MainData.HDeleteDate}' end)";
			oCn.RunProc(sql.Replace("\r\n", ""));

			//åè¡¨æ°æ®èµå¼
			var dataArr = _saveObj["Result"]["Result"]["DetailEntity"];
			foreach (var oSub in dataArr)
			{
			var subData = new
			{
			HInterID = DBUtility.ClsPub.isLong(_saveObj["Result"]["Result"]["Id"]),
			HEntryID = DBUtility.ClsPub.isLong(oSub["Id"]),
			HERPInterID = DBUtility.ClsPub.isLong(_saveObj["Result"]["Result"]["Id"]),
			HERPEntryID = DBUtility.ClsPub.isLong(oSub["Id"]),
			HSEQ = DBUtility.ClsPub.isLong(oSub["Seq"]),
			HRemark = "",
			HMaterID = DBUtility.ClsPub.isLong(oSub["MATERIALID_Id"]),
			HProdMaterID = DBUtility.ClsPub.isLong(oSub["PMATERIALID_Id"]),
			HUnitID = DBUtility.ClsPub.isLong(oSub["UnitID_Id"]),
			HAuxPropID = DBUtility.ClsPub.isLong(oSub["AuxPropID_Id"]),
			HBatchNO = DBUtility.ClsPub.isStrNull(oSub["Lot_Text"]),
			HWHID = DBUtility.ClsPub.isLong(oSub["StockID_Id"]),
			HSPID = DBUtility.ClsPub.isLong(oSub["StockLOCID_Id"]),
			HPrice = 0,
			HMoney = 0,
			HMTONo = DBUtility.ClsPub.isStrNull(oSub["CHILDMTONO"]),
			HPlanMode = 0,
			HStockStatusID = DBUtility.ClsPub.isLong(oSub["StockStatusId_Id"]),
			HQty = DBUtility.ClsPub.isDoule(oSub["AppQty"]),
			HQtyMust = DBUtility.ClsPub.isDoule(oSub["MustQty"]),
			HRelationQty = DBUtility.ClsPub.isDoule(oSub["ActPickedQty"]),
			HMoveStockQty = 0,
			HRelationMoney = 0,
			HSourceInterID = 0,
			HSourceEntryID = 0,
			HSourceBillNo = DBUtility.ClsPub.isStrNull(oSub["MOBILLNO"]),
			HSourceBillType = "3710",
			HPPBOMInterID = DBUtility.ClsPub.isLong(oSub["PPBomId"]),
			HPPBOMEntryID = DBUtility.ClsPub.isLong(oSub["PPBomEntryId"]),
			HPPBOMEntrySEQ = 0,
			HPPBOMBillNo = "",
			HICMOInterID = 0,
			HICMOEntryID = 0,
			HICMOEntrySEQ = DBUtility.ClsPub.isLong(oSub["MOBILLSEQ"]),
			HICMOBillNo = DBUtility.ClsPub.isStrNull(oSub["MOBILLNO"]),
			HPOOrderInterID = 0,
			HPOOrderEntryID = 0,
			HPOOrderBillNo = "",
			HOWNERID = DBUtility.ClsPub.isLong(oSub["OwnerID_Id"]),
			HOWNERTYPEID = DBUtility.ClsPub.isStrNull(oSub["OwnerTypeId"]),
			HKEEPERID = DBUtility.ClsPub.isLong(oSub["KeeperId_Id"]),
			HKEEPERTYPEID = DBUtility.ClsPub.isStrNull(oSub["KeeperTypeId"]),
			HSUPPLYORGID = DBUtility.ClsPub.isLong(oSub["SupplyOrgId_Id"]),
			HBOMID = DBUtility.ClsPub.isLong(oSub["FChildBomID_Id"]),
			HProcessID = DBUtility.ClsPub.isLong(oSub["ProcessID_Id"]),
			HBaseUnitID = DBUtility.ClsPub.isLong(oSub["BaseUnitID_Id"]),
			HOperID = DBUtility.ClsPub.isLong(oSub["OperID"]),
			HOptQueue = DBUtility.ClsPub.isStrNull(oSub["OptQueue"]),
			HGroupRowId = DBUtility.ClsPub.isStrNull(oSub["GroupRowId"]),
			};

			//åå¥åè¡¨
			sql = $@"Insert into Kf_MateOutRequestBillSub
			(HInterID,HEntryID,HERPInterID,HERPEntryID,HSEQ,HRemark
			,HMaterID,HProdMaterID,HUnitID,HAuxPropID,HBatchNO,HWHID,HSPID
			,HPrice,HMoney,HMTONo,HPlanMode,HStockStatusID,HDate
			,HQty,HQtyMust,HRelationQty,HMoveStockQty,HRelationMoney
			,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType
			,HPPBOMInterID,HPPBOMEntryID,HPPBOMEntrySEQ,HPPBOMBillNo
			,HICMOInterID,HICMOEntryID,HICMOEntrySEQ,HICMOBillNo
			,HPOOrderInterID,HPOOrderEntryID,HPOOrderBillNo
			,HOWNERID,HOWNERTYPEID,HKEEPERID,HKEEPERTYPEID,HSUPPLYORGID
			,HBOMID,HProcessID,HBaseUnitID,HOperID,HOptQueue,HGroupRowId)
			Values ({subData.HInterID},{subData.HEntryID},{subData.HERPInterID},{subData.HERPEntryID},{subData.HSEQ},'{subData.HRemark}'
			,{subData.HMaterID},{subData.HProdMaterID},{subData.HUnitID},{subData.HAuxPropID},'{subData.HBatchNO}',{subData.HWHID},{subData.HSPID}
			,{subData.HPrice},{subData.HMoney},'{subData.HMTONo}',{subData.HPlanMode},{subData.HStockStatusID},getdate()
			,{subData.HQty},{subData.HQtyMust},{subData.HRelationQty},{subData.HMoveStockQty},{subData.HRelationMoney}
			,{subData.HSourceInterID},{subData.HSourceEntryID},'{subData.HSourceBillNo}','{subData.HSourceBillType}'
			,{subData.HPPBOMInterID},{subData.HPPBOMEntryID},{subData.HPPBOMEntrySEQ},'{subData.HPPBOMBillNo}'
			,{subData.HICMOInterID},{subData.HICMOEntryID},{subData.HICMOEntrySEQ},'{subData.HICMOBillNo}'
			,{subData.HPOOrderInterID},{subData.HPOOrderEntryID},'{subData.HPOOrderBillNo}'
			,{subData.HOWNERID},'{subData.HOWNERTYPEID}',{subData.HKEEPERID},'{subData.HKEEPERTYPEID}',{subData.HSUPPLYORGID}
			,{ subData.HBOMID},{subData.HProcessID},{ subData.HBaseUnitID},{subData.HOperID},'{ subData.HOptQueue}','{ subData.HGroupRowId}')";
			oCn.RunProc(sql.Replace("\r\n", ""));
			}

			oCn.Commit();
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "åæ®åæ¥æåï¼";
			objJsonResult.data = null;
			return objJsonResult;
			}
			else
			{
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "ä¸æ¯æåæ¥åè½ï¼";
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			else
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "è·åç³»ç»åæ°å¤±è´¥ï¼ " + sErrMsg;
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			catch (Exception e)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "åæ®åæ¥å¤±è´¥ï¼" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			#endregion

			}
			}