public JavaGenerater(MyHelper.DbSchema schema, Connection connection)
{
mDbSchema = schema;
mTableName = schema.TableName;
mConnection = connection;
ClassNmae = MyHelper.StringHelper.dbNameToClassName(MyHelper.StringHelper.DBNamingToCamelCase(mTableName));
}
public string dbEnumGenerater()
{
getDbSchema();
if (mDbSchemas.Count > 0)
{
StringBuilder sb = new StringBuilder();
sb.AppendLine("using System;");
sb.AppendLine("using System.Collections.Generic;");
sb.AppendLine("using System.Linq;");
sb.AppendLine("using System.Text;");
sb.AppendLine("using System.Threading.Tasks;");
sb.AppendLine();
sb.AppendLine(string.Format("namespace {0}", mConnection.nameSpace));
sb.AppendLine("{");
sb.AppendLine();
sb.AppendLine(getcomment("数据库中的所有表名称"));
sb.AppendLine(tab + " public enum DataTabeName{");
for (int i = 0; i < mDbSchemas.Count; i++)
{
MyHelper.DbSchema sc = mDbSchemas[i];
sb.AppendLine(tab + tab + sc.TableName + comma);
}
sb.AppendLine(tab + "}");
for (int i = 0; i < mDbSchemas.Count; i++)
{
MyHelper.DbSchema sc = mDbSchemas[i];
sb.AppendLine(tableEnumGeneraterNoNameSpace(sc.TableName));
}
sb.AppendLine("}");
return(sb.ToString());
}
return(null);
}
public string tableEnumGenerater(MyHelper.DbSchema schema)
{
StringBuilder sb = new StringBuilder();
sb.AppendLine();
if (!string.IsNullOrEmpty(schema.TableComment))
{
sb.AppendLine(getcomment(schema.TableComment));
}
string name = MyHelper.StringHelper.upperCaseFirstLetter(MyHelper.StringHelper.DBNamingToCamelCase(schema.TableName));
if (!string.IsNullOrEmpty(mConnection.enumSuffi))
{
name = name + MyHelper.StringHelper.upperCaseFirstLetter(mConnection.enumSuffi);
}
sb.AppendLine(tab + $"public enum {name}" + "{");
if (mConnection.type == DbType.mysql.ToString())
{
List <MyHelper.MysqlTabeSchema> myschemas = new MyHelper.MySqlHelper(mConnection.connStr).getTableSchema(schema.TableName);
for (int i = 0; i < myschemas.Count; i++)
{
sb.AppendLine(tab + tab + myschemas[i].Field + comma);
}
}
else
{
List <MyHelper.SqliteTableSchema> myschemas = new MyHelper.SQLiteHelper(mConnection.connStr).getTableSchema(schema.TableName);
for (int i = 0; i < myschemas.Count; i++)
{
sb.AppendLine(tab + tab + myschemas[i].name + comma);
}
}
sb.AppendLine(tab + "}");
return(sb.ToString());
}
public DataMoveDesW(Connection conn, MyHelper.DbSchema schema, string createSql = null)
{
InitializeComponent();
mConnection = conn;
CurrSchema = schema;
currCreateSql = createSql;
}
private void exceptIdentical()
{
for (int i = 0; i < mNowSchemas.Count; i++)
{
MyHelper.DbSchema schema = mNowSchemas[i];
bool isContains = false;
for (int j = 0; j < mHostoryDbSchemas.Count; j++)
{
MyHelper.DbSchema historySchema = mHostoryDbSchemas[j];
if (schema.TableName == historySchema.TableName)
{
isContains = true;
if (schema.updateTime == null)
{
needThreadGeneraters.Add(schema);
}
else if (historySchema.updateTime != schema.updateTime)
{
needThreadGeneraters.Add(schema);
}
}
}
if (isContains == false)
{
needThreadGeneraters.Add(schema);
}
}
}
private void TabButton_Click(object sender, RoutedEventArgs e)
{
RadioButton tabbtn = sender as RadioButton;
currDbschema = (MyHelper.DbSchema)tabbtn.Tag;
startCeneraterCode();
}
public DataMoveDialog(Connection fromConn, Connection toConn, MyHelper.DbSchema schema, string moveType, string createSql = null)
{
InitializeComponent();
mFromConnection = fromConn;
mToConnection = toConn;
CurrSchema = schema;
currCreateSql = createSql;
DataMoverType = moveType;
mDispatcherTimer = new DispatcherTimer();
mDispatcherTimer.Interval = TimeSpan.FromMilliseconds(5000);
mDispatcherTimer.Tick += MDispatcherTimer_Tick;
}
public RadioButton getRadioButton(MyHelper.DbSchema schema)
{
RadioButton tb = new RadioButton();
tb.Style = App.Current.Resources["menuRadioButtonStyle"] as Style;
tb.Height = 28;
Foreground = App.Current.Resources["69"] as Brush;
tb.Tag = schema;
tb.Content = schema.TableName;
if (!string.IsNullOrEmpty(schema.TableComment))
{
tb.ToolTip = schema.TableComment;
}
tb.Margin = new Thickness(0, 10, 0, 0);
tb.Click += TabButton_Click;
return(tb);
}
public string tableEnumGenerater(MyHelper.DbSchema schema)
{
StringBuilder sb = new StringBuilder();
sb.AppendLine("using System;");
sb.AppendLine("using System.Collections.Generic;");
sb.AppendLine("using System.Linq;");
sb.AppendLine("using System.Text;");
sb.AppendLine("using System.Threading.Tasks;");
sb.AppendLine();
sb.AppendLine(string.Format("namespace {0}", mConnection.nameSpace));
sb.AppendLine("{");
if (!string.IsNullOrEmpty(schema.TableComment))
{
sb.AppendLine(getcomment(schema.TableComment));
}
string name = MyHelper.StringHelper.upperCaseFirstLetter(MyHelper.StringHelper.DBNamingToCamelCase(schema.TableName));
if (!string.IsNullOrEmpty(mConnection.enumSuffi))
{
name = name + mConnection.enumSuffi;
}
sb.AppendLine(tab + $"public enum {name}" + "{");
if (mConnection.type == DbType.mysql.ToString())
{
mMysqlTabeSchemas = new MyHelper.MySqlHelper(mConnection.connStr).getTableSchema(schema.TableName);
for (int i = 0; i < mMysqlTabeSchemas.Count; i++)
{
sb.AppendLine(tab + tab + mMysqlTabeSchemas[i].Field + comma);
}
}
else
{
mSqliteTableSchemas = new MyHelper.SQLiteHelper(mConnection.connStr).getTableSchema(schema.TableName);
for (int i = 0; i < mSqliteTableSchemas.Count; i++)
{
sb.AppendLine(tab + tab + mSqliteTableSchemas[i].name + comma);
}
}
sb.AppendLine(tab + "}");
sb.AppendLine("}");
return(sb.ToString());
}
private void generaterCode(List <MyHelper.DbSchema> list)
{
if (list == null || list.Count <= 0)
{
return;
}
string fileName = string.Empty;
for (int i = 0; i < needThreadGeneraters.Count; i++)
{
//java class
MyHelper.DbSchema schema = needThreadGeneraters[i];
if (!string.IsNullOrEmpty(mConnection.javaClassPath))
{
if (MyHelper.FileHelper.FolderExistsCreater(mConnection.javaClassPath))
{
string javaClass = new JavaGenerater(schema, mConnection).CeneraterClass();
String suffix = string.Empty;
if (!String.IsNullOrEmpty(mConnection.classSuffix))
{
suffix = MyHelper.StringHelper.upperCaseFirstLetter(mConnection.classSuffix);
}
fileName = "\\" + MyHelper.StringHelper.upperCaseFirstLetter(MyHelper.StringHelper.DBNamingToCamelCase(schema.TableName)) + suffix + ".java";
MyHelper.FileHelper.Write(mConnection.javaClassPath + fileName, javaClass);
}
}
//java enum
if (!string.IsNullOrEmpty(mConnection.javaEnumPath))
{
if (MyHelper.FileHelper.FolderExistsCreater(mConnection.javaEnumPath))
{
string javaEnum = new JavaEnumGenerare(mConnection).tableEnumGenerater(schema);
String suffix = string.Empty;
if (!String.IsNullOrEmpty(mConnection.enumSuffi))
{
suffix = MyHelper.StringHelper.upperCaseFirstLetter(mConnection.enumSuffi);
}
fileName = "\\" + MyHelper.StringHelper.upperCaseFirstLetter(MyHelper.StringHelper.DBNamingToCamelCase(schema.TableName)) + suffix + ".java";
MyHelper.FileHelper.Write(mConnection.javaEnumPath + fileName, javaEnum);
}
}
//Csharp class
if (!string.IsNullOrEmpty(mConnection.cSharpClassPath))
{
if (MyHelper.FileHelper.FolderExistsCreater(mConnection.cSharpClassPath))
{
string csharpClass = new CSharpCenerater(schema, mConnection).CeneraterClass();
String suffix = string.Empty;
if (!String.IsNullOrEmpty(mConnection.classSuffix))
{
suffix = MyHelper.StringHelper.upperCaseFirstLetter(mConnection.classSuffix);
}
fileName = "\\" + MyHelper.StringHelper.upperCaseFirstLetter(MyHelper.StringHelper.DBNamingToCamelCase(schema.TableName)) + suffix + ".cs";
MyHelper.FileHelper.Write(mConnection.cSharpClassPath + fileName, csharpClass);
}
}
//Csharp enum
if (!string.IsNullOrEmpty(mConnection.cSharpEnumPath))
{
if (MyHelper.FileHelper.FolderExistsCreater(mConnection.cSharpEnumPath))
{
string csharpEnum = new CsharpEnumGenerare(mConnection).tableEnumGenerater(schema);
String suffix = string.Empty;
if (!String.IsNullOrEmpty(mConnection.enumSuffi))
{
suffix = MyHelper.StringHelper.upperCaseFirstLetter(mConnection.enumSuffi);
}
fileName = "\\" + MyHelper.StringHelper.upperCaseFirstLetter(MyHelper.StringHelper.DBNamingToCamelCase(schema.TableName)) + suffix + ".cs";
MyHelper.FileHelper.Write(mConnection.cSharpEnumPath + fileName, csharpEnum);
}
}
//Csharp all enum
if (!string.IsNullOrEmpty(mConnection.cSharpEnumAllPath))
{
if (MyHelper.FileHelper.FolderExistsCreater(mConnection.cSharpEnumAllPath))
{
string csharpEnum = new CsharpEnumGenerare(mConnection).dbEnumGenerater();
fileName = "\\" + MyHelper.StringHelper.upperCaseFirstLetter(MyHelper.StringHelper.DBNamingToCamelCase(mConnection.dbName)) + ".cs";
MyHelper.FileHelper.Write(mConnection.cSharpEnumAllPath + fileName, csharpEnum);
}
}
//crete sql
if (!string.IsNullOrEmpty(mConnection.sqlPath))
{
if (MyHelper.FileHelper.FolderExistsCreater(mConnection.sqlPath))
{
string createSQl = new CsharpEnumGenerare(mConnection).tableEnumGenerater(schema);
fileName = "\\" + schema.TableName + ".sql";
MyHelper.FileHelper.Write(mConnection.sqlPath + fileName, createSQl);
}
}
}
}
