// admin管理员表查询 public static HouseFenYe AdminChaXun(int pageIndex, int pageSize)// { NewHope4Entities ent = new NewHope4Entities(); var obj = from p in ent.Admin orderby p.UserID where p.state == 0 select new { UserID = p.UserID, UserName = p.UserName, Name = p.Name, Email = p.Email, Phone = p.Phone, LoginNum = p.LoginNum, Did = p.department.DName, RID = p.role.RName, Userpwd = p.Userpwd, UserTypeID = p.UserTypeID, state = p.state }; var ms = obj.ToString(); HouseFenYe fy = new HouseFenYe(); fy.list = obj.Skip((pageIndex - 1) * pageSize).Take(pageSize); fy.PageCount = obj.Count(); return(fy); //return obj; }
// menu表查询 public static HouseFenYe menuChaXun(int pageIndex, int pageSize)// { NewHope4Entities ent = new NewHope4Entities(); var obj = from p in ent.menu orderby p.MID where p.state == 0 select new { MID = p.MID, MNmae = p.MNmae, PID = p.Parentmenu.UserTypeName, TypeID = p.MenuType.MName, style = p.style, sort = p.sort, path = p.path, CreationDate = p.CreationDate, state = p.state }; var ms = obj.ToString(); HouseFenYe fy = new HouseFenYe(); fy.list = obj.Skip((pageIndex - 1) * pageSize).Take(pageSize); fy.PageCount = obj.Count(); return(fy); }
//根据菜单名称查询 public static HouseFenYe menuChaXunByName(string user2, int pageIndex, int pageSize)// { NewHope4Entities ent = new NewHope4Entities(); var obj = from p in ent.menu orderby p.MID select new { MID = p.MID, MNmae = p.MNmae, PID = p.Parentmenu.UserTypeName, TypeID = p.MenuType.MName, style = p.style, sort = p.sort, path = p.path, CreationDate = p.CreationDate, state = p.state }; try { int num = int.Parse(user2); obj = obj.Where(p => p.MID == num); } catch (Exception) { obj = obj.Where(p => p.MNmae.Contains(user2)); } HouseFenYe fy = new HouseFenYe(); fy.list = obj.Skip((pageIndex - 1) * pageSize).Take(pageSize); fy.PageCount = obj.Count(); return(fy); }
//根据员工名称查询 public static HouseFenYe departmentChaXunByName(string user2, int pageIndex, int pageSize)// { NewHope4Entities ent = new NewHope4Entities(); var obj = from p in ent.department orderby p.Did where p.state == 0 select new { Did = p.Did, DName = p.DName, CreationDate = p.CreationDate, state = p.state }; try { int num = int.Parse(user2); obj = obj.Where(p => p.Did == num); } catch (Exception) { obj = obj.Where(p => p.DName.Contains(user2)); } HouseFenYe fy = new HouseFenYe(); fy.list = obj.Skip((pageIndex - 1) * pageSize).Take(pageSize); fy.PageCount = obj.Count(); return(fy); }
//根据员工名称查询 public static HouseFenYe roleChaXunByName(string user2, int pageIndex, int pageSize)// { NewHope4Entities ent = new NewHope4Entities(); var obj = from p in ent.role orderby p.RID select new { RID = p.RID, RName = p.RName, CreationDate = p.CreationDate, remark = p.remark, state = p.state }; try { int num = int.Parse(user2); obj = obj.Where(p => p.RID == num); } catch (Exception) { obj = obj.Where(p => p.RName.Contains(user2)); } HouseFenYe fy = new HouseFenYe(); fy.list = obj.Skip((pageIndex - 1) * pageSize).Take(pageSize); fy.PageCount = obj.Count(); return(fy); }
//根据员工名称查询 public static HouseFenYe AdminChaXunByName(string user2, int pageIndex, int pageSize)// { NewHope4Entities ent = new NewHope4Entities(); var obj = from p in ent.Admin orderby p.UserID where p.state == 0 select new { UserID = p.UserID, UserName = p.UserName, Name = p.Name, Email = p.Email, Phone = p.Phone, LoginNum = p.LoginNum, Did = p.department.DName, RID = p.role.RName, Userpwd = p.Userpwd, UserTypeID = p.UserTypeID, state = p.state }; try { int num = int.Parse(user2); obj = obj.Where(p => p.UserID == num); } catch (Exception) { obj = obj.Where(p => p.UserName.Contains(user2)); } //if (user > 0) //{ // obj = obj.Where(p => p.UserID == user); //} //else if(!string.IsNullOrEmpty(user2)) //{ // obj = obj.Where(p => p.UserName.Contains(user2)); //} //var ms = obj.ToString(); HouseFenYe fy = new HouseFenYe(); fy.list = obj.Skip((pageIndex - 1) * pageSize).Take(pageSize); fy.PageCount = obj.Count(); return(fy); //return obj; }
//模糊查询 public static HouseFenYe AdminHouseChaXun(int userId, string name, int BuMen, int JueSe, int pageIndex, int pageSize) { NewHope4Entities ent = new NewHope4Entities(); var obj = from p in ent.Admin orderby p.UserID where p.state == 0 select new { UserID = p.UserID, UserName = p.UserName, Name = p.Name, Email = p.Email, Phone = p.Phone, LoginNum = p.LoginNum, Did = p.department.DName, RID = p.role.RName, Did2 = p.Did, Rid2 = p.RID, Userpwd = p.Userpwd, UserTypeID = p.UserTypeID, state = p.state }; if (userId != 0) { obj = obj.Where(p => p.UserID == userId); } if (!string.IsNullOrEmpty(name)) { obj = obj.Where(p => p.Name.Contains(name)); } if (BuMen != 0) { obj = obj.Where(p => p.Did2 == BuMen); } if (JueSe != 0) { obj = obj.Where(p => p.Rid2 == JueSe); } var ms = obj.ToString(); HouseFenYe fy = new HouseFenYe(); fy.list = obj.Skip((pageIndex - 1) * pageSize).Take(pageSize); fy.PageCount = obj.Count(); return(fy); }
// department表查询 public static HouseFenYe departmentChaXun(int pageIndex, int pageSize)// { NewHope4Entities ent = new NewHope4Entities(); var obj = from p in ent.department orderby p.Did where p.state == 0 select new { Did = p.Did, DName = p.DName, CreationDate = p.CreationDate, state = p.state }; var ms = obj.ToString(); HouseFenYe fy = new HouseFenYe(); fy.list = obj.Skip((pageIndex - 1) * pageSize).Take(pageSize); fy.PageCount = obj.Count(); return(fy); }
/// <summary> /// role表查询 /// </summary> /// <returns></returns> public static HouseFenYe roleChaXun(int pageIndex, int pageSize)// { NewHope4Entities ent = new NewHope4Entities(); var obj = from p in ent.role orderby p.RID where p.state == 0 select new { RID = p.RID, RName = p.RName, CreationDate = p.CreationDate, remark = p.remark, state = p.state }; var ms = obj.ToString(); HouseFenYe fy = new HouseFenYe(); fy.list = obj.Skip((pageIndex - 1) * pageSize).Take(pageSize); fy.PageCount = obj.Count(); return(fy); }