private void CreateMode()
{
try
{
if (rbt_sqlserver.Checked)
{
List <DataBaseColumn> columns = this.dataGridView1.DataSource as List <DataBaseColumn>;
List <string> list = new List <string>();
list.Add("using System;");
list.Add($"public class {this.tvTables.SelectedNode.Text}");
list.Add("{");
foreach (var column in columns)
{
if (!string.IsNullOrWhiteSpace(column.Column_description))
{
list.Add("\t/// <summary>");
list.Add("\t/// " + column.Column_description);
list.Add("\t/// </summary>");
}
string c_type = FileOperate.SqlServerTypeToCType(column.DATA_TYPE);
list.Add("\tpublic " + c_type + " " +
column.COLUMN_NAME.Substring(0, 1).ToUpper() + column.COLUMN_NAME.Substring(1)
+ " { get; set; }");
}
list.Add("}");
string fileName = this.tvTables.SelectedNode.Text + ".cs";
FileOperate.FileWrite(list, this.txt_output.Text.Trim() + @"\" + fileName);
MessageBox.Show($"生成{fileName}成功!");
}
else if (rbt_mysql.Checked)
{
List <DataBaseColumnMysql> columns = this.dataGridView1.DataSource as List <DataBaseColumnMysql>;
List <string> list = new List <string>();
list.Add("using System;");
list.Add($"public class {this.tvTables.SelectedNode.Text}");
list.Add("{");
foreach (var column in columns)
{
if (!string.IsNullOrWhiteSpace(column.COLUMN_COMMENT))
{
list.Add("\t/// <summary>");
list.Add("\t/// " + column.COLUMN_COMMENT);
list.Add("\t/// </summary>");
}
string c_type = FileOperate.SqlServerTypeToCType(column.DATA_TYPE);
list.Add("\tpublic " + c_type + " " +
column.COLUMN_NAME.Substring(0, 1).ToUpper() + column.COLUMN_NAME.Substring(1)
+ " { get; set; }");
}
list.Add("}");
string fileName = this.tvTables.SelectedNode.Text + ".cs";
FileOperate.FileWrite(list, this.txt_output.Text.Trim() + @"\" + fileName);
MessageBox.Show($"生成{fileName}成功!");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
