WebAPI/Controllers/仓存管理/条码出入库记录/Kf_ICStockInOutBillController.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
WebAPI/Controllers/仓存管理/条码库存/KF_ICInventoryList_WMSBillController.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
WebAPI/WebAPI.csproj | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 |
WebAPI/Controllers/²Ö´æ¹ÜÀí/ÌõÂë³öÈë¿â¼Ç¼/Kf_ICStockInOutBillController.cs
New file @@ -0,0 +1,96 @@ using Newtonsoft.Json; using Newtonsoft.Json.Converters; using System; using System.Collections.Generic; using System.Data; using System.Linq; using System.Web; using System.Web.Http; using WebAPI.Models; namespace WebAPI.Controllers.ä»å管ç.æ¡ç åºå ¥åºè®°å½ { public class Kf_ICStockInOutBillController : ApiController { public DBUtility.ClsPub.Enum_BillStatus BillStatus;//åæ®ç¶æï¼æ°å¢ï¼ä¿®æ¹ï¼æµè§ï¼æ´æ°åä»·ï¼åæ´ï¼ private json objJsonResult = new json(); public DataSet ds = new DataSet(); SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); //åå¨è¿ç¨ æ°æ® ç±» public class Data { public Data() { HStartDate = DateTime.Now.AddMonths(-1); HEndDate = DateTime.Now; BillType = "å ¨é¨"; } public DateTime HStartDate;//å¼å§æ¥æ public DateTime HEndDate;//ç»ææ¥æ public string MaterialName;//ç©æ public string sWH;//ä»åº public string sSP;//ä»ä½ public string sBatchNo;//æ¹å· public string HBarCode;//æ¡å½¢ç public string BillType;//åæ®ç±»å public string BillNo;//åæ®å· public string SeOrderBillNo;//(éå®è®¢åå·) } #region åºå ¥åºè®°å½æ¥è¯¢ [Route("Kf_ICStockInOutBill/StockInOutBillList")] [HttpGet] public object StockInOutBillList(string sWhere) { List<object> columnNameList = new List<object>(); try { var data = JsonConvert.DeserializeObject<Data>(sWhere); ds = oCN.RunProcReturn("exec h_p_Kf_BarCodeOutInReport '" + data.HStartDate + "','" + data.HEndDate + "','" + data.MaterialName + "','" + data.sWH + "','" + data.sSP + "','" + data.sBatchNo + "','" + data.HBarCode + "','" + data.BillType + "','" + data.BillNo + "','" + data.SeOrderBillNo + "'", "h_p_Kf_BarCodeOutInReport"); foreach (DataColumn col in ds.Tables[0].Columns) { Type dataType = col.DataType; string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//è·åå°DataColumnå对象çåå } if (ds.Tables[0].Rows.Count > 0) { objJsonResult.code = "1"; objJsonResult.count = ds.Tables[0].Rows.Count; objJsonResult.Message = "è·åèµæºç»å®æ°æ®æåï¼"; objJsonResult.data = JsonConvert.DeserializeObject<DataTable>(JsonConvert.SerializeObject(ds.Tables[0], new IsoDateTimeConverter { DateTimeFormat = "yyyy-MM-dd HH:mm:ss" })); //åºååDataSetä¸çæ¶é´æ ¼å¼ï¼ç¶ååååºåå忥 objJsonResult.list = columnNameList; return objJsonResult; } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "ææ èµæºç»å®ï¼"; objJsonResult.data = null; objJsonResult.list = columnNameList; return objJsonResult; } } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = e.Message.ToString(); objJsonResult.data = null; objJsonResult.list = columnNameList; } return objJsonResult; } #endregion } } WebAPI/Controllers/²Ö´æ¹ÜÀí/ÌõÂë¿â´æ/KF_ICInventoryList_WMSBillController.cs
New file @@ -0,0 +1,86 @@ using Newtonsoft.Json; using Newtonsoft.Json.Converters; using System; using System.Collections.Generic; using System.Data; using System.Linq; using System.Web; using System.Web.Http; using WebAPI.Models; namespace WebAPI.Controllers.ä»å管ç.æ¡ç åºå { public class KF_ICInventoryList_WMSBillController : ApiController { public DBUtility.ClsPub.Enum_BillStatus BillStatus;//åæ®ç¶æï¼æ°å¢ï¼ä¿®æ¹ï¼æµè§ï¼æ´æ°åä»·ï¼åæ´ï¼ private json objJsonResult = new json(); public DataSet ds = new DataSet(); SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); #region æ¡ç åºåæ¥è¯¢å表 [Route("KF_ICInventoryList_WMSBill/GetWMSBillList")] [HttpGet] public object GetWMSBillList(int page, int limit,string sWhere) { //page é¡µæ° //limit 页颿¾ç¤ºçè¡æ° //sWhereæ¨¡ç³æ¥è¯¢ æ¡ä»¶ List<object> columnNameList = new List<object>(); try { //å页SQLè¯å¥ string sql = "select top "+limit+ " (select count(*) from h_v_KF_ICInventoryList_WMS) æ»æ°, * from (select row_number() over(order by HMaterID asc)" + " as rownumber, * from h_v_KF_ICInventoryList_WMS) temp_row where rownumber >"+((page-1)*limit)+" "; if (sWhere == null || sWhere.Equals("")) { ds = oCN.RunProcReturn(sql, "h_v_KF_ICInventoryList_WMS"); } else { ds = oCN.RunProcReturn(sql + sWhere, "h_v_KF_ICInventoryList_WMS"); } //è·åè¡¨å¤´åæ®µåç§° foreach (DataColumn col in ds.Tables[0].Columns) { Type dataType = col.DataType; string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//è·åå°DataColumnå对象çåå } if (ds.Tables[0].Rows.Count > 0) { objJsonResult.code = "1"; objJsonResult.count =int.Parse(ds.Tables[0].Rows[0]["æ»æ°"].ToString()); objJsonResult.Message = "è·åèµæºç»å®æ°æ®æåï¼"; objJsonResult.data = JsonConvert.DeserializeObject<DataTable>(JsonConvert.SerializeObject(ds.Tables[0], new IsoDateTimeConverter { DateTimeFormat = "yyyy-MM-dd HH:mm:ss" })); //åºååDataSetä¸çæ¶é´æ ¼å¼ï¼ç¶ååååºåå忥 objJsonResult.list = columnNameList; return objJsonResult; } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "ææ èµæºç»å®ï¼"; objJsonResult.data = null; objJsonResult.list = columnNameList; return objJsonResult; } } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = e.Message.ToString(); objJsonResult.data = null; objJsonResult.list = columnNameList; } return objJsonResult; } #endregion } } WebAPI/WebAPI.csproj
@@ -352,6 +352,8 @@ <Compile Include="Controllers\SCGL\Sc_PackUnionBillController.cs" /> <Compile Include="Controllers\Sc_ProcessMangementController.cs" /> <Compile Include="Controllers\ä»å管ç\æ«ç å¼å¸¸è®°å½\KF_PonderationBillController.cs" /> <Compile Include="Controllers\ä»å管ç\æ¡ç åºå ¥åºè®°å½\Kf_ICStockInOutBillController.cs" /> <Compile Include="Controllers\ä»å管ç\æ¡ç åºå\KF_ICInventoryList_WMSBillController.cs" /> <Compile Include="Controllers\ä»å管ç\è°æ¨çç¹\Kf_MoveStockRequestBillController.cs" /> <Compile Include="Controllers\ä»å管ç\颿åè´§\apiController.cs" /> <Compile Include="Controllers\ä»å管ç\颿åè´§\Kf_StepFoldOutBillController.cs" /> @@ -722,7 +724,9 @@ <Folder Include="App_Data\" /> <Folder Include="Views\Cg_PurchaseReturn\" /> <Folder Include="Views\Gy_EquipType\" /> <Folder Include="Views\KF_ICInventoryList_WMSBill\" /> <Folder Include="Views\Kf_ICStockBillMain\" /> <Folder Include="Views\Kf_ICStockInOutBill\" /> <Folder Include="Views\Kf_MoveStockRequestBill\" /> <Folder Include="Views\KF_PonderationBill\" /> <Folder Include="Views\kf_StepFoldinBill\" />