//阅卷修改课程
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);
}
}
