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