// 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);
}
