派生自 MES-WEB-API
WebAPI/Controllers/Éú²ú¹ÜÀí/Éú²úÈÎÎñµ¥/Sc_ICMOBillController.cs
@@ -9,6 +9,7 @@ using System.Data; using System.Data.SqlClient; using System.Web.Http; using System.Windows.Forms; using WebAPI.Models; namespace WebAPI.Controllers @@ -72,7 +73,7 @@ string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string msg2 = sArray[0].ToString(); //主表æ°æ® string msg3 = sArray[1].ToString(); //å表æ°æ® int OperationType = int.Parse(sArray[2].ToString()); // æ°æ®ç±»å 1æ·»å 3ä¿®æ¹ int OperationType = int.Parse(sArray[2].ToString()); // æ°æ®ç±»å 1æ·»å 2å¤å¶ 3ä¿®æ¹ string user = sArray[3].ToString(); try @@ -185,7 +186,7 @@ long HSeOrderEntrySEQ = DetailColl[0].HSeOrderEntrySEQ == null ? 0 : DetailColl[0].HSeOrderEntrySEQ; //éå®è®¢åè¡å·, string HPROJECTNO = DetailColl[0].HPROJECTNO == null ? "''" : DetailColl[0].HPROJECTNO; //项ç®ç¼å·, long HPRODUCTTYPE = DetailColl[0].HPRODUCTTYPE == null ? 0 : DetailColl[0].HPRODUCTTYPE; //产åç±»å, long HCOSTRATE = DetailColl[0].HCOSTRATE == null ? 0 : DetailColl[0].HCOSTRATE; // æé, double HCOSTRATE = DetailColl[0].HCOSTRATE == null ? 0 : DetailColl[0].HCOSTRATE; // æé, long HBASEUNITID = DetailColl[0].HBASEUNITID == null ? 0 : DetailColl[0].HBASEUNITID; //åºæ¬è®¡éåä½, int i = 0; @@ -287,11 +288,13 @@ (HBillType,HInterID,HBillNo,HDate,HPRDORGID ,HYear,HPeriod,HRemark,HMaker,HMakeDate ,HSeOrderBillNo,HSeOrderInterID,HSeOrderEntryID,HEmpID,HCusID ,HCenterID,HPlanQty,HDeptID,HMaterID,HUnitID,HBomID,HPlanBeginDate,HPlanEndDate,HBillStatus) ,HCenterID,HPlanQty,HDeptID,HMaterID,HUnitID,HBomID,HPlanBeginDate,HPlanEndDate,HBillStatus ,HOWNERID,HOWNERTYPEID) values('3710'," + mainList[0].HInterID + ",'" + mainList[0].HBillNo + "','" + mainList[0].HDate + "'," + mainList[0].HPRDORGID + "," + DateTime.Now.Year + "," + DateTime.Now.Month + ",'" + mainList[0].HRemark + "','" + mainList[0].HMaker + "',getdate()" + ",'" + mainList[0].HSeOrderBillNo + "'," + mainList[0].HSeOrderInterID + "," + mainList[0].HSeOrderEntryID + "," + mainList[0].HEmpID + "," + mainList[0].HCusID + "," + mainList[0].HCenterID + "," + mainList[0].HPlanQty + ",0,0,0,0,'','',2) "); "," + mainList[0].HCenterID + "," + mainList[0].HPlanQty + ",0,0,0,0,'','',2" + ","+ mainList[0].HOWNERID + ",'"+ mainList[0].HOWNERTYPEID + "') "); //ä¿å主表 foreach (var oSub in subList) { @@ -300,12 +303,14 @@ ,HPlanBeginDate,HPlanEndDate ,HBeginDate,HEndDate ,HMaterID,HUnitID,HRemark,HSourceID,HDeptID,HSTATUS ,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney) ,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney ,HCOSTRATE,HISBACKFLUSH,HBatchNo,HBomID,HCHECKPRODUCT,HSEQ,HSTOCKINORGID) values({oSub.HInterID},{oSub.HEntryID},{(oSub.HQty == null ? 0 : oSub.HQty)} ,'{(oSub.HPlanBeginDate == null ? DateTime.Now.ToString("yyyy-MM-dd") : oSub.HPlanBeginDate.ToString())}','{(oSub.HPlanEndDate == null ? DateTime.Now.AddDays(1).ToString("yyyy-MM-dd") : oSub.HPlanEndDate.ToString())}' ,'{(oSub.HPlanBeginDate == null ? DateTime.Now.ToString("yyyy-MM-dd") : oSub.HPlanBeginDate.ToString())}','{(oSub.HPlanEndDate == null ? DateTime.Now.AddDays(1).ToString("yyyy-MM-dd") : oSub.HPlanEndDate.ToString())}' ,{oSub.HMaterID},{oSub.HUnitID},'{oSub.HRemark}',{oSub.HSourceID},{oSub.HDeptID},4 ,0,0,'','',0,0)"); ,{oSub.HMaterID},{oSub.HUnitID},'{oSub.HRemark}',{oSub.HSourceID},{oSub.HDeptID},'{oSub.HSTATUS}' ,0,0,'','',0,0 ,{oSub.HCOSTRATE},{oSub.HISBACKFLUSH},'{oSub.HBatchNo}',{oSub.HBomID},{oSub.HCHECKPRODUCT},{oSub.HSEQ},{oSub.HSTOCKINORGID})"); } foreach (var _item in _mainList) @@ -408,6 +413,7 @@ int OperationType = int.Parse(sArray[1].ToString()); // æ°æ®ç±»å 1æ·»å 3ä¿®æ¹ string user = sArray[2].ToString(); int HEntryID = int.Parse(sArray[3].ToString()); string HComputerName = SystemInformation.ComputerName; //设å¤å称 try { @@ -438,6 +444,8 @@ long HBomID = mainList[0].HBomID;//bom //double? HPlanQty = mainList[0].HPlanQty == null ? 0 : mainList[0].HPlanQty;//计åæ°é string HMaker = user;//å¶å人 string HIsStockQty = mainList[0].HIsStockQty; string HRemark3 = mainList[0].HRemark3; ds = oCN.RunProcReturn("select * from h_v_IF_ICMOBillList where hmainid=" + HInterID + " and åæ®å·='" + HBillNo + "'", "h_v_IF_ICMOBillList"); @@ -448,11 +456,17 @@ (HBillType,HBillStatus,HInterID,HBillNo,HDate,HPRDORGID ,HYear,HPeriod,HRemark,HMaker,HMakeDate ,HSeOrderBillNo,HSeOrderInterID,HSeOrderEntryID,HEmpID,HCusID ,HCenterID,HPlanQty,HDeptID,HMaterID,HUnitID,HBomID,HPlanBeginDate,HPlanEndDate) ,HCenterID,HPlanQty,HDeptID,HMaterID,HUnitID,HBomID,HPlanBeginDate,HPlanEndDate ,HIsStockQty,HRemark3) values('3710',1," + HInterID + ",'" + HBillNo + "','" + HDate + "'," + HPRDORGID + "," + DateTime.Now.Year + "," + DateTime.Now.Month + ",'" + HRemark + "','" + HMaker + "',getdate()" + ",'" + HSeOrderBillNo + "'," + HSeOrderInterID + "," + HSeOrderEntryID + "," + HEmpID + "," + HCusID + "," + HCenterID + ",0,0,0,0," + HBomID + ",'','') "); "," + HCenterID + ",0,0,0,0," + HBomID + ",'',''" + ",'"+ HIsStockQty + "','"+ HRemark3 + "') "); 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) { @@ -468,11 +482,14 @@ //ä¿®æ¹ oCN.RunProc("update Sc_ICMOBillMain set " + "HRemark='" + HRemark + "', HUpDater='" + HMaker + "', HUpDateDate=getdate()" + ", HSeOrderBillNo='" + HSeOrderBillNo + "', HSeOrderInterID=" + HSeOrderInterID + ", HSeOrderEntryID=" + HSeOrderEntryID + ", HEmpID=" + HEmpID + ", HCusID=" + HCusID + "" + ", HCenterID=" + HCenterID + ",HBomID=" + HBomID + " where HInterID=" + HInterID); ", HSeOrderBillNo='" + HSeOrderBillNo + "', HSeOrderInterID=" + HSeOrderInterID + ", HSeOrderEntryID=" + HSeOrderEntryID + ", HEmpID=" + HEmpID + ", HCusID=" + HCusID + ", HCenterID=" + HCenterID + ",HBomID=" + HBomID + ",HIsStockQty='"+ HIsStockQty + "',HRemark3='" + HRemark3 + "' where HInterID=" + HInterID); //å é¤å表 oCN.RunProc("delete from Sc_ICMOBillSub where HInterID='" + HInterID + "' and HEntryID='" + HEntryID + "'"); 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_NoTable(msg3, HInterID, OperationType, HEntryID); @@ -505,6 +522,8 @@ public json AddBillSub_NoTable(string msg3, long HInterID, int OperationType,int HEntryID) { ClsSc_ICMOBillSub oSub = Newtonsoft.Json.JsonConvert.DeserializeObject<ClsSc_ICMOBillSub>(msg3); if (oSub.HQty <= 0 || oSub.HQty == null) { objJsonResult.code = "0"; @@ -523,14 +542,7 @@ return objJsonResult; } if (oSub.HDeptID == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "ç产车é´ä¸è½ä¸ºç©º"; objJsonResult.data = null; return objJsonResult; } if (oSub.HUnitID == 0) { @@ -556,13 +568,15 @@ ,HBeginDate,HEndDate ,HMaterID,HUnitID,HRemark,HSourceID,HDeptID,HSTATUS ,HBomID,HEntryCusID,HSTOCKINORGID ,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney) ,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney ,HAuxQty,HAuxUnit,HWidth,HWeight,HColorRemark) values({HInterID},{HEntryID},{(oSub.HQty == null ? 0 : oSub.HQty)} ,'{(oSub.HPlanBeginDate == null ? DateTime.Now.ToString("yyyy-MM-dd") : oSub.HPlanBeginDate.ToString())}','{(oSub.HPlanEndDate == null ? DateTime.Now.AddDays(1).ToString("yyyy-MM-dd") : oSub.HPlanEndDate.ToString())}' ,'{(oSub.HBeginDate == null ? DateTime.Now.ToString("yyyy-MM-dd") : oSub.HBeginDate.ToString())}','{(oSub.HEndDate == null ? DateTime.Now.AddDays(1).ToString("yyyy-MM-dd") : oSub.HEndDate.ToString())}' ,{oSub.HMaterID},{oSub.HUnitID},'{oSub.HRemark}',{oSub.HSourceID},{oSub.HDeptID},{oSub.HSTATUS} ,{oSub.HBomID} ,{oSub.HCusID} ,{oSub.HSTOCKINORGID} ,0,0,'','',0,0)"); ,0,0,'','',0,0 ,{oSub.HAuxQty},{oSub.HAuxUnit},{oSub.HWidth},{oSub.HWeight},'{oSub.HColorRemark}')"); objJsonResult.code = "1"; @@ -815,6 +829,8 @@ { try { string HComputerName = SystemInformation.ComputerName; //设å¤å称 //å¤ææ¯å¦æå é¤æé if (!DBUtility.ClsPub.Security_Log("Sc_ICMOBill_Drop", 1, false, user)) { @@ -844,6 +860,22 @@ return objJsonResult; ; } string sReturn = ""; if (oSystemParameter.ShowBill(ref sReturn)) { if (oSystemParameter.omodel.Sc_ICMOBill_DeleterAndMakerMustSame == "Y") { if (ds.Tables[0].Rows[0]["HMaker"].ToString() != user && (user != "admin" && user != "Admin")) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "åªè½å é¤æ¬äººçåæ®ï¼"; objJsonResult.data = null; return objJsonResult; } } } if (int.Parse(ds.Tables[0].Rows[0]["HBillStatus"].ToString()) > 1) { objJsonResult.code = "0"; @@ -853,8 +885,47 @@ return objJsonResult; ; } var DataSet = oCN.RunProcReturn("select * from Sc_ProcessExchangeBillMain where HICMOBillNo='" + ds.Tables[0].Rows[0]["HBillNo"].ToString() +"'", "Sc_ProcessExchangeBillMain"); if (DataSet.Tables[0].Rows.Count > 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "åæ®å·²ä¸æ¨å·¥åºæµè½¬å¡,ä¸å 许å é¤ï¼"; objJsonResult.data = null; return objJsonResult; ; } DataSet = oCN.RunProcReturn("select * from h_v_IF_ProductInBillList where æºååå·='" + ds.Tables[0].Rows[0]["HBillNo"].ToString() + "'", "h_v_IF_ProductInBillList"); if (DataSet.Tables[0].Rows.Count > 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "åæ®å·²ä¸æ¨çäº§å ¥åºå,ä¸å 许å é¤ï¼"; objJsonResult.data = null; return objJsonResult; ; } DataSet = oCN.RunProcReturn("select * from h_v_IF_MateOutBillList where æºååå·='" + ds.Tables[0].Rows[0]["HBillNo"].ToString() + "'", "h_v_IF_MateOutBillList"); if (DataSet.Tables[0].Rows.Count > 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "åæ®å·²ä¸æ¨ç产é¢æå,ä¸å 许å é¤ï¼"; objJsonResult.data = null; return objJsonResult; ; } oCN.RunProc("delete from Sc_ICMOBillMain where HInterID=" + HInterID); oCN.RunProc("delete from Sc_ICMOBillSub where HInterID=" + HInterID); LogService.Write("ç¨æ·:" + user + ",æ¥æ:" + DateTime.Now + ",å é¤ç产订ååæ®:" + ds.Tables[0].Rows[0]["HBillNo"].ToString()); oCN.RunProc("Insert into System_log (GeginDate, userid, WorkstationName, WorkList, SystemName, NetuserName, State) select GETDATE(),'" + user + "','" + HComputerName + "','" + "å é¤ç产订ååæ®ï¼" + ds.Tables[0].Rows[0]["HBillNo"].ToString() + "','LMES-ç产订å模å','" + DBUtility.ClsPub.IPAddress + "','å é¤åæ®'", ref DBUtility.ClsPub.sExeReturnInfo); oCN.Commit();//æ交äºå¡ objJsonResult.code = "0"; objJsonResult.count = 1; @@ -874,6 +945,204 @@ } #endregion #region ç产任å¡å å¤è¡æ¹éä¸æ¨ [Route("Sc_ICMOBill/Sc_ICMOReportBill_dh")] [HttpGet] public object Sc_ICMOReportBill_dh(string HInterID, string user, int OrganizationID) { try { //è·ååæ®ID string[] HBillNo = HInterID.Split(','); string Error = ""; int i = 0; foreach (var item in HBillNo) { string err = ""; DAL.ClsSc_ProcessExchangeBill oBill = new DAL.ClsSc_ProcessExchangeBill(); Model.ClsSc_ProcessExchangeBillMain lsmain = new Model.ClsSc_ProcessExchangeBillMain(); List<Model.ClsSc_ProcessExchangeBillSub> ls = new List<Model.ClsSc_ProcessExchangeBillSub>(); string HBillNOs = ""; string hmainid = item.Split('|')[0]; string HEntryID = item.Split('|')[1]; ds = oCN.RunProcReturn("select * from h_v_IF_ICMOBillList where 1 = 1 and hmainid=" + hmainid + " and HEntryID=" + HEntryID + " order by åæ®å· desc", "h_v_IF_ICMOBillList"); if (ds.Tables[0].Rows.Count == 0) { err = "æ æ°æ®! \n"; } else { string HNumber = ds.Tables[0].Rows[0]["产å代ç "].ToString(); HBillNOs = ds.Tables[0].Rows[0]["åæ®å·"].ToString(); if (ds.Tables[0].Rows[0]["å®¡æ ¸äºº"].ToString() == "") { err = "æéç产订å为æªå®¡æ ¸ç¶æï¼ä¸å 许ä¸æ¨çæå·¥åºæµè½¬å¡ï¼\n"; } if (ds.Tables[0].Rows[0]["å ³é人"].ToString() != "") { err = "æéç产订åä¸ºå·²å ³éç¶æï¼ä¸å 许ä¸æ¨çæå·¥åºæµè½¬å¡ï¼\n"; } if (ds.Tables[0].Rows[0]["ä½åºäºº"].ToString() != "") { err = "æéç产订å为已ä½åºç¶æï¼ä¸å 许ä¸æ¨çæå·¥åºæµè½¬å¡ï¼\n"; } ds = oCN.RunProcReturn("select * from h_v_S_Sc_ICMOBillList where hmainid=" + hmainid + " and HEntryID=" + HEntryID + " and HSTOCKINORGID='" + OrganizationID + "'", "h_v_S_Sc_ICMOBillList"); if (double.Parse(ds.Tables[0].Rows[0]["æµè½¬å¡æ°é"].ToString()) == 0) { err = "æéç产订åå·²å ¨é¨ä¸æ¨çæå·¥åºæµè½¬å¡ï¼å©ä½å¯ä¸æ¨æ°é为0ï¼ä¸å 许ä¸æ¨çæå·¥åºæµè½¬å¡ï¼\n"; } lsmain.HMaker = user; //å¶å人 lsmain.HBillType = "3772"; lsmain.HBillSubType = "3772"; lsmain.HDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd")); lsmain.HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year); lsmain.HPeriod = DBUtility.ClsPub.isLong(DateTime.Now.Month); lsmain.HICMOInterID = long.Parse(ds.Tables[0].Rows[0]["hmainid"].ToString()); lsmain.HICMOBillNo = ds.Tables[0].Rows[0]["ç产订åå·"].ToString(); lsmain.HICMOEntryID = long.Parse(ds.Tables[0].Rows[0]["HEntryID"].ToString()); lsmain.HOrderProcNO = ds.Tables[0].Rows[0]["订åè·è¸ªå·"].ToString(); lsmain.HMaterID = long.Parse(ds.Tables[0].Rows[0]["hmaterid"].ToString()); lsmain.HMaterID2 = long.Parse(ds.Tables[0].Rows[0]["hmaterid"].ToString()); lsmain.HMaterNumber = ds.Tables[0].Rows[0]["ç©æ代ç "].ToString(); lsmain.HMaterModel = ds.Tables[0].Rows[0]["è§æ ¼åå·"].ToString(); lsmain.HBatchNo = ds.Tables[0].Rows[0]["æ¹å·"].ToString(); lsmain.HSplitNo =1;//é½æ¯1 lsmain.HUnitID = long.Parse(ds.Tables[0].Rows[0]["hunitid"].ToString()); lsmain.HUnitNumber = ds.Tables[0].Rows[0]["计éåä½ä»£ç "].ToString(); lsmain.HPlanQty = double.Parse(ds.Tables[0].Rows[0]["计åç产æ°é"].ToString()); lsmain.HQty = double.Parse(ds.Tables[0].Rows[0]["æµè½¬å¡æ°é"].ToString()); lsmain.HPlanBeginDate = DateTime.Parse(ds.Tables[0].Rows[0]["计åå¼å·¥æ¥æ"].ToString()); lsmain.HPlanEndDate = DateTime.Parse(ds.Tables[0].Rows[0]["计åå®å·¥æ¥æ"].ToString()); lsmain.HWorkShopID = long.Parse(ds.Tables[0].Rows[0]["hdeptid"].ToString()); lsmain.HProdMaterCode = ds.Tables[0].Rows[0]["产åCODE"].ToString(); lsmain.HSeOrderBillNo = ds.Tables[0].Rows[0]["éå®è®¢åå·"].ToString(); lsmain.HCusShortName = ds.Tables[0].Rows[0]["客æ·ç®ç§°"].ToString(); lsmain.HCusNeedMaterial = ds.Tables[0].Rows[0]["客æ·è¦æ±æææå"].ToString(); lsmain.HPlanSendGoodsDate = ds.Tables[0].Rows[0]["é¢è®¡åºè´§æ¥æ"].ToString()==""?DateTime.Now.ToString(): ds.Tables[0].Rows[0]["é¢è®¡åºè´§æ¥æ"].ToString(); lsmain.HSellDate = DateTime.Now.ToString(); lsmain.HPRDORGID = OrganizationID; lsmain.HProdMaterName = ds.Tables[0].Rows[0]["产åå称"].ToString(); lsmain.HCusName = ds.Tables[0].Rows[0]["客æ·å称"].ToString(); lsmain.HWorkRemark = ds.Tables[0].Rows[0]["ç产å¤æ³¨"].ToString(); lsmain.HImportNote = ds.Tables[0].Rows[0]["éè¦æ示"].ToString(); lsmain.HPicNumVer = ds.Tables[0].Rows[0]["å¾å·çæ¬"].ToString(); lsmain.HPicNumAssemble = ds.Tables[0].Rows[0]["æ»è£ å¾å·"].ToString(); lsmain.HMaterTexture = ds.Tables[0].Rows[0]["æè´¨"].ToString(); lsmain.HProductNum = ds.Tables[0].Rows[0]["æåç¼å·"].ToString(); lsmain.HVerNum = ds.Tables[0].Rows[0]["çæ¬"].ToString(); //lsmain.HCusNumber = ds.Tables[0].Rows[0]["æºå客æ·ç¼ç "].ToString(); //lsmain.HPickLabel = ds.Tables[0].Rows[0]["å è£ æ è¯"].ToString(); //lsmain.HPickLabelNumber = ds.Tables[0].Rows[0]["å è£ æ è¯ç¼ç "].ToString(); //lsmain.HXTNumber = ds.Tables[0].Rows[0]["è¯ä½ç©æ代ç "].ToString(); //lsmain.HXTModel = ds.Tables[0].Rows[0]["è¯ä½è§æ ¼åå·"].ToString(); lsmain.HWidth = double.Parse(ds.Tables[0].Rows[0]["HWidth"].ToString()); lsmain.HWeight = double.Parse(ds.Tables[0].Rows[0]["HWeight"].ToString()); lsmain.HAuxUnit = int.Parse(ds.Tables[0].Rows[0]["HAuxUnit"].ToString()); lsmain.HRemark2 = ds.Tables[0].Rows[0]["å¤æ³¨"].ToString(); lsmain.HEmpID = long.Parse(ds.Tables[0].Rows[0]["HEmpID"].ToString()); lsmain.HCusID = long.Parse(ds.Tables[0].Rows[0]["HCusID"].ToString()); lsmain.HColorRemark = ds.Tables[0].Rows[0]["æè²è¦æ±"].ToString(); lsmain.HBLFlag = ds.Tables[0].Rows[0]["HBLFlag"].ToString() == "0" ? false : true; lsmain.HAuxQty = 0; lsmain.HAuxUnit = 0; ds = oCN.RunProcReturn("select top 1000 * from h_v_Gy_RoutingBillList a left join Gy_Process p on a.hprocid = p.HItemID where ç©æ代ç ='" + HNumber + "' and é»è®¤å·¥èº=1", "h_v_Gy_RoutingBillList"); if (ds.Tables[0].Rows.Count == 0) { err = "æéç产订å对åºç©ææªè®¾ç½®å¯¹åºçå·¥èºè·¯çº¿ï¼ä¸å 许ä¸æ¨çæå·¥åºæµè½¬å¡ï¼\n"; } else { lsmain.HRoutingBillID = ds.Tables[0].Rows[0]["hmainid"].ToString(); oBill.omodel = lsmain; int j = 0; foreach (DataRow row in ds.Tables[0].Rows) { if (row["HTProcessFlag"].ToString() == "False") { ClsSc_ProcessExchangeBillSub sub = new ClsSc_ProcessExchangeBillSub(); sub.HEntryID = j + 1; sub.HEntryCloseDate = DBUtility.ClsPub.isDate(DateTime.Now); sub.HProcNo = long.Parse(row["å·¥åºå·"].ToString()); sub.HProcID = long.Parse(row["HProcID"].ToString()); sub.HProcNumber = row["å·¥åºä»£ç "].ToString(); sub.HWorkRemark = row["表ä½å¤æ³¨"].ToString(); sub.HCenterID = long.Parse(row["HCenterID"].ToString()); sub.HSupID = long.Parse(row["HSupID"].ToString()); sub.HSupFlag = row["å§å¤æ è®°"].ToString() == "False" ? false : true; sub.HQty = lsmain.HQty; sub.HTechnologyParameter = row["å·¥èºåæ°"].ToString(); sub.HPicNum = row["å¾çº¸ç¼å·"].ToString(); sub.HProcCheckNote = row["æ¬å·¥åºç¡®è®¤è®°å½"].ToString(); sub.HDeptID = 0; sub.HDeptNumber = ""; sub.HOutPrice = 0; sub.HRemark = ""; sub.HRelationQty_In =0; sub.HRelationQty_Out = 0; sub.HRelationQty_WWOrder = 0; sub.HRelationQty_Bad = 0; sub.HOverRate = 0; sub.HMaxQty = 0; sub.HPassRate = 0; sub.HSumPassRate = 0; j++; oBill.DetailColl.Add(sub); } } } } bool bResult = false; if (err != "") { Error += "ç产订ååæ®å·:" + HBillNOs + "\n" + err; } else { oBill.omodel.HBillNo = DBUtility.ClsPub.CreateBillCode("3772", ref DBUtility.ClsPub.sExeReturnInfo,true); bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo); oBill.DetailColl.Clear(); if (!bResult) { Error += "ä¿å失败,ç产订ååæ®å·:" + HBillNOs + "\n" + err; } else { i++; } } } Error = "æå:" + i + "è¡ !!! " + Error; objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = Error; 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("Sc_ICMOBill/GetHDeptList")] [HttpGet] @@ -901,6 +1170,33 @@ } #endregion #region ç产任å¡åè·åå·¥ä½ä¸å¿ [Route("Sc_ICMOBill/GetHWorkCenterList")] [HttpGet] public object GetHWorkCenterList() { try { DataSet oDs = new DataSet(); //========== oDs = oCN.RunProcReturn("select HItemID,HName from Gy_WorkCenter", "Gy_WorkCenter"); objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "è·åæåï¼"; objJsonResult.data = oDs.Tables[0]; return objJsonResult; ; } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "å é¤å¤±è´¥ï¼" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #region å¢åè£ ç®±åå车äºä»¶ [Route("Sc_ICMOBill/QK_PackingBillByXSBill")] [HttpGet]
