MES-WEB-API.git

			@@ -1601,6 +1601,18 @@
			objJsonResult.data = null;
			return objJsonResult;
			}
			DataSet dss;
			//判断工艺路线是否被引用
			dss = oCN.RunProcReturn("select COUNT(*) as number from Sc_ProcessExchangeBillMain where HRoutingBillID = " + lngBillKey, "Gy_RoutingBillMain");
			//判断是否可编辑
			if (dss.Tables[0].Rows[0]["number"].ToString() != "0")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "此单据已经被引用，不允许删除！";
			objJsonResult.data = 1;
			return objJsonResult;
			}
			//if (hdeleteman != "")
			//{
			// objJsonResult.code = "0";
			@@ -3370,6 +3382,152 @@

			}

			#region 工艺路线列表启用默认_权限判断
			[Route("Gy_RoutingBill/set_defaultRoute_CheckRight")]
			[HttpGet]
			public object set_defaultRoute_CheckRight(string user, string HBillSubType)
			{
			try
			{
			if (HBillSubType == "SUB")
			{
			//判断是否有删除权限
			if (!DBUtility.ClsPub.Security_Log("Gy_RoutingBill_Sub_SetDefaultRoute", 1, false, user))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "子工艺路线无权限启用默认工艺路线!";
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			else
			{
			//判断是否有删除权限
			if (!DBUtility.ClsPub.Security_Log("Gy_RoutingBill_SetDefaultRoute", 1, false, user))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "工艺路线无权限启用默认!";
			objJsonResult.data = null;
			return objJsonResult;
			}
			}


			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "执行成功！";
			objJsonResult.data = null;
			return objJsonResult; ;

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

			#region 工艺路线列表启用默认
			[Route("Gy_RoutingBill/set_defaultRoute")]
			[HttpGet]
			public object set_defaultRoute(string HInterID, string user, string HBillSubType)
			{
			try
			{
			if (HBillSubType == "SUB")
			{
			//判断是否有删除权限
			if (!DBUtility.ClsPub.Security_Log("Gy_RoutingBill_Sub_SetDefaultRoute", 1, false, user))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "子工艺路线无权限启用默认工艺路线!";
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			else
			{
			//判断是否有删除权限
			if (!DBUtility.ClsPub.Security_Log("Gy_RoutingBill_SetDefaultRoute", 1, false, user))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "工艺路线无权限启用默认!";
			objJsonResult.data = null;
			return objJsonResult;
			}
			}


			if (string.IsNullOrWhiteSpace(HInterID))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "HInterID为空！";
			objJsonResult.data = null;
			return objJsonResult;
			}

			ClsPub.CurUserName = user;
			BillOld.MvarItemKey = "Gy_RoutingBillMain";
			oCN.BeginTran();//开始事务

			//判断单据是否已经审核
			DataSet ds;
			string sql = "select * from " + BillOld.MvarItemKey + " where HinterID = " + HInterID;
			ds = oCN.RunProcReturn(sql, BillOld.MvarItemKey);
			if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
			{
			if (!(ds.Tables[0].Rows[0]["HChecker"] != null && ds.Tables[0].Rows[0]["HChecker"].ToString() != ""))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "单据未审核!不可以被启用为该物料的默认工艺路线!";
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			else
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "单据不存在，检查该单据是否已经被删除!";
			objJsonResult.data = null;
			return objJsonResult;
			}

			//刷新默认工艺路线
			oCN.RunProc("exec h_p_Gy_RoutingBillCheck " + HInterID+",'" + user + "'");

			oCN.Commit();//提交事务

			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "执行成功！";
			objJsonResult.data = null;
			return objJsonResult; ;

			}
			catch (Exception e)
			{
			oCN.RollBack();

			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "执行失败！" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			#endregion

			#region 工艺路线审核/反审核功能
			[Route("Gy_RoutingBill/CheckGy_RoutingBill")]
			[HttpGet]
			@@ -3434,20 +3592,45 @@
			return objJsonResult;
			}
			}
			//审核单据
			if (!BillOld.CheckBill(Int64.Parse(HInterID), ref ClsPub.sExeReturnInfo))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "审核失败!原因:" + ClsPub.sExeReturnInfo;
			objJsonResult.data = null;
			return objJsonResult;
			}

			//审核工艺路线
			oCN.RunProc(" Update Gy_RoutingBillMain set HChecker='" + user + "',HCheckDate=getdate(),HBillStatus=2 Where HInterID=" + HInterID.ToString());

			////刷新默认工艺路线
			//oCN.RunProc("exec h_p_Gy_RoutingBillCheck " + HInterID);

			////审核单据
			//if (!BillOld.CheckBill(Int64.Parse(HInterID), ref ClsPub.sExeReturnInfo))
			//{
			// objJsonResult.code = "0";
			// objJsonResult.count = 1;
			// objJsonResult.Message = "审核失败!原因:" + ClsPub.sExeReturnInfo;
			// objJsonResult.data = null;
			// return objJsonResult;
			//}
			}
			else
			{
			//反审核前控制=========================================
			DataSet ds = oCN.RunProcReturn("Exec h_p_Gy_Routing_BeforeUnCheckCtrl " + HInterID + ",'" + 0 + "','" + user + "'", "h_p_Gy_Routing_BeforeUnCheckCtrl");
			if (ds == null)
			{
			objJsonResult.code = CodeConstant.FAIL;
			objJsonResult.count = CountConstant.FAIL;
			objJsonResult.Message = "反审核失败!原因:" + "反审核前判断失败！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			if (DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBack"]) != "0")
			{
			objJsonResult.code = CodeConstant.FAIL;
			objJsonResult.count = CountConstant.FAIL;
			objJsonResult.Message = "反审核失败!原因:" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);
			objJsonResult.data = null;
			return objJsonResult;
			}
			//=========================================================
			//判断单据是否已经反审核
			DataSet ds;
			string sql = "select * from " + BillOld.MvarItemKey + " where HinterID = " + HInterID;
			ds = oCN.RunProcReturn(sql, BillOld.MvarItemKey);
			if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
			@@ -3496,6 +3679,8 @@
			}
			catch (Exception e)
			{
			oCN.RollBack();

			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "执行失败！" + e.ToString();