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