using HH.WMS.BLL;
|
using HH.WMS.BLL.Check;
|
using HH.WMS.BLL.Common;
|
using HH.WMS.Common;
|
using HH.WMS.Common.Algorithm;
|
using HH.WMS.Entitys;
|
using HH.WMS.Entitys.Basic;
|
using HH.WMS.Entitys.Check;
|
using HH.WMS.Entitys.Common;
|
using HH.WMS.WebApi.Areas.Common.Controllers;
|
using Newtonsoft.Json;
|
using Newtonsoft.Json.Converters;
|
using Newtonsoft.Json.Linq;
|
using System;
|
using System.Collections.Generic;
|
using System.Data;
|
using System.Linq;
|
using System.Net;
|
using System.Net.Http;
|
using System.Web.Http;
|
|
namespace HH.WMS.WebApi.Areas.Check.Controllers
|
{
|
public class CheckController : BaseController
|
{
|
#region 获取盘点主表分页
|
/// <summary>
|
/// 获取盘点主表分页
|
/// </summary>
|
/// <param name="obj"></param>
|
/// <returns></returns>
|
/// <History>[Hanhe(lt)] created by 2018-7-4</History>
|
[HttpPost]
|
public string GetDataTable(dynamic obj)
|
{
|
string tokenId = Util.ToString(obj.tokenId);
|
return ValidateToken(tokenId, t =>
|
{
|
DataTable dt = BLLCreator.Create<TN_WM_CHECK_MSTBLL>().GetDataTable(obj);
|
OperateResult res = OperateResult.Succeed(null, new { rows = dt, total = obj.PageCount });
|
IsoDateTimeConverter timeFormat = new IsoDateTimeConverter();
|
timeFormat.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
|
return JsonConvert.SerializeObject(res, timeFormat);
|
});
|
|
}
|
#endregion
|
|
#region 获取盘点单数据
|
public OperateResult GetModel(string opNo)
|
{
|
return ValidateToken(t =>
|
{
|
TN_WM_CHECK_MSTEntity mst = BLLCreator.Create<DapperBLL<TN_WM_CHECK_MSTEntity>>().GetSingleEntity(new { CN_S_OP_NO = opNo });
|
mst.dtls = BLLCreator.Create<DapperBLL<TN_WM_CHECK_DTLEntity>>().GetList(new { CN_S_OP_NO = opNo });
|
|
return OperateResult.Succeed("", mst);
|
});
|
}
|
#endregion
|
#region 获取盘点单子表
|
/// <summary>
|
/// 获取盘点明细
|
/// </summary>
|
/// <param name="obj"></param>
|
/// <returns></returns>
|
/// <history>[HanHe(lt)] CREATED 2018/12/6</history>
|
/// <history>[HanHe(dbs)] CREATED 2019/3/18</history>
|
public OperateResult GetCheckDtl(string opNo)
|
{
|
return ValidateToken(t =>
|
{
|
List<TN_WM_CHECK_DTLEntity> list = BLLCreator.Create<DapperBLL<TN_WM_CHECK_DTLEntity>>().GetList(new { CN_S_OP_NO = opNo });
|
return OperateResult.Succeed("", list);
|
});
|
}
|
#endregion
|
|
#region 获取盘点结果明细
|
/// <summary>
|
/// 获取盘点明细
|
/// </summary>
|
/// <param name="obj"></param>
|
/// <returns></returns>
|
/// <history>[HanHe(lt)] CREATED 2018/12/6</history>
|
/// <history>[HanHe(dbs)] CREATED 2019/3/18</history>
|
[HttpGet]
|
public OperateResult GetCheckList(string opNo)
|
{
|
return ValidateToken(t =>
|
{
|
List<TN_WM_CHECK_LISTEntity> list = BLLCreator.Create<DapperBLL<TN_WM_CHECK_LISTEntity>>().GetList(new { CN_S_OP_NO = opNo });
|
return OperateResult.Succeed("", list);
|
});
|
}
|
|
/// <summary>
|
/// 获取盘点明细
|
/// </summary>
|
/// <param name="obj"></param>
|
/// <returns></returns>
|
/// <history>[HanHe(lt)] CREATED 2018/12/6</history>
|
/// <history>[HanHe(dbs)] CREATED 2019/3/18</history>
|
[HttpGet]
|
public OperateResult GetChecklistGroup(string sqlWhere)
|
{
|
return ValidateToken(t =>
|
{
|
var list = BLLCreator.Create<TN_WM_CHECK_LISTBLL>().GetGroupDT(sqlWhere);
|
return OperateResult.Succeed("", list);
|
});
|
}
|
#endregion
|
|
#region 获取货位物料信息
|
/// <summary>
|
/// 获取货位物料信息
|
/// </summary>
|
/// <param name="obj">Json查询条件</param>
|
/// <returns></returns>
|
/// <history>[HanHe(lt)] CREATED 2018/7/12</history>
|
[HttpPost]
|
public OperateResult GetTrayLocation(SearchModel searchModel)
|
{
|
return ValidateToken(searchModel.TokenId, t =>
|
{
|
return BLLCreator.Create<TN_WM_CHECK_MSTBLL>().GetTrayLocation(searchModel);
|
});
|
}
|
|
#endregion
|
|
#region 新增
|
/// <summary>
|
///新增
|
/// </summary>
|
/// <param name="obj">Json实体类</param>
|
/// <returns></returns>
|
/// <history>[HanHe(lt)] CREATED 2018/7/13</history>
|
[HttpPost]
|
public OperateResult AddCheck(TN_WM_CHECK_MSTEntity mst)
|
{
|
return ValidateToken(mst.TokenId, t =>
|
{
|
//TN_WM_CHECK_MSTEntity entityMst = JsonConvert.DeserializeObject<TN_WM_CHECK_MSTEntity>(obj.Value<object>("entityMst").ToString());
|
//List<TN_WM_CHECK_DTLEntity> entityDtl = JsonConvert.DeserializeObject<List<TN_WM_CHECK_DTLEntity>>(obj.Value<object>("entityDtl").ToString());
|
return BLLCreator.Create<TN_WM_CHECK_MSTBLL>().Add(mst);
|
});
|
|
}
|
#endregion
|
|
#region 自定义新增
|
/// <summary>
|
///自定义新增
|
/// </summary>
|
/// <param name="entity"></param>
|
/// <returns></returns>
|
/// <history>[HanHe(lt)] CREATED 2018/7/13</history>
|
[HttpPost]
|
public OperateResult AddCheckBatch(JObject obj)
|
{
|
string tokenId = obj["tokenId"].ToString();
|
|
return ValidateToken(tokenId, t =>
|
{
|
TN_WM_CHECK_MSTEntity entityMst = JsonConvert.DeserializeObject<TN_WM_CHECK_MSTEntity>(obj.Value<object>("entityMst").ToString());
|
List<TN_WM_CHECK_DTLEntity> entityDtl = BLL.BLLCreator.Create<TN_WM_CHECK_MSTBLL>().Getlist(obj.Value<string>("sqlwhere").ToString(), obj.Value<string>("type").ToString());
|
entityMst.dtls = entityDtl;
|
return BLL.BLLCreator.Create<TN_WM_CHECK_MSTBLL>().Add(entityMst);
|
});
|
}
|
#endregion
|
|
#region 提交
|
/// <summary>
|
///提交
|
/// </summary>
|
/// <param name="entity"></param>
|
/// <returns></returns>
|
/// <history>[HanHe(lt)] CREATED 2018/8/24</history>
|
[HttpPost]
|
public OperateResult Submit(JObject obj)
|
{
|
string tokenid = obj["tokenid"].ToString();
|
return ValidateToken(tokenid, t =>
|
{
|
string[] opNos = obj.Value<object>("opNo").ToString().Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
|
return BLL.BLLCreator.Create<TN_WM_CHECK_MSTBLL>().Submit(opNos, t);
|
});
|
}
|
#endregion
|
|
#region 删除主子表
|
/// <summary>
|
///删除主子表
|
/// </summary>
|
/// <param name="entity"></param>
|
/// <returns></returns>
|
/// <history>[HanHe(lt)] CREATED 2018/8/24</history>
|
/// <history>[HanHe(dbs)] CREATED 2019/3/18</history>
|
[HttpGet]
|
public OperateResult Delete(string opNo)
|
{
|
return ValidateToken(t =>
|
{
|
return BLLCreator.Create<TN_WM_CHECK_MSTBLL>().Delete(opNo);
|
});
|
}
|
#endregion
|
|
#region 修改主子表
|
/// <summary>
|
/// 修改主子表
|
/// </summary>
|
/// <param name="obj">条件</param>
|
/// <returns></returns>
|
/// <history>[HanHe(lt)] CREATED 2018/8/24</history>
|
/// <history>[HanHe(dbs)] CREATED 2019/3/18</history>
|
public OperateResult Update(TN_WM_CHECK_MSTEntity mst)
|
{
|
return ValidateToken(mst.TokenId, t =>
|
{
|
//TN_WM_CHECK_MSTEntity entityMst = JsonConvert.DeserializeObject<TN_WM_CHECK_MSTEntity>(obj.Value<object>("entityMst").ToString());
|
|
//List<TN_WM_CHECK_DTLEntity> entityDtl = JsonConvert.DeserializeObject<List<TN_WM_CHECK_DTLEntity>>(obj.Value<object>("entityDtl").ToString());
|
|
return BLL.BLLCreator.Create<TN_WM_CHECK_MSTBLL>().Update(mst);
|
});
|
}
|
#endregion
|
|
#region 查询汇总盘点结果表
|
/// <summary>
|
///查询汇总盘点结果表
|
/// </summary>
|
/// <param name="obj"></param>
|
/// <returns></returns>
|
/// <History>[HanHe(DBS)] CREATED BY 2019-3-22</History>
|
[HttpPost]
|
public OperateResult CheckResultShow(SearchModel sm)
|
{
|
return ValidateToken(sm.TokenId, t =>
|
{
|
return BLLCreator.Create<DapperBLL<TN_WM_CHECK_LISTEntity>>().GetPagingResult(sm.PageIndex, sm.PageSize,
|
new
|
{
|
CN_S_OP_NO = Util.ToString(sm.SearchCondition.CN_S_OP_NO),
|
CN_S_STOCK_AREA = Util.ToString(sm.SearchCondition.CN_S_STOCK_AREA),
|
CN_S_ITEM_CODE = Util.ToString(sm.SearchCondition.CN_S_ITEM_CODE)
|
});
|
});
|
}
|
#endregion
|
|
#region 获取盘点子表
|
/// <summary>
|
/// 获取盘点子表不分页
|
/// </summary>
|
/// <param name="obj"></param>
|
/// <returns></returns>
|
/// <History>[Hanhe(lt)] created by 2018-7-13</History>
|
[HttpGet]
|
public string GetCheckMstDtlBywhere(string sqlwhere)
|
{
|
return ValidateToken(t =>
|
{
|
DataTable dt = BLLCreator.Create<TN_WM_CHECK_DTLBLL>().Getjoinentity(sqlwhere);
|
OperateResult result = OperateResult.Succeed(null, dt);
|
return JsonConvert.SerializeObject(result);
|
});
|
}
|
#endregion
|
|
#region DPA
|
#region 获取盘点清单
|
/// <summary>
|
/// 获取盘点清单
|
/// </summary>
|
/// <param name="opNo">盘点单号</param>
|
/// <param name="pageSize"></param>
|
/// <param name="pageIndex"></param>
|
/// <returns></returns>
|
/// <history>[HanHe(lt)] CREATED 2018/8/29</history>
|
[HttpGet]
|
|
public OperateResult GetCheckMst(string opNo, int pageSize, int pageIndex)
|
{
|
try
|
{
|
return ValidateToken(t =>
|
{
|
long total;
|
DataTable dt = BLLCreator.Create<DapperBLL<TN_WM_CHECK_MSTEntity>>().GetPagingData(new List<SearchWhere>(){
|
new SearchWhere(){ key="CN_S_OP_NO", sign= WhereSign.Like, value=opNo},
|
new SearchWhere(){ key="CN_S_STATE", sign= WhereSign.Include, value=new List<string>{"盘点中","已提交"} },
|
}, pageIndex, pageSize, out total, true, new { CN_S_OP_NO = "%" + opNo + "%", CN_S_STATE = new List<string> { "盘点中", "已提交" } });
|
|
dt.Columns.Add("CN_S_STOCK_NAME");
|
dt.Columns["CN_S_STOCK_NAME"].ReadOnly = false;
|
foreach (DataRow dr in dt.Rows)
|
dr["CN_S_STOCK_NAME"] = GetStockName(dr["CN_S_STOCK_CODE"].ToString());
|
return OperateResult.Succeed("", new
|
{
|
rows = dt,
|
total = total
|
});
|
});
|
}
|
catch (Exception ex)
|
{
|
return OperateResult.Error(ex.Message.ToString());
|
}
|
}
|
#endregion
|
|
#region 获取盘点清单
|
/// <summary>
|
/// 获取盘点清单
|
/// </summary>
|
/// <param name="opNo">盘点单号</param>
|
/// <param name="pageSize"></param>
|
/// <param name="pageIndex"></param>
|
/// <returns></returns>
|
/// <history>[HanHe(lt)] CREATED 2018/8/29</history>
|
[HttpGet]
|
|
public string GetCheckList(string opNo, string pageSize, string pageIndex)
|
{
|
try
|
{
|
|
return ValidateToken(t =>
|
{
|
string sqlWhere = "where 1=1";
|
if (!string.IsNullOrEmpty(opNo))
|
{
|
sqlWhere += " AND CN_S_OP_NO like '%" + opNo + "%'";
|
}
|
//sqlWhere += " AND CN_S_ISCHECK='Y'";
|
var OrdeBy = "ORDER BY CN_S_OP_NO";
|
var ps = Convert.ToInt32(pageSize);
|
var pi = Convert.ToInt32(pageIndex);
|
|
DataTable dt = BLLCreator.Create<TN_WM_CHECK_LISTBLL>().GetDataTableGroup(sqlWhere, OrdeBy, ps, pi);
|
OperateResult res = OperateResult.Succeed(null, new { rows = dt, total = dt.Rows.Count });
|
return JsonConvert.SerializeObject(res);
|
});
|
}
|
catch (Exception ex)
|
{
|
|
return JsonConvert.SerializeObject(OperateResult.Error(ex.Message.ToString()));
|
}
|
}
|
#endregion
|
|
#region 根据货位盘点号获取托盘码
|
/// <summary>
|
/// 获取盘点清单
|
/// </summary>
|
/// <param name="opNo">盘点单号</param>
|
/// <param name="locationCode">货位码</param>
|
/// <param name="pageSize"></param>
|
/// <param name="pageIndex"></param>
|
/// <returns></returns>
|
/// <history>[HanHe(lt)] CREATED 2018/8/29</history>
|
[HttpGet]
|
|
public string GetTrayListByLocationCode(string opNo, string locationCode)
|
{
|
try
|
{
|
return ValidateToken(t =>
|
{
|
string sqlWhere = "where 1=1";
|
if (!string.IsNullOrEmpty(opNo))
|
{
|
sqlWhere += " AND CN_S_OP_NO = '" + opNo + "'";
|
}
|
if (!string.IsNullOrEmpty(locationCode))
|
{
|
sqlWhere += " AND CN_S_LOCATION_CODE = '" + locationCode + "'";
|
}
|
|
DataTable dt = BLLCreator.Create<TN_WM_CHECK_LISTBLL>().GetTrayByLocationCode(sqlWhere);
|
OperateResult res = OperateResult.Succeed(null, new { rows = dt, total = dt.Rows.Count });
|
return JsonConvert.SerializeObject(res);
|
});
|
}
|
catch (Exception ex)
|
{
|
|
return JsonConvert.SerializeObject(OperateResult.Error(ex.Message.ToString()));
|
}
|
}
|
#endregion
|
|
#region 根据货位托盘获取盘点信息
|
/// <summary>
|
/// 获取盘点清单
|
/// </summary>
|
/// <param name="opNo">盘点单号</param>
|
/// <param name="trayCode">托盘编码</param>
|
/// <param name="locationCode">货位码</param>
|
/// <param name="isCheckTwo">是否是二次分拣(0不是1是)</param>
|
/// <returns></returns>
|
/// <history>[HanHe(lt)] CREATED 2018/8/29</history>
|
[HttpGet]
|
|
public string GetCheckListByopNoTray(string opNo, string trayCode, string locationCode, string isCheckTwo)
|
{
|
return ValidateToken(t =>
|
{
|
List<TN_WM_CHECK_LISTEntity> list = BLLCreator.Create<TN_WM_CHECK_LISTBLL>().GetUnitCheckList(opNo, trayCode, locationCode);
|
OperateResult res = OperateResult.Succeed(null, list);
|
return JsonConvert.SerializeObject(res);
|
});
|
}
|
#endregion
|
|
#region 保存盘点数据
|
/// <summary>
|
/// 保存盘点数据
|
/// </summary>
|
/// <param name="obj"></param>
|
/// <returns></returns>
|
/// <history>[HanHe(lt)] CREATED 2018/8/30</history>
|
//[HttpPost]
|
//public OperateResult Save(JObject obj)
|
//{
|
// string tokenId = obj["tokenId"].ToString();
|
// return ValidateToken(tokenId, t =>
|
// {
|
// //HH.Redis.ReisModel.RedisUserEntity t = new HH.Redis.ReisModel.RedisUserEntity() { CN_S_LOGIN="hh", CN_S_NAME="hh"};
|
// //OperateResult result = BLL.BLLCreator.Create<TN_WM_CHECK_LISTBLL>().SaveCheckPDA(obj, t);
|
// return result;
|
// });
|
//}
|
#endregion
|
|
#region 根据货位获取托盘中物料
|
/// <summary>
|
/// 根据货位获取托盘中物料
|
/// </summary>
|
/// <param name="sqlwhere">查询条件</param>
|
/// <returns></returns>
|
/// <history>[HanHe(lt)] CREATED 2019/1/2</history>
|
[HttpGet]
|
public string GetTrayitemBylocation(string locationCode)
|
{
|
return ValidateToken(t =>
|
{
|
DataTable dt = BLL.BLLCreator.Create<TN_WM_CHECK_LISTBLL>().GetTrayitemBylocation(locationCode);
|
OperateResult result = OperateResult.Succeed("", dt);
|
return JsonConvert.SerializeObject(result);
|
});
|
}
|
#endregion
|
|
#endregion
|
|
#region 执行下达任务 注释修改
|
/// <summary>
|
/// 执行下达任务
|
/// </summary>
|
/// <param name="obj"></param>
|
/// <returns></returns>
|
/// <history>[HanHe(lt)] CREATED 2018/8/30</history>
|
[HttpGet]
|
public OperateResult implement(string opNo)
|
{
|
OperateResult result = BLLCreator.Create<TN_WM_CHECK_LISTBLL>().UpdateMstByOpNo("执行", "where CN_S_OP_NO in ('" + opNo + "')");
|
return result;
|
}
|
#endregion
|
|
#region 综合查询
|
/// <summary>
|
/// 根据货位获取托盘中物料
|
/// </summary>
|
/// <param name="sqlwhere">查询条件</param>
|
/// <returns></returns>
|
/// <history>[HanHe(lt)] CREATED 2019/1/2</history>
|
[HttpGet]
|
public string GetComPreInfo(string queryCode, string queryType)
|
{
|
return ValidateToken(t =>
|
{
|
DataTable dt = new DataTable();
|
//货位查询
|
if (queryType == "2")
|
{
|
dt = BLL.BLLCreator.Create<TN_WM_CHECK_LISTBLL>().GetTrayitemBylocation(queryCode);
|
}
|
OperateResult result = OperateResult.Succeed("", dt);
|
return JsonConvert.SerializeObject(result);
|
});
|
}
|
#endregion
|
|
#region 无单据盘点
|
/// <summary>
|
/// 无单据盘点
|
/// </summary>
|
/// <param name="sqlwhere">查询条件</param>
|
/// <returns></returns>
|
/// <history>[HanHe(lt)] CREATED 2019/1/2</history>
|
[HttpPost]
|
public OperateResult NoBillCheck(JObject obj)
|
{
|
string tokenId = obj["tokenId"].ToString();
|
List<TN_WM_CHECK_LISTEntity> checklist = JsonConvert.DeserializeObject<List<TN_WM_CHECK_LISTEntity>>(obj["checklist"].ToString());
|
return ValidateToken(tokenId, t =>
|
{
|
OperateResult result = BLL.BLLCreator.Create<TN_WM_CHECK_MSTBLL>().NoBillCheck(checklist, t);
|
return result;
|
});
|
}
|
#endregion
|
|
#region 盘点盈亏统计确认
|
/// <summary>
|
/// 盘点盈亏统计确认
|
/// </summary>
|
/// <param name="opNo">盘点单号</param>
|
/// <returns></returns>
|
/// <history>[HanHe(DBS)] CREATED 2019/3/22</history>
|
[HttpGet]
|
public OperateResult CheckConfirm(string opNo)
|
{
|
return ValidateToken(t =>
|
{
|
OperateResult result = BLLCreator.Create<TN_WM_CHECK_MSTBLL>().CheckConfirm(opNo, t);
|
return result;
|
});
|
}
|
#endregion
|
}
|
}
|
