public ActionResult GetSysWorkList(SysWorkFilter filter)
{
filter.UserId = CurrentUser.Id;
filter.UserName = CurrentUser.UserName;
var data = business.GetSysWorkList(filter, out int total);
return(Json(new TableDataModel(total, data)));
}
public List <SysWorkModel> GetSysWorkList(SysWorkFilter filter, out int total)
{
using (DataProvider dp = new DataProvider())
{
var list = data.GetSysWorkList(dp, filter, out total);
return(Mapper.Map <List <SysWorkModel> >(list));
}
}
public List <SysWorkModel> GetSysWorkList(DataProvider dp, SysWorkFilter filter, out int total, bool IsPage = true)
{
var list = from a in dp.PM_SysWork.Where(m => !m.IsDel)
join b in dp.System_User on a.CreateUser equals b.Id into c from ci in c.DefaultIfEmpty()
join d in dp.System_User on a.UpdateUser equals d.Id into e from ei in e.DefaultIfEmpty()
select new SysWorkModel
{
Id = a.Id,
WorkNo = a.WorkNo,
WorkName = a.WorkNo,
Principal = a.Principal,
WorkType = a.WorkType,
ProjectLeader = a.ProjectLeader,
SpecialConsultant = a.SpecialConsultant,
FileName = a.FileName,
FilePath = a.FilePath,
IsDel = a.IsDel,
CreateUserName = ci.UserName,
UpdateUserName = ei.UserName,
CreateTime = a.CreateTime,
CreateUser = a.CreateUser,
UpdateTime = a.UpdateTime,
UpdateUser = a.UpdateUser
};
if (!string.IsNullOrWhiteSpace(filter.WorkNo))
{
list = list.Where(m => m.WorkNo.Contains(filter.WorkNo));
}
if (!string.IsNullOrWhiteSpace(filter.WorkName))
{
list = list.Where(m => m.WorkName.Contains(filter.WorkName));
}
if (filter.WorkType.IsNotNullAndCountGtZero())
{
list = list.Where(m => filter.WorkType.Contains(m.WorkType));
}
if (filter.UserName.ToUpper() != "ADMIN")
{
list = list.Where(m => m.CreateUser == filter.UserId);
}
list = list.OrderByDescending(m => m.CreateTime);
total = list.Count();
if (IsPage)
{
return(list.Skip(filter.Skip).Take(filter.PageSize).ToList());
}
else
{
return(list.ToList());
}
}
