/// <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); } }
public static int del(int id) { return(DepartService.del(id)); }
public static int Add(Depart det) { return(DepartService.Add(det)); }
public static int upDepartById(string DepartName, int id) { return(DepartService.upDepartById(DepartName, id)); }
public static PageList getDepartByName(int pageIndex, int pageSize, string name) { return(DepartService.getDepartByName(pageIndex, pageSize, name)); }