DAL/RoomTypeDAO.cs

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

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

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using Model;

namespace DAL
{
    public class RoomTypeDAO
    {
        private DataSet ds;
        SQLHelper sqlhelper = new SQLHelper();

        //查询信息总记录
        public int getInfoCount()
        {
            int count = 0;
            try
            {
                count = sqlhelper.ReturnSQL("select count(*) from  roomtype");
            }
            catch (Exception)
            {
                
                throw;
            }
            return count;
        }

        //得到所有房间类型信息
        public DataSet getAllRoomTypeInfo(int start,int limit)
        {
            try
            {
                ds = sqlhelper.GetDataSet("select top "+limit+" * from roomtype where typeid not in(select top "+start+" typeid from roomtype order by typeid asc)");
            }
            catch (Exception)
            {
                
                throw;
            }
            return ds;
        }

        //删除房间信息
        public int DeleteRoomTypeInfo(int typeid)
        {
            int count = 0;
            try
            {
                count = sqlhelper.RunSQL("delete roomtype where typeid="+typeid);
            }
            catch (Exception)
            {
                
                throw;
            }
            return count;
        }