destineroomlistaccess.cs

来自「酒店管理系统,您酒店物业管理的好帮手」· CS 代码 · 共 34 行

using System;
using System.Collections.Generic;
using System.Text;
using Hotel.DAO;
using System.Data;

namespace Hotel.Operation
{
    public class DestineRoomListAccess
    {
        GetDatabase objGetDatabase = null;
        public DestineRoomListAccess()
        {
            objGetDatabase = new GetDatabase();
        }
        //插入
        public int AddDestineRoomList(int li,string room)
        {
            string sql = "insert DestineRoomList values("+li+",'"+room+"')";
            int k = objGetDatabase.ExecuteSql(sql);
            objGetDatabase.DataClose();
            return k;
        }
        //查询
        public DataSet GetInfo(int num)
        {
            string sql = "select * from DestineRoomList where listID='"+num+"'";
            DataSet ds = new DataSet();
            ds = objGetDatabase.GetDataSet(sql, "DestineRoomList");
            return ds;
        }
    }
}