From 5e610f4c9d9870b393720bc5fcc856e97bc2ea4b Mon Sep 17 00:00:00 2001 From: zongzhibin <zongzhibin@weben-smart.com> Date: 周三, 27 11月 2024 09:36:26 +0800 Subject: [PATCH] Merge branch 'master' of http://222.71.245.114:9086/r/LA24030-LuLI_PackageLine --- LA24030_LuLiPackageLine_Wms/Admin.NET.Application/Service/PrintCenter/WmsRecordPrint/WmsRecordPrintService.cs | 214 +++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 214 insertions(+), 0 deletions(-) diff --git a/LA24030_LuLiPackageLine_Wms/Admin.NET.Application/Service/PrintCenter/WmsRecordPrint/WmsRecordPrintService.cs b/LA24030_LuLiPackageLine_Wms/Admin.NET.Application/Service/PrintCenter/WmsRecordPrint/WmsRecordPrintService.cs new file mode 100644 index 0000000..f3edd47 --- /dev/null +++ b/LA24030_LuLiPackageLine_Wms/Admin.NET.Application/Service/PrintCenter/WmsRecordPrint/WmsRecordPrintService.cs @@ -0,0 +1,214 @@ +锘縰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.PrintCenterGroupName, Order = 100)] +public class WmsRecordPrintService : IDynamicApiController, ITransient +{ + private readonly SqlSugarRepository<WmsRecordPrint> _rep; + public WmsRecordPrintService(SqlSugarRepository<WmsRecordPrint> rep) + { + _rep = rep; + } + + /// <summary> + /// 鍒嗛〉鏌ヨ鎵撳嵃璁板綍 + /// </summary> + /// <param name="input"></param> + /// <returns></returns> + [HttpPost] + [ApiDescriptionSettings(Name = "Page")] + [Description("WmsRecordPrint/Page")] + public async Task<SqlSugarPagedList<WmsRecordPrintOutput>> Page(WmsRecordPrintInput 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("WmsRecordPrint/List")] + public async Task<List<WmsRecordPrintOutput>> List([FromQuery] WmsRecordPrintInput input) + { + var query = CommonPageFilter(input); + return await query.OrderBuilder(input, "", "Id").Select<WmsRecordPrintOutput>().ToListAsync(); + } + + /// <summary> + /// 澧炲姞鎵撳嵃璁板綍 + /// </summary> + /// <param name="input"></param> + /// <returns></returns> + [HttpPost] + [ApiDescriptionSettings(Name = "Add")] + [Description("WmsRecordPrint/Add")] + public async Task<long> Add(AddWmsRecordPrintInput input) + { + var entity = input.Adapt<WmsRecordPrint>(); + + //閲嶅鎬ч獙璇� + await CheckExist(entity); + + await _rep.InsertAsync(entity); + return entity.Id; + } + + /// <summary> + /// 鍒犻櫎鎵撳嵃璁板綍 + /// </summary> + /// <param name="input"></param> + /// <returns></returns> + [HttpPost] + [ApiDescriptionSettings(Name = "Delete")] + [Description("WmsRecordPrint/Delete")] + public async Task Delete(DeleteWmsRecordPrintInput 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("WmsRecordPrint/Update")] + public async Task Update(UpdateWmsRecordPrintInput input) + { + var entity = input.Adapt<WmsRecordPrint>(); + + //閲嶅鎬ч獙璇� + 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("WmsRecordPrint/Detail")] + public async Task<WmsRecordPrint> Detail([FromQuery] QueryByIdWmsRecordPrintInput input) + { + return await _rep.GetFirstAsync(u => u.Id == input.Id); + } + + + + + + + #region 绉佹湁鏂规硶 + + /// <summary> + /// 鍏叡鏌ヨ鎵撳嵃璁板綍鏉′欢 + /// </summary> + /// <param name="input"></param> + /// <returns></returns> + private ISugarQueryable<WmsRecordPrintOutput> CommonPageFilter(WmsRecordPrintInput input) + { + var query = _rep.AsQueryable() + .WhereIF(!string.IsNullOrWhiteSpace(input.SearchKey), u => + u.PackageCode.Contains(input.SearchKey.Trim()) + || u.Info4.Contains(input.SearchKey.Trim()) + || u.Info5.Contains(input.SearchKey.Trim()) + || u.Info6.Contains(input.SearchKey.Trim()) + || u.Info7.Contains(input.SearchKey.Trim()) + || u.Info8.Contains(input.SearchKey.Trim()) + || u.Info10.Contains(input.SearchKey.Trim()) + || u.Info11.Contains(input.SearchKey.Trim()) + || u.Info12.Contains(input.SearchKey.Trim()) + || u.Info13.Contains(input.SearchKey.Trim()) + || u.Info14.Contains(input.SearchKey.Trim()) + || u.Info16.Contains(input.SearchKey.Trim()) + || u.Remarks.Contains(input.SearchKey.Trim()) + || u.CreateUserName.Contains(input.SearchKey.Trim()) + || u.UpdateUserName.Contains(input.SearchKey.Trim()) + ) + .WhereIF(input.PrintType.HasValue, u => u.PrintType == input.PrintType) + .WhereIF(input.PrintSource.HasValue, u => u.PrintSource == input.PrintSource) + .WhereIF(!string.IsNullOrWhiteSpace(input.PackageCode), u => u.PackageCode.Contains(input.PackageCode.Trim())) + .WhereIF(!string.IsNullOrWhiteSpace(input.Info4), u => u.Info4.Contains(input.Info4.Trim())) + .WhereIF(!string.IsNullOrWhiteSpace(input.Info5), u => u.Info5.Contains(input.Info5.Trim())) + .WhereIF(!string.IsNullOrWhiteSpace(input.Info6), u => u.Info6.Contains(input.Info6.Trim())) + .WhereIF(!string.IsNullOrWhiteSpace(input.Info7), u => u.Info7.Contains(input.Info7.Trim())) + .WhereIF(!string.IsNullOrWhiteSpace(input.Info8), u => u.Info8.Contains(input.Info8.Trim())) + .WhereIF(!string.IsNullOrWhiteSpace(input.Info10), u => u.Info10.Contains(input.Info10.Trim())) + .WhereIF(!string.IsNullOrWhiteSpace(input.Info11), u => u.Info11.Contains(input.Info11.Trim())) + .WhereIF(!string.IsNullOrWhiteSpace(input.Info12), u => u.Info12.Contains(input.Info12.Trim())) + .WhereIF(!string.IsNullOrWhiteSpace(input.Info13), u => u.Info13.Contains(input.Info13.Trim())) + .WhereIF(!string.IsNullOrWhiteSpace(input.Info14), u => u.Info14.Contains(input.Info14.Trim())) + .WhereIF(input.Info15>0, u => u.Info15 == input.Info15) + .WhereIF(!string.IsNullOrWhiteSpace(input.Info16), u => u.Info16.Contains(input.Info16.Trim())) + .WhereIF(input.PrintSheetNum>0, u => u.PrintSheetNum == input.PrintSheetNum) + .WhereIF(input.PrintNum>0, u => u.PrintNum == input.PrintNum) + .WhereIF(input.PrintStatus.HasValue, u => u.PrintStatus == input.PrintStatus) + .WhereIF(input.IsAllowPrint.HasValue, u => u.IsAllowPrint == input.IsAllowPrint) + .WhereIF(!string.IsNullOrWhiteSpace(input.Remarks), u => u.Remarks.Contains(input.Remarks.Trim())) + .Select<WmsRecordPrintOutput>(); + return query; + } + + /// <summary> + /// 閲嶅鎬ч獙璇� + /// </summary> + /// <param name="input">楠岃瘉瀵硅薄</param> + /// <param name="isEdit">鏄惁鏄紪杈�</param> + /// <returns></returns> + private async Task CheckExist( WmsRecordPrint input,bool isEdit=false) + { + + + + //娌℃湁閰嶇疆缁勫悎鏍¢獙锛屼笉闇�瑕侀獙閲� + + + //娌℃湁閰嶇疆鍗曠嫭鏍¢獙锛屼笉闇�瑕侀獙閲� + } + + /// <summary> + /// 鏍规嵁缁勫悎鏍¢獙鍜屽崟鐙牎楠岄獙璇佹暟鎹槸鍚﹀凡瀛樺湪-瀵煎叆鏃堕獙璇� + /// </summary> + /// <param name="inputs"></param> + /// <returns></returns> + private async Task CheckExisitForImport(List<WmsRecordPrint> inputs) + { + if (inputs?.Count <= 0) + { + throw Oops.Oh($"瀵煎叆鏁版嵁涓嶈兘涓虹┖"); + } + //鏍规嵁缁勫悎鏍¢獙楠岃瘉琛ㄦ牸涓腑鏄惁宸插瓨鍦ㄧ浉鍚屾暟鎹� + + + + + + + + + //鏍规嵁鍗曠嫭鏍¢獙楠岃瘉琛ㄦ牸涓腑鏄惁宸插瓨鍦ㄧ浉鍚屾暟鎹� + + + + } + #endregion + +} + -- Gitblit v1.9.3