From fe4782024b58742f763989b457973b95382adf7b Mon Sep 17 00:00:00 2001 From: ch <37327@LLOOCCY> Date: 星期四, 23 十二月 2021 14:45:34 +0800 Subject: [PATCH] 修改了 销售出库、产品入库单据缓存列表功能 --- DAL/WMS/ClsKF_PonderationBillMain_Temp_View.cs | 64 +++++++ WebAPI/Properties/PublishProfiles/FolderProfile.pubxml.user | 149 ++++++++-------- WebAPI/Controllers/SellOutController.cs | 85 +++++++++ DAL/WMS/ClsKF_PonderationBillMain_Temp_Ctl.cs | 35 +++ DBUtility/obj/Release/DBUtility.csproj.ResolveComReference.cache | 0 DBUtility/obj/Release/DBUtility.csprojAssemblyReference.cache | 0 WebAPI/WebServer.cs | 35 +++ WebAPI/Controllers/WebAPIController.cs | 39 ++++ WebAPI/Controllers/ProductInController.cs | 92 ++++++++++ WebAPI/WebAPI.csproj | 4 Model/obj/Release/Model.csprojAssemblyReference.cache | 0 11 files changed, 429 insertions(+), 74 deletions(-) diff --git a/DAL/WMS/ClsKF_PonderationBillMain_Temp_Ctl.cs b/DAL/WMS/ClsKF_PonderationBillMain_Temp_Ctl.cs index a2890db..938647e 100644 --- a/DAL/WMS/ClsKF_PonderationBillMain_Temp_Ctl.cs +++ b/DAL/WMS/ClsKF_PonderationBillMain_Temp_Ctl.cs @@ -14,6 +14,41 @@ + //宸蹭笂浼犲垪琛ㄧ晫闈紝鎾ら攢鍔熻兘锛屽垹闄MS琛ㄥ拰鏈湴鍑哄叆搴撳崟璁板綍锛屽苟鏇存柊TEMP琛ㄤ腑鐨勪笂浼犲瓧娈� HRelationInterID=0 + public bool DeleteICStockBillAndWMS(Int64 sHInterID, string sHBillNo, string sHBillType, ref string sErrMsg) + { + SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); + try + { + oCn.BeginTran(); + DataSet Ds = oCn.RunProcReturn("exec h_p_WMS_ICStockBillAndWMS_Delete " + sHInterID + ",'" + sHBillNo + "','" + sHBillType + "'", "h_p_WMS_ICStockBillAndWMS_Delete"); + if (Ds == null || Ds.Tables[0].Rows.Count == 0) + { + sErrMsg = "鎾ら攢鍗曟嵁澶辫触锛屾暟鎹簱杩炴帴澶辫触锛�"; + oCn.RollBack(); + return false; + } + if (DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0][0]) == 0) + { + sErrMsg = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HRemark"]); + oCn.Commit(); + return true; + } + else + { + sErrMsg = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HRemark"]); + oCn.RollBack(); + return false; + } + } + catch (Exception e) + { + sErrMsg = e.Message; + oCn.RollBack(); + return false; + } + } + //鍒ゆ柇鏉$爜 鍏ュ簱鏁伴噺鏄惁瓒呰繃鏉$爜鏈韩棰濆畾鏁伴噺 public bool IsBarCode(string sBarCode, string sBillType, bool sRedBlueFlag, ref double sQty, ref string sReturn) { diff --git a/DAL/WMS/ClsKF_PonderationBillMain_Temp_View.cs b/DAL/WMS/ClsKF_PonderationBillMain_Temp_View.cs index 55bbd3d..204ff44 100644 --- a/DAL/WMS/ClsKF_PonderationBillMain_Temp_View.cs +++ b/DAL/WMS/ClsKF_PonderationBillMain_Temp_View.cs @@ -25,6 +25,70 @@ // + #region 鍗曟嵁鍒楄〃鏁版嵁澶勭悊 + + //鏄剧ず鐗╂枡鏄庣粏鍒楄〃銆佹ā娌诲叿鍒楄〃銆佸厛杩涘厛鍑哄垪琛ㄤ俊鎭� + public DataSet GetBillEntry_TmpList(long HInterID, string HBillNo, string HBillType, ref string sMouldManagerCtl, ref string sFIFOCtl, ref string sErrMsg) + { + SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); + string sSimpleMode = "N"; //鏄惁鍚敤鎵爜绠�鏄撴ā寮忥紝鍙樉绀哄凡鎵爜婧愬崟璁板綍(Y,N) + + //鑾峰彇绯荤粺鍙傛暟 + Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter(); + if (oSystemParameter.ShowBill(ref sErrMsg) == false) + { + sErrMsg = "鍗曟嵁鍙凤細" + HBillNo + "锛屽崟鎹甀D锛�" + HInterID + "锛涜繑鍥炵墿鏂欐槑缁嗗垪琛ㄦ椂鑾峰彇绯荤粺鍙傛暟澶辫触锛� " + sErrMsg; + return null; + } + + //鍒ゆ柇鏄惁鍚敤鍣ㄥ叿绠$悊(Y,N) + if (oSystemParameter.omodel.WMS_MouldManagerCtl == "Y") //鍚敤妯℃不鍏风鐞� + { + sMouldManagerCtl = "Y"; + } + //鍒ゆ柇鏄惁鍚敤鍏堣繘鍏堝嚭绠$悊(Y,N)锛屾槸鍚﹀惎鐢ㄦ壂鐮佺畝鏄撴ā寮忥紝鍙樉绀哄凡鎵爜婧愬崟璁板綍(Y,N) + if (HBillType == "1204") //鐢熶骇棰嗘枡鍗� + { + if (oSystemParameter.omodel.Kf_MateOutBill_FIFOCtl == "Y") //鐢熶骇棰嗘枡鍗�-鍏堣繘鍏堝嚭鎺у埗 + { + sFIFOCtl = "Y"; + } + if (oSystemParameter.omodel.Kf_MateOutBill_SimpleMode == "Y") //鐢熶骇棰嗘枡鍗�-鎵爜绠�鏄撴ā寮� + { + sSimpleMode = "Y"; + } + } + if (HBillType == "1205" && oSystemParameter.omodel.Kf_SellOutBill_FIFOCtl == "Y") //閿�鍞嚭搴撳崟-鍏堣繘鍏堝嚭鎺у埗 + { + sFIFOCtl = "Y"; + } + if (HBillType == "1211" && oSystemParameter.omodel.Kf_EntrustOutBill_FIFOCtl == "Y") //濮斿鍑哄簱鍗�-鍏堣繘鍏堝嚭鎺у埗 + { + sFIFOCtl = "Y"; + } + + DataSet DS = oCn.RunProcReturn("exec h_p_WMS_BillEntryTmpList " + HInterID.ToString() + ",'" + HBillType + "','" + sMouldManagerCtl + "','" + sFIFOCtl + "','" + sSimpleMode + "'", "h_p_WMS_BillEntryTmpList"); + return DS; + } + + + #endregion + + + public DataSet GetKf_ICStockBillList(string sHBillType, string sHMaker, Int64 sHOWNERID) + { + SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); + DataSet Ds = oCn.RunProcReturn("exec h_p_Kf_ICStockBillList '" + sHBillType + "','" + sHMaker + "'," + sHOWNERID.ToString(), "h_p_Kf_ICStockBillList"); + if (Ds == null || Ds.Tables[0].Rows.Count == 0) + { + return null; + } + else + { + return Ds; + } + } + //鎵弿鏉$爜杩斿洖鍑哄叆搴撴潯鐮佷复鏃惰〃淇℃伅 public DataSet GetInfoByID_View(long HInterID, string sBillType, string sWhere) { diff --git a/DBUtility/obj/Release/DBUtility.csproj.ResolveComReference.cache b/DBUtility/obj/Release/DBUtility.csproj.ResolveComReference.cache index 9f5519e..a1123a1 100644 --- a/DBUtility/obj/Release/DBUtility.csproj.ResolveComReference.cache +++ b/DBUtility/obj/Release/DBUtility.csproj.ResolveComReference.cache Binary files differ diff --git a/DBUtility/obj/Release/DBUtility.csprojAssemblyReference.cache b/DBUtility/obj/Release/DBUtility.csprojAssemblyReference.cache index 07206dc..7bf5a5e 100644 --- a/DBUtility/obj/Release/DBUtility.csprojAssemblyReference.cache +++ b/DBUtility/obj/Release/DBUtility.csprojAssemblyReference.cache Binary files differ diff --git a/Model/obj/Release/Model.csprojAssemblyReference.cache b/Model/obj/Release/Model.csprojAssemblyReference.cache new file mode 100644 index 0000000..0a0fd3c --- /dev/null +++ b/Model/obj/Release/Model.csprojAssemblyReference.cache Binary files differ diff --git a/WebAPI/Controllers/ProductInController.cs b/WebAPI/Controllers/ProductInController.cs index 13a7233..fc04bad 100644 --- a/WebAPI/Controllers/ProductInController.cs +++ b/WebAPI/Controllers/ProductInController.cs @@ -165,6 +165,94 @@ } } + + + /// <summary> + /// 鐢熶骇鍏ュ簱缂撳瓨鍒楄〃缂栬緫鎸夐挳 鑾峰彇琛ㄤ綋淇℃伅 + /// </summary> + /// <param name="HSourceBillNo"></param> + /// <returns></returns> + [Route("ProdIn/ProdInDetaiNew")] + [HttpGet] + public object ProdInDetaiNew(string HInterID) + { + + DataSet ds; + List<object> list = new List<object>(); + string Swhere = ""; + try + { + if (HInterID != "" || HInterID != null) + { + Swhere = " and hmainid='" + HInterID + "'"; + } + else + { + Swhere = HInterID; + } + SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); + //鑾峰彇閿�鍞嚭搴撶紪杈戞暟鎹� + string sql = "select 鏁伴噺 HQty,搴旀敹鏁伴噺 HQtyMust,鐗╂枡浠g爜 HMaterNumber,鐗╂枡鍚嶇О HMaterName,瑙勬牸鍨嬪彿 HMaterModel,婧愬崟涓诲唴鐮� HSourceInterID,婧愬崟瀛愬唴鐮� HSourceEntryID,婧愬崟鍗曞彿 HSourceBillNo,鎵规 HBatchNo,杈呭姪灞炴�� HAuxPropID,璁″垝璺熻釜鍙� HMTONo,ck HWHID from h_v_SelloutDetail where 1 = 1 " + Swhere + ""; + ds = oCN.RunProcReturn(sql, "h_v_SelloutDetail"); + + list.Add(ds.Tables[0]); + objJsonResult.code = "0"; + objJsonResult.count = 1; + objJsonResult.Message = "鑾峰彇淇℃伅鎴愬姛锛�"; + objJsonResult.list = list; + } + catch (Exception e) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "娌℃湁杩斿洖浠讳綍璁板綍锛�" + e.ToString(); + objJsonResult.data = null; + } + return objJsonResult; + } + + + /// <summary> + /// 杩斿洖浜у搧鍏ュ簱鎵爜鏄庣粏 + /// </summary> + /// <returns></returns> + [Route("ProductIn/DisPlayBarCodeList_Json")] + [HttpGet] + public object DisPlayBarCodeList_Json(long HBillID, string HBillNo, string HBillType, string sMouldManagerCtl, string sFIFOCtl) + { + try + { + ds = webserver.GetBarcodeList(HBillID, HBillNo, HBillType, ref sMouldManagerCtl, ref sFIFOCtl, ref DBUtility.ClsPub.sErrInfo); + if (ds == null || ds.Tables[3].Rows.Count <= 0) + { + + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "娌℃湁杩斿洖浠讳綍璁板綍锛�"; + objJsonResult.data = null; + return objJsonResult; + //DBUtility.ClsPub.MessageBeep((int)DBUtility.ClsPub.BeepType.Warning); + } + else + { + objJsonResult.code = "0"; + objJsonResult.count = 1; + objJsonResult.Message = "鑾峰彇淇℃伅鎴愬姛锛�"; + objJsonResult.data = ds.Tables[3]; + return objJsonResult; + } + } + catch (Exception e) + { + + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "娌℃湁杩斿洖浠讳綍璁板綍锛�" + e.ToString(); + objJsonResult.data = null; + return objJsonResult; + } + } + [Route("ProductIn/DisBillEntryList_Mate_Webs_Json")] [HttpGet] public object DisBillEntryList_Mate_Webs_Json(string HBillType, string sWhere) @@ -210,6 +298,7 @@ [HttpGet] public object set_SavePonderationBillMain_Temp_Source_Fast_Json(string HSourceBillType, string HSourceBillNo, Int64 sInterID, string sBillNo) { + string aa = ""; try { // DataSet ds = new DataSet(); @@ -217,6 +306,7 @@ string sWhere = " Where 鍗曟嵁鍙� like '%" + HSourceBillNo.Trim() + "%'"; if (HSourceBillType == "3710") { + aa = "鎵ц浜�"; ds = webserver.GetSc_ICMOBillList(sWhere + " "); } if (HSourceBillType == "3711") @@ -227,7 +317,7 @@ { objJsonResult.code = "0"; objJsonResult.count = 0; - objJsonResult.Message = "娌℃湁杩斿洖浠讳綍璁板綍,婧愬崟绫诲瀷鏈夐敊璇紒"; + objJsonResult.Message = "娌℃湁杩斿洖浠讳綍璁板綍,婧愬崟绫诲瀷鏈夐敊璇紒"+aa; objJsonResult.data = null; return objJsonResult; ; } diff --git a/WebAPI/Controllers/SellOutController.cs b/WebAPI/Controllers/SellOutController.cs index b4a122e..3e0e9a6 100644 --- a/WebAPI/Controllers/SellOutController.cs +++ b/WebAPI/Controllers/SellOutController.cs @@ -64,6 +64,91 @@ } + /// <summary> + /// 閿�鍞嚭搴撶紦瀛樺垪琛ㄧ紪杈戞寜閽� 鑾峰彇琛ㄤ綋淇℃伅 + /// </summary> + /// <param name="HSourceBillNo"></param> + /// <returns></returns> + [Route("SellOut/SellOutDetaiNew")] + [HttpGet] + public object SellOutDetaiNew(string HInterID) + { + + DataSet ds; + List<object> list = new List<object>(); + string Swhere = ""; + try + { + if (HInterID != "" || HInterID != null) + { + Swhere = " and hmainid='" + HInterID + "'"; + } + else + { + Swhere = HInterID; + } + SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); + //鑾峰彇閿�鍞嚭搴撶紪杈戞暟鎹� + string sql = "select 鏁伴噺 HQty,搴旀敹鏁伴噺 HQtyMust,鐗╂枡浠g爜 HMaterNumber,鐗╂枡鍚嶇О HMaterName,瑙勬牸鍨嬪彿 HMaterModel,婧愬崟涓诲唴鐮� HSourceInterID,婧愬崟瀛愬唴鐮� HSourceEntryID,婧愬崟鍗曞彿 HSourceBillNo,鎵规 HBatchNo,杈呭姪灞炴�� HAuxPropID,璁″垝璺熻釜鍙� HMTONo,ck HWHID from h_v_SelloutDetail where 1 = 1 " + Swhere + ""; + ds = oCN.RunProcReturn(sql, "h_v_SelloutDetail"); + + list.Add(ds.Tables[0]); + objJsonResult.code = "0"; + objJsonResult.count = 1; + objJsonResult.Message = "鑾峰彇淇℃伅鎴愬姛锛�"; + objJsonResult.list = list; + } + catch (Exception e) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "娌℃湁杩斿洖浠讳綍璁板綍锛�" + e.ToString(); + objJsonResult.data = null; + } + return objJsonResult; + } + + + //宸蹭笂浼犲垪琛ㄥ埛鏂� + [Route("Web/DisBillUpdateLoad_Json")] + [HttpGet] + public object DisBillUpdateLoad_Json(string HBillType, string HMaker, Int64 HOrgID) + { + try + { + ds = webserver.GetDisBillUpdateLoad_Json(HBillType, HMaker, HOrgID); + if (ds == null || ds.Tables[0].Rows.Count <= 0) + { + + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "娌℃湁杩斿洖浠讳綍璁板綍锛�"; + objJsonResult.data = null; + return objJsonResult; + //DBUtility.ClsPub.MessageBeep((int)DBUtility.ClsPub.BeepType.Warning); + } + else + { + objJsonResult.code = "0"; + objJsonResult.count = 1; + objJsonResult.Message = "鑾峰彇淇℃伅鎴愬姛锛�"; + objJsonResult.data = ds.Tables[0]; + return objJsonResult; + } + } + catch (Exception e) + { + + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "娌℃湁杩斿洖浠讳綍璁板綍锛�" + e.ToString(); + objJsonResult.data = null; + return objJsonResult; + } + } + + + [Route("SellOut/GetMAXNum")] [HttpGet] public object GetMAXNum() diff --git a/WebAPI/Controllers/WebAPIController.cs b/WebAPI/Controllers/WebAPIController.cs index 8efa4cc..23d85d3 100644 --- a/WebAPI/Controllers/WebAPIController.cs +++ b/WebAPI/Controllers/WebAPIController.cs @@ -187,6 +187,45 @@ } + + //鎾ら攢缂撳瓨鍒楄〃璁板綍 + [Route("Web/Rescind_Json")] + [HttpGet] + public object Rescind_Json(long sHInterID, string sBillNo, string sBillType) + { + string sErrMsg = string.Empty; + try + { + if (webserver.RescindBillList(sHInterID, sBillNo, sBillType, ref sErrMsg)) + { + objJsonResult.code = "0"; + objJsonResult.count = 1; + objJsonResult.Message = "鍒犻櫎鎴愬姛锛�"; + objJsonResult.data = null; + return objJsonResult; + } + else + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍒犻櫎澶辫触锛�"; Web / GetOrganizations + objJsonResult.data = null; + return objJsonResult; + } + } + catch (Exception) + { + + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍒犻櫎澶辫触锛�"; + objJsonResult.data = null; + return objJsonResult; + } + + } + + //鍒犻櫎缂撳瓨鍒楄〃璁板綍 [Route("Web/Delete_Json")] [HttpGet] diff --git a/WebAPI/Properties/PublishProfiles/FolderProfile.pubxml.user b/WebAPI/Properties/PublishProfiles/FolderProfile.pubxml.user index 0db68b7..fdef600 100644 --- a/WebAPI/Properties/PublishProfiles/FolderProfile.pubxml.user +++ b/WebAPI/Properties/PublishProfiles/FolderProfile.pubxml.user @@ -9,7 +9,7 @@ </PropertyGroup> <ItemGroup> <File Include="apiapp.json"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>12/22/2021 19:58:34</publishTime> </File> <File Include="bin/Antlr3.Runtime.dll"> <publishTime>02/22/2013 08:43:40</publishTime> @@ -18,31 +18,31 @@ <publishTime>02/22/2013 08:43:40</publishTime> </File> <File Include="bin/BLL.dll"> - <publishTime>12/22/2021 13:51:29</publishTime> + <publishTime>12/22/2021 22:01:30</publishTime> </File> <File Include="bin/BLL.pdb"> - <publishTime>12/22/2021 13:51:29</publishTime> + <publishTime>12/22/2021 22:01:30</publishTime> </File> <File Include="bin/DAL.dll"> - <publishTime>12/22/2021 13:51:28</publishTime> + <publishTime>12/22/2021 22:01:29</publishTime> </File> <File Include="bin/DAL.pdb"> - <publishTime>12/22/2021 13:51:28</publishTime> + <publishTime>12/22/2021 22:01:29</publishTime> </File> <File Include="bin/Dapper.dll"> <publishTime>07/22/2016 14:52:40</publishTime> </File> <File Include="bin/DBUtility.dll"> - <publishTime>12/22/2021 13:51:26</publishTime> + <publishTime>12/22/2021 22:01:27</publishTime> </File> <File Include="bin/DBUtility.pdb"> - <publishTime>12/22/2021 13:51:26</publishTime> + <publishTime>12/22/2021 22:01:27</publishTime> </File> <File Include="bin/Interop.gregn6Lib.dll"> <publishTime>08/25/2021 10:28:25</publishTime> </File> <File Include="bin/Kingdee.BOS.WebApi.Client.dll"> - <publishTime>08/09/2021 09:06:25</publishTime> + <publishTime>12/22/2021 19:58:31</publishTime> </File> <File Include="bin/Kingdee.BOS.WebApi.FormService.dll"> <publishTime>09/20/2018 19:23:20</publishTime> @@ -60,34 +60,34 @@ <publishTime>07/25/2012 11:48:56</publishTime> </File> <File Include="bin/Model.dll"> - <publishTime>12/22/2021 13:51:26</publishTime> + <publishTime>12/22/2021 22:01:27</publishTime> </File> <File Include="bin/Model.pdb"> - <publishTime>12/22/2021 13:51:26</publishTime> + <publishTime>12/22/2021 22:01:27</publishTime> </File> <File Include="bin/Models/ClsSc_MouldScrapOutBillMain.cs"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>12/22/2021 19:58:34</publishTime> </File> <File Include="bin/Newtonsoft.Json.dll"> <publishTime>08/03/2014 20:33:56</publishTime> </File> <File Include="bin/Pub_Class.dll"> - <publishTime>12/22/2021 13:51:24</publishTime> + <publishTime>12/22/2021 22:01:25</publishTime> </File> <File Include="bin/Pub_Class.pdb"> - <publishTime>12/22/2021 13:51:24</publishTime> + <publishTime>12/22/2021 22:01:25</publishTime> </File> <File Include="bin/Pub_Control.dll"> - <publishTime>12/22/2021 13:51:25</publishTime> + <publishTime>12/22/2021 22:01:26</publishTime> </File> <File Include="bin/Pub_Control.pdb"> - <publishTime>12/22/2021 13:51:25</publishTime> + <publishTime>12/22/2021 22:01:26</publishTime> </File> <File Include="bin/SQLHelper.dll"> - <publishTime>12/22/2021 13:51:25</publishTime> + <publishTime>12/22/2021 22:01:26</publishTime> </File> <File Include="bin/SQLHelper.pdb"> - <publishTime>12/22/2021 13:51:25</publishTime> + <publishTime>12/22/2021 22:01:26</publishTime> </File> <File Include="bin/stdole.dll"> <publishTime>05/09/2021 13:35:37</publishTime> @@ -156,7 +156,7 @@ <publishTime>11/28/2018 13:01:00</publishTime> </File> <File Include="bin/System.Web.Http.WebHost.dll"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>12/22/2021 19:58:33</publishTime> </File> <File Include="bin/System.Web.Mvc.dll"> <publishTime>01/28/2015 04:02:18</publishTime> @@ -189,10 +189,13 @@ <publishTime>11/24/2014 11:18:48</publishTime> </File> <File Include="bin/WebAPI.dll"> - <publishTime>12/22/2021 13:51:31</publishTime> + <publishTime>12/22/2021 20:38:25</publishTime> + </File> + <File Include="bin/WebAPI.dll.config"> + <publishTime>12/22/2021 19:58:34</publishTime> </File> <File Include="bin/WebAPI.pdb"> - <publishTime>12/22/2021 13:51:31</publishTime> + <publishTime>12/22/2021 20:38:25</publishTime> </File> <File Include="bin/WebGrease.dll"> <publishTime>07/17/2013 17:03:52</publishTime> @@ -204,166 +207,166 @@ <publishTime>11/29/2018 13:26:30</publishTime> </File> <File Include="Content/bootstrap.css"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>12/22/2021 19:58:33</publishTime> </File> <File Include="Content/bootstrap.min.css"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>12/22/2021 19:58:33</publishTime> </File> <File Include="Content/Site.css"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>12/22/2021 19:58:33</publishTime> </File> <File Include="DLL/BLL.dll"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>12/22/2021 19:58:33</publishTime> </File> <File Include="DLL/DAL.dll"> - <publishTime>10/29/2021 17:42:10</publishTime> + <publishTime>12/22/2021 19:58:33</publishTime> </File> <File Include="DLL/DBUtility.dll"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>12/22/2021 19:58:33</publishTime> </File> <File Include="DLL/Kingdee.BOS.WebApi.Client.dll"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>12/22/2021 19:58:33</publishTime> </File> <File Include="DLL/Model.dll"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>12/22/2021 19:58:33</publishTime> </File> <File Include="DLL/Newtonsoft.Json.Net35.dll"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>12/22/2021 19:58:33</publishTime> </File> <File Include="DLL/Pub_Class.dll"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>12/22/2021 19:58:33</publishTime> </File> <File Include="DLL/Pub_Control.dll"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>12/22/2021 19:58:33</publishTime> </File> <File Include="DLL/SQLHelper.dll"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>12/22/2021 19:58:33</publishTime> </File> <File Include="fonts/glyphicons-halflings-regular.eot"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>12/22/2021 19:58:34</publishTime> </File> <File Include="fonts/glyphicons-halflings-regular.svg"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>12/22/2021 19:58:34</publishTime> </File> <File Include="fonts/glyphicons-halflings-regular.ttf"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>12/22/2021 19:58:34</publishTime> </File> <File Include="fonts/glyphicons-halflings-regular.woff"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>12/22/2021 19:58:34</publishTime> </File> <File Include="Global.asax"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>12/22/2021 19:58:33</publishTime> </File> <File Include="Index.html"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>12/22/2021 19:58:33</publishTime> </File> <File Include="Metadata/deploymentTemplates/apiappconfig.azureresource.json"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>12/22/2021 19:58:33</publishTime> </File> <File Include="packages.config"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>12/22/2021 19:58:34</publishTime> </File> <File Include="Views/Scripts/bootstrap.js"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>12/22/2021 19:58:34</publishTime> </File> <File Include="Views/Scripts/bootstrap.min.js"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>12/22/2021 19:58:34</publishTime> </File> <File Include="Views/Scripts/jquery-1.10.2.js"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>12/22/2021 19:58:34</publishTime> </File> <File Include="Views/Scripts/jquery-1.10.2.min.js"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>12/22/2021 19:58:34</publishTime> </File> <File Include="Views/Scripts/jquery-1.10.2.min.map"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>12/22/2021 19:58:34</publishTime> </File> <File Include="Views/Scripts/jquery.validate.js"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>12/22/2021 19:58:34</publishTime> </File> <File Include="Views/Scripts/jquery.validate.min.js"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>12/22/2021 19:58:34</publishTime> </File> <File Include="Views/Scripts/jquery.validate.unobtrusive.js"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>12/22/2021 19:58:34</publishTime> </File> <File Include="Views/Scripts/jquery.validate.unobtrusive.min.js"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>12/22/2021 19:58:34</publishTime> </File> <File Include="Views/Scripts/modernizr-2.6.2.js"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>12/22/2021 19:58:34</publishTime> </File> <File Include="Views/Shared/Error.cshtml"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>12/22/2021 19:58:34</publishTime> </File> <File Include="Views/Shared/_Layout.cshtml"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>12/22/2021 19:58:34</publishTime> </File> <File Include="Views/web.config"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>12/22/2021 19:58:34</publishTime> </File> <File Include="Views/_ViewStart.cshtml"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>12/22/2021 19:58:34</publishTime> </File> <File Include="Web References/WebS/ClsCLD_Customer_Model.datasource"> - <publishTime>08/10/2021 08:30:51</publishTime> + <publishTime>12/22/2021 19:58:34</publishTime> </File> <File Include="Web References/WebS/ClsCLD_Department_Model.datasource"> - <publishTime>08/10/2021 08:30:51</publishTime> + <publishTime>12/22/2021 19:58:34</publishTime> </File> <File Include="Web References/WebS/ClsCLD_Employee_Model.datasource"> - <publishTime>08/10/2021 08:30:51</publishTime> + <publishTime>12/22/2021 19:58:34</publishTime> </File> <File Include="Web References/WebS/ClsCLD_StockPlace_Model.datasource"> - <publishTime>08/10/2021 08:30:51</publishTime> + <publishTime>12/22/2021 19:58:34</publishTime> </File> <File Include="Web References/WebS/ClsCLD_Supplier_Model.datasource"> - <publishTime>08/10/2021 08:30:51</publishTime> + <publishTime>12/22/2021 19:58:34</publishTime> </File> <File Include="Web References/WebS/ClsCLD_Warehouse_Model.datasource"> - <publishTime>08/10/2021 08:30:51</publishTime> + <publishTime>12/22/2021 19:58:34</publishTime> </File> <File Include="Web References/WebS/ClsGy_BadReason_Model.datasource"> - <publishTime>08/10/2021 08:30:51</publishTime> + <publishTime>12/22/2021 19:58:34</publishTime> </File> <File Include="Web References/WebS/ClsGy_BarCodeBill_WMS_Model_View.datasource"> - <publishTime>08/10/2021 08:30:52</publishTime> + <publishTime>12/22/2021 19:58:34</publishTime> </File> <File Include="Web References/WebS/ClsGy_Customer_Model.datasource"> - <publishTime>08/10/2021 08:30:52</publishTime> + <publishTime>12/22/2021 19:58:34</publishTime> </File> <File Include="Web References/WebS/ClsGy_Department_Model.datasource"> - <publishTime>08/10/2021 08:30:52</publishTime> + <publishTime>12/22/2021 19:58:34</publishTime> </File> <File Include="Web References/WebS/ClsGy_Employee_Model.datasource"> - <publishTime>08/10/2021 08:30:52</publishTime> + <publishTime>12/22/2021 19:58:34</publishTime> </File> <File Include="Web References/WebS/ClsGy_Group_Model.datasource"> - <publishTime>08/10/2021 08:30:52</publishTime> + <publishTime>12/22/2021 19:58:34</publishTime> </File> <File Include="Web References/WebS/ClsGy_Item30JiTai_Model.datasource"> - <publishTime>08/10/2021 08:30:51</publishTime> + <publishTime>12/22/2021 19:58:34</publishTime> </File> <File Include="Web References/WebS/ClsGy_Source_Model.datasource"> - <publishTime>08/10/2021 08:30:52</publishTime> + <publishTime>12/22/2021 19:58:34</publishTime> </File> <File Include="Web References/WebS/ClsGy_StockPlace_Model.datasource"> - <publishTime>08/10/2021 08:30:52</publishTime> + <publishTime>12/22/2021 19:58:34</publishTime> </File> <File Include="Web References/WebS/ClsGy_Supplier_Model.datasource"> - <publishTime>08/10/2021 08:30:52</publishTime> + <publishTime>12/22/2021 19:58:34</publishTime> </File> <File Include="Web References/WebS/ClsGy_Warehouse_Model.datasource"> - <publishTime>08/10/2021 08:30:52</publishTime> + <publishTime>12/22/2021 19:58:34</publishTime> </File> <File Include="Web References/WebS/ClsKf_ICStockBill_WMS.datasource"> - <publishTime>08/10/2021 08:30:52</publishTime> + <publishTime>12/22/2021 19:58:34</publishTime> </File> <File Include="Web References/WebS/Reference.map"> <publishTime>08/06/2021 22:57:28</publishTime> </File> <File Include="Web.config"> - <publishTime>12/22/2021 13:51:36</publishTime> + <publishTime>12/22/2021 22:01:31</publishTime> </File> </ItemGroup> </Project> \ No newline at end of file diff --git a/WebAPI/WebAPI.csproj b/WebAPI/WebAPI.csproj index 9a7365c..6b102c6 100644 --- a/WebAPI/WebAPI.csproj +++ b/WebAPI/WebAPI.csproj @@ -173,6 +173,10 @@ <HintPath>..\packages\WebActivatorEx.2.0.6\lib\net40\WebActivatorEx.dll</HintPath> <Private>True</Private> </Reference> + <Reference Include="WebAPI, Version=1.0.0.0, Culture=neutral, processorArchitecture=x86"> + <SpecificVersion>False</SpecificVersion> + <HintPath>bin\WebAPI.dll</HintPath> + </Reference> <Reference Include="WebGrease, Version=1.5.2.14234, Culture=neutral, PublicKeyToken=31bf3856ad364e35, processorArchitecture=MSIL"> <HintPath>..\packages\WebGrease.1.5.2\lib\WebGrease.dll</HintPath> <Private>True</Private> diff --git a/WebAPI/WebServer.cs b/WebAPI/WebServer.cs index 6509869..b44ef78 100644 --- a/WebAPI/WebServer.cs +++ b/WebAPI/WebServer.cs @@ -7832,5 +7832,40 @@ return ds; } #endregion + + /// <summary> + /// 杩斿洖鎵爜鏄庣粏淇℃伅 + /// </summary> + public DataSet GetBarcodeList(long HInterID, string HBillNo, string sBillType, ref string sMouldManagerCtl, ref string sFIFOCtl, ref string sErrMsg) + { + DAL.ClsKF_PonderationBillMain_Temp_View bll = new DAL.ClsKF_PonderationBillMain_Temp_View(); + return bll.GetBillEntry_TmpList(HInterID, HBillNo, sBillType, ref sMouldManagerCtl, ref sFIFOCtl, ref sErrMsg); + //DAL.ClsKF_PonderationBillMain_Temp_View dal = new DAL.ClsKF_PonderationBillMain_Temp_View(); + //return dal.GetInfoByID_View(HInterID, sBillType, sWhere); + } + + //鎾ら攢缂撳瓨鍒楄〃閫変腑鏁版嵁 + public bool RescindBillList(Int64 sHInterID, string sBillNo, string sBillType, ref string sErrMsg) + { + DAL.ClsKF_PonderationBillMain_Temp_Ctl dal = new DAL.ClsKF_PonderationBillMain_Temp_Ctl(); + if (dal.DeleteICStockBillAndWMS(sHInterID, sBillNo, sBillType, ref sErrMsg)) + { + sErrMsg = "鍒犻櫎鎴愬姛锛�"; + return true; + } + else + { + sErrMsg = "鍒犻櫎澶辫触锛�"; + return false; + } + } + + //杩斿洖缂撳瓨鍒楄〃宸蹭笂浼犲垪琛ㄤ俊鎭� + public DataSet GetDisBillUpdateLoad_Json(string sHBillType, string HMaker, Int64 HOrgID) + { + DAL.ClsKF_PonderationBillMain_Temp_View dal = new DAL.ClsKF_PonderationBillMain_Temp_View(); + return dal.GetKf_ICStockBillList(sHBillType, HMaker, HOrgID); + } + } } \ No newline at end of file -- Gitblit v1.9.1