roomtypedal.cs

酒店管理系统项目需求说明 第一部分 引言 1 1.1编写目的 1 1.2背景 1 第二部分 任务概述 2 3.1实现目标 2 3.1.1客房类型模块： 2 3.1.2客房信息

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using Entity;

namespace DAL
{
    public class RoomTypeDAL
    {
        /// <summary>
        /// 查询RoomType表
        /// </summary>
        /// <returns></returns>
        public static List<RoomTypeEntity> GetRoomType()
        {
            //创建RoomTypeEntity的泛型对象RTE
            List<RoomTypeEntity> RTE = new List<RoomTypeEntity>();

            //创建以个表格对象dt，用来保存SQLHelp.FillTable(sql语句)所返回的一张表
            DataTable dt = SQLHelp.FillTable("select * from RoomType");

            //如果返回的表格dt不为空并且有数据，则执行一下代码
            if (dt != null && dt.Rows.Count > 0)
            {
                //用foreach循环将dt里的数据取出来放到RoomTypeEntity对象里
                foreach (DataRow dr in dt.Rows)
                {
                    //创建RoomTypeEntity对象r
                    RoomTypeEntity r = new RoomTypeEntity();

                    //将表格的数据封装到r里
                    r.AddBedPrice = Convert.ToDouble(dr["AddBedPrice"]);
                    r.IsAddBed = dr["IsAddBed"].ToString();
                    r.Remark = dr["Remark"].ToString();
                    r.TypeID = (int)dr["TypeID"];
                    r.TypeName = dr["TypeName"].ToString();
                    r.TypePrice = Convert.ToDouble(dr["TypePrice"]);

                    //循环一次将r放入泛型对象RTE里
                    RTE.Add(r);
                }
            }
            //返回泛型对象RTE
            return RTE;
        }

        public static RoomTypeEntity GetRoomTypeByTypeID(int TypeID)
        {
            RoomTypeEntity RTE = new RoomTypeEntity();
            string sql = "select * from RoomType where TypeID = "+TypeID;
            DataTable dt = SQLHelp.FillTable(sql);
            RTE.AddBedPrice = Convert.ToDouble(dt.Rows[0]["AddBedPrice"]);
            RTE.IsAddBed = dt.Rows[0]["IsAddBed"].ToString();
            RTE.Remark = dt.Rows[0]["Remark"].ToString();
            RTE.TypeName = dt.Rows[0]["TypeName"].ToString();
            RTE.TypePrice = Convert.ToDouble(dt.Rows[0]["TypePrice"]);
            RTE.ImageURL = dt.Rows[0]["ImageURL"].ToString();
            return RTE;

        }

        public static int GetTypeIDByTypeName(string TypeName)
        {
            string sql = "select TypeID from RoomType where TypeName = '"+TypeName+"'";
            DataTable dt = SQLHelp.FillTable(sql);
            return Convert.ToInt32(dt.Rows[0][0]);
        }

        public static int GetCountTypeNameByTypeName(string TypeName)
        {
            string sql = "select count(*) from roomtype where TypeName = '" + TypeName + "'";
            return Convert.ToInt32(SQLHelp.FillTable(sql).Rows[0][0]);
        }


        public static DataTable GetRoomTypeByFilter(string TypeName)
        {
            string sql = "select * from roomtype where typename like '%"+TypeName+"%'";
            return SQLHelp.FillTable(sql);
        }
        public static DataTable GetRoomTypeByFilter()
        {
            string sql = "select * from roomtype";
            return SQLHelp.FillTable(sql);
        }

        public static DataTable GetImageURL()
        {
            string sql = "select * from roomtype";
            return SQLHelp.FillTable(sql);
        }

        public static DataTable GetImageURL(int TypeID)
        {
            string sql = "select * from roomtype where TypeID = "+TypeID;
            return SQLHelp.FillTable(sql);
        }

        

        /// <summary>
        /// 增加RoomType表
        /// </summary>
        /// <param name="RTE"></param>
        /// <returns></returns>
        public static int AddRoomType(RoomTypeEntity RTE)
        {
            //从传进来的RoomTypeEntiy对象拼凑sql语句
            string sql = "insert into RoomType values('"+RTE.TypeName+"',"+RTE.TypePrice+",'"+RTE.IsAddBed+"',"+RTE.AddBedPrice+",'"+RTE.Remark+"','"+RTE.ImageURL+"')";

            //调用SQLHelp类的ExecQuery() 方法执行拼凑的sql，及返回相应的数据
            return SQLHelp.ExecQuery(sql);
        }

        /// <summary>
        /// 修改RoomType表
        /// </summary>
        /// <param name="RTE"></param>
        /// <returns></returns>
        public static int UpdateRoomType(RoomTypeEntity RTE)
        {
            //从传进来的RoomTypeEntiy对象拼凑sql语句
            string sql = "update RoomType set TypeName = '"+RTE.TypeName+"',TypePrice = "+RTE.TypePrice+",IsAddBed = '"+RTE.IsAddBed+"',AddBedPrice = "+RTE.AddBedPrice+",Remark = '"+RTE.Remark+"' where TypeID = "+RTE.TypeID;

            //调用SQLHelp类的ExecQuery() 方法执行拼凑的sql，及返回相应的数据
            return SQLHelp.ExecQuery(sql);
        }

        public static int UpdateRoomTypeByTypeName(RoomTypeEntity RTE)
        {

            string sql = "update RoomType set TypePrice = "+RTE.TypePrice+",IsAddBed = '"+RTE.IsAddBed+"',AddBedPrice = "+RTE.AddBedPrice+",Remark = '"+RTE.Remark+"',ImageURL = '"+RTE.ImageURL+"' where TypeName = '"+RTE.TypeName+"'";
            return SQLHelp.ExecQuery(sql);
        }

        /// <summary>
        /// 删除RoomType表
        /// </summary>
        /// <param name="RTE"></param>
        /// <returns></returns>
        public static int DeleteRoomType(RoomTypeEntity RTE)
        {
            //从传进来的RoomTypeEntiy对象拼凑sql语句
            string sql = "delete RoomType where TypeID = "+RTE.TypeID;

            //调用SQLHelp类的ExecQuery() 方法执行拼凑的sql，及返回相应的数据
            return SQLHelp.ExecQuery(sql);
        }

        public static DataTable GetRoomTypeByRoom_TypeID(int TypeID)
        {
            string sql = "select count(*) from  Room where TypeId=(select typeid from roomtype where typeid = "+TypeID+")";
            return SQLHelp.FillTable(sql);
        }
    }
}