private void RptBind(string strWhere, string orderby) { if (!int.TryParse(Request.Params["page"] as string, out this.page)) { this.page = 0; } Spread.BLL.Report bll = new Spread.BLL.Report(); this.rptList.DataSource = bll.GetList(strWhere); this.rptList.DataBind(); }
protected void rptList_ItemCommand(object source, RepeaterCommandEventArgs e) { if (e.CommandName.Trim()!="") { Spread.BLL.Report bll = new Spread.BLL.Report(); StringBuilder strWhere = new StringBuilder(); strWhere.Append(" UserID='" + this.hduserid.Value + "' "); if (e.CommandName.Trim() != "总计") { strWhere.Append("AND SumDate='" + e.CommandName.Trim() + "'"); } if (this.ddlChanel.SelectedValue != "0") strWhere.Append(" and Bak2='" + this.ddlChanel.SelectedItem.Text + "'"); if (this.gameinput.Value != "") strWhere.Append(" and GameName like '%" + this.gameinput.Value + "%' "); if (this.ddlMenu.SelectedValue != "0") strWhere.Append(" and Bak1='" + this.ddlMenu.SelectedValue + "' "); DataTable dt = bll.GetList(strWhere.ToString()).Tables[0]; ExportDetailToExcel2(dt, "详细报表"); } }