using System;
|
using System.Collections.Generic;
|
using System.Configuration;
|
using System.Data;
|
using System.Data.SqlClient;
|
using System.Linq;
|
using System.Text;
|
using System.Threading.Tasks;
|
using SqlSugar;
|
using IStation.Entity;
|
|
namespace IStation.DAL
|
{
|
/// <summary>
|
/// 用户
|
/// </summary>
|
public class User : BaseTraceDAL_Sorter_UseStatus_TagName<Entity.User>
|
{
|
/// <summary>
|
///
|
/// </summary>
|
public override ConnectionConfig ConnectionConfig
|
{
|
get { return ConfigHelper.DefaultConnectionConfig; }
|
|
}
|
|
/// <summary>
|
/// 更新登录密码
|
/// </summary>
|
public bool UpdateLoginPwd(long ID, string LoginPwd,long UpdateUserID,DateTime UpdateTime)
|
{
|
if (string.IsNullOrEmpty(LoginPwd))
|
return default;
|
using (SqlSugarClient db = new SqlSugarClient(ConnectionConfig))
|
{
|
return db.Updateable<Entity.User>()
|
.SetColumns(x => x.LoginPwd == LoginPwd)
|
.SetColumns(x => x.UpdateUserID == UpdateUserID)
|
.SetColumns(x => x.UpdateTime == UpdateTime)
|
.Where(x => x.ID == ID)
|
.ExecuteCommand() > 0;
|
}
|
}
|
|
/// <summary>
|
/// 通过 ID 删除
|
/// </summary>
|
public override bool DeleteByID(long ID)
|
{
|
using (SqlSugarClient db = new SqlSugarClient(ConnectionConfig))
|
{
|
db.BeginTran();
|
var result = db.Deleteable<Entity.User>()
|
.Where(x => x.ID == ID)
|
.ExecuteCommandHasChange();
|
if (!result)
|
{
|
db.RollbackTran();
|
return false;
|
}
|
db.Deleteable<Entity.UserAttention>()
|
.Where(x => x.UserID == ID)
|
.ExecuteCommand();
|
db.CommitTran();
|
return true;
|
}
|
}
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
}
|
}
|
