using HslCommunication;
|
using MailKit.Search;
|
using SqlSugar;
|
using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Text;
|
using System.Threading.Tasks;
|
using WIDESEA_Common.WareHouseEnum;
|
using WIDESEA_Core;
|
using WIDESEA_Core.BaseRepository;
|
using WIDESEA_Core.BaseServices;
|
using WIDESEA_Core.Helper;
|
using WIDESEA_DTO.SquareCabin;
|
using WIDESEA_IWMsInfoServices;
|
using WIDESEA_Model.Models;
|
using static WIDESEA_DTO.SquareCabin.TowcsDto;
|
|
namespace WIDESEA_WMsInfoServices
|
{
|
public class InventoryInfoService : ServiceBase<Dt_InventoryInfo, IRepository<Dt_InventoryInfo>>, IInventoryInfoService
|
{
|
public InventoryInfoService(IRepository<Dt_InventoryInfo> BaseDal) : base(BaseDal)
|
{
|
}
|
public IRepository<Dt_InventoryInfo> Repository => BaseDal;
|
|
|
/// <summary>
|
/// 获取库存
|
/// </summary>
|
/// <returns></returns>
|
public WebResponseContent GetInventory()
|
{
|
WebResponseContent content = new WebResponseContent();
|
try
|
{
|
List<object> lists = new List<object>();
|
#region 冷冻库
|
string WareCodeLD = WarehouseEnum.冷冻库.ObjToInt().ToString("000");
|
var LDQty = Convert.ToInt32(BaseDal.QueryData(x => x.WarehouseCode == WareCodeLD).Sum(x => x.StockQuantity));
|
lists.Add(new
|
{
|
name = WarehouseEnum.冷冻库.ObjToString(),
|
count = LDQty
|
});
|
#endregion
|
#region 麻精库
|
string WareCodeMJ = WarehouseEnum.麻精库.ObjToInt().ToString("000");
|
var MJQty = Convert.ToInt32(BaseDal.QueryData(x => x.WarehouseCode == WareCodeMJ).Sum(x => x.StockQuantity));
|
lists.Add(new
|
{
|
name = WarehouseEnum.麻精库.ObjToString(),
|
count = MJQty
|
});
|
#endregion
|
#region 大件库
|
string WareCodeDJ = WarehouseEnum.大件库.ObjToInt().ToString("000");
|
var DJQty = Convert.ToInt32(BaseDal.QueryData(x => x.WarehouseCode == WareCodeDJ).Sum(x => x.StockQuantity));
|
lists.Add(new
|
{
|
name = WarehouseEnum.大件库.ObjToString(),
|
count = DJQty
|
});
|
#endregion
|
content.OK(data: lists);
|
}
|
catch (Exception ex)
|
{
|
content.Error(ex.Message);
|
}
|
return content;
|
}
|
|
|
|
}
|
}
|
