HotelDAL/RoomType.cs

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

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

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

        //修改一条数据
        public void Update(HotelModels.RoomType one)
        {
            string sqlstr = "update RoomType set TypeName='" + one.TypeName + "',TypePrice=" + one.TypePrice + ",IsTv='" + one.IsTv + "',IsKongTiao='" + one.IsKongTiao + "',Remark='" + one.Remark + "' where TypeId='" + one.TypeId + "'";
            DBHelper.ExecuteNonQuery(sqlstr, CommandType.Text, null);
        }
        //删除一条数据
        public void Delete(HotelModels.RoomType one)
        {
            string sqlstr = "delete RoomType  where TypeId='" + one.TypeId + "'";
            DBHelper.ExecuteNonQuery(sqlstr, CommandType.Text, null);
        }

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

        public HotelModels.RoomType GetModelById(int Id)
        {
            string sqlstr = "select * from RoomType where TypeId=" + Id;
            DataTable dt = DBHelper.ExecuteGetDataTable(sqlstr, CommandType.Text, null);
            if (dt.Rows.Count > 0)
            {
                HotelModels.RoomType one = new HotelModels.RoomType();
                one.TypeId = int.Parse(dt.Rows[0]["TypeId"].ToString());
                one.TypeName = dt.Rows[0]["TypeName"].ToString();
                one.TypePrice = Convert.ToDouble(dt.Rows[0]["TypePrice"].ToString());
                one.IsTv = dt.Rows[0]["IsTv"].ToString();
                one.IsKongTiao = dt.Rows[0]["IsKongTiao"].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("RoomType", null, pageSize, pageIndex, fldSort, Sort, strCondition, "TypeId", false, out pageCount, out Counts, out strSql);
            return dt;
        }