RoomTypeInfoDAL/RoomTypeService.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;
using RoomTypeInfoDAL;
using RoomTypeModel;
using System.Data.Common;

namespace RoomTypeInfoDAL
{
    public class RoomTypeService
    {
        DBHelper DB = new DBHelper();


        //查询客房类型所有信息
        public List<RoomType> Select(string type)
        {
            List<RoomType> cen = new List<RoomType>();

            string sql = "select * from  RoomType ";

            if (type != "")
            {
                sql += " where TypeName like'%" + type + "%'";

            }
            try
            {
                DB.comm.CommandText = sql;
                DB.comm.Connection.Open();
                DbDataReader data =DB.comm.ExecuteReader();

                while (data.Read())
                {
                    RoomType room = new RoomType();
                    room.TypeName = (string)data["TypeName"];
                    room.TypePrice = Convert.ToDouble(data["TypePrice"]);
                    room.IsAddBed = (string)data["IsAddBed"];
                    room.AddBedPrice = Convert.ToDouble(data["AddBedPrice"]);
                    room.Remark = (string)data["Remark"];
                    room.TypeID = Convert.ToInt32(data["TypeID"]);
                    cen.Add(room);
                }
                data.Close();


            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
            }
            finally
            {
                DB.comm.Connection.Close();
            }

            return cen;

        }