using IWareDataAccess.Entity.Base; using IWareDataAccess.Helper; using IWareDataAccess.ReturnEntity; using IWareDataAccess.ReturnEntity.Base; using IWareDataAccess.ReturnEntity.Sys; using Newtonsoft.Json; using System; using System.Collections.Generic; using System.Linq; using System.Net; using System.Net.Http; using System.Web; using System.Web.Http; namespace WebApi_QQJF.Controllers { public class ItemController : ApiController { /// /// 统一对象,读取值 /// /// private ItemWebEntity GetEntity() { ItemWebEntity model = new ItemWebEntity(); HttpContextBase context = (HttpContextBase)Request.Properties["MS_HttpContext"];//获取传统context HttpRequestBase request = context.Request;//定义传统request对象 WebHelper.WebHelper.GetRequest(request, model); return model; } [HttpPost, Route("Item/Search")] public IHttpActionResult Search(int page) { int onePageNum = 20; return SearchFunc(page, onePageNum); } [HttpPost, Route("Item/Search")] public IHttpActionResult Search(int page, int onePageNum) { return SearchFunc(page, onePageNum); } private IHttpActionResult SearchFunc(int page, int onePageNum) { string msg = ""; ItemWebEntity model = new ItemWebEntity(); model = GetEntity(); //转dic Dictionary dic = Helper.EntityToDictionary(model); //调用查询方法 ReturnSearchItemView returnData = new ReturnSearchItemView(); returnData.code = 0; returnData.num = IWareDataAccess.Base.ITEM.ItemSqlFunc.SearchViewNum(model, out msg); returnData.page = page; returnData.pageNum = (returnData.num - 1) / 20 + 1; returnData.data = IWareDataAccess.Base.ITEM.ItemSqlFunc.SearchView(model, page, onePageNum); returnData.msg = msg; //返回JSON结果 return Json(returnData); } [HttpPost, Route("Item/GetAllItem")] public IHttpActionResult GetAllItem() { ItemWebEntity model = new ItemWebEntity(); model = GetEntity(); //转dic Dictionary dic = Helper.EntityToDictionary(model); var data = IWareDataAccess.Base.ITEM.ItemSqlFunc.SearchAllView(model); //返回JSON结果 return Json(data); } [HttpPost, Route("Item/AddOrUpdate")] public IHttpActionResult AddOrUpdate() { string msg = ""; ItemWebEntity model = new ItemWebEntity(); model = GetEntity(); //调用查询方法 bool result = IWareDataAccess.Base.ITEM.ItemSqlFunc.AddOrUpdate(model,out msg); ReturnResultAndMsg returnData = new ReturnResultAndMsg(); returnData.code = result ? 0 : 1; returnData.msg = msg; //返回JSON结果 return Json(returnData); } [HttpPost, Route("Item/Delete")] public IHttpActionResult Delete() { string msg = ""; ItemWebEntity model = new ItemWebEntity(); model = GetEntity(); //调用查询方法 bool result = IWareDataAccess.Base.ITEM.ItemSqlFunc.Delete(model,out msg); ReturnResultAndMsg returnData = new ReturnResultAndMsg(); returnData.code = result ? 0 : 1; returnData.msg = msg; //返回JSON结果 return Json(returnData); } /// /// 导入零件的基础单价和最大最小库存量 /// /// [HttpPost, Route("Item/ImportItemInfo")] public IHttpActionResult ImportItemInfo() { string msg = ""; List model = new List(); HttpContextBase context = (HttpContextBase)Request.Properties["MS_HttpContext"];//获取传统context HttpRequestBase request = context.Request;//定义传统request对象 string Items = request.Form["items"]; string userName = request.Form["userName"]; model = JsonConvert.DeserializeObject>(Items); //调用查询方法 bool bl = IWareDataAccess.Base.ITEM.ItemSqlFunc.ImportItemInfo(model, userName, out msg); ReturnResultAndMsg returnData = new ReturnResultAndMsg(); returnData.code = bl ? 0 : 1; returnData.msg = msg; //返回JSON结果 return Json(returnData); } /// /// 根据器具类型找对应所需可以装入的零件 /// /// [HttpPost, Route("Item/GetItemByContainerType")] public IHttpActionResult GetItemByContainerType() { string msg = ""; HttpContextBase context = (HttpContextBase)Request.Properties["MS_HttpContext"];//获取传统context HttpRequestBase request = context.Request;//定义传统request对象 string itemName = request.Form["itemName"]; string containerType = request.Form["containerType"]; //调用查询方法 var result = IWareDataAccess.Base.ITEM.ItemSqlFunc.GetItemByContainerType(itemName,containerType, out msg); //返回JSON结果 ReturnCommonItem returnData = new ReturnCommonItem(); returnData.data = result; returnData.code = string.IsNullOrEmpty(msg) ? 0 : 1; returnData.msg = msg; return Json(returnData); } /// /// 修改上下限开启 /// /// [HttpPost, Route("Item/UpdateStorageEnable")] public IHttpActionResult UpdateStorageEnable() { string msg = ""; ItemWebEntity model = new ItemWebEntity(); model = GetEntity(); //调用查询方法 bool result = IWareDataAccess.Base.ITEM.ItemSqlFunc.UpdateStorageEnable(model, out msg); ReturnResultAndMsg returnData = new ReturnResultAndMsg(); returnData.code = result ? 0 : 1; returnData.msg = msg; //返回JSON结果 return Json(returnData); } /// /// 搜索上下限是否开启 /// /// [HttpPost, Route("Item/SearchStorageEnable")] public IHttpActionResult SearchStorageEnable() { string msg = ""; ItemWebEntity model = new ItemWebEntity(); model = GetEntity(); //调用查询方法 bool result = IWareDataAccess.Base.ITEM.ItemSqlFunc.SearchStorageEnable(model, out msg); ReturnResultAndMsg returnData = new ReturnResultAndMsg(); returnData.code = result ? 0 : 1; returnData.msg = msg; //返回JSON结果 return Json(returnData); } /// /// 批量修改上限 /// /// [HttpPost, Route("Item/UpdateMaxStorage")] public IHttpActionResult UpdateMaxStorage() { string msg = ""; ItemWebEntity model = new ItemWebEntity(); model = GetEntity(); //调用查询方法 bool result = IWareDataAccess.Base.ITEM.ItemSqlFunc.UpdateMaxStorage(model, out msg); ReturnResultAndMsg returnData = new ReturnResultAndMsg(); returnData.code = result ? 0 : 1; returnData.msg = msg; //返回JSON结果 return Json(returnData); } /// /// 批量修改下限 /// /// [HttpPost, Route("Item/UpdateMinStorage")] public IHttpActionResult UpdateMinStorage() { string msg = ""; ItemWebEntity model = new ItemWebEntity(); model = GetEntity(); //调用查询方法 bool result = IWareDataAccess.Base.ITEM.ItemSqlFunc.UpdateMinStorage(model, out msg); ReturnResultAndMsg returnData = new ReturnResultAndMsg(); returnData.code = result ? 0 : 1; returnData.msg = msg; //返回JSON结果 return Json(returnData); } } }