基于FineUIMVC的代码生成器(传统三层)v1.0-2


第一篇博客只是粗略说明了一下,其实这个工具真正用话可能大家还要细看下,我今天(连夜)写个例子,截几个图,做一下自定义模板的实例教程,因为代码生成本身是个工具,动画效果都是次要的,主要是工具本身,其中自带的模板并不适合所有开发环境,所以还是侧重模板编写和接口。

前面说到我要写个MVC前台的模板按表生成 Index.cshtml 和 Controller.cs,所以就那这两个做个例子。说到模板就是一个制式的文件,我要先做错一个标准文件作为模板,然后根据不同表生成自己的文件, 其实大家都是程序员说这都是废话,博客比较长,说明的比较细,截图多,最下面有源码
环境准备,我先搭了一个FineUI的空项目 CodeFDemo
用生成工具生成了 asset_a2 表的后台三层
 
添加到项目,生成,该表是一个资产分类表
 

第一步 做一个模板的真实页面

准备工作做完,再做一个前台展示页面,以此为标准制作模板文件
Index.cshtml
 
@{
    ViewBag.Title = "Index";
    var F = Html.F();
}
@section head {

}
@section body {
    @(
         F.Panel()
         .IsViewPort(true)
         .ShowBorder(false)
         .ShowHeader(false)
         .Layout(LayoutType.Region)
         .Items(
             //中间Panel 查询和列表
             F.Panel()
             //.IsViewPort(true)
             .BoxFlex(4)
             .Layout(LayoutType.VBox)
             .BodyPadding(0)//5
             .BoxConfigChildMargin("0 0 0 0")//0 0 5 0
             .ShowBorder(false)
             .ShowHeader(false)
             .Items(
                 //查询表单
                 F.Form()
                 .ID("searchForm").Title("查询条件")
                 .BodyPadding(5).BoxConfigChildMargin("0 5 0 5").BoxFlex(1)
                 .Layout(LayoutType.VBox)
                 .BoxConfigAlign(BoxLayoutAlign.Stretch).BoxConfigPosition(BoxLayoutPosition.Center)
                 .EnableCollapse(true)
                 .LabelWidth(100)
                 .RowsEx(4,
                     F.TextBox()
                         .ID("txtstr20")
                         .Attribute("data", "SYS_ASSET_A1_160")
                         .Label("分类名称")
                         .EmptyText("分类名称"),
                     F.TextBox()
                         .ID("txtstr20")
                         .Attribute("data", "SYS_ASSET_A1_160")
                         .Label("分类编号")
                         .EmptyText("分类编号")
                 )
                 ,
                 //列表
                 F.Grid()
                 .Title("列表")
                 .ID("Grid1")
                 .BoxFlex(6)
                 .EnableCheckBoxSelect(true)
                 .DataIDField("ASSET_A2_AUTOID")
                 .AllowPaging(true)
                 .EnableHeaderMenu(false)
                 .PageSize(15)
                 .Toolbars(
                     F.Toolbar().Items(
                             F.DefaultGridBtn("Grid1")
                         )
                     )
                 .Columns(
                         F.RowNumberField(),
                         F.RenderField()
                             .HeaderText("ID")
                             .Hidden(true)
                             .DataField("ASSET_A2_AUTOID"),
                         F.RenderField()
                             .HeaderText("分类名称")
                             .ExpandUnusedSpace(true)
                             .DataField("ASSET_A2_10"),
                         F.RenderField()
                             .HeaderText("分类编号")
                             .ExpandUnusedSpace(true)
                             .DataField("ASSET_A2_20"),
                         F.RenderField()
                             .HeaderText("新增时间")
                             .ExpandUnusedSpace(true)
                             .DataField("ASSET_A2_MAKETIME")

                         )
                 .DataSource(ViewBag.griddata)
                 //.Listener("rowclick", "OnGrid1RowClick")
                 )
             )
    )
}
@section script {
<script>
        F.ready(function () {
        })

        //列表行点击事件
        function OnGrid1RowClick(e, rowid) {
            F.doPostBack('@Url.Action("Grid1_RowClick")', {
                rowid: rowid,
                fields: F.ui.Grid1.fields
            });
        }

        //列表新增
        function Grid1new_Click() {
            F.ui.Grid1.showEdit();//新增
        }
        //列表修改 得到列表选中项 getSelectedRows 注意DataIDField属性
        function Grid1edit_Click(g,rowid) {
            F.ui.Grid1.showEdit(true);//修改
        }
        //删除 删除此方法自动回发Grid1Del_Click 方法 参数为 id fields
        function Grid1delete_Click(g,ids) {

        }
        //刷新列表
        function lodeGrid() {
            F.doPostBack('@Url.Action("lodeGrid")', {
                fields: F.ui.Grid1.fields
            });
        }

</script>

}

asset_a2Controller.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using CodeFDemo.BP;

namespace CodeFDemo.Controllers.sysApp
{
    public class asset_a2Controller : Controller
    {
        // GET: sysA1
        public ActionResult Index()
        {
            BLLasset_a2 bll = new BLLasset_a2();
            ViewBag.griddata = bll.Getasset_a2MsByQuery(new Message.MsQuery()).ToArray();
            return View();
        }
    }
}

 OK,浏览下(本实例只做列表展示)

 

第二步 将标准文件改写为模板文件

再看下代码,其中Grid的Columns是列的循环,查询条件也是列的循环,数据库表格的列一循环就可以了
所以就有了两个模板
@{
    ViewBag.Title = "Index";
    var F = Html.F();
}
@section head {

}
@section body {
    @(
         F.Panel()
         .IsViewPort(true)
         .ShowBorder(false)
         .ShowHeader(false)
         .Layout(LayoutType.Region)
         .Items(
             //中间Panel 查询和列表
             F.Panel()
             //.IsViewPort(true)
             .BoxFlex(4)
             .Layout(LayoutType.VBox)
             .BodyPadding(0)//5
             .BoxConfigChildMargin("0 0 0 0")//0 0 5 0
             .ShowBorder(false)
             .ShowHeader(false)
             .Items(
                 //查询表单
                 F.Form()
                 .ID("searchForm").Title("查询条件")
                 .BodyPadding(5).BoxConfigChildMargin("0 5 0 5").BoxFlex(1)
                 .Layout(LayoutType.VBox)
                 .BoxConfigAlign(BoxLayoutAlign.Stretch).BoxConfigPosition(BoxLayoutPosition.Center)
                 .EnableCollapse(true)
                 .LabelWidth(100)
                 .RowsEx(4
                     $$TextBoxForSearch$$
                 )
                 ,
                 //列表
                 F.Grid()
                 .Title("列表")
                 .ID("Grid1")
                 .BoxFlex(6)
                 .EnableCheckBoxSelect(true)
                 .DataIDField("$$KEY$$")
                 .AllowPaging(true)
                 .EnableHeaderMenu(false)
                 .PageSize(15)
                 .Toolbars(
                     F.Toolbar().Items(
                             F.DefaultGridBtn("Grid1")
                         )
                     )
                 .Columns(
                         F.RowNumberField(),
                         F.RenderField()
                             .HeaderText("ID")
                             .Hidden(true)
                             .DataField("$$KEY$$")
                         $$GridColumns$$

                         )
                 .DataSource(ViewBag.griddata)
                 //.Listener("rowclick", "OnGrid1RowClick")
                 )
             )
    )
}
@section script {
<script>
        F.ready(function () {
        })

        //列表行点击事件
        function OnGrid1RowClick(e, rowid) {
            F.doPostBack('@Url.Action("Grid1_RowClick")', {
                rowid: rowid,
                fields: F.ui.Grid1.fields
            });
        }

        //列表新增
        function Grid1new_Click() {
            F.ui.Grid1.showEdit();//新增
        }
        //列表修改 得到列表选中项 getSelectedRows 注意DataIDField属性
        function Grid1edit_Click(g,rowid) {
            F.ui.Grid1.showEdit(true);//修改
        }
        //删除 删除此方法自动回发Grid1Del_Click 方法 参数为 id fields
        function Grid1delete_Click(g,ids) {

        }
        //刷新列表
        function lodeGrid() {
            F.doPostBack('@Url.Action("lodeGrid")', {
                fields: F.ui.Grid1.fields
            });
        }

</script>

}
                    ,F.TextBox()
                         .ID("txt$$ColunName$$")
                         .Attribute("data", "$$ColunName$$")
                         .Label("$$ColunNotes$$")
                         .EmptyText("$$ColunNotes$$")

 

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using $$namespace$$.BP;

namespace $$namespace$$.Controllers.sysApp
{
    public class $$tablename$$Controller : Controller
    {
        // GET: sysA1
        public ActionResult Index()
        {
            BLL$$tablename$$ bll = new BLL$$tablename$$();
            ViewBag.griddata = bll.Get$$tablename$$MsByQuery(new Message.MsQuery()).ToArray();
            return View();
        }
    }
}

 

其中$$namespace$$ $$tablename$$ $$KEY$$ $$ColunName$$ $$ColunNotes$$ 都是系统默认字典。
 
多了两个自定义字典$$TextBoxForSearch$$和$$GridColumns$$,其中$$TextBoxForSearch$$单独建了一个模板,为了让大家看看接口实现的另一种写法。
将保存好的模板放到模板目录里
 

第三步 编写模板翻译类

新建模板扩展类,引用CodeFactoryMVC.Main.dll,列实现接口ICodeFactory

注意第43行:

生成CodeFEx.dll,考到bin文件夹下,在web上新增接口

 OK完成,刷新页面选择其余表,填写项目名称,点击生成,拷贝到原项目,随便找个表预览下

 

 

 

一个list页面就做好了。CodeFDemo的项目源码会放在 知识星球 提供下载,

没有加入星球的赶紧加入(越来越贵!)

 

 

 
 
 
 
 
 
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
对象关系映射架构(DBFramework)及代码生成器源码 一、使用对象关系映射组件Kenly.DBFramework.dll不用编写任何SQL或者存储过程即可实现下列功能: 1、数据表、视图和存储过程与对象之间的转换。 2、数据表、视图的自定义条件查询。 3、数据表、视图的分页查询。 4、根据ID、主键或自定义条件对数据表进行增、删、改操作。 5、实现一对一、一对多、多对一和多对多的关系映射。 6、支持单个对象和多个对象之间的事务控制。 7、支持查询结果排序。 8、支持查询表达式生成。 9、支持延迟加载。 二、代码生成器 1、根据指定的数据库连接,自动生成数据表、视图和存储过程对应的对象代码(C#代码)。 2、自动生成相关的工程文件,生成完整的业务层项目文件。 3、可以帮助生成自定义查询方法。 4、支持SQLServer2000、SQLServer2005和Oracle代码生成插件,支持插件扩展。 提供 1、对象关系映射组件: Kenly.DBFramework.dll 2、代码生成器源码:CodeHelper。 3、代码生成器插件源码(支持SQLServer2000、SQLServer2005和Oracle):Plugin。 4、使用手册:DBFramework.Manual V4.5.3.pdf。 主要API: public abstract class ViewGateway where T: new() { // Methods static ViewGateway(); protected ViewGateway(); protected static int Count(); protected static int Count(string condition); protected static List CountGroup(string groupBy); protected static List CountGroup(string condition, string groupBy); public static List CreateInstances(int count); protected static List Distinct(string columnName); protected static List Distinct(string columnName, string condition); protected static List Distinct(string columnName, string condition, bool ignoreNull); protected static bool Exists(string condition); public bool ExistsById(); public bool ExistsByPK(); protected static List Find(PagingArg pagingArg, params string[] propertyNames); protected static List Find(string condition, params string[] propertyNames); protected static List Find(PagingArg pagingArg, bool sqlServer2000, params string[] propertyNames); protected static List Find(string condition, PagingArg pagingArg, params string[] propertyNames); protected static List Find(string condition, PagingArg pagingArg, bool sqlServer2000, params string[] propertyNames); protected static List FindAll(params string[] propertyNames); protected static void FindTop(T firstOne); protected static List FindTop(int topCount, params string[] propertyNames); protected static void FindTop(string condition, T firstOne); protected static List FindTop(string condition, int topCount, params string[] propertyNames); protected static void InitializeGateway(GatewayConfig config); protected static void InitializeGateway(DatabaseType dbType, string connectionString); protected void InitializeInstance(T entity); protected static object Max(string columnName); protected static object Max(string columnName, string condition); protected static List MaxGroup(string columnName, string groupBy); protected static List MaxGroup(string columnName, string condition, string groupBy); protected static object Min(string columnName); protected static object Min(string columnName, string condition); protected static List MinGroup(string columnName, string groupBy); protected static List MinGroup(string columnName, string condition, string groupBy); protected static DataTable Query(PagingArg pagingArg, params string[] propertyNames); protected static DataTable Query(string condition, params string[] propertyNames); protected static DataTable Query(PagingArg pagingArg, bool sqlServer2000, params string[] propertyNames); protected static DataTable Query(string condition, PagingArg pagingArg, params string[] propertyNames); protected static DataTable Query(string condition, PagingArg pagingArg, bool sqlServer2000, params string[] propertyNames); protected static DataTable QueryAll(params string[] propertyNames); protected static DataTable QueryTop(int topCount, params string[] propertyNames); protected static DataTable QueryTop(string condition, int topCount, params string[] propertyNames); public ArrayList RetrieveAssociations(); public ArrayList RetrieveAssociations(Type elementType); public ArrayList RetrieveAssociations(params Type[] elementTypes); public void RetrieveById(); public void RetrieveByPK(); protected internal virtual void RetrieveBySql(string sql); public void ShadowCopyTo(object targetEntity); public void ShadowCopyTo(T targetEntity); protected static double Sum(string columnName); protected static double Sum(string columnName, string condition); protected static List SumGroup(string columnName, string groupBy); protected static List SumGroup(string columnName, string condition, string groupBy); public static string ToColumnName(string propertyName); public static T ToObject(DataRow adaptedRow); public static List ToObjects(DataTable adaptedTable); public static List ToObjects(DataRow[] adaptedRows); public static string ToPropertyName(string columnName); public static DataTable ToTable(IList entities); public static DataTable ToTable(params T[] entities); public static DataTable ToTable(bool isAdapted, params T[] entities); public static DataTable ToTable(bool isAdapted, IList entities); // Properties protected internal static string CommandText { get; } protected internal static GatewayConfig Config { get; } internal T Entity { get; set; } public object EntityId { get; } public object PrimaryKey { get; } protected static Order SortedOrder { get; set; } } public abstract class TableGateway : ViewGateway where T: TableGateway, new() { // Methods static TableGateway(); protected TableGateway(); public int AddNew(); public static int AddNew(IList entities); public static int AddNew(T entity); public int AddNew(bool returnIdentity); public static int AddNew(T entity, bool returnIdentity); public static int AddNew(IList entities, out Transaction transaction); public static int AddNew(IList entities, bool returnIdentity); public static int AddNew(T entity, out Transaction transaction); public static int AddNew(IList entities, bool returnIdentity, out Transaction transaction); public static int AddNew(T entity, bool returnIdentity, out Transaction transaction); public IDbTransaction BeginTransaction(); public IDbTransaction BeginTransaction(IsolationLevel isolationLevel); public IDbTransaction BeginTransaction(double activeTime); public IDbTransaction BeginTransaction(IsolationLevel isolationLevel, double activeTime); public bool Commit(); protected static int Delete(string condition); protected static int Delete(string condition, out Transaction transaction); public int DeleteById(); public static int DeleteById(T entity); public static int DeleteById(IList entities); public static int DeleteById(IList entities, out Transaction transaction); public static int DeleteById(T entity, out Transaction transaction); public int DeleteByPK(); public static int DeleteByPK(T entity); public static int DeleteByPK(IList entities); public static int DeleteByPK(IList entities, out Transaction transaction); public static int DeleteByPK(T entity, out Transaction transaction); protected void OnPropertyChanged(MethodBase propertyMethod); protected void OnPropertyChanged(string propertyName); protected internal override void RetrieveBySql(string sql); public bool Rollback(); protected static int Update(T entity, string condition); protected static int Update(T entity, string condition, out Transaction transaction); public int UpdateById(); public static int UpdateById(IList entities); public static int UpdateById(T entity); public static int UpdateById(T entity, out Transaction transaction); public static int UpdateById(IList entities, out Transaction transaction); public int UpdateByPK(); public static int UpdateByPK(IList entities); public static int UpdateByPK(T entity); public static int UpdateByPK(IList entities, out Transaction transaction); public static int UpdateByPK(T entity, out Transaction transaction); // Properties public bool Changed { get; } public List ChangedPropertyNames { get; } } public class StoredProcedure : IStoredProcedure { public bool BeginTransaction(); public void CloseReader(IDataReader reader); public bool Commit(); public DataSet ExecuteDataSet(); public DataTable ExecuteDataTable(); public DataTable ExecuteDataTable(); public List ExecuteEntity(); public int ExecuteNonQuery(); public IDataReader ExecuteReader(); public object ExecuteScalar(); protected static void InitializeGateway(GatewayConfig config); protected static void InitializeGateway(DatabaseType dbType, string connectionString); protected void InitializeInstance(T entity); public bool Rollback(); } public class AggregateEntity where T: AggregateEntity, new() { public static List Execute(); protected static List Execute(string condition); public static DataTable ExecuteDataTable(); protected static DataTable ExecuteDataTable(string condition); protected static void InitializeGateway(GatewayConfig config); protected static void InitializeGateway(DatabaseType dbType, string connectionString); // Properties protected static Order SortedOrder { get; set; } } public static class EntityMapper { // Methods public static void AdaptToDatabase(DataTable adaptedTable); public static void AdaptToEntity(DataTable rawTable); public static void CopyToEntities(IList entities, IList adaptedRows); public static void CopyToEntities(IList entities, DataTable adaptedTable); public static void CopyToEntity(T entity, DataRow row); public static List CreateEntities(int count); public static DataTable CreateTable(); public static DataTable CreateTable(bool isAdapted); public static string ToColumnName(string propertyName); public static List ToEntities(IList adaptedRows); public static List ToEntities(DataTable table); public static T ToEntity(DataRow adaptedRow); public static string ToPropertyName(string columnName); public static DataTable ToTable(IList entities); public static DataTable ToTable(params T[] entities); public static DataTable ToTable(bool isAdapted, params T[] entities); public static DataTable ToTable(bool isAdapted, IList entities); } public static class EntityUtility { // Methods public static List Inherit(IList entities); public static T Inherit(object entity); public static T Inherit(Tbase baseEntity, TransformAction method); public static List Inherit(IList baseEntities, TransformAction method); public static void ShadowCopy(IList targetEntities, IList sourceEntities); public static void ShadowCopy(object targetEntity, object sourceEntity); }

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值