MES-WEB-API.git

			@@ -451,6 +451,7 @@
			",HSourceID5=" + HSourceID5 +
			",HPayProcID=" + HPayProcID +
			",HGroupID=" + HGroupID +
			",HShiftsID=" + HShiftsID +
			",HWorkTimes=" + HWorkTimes +
			",HSaveBillFlag=0 " +
			",HBadCount=" + HBadCount +
			@@ -468,10 +469,9 @@
			",HWasterQty_Work=" + HWasterQty_Work +
			",HWasterQty_Mater=" + HWasterQty_Mater +
			",HBackWorkQty=" + HBackWorkQty +
			",HShiftsID=" + HShiftsID +
			",HBackWorkByMaterQty=" + HBackWorkByMaterQty +
			",HMouldID=" + HMouldID +
			",HMachineWorkTimes=" + HMachineWorkTimes +
			",HMachineWorkTimes=" + HMachineWorkTimes +
			" where HInterID=" + HInterID);

			LogService.Write("用户:" + user + ",日期:" + DateTime.Now + ",修改工序出站单据:" + HBillNo);
			@@ -3976,5 +3976,95 @@
			}
			}
			#endregion

			#region 编辑页面根据id获取工序出站汇报单信息
			[Route("Cj_StationOutBill/SetBillTime")]
			[HttpGet]
			public object SetBillTime(int HInterID,DateTime dateTime,string user)
			{
			try
			{
			//判断是否有编辑权限
			if (!DBUtility.ClsPub.Security_Log("Cj_StationOutBill_Edit", 1, false, user))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "出站单无编辑权限!";
			objJsonResult.data = null;
			return objJsonResult;
			}
			string sql = "select * from Sc_StationOutBillMain with(nolock) where HInterID=" + HInterID;
			ds = oCN.RunProcReturn(sql, "Sc_StationOutBillMain");
			if (ds == null \|\| ds.Tables[0].Rows.Count == 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "修改失败没找到相关出站汇报单";
			objJsonResult.data = null;
			return objJsonResult;
			}
			//修改前时间修改后时间判断有无工资计算
			string HGroupID = ds.Tables[0].Rows[0]["HGroupID"].ToString();
			string HOldDate = ds.Tables[0].Rows[0]["HDate"].ToString();
			string sql1 = "select * from Pay_SingleBalBillMain where HGroupID =" +HGroupID + " and HDate ='" + HOldDate + "'";
			string sql2 = "select * from Pay_GroupBalBillMain where HGroupID =" + HGroupID + " and HDate ='" + HOldDate + "'";
			string sql3 = "select * from Pay_SingleBalBillMain where HGroupID =" + HGroupID + " and HDate ='" + dateTime + "'";
			string sql4 = "select * from Pay_GroupBalBillMain where HGroupID =" + HGroupID + " and HDate ='" + dateTime + "'";
			ds = oCN.RunProcReturn(sql1, "Sc_StationOutBillMain");
			if (ds.Tables[0].Rows.Count > 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "修改失败该时间班组已计算工资:" + HOldDate;
			objJsonResult.data = null;
			return objJsonResult;
			}
			ds = oCN.RunProcReturn(sql2, "Sc_StationOutBillMain");
			if (ds.Tables[0].Rows.Count > 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "修改失败该时间班组已计算工资:" + HOldDate;
			objJsonResult.data = null;
			return objJsonResult;
			}
			ds = oCN.RunProcReturn(sql3, "Sc_StationOutBillMain");
			if (ds.Tables[0].Rows.Count > 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "修改失败该时间班组已计算工资:" + dateTime;
			objJsonResult.data = null;
			return objJsonResult;
			}
			ds = oCN.RunProcReturn(sql4, "Sc_StationOutBillMain");
			if (ds.Tables[0].Rows.Count > 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "修改失败该时间班组已计算工资:" + dateTime;
			objJsonResult.data = null;
			return objJsonResult;
			}
			//修改时间
			sql = "update Sc_StationOutBillMain set HDate = '" + dateTime + "' where HInterID = " + HInterID;
			oCN.RunProcReturn(sql, "Sc_StationOutBillMain");
			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "Sucess！";
			objJsonResult.data = null;
			return objJsonResult;

			}
			catch (Exception e)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "Exception！" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			#endregion
			}
			}