HotelDAL/OpenRoomInfo.cs

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

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

using System;
using System.Collections.Generic;
using System.Text;
using HotelModels;
using System.Data;
using System.Data.SqlClient;
namespace HotelDAL
{
    public class OpenRoomInfo
    {
        //添加一条数据
        public void Add(HotelModels.OpenRoomInfo one)
        {
            string sqlstr = "insert into OpenRoomInfo(RoomId,GuestNumber,GuestName,GuestMoney,Remark,RequteTime) values (" + one.RoomId + ",'" + one.GuestNumber + "','" + one.GuestName + "'," + one.GuestMoney + ",'" + one.Remark + "','"+one.RequteTime+"')";
            DBHelper.ExecuteNonQuery(sqlstr, CommandType.Text, null);
        }

        //修改一条数据
        public void Update(HotelModels.OpenRoomInfo one)
        {
            string sqlstr = "update OpenRoomInfo set RoomId=" + one.RoomId + ",GuestNumber='" + one.GuestNumber + "',GuestName='" + one.GuestName + "',GuestMoney=" + one.GuestMoney + ",Remark='" + one.Remark + "',RequteTime='"+one.RequteTime+"'  where OpenRoomId='" + one.OpenRoomId + "'";
            DBHelper.ExecuteNonQuery(sqlstr, CommandType.Text, null);
        }
        //删除一条数据
        public void Delete(HotelModels.OpenRoomInfo one)
        {
            string sqlstr = "delete OpenRoomInfo  where OpenRoomId='" + one.OpenRoomId + "'";
            DBHelper.ExecuteNonQuery(sqlstr, CommandType.Text, null);
        }

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

        public HotelModels.OpenRoomInfo GetModelById(int Id)
        {
            string sqlstr = "select * from OpenRoomInfo where OpenRoomId=" + Id;
            DataTable dt = DBHelper.ExecuteGetDataTable(sqlstr, CommandType.Text, null);
            if (dt.Rows.Count > 0)
            {
                HotelModels.OpenRoomInfo one = new HotelModels.OpenRoomInfo();
                one.OpenRoomId = int.Parse(dt.Rows[0]["OpenRoomId"].ToString());
                one.RoomId = int.Parse(dt.Rows[0]["RoomId"].ToString());
                one.GuestNumber = dt.Rows[0]["GuestNumber"].ToString();
                one.GuestName = dt.Rows[0]["GuestName"].ToString();
                one.GuestMoney = Convert.ToDouble(dt.Rows[0]["GuestMoney"].ToString());
                one.OpenTime = Convert.ToDateTime(dt.Rows[0]["OpenTime"].ToString());
                one.RequteTime = dt.Rows[0]["RequteTime"].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("OpenRoomInfo", null, pageSize, pageIndex, fldSort, Sort, strCondition, "OpenRoomId", false, out pageCount, out Counts, out strSql);