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