using System; using System.Data.Common; using System.Data.OleDb; using System.Data; namespace pub.mo { /// <summary> /// OleDb 数据库 /// </summary> public class OleDbProvider : IDbProvider { private string _get_conn; public OleDbProvider(string strConn) { _get_conn = strConn; } public string get_conn { get { return _get_conn; } set { _get_conn = value; } } /// <summary> /// 添加参数 /// </summary> /// <param name="ParamName">@字段别名</param> /// <param name="ParamText">内容</param> /// <returns>IDataParameter</returns> public IDataParameter addPar(string param_name, string param_text) { return new OleDbParameter(param_name, param_text); } /// <summary> /// 添加参数 /// </summary> /// <param name="param_name">@字段别名</param> /// <param name="db_type">字段类型</param> /// <param name="param_text">内容</param> /// <returns>IDataParameter</returns> public IDataParameter addPar(string param_name, DbType db_type, string param_text) { OleDbParameter param = new OleDbParameter(param_name, db_type); param.Value = param_text; return param; } /// <summary> /// 添加参数 /// </summary> /// <param name="param_name">@字段别名</param> /// <param name="db_type">字段类型</param> /// <param name="param_text">内容</param> /// <param name="para_size">大小</param> /// <returns>IDataParameter</returns> public IDataParameter addPar(string param_name, DbType db_type, string param_text, int para_size) { OleDbParameter param = new OleDbParameter(param_name, db_type); param.Value = param_text; param.Size = para_size; return param; } /// <summary> /// 创建OleDbConnection /// </summary> /// <param name="conn_prov">链接驱动字符串</param> /// <returns>IDbConnection</returns> public IDbConnection create_connection(string conn_prov) { return new OleDbConnection(conn_prov); } public DbDataAdapter new_DataAdapter() { return new OleDbDataAdapter(); } } }