sqlserverroomtypeservice.cs

酒店管理系统项目内容 包含当前常用的全部功能

using System;
using System.Collections.Generic;
using System.Text;
using MyHotelIDAL;
using MyHotelModel;
using System.Data.SqlClient;
using System.Data;

namespace MyHotelDAL
{
    public class SqlServerRoomTypeService:IRoomTypeService
    {
        SqlServerDBHelper helper;

        public SqlServerRoomTypeService()
        {
            helper = new SqlServerDBHelper();
        }

        #region IRoomTypeService 成员

        public bool InsertRoomType(RoomType type)
        {
            string sql = "insert into RoomType(TypeName,TypePrice,AddBedPrice,IsAddBed,Remark)" +
                "values(@TypeName,@TypePrice,@AddBedPrice,@IsAddBed,@Remark)";
            SqlParameter[] paras = new SqlParameter[]{
                    new SqlParameter("@TypeName",type.TypeName),
                    new SqlParameter("@TypePrice",type.TypePrice),
                    new SqlParameter("@AddBedPrice",type.AddBedPrice),
                    new SqlParameter("@IsAddBed",type.IsAddBed),
                    new SqlParameter("@Remark",type.Remark)
                };
            return helper.ModifyDB(sql, paras);
        }

        public bool UpdateRoomType(RoomType type)
        {
            string sql = "update RoomType set TypeName=@TypeName,TypePrice=@TypePrice,AddBedPrice=@AddBedPrice,IsAddBed=@IsAddBed,Remark=@Remark where TypeID=@TypeID ";
            
            SqlParameter[] paras = new SqlParameter[]{
                    new SqlParameter("@TypeName",type.TypeName),
                    new SqlParameter("@TypePrice",type.TypePrice),
                    new SqlParameter("@AddBedPrice",type.AddBedPrice),
                    new SqlParameter("@IsAddBed",type.IsAddBed),
                    new SqlParameter("@Remark",type.Remark),
                    new SqlParameter("@TypeID",type.TypeId)
                };
            return helper.ModifyDB(sql, paras);
        }

        public bool DeleteRoomType(int id)
        {
            string sql = "delete from RoomType where TypeID=@TypeID";

            SqlParameter para = new SqlParameter("@TypeID", id);

            return helper.ModifyDB(sql,para);
        }

        public IList<RoomType> SelectAllRoomTypes()
        {
            string sql = "select TypeID,TypeName,TypePrice,AddBedPrice,IsAddBed,Remark from RoomType";

            DataSet ds = helper.GetDataSet(sql);

            IList<RoomType> list = new List<RoomType>();

            foreach (DataRow row in ds.Tables[0].Rows)
            {
                RoomType type = new RoomType();
                type.TypeId = Convert.ToInt32(row["TypeID"]);
                type.TypeName = row["TypeName"].ToString();
                type.TypePrice = Convert.ToDecimal(row["TypePrice"]);
                type.AddBedPrice = Convert.ToDecimal(row["AddBedPrice"]);
                type.IsAddBed = row["IsAddBed"].ToString();
                type.Remark = row["Remark"].ToString();

                list.Add(type);
            }

            return list;
        }

        public RoomType SelectRoomTypeById(int id)
        {
            string sql = "select TypeID,TypeName,TypePrice,AddBedPrice,IsAddBed,Remark from RoomType where TypeID=@TypeID";
            
            DataSet ds = null;

            SqlParameter para = new SqlParameter("@TypeID", id);

            ds = helper.GetDataSet(sql,para);

            RoomType type = new RoomType();

            foreach (DataRow row in ds.Tables[0].Rows)
            {
                type.TypeId = Convert.ToInt32(row["TypeID"]);
                type.TypeName = row["TypeName"].ToString();
                type.TypePrice = Convert.ToDecimal(row["TypePrice"]);
                type.AddBedPrice = Convert.ToDecimal(row["AddBedPrice"]);
                type.IsAddBed = row["IsAddBed"].ToString();
                type.Remark = row["Remark"].ToString();
            }

            return type;
        }

        public IList<RoomType> SelectRoomTypeByName(string name)
        {
            string sql = "select TypeID,TypeName,TypePrice,AddBedPrice,IsAddBed,Remark from RoomType ";

            DataSet ds = null;

            if (name != "")
            {
                sql += "where TypeName = @TypeName";

                SqlParameter para = new SqlParameter("@TypeName", name);

                ds = helper.GetDataSet(sql, para);
            }
            else 
            {
                ds = helper.GetDataSet(sql);
            }
            
            IList<RoomType> list = new List<RoomType>();

            foreach (DataRow row in ds.Tables[0].Rows)
            {
                RoomType type = new RoomType();
                type.TypeId = Convert.ToInt32(row["TypeID"]);
                type.TypeName = row["TypeName"].ToString();
                type.TypePrice = Convert.ToDecimal(row["TypePrice"]);
                type.AddBedPrice = Convert.ToDecimal(row["AddBedPrice"]);
                type.IsAddBed = row["IsAddBed"].ToString();
                type.Remark = row["Remark"].ToString();

                list.Add(type);
            }

            return list;
        }

        #endregion
  
    }
}