WebAPI/Controllers/Sc_MouldRepairInBillListController.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
WebAPI/Controllers/仓存管理/扫码异常记录/KF_PonderationBillController.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
WebAPI/WebAPI.csproj | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 |
WebAPI/Controllers/Sc_MouldRepairInBillListController.cs
@@ -755,8 +755,15 @@ { try { ds = Sc_GetMoveStockBillList(sWhere); if (sWhere == null || sWhere.Equals("")) { ds = oCN.RunProcReturn("select * from h_v_IF_MoveStockBillList order by æ¥æ desc", "h_v_IF_MoveStockBillList"); } else { string sql = "select * from h_v_IF_MoveStockBillList where 1=1 " + sWhere+ "order by æ¥æ desc"; ds = oCN.RunProcReturn(sql, "h_v_IF_MoveStockBillList"); } if (ds == null || ds.Tables[0].Rows.Count <= 0) { objJsonResult.code = "0"; @@ -784,14 +791,6 @@ } } #region sqlè¯å¥ public static DataSet Sc_GetMoveStockBillList(string sWhere) { return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_IF_MoveStockBillList order by æ¥æ desc", "h_v_IF_MoveStockBillList"); } #endregion /// <summary> /// éå®åºåºåå表 /// </summary> WebAPI/Controllers/²Ö´æ¹ÜÀí/ɨÂëÒì³£¼Ç¼/KF_PonderationBillController.cs
New file @@ -0,0 +1,70 @@ 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_PonderationBillController : 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_PonderationBill/PonderationBillList")] [HttpGet] public object PonderationBillList(string HbarCode) { List<object> columnNameList = new List<object>(); try { ds = oCN.RunProcReturn("exec h_p_WMS_BarCodeStatusQuery '" + HbarCode + "'", "h_p_WMS_BarCodeStatusQuery"); 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/WebAPI.csproj
@@ -351,6 +351,7 @@ <Compile Include="Controllers\SCGL\Sc_ProductionReturnBillController.cs" /> <Compile Include="Controllers\SCGL\Sc_PackUnionBillController.cs" /> <Compile Include="Controllers\Sc_ProcessMangementController.cs" /> <Compile Include="Controllers\ä»å管ç\æ«ç å¼å¸¸è®°å½\KF_PonderationBillController.cs" /> <Compile Include="Controllers\ä»å管ç\è°æ¨çç¹\Kf_MoveStockRequestBillController.cs" /> <Compile Include="Controllers\ä»å管ç\颿åè´§\apiController.cs" /> <Compile Include="Controllers\ä»å管ç\颿åè´§\Kf_StepFoldOutBillController.cs" /> @@ -723,6 +724,7 @@ <Folder Include="Views\Gy_EquipType\" /> <Folder Include="Views\Kf_ICStockBillMain\" /> <Folder Include="Views\Kf_MoveStockRequestBill\" /> <Folder Include="Views\KF_PonderationBill\" /> <Folder Include="Views\kf_StepFoldinBill\" /> <Folder Include="Views\Kf_StepFoldOutBill\" /> <Folder Include="Views\MoveStockBill\" />