DA/DBDestines.cs

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

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

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using Common;

namespace DA
{
   public  class DBDestines:IDisposable
   {
       string sql;
       SqlDataReader dr;
       SqlHelpers sqlh;
       public DBDestines()
       {
           sqlh = new SqlHelpers();
       }
       public DBDestines(SqlHelpers sh)
       {
           sqlh = sh;
       }
       public void Dispose()
           {
               sqlh.Dispose();
       }
       /// <summary>
       ///DB  查询所有预定信息的方法
       /// </summary>
       /// <returns></returns>
       public List<CDestines> DBDestinesQuery()
       {
           List<CDestines> dd = new List<CDestines>();
           sql = "select * from Destines";
           dr = sqlh.RQuery(sql ,null ,CommandType.Text  );
           while (dr.Read())
           {
               CDestines d = new CDestines();
               d.CdId1 = Convert.ToInt32(dr["did"]);
               d.CdCName1 = dr["dCName"].ToString();
               d.CdCLinkphone1 = dr["dCLinkphone"].ToString();
               d.CrtName1  = dr["rtName"].ToString();
               d.CtName1 = dr["tName"].ToString();
               d.CdStartTime1 = Convert.ToDateTime(dr["dStartTime"]);
               d.CdRemark1 = dr["dRemark"].ToString();
               dd.Add(d);
               
           }
           dr.Close();
           return dd;
       }
       /// <summary>
       /// DB  插入预订信息的方法
       /// </summary>
       /// <param name="cd"></param>
       public void DBDestinesInsert(CDestines cd)
       {
           List<SqlParameter > pars = new List<SqlParameter >();
           pars.Add(new SqlParameter("@dCName", SqlDbType.VarChar, 20));
           pars[0].Value = cd.CdCName1;