//阅卷修改课程 public static object updatesubject(string _uid, string _pwd, string _path, string postString, ref string error) { Entity.MsSQL.T_MarkUser _user = Dal.MsSQL.T_MarkUser.GetModel(_uid, _pwd); if (_user != null) { Entity.Request.handelsubject _subject = Untity.HelperJson.DeserializeObject <Entity.Request.handelsubject>(postString); Entity.MsSQL.T_Subject _model = new Entity.MsSQL.T_Subject() { ID = Untity.HelperDataCvt.strToLong(_subject.ID), Name = _subject.Name, Category = _subject.Category, Price = _subject.Price, Describe = _subject.Describe, OLSchoolId = _subject.OLSchoolId, OLSchoolAOMid = _subject.OLSchoolAOMid, OLSchoolCourseId = _subject.OLSchoolCourseId, OLSchoolMasterTypeId = _subject.OLSchoolMasterTypeId, OLSchoolName = _subject.OLSchoolName, OLSchoolProvinceId = _subject.OLSchoolProvinceId, OLSchoolQuestionNum = _subject.OLSchoolQuestionNum, OLAccCourseId = getAccCourseId(_subject.OLSchoolId, _path), OLPaperID = _subject.OLPaperID }; return(Dal.MsSQL.T_Subject.Update(_model).ToString()); } else { error = "账号失效,请重新登陆"; return("-1"); } }
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 long Add(Entity.MsSQL.T_Subject model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into T_Subject("); strSql.Append("Name,Category,Price,Describe,OLSchoolId,OLSchoolName,OLSchoolProvinceId,OLSchoolCourseId,OLSchoolQuestionNum,OLSchoolAOMid,OLSchoolMasterTypeId,OLAccCourseId,OLPaperID)"); strSql.Append(" values ("); strSql.Append("@Name,@Category,@Price,@Describe,@OLSchoolId,@OLSchoolName,@OLSchoolProvinceId,@OLSchoolCourseId,@OLSchoolQuestionNum,@OLSchoolAOMid,@OLSchoolMasterTypeId,@OLAccCourseId,@OLPaperID)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@Name", SqlDbType.NVarChar, 200), new SqlParameter("@Category", SqlDbType.NVarChar, 200), new SqlParameter("@Price", SqlDbType.VarChar, 50), new SqlParameter("@Describe", SqlDbType.NVarChar, 500), new SqlParameter("@OLSchoolId", SqlDbType.NVarChar, 100), new SqlParameter("@OLSchoolName", SqlDbType.NVarChar, 200), new SqlParameter("@OLSchoolProvinceId", SqlDbType.VarChar, 10), new SqlParameter("@OLSchoolCourseId", SqlDbType.VarChar, 10), new SqlParameter("@OLSchoolQuestionNum", SqlDbType.VarChar, 10), new SqlParameter("@OLSchoolAOMid", SqlDbType.VarChar, 10), new SqlParameter("@OLSchoolMasterTypeId", SqlDbType.VarChar, 10), new SqlParameter("@OLAccCourseId", SqlDbType.VarChar, 10), new SqlParameter("@OLPaperID", SqlDbType.VarChar, 50) }; parameters[0].Value = model.Name; parameters[1].Value = model.Category; parameters[2].Value = model.Price; parameters[3].Value = model.Describe; parameters[4].Value = model.OLSchoolId; parameters[5].Value = model.OLSchoolName; parameters[6].Value = model.OLSchoolProvinceId; parameters[7].Value = model.OLSchoolCourseId; parameters[8].Value = model.OLSchoolQuestionNum; parameters[9].Value = model.OLSchoolAOMid; parameters[10].Value = model.OLSchoolMasterTypeId; parameters[11].Value = model.OLAccCourseId; parameters[12].Value = model.OLPaperID; object obj = Untity.HelperMsSQL.ExecuteScalar(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt64(obj)); } }
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 bool Update(Entity.MsSQL.T_Subject model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update T_Subject set "); strSql.Append("Name=@Name,"); strSql.Append("Category=@Category,"); strSql.Append("Price=@Price,"); strSql.Append("Describe=@Describe,"); strSql.Append("OLSchoolId=@OLSchoolId,"); strSql.Append("OLSchoolName=@OLSchoolName,"); strSql.Append("OLSchoolProvinceId=@OLSchoolProvinceId,"); strSql.Append("OLSchoolCourseId=@OLSchoolCourseId,"); strSql.Append("OLSchoolQuestionNum=@OLSchoolQuestionNum,"); strSql.Append("OLSchoolAOMid=@OLSchoolAOMid,"); strSql.Append("OLSchoolMasterTypeId=@OLSchoolMasterTypeId,"); strSql.Append("OLAccCourseId=@OLAccCourseId,"); strSql.Append("OLPaperID=@OLPaperID,"); strSql.Append("IsDel=@IsDel "); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@Name", SqlDbType.NVarChar, 200), new SqlParameter("@Category", SqlDbType.NVarChar, 200), new SqlParameter("@Price", SqlDbType.VarChar, 50), new SqlParameter("@Describe", SqlDbType.NVarChar, 500), new SqlParameter("@OLSchoolId", SqlDbType.NVarChar, 100), new SqlParameter("@OLSchoolName", SqlDbType.NVarChar, 200), new SqlParameter("@OLSchoolProvinceId", SqlDbType.VarChar, 10), new SqlParameter("@OLSchoolCourseId", SqlDbType.VarChar, 10), new SqlParameter("@OLSchoolQuestionNum", SqlDbType.VarChar, 10), new SqlParameter("@OLSchoolAOMid", SqlDbType.VarChar, 10), new SqlParameter("@OLSchoolMasterTypeId", SqlDbType.VarChar, 10), new SqlParameter("@OLAccCourseId", SqlDbType.VarChar, 10), new SqlParameter("@OLPaperID", SqlDbType.VarChar, 50), new SqlParameter("@IsDel", SqlDbType.Char, 1), new SqlParameter("@ID", SqlDbType.BigInt, 8) }; parameters[0].Value = model.Name; parameters[1].Value = model.Category; parameters[2].Value = model.Price; parameters[3].Value = model.Describe; parameters[4].Value = model.OLSchoolId; parameters[5].Value = model.OLSchoolName; parameters[6].Value = model.OLSchoolProvinceId; parameters[7].Value = model.OLSchoolCourseId; parameters[8].Value = model.OLSchoolQuestionNum; parameters[9].Value = model.OLSchoolAOMid; parameters[10].Value = model.OLSchoolMasterTypeId; parameters[11].Value = model.OLAccCourseId; parameters[12].Value = model.OLPaperID; parameters[13].Value = 0; parameters[14].Value = model.ID; int rows = Untity.HelperMsSQL.ExecuteQuery(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }