protected void btnRptPointChangeExcel_Click(object sender, EventArgs e) { PointLog bllPointLog = new PointLog(); int Counts = this.NetPagerParameter.RecordCount; string strSql = this.QueryCondition(); strSql += "and PointLog.PointShopID = SysShop.ShopID and PointLog.PointMemID = Mem.MemID and Mem.MemLevelID=MemLevel.LevelID and PointLog.PointUserID = SysUser.UserID"; strSql = PubFunction.GetShopAuthority(this._UserShopID, "PointShopID", strSql); DataTable dtPointLog = bllPointLog.GetListSP(100000, 1, out Counts, new string[] { strSql }).Tables[0]; DataExcelInfo.PointChangeReportExcel(dtPointLog, this._UserName); }