/// <summary>
/// 初始化类型集合
/// </summary>
/// <returns></returns>
private static ComboBoxItemCollection InitPropertyType()
{
ComboBoxItemCollection lst = new ComboBoxItemCollection();
lst.Add(new ComboBoxItem("普通", EntityPropertyType.Normal));
lst.Add(new ComboBoxItem("主键", EntityPropertyType.PrimaryKey));
lst.Add(new ComboBoxItem("自增长主键", EntityPropertyType.PrimaryKey | EntityPropertyType.Identity));
lst.Add(new ComboBoxItem("版本号", EntityPropertyType.Version));
return(lst);
}
/// <summary>
/// 初始化架构层数
/// </summary>
/// <returns></returns>
private static ComboBoxItemCollection InitTiers()
{
ComboBoxItemCollection tiers = new ComboBoxItemCollection();
ComboBoxItem item = new ComboBoxItem("三层架构", 3);
tiers.Add(item);
item = new ComboBoxItem("单层架构", 1);
tiers.Add(item);
return(tiers);
}
/// <summary>
/// 初始化数据库类型
/// </summary>
/// <returns></returns>
private static ComboBoxItemCollection InitItems()
{
ComboBoxItemCollection types = new ComboBoxItemCollection();
ComboBoxItem item = new ComboBoxItem("SQL Server 2000", "Sql2K");
item.Tag = new ComboBoxItem("server=127.0.0.1;database=mydb;uid=sa;pwd=sa", null);
types.Add(item);
item = new ComboBoxItem("SQL Server 2005", "Sql2K5");
item.Tag = new ComboBoxItem("server=127.0.0.1;database=mydb;uid=sa;pwd=sa", null);
types.Add(item);
item = new ComboBoxItem("SQL Server 2008 或以上", "Sql2K8");
item.Tag = new ComboBoxItem("server=127.0.0.1;database=mydb;uid=sa;pwd=sa", null);
types.Add(item);
item = new ComboBoxItem("Oracle 9 或以上", "Oracle9");
item.Tag = new ComboBoxItem("server=Myserver;user id=username;password=pwd", null);
types.Add(item);
item = new ComboBoxItem("Oracle 11 ODAC", "Buffalo.Data.Oracle11");
item.Tag = new ComboBoxItem("user id=system;password=123456;data source=//127.0.0.1:1521/orcl", GetOracleSummary("11", "11w"));
types.Add(item);
item = new ComboBoxItem("Oracle 12 ODAC", "Buffalo.Data.Oracle12");
item.Tag = new ComboBoxItem("user id=system;password=123456;data source=//127.0.0.1:1521/orcl", GetOracleSummary("12", "12"));
types.Add(item);
item = new ComboBoxItem("MySQL 5.0 或以上", "Buffalo.Data.MySQL");
item.Tag = new ComboBoxItem("User ID=root;Password=pwd;Host=127.0.0.1;Port=3306;Database=mydb;", null);
types.Add(item);
item = new ComboBoxItem("SQLite", "Buffalo.Data.SQLite");
item.Tag = new ComboBoxItem("Data Source=D:\\db.s3db", null);
types.Add(item);
item = new ComboBoxItem("IBM DB2 v9或以上", "Buffalo.Data.DB2");
item.Tag = new ComboBoxItem("server=127.0.0.1:50000;DATABASE =mydb;UID=DB2Admin;PWD=pwd", null);
types.Add(item);
item = new ComboBoxItem("Postgresql9或以上", "Buffalo.Data.PostgreSQL");
item.Tag = new ComboBoxItem("Server=127.0.0.1;Port=5432;User Id=postgres;Password=pwd;Database=mydb", null);
types.Add(item);
item = new ComboBoxItem("Access", "Access");
item.Tag = new ComboBoxItem("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\\db.mdb; Jet OLEDB:Database Password=pwd", null);
types.Add(item);
return(types);
}
