bll_roomtype.cs

饮食管理系统

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

namespace BusinessLayer
{
   public class BLL_RoomType
    {
       RoomType rt = new RoomType();
       SqlDataAccess sql = new SqlDataAccess();

       public DataTable SelectRoomTypeByRoomid(RoomType rt)
       {
           return sql.ExecuteDateSetBySelect("proc_SelectRoomTypeByRoomid", rt.RoomId);
       }
       public RoomType SelectRoomTypeByid(tableState ts)
       {
           DataTable dt=sql.ExecuteDateSetBySelect("proc_SelectRoomTypeByRoomid", ts.RoomID);
           rt.roomType = dt.Rows[0][1].ToString();
           rt.LowCousume = float.Parse(dt.Rows[0][2].ToString());
           rt.RoomReamrk = dt.Rows[0][3].ToString() ;
           return rt;
       }
       public DataTable SelectRoomTypeAll()
       {
           return sql.ExecuteDataSetBySelect("proc_SelectRoomTypeAll");
       }

       public int InsertRoomType(RoomType r)
       {
           return sql.ExecuteDataSetByUpdate("proc_InsertRoomType",r.roomType,r.LowCousume,r.RoomReamrk,r.RoomRs);
       }
       public int UpdateRoomTypeByID(RoomType r)
       {
           return sql.ExecuteDataSetByUpdate("proc_UpdateRoomTypeByID", r.RoomId, r.roomType, r.LowCousume, r.RoomReamrk, r.RoomRs);
       }
       public int DeleteRoomTypeById(RoomType r)
       {
           return sql.ExecuteDataSetByUpdate("proc_DeleteRoomTypeById", r.RoomId);
       }
    }

}