MES-WEB-API.git

			@@ -23,6 +23,7 @@
			public DBUtility.ClsPub.Enum_BillStatus BillStatus;
			Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter();
			public DAL.ClsSc_ICMOBill BillOld = new DAL.ClsSc_ICMOBill();
			public WebS.WebService1 oWebs = new WebS.WebService1();
			private json objJsonResult = new json();
			SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
			DataSet ds;
			@@ -52,7 +53,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "完工单无编辑权限!";
			objJsonResult.Message = "[0000-1-065]完工单无编辑权限!";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -63,7 +64,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "出站单无编辑权限!";
			objJsonResult.Message = "[0000-1-065]出站单无编辑权限!";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -89,11 +90,12 @@
			double HPeriod = DateTime.Now.Month;
			string HRemark = list[0].HRemark;//备注
			string HSourceName = list[0].HSourceName;//生产资源名称
			double HPieceQty = list[0].HPieceQty;//进站PCS数
			double HPieceQty = list[0].HPieceQty;//进站PCS数件数
			double HWasterQty = list[0].HWasterQty;//报废数量
			double HPlanPieceQty = list[0].HPlanPieceQty;//进站PNL数
			double HBadPNL = list[0].HBadPNL;//报废PNL数
			long HICMOInterID = list[0].HICMOInterID;//任务单ID
			long HICMOEntryID = list[0].HICMOEntryID;//任务单ID
			string HICMOBillNo = list[0].HICMOBillNo;//任务单
			int HProcPlanInterID = 0;
			int HProcPlanEntryID = 0;
			@@ -153,6 +155,10 @@
			double HBackWorkByMaterQty = list[0].HBackWorkByMaterQty;//遗失数量
			int HMouldID = list[0].HMouldID;//模具id
			double HMachineWorkTimes = list[0].HMachineWorkTimes;//设备工时
			int HIsTimeFlag = list[0].HIsTimeFlag;//是否计时
			string HRelBeginTime = list[0].HRelBeginTime;//开工时间
			string HRelEndTime = list[0].HRelEndTime;//完工时间
			double HWeight = list[0].HWeight;//重量
			LogService.Write($"1.字段赋值，用时" + sw.Elapsed );

			//单据完整性判断
			@@ -160,7 +166,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "流转卡没有选择！请扫描条形码或输入条形码后回车";
			objJsonResult.Message = "[3791-2-005]流转卡没有选择！请扫描条形码或输入条形码后回车";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -168,7 +174,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "流水号没有选择！请输入流水号后回车";
			objJsonResult.Message = "[0000-2-032]流水号没有选择！请输入流水号后回车";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -176,7 +182,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "流水号没有选择！";
			objJsonResult.Message = "[0000-2-032]流水号没有选择！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -184,7 +190,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "流转卡号没有选择！";
			objJsonResult.Message = "[0000-2-032]流转卡号没有选择！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -192,7 +198,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "产品没有选择！";
			objJsonResult.Message = "[0000-2-007]产品没有选择！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -209,7 +215,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "当前工序没有选择！";
			objJsonResult.Message = "[0000-2-011]当前工序没有选择！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -233,13 +239,13 @@
			}

			//判断客户不为龙山汽配
			if (oSystemParameter.omodel.WMS_CampanyName != "龙山汽配" && oSystemParameter.omodel.WMS_CampanyName != "瑞与祺" && oSystemParameter.omodel.WMS_CampanyName != "添康科技") //系统参数
			if (oSystemParameter.omodel.WMS_CampanyName != "龙山汽配" && oSystemParameter.omodel.WMS_CampanyName != "瑞与祺" && oSystemParameter.omodel.WMS_CampanyName != "添康科技" && oSystemParameter.omodel.WMS_CampanyName != "海诚") //系统参数
			{
			if (HSourceID == 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "生产资源没有选择！";
			objJsonResult.Message = "[0000-2-006]生产资源没有选择！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -255,7 +261,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "操作员没有选择！";
			objJsonResult.Message = "[0000-2-030]操作员没有选择！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -268,7 +274,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "操作员没有选择！";
			objJsonResult.Message = "[0000-2-030]操作员没有选择！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -280,7 +286,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "合格数量加报废数量加不良数量不能为0！";
			objJsonResult.Message = "[3791-2-006]合格数量加报废数量加不良数量不能为0！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -288,12 +294,12 @@
			//判断当前工单是否开工
			else if (oSystemParameter.omodel.MES_StationOutBill_MustBeginWorkCtl == "Y")
			{
			ds = oCN.RunProcReturn("select * from Sc_ICMOBillStatus_Tmp where HSourceID = '" + HSourceID + "' and HICMOBillNo = '" + HICMOBillNo + "' and HInterID = '" + HICMOInterID + "' and hicmostatus =1", "Sc_ICMOBillStatus_Tmp");
			ds = oCN.RunProcReturn("select * from Sc_ICMOBillStatus_Tmp with(nolock) where HSourceID = '" + HSourceID + "' and HICMOBillNo = '" + HICMOBillNo + "' and HInterID = '" + HICMOInterID + "' and hicmostatus =1", "Sc_ICMOBillStatus_Tmp");
			if (ds.Tables[0].Rows[0]["HICMOStatus"].ToString() != "1")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "当前工单不是开工状态不能汇报！";
			objJsonResult.Message = "[3791-2-007]当前工单不是开工状态不能汇报！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -303,7 +309,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "合格数量加报废数量不能为0！";
			objJsonResult.Message = "[3791-2-008]合格数量加报废数量不能为0！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -373,7 +379,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "保存前判断失败！";
			objJsonResult.Message = "[0000-2-012]保存前判断失败！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -381,7 +387,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;
			}
			@@ -398,7 +404,7 @@
			oCN.RollBack();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "单据号重复！";
			objJsonResult.Message = "[0000-2-013]单据号重复！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -406,25 +412,25 @@
			oCN.RunProc("Insert Into Sc_StationOutBillMain " +
			"(HBillType,HBillSubType,HInterID,HBillNo,HBillStatus,HDate,HMaker,HMakeDate,HMouldNum" +
			",HYear,HPeriod,HRemark,HSourceName,HPieceQty,HWasterQty,HPlanPieceQty,HBadPNL" +
			",HICMOInterID,HICMOBillNo,HProcPlanInterID,HProcPlanEntryID,HProcPlanBillNo,HProcExchInterID,HProcExchEntryID" +
			",HICMOInterID,HICMOEntryID,HICMOBillNo,HProcPlanInterID,HProcPlanEntryID,HProcPlanBillNo,HProcExchInterID,HProcExchEntryID" +
			",HProcExchBillNo,HMaterID,HProcID,HICMOQty,HPlanQty,HStationOutTime,HSourceID,HPayProcID" +
			",HGroupID,HDeptID,HEmpID,HBarCode,HAddr,HBarCodeMaker,HBarCodeMakeDate,HSourceID2,HSourceID3,HSourceID4,HSourceID5" +
			",HSupID,HQty,HPrice,HMoney,HBadCount,HCenterID,HProcNo,HOrderProcNO,HSourceNameList" +
			",HMainSourceInterID,HMainSourceBillNo,HMainSourceBillType,HLastSubProc" +
			",HEmpID2,HEmpID3,HEmpID4,HEmpID5,HDSQty,HChongQty,HPriceRate,HWorkTimes,HQCCheckID,HMainInterID,HPRDOrgID" +
			",HmaterOutqty,HProcPriceRate,HTemporaryAreaID,HWasterQty_Work,HWasterQty_Mater,HBackWorkQty,HShiftsID" +
			",HToCheckQty,HLossQty,HBackWorkByMaterQty,HMouldID,HMachineWorkTimes " +
			",HToCheckQty,HLossQty,HBackWorkByMaterQty,HMouldID,HMachineWorkTimes,HIsTimeFlag,HRelBeginTime,HRelEndTime,HWeight " +
			") " +
			" values('" + BillType + "','" + (OperationType == "5" ? "SUB" : HBillSubType) + "'," + HInterID + ",'" + HBillNo + "'," + HBillStatus + ",'"+ HDate + "','" + HMaker + "',getdate(),'" + HMouldNum + "'" +
			"," + HYear + "," + HPeriod + ",'" + HRemark + "','" + HSourceName + "'," + HPieceQty + "," + HWasterQty + "," + HPlanPieceQty + "," + HBadPNL +
			"," + HICMOInterID + ",'" + HICMOBillNo + "'," + HProcPlanInterID + "," + HProcPlanEntryID + ",'" + HProcPlanBillNo + "'," + HProcExchInterID + "," + HProcExchEntryID +
			"," + HICMOInterID + "," + HICMOEntryID + ",'" + HICMOBillNo + "'," + HProcPlanInterID + "," + HProcPlanEntryID + ",'" + HProcPlanBillNo + "'," + HProcExchInterID + "," + HProcExchEntryID +
			",'" + HProcExchBillNo + "'," + HMaterID + "," + HProcID + "," + HICMOQty + "," + HPlanQty + ",getdate()," + HSourceID + "," + HPayProcID +
			"," + HGroupID + "," + HDeptID + "," + HEmpID + ",'" + HBarCode + "','" + HAddr + "','" + HBarCodeMaker + "',getdate()" + "," + HSourceID2 + "," + HSourceID3 + "," + HSourceID4 + "," + HSourceID5 +
			"," + HSupID + "," + HQty + "," + HPrice + "," + HMoney + "," + HBadCount + "," + HCenterID + "," + HProcNo + ",'" + HOrderProcNO + "'" + ",'" + HSourceNameList + "'" +
			"," + HMainSourceInterID + ",'" + HMainSourceBillNo + "','" + HMainSourceBillType + "'," + Convert.ToString(HLastSubProc ? 1 : 0) +
			"," + HEmpID2 + "," + HEmpID3 + "," + HEmpID4 + "," + HEmpID5 + "," + HDSQty + "," + HChongQty + "," + HPriceRate + "," + HWorkTimes + "," + HQCCheckID + "," + HMainInterID + "," + HPRDOrgID +
			"," + HmaterOutqty + "," + HProcPriceRate + "," + HTemporaryAreaID + "," + HWasterQty_Work + "," + HWasterQty_Mater + "," + HBackWorkQty +
			"," + HShiftsID + "," + HToCheckQty + "," + HLossQty + ","+ HBackWorkByMaterQty + "," + HMouldID + ",'" + HMachineWorkTimes + "') ");
			"," + HShiftsID + "," + HToCheckQty + "," + HLossQty + ","+ HBackWorkByMaterQty + "," + HMouldID + ",'" + HMachineWorkTimes + "',"+ HIsTimeFlag + ",'" + HRelBeginTime + "','" + HRelEndTime + "','" + HWeight + "') ");

			LogService.Write($"4.新增结束，用时" + sw.Elapsed);
			LogService.Write("用户:" + user + ",日期:" + DateTime.Now + ",新增工序出站单据:" + HBillNo);
			@@ -433,7 +439,7 @@
			else if ("Modify".Equals(eventType))
			{
			num = 2;
			oCN.RunProc("UpDate Sc_StationOutBillMain set " +
			oCN.RunProc("UpDate a set " +
			"HUpDater='" + HMaker + "'" +
			",HUpDateDate=getdate()" +
			",HSourceName='" + HSourceName + "'" +
			@@ -471,7 +477,9 @@
			",HBackWorkQty=" + HBackWorkQty +
			",HBackWorkByMaterQty=" + HBackWorkByMaterQty +
			",HMouldID=" + HMouldID +
			",HMachineWorkTimes=" + HMachineWorkTimes +
			",HMachineWorkTimes=" + HMachineWorkTimes +
			",HWeight=" + HWeight +
			" from Sc_StationOutBillMain a with(nolock)" +
			" where HInterID=" + HInterID);

			LogService.Write("用户:" + user + ",日期:" + DateTime.Now + ",修改工序出站单据:" + HBillNo);
			@@ -482,7 +490,7 @@
			oCN.RollBack();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "操作类型无效！";
			objJsonResult.Message = "[0000-2-014]操作类型无效！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -495,7 +503,7 @@
			oCN.RollBack();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "判断数量失败！";
			objJsonResult.Message = "[0000-2-015]判断数量失败！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -505,7 +513,7 @@
			oCN.RollBack();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "判断数量失败！";
			objJsonResult.Message = "[0000-2-015]判断数量失败！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -515,7 +523,7 @@
			oCN.RollBack();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "数量控制," + ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);
			objJsonResult.Message = ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -527,8 +535,8 @@
			oCN.RunProc("exec h_p_Mes_StationOutBillBackBarCode " + HInterID + " ");
			LogService.Write($"7.存储过程结束，用时" + sw.Elapsed);
			//判断是否是末道工序
			ds1 = oCN.RunProcReturn(" select HLastProc,HFstProc from Sc_ProcessExchangeBillMain a " +
			" inner join Sc_ProcessExchangeBillSub b on a.HInterID=b.HInterID " +
			ds1 = oCN.RunProcReturn(" select HLastProc,HFstProc 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 + " ", "Sc_ProcessExchangeBillMain");
			LogService.Write($"7.1.查询，用时" + sw.Elapsed);
			//判断是否是新增
			@@ -590,7 +598,7 @@
			oCN.RollBack();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "保存后控制判断失败！";
			objJsonResult.Message = "[0000-2-016]保存后控制判断失败！";
			objJsonResult.data = null;
			return objJsonResult;

			@@ -600,7 +608,7 @@
			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;
			}
			@@ -625,33 +633,38 @@
			objJsonResult.Verify = "N";
			}
			}
			//判断是否是新增
			if ("Add".Equals(eventType))
			{
			//判断客户为海诚同步金蝶工序汇报单
			if (oSystemParameter.omodel.WMS_CampanyName == "海诚"\|\| oSystemParameter.omodel.WMS_CampanyName == "天擎")
			{
			object objResult = set_SaveStationOutBill_CLD_Json(HInterID, HBillNo, user);
			}
			//判断客户为华舟包装生成条码主档
			else if (oSystemParameter.omodel.WMS_CampanyName == "华舟")
			{
			var objResult = Cj_StationOutBarCode_Save(HInterID,1);
			}
			}
			else if ("Modify".Equals(eventType))
			{
			//判断客户为华舟包装生成条码主档
			if (oSystemParameter.omodel.WMS_CampanyName == "华舟")
			{
			var objResult = Cj_StationOutBarCode_Save(HInterID, 2);
			}

			}
			sw.Stop();//结束计时
			LogService.Write($"11.参数查询结束,新增结束，用时" + sw.Elapsed);
			LogService.Write("END--出站单据保存结束，出站单号：" + HBillNo);

			//测试语句===========================================================================================================
			string msg_str = "";
			string sql_str = "select a.HQty HQty_Main,b.HQty HQty_Sub " +
			"from Sc_ProcessExchangeBillMain as a " +
			"inner join Sc_ProcessExchangeBillSub as b on a.HInterID = b.HInterID " +
			"where a.HInterID = " + HProcExchInterID;
			DataSet ds_str = oCN.RunProcReturn(sql_str, "Sc_ProcessExchangeBillMain");
			if (ds_str.Tables[0].Rows.Count > 0)
			{
			msg_str = "HQty_Main:" + ds_str.Tables[0].Rows[0]["HQty_Main"].ToString() + ";HQty_Sub:";
			for (int j = 0; j < ds_str.Tables[0].Rows.Count; j++)
			{
			msg_str += ds_str.Tables[0].Rows[j]["HQty_Sub"].ToString() + ",";
			}
			}

			oCN.RunProc("Insert into System_log (GeginDate, userid, WorkstationName, WorkList, SystemName, NetuserName, State) select GETDATE(),'" + user + "','" + HComputerName + "','" + "修改工序出站单据：" + HBillNo + "[工序流转卡号：" + HProcExchBillNo + "]" + msg_str + "','LMES-工序出站模块','" + DBUtility.ClsPub.IPAddress + "','新增或修改单据'", ref DBUtility.ClsPub.sExeReturnInfo);
			//==============================================================================================================


			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "新增单据成功！";
			objJsonResult.Message = "[0000-1-050]新增单据成功！";
			objJsonResult.data = ds.Tables[0];
			return objJsonResult;
			}
			@@ -661,7 +674,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;
			}
			@@ -935,7 +948,7 @@
			Int64 HInterID = DBUtility.ClsPub.CreateBillID("3711", ref DBUtility.ClsPub.sExeReturnInfo);
			string HBillNo = DBUtility.ClsPub.CreateBillCode("3711", ref DBUtility.ClsPub.sExeReturnInfo, true);
			//获取组织代码
			string OrganizationNUM = oCN.RunProcReturn("select HNumber from Xt_ORGANIZATIONS where HItemID=" + OrganizationID, "Xt_ORGANIZATIONS").Tables[0].Rows[0]["HNumber"].ToString();
			string OrganizationNUM = oCN.RunProcReturn("select HNumber from Xt_ORGANIZATIONS with(nolock) where HItemID=" + OrganizationID, "Xt_ORGANIZATIONS").Tables[0].Rows[0]["HNumber"].ToString();
			//根据工序汇报单主ID获取工序汇报入库单的数据
			DataSet ds = oCN.RunProcReturn("select * from h_v_MES_StationOutBillList_LastProc where HInterID=" + InterID, "h_v_MES_StationOutBillList_LastProc");
			if (ds.Tables[0].Rows.Count <= 0)
			@@ -950,7 +963,7 @@

			//保存
			//oCN.BeginTran();
			DataSet DsTable = oCN.RunProcReturn($"select * from Sc_ICMOReportBillMain where HBillNo='{HBillNo}'", "Sc_ICMOReportBillMain");
			DataSet DsTable = oCN.RunProcReturn($"select * from Sc_ICMOReportBillMain with(nolock) where HBillNo='{HBillNo}'", "Sc_ICMOReportBillMain");
			if (DsTable.Tables[0].Rows.Count > 0)
			{
			objJsonResult.code = "0";
			@@ -1112,7 +1125,7 @@
			return objJsonResult;
			}

			oCN.RunProc("update Sc_StationOutBillMain set HRelationQty=1 where HBillNo='" + BillNo + "'");
			oCN.RunProc("update a set HRelationQty=1 from Sc_StationOutBillMain a with(nolock) where HBillNo='" + BillNo + "'");

			//oCN.Commit();
			objJsonResult.code = "0";
			@@ -1328,7 +1341,7 @@
			return objJsonResult;
			}

			oCN.RunProc("update Sc_StationOutBillMain set HRelationQty=1 where HBillNo='" + BillNo + "'");
			oCN.RunProc("update a set HRelationQty=1 from Sc_StationOutBillMain a with(nolock) where HBillNo='" + BillNo + "'");

			//oCN.Commit();
			objJsonResult.code = "0";
			@@ -1349,7 +1362,195 @@
			}
			#endregion

			#region [出站单生成条码主档]
			[Route("Cj_StationOutBill/Cj_StationOutBarCode_Save")]
			[HttpPost]
			public object Cj_StationOutBarCode_Save(long HInterID, int Type)
			{
			try
			{
			ListModels oListModels = new ListModels();
			DAL.ClsGy_BarCodeBill_ChaiMa BillNew = new DAL.ClsGy_BarCodeBill_ChaiMa();

			oCN.BeginTran();

			// 如果Type为2，先删除老的条码记录
			if (Type == 2)
			{
			string deleteSql = "DELETE FROM Gy_BarCodeBill WHERE HInterID = '" + HInterID + "'";
			oCN.RunProc(deleteSql);
			}

			// 查询 HQty、HPieceQty 和重量字段
			DataSet dsPiece = oCN.RunProcReturn("select HPieceQty, HQty, HWeight from Sc_StationOutBillMain where HInterID='" + HInterID + "'", "Sc_StationOutBillMain");

			if (dsPiece == null \|\| dsPiece.Tables[0].Rows.Count == 0)
			{
			oCN.RollBack();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "保存失败！未查询到条码信息";
			objJsonResult.data = 1;
			return objJsonResult;
			}

			decimal HPieceQty = Convert.ToDecimal(dsPiece.Tables[0].Rows[0]["HPieceQty"]);
			decimal HQty = Convert.ToDecimal(dsPiece.Tables[0].Rows[0]["HQty"]);
			decimal totalWeight = Convert.ToDecimal(dsPiece.Tables[0].Rows[0]["HWeight"]);

			if (HPieceQty <= 0)
			{
			oCN.RollBack();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "保存失败！件数必须大于0";
			objJsonResult.data = 1;
			return objJsonResult;
			}

			if (totalWeight <= 0)
			{
			oCN.RollBack();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "保存失败！重量必须大于0";
			objJsonResult.data = 1;
			return objJsonResult;
			}

			// 固定生成指定件数的条码
			int barcodeCount = (int)HPieceQty; // HPieceQty 作为条码件数

			// 计算每张条码的基础数量和基础重量
			decimal baseQtyPerPiece = Math.Floor(HQty / HPieceQty);
			decimal remainderQty = HQty % HPieceQty;

			// 计算每张条码的基础重量（净重和毛重相同）
			decimal baseWeightPerPiece = Math.Floor(totalWeight / HPieceQty * 10000) / 10000; // 保留4位小数
			decimal remainderWeight = totalWeight - (baseWeightPerPiece * HPieceQty);

			// 查询原始单据信息
			ds = oCN.RunProcReturn("select * from Sc_StationOutBillMain where HInterID='" + HInterID + "'", "Sc_StationOutBillMain");

			if (ds != null && ds.Tables[0].Rows.Count > 0)
			{
			DataRow row = ds.Tables[0].Rows[0];

			// 循环生成条码
			for (int i = 0; i < barcodeCount; i++)
			{
			// 计算当前条码的数量
			decimal currentQty = baseQtyPerPiece;
			if (i < remainderQty) // 如果有余数，前N张条码各加1
			{
			currentQty += 1;
			}

			// 计算当前条码的重量（净重和毛重相同）
			decimal currentWeight = baseWeightPerPiece;
			if (i < Math.Ceiling(remainderWeight / baseWeightPerPiece) && remainderWeight > 0)
			{
			currentWeight += baseWeightPerPiece; // 重量余数也分摊到前几张条码
			}

			// 生成条码号
			string barcodeNumber = row["HBillNO"].ToString() + (barcodeCount > 1 ? "-" + (i + 1).ToString() : "");

			// 修改插入语句，添加HMaterialJQty和HMaterialMQty字段
			string sql = "insert into Gy_BarCodeBill (HInterID, HEntryID, HBarCode, HBarCodeType, HBarCodeSubType, HMaterID, HUnitID, HQty, HMaterialJQty, HMaterialMQty, HBatchNo, HSupID, HGroupID, HMaker, HMakeDate, " +
			"HPrintQty, HSourceInterID, HSourceEntryID, HSourceBillNo, HSourceBillType, HinitQty, HEndQty, HBarcodeQtys, HBarcodeNo, HDeptID, HWhID, HSPID, HRemark, " +
			"HCusID, HCusType, HEndDate, HWorkLineName, HBarCodeDate, HSTOCKORGID, HOWNERID, HSeOrderBillNo, HGiveAwayFlag, HMaterName, HMaterModel, " +
			"HPinfan, HAuxPropID, HMTONo, HInnerBillNo, HCoilNO, HFurnaceNO, HFactory, HAuxQty, HheatNO, HEmpID, HCusModel, HCusMaterName, HCheckEmpName, HZZRQ, HSupMaterNumber, HSupBatchNo" +
			") values (" +
			"'" + row["HInterID"].ToString() + "', " +
			"'" + (i + 1).ToString() + "', " + // HEntryID 改为序号
			"'" + barcodeNumber + "', " + // 使用带序号的条码号
			"'唯一条码', " +
			"'', " +
			"'" + row["HMaterID"].ToString() + "', " +
			"'0', " +
			"'" + currentQty.ToString() + "', " + // 使用当前条码的数量
			"'" + currentWeight.ToString() + "', " + // 净重
			"'" + currentWeight.ToString() + "', " + // 毛重（与净重相同）
			"'', " +
			"'', " +
			"'" + row["HGroupID"].ToString() + "', " +
			"'" + row["HMaker"].ToString() + "', getdate(), " +
			"'0', " +
			"'" + row["HICMOInterID"].ToString() + "', " +
			"'" + row["HICMOEntryID"].ToString() + "', " +
			"'" + row["HICMOBillNo"].ToString() + "', " +
			"'3710', " +
			"'0', " +
			"'0', " +
			"'1', " +
			"'" + (i + 1).ToString() + "', " + // HBarcodeNo 改为序号
			"'" + row["HDeptID"].ToString() + "', " +
			"'0', " +
			"'0', " +
			"'" + row["HRemark"].ToString() + "', " +
			"'0', " +
			"'', " +
			"getdate(), " +
			"'', " +
			"'" + row["HDate"].ToString() + "', " +
			"'" + row["HPRDORGID"].ToString() + "', " +
			"'" + row["HPRDORGID"].ToString() + "', " +
			"'', " +
			"'0', " +
			"'', " +
			"'', " +
			"'', " +
			"'0', " +
			"'', " +
			"'', " +
			"'', " +
			"'', " +
			"'', " +
			"'0', " +
			"'', " +
			"'" + row["HEmpID"].ToString() + "', " +
			"'', " +
			"'', " +
			"'', " +
			"'', " +
			"'', " +
			"''" +
			")";

			// 插入拆分条码
			oCN.RunProc(sql);
			}

			oCN.Commit();
			objJsonResult.code = "1";
			objJsonResult.count = barcodeCount;
			objJsonResult.Message = "保存成功！共生成" + barcodeCount + "张条码";
			objJsonResult.data = barcodeCount;
			return objJsonResult;
			}
			else
			{
			oCN.RollBack();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "保存失败！未查询到条码信息";
			objJsonResult.data = 1;
			return objJsonResult;
			}
			}
			catch (Exception e)
			{
			oCN.RollBack();
			oCN.RunProc("update Sc_StationOutBillMain set HInterFaceRemark ='" + e.ToString().Replace("'", "''") + "', HInterFaceStatus ='未生成' where HInterID=" + HInterID);
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "保存失败！" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			#endregion



			@@ -1659,7 +1860,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "完工单无查询权限!";
			objJsonResult.Message = "[0000-1-068]完工单无查询权限!";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -1670,7 +1871,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "出站单无查询权限!";
			objJsonResult.Message = "[0000-1-068]出站单无查询权限!";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -1691,7 +1892,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "没有查询到相关用户信息!";
			objJsonResult.Message = "[0000-1-069]没有查询到相关用户信息!";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -1725,7 +1926,7 @@
			//{
			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "Sucess！";
			objJsonResult.Message = "[0000-1-037]Sucess！";
			objJsonResult.list = columnNameList;
			objJsonResult.data = ds.Tables[0];
			return objJsonResult;
			@@ -1743,7 +1944,114 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "Exception！" + e.ToString();
			objJsonResult.Message = "[0000-1-038]Exception！" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			#endregion

			#region 返回工序出站汇报单列表
			[Route("Cj_StationOutBill/get_Display_Eng")]
			[HttpGet]
			public object get_Display_Eng(string sWhere, string user, string HBillSubType)
			{
			try
			{
			List<object> columnNameList = new List<object>();
			if (HBillSubType == "SUB")
			{
			//判断是否有查询权限
			if (!DBUtility.ClsPub.Security_Log("Cj_StationOutBill_Sub_Query", 1, false, user))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "[0000-1-068]完工单无查询权限!";
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			else
			{
			//判断是否有查询权限
			if (!DBUtility.ClsPub.Security_Log("Cj_StationOutBill_Query", 1, false, user))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "[0000-1-068]出站单无查询权限!";
			objJsonResult.data = null;
			return objJsonResult;
			}
			}


			//获取系统参数
			string Ret = "";
			if (oSystemParameter.ShowBill(ref Ret))
			{
			//判断客户为龙山汽配
			if (oSystemParameter.omodel.WMS_CampanyName == "龙山汽配")
			{
			//获取需要拼接的字符串
			string sql_splice = DBUtility.ClsPub.SpliceSQL(user, "工序汇报单列表");

			if (sql_splice == "没有查询到相关用户信息")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "[0000-1-069]没有查询到相关用户信息!";
			objJsonResult.data = null;
			return objJsonResult;
			}
			else
			{
			sWhere += sql_splice;
			}
			}
			}

			if (sWhere == null \|\| sWhere.Equals(""))
			{
			ds = oCN.RunProcReturn("select * from h_v_MES_StationOutBillList_Eng where 1 = 1" + sWhere + "order by hmainid desc", "h_v_MES_StationOutBillList");
			}
			else
			{
			string sql1 = "select * from h_v_MES_StationOutBillList_Eng where 1 = 1 ";
			string sql = sql1 + sWhere + " order by hmainid desc";
			ds = oCN.RunProcReturn(sql, "h_v_MES_StationOutBillList_Eng");
			}

			//添加列名
			foreach (DataColumn col in ds.Tables[0].Columns)
			{
			Type dataType = col.DataType;
			string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}";
			columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//获取到DataColumn列对象的列名
			}

			//if (ds.Tables[0].Rows.Count != 0 \|\| ds != null)
			//{
			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "[0000-1-037]Sucess！";
			objJsonResult.list = columnNameList;
			objJsonResult.data = ds.Tables[0];
			return objJsonResult;
			//}
			//else
			//{
			//objJsonResult.code = "0";
			//objJsonResult.count = 0;
			//objJsonResult.Message = "无数据";
			//objJsonResult.data = null;
			//return objJsonResult;
			//}
			}
			catch (Exception e)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "[0000-1-038]Exception！" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -1765,7 +2073,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "完工单无查询权限!";
			objJsonResult.Message = "[0000-1-068]完工单无查询权限!";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -1777,7 +2085,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "出站单无查询权限!";
			objJsonResult.Message = "[0000-1-068]出站单无查询权限!";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -1798,7 +2106,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "没有查询到相关用户信息!";
			objJsonResult.Message = "[0000-1-069]没有查询到相关用户信息!";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -1830,7 +2138,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;
			@@ -1839,7 +2147,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;
			}
			@@ -1890,7 +2198,7 @@

			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "Sucess！";
			objJsonResult.Message = "[0000-1-037]Sucess！";
			objJsonResult.list = columnNameList;
			objJsonResult.data = ds.Tables[0];
			return objJsonResult;
			@@ -1899,7 +2207,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;
			}
			@@ -2272,7 +2580,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "完工单无权限！";
			objJsonResult.Message = "[0000-1-058]完工单无权限！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -2283,7 +2591,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "出站单无权限！";
			objJsonResult.Message = "[0000-1-058]出站单无权限！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -2301,7 +2609,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "只能删除本人的单据！";
			objJsonResult.Message = "[0000-1-011]只能删除本人的单据！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -2317,7 +2625,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "判断关联失败！";
			objJsonResult.Message = "[0000-2-018]判断关联失败！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -2325,7 +2633,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0][1]);
			objJsonResult.Message = "[0000-1-007]" + Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0][1]);
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -2333,7 +2641,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "单据已经审核,不能删除！";
			objJsonResult.Message = "[0000-1-013]单据已经审核,不能删除！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -2344,7 +2652,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "系统参数控制,已有下道工序,不能删除！";
			objJsonResult.Message = "[3791-1-002]系统参数控制,已有下道工序,不能删除！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -2354,7 +2662,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "删除出站汇报单发生异常，没有任何返回记录！";
			objJsonResult.Message = "[3791-1-005]删除出站汇报单发生异常，没有任何返回记录！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -2364,7 +2672,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = ds.Tables[0].Rows[0]["HRemarkBack"].ToString();
			objJsonResult.Message = "[0000-1-007]" + ds.Tables[0].Rows[0]["HRemarkBack"].ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -2378,7 +2686,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "删除失败!原因:删除前判断失败，请与网络管理人员联系";
			objJsonResult.Message = "[0000-1-006]删除失败!原因:删除前判断失败，请与网络管理人员联系";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -2387,7 +2695,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "删除失败!原因:" + ds.Tables[0].Rows[0]["HRemark"].ToString(); ;
			objJsonResult.Message = "[0000-1-007]删除失败!原因:" + ds.Tables[0].Rows[0]["HRemark"].ToString(); ;
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -2397,7 +2705,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = DBUtility.ClsPub.sExeReturnInfo;
			objJsonResult.Message = "[0000-1-007]" + DBUtility.ClsPub.sExeReturnInfo;
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -2409,7 +2717,7 @@

			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "删除成功！";
			objJsonResult.Message = "[0000-1-008]删除成功！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -2418,7 +2726,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "单据未找到！";
			objJsonResult.Message = "[0000-1-005]单据未找到！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -2428,7 +2736,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "异常！" + e.ToString();
			objJsonResult.Message = "[0000-1-007]异常！" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -2450,7 +2758,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "完工单无权限！";
			objJsonResult.Message = "[3791-1-001]完工单无权限！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -2462,7 +2770,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "出站单无权限！";
			objJsonResult.Message = "[3791-1-001]出站单无权限！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -2480,7 +2788,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "只能删除本人的单据！";
			objJsonResult.Message = "[0000-1-011]只能删除本人的单据！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -2496,7 +2804,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "判断关联失败！";
			objJsonResult.Message = "[0000-2-018]判断关联失败！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -2504,7 +2812,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0][1]);
			objJsonResult.Message = "[0000-1-007]" + Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0][1]);
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -2512,7 +2820,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "单据已经审核,不能删除！";
			objJsonResult.Message = "[0000-1-013]单据已经审核,不能删除！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -2523,7 +2831,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "系统参数控制,已有下道工序,不能删除！";
			objJsonResult.Message = "[3791-1-002]系统参数控制,已有下道工序,不能删除！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -2546,7 +2854,7 @@

			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "删除成功！";
			objJsonResult.Message = "[0000-1-008]删除成功！";
			objJsonResult.data = null;
			return objJsonResult;

			@@ -2555,7 +2863,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "单据未找到！";
			objJsonResult.Message = "[0000-1-005]单据未找到！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -2565,7 +2873,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "异常！" + e.ToString();
			objJsonResult.Message = "[0000-1-007]异常！" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -2638,11 +2946,149 @@
			}
			#endregion

			#region 根据id删除出站单和关键件清单表
			[Route("Cj_StationOutBill/del_StationOutBillandAssemblyBill")]
			[HttpGet]
			public object del_StationOutBillandAssemblyBill(long HInterID, string HBarCode_P, string HDeleteMan, string HBillSubType)
			{
			try
			{
			string HComputerName = SystemInformation.ComputerName; //设备名称
			if (HBillSubType == "SUB")
			{
			//编辑权限
			if (!DBUtility.ClsPub.Security_Log("Cj_StationOutBill_Sub_Drop", 1, false, HDeleteMan))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "[3791-1-001]完工单无权限！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			else
			{
			//编辑权限
			if (!DBUtility.ClsPub.Security_Log("Cj_StationOutBill_Drop", 1, false, HDeleteMan))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "[3791-1-001]出站单无权限！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			}

			DAL.ClsSc_StationOutBill oBill = new DAL.ClsSc_StationOutBill();
			if (oBill.ShowBill(HInterID, ref DBUtility.ClsPub.sExeReturnInfo))
			{
			string sReturn = "";
			if (oSystemParameter.ShowBill(ref sReturn))
			{
			if (oSystemParameter.omodel.MES_StationOutBill_DeleteCtl == "Y")
			{
			if (oBill.omodel.HMaker != HDeleteMan && (HDeleteMan != "admin" && HDeleteMan != "Admin"))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "[0000-1-011]只能删除本人的单据！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			}


			SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
			DataSet ds;
			//判断是否存在相同单据号的领料单判断生产订单是否已结案，要求计划手工反结案
			ds = oCn.RunProcReturn("exec h_p_MES_StationOutBill_DelCtrl '" + oBill.omodel.HBillNo + "'", "h_p_MES_StationOutBill_DelCtrl");
			if (ds == null)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "[0000-2-018]判断关联失败！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			if (ds.Tables[0].Rows.Count > 0 && Pub_Class.ClsPub.isInt(ds.Tables[0].Rows[0][0]) == 2)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "[0000-1-007]" + Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0][1]);
			objJsonResult.data = null;
			return objJsonResult;
			}
			if (oBill.omodel.HChecker != "")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "[0000-1-013]单据已经审核,不能删除！";
			objJsonResult.data = null;
			return objJsonResult;
			}

			ds = oCn.RunProcReturn($"exec h_p_DelOutInBill {HInterID},'MES_StationOutBill_DeleteRelationCtl'", "h_p_DelOutInBill");

			if (ds.Tables[0].Rows[0][0].ToString() == "0")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "[3791-1-002]系统参数控制,已有下道工序,不能删除！";
			objJsonResult.data = null;
			return objJsonResult;
			}

			oCn.BeginTran();

			ds = oCn.RunProcReturn($"select * from Sc_AssemblyBillMain where HMainSourceInterID={oBill.omodel.HProcExchInterID} and HMainSourceEntryID={oBill.omodel.HProcExchEntryID} and HBarCode_P='{HBarCode_P}'", "Sc_AssemblyBillMain");

			if (ds.Tables[0].Rows.Count > 0)
			{
			oCn.RunProc($"delete from Sc_AssemblyBillMain where HMainSourceInterID={oBill.omodel.HProcExchInterID} and HMainSourceEntryID={oBill.omodel.HProcExchEntryID} and HBarCode_P='{HBarCode_P}'");
			oCn.RunProc($"delete from Sc_AssemblyBillSub where HInterID={ds.Tables[0].Rows[0]["HInterID"].ToString()} and HBarCode_P='{HBarCode_P}'");
			}

			oCn.RunProc("delete from Sc_StationOutBillSub_SN where HInterID=" + HInterID + " and HBarCode='" + HBarCode_P + "'");
			oCn.RunProc($"delete from Sc_StationOutBillMain where HInterID={HInterID}");


			oCn.Commit();

			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "[0000-1-008]删除成功！";
			objJsonResult.data = null;
			return objJsonResult;

			}
			else
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "[0000-1-005]单据未找到！";
			objJsonResult.data = null;
			return objJsonResult;
			}

			}
			catch (Exception e)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "[0000-1-007]异常！" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			#endregion

			#region 编辑前判断
			[Route("Cj_StationOutBill/set_ShowBillJudge")]
			[HttpGet]
			public object set_ShowBillJudge(string HBillNo)
			{
			string sReturn = "";
			try
			{
			ds = oCN.RunProcReturn("exec h_p_MES_StationOutBill_DelCtrl '" + HBillNo + "'", "h_p_MES_StationOutBill_DelCtrl");
			@@ -2650,7 +3096,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "判断关联失败！";
			objJsonResult.Message = "[0000-2-018]判断关联失败！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -2666,18 +3112,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
			@@ -2696,7 +3165,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "完工单审核失败！无权限！";
			objJsonResult.Message = "[0000-1-060]完工单审核失败！无权限！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -2707,7 +3176,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "出站单审核失败！无权限！";
			objJsonResult.Message = "[0000-1-060]出站单审核失败！无权限！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -2724,7 +3193,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "第"+(i+1)+"行:单据ID为0，不能审核！";
			objJsonResult.Message = "[0000-1-009]第" + (i+1)+"行:单据ID为0，不能审核！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -2735,7 +3204,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "第" + (i + 1) + "行:单据已审核!不能再次审核";
			objJsonResult.Message = "[0000-1-023]第" + (i + 1) + "行:单据已审核!不能再次审核";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -2745,7 +3214,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "第" + (i + 1) + "行:单据不存在!原因:" + DBUtility.ClsPub.sExeReturnInfo;
			objJsonResult.Message = "[0000-1-005]第" + (i + 1) + "行:单据不存在!原因:" + DBUtility.ClsPub.sExeReturnInfo;
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -2754,14 +3223,14 @@
			int j = 0;
			for (int i = 0; i < HInterIDs.Length; i++)
			{
			//审核前控制
			//审核前控制================================================================================
			string sql = "exec h_p_Sc_StationOutBill_BeforeCheckCtrl " + HInterIDs[i] + ",'" + HBillNo[i] + "','" + CurUserName + "'";
			ds = oCN.RunProcReturn(sql, "h_p_Sc_StationOutBill_BeforeCheckCtrl");
			if (ds == null \|\| ds.Tables.Count == 0 \|\| ds.Tables[0].Rows.Count == 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "审核失败!原因:审核前判断失败，请与网络管理人员联系";
			objJsonResult.Message = "[0000-1-024]审核失败!原因:审核前判断失败，请与网络管理人员联系";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -2770,11 +3239,11 @@
			{
			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_StationOutBillCheckBill(long.Parse(HInterIDs[i]), HBillNo[i], CurUserName, oBill.omodel.HLastSubProc, ref DBUtility.ClsPub.sExeReturnInfo))
			@@ -2785,7 +3254,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "成功:" + j + "行,第" + (i + 1) + "行:审核失败!原因:" + DBUtility.ClsPub.sExeReturnInfo;
			objJsonResult.Message = DBUtility.ClsPub.sExeReturnInfo;
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -2793,7 +3262,7 @@

			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "全部执行成功!";
			objJsonResult.Message = "[0000-1-029]全部执行成功!";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -2801,7 +3270,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "审核失败！" + e.ToString();
			objJsonResult.Message = "[0000-1-025]审核失败！" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -2815,21 +3284,21 @@
			string HChecker = CurUserName;
			string HCheckDate = DBUtility.ClsPub.GetServerDate(-1);
			oCN.BeginTran();
			ds = oCN.RunProcReturn("Select * from Sc_StationOutBillMain Where HInterID=" + lngBillKey.ToString(), "Sc_StationOutBillMain");
			ds = oCN.RunProcReturn("Select * from Sc_StationOutBillMain with(nolock) Where HInterID=" + lngBillKey.ToString(), "Sc_StationOutBillMain");
			if (ds.Tables[0].Rows.Count == 0)
			{
			sReturn = "单据未找到！";
			return false;
			}
			oCN.RunProc(" Update Sc_StationOutBillMain set HChecker='" + HChecker + "',HCheckDate='" + HCheckDate + "' Where HInterID=" + lngBillKey.ToString());
			oCN.RunProc(" Update a set HChecker='" + HChecker + "',HCheckDate='" + HCheckDate + "' from Sc_StationOutBillMain a with(nolock) Where HInterID=" + lngBillKey.ToString());
			oCN.RunProc("exec h_p_Mes_ProcessExchangeRelationQty_Check_In " + lngBillKey.ToString() + ",1");
			//判断是否是末道工序
			DataSet ds1;
			ds1 = oCN.RunProcReturn("select HLastProc,HFstProc " +
			" from Sc_ProcessExchangeBillMain a " +
			" inner join Sc_ProcessExchangeBillSub b on a.HInterID=b.HInterID " +
			" Where a.HInterID=(Select HProcExchInterID from Sc_StationOutBillMain Where HInterID=" + lngBillKey + ") " +
			" and b.HEntryID=(Select HProcExchEntryID from Sc_StationOutBillMain Where HInterID=" + lngBillKey + ")", "Sc_ProcessExchangeBillMain");
			" from Sc_ProcessExchangeBillMain a with(nolock)" +
			" inner join Sc_ProcessExchangeBillSub b with(nolock) on a.HInterID=b.HInterID " +
			" Where a.HInterID=(Select HProcExchInterID from Sc_StationOutBillMain with(nolock) Where HInterID=" + lngBillKey + ") " +
			" and b.HEntryID=(Select HProcExchEntryID from Sc_StationOutBillMain with(nolock) Where HInterID=" + lngBillKey + ")", "Sc_ProcessExchangeBillMain");
			if (ds1 == null \|\| ds1.Tables[0].Rows.Count == 0 \|\| HLastSubProc ==false)
			{
			}
			@@ -2837,8 +3306,8 @@
			{
			}

			DataSet dataSet = oCN.RunProcReturn(@"select a.HProcExchBillNo,a.HQty,b.HQty HProcExchQty from Sc_StationOutBillMain a
			inner join Sc_ProcessExchangeBillMain b on a.HProcExchInterID = b.HInterID
			DataSet dataSet = oCN.RunProcReturn(@"select a.HProcExchBillNo,a.HQty,b.HQty HProcExchQty from Sc_StationOutBillMain a with(nolock)
			inner join Sc_ProcessExchangeBillMain b with(nolock) on a.HProcExchInterID = b.HInterID
			where a.HInterID = " + lngBillKey, "Sc_ProcessExchangeBillMain");

			if (dataSet.Tables[0].Rows.Count > 0)
			@@ -2850,7 +3319,7 @@
			LogService.Write("出站单据审核更改流转卡数量,流转卡:" + HProcExchBillNo + ",出站单号：" + HBillNo + ",原流转卡数量:" + HProcExchQty + ",新流转卡数量:" + HQty);
			}

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

			//================================================================================

			sReturn = sReturn + " 审核功能！";
			oCN.Commit();
			@@ -2894,7 +3363,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "完工单反审核失败！无权限！";
			objJsonResult.Message = "[0000-1-061]完工单反审核失败！无权限！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -2906,7 +3375,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "出站单反审核失败！无权限！";
			objJsonResult.Message = "[0000-1-061]出站单反审核失败！无权限！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -2927,7 +3396,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "第" + (i + 1) + "行:单据ID为0，不能反审核！";
			objJsonResult.Message = "[0000-1-009]第" + (i + 1) + "行:单据ID为0，不能反审核！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -2939,7 +3408,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "第" + (i + 1) + "行:单据未审核!不需要反审核!";
			objJsonResult.Message = "[0000-1-018]第" + (i + 1) + "行:单据未审核!不需要反审核!";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -2951,7 +3420,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "第" + (i + 1) + "行:审核人和反审核人不一致!";
			objJsonResult.Message = "[0000-1-062]第" + (i + 1) + "行:审核人和反审核人不一致!";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -2963,7 +3432,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "第" + (i + 1) + "行:单据不存在!原因:" + DBUtility.ClsPub.sExeReturnInfo;
			objJsonResult.Message = "[0000-1-005]第" + (i + 1) + "行:单据不存在!原因:" + DBUtility.ClsPub.sExeReturnInfo;
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -2972,14 +3441,14 @@
			int j = 0;
			for (int i = 0; i < HInterIDs.Length; i++)
			{
			//反审核前控制
			//反审核前控制=============================================================
			string sql = "exec h_p_Sc_StationOutBill_BeforeUnCheckCtrl " + HInterIDs[i] + ",'" + HBillNo[i] + "','" + CurUserName + "'";
			ds = oCN.RunProcReturn(sql, "h_p_Sc_StationOutBill_BeforeUnCheckCtrl");
			if (ds == null \|\| ds.Tables.Count == 0 \|\| ds.Tables[0].Rows.Count == 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "反审核失败!原因:反审核前判断失败，请与网络管理人员联系";
			objJsonResult.Message = "[0000-1-027]反审核失败!原因:反审核前判断失败，请与网络管理人员联系";
			objJsonResult.data = null;
			return objJsonResult;

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

			//================================================================================
			//反审核
			if (Cj_StationOutBillAbandonCheckBill(long.Parse(HInterIDs[i]),HBillNo[i], CurUserName, oBill.omodel.HLastSubProc, ref DBUtility.ClsPub.sExeReturnInfo))
			{
			@@ -3002,7 +3471,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "成功:" + j + "行,第" + (i + 1) + "行:反审核失败!原因:" + DBUtility.ClsPub.sExeReturnInfo;
			objJsonResult.Message = "[0000-1-028]成功:" + j + "行,第" + (i + 1) + "行:反审核失败!原因:" + DBUtility.ClsPub.sExeReturnInfo;
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -3010,7 +3479,7 @@

			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "全部执行成功!";
			objJsonResult.Message = "[0000-1-019]全部执行成功!";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -3018,7 +3487,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "反审核失败！" + e.ToString();
			objJsonResult.Message = "[0000-1-028]反审核失败！" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -3086,7 +3555,7 @@
			return false; ;
			}
			}

			#endregion

			#region 工序出站关闭/反关闭功能
			[Route("Cj_StationOutBill/CloseCj_StationOutBill")]
			@@ -3102,7 +3571,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "完工单无权限关闭!";
			objJsonResult.Message = "[0000-1-063]完工单无权限关闭!";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -3113,7 +3582,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "出站单无权限关闭!";
			objJsonResult.Message = "[0000-1-063]出站单无权限关闭!";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -3124,7 +3593,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "HInterID为空！";
			objJsonResult.Message = "[0000-1-009]HInterID为空！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -3146,17 +3615,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_StationOutBill_BeforeCloseCtrl " + HInterID + ",'" + HBillNo + "','" + user + "'";
			ds = oCN.RunProcReturn(sql1, "h_p_Sc_StationOutBill_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_StationOutBill_AfterCloseCtrl", user, ref ClsPub.sExeReturnInfo))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "[0000-1-034]关闭失败!原因:" + ClsPub.sExeReturnInfo;
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -3173,17 +3666,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_StationOutBill_BeforeUnCloseCtrl " + HInterID + ",'" + HBillNo + "','" + user + "'";
			ds = oCN.RunProcReturn(sql1, "h_p_Sc_StationOutBill_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_StationOutBill_AfterUnCloseCtrl", user, ref ClsPub.sExeReturnInfo))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "[0000-1-036]反关闭失败!原因:" + ClsPub.sExeReturnInfo;
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -3193,7 +3710,7 @@

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

			@@ -3202,16 +3719,95 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "执行失败！" + e.ToString();
			objJsonResult.Message = "[0000-1-034]执行失败！" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			#endregion

			#region 工序汇报单流水号回车获取工序信息(带子序列)
			[Route("Cj_StationOutBill/txtHProcNo_KeyDown")]
			[HttpGet]
			public object txtHProcNo_KeyDown(string sBillNo, string sProcNo,string HSEQNumber)
			{
			try
			{
			if (sBillNo.Equals("") \|\| sProcNo.Equals(""))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "[0000-2-019]条形码不能为空！";
			objJsonResult.data = null;
			return objJsonResult;
			}

			//得到信息（委外标记为0时，流转标记为1时）
			ds = oCN.RunProcReturn("select top 1 * from h_v_Sc_ProcessExchangeBillList_Sec where 单据号= '" + sBillNo + "' and 下道流转工序<>'转' and 委外标记=0 and 流转标记=1 and 工序号='" + sProcNo + "' and 序列号='"+ HSEQNumber+"'", "h_v_Sc_ProcessExchangeBillList_Sec");
			//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 = "[3790-2-013]工序号错误或者当前工序号不允许进站，请重新输入！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "[0000-1-037]Sucess！";
			objJsonResult.data = ds.Tables[0];
			return objJsonResult;
			}
			catch (Exception e)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "[0000-1-038]Exception！" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			#endregion

			//是否被关联
			#region 工序汇报单获取对应所以序列
			[Route("Cj_StationOutBill/getAllHSEQ")]
			[HttpGet]
			public object getAllHSEQ(string HInterID)
			{
			try
			{
			//得到信息（委外标记为0时，流转标记为1时
			ds = oCN.RunProcReturn("select * from Sc_ProcessExchangeBillSEQ where HInterID= " + HInterID, "Sc_ProcessExchangeBillSEQ");

			//写入信息
			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 = "[0000-1-037]Sucess！";
			objJsonResult.data = ds.Tables[0];
			return objJsonResult;
			}
			catch (Exception e)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "[0000-1-038]Exception！" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			#endregion

			#region //是否被关联
			public bool Cj_StationInBillisUse(Int64 lngBillKey, ref string sReturn)
			{
			try
			@@ -3455,6 +4051,7 @@
			objJsonResult.data = ds.Tables[0];
			return objJsonResult;
			}

			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "";
			@@ -3476,6 +4073,8 @@
			objJsonResult.data = ds.Tables[0];
			return objJsonResult;
			}



			objJsonResult.code = "1";
			objJsonResult.count = 1;
			@@ -3521,14 +4120,27 @@
			return objJsonResult;
			}


			List<object> columnNameList = new List<object>();

			string sql1 = "select * from h_v_MES_StationOutBillList_SN where 1 = 1 ";
			string sql = sql1 + sWhere + " order by 制单日期 desc";
			ds = oCN.RunProcReturn(sql, "h_v_MES_StationOutBillList_SN");

			//添加列名
			foreach (DataColumn col in ds.Tables[0].Columns)
			{
			LogService.Write(21231321);
			Type dataType = col.DataType;
			string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}";
			columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//获取到DataColumn列对象的列名
			}

			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "Sucess！";
			objJsonResult.data = ds.Tables[0];
			objJsonResult.list = columnNameList;
			return objJsonResult;
			}
			catch (Exception e)
			@@ -3836,7 +4448,7 @@
			{
			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "";
			objJsonResult.Message = "[0000-1-037]";
			objJsonResult.data = ds.Tables[0];
			return objJsonResult;
			}
			@@ -3844,7 +4456,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "";
			objJsonResult.Message = "[0000-1-010]";
			return objJsonResult;
			}

			@@ -3855,7 +4467,7 @@

			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "没有返回任何记录！" + e.ToString();
			objJsonResult.Message = "[0000-1-010]没有返回任何记录！" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -3992,7 +4604,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "出站单无编辑权限!";
			objJsonResult.Message = "[0000-1-065]出站单无编辑权限!";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -4002,7 +4614,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "修改失败没找到相关出站汇报单";
			objJsonResult.Message = "[3791-1-003]修改失败没找到相关出站汇报单";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -4018,7 +4630,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "修改失败该时间班组已计算工资:" + HOldDate;
			objJsonResult.Message = "[3791-1-004]修改失败该时间班组已计算工资:" + HOldDate;
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -4027,7 +4639,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "修改失败该时间班组已计算工资:" + HOldDate;
			objJsonResult.Message = "[3791-1-004]修改失败该时间班组已计算工资:" + HOldDate;
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -4036,7 +4648,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "修改失败该时间班组已计算工资:" + dateTime;
			objJsonResult.Message = "[3791-1-004]修改失败该时间班组已计算工资:" + dateTime;
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -4045,7 +4657,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "修改失败该时间班组已计算工资:" + dateTime;
			objJsonResult.Message = "[3791-1-004]修改失败该时间班组已计算工资:" + dateTime;
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -4054,7 +4666,7 @@
			oCN.RunProcReturn(sql, "Sc_StationOutBillMain");
			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "Sucess！";
			objJsonResult.Message = "[0000-1-067]Sucess！";
			objJsonResult.data = null;
			return objJsonResult;

			@@ -4063,7 +4675,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "Exception！" + e.ToString();
			objJsonResult.Message = "[0000-1-066]Exception！" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -4146,7 +4758,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "无删除权限!";
			objJsonResult.Message = "[0000-1-058]无删除权限!";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -4157,7 +4769,7 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "查无数据！";
			objJsonResult.Message = "[0000-1-045]查无数据！";
			objJsonResult.data = null;
			}

			@@ -4172,7 +4784,7 @@

			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "Sucess！";
			objJsonResult.Message = "[0000-1-037]Sucess！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -4181,11 +4793,74 @@
			oCN.RollBack();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "Exception！" + e.ToString();
			objJsonResult.Message = "[0000-1-038]Exception！" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			#endregion


			#region 工序汇报单同步至金蝶云

			/// <summary>
			/// 工序汇报单同步至金蝶云
			/// </summary>
			/// <returns></returns>
			[Route("Cj_StationOutBill/set_SaveStationOutBill_CLD_Json")]
			[HttpGet]
			public object set_SaveStationOutBill_CLD_Json(Int64 HInterID, string HBillNo, string HMaker)
			{
			try
			{
			//同步前控制=========================================
			ds = oCN.RunProcReturn("Exec h_p_Sc_StationOutBill_BeforeSyncCtrl " + HInterID.ToString() + ", '" + HBillNo + "','" + HMaker + "'", " h_p_Sc_StationOutBill_BeforeSyncCtrl ");
			if (ds == null)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "[0000-2-012]保存前判断失败！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			if (DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBack"]) != "0")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "[0000-1-051]同步失败！" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HRemark"]);
			objJsonResult.data = null;
			return objJsonResult;
			}
			//=========================================================
			if (oWebs.set_SaveStationOutBill_CLD(HInterID, HBillNo, HMaker, ref DBUtility.ClsPub.sErrInfo))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "成功";
			objJsonResult.data = null;
			return objJsonResult;
			}
			else
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = DBUtility.ClsPub.sErrInfo;
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			catch (Exception e)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "同步至金蝶云失败！" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}

			#endregion


			}
			}