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 cancel(string _uid, string _pwd, string postString, ref string error)
{
Entity.MsSQL.T_Organiza _orga = Dal.MsSQL.T_Organiza.GetModel(_uid, _pwd);
if (_orga != null)
{
Entity.Respose.studentcertifi _cancel = Untity.HelperJson.DeserializeObject <Entity.Respose.studentcertifi>(postString);
Dal.MsSQL.T_StudentTicket.Delete(_cancel.TicketNum);
return("1");
}
else
{
error = "账号失效，请重新登陆";
return("-1");
}
}
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");
}
}
