using HxDbContext;
|
using HxModel;
|
using MySqlX.XDevAPI.Common;
|
using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Text;
|
using System.Threading.Tasks;
|
|
namespace HxUserManagement.HxDAL
|
{
|
public class UserInfoDAL
|
{
|
#region 获取信息
|
/// <summary>
|
/// 获取用户信息
|
/// </summary>
|
/// <param name="id">ID</param>
|
/// <returns></returns>
|
public UserInfoModel GetUserInfodById(string id)
|
{
|
var result = new MySqlEF<UserInfoModel>().GetModel(x => x.Id == id);
|
if (result != null)
|
{
|
return result;
|
}
|
return null;
|
}
|
|
/// <summary>
|
/// 根据参数获取用户信息
|
/// </summary>
|
/// <param name="username">用户名</param>
|
/// <returns></returns>
|
public UserInfoModel GetInfoByUserName(string username)
|
{
|
var result = new MySqlEF<UserInfoModel>().GetModel(x => x.UserName == username);
|
if (result != null)
|
{
|
return result;
|
}
|
return null;
|
}
|
|
/// <summary>
|
/// 获取所有用户列表
|
/// </summary>
|
/// <returns></returns>
|
public List<UserInfoModel> GetAllUserInfo()
|
{
|
var result = new MySqlEF<UserInfoModel>().GetList(null);
|
var resultB = new MySqlEF<RolesModel>().GetList(null);
|
|
foreach (var user in result)
|
{
|
var role = resultB.Where(s => s.Id == user.Authority).FirstOrDefault();
|
if (role != null)
|
{
|
user.AuthorityName = role.Name;
|
}
|
}
|
|
if (result != null)
|
{
|
return result.ToList();
|
}
|
return null;
|
}
|
|
/// <summary>
|
/// 根据状态获取用户列表
|
/// </summary>
|
/// <param name="deviceconfigId"></param>
|
/// <param name="deviceconfigMethodId"></param>
|
/// <param name="type"></param>
|
/// <param name="parameterName"></param>
|
/// <returns></returns>
|
public List<UserInfoModel> GetInfo(string status)
|
{
|
var result = new MySqlEF<UserInfoModel>().GetList(x => x.Status == status);
|
if (result != null)
|
{
|
return result.ToList();
|
}
|
return null;
|
}
|
|
public List<UserInfoModel> Search(string name, string phone, string state, string authority)
|
{
|
var result = GetAllUserInfo();
|
if (string.IsNullOrEmpty(name) && string.IsNullOrEmpty(phone) && string.IsNullOrEmpty(state) && string.IsNullOrEmpty(authority))
|
{
|
if (result != null)
|
{
|
return result.ToList();
|
}
|
}
|
|
if (!string.IsNullOrEmpty(authority))
|
result = result.Where(s => s.Authority == authority).ToList();
|
if (result == null)
|
return null;
|
|
if (!string.IsNullOrEmpty(state))
|
result = result.Where(s => s.Status == state).ToList();
|
if (result == null)
|
return null;
|
|
if (!string.IsNullOrEmpty(phone))
|
result = result.Where(s => s.Phone != null && s.Phone.Contains(phone)).ToList();
|
if (result == null)
|
return null;
|
|
if (!string.IsNullOrEmpty(name))
|
result = result.Where(s => s.UserName.Contains(name)).ToList();
|
if (result == null)
|
return null;
|
|
return result.ToList();
|
}
|
#endregion
|
|
#region 删除
|
/// <summary>
|
/// 删除
|
/// </summary>
|
/// <param name="id"></param>
|
/// <returns></returns>
|
public bool DelById(string id)
|
{
|
var resultDelModel = new MySqlEF<UserInfoModel>().GetModel(x => x.Id == id);
|
#region AddLog
|
OperateAuditLogDAL logDAL = new OperateAuditLogDAL();
|
logDAL.Add("删除", "删除用户【" + resultDelModel.UserName + "】");
|
#endregion
|
if (resultDelModel != null)
|
{
|
var result = new MySqlEF<UserInfoModel>().Delete(new UserInfoModel { Id = id });
|
return result;
|
}
|
return false;
|
}
|
#endregion
|
|
#region 添加
|
/// <summary>
|
/// 添加
|
/// </summary>
|
/// <param name="model"></param>
|
/// <returns></returns>
|
public UserInfoModel Add(UserInfoModel model)
|
{
|
try
|
{
|
var result = new MySqlEF<UserInfoModel>().Add(model);
|
|
#region AddLog
|
OperateAuditLogDAL logDAL = new OperateAuditLogDAL();
|
logDAL.Add("添加", "添加用户【" + model.UserName + "】");
|
#endregion
|
|
if (result != null)
|
{
|
return model;
|
}
|
}
|
catch (Exception ex)
|
{
|
}
|
return null;
|
}
|
#endregion
|
|
#region 修改
|
/// <summary>
|
/// 修改
|
/// </summary>
|
/// <param name="model"></param>
|
/// <returns></returns>
|
public UserInfoModel Update(UserInfoModel model)
|
{
|
var result = new MySqlEF<UserInfoModel>().Update(model);
|
|
#region AddLog
|
OperateAuditLogDAL logDAL = new OperateAuditLogDAL();
|
logDAL.Add("修改", "修改用户【" + model.UserName + "】");
|
#endregion
|
|
if (result != null)
|
{
|
return result;
|
}
|
|
return null;
|
}
|
#endregion
|
}
|
}
|
