private void RptBind(string _strWhere, string _orderby)
{
this.page = AXRequest.GetQueryInt("page", 1);
if (this.status > 0)
{
this.ddlStatus.SelectedValue = this.status.ToString();
}
if (this.category_id > 0)
{
this.ddlCategoryId.SelectedValue = this.category_id.ToString();
}
txtKeywords.Text = this.keywords;
txtstart_time.Value = this.start_time;
txtstop_time.Value = this.stop_time;
ax_ticket bll = new ax_ticket();
this.rptList.DataSource = bll.GetList(this.pageSize, this.page, _strWhere, _orderby, out this.totalCount);
this.rptList.DataBind();
//绑定页码
txtPageNum.Text = this.pageSize.ToString();
string pageUrl = Utils.CombUrlTxt("ticket_list.aspx", "status={0}&category_id={1}&keywords={2}&start_time={3}&stop_time={4}&page={5}", this.status.ToString(), this.category_id.ToString(), this.keywords, this.txtstart_time.Value, this.txtstop_time.Value, "__id__");
PageContent.InnerHtml = Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8);
}
//导出报表
protected void btnExport_Click(object sender, EventArgs e)
{
//Response.Redirect(Utils.CombUrlTxt("ticket_rep.aspx", "status={0}&category_id={1}&keywords={2}", this.status.ToString(), this.category_id.ToString(), this.keywords));
ax_ticket mys = new ax_ticket();
string sqlstr = "id>0" + CombSqlTxt(this.status, this.category_id, this.keywords, this.start_time, this.stop_time) + "order by ticket_no asc";
DataSet tdSet = mys.GetList(sqlstr);
CreateExcel(tdSet);
}
