protected void btnMemDrawMoneyExcel_Click(object sender, EventArgs e) { MemDrawMoney bllDrawMoney = new MemDrawMoney(); int Counts = this.NetPagerParameter.RecordCount; string strSql = this.QueryCondition(); strSql += "and MemDrawMoney.DrawMoneyShopID = SysShop.ShopID and MemDrawMoney.DrawMoneyMemID = Mem.MemID and Mem.MemLevelID=MemLevel.LevelID and MemDrawMoney.DrawMoneyUserID = SysUser.UserID"; strSql = PubFunction.GetShopAuthority(this._UserShopID, "DrawMoneyShopID", strSql); DataTable db = bllDrawMoney.GetListSP(1000000, 1, out Counts, new string[] { strSql }).Tables[0]; DataExcelInfo.MemDrawMoney(db, this._UserName); }