userroomdal.cs

酒店管理系统项目需求说明 第一部分 引言 1 1.1编写目的 1 1.2背景 1 第二部分 任务概述 2 3.1实现目标 2 3.1.1客房类型模块： 2 3.1.2客房信息

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Entity;
using System.Data;

namespace DAL
{
    public class UserRoomDAL
    {
        public static DataTable GetUserRoom()
        {
            string sql = "select * from UserRoom";
            return SQLHelp.FillTable(sql);
        }

        public static DataTable GetUserRoomByHotelUser_UserNameRoom_Number(string UserName,string Number)
        {
            string sql = "EXEC SEL_UserRoom '"+UserName+"','"+Number+"'";
            return SQLHelp.FillTable(sql);
        }

        public static DataTable GetUserReceptionTable()
        {
            string sql = "select * from View_UserReception";
            return SQLHelp.FillTable(sql);
        }

        public static DataTable GetUserReceptionByUserName(string UserName)
        {
            string sql = "select * from View_UserReception where UserName = '"+UserName+"'";
            return SQLHelp.FillTable(sql);
        }

        public static DataTable GetUserReceptionByName(string Name)
        {
            string sql = "select * from View_UserReception where Name like '%" + Name + "%'";
            return SQLHelp.FillTable(sql);
        }

        public static DataTable GetUserReceptionStateByRoomID(int RoomID)
        {
            string sql = "select state,username,number from View_UserReception where RoomID = " + RoomID + "";
            return SQLHelp.FillTable(sql);
        }

        public static int AddUserRoom(UserRoomEntity URE)
        { 
            string sql = "insert into UserRoom values("+URE.UserID+","+URE.RoomID+",'"+URE.State+"')";
            return SQLHelp.ExecQuery(sql);
        }
        /**/
        public static int UpdateUserReceptionStateByRoomID(int RoomID)
        {
            string sql = "update Room set state = '入住' where RoomID = " + RoomID + "";
            SQLHelp.ExecQuery(sql);
            string strsql = "EXEC UPD_State "+RoomID;
            return SQLHelp.ExecQuery(strsql);
        }

        

        public static int DeleteUserRoomByUserID(int UserID,int RoomID)
        {
            string sql = "delete from UserRoom where UserID = " + UserID + "and RoomID = " + RoomID;
            return SQLHelp.ExecQuery(sql);
        }
    }
}