From bdd84cc48ba7b2527584c44d174da8e7d20c5375 Mon Sep 17 00:00:00 2001
From: zhaowc <526854230@qq.com>
Date: 星期三, 18 九月 2024 16:37:13 +0800
Subject: [PATCH] 增加对申请入库时对平库库位的校验
---
Wms/WMS.DAL/BaseRepository.cs | 28 +++++++++++++++++++---------
1 files changed, 19 insertions(+), 9 deletions(-)
diff --git a/Wms/WMS.DAL/BaseRepository.cs b/Wms/WMS.DAL/BaseRepository.cs
index b72953c..a253d34 100644
--- a/Wms/WMS.DAL/BaseRepository.cs
+++ b/Wms/WMS.DAL/BaseRepository.cs
@@ -108,6 +108,12 @@
return data;
}
+ public async Task<T> GetOneByIdAsync1(int id)
+ {
+ var data = await _db.Queryable<T>().FirstAsync(m => m.Id == id && m.IsDel == "1");
+ return data;
+ }
+
public List<T> GetModels(string sqlString)
{
var models = _db.Ado.SqlQuery<T>(sqlString);
@@ -120,37 +126,41 @@
return model.FirstOrDefault();
}
- public SqlSugar.ISugarQueryable<T> GetAllAsync()
+ public SqlSugar.ISugarQueryable<T> GetAll()
{
var data =_db.Queryable<T>().Where(m=>m.IsDel =="0");
return data;
}
- public SqlSugar.ISugarQueryable<T> GetAllWhereAsync(System.Linq.Expressions.Expression<Func<T, bool>> predicate)
+ public async Task<List<T>> GetAllAsync()
{
- var data = GetAllAsync().Where(predicate);
+ return await _db.Queryable<T>().Where(m => m.IsDel == "0").ToListAsync();
+ }
+ public SqlSugar.ISugarQueryable<T> GetAllWhere(System.Linq.Expressions.Expression<Func<T, bool>> predicate)
+ {
+ var data = GetAll().Where(predicate);
return data;
}
- public SqlSugar.ISugarQueryable<T> GetAllByOrderAsync(System.Linq.Expressions.Expression<Func<T, bool>> predicate, bool asc = true)
+ public SqlSugar.ISugarQueryable<T> GetAllByOrder(System.Linq.Expressions.Expression<Func<T, bool>> predicate, bool asc = true)
{
var type = OrderByType.Asc;
if (!asc)
{
type = OrderByType.Desc;
}
- var data = GetAllWhereAsync(predicate).OrderBy(m => m.CreateTime, type);
+ var data = GetAllWhere(predicate).OrderBy(m => m.CreateTime, type);
return data;
}
- public SqlSugar.ISugarQueryable<T> GeTAllByPageAsync(System.Linq.Expressions.Expression<Func<T, bool>> predicate, int pageSize, int pageIndex,out int count )
+ public SqlSugar.ISugarQueryable<T> GeTAllByPage(System.Linq.Expressions.Expression<Func<T, bool>> predicate, int pageSize, int pageIndex,out int count )
{
- var list = GetAllWhereAsync(predicate);
+ var list = GetAllWhere(predicate);
count = list.Count();
var data = list.Skip(pageSize * (pageIndex - 1)).Take(pageSize);
return data;
}
- public SqlSugar.ISugarQueryable<T> GetAllByOrderPageAsync(System.Linq.Expressions.Expression<Func<T, bool>> predicate, int pageSize, int pageIndex, out int count , bool asc = true)
+ public SqlSugar.ISugarQueryable<T> GetAllByOrderPage(System.Linq.Expressions.Expression<Func<T, bool>> predicate, int pageSize, int pageIndex, out int count , bool asc = true)
{
- var list = GetAllByOrderAsync(predicate, asc);
+ var list = GetAllByOrder(predicate, asc);
count = list.Count();
var data = list.Skip(pageSize * (pageIndex-1)).Take(pageSize);
--
Gitblit v1.8.0