protected void BtnMemExcel_Click(object sender, EventArgs e) { Chain.BLL.Mem bllMember = new Chain.BLL.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 += " and Mem.MemShopID =SysShopMemLevel.ShopID and SysShopMemLevel.MemLevelID=MemLevel.LevelID "; DataTable db = bllMember.GetListSP(100000, 1, out Counts, new string[] { PubFunction.GetMemListShopAuthority(this._UserShopID, "MemShopID", strSql) }).Tables[0]; DataExcelInfo.MemReportExcel(db, this._UserName); }