private void BindGrid() { string email = SearchEmail.Value.Trim(); bool isAdmin = SearchAdmin.Checked; DataTable dt = oUserBLL.searchUser(email, isAdmin); UserList.DataSource = dt; UserList.DataBind(); }
protected void UserList_ItemCanceling(object sender, ListViewCancelEventArgs e)//отмена редактирования { UserList.EditIndex = -1; UserList.DataSource = usServ.ReadAll() .Select(c => new { c.Id, c.Name, c.RoleId, c.IsDeleted }) .ToList(); UserList.DataBind(); }
private void BindGrid() { UserList.DataSource = cEmpleado.obtenerEmpleados(objConexion).Tables[0].DefaultView; UserList.DataBind(); cEmpleado.closeConexion(); ClienteList.DataSource = cCliente.obtenerClientes(objConexion).Tables[0].DefaultView; ClienteList.DataBind(); cCliente.closeConexion(); }
protected void Page_Load(object sender, EventArgs e) { userBusiness = IOCContainer.Resolve <IUserBusiness>(); if (!Page.IsPostBack) { UserList.DataSource = userBusiness.Get(); UserList.DataBind(); } }
/// <summary> /// Handles the Click event of the SearchUsers control to databind the user list with search result. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="System.EventArgs"/> instance containing the event data.</param> protected void SearchUsers_Click(object sender, EventArgs e) { // Make sure to clear any membership modifications before showing the new search result. _modifiedMembers.Clear(); UserList.PageIndex = 0; UserList.DataBind(); //Hide 'Save' button if there is empty result. SaveMembership.Visible = IsEditable; SendNotificationsConfirmation.Visible = SaveMembership.Visible; }
protected void UserList_ItemEditing(object sender, ListViewEditEventArgs e) //переход в режи редактирования { UserList.EditIndex = e.NewEditIndex; //индекс редактируемой RoleIdDbUpdate(); UserList.DataSource = usServ.ReadAll() .Select(c => new { c.Id, c.Name, c.RoleId, c.IsDeleted }) .ToList(); UserList.DataBind(); }
protected void UserList_ItemDeleting(object sender, ListViewDeleteEventArgs e)//CommandName имя команды для уволнения { var id = (int)e.Keys["Id"]; usServ.Delete(id); UserList.DataSource = usServ.ReadAll() .Select(c => new { c.Id, c.Name, c.RoleId, c.IsDeleted }) .ToList(); UserList.DataBind(); //чтобы закинуть в таблицу }
private void BindUsersToUserList() { // Get all of the user accounts MembershipUserCollection users = Membership.GetAllUsers(); UserList.DataSource = users; UserList.DataBind(); // Check the selected user's roles CheckRolesForSelectedUser(); }
protected void CSOM_Click(object sender, EventArgs e) { string commandAccessToken = ((LinkButton)sender).CommandArgument; RetrieveWithCSOM(commandAccessToken); WebTitleLabel.Text = siteName; CurrentUserLabel.Text = currentUser; UserList.DataSource = listOfUsers; UserList.DataBind(); ListList.DataSource = listOfLists; ListList.DataBind(); }
private void BindData() { try { UserList.DataSource = LearningManagementSystem.Components.User.GetUserList(); UserList.DataBind(); } catch (Exception ex) { Omnificence.Trace.Logger.Log(ex.Message.ToString()); } }
protected void UserList_EditCommand(object source, DataListCommandEventArgs e) { this.Timer1.Enabled = false; this.UserList.EditItemIndex = e.Item.ItemIndex; string ID = this.UserList.DataKeys[e.Item.ItemIndex].ToString(); string mySql = "select UserName,Password,PhoneNumber from UserInfo where PhoneNumber='" + ID + "'"; DataSet MySet = DataBase.RunDataSet(mySql); DataTable MyTable = MySet.Tables[0]; UserList.DataSource = MyTable; UserList.DataBind(); }
private void RefreshUserList() { UserList.Items.Clear(); SnitzRoleProvider srp = new SnitzRoleProvider(); srp.GetUsersInRole(txtName.Text); UserList.DataSource = srp.GetUsersInRole(txtName.Text); UserList.DataBind(); UsersInRole.Text = String.Format("{0} User(s) in {1} Role", UserList.Items.Count, txtName.Text); NewUserForRole.Text = ""; }
protected void SaveBtn_Click(object sender, EventArgs e) { var NameTxt = UserList.FindControlRecursive <TextBox>("NameTxt"); // имя которое введем var NewUser = new User(); NewUser.Name = NameTxt.Text; var RoleIdDdl = UserList.FindControlRecursive <DropDownList>("RoleIdDdl"); Enum.TryParse <RoleEnum>(RoleIdDdl.SelectedValue, out var role); NewUser.RoleId = role; usServ.Create(NewUser); UserList.DataSource = usServ.ReadAll() .Select(c => new { c.Id, c.Name, c.RoleId, c.IsDeleted }) .ToList(); UserList.DataBind(); }
void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { if ((Page.User.IsInRole("ProjectAdministrator") || Page.User.IsInRole("ProjectManager"))) { UserList.DataSourceID = "ProjectMembers"; if (Page.User.IsInRole("ProjectAdministrator")) { ProjectData.SortParameterName = "sortParameter"; ProjectData.SelectMethod = "GetAllProjects"; } else if (Page.User.IsInRole("ProjectManager")) { ProjectData.SelectParameters.Add(new Parameter("userName", TypeCode.String, Page.User.Identity.Name)); ProjectData.SortParameterName = "sortParameter"; ProjectData.SelectMethod = "GetProjectsByManagerUserName"; } } else { ProjectData.SelectParameters.Add(new Parameter("userName", TypeCode.String, Page.User.Identity.Name)); ProjectData.SelectMethod = "GetProjectsByUserName"; UserList.Items.Add(Page.User.Identity.Name); } ProjectList.DataBind(); UserList.DataBind(); ProjectListGridView.DataBind(); if (ProjectList.Items.Count >= 1) { TimeEntryView.Visible = true; MessageView.Visible = false; } else { TimeEntryView.Visible = false; MessageView.Visible = true; } } if (UserList.Items.Count == 0) { AddEntry.Enabled = false; } }
public void Page_Init() { UserRoles.DataSource = Roles.GetAllRoles(); UserRoles.DataBind(); UserList.DataSource = Membership.GetAllUsers(); UserList.DataBind(); if (IsPostBack) { selectedFolderName = ""; } else { selectedFolderName = Request.QueryString["selectedFolderName"]; } }
protected void UserList_ItemUpdating(object sender, ListViewUpdateEventArgs e) //сохранение после редактирования { var id = int.Parse(((Label)UserList.Items[e.ItemIndex].FindControl("IDLbl")).Text); var name = ((TextBox)UserList.Items[e.ItemIndex].FindControl("EditNameTxt")).Text; var roleList = ((DropDownList)UserList.Items[e.ItemIndex].FindControl("RoleIdDdl")); var user = usServ.Read(id); user.Name = name; Enum.TryParse <RoleEnum>(roleList.SelectedValue, out var role); user.RoleId = role; usServ.Update(user); UserList.EditIndex = -1; UserList.DataSource = usServ.ReadAll() .Select(c => new { c.Id, c.Name, c.RoleId, c.IsDeleted }) .ToList(); UserList.DataBind(); }
private void BindUserData() { ///定义获取数据的类 User user = new User(); SqlDataReader recu = user.GetUsers(); ///设定控件的数据源 UserList.DataSource = recu; ///设定控件的Text属性和Value属性 UserList.DataTextField = "UserName"; UserList.DataValueField = "UserID"; ///绑定控件的数据 UserList.DataBind(); ///关闭数据读取器和数据库的连接 recu.Close(); }
private void BindUserList() { using (SysUserBusiness user = new SysUserBusiness()) { if (IsAdmin) { UserList.DataSource = user.GetSysUsers(); List <SysUserViewEntity> SysUsers = user.GetSysUsers(); List <RoleMemberEntity> RoleMembers = m_Role.GetRoleMembers(RoleNo); SysUserViewEntity SysUser; foreach (RoleMemberEntity RoleMember in RoleMembers) { SysUser = SysUsers.Where(p => p.UserNo == RoleMember.UserNo).ToList().FirstOrDefault(); SysUsers.Remove(SysUser); } UserList.DataSource = SysUsers; } UserList.DataBind(); } }
protected void btnUsers_Click(object sender, EventArgs e) { var SPContext = SharePointContextProvider.Current.GetSharePointContext(Context); using (var clientContext = SPContext.CreateUserClientContextForSPHost()) { clientContext.Load(clientContext.Web.CurrentUser); clientContext.ExecuteQuery(); UserCollection users = clientContext.Web.SiteUsers; clientContext.Load <UserCollection>(users); clientContext.ExecuteQuery(); foreach (User siteUser in users) { listOfUsers.Add(siteUser.Title); } UserList.DataSource = listOfUsers; UserList.DataBind(); } }
/// <summary> /// 绑定用户数据 /// </summary> protected void BindOrder() { string strWhere = "(dbo.Users.RoleID <> 0)"; if (GroupList.SelectedValue != "all") { strWhere = strWhere + " and dbo.Users.UserGroup=" + GroupList.SelectedValue; } DataSet ds = bll.GetUserList(strWhere, "ORDER BY dbo.Users.CreateTime DESC"); if (ds.Tables[0].Rows.Count == 0) { GridViewMsg.InnerText = ResourceManager.GetString("Pub_Msg_norecord"); } else { GridViewMsg.InnerText = ResourceManager.GetString("Pub_Lab_gy") + ds.Tables[0].Rows.Count + ResourceManager.GetString("Pub_Lab_tjl"); } UserList.DataSource = ds; UserList.DataBind(); }
protected void LoadUserList() { using (var db = CLinq.DataContext.Create()) { var userQuery = from u in db.Users orderby u.UserRef select new { u.UserRef, u.UserName, u.EmailAddress, LastLoginDate = u.LastLogin, Comments = u.Comments.Count, Ratings = u.UserToLinks.Count, PollVotes = u.UserToPollOptions.Count, u.IsAdmin }; UserList.DataSource = userQuery.ToList(); UserList.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { TimeTxt.Text = DateTime.Now.ToString("yyyy-MM-dd"); string AddTime = System.DateTime.Now.AddDays(1).ToString("yyyy-MM-dd"); if (!IsPostBack) { DataTable dt = Session["UserTable"] as DataTable; if (dt.Rows[0]["UserType"].ToString() == "3") { this.shop.Visible = false; this.num.Visible = false; } SelectInfo(TimeTxt.Text, AddTime); string Sql = "select UserName,Password,PhoneNumber from UserInfo where UserType=3"; DataSet ST = DataBase.RunDataSet(Sql); DataTable S = ST.Tables[0]; UserList.DataSource = S; UserList.DataBind(); Timer Timer1 = new Timer(); Timer1.Enabled = true; //启动计时器 } }
/// <summary> /// 绑定数据 /// </summary> protected void BindData() { #region oooooooooooold Code //DataTable sd = new DataTable(); //string[] sql = new string[2]; //string topSQL = " top 30 "; //sql[0] = "select " + topSQL + " * from VUsersAlbum where Enable='" + Library.EnableState.未处理 + "'"; //sql[1] = "select " + topSQL + " count(*) from VUsersAlbum where Enable='" + Library.EnableState.未处理 + "'"; //string url = "UserAlbum.aspx"; //PageLink page_set = new PageLink( url, 30, 10, "", sql ); //page_set.paraLinkType = paraLinkShow.middling.ToString(); //sd = page_set.get_table(); //if( sd.Rows.Count > 0 ) //{ // rptDataList.DataSource = sd; // rptDataList.DataBind(); // this.pageList.Text = page_set.pageList(); //} //else // this.NoUserList.Visible = true; //sd.Clear(); #endregion DbSession.Default.CacheOn(); string where = ""; string es = CommonManager.Web.RequestUrlDecode("es", ""); string userid = CommonManager.Web.RequestUrlDecode("userid", ""); //Limit.getFormValue( "userid" ); if (!string.IsNullOrEmpty(es)) { where = "and Enable='" + es + "'"; //Response.Write( where ); //Response.End(); } if (!string.IsNullOrEmpty(userid)) { where += string.IsNullOrEmpty(where) ? "and UserName='******'" : "and UserName='******'"; //Response.Write( where ); //Response.End(); } DataSet dt = DbSession.Default.FromProc("Web_pGetDataPager") .AddInputParameter("@PageSize", DbType.Int32, anpPageIndex.PageSize) .AddInputParameter("@CurrentPage", DbType.Int32, PageIndex) .AddInputParameter("@Columns", DbType.String, "*") .AddInputParameter("@TableName", DbType.String, "VUsersAlbum") .AddInputParameter("@Wheres", DbType.String, " " + where) .AddInputParameter("@KeyName", DbType.String, "ID") .AddInputParameter("@OrderBy", DbType.String, "InputTime desc") .ToDataSet(); //.AddInputParameter( "@QueryStr", DbType.String, "select * from VUsersAlbum" + where ) //.AddInputParameter( "@PageSize", DbType.Int32, anpPageIndex.PageSize ) //.AddInputParameter( "@PageCurrent", DbType.Int32, PageIndex ) //.AddInputParameter( "@FdShow", DbType.String, "*" ) //.AddInputParameter( "@FdOrder", DbType.String, "InputTime desc" ) //.ToDataTable(); if (/*dt.Rows.Count <= 0*/ dt.Tables.Count > 0 && dt.Tables[1].Rows.Count > 0) { anpPageIndex.RecordCount = (int)dt.Tables[0].Rows[0][0]; //DbSession.Default.Count<VUsersAlbum>( new WhereClip( where.Replace( "where", "" ) ) ); anpPageIndex.CurrentPageIndex = PageIndex; UserList.DataSource = dt.Tables[1]; UserList.DataBind(); UserList.Visible = true; NoUserList.Visible = false; } else { UserList.Visible = false; this.NoUserList.Visible = true; } }
private void BindGrid() { UserList.DataSource = cMercaderia.obtenerMercaderia(objConexion).Tables[0].DefaultView; UserList.DataBind(); cMercaderia.closeConexion(); }
public override void DataBind() { base.DataBind(); UserList.DataSource = Controller.GetUsers(); UserList.DataBind(); }
protected void GroupList_SelectedIndexChanged(object sender, EventArgs e) { GroupText.Text = GroupList.SelectedItem.ToString(); UserList.DataBind(); }
/// <summary> /// Bind data for this control. /// </summary> private void BindData() { // load available images from images/medals folder using (DataTable dt = new DataTable("Files")) { // create structure dt.Columns.Add("FileID", typeof(long)); dt.Columns.Add("FileName", typeof(string)); dt.Columns.Add("Description", typeof(string)); // add blank row DataRow dr = dt.NewRow(); dr["FileID"] = 0; dr["FileName"] = "../spacer.gif"; // use blank.gif for Description Entry dr["Description"] = "Select Medal Image"; dt.Rows.Add(dr); // add files from medals folder DirectoryInfo dir = new DirectoryInfo(Request.MapPath(String.Format("{0}images/medals", YafForumInfo.ForumFileRoot))); FileInfo[] files = dir.GetFiles("*.*"); long nFileID = 1; foreach (FileInfo file in files) { string sExt = file.Extension.ToLower(); // do just images if (sExt != ".png" && sExt != ".gif" && sExt != ".jpg") { continue; } dr = dt.NewRow(); dr["FileID"] = nFileID++; dr["FileName"] = file.Name; dr["Description"] = file.Name; dt.Rows.Add(dr); } // medal image MedalImage.DataSource = dt; MedalImage.DataValueField = "FileName"; MedalImage.DataTextField = "Description"; // ribbon bar image RibbonImage.DataSource = dt; RibbonImage.DataValueField = "FileName"; RibbonImage.DataTextField = "Description"; // small medal image SmallMedalImage.DataSource = dt; SmallMedalImage.DataValueField = "FileName"; SmallMedalImage.DataTextField = "Description"; // small ribbon bar image SmallRibbonImage.DataSource = dt; SmallRibbonImage.DataValueField = "FileName"; SmallRibbonImage.DataTextField = "Description"; } // bind data to controls DataBind(); // load existing medal if we are editing one if (Request.QueryString["m"] != null) { // load users and groups who has been assigned this medal UserList.DataSource = DB.user_medal_list(null, Request.QueryString["m"]); UserList.DataBind(); GroupList.DataSource = DB.group_medal_list(null, Request.QueryString["m"]); GroupList.DataBind(); // enable adding users/groups AddUserRow.Visible = true; AddGroupRow.Visible = true; using (DataTable dt = YAF.Classes.Data.DB.medal_list(Request.QueryString["m"])) { // get data row DataRow row = dt.Rows[0]; // load flags MedalFlags flags = new MedalFlags(row["Flags"]); // set controls Name.Text = row["Name"].ToString(); Description.Text = row["Description"].ToString(); Message.Text = row["Message"].ToString(); Category.Text = row["Category"].ToString(); SortOrder.Text = row["SortOrder"].ToString(); ShowMessage.Checked = flags.ShowMessage; AllowRibbon.Checked = flags.AllowRibbon; AllowHiding.Checked = flags.AllowHiding; AllowReOrdering.Checked = flags.AllowReOrdering; // select images SelectImage(MedalImage, MedalPreview, row["MedalURL"]); SelectImage(RibbonImage, RibbonPreview, row["RibbonURL"]); SelectImage(SmallMedalImage, SmallMedalPreview, row["SmallMedalURL"]); SelectImage(SmallRibbonImage, SmallRibbonPreview, row["SmallRibbonURL"]); } using (DataTable dt = DB.group_list(PageContext.PageBoardID, null)) { // get data row DataRow row = dt.Rows[0]; AvailableGroupList.DataSource = dt; AvailableGroupList.DataTextField = "Name"; AvailableGroupList.DataValueField = "GroupID"; AvailableGroupList.DataBind(); } } else { // set all previews on blank image MedalPreview.Src = String.Format("{0}images/spacer.gif", YafForumInfo.ForumRoot); RibbonPreview.Src = String.Format("{0}images/spacer.gif", YafForumInfo.ForumRoot); SmallMedalPreview.Src = String.Format("{0}images/spacer.gif", YafForumInfo.ForumRoot); SmallRibbonPreview.Src = String.Format("{0}images/spacer.gif", YafForumInfo.ForumRoot); } }
//------------------------------------------------------------------------------------------- private void UpdateUsers() { UserList.DataSource = Roles.GetUsersInRole(RolesList.SelectedItem.Text); UserList.DataBind(); }
/// <summary> /// Updates the state of the control (visible buttons etc.) according to the new View Mode. /// </summary> /// <param name="viewMode">The new view mode.</param> private void SetViewMode(ViewMode viewMode) { bool isAdministrator = Membership.QueryDistinctMembershipLevel(WorkroomStartPage, MembershipLevels.Administer); if (!isAdministrator) { viewMode = ViewMode.ViewMembers; } ActiveMode = viewMode; switch (viewMode) { case ViewMode.ViewMembers: ToolBarButtons.Visible = isAdministrator; PersistButtons.Visible = false; ConfirmDeleteButtons.Visible = false; SearchDialog.Visible = false; ConfirmDeleteButtons.Visible = false; DeleteButton.Visible = false; DeleteUserDialog.Visible = false; MemberListHeading.Text = Translate("/workroom/membershipmanager/viewmembersheading"); SendNotificationsConfirmation.Visible = false; break; case ViewMode.AddMembers: ToolBarButtons.Visible = false; PersistButtons.Visible = true; DeleteButton.Visible = false; SearchDialog.Visible = true; ConfirmDeleteButtons.Visible = false; DeleteButton.Visible = false; DeleteUserDialog.Visible = false; MemberListHeading.Text = Translate("/workroom/membershipmanager/searchresultheading"); FillInviteMembershipDropDown(); SendNotificationsConfirmation.Visible = true; SendOkPanel.Visible = false; SendErrorPanel.Visible = false; SendNotificationsConfirmation.Visible = false; break; case ViewMode.EditMembers: ToolBarButtons.Visible = false; PersistButtons.Visible = true; SearchDialog.Visible = false; DeleteButton.Visible = true; ConfirmDeleteButtons.Visible = false; DeleteUserDialog.Visible = false; MemberListHeading.Text = Translate("/workroom/membershipmanager/managemembersheading"); SendNotificationsConfirmation.Visible = true; break; case ViewMode.DeleteMember: ToolBarButtons.Visible = false; PersistButtons.Visible = false; DeleteButton.Visible = false; ConfirmDeleteButtons.Visible = true; DeleteUserDialog.Visible = true; SearchDialog.Visible = false; MemberListHeading.Text = Translate("/workroom/membershipmanager/managemembersheading"); SendOkPanel.Visible = false; SendErrorPanel.Visible = false; SendNotificationsConfirmation.Visible = true; break; } //Clear search criteria UserName.Text = string.Empty; Email.Text = string.Empty; // Always clear the collection of modified members, // this is only for persisting modifications between changes in paging. _modifiedMembers.Clear(); SetupDeleteUserSelection(); UserList.PageIndex = 0; UserList.DataBind(); }
public void UsersLoginList() { string bt = CommonManager.Web.Request("bt", ""); string et = CommonManager.Web.Request("et", ""); string kw = CommonManager.Web.Request("kw", "").Replace('$', '\\'); string isLike = CommonManager.Web.Request("IsLike", ""); string selType = CommonManager.Web.Request("sel", ""); //关键字类别 string sel2 = CommonManager.Web.Request("sel2", ""); //某条件如:ip/matchinecode string sel3 = CommonManager.Web.Request("sel3", ""); //玩家状态 string sel4 = CommonManager.Web.Request("sel4", ""); //排列条件 string sel5 = CommonManager.Web.Request("sel5", "desc"); //排列方式 string loginCount = CommonManager.Web.Request("loginCount", "0"); //某条件下登录的次数 string sqlWhere = ""; string order = ""; if (sel4 == "mcode") { order = " MachineCode " + sel5; } else if (sel4 == "ip") { order = "LastLoginIP " + sel5; } else { order = "LastLoginTM " + sel5; } if (bt != "") { sqlWhere += " and LastLoginTm>='" + bt + "'"; } if (et != "") { sqlWhere += " and LastLoginTM<='" + et + "'"; } if (kw != "") { if (selType == "1") { sqlWhere += (isLike == "1")? " and username like '%" + kw + "%'":" and username='******'"; } else if (selType == "2") { sqlWhere += (isLike == "1") ? " and userid like '%" + kw + "%'" : " and userid=" + kw; } else if (selType == "3") { sqlWhere += (isLike == "1") ? " and LastLoginIP like '%" + kw + "%'" : " and LastLoginIP='" + kw + "'"; } else if (selType == "4") { sqlWhere += (isLike == "1") ? " and machinecode like '%" + kw + "%'" : " and machinecode='" + kw + "'"; } else { sqlWhere += (isLike == "1") ? " and HardID like '%" + kw + "%'" : " and HardID='" + kw + "'"; } } if (sel3 != "" && sel3 != "0") { if (sel3 == "1") { sqlWhere += " and [disabled]=1 or machinecode in (select LockCode from TLockCode) or lastloginip in (select accessipchar from TGameIPRule where LimitedLogon<>0) "; } else { sqlWhere += " and [disabled]=0 and machinecode not in (select LockCode from TLockCode) and lastloginip not in (select accessipchar from TGameIPRule where LimitedLogon<>0)"; } } if (loginCount != "0") { if (sel2 == "ip") { sqlWhere += " and lastloginip IN ( SELECT lastloginip FROM web_vuserloginlist GROUP BY lastloginip HAVING COUNT(lastloginip)>" + loginCount + ")"; } else { sqlWhere += " and MachineCode in (select MachineCode from Web_vuserLoginList GROUP BY MachineCode having count(machinecode)>" + loginCount + ")"; } } DataSet ds = DbSession.Default.FromProc("Web_pGetDataPager") .AddInputParameter("@PageSize", DbType.Int32, anpPageIndex.PageSize) .AddInputParameter("@CurrentPage", DbType.Int32, PageIndex) .AddInputParameter("@Columns", DbType.String, "*") .AddInputParameter("@TableName", DbType.String, "Web_vUserLoginList") .AddInputParameter("@Wheres", DbType.String, sqlWhere) .AddInputParameter("@KeyName", DbType.String, "UserID") .AddInputParameter("@OrderBy", DbType.String, order) .ToDataSet(); if (ds.Tables.Count > 0 && ds.Tables[1].Rows.Count > 0) { anpPageIndex.RecordCount = (int)ds.Tables[0].Rows[0][0]; anpPageIndex.CurrentPageIndex = PageIndex; DataTable dt = ds.Tables[1]; dt.Columns.Add("IsLimitIP", typeof(bool)); dt.Columns.Add("IsLockCode", typeof(bool)); dt.Columns.Add("IsLockHard", typeof(bool)); foreach (DataRow row in dt.Rows) { row["IsLimitIP"] = DbSession.Default.FromSql("select count(AccessIPChar) from TGameIPRule where LimitedLogon<>0 and AccessIPChar='" + row["LastLoginIP"].ToString() + "'").ToScalar(); row["IsLockCode"] = DbSession.Default.FromSql("select count(LockCode) from TLockCode where LockCode='" + row["MachineCode"].ToString() + "'").ToScalar(); row["IsLockHard"] = DbSession.Default.FromSql("select count(LockHard) from TLockCode where LockHard='" + row["HardID"].ToString() + "'").ToScalar(); } UserList.DataSource = dt; UserList.DataBind(); UserList.Visible = true; NoUserList.Visible = false; } else { anpPageIndex.CurrentPageIndex = 1; this.NoUserList.Visible = true; UserList.Visible = false; } }