当前文件路径：hevod/DAL/ServerPath.cs

		            
  1using System;
  2using System.Data;
  3using System.Data.OleDb;
  4namespace DAL
  5...{
  6    /**//// <summary>
  7    /// 服务器路径
  8    /// </summary>
  9    public class ServerPath
 10    ...{
 11        public DBConn dbConn = new DBConn();
 12
 13     /**//// <summary>
 14    /// 读取全部列表
 15    /// </summary>
 16        public DataSet GetServerPaths()
 17        ...{
 18            string sql = "select id,url from serverPath";
 19            OleDbCommand cmd = new OleDbCommand(sql, dbConn.conn);
 20            OleDbDataAdapter da = new OleDbDataAdapter(cmd);
 21            DataSet ds = null;
 22            try
 23            ...{
 24                dbConn.Open();
 25                ds = new DataSet();
 26                da.Fill(ds);
 27            }
 28            catch (OleDbException ex)
 29            ...{
 30                throw ex;
 31            }
 32            catch (Exception ex)
 33            ...{
 34                throw ex;
 35            }
 36            finally
 37            ...{
 38                dbConn.Close();
 39            }
 40            return ds;
 41        }
 42
 43        /**//// <summary>
 44        /// 根据ID取得影片服务器信息
 45        /// </summary>
 46        /// <returns></returns>
 47        public Model.ServerPath GetServerPath(int id)
 48        ...{
 49            Model.ServerPath modelSP = new Model.ServerPath();
 50            string sql = "select url from serverPath where id=" + id;
 51            OleDbCommand cmd = new OleDbCommand(sql, dbConn.conn);
 52            dbConn.Open();
 53            OleDbDataReader dr = cmd.ExecuteReader();
 54            if (dr.Read())
 55            ...{
 56                modelSP.Url = dr["Url"].ToString();
 57            }
 58            else
 59            ...{
 60                modelSP.Url = "未知";
 61            }
 62            dbConn.Close();
 63            return modelSP;
 64        }
 65
 66        /**//// <summary>
 67        /// 增加一条记录
 68        /// </summary>
 69        public bool AddServerPath(string strUrl)
 70        ...{
 71            bool isOK=false;
 72            string sql = "insert into serverPath (url) values ('"+strUrl+"')";
 73            OleDbCommand cmd = new OleDbCommand(sql, dbConn.conn);
 74            try
 75            ...{
 76                dbConn.Open();
 77                if (cmd.ExecuteNonQuery() > 0)
 78                    isOK = true;
 79            }
 80            catch (OleDbException ex)
 81            ...{
 82                throw ex;
 83            }
 84            catch (Exception ex)
 85            ...{
 86                throw ex;
 87            }
 88            finally
 89            ...{
 90                dbConn.Close();
 91            }
 92            return isOK;
 93        }
 94
 95        /**//// <summary>
 96        /// 按照id修改记录
 97        /// </summary>
 98        public bool ModifyServerPath(int id,string strUrl)
 99        ...{
100            bool isOK=false;
101            string sql = "update serverPath set url='"+strUrl+"' where id="+id;
102            OleDbCommand cmd = new OleDbCommand(sql, dbConn.conn);
103            try
104            ...{
105                dbConn.Open();
106                if (cmd.ExecuteNonQuery() > 0)
107                    isOK = true;
108            }
109            catch (OleDbException ex)
110            ...{
111                throw ex;
112            }
113            catch (Exception ex)
114            ...{
115                throw ex;
116            }
117            finally
118            ...{
119               dbConn.Close();
120            }
121            return isOK;
122        }
123
124        /**//// <summary>
125        /// 删除记录
126        /// </summary>
127        public bool DelServerPath(int id)
128        ...{
129            bool isOK = false;
130            string sql = "delete from serverPath where id="+id;
131            OleDbCommand cmd = new OleDbCommand(sql, dbConn.conn);
132            try
133            ...{
134                dbConn.Open();
135                if (cmd.ExecuteNonQuery() > 0)
136                    isOK = true;
137            }
138            catch (OleDbException ex)
139            ...{
140                throw ex;
141            }
142            catch (Exception ex)
143            ...{
144                throw ex;
145            }
146            finally
147            ...{
148                dbConn.Close();
149            }
150            return isOK;
151
152        }
153    }
154}
155