public static PageSetting User_SelPage(int cpage, int psize, F_User filter)
{
List <SqlParameter> sp = new List <SqlParameter>();
string where = "SiteID=" + filter.storeId + " ";
//where += " AND Status=0";
switch (filter.utype)
{
case "employee":
where += " AND GroupID=" + ExConast.EmployGroup;
break;
case "client":
default:
where += " AND GroupID=" + ExConast.ClientGroup;
break;
}
if (!string.IsNullOrEmpty(filter.uname))
{
sp.Add(new SqlParameter("uname", "%" + filter.uname + "%"));
where += " AND UserName LIKE @uname";
}
if (filter.status != -100)
{
where += " AND Status=" + filter.status;
}
PageSetting setting = PageSetting.Single(cpage, psize, "ZL_User", "UserID", where, "UserID DESC", sp);
DBCenter.SelPage(setting);
return(setting);
}
/// <summary>
/// 员工筛选,带角色名称
/// </summary>
public static DataTable Employ_Sel(F_User filter)
{
List <SqlParameter> sp = new List <SqlParameter>();
string where = "SiteID=" + filter.storeId + " ";
where += " AND GroupID=" + ExConast.EmployGroup;
if (!string.IsNullOrEmpty(filter.uname))
{
sp.Add(new SqlParameter("uname", "%" + filter.uname + "%"));
where += " AND UserName LIKE @uname";
}
if (filter.status != -100)
{
where += " AND Status=" + filter.status;
}
PageSetting setting = PageSetting.Double(1, int.MaxValue, "ZL_User", "ZL_Ex_ERole", "A.UserID",
"A.PageID=B.ID", where, "A.UserID DESC", sp);
DBCenter.SelPage(setting);
return(setting.dt);
}
/// <summary>
/// 获取指定店铺的员工|客户信息
/// </summary>
public static DataTable User_Sel(F_User filter)
{
return(User_SelPage(1, int.MaxValue, filter).dt);
}
