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)));
}
//
// GET: /User/
public ActionResult Index(string name = "", string userCode = "", string DepartmentId = "", int page = 1)
{
int maxRecords = 4;//每页4条
int currentPage = page;
//var users = db.Users.Include(a => a.Role).Include(a => a.Dep).OrderBy(p=>p.UserId);
var users = from user in db.Users select user;
string sDepid = Request.Cookies["User"]["DepID"];
//字段搜索功能
if (!String.IsNullOrEmpty(name))
{
users = users.Where(s => s.Name.Contains(name));
}
if (!String.IsNullOrEmpty(userCode))
{
users = users.Where(s => s.UserCode.Contains(userCode));
}
if (!String.IsNullOrEmpty(DepartmentId))
{
int depId = int.Parse(DepartmentId);
users = users.Where(s => s.DepartmentId == depId);
}
else
{
int ownerDepId = int.Parse(sDepid);
users = users.Where(s => s.DepartmentId == ownerDepId);
}
//分页上要保留上次搜索的值
ViewBag.name = String.IsNullOrEmpty(name) ? "" : name;
ViewBag.userCode = String.IsNullOrEmpty(userCode) ? "" : userCode;
//ViewBag.DepartmentId = DepartmentId;
MyTools myTools = new MyTools();
ViewBag.DepartmentId = new SelectList(myTools.GetDepList(sDepid), "DepartmentId", "name");
//分页需要排序
users = users.OrderByDescending(p => p.UserId);
//return View(users.ToList());
return(View(users.ToPagedList(currentPage,
maxRecords)));
}
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));
}