//Criteria 类代码生成
private void btnCriteriaGenerate_Click(object sender, EventArgs e)
{
string resultMsg = string.Empty;
string strDataAccess = ConfigurationManager.AppSettings["DataAccess"];
CodeGenerators gen = new CodeGenerators();
try
{
if (cboSqlDataBase.Text == "Please select" || (string.IsNullOrWhiteSpace(cboSqlDataBase.Text) && strDataAccess.Equals(BaseDict.SqlServerData)))
{
MessageBox.Show("请选择数据库!", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (cboSqlDataTable.Text == "Please select" || string.IsNullOrWhiteSpace(cboSqlDataTable.Text))
{
MessageBox.Show("请选择数据表!", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
rtxtCont.Text = gen.CriteriaCodeGeneration(out resultMsg,dataBaseName:cboSqlDataBase.Text.Trim(),tableName: cboSqlDataTable.Text.Trim() ,dalNamespace: txtLogicNamespace.Text.Trim());
SetStyle();
}
catch (Exception ex)
{
MessageBox.Show("Error:" + ex.ToString());
}
}
public void ModelCodeGenerationTest()
{
string resultMsg = string.Empty;
var gen = new CodeGenerators();
//var code = gen.ModelCodeGeneration(out resultMsg, "Models", "SHIP_INFO", BaseDict.OracleData);
var criteria = new GeneratorCriteria();
criteria.ModelsNamespace = "Models";
criteria.ModelClassNamePrefix = "Model";
criteria.DalNamespace = "Logic";
criteria.DalClassNamePrefix = "Logic";
criteria.TableName = "TUSER";
criteria.DataBaseType = BaseDict.OracleData;
var code = gen.ModelCodeGeneration(out resultMsg, criteria.TableName, criteria.DataBaseType, criteria.DataBaseName, criteria.ModelsNamespace,
criteria.ModelClassNamePrefix);
var code1 = string.Empty;
Assert.AreNotEqual(code, code1);
}
/// <summary>
/// 数据库连接
/// </summary>
private void Connection()
{
CodeGenerators gen = new CodeGenerators();
string resultMsg = string.Empty;
string strDataAccess = ConfigurationManager.AppSettings["DataAccess"];
if (strDataAccess.Equals(BaseDict.OracleData))
{
var list = gen.QueryTablesAll(out resultMsg, strDataAccess);
if (string.IsNullOrWhiteSpace(resultMsg) || resultMsg.Contains(BaseDict.SuccessPrefix))
{
list.Insert(0, new ModelGeneration() { TableName = "Please select" });
cboSqlDataTable.DisplayMember = "TableName";
cboSqlDataTable.ValueMember = "TableName";
cboSqlDataTable.DataSource = list;
cboSqlDataTable.SelectedValue = "Please select";
MessageBox.Show("连接成功!", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show(resultMsg, "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else if (strDataAccess.Equals(BaseDict.SqlServerData))
{
var list = gen.QueryDataBaseAll(out resultMsg, strDataAccess);
cboSqlDataBase.DataSource = list;
}
}
//数据库下拉列表选择事件
private void cboSqlDataBase_SelectedIndexChanged(object sender, EventArgs e)
{
string resultMsg = string.Empty;
string strDataBaseType = ConfigurationManager.AppSettings["DataAccess"];
string strDataBaseName = cboSqlDataBase.Text;
if (strDataBaseType.Equals(BaseDict.SqlServerData) && (cboSqlDataBase.Text.Equals("Please select") || string.IsNullOrWhiteSpace(cboSqlDataBase.Text)))
{
return;
}
try
{
CodeGenerators gener = new CodeGenerators();
var list = gener.QueryTablesAll(out resultMsg, strDataBaseType, strDataBaseName);
list.Insert(0, new ModelGeneration() { TableName = "Please select" });
cboSqlDataTable.DisplayMember = "TableName";
cboSqlDataTable.ValueMember = "TableName";
cboSqlDataTable.DataSource = list;
cboSqlDataTable.SelectedValue = "Please select";
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
//存储过程生成按钮事件
private void btnSqlGenerate_Click(object sender, EventArgs e)
{
string resultMsg = string.Empty;
string strDataAccess = ConfigurationManager.AppSettings["DataAccess"];
CodeGenerators gen = new CodeGenerators();
if (cboSqlDataBase.Text == "Please select" || (string.IsNullOrWhiteSpace(cboSqlDataBase.Text) && strDataAccess.Equals(BaseDict.SqlServerData)))
{
MessageBox.Show("请选择数据库!", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (cboSqlDataTable.Text == "Please select" || string.IsNullOrWhiteSpace(cboSqlDataTable.Text))
{
MessageBox.Show("请选择数据表!", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
rtxtCont.Clear();
rtxtCont.Text = gen.TSqlCodeGeneration(out resultMsg, cboSqlDataTable.Text.Trim(), strDataAccess, cboSqlDataBase.Text.Trim(),
txtSqlParameterPrefix.Text.Trim(),txtProcedurePrefix.Text.Trim());
SetStyle();
}
/// <summary>
/// 数据库连接测试
/// </summary>
private void DBConnectionTest()
{
var strDataAccess = ConfigurationManager.AppSettings["DataAccess"];
var resultMsg = string.Empty;
CodeGenerators gen = new CodeGenerators();
var list = gen.QueryTablesAll(out resultMsg, strDataAccess);
if (string.IsNullOrWhiteSpace(resultMsg) || resultMsg.Contains(BaseDict.SuccessPrefix))
{
MessageBox.Show("连接成功!", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show(resultMsg, "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
