派生自 MES-WEB-API
| WebAPI/Controllers/CJGL/Cj_StationOutBillController.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| WebAPI/Controllers/JHGL/Gy_RoutingBillController.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| WebAPI/Controllers/SCGL/日计划管理/JIT_ICMOSortBillController.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| WebAPI/WebAPI.csproj | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 |
WebAPI/Controllers/CJGL/Cj_StationOutBillController.cs
@@ -181,14 +181,14 @@ objJsonResult.data = null; return objJsonResult; } if (HQCCheckID == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ£éªå没æéæ©ï¼"; objJsonResult.data = null; return objJsonResult; } //if (HQCCheckID == 0) //{ // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "æ£éªå没æéæ©ï¼"; // objJsonResult.data = null; // return objJsonResult; //} //if (HSourceID == 0) //{ // objJsonResult.code = "0"; WebAPI/Controllers/JHGL/Gy_RoutingBillController.cs
@@ -119,9 +119,9 @@ string msg2 = sArray[0].ToString(); string msg3 = sArray[1].ToString(); int hentryid = int.Parse(sArray[2].ToString());//å表ç顺åºid int OperationType = int.Parse(sArray[3].ToString());//æ°æ®ç±»å 1æ·»å 3ä¿®æ¹ string user = sArray[4].ToString();//ç¨æ·å //int hentryid = int.Parse(sArray[2].ToString());//å表ç顺åºid int OperationType = int.Parse(sArray[2].ToString());//æ°æ®ç±»å 1æ·»å 3ä¿®æ¹ string user = sArray[3].ToString();//ç¨æ·å try { //å¤ææ¯å¦æç¼è¾æé @@ -170,7 +170,9 @@ string HProductNum = mainList[0].HProductNum;//æåç¼å· string HVerNum = mainList[0].HVerNum;//çæ¬ if (OperationType == 1)//æ°å¢ ds = oCN.RunProcReturn("select * from h_v_Gy_RoutingBillList where hmainid=" + HInterID + " and åæ®å·='" + HBillNo + "'", "h_v_Gy_RoutingBillList"); if (OperationType == 1 && ds.Tables[0].Rows.Count == 0)//æ°å¢ { //主表 oCN.RunProc("Insert Into Gy_RoutingBillMain " + @@ -184,9 +186,9 @@ "," + HRoutingGroupID + "," + HUnitID + ",'" + HMaterNumber + "','" + HUnitNumber + "'," + Convert.ToString(HStandard ? 1 : 0) + "," + HMainGroupID + "," + HMainProcID + "," + HMainCenterID + ",'" + HMainTimeUnit + "'," + HMainUnitTime + "," + HMainWorkQty + "," + HMainPrice + "," + HStdSourceQty + "," + HAddSourceRate + "," + HPRDORGID + "," + HDelSourceRate + ",'"+ HPicNumVer + "','" + HPicNumAssemble + "','" + HMaterTexture + "','" + HProductNum + "','" + HVerNum + "',"+ HOrgID + ") "); ",'" + HPicNumVer + "','" + HPicNumAssemble + "','" + HMaterTexture + "','" + HProductNum + "','" + HVerNum + "'," + HOrgID + ") "); } else if (OperationType == 3) else if (OperationType == 3 || ds.Tables[0].Rows.Count != 0) { //ä¿®æ¹ oCN.RunProc("update Gy_RoutingBillMain set " + "HDate='" + HDate + @@ -200,10 +202,10 @@ ",HProductNum='" + HProductNum + "',HVerNum='" + HVerNum + "' where HInterID='" + HInterID + "'"); //å é¤å表 oCN.RunProc("delete from Gy_RoutingBillSub where HInterID='" + HInterID + "' and HEntryID='" + hentryid + "'"); oCN.RunProc("delete from Gy_RoutingBillSub where HInterID='" + HInterID+"'"); } //ä¿åå表 objJsonResult = AddBillSub(msg3, HInterID, hentryid); objJsonResult = AddBillSub(msg3, HInterID); if (objJsonResult.code == "0") { objJsonResult.code = "0"; @@ -255,7 +257,7 @@ } } public json AddBillSub(string msg3, long HInterID, int hentryid) public json AddBillSub(string msg3, long HInterID) { List<Gy_RoutingBillSub> DetailColl = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Gy_RoutingBillSub>>(msg3); int i = 0; @@ -284,7 +286,7 @@ ",HTechnologyParameter,HPicNum,HProcCheckNote" + ",HOverRate,HProcWorkNum" + ") values(" + HInterID + "," + (hentryid==-1?i: hentryid) + "," + oSub.HProcID.ToString() + ",'" + (hentryid == -1 ? i : hentryid) + "'," + oSub.HSupID.ToString() + "," + Convert.ToString(oSub.HSupFlag ? 1 : 0) + "" + + HInterID + "," + i + "," + oSub.HProcID.ToString() + ",'" + i + "'," + oSub.HSupID.ToString() + "," + Convert.ToString(oSub.HSupFlag ? 1 : 0) + "" + "," + oSub.HWorkQty.ToString() + "," + oSub.HCenterID.ToString() + ",'" + oSub.HTimeUnit.ToString() + "'," + oSub.HUnitTime.ToString() + "," + oSub.HReadyTime.ToString() + "," + oSub.HQueueTime.ToString() + "," + oSub.HMoveTime.ToString() + ",'" + oSub.HCloseMan + "'," + Convert.ToString(oSub.HCloseType ? 1 : 0) + ",'" + oSub.HRemark + "','" + oSub.HProcType + "'," + Convert.ToString(oSub.HNextProcFlag ? 1 : 0) + "," + Convert.ToString(oSub.HFlowProc ? 1 : 0) + WebAPI/Controllers/SCGL/Èռƻ®¹ÜÀí/JIT_ICMOSortBillController.cs
New file @@ -0,0 +1,56 @@ using System; using System.Collections.Generic; using System.Data; using System.Linq; using System.Web; using System.Web.Http; using WebAPI.Models; using Newtonsoft.Json; using Newtonsoft.Json.Linq; using System.Diagnostics; namespace WebAPI.Controllers.SCGL.æ¥è®¡å管ç { public class JIT_ICMOSortBillController : ApiController { private json objJsonResult = new json(); public DataSet ds = new DataSet(); public WebServer webserver = new WebServer(); SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); #region ç产æ¥è®¡å æ¥è¯¢ [Route("JIT_ICMOSortBill/JIT_ICMOSortBillList")] [HttpGet] public object JIT_ICMOSortBillList(string sWhere, string user) { try { //æ¥çæé if (!DBUtility.ClsPub.Security_Log("Sc_WorkBillSortBill_Query", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ æ¥çæéï¼"; objJsonResult.data = null; return objJsonResult; } ds = oCN.RunProcReturn("select * from h_v_Sc_ICMOSortBillList", "h_v_Sc_ICMOSortBillList"); 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 } } WebAPI/WebAPI.csproj
@@ -386,6 +386,7 @@ <Compile Include="Controllers\SCGL\Sc_ICBomBillController.cs" /> <Compile Include="Controllers\SCGL\æ¥è®¡å管ç\JIT_DayPlanPlatFormBillController.cs" /> <Compile Include="Controllers\SCGL\æ¥è®¡å管ç\JIT_DayPlanPlatFormImportController.cs" /> <Compile Include="Controllers\SCGL\æ¥è®¡å管ç\JIT_ICMOSortBillController.cs" /> <Compile Include="Controllers\SCGL\æ¥è®¡å管ç\NpoiHelper.cs" /> <Compile Include="Controllers\SCGL\æ¥è®¡å管ç\Sc_JIT_ComplementGoodBillController.cs" /> <Compile Include="Controllers\SCGL\æ¥è®¡å管ç\JIT_CompleteController..cs" /> @@ -836,6 +837,7 @@ <Folder Include="Views\Gy_RoutingGroup\" /> <Folder Include="Views\JIT_DayPlanPlatFormBill\" /> <Folder Include="Views\JIT_DayPlanPlatFormImport\" /> <Folder Include="Views\JIT_ICMOSortBillList\" /> <Folder Include="Views\KF_ICInventoryList_WMSBill\" /> <Folder Include="Views\Kf_ICStockBillMain\" /> <Folder Include="Views\Kf_ICStockInOutBill\" />
