分享改进完全定制自己的代码生成器-白红宇

分享改进完全定制自己的代码生成器

阅读量：6942 次

发布时间：2019-06-27

本文共 10763 字，大约阅读时间需要 35 分钟。

codesmith确实是款不错的工具但是它并不开源对于一些有自己特殊需求的用户只能自己另想其他解决方案例如我说想做一个web版本的代码生成器或者说用户没有c#基础

这里开源一个之前做过的工具当初的目的主要是解决在框架当中局部更新的问题

因为在大部分orm框架当中都是简单的获取一个实体然后这个实体某个值然后更新的时候还是传入这个改变的实体不过严格意义上来说在你传入更新实体的时候它的其他字段说不定已经被其他请求更新过了所以导致你的这次更新会覆盖掉别人的更新当然也会有同一字段的问题不过这里不深入讨论该问题重点在代码生成上

另外一个意义就是让大家了解一下一般的代码生成器的工作流程以及实现方法

Github地址

使用方法很简单先输入数据库连接字符串下面会出现table和view，当然自己可以根据源代码加载更多的内容

我程序里主要生成实体层和数据处理层所以我提供了2个文本框一个是实体层的命名空间一个是数据处理层的命名的命名空间，这样就不用在模板里设置，可以在win界面或者web界面直接修改

选择好表和view并且设置好命名空间后点击启动左下角提示成功后就可以打开目录查看自己生成的文件

生成的实体文件

这里的PartiallyColumnAttribute主要就是用来解决局部更新问题，和代码生成本身无关联。

DA文件

//------------------------------------    //用途：表LitespeedActivity的数据处理类（工具自动生成）    //作者：杜兵    //时间：2015-03-11 05:43:32    //-------------------------------------    using System;    using System.Data;    using System.Data.Common;    using Model.Service;    using Ctrip.TMPay.Framework.Common;    using Ctrip.TMPay.DataAccess.Common;    namespace DataAccess.Service    {        public partial class LitespeedActivityDA : BaseDA
     
              {                        /// 
                  /// 根据主键获取LitespeedActivity            ///
            ///< param name="serverName">            ///< returns>            public LitespeedActivityEntity GetLitespeedActivity(String serverName)            {                DbCommand dbCmd = DbObject.GetSqlStringCommand(SqlCommandConstants.LitespeedActivitySelectCommand);                DbObject.AddInParameter(dbCmd, "@ServerName", DbType.String, serverName);                LitespeedActivityEntity litespeedActivityEntity = null;                using (IDataReader dataReader = DbObject.ExecuteReader(dbCmd))                {                    if (dataReader.Read())                    {                          litespeedActivityEntity = new LitespeedActivityEntity{                              ServerName = DbFieldHelper.GetString(dataReader, "ServerName"),                              ActivityID = DbFieldHelper.GetInt32(dataReader, "ActivityID"),                              DatabaseID = DbFieldHelper.GetInt32(dataReader, "DatabaseID"),                              ActivityTypeID = DbFieldHelper.GetInt32(dataReader, "ActivityTypeID"),                              StartTime = DbFieldHelper.GetDateTime(dataReader, "StartTime"),                              FinishTime = DbFieldHelper.GetDateTime(dataReader, "FinishTime"),                              StatusTypeID = DbFieldHelper.GetInt32(dataReader, "StatusTypeID"),                              DatabaseSize = DbFieldHelper.GetDouble(dataReader, "DatabaseSize"),                              PercentCompleted = DbFieldHelper.GetInt32(dataReader, "PercentCompleted"),                              ActivityDetail = DbFieldHelper.GetString(dataReader, "ActivityDetail"),                              ErrorMessage = DbFieldHelper.GetString(dataReader, "ErrorMessage"),                              ResultMessage = DbFieldHelper.GetString(dataReader, "ResultMessage"),                              ReplicateID = DbFieldHelper.GetGuid(dataReader, "ReplicateID"),                              LS = DbFieldHelper.GetByte(dataReader, "LS"),                              PID = DbFieldHelper.GetInt32(dataReader, "PID"),                              NativeSize = DbFieldHelper.GetDouble(dataReader, "NativeSize"),                              BackupSize = DbFieldHelper.GetDouble(dataReader, "BackupSize"),                              BackupTime = DbFieldHelper.GetDouble(dataReader, "BackupTime"),                              AttachedNativeSize = DbFieldHelper.GetDouble(dataReader, "AttachedNativeSize"),                              AttachedBackupSize = DbFieldHelper.GetDouble(dataReader, "AttachedBackupSize"),                              AttachedBackupTime = DbFieldHelper.GetDouble(dataReader, "AttachedBackupTime"),                                                        };                     }                 }                 return litespeedActivityEntity;             }                   /// 
                  /// 根据主键获取LitespeedActivity            ///
            ///< param name="activityID">            ///< returns>            public LitespeedActivityEntity GetLitespeedActivity(Int32 activityID)            {                DbCommand dbCmd = DbObject.GetSqlStringCommand(SqlCommandConstants.LitespeedActivitySelectCommand);                DbObject.AddInParameter(dbCmd, "@ActivityID", DbType.Int32, activityID);                LitespeedActivityEntity litespeedActivityEntity = null;                using (IDataReader dataReader = DbObject.ExecuteReader(dbCmd))                {                    if (dataReader.Read())                    {                          litespeedActivityEntity = new LitespeedActivityEntity{                              ServerName = DbFieldHelper.GetString(dataReader, "ServerName"),                              ActivityID = DbFieldHelper.GetInt32(dataReader, "ActivityID"),                              DatabaseID = DbFieldHelper.GetInt32(dataReader, "DatabaseID"),                              ActivityTypeID = DbFieldHelper.GetInt32(dataReader, "ActivityTypeID"),                              StartTime = DbFieldHelper.GetDateTime(dataReader, "StartTime"),                              FinishTime = DbFieldHelper.GetDateTime(dataReader, "FinishTime"),                              StatusTypeID = DbFieldHelper.GetInt32(dataReader, "StatusTypeID"),                              DatabaseSize = DbFieldHelper.GetDouble(dataReader, "DatabaseSize"),                              PercentCompleted = DbFieldHelper.GetInt32(dataReader, "PercentCompleted"),                              ActivityDetail = DbFieldHelper.GetString(dataReader, "ActivityDetail"),                              ErrorMessage = DbFieldHelper.GetString(dataReader, "ErrorMessage"),                              ResultMessage = DbFieldHelper.GetString(dataReader, "ResultMessage"),                              ReplicateID = DbFieldHelper.GetGuid(dataReader, "ReplicateID"),                              LS = DbFieldHelper.GetByte(dataReader, "LS"),                              PID = DbFieldHelper.GetInt32(dataReader, "PID"),                              NativeSize = DbFieldHelper.GetDouble(dataReader, "NativeSize"),                              BackupSize = DbFieldHelper.GetDouble(dataReader, "BackupSize"),                              BackupTime = DbFieldHelper.GetDouble(dataReader, "BackupTime"),                              AttachedNativeSize = DbFieldHelper.GetDouble(dataReader, "AttachedNativeSize"),                              AttachedBackupSize = DbFieldHelper.GetDouble(dataReader, "AttachedBackupSize"),                              AttachedBackupTime = DbFieldHelper.GetDouble(dataReader, "AttachedBackupTime"),                                                        };                     }                 }                 return litespeedActivityEntity;             }                   /// 
                  /// 全参数更新LitespeedActivity            ///
            ///< param name="litespeedActivityEntity">LitespeedActivityEntity            ///< returns>            public BizResult
      
        UpdateLitespeedActivity(LitespeedActivityEntity litespeedActivityEntity)            {                FillParams(litespeedActivityEntity);                return PartiallyUpdateLitespeedActivity(litespeedActivityEntity);            }                    /// 
                   /// 部分参数更新LitespeedActivity            ///
            ///< param name="litespeedActivityEntity">LitespeedActivityEntity            ///< returns>            public BizResult
       
         PartiallyUpdateLitespeedActivity(LitespeedActivityEntity litespeedActivityEntity)            {                               return ExecuteSP(SqlProcedureConstants.LitespeedActivityUpdateSpName, CheckUpdate, litespeedActivityEntity);            }                           /// 
                    /// 创建LitespeedActivity            ///
            ///< param name="litespeedActivityEntity">LitespeedActivityEntity            ///< returns>            public BizResult
        
          CreateLitespeedActivity(LitespeedActivityEntity litespeedActivityEntity)            {                 FillParams(litespeedActivityEntity);                 return ExecuteSP(SqlProcedureConstants.LitespeedActivityInsertSpName, null, litespeedActivityEntity);            }                          /// 
                     /// 删除LitespeedActivity            ///
            ///< param name="litespeedActivityEntity">LitespeedActivityEntity            ///< returns>            public BizResult
         
           DeleteLitespeedActivity(LitespeedActivityEntity litespeedActivityEntity)            {                 FillPKParams(litespeedActivityEntity);                 return ExecuteSP(SqlProcedureConstants.LitespeedActivityDeleteSpName, null, litespeedActivityEntity);            }         }    }

还有其他的一些文件就不一一列出了

原理很简单也是根据模板。不过和codesmith不同的是我这里用的是xsl模板包括语法

基于xml的语法并不难就算不懂.net的人学习半个小时也可以自己定制模板了

举个例子


     
       
        
        
        
        
        
        
          
       Table  
        
      
           //------------------------------------    //用途：表
       的实体类（工具自动生成）    //作者：杜兵     //时间：
           //-------------------------------------    using System;    using System.Data;    namespace 
           {        [Serializable]        public partial class 
       Entity : BaseEntity        {
    
                   
                    
                   
                      
                    
                       
          
           System.Xml.Linq.XElement
                        
           
            
                      
                   
                  
                    
                       
          
           rowversion
                        
          
           Variant
                        
           
            
                      
                   
                  
                    
                   
        
                  
                 
                  /// 
                  /// 
                   ///
                 [PartiallyColumnAttribute(DbType = 
         
        
         
          , CanBeNull = false
         
         
          , CanBeNull = true
         
        
        
         , IsPrimaryKey = true
        )]          public 
        
         
        
         {  get; set; }
                }    }

　　这里代码里模板实现主要是解决局部更新的功能，大家可以根据自己不同的需求来修改部分逻辑。

　　核心的配置文件在config下CodeSet.xml

　　主要的配置节点如下

　　细节比较多，但是通过源代码大家应该理解都没有问题，如果有不清楚的地方可以给我留言。后续会放出更多以前做过的工具。

希望对大家有帮助。

转载地址：http://wuinl.baihongyu.com/

你可能感兴趣的文章