一款比动软件代码生成器好用很多的MVC代码生成工具,有源码下载

牛牛代码生成器是一款功能齐全,操作灵活,使用简单的c#代码生成器,它能支持Oracle及Sql Server两种数据库,生成的代码规范、完整且高效,尤其与本站中的   牛牛C# 程序开发平台 配合使用,堪称经典组合。下面,我们来为您介绍这款软件:
目录
Generate By Table
Generate By View
Generate From File
Publish Generated
System Setting
Other
 
登入:
        本软件支持Oracle和Sql Server两种数据库:


#p#分页标题#e#
主窗体:
     它包含六个菜单:
1> 由表生成 
点击 “Generate by Table”, 显示如下界面:
Ø  第 1 步, 选择一个表,点击 “Next > “:
 
Ø   第 2 步:点击向上(或向下)的箭头按钮,调整表列的顺序:
  • 点击 “Next > “:
#p#分页标题#e#
 
 
Ø   第 3 步:选择您要生成的函数,点击 “Next > “:
Ø   第 4 步, 选择您要生成的函数,点击 “Next > “:
Ø    第 5 步,  选择存储过程,点击 “Next > “:
 #p#分页标题#e#
Ø   第 6 步, 选择数据库的连接方式及生成的代码文件的路径,点击 “Next > “:
Ø   第 7 步,  检查前几步所选的参数,然后点击"Finish",生成代码文件:
成功,则提示如下窗口:
 
以下是生成的代码文件:
²  Model 类(数据模型):
²  IDal  类(接口类):
²  Dal 类(数据实现类):
#p#分页标题#e#
²  Bll 类(表示层):
Ø   第 8 步, 生成成功后,系统给出如下提示,询问您是否要发布代码.
点击“Yes”, 弹出如下窗口,输入要发布的路径:
点击 “Finish” 按钮即可发布.
#p#分页标题#e#
 
2> 由视图生成
点击 “Generate View”, 弹出如下窗口:
Ø   第 8 步, 选择一个视图:
 
       余下的步骤与 “Generate By Table” 的操作完全一致.

#p#分页标题#e#
3> 由文本文件生成
点击 “Generate From File”菜单, 弹出如下窗口:
Ø   第 1 步, 创建一个文件文件,格式如下:
Ø   第 2 步, 在下面的窗口中点击右键,选择 “Load From File”菜单:
选取第 1 步中的文本文件:
载入后的数据如图:
Ø   第 3 步, 点击"Generate",在状态栏会提示"Success"的红色信息:
Ø   第 4 步, 点击 “View”, 查看生成的代码,如下图:
 
#p#分页标题#e#

4> 发布代码 
点击 “Publish Generated”, 显示如下界面:
点击"Publish“按钮,发布在您的解决方案中.
点击  图标, 您可以查看生成的文件中的代码.
#p#分页标题#e#

5> 系统设定
点击 “System Setting”, 显示如下窗体:
 
Ø  Connect by: 默认为"OracleClient", 该项设置数据库的连接方式.
Ø  Using BindingCollection, 函数返回的列表集合类型,默认为  BindingCollection<mod>  它是  IList<mod> 的继承类,其扩展功能可以使绑定的表格在点击列标题时排序.
Ø  Using Utility Convert Functions. 数据转换方式.
Ø  Menus: 您的三层架构文件夹,生成代码前,即在如下下拉框中的选项:
6> 其它
右击 ,弹出如下菜单,您可以自行研究:



 

如需该工具源码,请上牛牛网下载。

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
一、使用对象关系映射组件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、代码生成器源码:Xsd2CS。 3、代码生成器插件源码(支持SQLServer2000、SQLServer2005和Oracle):Plugin。 4、使用手册:DBFramework.Manual V4.5.3.pdf。 主要API: public abstract class ViewGateway<T> where T: new() { // Methods static ViewGateway(); protected ViewGateway(); protected static int Count(); protected static int Count(string condition); protected static List<int> CountGroup(string groupBy); protected static List<int> CountGroup(string condition, string groupBy); public static List<T> CreateInstances(int count); protected static List<ColumnType> Distinct<ColumnType>(string columnName); protected static List<ColumnType> Distinct<ColumnType>(string columnName, string condition); protected static List<ColumnType> Distinct<ColumnType>(string columnName, string condition, bool ignoreNull); protected static bool Exists(string condition); public bool ExistsById(); public bool ExistsByPK(); protected static List<T> Find(PagingArg pagingArg, params string[] propertyNames); protected static List<T> Find(string condition, params string[] propertyNames); protected static List<T> Find(PagingArg pagingArg, bool sqlServer2000, params string[] propertyNames); protected static List<T> Find(string condition, PagingArg pagingArg, params string[] propertyNames); protected static List<T> Find(string condition, PagingArg pagingArg, bool sqlServer2000, params string[] propertyNames); protected static List<T> FindAll(params string[] propertyNames); protected static void FindTop(T firstOne); protected static List<T> FindTop(int topCount, params string[] propertyNames); protected static void FindTop(string condition, T firstOne); protected static List<T> 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<object> MaxGroup(string columnName, string groupBy); protected static List<object> MaxGroup(string columnName, string condition, string groupBy); protected static object Min(string columnName); protected static object Min(string columnName, string condition); protected static List<object> MinGroup(string columnName, string groupBy); protected static List<object> 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<double> SumGroup(string columnName, string groupBy); protected static List<double> SumGroup(string columnName, string condition, string groupBy); public static string ToColumnName(string propertyName); public static T ToObject(DataRow adaptedRow); public static List<T> ToObjects(DataTable adaptedTable); public static List<T> ToObjects(DataRow[] adaptedRows); public static string ToPropertyName(string columnName); public static DataTable ToTable(IList<T> entities); public static DataTable ToTable(params T[] entities); public static DataTable ToTable(bool isAdapted, params T[] entities); public static DataTable ToTable(bool isAdapted, IList<T> 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<T> : ViewGateway<T> where T: TableGateway<T>, new() { // Methods static TableGateway(); protected TableGateway(); public int AddNew(); public static int AddNew(IList<T> 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<T> entities, out Transaction transaction); public static int AddNew(IList<T> entities, bool returnIdentity); public static int AddNew(T entity, out Transaction transaction); public static int AddNew(IList<T> 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<T> entities); public static int DeleteById(IList<T> 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<T> entities); public static int DeleteByPK(IList<T> 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<T> entities); public static int UpdateById(T entity); public static int UpdateById(T entity, out Transaction transaction); public static int UpdateById(IList<T> entities, out Transaction transaction); public int UpdateByPK(); public static int UpdateByPK(IList<T> entities); public static int UpdateByPK(T entity); public static int UpdateByPK(IList<T> entities, out Transaction transaction); public static int UpdateByPK(T entity, out Transaction transaction); // Properties public bool Changed { get; } public List<string> ChangedPropertyNames { get; } } public class StoredProcedure<T> : IStoredProcedure { public bool BeginTransaction(); public void CloseReader(IDataReader reader); public bool Commit(); public DataSet ExecuteDataSet(); public DataTable ExecuteDataTable(); public DataTable ExecuteDataTable<Ttarget>(); public List<Ttarget> ExecuteEntity<Ttarget>(); 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<T> where T: AggregateEntity<T>, new() { public static List<T> Execute(); protected static List<T> 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<T> { // Methods public static void AdaptToDatabase(DataTable adaptedTable); public static void AdaptToEntity(DataTable rawTable); public static void CopyToEntities(IList<T> entities, IList<DataRow> adaptedRows); public static void CopyToEntities(IList<T> entities, DataTable adaptedTable); public static void CopyToEntity(T entity, DataRow row); public static List<T> CreateEntities(int count); public static DataTable CreateTable(); public static DataTable CreateTable(bool isAdapted); public static string ToColumnName(string propertyName); public static List<T> ToEntities(IList<DataRow> adaptedRows); public static List<T> ToEntities(DataTable table); public static T ToEntity(DataRow adaptedRow); public static string ToPropertyName(string columnName); public static DataTable ToTable(IList<T> entities); public static DataTable ToTable(params T[] entities); public static DataTable ToTable(bool isAdapted, params T[] entities); public static DataTable ToTable(bool isAdapted, IList<T> entities); } public static class EntityUtility { // Methods public static List<T> Inherit<T>(IList entities); public static T Inherit<T>(object entity); public static T Inherit<Tbase, T>(Tbase baseEntity, TransformAction<Tbase, T> method); public static List<T> Inherit<Tbase, T>(IList<Tbase> baseEntities, TransformAction<Tbase, T> 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、付费专栏及课程。

余额充值