using EnumType;
|
using IWareDataAccess.EF;
|
using IWareDataAccess.Entity.Base;
|
using IWareDataAccess.Entity.Order;
|
using IWareDataAccess.Helper;
|
using IWareDataAccess.ReturnEntity;
|
using IWareDataAccess.ReturnEntity.Order;
|
using Models.Input;
|
using Newtonsoft.Json;
|
using System;
|
using System.Collections.Generic;
|
using System.IO;
|
using System.Linq;
|
using System.Linq.Expressions;
|
using System.Net;
|
using System.Net.Http;
|
using System.Web;
|
using System.Web.Http;
|
|
namespace WebApi_QQJF.Controllers
|
{
|
/// <summary>
|
/// 送签单
|
/// </summary>
|
public class InOrderController : ApiController
|
{
|
/// <summary>
|
/// 统一对象，读取值
|
/// </summary>
|
/// <returns></returns>
|
private InOrderWebEntity GetEntity()
|
{
|
InOrderWebEntity model = new InOrderWebEntity();
|
HttpContextBase context = (HttpContextBase)Request.Properties["MS_HttpContext"];//获取传统context
|
HttpRequestBase request = context.Request;//定义传统request对象
|
|
WebHelper.WebHelper.GetRequest(request, model);
|
|
return model;
|
}
|
|
[HttpPost, Route("InOrder/Search")]
|
public IHttpActionResult Search(int page)
|
{
|
int onePageNum = 20;
|
return SearchFunc(page, onePageNum);
|
}
|
|
[HttpPost, Route("InOrder/Search")]
|
public IHttpActionResult Search(int page, int onePageNum)
|
{
|
return SearchFunc(page, onePageNum);
|
}
|
|
private static Expression<Func<View_ORDER_INORDER, bool>> GetFilter(InOrderWebEntity webEntity)
|
{
|
var f = PredicateBuilder.GetFilterExpression<InOrderWebEntity, View_ORDER_INORDER>(webEntity);
|
if (webEntity.InOrderPageType != null)
|
{//说明是要分页面查询 【EditBy shaocx,2022-11-01】
|
Expression<Func<View_ORDER_INORDER, bool>> newExpress = null;
|
InOrderPageTypeEnum inorderPageEnum = (InOrderPageTypeEnum)Enum.Parse(typeof(InOrderPageTypeEnum), webEntity.InOrderPageType.ToString());
|
switch (inorderPageEnum)
|
{
|
case InOrderPageTypeEnum.完工品输入页面:
|
newExpress = a => a.OrderStatusId != (int)InOrderStatusEnum.完工;
|
break;
|
}
|
if (newExpress != null)
|
{
|
f = f.And(newExpress);
|
}
|
}
|
return f;
|
}
|
|
private IHttpActionResult SearchFunc(int page, int onePageNum)
|
{
|
string msg = "";
|
InOrderWebEntity model = new InOrderWebEntity();
|
model = GetEntity();
|
//调用查询方法
|
var f = GetFilter(model);
|
ReturnSearchInOrderView returnData = new ReturnSearchInOrderView();
|
returnData.data = IWareDataAccess.Order.INORDER.InOrderSqlFunc.SearchView(f, page, onePageNum, out msg);
|
returnData.code = 0;
|
returnData.num = IWareDataAccess.Order.INORDER.InOrderSqlFunc.SearchViewNum(f);
|
returnData.page = page;
|
returnData.pageNum = (returnData.num - 1) / 20 + 1;
|
returnData.msg = msg;
|
//返回JSON结果
|
return Json(returnData);
|
}
|
|
/// <summary>
|
/// 导出冲压计划数据
|
/// </summary>
|
/// <returns></returns>
|
[HttpPost, Route("InOrder/ExportInOrder")]
|
public IHttpActionResult ExportInOrder(int page, int onePageNum)
|
{
|
string msg = "";
|
InOrderWebEntity model = new InOrderWebEntity();
|
model = GetEntity();
|
|
//调用查询方法
|
var f = GetFilter(model);
|
var data = IWareDataAccess.Order.INORDER.InOrderSqlFunc.ExportInOrder(f, page, onePageNum, out msg);
|
//返回JSON结果
|
return Json(data);
|
|
}
|
|
/// <summary>
|
/// 新建或修改送签单
|
/// </summary>
|
/// <returns></returns>
|
[HttpPost, Route("InOrder/AddOrUpdate")]
|
public IHttpActionResult AddOrUpdate()
|
{
|
string msg = "";
|
InOrderWebEntity model = new InOrderWebEntity();
|
model = GetEntity();
|
//调用查询方法
|
bool result = IWareDataAccess.Order.INORDER.InOrderSqlFunc.AddOrUpdate(model, out msg);
|
ReturnResultAndMsg returnData = new ReturnResultAndMsg();
|
returnData.code = result ? 0 : 1;
|
returnData.msg = msg;
|
//返回JSON结果
|
return Json(returnData);
|
}
|
|
[HttpPost, Route("InOrder/Add")]
|
public IHttpActionResult Add()
|
{
|
string msg = "";
|
InOrderWebEntity model = new InOrderWebEntity();
|
model = GetEntity();
|
model.orderStatus = "新建";
|
|
//调用查询方法
|
bool result = IWareDataAccess.Order.INORDER.InOrderSqlFunc.AddOrUpdate(model, out msg);
|
ReturnResultAndMsg returnData = new ReturnResultAndMsg();
|
returnData.code = result ? 0 : 1;
|
returnData.msg = msg;
|
//返回JSON结果
|
return Json(returnData);
|
}
|
|
[HttpPost, Route("InOrder/Update")]
|
public IHttpActionResult Update()
|
{
|
string msg = "";
|
InOrderWebEntity model = new InOrderWebEntity();
|
model = GetEntity();
|
//调用查询方法
|
bool result = IWareDataAccess.Order.INORDER.InOrderSqlFunc.AddOrUpdate(model, out msg);
|
ReturnResultAndMsg returnData = new ReturnResultAndMsg();
|
returnData.code = result ? 0 : 1;
|
returnData.msg = msg;
|
//返回JSON结果
|
return Json(returnData);
|
}
|
|
/// <summary>
|
/// 修改线下交付数量
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[HttpPost, Route("InOrder/UpdateUnlineNum")]
|
public IHttpActionResult UpdateUnlineNum(InOrderUnlineNumInput input)
|
{
|
if (string.IsNullOrEmpty(input.InOrderCode))
|
{
|
return Json(ReturnResultAndMsg.Fail("计划单号不能为空!"));
|
}
|
string msg = "";
|
//调用查询方法
|
bool result = IWareDataAccess.Order.INORDER.InOrderSqlFunc.UpdateUnlineNum(input, out msg);
|
ReturnResultAndMsg returnData = new ReturnResultAndMsg();
|
returnData.code = result ? 0 : 1;
|
returnData.msg = msg;
|
//返回JSON结果
|
return Json(returnData);
|
}
|
|
/// <summary>
|
/// 提交审核
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[HttpPost, Route("InOrder/Send")]
|
public IHttpActionResult Send(InOrderAuditInput input)
|
{
|
string msg = "";
|
string type = "提交审核";
|
|
if (string.IsNullOrEmpty(input.InOrderCode))
|
{
|
return Json(ReturnResultAndMsg.Fail("计划单号不能为空!"));
|
}
|
if (input.AuditUserId == null || input.AuditUserId == 0)
|
{
|
return Json(ReturnResultAndMsg.Fail("审核人不能为空!"));
|
}
|
|
//调用查询方法
|
bool result = IWareDataAccess.Order.INORDER.InOrderSqlFunc.UpdateStatus(input, type, out msg);
|
ReturnResultAndMsg returnData = new ReturnResultAndMsg();
|
returnData.code = result ? 0 : 1;
|
returnData.msg = msg;
|
//返回JSON结果
|
return Json(returnData);
|
}
|
|
[HttpPost, Route("InOrder/Check")]
|
public IHttpActionResult Check(InOrderAuditInput input)
|
{
|
if (string.IsNullOrEmpty(input.InOrderCode))
|
{
|
return Json(ReturnResultAndMsg.Fail("计划单号不能为空!"));
|
}
|
string msg = "";
|
string type = "审核通过";
|
//调用查询方法
|
bool result = IWareDataAccess.Order.INORDER.InOrderSqlFunc.UpdateStatus(input, type, out msg);
|
ReturnResultAndMsg returnData = new ReturnResultAndMsg();
|
returnData.code = result ? 0 : 1;
|
returnData.msg = msg;
|
//返回JSON结果
|
return Json(returnData);
|
}
|
|
[HttpPost, Route("InOrder/Reject")]
|
public IHttpActionResult Reject(InOrderAuditInput input)
|
{
|
if (string.IsNullOrEmpty(input.InOrderCode))
|
{
|
return Json(ReturnResultAndMsg.Fail("计划单号不能为空!"));
|
}
|
string msg = "";
|
string type = "驳回";
|
//调用查询方法
|
bool result = IWareDataAccess.Order.INORDER.InOrderSqlFunc.UpdateStatus(input, type, out msg);
|
ReturnResultAndMsg returnData = new ReturnResultAndMsg();
|
returnData.code = result ? 0 : 1;
|
returnData.msg = msg;
|
//返回JSON结果
|
return Json(returnData);
|
}
|
|
[HttpPost, Route("InOrder/Delete")]
|
public IHttpActionResult Delete()
|
{
|
string msg = "";
|
InOrderWebEntity model = new InOrderWebEntity();
|
model = GetEntity();
|
//调用查询方法
|
bool result = IWareDataAccess.Order.INORDER.InOrderSqlFunc.Delete(model, out msg);
|
ReturnResultAndMsg returnData = new ReturnResultAndMsg();
|
returnData.code = result ? 0 : 1;
|
returnData.msg = msg;
|
//返回JSON结果
|
return Json(returnData);
|
|
}
|
|
[HttpPost, Route("InOrder/GetCode")]
|
public IHttpActionResult GetCode()
|
{
|
string msg = "";
|
InOrderWebEntity model = new InOrderWebEntity();
|
model = GetEntity();
|
//调用查询方法
|
string result = IWareDataAccess.Order.INORDER.InOrderSqlFunc.GetCode();
|
//返回JSON结果
|
return Json(result);
|
|
}
|
|
/// <summary>
|
/// 导入冲压计划数据
|
/// </summary>
|
/// <returns></returns>
|
[HttpPost, Route("InOrder/ImportInOrder")]
|
public IHttpActionResult ImportInOrder()
|
{
|
string msg = "";
|
List<InOrderWebEntity> model = new List<InOrderWebEntity>();
|
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<InOrderWebEntity>>(Items);
|
//model = JsonConvert.DeserializeObject<List<InOrderExcelEntity>>(Items);
|
//string path = HttpContext.Current.Request.MapPath("~/");
|
//HttpPostedFile file = HttpContext.Current.Request.Files[0];
|
//bool bl = IWareDataAccess.Helper.ExcelHelper.UploadFiles(file, path, out msg); ;
|
//调用查询方法
|
bool bl = IWareDataAccess.Order.INORDER.InOrderSqlFunc.ImportInOrder(model, userName, out msg);
|
ReturnResultAndMsg returnData = new ReturnResultAndMsg();
|
returnData.code = bl ? 0 : 1;
|
returnData.msg = msg;
|
//返回JSON结果
|
return Json(returnData);
|
|
}
|
|
|
|
|
[HttpPost, Route("InOrder/ExcelTest")]
|
public IHttpActionResult ExcelTest()
|
{
|
string msg = "";
|
;
|
InOrderExcelEntity ent = new InOrderExcelEntity();
|
string path = HttpContext.Current.Request.MapPath("~/");
|
var file = HttpContext.Current.Request.Files[0].InputStream;
|
HttpPostedFile pf = HttpContext.Current.Request.Files[0];
|
string datetime = Helper.GetTimeStamp();
|
string strPath = @"c:\ImportExcel\" + datetime + "\\";//这里要注意的是先要建立File文件夹，不然会报错，也可以自己写一个检测文件夹，这里就先不赘述
|
if (!Directory.Exists(strPath))
|
{
|
Directory.CreateDirectory(strPath);
|
}
|
strPath += pf.FileName;
|
pf.SaveAs(strPath);
|
//Helper.StreamToFile(file, strPath);//需要用到下一步的帮助类将其保存为文件
|
bool bl = IWareDataAccess.Order.INORDER.InOrderSqlFunc.ImportExcel(strPath, ent, out msg);
|
ReturnResultAndMsg returnData = new ReturnResultAndMsg();
|
returnData.code = bl ? 0 : 1;
|
returnData.msg = msg;
|
//返回JSON结果
|
return Json(returnData);
|
|
}
|
}
|
}
|
