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

            strSql += " and OrderType<>3 ";
            strSql += " and OrderLog.OrderShopID = SysShop.ShopID and OrderLog.OrderMemID = Mem.MemID  and OrderLog.OrderUserID = SysUser.UserID";
            strSql  = PubFunction.GetShopAuthority(this._UserShopID, "OrderShopID", strSql);
            DataTable dtExpenseHistory = this.bllOrderLog.GetListSP(1000000, 1, out Counts, new string[]
            {
                strSql
            }).Tables[0];

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