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

		            
 1using System;
 2using System.Data;
 3using System.Data.OleDb;
 4using System.Text;
 5
 6namespace DAL
 7...{
 8    /**//// <summary>
 9    /// 影片产地
10    /// </summary>
11  public  class FromCountry
12    ...{
13      public DBConn dbConn = new DBConn();
14      /**//// <summary>
15      /// 根据ID返回地区名称
16      /// </summary>
17      /// <param name="id"></param>
18      /// <returns></returns>
19      public Model.FromCountry GetFromCountry(int id)
20      ...{
21          Model.FromCountry modelFC = new Model.FromCountry();
22          string sql = "select caption from fromCountry where id="+id;
23          OleDbCommand cmd = new OleDbCommand(sql,dbConn.conn);
24          dbConn.Open();
25          OleDbDataReader dr = cmd.ExecuteReader();
26          if (dr.Read())
27          ...{
28              modelFC.Caption = dr["caption"].ToString();
29          }
30          else
31          ...{
32              modelFC.Caption = "未知";
33          }
34          dbConn.Close();
35          return modelFC;
36      }
37    }
38}
39