private void checkCombo_DataFill(object sender, UtilityLibrary.Combos.TreeCombo.EventArgsTreeDataFill e)
{
string dbConn = this.txtDbConn.Text.ToString().Trim();
if (!String.IsNullOrEmpty(dbConn) && !this.ckCombo.FillCalled)
{
List <string> tabNames = new List <string>();
var dbType1 = this.dbMySql.Checked;
var dbType2 = this.dbSqlServer.Checked;
if (dbType1 && !dbType2)
{
tabNames = MySqlHelper.GetTables(dbConn);
}
if (!dbType1 && dbType2)
{
string dbName = SqlServiceHelper.GetDBName(dbConn);
tabNames = SqlServiceHelper.GetTables(dbConn, dbName);
}
if (tabNames.Count > 0)
{
e.BindedControl.Nodes.Clear();
foreach (var o in tabNames)
{
e.BindedControl.Nodes.Add(o);
}
}
}
}
public static String Genrate(String tabName, String dbConfig, String dbStr, DBType dbType)
{
string className = ConvertHelper.TableNameToClassName(tabName);
StringBuilder column = new StringBuilder();
StringBuilder param = new StringBuilder();
StringBuilder clmparam = new StringBuilder();
StringBuilder clazzclm = new StringBuilder();
String result = template.Replace("$dbconfig$", dbConfig).Replace("$classname$", className).Replace("$tabname$", tabName);
if (!string.IsNullOrEmpty(dbStr))
{
List <String> flist = new List <String>();
if (dbType == DBType.MySql)
{
flist = MySqlHelper.GetFields(dbStr, tabName);
}
if (dbType == DBType.SqlService)
{
flist = SqlServiceHelper.GetFields(dbStr, tabName);
}
if (flist.Count > 0)
{
foreach (var o in flist)
{
if (!o.ToLower().Equals("id"))
{
string paramStr = ConvertHelper.TableNameToClassName(o);
column.Append(o + ",");
param.Append("@" + paramStr + ",");
if (!o.ToLower().Contains("create"))
{
clmparam.Append(o + "=@" + paramStr + ",");
}
clazzclm.Append(o + " as " + paramStr + ",");
}
}
}
result = result.Replace("$column=param$", clmparam.ToString().Trim(',')).
Replace("$param$", param.ToString().Trim(',')).
Replace("$column$", column.ToString().Trim(',')).
Replace("$clazzclm$", clazzclm.ToString().Trim(','));
}
return(result);
}
public static String Genrate(String nameSpace, String tabName, String dbConn, DBType dbType)
{
string className = ConvertHelper.TableNameToClassName(tabName);
String result = template.Replace("$namespace$", nameSpace).Replace("$classname$", className);
//添加properties
StringBuilder sb = new StringBuilder();
List <FieldProperty> flist = new List <FieldProperty>();
if (dbType == DBType.MySql)
{
flist = MySqlHelper.GetProperties(dbConn, tabName);
}
if (dbType == DBType.SqlService)
{
flist = SqlServiceHelper.GetProperties(dbConn, tabName);
}
if (flist.Count > 0)
{
foreach (var o in flist)
{
if (!o.FildName.ToLower().Equals("id"))
{
o.FildName = ConvertHelper.TableNameToClassName(o.FildName);
if (dbType == DBType.MySql)
{
sb.Append(" public " + ConvertHelper.MySqlTypeToCShpaeType(o) + " " + o.FildName + " { get; set; } \r\n");
}
if (dbType == DBType.SqlService)
{
sb.Append(" public " + ConvertHelper.SqlServiceTypeToCShpaeType(o) + " " + o.FildName + " { get; set; } \r\n");
}
}
}
}
return(result.Replace("$properties$", sb.ToString()));
}
