private void btnMainTable_Click(object sender, EventArgs e)
{
int cnt = selectedTables.Count(d => d.mainTableFlag);
if (cnt > 0)
{
ErrorMessage("主表只能有一张");
return;
}
DialogTables dialog = new DialogTables();
if (dialog.ShowDialog(this) == DialogResult.Yes)
{
SelectedTable t = selectedTables.FirstOrDefault(d => d.tableName == dialog.TableName);
if (t == null)
{
t = new SelectedTable();
t.mainTableFlag = true;
t.tableName = dialog.TableName;
selectedTables.Add(t);
}
}
dialog.Dispose();
dgTables.DataSource = null;
dgTables.DataSource = selectedTables;
dgTables.Refresh();
dgTables.ClearSelection();
}
private void btnFields_Click(object sender, EventArgs e)
{
if (dgTables.SelectedRows.Count == 0)
{
return;
}
SelectedTable t = dgTables.SelectedRows[0].DataBoundItem as SelectedTable;
DialogFields dialog = new DialogFields(t.tableName, false);
List <SelectedField> fields = new List <SelectedField>();
if (dialog.ShowDialog(this) == DialogResult.Yes)
{
foreach (var info in dialog.selectedFields)
{
int cnt = selectedFields.Count(d => d.tableName == t.tableName && d.fieldName == info.fieldName);
if (cnt > 0)
{
continue;
}
info.entityFieldName = info.fieldName;
cnt = selectedFields.Count(d => d.fieldName == info.fieldName);
while (cnt > 0)
{
DialogTextbox tdialog = new DialogTextbox("请输入字段别名");
if (tdialog.ShowDialog(this) == DialogResult.Yes)
{
info.entityFieldName = tdialog.content;
}
dialog.Dispose();
cnt = selectedFields.Count(d => d.entityFieldName == info.entityFieldName);
if (cnt > 0)
{
ErrorMessage("已有重复字段别名，请重新输入");
}
else
{
cnt = fields.Count(d => d.entityFieldName == info.entityFieldName);
if (cnt > 0)
{
ErrorMessage("已有重复字段别名，请重新输入");
}
}
}
fields.Add(info);
}
}
foreach (var field in fields)
{
selectedFields.Add(field);
}
dialog.Dispose();
dgSelectedField.DataSource = null;
dgSelectedField.DataSource = selectedFields;
dgSelectedField.Refresh();
dgSelectedField.ClearSelection();
}
private void btnDelTable_Click(object sender, EventArgs e)
{
if (dgTables.SelectedRows.Count == 0)
{
return;
}
SelectedTable t = dgTables.SelectedRows[0].DataBoundItem as SelectedTable;
if (MessageBox.Show(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "\r\n您确认要删除" + t.tableName + "的所有关联内容吗?"
, "提示"
, MessageBoxButtons.YesNoCancel
, MessageBoxIcon.Question
, MessageBoxDefaultButton.Button1) != DialogResult.Yes)
{
return;
}
List <SelectedField> selectedFields1 = new List <SelectedField>();
foreach (var info in selectedFields)
{
if (info.tableName == t.tableName)
{
continue;
}
selectedFields1.Add(info);
}
selectedFields = selectedFields1;
List <SelectedTable> selectedTables1 = new List <SelectedTable>();
foreach (var info in selectedTables)
{
if (info.tableName == t.tableName)
{
continue;
}
selectedTables1.Add(info);
}
selectedTables = selectedTables1;
dgSelectedField.DataSource = null;
dgSelectedField.DataSource = selectedFields;
dgSelectedField.Refresh();
dgSelectedField.ClearSelection();
dgTables.DataSource = null;
dgTables.DataSource = selectedTables;
dgTables.Refresh();
dgTables.ClearSelection();
}
private void btnJoinTables_Click(object sender, EventArgs e)
{
DialogTables dialog = new DialogTables();
if (dialog.ShowDialog(this) == DialogResult.Yes)
{
SelectedTable t = selectedTables.FirstOrDefault(d => d.tableName == dialog.TableName);
if (t == null)
{
t = new SelectedTable();
t.mainTableFlag = false;
t.tableName = dialog.TableName;
selectedTables.Add(t);
}
}
dialog.Dispose();
dgTables.DataSource = null;
dgTables.DataSource = selectedTables;
dgTables.Refresh();
dgTables.ClearSelection();
}
private void dgTables_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
foreach (DataGridViewRow row in dgTables.Rows)
{
SelectedTable t = row.DataBoundItem as SelectedTable;
if (t.mainTableFlag)
{
foreach (DataGridViewCell cell in row.Cells)
{
cell.Style.BackColor = Color.ForestGreen;
cell.Style.ForeColor = Color.White;
}
}
else
{
foreach (DataGridViewCell cell in row.Cells)
{
cell.Style.BackColor = Color.White;
cell.Style.ForeColor = Color.Black;
}
}
}
}
private void btnCreateDal_Click(object sender, EventArgs e)
{
string spaceName = cbNameSpace.Text.ToUpper();
string entityName = txtEntityName.Text.Trim();
if (string.IsNullOrEmpty(entityName))
{
DialogTextbox dialog = new DialogTextbox("请输入数据模型名称");
if (dialog.ShowDialog(this) == DialogResult.Yes)
{
entityName = dialog.content;
txtEntityName.Text = entityName;
}
dialog.Dispose();
}
if (string.IsNullOrEmpty(entityName))
{
return;
}
string joinStr = string.Empty;
DialogMultextbox mdialog = new DialogMultextbox("请输入表关系语句");
if (mdialog.ShowDialog(this) == DialogResult.Yes)
{
joinStr = mdialog.content;
}
mdialog.Dispose();
if (MessageBox.Show(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "\r\n您确认要创建" + entityName + "的DAL类文件吗?"
, "提示"
, MessageBoxButtons.YesNoCancel
, MessageBoxIcon.Question
, MessageBoxDefaultButton.Button1) != DialogResult.Yes)
{
return;
}
StringBuilder sb = new StringBuilder();
///using
sb.AppendLine("using DM." + spaceName + ";");
sb.AppendLine("using Infrustructure.Utilities;");
sb.AppendLine("using Microsoft.Practices.EnterpriseLibrary.Data;");
sb.AppendLine("using System;");
sb.AppendLine("using System.Collections.Generic;");
sb.AppendLine("using System.Data;");
sb.AppendLine("using System.Data.Common;");
sb.AppendLine("using System.Linq;");
sb.AppendLine("using System.Text;");
sb.AppendLine("");
///namespace
sb.AppendLine("namespace DAL." + spaceName + "");
sb.AppendLine("{");
sb.AppendLine(" public class " + entityName + "DAL");
sb.AppendLine(" {");
///GetListByPage
sb.AppendLine(" public List<" + entityName + "Info> GetListByPage(string textWhere, string textOrder, int pageIndex, int pageRow)");
sb.AppendLine(" {");
sb.AppendLine(" if (pageIndex <= 0) pageIndex = 1;");
sb.AppendLine(" if (pageRow <= 0) pageRow = 10;");
sb.AppendLine(" string whereText = string.Empty;");
sb.AppendLine(" if (!string.IsNullOrEmpty(textWhere))");
sb.AppendLine(" {");
sb.AppendLine(" if (textWhere.Trim().StartsWith(\"and\", StringComparison.OrdinalIgnoreCase))");
sb.AppendLine(" whereText += \" where 1 = 1 \" + textWhere;");
sb.AppendLine(" else");
sb.AppendLine(" whereText += \" where \" + textWhere;");
sb.AppendLine(" }");
sb.AppendLine(" else");
sb.AppendLine(" whereText += \" where 1 = 1 \";");
sb.AppendLine(" if (string.IsNullOrEmpty(textOrder))");
SelectedField keyField = selectedFields.FirstOrDefault(d => d.keyFieldFlag);
if (keyField == null)
{
return;
}
sb.AppendLine(" textOrder += \"dbo.[" + keyField.tableName + "].[" + keyField.entityFieldName + "] desc\";");
sb.AppendLine(" string sql = \"select top \" + pageRow + \" * from \"");
sb.AppendLine(" + \"(select row_number() over(order by \" + textOrder + \") as rownumber\"");
SelectedTable mainTable = selectedTables.FirstOrDefault(d => d.mainTableFlag);
if (mainTable == null)
{
return;
}
sb.AppendLine(" + \", \" + FieldSql + \" from dbo.[" + mainTable.tableName + "] with(nolock)\" + LeftJoinSql + \" \" + whereText + \") T \"");
sb.AppendLine(" + \"where rownumber > \" + (pageIndex - 1) * pageRow + \" \";");
sb.AppendLine(" Database db = DatabaseFactory.CreateDatabase();");
sb.AppendLine(" DbCommand cmd = db.GetSqlStringCommand(sql);");
sb.AppendLine(" List<" + entityName + "Info> list = new List<" + entityName + "Info>();");
sb.AppendLine(" using (IDataReader dr = db.ExecuteReader(cmd))");
sb.AppendLine(" {");
sb.AppendLine(" while (dr.Read())");
sb.AppendLine(" {");
sb.AppendLine(" " + entityName + "Info info = new " + entityName + "Info();");
foreach (var table in selectedTables)
{
sb.AppendLine(" Update" + GetEntityNameByTableName(table.tableName) + "Fields(info, dr);");
}
sb.AppendLine(" list.Add(info);");
sb.AppendLine(" }");
sb.AppendLine(" }");
sb.AppendLine(" return list;");
sb.AppendLine(" }");
///GetCounts
sb.AppendLine(" public int GetCounts(string textWhere)");
sb.AppendLine(" {");
sb.AppendLine(" if (string.IsNullOrEmpty(textWhere))");
sb.AppendLine(" textWhere = string.Empty;");
sb.AppendLine(" else");
sb.AppendLine(" {");
sb.AppendLine(" if (!textWhere.Trim().StartsWith(\"and\", StringComparison.OrdinalIgnoreCase))");
sb.AppendLine(" textWhere = \" and \" + textWhere;");
sb.AppendLine(" }");
sb.AppendLine(" string sql = \"select count(1) from dbo.[" + mainTable.tableName + "] with(nolock)\" + LeftJoinSql + \" where 1 = 1 {0}; \";");
sb.AppendLine(" Database db = DatabaseFactory.CreateDatabase();");
sb.AppendLine(" DbCommand cmd = db.GetSqlStringCommand(string.Format(sql, textWhere));");
sb.AppendLine(" return Convert.ToInt32(db.ExecuteScalar(cmd));");
sb.AppendLine(" }");
///GetInfo
string keyFieldType = "string";
string dbType = "String";
switch (keyField.dataType)
{
case "int": keyFieldType = "int"; dbType = "Int32"; break;
case "numeric": keyFieldType = "decimal"; dbType = "Decimal"; break;
}
sb.AppendLine(" public " + entityName + "Info GetInfo(" + keyFieldType + " " + keyField.fieldName + ")");
sb.AppendLine(" {");
sb.AppendLine(" string sql = \"select \" + FieldSql + \" from dbo.[" + mainTable.tableName + "] with(nolock)\" + LeftJoinSql + \" where dbo.[" + keyField.tableName + "].[" + keyField.entityFieldName + "] = @" + keyField.fieldName + "; \";");
sb.AppendLine(" Database db = DatabaseFactory.CreateDatabase();");
sb.AppendLine(" DbCommand cmd = db.GetSqlStringCommand(sql);");
sb.AppendLine(" db.AddInParameter(cmd, \"@" + keyField.entityFieldName + "\", DbType." + dbType + ", " + keyField.fieldName + ");");
sb.AppendLine(" using (IDataReader dr = db.ExecuteReader(cmd))");
sb.AppendLine(" {");
sb.AppendLine(" if (dr.Read())");
sb.AppendLine(" {");
sb.AppendLine(" " + entityName + "Info info = new " + entityName + "Info();");
foreach (var table in selectedTables)
{
sb.AppendLine(" Update" + GetEntityNameByTableName(table.tableName) + "Fields(info, dr);");
}
sb.AppendLine(" return info;");
sb.AppendLine(" }");
sb.AppendLine(" }");
sb.AppendLine(" return null;");
sb.AppendLine(" }");
///LeftJoinSql
sb.AppendLine(" private string LeftJoinSql = \"" + joinStr + "\";");
///FieldSql
sb.AppendLine(" private string FieldSql = string.Empty");
bool firstFlag = true;
foreach (var field in selectedFields)
{
sb.AppendLine(" + \"" + (firstFlag ? string.Empty : ",")
+ "dbo.[" + field.tableName + "].[" + field.fieldName + "]"
+ (field.fieldName == field.entityFieldName ? string.Empty : (" as " + field.entityFieldName)) + "\"");
firstFlag = false;
}
sb.AppendLine(" ;");
///UpdateFields
foreach (var table in selectedTables)
{
sb.AppendLine(" private void Update" + GetEntityNameByTableName(table.tableName) + "Fields(" + entityName + "Info info, IDataReader dr)");
sb.AppendLine(" {");
foreach (var field in selectedFields)
{
string getDataType = "GetString";
switch (field.dataType)
{
case "int": getDataType = "GetInt32"; break;
case "numeric": getDataType = "GetDecimal"; break;
}
if (field.keyFieldFlag)
{
sb.AppendLine(" info." + GetEntityNameByTableName(field.fieldName) + " = DBConvert." + getDataType + "(dr, dr.GetOrdinal(\"" + field.entityFieldName + "\"));");
}
else
{
sb.AppendLine(" info." + GetEntityNameByTableName(field.tableName) + "_" + field.fieldName + " = DBConvert." + getDataType + "(dr, dr.GetOrdinal(\"" + field.entityFieldName + "\"));");
}
}
sb.AppendLine(" }");
}
///
///
sb.AppendLine(" }");
sb.AppendLine("}");
SaveFileDialog savedialog = new SaveFileDialog();
savedialog.FileName = entityName + "DAL.cs";
if (savedialog.ShowDialog(this) == DialogResult.OK)
{
if (!File.Exists(savedialog.FileName))
{
File.Create(savedialog.FileName).Close();
}
using (StreamWriter sw = new StreamWriter(savedialog.FileName))
{
sw.WriteLine(sb.ToString());
sw.Close();
}
}
}
