Exemplo n.º 1
0
 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();
 }
Exemplo n.º 2
0
 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, "详细报表");
     }
 }