1.首先打开PowerDesigner，点击左上角“File”—>"Reverse Engineer"—>"Database..."
2.选择数据库，导入sql脚本，生成物理模型。‘
3.选择Tools-Generate Object-Oriented Model,选择要生成哪种语言。点击configure model options可以调整生成格式。
我将Name选择为UPPERCASE，Code选择lowercase
4.确定，新生成了model，现在选择Language-Edit Current Object Language，修改Profile/Attribute/Templates/definition为需要的形式
我的代码为
.if (%isValidAttribute%)
/// <summary>
[%comment%\n]\
/// <summary>
[%customAttributes%\n]\
[%oidDocTag%\n]\
.if (%Multiple% == ) and (%isIndexer% == false)
private %dataType% _%fieldCode%[ = %InitialValue%];
[%visibility% ][%flags% ]%dataType% %Name%
{
get
{
return _%fieldCode%;
}
set
{
_%fieldCode% = value;
}
}
.else
private %dataType%[%arraySize%] _%fieldCode%[ = %InitialValue%];
[%visibility% ][%flags% ]%dataType%[%arraySize%] %Name%
{
get
{
return _%fieldCode%;
}
set
{
_%fieldCode% = value;
}
}
.endif
.endif
5.选择language-generate xx code ，选择一个目录，实体类代码就生成好了。我生成的格式如下
public class SH
{
/// <summary>
/// 审核状态：0未审核1审核通过2审核不通过
/// <summary> private decimal _state;
public decimal STATE
{
get
{
return _state;
}
set
{
_state = value;
}
}
/// <summary>
/// 审核意见
/// <summary> private string _shyj;
public string SHYJ
{
get
{
return _shyj;
}
set
{
_shyj = value;
}
}
/// <summary>
/// 审核时间
/// <summary> private DateTime _shsj;
public DateTime SHSJ
{
get
{
return _shsj;
}
set
{
_shsj = value;
}
}
/// <summary>
/// 审核人姓名
/// <summary> private string _shrname;
public string SHRNAME
{
get
{
return _shrname;
}
set
{
_shrname = value;
}
}
/// <summary>
/// 审核人ID
/// <summary> private string _shrid;
public string SHRID
{
get
{
return _shrid;
}
set
{
_shrid = value;
}
} /// <summary>
/// 申请原因
/// <summary> private string _sqyy;
public string SQYY
{
get
{
return _sqyy;
}
set
{
_sqyy = value;
}
} /// <summary>
/// 申请时间
/// <summary> private DateTime _sqtime;
public DateTime SQTIME
{
get
{
return _sqtime;
}
set
{
_sqtime = value;
}
}
/// <summary>
/// 申请人手机号
/// <summary> private string _mobile;
public string MOBILE
{
get
{
return _mobile;
}
set
{
_mobile = value;
}
}
/// <summary>
/// 申请人姓名
/// <summary> private string _username;
public string USERNAME
{
get
{
return _username;
}
set
{
_username = value;
}
}
/// <summary>
/// 申请人ID
/// <summary> private string _userid;
public string USERID
{
get
{
return _userid;
}
set
{
_userid = value;
}
}
/// <summary>
/// 企业名称
/// <summary> private string _cpname;
public string CPNAME
{
get
{
return _cpname;
}
set
{
_cpname = value;
}
}
/// <summary>
/// 企业ID
/// <summary> private string _cpid;
public string CPID
{
get
{
return _cpid;
}
set
{
_cpid = value;
}
}
/// <summary>
/// 唯一标识
/// <summary> private string _id;
public string ID
{
get
{
return _id;
}
set
{
_id = value;
}
} }