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); } } } }