protected void btnRptMemExcel_Click(object sender, EventArgs e) { Mem bllMem = new Mem(); int Counts = this.NetPagerParameter.RecordCount; string strSql = this.QueryCondition(); strSql += "and Mem.MemShopID = SysShop.ShopID and Mem.MemLevelID = MemLevel.LevelID and Mem.MemUserID = SysUser.UserID"; strSql = PubFunction.GetShopAuthority(this._UserShopID, "MemShopID", strSql); DataTable dtMem = bllMem.GetListSP(1000000, 1, out Counts, new string[] { strSql }).Tables[0]; DataExcelInfo.RptMemDrainReportExcel(dtMem, this._UserName); }