protected void btnExpenseExcel_Click(object sender, EventArgs e) { int Counts = this.NetPagerParameter.RecordCount; string strSql = this.QueryCondition(); strSql += " and OrderType<>3 "; strSql += " and OrderLog.OrderShopID = SysShop.ShopID and OrderLog.OrderMemID = Mem.MemID and OrderLog.OrderUserID = SysUser.UserID"; strSql = PubFunction.GetShopAuthority(this._UserShopID, "OrderShopID", strSql); DataTable dtExpenseHistory = this.bllOrderLog.GetListSP(1000000, 1, out Counts, new string[] { strSql }).Tables[0]; DataExcelInfo.ExpenseHistory(dtExpenseHistory, this._UserName); }