多表LINQ写法解决思路
日期：2014-05-20 浏览次数：20699 次
多表LINQ写法
业务表T：
岗位表P：
部门表D：
业务表T：
[Key]
public int ID { get; set; }
[Display(Name = "员工")]
[Required(ErrorMessage = "*")]
public string StaffNo { get; set; }
[Display(Name = "调动时间")]
[Required(ErrorMessage = "*")]
public DateTime TransferDate { get; set; }
[Display(Name = "调出公司")]
[Required(ErrorMessage = "*")]
public int OutCompanyID { get; set; }
[Display(Name = "调出部门")]
[Required(ErrorMessage = "*")]
public int OutDeptID { get; set; }
[Display(Name = "调出岗位")]
[Required(ErrorMessage = "*")]
public int OutPositionID { get; set; }
[Display(Name = "调入公司")]
[Required(ErrorMessage = "*")]
public int InCompanyID { get; set; }
[Display(Name = "调入部门")]
[Required(ErrorMessage = "*")]
public int InDeptID { get; set; }
[Display(Name = "调入岗位")]
[Required(ErrorMessage = "*")]
public int InPositionID { get; set; }
岗位表P：
[Key]
public int ID { get; set; }
[Display(Name = "岗位名称")]
[Required(ErrorMessage = "*")]
[StringLength(15, ErrorMessage = "不能超过15个字符")]
public string Name { get; set; }
[Display(Name = "所属部门")]
public int DeptID { get; set; }
[ForeignKey("DeptID")]
public virtual BaseOrganization Organization { get; set; }
部门表D：
[Key]
public int ID { get; set; }
[Display(Name = "机构名称")]
[Required(ErrorMessage = "*")]
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
