日期:2014-05-17 浏览次数:20647 次
namespace NEWS_CHANEL.Admin
{
public partial class AdminList : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
data();
PageControl.ResetGridView(this.GridView1);
}
}
private void data()
{
BLL.SysAdmin admin = new BLL.SysAdmin();
SqlDataReader dr = admin.GetAdmins();
DataTable dt = SQLHelper.ConvertDrToDt(dr);
dt.Columns.Add("Admin_ID");
dt.Columns.Add("AdminName");
dt.Columns.Add("Role_ID");
DAL.PageControl.GridViewDataBind(GridView1, dt);
}
}
}
namespace BLL
{
public class SysAdmin
{
//定义管理员组数值
public static readonly int Superadmin = 0;
public static readonly int Normaladmin = 1;
public SqlDataReader GetAdmins()
{
SQLHelper sql = new SQLHelper();
SqlDataReader dr = null;
//执行存储过程
try
{
sql.RunProc("Proc_Admins", out dr);
}
catch (Exception e)
{
throw e;
}
finally { }
return dr;
}
}
}
namespace DAL
{
public class PageControl
{
private static string EmptyText = "没有相关数据!"; //数据为空时,Gridview显示提示
public PageControl()
{
}
/// <summary>
/// 空数据时刷新页面正常显示表头
/// </summary>
/// <param name="gridview"&g