private void DataPlay(int PageNo)
{
//得到当前页号
this.curpage.Text = PageNo.ToString();
HyoaClass.Hyoa_mail Hyoa_mail = new HyoaClass.Hyoa_mail();
DataTable dt;
dt = Hyoa_mail.Getmail_sjx(Session["hyuid"].ToString(), "收件", "收件箱");
DataTable tempTable = dt.Clone();
for (int i = (PageNo - 1) * System.Int32.Parse(PageSize.Text); i < PageNo * System.Int32.Parse(PageSize.Text); i++)
{
if (i > dt.Rows.Count - 1)
break;
DataRow dr = tempTable.NewRow();
for (int j = 0; j < dt.Columns.Count; j++)
{
dr[dt.Columns[j].ColumnName] = dt.Rows[i][j];
}
tempTable.Rows.Add(dr);
}
int TotalRecord = dt.Rows.Count;
this.sumts.Text = TotalRecord.ToString();
this.sumts2.Text = TotalRecord.ToString();
this.ShowTotalRecord.Text = TotalRecord.ToString();
//计算及显示总页数
int TotalPage;
if (TotalRecord < System.Int32.Parse(PageSize.Text))
{
TotalPage = 1;
}
else
{
if (TotalRecord % System.Int32.Parse(PageSize.Text) != 0)
{
TotalPage = TotalRecord / System.Int32.Parse(PageSize.Text) + 1;
}
else
{
TotalPage = TotalRecord / System.Int32.Parse(PageSize.Text);
}
}
this.ShowTotalPage.Text = TotalPage.ToString();
this.rptlist.DataSource = tempTable;
this.rptlist.DataBind();
dt.Clear();
}
private void DataPlay(int PageNo)
{
//加载外部收件账号
string lswbjszh = "--按账号查看--";
if (this.Request.QueryString["wbjszh"] != null)
{
lswbjszh = this.Request.QueryString["wbjszh"].ToString();
}
HyoaClass.Hyoa_mail_config Hyoa_mail_config = new HyoaClass.Hyoa_mail_config();
DataTable dtmailconfig = Hyoa_mail_config.Getmailconfigbyuserid(this.Session["hyuid"].ToString());
if (dtmailconfig.Rows.Count > 0)
{
this.ddlwbjszh.DataSource = dtmailconfig;
this.ddlwbjszh.DataTextField = "hy_mailid";
this.ddlwbjszh.DataValueField = "hy_mailid";
this.ddlwbjszh.DataBind();
this.ddlwbjszh.Items.Insert(0, new ListItem("本系统邮件", "本系统邮件"));
this.ddlwbjszh.Items.Insert(0, new ListItem("--按账号查看--", "--按账号查看--"));
this.ddlwbjszh.SelectedValue = lswbjszh;
}
//得到当前页号
this.curpage.Text = PageNo.ToString();
HyoaClass.Hyoa_mail Hyoa_mail = new HyoaClass.Hyoa_mail();
DataTable dt;
if (lswbjszh == "--按账号查看--")
lswbjszh = "";
if (lswbjszh == "本系统邮件")
lswbjszh = "本系统邮件";
dt = Hyoa_mail.Getmail_sjx(Session["hyuid"].ToString(), "收件", "收件箱", lswbjszh);
DataTable tempTable = dt.Clone();
DataColumn col = new DataColumn("wdyj", typeof(String)); //定义新的一列 add
tempTable.Columns.Add(col); //追加一列 add
for (int i = (PageNo - 1) * System.Int32.Parse(PageSize.Text); i < PageNo * System.Int32.Parse(PageSize.Text); i++)
{
if (i > dt.Rows.Count - 1)
break;
DataRow dr = tempTable.NewRow();
for (int j = 0; j < dt.Columns.Count; j++)
{
dr[dt.Columns[j].ColumnName] = dt.Rows[i][j];
}
//得到是否未读
string ls_wdyj = "<font color=red>未读</font>"; //add
if(dt.Rows[i]["hy_sccksj"].ToString()!="")
ls_wdyj = "已读";
dr["wdyj"] = ls_wdyj; //将新值赋给相应的列 add
tempTable.Rows.Add(dr);
}
int TotalRecord = dt.Rows.Count;
this.sumts.Text = TotalRecord.ToString();
this.sumts2.Text = TotalRecord.ToString();
this.ShowTotalRecord.Text = TotalRecord.ToString();
//计算及显示总页数
int TotalPage;
if (TotalRecord < System.Int32.Parse(PageSize.Text))
{
TotalPage = 1;
}
else
{
if (TotalRecord % System.Int32.Parse(PageSize.Text) != 0)
{
TotalPage = TotalRecord / System.Int32.Parse(PageSize.Text) + 1;
}
else
{
TotalPage = TotalRecord / System.Int32.Parse(PageSize.Text);
}
}
this.ShowTotalPage.Text = TotalPage.ToString();
this.rptlist.DataSource = tempTable;
this.rptlist.DataBind();
dt.Clear();
}
