public ClassGenerator(DBConnectType ConnectType)
{
InitializeComponent();
da = new DataAccess(ConnectType);
pt = new ProcTable();
g = new Generator();
pt.SetConnectionString(LoadServer.cn);
if (TestAndLoad())
{
btnGenerate.Enabled = true;
}
}
/// <summary>
/// 获取数据操作类
/// 连接串：http://www.connectionstrings.com/
/// sybase AseConnection 连接串：Data Source='myASEserver';Port=5000;Database='myDBname';UID='username';PWD='password';"
/// sybase OleDb连接串： Provider=Sybase.ASEOLEDBProvider;Server Name=myASEserver,5000;Initial Catalog=myDBname;User Id=username;Password=password
/// sybase odbc连接串：Driver={SYBASE ASE ODBC Driver};Srvr=Aron1;Uid=username;Pwd=password" or "DSN=;Uid=;Pwd="
/// oracle OracleConnection连接串： Data Source=MyOracleDB;User Id=username;Password=passwd;Integrated Security=no;"
/// oracle Oledb 连接串："Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=Username;Password=asdasd;"
/// oracle odbc 连接串:"Driver={Microsoft ODBC for Oracle};Server=OracleServer.world;Uid=Username;Pwd=asdasd;"
/// mysql MySqlClient : "Host=server; UserName=myusername; Password=mypassword;Database=mydb;"
/// mysql OleDb: "Provider=MySQLProv;Data Source=mydb;User Id=UserName;Password=asdasd;"
/// 通用odbc连接 串： Dsn=cimas;Uid=sa;Pwd=123321
/// </summary>
/// <param name="strConnection"></param>
/// <param name="DBType">数据库类型（ODBC,OleDb,Sybase,Oracle,DB2,SqlServer,MySql）</param>
/// <returns></returns>
public static DBOperator GetDBOperator(string strConnection, DBConnectType DataType)
{
switch (DataType)
{
case DBConnectType.ODBC:
return(new OdbcDBOperator(strConnection));
case DBConnectType.SqlServer:
return(new SqlDBOperator(strConnection));
//case sybase:
//return new SybaseDBOperator(strConnection);
//case DBConnectType.Oracle:
// return new OracleDBOperator(strConnection);
//case DBConnectType.MySql:
// return new MySqlDBOperator(strConnection);
default: //默认是oledb模式
return(new OleDBOperator(strConnection));
}
}
public DataAccess(DBConnectType ConnectType)
{
dbConnectType_ = ConnectType;
//strConnection = ConfigurationManager.ConnectionStrings["ConnectionString"].ToString();
}
