DA/DBRoomsType.cs

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

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

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using Common;
namespace DA
{
   public  class DBRoomsType:IDisposable 
    {
          string sql;
        SqlHelpers sqlh;
       SqlDataReader dr;
     
        public DBRoomsType()
        {
            sqlh = new SqlHelpers();
        }
       public DBRoomsType(SqlHelpers sh)
        {
            sqlh = sh;
        }
        public void Dispose()
        {
            sqlh.Dispose();
        }
       /// <summary>
        ///DB   查询所有餐台类型的业务
       /// </summary>
       /// <returns></returns>
       public List<CRoomType> DBRoomsTypeQuery()
       {
           List<CRoomType> lrt = new List<CRoomType>();
           sql = "select * from Roomtype";
           dr = sqlh.RQuery(sql, null, CommandType.Text);
           while (dr.Read())
           {
               CRoomType rt = new CRoomType();
               rt.CrtId1  = Convert.ToInt32(dr["rtId"]);
               rt.CrtName1  = dr["rtName"].ToString();
               rt.CrtLeastCost1 = Convert.ToDecimal(dr["rtLeastCost"]);
               rt.CrtMostNumber1  = Convert.ToInt32(dr["rtMostNumber"]);
               rt.CrtAmount1  = Convert.ToInt32(dr["rtAmount"]);
               lrt.Add(rt);
           }
           dr.Close();
           return lrt;
       }

       /// <summary>
       /// 根据餐台类型查询餐台的方法
       /// </summary>
       /// <param name="rtName"></param>
       /// <returns></returns>
       public int DBRoomsTypeQueryRooms(string rtName)
       {
           List<SqlParameter> pars = new List<SqlParameter>();
           pars.Add(new SqlParameter("@rtName", SqlDbType.VarChar, 20));
           pars[0].Value = rtName;
           sql = "select rtId from RoomType where rtName=@rtName";