From 1b6830d5f8671e48bdc13d7155b848aa938283f5 Mon Sep 17 00:00:00 2001 From: zongzhibin <zongzhibin@weben-smart.com> Date: 周五, 29 11月 2024 15:53:16 +0800 Subject: [PATCH] Merge branch 'master' of http://222.71.245.114:9086/r/LA24030-LuLI_PackageLine --- LA24030_LuLiPackageLine_Wms/Admin.NET.Application/Service/WmsOrder/Mes_Order_Gather/Mes_Order_GatherService.cs | 201 ++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 201 insertions(+), 0 deletions(-) diff --git a/LA24030_LuLiPackageLine_Wms/Admin.NET.Application/Service/WmsOrder/Mes_Order_Gather/Mes_Order_GatherService.cs b/LA24030_LuLiPackageLine_Wms/Admin.NET.Application/Service/WmsOrder/Mes_Order_Gather/Mes_Order_GatherService.cs new file mode 100644 index 0000000..f5b22c7 --- /dev/null +++ b/LA24030_LuLiPackageLine_Wms/Admin.NET.Application/Service/WmsOrder/Mes_Order_Gather/Mes_Order_GatherService.cs @@ -0,0 +1,201 @@ +锘縰sing Admin.NET.Core.Service; +using Admin.NET.Application.Entity; +using Microsoft.AspNetCore.Http; +using System.Data; +using System.Web; +using System.Text; +namespace Admin.NET.Application; +/// <summary> +/// 璁㈠崟鏁版嵁鏈嶅姟 +/// </summary> +[ApiDescriptionSettings(ApplicationConst.WmsOrderGroupName, Order = 100)] +public class Mes_Order_GatherService : IDynamicApiController, ITransient +{ + private readonly SqlSugarRepository<Mes_Order_Gather> _rep; + public Mes_Order_GatherService(SqlSugarRepository<Mes_Order_Gather> rep) + { + _rep = rep; + } + + /// <summary> + /// 鍒嗛〉鏌ヨ璁㈠崟鏁版嵁 + /// </summary> + /// <param name="input"></param> + /// <returns></returns> + [HttpPost] + [ApiDescriptionSettings(Name = "Page")] + [Description("Mes_Order_Gather/Page")] + public async Task<SqlSugarPagedList<Mes_Order_GatherOutput>> Page(Mes_Order_GatherInput input) + { + var query = CommonPageFilter(input); + return await query.OrderBuilder(input, "", "Id").ToPagedListAsync(input.Page, input.PageSize); + } + + /// <summary> + /// 涓嶅垎椤垫煡璇㈣鍗曟暟鎹� + /// </summary> + /// <param name="input"></param> + /// <returns></returns> + [HttpGet] + [ApiDescriptionSettings(Name = "List")] + [Description("Mes_Order_Gather/List")] + public async Task<List<Mes_Order_GatherOutput>> List([FromQuery] Mes_Order_GatherInput input) + { + var query = CommonPageFilter(input); + return await query.OrderBuilder(input, "", "Id").Select<Mes_Order_GatherOutput>().ToListAsync(); + } + + /// <summary> + /// 澧炲姞璁㈠崟鏁版嵁 + /// </summary> + /// <param name="input"></param> + /// <returns></returns> + [HttpPost] + [ApiDescriptionSettings(Name = "Add")] + [Description("Mes_Order_Gather/Add")] + public async Task<long> Add(AddMes_Order_GatherInput input) + { + var entity = input.Adapt<Mes_Order_Gather>(); + + //閲嶅鎬ч獙璇� + await CheckExist(entity); + + await _rep.InsertAsync(entity); + return entity.Id; + } + + /// <summary> + /// 鍒犻櫎璁㈠崟鏁版嵁 + /// </summary> + /// <param name="input"></param> + /// <returns></returns> + [HttpPost] + [ApiDescriptionSettings(Name = "Delete")] + [Description("Mes_Order_Gather/Delete")] + public async Task Delete(DeleteMes_Order_GatherInput input) + { + var entity = await _rep.GetFirstAsync(u => u.Id == input.Id) ?? throw Oops.Oh(ErrorCodeEnum.D1002); + //await _rep.FakeDeleteAsync(entity); //鍋囧垹闄� + await _rep.DeleteAsync(entity); //鐪熷垹闄� + } + + /// <summary> + /// 鏇存柊璁㈠崟鏁版嵁 + /// </summary> + /// <param name="input"></param> + /// <returns></returns> + [HttpPost] + [ApiDescriptionSettings(Name = "Update")] + [Description("Mes_Order_Gather/Update")] + public async Task Update(UpdateMes_Order_GatherInput input) + { + var entity = input.Adapt<Mes_Order_Gather>(); + + //閲嶅鎬ч獙璇� + await CheckExist(entity,true); + + await _rep.AsUpdateable(entity).IgnoreColumns(ignoreAllNullColumns: true).ExecuteCommandAsync(); + } + + /// <summary> + /// 鑾峰彇璁㈠崟鏁版嵁 + /// </summary> + /// <param name="input"></param> + /// <returns></returns> + [HttpGet] + [ApiDescriptionSettings(Name = "Detail")] + [Description("Mes_Order_Gather/Detail")] + public async Task<Mes_Order_Gather> Detail([FromQuery] QueryByIdMes_Order_GatherInput input) + { + return await _rep.GetFirstAsync(u => u.Id == input.Id); + } + + + + + + + #region 绉佹湁鏂规硶 + + /// <summary> + /// 鍏叡鏌ヨ璁㈠崟鏁版嵁鏉′欢 + /// </summary> + /// <param name="input"></param> + /// <returns></returns> + private ISugarQueryable<Mes_Order_GatherOutput> CommonPageFilter(Mes_Order_GatherInput input) + { + var query = _rep.AsQueryable() + .WhereIF(!string.IsNullOrWhiteSpace(input.SearchKey), u => + u.Info5.Contains(input.SearchKey.Trim()) + || u.PlanNo.Contains(input.SearchKey.Trim()) + || u.OrderId.Contains(input.SearchKey.Trim()) + || u.CreateUserName.Contains(input.SearchKey.Trim()) + || u.UpdateUserName.Contains(input.SearchKey.Trim()) + ) + .WhereIF(!string.IsNullOrWhiteSpace(input.Info5), u => u.Info5.Contains(input.Info5.Trim())) + .WhereIF(!string.IsNullOrWhiteSpace(input.PlanNo), u => u.PlanNo.Contains(input.PlanNo.Trim())) + .WhereIF(!string.IsNullOrWhiteSpace(input.OrderId), u => u.OrderId.Contains(input.OrderId.Trim())) + .WhereIF(input.IsKitting.HasValue, u => u.IsKitting == input.IsKitting) + .WhereIF(input.PackageNum>0, u => u.PackageNum == input.PackageNum) + .WhereIF(input.UnLinePackageNum>0, u => u.UnLinePackageNum == input.UnLinePackageNum) + .WhereIF(input.NoUnLinePackageNum>0, u => u.NoUnLinePackageNum == input.NoUnLinePackageNum) + .Select<Mes_Order_GatherOutput>(); + if(input.CreateTimeRange != null && input.CreateTimeRange.Count >0) + { + DateTime? start= input.CreateTimeRange[0].Value; + query = query.WhereIF(start.HasValue, u => u.CreateTime >= start); + if (input.CreateTimeRange.Count >1 && input.CreateTimeRange[1].HasValue) + { + var end = input.CreateTimeRange[1].Value; + query = query.Where(u => u.CreateTime <= end); + } + } + return query; + } + + /// <summary> + /// 閲嶅鎬ч獙璇� + /// </summary> + /// <param name="input">楠岃瘉瀵硅薄</param> + /// <param name="isEdit">鏄惁鏄紪杈�</param> + /// <returns></returns> + private async Task CheckExist( Mes_Order_Gather input,bool isEdit=false) + { + + + + //娌℃湁閰嶇疆缁勫悎鏍¢獙锛屼笉闇�瑕侀獙閲� + + + //娌℃湁閰嶇疆鍗曠嫭鏍¢獙锛屼笉闇�瑕侀獙閲� + } + + /// <summary> + /// 鏍规嵁缁勫悎鏍¢獙鍜屽崟鐙牎楠岄獙璇佹暟鎹槸鍚﹀凡瀛樺湪-瀵煎叆鏃堕獙璇� + /// </summary> + /// <param name="inputs"></param> + /// <returns></returns> + private async Task CheckExisitForImport(List<Mes_Order_Gather> inputs) + { + if (inputs?.Count <= 0) + { + throw Oops.Oh($"瀵煎叆鏁版嵁涓嶈兘涓虹┖"); + } + //鏍规嵁缁勫悎鏍¢獙楠岃瘉琛ㄦ牸涓腑鏄惁宸插瓨鍦ㄧ浉鍚屾暟鎹� + + + + + + + + + //鏍规嵁鍗曠嫭鏍¢獙楠岃瘉琛ㄦ牸涓腑鏄惁宸插瓨鍦ㄧ浉鍚屾暟鎹� + + + + } + #endregion + +} + -- Gitblit v1.9.3