今天给大家讲解一下怎么遍历所有的数据表及相关信息
官网地址:https://www.w3soft.cn/codegenerator
视频教程如下
点我播放视频教程
操作代码
@using RazorEngine;
@using DbModels;
@inherits RazorEngine.Templating.TemplateBase<GenerateModel>
@using System.Text;
@{
//=========================配置开始=========================================
//1、是不是单一文件,假如使用数据库批量生成,就设置成为false,不使用数据库,应设置成true
Model.Config.IsSingleFile = true;
//2、输出文件名
Model.Config.OutFileName = "这里输入文件名称";
//3、输出文件后缀
Model.Config.OutFileSuffix = ".cs";
//4、可以配置其它的,具体看样例
Model.Config.Language = Languages.CSharp;
//=========================配置结束=========================================
}
@functions{
string GetTableInfo(TableInfomation table)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.AppendFormat("\r\n\r\n\r\n\r\n表开始:==========={0}=========\r\n\r\n\r\n\r\n", table.TableName);
stringBuilder.AppendFormat("表名:{0}\r\n", table.TableName);
stringBuilder.AppendFormat("表引擎:{0}\r\n", table.ENGINE);
stringBuilder.AppendFormat("备注:{0}\r\n", table.Remark);
stringBuilder.AppendFormat("表类型:{0}\r\n", table.TableTypes);
foreach (var field in table.LisFields)
{
stringBuilder.AppendFormat("\r\n\r\n\r\n字段开始:==========={0}=========\r\n", field.ColName);
stringBuilder.AppendFormat("字段名:{0}\r\n", field.ColName);
stringBuilder.AppendFormat("默认值:{0}\r\n", field.Default);
stringBuilder.AppendFormat("字段类型:{0}\r\n", field.FieldType);
stringBuilder.AppendFormat("是不是标识:{0}\r\n", field.IsIdentification);
stringBuilder.AppendFormat("是不是键:{0}\r\n", field.IsKey);
if (field.IsKey)
{
stringBuilder.AppendFormat("键的索引号:{0}\r\n", field.KeyIndex);
}
stringBuilder.AppendFormat("非空:{0}\r\n", field.IsNotNull);
stringBuilder.AppendFormat("数据长度:{0}\r\n", field.Length);
stringBuilder.AppendFormat("小数位数:{0}\r\n", field.Precision);
//C#专用上数据表信息A这里不演示
}
return stringBuilder.ToString();
}
}@*================所有的表信息===================*@
@*@foreach (var tableinfo in Model.LisAllTableInfos)
{
<c>@tableinfo.TableName</c>
}*@
@*================选择的表信息===================*@
@foreach (var tableinfo in Model.LisSelectTableInfos)
{
@GetTableInfo(tableinfo);
}
@*================当前的表信息===================
@Model.TableInfo.TableName*@