public List <UserRoleEntity> UsersByPage(B_TbUser info, DateTime?startTime, DateTime?endTime, int isAble,
ref int totalCount,
int pageSize = 20, int pageIndex = 1)
{
var exp = Expressionable.Create <B_TbUser, B_TbUserRole, B_TbRole>();
if (!string.IsNullOrEmpty(info.AccountName))
{
exp = exp.And((u, ur, r) => u.AccountName.Contains(info.AccountName));
}
if (!string.IsNullOrEmpty(info.RealName))
{
exp = exp.And((u, ur, r) => u.RealName.Contains(info.RealName));
}
if (isAble != -1)
{
bool temp = isAble == 1?true:false;
exp = exp.And((u, ur, r) => u.IsAble == temp);
}
if (startTime != null)
{
exp = exp.And((u, ur, r) => u.CreateTime > startTime);
}
if (endTime != null)
{
exp = exp.And((u, ur, r) => u.CreateTime < endTime);
}
var list = db.Queryable <B_TbUser, B_TbUserRole, B_TbRole>((u, ur, r) =>
new object[] {
JoinType.Left, u.ID == ur.UserId,
JoinType.Left, ur.RoleId == r.ID
})
.Where(exp.ToExpression()).OrderBy((u, ur, r) => u.CreateTime, OrderByType.Asc)
.Select((u, ur, r) => new UserRoleEntity()
{
ID = u.ID,
AccountName = u.AccountName,
RealName = u.RealName,
Creater = u.Creater,
CreateTime = u.CreateTime,
Description = u.Description,
Email = u.Email,
IfChangePwd = u.IfChangePwd,
IsAble = u.IsAble,
MobilePhone = u.MobilePhone,
Password = null,
Position = u.Position,
RoleId = r.ID,
RoleName = r.RoleName,
Updater = u.Updater,
UpdateTime = u.UpdateTime,
WorkNumber = u.WorkNumber,
})
.ToPageList(pageIndex, pageSize, ref totalCount);
return(list);
}
public int UpdateUser(B_TbUser info)
{
return(db.Updateable <B_TbUser>(info).With(SqlWith.UpdLock).IgnoreColumns(it => new {
it.Creater,
it.CreateTime,
it.Password,
it.WorkNumber,
}).ExecuteCommand());
}
public int AddUser(B_TbUser info)
{
int id = db.Insertable(info).With(SqlWith.UpdLock).ExecuteReturnIdentity();
return(id);
}
public int UpdateUser(B_TbUser info)
{
return(userDAL.UpdateUser(info));
}
public List <UserRoleEntity> UsersByPage(B_TbUser info, DateTime?startTime, DateTime?endTime, int isAble,
ref int totalCount,
int pageSize = 20, int pageIndex = 1)
{
return(userDAL.UsersByPage(info, startTime, endTime, isAble, ref totalCount, pageSize, pageIndex));
}
public int AddUser(B_TbUser info)
{
return(userDAL.AddUser(info));
}
