PDMan SqlSugar模板

原创已于 2022-09-23 16:52:23 修改 · 492 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#c#

于 2022-09-22 19:10:05 首次发布

自用专栏收录该内容

17 篇文章

订阅专栏

本文介绍了一个使用SqlSugar ORM框架自动生成C#实体类的过程。该过程包括了如何根据数据库表结构动态创建实体类，并为每个字段添加相应的属性及SugarColumn特性。此外，还展示了如何自动生成构造函数及ToString方法。

using System;
using System.Collections.Generic;
using SqlSugar;

$blankline
{{
    var today=new Date();
    var fullYear=today.getFullYear();
    var month=today.getMonth() + 1;
    var days=today.getDate();
    var sqlSugartable='[SugarTable("{{=it.entity.defKey}}", TableDescription = "{{=it.func.join(it.entity.defName,it.entity.comment,';')}}")]';
    
    var pkVarName = "undefinedId";
    var pkDataType = "String";
    it.entity.fields.forEach(function(field){
        if(field.primaryKey){
            pkVarName = it.func.camel(field.defKey,false);
            pkDataType = field["type"];
            return;
        }
    });
    /*
    var defKeyArray=it.entity.fields.map(t=>+t.defKey+'\":this.'+it.func.camel(t.defKey,true));
    */
    var pkgName = it.entity.env.base.nameSpace;
    var beanClass = it.entity.env.base.codeRoot;
    var beanVarName = beanClass.charAt(0).toLowerCase()+beanClass.slice(1);
    var serviceClass = beanClass+'Service';
    var serviceVarName= beanVarName+'Service';
}}


/*
 * @author : 
 * @date : {{=fullYear}}-{{=month}}-{{=days}}
 * @desc : {{=it.func.join(it.entity.defName,it.entity.comment,'-')}}
 */
namespace {{=pkgName}}
{
    /// <summary>
    /// {{=it.func.join(it.entity.defName,it.entity.comment,';')}}
    /// </summary>
    {{=sqlSugartable}}
    public class {{=it.entity.defKey}}
    {
        {{~it.entity.fields:field:index}}
        /// <summary>
        /// {{=it.func.join(field.defName,field.comment,';')}}
        /// </summary>
        {{? field.primaryKey }}
        [SugarColumn(ColumnName="{{=field.defKey}}",IsIdentity = true, IsPrimaryKey = true)]
        {{?}}
        {{?  !field.primaryKey }}
        [SugarColumn(ColumnName="{{=field.defKey}}")]
        {{?}}
        public {{=field.type}} {{=it.func.camel(field.defKey,true)}}{ get; set; }
        $blankline
        {{~}}
    
    
        public override string ToString()
        {
            return $"{{=it.entity.fields.map(t=>{let s= t.defKey+':{this.'+it.func.camel(t.defKey,true); 
            /*if(t.type!="string"){
                s+='.ToString()';
                }   */
            s +='}';
            return s;
            }).join(',')}}";
        }
    }
}