/// <summary> /// /// </summary> /// <param name="testManId"></param> /// <returns></returns> public static string getUnitName(string testManId) { string name = string.Empty; var getPerson = Funs.DB.SitePerson_Person.FirstOrDefault(x => x.PersonId == testManId); if (getPerson != null) { name = UnitService.GetUnitNameByUnitId(getPerson.UnitId); } return(name); }
/// <summary> /// 获取考生信息 /// </summary> /// <param name="testPlanId"></param> /// <param name="testManId"></param> /// <param name="userType"></param> /// <param name="identityCard"></param> /// <returns></returns> public static Model.TestRecordItem getTestRecordInfo(string testPlanId, string testManId, string userType, string identityCard) { using (Model.SUBHSSEDB db = new Model.SUBHSSEDB(Funs.ConnString)) { Model.TestRecordItem newTestRecord = new Model.TestRecordItem(); var getTestPlan = db.Test_TestPlan.FirstOrDefault(x => x.TestPlanId == testPlanId); if (getTestPlan != null) { newTestRecord.TestPlanName = getTestPlan.PlanName; newTestRecord.TestPlanId = testPlanId; newTestRecord.TestPlanStartTime = string.Format("{0:yyyy-MM-dd HH:mm:ss}", getTestPlan.TestStartTime); newTestRecord.TestPlanEndTime = string.Format("{0:yyyy-MM-dd HH:mm:ss}", getTestPlan.TestEndTime); newTestRecord.TestManId = testManId; newTestRecord.UserType = userType; var getUpdateTestRecord = db.Test_TestRecord.FirstOrDefault(x => x.TestPlanId == testPlanId && x.IdentityCard == identityCard); if (getUpdateTestRecord == null && userType != "2") { getUpdateTestRecord = db.Test_TestRecord.FirstOrDefault(x => x.TestPlanId == testPlanId && x.TestManId == testManId); } if (getUpdateTestRecord != null) { newTestRecord.TestRecordId = getUpdateTestRecord.TestRecordId; newTestRecord.DepartId = getUpdateTestRecord.DepartId; newTestRecord.UnitId = getUpdateTestRecord.UnitId; newTestRecord.ProjectId = getUpdateTestRecord.ProjectId; newTestRecord.TestManName = getUpdateTestRecord.TestManName; newTestRecord.Telephone = getUpdateTestRecord.Telephone; newTestRecord.IdentityCard = getUpdateTestRecord.IdentityCard; newTestRecord.TestScores = getUpdateTestRecord.TestScores ?? 0; } else { if (userType == "1") { var getUser = db.Sys_User.FirstOrDefault(x => x.UserId == testManId); if (getUser != null) { newTestRecord.TestManName = getUser.UserName; newTestRecord.UnitId = getUser.UnitId; newTestRecord.DepartId = getUser.DepartId; newTestRecord.IdentityCard = getUser.IdentityCard; newTestRecord.Telephone = getUser.Telephone; } } else if (userType == "3") { var getPerson = db.SitePerson_Person.FirstOrDefault(x => x.PersonId == testManId); if (getPerson != null) { newTestRecord.TestManName = getPerson.PersonName; newTestRecord.ProjectId = getPerson.ProjectId; newTestRecord.UnitId = getPerson.UnitId; newTestRecord.WorkPostId = getPerson.WorkPostId; newTestRecord.IdentityCard = getPerson.IdentityCard; newTestRecord.Telephone = getPerson.Telephone; } } else { newTestRecord.UnitId = newTestRecord.UnitId = CommonService.GetIsThisUnitId(); } } newTestRecord.DepartName = DepartService.getDepartNameById(newTestRecord.DepartId); newTestRecord.UnitName = UnitService.GetUnitNameByUnitId(newTestRecord.UnitId); newTestRecord.ProjectName = ProjectService.GetProjectNameByProjectId(newTestRecord.ProjectId); newTestRecord.IsThiUnit = CommonService.GetIsThisUnit(newTestRecord.UnitId); } return(newTestRecord); } }