简单三层代码生成器（C#）（传智播客整理）

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;namespace 代码生成器
{public partial class Form1 : Form{public Form1(){InitializeComponent();}//for(int i&＃61;0;i<4;i&＃43;&＃43;){//}string kongge1 &＃61; "\t";string kongge2 &＃61; "\t\t";string kongge3 &＃61; "\t\t\t";string kongge4 &＃61; "\t\t\t\t";StringBuilder SB &＃61; new StringBuilder();#region 把数据库类型转化为.net类型private static string ToNetType(string dataType){switch (dataType){case "int":return "int";break;case "nvarchar":case "varchar":case "char":case "nchar":return "string";case "bit":return "bool";case "datetime":return "DateTime";default:return "object";}} #endregion#region 数据库连接操作public DataTable ExecuteDataTable(string cmdText, params SqlParameter[] parameters)//不能写成static{using (SqlConnection conn &＃61; new SqlConnection(txtConnStr.Text)){//WhetherCon(txtConnSr.Text);//待优化 /************此处写等待用户输入的代码********************/conn.Open();using (SqlCommand cmd &＃61; conn.CreateCommand()){cmd.CommandText &＃61; cmdText;cmd.Parameters.AddRange(parameters);DataTable dt &＃61; new DataTable();SqlDataAdapter adapter &＃61; new SqlDataAdapter(cmd);adapter.Fill(dt);return dt;}}} #endregion#region "连接"按钮事件private void btnConnect_Click(object sender, EventArgs e){DataTable dt &＃61; ExecuteDataTable("select * from information_schema.tables");foreach (DataRow row in dt.Rows){string tablename &＃61; (string)row["TABLE_NAME"];clbFile.Items.Add(tablename);}}#endregion#region "生成"按钮事件&＃xff1b;生成文件选项private void btnGo_Click(object sender, EventArgs e){foreach (string tablename in clbFile.CheckedItems)//遍历&＃xff0c;获得用户所勾选的表的名字{if (checkBox1.Checked &＃61;&＃61; true)/*★★*/{CreateModel(tablename);//生成modelSB.AppendLine("模型层生成完成\r\n");}if (checkBox2.Checked &＃61;&＃61; true){CreateDAL(tablename);//生成DALSB.AppendLine("数据访问层生成完成\r\n");}if (checkBox3.Checked &＃61;&＃61; true){CreateBLL(tablename);//生成BLLSB.AppendLine("业务逻辑层生成完成\r\n");}txtShow.Text&＃61;SB.ToString();}}#endregion #region 生成Model///