using IStation.Entity;
|
using SqlSugar;
|
using System;
|
using System.Collections.Generic;
|
using System.Data;
|
using System.Linq;
|
using System.Text;
|
using System.Threading.Tasks;
|
|
namespace IStation.DAL
|
{
|
/// <summary>
|
///
|
/// </summary>
|
public partial class BaseDAL_Sorter<T> : BaseDAL<T> where T : Entity.BaseEntity,ISorter, new()
|
{
|
/// <summary>
|
/// 更新排序码
|
/// </summary>
|
public virtual bool UpdateSortCode(long ID, int SortCode)
|
{
|
using (SqlSugarClient db = new SqlSugarClient(ConnectionConfig))
|
{
|
return db.Updateable<T>()
|
.SetColumns(x => x.SortCode == SortCode).Where(x => x.ID == ID).ExecuteCommand() > 0;
|
}
|
}
|
|
/// <summary>
|
/// 更新排序
|
/// </summary>
|
public virtual bool UpdateSorter(List<Entity.Sorter> Sorters)
|
{
|
if (Sorters == null || Sorters.Count() < 1)
|
return default;
|
if (Sorters.Exists(x => x.ID < 1))
|
return default;
|
using (SqlSugarClient db = new SqlSugarClient(ConnectionConfig))
|
{
|
return db.Updateable<T>(Sorters).UpdateColumns(nameof(Entity.ISorter.SortCode)).ExecuteCommand()>0;
|
}
|
}
|
|
|
}
|
}
|
