Пример #1
0
        protected void btnExpenseExcel_Click(object sender, EventArgs e)
        {
            int    Counts = this.NetPagerParameter.RecordCount;
            string strSql = this.QueryCondition();

            strSql += " and MicroWebsiteOrderLog.MicroOrderShopID = SysShop.ShopID and MicroWebsiteOrderLog.MicroOrderMemID = Mem.MemID and MicroOrderStatus !=2 ";
            strSql  = PubFunction.GetShopAuthority(this._UserShopID, "MicroOrderShopID", strSql);
            DataTable dtExpenseHistory = new MicroWebsiteOrderLog().GetListSP1(this.NetPagerParameter.PageSize, this.NetPagerParameter.CurrentPageIndex, out Counts, new string[]
            {
                strSql
            }).Tables[0];

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