destineaccess.cs

酒店管理系统,您酒店物业管理的好帮手

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

namespace Hotel.Operation
{
    public class DestineAccess
    {
        GetDatabase objGetDatabase = null;
        //Destine destineEntity = null;

        public DestineAccess()
        {
            objGetDatabase = new GetDatabase();
        }
        //预定客房
        public int AddDestine(Destine dt)
        {
            string sql = "insert Destine values('"+dt.DName+"','"+dt.CarNum+"','"+dt.Sex+"','"
                +dt.Phone+"','"+dt.BeginTime+"',"+dt.SaveTime+",'"+dt.ToTime+"','"+dt.Remark+"')";
            int k = objGetDatabase.ExecuteSql(sql);
            objGetDatabase.DataClose();
            return k;
            
        }
        //最后一个ID
        public int GetMaxID()
        {
            string sql = "select max(destineID) from destine";
            SqlDataReader dr= objGetDatabase.GetDataReader(sql);
            dr.Read();
            int k = 0;
            if (dr.HasRows)
            {
                k = int.Parse(dr.GetValue(0).ToString());
            }
            objGetDatabase.DrClose(dr);
            objGetDatabase.DataClose();
            return k;
        }
        //查询所有定房信息
        public DataSet GetDestineInfo()
        {
            string sql = "select * from destine";
            DataSet ds = new DataSet();
            ds = objGetDatabase.GetDataSet(sql, "destine");
            return ds;
        }
    }
}