Ejemplo n.º 1
0
        protected void btnPointRankExcel_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 MemPoint>0 ";
            strSql  = PubFunction.GetShopAuthority(this._UserShopID, "MemShopID", strSql);
            DataTable dtPoint = bllMem.GetPointRankList(100000, 1, out Counts, new string[]
            {
                strSql
            }).Tables[0];

            DataExcelInfo.PointRankReportExcel(dtPoint, this._UserName);
        }