From 33b8cbd1b0419d59ef861ee401dacd1cb2bed410 Mon Sep 17 00:00:00 2001
From: Ben Lin <maobin001@msn.com>
Date: 星期五, 12 四月 2024 14:44:10 +0800
Subject: [PATCH] 盟祺科技改到api
---
Tiger.Business/WMS/MengQi/Biz.Mq.Customer.cs | 39 +++++++++++++++++++++++++++++++++++++--
1 files changed, 37 insertions(+), 2 deletions(-)
diff --git a/Tiger.Business/WMS/MengQi/Biz.Mq.Customer.cs b/Tiger.Business/WMS/MengQi/Biz.Mq.Customer.cs
index b842687..3327b8a 100644
--- a/Tiger.Business/WMS/MengQi/Biz.Mq.Customer.cs
+++ b/Tiger.Business/WMS/MengQi/Biz.Mq.Customer.cs
@@ -1,4 +1,5 @@
锘縰sing Rhea.Common;
+using SqlSugar;
using System;
using System.Collections.Generic;
using System.Data;
@@ -18,6 +19,28 @@
public partial class MqCustomer : ICustomer
{
/// <summary>
+ /// 鑾峰彇鍒嗛〉
+ /// </summary>
+ /// <param name="pageList"></param>
+ /// <returns></returns>
+ public async Task<ApiAction<PageAble<Customer>>> GetCustomers(PageAble<Customer> pageList)
+ {
+ var res = new ApiAction<PageAble<Customer>>();
+ try
+ {
+ RefAsync<int> total = 0;
+ pageList.data = await Db.Queryable<Customer>().WhereIF(!string.IsNullOrEmpty(pageList.sqlcmd), x => x.CustomerCode.Contains(pageList.sqlcmd)).OrderBy(x=>x.CustomerCode).ToPageListAsync(pageList.pageIndex, pageList.pageSize, total);
+ pageList.totals = total;
+ }
+ catch (Exception ex)
+ {
+ res.CatchExceptionWithLog(ex, "鑾峰彇瀹㈡埛淇℃伅寮傚父");
+ }
+ res.Data = pageList;
+ return res;
+ }
+
+ /// <summary>
/// 鑾峰彇瀹㈡埛淇℃伅
/// </summary>
/// <returns></returns>
@@ -36,9 +59,21 @@
return res;
}
- public async Task<Result> SaveImportCustomerInfo(DataTable dt)
+ public async Task<ApiAction> SaveImportCustomerInfo(List<Customer> list)
{
- throw new NotImplementedException();
+ var res = new ApiAction();
+ //鏇存柊鏈哄瀷璁板綍
+ var db = Db;
+ var dbTran = await db.UseTranAsync(async () =>
+ {
+ await db.Saveable(list).ExecuteCommandAsync();
+ });
+ if (!dbTran.IsSuccess)
+ {
+ res.IsSuccessed = false;
+ res.Message = $"瀵煎叆寮傚父";
+ }
+ return res;
}
}
}
--
Gitblit v1.9.3