Beispiel #1
0
        protected void btnMemDrawMoneyExcel_Click(object sender, EventArgs e)
        {
            MemDrawMoney bllDrawMoney = new MemDrawMoney();
            int          Counts       = this.NetPagerParameter.RecordCount;
            string       strSql       = this.QueryCondition();

            strSql += "and MemDrawMoney.DrawMoneyShopID = SysShop.ShopID and MemDrawMoney.DrawMoneyMemID = Mem.MemID and Mem.MemLevelID=MemLevel.LevelID and MemDrawMoney.DrawMoneyUserID = SysUser.UserID";
            strSql  = PubFunction.GetShopAuthority(this._UserShopID, "DrawMoneyShopID", strSql);
            DataTable db = bllDrawMoney.GetListSP(1000000, 1, out Counts, new string[]
            {
                strSql
            }).Tables[0];

            DataExcelInfo.MemDrawMoney(db, this._UserName);
        }