/// <summary>
/// 用户列表
/// </summary>
/// <returns></returns>
public IEnumerable <UserEntity> GetList()
{
var sql = PetaPoco.Sql.Builder.Append(@"select * from Base_User where 1=1 and UserId<>'System' and DeleteMark=0");
sql.Append(" order by CreateDate desc");
var list = Base_User.Query(sql);
return(EntityConvertTools.CopyToList <Base_User, UserEntity>(list.ToList()));
}
/// <summary>
/// 获取部门下面用户列表
/// </summary>
/// <returns></returns>
public IEnumerable <UserEntity> GetDepartmentUserList()
{
var sql = PetaPoco.Sql.Builder.Append(@"SELECT u.* FROM Base_User u
LEFT JOIN Base_Department d ON d.DepartmentId = u.DepartmentId
WHERE 1=1
AND u.UserId <> 'System' AND u.EnabledMark = 1 AND u.DeleteMark=0");
var list = Base_User.Query(sql);
return(EntityConvertTools.CopyToList <Base_User, UserEntity>(list.ToList()));
}
/// <summary>
/// 账户不能重复
/// </summary>
/// <param name="account">账户值</param>
/// <param name="keyValue">主键</param>
/// <returns></returns>
public bool ExistAccount(string account, string keyValue)
{
var sql = PetaPoco.Sql.Builder.Append(@"select * from Base_User where 1=1");
if (!string.IsNullOrEmpty(account))
{
sql.Append(" and Account=@0", account);
}
if (!string.IsNullOrEmpty(keyValue))
{
sql.Append(" and UserId!=@0", keyValue);
}
return(Base_User.Query(sql).Count() == 0 ? true : false);
}
