using System.Collections.Generic;using System.Text;    public class Class1    {        //传递 1.表名 2.列名 3.类型        public void GenerateModel(string TableName, string ColumnName, string TypeName) //生成Model        {            #region  数据库ID所对应的类型值            Dictionary
     
       DicType = new Dictionary
      
       ();            DicType.Add(56, "int");            DicType.Add(231, "string");            #endregion            #region 列名集合和数据ID            Dictionary
       
         DicColum = new Dictionary
        
         ();            DicColum.Add("DictID", 56);            DicColum.Add("DictType", 231);            DicColum.Add("ParentID", 56);            DicColum.Add("Subtitle", 231);            DicColum.Add("Sorting", 56);            #endregion            TypeName = "Model";            TableName = "TableName";            TableName = TableName + TypeName;            StringBuilder sb = new StringBuilder();            sb.Append("using System;"); //引入命名空间            sb.Append("namespace "); //命名空间名字            sb.Append(TypeName + "{
    ");            sb.Append("    public partial class ");            sb.Append(TableName + "{
    ");            sb.Append("public " + TableName + "(){}");            sb.Append("#region Model" + "\r\n"); //Begin            #region //内容            foreach (var i in DicColum)            {                foreach (var j in DicType)                {                    if (i.Value == j.Key) // DicColum的56== DicType的56                    {                        sb.Append("private ");                        sb.Append(j.Value);                        sb.Append(" _");                        //sb.Append(i.Key); //DicColumd的DictID   //转换一下大小写在追加                        sb.Append(i.Key.ToLower());                        sb.Append(";\r\n");                    }                }            }            foreach (var i in DicColum)            {                foreach (var j in DicType)                {                    if (i.Value == j.Key) // DicColum的56== DicType的56                    {                        sb.Append("public ");                        sb.Append(j.Value);                        sb.Append(" ");                        sb.Append(i.Key);                        sb.Append("{\r\n"); //set{ _dicttype=value;}                        sb.AppendFormat("set{
    { _{0} =value;}}", i.Key.ToLower());                        sb.AppendFormat("get{
    {return _{0} ;}}", i.Key.ToLower());                        sb.Append("\r\n}");                                       }                }            }            #endregion            sb.Append("\r\n" + "#endregion"); //End            sb.Append("\r\n" + "}}");            //sb.AppendFormat("using System;namespace {0}{ public partial class Dictionary{1}{ public {1}(){}}}");            string ss = sb.ToString();        }        public void GenerateDAL(string TableName, string ColumnName, string TypeName)        {            TypeName = "DAL";            TableName = "ClassName";            TableName = TableName + TypeName;            StringBuilder sb = new StringBuilder();            sb.Append("using System;"); //引入命名空间            sb.Append("using System.Data;");            sb.Append("using System.Text;");            sb.Append("using System.Data.SqlClient;");            sb.Append("using System.Collections.Generic;");            sb.AppendFormat("namespace {0}\r\n{\r\n", TypeName);            sb.AppendFormat(" public partial class {0}\r\n{\r\n", TableName);            sb.AppendFormat("public {0}(){}", TableName); //构造函数            sb.AppendFormat("public int Add({0} model)\r\n{
    {\r\n", "Model模型名称");            sb.Append("StringBuilder strSql = new StringBuilder();");            //这种方法不好---------终止        }    }