//打印准考证考场科目信息
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)));
}
