public void Bind4()
{
string sql = "select top 5 * from [Plan] where username='******' order by planid desc";
this.DataList4.DataSource = OperateDB.ExecuteDataSet(sql);
this.DataList4.DataBind();
}
public void Bind3()
{
string sql = "select top 5 * from News order by NewsID desc";
DataList3.DataSource = OperateDB.ExecuteDataSet(sql);
DataList3.DataBind();
}
private void bind2()
{
string Name = SelectName();
string sql = "select top 5 title,sid,Pubdate from Email where Meetname='" + Name + "' order by sid desc ";
this.DataList2.DataSource = OperateDB.ExecuteDataSet(sql);
this.DataList2.DataBind();
}
private void bing1()
{
string UserName = Session["UserName"].ToString();
string sql = "select id from UserInfo where UserName='******'";
int id = Convert.ToInt32(OperateDB.getExecuteScalar(sql));
string sql1 = "select top 5 * from Calendar where id=" + id + " order by CalendarID desc";
DataSet ds = OperateDB.ExecuteDataSet(sql1);
this.DataList1.DataSource = ds.Tables[0];
this.DataList1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
string num = getemailnum(getname());
if (num != "0")
{
this.emailcount.InnerText = num;
this.title.InnerHtml = "You have " + num + " Mails";
string sql = "select * from Email where Meetname='" + getname() + "' and Status = '未读'";
this.dl.DataSource = OperateDB.ExecuteDataSet(sql);
dl.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!OA.Administrator.admin.isadmin(Session["UserName"].ToString()))
{
Response.Write("<script>alert('你没有权限');window.opener=null;window.close();</script>");
}
else
{
string num = getemailnum(getname());
if (num != "0")
{
this.emailcount.InnerText = num;
this.title.InnerHtml = "You have " + num + " Mails";
string sql = "select * from Email where Meetname='" + getname() + "' and Status = '未读'";
this.dl.DataSource = OperateDB.ExecuteDataSet(sql);
dl.DataBind();
}
}
}
public static PagedDataSource paged(string sql, AspNetPager AspNetPager1)
{
DataSet ds = OperateDB.ExecuteDataSet(sql);
DataTable dt = new DataTable();
dt = ds.Tables[0];
DataColumn dc = dt.Columns.Add("number", System.Type.GetType("System.String"));
for (int i = 0; i < dt.Rows.Count; i++)
{
dt.Rows[i]["number"] = (i + 1).ToString();
}
DataView dv = ds.Tables[0].DefaultView;
PagedDataSource pds = new PagedDataSource();
AspNetPager1.RecordCount = dv.Count;
pds.DataSource = dv;
pds.AllowPaging = true;
pds.CurrentPageIndex = AspNetPager1.CurrentPageIndex - 1;
pds.PageSize = AspNetPager1.PageSize;
return(pds);
}
