Exemplo n.º 1
0
        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);
        }