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

		            
 1using System;
 2using System.Data;
 3using System.Data.OleDb;
 4
 5namespace DAL
 6...{
 7    /**//// <summary>
 8    /// 推荐电影
 9    /// </summary>
10      public class CommendFilm
11    ...{
12          public DBConn dbConn = new DBConn();
13
14          /**//// <summary>
15          /// 根据Id来更新电影信息
16          /// </summary>
17          /// <param name="id"></param>
18          public void UpdateCommendFilm(int id,string filmUrl)
19          ...{
20              string sql = "update commendFilm set filmUrl='"+filmUrl+"' where id="+id;
21              OleDbCommand cmd = new OleDbCommand(sql, dbConn.conn);
22              try
23              ...{
24                  dbConn.Open();
25                  cmd.ExecuteNonQuery();
26              }
27              catch (Exception ex)
28              ...{
29                  throw ex;
30              }
31              finally
32              ...{
33                  dbConn.Close();
34              }
35              //return isOK;
36          }
37
38          /**//// <summary>
39          /// 根据ID取得推荐电影信息
40          /// </summary>
41          /// <param name="id"></param>
42          /// <returns></returns>
43          public Model.commendFilm GetCommendFilmInfo(int id)
44          ...{
45              Model.commendFilm modelCF = new Model.commendFilm();
46              string sql = "select top 1 filmUrl from commendFilm where id="+id;
47              OleDbCommand cmd = new OleDbCommand(sql, dbConn.conn);
48              dbConn.Open();
49              OleDbDataReader dr = cmd.ExecuteReader();
50              if (dr.Read())
51              ...{
52                  modelCF.FilmUrl = dr[0].ToString();
53              }
54              else
55              ...{
56                  modelCF.FilmUrl = "没有找到Url";
57              }
58              dr.Close();
59              dbConn.Close();
60              return modelCF;
61          }
62
63    }
64}
65