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