温馨提示:代码在线浏览功能只能做为源码浏览参考,不能展示项目的全部,如果想更进一步了解该代码请下载:燕赵宽频点播系统V1.0源码
当前文件路径:hevod/DAL/FromCountry.cs

1using System; 2
using System.Data; 3
using System.Data.OleDb; 4
using System.Text; 5
6
namespace 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





}