public ActionResult UploadView(string recordUserId = "", string recordUser = "",
string uploadUserId = "", string uploadUser="",
string DepartmentId = "", int page = 1)
{
int maxRecords = 8;//每页4条
int currentPage = page;
string sDepid = Request.Cookies["User"]["DepID"];
var files = db.FileModels.Include(u=>u.UploadUser).Include(p=>p.RecordUser);
//字段搜索功能
if (!String.IsNullOrEmpty(recordUserId))
{
int id = int.Parse(recordUserId);
files = files.Where(s => s.RecordUserId == id);
}
if (!String.IsNullOrEmpty(uploadUserId))
{
int id = int.Parse(uploadUserId);
files = files.Where(s => s.UploadUserId == id);
}
if (!String.IsNullOrEmpty(DepartmentId))
{
int depId = int.Parse(DepartmentId);
files = files.Where(s => s.UploadUserDepartmentId == depId);
}
else
{
int ownerDepId = int.Parse(sDepid);
files = files.Where(s => s.UploadUserDepartmentId == ownerDepId);
}
//return View(files.ToList());
//files = from file in db.FileModels select file;
MyTools myTools = new MyTools();
ViewBag.DepartmentId = new SelectList(myTools.GetDepList(sDepid), "DepartmentId", "name");
ViewBag.uploadUser = uploadUser;
ViewBag.uploadUserId = uploadUserId;
ViewBag.recordUser = recordUser;
ViewBag.recordUserId = recordUserId;
//分页需要排序
files = files.OrderByDescending(p => p.FileId);
return View(files.ToPagedList(currentPage,
maxRecords));
}
