Exemple #1
0
        protected void btnRptPointExchangeExcel_Click(object sender, EventArgs e)
        {
            PointExchange bllGiftExchange = new PointExchange();
            int           Counts          = this.NetPagerParameter.RecordCount;
            string        strSql          = this.QueryCondition() + " and GiftExchange.ExchangeStatus=2 and GiftExchange.MemID=Mem.MemID and GiftExchange.ExchangeUserID = SysUser.UserID and Mem.MemShopID = SysShop.ShopID";

            strSql = PubFunction.GetShopAuthority(this._UserShopID, "MemShopID", strSql);
            DataTable dtGiftExchange = bllGiftExchange.GetListSP(100000, 1, out Counts, new string[]
            {
                strSql
            }).Tables[0];

            DataExcelInfo.RptGiftExchangeExcel(dtGiftExchange, this._UserName);
        }