[NetStar.EF.Join(@"
LEFT JOIN t_stm_user T1 ON T1.ID = T0.CREATOR_ID
LEFT JOIN t_stm_user T2 ON T2.ID = T0.REVISER_ID
LEFT JOIN t_mcrm_market_data T3 ON T3.ID = T0.CLASSIFY_ID
")]
public partial class MarketInformationViewInfo : MarketInformationInfo
{
[NetStar.EF.RefColumn("T1.USER_NAME")]
public virtual string UserName { get; set; }
[NetStar.EF.RefColumn("T2.USER_NAME")]
public virtual string ReviserName { get; set; }
[NetStar.EF.RefColumn("T3.TARGET_NAME")]
public virtual string Name { get; set; }
[NetStar.EF.RefColumn("T3.UNIT")]
public virtual string Unit { get; set; }
[NetStar.EF.RefColumn("T3.MAX_V")]
public virtual decimal? MaxV { get; set; }
[NetStar.EF.RefColumn("T3.MIN_V")]
public virtual decimal? MinV { get; set; }
[NetStar.EF.RefColumn("max(T0.DAY_DATE)")]
public virtual DateTime? MaxDayDate { get; set; }
}
- decimal ? 后边带个问号,代表可以为空
- “max(T0.DAY_DATE)” 能这样写,说明可以使用数据库的函数