using HH.WMS.BLL;
|
using HH.WMS.BLL.AllQuery;
|
using HH.WMS.BLL.Basic;
|
using HH.WMS.BLL.External;
|
using HH.WMS.BLL.InStock;
|
using HH.WMS.BLL.OutStock;
|
using HH.WMS.Common;
|
using HH.WMS.DAL;
|
using HH.WMS.DAL.Algorithm;
|
using HH.WMS.DAL.Basic;
|
using HH.WMS.DAL.InStock;
|
using HH.WMS.Entitys;
|
using HH.WMS.Entitys.Basic;
|
using HH.WMS.Entitys.Common;
|
using HH.WMS.Entitys.Entitys;
|
using HH.WMS.Entitys.External;
|
using HH.WMS.Utils;
|
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.Web;
|
using System.Web.Http;
|
|
namespace HH.WMS.WebApi.Areas.AllQuery.Controllers
|
{
|
/// <summary>
|
/// 库存统计Controller
|
/// </summary>
|
public class InventoryController : BaseController
|
{
|
#region 出入库业务查询
|
/// <summary>
|
/// 出入库业务查询
|
/// </summary>
|
/// <param name="searchModel"></param>
|
/// <returns></returns>
|
/// <History>[Hanhe(DBS)] CREATED BY 2018-12-03</History>
|
[HttpPost]
|
public OperateResult GetOrderBussList(SearchModel searchModel)
|
{
|
return ValidateToken(searchModel.TokenId, x =>
|
{
|
try
|
{
|
OperateResult result;
|
//IsoDateTimeConverter timeFormat = new IsoDateTimeConverter();
|
//timeFormat.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
|
result = BLLCreator.Create<InventoryBll>().GetOrderBussList(searchModel.PageIndex, searchModel.PageSize, searchModel.SearchCondition);
|
return result;
|
}
|
catch (Exception ex)
|
{
|
return OperateResult.Error(ex.Message.ToString());
|
}
|
});
|
}
|
#endregion
|
|
#region 库存统计查询
|
/// <summary>
|
/// 库存统计查询
|
/// </summary>
|
/// <param name="searchModel"></param>
|
/// <returns></returns>
|
/// <History>[Hanhe(DBS)] CREATED BY 2018-12-03</History>
|
[HttpPost]
|
public OperateResult GetInventoryList(SearchModel searchModel)
|
{
|
return ValidateToken(searchModel.TokenId, x =>
|
{
|
try
|
{
|
return BLLCreator.Create<InventoryBll>().GetInventoryList(searchModel, true);
|
}
|
catch (Exception ex)
|
{
|
return OperateResult.Error(ex.Message.ToString());
|
}
|
});
|
}
|
|
/// <summary>
|
/// 库存查询不分页
|
/// </summary>
|
/// <param name="searchModel"></param>
|
/// <returns></returns>
|
/// <History>[Hanhe(DBS)] CREATED BY 2019-1-20</History>
|
[HttpPost]
|
public OperateResult GetInventoryListExport(SearchModel searchModel)
|
{
|
return ValidateToken(searchModel.TokenId, x =>
|
{
|
try
|
{
|
return BLLCreator.Create<InventoryBll>().GetInventoryList(searchModel, false);
|
}
|
catch (Exception ex)
|
{
|
return OperateResult.Error(ex.Message.ToString());
|
}
|
});
|
}
|
#endregion
|
|
#region 汇总指定日期内的出入库业务量
|
/// <summary>
|
/// 汇总指定日期内的出入库业务量
|
/// </summary>
|
/// <param name="searchModel"></param>
|
/// <param name="orderBy"></param>
|
/// <returns></returns>
|
/// <History>[Hanhe(dbs)] created 2018/12/2</History>
|
public OperateResult GetBussLine(int day)
|
{
|
return ValidateToken(x =>
|
{
|
DataTable dt = null;
|
try
|
{
|
dt = BLLCreator.Create<InventoryBll>().GetBussLine(day);
|
return OperateResult.Succeed("", dt);
|
}
|
catch (Exception ex)
|
{
|
return OperateResult.Error(ex.Message.ToString());
|
}
|
});
|
}
|
#endregion
|
|
#region 获取货位的历史上下架记录
|
/// <summary>
|
/// 获取货位的历史上下架记录
|
/// </summary>
|
/// <param name="searchModel"></param>
|
/// <returns></returns>
|
/// <History>[Hanhe(DBS)] CREATED BY 2018-12-03</History>
|
[HttpPost]
|
public OperateResult GetLocationHistory(SearchModel searchModel)
|
{
|
return ValidateToken(searchModel.TokenId, x =>
|
{
|
try
|
{
|
OperateResult result;
|
result = BLLCreator.Create<InventoryBll>().GetLocationHistory(searchModel);
|
return result;
|
}
|
catch (Exception ex)
|
{
|
return OperateResult.Error(ex.Message.ToString());
|
}
|
});
|
}
|
#endregion
|
|
#region 获取货位的历史上下架记录 巨星
|
/// <summary>
|
/// 获取货位的历史上下架记录
|
/// </summary>
|
/// <param name="searchModel"></param>
|
/// <returns></returns>
|
/// <History>[Hanhe(DBS)] CREATED BY 2018-12-03</History>
|
[HttpPost]
|
public OperateResult GetLocationHistoryJx(SearchModel searchModel)
|
{
|
return ValidateToken(searchModel.TokenId, x =>
|
{
|
try
|
{
|
OperateResult result;
|
result = BLLCreator.Create<InventoryBll>().GetLocationHistoryJx(searchModel);
|
return result;
|
}
|
catch (Exception ex)
|
{
|
return OperateResult.Error(ex.Message.ToString());
|
}
|
});
|
}
|
#endregion
|
|
#region 查询货位库存
|
/// <summary>
|
/// 查询货位库存
|
/// </summary>
|
/// <param name="searchModel"></param>
|
/// <returns></returns>
|
/// <History>[Hanhe(DBS)] CREATED BY 2018-12-03</History>
|
[HttpPost]
|
public OperateResult GetLocationInventoryList(SearchModel searchModel)
|
{
|
return ValidateToken(searchModel.TokenId, x =>
|
{
|
try
|
{
|
OperateResult result;
|
result = BLLCreator.Create<InventoryBll>().GetLocationInventoryList(searchModel, false);
|
return result;
|
}
|
catch (Exception ex)
|
{
|
return OperateResult.Error(ex.Message.ToString());
|
}
|
});
|
}
|
[HttpPost]
|
public OperateResult GetLocationInventoryListJx(SearchModel searchModel)
|
{
|
return ValidateToken(searchModel.TokenId, x =>
|
{
|
try
|
{
|
OperateResult result;
|
result = BLLCreator.Create<InventoryBll>().GetLocationInventoryListJx(searchModel, false);
|
return result;
|
}
|
catch (Exception ex)
|
{
|
return OperateResult.Error(ex.Message.ToString());
|
}
|
});
|
}
|
|
[HttpPost]
|
public OperateResult GetLocationInventoryExport(SearchModel searchModel)
|
{
|
return ValidateToken(searchModel.TokenId, x =>
|
{
|
try
|
{
|
OperateResult result;
|
result = BLLCreator.Create<InventoryBll>().GetLocationInventoryList(searchModel, true);
|
return result;
|
}
|
catch (Exception ex)
|
{
|
return OperateResult.Error(ex.Message.ToString());
|
}
|
});
|
}
|
#endregion
|
//[HttpPost]
|
//public OperateResult HistoryLine(SearchModel searchModel)
|
//{
|
// return ValidateToken(searchModel.TokenId, x =>
|
// {
|
// try
|
// {
|
// OperateResult result;
|
// result = BLLCreator.Create<InventoryBll>().HistoryLine(searchModel);
|
// return result;
|
// }
|
// catch (Exception ex)
|
// {
|
// return OperateResult.Error(ex.Message.ToString());
|
// }
|
// });
|
//}
|
|
#region 查询盘点报表
|
/// <summary>
|
/// 查询盘点报表
|
/// </summary>
|
/// <param name="searchModel"></param>
|
/// <returns></returns>
|
/// <History>[Hanhe(DBS)] CREATED BY 2019-1-10</History>
|
[HttpPost]
|
public OperateResult GetCheckDtl(SearchModel searchModel)
|
{
|
return ValidateToken(searchModel.TokenId, x =>
|
{
|
try
|
{
|
OperateResult result;
|
result = BLLCreator.Create<InventoryBll>().GetCheckDtl(searchModel);
|
return result;
|
}
|
catch (Exception ex)
|
{
|
return OperateResult.Error(ex.Message.ToString());
|
}
|
});
|
}
|
#endregion
|
|
#region 汇总查询盘点报表
|
/// <summary>
|
/// 汇总查询盘点报表
|
/// </summary>
|
/// <param name="searchModel"></param>
|
/// <returns></returns>
|
/// <History>[Hanhe(DBS)] CREATED BY 2019-1-10</History>
|
[HttpPost]
|
public OperateResult GetCheckDtlTotal(SearchModel searchModel)
|
{
|
return ValidateToken(searchModel.TokenId, x =>
|
{
|
try
|
{
|
OperateResult result;
|
result = BLLCreator.Create<InventoryBll>().GetCheckDtlTotal(searchModel);
|
return result;
|
}
|
catch (Exception ex)
|
{
|
return OperateResult.Error(ex.Message.ToString());
|
}
|
});
|
}
|
#endregion
|
|
#region 物料盘点汇总
|
/// <summary>
|
/// 物料盘点汇总
|
/// </summary>
|
/// <param name="searchModel"></param>
|
/// <returns></returns>
|
/// <History>[Hanhe(DBS)] CREATED BY 2019-1-10</History>
|
[HttpPost]
|
public OperateResult GetItemCheckDtl(SearchModel searchModel)
|
{
|
return ValidateToken(searchModel.TokenId, x =>
|
{
|
try
|
{
|
OperateResult result;
|
result = BLLCreator.Create<InventoryBll>().GetItemCheckDtl(searchModel);
|
return result;
|
}
|
catch (Exception ex)
|
{
|
return OperateResult.Error(ex.Message.ToString());
|
}
|
});
|
}
|
#endregion
|
|
#region 物料盘点数量金额汇总
|
/// <summary>
|
/// 物料盘点数量金额汇总
|
/// </summary>
|
/// <param name="searchModel"></param>
|
/// <returns></returns>
|
/// <History>[Hanhe(DBS)] CREATED BY 2019-1-10</History>
|
[HttpPost]
|
public OperateResult GetItemCheckDtlTotal(SearchModel searchModel)
|
{
|
return ValidateToken(searchModel.TokenId, x =>
|
{
|
try
|
{
|
OperateResult result;
|
result = BLLCreator.Create<InventoryBll>().GetCheckDtlTotal(searchModel);
|
return result;
|
}
|
catch (Exception ex)
|
{
|
return OperateResult.Error(ex.Message.ToString());
|
}
|
});
|
}
|
#endregion
|
|
#region 更新记录
|
/// <summary>
|
/// 更新记录
|
/// </summary>
|
/// <returns></returns>
|
[HttpGet]
|
public OperateResult GetVersionLog()
|
{
|
return ValidateToken(t =>
|
{
|
var updateLogList = BLLCreator.Create<InventoryBll>().GetVersionLog().Where(x => x.CN_T_UPDATE.HasValue);
|
var ul = updateLogList.Select(x =>
|
{
|
return new
|
{
|
version = x.CN_S_VERSION,
|
title = "更新时间：" + x.CN_T_UPDATE.Value.ToString("yyyy-MM-dd"),
|
content = x.CN_S_CONTENT,
|
order = x.CN_N_ORDER
|
};
|
});
|
var result = ul.GroupBy(x => new
|
{
|
x.version,
|
x.title
|
}).Select(y => new
|
{
|
title = y.Key.version + " " + y.Key.title,
|
update = y.AsEnumerable().OrderBy(o => o.order).Select(s => new
|
{
|
content = s.order + "、" + s.content
|
})
|
});
|
return OperateResult.Succeed(null, result);
|
});
|
}
|
#endregion
|
|
[HttpGet]
|
public OperateResult OutItemBoardData()
|
{
|
return ValidateToken(t =>
|
{
|
//待出库和已复验的所有出库单
|
var outMst = BLLCreator.CreateDapper<TN_WM_OUT_MSTEntity>().GetList(new
|
{
|
CN_S_STATE = new List<string>() { Constants.State_WaitOut, Constants.State_Rechecked }
|
});
|
//出库单子表
|
var outDtl = BLLCreator.CreateDapper<TN_WM_OUT_DTLEntity>().GetList(new
|
{
|
CN_S_OP_NO = outMst.Select(x => x.CN_S_OP_NO).ToList()
|
});
|
//波次主表
|
var waveMst = BLLCreator.CreateDapper<TN_WM_WAVE_MSTEntity>().GetList(new
|
{
|
CN_S_WAVE_NO = outMst.Select(x => x.CN_S_WAVE_CODE).ToList()
|
});
|
var result = outMst.Select(x =>
|
{
|
var currentDtl = outDtl.FindAll(y => y.CN_S_OP_NO == x.CN_S_OP_NO);
|
string pickState = "待拣";
|
if (x.CN_S_STATE == Constants.State_Rechecked)
|
{
|
pickState = "已拣";
|
}
|
else
|
{
|
var waveEntity = waveMst.Find(w => w.CN_S_WAVE_NO == x.CN_S_WAVE_CODE);
|
if (waveEntity != null && waveEntity.CN_S_STATE != Constants.Sorting_Stay && waveEntity.CN_S_STATE != Constants.Sorting_Being)
|
pickState = "已拣";
|
}
|
return new
|
{
|
OpNo = x.CN_S_OP_NO,
|
FromNo = x.CN_S_FROM_NO,
|
Customer = x.CN_S_CUSTOMER_NAME,
|
PickState = pickState,
|
Items = currentDtl.Select(m => new
|
{
|
ItemCode = m.CN_S_ITEM_CODE,
|
ItemName = m.CN_S_ITEM_NAME,
|
ItemModel = m.CN_S_MODEL,
|
ProductNo = m.CN_S_PRODUCTION_BATCH,
|
Qty = m.CN_F_QUANTITY,
|
Unit = m.CN_S_MEASURE_UNIT
|
})
|
};
|
});
|
return OperateResult.Succeed(null, result);
|
});
|
}
|
|
|
#region 恢复到正常
|
|
[HttpGet]
|
public IHttpActionResult LocationToNormal(string locationCode, string state)
|
{
|
Log.Info("恢复到正常", "接收参数为：" + locationCode + state);
|
var result = new OperateResult();
|
|
if (string.IsNullOrEmpty(state))
|
state = "";
|
|
if (state.Equals("扫码异常"))
|
{
|
result = BLLCreator.Create<TN_WM_LOCATION_EXTBLL>().UpdateState(locationCode.Trim(), "正常", "");
|
}
|
else
|
{
|
//更新货位状态到正常，空
|
result = BLLCreator.Create<TN_WM_LOCATION_EXTBLL>().UpdateState(locationCode.Trim(), "正常", "");
|
}
|
|
|
return Json(result);
|
}
|
|
#endregion
|
|
#region 解绑货位
|
|
[HttpGet]
|
public IHttpActionResult LocationToUnBind(string locationCode, string state)
|
{
|
try
|
{
|
Log.Detail("解绑货位", "接收参数为locationCode：" + locationCode + " state为：" + state);
|
|
locationCode = locationCode.Trim();
|
var objLocation = BLLCreator.Create<TN_WM_B_TRAY_LOCATIONBLL>().GetDetailByLocationCode(locationCode).FirstOrDefault();
|
var result = BLLCreator.Create<DapperBLL<TN_WM_B_TRAY_LOCATIONEntity>>().Delete(new { CN_S_LOCATION_CODE = locationCode });
|
Log.Detail("解绑货位", "删除托盘货位关联结果：" + JsonConvert.SerializeObject(result));
|
if (!result.Success)
|
{
|
return Json(result);
|
}
|
|
AutoBomLocationEntity locationModel = DALCreator.Create<TN_WMS_LOCATIONDAL>().GetModel(locationCode);
|
BLLCreator.Create<TN_WM_B_LOCATION_CHANGEBLL>().AddStateChange(locationCode, "空取异常", "正常", "恢复正常", "WMS", "", "", locationModel.CN_S_STOCK_CODE, locationModel.CN_S_AREA_CODE, null);
|
|
//删除托盘产品关联
|
result = DALCreator.Create<TN_WM_B_TRAY_ITEM_RELDAL>().DeleteTrayItem(" CN_S_TRAY_CODE='" + objLocation.CN_S_TRAY_CODE + "' ", null);
|
Log.Detail("解绑货位", "删除托盘产品关联结果：" + JsonConvert.SerializeObject(result));
|
return Json(result);
|
}
|
catch (Exception ex)
|
{
|
Log.Info("LocationToUnBind error", ex.Message);
|
return Json(OperateResult.Error(ex.Message));
|
}
|
}
|
|
#endregion
|
|
#region 绑定托盘货位物料
|
|
[HttpGet]
|
public IHttpActionResult LocationToBind(string locationCode, string trayCode, string materialCode)
|
{
|
locationCode = locationCode.Trim();
|
var result = new SqlExecuteResult { Success = true };
|
|
AutoBomItemEntity materialEntity = BLLCreator.Create<TN_WMS_ITEMBLL>().GetItem(materialCode);
|
|
TN_WM_B_TRAY_INFOEntity trayEntity = BLLCreator.Create<DapperBLL<TN_WM_B_TRAY_INFOEntity>>().GetSingleEntity(new { CN_S_TRAY_CODE = trayCode }); //DALCreator.Create<TN_WM_B_TRAY_INFODAL>().GetModel(trayCode);
|
|
TN_WM_B_TRAY_ITEM_RELEntity entity = new TN_WM_B_TRAY_ITEM_RELEntity();
|
entity.CN_S_TRAY_CODE = trayCode;
|
entity.CN_S_TRAY_GRID = "1";
|
entity.CN_S_ITEM_CODE = materialEntity.CN_S_ITEM_CODE;
|
entity.CN_S_ITEM_NAME = materialEntity.CN_S_ITEM_NAME;
|
entity.CN_S_ITEM_STATE = "合格";
|
entity.CN_S_TRAY_TYPE = "托盘";
|
entity.CN_GUID = Guid.NewGuid().ToString();
|
entity.CN_F_QUANTITY = 1;
|
entity.CN_T_CREATE = DateTime.Now;
|
entity.CN_T_MODIFY = DateTime.Now;
|
|
result = DAOManager.ExecuteTransaction(trans =>
|
{
|
|
//删除原托盘中绑定的物料
|
var transResult = DALCreator.Create<TN_WM_B_TRAY_ITEM_RELDAL>().DeleteTrayItem(" CN_S_TRAY_CODE='" + trayCode + "' ", trans);
|
//result = BLLCreator.Create<TN_WM_B_TRAY_ITEM_RELBLL>().DeleteItemRel(" and CN_S_TRAY_CODE = '" + trayCode + "'", trans);
|
if (transResult.Success)
|
{
|
//添加托盘料架关联
|
transResult = BLLCreator.Create<DapperBLL<TN_WM_B_TRAY_ITEM_RELEntity>>().Add(entity);
|
//result = BLLCreator.Create<TN_WM_B_TRAY_ITEM_RELBLL>().(new List<TN_WM_B_TRAY_ITEM_RELEntity> { entity }, null);
|
}
|
if (!transResult.Success)
|
{
|
DAOManager.RollbackTransaction(trans);
|
return new SqlExecuteResult { Success = transResult.Success };
|
}
|
//添加托盘货位关联
|
transResult = BLLCreator.Create<TN_WM_B_TRAY_LOCATIONBLL>().AddTrayLocationRelation(trayCode, locationCode, new Redis.ReisModel.RedisUserEntity(), "");
|
if (!transResult.Success)
|
{
|
DAOManager.RollbackTransaction(trans);
|
}
|
return new SqlExecuteResult { Success = transResult.Success };
|
});
|
|
return Json(result);
|
}
|
|
#endregion
|
|
#region 宇寿需求变更20190926 新增业务汇总查询
|
|
/// <summary>
|
/// 获取货位的历史上下架记录
|
/// </summary>
|
/// <param name="searchModel"></param>
|
/// <returns></returns>
|
/// <History>[Hanhe(DBS)] CREATED BY 2018-12-03</History>
|
[HttpPost]
|
public OperateResult GetInventorySummary(SearchModel searchModel)
|
{
|
return ValidateToken(searchModel.TokenId, x =>
|
{
|
try
|
{
|
OperateResult result;
|
result = BLLCreator.Create<InventoryBll>().GetInventorySummary(searchModel);
|
return result;
|
}
|
catch (Exception ex)
|
{
|
return OperateResult.Error(ex.Message.ToString());
|
}
|
});
|
}
|
|
[HttpPost]
|
public OperateResult ExportInventorySummary(SearchModel searchModel)
|
{
|
return ValidateToken(searchModel.TokenId, x =>
|
{
|
try
|
{
|
OperateResult result;
|
result = BLLCreator.Create<InventoryBll>().ExportInventorySummary(searchModel);
|
return result;
|
}
|
catch (Exception ex)
|
{
|
return OperateResult.Error(ex.Message.ToString());
|
}
|
});
|
}
|
|
#endregion
|
}
|
}
|
