private static Entity.Respose.studentcertifi ConvertStudentCertifiToResponse(Entity.MsSQL.T_Certificate _Certifi, Entity.MsSQL.T_StudentTicket _ticket, Entity.MsSQL.T_CertifiSerial _Serial, List <Entity.MsSQL.T_CertifiSubject> _CertifiSubjectsAll, List <Entity.MsSQL.T_Subject> _SubjectsAll) { if (_Certifi == null) { return(null); } Entity.Respose.studentcertifi result = new Entity.Respose.studentcertifi() { SerialNum = _ticket == null ? "" : Untity.HelperDataCvt.objToString(_ticket.SerialNum), CategoryName = Untity.HelperDataCvt.objToString(_Certifi.CategoryName), TicketNum = _ticket == null ? "" : Untity.HelperDataCvt.objToString(_ticket.TicketNum), ExamSubject = Untity.HelperDataCvt.objToString(_Certifi.ExamSubject), Describe = Untity.HelperDataCvt.objToString(_Certifi.Describe), NormalResult = Untity.HelperDataCvt.objToString(_Certifi.NormalResult), ExamResult = Untity.HelperDataCvt.objToString(_Certifi.ExamResult), StartTime = Untity.HelperDataCvt.DateTimeToStrNoHour(_Certifi.StartTime), EndTime = Untity.HelperDataCvt.DateTimeToStrNoHour(_Certifi.EndTime), IssueDate = ((_Serial != null && _Serial.IssueDate != null) ? Untity.HelperDataCvt.DateTimeToStr(Convert.ToDateTime(_Serial.IssueDate)) : ""), CertState = CertState.未报名, CertifiId = _Certifi.Id.ToString(), }; if (_ticket != null) { if (string.IsNullOrEmpty(_ticket.SerialNum)) { result.CertState = CertState.已报名; } else { result.CertState = CertState.已发证; } } List <Entity.MsSQL.T_CertifiSubject> _CertifiSubjects = _CertifiSubjectsAll.Where(ii => ii.CertificateId == _Certifi.Id.ToString()).ToList(); foreach (var item in _CertifiSubjects) { Entity.MsSQL.T_Subject _subject = _SubjectsAll.Where(ii => ii.ID.ToString() == item.SubjectId).FirstOrDefault(); result.Subject.Add(new Entity.Respose.allcertifisubject() { CertificateId = item.CertificateId, Category = _subject == null ? "" : _subject.Category, SubjectId = item.SubjectId, NormalResult = Untity.HelperDataCvt.objToString(item.NormalResult), ExamResult = Untity.HelperDataCvt.objToString(item.ExamResult), Name = _subject == null ? "" : _subject.Name, Price = _subject == null ? "" : _subject.Price, OLSchoolId = _subject.OLSchoolId }); } return(result); }
public static object getstudentcertifi(string _uid, string _pwd, string studentid, ref string error) { Entity.Respose.getstudentcertifi result = new Entity.Respose.getstudentcertifi(); Entity.MsSQL.T_Organiza _orga = Dal.MsSQL.T_Organiza.GetModel(_uid, _pwd); if (_orga != null) { List <Entity.Respose.unsignupcertificate> _allunsign = new List <Entity.Respose.unsignupcertificate>(); if (!string.IsNullOrEmpty(studentid)) { Entity.MsSQL.T_Student _student = OrganizaRepository.Singleton.GetStudentModel(studentid); if (_student != null) { if (_orga.Id != _student.OrgaId) { error = "非本机构学员无法查询!"; return("-1"); } result.cardid = _student.CardId; result.name = _student.Name; result.username = _student.OLSchoolUserName; List <Entity.MsSQL.T_Certificate> _CertifisAll = Dal.MsSQL.T_Certificate.GetList(); List <Entity.MsSQL.T_Subject> _SubjectsAll = Dal.MsSQL.T_Subject.GetAllList(); List <Entity.MsSQL.T_CertifiSubject> _CertifiSubjectsAll = Dal.MsSQL.T_CertifiSubject.GetList(); List <Entity.MsSQL.T_StudentTicket> _TicketsAll = Dal.MsSQL.T_StudentTicket.GetList(studentid); List <Entity.MsSQL.T_CertifiSerial> _SerialsAll = Dal.MsSQL.T_CertifiSerial.GetAllList(); foreach (var item in _TicketsAll) { Entity.MsSQL.T_Certificate _Certifi = _CertifisAll.Where(ii => ii.Id.ToString() == item.CertificateId).FirstOrDefault(); Entity.MsSQL.T_CertifiSerial _Serial = _SerialsAll.Where(ii => ii.SerialNum.ToString() == item.SerialNum).FirstOrDefault(); Entity.Respose.studentcertifi _model = ConvertStudentCertifiToResponse(_Certifi, item, _Serial, _CertifiSubjectsAll, _SubjectsAll); if (_model == null) { continue; } if (string.IsNullOrEmpty(item.SerialNum)) { result.signup.Add(_model); } else { result.hold.Add(_model); } } foreach (var item in _CertifisAll) { try { if (item.EndTime < DateTime.Now && !string.IsNullOrEmpty(Untity.HelperDataCvt.DateTimeToStr(item.EndTime))) { continue; } Entity.Respose.studentcertifi _item1 = result.signup.Where(ii => ii.CertifiId == item.Id.ToString()).FirstOrDefault(); if (_item1 != null) { continue; } Entity.Respose.studentcertifi _item2 = result.hold.Where(ii => ii.CertifiId == item.Id.ToString()).FirstOrDefault(); if (_item2 != null) { continue; } Entity.Respose.studentcertifi _model = ConvertStudentCertifiToResponse(item, null, null, _CertifiSubjectsAll, _SubjectsAll); if (_model != null) { result.unsignup.Add(_model); } } catch { continue; } } } else { error = "学员不存在,请核对信息是否正确"; } } return(result); } else { error = "账号失效,请重新登陆"; return("-1"); } }