//打印准考证考场科目信息 public static object getticketprintInfo(string _uid, string _pwd, string _ticketnum, ref string error) { Entity.Respose.getticketprintInfo result = new Entity.Respose.getticketprintInfo(); Entity.MsSQL.T_Organiza _orga = Dal.MsSQL.T_Organiza.GetModel(_uid, _pwd); result = Dal.MsSQL.T_StudentTicket.GetTicketPrintInfoModel(_ticketnum); return(result); }
public static object updateorganizapwd(string _uid, string _pwd, string postString, ref string error) { Entity.MsSQL.T_MarkUser _user = Dal.MsSQL.T_MarkUser.GetModel(_uid, _pwd); if (_user != null) { Entity.Request.handelorganiza _organiza = Untity.HelperJson.DeserializeObject <Entity.Request.handelorganiza>(postString); long _id = Untity.HelperDataCvt.strToLong(_organiza.ID); string _password = Untity.HelperDataCvt.objToString(_organiza.Password); if (!string.IsNullOrEmpty(_password)) { Entity.MsSQL.T_Organiza model = Dal.MsSQL.T_Organiza.GetModel(_id); if (model != null) { Dal.MsSQL.T_Organiza.UpdatePwd(_id, _password); return(1); } else { error = "用户不存在"; } } else { error = "密码不能为空"; } } else { error = "账号失效,请重新登陆"; } return(1); }
//获取座位 public static object getexamseatInfo(string _uid, string _pwd, string ExamRoomId, ref string error) { Entity.MsSQL.T_Organiza _orga = Dal.MsSQL.T_Organiza.GetModel(_uid, _pwd); List <Entity.Respose.getexamseatInfo> result = Dal.MsSQL.T_ExamSeat.GetExamseatInfoModel(ExamRoomId); return(result); }
//修改考场 public static object updateexamroom(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.addexamroom _examroom = Untity.HelperJson.DeserializeObject <Entity.Request.addexamroom>(postString); Entity.MsSQL.T_ExamRoom _model = new Entity.MsSQL.T_ExamRoom() { Id = _examroom.id, ExamName = Untity.HelperDataCvt.objToString(_examroom.ExamName), ExamPlace = Untity.HelperDataCvt.objToString(_examroom.ExamPlace), CentreName = Untity.HelperDataCvt.objToString(_examroom.CentreName), ExamNum = Untity.HelperDataCvt.objToString(_examroom.ExamNum), SeatNum = Untity.HelperDataCvt.objToString(_examroom.SeatNum), ResultReleaseTime = _examroom.ResultReleaseTime }; Dal.MsSQL.T_ExamRoom.Update(_model, postString).ToString(); return("1"); } else { error = "账号失效,请重新登陆"; return("-1"); } }
public static object updatestudent(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.addstudent _student = Untity.HelperJson.DeserializeObject <Entity.Request.addstudent>(postString); Entity.MsSQL.T_Student _model = new Entity.MsSQL.T_Student() { Id = Untity.HelperDataCvt.objToString(_student.idnumber), OrgaId = _orga.Id, Name = Untity.HelperDataCvt.objToString(_student.name), CardId = Untity.HelperDataCvt.objToString(_student.cardid), HeaderUrl = Untity.HelperDataCvt.objToString(_student.headerurl), Sex = Untity.HelperDataCvt.objToString(_student.sex), TelPhone = Untity.HelperDataCvt.objToString(_student.telphone), ProvinceId = Untity.HelperDataCvt.objToString(_student.provinceid), CityId = Untity.HelperDataCvt.objToString(_student.cityid), ZoneId = Untity.HelperDataCvt.objToString(_student.zoneid), Address = Untity.HelperDataCvt.objToString(_student.address), PostProvinceId = Untity.HelperDataCvt.objToString(_student.postprovinceid), PostCityId = Untity.HelperDataCvt.objToString(_student.postcityid), PostZoneId = Untity.HelperDataCvt.objToString(_student.postzoneid), PostAddress = Untity.HelperDataCvt.objToString(_student.postaddress) }; Dal.MsSQL.T_Student.Update(_model).ToString(); return("1"); } else { error = "账号失效,请重新登陆"; return("-1"); } }
//(座位添加准考证) public static object updateexamseat(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.addexamseat _examseat = Untity.HelperJson.DeserializeObject <Entity.Request.addexamseat>(postString); Entity.MsSQL.T_ExamSeat _model = new Entity.MsSQL.T_ExamSeat() { ExamRoomId = Untity.HelperDataCvt.objToString(_examseat.ExamRoomId), SeatNumber = Untity.HelperDataCvt.objToString(_examseat.SeatNumber), TicketId = Untity.HelperDataCvt.objToString(_examseat.TicketId) }; bool flag = Dal.MsSQL.T_ExamSeat.isSelect(_model); if (flag) { error = "考场座位号已绑定,不能再次绑定!"; return("-1"); } else { Dal.MsSQL.T_ExamSeat.Update(_model).ToString(); return("1"); } } else { error = "账号失效,请重新登陆"; return("-1"); } }
public static object getcertifiprint(string _uid, string _pwd, string _serialnum, ref string error) { Entity.Respose.getcertifiprint result = new Entity.Respose.getcertifiprint(); Entity.MsSQL.T_Organiza _orga = Dal.MsSQL.T_Organiza.GetModel(_uid, _pwd); result = Dal.MsSQL.T_StudentTicket.GetCertifiPrintModel(_serialnum); return(result); }
public static Entity.Respose.OLUserResponse getOLSchoolUserId(Entity.MsSQL.T_Organiza _orga, string _username, string _password) { Untity.HelperMethod p = new Untity.HelperMethod(); string path = HelperAppSet.getAppSetting("olschoolpath"); string fullpath = path + "/Member/GetUserId?classid=" + _orga.ClassId + "&UserName="******"&PWD=" + _password; string json = p.Get(fullpath); Entity.Respose.GTXResult result = Untity.HelperJson.DeserializeObject <Entity.Respose.GTXResult>(json); Entity.Respose.OLUserResponse rep = Untity.HelperJson.DeserializeObject <Entity.Respose.OLUserResponse>(Untity.HelperDataCvt.objToString(result.Data)); return(rep); }
public static object getStudent(string _uid, string _pwd, string _name, string _cardid, string page, string limit, ref long count, ref string error) { List <Entity.Respose.getstudent> result = new List <Entity.Respose.getstudent>(); Entity.MsSQL.T_Organiza _orga = Dal.MsSQL.T_Organiza.GetModel(_uid, _pwd); if (_orga != null) { result = ConvertStudentToResponse(Dal.MsSQL.T_Student.GetListByPage(_orga.Id, _name, _cardid, page, limit, ref count)); } return(result); }
//判断是否绑定座位 public static object isbountseat(string _uid, string _pwd, string _ticketnum, ref string error) { Entity.Respose.getexamseatInfo result = new Entity.Respose.getexamseatInfo(); Entity.MsSQL.T_Organiza _orga = Dal.MsSQL.T_Organiza.GetModel(_uid, _pwd); bool flag = Dal.MsSQL.T_ExamSeat.isSelectSeat(_ticketnum); if (flag) { return("0"); } return("-1"); }
public static object getscore(string _uid, string _pwd, string _ticketnum, string page, string limit, ref long count, ref string error) { Entity.MsSQL.T_Organiza _orga = Dal.MsSQL.T_Organiza.GetModel(_uid, _pwd); Entity.Respose.getscore result = new Entity.Respose.getscore(); if (_orga != null) { result.all = Dal.MsSQL.T_StudentTicket.GetListByTicketNum(_orga.Id, _ticketnum, page, limit, ref count); } else { error = "账号失效,请重新登陆"; } return(result); }
public static object wxlogin(string _classid, ref string uid, ref string pwd, ref string error) { Entity.MsSQL.T_Organiza _orga = Dal.MsSQL.T_Organiza.GetModel(_classid); if (_orga == null) { error = "机构尚未录入,请联系客服"; } else { uid = _orga.Name; pwd = _orga.Password; } return(1); }
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 deletestudent(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.addstudent _student = Untity.HelperJson.DeserializeObject <Entity.Request.addstudent>(postString); Dal.MsSQL.T_Student.Delete(Untity.HelperDataCvt.objToString(_student.idnumber)); return("1"); } else { error = "账号失效,请重新登陆"; return("-1"); } }
//删除考场 public static object deleteexamroom(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.addexamroom _examroom = Untity.HelperJson.DeserializeObject <Entity.Request.addexamroom>(postString); Dal.MsSQL.T_ExamRoom.Delete(Untity.HelperDataCvt.objToString(_examroom.id)); return("1"); } else { error = "账号失效,请重新登陆"; return("-1"); } }
public static object bangding(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.bangding _bangding = Untity.HelperJson.DeserializeObject <Entity.Request.bangding>(postString); Entity.MsSQL.T_Student _student = Dal.MsSQL.T_Student.GetModel(_bangding.studentid); if (_student != null) { //判定当前网校账号是否已经绑定现有学生账号 long olcount = Dal.MsSQL.T_Student.GetOLSchoolUserCount(_student.Id, _bangding.olschoolusername, Untity.HelperDataCvt.objToString(_orga.Id)); if (olcount > 0) { error = "此网校账号已经被其他学员绑定,无法绑定"; return(olcount); } //验证账号合法性 Entity.Respose.OLUserResponse oluser = Dal.MsSQL.T_Student.getOLSchoolUserId(_orga, _bangding.olschoolusername, _bangding.olschoolpwd); if (string.IsNullOrEmpty(oluser.id)) { error = oluser.msg + ",无法绑定"; return("-1"); } //第一次绑定或修改绑定 if (string.IsNullOrEmpty(_student.OLSchoolUserId) || Untity.HelperDataCvt.objToString(_student.OLSchoolUserId) != oluser.id) { Dal.MsSQL.T_Student.updateOLSchoolUserId(oluser.id, _bangding.olschoolusername, _bangding.olschoolpwd, _student.Id); } } else { error = "学员不存在,请核对信息是否正确"; } return("1"); } else { error = "账号失效,请重新登陆"; return("-1"); } }
public static bool IsBuyAll(Entity.MsSQL.T_Organiza _orga, string _ids, string _username, ref string error) { HelperMethod p = new HelperMethod(); //string path = HelperAppSet.getAppSetting("olschoolpath"); //string classid = HelperAppSet.getAppSetting("classid"); string path = HelperAppSet.getAppSetting("olschoolpath"); string fullpath = path + "/Member/IsBuyAll?classid=" + _orga.ClassId + "&UserName="******"&Ids=" + _ids; string json = p.Get(fullpath); Entity.Respose.GTXResult result = Untity.HelperJson.DeserializeObject <Entity.Respose.GTXResult>(json); if (HelperDataCvt.objToString(result.Data).Contains("未购买")) { error = HelperDataCvt.objToString(result.Data); return(false); } else { return(true); } }
/// <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 _uid, string _pwd, 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_Organiza _orga = Dal.MsSQL.T_Organiza.GetModel(_uid, _pwd); if (_orga == null) { error = "账号或者密码错误,请重新输入"; } } return(1); }
public static object Update(Entity.MsSQL.T_Organiza model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update T_Organiza set "); strSql.Append("Name=@Name,"); //strSql.Append("Password=@Password,"); strSql.Append("AppName=@AppName,"); strSql.Append("ClassId=@ClassId,"); strSql.Append("Path=@Path,"); strSql.Append("Describe=@Describe "); strSql.Append(" where Id=@Id"); SqlParameter[] parameters = { new SqlParameter("@Name", SqlDbType.VarChar, 200), //new SqlParameter("@Password", SqlDbType.VarChar,200), new SqlParameter("@AppName", SqlDbType.VarChar, 200), new SqlParameter("@ClassId", SqlDbType.NVarChar, 10), new SqlParameter("@Path", SqlDbType.VarChar, 200), new SqlParameter("@Describe", SqlDbType.VarChar, 2000), new SqlParameter("@Id", SqlDbType.BigInt) }; parameters[0].Value = model.Name; //parameters[1].Value = model.Password; parameters[1].Value = model.AppName; parameters[2].Value = model.ClassId; parameters[3].Value = model.Path; parameters[4].Value = model.Describe; parameters[5].Value = model.Id; int rows = Untity.HelperMsSQL.ExecuteQuery(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
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 addorganiza(string _uid, string _pwd, string postString, ref string error) { Entity.MsSQL.T_MarkUser _user = Dal.MsSQL.T_MarkUser.GetModel(_uid, _pwd); if (_user != null) { Entity.Request.handelorganiza _organiza = Untity.HelperJson.DeserializeObject <Entity.Request.handelorganiza>(postString); Entity.MsSQL.T_Organiza _model = new Entity.MsSQL.T_Organiza() { Name = Untity.HelperDataCvt.objToString(_organiza.Name), Password = Untity.HelperDataCvt.objToString(_organiza.Password), AppName = Untity.HelperDataCvt.objToString(_organiza.AppName), ClassId = Untity.HelperDataCvt.objToString(_organiza.ClassId), Path = Untity.HelperDataCvt.objToString(_organiza.Path), Describe = Untity.HelperDataCvt.objToString(_organiza.Describe) }; return(Dal.MsSQL.T_Organiza.Add(_model).ToString()); } else { error = "账号失效,请重新登陆"; return("-1"); } }
public static object Add(Entity.MsSQL.T_Organiza model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into T_Organiza("); strSql.Append("Name,Password,AppName,ClassId,Path,Describe)"); strSql.Append(" values ("); strSql.Append("@Name,@Password,@AppName,@ClassId,@Path,@Describe)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@Name", SqlDbType.VarChar, 200), new SqlParameter("@Password", SqlDbType.VarChar, 200), new SqlParameter("@AppName", SqlDbType.VarChar, 200), new SqlParameter("@ClassId", SqlDbType.NVarChar, 10), new SqlParameter("@Path", SqlDbType.VarChar, 200), new SqlParameter("@Describe", SqlDbType.VarChar, 2000) }; parameters[0].Value = model.Name; parameters[1].Value = model.Password; parameters[2].Value = model.AppName; parameters[3].Value = model.ClassId; parameters[4].Value = model.Path; parameters[5].Value = model.Describe; object obj = Untity.HelperMsSQL.ExecuteScalar(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt64(obj)); } }
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"); } }
/// <summary> /// 刷新用户信息 /// </summary> /// <param name="_examid"></param> /// <param name="_cardid"></param> /// <param name="error"></param> /// <returns></returns> public static object userinfo(string _uid, string _pwd, ref string error) { Entity.MsSQL.T_Organiza _orga = Dal.MsSQL.T_Organiza.GetModel(_uid, _pwd); return(_orga); }
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); }
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"); } }
public static object getStudentId(string _uid, string _pwd) { Entity.MsSQL.T_Organiza _orga = Dal.MsSQL.T_Organiza.GetModel(_uid, _pwd); return(string.Format("{0}{1}{2}", DateTime.Now.ToString("yyyyMMddHHmmss"), _orga == null ? 0 : _orga.Id, new Random().Next(10, 99))); }