roomtypeservice.cs

实现酒店管理开房、退房、以及房间类型选择

using System;
using System.Collections.Generic;
using System.Text;
using System.Configuration;
using System.Data.SqlClient;
using HotelManagerModels;

namespace HotelManagerDAL
{
    public class RoomTypeService
    {
        
        string url = ConfigurationManager.ConnectionStrings["sqlurl"].ToString();
        public List<RoomType> GetAllHotelRoom()
        {
            List<RoomType> list = new List<RoomType>();
           
            
            SqlConnection conn = new SqlConnection(url);
            string sql = "select * from roomtype";
            SqlCommand cmd = new SqlCommand(sql,conn);
            conn.Open();
            SqlDataReader data = cmd.ExecuteReader();
            while (data.Read()) 
            {
                RoomType type = new RoomType();
                type.TypeID = (int)data["typeid"];
                type.TypeName = data["typename"].ToString();
                type.TypePrice = Convert.ToDecimal(data["typeprice"]);
                type.IsAddBed = data["isaddbed"].ToString();
                type.AddBedPrice = Convert.ToDecimal(data["addbedprice"]);
                type.Remark = data["remark"].ToString();
                list.Add(type);
            }
            return list;
        }

        public int Update(RoomType type) 
        {
            SqlConnection conn = new SqlConnection(url);
            string sql = string.Format("update roomtype set typename='{0}',typeprice={1},addbedprice={2},isaddbed='{3}',remark='{4}' where typeId={5}",type.TypeName,type.TypePrice,type.AddBedPrice,type.IsAddBed,type.Remark,type.TypeID);
            SqlCommand cmd = new SqlCommand(sql, conn);
            conn.Open();
            int number = cmd.ExecuteNonQuery();
            conn.Close();
            return number;
        }

        public List<RoomType> SelectId(string name)
        {
            List<RoomType> list = new List<RoomType>();


            SqlConnection conn = new SqlConnection(url);
            string sql =string.Format( "select * from roomtype where typename='{0}'",name);
            SqlCommand cmd = new SqlCommand(sql, conn);
            conn.Open();
            SqlDataReader data = cmd.ExecuteReader();
           if (data.Read())
            {
                RoomType type = new RoomType();
                type.TypeID = (int)data["typeid"];
                type.TypeName = data["typename"].ToString();
                type.TypePrice = Convert.ToDecimal(data["typeprice"]);
                type.IsAddBed = data["isaddbed"].ToString();
                type.AddBedPrice = Convert.ToDecimal(data["addbedprice"]);
                type.Remark = data["remark"].ToString();
                list.Add(type);
            }
            return list;
        }
    }
}