using System;
using System.Collections.Generic;
using System.Text;
using Hotel.DAO;
using System.Data;
using Hotel.Entity;

namespace Hotel.Operation
{
    public class AccountAccess
    {
        GetDatabase objGetDatabase = null;
        //Account accountEntity = null;

        public AccountAccess()
        {
            objGetDatabase = new GetDatabase();
        }
        //通過帳號查清單
        public DataSet GetAccount(int num)
        {
            string sql = "select 項目=(select ItemName from ItemsPrice where ItemID="
                +"Account.ItemID),單價=(select Price from ItemsPrice where ItemId=Account.ItemID),"
                +"數量=ANumber,總價=Consume,折扣=Rebate,實價=EndPrice from Account where RoomUseID=" + num;
            DataSet ds = new DataSet();
            ds = objGetDatabase.GetDataSet(sql, "Account");
            return ds;
        }
        //添加消費
        public int AddAccount(Account ac)
        {
            string sql = "insert Account values("+ac.RoomUseID+","+ac.ItemID+","
                +ac.ANumber+","+ac.Consume+","+ac.Rebate+","+ac.EndPrice+",'"+ac.Remark+"')";
            int k = objGetDatabase.ExecuteSql(sql);
            return k;
        }
    }
}