/// <summary> /// 通过参建单位主键获取参建人员 /// </summary> /// <param name="projGuid">项目主键</param> /// <param name="UnitGuid">参建单位主键</param> /// <returns>DataTable参建人员集合</returns> public static DataTable GetPersonsByUnit(string projGuid, string UnitGuid) { API api = new API(); SysDbContext context = api.CreateDbContext(); DataTable dt = SelectUnitAndPerson.GetPersonsByUnit(projGuid, UnitGuid); string guid = ""; foreach (DataRow dr in dt.Select()) { guid = dr["TypeName"].ToString(); var dic1 = context.Mapping.Where(d => d.Guid == guid).ToList(); if (dic1.Count > 0) { dr["TypeName"] = dic1[0].Name; } else { dr["TypeName"] = ""; } } return(dt); }