protected string QueryServers(dt_user_groups group) { var servers = group.li_user_group_servers.Select(g => g.dt_users).Select( u => string.IsNullOrWhiteSpace(u.real_name) ? u.user_name : string.Format("{0}({1})", u.user_name, u.real_name)).ToList(); return(string.Join("<br>", servers)); }
protected string QueryDepartmentName(dt_user_groups group) { Agp2pDataContext context = new Agp2pDataContext(); var c = context.li_user_group_departments.FirstOrDefault(w => w.user_group_id == group.id); if (c != null) { return(context.li_departments.FirstOrDefault(w => w.id == c.department_id).department_name); } else { return(null); } }
protected void Page_Load(object sender, EventArgs e) { pageSize = GetPageSize(10); //每页数量 page = DTRequest.GetQueryInt("page", 1); var group_id = DTRequest.GetQueryString("group_id"); title = DTRequest.GetFormString("title"); groupNames = DTRequest.GetFormString("groupNames"); mobiles = DTRequest.GetFormString("mobiles").Trim(); if (!string.IsNullOrWhiteSpace(title)) { hidtitle.Value = title; } if (!string.IsNullOrWhiteSpace(groupNames)) { hidgroupNames.Value = groupNames; } if (!string.IsNullOrWhiteSpace(mobiles)) { hidmobiles.Value = mobiles; } if (!string.IsNullOrWhiteSpace(hidtitle.Value.ToString())) { dt_user_groups ug = context.dt_user_groups.FirstOrDefault(c => c.title == hidtitle.Value.ToString()); group_id = ug.id.ToString(); } if (string.IsNullOrWhiteSpace(group_id)) { JscriptMsg("传输参数不正确!", "back", "Error"); return; } groupId = Convert.ToInt32(group_id); if (!Page.IsPostBack) { //ChkAdminLevel("ChoiceUser", DTEnums.ActionEnum.Edit.ToString()); //检查权限 var keywords = DTRequest.GetQueryString("keywords"); if (!string.IsNullOrEmpty(keywords)) { txtKeywords.Text = keywords; } RptBind(); } }
protected decimal QueryGroupUserWalletSum(dt_user_groups group, Func <li_wallets, decimal> columnSelector) { return(group.dt_users.Select(u => u.li_wallets).Sum(columnSelector)); }
protected int QueryGroupUserCount(dt_user_groups group) { return(group.dt_users.Count()); }