using HH.WMS.BLL;
|
using HH.WMS.BLL.Basic;
|
using HH.WMS.BLL.MoveStock;
|
using HH.WMS.Entitys;
|
using HH.WMS.Entitys.Common;
|
using HH.WMS.Entitys.MoveStock;
|
using HH.WMS.WebApi.Areas.Common.Controllers;
|
using Newtonsoft.Json;
|
using Newtonsoft.Json.Converters;
|
using System;
|
using System.Collections.Generic;
|
using System.Data;
|
using System.Linq;
|
using System.Net;
|
using System.Net.Http;
|
using System.Text;
|
using System.Web.Http;
|
|
namespace HH.WMS.WebApi.Areas.MoveStock.Controllers
|
{
|
public class MoveStockTaskController : BaseController
|
{
|
[HttpPost]
|
public string GetMoveStockTaskMsts(SearchModel model)
|
{
|
return ValidateToken(model.TokenId, t =>
|
{
|
long total;
|
StringBuilder str = new StringBuilder();
|
str.Append(" select * from TN_WM_MOVE_STOCK_TASK_MST where 1=1");
|
|
if (model.SearchCondition != null)
|
{ //判断是否页面第一次加载
|
// if (model.SearchCondition.CN_S_STOCK_CODE != "")
|
// {
|
// str.Append(" AND CN_S_STOCK_CODE ='" + model.SearchCondition.CN_S_STOCK_CODE + "'");
|
// }
|
// if (model.SearchCondition.CN_S_OP_MODE != "")
|
// {
|
// str.Append(" AND CN_S_OP_MODE ='" + model.SearchCondition.CN_S_OP_MODE + "'");
|
// }
|
// if (model.SearchCondition.CN_S_OP_NO != "")
|
// {
|
// str.Append(" AND CN_S_OP_NO like '%" + model.SearchCondition.CN_S_OP_NO + "%'");
|
// }
|
if (!string.IsNullOrEmpty(model.SearchCondition.CN_S_STATE.ToString()))
|
{
|
str.Append(" AND CN_S_STATE ='" + model.SearchCondition.CN_S_STATE + "'");
|
}
|
if (!string.IsNullOrEmpty(model.SearchCondition.CN_T_START.ToString()))
|
{
|
str.Append(" AND CN_T_CREATE >='" + model.SearchCondition.CN_T_START + "'");
|
}
|
if (!string.IsNullOrEmpty(model.SearchCondition.CN_T_END.ToString()))
|
{
|
str.Append(" AND CN_T_CREATE <= DateAdd(dd, 1, '" + model.SearchCondition.CN_T_END + "')");
|
}
|
}
|
|
DataTable dt = BLLCreator.Create<MoveStockTaskBLL>().GetDataList(str.ToString(), model.PageIndex, model.PageSize, out total, null);
|
dt.Columns["CN_S_START_AREA"].ReadOnly = false;
|
dt.Columns["CN_S_END_AREA"].ReadOnly = false;
|
foreach (DataRow dr in dt.Rows)
|
{
|
var startArea = BLLCreator.Create<TN_AB_B_STOCK_AREABLL>().GetStockAreaEntity(dr["CN_S_START_AREA"].ToString());
|
var endArea = BLLCreator.Create<TN_AB_B_STOCK_AREABLL>().GetStockAreaEntity(dr["CN_S_END_AREA"].ToString());
|
if (startArea != null)
|
{
|
dr["CN_S_START_AREA"] = startArea.CN_S_AREA_NAME;
|
}
|
if (endArea != null)
|
{
|
dr["CN_S_END_AREA"] = endArea.CN_S_AREA_NAME;
|
}
|
}
|
OperateResult res = OperateResult.Succeed(null, new { rows = dt, total = total });
|
IsoDateTimeConverter timeFormat = new IsoDateTimeConverter();
|
timeFormat.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
|
return JsonConvert.SerializeObject(res, timeFormat);
|
});
|
}
|
|
[HttpGet]
|
public string GetMoveStockTaskDtls(string guid)
|
{
|
var dt = BLLCreator.Create<DapperBLL<TN_WM_MOVE_STOCK_TASK_DTLEntity>>().GetDataTable(new { CN_PARENT_GUID = guid });
|
OperateResult res = OperateResult.Succeed("", dt);
|
return JsonConvert.SerializeObject(res);
|
}
|
|
[HttpGet]
|
public OperateResult Delete(string guid)
|
{
|
var result = BLL.BLLCreator.Create<MoveStockTaskBLL>().Delete(guid);
|
if (result.Success)
|
{
|
return OperateResult.Succeed();
|
}
|
return OperateResult.Error(result.Msg);
|
}
|
}
|
}
|
