HotelDAL/Room.cs

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

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

using System;
using System.Collections.Generic;
using System.Text;
using HotelModels;
using System.Data;
using System.Data.SqlClient;
namespace HotelDAL
{
    public class Room
    {
        //添加一条数据
        public void Add(HotelModels.Room one)
        {
            string sqlstr = "insert into Room(Number,BedNumber,TypeId,StateId,Remark) values ('" + one.Number + "'," + one.BedNumber + "," + one.TypeId + "," + one.StateId + ",'" + one.Remark + "')";
            DBHelper.ExecuteNonQuery(sqlstr, CommandType.Text, null);
        }

        //修改一条数据
        public void Update(HotelModels.Room one)
        {
            string sqlstr = "update Room set Number='" + one.Number + "',BedNumber=" + one.BedNumber + ",TypeId=" + one.TypeId + ",StateId=" + one.StateId + ",Remark='" + one.Remark + "' where RoomId='" + one.RoomId + "'";
            DBHelper.ExecuteNonQuery(sqlstr, CommandType.Text, null);
        }
        //删除一条数据
        public void Delete(HotelModels.Room one)
        {
            string sqlstr = "delete Room  where RoomId='" + one.RoomId + "'";
            DBHelper.ExecuteNonQuery(sqlstr, CommandType.Text, null);
        }

        //通过Id获得一条数据(实体对象)

        public HotelModels.Room GetModelById(int Id)
        {
            string sqlstr = "select * from Room where RoomId=" + Id;
            DataTable dt = DBHelper.ExecuteGetDataTable(sqlstr, CommandType.Text, null);
            if (dt.Rows.Count > 0)
            {
                HotelModels.Room one = new HotelModels.Room();
                one.RoomId = int.Parse(dt.Rows[0]["RoomId"].ToString());
                one.Number = dt.Rows[0]["Number"].ToString();
                one.BedNumber = Convert.ToInt32(dt.Rows[0]["BedNumber"].ToString());
                one.TypeId = Convert.ToInt32(dt.Rows[0]["TypeId"].ToString());
                one.StateId = Convert.ToInt32(dt.Rows[0]["StateId"].ToString());
                one.Remark = dt.Rows[0]["Remark"].ToString();
                return one;
            }
            else
            {
                return null;
            }
        }

        //根据条件获取分页数据
        public DataTable GetList(int pageSize, int pageIndex, string fldSort, bool Sort, string strCondition, out int pageCount, out int Counts)
        {
            string strSql;
            DataTable dt = DBHelper.PageList("Room", null, pageSize, pageIndex, fldSort, Sort, strCondition, "RoomId", false, out pageCount, out Counts, out strSql);
            return dt;
        }