~yxj/MES-WEB-API.git

			@@ -68,6 +68,395 @@
			}
			}

			/// <summary>
			/// 委外工序发出单流水号回车获取流转卡信息（委外工序接收、工序进站接收通用）
			///参数：string sql。
			///返回值：object。
			/// </summary>
			[Route("Cj_StationEntrustInBill/txtHBarCode_KeyDown")]
			[HttpGet]
			public object txtHBarCode_KeyDown(string HBarCode)
			{
			try
			{
			if (HBarCode == null \|\| HBarCode.Equals(""))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "条形码不能为空！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			//拆分条形码
			string sBillBarCode = HBarCode.Trim();
			string[] NewBarCode;
			if (sBillBarCode.CompareTo("#") > 0)
			{
			NewBarCode = sBillBarCode.Split(Convert.ToChar("#"));
			sBillBarCode = NewBarCode[0];
			}
			string sBillNo = sBillBarCode;
			//得到信息
			ds = oCN.RunProcReturn("select top 1 * from h_v_Sc_ProcessExchangeBillList where 单据号= '" + sBillNo + "'", "h_v_Sc_ProcessExchangeBillList");
			//写入信息
			if (ds == null \|\| ds.Tables[0].Rows.Count == 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "未查询到流转卡信息！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			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>
			/// 新增单据-保存按钮
			///参数：string sql。
			///返回值：object。
			/// </summary>
			[Route("Cj_StationEntrustInBill/AddBill")]
			[HttpPost]
			public object AddBill([FromBody] JObject oMain)
			{
			var _value = oMain["oMain"].ToString();
			string msg1 = _value.ToString();
			try
			{
			//委外工序发出反序列化
			msg1 = "[" + msg1.ToString() + "]";
			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();
			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();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "判断数量失败！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			if (ds.Tables[0].Rows.Count == 0)
			{
			oCN.RollBack();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "判断数量失败！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			if (DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBack"]) == "2")
			{
			oCN.RollBack();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);
			objJsonResult.data = null;
			return objJsonResult;
			}
			oCN.RunProc("exec h_p_Mes_ProcessExchangeRelationQty_In " + HInterID.ToString() + ",1");
			oCN.RunProc("exec h_p_WW_EntrustWorkOrderRelationQty_In " + HInterID.ToString() + ",1");
			oCN.Commit();
			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "新增单据成功！";
			objJsonResult.data = ds.Tables[0];
			return objJsonResult;
			}
			catch (Exception e)
			{
			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();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}


			/// <summary>
			/// 委外工序发出单流水号回车获取工序信息
			///参数：string sql。
			///返回值：object。
			/// </summary>
			[Route("Cj_StationEntrustInBill/txtHProcNo_KeyDown")]
			[HttpGet]
			public object txtHProcNo_KeyDown(string sBillNo, string sProcNo)
			{
			try
			{
			if (sBillNo.Equals("") \|\| sProcNo.Equals(""))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "条形码不能为空！";
			objJsonResult.data = null;
			return objJsonResult;
			}

			//得到信息（委外标记为0时，流转标记为1时）
			ds = oCN.RunProcReturn("select top 1 * from h_v_Sc_ProcessExchangeBillList where 单据号= '" + sBillNo + "' and 下道流转工序<>'转' and 委外标记=1 and 流转标记=1 and 工序号='" + sProcNo + "'", "h_v_Sc_ProcessExchangeBillList");
			//Ds = oCn.RunProcReturn("select top 1 * from h_v_Sc_ProcessExchangeBillList where 单据号= '" + sBillNo + "' and 工序号='" + sProcNo + "' and 委外标记=0 and 流转标记=1 ", "h_v_Sc_ProcessExchangeBillList");
			//写入信息
			if (ds == null \|\| ds.Tables[0].Rows.Count == 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "工序号错误或者当前工序号不允许进站，请重新输入！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			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;
			}
			}




			//