MES-WEB-API.git

			@@ -52,7 +52,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "开工单无编辑权限!";
			objJsonResult.Message = "[3790-2-003]开工单无编辑权限!";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -63,7 +63,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "进站单无编辑权限!";
			objJsonResult.Message = "[3790-2-003]进站单无编辑权限!";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -81,7 +81,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "错误的流转卡内码！";
			objJsonResult.Message = "[3790-2-004]错误的流转卡内码！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -90,7 +90,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "流水号没有选择！请输入流水号后回车！";
			objJsonResult.Message = "[3790-2-002]流水号没有选择！请输入流水号后回车！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -99,7 +99,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "流水号没有选择！";
			objJsonResult.Message = "[3790-2-005]流水号没有选择！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -108,7 +108,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "流转卡号没有选择！";
			objJsonResult.Message = "[3790-2-006]流转卡号没有选择！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -155,7 +155,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "产品没有选择！";
			objJsonResult.Message = "[0000-2-007]产品没有选择！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -169,7 +169,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "生产资源没有选择！";
			objJsonResult.Message = "[0000-2-006]生产资源没有选择！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -180,7 +180,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "工作中心没有选择！";
			objJsonResult.Message = "[0000-2-010]工作中心没有选择！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -188,7 +188,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "当前工序没有选择！";
			objJsonResult.Message = "[0000-2-011]当前工序没有选择！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -196,7 +196,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "接收个数不能为0！";
			objJsonResult.Message = "[3790-2-007]接收个数不能为0！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -206,7 +206,7 @@

			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "判断首道工序失败，不允许保存！";
			objJsonResult.Message = "[3790-2-008]判断首道工序失败，不允许保存！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -218,7 +218,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "保存前判断失败！";
			objJsonResult.Message = "[0000-2-012]保存前判断失败！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -226,7 +226,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "保存失败！" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);
			objJsonResult.Message = "[0000-1-051]保存失败！" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -242,7 +242,7 @@
			oCN.RollBack();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "单据号重复！";
			objJsonResult.Message = "[0000-2-013]单据号重复！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -342,7 +342,7 @@
			oCN.RollBack();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "操作类型无效！";
			objJsonResult.Message = "[操作类型无效]操作类型无效！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -353,7 +353,7 @@
			oCN.RollBack();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "判断数量失败！";
			objJsonResult.Message = "[0000-2-015]判断数量失败！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -362,19 +362,38 @@
			oCN.RollBack();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "判断数量失败！";
			objJsonResult.Message = "[0000-2-015]判断数量失败！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			if (ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBack"]) == "2")
			if (oSystemParameter.ShowBill(ref sReturn) == true)
			{
			oCN.RollBack();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);
			objJsonResult.data = null;
			return objJsonResult;
			if (oSystemParameter.omodel.WMS_CampanyName == "杭州斯莫尔") //系统参数判断客户
			{
			if (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;
			}
			}
			else
			{
			if (ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBack"]) == "2")
			{
			oCN.RollBack();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "[0000-2-015]" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			}

			oCN.RunProc("exec h_p_Mes_ProcessExchangeRelationQty_In " + HInterID + ",1");
			//判断是否是首道工序
			ds1 = oCN.RunProcReturn(" select HLastProc,HFstProc from Sc_ProcessExchangeBillMain a " +
			@@ -389,14 +408,14 @@

			}

			//=========================保存后控制
			//=========================保存后控制 ============================
			DataSet ds2 = oCN.RunProcReturn("Exec h_p_Sc_StationInBill_AfterSaveCtrl " + HInterID.ToString() + ", '" + HBillNo + "',1 ", "h_p_Sc_StationInBill_AfterSaveCtrl");
			if (ds2 == null)
			{
			oCN.RollBack();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "保存后控制判断失败！";
			objJsonResult.Message = "[0000-2-016]保存后控制判断失败！";
			objJsonResult.data = null;
			return objJsonResult;

			@@ -406,11 +425,11 @@
			oCN.RollBack();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "保存失败2！" + DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBackRemark"]);
			objJsonResult.Message = "[0000-1-051]保存失败2！" + DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBackRemark"]);
			objJsonResult.data = null;
			return objJsonResult;
			}
			//============================
			//=======================================================

			oCN.Commit();

			@@ -447,7 +466,7 @@

			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "新增单据成功！";
			objJsonResult.Message = "[0000-1-050]新增单据成功！";
			objJsonResult.data = ds.Tables[0];
			return objJsonResult;
			}
			@@ -456,7 +475,7 @@
			oCN.RollBack();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "Exception！" + e.ToString();
			objJsonResult.Message = "[0000-1-051]Exception！" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -544,7 +563,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "条形码不能为空！";
			objJsonResult.Message = "[0000-2-019]条形码不能为空！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -557,13 +576,13 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "工序号错误或者当前工序号不允许进站，请重新输入！";
			objJsonResult.Message = "[3790-2-013]工序号错误或者当前工序号不允许进站，请重新输入！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "Sucess！";
			objJsonResult.Message = "[0000-1-037]Sucess！";
			objJsonResult.data = ds.Tables[0];
			return objJsonResult;
			}
			@@ -571,7 +590,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "Exception！" + e.ToString();
			objJsonResult.Message = "[0000-1-038]Exception！" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -593,30 +612,30 @@
			oCN.RunProc("exec h_p_MES_StationInBillSubBindSource_Insert " + HProcExchInterID.ToString() + " , " + HProcExchEntryID.ToString() + "," + HInterID.ToString() + " ");

			ds = oCN.RunProcReturn($@"select * from
			(
			select
			a.HICMOInterID,a.HICMOEntryID,b.HProcID
			from Sc_ProcessExchangeBillMain a with(nolock)
			inner join Sc_ProcessExchangeBillSub b with(nolock) on a.HInterID=b.HinterID
			Where a.HInterID={HProcExchInterID} and b.HEntryID={HProcExchEntryID}
			) a
			inner join (
			select a.HICMOInterID,a.HICMOEntryID,isnull(c.HItemID,0) HProcID
			from Sc_PPBomBillMain a with(nolock)
			inner join Sc_PPBomBillSub b with(nolock) on a.HInterID=b.HInterID
			left join Gy_Process c on b.HProcName = c.HName
			)b on a.HICMOInterID=b.HICMOInterID and a.HICMOEntryID=b.HICMOEntryID and a.HProcID=b.HProcID", "Sc_ProcessExchangeBillMain");
			(
			select
			a.HICMOInterID,a.HICMOEntryID,b.HProcID
			from Sc_ProcessExchangeBillMain a with(nolock)
			inner join Sc_ProcessExchangeBillSub b with(nolock) on a.HInterID=b.HinterID
			Where a.HInterID={HProcExchInterID} and b.HEntryID={HProcExchEntryID}
			) a
			inner join (
			select a.HICMOInterID,a.HICMOEntryID,isnull(c.HItemID,0) HProcID
			from Sc_PPBomBillMain a with(nolock)
			inner join Sc_PPBomBillSub b with(nolock) on a.HInterID=b.HInterID
			left join Gy_Process c on b.HProcName = c.HName
			)b on a.HICMOInterID=b.HICMOInterID and a.HICMOEntryID=b.HICMOEntryID and a.HProcID=b.HProcID", "Sc_ProcessExchangeBillMain");

			if (ds.Tables[0].Rows.Count > 0) {
			objJsonResult.Message = "需要绑定配件！";
			objJsonResult.Message = "[0000-2-026]需要绑定配件！";
			}
			else
			{
			objJsonResult.Message = "不需要绑定配件！";
			objJsonResult.Message = "[0000-2-027]不需要绑定配件！";
			}
			}
			else {
			objJsonResult.Message = "不需要绑定配件！";
			objJsonResult.Message = "[0000-2-027]不需要绑定配件！";
			}

			objJsonResult.code = "1";
			@@ -628,7 +647,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "Exception！" + e.ToString();
			objJsonResult.Message = "[0000-1-038]Exception！" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -694,13 +713,13 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "未查询到职员信息！";
			objJsonResult.Message = "[0000-2-028]未查询到职员信息！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "Sucess！";
			objJsonResult.Message = "[0000-1-037]Sucess！";
			objJsonResult.data = ds.Tables[0];
			return objJsonResult;
			}
			@@ -708,7 +727,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "Exception！" + e.ToString();
			objJsonResult.Message = "[0000-1-038]Exception！" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -777,7 +796,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "进站单无查询权限!";
			objJsonResult.Message = "进站单无查询权限!";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -848,7 +867,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "开工单无查询权限!";
			objJsonResult.Message = "[3790-1-004]开工单无查询权限!";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -860,7 +879,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "进站单无查询权限!";
			objJsonResult.Message = "[3790-1-004]进站单无查询权限!";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -887,7 +906,7 @@

			objJsonResult.code = "1";
			objJsonResult.count = int.Parse(ds.Tables[1].Rows[0]["count"].ToString());
			objJsonResult.Message = "Sucess！";
			objJsonResult.Message = "[0000-1-037]Sucess！";
			objJsonResult.list = columnNameList;
			objJsonResult.data = ds.Tables[0];
			return objJsonResult;
			@@ -896,7 +915,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "查询数据异常，请与管理员联系！" + e.ToString();
			objJsonResult.Message = "[0000-1-010]查询数据异常，请与管理员联系！" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -908,14 +927,15 @@
			[HttpGet]
			public object set_ShowBillJudge(string HBillNo)
			{
			string sReturn = "";
			try
			{
			{
			ds = oCN.RunProcReturn("exec h_p_MES_StationInBill_DelCtrl '" + HBillNo + "'", "h_p_MES_StationInBill_DelCtrl");
			if (ds == null \|\| ds.Tables[0].Rows.Count == 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "判断关联失败！";
			objJsonResult.Message = "[0000-2-018]判断关联失败！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -931,18 +951,41 @@
			{
			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "Sucess！";
			objJsonResult.Message = "[0000-1-037]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;
			if (oSystemParameter.ShowBill(ref sReturn) == true)
			{
			if (oSystemParameter.omodel.WMS_CampanyName == "杭州斯莫尔") //系统参数判断客户
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			else
			{

			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "[0000-1-038]Exception！" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			else
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "[0000-1-038]Exception！" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			}
			#endregion
			@@ -990,8 +1033,6 @@
			{
			try
			{
			string ModRightNameCheck = "";

			if (HBillSubType == "SUB")
			{
			//审核权限
			@@ -999,7 +1040,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "开工单审核失败！无权限！";
			objJsonResult.Message = "[3790-1-006]开工单审核失败！无权限！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -1010,7 +1051,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "进站单审核失败！无权限！";
			objJsonResult.Message = "[3790-1-006]进站单审核失败！无权限！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -1020,7 +1061,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "单据ID为0，不能审核！";
			objJsonResult.Message = "[0000-1-009]单据ID为0，不能审核！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -1032,7 +1073,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "单据已审核!不能再次审核";
			objJsonResult.Message = "[0000-1-023]单据已审核!不能再次审核";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -1041,12 +1082,12 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "单据不存在!原因:" + DBUtility.ClsPub.sExeReturnInfo;
			objJsonResult.Message = "[0000-1-045]单据不存在!原因:" + DBUtility.ClsPub.sExeReturnInfo;
			objJsonResult.data = null;
			return objJsonResult;
			}

			//审核前控制
			//审核前控制==========================================================================
			string HBillNo = oBill.omodel.HBillNo;
			string sql = "exec h_p_Sc_StationInBill_BeforeCheckCtrl " + HInterID + ",'" + HBillNo + "','" + CurUserName + "'";
			ds = oCN.RunProcReturn(sql, "h_p_Sc_StationInBill_BeforeCheckCtrl");
			@@ -1054,7 +1095,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "审核失败!原因:审核前判断失败，请与网络管理人员联系";
			objJsonResult.Message = "[0000-1-024]审核失败!原因:审核前判断失败，请与网络管理人员联系";
			objJsonResult.data = null;
			return objJsonResult;

			@@ -1063,17 +1104,17 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "审核失败!原因:" + ds.Tables[0].Rows[0]["HRemark"].ToString(); ;
			objJsonResult.Message = "[0000-1-025]审核失败!原因:" + ds.Tables[0].Rows[0]["HRemark"].ToString(); ;
			objJsonResult.data = null;
			return objJsonResult;
			}

			//=============================================================================
			//审核
			if (Cj_StationInBillCheckBill(HInterID, HBillNo, CurUserName, ref DBUtility.ClsPub.sExeReturnInfo))
			{
			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "审核成功!";
			objJsonResult.Message = "[0000-1-029]审核成功!";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -1081,7 +1122,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "审核失败!原因:" + DBUtility.ClsPub.sExeReturnInfo;
			objJsonResult.Message = "[0000-1-025]审核失败!原因:" + DBUtility.ClsPub.sExeReturnInfo;
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -1091,7 +1132,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "审核失败！" + e.ToString();
			objJsonResult.Message = "[0000-1-025]审核失败！" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -1127,7 +1168,7 @@
			{
			}

			//审核后控制
			//审核后控制=======================================================
			string sql = "exec h_p_Sc_StationInBill_AfterCheckCtrl " + lngBillKey + ",'" + HBillNo + "','" + CurUserName + "'";
			ds = oCN.RunProcReturn(sql, "h_p_Sc_StationInBill_AfterCheckCtrl");
			if (ds == null \|\| ds.Tables.Count == 0 \|\| ds.Tables[0].Rows.Count == 0)
			@@ -1142,7 +1183,7 @@
			oCN.RollBack();
			return false;
			}

			//====================================================================
			sReturn = sReturn + " 审核功能！";
			oCN.Commit();
			return true;
			@@ -1170,7 +1211,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "开工单反审核失败！无权限！";
			objJsonResult.Message = "[3790-1-007]开工单反审核失败！无权限！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -1182,7 +1223,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "进站单反审核失败！无权限！";
			objJsonResult.Message = "[3790-1-007]进站单反审核失败！无权限！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -1194,7 +1235,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "单据ID为0，不能反审核！";
			objJsonResult.Message = "[0000-1-009]单据ID为0，不能反审核！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -1206,7 +1247,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "单据未审核!不需要反审核!";
			objJsonResult.Message = "[0000-1-018]单据未审核!不需要反审核!";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -1215,12 +1256,12 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "单据不存在!原因:" + DBUtility.ClsPub.sExeReturnInfo;
			objJsonResult.Message = "[0000-1-005]单据不存在!原因:" + DBUtility.ClsPub.sExeReturnInfo;
			objJsonResult.data = null;
			return objJsonResult;
			}

			//反审核前控制
			//反审核前控制=============================================================================
			string HBillNo = oBill.omodel.HBillNo;
			string sql = "exec h_p_Sc_StationInBill_BeforeUnCheckCtrl " + HInterID + ",'" + HBillNo + "','" + CurUserName + "'";
			ds = oCN.RunProcReturn(sql, "h_p_Sc_StationInBill_BeforeUnCheckCtrl");
			@@ -1228,7 +1269,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "反审核失败!原因:反审核前判断失败，请与网络管理人员联系";
			objJsonResult.Message = "[0000-1-027]反审核失败!原因:反审核前判断失败，请与网络管理人员联系";
			objJsonResult.data = null;
			return objJsonResult;

			@@ -1237,17 +1278,17 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "反审核失败!原因:" + ds.Tables[0].Rows[0]["HRemark"].ToString(); ;
			objJsonResult.Message = "[0000-1-027]反审核失败!原因:" + ds.Tables[0].Rows[0]["HRemark"].ToString(); ;
			objJsonResult.data = null;
			return objJsonResult;
			}

			//============================================================================================
			//反审核
			if (Cj_StationInBillAbandonCheckBill(HInterID, HBillNo, CurUserName, ref DBUtility.ClsPub.sExeReturnInfo))
			{
			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "反审核成功!";
			objJsonResult.Message = "[0000-1-019]反审核成功!";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -1255,7 +1296,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "反审核失败!原因:" + DBUtility.ClsPub.sExeReturnInfo;
			objJsonResult.Message = "[0000-1-028]反审核失败!原因:" + DBUtility.ClsPub.sExeReturnInfo;
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -1264,7 +1305,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "反审核失败！" + e.ToString();
			objJsonResult.Message = "[0000-1-028]反审核失败！" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -1305,7 +1346,7 @@
			{
			}

			//反审核后控制
			//反审核后控制========================================================================
			string sql = "exec h_p_Sc_StationInBill_AfterUnCheckCtrl " + lngBillKey + ",'" + HBillNo + "','" + CurUserName + "'";
			ds = oCN.RunProcReturn(sql, "h_p_Sc_StationInBill_AfterUnCheckCtrl");
			if (ds == null \|\| ds.Tables.Count == 0 \|\| ds.Tables[0].Rows.Count == 0)
			@@ -1320,7 +1361,7 @@
			oCN.RollBack();
			return false;
			}

			//============================================================================================
			sReturn = sReturn + "反审核功能！";
			oCN.Commit();
			return true;
			@@ -1371,7 +1412,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "开工单无权限关闭!";
			objJsonResult.Message = "[3790-1-008]开工单无权限关闭!";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -1382,7 +1423,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "进站单无权限关闭!";
			objJsonResult.Message = "[3790-1-008]进站单无权限关闭!";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -1393,7 +1434,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "HInterID为空！";
			objJsonResult.Message = "[0000-1-009]HInterID为空！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -1415,17 +1456,41 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "单据已关闭!不需要再关闭!";
			objJsonResult.Message = "[0000-1-033]单据已关闭!不需要再关闭!";
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			//关闭单据
			if (!BillOld.CloseBill(Int64.Parse(HInterID), ref ClsPub.sExeReturnInfo))
			var HBillNo = ds.Tables[0].Rows[0]["HBillNo"].ToString();

			//关闭前控制=========================================
			string sql1 = "exec h_p_Sc_ShiftsBeginInfoBill_BeforeCloseCtrl " + HInterID + ",'" +HBillNo + "','" + user + "'";
			ds = oCN.RunProcReturn(sql1, "h_p_Sc_ShiftsBeginInfoBill_BeforeCloseCtrl");
			if (ds == null \|\| ds.Tables.Count == 0 \|\| ds.Tables[0].Rows.Count == 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "关闭失败!原因:" + ClsPub.sExeReturnInfo;
			objJsonResult.Message = "关闭失败!原因:关闭前判断失败，请与网络管理人员联系";
			objJsonResult.data = null;
			return objJsonResult;
			}

			if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "关闭失败!原因:" + ds.Tables[0].Rows[0]["HRemark"].ToString(); ;
			objJsonResult.data = null;
			return objJsonResult;
			}
			//==================================================================================

			//关闭单据
			if (!BillOld.CloseBill(Int64.Parse(HInterID), HBillNo, "h_p_Sc_ShiftsBeginInfoBill_AfterCloseCtrl", user,ref ClsPub.sExeReturnInfo))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "[0000-1-034]关闭失败!原因:" + ClsPub.sExeReturnInfo;
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -1442,17 +1507,41 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "单据已反关闭!不需要再反关闭!";
			objJsonResult.Message = "[0000-1-035]单据已反关闭!不需要再反关闭!";
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			//反关闭单据
			if (!BillOld.CancelClose(Int64.Parse(HInterID), ref ClsPub.sExeReturnInfo))
			var HBillNo = ds.Tables[0].Rows[0]["HBillNo"].ToString();
			//反关闭前控制=========================================
			string sql1 = "exec h_p_Sc_StationInBill_BeforeUnCloseCtrl " + HInterID + ",'" + HBillNo + "','" + user + "'";
			ds = oCN.RunProcReturn(sql1, "h_p_Sc_StationInBill_BeforeUnCloseCtrl");
			if (ds == null \|\| ds.Tables.Count == 0 \|\| ds.Tables[0].Rows.Count == 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "反关闭失败!原因:" + ClsPub.sExeReturnInfo;
			objJsonResult.Message = "反关闭失败!原因:反关闭前判断失败，请与网络管理人员联系";
			objJsonResult.data = null;
			return objJsonResult;
			}

			if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "反关闭失败!原因:" + ds.Tables[0].Rows[0]["HRemark"].ToString(); ;
			objJsonResult.data = null;
			return objJsonResult;
			}
			//==================================================================================


			//反关闭单据
			if (!BillOld.CancelClose(Int64.Parse(HInterID), HBillNo, "h_p_Sc_StationInBill_AfterUnCloseCtrl", user, ref ClsPub.sExeReturnInfo))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "[0000-1-036]反关闭失败!原因:" + ClsPub.sExeReturnInfo;
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -1462,7 +1551,7 @@

			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "执行成功！";
			objJsonResult.Message = "[0000-1-037]执行成功！";
			objJsonResult.data = null;
			return objJsonResult; ;

			@@ -1471,7 +1560,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "执行失败！" + e.ToString();
			objJsonResult.Message = "[0000-1-037]执行失败！" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -1539,7 +1628,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "开工单无权限！";
			objJsonResult.Message = "[3790-1-005]开工单无权限！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -1550,7 +1639,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "进站接收单无权限！";
			objJsonResult.Message = "[3790-1-005]进站接收单无权限！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -1568,7 +1657,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "只能删除本人的单据！";
			objJsonResult.Message = "[0000-1-011]只能删除本人的单据！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -1941,7 +2030,7 @@
			File.Delete(fileurl); //删除指定文件
			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "删除成功！";
			objJsonResult.Message = "[0000-1-008]删除成功！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -1949,7 +2038,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "Exception！" + e.ToString();
			objJsonResult.Message = "[0000-1-007]Exception！" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}