Beispiel #1
0
        /// <summary>
        /// SQL Server生成代码
        /// </summary>
        /// <param name="className"></param>
        /// <param name="nameSpace"></param>
        /// <param name="filePath"></param>
        /// <param name="dt"></param>
        private void BuilderCode(string className, string nameSpace, string filePath, DataTable dt)
        {
            TableHelper helper = new TableHelper(false, false, false);
            NormalModel model  = new NormalModel();

            model.NameSpace = nameSpace;
            model.TableName = className;
            model.Title     = className;
            // model.SearchColumnsStr
            List <CodeModel.ColumnInfo> list = new List <CodeModel.ColumnInfo>();

            foreach (DataRow row in dt.Rows)
            {
                CodeModel.ColumnInfo column = new CodeModel.ColumnInfo();
                column.ColumnName = row["COLUMN_NAME"].ToString();
                column.DBType     = row["DATA_TYPE"].ToString();
                list.Add(column);
            }
            model.ColumnList = list;
            string content  = helper.GetClassString(model);
            string fileName = filePath + className + ".cs";

            using (FileStream fs = new FileStream(fileName, FileMode.OpenOrCreate))
            {
                byte[] buffer = Encoding.UTF8.GetBytes(content);
                fs.Write(buffer, 0, buffer.Length);
                //fs.Flush();
                //fs.Close();
            }
        }
Beispiel #2
0
        private void CreatCodeByPDM(string nameSpace, string filePath, TableInfo table)
        {
            string      tableName = table.Code;
            TableHelper helper    = new TableHelper(false, false, false);
            NormalModel model     = new NormalModel();

            model.NameSpace = nameSpace;
            model.TableName = tableName;
            model.Title     = table.Name;

            //model.ColumnList = table.Columns;
            // model.SearchColumnsStr
            List <CodeModel.ColumnInfo> list = new List <CodeModel.ColumnInfo>();

            foreach (var row in table.Columns)
            {
                CodeModel.ColumnInfo column = new CodeModel.ColumnInfo();
                column.ColumnName      = row.Code;
                column.DBType          = row.DataType;
                column.Comment         = row.Name;
                column.IsAutoIncrement = row.Identity;
                column.IsMainKey       = row.IsPrimaryKey;
                list.Add(column);
            }
            model.ColumnList = list;
            string content  = helper.GetClassString(model, true);
            string fileName = filePath + "\\" + tableName + ".cs";

            using (FileStream fs = new FileStream(fileName, FileMode.OpenOrCreate))
            {
                byte[] buffer = Encoding.UTF8.GetBytes(content);
                fs.Write(buffer, 0, buffer.Length);
            }
        }