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