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);
}
}
}