예제 #1
0
        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);
        }