MES-WEB-API.git

			@@ -1065,7 +1065,7 @@

			SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
			string sql = string.Format(@"exec h_p_Sc_GetProcessExchangeBillSubTech ");
			ds = oCN.RunProcReturn(sql + HInterID, "h_p_Sc_GetProcessExchangeBillSubTech");
			ds = oCN.RunProcReturn(sql + " '" + HInterID + "'", "h_p_Sc_GetProcessExchangeBillSubTech");

			//添加列名
			foreach (DataColumn col in ds.Tables[0].Columns)
			@@ -1170,7 +1170,7 @@

			string sql = string.Format(@"select * from h_v_Sc_ProcessExchangeBillQuerySub");

			ds = oCN.RunProcReturn(sql + " where hmainid=" + HInterID + " and 出站关联数量=0 and cast(流水号 as int)>" + ds1 .Tables[0].Rows[0][0].ToString(), "h_v_Sc_ProcessExchangeBillQuerySub");
			ds = oCN.RunProcReturn(sql + " where hmainid=" + HInterID + " and 出站关联数量=0 and cast(流水号 as int)>" + ds1 .Tables[0].Rows[0][0].ToString()+ " order by cast(流水号 as int) ", "h_v_Sc_ProcessExchangeBillQuerySub");

			if (float.Parse(ds.Tables[0].Rows[0]["进站关联数量"].ToString()) > 0)
			{
			@@ -1246,9 +1246,9 @@
			objJsonResult.data = 1;
			return objJsonResult;
			}

			int num = oItem.HBillNo.Split('-').Length;
			oBill.omodel.HMaker = msg5; //制单人
			oBill.omodel.HNo = DBUtility.ClsPub.isLong(oItem.HBillNo.Split('-')[1]);
			oBill.omodel.HNo = DBUtility.ClsPub.isLong(oItem.HBillNo.Split('-')[num - 1]);
			oBill.omodel.HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year);
			oBill.omodel.HPeriod = DBUtility.ClsPub.isLong(DateTime.Now.Month);
			oBill.omodel.HDate = oItem.HDate;// 日期
			@@ -1312,7 +1312,6 @@
			j++;
			}
			}


			//保存
			//保存完毕后处理
			@@ -1912,7 +1911,6 @@
			}
			#endregion


			#region 工序流转卡列表
			/// <summary>
			/// 获取工序流转卡列表信息
			@@ -1966,5 +1964,367 @@
			}
			#endregion

			#region[批量拆分生成流转卡]
			/// <summary>
			/// 返回拆分后的生产订单信息
			/// </summary>
			/// <param name="hmainid">生产任务单主子ID</param>
			/// <returns>object</returns>
			[Route("Sc_ProcessExchangeBill/BatchSpilt")]
			[HttpGet]
			public object BatchSpilt(string HInterID, string user)
			{
			try
			{
			if (string.IsNullOrWhiteSpace(HInterID))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "源单主子id为空！";
			objJsonResult.data = null;
			return objJsonResult;
			}

			string[] HInterEntryIDArr = HInterID.Split(',');

			DataTable dt = new DataTable();

			for (int i = 0; i < HInterEntryIDArr.Length; i++)
			{
			string[] HIDs = HInterEntryIDArr[i].Split('@');

			string sql = "exec h_p_Sc_ProcessExchange_BatchSplit '" + HIDs[0] + "','" + HIDs[1] + "'";

			ds = oCN.RunProcReturn(sql, "h_p_Sc_ProcessExchange_BatchSplit");

			if (i == 0)
			{
			dt = ds.Tables[0];
			}
			else
			{
			foreach (DataRow item in ds.Tables[0].Rows)
			{
			DataRow dataRow = dt.NewRow();
			dataRow.ItemArray = item.ItemArray;
			dt.Rows.Add(dataRow);
			}
			}
			}

			if (dt == null \|\| dt.Rows.Count == 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "拆分生产订单无数据！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			else
			{
			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "Sucess！";
			objJsonResult.data = dt;
			return objJsonResult;
			}
			}
			catch (Exception e)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "Exception！" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			#endregion

			#region[批量拆分下推-保存按钮]
			/// <summary>
			/// 新增单据-保存按钮
			///参数：string sql。
			///返回值：object。
			/// </summary>
			[Route("Sc_ProcessExchangeBill/AddBill_BatchSplit")]
			[HttpPost]
			public object AddBill_BatchSplit([FromBody] JObject sMainSub)
			{
			var _value = sMainSub["sMainSub"].ToString();
			string msg1 = _value.ToString();
			string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
			string msg2 = sArray[0].ToString();//明细行信息
			string HUser = sArray[1].ToString();//用户
			string HComputerName = SystemInformation.ComputerName; //设备名称

			string UserName = "";
			ListModels oListModels = new ListModels();
			bool bResult = true;

			try
			{
			if (!DBUtility.ClsPub.Security_Log("Sc_ProcessExchangeBill_Edit", 1, false, HUser))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "流转卡无保存权限！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			DAL.ClsSc_ProcessExchangeBill oBill = new DAL.ClsSc_ProcessExchangeBill();
			//表体数据
			//按 },{来拆分数组 //去掉【和】
			msg2 = msg2.Substring(1, msg2.Length - 2);
			msg2 = msg2.Replace("\\", "");
			msg2 = msg2.Replace("\n", ""); //\n
			//msg2 = msg2.Replace("'", "’");
			List<Model.ClsSc_ProcessExchangeBillSub_BatchSplit> ls = new List<Model.ClsSc_ProcessExchangeBillSub_BatchSplit>();
			ls = oListModels.getObjectByJson_Sc_ProcessExchangeBillSub_BatchSplit(msg2);

			DateTime dt = DateTime.Now;
			string sql = "";
			Int64 HInterID = 0;
			string HBillNo = "";
			Int64 HICMOInterID = 0;
			Int64 HICMOEntryID = 0;
			string HICMOBillNo = "";
			double HQty = 0;
			double HProQty = 0;

			foreach (Model.ClsSc_ProcessExchangeBillSub_BatchSplit oItemSub in ls)
			{
			//HBillNo = DBUtility.ClsPub.CreateBillCode_Prod("3772", ref DBUtility.ClsPub.sExeReturnInfo, true);
			HInterID = oItemSub.HInterID;
			HBillNo = oItemSub.HBillNo;
			HICMOInterID = oItemSub.HICMOInterID;
			HICMOEntryID = oItemSub.HICMOEntryID;
			HICMOBillNo = oItemSub.HICMOBillNo;
			HQty = oItemSub.HQty;
			HProQty = oItemSub.HProQty;

			sql = "select * from h_v_Sc_ProcessExchangeBill_BatchSplit where hmainid = " + oItemSub.HICMOInterID + " and hentryid = "
			+ oItemSub.HICMOEntryID;
			ds = oCN.RunProcReturn(sql, "h_v_Sc_ProcessExchangeBill_BatchSplit");
			//主表赋值
			if (ds.Tables[0].Rows.Count > 0 && ds != null)
			{
			oBill.omodel.HInterID = HInterID;
			oBill.omodel.HBillNo = HBillNo;
			oBill.omodel.HBillSubType = "3772";
			oBill.omodel.HMainSourceBillSubType = "3710";
			oBill.omodel.HDate = oItemSub.HDate;
			oBill.omodel.HMaker = HUser;
			oBill.omodel.HMakeDate = System.DateTime.Now.ToString("G");
			oBill.omodel.HPrevMainSourceInterID = 0;
			oBill.omodel.HYear = DBUtility.ClsPub.isLong(oItemSub.HDate.Year);
			oBill.omodel.HPeriod = DBUtility.ClsPub.isLong(oItemSub.HDate.Month);
			oBill.omodel.HRemark = "";
			oBill.omodel.HBatchNo = oItemSub.HBatchNo;
			oBill.omodel.HMainMaterID = 0;
			oBill.omodel.HKeyMaterID = 0;
			oBill.omodel.HNo = 0;
			oBill.omodel.HOrderProcNO = ds.Tables[0].Rows[0]["HPlanOrderProcNo"].ToString();
			oBill.omodel.HWWOrderInterID = 0;
			oBill.omodel.HWWOrderEntryID = 0;
			oBill.omodel.HWWOrderBillNo = "";
			oBill.omodel.HEquipMentID = 0; //!
			oBill.omodel.HICMOBillNo = oItemSub.HICMOBillNo;
			oBill.omodel.HMaterID = oItemSub.HMaterID;
			oBill.omodel.HMaterNumber = ds.Tables[0].Rows[0]["HMaterNumber"].ToString();
			oBill.omodel.HUnitID = Pub_Class.ClsPub.isLong(ds.Tables[0].Rows[0]["HUnitID"]);
			oBill.omodel.HMateOutBatchNo = "";
			oBill.omodel.HUnitNumber = ds.Tables[0].Rows[0]["HUnitNumber"].ToString();
			oBill.omodel.HMaterID2 = oItemSub.HMaterID;
			oBill.omodel.HProjectNum = "";
			oBill.omodel.HPlanQty = oItemSub.HQty;
			oBill.omodel.HQty = oItemSub.HProQty;
			oBill.omodel.HPlanBeginDate = Convert.ToDateTime(dt.ToShortDateString().ToString());
			oBill.omodel.HPlanEndDate = Convert.ToDateTime(dt.ToShortDateString().ToString());
			oBill.omodel.HExplanation = "";
			oBill.omodel.HInnerBillNo = "";
			oBill.omodel.HSupID = 0;
			oBill.omodel.HWorkShopID = Pub_Class.ClsPub.isLong(ds.Tables[0].Rows[0]["HDeptID"]);
			oBill.omodel.HWorkTypeNum = "";
			oBill.omodel.HProdMaterCode = "";
			oBill.omodel.HSeOrderBillNo = ds.Tables[0].Rows[0]["HSeOrderBillNo"].ToString();
			oBill.omodel.HCusShortName = "";
			oBill.omodel.HCusNeedMaterial = "";
			oBill.omodel.HPlanSendGoodsDate = dt.ToShortDateString().ToString();
			oBill.omodel.HProdMaterName = "";
			oBill.omodel.HCusName = "";
			oBill.omodel.HWorkRemark = "";
			oBill.omodel.HImportNote = "";
			oBill.omodel.HMaterNumber_A = "";
			oBill.omodel.HMaterNumber_B = "";
			oBill.omodel.HMaterNumber_C = "";
			oBill.omodel.HMaterNumber_D = "";
			oBill.omodel.HProdType = "";
			oBill.omodel.HMaterShortName = "";
			oBill.omodel.HMaterIDA = "";
			oBill.omodel.HMaterIDB = "";
			oBill.omodel.HMaterIDC = "";
			oBill.omodel.HMaterIDD = "";
			oBill.omodel.HICMOInterID = oItemSub.HICMOInterID;
			oBill.omodel.HICMOEntryID = oItemSub.HICMOEntryID;
			oBill.omodel.HPicNumVer = "";
			oBill.omodel.HPicNumAssemble = "";
			oBill.omodel.HMaterTexture = "";
			oBill.omodel.HProductNum = "";
			oBill.omodel.HVerNum = "";
			oBill.omodel.HPRDORGID = Pub_Class.ClsPub.isLong(ds.Tables[0].Rows[0]["HPRDORGID"]);
			oBill.omodel.HBLFlag = false;
			oBill.omodel.HCusNumber = "";
			oBill.omodel.HPickLabel = "";
			oBill.omodel.HPickLabelNumber = "";
			oBill.omodel.HXTNumber = "";
			oBill.omodel.HXTModel = "";
			oBill.omodel.HWorkBillSortNo = "";//!
			oBill.omodel.HRoutingBillID = oItemSub.HRoutingInterID.ToString();
			oBill.omodel.HMaterModel = ds.Tables[0].Rows[0]["HMaterModel"].ToString();
			oBill.omodel.HWidth = 0;
			oBill.omodel.HWeight = 0;
			oBill.omodel.HAuxQty = 0;
			oBill.omodel.HAuxUnit = 0;
			oBill.omodel.HAuxQty2 = 0;
			oBill.omodel.HAuxUnit2 = 0;
			oBill.omodel.HSplitNo = 0;
			oBill.omodel.HHeight = "";
			oBill.omodel.HInches = "";
			oBill.omodel.HAl1Long = "";
			oBill.omodel.HDensity = "";
			oBill.omodel.HTela = "";
			oBill.omodel.HUnderTela = "";
			oBill.omodel.HSizing = "";
			oBill.omodel.HSellDate = dt.ToShortDateString().ToString();
			oBill.omodel.HRemark2 = "批量拆分下推";
			oBill.omodel.HRemark3 = "";
			oBill.omodel.HEmpID = 0;
			oBill.omodel.HCusID = 0;
			oBill.omodel.HColorRemark = "";
			oBill.omodel.HSplitSumQty = 0;
			oBill.omodel.HSplitColorQty = 0;
			oBill.omodel.HMachineLine = "";
			oBill.omodel.HMainSourceInterID = 0;
			oBill.omodel.HMainSourceEntryID = 0;
			oBill.omodel.HMainSourceBillNo = "";
			oBill.omodel.HOrderLevID = 0;
			oBill.omodel.HWidth_New = 0;
			oBill.omodel.HRemark_New = "";
			oBill.omodel.HWeight_New = 0;
			oBill.omodel.HPlanOrderProcNo = ds.Tables[0].Rows[0]["HPlanOrderProcNo"].ToString();
			oBill.omodel.HMouldNum = "0";
			}
			//子表赋值
			for(int i = 0; i < ds.Tables[0].Rows.Count; i++)
			{
			Model.ClsSc_ProcessExchangeBillSub oItemSubs = new Model.ClsSc_ProcessExchangeBillSub();
			oItemSubs.HEntryID = i + 1;
			oItemSubs.HBillNo_bak = HBillNo;
			oItemSubs.HCloseMan = "";
			oItemSubs.HEntryCloseDate = Convert.ToDateTime(dt.ToShortDateString().ToString());
			oItemSubs.HCloseType = false;
			oItemSubs.HRemark = "";
			oItemSubs.HSourceInterID = HICMOInterID;
			oItemSubs.HSourceEntryID = HICMOEntryID;
			oItemSubs.HSourceBillNo = HICMOBillNo;
			oItemSubs.HSourceBillType = "3710";
			oItemSubs.HRelationQty = 0;
			oItemSubs.HRelationMoney = 0;
			oItemSubs.HRelationQty_In = 0;
			oItemSubs.HRelationQty_Out = 0;
			oItemSubs.HRelationQty_WWOrder = 0;
			oItemSubs.HRelationQty_Bad = 0;
			oItemSubs.HProcNo = Pub_Class.ClsPub.isLong(ds.Tables[0].Rows[i]["HProcNo"]);
			oItemSubs.HProcID = Pub_Class.ClsPub.isLong(ds.Tables[0].Rows[i]["HProcID"]);
			oItemSubs.HProcNumber = ds.Tables[0].Rows[i]["HProcNumber"].ToString();
			oItemSubs.HWorkRemark = "";
			oItemSubs.HCenterID = Pub_Class.ClsPub.isLong(ds.Tables[0].Rows[i]["HCenterID"]);
			oItemSubs.HDeptID = Pub_Class.ClsPub.isLong(ds.Tables[0].Rows[i]["HDeptID"]);
			oItemSubs.HDeptNumber = ds.Tables[0].Rows[i]["HDeptNumber"].ToString();
			oItemSubs.HGroupID = 0;
			oItemSubs.HGroupNumber = oItemSub.HGroupNumber;
			oItemSubs.HWorkerID = 0;
			oItemSubs.HWorkerNumber = "";
			oItemSubs.HSourceID = 0;
			oItemSubs.HQty = HProQty;
			oItemSubs.HTimeUnit = "";
			oItemSubs.HPlanWorkTimes = 0;
			oItemSubs.HPlanBeginDate = Convert.ToDateTime(dt.ToShortDateString().ToString());
			oItemSubs.HPlanEndDate = Convert.ToDateTime(dt.ToShortDateString().ToString());
			oItemSubs.HRelBeginDate = Convert.ToDateTime(dt.ToShortDateString().ToString());
			oItemSubs.HRelEndDate = Convert.ToDateTime(dt.ToShortDateString().ToString());
			oItemSubs.HReadyTime = 0;
			oItemSubs.HQueueTime = 0;
			oItemSubs.HMoveTime = 0;
			oItemSubs.HBeginDayQty = 0;
			oItemSubs.HBeginFixQty = 0;
			oItemSubs.HFixWorkDays = 0;
			oItemSubs.HTrunWorkDays = 0;
			oItemSubs.HReadyTimes = 0;
			oItemSubs.HMyWorkDays = 0;
			oItemSubs.HOutPrice = 0;
			oItemSubs.HOutMoney = 0;
			oItemSubs.HPassRate = 0;
			oItemSubs.HLastProc = "";
			oItemSubs.HKeyProc = "";
			oItemSubs.HFstProc = "";
			oItemSubs.HICMOInterID = HICMOInterID;
			oItemSubs.HICMOBillNo = HICMOBillNo;
			oItemSubs.HWWOrderInterID = 0;
			oItemSubs.HWWOrderEntryID = 0;
			oItemSubs.HWWOrderBillNo = "";
			oItemSubs.HReportQty = 0;
			oItemSubs.HBackProc = false;
			oItemSubs.HSupID = 0;
			oItemSubs.HSupFlag = false;
			oItemSubs.HOverRate = 0;
			oItemSubs.HMaxQty = 0;
			oItemSubs.HTechnologyParameter = "";
			oItemSubs.HProcCheckNote = "";
			oItemSubs.HPicNum = "";
			oItemSubs.HMouldNo = "";
			oItemSubs.HProcWorkNum = "";
			oItemSubs.HSeOrderInterID = 0;
			oItemSubs.HSeOrderEntryID = 0;
			oItemSubs.HSNCtrl = false;

			oBill.DetailColl.Add(oItemSubs);//添加明细行值
			}
			//调用保存方法
			bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);
			oBill.DetailColl.Clear();//清空明细行值
			if (!bResult)
			{
			break;
			}
			}

			if (bResult)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "保存成功！";
			objJsonResult.data = 1;
			return objJsonResult;
			}
			else
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "保存失败！" + DBUtility.ClsPub.sExeReturnInfo;
			objJsonResult.data = 1;
			return objJsonResult;
			}
			}
			catch (Exception e)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "保存失败！" + e.ToString();
			objJsonResult.data = 1;
			return objJsonResult;
			}
			}
			#endregion
			}
			}