using System;
|
using System.Collections.Generic;
|
using System.Text;
|
using System.Windows.Forms;
|
using System.IO;
|
using Newtonsoft.Json;
|
using System.Windows.Forms.VisualStyles;
|
using GenerateCode_WeiBen_WMS.DataBaseFactory;
|
using GenerateCode_WeiBen_WMS.Const;
|
using GenerateCode_WeiBen_WMS.Model;
|
|
namespace GenerateCode_GEBrilliantFactory
|
{
|
public partial class MainForm : Form
|
{
|
public static string projectNamePrefix = "";
|
public static string dataBaseName = "";
|
public static DataBaseEnum dataBaseEnum = DataBaseEnum.MySql;
|
public MainForm()
|
{
|
InitializeComponent();
|
|
this.tbPath.Text = "D:\\C#AutoCreateCodeFile";
|
|
this.tb_Primary.Text = "id";//主键名
|
this.tb_PrimaryDesc.Text = "主键";
|
this.tb_OrderBy.Text = "ModifyTime";//排序字段
|
|
this.tb_ProjectNamePrefix.Text = "Test";
|
this.tb_TableName.Text = "scms_wmsmaterials";//表名
|
this.tb_WCF_NameSpacePath.Text = "HIAWms";//WCF项目命名空间
|
this.tb_FileName.Text = "Xiangzi";//文件前缀名
|
this.tb_ChinaComment.Text = "物料基础信息表";//中文注释
|
this.tb_CreatePerson.Text = "shaocx";//创建人
|
this.tb_EntityName.Text = "WmsMaterials";//实体类名
|
this.tb_EntityProName.Text = "_wmsMaterials";//实体类对象名
|
|
this.cmb_DataSource.DropDownStyle = ComboBoxStyle.DropDownList;
|
List<ListItem> itemList = CommonHelper.GetDataSources();
|
foreach (var item in itemList)
|
{
|
this.cmb_DataSource.Items.Add(item);
|
}
|
this.cmb_DataSource.SelectedIndex = 0;
|
|
this.cmb_DataBase.DropDownStyle = ComboBoxStyle.DropDownList;
|
List<ListItem> itemList_Db = CommonHelper.GetDataBase();
|
foreach (var item in itemList_Db)
|
{
|
this.cmb_DataBase.Items.Add(item);
|
}
|
this.cmb_DataBase.SelectedIndex = 0;
|
}
|
|
/// <summary>
|
/// 保存路径对话框
|
/// </summary>
|
/// <param name="sender"></param>
|
/// <param name="e"></param>
|
private void button1_Click(object sender, EventArgs e)
|
{
|
FolderBrowserDialog fbd = new FolderBrowserDialog();
|
if (DialogResult.OK == fbd.ShowDialog())
|
{
|
tbPath.Text = fbd.SelectedPath;
|
}
|
}
|
|
private void btnExit_Click(object sender, EventArgs e)
|
{
|
Application.Exit();
|
}
|
|
//一键生成所有文件
|
private void btn_CreateFile_Click(object sender, EventArgs e)
|
{
|
try
|
{
|
projectNamePrefix = this.tb_ProjectNamePrefix.Text;
|
if (projectNamePrefix == "")
|
{
|
MessageBox.Show("请输入项目名前缀！");
|
this.tb_ProjectNamePrefix.Focus();
|
return;
|
}
|
|
if (dataBaseName == "")
|
{
|
MessageBox.Show("请选择数据库！");
|
return;
|
}
|
|
string primaryKey = this.tb_Primary.Text.Trim();//主键名
|
string primaryKeyDesc = this.tb_PrimaryDesc.Text.Trim();//主键描述
|
string tableName = this.tb_TableName.Text.Trim();//表名
|
string wcf_NameSpacePath = this.tb_WCF_NameSpacePath.Text.Trim();//WCF项目命名空间
|
string filePrefixName = this.tb_FileName.Text.Trim();//文件前缀名
|
string modulelogo = this.tb_Modulelogo.Text.Trim();//模块简写
|
string chinaComment = this.tb_ChinaComment.Text.Trim();//中文注释
|
string createPerson = this.tb_CreatePerson.Text.Trim();//创建人
|
string entityName = this.tb_EntityName.Text.Trim();//实体类名
|
string tableAlias = this.tb_EntityProName.Text.Trim();//实体类对象名/表别名
|
string orderByName = this.tb_OrderBy.Text.Trim();//排序字段名称
|
string routePrefix = this.tb_RoutePrefix.Text.Trim();//WCF路由前缀
|
string connStr = this.lbl_DataSource.Text.Trim();//数据库连接字符串
|
if (connStr == "")
|
{
|
MessageBox.Show("请选择数据库源！");
|
this.cmb_DataSource.Focus();
|
return;
|
}
|
if (tableName == "")
|
{
|
MessageBox.Show("请输入表名！");
|
this.tb_TableName.Focus();
|
return;
|
}
|
if (primaryKey == "")
|
{
|
MessageBox.Show("请输入主键名！");
|
this.tb_Primary.Focus();
|
return;
|
}
|
if (routePrefix == "")
|
{
|
MessageBox.Show("请输入WCF路由前缀！");
|
this.tb_RoutePrefix.Focus();
|
return;
|
}
|
if (wcf_NameSpacePath == "")
|
{
|
MessageBox.Show("请输入命名空间！");
|
this.tb_WCF_NameSpacePath.Focus();
|
return;
|
}
|
|
//读取Mysql
|
var handler = DataBaseServiceFactory.GetHandle(dataBaseEnum);
|
List<ColumnModel> columnList = handler.GetColumnList(tableName, connStr);
|
if (columnList.Count == 0)
|
{
|
MessageBox.Show("没有获取到表下面的列集合！");
|
return;
|
}
|
|
string groupName = this.tb_GroupName.Text.Trim();
|
//if (groupName == "")
|
//{
|
// MessageBox.Show("请输入分组名！");
|
// this.tb_GroupName.Focus();
|
// return;
|
//}
|
|
string addEntityParam = "Add" + modulelogo + "Param";//新增参数类名
|
string str_generate = "";
|
bool tf;
|
|
GenerateCodeParam param = new GenerateCodeParam()
|
{
|
Modulelogo = modulelogo,
|
ChinaComment = chinaComment,
|
NameSpacePath = wcf_NameSpacePath,
|
ColumnNameList = columnList,
|
EntityName = entityName
|
};
|
|
//生成Model
|
//CreateModelFile(columnList, tableName, filePrefixName, wcf_NameSpacePath, createPerson, chinaComment, entityName, modulelogo);
|
//CreateModelParamFile(columnList, tableName, filePrefixName, wcf_NameSpacePath, createPerson, chinaComment, entityName, modulelogo);
|
|
#region 实体类
|
var entityFilePath = tbPath.Text + @"\server\src\CMS.Plugin." + tb_WCF_NameSpacePath.Text.Trim() + @".Application.Contracts\Dtos\" + tb_EntityName.Text.Trim();
|
//1、生成 分页查询实体 文件
|
str_generate = InputModel_Generate.CreateQueryModelLText(param);
|
tf = TextHelper.Export2File_V2(entityFilePath, $"Get{param.EntityName}Input.cs", tableName, str_generate, FileType.InputModel, filePrefixName, entityName, modulelogo);
|
|
//2、生成 CreateDto 文件
|
str_generate = CreateDto_Generate.CreateText(param);
|
tf = TextHelper.Export2File_V2(entityFilePath, $"{param.EntityName}CreateDto.cs", tableName, str_generate, FileType.InputModel, filePrefixName, entityName, modulelogo);
|
|
//3、生成 CreateOrUpdateDtoBase 文件
|
str_generate = CreateOrUpdateDtoBase_Generate.CreateText(param);
|
tf = TextHelper.Export2File_V2(entityFilePath, $"{param.EntityName}CreateOrUpdateDtoBase.cs", tableName, str_generate, FileType.InputModel, filePrefixName, entityName, modulelogo);
|
|
#endregion
|
|
|
////生成 OutputModel 文件
|
//str_generate = OutputModel_Generate.CreateQueryModelLText(modulelogo, chinaComment, columnList, entityName);
|
//tf = TextHelper.Export2File(tbPath.Text, tableName, str_generate, FileType.OutputModel, filePrefixName, entityName, modulelogo);
|
|
////生成Controller文件
|
////str_generate = Controller_Generate.CreateText(modulelogo, chinaComment, columnList, entityName, orderByName);
|
////tf = TextHelper.Export2File(tbPath.Text, tableName, str_generate, FileType.Controller, filePrefixName, entityName, modulelogo);
|
|
////生成Services接口文件
|
//str_generate = Services_Interface_Generate.CreateText(wcf_NameSpacePath, modulelogo, entityName, chinaComment, addEntityParam);
|
//tf = TextHelper.Export2File(tbPath.Text, tableName, str_generate, FileType.WCF_InterFace, filePrefixName, entityName, modulelogo);
|
|
|
////生成Services接口实现文件
|
//str_generate = Services_InterfaceRealize_Generate.CreateText(wcf_NameSpacePath, modulelogo,
|
// entityName, chinaComment, filePrefixName, primaryKey, tableAlias, addEntityParam, columnList, groupName);
|
//tf = TextHelper.Export2File(tbPath.Text, tableName, str_generate, FileType.WCF_InterFaceRealize, filePrefixName, entityName, modulelogo);
|
|
/*
|
//生成存储过程文件
|
str_generate = Procedure_Generate.CreateProcText(tableName, tableAlias, createPerson, chinaComment,
|
primaryKey, filePrefixName, orderByName, modulelogo, columnList);
|
tf = TextHelper.Export2File(tbPath.Text, tableName, str_generate, FileType.Proc, filePrefixName, entityName, modulelogo);
|
|
//生成DAL文件
|
str_generate = DAL_Generate.CreateDALText(filePrefixName, tableName, entityName, createPerson,
|
chinaComment, primaryKey, primaryKeyDesc, modulelogo, tableAlias, columnList);
|
tf = TextHelper.Export2File(tbPath.Text, tableName, str_generate, FileType.DAL, filePrefixName, entityName, modulelogo);
|
|
//生成BLL文件
|
str_generate = BLL_Generate.CreateBLLText(filePrefixName, tableName, entityName, createPerson,
|
chinaComment, primaryKey, primaryKeyDesc, modulelogo, tableAlias, addEntityParam, columnList);
|
tf = TextHelper.Export2File(tbPath.Text, tableName, str_generate, FileType.BLL, filePrefixName, entityName, modulelogo);
|
|
|
|
//生成AddModel文件
|
str_generate = AddModel_Generate.CreateAddModelLText(addEntityParam, chinaComment, columnList);
|
tf = TextHelper.Export2File(tbPath.Text, tableName, str_generate, FileType.AddModelParam, filePrefixName, entityName, modulelogo);
|
|
|
|
|
//*/
|
|
//VUE方法配置
|
//str_generate = VUE_FunConfig_Generate.CreateText(modulelogo, chinaComment, routePrefix, entityName);
|
//tf = TextHelper.Export2File(tbPath.Text, tableName, str_generate, FileType.VUE_FunConfig, filePrefixName, entityName, modulelogo);
|
|
//VUE文件
|
//str_generate = VUE_Generate.CreateText(tableAlias, modulelogo, primaryKey, columnList, chinaComment
|
// , this.tb_templeteFileDownName.Text, this.tb_importExcelCategroy.Text);
|
//tf = TextHelper.Export2File(tbPath.Text, tableName, str_generate, FileType.VUEFile, filePrefixName, entityName, modulelogo);
|
|
//btn_InsertSql_Click(null, null);
|
}
|
catch (Exception ex)
|
{
|
MessageBox.Show("生成文件失败！" + ex.Message);
|
return;
|
}
|
//MessageBox.Show("生成文件成功！");
|
//成功之后打开文件夹
|
using (System.Diagnostics.Process.Start(this.tbPath.Text))
|
{
|
|
}
|
//*/
|
}
|
|
#region 分类文件
|
|
/// <summary>
|
/// 生成Model
|
/// </summary>
|
/// <param name="_tableName"></param>
|
private void CreateModelFile(List<ColumnModel> strList, string _tableName, string filePrefixName, string nameSpacePath,
|
string createPerson, string chinaComment, string entityName, string modulelogo)
|
{
|
bool tf = TextHelper.Export2File(tbPath.Text, _tableName,
|
Model_Generate.GenerateModel(_tableName, strList, filePrefixName, nameSpacePath, createPerson, chinaComment, entityName),
|
FileType.Model, filePrefixName, entityName, modulelogo);
|
}
|
|
/// <summary>
|
/// 生成Model参数
|
/// </summary>
|
/// <param name="_tableName"></param>
|
private void CreateModelParamFile(List<ColumnModel> strList, string _tableName, string filePrefixName, string nameSpacePath,
|
string createPerson, string chinaComment, string entityName, string modulelogo)
|
{
|
bool tf = TextHelper.Export2File(tbPath.Text, _tableName,
|
Model_Generate.GenerateModelParam(_tableName, strList, filePrefixName, nameSpacePath, createPerson, chinaComment, entityName),
|
FileType.Model, filePrefixName, entityName, modulelogo);
|
}
|
#endregion
|
|
/// <summary>
|
/// 文本改变事件
|
/// </summary>
|
/// <param name="sender"></param>
|
/// <param name="e"></param>
|
private void tb_TableName_TextChanged(object sender, EventArgs e)
|
{
|
string tableName = this.tb_TableName.Text.Trim();//表名
|
if (tableName != "")
|
{
|
var str = CommonHelper.TitleToUpper(tableName);
|
this.tb_FileName.Text = this.tb_EntityName.Text = str;
|
var index = tableName.IndexOf('_');
|
if (index > -1)
|
{
|
var moule_str = tableName.Substring(index + 1, tableName.Length - index - 1);
|
this.tb_Modulelogo.Text = moule_str;
|
this.tb_EntityProName.Text = CommonHelper.TitleToLower(moule_str);
|
}
|
else
|
{
|
this.tb_Modulelogo.Text = tableName;
|
this.tb_EntityProName.Text = CommonHelper.TitleToLower(tableName);
|
}
|
}
|
}
|
|
private void btn_InsertSql_Click(object sender, EventArgs e)
|
{
|
string connStr = this.lbl_DataSource.Text.Trim();//数据库连接字符串
|
if (connStr == "")
|
{
|
MessageBox.Show("请选择数据库源！");
|
this.cmb_DataSource.Focus();
|
return;
|
}
|
var tableName = this.tb_TableName.Text.Trim();
|
if (tableName == string.Empty)
|
{
|
MessageBox.Show("请输入表名!");
|
return;
|
}
|
List<ColumnModel> columnList = StructStrHelper.GetColumnList(tableName, connStr);
|
if (columnList.Count == 0)
|
{
|
MessageBox.Show("没有获取到表下面的列集合！");
|
return;
|
}
|
string chinaComment = this.tb_ChinaComment.Text.Trim();//中文注释
|
string createPerson = this.tb_CreatePerson.Text.Trim();//创建人
|
var str_generate = InsertSQL_Generate.CreateInsertSQLText(tableName, createPerson, chinaComment, columnList);
|
bool tf = TextHelper.Export2File(tbPath.Text, tableName, str_generate, FileType.SQL_Insert, "", "", "");
|
//MessageBox.Show("生成文件成功！");
|
//成功之后打开文件夹
|
using (System.Diagnostics.Process.Start(this.tbPath.Text + "\\" + this.tb_TableName.Text))
|
{
|
|
}
|
}
|
|
private void label13_Click(object sender, EventArgs e)
|
{
|
|
}
|
|
private void MainForm_Load(object sender, EventArgs e)
|
{
|
tb_EntityProName.Enabled = false;
|
tb_FileName.Enabled = false;
|
tb_Modulelogo.Enabled = false;
|
tb_WCF_NameSpacePath.Enabled = true;
|
tb_RoutePrefix.Enabled = false;
|
}
|
|
private void cmb_DataSource_SelectedIndexChanged(object sender, EventArgs e)
|
{
|
string connStr = (this.cmb_DataSource.SelectedItem as ListItem).Value;
|
var name = (this.cmb_DataSource.SelectedItem as ListItem).Text;
|
this.lbl_DataSource.Text = connStr;
|
dataBaseName = name;
|
if (name == "GSiemens_LES")
|
{
|
this.tb_ProjectNamePrefix.Text = "LES";
|
}
|
else if (name == "GSiemens_WIP")
|
{
|
this.tb_ProjectNamePrefix.Text = "WIP";
|
}
|
else if (name.Contains("AoSinWms"))
|
{
|
this.tb_ProjectNamePrefix.Text = "AoSinWms";
|
}
|
else
|
{
|
this.tb_ProjectNamePrefix.Text = "Test";
|
}
|
}
|
|
private void ck_IsShowImport_CheckedChanged(object sender, EventArgs e)
|
{
|
//this.tb_templeteFileDownName.Enabled = false;
|
//this.tb_importExcelCategroy.Enabled = false;
|
//if (this.ck_IsShowImport.Checked)
|
//{
|
// this.tb_templeteFileDownName.Enabled = true;
|
// this.tb_importExcelCategroy.Enabled = true;
|
//}
|
}
|
|
private void tb_EntityProName_TextChanged(object sender, EventArgs e)
|
{
|
|
}
|
|
private void cmb_DataBase_SelectedIndexChanged(object sender, EventArgs e)
|
{
|
string connStr = (this.cmb_DataBase.SelectedItem as ListItem).Value;
|
var name = (this.cmb_DataBase.SelectedItem as ListItem).Text;
|
|
dataBaseEnum = (DataBaseEnum)Enum.Parse(typeof(DataBaseEnum), name);
|
}
|
}
|
}
|
