internal void UserQueryBuild(DTO.PQUserQuery request)
{
this.AppendInit();
this.AppendFieldRownum("u.UserID desc");
this.AppendFieldStr("u.[UserID]");
this.AppendFieldStr("u.[UserAccount]");
this.AppendFieldDate("u.[StartDate]");
this.AppendFieldDate("u.[EndDate]");
this.AppendFieldTime("u.[LastLoginTime]");
this.AppendFieldTime("u.[CreateTime]");
this.AppendFieldTime("u.[UpdateTime]");
this.AppendFieldStr("u.[Enabled]");
this.AppendFieldStr("u.[OrgID]");
this.AppendFieldStr("o.[FullPath]");
this.AppendFieldStr("u.[CellPhone]");
this.AppendFieldStr("u.[Email]");
this.AppendFieldStr("u.[WorkNumber]");
this.AppendFieldStr("u.[RoleID]");
this.AppendFieldStr("r.[RoleName]");
this.AppendFieldStr("u.[UserName]");
this.AppendFromStr("from tbUser u,tbOrg o,tbRole r");
this.AppendFromStr("where u.orgid=o.orgid and u.roleid=r.roleid");
this.AppendWhereContains("o.FullPath", request.OrgName);
this.AppendWhereContains("u.UserName", request.UserName);
this.AppendWhereLike("u.CellPhone", request.Cellphone);
this.AppendWhereLike("u.UserAccount", request.UserAccount);
this.AppendWhereLike("u.WorkNumber", request.WorkNumber);
this.AppendComplete(request.Page, request.PageRow);
}
/// <summary>
/// 查询用户
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public DTO.PSUserQuery UserQuery(DTO.PQUserQuery request)
{
DTO.PSUserQuery response = new DTO.PSUserQuery();
try
{
DAL.cUserDAL dal = new DAL.cUserDAL(con);
dal.UserQueryBuild(request);
response.data = dal.Query <DTO.LUser>();
int num = dal.Count();
response.Page = request.Page;
response.MaxNum = num;
response.count = num;
response.MaxPage = MathExpansion.CaculatPage(num, request.PageRow);
response.ErrorMessage = rm.GetString(response.ErrorCode);
response.code = response.ErrorCode == "A_0" ? "0" : response.ErrorCode;
response.msg = response.ErrorMessage;
}
catch (Exception ex)
{
LogHelper.Error("cUserBLL.QueryUser出错！", ex);
throw;
}
return(response);
}
