/// <summary>
/// 分页数据
/// </summary>
/// <param name="queryModel"></param>
/// <returns></returns>
public SoaDataPageResponse <FunctionModel> GetList(SoaDataPage <FunctionQueryModelRequest> queryModel)
{
SoaDataPageResponse <FunctionModel> response = new SoaDataPageResponse <FunctionModel>();
SoaDataPageResponse <Esmart_Sys_Functions> soa = FunctionDbAction.GetList(queryModel);
List <FunctionModel> listFunction = new List <FunctionModel>();
if (soa.Body.Any())
{
foreach (var li in soa.Body)
{
listFunction.Add(new FunctionModel()
{
AppId = li.AppId,
CreateId = li.CreateId,
CreateTime = li.CreateTime,
FunctionId = li.FunctionId,
FunctionKey = li.FunctionKey,
FunctionName = li.FunctionName,
Remark = li.Remark
});
}
}
response.Body = listFunction;
response.Count = soa.Count;
return(response);
}
public static SoaDataPageResponse <T> SetResponsePage <T>(T obj)
{
SoaDataPageResponse <T> mr = new SoaDataPageResponse <T>();
mr.Header.ReturnCode = (int)ServerErrcodeEnum.Normal;
return(mr);
}
public SoaDataPageResponse <RoleModel> GetRoleList(SoaDataPage <RoleGridFilterViewModel> fiter)
{
SoaDataPageResponse <RoleModel> response = new SoaDataPageResponse <RoleModel>();
List <Esmart_Sys_Roles> roles;
if (CommonAction.IsSysAdmin(fiter.Where.LogInUserId))
{
roles = RoleDbAction.GetAllRols();
response.Count = roles.Count;
roles = roles.Skip((fiter.PageIndex - 1) * fiter.PageSize).Take(fiter.PageSize).ToList();
}
else
{
int count;
roles = UserRolesDbAction.GetRolesByUserId(fiter, out count);
response.Count = count;
}
var body = roles.ConvertAll(a => new RoleModel()
{
CreateTime = a.CreateTime,
CreatorId = a.CreateId,
EndDate = a.EndTime,
Id = a.RoleId,
Name = a.RoleName,
Remark = a.Remark,
StartDate = a.StartTime,
IsBuiltin = a.IsBuiltin
});
response.Body = body;
return(response);
}
/// <summary>
/// 分页数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static SoaDataPageResponse <Esmart_Sys_Functions> GetList(SoaDataPage <FunctionQueryModelRequest> model)
{
SoaDataPageResponse <Esmart_Sys_Functions> response = new SoaDataPageResponse <Esmart_Sys_Functions>();
var engine = PermissionDb.CreateEngine();
var list = engine.Esmart_Sys_Functions.Where(m => m.IsDelete == 0);
if (model.Where.AppId > 0)
{
list = list.Where(m => m.AppId == model.Where.AppId);
}
if (!string.IsNullOrEmpty(model.Where.Name))
{
list = list.Where(m => (m.FunctionKey.Contains(model.Where.Name) || m.FunctionName.Contains(model.Where.Name)));
}
response.Count = list.Count();
//分页
var listFunctions = list.OrderByDescending(m => m.CreateTime).Skip((model.PageIndex - 1) * model.PageSize).Take(model.PageSize).ToList();
response.Body = listFunctions;
return(response);
}
public static SoaDataPageResponse <T> SetResponseExceptionPage <T>(Exception ex)
{
SoaDataPageResponse <T> rValue = new SoaDataPageResponse <T>();
if (ex is TpoBaseException || ex is ApplicationException)
{
TpoBaseException bEx = ex as TpoBaseException;
rValue.Header.ReturnCode = bEx.Code;
rValue.Header.Message = ex.Message;
LogTxt.WriteLog("BusinessException" + bEx.Code, (int)LogType.Other);
}
else
{
rValue.Header.ReturnCode = (int)ServerErrcodeEnum.ServiceError;//系统异常
rValue.Header.Message = "服务未处理异常";
Exception logException = ex;
if (ex.InnerException != null)
{
logException = ex.InnerException;
}
LogTxt.WriteLog("BusinessException" + logException.Message, (int)LogType.Other);
}
return(rValue);
}
public static SoaDataPageResponse <UsersView> GetUsersByDepartList(SoaDataPage <UserSearchModel> filter)
{
var engine = PermissionDb.CreateEngine();
var query = from t in engine.Esmart_Sys_Users
join d in engine.Esmart_Sys_Department_User on t.UserID equals d.UserId
join dep in engine.Esmart_Sys_Departments on d.DeparentId equals dep.DeparentId
where d.DeparentId == filter.Where.DeapartmentId
select new UsersView
{
UserID = t.UserID,
WorkNo = t.WorkNo,
UserName = t.UserName,
PassWord = t.PassWord,
Email = t.Email,
Ename = t.Ename,
TrueName = t.TrueName,
Sex = t.Sex,
Education = t.Education,
Graduate = t.Graduate,
Birthday = t.Birthday,
qq = t.qq,
Skype = t.Skype,
Mobile = t.Mobile,
HomeTel = t.HomeTel,
HomeAddr = t.HomeAddr,
OfficeAddr = t.OfficeAddr,
OfficeName = t.OfficeName,
Isleave = t.Isleave,
IsDelete = t.IsDelete,
Remark = t.Remark,
CreateId = t.CreateId,
CreateTime = d.CreateTime,
DeparentName = dep.Name
};
if (!string.IsNullOrWhiteSpace(filter.Where.TrueName))
{
query = query.Where(n => n.TrueName.Contains(filter.Where.TrueName));
}
if (!string.IsNullOrWhiteSpace(filter.Where.Ename))
{
query = query.Where(n => n.Ename.Contains(filter.Where.Ename));
}
if (!string.IsNullOrWhiteSpace(filter.Where.WorkNo))
{
query = query.Where(n => n.WorkNo.Contains(filter.Where.WorkNo));
}
var response = new SoaDataPageResponse <UsersView> {
Count = query.Count()
};
query = !string.IsNullOrWhiteSpace(filter.OrderBy) ? query.SortBy(filter.OrderBy + " " + filter.SortCol) : query.OrderByDescending(n => n.CreateTime);
response.Body = query.Skip((filter.PageIndex - 1) * filter.PageSize).Take(filter.PageSize).ToList();
return(response);
}
public SoaDataPageResponse <UsersView> GetUsersByDepartList(SoaDataPage <UserSearchModel> filter)
{
SoaDataPageResponse <UsersView> response;
if (filter.Where.DeapartmentId != 0)
{
response = DepartmentDbAction.GetUsersByDepartList(filter);
}
else
{
IQueryable <UsersView> query;
if (CommonAction.IsSysAdmin(filter.Where.UserId))
{
query = DepartmentUserDbAction.GetAllUsers(true).AsQueryable();
}
else
{
var userList = new List <UsersView>(100);
var departments = DepartmentDbAction.GetDepartments(filter.Where.UserId);
foreach (var department in departments)
{
var users = DepartmentUserDbAction.GetUsersInDepartment(department.DeparentId, true);
userList.AddRange(users);
}
query = userList.AsQueryable();
}
if (!string.IsNullOrWhiteSpace(filter.Where.TrueName))
{
query = query.Where(n => n.TrueName != null && n.TrueName.Contains(filter.Where.TrueName));
}
if (!string.IsNullOrWhiteSpace(filter.Where.Ename))
{
query = query.Where(n => n.Ename != null && n.Ename.Contains(filter.Where.Ename));
}
if (!string.IsNullOrWhiteSpace(filter.Where.WorkNo))
{
query = query.Where(n => n.WorkNo != null && n.WorkNo.Contains(filter.Where.WorkNo));
}
response = new SoaDataPageResponse <UsersView> {
Count = query.Count()
};
query = !string.IsNullOrWhiteSpace(filter.OrderBy) ? query.SortBy(filter.OrderBy + " " + filter.SortCol) : query.OrderByDescending(n => n.CreateTime);
response.Body = query.Skip((filter.PageIndex - 1) * filter.PageSize).Take(filter.PageSize).ToList();
}
foreach (var user in response.Body)
{
user.RoleNames = string.Join(",", UserRolesDbAction.GetUserRoleNames(user.UserID));
}
return(response);
}
