/// <summary> /// 绑定数据 /// </summary> protected void BindData() { String strSql = "SELECT * FROM [T_UserRole]"; DataTable dt = db.ExecuteDataTable(strSql); Repeater1.BindPage(Pager1, dt.DefaultView, dt.Rows.Count); }
/// <summary> /// 绑定数据 /// </summary> private void BindData() { String sql = "SELECT * FROM [t_links] ORDER BY id DESC"; DataTable dt = db.ExecuteDataTable(sql); Repeater1.BindPage(Pager1, dt.DefaultView, dt.Rows.Count); }
/// <summary> /// 绑定数据 /// </summary> private void BindData() { String sql = "SELECT a.*, IsNull(b.menuName ,'顶级分类') AS pName FROM [T_SiteMenu] AS a LEFT JOIN [T_SiteMenu] AS b ON a.[ParentID] = b.id ORDER BY a.parentid,a.sort"; DataTable dt = db.ExecuteDataTable(sql); Repeater1.BindPage(Pager1, dt.DefaultView, dt.Rows.Count); }
/// <summary> /// 绑定数据 /// </summary> private void BindData() { //String sql = String.Format("SELECT a.*,IsNull(b.GroupName,'顶级栏目') AS ParentName FROM [t_group] AS a LEFT JOIN [t_group] AS b ON a.ParentID = b.ID WHERE a.tablename='{0}' ORDER BY a.parentid ASC,a.id", TableName); //Groups = db.ExecuteObject<List<T_Group>>(sql); var groups = Groups.FindAll(a => { return(a.TableName == TableName); }); Repeater1.BindPage <T_GroupEntity>(Pager1, Groups); }
/// <summary> /// 绑定数据 /// </summary> protected void BindData() { String sql = "SELECT a.*,b.name FROM [T_User] AS a LEFT JOIN [t_userrole] AS b ON a.roleid = b.id"; if (!Admin.IsSuper) { sql += " WHERE a.Super=0"; } DataTable dt = db.ExecuteDataTable(sql); Repeater1.BindPage(Pager1, dt.DefaultView, dt.Rows.Count); }
/// <summary> /// 数据绑定 /// </summary> protected void BindData() { String _dir = Server.MapPath("/Developer/BackUp"); if (!Directory.Exists(_dir)) { Directory.CreateDirectory(_dir); } DirectoryInfo directory = new DirectoryInfo(_dir); FileInfo[] files = directory.GetFiles("*.rar"); Repeater1.BindPage(Pager1, files, files.Length); }