/// <summary>
/// 登陆
/// </summary>
/// <param name="_examid"></param>
/// <param name="_cardid"></param>
/// <param name="_vcode"></param>
/// <param name="_vcodeCookie"></param>
/// <param name="error"></param>
/// <returns></returns>
public static object login(string _examid, string _cardid, string _vcode, string _vcodeCookie, ref string error)
{
if (string.IsNullOrEmpty(_vcodeCookie))
{
error = "验证码已失效";
}
else if (_vcodeCookie != Untity.HelperSecurity.MD5(_vcode.ToLower()))
{
error = "验证码错误";
}
else
{
Entity.MsSQL.T_Student _student = Dal.MsSQL.T_Student.GetModelByCardId(_cardid);
if (_student == null)
{
error = "系统不存在该身份证";
}
else
{
List <Entity.MsSQL.T_StudentTicket> _tickets = Dal.MsSQL.T_StudentTicket.GetList(_student.Id.ToString());
Entity.MsSQL.T_StudentTicket _ticket = _tickets.Where(ii => ii.TicketNum == _examid).FirstOrDefault();
if (_ticket == null)
{
error = "系统不存在该准考证";
}
}
}
return(1);
}
public static long Add(Entity.MsSQL.T_StudentTicket model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into T_StudentTicket(");
strSql.Append("CertificateId,OrgaizId,StudentId,TicketNum,OLMobile)");
strSql.Append(" values (");
strSql.Append("@CertificateId,@OrgaizId,@StudentId,@TicketNum,@OLMobile)");
SqlParameter[] parameters =
{
new SqlParameter("@CertificateId", SqlDbType.VarChar, 100),
new SqlParameter("@OrgaizId", SqlDbType.BigInt, 8),
new SqlParameter("@StudentId", SqlDbType.VarChar, 100),
new SqlParameter("@TicketNum", SqlDbType.VarChar, 100),
new SqlParameter("@OLMobile", SqlDbType.VarChar, 20),
};
parameters[0].Value = model.CertificateId;
parameters[1].Value = model.OrgaizId;
parameters[2].Value = model.StudentId;
parameters[3].Value = model.TicketNum;
parameters[4].Value = model.OLMobile;
object obj = Untity.HelperMsSQL.ExecuteScalar(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt64(obj));
}
}
/// <summary>
/// 刷新用户信息
/// </summary>
/// <param name="_examid"></param>
/// <param name="_cardid"></param>
/// <param name="error"></param>
/// <returns></returns>
public static object userinfo(string _examid, string _cardid, ref string error)
{
//return new Entity.Respose.UserInfo();
Entity.MsSQL.T_Student _student = Dal.MsSQL.T_Student.GetModelByCardId(_cardid);
if (_student == null)
{
error = "系统不存在该身份证";
return(null);
}
List <Entity.MsSQL.T_StudentTicket> _tickets = Dal.MsSQL.T_StudentTicket.GetList(_student.Id.ToString());
Entity.MsSQL.T_StudentTicket _ticket = _tickets.Where(ii => ii.TicketNum == _examid).FirstOrDefault();
if (_ticket == null)
{
error = "系统不存在该准考证";
return(null);
}
List <Entity.MsSQL.T_CertifiSubject> _AllCertSubjects = Dal.MsSQL.T_CertifiSubject.GetList();
List <Entity.MsSQL.T_CertifiSubject> _CertSubjects = _AllCertSubjects.Where(ii => ii.CertificateId == _ticket.CertificateId).ToList();
string _subjectids = "";
foreach (var _CertSubject in _CertSubjects)
{
if (Untity.HelperDataCvt.strToIni(_CertSubject.IsNeedExam, 0) <= 0)
{
continue;
}
_subjectids += string.Format("'{0}',", _CertSubject.SubjectId);
}
if (_subjectids.Length > 0)
{
_subjectids = _subjectids.Substring(0, _subjectids.Length - 1);
}
List <Entity.MsSQL.T_Subject> _subjects = Dal.MsSQL.T_Subject.GetList(_subjectids);
if (_subjects.Count == 0)
{
error = "无考试科目，请联系管理员确认";
return(null);
}
Entity.Respose.UserInfo result = new Entity.Respose.UserInfo()
{
studentname = _student.Name,
certifiid = _ticket.CertificateId,
};
foreach (var item in _subjects)
{
result.subjects.Add(new Entity.Respose.SubjectInfo()
{
subjectid = item.ID.ToString(),
name = item.Name
});
}
return(result);
}
public static object updatestateto2(string _examid, ref string error)
{
Entity.MsSQL.T_StudentTicket _ticket = Dal.MsSQL.T_StudentTicket.GetModel(_examid);
if (_ticket == null)
{
error = "系统不存在该准考证";
return(null);
}
Dal.MsSQL.T_StudentTicket.updatestateto2(_examid);
return("1");
}
public static object getSubjectsByTicket(string _uid, string _pwd, string id, ref string error)
{
Entity.MsSQL.T_Organiza _orga = Dal.MsSQL.T_Organiza.GetModel(_uid, _pwd);
var result = new object();
if (_orga != null)
{
Entity.MsSQL.T_StudentTicket _stmodel = Dal.MsSQL.T_StudentTicket.GetModel(id);
Entity.MsSQL.T_Student _stumodel = Dal.MsSQL.T_Student.GetModel(_stmodel.StudentId);
Entity.MsSQL.T_Organiza _orgmodel = Dal.MsSQL.T_Organiza.GetModel(_stmodel.OrgaizId);
List <Entity.Respose.allcertifisubject> _certifisubjectlist = Dal.MsSQL.T_CertifiSubject.GetAllListByCertId(_stmodel.CertificateId);
_certifisubjectlist = _certifisubjectlist.Where(a => a.Category == SubjectCategory.视频 || a.Category == SubjectCategory.题库).ToList();
List <Entity.Respose.normalscore> _nslist = Dal.MsSQL.T_StudentSubjectScore.getnormalscore(_certifisubjectlist, _orgmodel.ClassId, _stumodel.OLSchoolUserId, id);
result = _nslist;
}
else
{
error = "账号失效，请重新登陆";
}
return(result);
}
public static object subjectinfo(string _examid, string _cardid, string postString, ref string error)
{
Entity.MsSQL.T_Student _student = Dal.MsSQL.T_Student.GetModelByCardId(_cardid);
if (_student == null)
{
error = "系统不存在该身份证";
return(null);
}
List <Entity.MsSQL.T_StudentTicket> _tickets = Dal.MsSQL.T_StudentTicket.GetList(_student.Id.ToString());
Entity.MsSQL.T_StudentTicket _ticket = _tickets.Where(ii => ii.TicketNum == _examid).FirstOrDefault();
if (_ticket == null)
{
error = "系统不存在该准考证";
return(null);
}
Entity.Request.ExamSubjectInfo subjectinfo = Untity.HelperJson.DeserializeObject <Entity.Request.ExamSubjectInfo>(postString);
long _certifiid = Untity.HelperDataCvt.strToLong(subjectinfo.certifiid);
long _subjectid = Untity.HelperDataCvt.strToLong(subjectinfo.subjectid);
bool _iswinopen = false;
string _url = "";
Entity.MsSQL.T_Subject _subject = Dal.MsSQL.T_Subject.GetModel(_subjectid);
if (_subject == null)
{
error = "系统不存在该科目";
return(null);
}
Entity.Respose.ExamSubjectInfo result = new Entity.Respose.ExamSubjectInfo();
result.certifiid = _certifiid.ToString();
result.subjectid = _subjectid.ToString();
result.subjectname = _subject.Name;
result.url = _url;
result.iswinopen = _iswinopen;
return(result);
}
public static object getscoredetail(string _ticketid, string _OLSchoolUserId, ref string error)
{
Entity.Respose.getscoredetail result = new Entity.Respose.getscoredetail();
Entity.MsSQL.T_StudentTicket ticketmodel = Dal.MsSQL.T_StudentTicket.GetModel(_ticketid);
if (ticketmodel != null)
{
Entity.MsSQL.T_Student _st = Dal.MsSQL.T_Student.GetModelByOLSchoolUserId(_OLSchoolUserId);
Entity.MsSQL.T_Organiza _org = Dal.MsSQL.T_Organiza.GetModel(_st.OrgaId);
List <Entity.Respose.allcertifisubject> _certifisubjectlist = Dal.MsSQL.T_CertifiSubject.GetAllListByCertId(ticketmodel.CertificateId);
Entity.MsSQL.T_Certificate certifimodel = Dal.MsSQL.T_Certificate.GetModel(Untity.HelperDataCvt.strToIni(ticketmodel.CertificateId));
//获取网校课程得分情况并计算得分情况
List <Entity.Respose.scoredetail> _olscoredetail = Dal.MsSQL.T_StudentSubjectScore.getscore(_certifisubjectlist, _org.ClassId, _OLSchoolUserId, _ticketid);
//计算视频平均平时成绩
decimal videoNormalScore = 0;
decimal videoNormalAverageScore = 0;
string _accountform = "（";
var videoscoredetail = _olscoredetail.Where(a => a.Category == SubjectCategory.视频 || a.Category == SubjectCategory.题库)
.Select(b =>
{
videoNormalScore += decimal.Parse(b.NormalScore);
_accountform += b.Name + "平时成绩+";
return(b);
}).ToList();
if (videoscoredetail.Count() > 0)
{
videoNormalAverageScore = videoNormalScore / videoscoredetail.Count();
_accountform = _accountform.TrimEnd('+');
_accountform += "）/ " + videoscoredetail.Count() + " * " + certifimodel.NormalResult + "% + ";
}
else
{
_accountform = _accountform.Substring(0, _accountform.Length - 1);
_accountform += "0 * " + certifimodel.NormalResult + "% + ";
}
//计算考试科目平均成绩
decimal examScore = 0;
decimal examAverageScore = 0;
_accountform += "（";
var notvideoscoredetail = _olscoredetail.Where(a => a.Category != SubjectCategory.视频)
.Select(b =>
{
examScore += decimal.Parse(b.ExamScore);
_accountform += b.Name + "考试成绩+";
return(b);
}).ToList();
if (notvideoscoredetail.Count() > 0)
{
examAverageScore = examScore / notvideoscoredetail.Count();
_accountform = _accountform.TrimEnd('+');
_accountform += "）/ " + notvideoscoredetail.Count() + " * " + certifimodel.ExamResult + "%";
}
else
{
_accountform = _accountform.Substring(0, _accountform.Length - 1);
_accountform += "0 * " + certifimodel.ExamResult + "%";
}
//总得分，平时，考试
double _scoresum = 0;
double _normalsum = 0;
double _examsum = 0;
foreach (Entity.Respose.scoredetail item in _olscoredetail)
{
item.Category = _certifisubjectlist.Where(i => i.OLSchoolAOMid == item.AOMid).FirstOrDefault().Category;
item.Name = _certifisubjectlist.Where(i => i.OLSchoolAOMid == item.AOMid).FirstOrDefault().Name;
item.NormalResult = _certifisubjectlist.Where(i => i.OLSchoolAOMid == item.AOMid).FirstOrDefault().NormalResult;
item.ExamResult = _certifisubjectlist.Where(i => i.OLSchoolAOMid == item.AOMid).FirstOrDefault().ExamResult;
_normalsum += Untity.HelperDataCvt.strToDouble(item.NormalScore) * Untity.HelperDataCvt.strToDouble(item.NormalResult) / 100;
_examsum += Untity.HelperDataCvt.strToDouble(item.ExamScore) * Untity.HelperDataCvt.strToDouble(item.ExamResult) / 100;
}
_scoresum = (_normalsum * Untity.HelperDataCvt.strToDouble(certifimodel.NormalResult) / 100 +
_examsum * Untity.HelperDataCvt.strToDouble(certifimodel.ExamResult) / 100);
result.all = _olscoredetail;
//esult.scoresum = Math.Round(_scoresum, 2).ToString();
result.accountform = _accountform;
decimal score = 0M;
score = int.Parse(certifimodel.NormalResult) / 100M * videoNormalAverageScore + int.Parse(certifimodel.ExamResult) / 100M * examAverageScore;
result.scoresum = Math.Round(score, 2).ToString();
}
else
{
error = "证书有异常，无法查询";
return("-1");
}
return(result);
}
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 signup(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.Request.signup _signup = Untity.HelperJson.DeserializeObject <Entity.Request.signup>(postString);
Entity.MsSQL.T_Student _student = Dal.MsSQL.T_Student.GetModel(_signup.studentid);
if (_student != null)
{
//判断当前证书是否已经报名
long tccount = Dal.MsSQL.T_StudentTicket.GetTicketCount(_student.Id, _signup.certificateid.ToString());
if (tccount > 0)
{
error = "已报名，请误重复报名";
return(tccount);
}
//验证账号合法性
if (string.IsNullOrEmpty(_student.OLSchoolUserId))
{
error = "尚未绑定网校账号，无法报名";
return("-1");
}
//判断当前课程是否全部购买
Entity.MsSQL.T_Certificate _certificate = Dal.MsSQL.T_Certificate.GetModel(_signup.certificateid);
if (_certificate != null)
{
List <Entity.Respose.allcertifisubject> _sublist = new List <Entity.Respose.allcertifisubject>();
_sublist = Dal.MsSQL.T_CertifiSubject.GetAllListByCertId(Untity.HelperDataCvt.objToString(_certificate.Id));
if (_sublist.Count == 0)
{
error = "证书没有配置课程，无法报名";
return("-1");
}
////判断网校课程是否已购买
//string ids = string.Join(",", _sublist.Select(ii => ii.OLSchoolAOMid.ToString()).ToList());
//if (ids != "" && !(Dal.MsSQL.T_Subject.IsBuyAll(_orga, ids, _student.OLSchoolUserName, ref error)))
//{
// error = error + ",无法报名";
// return "-1";
//}
//HttpResponseResult result = OrganizaRepository.Singleton.OpenLearningSystemCertificate(_student.OLSchoolUserName, _student.OLSchoolPWD, _certificate);
//if (result.isSuccess == false)
//{
// error = "开通学习平台账号失败，" + result.Message;
// return "-1";
//}
//JObject olsc = JsonConvert.DeserializeObject<JObject>(result.Data);
//if (JToken.DeepEquals(olsc["code"], 1))
//{
// error = "开通学习平台账号失败，" + olsc["msg"];
// return "-1";
//}
Entity.MsSQL.T_StudentTicket _model = new Entity.MsSQL.T_StudentTicket()
{
CertificateId = _signup.certificateid.ToString(),
OrgaizId = _orga.Id,
StudentId = _student.Id,
TicketNum = getZKH(Untity.HelperDataCvt.objToString(_orga.Id)).ToString(),
OLMobile = ""
};
return(Dal.MsSQL.T_StudentTicket.Add(_model).ToString());
}
else
{
error = "证书不存在，请核对信息是否正确";
}
}
else
{
error = "学员不存在，请核对信息是否正确";
}
return("1");
}
else
{
error = "账号失效，请重新登陆";
return("-1");
}
}
