MES-WEB-API.git

			@@ -1,19 +1,16 @@
			using Newtonsoft.Json;
			using Newtonsoft.Json.Linq;
			using Pub_Class;
			using SQLHelper;
			using SyntacticSugar.constant;
			using System;
			using System.Collections;
			using System.Collections.Generic;
			using System.Data;
			using System.Data.SqlClient;
			using System.IO;
			using System.Web;
			using System.Web.Http;
			using System.Windows.Forms;
			using WebAPI.Controllers.SCGL.日计划管理;
			using WebAPI.Models;
			using SyntacticSugar.constant;
			namespace WebAPI.Controllers
			{
			//工艺路线Controller
			@@ -29,6 +26,7 @@
			public DAL.ClsGy_Process_View oProcHlp = new DAL.ClsGy_Process_View();
			DAL.ClsGy_WorkCenter_View oCenHlp = new DAL.ClsGy_WorkCenter_View();
			DAL.ClsGy_Warehouse_View oCenWare = new DAL.ClsGy_Warehouse_View();
			DAL.ClsGy_Source_View oSourceHlp = new DAL.ClsGy_Source_View();
			Gy_RoutingBill_temporary omdelMian = new Gy_RoutingBill_temporary();
			public string BillType = "3301";
			Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter();
			@@ -244,6 +242,21 @@
			return objJsonResult;
			}
			}
			else if (oSystemParameter.omodel.WMS_CampanyName == "添康科技")
			{
			DataSet dss;
			dss = oCN.RunProcReturn("select COUNT(*) as number from Sc_ProcessExchangeBillMain where HRoutingBillID = " + HInterID, "Gy_RoutingBillMain");
			//判断是否可编辑
			if (dss.Tables[0].Rows[0]["number"].ToString() != "0")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "此单据已经被引用，不允许修改！";
			objJsonResult.data = 1;
			return objJsonResult;
			}
			}

			if (OperationType == 2)
			{
			ds = oCN.RunProcReturn("select * from h_v_Gy_RoutingBillList where 单据号='" + HBillNo + "'", "h_v_Gy_RoutingBillList");
			@@ -255,12 +268,34 @@
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			}

			ds = oCN.RunProcReturn("select * from h_v_Gy_RoutingBillList where hmainid=" + HInterID + " and 单据号='" + HBillNo + "'", "h_v_Gy_RoutingBillList");

			if ((OperationType == 1 \|\| OperationType == 2) && ds.Tables[0].Rows.Count == 0)//新增
			{

			//保存前控制=========================================
			string HBillNote = "";
			ds = oCN.RunProcReturn("Exec h_p_Gy_RoutingBill_BeforeSaveCtrl " + HInterID.ToString() + ", '" + HBillNo + "','" + HBillNote + "',1 ", " h_p_Gy_RoutingBill_BeforeSaveCtrl ");
			if (ds == null)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "保存前判断失败！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			if (DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBack"]) != "0")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "保存失败！" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);
			objJsonResult.data = null;
			return objJsonResult;
			}
			//=========================================================

			//主表
			oCN.RunProc("Insert Into Gy_RoutingBillMain " +
			"(HBillType,HBillSubType,HInterID,HBillNo,HDate" +
			@@ -276,35 +311,78 @@
			"," + HMainPrice + "," + HStdSourceQty + "," + HAddSourceRate + "," + HPRDORGID + "," + HDelSourceRate +
			",'" + HPicNumVer + "','" + HPicNumAssemble + "','" + HMaterTexture + "','" + HProductNum + "','" + HVerNum + "'," + HOrgID + ",'"+ HProcPriceType + "','" + HBeginDate + "','" + HEndDate + "') ");


			//=========================保存后控制添加审批流
			//DataSet ds2 = oCN.RunProcReturn("Exec h_p_Gy_RoutingBill_AfterSaveCtrl " + HInterID.ToString() + ", '" + HBillNo + "',1 ", "h_p_Gy_RoutingBill_AfterSaveCtrl");
			//if (ds2 == null)
			//{
			// oCN.RollBack();
			// objJsonResult.code = "0";
			// objJsonResult.count = 0;
			// objJsonResult.Message = "保存后控制判断失败！";
			// objJsonResult.data = null;
			// return objJsonResult;

			//}
			//if (DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBack"]) != "0")
			//{
			// oCN.RollBack();
			// objJsonResult.code = "0";
			// objJsonResult.count = 0;
			// objJsonResult.Message = "保存失败2！" + DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBackRemark"]);
			// objJsonResult.data = null;
			// return objJsonResult;
			//}
			//============================

			LogService.Write("用户:" + user + ",日期:" + DateTime.Now + ",新增工艺路线单据:" + HBillNo);
			oCN.RunProc("Insert into System_log (GeginDate, userid, WorkstationName, WorkList, SystemName, NetuserName, State) select GETDATE(),'" + user + "','" + HComputerName + "','" + "新增工艺路线单据：" + HBillNo + "','LMES-工艺路线模块','" + DBUtility.ClsPub.IPAddress + "','新增单据'", ref DBUtility.ClsPub.sExeReturnInfo);
			}
			else if (OperationType == 3 \|\| ds.Tables[0].Rows.Count != 0)
			{ //修改

			//修改
			DataSet dss;
			dss = oCN.RunProcReturn("select * from Gy_RoutingBillMain where HInterID=" + HInterID + " and HBillNo='" + HBillNo + "'", "Gy_RoutingBillMain");
			//判断是否可编辑
			if ((dss.Tables[0].Rows[0]["HChecker"].ToString() != "" && dss.Tables[0].Rows[0]["HChecker"] != null) \|\| (dss.Tables[0].Rows[0]["HBillStatus"].ToString() != "1" && dss.Tables[0].Rows[0]["HBillStatus"].ToString() != "5" && dss.Tables[0].Rows[0]["HBillStatus"].ToString() != "0"))
			if (oSystemParameter.omodel.WMS_CampanyName == "乔一")
			{

			}
			else
			{
			//修改
			DataSet dss;
			dss = oCN.RunProcReturn("select * from Gy_RoutingBillMain where HInterID=" + HInterID + " and HBillNo='" + HBillNo + "'", "Gy_RoutingBillMain");
			//判断是否可编辑
			if ((dss.Tables[0].Rows[0]["HChecker"].ToString() != "" && dss.Tables[0].Rows[0]["HChecker"] != null) \|\| (dss.Tables[0].Rows[0]["HBillStatus"].ToString() != "1" && dss.Tables[0].Rows[0]["HBillStatus"].ToString() != "0" && dss.Tables[0].Rows[0]["HBillStatus"].ToString() != "5"))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "此单据状态未在创建，不允许修改！";
			objJsonResult.data = 1;
			return objJsonResult;
			}
			}

			//保存前控制=========================================
			string HBillNote = "";
			ds = oCN.RunProcReturn("Exec h_p_Gy_RoutingBill_BeforeSaveCtrl " + HInterID.ToString() + ", '" + HBillNo + "','" + HBillNote + "',2 ", " h_p_Gy_RoutingBill_BeforeSaveCtrl ");
			if (ds == null)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "此单据状态未在创建或退回，不允许修改！";
			objJsonResult.data = 1;
			objJsonResult.Message = "保存前判断失败！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			dss = oCN.RunProcReturn("select COUNT(*) as number from Sc_ProcessExchangeBillMain where HRoutingBillID = " + HInterID, "Gy_RoutingBillMain");
			//判断是否可编辑
			if (dss.Tables[0].Rows[0]["number"].ToString() != "0")
			if (DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBack"]) != "0")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "此单据已经被引用，不允许修改！";
			objJsonResult.data = 1;
			objJsonResult.Message = "保存失败！" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);
			objJsonResult.data = null;
			return objJsonResult;
			}

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


			oCN.RunProc("update Gy_RoutingBillMain set " +
			"HDate='" + HDate +
			"',HYear='" + HYear + "',HPeriod='" + HPeriod + "',HRemark='" + HRemark + "',hupdater='" + HMaker +
			@@ -319,11 +397,38 @@
			//删除子表
			oCN.RunProc("delete from Gy_RoutingBillSub where HInterID='" + HInterID + "'");

			//=========================保存后控制添加审批流
			//DataSet ds2 = oCN.RunProcReturn("Exec h_p_Gy_RoutingBill_AfterSaveCtrl " + HInterID.ToString() + ", '" + HBillNo + "',2 ", "h_p_Gy_RoutingBill_AfterSaveCtrl");
			//if (ds2 == null)
			//{
			// oCN.RollBack();
			// objJsonResult.code = "0";
			// objJsonResult.count = 0;
			// objJsonResult.Message = "保存后控制判断失败！";
			// objJsonResult.data = null;
			// return objJsonResult;

			//}
			//if (DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBack"]) != "0")
			//{
			// oCN.RollBack();
			// objJsonResult.code = "0";
			// objJsonResult.count = 0;
			// objJsonResult.Message = "保存失败2！" + DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBackRemark"]);
			// objJsonResult.data = null;
			// return objJsonResult;
			//}
			//============================

			LogService.Write("用户:" + user + ",日期:" + DateTime.Now + ",修改工艺路线单据:" + HBillNo);
			oCN.RunProc("Insert into System_log (GeginDate, userid, WorkstationName, WorkList, SystemName, NetuserName, State) select GETDATE(),'" + user + "','" + HComputerName + "','" + "修改工艺路线单据：" + HBillNo + "','LMES-工艺路线模块','" + DBUtility.ClsPub.IPAddress + "','修改单据'", ref DBUtility.ClsPub.sExeReturnInfo);
			}
			//保存子表
			objJsonResult = AddBillSub(msg3, HInterID, OperationType);




			if (objJsonResult.code == "0")
			{
			objJsonResult.code = "0";
			@@ -370,14 +475,16 @@
			}


			if (oSystemParameter.omodel.WMS_CampanyName == "乔一")
			{
			//是否勾选默认工艺路线
			if (HStandard)
			{
			//设置默认工艺路线
			oCN.RunProc("exec h_p_Gy_RoutingBillCheck " + HInterID + ",'" + user + "'");
			}
			}

			//是否勾选默认工艺路线
			//if (HStandard)
			//{
			// //设置默认工艺路线
			// oCN.RunProc("exec h_p_Gy_RoutingBillCheck " + HInterID + ",'" + user + "'");
			//}

			//判断是否重复工序号
			ds = oCN.RunProcReturn("exec h_p_Gy_RoutingCtrl " + HInterID, "h_p_Gy_RoutingCtrl");

			@@ -429,7 +536,7 @@
			foreach (Gy_RoutingBillSub oSub in DetailColl)
			{
			i++;
			if (oSystemParameter.omodel.WMS_CampanyName != "龙山汽配" && oSystemParameter.omodel.WMS_CampanyName != "添康科技")
			if (oSystemParameter.omodel.WMS_CampanyName != "龙山汽配" && oSystemParameter.omodel.WMS_CampanyName != "添康科技" && oSystemParameter.omodel.WMS_CampanyName != "宝工")
			{
			if (oSub.HWorkQty <= 0)
			{
			@@ -456,7 +563,7 @@
			",HPackStd,HPack,HPutArea,HMyWorkDays,HMyFixWorkDays,HPassRate" +
			",HTechnologyParameter,HPicNum,HProcCheckNote" +
			",HOverRate,HProcWorkNum,HBadWHID,HWasterWHID, HWHID,HIsTime,HEstimate " +
			",HWorkTimes_S,HSortProcFlag " +
			",HWorkTimes_S,HSortProcFlag,HSubStdEmpAvg_S,HYDCoefficient" +
			") values("
			+ HInterID + "," + i + "," + oSub.HProcID.ToString() + ",'" + oSub.HProcNo + "'," + oSub.HSupID.ToString() + "," + Convert.ToString(oSub.HSupFlag ? 1 : 0) + "" +
			"," + oSub.HWorkQty.ToString() + "," + oSub.HCenterID.ToString() + ",'" + oSub.HTimeUnit.ToString() + "'," + oSub.HUnitTime.ToString() +
			@@ -469,7 +576,8 @@
			",'" + oSub.HPackStd + "','" + oSub.HPack + "','" + oSub.HPutArea + "'," + oSub.HMyWorkDays.ToString() + "," + oSub.HMyFixWorkDays.ToString() + "," + oSub.HPassRate.ToString() +
			",'" + oSub.HTechnologyParameter.ToString() + "','" + oSub.HPicNum.ToString() + "','" + oSub.HProcCheckNote.ToString() +
			"', " + oSub.HOverRate.ToString() + ",'" + oSub.HProcWorkNum.ToString() + "'," + oSub.HBadWHID.ToString() + "," + oSub.HWasterWHID.ToString() + "," + oSub.HWHID.ToString() + "," + Convert.ToString(oSub.HIsTime ? 1 : 0) + "," + oSub.HEstimate.ToString() +
			", " + oSub.HWorkTimes_S.ToString() + "," + Convert.ToString(oSub.HSortProcFlag ? 1 : 0) +
			", " + oSub.HWorkTimes_S.ToString() + "," + Convert.ToString(oSub.HSortProcFlag ? 1 : 0) + "," + oSub.HSubStdEmpAvg_S +
			"," + oSub.HYDCoefficient +
			") ");
			//计价方式不为计时，则把计时暂估字段更新为空
			if (oSub.HIsTime == false)
			@@ -499,7 +607,7 @@
			",HTechnologyParameter,HPicNum,HProcCheckNote" +
			",HOverRate,HProcWorkNum,HBadWHID,HWasterWHID, HWHID,HEstimate,HIsTime" +
			",HQCSchemeID_Fst,HQCSchemeID_Proc,HQCSchemeID_Patrol" +
			",HWorkTimes_S,HSortProcFlag,HSNCtrl,HQCFst,HQCProc,HQCPatrol,HMaterToSourceCtrl " +
			",HWorkTimes_S,HSortProcFlag,HSNCtrl,HQCFst,HQCProc,HQCPatrol,HMaterToSourceCtrl,HSubStdEmpAvg_S,HYDCoefficient" +
			") values("
			+ HInterID + "," + i + "," + oSub.HProcID.ToString() + ",'" + oSub.HProcNo + "'," + oSub.HSupID.ToString() + "," + Convert.ToString(oSub.HSupFlag ? 1 : 0) + "" +
			"," + oSub.HWorkQty.ToString() + "," + oSub.HCenterID.ToString() + ",'" + oSub.HTimeUnit.ToString() + "'," + oSub.HUnitTime.ToString() +
			@@ -513,7 +621,7 @@
			",'" + oSub.HTechnologyParameter.ToString() + "','" + oSub.HPicNum.ToString() + "','" + oSub.HProcCheckNote.ToString() +
			"', " + oSub.HOverRate.ToString() + ",'" + oSub.HProcWorkNum.ToString() + "'," + oSub.HBadWHID.ToString() + "," + oSub.HWasterWHID.ToString() + "," + oSub.HWHID.ToString() + "," + oSub.HEstimate.ToString() + "," + Convert.ToString(oSub.HIsTime ? 1 : 0) + "," + oSub.HQCSchemeID_Fst + "," +
			oSub.HQCSchemeID_Proc + "," + oSub.HQCSchemeID_Patrol +
			", " + oSub.HWorkTimes_S.ToString() + "," + Convert.ToString(oSub.HSortProcFlag ? 1 : 0) + "," + Convert.ToString(oSub.HSNCtrl ? 1 : 0) + "," + Convert.ToString(oSub.HQCFst ? 1 : 0) + "," + Convert.ToString(oSub.HQCProc ? 1 : 0) + "," + Convert.ToString(oSub.HQCPatrol ? 1 : 0) + "," + Convert.ToString(oSub.HMaterToSourceCtrl ? 1 : 0) +
			", " + oSub.HWorkTimes_S.ToString() + "," + Convert.ToString(oSub.HSortProcFlag ? 1 : 0) + "," + Convert.ToString(oSub.HSNCtrl ? 1 : 0) + "," + Convert.ToString(oSub.HQCFst ? 1 : 0) + "," + Convert.ToString(oSub.HQCProc ? 1 : 0) + "," + Convert.ToString(oSub.HQCPatrol ? 1 : 0) + "," + Convert.ToString(oSub.HMaterToSourceCtrl ? 1 : 0) + "," + oSub.HSubStdEmpAvg_S + "," + oSub.HYDCoefficient +
			") ");
			//计价方式不为计时，则把计时暂估字段更新为空
			if (oSub.HIsTime == false)
			@@ -529,8 +637,8 @@
			}
			}

			//保存后控制========================================= 添加审批流
			ds = oCN.RunProcReturn("exec h_p_Gy_RoutingBill_AfterSaveCtrl " + HInterID, "h_p_Gy_RoutingBill_AfterSaveCtrl");
			////保存后控制========================================= 添加审批流
			ds = oCN.RunProcReturn("exec h_p_Gy_RoutingBill_AfterSaveCtrl " + HInterID + ",'',"+ OperationType, "h_p_Gy_RoutingBill_AfterSaveCtrl");

			if (ds == null \|\| ds.Tables[0].Rows.Count == 0)
			{
			@@ -548,7 +656,7 @@
			objJsonResult.data = null;
			return objJsonResult;
			}
			//=========================================================
			////=========================================================
			}

			objJsonResult.code = "1";
			@@ -558,6 +666,107 @@
			return objJsonResult;
			}

			//工艺路线孙表新增
			[Route("Gy_RoutingBillSub/AddWorkQty")]
			[HttpPost]
			public object AddWorkQty([FromBody] JObject sMainSub)
			{
			try
			{
			var _value = sMainSub["sMainSub"].ToString();
			string msg1 = _value.ToString();

			string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
			string msg2 = sArray[0].ToString();
			string user = sArray[1].ToString();

			//判断是否有编辑权限
			if (!DBUtility.ClsPub.Security_Log("Gy_RoutingBill_Edit", 1, false, user))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "工艺路线无权限编辑!";
			objJsonResult.data = null;
			return objJsonResult;
			}

			List<Gy_RoutingBillSub_WorkQty> DetailColl = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Gy_RoutingBillSub_WorkQty>>(msg2);
			int i = 0;

			oCN.BeginTran();//开始事物

			foreach (Gy_RoutingBillSub_WorkQty oSub in DetailColl)
			{
			i++;

			if (i == 1)
			{
			//先删除历史绑定数据后在重新保存
			oCN.RunProc("delete from Gy_RoutingBillSub_WorkQty where HInterID = " + oSub.HInterID + " and HEntryID = " + oSub.HEntryID);
			};

			oCN.RunProc($"insert into Gy_RoutingBillSub_WorkQty" +
			$"(HInterID,HEntryID,HEntrySubID,HSourceID,HWorkQty_Source,HEntryStdEmpQty,HEntryStdEmpAvg,HSortNum,HRemark)" +
			$"values({oSub.HInterID},{oSub.HEntryID},{i},{oSub.HSourceID},{oSub.HWorkQty_Source},{oSub.HEntryStdEmpQty}" +
			$",{oSub.HEntryStdEmpAvg},{oSub.HSortNum},'{oSub.HRemark}')");
			}

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

			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "保存成功！";
			objJsonResult.data = null;
			return objJsonResult;

			}
			catch (Exception e)
			{
			oCN.RollBack();//回滚事物
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "Exception！" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			#endregion

			#region 工艺路线孙表编辑获取数据
			[Route("Gy_RoutingBill/EditWorkQty")]
			[HttpGet]
			public object EditWorkQty(long HInterID,long HEntryID)
			{
			try
			{

			ds = oCN.RunProcReturn($"select * from h_v_Gy_RoutingBillSub_WorkQtyEdit where hmainid={HInterID} and hsubid={HEntryID} order by HEntrySubID asc", "h_v_Gy_RoutingBillSub_WorkQtyEdit");
			if (ds == null \|\| ds.Tables[0].Rows.Count == 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "false！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			else
			{
			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "Sucess！";
			objJsonResult.data = ds.Tables[0];
			return objJsonResult;
			}
			}
			catch (Exception e)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "Exception！" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			#endregion

			#region 临时定额报表
			@@ -650,7 +859,7 @@
			try
			{

			ds = oCN.RunProcReturn("select a.*,m.HProcPriceType,m.HBeginDate,m.HEndDate,s.HQCProc,s.HQCFst,s.HQCPatrol,s.HMaterToSourceCtrl from h_v_Gy_RoutingBillList as a,Gy_RoutingBillMain as m,Gy_RoutingBillSub as s where m.HInterID = hmainid and s.HInterID = hmainid and s.HEntryID = hsubid and hmainid =" + HInterID, "h_v_Gy_RoutingBillList");
			ds = oCN.RunProcReturn("select a.*,m.HProcPriceType,m.HBeginDate,m.HEndDate,s.HQCProc,s.HQCFst,s.HQCPatrol,s.HMaterToSourceCtrl from h_v_Gy_RoutingBill_Edit as a,Gy_RoutingBillMain as m,Gy_RoutingBillSub as s where m.HInterID = hmainid and s.HInterID = hmainid and s.HEntryID = hsubid and hmainid =" + HInterID, "h_v_Gy_RoutingBillList");
			if (ds == null \|\| ds.Tables[0].Rows.Count == 0)
			{
			objJsonResult.code = "0";
			@@ -1205,6 +1414,598 @@
			}
			#endregion

			#region 工艺路线_孙表文件上传
			[Route("Gy_RoutingBill/Gy_RoutingBillimport_WorkQty")]
			[HttpPost]
			public object Gy_RoutingBillimport_WorkQty()
			{
			try
			{
			var WorkBookName = HttpContext.Current.Request["WorkBookName"];
			DBUtility.ClsPub.HOrgID = long.Parse(HttpContext.Current.Request["HOrgID"]);
			Int64 HOrgID = long.Parse(HttpContext.Current.Request["HOrgID"]);
			//获取文件名称
			var file = HttpContext.Current.Request.Files[0];
			//获取文件物理路径
			string ExcelPath = HttpContext.Current.Server.MapPath("~/" + file.FileName);
			//保存文件
			file.SaveAs(ExcelPath);

			NpoiHelper np = new NpoiHelper();
			DataSet ExcelDs = np.ReadExcel(ExcelPath, 1, 2, WorkBookName);

			//删除文件
			File.Delete(ExcelPath);

			//创建临时表
			DataTable tb2 = new DataTable("dt2");
			DataTable tb3 = new DataTable("dt3");

			//添加列名
			for (int i = 0; i < ExcelDs.Tables[0].Columns.Count; i++)
			{
			tb2.Columns.Add(ExcelDs.Tables[0].Rows[0][i].ToString());
			}

			//添加数据
			for (int i = 1; i < ExcelDs.Tables[0].Rows.Count; i++)
			{
			DataRow row = tb2.NewRow();
			for (int j = 0; j < ExcelDs.Tables[0].Columns.Count; j++)
			{
			row[j] = ExcelDs.Tables[0].Rows[i][j].ToString();
			}
			tb2.Rows.Add(row);
			}


			var error = "";

			//查询工艺路线没有的列
			if (!tb2.Columns.Contains("产品代码"))
			error += "没有找到【产品代码】的标题,";

			if (!tb2.Columns.Contains("工序序号"))
			error += "没有找到【工序序号】的标题,";

			if (!tb2.Columns.Contains("工序"))
			error += "没有找到【工序】的标题,";

			if (!tb2.Columns.Contains("加工数量"))
			error += "没有找到【加工数量】的标题,";

			//if (!tb2.Columns.Contains("工作中心"))
			// error += "没有找到【工作中心】的标题,";

			//if (!tb2.Columns.Contains("本道开工余量"))
			// error += "没有找到【本道开工余量】的标题,";

			//if (!tb2.Columns.Contains("本道固定开工天数"))
			// error += "没有找到【本道固定开工天数】的标题,";

			//if (!tb2.Columns.Contains("班产定额"))
			// error += "没有找到【班产定额】的标题,";

			//if (!tb2.Columns.Contains("工序工价"))
			// error += "没有找到【工序工价】的标题,";

			//if (!tb2.Columns.Contains("工艺参数"))
			// error += "没有找到【工艺参数】的标题,";

			//if (!tb2.Columns.Contains("图纸编号"))
			// error += "没有找到【图纸编号】的标题,";

			//if (!tb2.Columns.Contains("本工序确认记录"))
			// error += "没有找到【本工序确认记录】的标题,";

			//if (!tb2.Columns.Contains("图号版本"))
			// error += "没有找到【图号版本】的标题,";

			//if (!tb2.Columns.Contains("总装图号"))
			// error += "没有找到【总装图号】的标题,";

			//if (!tb2.Columns.Contains("材质"))
			// error += "没有找到【材质】的标题,";

			//if (!tb2.Columns.Contains("成品编号"))
			// error += "没有找到【成品编号】的标题,";

			//if (!tb2.Columns.Contains("版本"))
			// error += "没有找到【版本】的标题,";

			//if (!tb2.Columns.Contains("模具编号"))
			// error += "没有找到【模具编号】的标题,";

			//if (!tb2.Columns.Contains("程序号"))
			// error += "没有找到【程序号】的标题,";

			//if (!tb2.Columns.Contains("良率"))
			// error += "没有找到【良率】的标题";

			//if (!tb2.Columns.Contains("不良品仓"))
			// error += "没有找到【不良品仓】的标题";

			//if (!tb2.Columns.Contains("报废品仓"))
			// error += "没有找到【报废品仓】的标题";

			//if (!tb2.Columns.Contains("良品仓"))
			// error += "没有找到【良品仓】的标题";

			if (!tb2.Columns.Contains("生产资源代码"))
			error += "没有找到【生产资源代码】的标题,";

			//if (!tb2.Columns.Contains("生产资源"))
			// error += "没有找到【生产资源】的标题,";

			if (error.Length > 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = $"Excel模板存在错误,{error}\r\n";
			objJsonResult.data = null;
			return objJsonResult;
			}


			//数据校验
			objJsonResult = (json)Checkdata_WorkQty(tb2);
			if (objJsonResult.code == "0")
			{
			return objJsonResult;
			}

			//删除临时表数据
			oCN.RunProc("delete from diyipi_WorkQty");

			//临时表添加数据
			for (int i = 0; i < tb2.Rows.Count; i++)
			{
			string sql_temp = "insert into diyipi_WorkQty(工艺路线代码,工艺路线名称, 产品代码,产品名称,工序序号,工序代码,工序,工作中心,加工数量" +
			//", 良率, 工序工价, 不合格单价, 报废单价, 本道固定开工天数, 本道开工余量, 上道等待天数" +
			//", 上道循环周期, 自动转移, 外协标记, 供应商代码, 供应商, 工艺参数, 图纸编号" +
			//", 本工序确认记录, 备注, 图号版本, 总装图号, 材质, 成品编号, 版本" +
			//", 模具编号, 程序号, 班产定额, 时间单位,不良品仓,报废品仓,良品仓" +
			",生产资源代码,HOrgID" +
			") " +
			" values(" +
			"'" + tb2.Rows[i]["工艺路线代码"].ToString() + "'" +
			",'" + tb2.Rows[i]["工艺路线名称"].ToString() + "'" +
			",'" + tb2.Rows[i]["产品代码"].ToString() + "'" +
			",'" + tb2.Rows[i]["产品名称"].ToString() + "'" +
			",'" + tb2.Rows[i]["工序序号"].ToString() + "'" +
			",'" + tb2.Rows[i]["工序代码"].ToString() + "'" +
			",'" + tb2.Rows[i]["工序"].ToString() + "'" +
			",'" + tb2.Rows[i]["工作中心"].ToString() + "'" +
			",'" + tb2.Rows[i]["加工数量"].ToString() + "'" +
			//",'" + tb2.Rows[i]["良率"].ToString() + "'" +
			//",'" + (tb2.Rows[i]["工序工价"].ToString() == "" ? "0" : tb2.Rows[i]["工序工价"].ToString()) + "'" +
			//",'" + tb2.Rows[i]["不合格单价"].ToString() + "'" +
			//",'" + tb2.Rows[i]["报废单价"].ToString() + "'" +
			//",'" + tb2.Rows[i]["本道固定开工天数"].ToString() + "'" +
			//",'" + tb2.Rows[i]["本道开工余量"].ToString() + "'" +
			//",'" + tb2.Rows[i]["上道等待天数"].ToString() + "'" +
			//",'" + tb2.Rows[i]["上道循环周期"].ToString() + "'" +
			//",'" + tb2.Rows[i]["自动转移"].ToString() + "'" +
			//",'" + tb2.Rows[i]["外协标记"].ToString() + "'" +
			//",'" + tb2.Rows[i]["供应商代码"].ToString() + "'" +
			//",'" + tb2.Rows[i]["供应商"].ToString() + "'" +
			//",'" + tb2.Rows[i]["工艺参数"].ToString() + "'" +
			//",'" + tb2.Rows[i]["图纸编号"].ToString() + "'" +
			//",'" + tb2.Rows[i]["本工序确认记录"].ToString() + "'" +
			//",'" + tb2.Rows[i]["备注"].ToString() + "'" +
			//",'" + tb2.Rows[i]["图号版本"].ToString() + "'" +
			//",'" + tb2.Rows[i]["总装图号"].ToString() + "'" +
			//",'" + tb2.Rows[i]["材质"].ToString() + "'" +
			//",'" + tb2.Rows[i]["成品编号"].ToString() + "'" +
			//",'" + tb2.Rows[i]["版本"].ToString() + "'" +
			//",'" + tb2.Rows[i]["模具编号"].ToString() + "'" +
			//",'" + tb2.Rows[i]["程序号"].ToString() + "'" +
			//",'" + tb2.Rows[i]["班产定额"].ToString() + "'" +
			//",'" + tb2.Rows[i]["时间单位"].ToString() + "'" +
			//",'" + tb2.Rows[i]["不良品仓"].ToString() + "'" +
			//",'" + tb2.Rows[i]["报废品仓"].ToString() + "'" +
			//",'" + tb2.Rows[i]["良品仓"].ToString() + "'" +
			",'" + tb2.Rows[i]["生产资源代码"].ToString() + "'" +
			"," + HOrgID + "" +
			")";
			oCN.RunProc(sql_temp);
			}

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


			//数据检验
			private object Checkdata_WorkQty(DataTable dt)
			{
			bool b = false;
			string sErrMsg = "";
			string sMsg = "";
			for (int i = 0; i <= dt.Rows.Count - 1; i++)
			{
			string sHNumber = "";
			string sHNamePoc = "";
			string sHNumberCen = "";
			Single sWorkQty = 0;
			Single sHPassRate = 0;
			string sHNumberSource = "";

			sHNumber = DBUtility.ClsPub.isStrNull(dt.Rows[i]["产品代码"].ToString());
			sHNamePoc = DBUtility.ClsPub.isStrNull(dt.Rows[i]["工序序号"].ToString());
			sHNamePoc = DBUtility.ClsPub.isStrNull(dt.Rows[i]["工序"].ToString());
			sWorkQty = DBUtility.ClsPub.isSingle(dt.Rows[i]["加工数量"].ToString());

			//sHNumberCen = DBUtility.ClsPub.isStrNull(dt.Rows[i]["工作中心"].ToString());
			//sHPassRate = DBUtility.ClsPub.isSingle(dt.Rows[i]["良率"].ToString());

			sHNumberSource = DBUtility.ClsPub.isStrNull(dt.Rows[i]["生产资源代码"].ToString());

			if (sHNumber != "")
			{
			//记录检验数据的所在行
			int index = i + 1;

			//得到物料内码
			if (!oMaterHlp.GetInfoByNumber(sHNumber))
			{
			sMsg = "[" + sHNumber + "]物料不存在";
			if (sErrMsg.Contains(sMsg) == false)
			{
			sErrMsg = sErrMsg + "[" + sHNumber + "]物料不存在\r\n";
			}
			b = true;
			}

			//得到工序内码
			if (!oProcHlp.GetInfoByName(sHNamePoc))
			{
			sMsg = "[" + sHNamePoc + "]工序不存在";
			if (sErrMsg.Contains(sMsg) == false)
			{
			sErrMsg = sErrMsg + "[" + sHNamePoc + "]工序不存在\r\n";
			}
			b = true;
			}

			//加工数量不能小于等于零
			if (sWorkQty < 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "第" + index + "行加工数量不能小于等于零！";
			objJsonResult.data = null;
			return objJsonResult;
			}

			////良率不能小于等于零
			//if (sHPassRate <= 0)
			//{
			// objJsonResult.code = "0";
			// objJsonResult.count = 0;
			// objJsonResult.Message = "第" + index + "行良率不能小于等于零！";
			// objJsonResult.data = null;
			// return objJsonResult;
			//}

			////审核代码是否合理
			//if (!DBUtility.ClsPub.AllowNumber(sHNumber))
			//{
			// objJsonResult.code = "0";
			// objJsonResult.count = 0;
			// objJsonResult.Message = "物料代码中不能出现连续‘.’并且首位末位不能为‘.’！";
			// objJsonResult.data = null;
			// return objJsonResult;
			//}


			////得到工作中心内码
			//if (!oCenHlp.GetInfoByName(sHNumberCen))
			//{
			// sMsg = "[" + sHNumberCen + "]工作中心不存在";
			// if (sErrMsg.Contains(sMsg) == false)
			// {
			// sErrMsg = sErrMsg + "[" + sHNumberCen + "]工作中心不存在\r\n";
			// }
			// b = true;
			//}


			//拆分【生产资源代码】，并逐个验证
			if (sHNumberSource != "")
			{
			char[] delimiter = new char[] { ',' };
			string[] sHNumberSourceList = sHNumberSource.Split(delimiter, StringSplitOptions.RemoveEmptyEntries);
			for (int t = 0; t < sHNumberSourceList.Length; t++)
			{
			if (!oSourceHlp.GetInfoByNumber(sHNumberSourceList[t]))
			{
			sMsg = "[" + sHNumberSourceList[t] + "]生产资源不存在";
			if (sErrMsg.Contains(sMsg) == false)
			{
			sErrMsg = sErrMsg + "[" + sHNumberSourceList[t] + "]生产资源不存在\r\n";
			}
			b = true;
			}
			}
			}
			}
			}
			if (b == true)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = sErrMsg;
			objJsonResult.data = null;
			return objJsonResult;
			}
			else
			{
			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = sErrMsg;
			objJsonResult.data = null;
			return objJsonResult;
			}

			}
			#endregion

			#region 工艺路线_孙表导入(保存)
			[Route("Gy_RoutingBill/Gy_RoutingBill_WorkQty_btnSave")]
			[HttpPost]
			public object Gy_RoutingBill_WorkQty_btnSave([FromBody] JObject sMainSub)
			{
			var _value = sMainSub["sMainSub"].ToString();
			string msg1 = _value.ToString();
			oCN.BeginTran();

			//保存主表
			objJsonResult = RoutAddBillMain_WorkQty(msg1);

			if (objJsonResult.code == "0")
			{
			oCN.RollBack();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = objJsonResult.Message;
			objJsonResult.data = null;
			return objJsonResult;
			}

			oCN.Commit();
			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = objJsonResult.Message;
			objJsonResult.data = null;
			return objJsonResult;
			}

			public json RoutAddBillMain_WorkQty(string msg1)
			{
			string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
			string msg2 = sArray[0].ToString();
			string msg3 = sArray[1].ToString();
			string user = sArray[2].ToString();

			try
			{
			if (!DBUtility.ClsPub.Security_Log("Gy_RoutingBill_Edit", 1, false, user))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "无保存权限！";
			objJsonResult.data = null;
			return objJsonResult;
			}

			//表头字段
			omdelMian = Newtonsoft.Json.JsonConvert.DeserializeObject<Gy_RoutingBill_temporary>(msg2);

			string finalErrMsg = "";

			//获取导入表中的最新数据
			DataSet dsMain = oCN.RunProcReturn("select distinct 产品代码 from diyipi_WorkQty", "diyipi_WorkQty");
			if (dsMain.Tables[0].Rows.Count > 0)
			{
			for(int i=0;i< dsMain.Tables[0].Rows.Count; i++)
			{
			string HMaterNumber = DBUtility.ClsPub.isStrNull(dsMain.Tables[0].Rows[0]["产品代码"]);
			if (!oMaterHlp.GetInfoByNumber(HMaterNumber))
			{
			string sMsg = "物料【" + HMaterNumber + "】不存在！";
			if (finalErrMsg.Contains(sMsg) == false)
			{
			finalErrMsg = finalErrMsg + "物料【" + HMaterNumber + "】不存在！\r\n";
			}
			continue;
			}

			//获取该物料导入的数据中是否存在多个工艺路线，如果存在，则报错
			string HBillNo = "";
			Int64 HInterID = 0;
			DataSet dsHBillNo = oCN.RunProcReturn("select distinct 工艺路线代码,工艺路线名称 from diyipi_WorkQty where 产品代码 = '" + HMaterNumber + "'", "diyipi_WorkQty");
			if (dsHBillNo.Tables[0].Rows.Count > 1)
			{
			string sMsg = "物料【" + HMaterNumber + "】存在多组【工艺路线代码，工艺路线名称】！";
			if (finalErrMsg.Contains(sMsg) == false)
			{
			finalErrMsg = finalErrMsg + "物料【" + HMaterNumber + "】存在多组【工艺路线代码，工艺路线名称】！\r\n";
			}
			continue;
			}
			else //物料对应工艺路线唯一，获取工艺路线主内码与工艺路线代码
			{
			//生成唯一的工艺路线代码
			HBillNo = DBUtility.ClsPub.isStrNull(dsHBillNo.Tables[0].Rows[0]["工艺路线代码"]);
			if (HBillNo == "")
			{
			DataSet dataSet = oCN.RunProcReturn($"select HBillNo from Gy_RoutingBillMain where HBillNo='1' ", "Gy_RoutingBillMain");
			while (1 == 1)
			{
			if (HBillNo != "")
			{
			if (dataSet.Tables[0].Rows.Count == 0)
			{
			break;
			}
			}
			HBillNo = DBUtility.ClsPub.CreateBillCode(BillType, ref DBUtility.ClsPub.sExeReturnInfo, true);
			dataSet = oCN.RunProcReturn($"select HBillNo from Gy_RoutingBillMain where HBillNo='{HBillNo}' ", "Gy_RoutingBillMain");
			}
			}

			//生成唯一的工艺路线内码
			if (HInterID == 0)
			{
			while (1 == 1)
			{
			HInterID = DBUtility.ClsPub.CreateBillID_Prod(BillType, ref DBUtility.ClsPub.sExeReturnInfo);//获得一个新的id
			DataSet dataSet = oCN.RunProcReturn("select * from Gy_RoutingBillMain where HInterID=" + HInterID, "Gy_RoutingBillMain");
			if (dataSet.Tables[0].Rows.Count == 0)
			{
			break;
			}
			}
			}
			}

			//拼接主表插入语句
			string sqlMain = "insert into Gy_RoutingBillMain" +
			"(HInterID,HYear,HPeriod,HBillType,HBillNo,HName,HDate,HMaker,HMakeDate,HRemark,HOrgID" +
			",HMaterID,HMaterNumber,HUnitID,HUnitNumber,HStandard,HRoutingGroupID) " +
			"values(" +
			"" + HInterID + "" +
			"," + DateTime.Now.Year + "" +
			"," + DateTime.Now.Month + "" +
			",'" + BillType + "'" +
			",'" + HBillNo + "'" +
			", ''" +
			"," + "convert(varchar(100),getdate(),23)" + "" +
			",'" + user + "'" +
			", getdate()" +
			",'" + "批量导入(包含孙表)" + "'" +
			"," + omdelMian.HOrgID +
			"," + oMaterHlp.omodel.HItemID + "" +
			",'" + oMaterHlp.omodel.HNumber + "'" +
			"," + oMaterHlp.omodel.HUnitID + "" +
			",'" + oMaterHlp.omodel.HUnitNumber + "'" +
			"," + 1 + "" +
			"," + 0 + "" +
			")";

			//获取该物料的工艺路线信息子表数据
			DataSet dsSub = oCN.RunProcReturn("select * from diyipi_WorkQty where 产品代码 = '" + HMaterNumber + "' order by 工序序号", "diyipi_WorkQty");
			for(int j = 0; j < dsSub.Tables[0].Rows.Count; j++)
			{
			string HProcNumber = DBUtility.ClsPub.isStrNull(dsSub.Tables[0].Rows[j]["工序代码"]);
			//得到工序内码
			if (!oProcHlp.GetInfoByNumber(HProcNumber))
			{
			string sMsg = "工序【" + HProcNumber + "】不存在！";
			if (finalErrMsg.Contains(sMsg) == false)
			{
			finalErrMsg = finalErrMsg + "工序【" + HProcNumber + "】不存在！\r\n";
			}
			continue;
			}
			else
			{
			string sqlSub = "insert into Gy_RoutingBillSub" +
			"(HInterID,HEntryID,HProcNo,HProcID,HCenterID,HWorkQty,HSortProcFlag,HRemark,HTimeUnit,HReadyTime,HQueueTime,HMoveTime) " +
			"values(" +
			"" + HInterID + "" +
			"," + (j + 1) + "" +
			"," + DBUtility.ClsPub.isLong(dsSub.Tables[0].Rows[j]["工序序号"]) +
			"," + oProcHlp.omodel.HItemID + "" +
			"," + 0 + "" +
			"," + DBUtility.ClsPub.isDoule(dsSub.Tables[0].Rows[j]["加工数量"]) +
			",1" +
			",'批量导入(包括孙表)'" +
			", 0" +
			", 0" +
			", 0" +
			", 0" +
			")";

			char[] delimiter = new char[] { ',' };
			string HSourceNumberList = DBUtility.ClsPub.isStrNull(dsSub.Tables[0].Rows[j]["生产资源代码"]);
			string[] sHNumberSourceList = HSourceNumberList.Split(delimiter, StringSplitOptions.RemoveEmptyEntries);
			for(int t = 0; t < sHNumberSourceList.Length; t++)
			{
			//得到生产资源内码
			if (!oSourceHlp.GetInfoByNumber(sHNumberSourceList[t]))
			{
			string sMsg = "生产资源【" + HProcNumber + "】不存在！";
			if (finalErrMsg.Contains(sMsg) == false)
			{
			finalErrMsg = finalErrMsg + "生产资源【" + HProcNumber + "】不存在！\r\n";
			}
			continue;
			}
			else
			{
			string sqlSub_WorkQty = "insert into Gy_RoutingBillSub_WorkQty" +
			"(HInterID,HEntryID,HEntrySubID,HRemark,HSourceID) " +
			"values(" +
			"" + HInterID + "" +
			"," + (j+1) + "" +
			"," + (t+1) + "" +
			", '批量导入(包括孙表)'" +
			"," + oSourceHlp.omodel.HItemID + "" +
			")";

			oCN.RunProc(sqlSub_WorkQty);
			}
			}
			oCN.RunProc(sqlSub);
			}
			}
			oCN.RunProc(sqlMain);
			oCN.RunProc("update Gy_RoutingBillMain set HStandard = 0 where HMaterID = " + oMaterHlp.omodel.HItemID + " and HInterID <>" + HInterID);
			}
			}

			if (finalErrMsg.Length > 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = finalErrMsg;
			objJsonResult.data = null;
			return objJsonResult;
			}

			oCN.RunProc("delete from diyipi_WorkQty");

			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "导入完成,共" + dsMain.Tables[0].Rows.Count + "个工艺路线";
			objJsonResult.data = null;
			return objJsonResult;
			}
			catch (Exception e)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "Exception！" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			#endregion

			#region 工艺路线审核、反审核
			/// <summary>
			///
			@@ -1212,7 +2013,7 @@
			/// <param name="HInterID">单据ID</param>
			/// <param name="IsAudit">审核(0),反审核(1)</param>
			/// <param name="CurUserName">审核人</param>
			/// <returns></returns>
			/// <returns></returns>Gy_RoutingBill/CheckGy_RoutingBill
			[Route("Gy_RoutingBill/AuditGy_RoutingBill")]
			[HttpGet]
			public object AuditGy_RoutingBill(string HInterID, int IsAudit, string CurUserName)
			@@ -1268,7 +2069,60 @@

			if (IsAudit == 0) //审核判断
			{

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

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

			//审核工艺路线
			oCN.RunProc("update Gy_RoutingBillMain set HChecker='" + CurUserName + "',HCheckDate=getdate(),HBillStatus=2 where HInterID=" + HInterID);


			//审核后控制=========================================
			string sql2 = "exec h_p_Gy_RoutingBill_AfterCheckCtrl " + HInterID + ",'" + ds.Tables[0].Rows[0]["HBillNo"].ToString() + "','" + CurUserName + "'";
			ds = oCN.RunProcReturn(sql1, "h_p_Gy_RoutingBill_AfterCheckCtrl");
			if (ds == null \|\| ds.Tables.Count == 0 \|\| ds.Tables[0].Rows.Count == 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "审核失败!原因:审核后判断失败，请与网络管理人员联系";
			objJsonResult.data = null;
			oCN.RollBack();
			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;
			oCN.RollBack();
			return objJsonResult;
			}
			//==================================================================================



			//获取系统参数
			string Ret = "";
			@@ -1289,8 +2143,58 @@
			}
			if (IsAudit == 1) //反审核判断
			{
			//反审核前控制=========================================
			string sql1 = "exec h_p_Gy_Routing_BeforeUnCheckCtrl " + HInterID + ",'" + ds.Tables[0].Rows[0]["HBillNo"].ToString() + "','" + CurUserName + "'";
			var ds2 = oCN.RunProcReturn(sql1, "h_p_Gy_Routing_BeforeUnCheckCtrl");
			if (ds2 == null \|\| ds2.Tables.Count == 0 \|\| ds2.Tables[0].Rows.Count == 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "审核失败!原因:反审核前判断失败，请与网络管理人员联系";
			objJsonResult.data = null;
			oCN.RollBack();
			return objJsonResult;
			}

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

			//反审核工艺路线
			oCN.RunProc("update Gy_RoutingBillMain set HChecker='',HCheckDate=null where HInterID=" + HInterID);

			//反审核后控制=========================================
			string sql2 = "exec h_p_Gy_RoutingBill_AfterUnCheckCtrl " + HInterID + ",'" + ds.Tables[0].Rows[0]["HBillNo"].ToString() + "','" + CurUserName + "'";
			ds = oCN.RunProcReturn(sql1, "h_p_Gy_RoutingBill_AfterUnCheckCtrl");
			if (ds == null \|\| ds.Tables.Count == 0 \|\| ds.Tables[0].Rows.Count == 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "审核失败!原因:反审核后判断失败，请与网络管理人员联系";
			objJsonResult.data = null;
			oCN.RollBack();
			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;
			oCN.RollBack();
			return objJsonResult;
			}
			//==================================================================================


			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "反审核成功";
			@@ -1339,6 +2243,16 @@
			var ds = oCN.RunProcReturn("select * from Gy_RoutingBillMain where HInterID=" + HInterID, "Gy_RoutingBillMain");
			if (ds.Tables[0].Rows.Count > 0)
			{
			string HBillStatus = Convert.ToString(ds.Tables[0].Rows[0]["HBillStatus"]);
			//string hdeleteman = Convert.ToString(ds.Tables[0].Rows[0]["hdeleteman"]);
			if (HBillStatus == "6")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "单据在审核中,不能关闭！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			if (IsAudit == 0) //关闭判断
			{
			if (ds.Tables[0].Rows[0]["HCloseMan"].ToString() != "")
			@@ -1406,6 +2320,194 @@
			}
			}
			#endregion

			#region 工艺路线作废/反作废
			/// <summary>
			/// </summary>
			/// <param name="HInterID">单据ID</param>
			/// <param name="IsAudit">作废(0),反作废(1)</param>
			/// <param name="CurUserName">作废人</param>
			/// <returns></returns>
			[Route("Gy_RoutingBill/DeleteGy_RoutingBill")]
			[HttpGet]
			public object DeleteOA_AndengFlowRuleBill(int HInterID, int IsAudit, string CurUserName)
			{
			string ModRightNameCheck = "Gy_RoutingBill_Delete";
			DBUtility.ClsPub.CurUserName = CurUserName;
			try
			{
			//检查权限
			if (!DBUtility.ClsPub.Security_Log_second(ModRightNameCheck, 1, false, CurUserName))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "作废失败！无权限！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			//HInterID数据判断
			if (HInterID <= 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "HInterID小于0！";
			objJsonResult.data = null;
			return objJsonResult;
			}


			Int64 lngBillKey = 0;
			lngBillKey = DBUtility.ClsPub.isLong(HInterID); //对HInterID进行类型的转换
			DAL.ClsGy_RoutingBill oBill = new DAL.ClsGy_RoutingBill(); //实例化单据操作类，用于进行相关操作

			//针对需要进行的操作，检验当前单据的状态是否支持需要进行的操作
			if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo)) //根据HInterID获取该单据的数据
			{
			if (oBill.omodel.HChecker.Trim() != "")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "单据已审核!不能进行作废！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			if (IsAudit == 1) //作废判断
			{
			if (oBill.omodel.HDeleteMan.Trim() != "")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "单据已作废!不能再作废！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			if (IsAudit == 2) //反作废判断
			{
			if (oBill.omodel.HDeleteMan.Trim() == "")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "单据未作废!不需要反作废！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			}
			else
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "单据不存在!原因:" + DBUtility.ClsPub.sExeReturnInfo;
			objJsonResult.data = null;
			return objJsonResult;
			}


			//进行需要进行的作废/反作废操作
			if (IsAudit == 1) //作废提交
			{
			//作废前控制=========================================
			string sql1 = "exec h_p_Gy_RoutingBill_BeforeDropCtrl " + oBill.omodel.HInterID + ",'" + oBill.omodel.HBillNo + "','" + CurUserName + "'";
			ds = oCN.RunProcReturn(sql1, "h_p_Gy_RoutingBill_BeforeDropCtrl");
			if (ds == null \|\| ds.Tables.Count == 0 \|\| ds.Tables[0].Rows.Count == 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "审核失败!原因:审核前判断失败，请与网络管理人员联系";
			objJsonResult.data = null;
			oCN.RollBack();
			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;
			oCN.RollBack();
			return objJsonResult;
			}
			//==================================================================================


			//作废提交
			if (oBill.Cancelltion(lngBillKey, oBill.omodel.HBillNo, "h_p_Gy_RoutingBill_AfterDropCtrl", CurUserName, ref DBUtility.ClsPub.sExeReturnInfo) == true)
			{
			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "作废成功";
			objJsonResult.data = null;
			return objJsonResult;
			}
			else
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "作废失败!原因:" + DBUtility.ClsPub.sExeReturnInfo;
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			if (IsAudit == 2) //反作废提交
			{
			//反作废前控制=========================================
			string sql1 = "exec h_p_Gy_RoutingBill_BeforeUnDropCtrl " + oBill.omodel.HInterID + ",'" + oBill.omodel.HBillNo + "','" + CurUserName + "'";
			ds = oCN.RunProcReturn(sql1, "h_p_Gy_RoutingBill_BeforeUnDropCtrl");
			if (ds == null \|\| ds.Tables.Count == 0 \|\| ds.Tables[0].Rows.Count == 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "作废失败!原因:反作废前判断失败，请与网络管理人员联系";
			objJsonResult.data = null;
			oCN.RollBack();
			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;
			oCN.RollBack();
			return objJsonResult;
			}
			//==================================================================================


			//反关闭提交
			if (oBill.AbandonCancelltion(lngBillKey, oBill.omodel.HBillNo, "h_p_Gy_RoutingBill_AfterUnDropCtrl", CurUserName, ref DBUtility.ClsPub.sExeReturnInfo) == true)
			{
			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "反作废成功";
			objJsonResult.data = null;
			return objJsonResult;
			}
			else
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "反作废失败!原因:" + DBUtility.ClsPub.sExeReturnInfo;
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			return objJsonResult;
			}
			catch (Exception e)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "作废失败或者反作废失败！" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			#endregion


			#region 工艺路线列表主表
			/// <summary>
			@@ -1567,7 +2669,7 @@
			" LEFT JOIN Gy_RoutingBillMain as po ON a.hmainid = po.HInterID" +
			" LEFT JOIN Xt_CheckItem as i ON i.HItemID = c.HCheckItemID" +
			" LEFT JOIN Xt_CheckUserRight as cr ON cr.HCheckItemID = i.HItemID and cr.HCheckFlowInterID = m.HInterID" +
			" where po.HBillStatus = 6 and po.HCheckItemNowID = i.HItemID and cr.HUserID = '" + userid + "'";
			" where 工序代码 != '9999' and a.HBillSubType<>'SUB' and po.HBillStatus = 6 and po.HCheckItemNowID = i.HItemID and cr.HUserID = '" + userid + "'";
			ds = oCN.RunProcReturn(sql, "h_v_Gy_RoutingBillList");
			foreach (DataColumn col in ds.Tables[0].Columns)
			{
			@@ -1614,10 +2716,11 @@
			return objJsonResult;
			}
			//搜索需要审核的
			string sql = " select DISTINCT a.*,c.HItemID as HCheckFlowStatusID,m.HName as 审批流,c.HCheckFlowID,i.HName as 审批项目名称,c.HCheckItemID,c.HChecker as 项目审核人,c.HCheckNote as 审批流审核建议,c.HCheckDate 审批流审核日期 from h_v_Gy_RoutingBillList AS a LEFT JOIN Xt_BillCheckFlowStatus AS c ON a.hmainid = c.HBillInterID and a.单据类型 = c.HBillTypeID" +
			string sql = "select TOP 1000 a.*,c.HItemID as HCheckFlowStatusID,m.HName as 审批流,c.HCheckFlowID,i.HName as 审批项目名称,c.HCheckItemID,c.HChecker as 项目审核人,c.HCheckNote as 审批流审核建议,c.HCheckDate 审批流审核日期 from h_v_Gy_RoutingBillList AS a LEFT JOIN Xt_BillCheckFlowStatus AS c ON a.hmainid = c.HBillInterID and a.单据类型 = c.HBillTypeID" +
			" LEFT JOIN Xt_CheckFlowMain as m ON m.HInterID = c.HCheckFlowID" +
			" LEFT JOIN Xt_CheckItem as i ON i.HItemID = c.HCheckItemID" +
			" where c.HCheckDate is not NUll and c.HChecker = '" + user + "'";
			" where 工序代码 != '9999' and a.HBillSubType<>'SUB' and c.HCheckDate is not NUll and c.HChecker = '" + user + "'"+
			" ORDER BY a.hmainid DESC;";
			ds = oCN.RunProcReturn(sql, "h_v_Gy_RoutingBillList");
			foreach (DataColumn col in ds.Tables[0].Columns)
			{
			@@ -2037,6 +3140,17 @@
			objJsonResult.count = CountConstant.SUCCEED;
			objJsonResult.Message = "审核成功";
			objJsonResult.data = null;
			//获取系统参数
			string Ret = "";
			if (oSystemParameter.ShowBill(ref Ret))
			{
			//判断客户
			if (oSystemParameter.omodel.WMS_CampanyName == "添康科技") //系统参数
			{
			//刷新默认工艺路线
			oCN.RunProc("exec h_p_Gy_RoutingBillCheck " + HInterID + ",'" + CurUserName + "'");
			}
			}
			}
			else
			{
			@@ -2292,7 +3406,7 @@
			return objJsonResult;
			}
			SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
			ds = oCN.RunProcReturn("select * from h_v_Gy_RoutingBillList where 定额类型 = '临时定额' and 失效时间 BETWEEN DATEADD(DAY, -15, GETDATE()) AND GETDATE() " + sWhere + " order by hmainid desc", "h_v_Gy_RoutingBillList");
			ds = oCN.RunProcReturn("select * from h_v_Gy_RoutingBillList where 定额类型 = '临时定额' and 状态!= '关闭' and 失效时间 BETWEEN CAST(GETDATE() AS DATE) AND DATEADD(DAY, 15, GETDATE()) " + sWhere + " order by hmainid desc", "h_v_Gy_RoutingBillList");
			foreach (DataColumn col in ds.Tables[0].Columns)
			{
			Type dataType = col.DataType;
			@@ -2338,7 +3452,6 @@
			objJsonResult = (json)AuditGy_Routing_Flow(idArray[i], IsAudit, CurUserName, CurUserID);//审核执行
			if (objJsonResult.count == 0)
			{
			oCN.RollBack();
			objJsonResult.Message += "第" + (i + 1) + "行出现问题无法继续完成";
			return objJsonResult;
			}
			@@ -2371,5 +3484,161 @@
			}
			#endregion

			#region 工艺路线批量驳回
			[Route("Gy_Routing/RejectAllCheckFlow")]
			[HttpGet]
			public object RejectAllCheckFlow(string HInterIDS,string CurUserID)
			{
			try
			{
			//处理字符串
			if (!string.IsNullOrEmpty(HInterIDS))
			{
			int[] idArray = Array.ConvertAll(HInterIDS.Split(','), int.Parse);
			// 处理idArray...
			for (int i = 0; i < idArray.Length; i++)
			{
			objJsonResult = (json)RejectCheckFlow(idArray[i].ToString(),CurUserID);//审核执行
			if (objJsonResult.count == 0)
			{
			objJsonResult.Message += "第" + (i + 1) + "行出现问题无法继续完成";
			return objJsonResult;
			}
			}
			}
			else
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "请选择正确行";
			objJsonResult.data = null;
			return objJsonResult;
			}

			objJsonResult.code = CodeConstant.SUCCEED;
			objJsonResult.count = CountConstant.SUCCEED;
			objJsonResult.Message = "执行成功！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			catch (Exception e)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "驳回工艺路线失败！" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			#endregion

			#region 工艺路线撤回
			[Route("Gy_Routing/WithdrawCheckFlow")]
			[HttpGet]
			public object WithdrawCheckFlow(string HInterID, string user)
			{
			try
			{
			Int64 lngBillKey = 0;
			lngBillKey = DBUtility.ClsPub.isLong(HInterID); //对HInterID进行类型的转换
			DAL.ClsGy_RoutingBill oBill = new DAL.ClsGy_RoutingBill(); //实例化单据操作类，用于进行相关操作
			//获取系统参数判断工艺路线是否启用多级审批禁用
			Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter();
			string sReturn = "";
			if (oSystemParameter.ShowBill(ref sReturn) == true)
			{
			if (oSystemParameter.omodel.Gy_RoutingBill_EnableMultiLevel.ToUpper() == "N") //系统参数未启用自动审核
			{
			objJsonResult.code = CodeConstant.FAIL;
			objJsonResult.count = CountConstant.FAIL;
			objJsonResult.Message = "工艺路线未启用多级审批禁用";
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo)) //根据HInterID获取该单据的数据
			{
			if (oBill.omodel.HBillStatus != 6)
			{
			objJsonResult.code = CodeConstant.FAIL;
			objJsonResult.count = CountConstant.FAIL;
			objJsonResult.Message = "单据未在审核中不能撤回";
			objJsonResult.data = null;
			return objJsonResult;
			}
			//判断是否有编辑权限
			if (!DBUtility.ClsPub.Security_Log("Gy_RoutingBill_Edit", 1, false, user))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "工艺路线无权限撤回!";
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			else
			{
			objJsonResult.code = CodeConstant.FAIL;
			objJsonResult.count = CountConstant.FAIL;
			objJsonResult.Message = "单据不存在!原因:" + DBUtility.ClsPub.sExeReturnInfo;
			objJsonResult.data = null;
			return objJsonResult;
			}
			//判断是否存在审核过的项目
			string sql0 = "select * from Xt_BillCheckFlowStatus where HBillInterID = " + lngBillKey + " and HBillTypeID = '" + oBill.BillType + "' and ISNULL(HChecker,'') <> ''";
			DataSet ds0 = oCN.RunProcReturn(sql0, "Xt_BillCheckFlowStatus");
			if (ds0 != null && ds0.Tables[0].Rows.Count == 0)
			{
			oCN.BeginTran();
			//获取需要驳回的审核项目
			string sql1 = "select c.* from Xt_CheckFlowMain as a " +
			"inner join Xt_CheckFlowSub as b on a.HInterID = b.HInterID " +
			"inner join Xt_BillCheckFlowStatus as c on a.HBillTypeID = c.HBillTypeID and b.HCheckItemID = c.HCheckItemID " +
			"where c.HBillTypeID = '" + this.BillType + "' and c.HBillInterID = " + lngBillKey + " " +
			"order by b.HFlowNo asc";
			DataSet ds1= oCN.RunProcReturn(sql1, "Xt_BillCheckFlowStatus");
			if (ds1 == null \|\| ds1.Tables[0].Rows.Count == 0)
			{
			sReturn = "撤回失败!原因:未发起审批！！";
			return false;
			}
			//获取当前审核项目
			string HCheckFlowID = ds1.Tables[0].Rows[0]["HCheckFlowID"].ToString(); //审批流内码
			sql0 = "select * from Gy_RoutingBillMain " + " where HInterID = " + lngBillKey;
			ds0 = oCN.RunProcReturn(sql0, "Gy_RoutingBillMain");
			string HCheckItemNowID = ds0.Tables[0].Rows[0]["HCheckItemNowID"].ToString(); //当前审批项目内码
			//更新驳回删除审核流状态表
			string sql02 = "Delete Xt_BillCheckFlowStatus where HBillTypeID = '" + this.BillType + "' and HBillInterID=" + lngBillKey + " and HCheckFlowID=" + HCheckFlowID;
			oCN.RunProc(sql02);
			oCN.RunProc(" Update Gy_RoutingBillMain" + " set HChecker='',HCheckDate=null,HBillStatus=1,HCheckItemNowID = 0,HCheckItemNextID = 0 Where HInterID=" + lngBillKey.ToString());
			oCN.Commit();
			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "撤回成功！";
			objJsonResult.data = null;
			return objJsonResult; ;
			}
			else
			{
			objJsonResult.code = CodeConstant.FAIL;
			objJsonResult.count = CountConstant.FAIL;
			objJsonResult.Message = "撤回失败!原因:单据存在已经审核的项目！！";
			objJsonResult.data = null;
			return objJsonResult;
			}

			}
			catch (Exception e)
			{
			oCN.RollBack();
			objJsonResult.code = CodeConstant.FAIL;
			objJsonResult.count = CountConstant.FAIL;
			objJsonResult.Message = "Exception！" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			#endregion

			}
			}