using SqlSugar;
|
using System.Collections.Generic;
|
using System.Linq;
|
|
namespace TProduct.DAL
|
{
|
public partial class BaseLiteSqlDAL_Sorter<T> : BaseLiteSqlDAL<T> where T : Entity.BaseEntity, Entity.ISorter, new()
|
{
|
/// <summary>
|
/// 更新排序码
|
/// </summary>
|
public virtual bool UpdateSortCode(long ID, int SortCode)
|
{
|
using (ISqlSugarClient db = Connection)
|
{
|
var result = db.Updateable<T>().SetColumns(x => x.SortCode == SortCode).Where(x => x.ID == ID).ExecuteCommandHasChange();
|
return result;
|
}
|
}
|
|
/// <summary>
|
/// 更新排序
|
/// </summary>
|
public virtual bool UpdateSorter(List<Entity.Sorter> Sorters)
|
{
|
if (Sorters == null || Sorters.Count() < 1)
|
return default;
|
using (ISqlSugarClient db = Connection)
|
{
|
db.Ado.BeginTran();
|
foreach (var item in Sorters)
|
{
|
var result = db.Updateable<T>().SetColumns(x => x.SortCode == item.SortCode).Where(x => x.ID == item.ID).ExecuteCommandHasChange();
|
if (!result)
|
{
|
db.Ado.RollbackTran();
|
return false;
|
}
|
}
|
db.Ado.CommitTran();
|
return true;
|
}
|
}
|
|
/// <summary>
|
/// 获取最大排序码
|
/// </summary>
|
public int GetMaxSorter()
|
{
|
using (ISqlSugarClient db = Connection)
|
{
|
return db.Queryable<T>().Max(x => x.SortCode);
|
}
|
}
|
|
/// <summary>
|
/// 获取最小排序码
|
/// </summary>
|
public int GetMinSorter()
|
{
|
using (ISqlSugarClient db = Connection)
|
{
|
return db.Queryable<T>().Min(x => x.SortCode);
|
}
|
}
|
|
}
|
}
|
