| | |
| | | using System.Data; |
| | | using System.Web; |
| | | using System.Text; |
| | | using System; |
| | | using Admin.NET.Application.Service.WmsTask.WmsRbLineTask.Dto; |
| | | |
| | | namespace Admin.NET.Application; |
| | | /// <summary> |
| | | /// 库存信息服务 |
| | |
| | | public class WmsStockQuanService : IDynamicApiController, ITransient |
| | | { |
| | | private readonly SqlSugarRepository<WmsStockQuan> _rep; |
| | | private readonly SqlSugarRepository<Mes_BatchOrderUPI_New> _Mes_BatchOrderUPI_New_Rep; |
| | | private readonly SqlSugarRepository<V_Station_Quan> _V_Station_Quan_Rep; |
| | | |
| | | public WmsStockQuanService(SqlSugarRepository<WmsStockQuan> rep, |
| | | SqlSugarRepository<Mes_BatchOrderUPI_New> Mes_BatchOrderUPI_New_Rep, |
| | | SqlSugarRepository<V_Station_Quan> v_Station_Quan_Rep) |
| | | public WmsStockQuanService(SqlSugarRepository<WmsStockQuan> rep) |
| | | { |
| | | _rep = rep; |
| | | _Mes_BatchOrderUPI_New_Rep = Mes_BatchOrderUPI_New_Rep; |
| | | _V_Station_Quan_Rep = v_Station_Quan_Rep; |
| | | } |
| | | |
| | | /// <summary> |
| | |
| | | .Select<WmsStockQuanOutput>(); |
| | | if(input.InTimeRange != null && input.InTimeRange.Count >0) |
| | | { |
| | | DateTime? start= input.InTimeRange[0].Value.AddDays(-1); |
| | | query = query.WhereIF(start.HasValue, u => u.InTime > start); |
| | | DateTime? start= input.InTimeRange[0].Value; |
| | | query = query.WhereIF(start.HasValue, u => u.InTime >= start); |
| | | if (input.InTimeRange.Count >1 && input.InTimeRange[1].HasValue) |
| | | { |
| | | var end = input.InTimeRange[1].Value.AddDays(1); |
| | | query = query.Where(u => u.InTime < end); |
| | | var end = input.InTimeRange[1].Value; |
| | | query = query.Where(u => u.InTime <= end); |
| | | } |
| | | } |
| | | if(input.OperTimeRange != null && input.OperTimeRange.Count >0) |
| | |
| | | return query; |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 重复性验证 |
| | | /// </summary> |
| | | /// <param name="input">验证对象</param> |
| | | /// <param name="isEdit">是否是编辑</param> |
| | | /// <returns></returns> |
| | | private async Task CheckExist( WmsStockQuan input,bool isEdit=false) |
| | | /// <summary> |
| | | /// 重复性验证 |
| | | /// </summary> |
| | | /// <param name="input">验证对象</param> |
| | | /// <param name="isEdit">是否是编辑</param> |
| | | /// <returns></returns> |
| | | private async Task CheckExist( WmsStockQuan input,bool isEdit=false) |
| | | { |
| | | |
| | | |
| | |
| | | throw Oops.Oh($"导入数据不能为空"); |
| | | } |
| | | //根据组合校验验证表格中中是否已存在相同数据 |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | //根据单独校验验证表格中中是否已存在相同数据 |
| | | |
| | | |
| | | |
| | | } |
| | | #endregion |
| | | |
| | | |
| | | |
| | | #endregion |
| | | |
| | | } |
| | | |