protected void btnMemCountExcel_Click(object sender, EventArgs e) { int Counts = this.NetPagerParameter.RecordCount; string strSql = this.QueryCondition(); strSql += " and Mem.MemID = MemCount.CountMemID and MemCount.CountShopID = SysShop.ShopID and Mem.MemUserID = SysUser.UserID and Mem.MemLevelID=MemLevel.LevelID"; strSql = PubFunction.GetShopAuthority(this._UserShopID, "CountShopID", strSql); DataTable dtMemCount = this.bllMemCount.GetListSP(10000000, 1, out Counts, new string[] { strSql }).Tables[0]; DataExcelInfo.MemCount(dtMemCount, this._UserName); }