派生自 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 @@ -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) { @@ -301,13 +304,13 @@ ,HBeginDate,HEndDate ,HMaterID,HUnitID,HRemark,HSourceID,HDeptID,HSTATUS ,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney ,HCOSTRATE,HISBACKFLUSH,HBatchNo,HBomID,HCHECKPRODUCT,HSEQ) ,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 ,{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.HCOSTRATE},{oSub.HISBACKFLUSH},'{oSub.HBatchNo}',{oSub.HBomID},{oSub.HCHECKPRODUCT},{oSub.HSEQ},{oSub.HSTOCKINORGID})"); } foreach (var _item in _mainList) @@ -410,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 { @@ -440,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"); @@ -450,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) { @@ -470,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); @@ -814,6 +829,8 @@ { try { string HComputerName = SystemInformation.ComputerName; //设å¤å称 //å¤ææ¯å¦æå é¤æé if (!DBUtility.ClsPub.Security_Log("Sc_ICMOBill_Drop", 1, false, user)) { @@ -843,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"; @@ -852,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; @@ -1098,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]
