派生自 MES-WEB-API
WebAPI/Controllers/Éú²ú¹ÜÀí/Éú²úÈÎÎñµ¥/Sc_ICMOBillController.cs
@@ -1,4 +1,5 @@ using Model; using Model.ç产管ç; using Newtonsoft.Json; using Newtonsoft.Json.Linq; using Pub_Class; @@ -8,6 +9,7 @@ using System.Data; using System.Data.SqlClient; using System.Web.Http; using System.Windows.Forms; using WebAPI.Models; namespace WebAPI.Controllers @@ -21,6 +23,10 @@ private json objJsonResult = new json(); SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); DataSet ds; //è·åç³»ç»åæ° Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter(); public DAL.ClsSc_ICMOBill BillOld = new DAL.ClsSc_ICMOBill(); #region ç产任å¡å ä¿å/ç¼è¾åè½ [Route("Sc_ICMOBill/ICMOBillEdit")] @@ -67,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 @@ -107,17 +113,27 @@ { //主表 oCN.RunProc(@"Insert Into Sc_ICMOBillMain (HBillType,HInterID,HBillNo,HDate,HPRDORGID (HBillType,HBillStatus,HInterID,HBillNo,HDate,HPRDORGID ,HYear,HPeriod,HRemark,HMaker,HMakeDate ,HSeOrderBillNo,HSeOrderInterID,HSeOrderEntryID,HEmpID,HCusID ,HCenterID,HPlanQty,HDeptID,HMaterID,HUnitID,HBomID,HPlanBeginDate,HPlanEndDate,HISENTRUST,HISREWORK) values('3710'," + HInterID + ",'" + HBillNo + "','" + HDate + "'," + HPRDORGID + values('3710',1," + HInterID + ",'" + HBillNo + "','" + HDate + "'," + HPRDORGID + "," + DateTime.Now.Year + "," + DateTime.Now.Month + ",'" + HRemark + "','" + HMaker + "',getdate()" + ",'" + HSeOrderBillNo + "'," + HSeOrderInterID + "," + HSeOrderEntryID + "," + HEmpID + "," + HCusID + "," + HCenterID + "," + HPlanQty + ",0,0,0,0,'',''" + "," + HISENTRUST + "," + HISREWORK + ") "); } else if (OperationType == 3 || ds.Tables[0].Rows.Count != 0) { //ä¿®æ¹ { if (ds.Tables[0].Rows[0]["å®¡æ ¸äºº"].ToString() != "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "åæ®å·²å®¡æ ¸,ä¸å 许修æ¹!"; objJsonResult.data = null; return objJsonResult; } //ä¿®æ¹ oCN.RunProc("update Sc_ICMOBillMain set " + "HRemark='" + HRemark + "', HChecker='" + HMaker + "', HCheckDate=getdate()" + ", HSeOrderBillNo='" + HSeOrderBillNo + "', HSeOrderInterID=" + HSeOrderInterID + ", HSeOrderEntryID=" + HSeOrderEntryID + ", HEmpID=" + HEmpID + ", HCusID=" + HCusID + "" + @@ -137,6 +153,9 @@ objJsonResult.data = null; return objJsonResult; } //ä¿®æ¹å段 HSTOCKINORGID oCN.RunProc("update Sc_ICMOBillSub set HSTOCKINORGID=" + HPRDORGID + " where HInterID=" + HInterID); objJsonResult.code = "1"; objJsonResult.count = 1; @@ -167,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; @@ -225,12 +244,13 @@ ,HBeginDate,HEndDate ,HMaterID,HUnitID,HRemark,HSourceID,HDeptID,HSTATUS ,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney ,HINSTOCKTYPE,HCHECKPRODUCT,HQAIP,HISBACKFLUSH,HREQSRC,HSTOCKINQUASELAUXQTY,HSeOrderEntrySEQ,HPROJECTNO,HPRODUCTTYPE,HCOSTRATE,HBASEUNITID) ,HINSTOCKTYPE,HCHECKPRODUCT,HQAIP,HISBACKFLUSH,HREQSRC,HSTOCKINQUASELAUXQTY,HSeOrderEntrySEQ,HPROJECTNO,HPRODUCTTYPE,HCOSTRATE,HBASEUNITID ,HSTOCKINORGID) values({HInterID},{i},{(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},{oSub.HSTATUS} ,0,0,'','',0,0,{HINSTOCKTYPE},{HCHECKPRODUCT},{HQAIP},{HISBACKFLUSH},{HREQSRC},{HSTOCKINQUASELAUXQTY},{HSeOrderEntrySEQ},{HPROJECTNO},{HPRODUCTTYPE},{HCOSTRATE},{HBASEUNITID})"); ,0,0,'','',0,0,{HINSTOCKTYPE},{HCHECKPRODUCT},{HQAIP},{HISBACKFLUSH},{HREQSRC},{HSTOCKINQUASELAUXQTY},{HSeOrderEntrySEQ},{HPROJECTNO},{HPRODUCTTYPE},{HCOSTRATE},{HBASEUNITID},{oSub.HSTOCKINORGID})"); } objJsonResult.code = "1"; @@ -247,12 +267,16 @@ { try { //LogService.Write(sMainSub.ToString()); var model = sMainSub["model"].ToString(); var entry = sMainSub["model"]["HENTRY"].ToString(); var _model = sMainSub["model"]["HPPBOMMAINENTRY"].ToString(); var _entry = sMainSub["model"]["HPPBOMSUBENTRY"].ToString(); model = "[" + model.ToString() + "]"; List<ClsSc_ICMOBillMain> mainList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ClsSc_ICMOBillMain>>(model); List<ClsSc_ICMOBillSub> subList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ClsSc_ICMOBillSub>>(entry); List<ClsSc_PPBomBillMain> _mainList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ClsSc_PPBomBillMain>>(_model); List<ClsSc_PPBomBillSub> _subList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ClsSc_PPBomBillSub>>(_entry); string sql = string.Empty; oCN.BeginTran(); sql = $"delete Sc_ICMOBillMain where HinterID = {mainList[0].HInterID}"; @@ -264,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) ,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,'','') "); "," + mainList[0].HCenterID + "," + mainList[0].HPlanQty + ",0,0,0,0,'','',2" + ","+ mainList[0].HOWNERID + ",'"+ mainList[0].HOWNERTYPEID + "') "); //ä¿å主表 foreach (var oSub in subList) { @@ -277,12 +303,46 @@ ,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},{oSub.HSTATUS} ,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) { //ç产ç¨ææ¸ å sql = $"delete Sc_PPBomBillMain where HinterID = {_item.HInterID}"; oCN.RunProc(sql); sql = $"delete Sc_PPBomBillSub where HinterID = {_item.HInterID}"; oCN.RunProc(sql); //主表 oCN.RunProc(@"Insert Into Sc_PPBomBillMain (HInterID,HYear,HPeriod,HBillType,HBillSubType,HDate,HBillNo,HBillStatus,HICMOInterID ,HICMOEntryID,HMaterID,HUnitID,HQty,HDeptID,HMaker,HMakeDate,HChecker,HCheckDate ,HSeOrderBillNo,HSeOrderInterID,HSeOrderEntryID,HPRDORGID,HENTRUSTORGID,HPARENTOWNERID ,HPARENTOWNERTYPEID,HERPInterID,HERPBillType,HSeOrderEntrySEQ,HICMOEntrySEQ,HREQSRC) values(" + _item.HInterID + "," + DateTime.Now.Year + "," + DateTime.Now.Month + ",'" + 3720 + "','" + _item.HBillSubType + "','" + _item.HDate + "','" + _item.HBillNo + "','" + _item.HBillStatus + "'," + _item.HICMOInterID + "," + _item.HICMOEntryID + ",'" + _item.HMaterID + "'," + _item.HUnitID + "," + _item.HQty + "," + _item.HDeptID + ",'" + _item.HMaker + "','" + _item.HMakeDate + "','" + _item.HChecker + "','" + _item.HCheckDate + "','" + _item.HSeOrderBillNo + "'," + _item.HSeOrderInterID + "," + _item.HSeOrderEntryID + "," + _item.HPRDORGID + "," + _item.HENTRUSTORGID + "," + _item.HPARENTOWNERID + ",'" + _item.HPARENTOWNERTYPEID + "'," + _item.HERPInterID + ",'" + _item.HERPBillType + "'," + _item.HSeOrderEntrySEQ + "," + _item.HICMOEntrySEQ + ",'" + _item.HREQSRC + "')"); } foreach (var oSub in _subList) { oCN.RunProc($@"Insert into Sc_PPBomBillSub (HInterID,HEntryID,HMaterID,HMaterNumber,HUnitID,HUnitNumber,HSPID,HQty,HQtyMust,HWHID,HRemark ,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HICMOInterID,HICMOEntryID,HICMOBillNo ,HCHILDSUPPLYORGID,HSUPPLYORGID,HENTRUSTPICKORGID,HSRCTRANSORGID,HGROUPBYOWNERID,HOWNERID,HOWNERTYPEID ,HRelationQty,HMoveStockQty,HAuxPropID,HBatchNO,HMTONo,HQtyScrap,HERPInterID,HERPEntryID ,HBackRelationQty,HNumerator,HDenominator,HBASEUNITID,HProcessID,HICMOENTRYSEQ,HPROJECTNO ,HOPERID,HSEQ,HSTOCKSTATUSID,HLOT,HOPTQUEUE,HRESERVETYPE,HSelPickedQty,HSELPRCDRETURNQTY,HProcName) values('{oSub.HInterID}','{oSub.HEntryID}','{oSub.HMaterID}','{oSub.HMaterNumber}','{oSub.HUnitID}','{oSub.HUnitNumber}','{oSub.HSPID}','{oSub.HQty}' ,'{oSub.HQtyMust}','{oSub.HWHID}','{oSub.HRemark}','{oSub.HSourceInterID}','{oSub.HSourceEntryID}','{oSub.HSourceBillNo}','{oSub.HSourceBillType}','{oSub.HICMOInterID}','{oSub.HICMOEntryID}','{oSub.HICMOBillNo}','{oSub.HCHILDSUPPLYORGID}','{oSub.HSUPPLYORGID}','{oSub.HENTRUSTPICKORGID}','{oSub.HSRCTRANSORGID}','{oSub.HGROUPBYOWNERID}','{oSub.HOWNERID}','{oSub.HOWNERTYPEID}','{oSub.HRelationQty}','{oSub.HMoveStockQty}','{oSub.HAuxPropID}','{oSub.HBatchNO}','{oSub.HMTONo}','{Convert.ToDecimal(oSub.HQtyScrap)}','{oSub.HERPInterID}','{oSub.HERPEntryID}','{oSub.HBackRelationQty}','{oSub.HNumerator}','{oSub.HDenominator}','{oSub.HBASEUNITID}','{oSub.HProcessID}','{oSub.HICMOENTRYSEQ}','{oSub.HPROJECTNO}','{oSub.HOPERID}','{oSub.HSEQ}','{oSub.HSTOCKSTATUSID}','{oSub.HLOT}','{oSub.HOPTQUEUE}','{oSub.HRESERVETYPE}','{oSub.HSelPickedQty}','{oSub.HSELPRCDRETURNQTY}','{oSub.HProcName}')"); } oCN.Commit(); objJsonResult.code = "1"; @@ -294,6 +354,7 @@ } catch (Exception e) { LogService.Write(e.Message.ToString()); oCN.RollBack(); objJsonResult.code = "0"; objJsonResult.count = 0; @@ -301,6 +362,7 @@ objJsonResult.data = null; return objJsonResult; } } @@ -350,6 +412,8 @@ string msg2 = sArray[0].ToString(); //主表æ°æ® 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 { @@ -380,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"); @@ -387,27 +453,46 @@ { //主表 oCN.RunProc(@"Insert Into Sc_ICMOBillMain (HBillType,HInterID,HBillNo,HDate,HPRDORGID (HBillType,HBillStatus,HInterID,HBillNo,HDate,HPRDORGID ,HYear,HPeriod,HRemark,HMaker,HMakeDate ,HSeOrderBillNo,HSeOrderInterID,HSeOrderEntryID,HEmpID,HCusID ,HCenterID,HPlanQty,HDeptID,HMaterID,HUnitID,HBomID,HPlanBeginDate,HPlanEndDate) values('3710'," + HInterID + ",'" + HBillNo + "','" + HDate + "'," + HPRDORGID + ,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) { //ä¿®æ¹ { if (ds.Tables[0].Rows[0]["å®¡æ ¸äºº"].ToString() != "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "åæ®å·²å®¡æ ¸,ä¸å 许修æ¹!"; objJsonResult.data = null; return objJsonResult; } //ä¿®æ¹ oCN.RunProc("update Sc_ICMOBillMain set " + "HRemark='" + HRemark + "', HChecker='" + HMaker + "', HCheckDate=getdate()" + ", HSeOrderBillNo='" + HSeOrderBillNo + "', HSeOrderInterID=" + HSeOrderInterID + ", HSeOrderEntryID=" + HSeOrderEntryID + ", HEmpID=" + HEmpID + ", HCusID=" + HCusID + "" + ", HCenterID=" + HCenterID + ",HBomID=" + HBomID + " where HInterID=" + HInterID); "HRemark='" + HRemark + "', HUpDater='" + HMaker + "', HUpDateDate=getdate()" + ", 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 + "'"); 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); objJsonResult = AddBillSub_NoTable(msg3, HInterID, OperationType, HEntryID); if (objJsonResult.code == "0") { @@ -434,9 +519,11 @@ } } public json AddBillSub_NoTable(string msg3, long HInterID, int OperationType) 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"; @@ -455,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) { @@ -473,28 +553,30 @@ return objJsonResult; } if (oSub.HBomID == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "BOMä¸è½ä¸ºç©º"; objJsonResult.data = null; return objJsonResult; } //if (oSub.HBomID == 0) //{ // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "BOMä¸è½ä¸ºç©º"; // objJsonResult.data = null; // return objJsonResult; //} oCN.RunProc($@"Insert into Sc_ICMOBillSub (HInterID,HENTRYID,HQty ,HPlanBeginDate,HPlanEndDate ,HBeginDate,HEndDate ,HMaterID,HUnitID,HRemark,HSourceID,HDeptID,HSTATUS ,HBomID,HEntryCusID ,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney) values({HInterID},1,{(oSub.HQty == null ? 0 : oSub.HQty)} ,HBomID,HEntryCusID,HSTOCKINORGID ,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} ,0,0,'','',0,0)"); ,{oSub.HBomID} ,{oSub.HCusID} ,{oSub.HSTOCKINORGID} ,0,0,'','',0,0 ,{oSub.HAuxQty},{oSub.HAuxUnit},{oSub.HWidth},{oSub.HWeight},'{oSub.HColorRemark}')"); objJsonResult.code = "1"; @@ -505,6 +587,241 @@ } #endregion #region ç产任å¡åå®¡æ ¸/åå®¡æ ¸åè½ [Route("Sc_ICMOBill/CheckSc_ICMOReportBill")] [HttpGet] public object CheckSc_ICMOReportBill(string HInterID,int Type, string user) { try { //å¤ææ¯å¦æå é¤æé if (!DBUtility.ClsPub.Security_Log("Sc_ICMOBill_Check", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ æéå®¡æ ¸!"; objJsonResult.data = null; return objJsonResult; } if (string.IsNullOrWhiteSpace(HInterID)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "HInterID为空ï¼"; objJsonResult.data = null; return objJsonResult; } ClsPub.CurUserName = user; oCN.BeginTran();//å¼å§äºå¡ //Type 1 å®¡æ ¸ 2 åå®¡æ ¸ if (Type == 1) { if (!BillOld.CheckBill(int.Parse(HInterID), ref ClsPub.sExeReturnInfo)) { objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "å®¡æ ¸å¤±è´¥!åå :" + ClsPub.sExeReturnInfo; objJsonResult.data = null; return objJsonResult; } } else { if (BillOld.AbandonCheck(int.Parse(HInterID), ref ClsPub.sExeReturnInfo)) { SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); DataSet DSet = oCn.RunProcReturn("exec h_p_Sc_ICMOBill_AbandonCheckCtrl " + int.Parse(HInterID), "h_p_Sc_ICMOBill_AbandonCheckCtrl"); //if (DBUtility.ClsPub.isInt(DSet.Tables[0].Rows[0]["Hback"]) != 0) //{ // objJsonResult.code = "0"; // objJsonResult.count = 1; // objJsonResult.Message = "该任å¡åå·²ä¸æ¨æµè½¬å¡ï¼ä¸å 许åå®¡æ ¸" + DBUtility.ClsPub.isStrNull(DSet.Tables[0].Rows[0]["HBackRemark"]); // objJsonResult.data = null; // return objJsonResult; //} } else { objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "å®¡æ ¸å¤±è´¥!åå :" + ClsPub.sExeReturnInfo; objJsonResult.data = null; return objJsonResult; } } oCN.Commit();//æ交äºå¡ objJsonResult.code = "0"; objJsonResult.count = 1; 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("Sc_ICMOBill/CloseSc_ICMOReportBill")] [HttpGet] public object CloseSc_ICMOReportBill(string HInterID, int Type, string user) { try { //å¤ææ¯å¦æå é¤æé if (!DBUtility.ClsPub.Security_Log("Sc_ICMOBill_Close", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ æéå ³é!"; objJsonResult.data = null; return objJsonResult; } if (string.IsNullOrWhiteSpace(HInterID)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "HInterID为空ï¼"; objJsonResult.data = null; return objJsonResult; } ClsPub.CurUserName = user; oCN.BeginTran();//å¼å§äºå¡ //Type 1 å ³é 2 åå ³é if (Type == 1) { if (!BillOld.CloseBill(int.Parse(HInterID), ref ClsPub.sExeReturnInfo)) { objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "å ³é失败!åå :" + ClsPub.sExeReturnInfo; objJsonResult.data = null; return objJsonResult; } } else { if (!BillOld.CancelClose(int.Parse(HInterID), ref ClsPub.sExeReturnInfo)) { objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "åå ³é失败!åå :" + ClsPub.sExeReturnInfo; objJsonResult.data = null; return objJsonResult; } } oCN.Commit();//æ交äºå¡ objJsonResult.code = "0"; objJsonResult.count = 1; 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("Sc_ICMOBill/CancellSc_ICMOReportBill")] [HttpGet] public object CancellSc_ICMOReportBill(string HInterID, int Type, string user) { try { //å¤ææ¯å¦æå é¤æé if (!DBUtility.ClsPub.Security_Log("Sc_ICMOBill_Delete", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ æéä½åº!"; objJsonResult.data = null; return objJsonResult; } if (string.IsNullOrWhiteSpace(HInterID)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "HInterID为空ï¼"; objJsonResult.data = null; return objJsonResult; } ClsPub.CurUserName = user; oCN.BeginTran();//å¼å§äºå¡ //Type 1 ä½åº 2 åä½åº if (Type == 1) { if (!BillOld.Cancelltion(int.Parse(HInterID), ref ClsPub.sExeReturnInfo)) { objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "ä½åºå¤±è´¥!åå :" + ClsPub.sExeReturnInfo; objJsonResult.data = null; return objJsonResult; } } else { if (!BillOld.AbandonCancelltion(int.Parse(HInterID), ref ClsPub.sExeReturnInfo)) { objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "åä½åºå¤±è´¥!åå :" + ClsPub.sExeReturnInfo; objJsonResult.data = null; return objJsonResult; } } oCN.Commit();//æ交äºå¡ objJsonResult.code = "0"; objJsonResult.count = 1; 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("Sc_ICMOBill/DeltetSc_ICMOReportBill")] [HttpGet] @@ -512,6 +829,8 @@ { try { string HComputerName = SystemInformation.ComputerName; //设å¤å称 //å¤ææ¯å¦æå é¤æé if (!DBUtility.ClsPub.Security_Log("Sc_ICMOBill_Drop", 1, false, user)) { @@ -540,8 +859,73 @@ objJsonResult.data = null; 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"; objJsonResult.count = 0; objJsonResult.Message = "åæ®ä¸æ¯æªå®¡æ ¸ç¶æ,ä¸å 许å é¤ï¼"; objJsonResult.data = null; 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; @@ -561,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] @@ -571,6 +1153,33 @@ DataSet oDs = new DataSet(); //========== oDs = oCN.RunProcReturn("select HItemID,HName from Gy_Department", "Gy_Department"); 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/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 = "è·åæåï¼"; @@ -1044,5 +1653,331 @@ #endregion #region [åæ¥åæ®] [Route("Sc_ICMOBill/Sc_ICMOBillViewApi")] [HttpGet] public json Sc_ICMOBillViewApi(string BillNo, string BillType) { string sql = string.Empty; string sReturn = ""; if (oSystemParameter.ShowBill(ref sReturn) == true) { //ç³»ç»åæ°æ¯å¦ä¸ºç§æäºæ¨¡å¼,Nä¸ºå ¬æäºæ¨¡å¼ï¼Y为ç§æäºæ¨¡å¼ if (oSystemParameter.omodel.WMS_CloudMode == "Y") { #region [ç§æäºæ¨¡å¼ï¼ç´æ¥è°ç¨æ°æ®åºåå¨è¿ç¨æ´æ°] try { oCN.BeginTran(); SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); DataSet DS = oCn.RunProcReturn("exec h_p_WMS_ERPSourceBillToLocal '" + BillNo + "','" + BillType + "'", "h_p_WMS_ERPSourceBillToLocal"); if (DS == null) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "åæ®åæ¥å¤±è´¥"; objJsonResult.data = null; return objJsonResult; } else { if (DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[0]["HBack"]) == "2") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "ERPä¸ä¸åå¨è¯¥åæ®å·"; objJsonResult.data = null; return objJsonResult; } else { objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "åæ®åæ¥æå"; 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 } else { #region [å ¬æäºæ¨¡å¼ï¼è°ç¨WEBAPIçæ¹å¼è¿è¡æ´æ°] var json = new { CreateOrgId = 0, Number = BillNo, Id = "" }; #region [éè¶é¨å] //ç»å½éè¶ var loginRet = InvokeHelper.Login(); var isSuccess = JObject.Parse(loginRet)["LoginResultType"].Value<int>(); //å¤ææ¯å¦ç»å½æå if (isSuccess < 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = loginRet; objJsonResult.data = null; return objJsonResult; } //æ¥ç è·åæ°æ® var _result = InvokeHelper.View("PRD_MO", JsonConvert.SerializeObject(json)); var _saveObj = JObject.Parse(_result); //å¤ææ°æ®æ¯å¦è·åæå if (_saveObj["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper() != "TRUE") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "éè¶ç产任å¡ååæ¥å¤±è´¥jsonRootï¼" + _result; objJsonResult.data = null; return objJsonResult; } #endregion //è·å主表æ°æ® DataSet Ds; Int64 InterID = 0; Ds = oCN.RunProcReturn("select * from Sc_ICMOBillMain where HBillNo = '" + BillNo + "'", "Sc_ICMOBillMain"); if (Ds.Tables[0].Rows.Count != 0 && ClsPub.isLong(Ds.Tables[0].Rows[0]["HInterID"].ToString()) != 0) { InterID = ClsPub.isLong(Ds.Tables[0].Rows[0]["HInterID"].ToString()); } #region [主表æ°æ®èµå¼] var jsonData = new { HInterID = _saveObj["Result"]["Result"]["Id"], HYear = DateTime.Now.Year, HPeriod = DateTime.Now.Month, HBillType = 3710, HDate = _saveObj["Result"]["Result"]["Date"], HBillNo = _saveObj["Result"]["Result"]["BillNo"], HBillStatus = _saveObj["Result"]["Result"]["ApproverId_Id"].ToString() == Convert.ToString(0) ? 1 : 2, HEMPID = 0, HRoutingInterID = 0, HPlanQty = 1, HRelationQty = 0, HPlanBeginDate = _saveObj["Result"]["Result"]["Date"], HPlanEndDate = DateTime.Now.ToString(), HBeginDate = _saveObj["Result"]["Result"]["Date"], HEndDate = DateTime.Now.ToString(), HMaterID = 0, HUnitID = 0, HBomID = 0, HBatchNo = "", HSourceInterID = 0, HSourceEntryID = 0, HSourceBillNo = "", HSourceBillType = "", HSeOrderInterID = 0, HSeOrderEntryID = 0, HSeOrderBillNo = "", HPRDORGID = _saveObj["Result"]["Result"]["PrdOrgId_Id"], HENTRUSTORGID = _saveObj["Result"]["Result"]["ENTrustOrgId_Id"], HOWNERID = _saveObj["Result"]["Result"]["OwnerId_Id"], HOWNERTYPEID = _saveObj["Result"]["Result"]["OwnerTypeId"], HCusID = 0, HDeptID = _saveObj["Result"]["Result"]["WorkShopID_Id"].ToString() == null ? 0 : _saveObj["Result"]["Result"]["WorkShopID_Id"], HRemark = "CLOUDå¯¼å ¥", HMTONo = "", HERPInterID = _saveObj["Result"]["Result"]["Id"], HERPBillType = _saveObj["Result"]["Result"]["BillType_Id"], HMaker = _saveObj["Result"]["Result"]["CreatorId"]["Name"], HMakeDate = _saveObj["Result"]["Result"]["CreateDate"], HChecker = _saveObj["Result"]["Result"]["ApproverId"]["Name"], HCheckDate = _saveObj["Result"]["Result"]["ApproveDate"], HBillSubType = _saveObj["Result"]["Result"]["IsRework"] = true ? 1 : 0, HISENTRUST = _saveObj["Result"]["Result"]["IsEntrust"], HISREWORK = _saveObj["Result"]["Result"]["IsRework"] }; #endregion // å é¤ä¸»è¡¨å¯¹åºæ°æ® sql = $"delete from Sc_ICMOBillMain where HInterID = " + InterID; oCN.RunProc(sql); //æå ¥ä¸»è¡¨ sql = $@" insert into Sc_ICMOBillMain (HInterID,HYear,HPeriod,HBillType,HDate ,HBillNo,HBillStatus,HEMPID,HRoutingInterID ,HPlanQty,HRelationQty,HPlanBeginDate,HPlanEndDate,HBeginDate,HEndDate ,HMaterID,HUnitID,HBomID,HBatchNo ,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HSeOrderInterID,HSeOrderEntryID,HSeOrderBillNo ,HPRDORGID,HENTRUSTORGID,HOWNERID,HOWNERTYPEID ,HCusID,HDeptID,HRemark,HMTONo,HERPInterID,HERPBillType ,HMaker,HMakeDate,HChecker,HCheckDate ,HBillSubType,HISENTRUST,HISREWORK ) values ({jsonData.HInterID},{jsonData.HYear},{jsonData.HPeriod},{jsonData.HBillType},'{jsonData.HDate}','{jsonData.HBillNo}', {jsonData.HBillStatus},{jsonData.HEMPID},{jsonData.HRoutingInterID},{jsonData.HPlanQty},{jsonData.HRelationQty}, '{jsonData.HPlanBeginDate}', '{jsonData.HPlanEndDate}','{jsonData.HBeginDate}','{jsonData.HEndDate}',{jsonData.HMaterID}, {jsonData.HUnitID},{jsonData.HBomID},'{jsonData.HBatchNo}',{jsonData.HSourceInterID},{jsonData.HSourceEntryID}, '{jsonData.HSourceBillNo}','{jsonData.HSourceBillType}',{jsonData.HSeOrderInterID}, {jsonData.HSeOrderEntryID},'{jsonData.HSeOrderBillNo}', {jsonData.HPRDORGID},{jsonData.HENTRUSTORGID},{jsonData.HOWNERID},'{jsonData.HOWNERTYPEID}',{jsonData.HCusID},{jsonData.HDeptID}, '{jsonData.HRemark}','{jsonData.HMTONo}',{jsonData.HERPInterID},'{jsonData.HERPBillType}','{jsonData.HMaker}','{jsonData.HMakeDate}', '{jsonData.HChecker}','{jsonData.HCheckDate}','{jsonData.HBillSubType}','{jsonData.HISENTRUST}','{jsonData.HISREWORK}')"; oCN.RunProc(sql); #region [ç³è¯·å表åé] var dataArr = _saveObj["Result"]["Result"]["TreeEntity"]; DataSet Cs; double RelationQty = 0; #endregion int i = 0; // è·åå表æ°æ® Cs = oCN.RunProcReturn("select * from Sc_ICMOBillSub where HInterID = " + InterID, "Sc_ICMOBillSub"); // å é¤å表对åºæ°æ® sql = $"delete from Sc_ICMOBillSub where HInterID = " + InterID; oCN.RunProc(sql); foreach (var oSub in dataArr) { #region [å表æ°æ®èµå¼] if (Cs.Tables[0].Rows.Count != 0 && ClsPub.isLong(Cs.Tables[0].Rows[0]["HInterID"].ToString()) != 0) { RelationQty = ClsPub.isDoule(Cs.Tables[0].Rows[i]["HRelationQty"].ToString()); i++; } var subData = new { HInterID = _saveObj["Result"]["Result"]["Id"], HENTRYID = oSub["Id"], HSEQ = oSub["Seq"], HQty = oSub["Qty"], HQTYMUST = oSub["Qty"], HRelationQty = RelationQty, HRelationMoney = 0, HPlanBeginDate = oSub["IdPlanStartDate"], HPlanEndDate = oSub["PlanFinishDate"], HBeginDate = oSub["StartDate"], HEndDate = oSub["FinishDate"], HBomID = oSub["BomId_Id"], HRemark = "CLOUDå¯¼å ¥", HMaterID = oSub["MaterialId_Id"], HUnitID = oSub["UnitId_Id"], HWHID = oSub["StockId_Id"], HSPID = oSub["StockLocId_Id"], HPROCID = oSub["ProcessId_Id"], HDEPTID = oSub["WorkShopID_Id"], HBatchNo = oSub["Lot_Text"], HSourceInterID = oSub["SrcBillId"], HSourceEntryID = oSub["SrcBillEntryId"], HSourceBillNo = oSub["SrcBillNo"], HSourceBillType = oSub["SrcBillType"], HSeOrderInterID = oSub["SaleOrderId"], HSeOrderEntryID = oSub["SaleOrderEntryId"], HSeOrderBillNo = oSub["SaleOrderNo"], HSTOCKINORGID = oSub["StockInOrgId_Id"], HINSTOCKOWNERID = oSub["InStockOwnerId_Id"], HINSTOCKOWNERTYPEID = oSub["InStockOwnerTypeId"], HREQUESTORGID = oSub["RequestOrgId_Id"], HPlanMode = 0, HMTONo = oSub["MTONo"], HERPInterID = _saveObj["Result"]["Result"]["Id"], HERPEntryID = oSub["Id"], HSTATUS = oSub["Status"], HEntryCusID = 0, HICMOReportRelationQty = oSub["RepQuaSelAuxQty"], HAuxPropID = oSub["AuxPropId_Id"], HProdMaterCode = "", HCusShortName = "", HCusNeedMaterial = "", HPlanSendGoodsDate = "", HProdMaterName = "", HWorkRemark = "", HImportNote = "", HCusName = "", HInstockQty_Max = 0, HInstockQty_Min = 0, HPickLabel = "", HPickLabelNumber = oSub["StockInLimitH"], HCusNumber = oSub["StockInLimitL"], HINSTOCKTYPE = oSub["InStockType"], HCHECKPRODUCT = oSub["CheckProduct"], HQAIP = oSub["QAIP"], HISBACKFLUSH = oSub["ISBACKFLUSH"], HREQSRC = oSub["ReqSrc"], HSTOCKINQUASELAUXQTY = oSub["StockInQuaSelAuxQty"], HSeOrderEntrySEQ = oSub["SaleOrderEntrySeq"], HPROJECTNO = oSub["ProjectNo"], HPRODUCTTYPE = oSub["ProductType"], HCOSTRATE = oSub["CostRate"], HBASEUNITID = oSub["BaseUnitId_Id"], }; #endregion //æå ¥å表 sql = $@" insert into Sc_ICMOBillSub (HInterID,HENTRYID,HSEQ,HQty,HQTYMUST,HRelationQty,HRelationMoney ,HPlanBeginDate,HPlanEndDate,HBeginDate,HEndDate,HBomID,HRemark ,HMaterID,HUnitID,HWHID,HSPID,HPROCID,HDEPTID,HBatchNo ,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType ,HSeOrderInterID,HSeOrderEntryID,HSeOrderBillNo ,HSTOCKINORGID,HINSTOCKOWNERID,HINSTOCKOWNERTYPEID,HREQUESTORGID ,HPlanMode,HMTONo,HERPInterID,HERPEntryID,HSTATUS ,HEntryCusID,HICMOReportRelationQty,HAuxPropID,HProdMaterCode,HCusShortName ,HCusNeedMaterial,HPlanSendGoodsDate,HProdMaterName,HWorkRemark,HImportNote,HCusName ,HInstockQty_Max,HInstockQty_Min,HPickLabel,HPickLabelNumber,HCusNumber ,HINSTOCKTYPE,HCHECKPRODUCT,HQAIP,HISBACKFLUSH,HREQSRC,HSTOCKINQUASELAUXQTY ,HSeOrderEntrySEQ,HPROJECTNO,HPRODUCTTYPE,HCOSTRATE,HBASEUNITID ) values ({subData.HInterID},{subData.HENTRYID},{subData.HSEQ},{subData.HQty},{subData.HQTYMUST},{subData.HRelationQty}, {subData.HRelationMoney},'{subData.HPlanBeginDate}','{subData.HPlanEndDate}','{subData.HBeginDate}','{subData.HEndDate}',{subData.HBomID}, '{subData.HRemark}',{subData.HMaterID},{subData.HUnitID},{subData.HWHID},{subData.HSPID},{subData.HPROCID},{subData.HDEPTID}, '{subData.HBatchNo}',{subData.HSourceInterID},{subData.HSourceEntryID},'{subData.HSourceBillNo}','{subData.HSourceBillType}', {subData.HSeOrderInterID},{subData.HSeOrderEntryID},'{subData.HSeOrderBillNo}',{subData.HSTOCKINORGID},{subData.HINSTOCKOWNERID}, '{subData.HINSTOCKOWNERTYPEID}',{subData.HREQUESTORGID},'{subData.HPlanMode}','{subData.HMTONo}',{subData.HERPInterID}, {subData.HERPEntryID},{subData.HSTATUS},{subData.HEntryCusID},{subData.HICMOReportRelationQty},{subData.HAuxPropID}, '{subData.HProdMaterCode}','{subData.HCusShortName}','{subData.HCusNeedMaterial}','{subData.HPlanSendGoodsDate}', '{subData.HProdMaterName}','{subData.HWorkRemark}','{subData.HImportNote}','{subData.HCusName}',{subData.HInstockQty_Max}, {subData.HInstockQty_Min},'{subData.HPickLabel}',{subData.HPickLabelNumber},{subData.HCusNumber},'{subData.HINSTOCKTYPE}', '{subData.HCHECKPRODUCT}','{subData.HQAIP}','{subData.HISBACKFLUSH}','{subData.HREQSRC}',{subData.HSTOCKINQUASELAUXQTY}, {subData.HSeOrderEntrySEQ},'{subData.HPROJECTNO}','{subData.HPRODUCTTYPE}',{subData.HCOSTRATE},{subData.HBASEUNITID})"; oCN.RunProc(sql); } objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "åæ®åæ¥æåï¼"; objJsonResult.data = null; return objJsonResult; #endregion } } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "åæ®è¯»å失败ï¼"; objJsonResult.data = null; return objJsonResult; } } #endregion } }
