protected void BtnMemExpenseExcel_Click(object sender, EventArgs e) { Mem member = new Mem(); int Counts = this.NetPagerParameter.RecordCount; string strSql = this.QueryCondition(); strSql += " and Mem.MemShopID=SysShop.ShopID "; StringBuilder strSb = new StringBuilder(); StringBuilder strDetail = new StringBuilder(); strSb.Append(" 1=1 "); strDetail.Append(" 1=1 "); if (this.txtStartTime.Value != "") { strSb.AppendFormat(" and OrderLog.OrderCreateTime>='{0}'", this.txtStartTime.Value); strDetail.AppendFormat(" and OrderCreateTime>='{0}'", this.txtStartTime.Value); } if (this.txtEndTime.Value != "") { strSb.AppendFormat(" and OrderLog.OrderCreateTime<='{0}'", PubFunction.TimeEndDay(this.txtEndTime.Value)); strDetail.AppendFormat(" and OrderCreateTime<='{0}'", PubFunction.TimeEndDay(this.txtEndTime.Value)); } DataTable dtMemExpense = this.bllMem.GetMemExpense(1000000, 1, out Counts, strSb.ToString(), new string[] { strSql }).Tables[0]; DataExcelInfo.MemExpenseReportExcel(dtMemExpense, this._UserName, strDetail.ToString()); }