/// <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"); } }