~yxj/MES-WEB-API.git

			@@ -69,7 +69,7 @@
			}

			/// <summary>
			/// 委外工序发出单流水号回车获取流转卡信息
			/// 委外工序发出单流水号回车获取流转卡信息（委外工序接收、工序进站接收通用）
			///参数：string sql。
			///返回值：object。
			/// </summary>
			@@ -138,70 +138,180 @@
			{
			//委外工序发出反序列化
			msg1 = "[" + msg1.ToString() + "]";
			List<StationEntrustInBill> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<StationEntrustInBill>>(msg1);

			var HInterID = list[0].HInterID;//递入type得到的单据ID
			var HYear = 2021;
			var HPeriod = list[0].HPeriod;//单价
			var HBillNo = list[0].HBillNo;//递入type得到的单据号
			var HBillStatus = 0;
			var HInnerBillNo = list[0].HInnerBillNo;//送货单号
			var HICMOBillNo = list[0].HICMOBillNo;//生产订单号
			long HICMOInterID = DBUtility.ClsPub.isLong(list[0].HICMOInterID);//生产订单号ID
			var HProcExchInterID = 0;
			var HProcExchEntryID = 0;
			var HProcExchBillNo = list[0].HProcExchBillNo;//流转卡
			var HProcID = list[0].HProcID;//当前工序
			var HMaterID = list[0].HMaterID;//产品ID
			var HStationInTime = list[0].HStationInTime;//
			var HEmpID = list[0].HEmpID;//操作员ID
			var HSourceID = list[0].HSourceID;//生产资源ID
			var HGroupID = list[0].HGroupID;//班组ID
			var HICMOQty = list[0].HICMOQty;//任务单数量
			var HPlanQty = list[0].HPlanQty;//流转卡数量
			var HQty = list[0].HQty;//发出数量
			var HSupID = list[0].HSupID;//供应商ID
			var HPieceQty = list[0].HPieceQty;//发出件数
			var HSourceName = list[0].HSourceName;//
			var HPrice = list[0].HPrice;//单价
			var HMoney = list[0].HMoney;//金额
			var HRemark = list[0].HRemark;//备注
			var HTaxRate = list[0].HTaxRate;//税率
			var HProcNo = list[0].HProcNo;//流水号
			var HOrderProcNO = list[0].HOrderProcNO;//订单跟踪号
			var HWWWorkOrderInterID = 0;//委外工单号子内码
			var HWWWorkOrderEntryID = 0;//委外工单号主内吗
			var HWWWorkOrderBillNo = list[0].HWWWorkOrderBillNo;//委外工单号
			var HMaker = list[0].HMaker;//制单人
			var HProcPlanInterID = 0;
			var HProcPlanEntryID = 0;
			var HProcPlanBillNo = "";
			var HDeptID = list[0].HDeptID;//部门ID
			var HBarCode = list[0].HBarCode;//条形码
			var HAddr = "";
			var HBarCodeMaker = "";

			List<StationBill> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<StationBill>>(msg1);
			string eventType = list[0].eventType;
			long HInterID = list[0].HInterID;//递入type得到的单据ID
			int HYear = 2021;
			double HPeriod = list[0].HPeriod;//单价
			string HBillNo = list[0].HBillNo;//递入type得到的单据号
			int HBillStatus = 0;
			string HInnerBillNo = list[0].HInnerBillNo;//送货单号
			string HICMOBillNo = list[0].HICMOBillNo;//生产订单号
			long HICMOInterID = list[0].HICMOInterID;//生产订单号ID
			long HProcExchInterID = list[0].lngBillKey;
			long HProcExchEntryID = list[0].lngBillSubKey;
			string HProcExchBillNo = list[0].HProcExchBillNo;//流转卡
			long HProcID = list[0].HProcID;//当前工序
			long HMaterID = list[0].HMaterID;//产品ID
			DateTime HStationInTime = list[0].HStationInTime;//
			long HEmpID = list[0].HEmpID;//操作员ID
			long HSourceID = list[0].HSourceID;//生产资源ID
			long HGroupID = list[0].HGroupID;//班组ID
			double HICMOQty = list[0].HICMOQty;//任务单数量
			double HPlanQty = list[0].HPlanQty;//流转卡数量
			double HQty = list[0].HQty;//发出数量
			long HSupID = list[0].HSupID;//供应商ID
			double HPieceQty = list[0].HPieceQty;//发出件数
			string HSourceName = list[0].HSourceName;//
			double HPrice = list[0].HPrice;//单价
			double HMoney = list[0].HMoney;//金额
			string HRemark = list[0].HRemark;//备注
			double HTaxRate = list[0].HTaxRate;//税率
			long HProcNo = list[0].HProcNo;//流水号
			string HOrderProcNO = list[0].HOrderProcNO;//订单跟踪号
			int HWWWorkOrderInterID = 0;//委外工单号子内码
			int HWWWorkOrderEntryID = 0;//委外工单号主内吗
			string HWWWorkOrderBillNo = list[0].HWWWorkOrderBillNo;//委外工单号
			string HMaker = list[0].HMaker;//制单人
			int HProcPlanInterID = 0;
			int HProcPlanEntryID = 0;
			string HProcPlanBillNo = "";
			long HDeptID = list[0].HDeptID;//部门ID
			string HBarCode = list[0].HBarCode;//条形码
			string HAddr = "";
			string HBarCodeMaker = "";
			if (HProcExchInterID <= 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "流转卡没有选择！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			if (HProcExchEntryID <= 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "流水号2没有选择！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			if (HProcNo <= 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "流水号没有选择！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			if (HProcExchBillNo == "")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "流转卡号没有选择！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			if (HMaterID <= 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "产品没有选择！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			if (HSupID <= 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "供应商没有选择！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			if (HProcID <= 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "当前工序没有选择！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			if (HQty <= 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "发出数量不能为0！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			//若MAINDI重复则重新获取
			oCN.BeginTran();
			//主表
			oCN.RunProc("Insert Into Sc_StationInBillMain " +
			"(HBillType,HBillSubType,HInterID,HBillNo,HBillStatus,HDate,HMaker,HMakeDate" +
			",HYear,HPeriod,HRemark,HInnerBillNo" +
			",HICMOInterID,HICMOBillNo,HProcPlanInterID,HProcPlanEntryID,HProcPlanBillNo,HProcExchInterID,HProcExchEntryID" +
			",HProcExchBillNo,HMaterID,HProcID,HICMOQty,HPlanQty,HStationInTime,HSourceID" +
			",HGroupID,HDeptID,HEmpID,HBarCode,HAddr,HBarCodeMaker,HBarCodeMakeDate" +
			",HSupID,HTaxRate,HQty,HPrice,HMoney,HPieceQty" +
			",HProcNo,HOrderProcNO,HWWWorkOrderBillNo,HWWWorkOrderInterID,HWWWorkOrderEntryID" +
			") " +
			" values('3792','3792'," + HInterID.ToString() + ",'" + HBillNo + "'," + HBillStatus.ToString() + ",getdate(),'" + HMaker + "',getdate()" +
			"," + HYear.ToString() + "," + HPeriod.ToString() + ",'" + HRemark + "','" + HInnerBillNo + "'" +
			"," + HICMOInterID.ToString() + ",'" + HICMOBillNo + "'," + HProcPlanInterID.ToString() + "," + HProcPlanEntryID.ToString() + ",'" + HProcPlanBillNo + "'," + HProcExchInterID.ToString() + "," + HProcExchEntryID.ToString() +
			",'" + HProcExchBillNo + "'," + HMaterID.ToString() + "," + HProcID.ToString() + "," + HICMOQty.ToString() + "," + HPlanQty.ToString() + ",getdate()," + HSourceID.ToString() +
			"," + HGroupID.ToString() + "," + HDeptID.ToString() + "," + HEmpID.ToString() + ",'" + HBarCode + "','" + HAddr + "','" + HBarCodeMaker + "',getdate()" +
			"," + HSupID.ToString() + "," + HTaxRate.ToString() + "," + HQty.ToString() + "," + HPrice.ToString() + "," + HMoney.ToString() + "," + HPieceQty.ToString() +
			"," + HProcNo.ToString() + ",'" + HOrderProcNO.ToString() + "'" + ",'" + HWWWorkOrderBillNo.ToString() + "'" + "," + HWWWorkOrderInterID.ToString() + "" + "," + HWWWorkOrderEntryID.ToString() + "" +
			") ");
			ds = oCN.RunProcReturn("exec h_p_MES_StationInBill_QtyCtrl " + HInterID.ToString() + "", "h_p_MES_StationInBill_QtyCtrl");
			if ("Add".Equals(eventType))
			{
			if (!AllowbillNo(HBillNo))
			{
			oCN.RollBack();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "单据号重复！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			//主表
			oCN.RunProc("Insert Into Sc_StationInBillMain " +
			"(HBillType,HBillSubType,HInterID,HBillNo,HBillStatus,HDate,HMaker,HMakeDate" +
			",HYear,HPeriod,HRemark,HInnerBillNo" +
			",HICMOInterID,HICMOBillNo,HProcPlanInterID,HProcPlanEntryID,HProcPlanBillNo,HProcExchInterID,HProcExchEntryID" +
			",HProcExchBillNo,HMaterID,HProcID,HICMOQty,HPlanQty,HStationInTime,HSourceID" +
			",HGroupID,HDeptID,HEmpID,HBarCode,HAddr,HBarCodeMaker,HBarCodeMakeDate" +
			",HSupID,HTaxRate,HQty,HPrice,HMoney,HPieceQty" +
			",HProcNo,HOrderProcNO,HWWWorkOrderBillNo,HWWWorkOrderInterID,HWWWorkOrderEntryID" +
			") " +
			" values('3792','3792'," + HInterID.ToString() + ",'" + HBillNo + "','" + HBillStatus.ToString() + "',getdate(),'" + HMaker + "',getdate()" +
			",'" + HYear.ToString() + "','" + HPeriod.ToString() + "','" + HRemark + "','" + HInnerBillNo + "'" +
			"," + HICMOInterID + ",'" + HICMOBillNo + "'," + HProcPlanInterID + "," + HProcPlanEntryID + ",'" + HProcPlanBillNo + "'," + HProcExchInterID + "," + HProcExchEntryID +
			",'" + HProcExchBillNo + "'," + HMaterID + "," + HProcID + "," + HICMOQty + "," + HPlanQty + ",getdate()," + HSourceID +
			"," + HGroupID + "," + HDeptID + "," + HEmpID + ",'" + HBarCode + "','" + HAddr + "','" + HBarCodeMaker + "',getdate()" +
			"," + HSupID + "," + HTaxRate + "," + HQty + "," + HPrice + "," + HMoney + "," + HPieceQty +
			",'" + HProcNo + "','" + HOrderProcNO + "'" + ",'" + HWWWorkOrderBillNo + "'" + "," + HWWWorkOrderInterID + "" + "," + HWWWorkOrderEntryID + "" +
			") ");
			}
			else if ("Modify".Equals(eventType))
			{

			//删除关联
			oCN.RunProc("exec h_p_Mes_ProcessExchangeRelationQty_In " + HInterID + ",-1");
			oCN.RunProc("exec h_p_WW_EntrustWorkOrderRelationQty_In " + HInterID + ",-1");

			//更新主表
			oCN.RunProc("UpDate Sc_StationInBillMain set " +
			"HBillNo='" + HBillNo + "'" +
			",HRemark='" + HRemark + "'" +
			",HUpDater='" + DBUtility.ClsPub.CurUserName + "'" +
			",HUpDateDate=getdate()" +
			",HInnerBillNo='" + HInnerBillNo + "'" +
			",HSupID=" + HSupID +
			",HQty=" + HQty +
			",HPieceQty=" + HPieceQty +
			",HPrice=" + HPrice +
			",HMoney=" + HMoney +
			",HTaxRate=" + HTaxRate +
			",HMaterID=" + HMaterID +
			",HProcID=" + HProcID +
			",HProcNo=" + HProcNo +
			",HOrderProcNO='" + HOrderProcNO + "'" +
			" where HInterID=" + HInterID);
			}
			else
			{
			oCN.RollBack();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "操作类型无效！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			ds = oCN.RunProcReturn("exec h_p_MES_StationInBill_QtyCtrl " + HInterID + "", "h_p_MES_StationInBill_QtyCtrl");
			if (ds == null)
			{
			oCN.RollBack();
			@@ -240,7 +350,55 @@
			}
			catch (Exception e)
			{
			oCN.RollBack();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "Exception！" + e.Message;
			objJsonResult.data = null;
			return objJsonResult;
			}
			}

			private bool AllowbillNo(string HBillNo)
			{
			ds = oCN.RunProcReturn("select HBillNo from Sc_StationInBillMain where HBillNo = '" + HBillNo + "'", "Sc_StationInBillMain");
			if (ds == null \|\| ds.Tables[0].Rows.Count == 0)
			{
			return true;
			}
			return false;
			}

			/// <summary>
			/// 编辑页面根据id获取委外工序接收单信息
			///参数：string sql。
			///返回值：object。
			/// </summary>
			[Route("Cj_StationEntrustInBill/GetStationEntrustInBill")]
			[HttpGet]
			public object GetStationEntrustInBill(int HInterID)
			{
			try
			{
			ds = oCN.RunProcReturn("select * from h_v_GetStationInBill where HInterID = " + HInterID, "h_v_GetStationOutBill");
			if (ds == null \|\| ds.Tables[0].Rows.Count == 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "委外工序接收单信息获取失败！";
			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();
			@@ -248,5 +406,10 @@
			return objJsonResult;
			}
			}




			//
			}
			}