using System; using System.Data.Common; using System.Data.SqlClient; using System.Data; namespace pub.mo { /// <summary> /// sqlserver 数据库 /// </summary> public class SqlServerProvider : IDbProvider { private string _get_conn; public SqlServerProvider(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></returns> public IDataParameter addPar(string param_name, string param_text) { return new SqlParameter(param_name, param_text); } public IDataParameter addPar(string param_name, DbType db_type, string param_text) { SqlParameter param = new SqlParameter(param_name, db_type); param.Value = param_text; return param; } public IDataParameter addPar(string param_name, DbType db_type, string param_text, int para_size) { SqlParameter param = new SqlParameter(param_name, db_type); param.Value = param_text; param.Size = para_size; return param; } /// <summary> /// 创建Connection /// </summary> /// <param name="conn_prov"></param> /// <returns></returns> public IDbConnection create_connection(string conn_prov) { return new SqlConnection(conn_prov); } public DbDataAdapter new_DataAdapter() { return new SqlDataAdapter(); } } }