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
|
{
|
/// <summary>
|
/// 统一对象，读取值
|
/// </summary>
|
/// <returns></returns>
|
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<string, string> 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<string, string> 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);
|
|
}
|
/// <summary>
|
/// 导入零件的基础单价和最大最小库存量
|
/// </summary>
|
/// <returns></returns>
|
[HttpPost, Route("Item/ImportItemInfo")]
|
public IHttpActionResult ImportItemInfo()
|
{
|
string msg = "";
|
List<ItemWebEntity> model = new List<ItemWebEntity>();
|
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<List<ItemWebEntity>>(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);
|
|
}
|
|
|
/// <summary>
|
/// 根据器具类型找对应所需可以装入的零件
|
/// </summary>
|
/// <returns></returns>
|
[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);
|
|
}
|
|
/// <summary>
|
/// 修改上下限开启
|
/// </summary>
|
/// <returns></returns>
|
[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);
|
|
}
|
|
/// <summary>
|
/// 搜索上下限是否开启
|
/// </summary>
|
/// <returns></returns>
|
[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);
|
|
}
|
|
|
/// <summary>
|
/// 批量修改上限
|
/// </summary>
|
/// <returns></returns>
|
[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);
|
|
}
|
|
/// <summary>
|
/// 批量修改下限
|
/// </summary>
|
/// <returns></returns>
|
[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);
|
|
}
|
}
|
}
|
