Exemplo n.º 1
0
        protected void btnExpenseExcel_Click(object sender, EventArgs e)
        {
            int    Counts = this.NetPagerParameter.RecordCount;
            string strSql = this.QueryCondition();

            strSql += " and Mem.MemShopID=SysShop.ShopID  and SysRotatePrizeLog.MemID = Mem.MemID and SysRotatePrizeLog.RotateID=SysRotate.RotateID and Mem.MemLevelID=MemLevel.LevelID and SysRotatePrizeLog.PrizeLevel<>'未中奖'";
            DataTable dtExpenseHistory = new Chain.BLL.SysRotatePrizeLog().GetListSP(100000, this.NetPagerParameter.CurrentPageIndex, out Counts, new string[]
            {
                strSql
            }).Tables[0];

            DataExcelInfo.SysRotatePrizeLogExcel(dtExpenseHistory, this._UserName);
        }