DA/DBRooms.cs

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

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

using System;
using System.Collections.Generic;
using System.Text;
using System.Data ;
using System.Data.SqlClient;
using Common;
namespace DA
{
    public class DBRooms : IDisposable
    {
       string sql;
       SqlHelpers sqlh;
       SqlDataReader dr;
        DataSet ds;
       public DBRooms()
       {
           sqlh = new SqlHelpers();
       }
       public DBRooms(SqlHelpers sh)
       {
           sqlh = sh;
       }
       public void Dispose()
       {
           sqlh.Dispose();
       }

       /// <summary>
        /// DA  根据餐台类型  查询所有餐台的方法
       /// </summary>
       /// <param name="rtid">餐台类型编号</param>
       /// <param name="rtname">状态类型编号</param>
       /// <returns></returns>
        public List<CRooms> DBQueryRooms(int rtid, int rtstate)
       {
           List<CRooms> Lcr = new List<CRooms>();
           List<SqlParameter> pars = new List<SqlParameter>();
           pars.Add(new SqlParameter("@rtid", SqlDbType.Int));
           pars[0].Value = rtid; 
           
           //根据状态类型编号来判断使用哪个sql语句
           if (rtstate == 0)  
           {
               sql = "select * from Rooms where rtId=@rtId and rtState='空闲'";
           }
           if (rtstate == 1)
           {
               sql = "select * from Rooms where rtId=@rtId and rtState='占用'";
           }
           if (rtstate == 2)
           {
               sql = "select * from Rooms where rtId=@rtId and rtState='预定'";
           }
           if (rtstate == 3)
           {
               sql = "select * from Rooms where rtId=@rtId and rtState='脏台'";
           }
           if (rtstate == 4)
           {
               sql = "select * from Rooms where rtId=@rtId and rtState='停用'";