public ActionResult Index()
{
IList <ExamEntity> exams = new List <ExamEntity>();
exams = ExamBll.GetInstance().GetExamList();
return(View(exams));
}
// Token: 0x0600009B RID: 155 RVA: 0x0000EE9C File Offset: 0x0000D09C
protected override void View()
{
this.channelinfo = ChannelBll.GetChannelInfo("exam_question");
if (this.channelinfo.id == 0)
{
this.ShowErr("对不起，目前系统尚未创建题目库频道。");
}
else
{
this.examresultlist = ExamBll.GetExamResultList(this.channelinfo.id, this.userid);
}
}
// Token: 0x060000CE RID: 206 RVA: 0x0001462C File Offset: 0x0001282C
protected override void View()
{
this.channelinfo = ChannelBll.GetChannelInfo("exam_question");
if (this.channelinfo.id == 0)
{
this.ShowErr("对不起，目前系统尚未创建题目库频道。");
}
else
{
string commandText = string.Format("SELECT SUM([curfavs]) AS [total] FROM [{0}Exam_ExamLogInfo] WHERE [channelid]={1} AND [uid]={2}", DbConfigs.Prefix, this.channelinfo.id, this.userid);
this.total = FPUtils.StrToInt(DbHelper.ExecuteScalar(commandText));
this.userexamlog = ExamBll.GetExamLogList(this.channelinfo.id, this.userid);
List <SortAppInfo> sortAppList = SortBll.GetSortAppList("exam_");
foreach (SortAppInfo sortAppInfo in sortAppList)
{
if (this.sortappidlist != "")
{
this.sortappidlist += ",";
}
this.sortappidlist += sortAppInfo.id;
}
SqlParam[] sqlparams = new SqlParam[]
{
DbHelper.MakeAndWhere("parentid", 0),
DbHelper.MakeAndWhere("channelid", this.channelinfo.id),
DbHelper.MakeAndWhere("appid", WhereType.In, this.sortappidlist),
DbHelper.MakeAndWhere("hidden", 0)
};
OrderByParam orderby = DbHelper.MakeOrderBy("display", OrderBy.ASC);
List <SortInfo> list = DbHelper.ExecuteList <SortInfo>(orderby, sqlparams);
foreach (SortInfo sortInfo in list)
{
ExamLogInfo examLogInfo;
if (this.userexamlog.ContainsKey(sortInfo.id))
{
examLogInfo = this.userexamlog[sortInfo.id];
}
else
{
examLogInfo = new ExamLogInfo();
}
examLogInfo.sortid = sortInfo.id;
examLogInfo.sortname = sortInfo.name;
examLogInfo.questions = sortInfo.posts;
examLogInfo.subcounts = sortInfo.subcounts;
this.examloglist.Add(examLogInfo);
}
}
}
// Token: 0x060000B2 RID: 178 RVA: 0x000117F4 File Offset: 0x0000F9F4
protected override void View()
{
if (!this.isperm)
{
this.ShowErr("对不起，您没有权限阅卷。");
}
else
{
this.examresult = DbHelper.ExecuteModel <ExamResult>(this.resultid);
if (this.examresult.id == 0)
{
this.ShowErr("该考生的试卷不存在或已被删除。");
}
else
{
this.examloglist = ExamBll.GetExamLogList(this.examresult.channelid, this.userid);
string commandText = string.Format("SELECT MAX([score]) AS [maxscore] FROM [{0}Exam_ExamResult] WHERE [id]={1}", DbConfigs.Prefix, this.resultid);
this.maxscore = Math.Round((double)FPUtils.StrToFloat(DbHelper.ExecuteScalar(commandText).ToString(), 0f), 1);
if (this.maxscore > this.examresult.total)
{
this.maxscore = this.examresult.total;
}
commandText = string.Format("SELECT AVG([score]) AS [avgscore] FROM [{0}Exam_ExamResult] WHERE [id]={1}", DbConfigs.Prefix, this.resultid);
this.avgscore = Math.Round((double)FPUtils.StrToFloat(DbHelper.ExecuteScalar(commandText).ToString(), 0f), 1);
SqlParam sqlParam = DbHelper.MakeAndWhere("examid", this.examresult.examid);
this.testers = DbHelper.ExecuteCount <ExamResult>(new SqlParam[]
{
sqlParam
});
commandText = string.Format("SELECT COUNT(*) FROM [{0}Exam_ExamResult] WHERE [examid]={1} AND [score]>{2}", DbConfigs.Prefix, this.examresult.examid, this.examresult.score);
if (this.examresult.score > 0.0)
{
this.display = FPUtils.StrToInt(DbHelper.ExecuteScalar(commandText).ToString(), 0) + 1;
}
this.examtopicresultlist = ExamBll.GetExamResultTopicList(this.resultid);
}
}
}
// Token: 0x0600004C RID: 76 RVA: 0x000080D4 File Offset: 0x000062D4
protected override void View()
{
this.examconfig = ExamConifgs.GetExamConfig();
this.examinfo = DbHelper.ExecuteModel <ExamInfo>(this.examid);
if (this.examinfo.id == 0)
{
this.ShowErr("对不起，该试卷不存在或已被删除。");
}
else
{
this.sortid = this.examinfo.sortid;
this.sortinfo = SortBll.GetSortInfo(this.sortid);
if (this.ispost)
{
string @string = FPRequest.GetString("action");
int @int = FPRequest.GetInt("examtopicid");
int int2 = FPRequest.GetInt("tid");
ExamTopic examTopic = DbHelper.ExecuteModel <ExamTopic>(@int);
if (@string == "delete")
{
DbHelper.ExecuteDelete <ExamTopic>(@int);
if (this.paper == 1)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.AppendFormat("UPDATE [{0}Exam_ExamInfo] SET [total]=[total]-{1},[questions]=[questions]-{2} WHERE [id]={3}", new object[]
{
DbConfigs.Prefix,
examTopic.perscore * (double)examTopic.questions,
examTopic.questions,
this.examid
});
DbHelper.ExecuteSql(stringBuilder.ToString());
}
}
else if (@string == "addpaper")
{
if (this.examinfo.papers == 4)
{
this.ShowErr("对不起，一场考试最多只能添加4份试卷。");
return;
}
string text = string.Format("UPDATE [{0}Exam_ExamInfo] SET [papers]=[papers]+1 WHERE [id]={1}", DbConfigs.Prefix, this.examid);
DbHelper.ExecuteSql(text);
this.paper = this.examinfo.papers + 1;
}
else if (@string == "delpaper")
{
if (this.examinfo.papers == 1)
{
this.ShowErr("对不起，一场考试必须有一份试卷。");
return;
}
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.AppendFormat("UPDATE [{0}Exam_ExamInfo] SET [papers]=[papers]-1 WHERE [id]={1}", DbConfigs.Prefix, this.examid);
stringBuilder.AppendFormat("DELETE FROM [{0}Exam_ExamTopic] WHERE [examid]={1} AND [paper]={2}", DbConfigs.Prefix, this.examid, this.paper);
stringBuilder.AppendFormat("UPDATE [{0}Exam_ExamTopic] SET [paper]=[paper]-1 WHERE [examid]={1} AND [paper]>{2}", DbConfigs.Prefix, this.examid, this.paper);
DbHelper.ExecuteSql(stringBuilder.ToString());
this.examinfo.papers = this.examinfo.papers - 1;
if (this.paper > this.examinfo.papers)
{
this.paper = this.examinfo.papers;
}
List <ExamTopic> examTopicList = ExamBll.GetExamTopicList(this.examid, 1);
double num = 0.0;
int num2 = 0;
foreach (ExamTopic examTopic2 in examTopicList)
{
num += examTopic2.perscore * (double)examTopic2.questions;
num2 += examTopic2.questions;
}
string sqlstring = string.Format("UPDATE [{0}Exam_ExamInfo] SET [questions]={1},[total]={2} WHERE [id]={3}", new object[]
{
DbConfigs.Prefix,
num2,
num,
this.examid
});
DbHelper.ExecuteSql(sqlstring);
}
else if (@string == "saveas")
{
if (this.examinfo.papers == 4)
{
this.ShowErr("对不起，一场考试最多只能添加4份试卷。");
return;
}
string text = string.Format("UPDATE [{0}Exam_ExamInfo] SET [papers]=[papers]+1 WHERE [id]={1}", DbConfigs.Prefix, this.examid);
DbHelper.ExecuteSql(text);
this.examtopiclist = ExamBll.GetExamTopicList(this.examid, this.paper);
this.examinfo.papers = this.examinfo.papers + 1;
for (int i = 0; i < this.examtopiclist.Count; i++)
{
this.examtopiclist[i].paper = this.examinfo.papers;
DbHelper.ExecuteInsert <ExamTopic>(this.examtopiclist[i]);
}
}
else if (@string == "deletetopic")
{
string text2 = "";
foreach (int num3 in FPUtils.SplitInt(examTopic.questionlist))
{
if (int2 != num3 && num3 > 0)
{
if (text2 != "")
{
text2 += ",";
}
text2 += num3;
}
}
examTopic.questionlist = text2;
if (examTopic.questionlist.Length > 0)
{
examTopic.curquestions = FPUtils.SplitInt(examTopic.questionlist).Length;
}
else
{
examTopic.curquestions = 0;
}
SqlParam[] sqlparams = new SqlParam[]
{
DbHelper.MakeSet("questionlist", examTopic.questionlist),
DbHelper.MakeSet("curquestions", examTopic.curquestions),
DbHelper.MakeAndWhere("id", @int)
};
DbHelper.ExecuteUpdate <ExamTopic>(sqlparams);
}
else if (@string == "display")
{
this.examtopiclist = ExamBll.GetExamTopicList(this.examid, this.paper);
string text = "";
foreach (ExamTopic examTopic3 in this.examtopiclist)
{
DataTable dataTable = new DataTable();
dataTable.Columns.Add("display", typeof(int));
dataTable.Columns.Add("qid", typeof(int));
foreach (int num4 in FPUtils.SplitInt(examTopic3.questionlist))
{
DataRow dataRow = dataTable.NewRow();
dataRow["display"] = FPRequest.GetInt("display_" + num4);
dataRow["qid"] = num4;
dataTable.Rows.Add(dataRow);
}
string text3 = "";
foreach (DataRow dataRow2 in dataTable.Select("1=1", "display asc"))
{
if (text3 != "")
{
text3 += ",";
}
text3 += dataRow2["qid"].ToString();
}
if (text != "")
{
text += "|";
}
text += string.Format("UPDATE [{0}Exam_ExamTopic] SET [questionlist]='{1}' WHERE [id]={2}", DbConfigs.Prefix, text3, examTopic3.id);
}
DbHelper.ExecuteSql(text);
}
base.Response.Redirect(this.pagename + string.Format("?examid={0}&paper={1}&examtopicid={2}", this.examid, this.paper, @int));
}
this.examtopiclist = ExamBll.GetExamTopicList(this.examid, this.paper);
SqlParam[] sqlparams2 = new SqlParam[]
{
DbHelper.MakeAndWhere("examid", this.examid),
DbHelper.MakeAndWhere("paper", this.paper)
};
this.examinfo.questions = FPUtils.StrToInt(DbHelper.ExecuteSum <ExamTopic>("questions", sqlparams2));
base.SaveRightURL();
}
}
// Token: 0x0600003D RID: 61 RVA: 0x000059E8 File Offset: 0x00003BE8
protected override void View()
{
this.sortinfo = SortBll.GetSortInfo(this.sortid);
if (this.sortinfo.id == 0)
{
this.ShowErr("对不起，该试卷库不存在或已被删除。");
}
else
{
if (this.channelid == 0)
{
this.channelid = this.sortinfo.channelid;
}
if (this.ispost)
{
string @string = FPRequest.GetString("chkid");
if (this.action == "delete")
{
string examSorts = ExamBll.GetExamSorts(@string);
SortBll.UpdateSortPosts(examSorts, -1);
DbHelper.ExecuteDelete <ExamInfo>(@string);
SqlParam sqlParam = DbHelper.MakeAndWhere("examid", WhereType.In, @string);
DbHelper.ExecuteDelete <ExamTopic>(new SqlParam[]
{
sqlParam
});
}
else if (this.action == "sum")
{
SqlParam sqlParam2 = DbHelper.MakeAndWhere("id", WhereType.In, @string);
List <ExamInfo> list = DbHelper.ExecuteList <ExamInfo>(new SqlParam[]
{
sqlParam2
});
string text = "";
foreach (ExamInfo examInfo in list)
{
int num = 0;
double num2 = 0.0;
if (examInfo.examdeparts == "" && examInfo.examuser == "" && examInfo.examroles == "")
{
SqlParam sqlParam3 = DbHelper.MakeAndWhere("examid", examInfo.id);
num = DbHelper.ExecuteCount <ExamResult>(new SqlParam[]
{
sqlParam3
});
num2 = FPUtils.StrToDouble(DbHelper.ExecuteSum <ExamResult>("score", new SqlParam[]
{
sqlParam3
}));
}
else
{
string text2 = "";
if (examInfo.examroles != "")
{
SqlParam sqlParam4 = DbHelper.MakeAndWhere("roleid", WhereType.In, examInfo.examroles);
List <UserInfo> list2 = DbHelper.ExecuteList <UserInfo>(new SqlParam[]
{
sqlParam4
});
foreach (UserInfo userInfo in list2)
{
if (!FPUtils.InArray(userInfo.id, text2))
{
if (text2 != "")
{
text2 += ",";
}
text2 += userInfo.id;
num++;
}
}
}
if (examInfo.examdeparts != "")
{
SqlParam sqlParam4 = DbHelper.MakeAndWhere("departid", WhereType.In, examInfo.examdeparts);
List <UserInfo> list2 = DbHelper.ExecuteList <UserInfo>(new SqlParam[]
{
sqlParam4
});
foreach (UserInfo userInfo in list2)
{
if (!FPUtils.InArray(userInfo.id, text2))
{
if (text2 != "")
{
text2 += ",";
}
text2 += userInfo.id;
num++;
}
}
}
if (examInfo.examuser != "")
{
SqlParam sqlParam4 = DbHelper.MakeAndWhere("id", WhereType.In, examInfo.examuser);
List <UserInfo> list2 = DbHelper.ExecuteList <UserInfo>(new SqlParam[]
{
sqlParam4
});
foreach (UserInfo userInfo in list2)
{
if (!FPUtils.InArray(userInfo.id, text2))
{
if (text2 != "")
{
text2 += ",";
}
text2 += userInfo.id;
num++;
}
}
}
string sqlstring = string.Format("DELETE FROM [{0}Exam_ExamResult] WHERE [examid]={1} AND [uid] NOT IN({2})", DbConfigs.Prefix, examInfo.id, text2);
DbHelper.ExecuteSql(sqlstring);
SqlParam[] sqlparams = new SqlParam[]
{
DbHelper.MakeAndWhere("examid", examInfo.id),
DbHelper.MakeAndWhere("uid", WhereType.In, text2)
};
num2 = FPUtils.StrToDouble(DbHelper.ExecuteSum <ExamResult>("score", sqlparams));
}
List <ExamTopic> examTopicList = ExamBll.GetExamTopicList(examInfo.id, 1);
double num3 = 0.0;
int num4 = 0;
foreach (ExamTopic examTopic in examTopicList)
{
num3 += examTopic.perscore * (double)examTopic.questions;
num4 += examTopic.questions;
}
if (text != "")
{
text += "|";
}
text += string.Format("UPDATE [{0}Exam_ExamInfo] SET [exams]={1},[score]={2},[questions]={3},[total]={4} WHERE [id]={5}", new object[]
{
DbConfigs.Prefix,
num,
num2,
num4,
num3,
examInfo.id
});
}
DbHelper.ExecuteSql(text);
}
}
string childSorts = SortBll.GetChildSorts(this.sortinfo);
List <SqlParam> list3 = new List <SqlParam>();
list3.Add(DbHelper.MakeAndWhere("sortid", WhereType.In, childSorts));
if (this.keyword != "")
{
list3.Add(DbHelper.MakeAndWhere("name", WhereType.Like, this.keyword));
}
if (this.starttime != "" && this.isDate(this.starttime))
{
list3.Add(DbHelper.MakeAndWhere("islimit", 1));
list3.Add(DbHelper.MakeAndWhere("starttime", WhereType.LessThanEqual, this.starttime));
}
if (this.endtime != "" && this.isDate(this.endtime))
{
list3.Add(DbHelper.MakeAndWhere("islimit", 1));
list3.Add(DbHelper.MakeAndWhere("endtime", WhereType.GreaterThanEqual, this.endtime));
}
if (this.typeid > 0)
{
this.typeinfo = DbHelper.ExecuteModel <TypeInfo>(this.typeid);
this.pagenav = "|" + this.typeinfo.name + "," + this.rawurl;
list3.Add(DbHelper.MakeAndWhere(string.Format("(','+[typeid]+',') LIKE '%,{0},%'", this.typeid), WhereType.Custom, ""));
}
this.examlist = DbHelper.ExecuteList <ExamInfo>(this.pager, list3.ToArray());
base.SaveRightURL();
}
}
// Token: 0x060000BD RID: 189 RVA: 0x00012850 File Offset: 0x00010A50
protected override void View()
{
this.channelinfo = ChannelBll.GetChannelInfo("exam_question");
if (this.channelinfo.id == 0)
{
this.ShowErr("对不起，目前系统尚未创建题目库频道。");
}
else
{
string sqlstring = string.Format("SELECT COUNT([uid]) FROM (SELECT DISTINCT [uid] FROM [{0}Exam_ExamResult] WHERE [channelid]={1} AND [status]>0) AS TA", DbConfigs.Prefix, this.channelinfo.id);
this.examusers = this.GetScalarTotal(sqlstring);
sqlstring = string.Format("SELECT AVG([score]) FROM [{0}Exam_ExamResult] WHERE [channelid]={1} AND [uid]={2} AND [status]>0", DbConfigs.Prefix, this.channelinfo.id, this.userid);
this.avg_my = this.GetScalarTotal(sqlstring);
sqlstring = string.Format("SELECT AVG([score]) FROM [{0}Exam_ExamResult] WHERE [channelid]={1} AND [status]>0", DbConfigs.Prefix, this.channelinfo.id);
this.avg_total = this.GetScalarTotal(sqlstring);
sqlstring = string.Format("SELECT COUNT(*) FROM (SELECT [uid],AVG([score]) AS [scoreavg] FROM [{0}Exam_ExamResult] WHERE [channelid]={1} AND [status]>0 GROUP BY [uid]) AS TA WHERE [scoreavg]>{2}", DbConfigs.Prefix, this.channelinfo.id, this.avg_my);
this.avg_display = FPUtils.StrToInt(this.GetScalarTotal(sqlstring)) + 1;
sqlstring = string.Format("SELECT SUM([answers]) AS [answers],SUM([wrongs]) AS [wrongs] FROM [{0}Exam_ExamLogInfo] WHERE [channelid]={1}", DbConfigs.Prefix, this.channelinfo.id);
ExamLogInfo examLogInfo = this.GetExamLogInfo(sqlstring);
this.accuracy_total = examLogInfo.accuracy;
sqlstring = string.Format("SELECT SUM([answers]) AS [answers],SUM([wrongs]) AS [wrongs] FROM [{0}Exam_ExamLogInfo] WHERE [channelid]={1} AND [uid]={2}", DbConfigs.Prefix, this.channelinfo.id, this.userid);
examLogInfo = this.GetExamLogInfo(sqlstring);
this.accuracy_my = examLogInfo.accuracy;
sqlstring = string.Format("SELECT COUNT(*) FROM (SELECT [uid],SUM(wrongs) AS [wrongs] FROM [{0}Exam_ExamLogInfo] WHERE [channelid]={1} GROUP BY [uid]) AS TA WHERE [wrongs]<{2}", DbConfigs.Prefix, this.channelinfo.id, examLogInfo.wrongs);
this.accuracy_display = FPUtils.StrToInt(this.GetScalarTotal(sqlstring)) + 1;
SqlParam[] sqlparams = new SqlParam[]
{
DbHelper.MakeAndWhere("channelid", this.channelinfo.id),
DbHelper.MakeAndWhere("status", WhereType.GreaterThan, 0),
DbHelper.MakeAndWhere("uid", this.userid)
};
List <ExamResult> list = DbHelper.ExecuteList <ExamResult>(OrderBy.ASC, sqlparams);
int num = 1;
foreach (ExamResult examResult in list)
{
if (this.examresult != "")
{
this.examresult += ",";
}
this.examresult += string.Format("['', {0}]", examResult.score);
num++;
}
this.userexamlog = ExamBll.GetExamLogList(this.channelinfo.id, this.userid);
List <SortAppInfo> sortAppList = SortBll.GetSortAppList("exam_");
foreach (SortAppInfo sortAppInfo in sortAppList)
{
if (this.sortappidlist != "")
{
this.sortappidlist += ",";
}
this.sortappidlist += sortAppInfo.id;
}
SqlParam[] sqlparams2 = new SqlParam[]
{
DbHelper.MakeAndWhere("parentid", 0),
DbHelper.MakeAndWhere("channelid", this.channelinfo.id),
DbHelper.MakeAndWhere("appid", WhereType.In, this.sortappidlist),
DbHelper.MakeAndWhere("hidden", 0)
};
OrderByParam orderby = DbHelper.MakeOrderBy("display", OrderBy.ASC);
List <SortInfo> list2 = DbHelper.ExecuteList <SortInfo>(orderby, sqlparams2);
foreach (SortInfo sortInfo in list2)
{
if (this.userexamlog.ContainsKey(sortInfo.id))
{
examLogInfo = this.userexamlog[sortInfo.id];
}
else
{
examLogInfo = new ExamLogInfo();
}
examLogInfo.sortid = sortInfo.id;
examLogInfo.sortname = sortInfo.name;
examLogInfo.questions = sortInfo.posts;
examLogInfo.subcounts = sortInfo.subcounts;
this.examloglist.Add(examLogInfo);
}
}
}
// Token: 0x060000D6 RID: 214 RVA: 0x00015284 File Offset: 0x00013484
protected override void View()
{
ExamQuestion examQuestion = DbHelper.ExecuteModel <ExamQuestion>(this.qid);
if (examQuestion.id == 0)
{
this.ShowErrMsg("对不起，该题目不存在或已被删除。");
}
SortInfo sortInfo = SortBll.GetSortInfo(examQuestion.sortid);
if (sortInfo.id == 0)
{
this.ShowErrMsg("对不起，该题目题库不存在或已被删除。");
}
foreach (int num in FPUtils.SplitInt(sortInfo.parentlist))
{
if (num != 0)
{
ExamLogInfo examLogInfo = ExamBll.GetExamLogInfo(this.userid, num);
if (examLogInfo.sortid == 0)
{
examLogInfo.sortid = examQuestion.sortid;
examLogInfo.channelid = examQuestion.channelid;
examLogInfo.uid = this.userid;
examLogInfo.notes = 1;
examLogInfo.notelist = this.qid.ToString();
if (num == sortInfo.id)
{
examLogInfo.curnotes = 1;
}
DbHelper.ExecuteInsert <ExamLogInfo>(examLogInfo);
}
else
{
if (!FPUtils.InArray(this.qid, examLogInfo.notelist))
{
examLogInfo.notes++;
ExamLogInfo examLogInfo2 = examLogInfo;
examLogInfo2.notelist += ((examLogInfo.notelist == "") ? this.qid.ToString() : ("," + this.qid.ToString()));
if (num != sortInfo.id)
{
examLogInfo.curnotes++;
}
}
DbHelper.ExecuteUpdate <ExamLogInfo>(examLogInfo);
}
}
}
SqlParam[] sqlparams = new SqlParam[]
{
DbHelper.MakeAndWhere("qid", this.qid),
DbHelper.MakeAndWhere("uid", this.userid)
};
ExamNote examNote = DbHelper.ExecuteModel <ExamNote>(sqlparams);
examNote.uid = this.userid;
examNote.qid = this.qid;
examNote.note = this.note;
if (examNote.id > 0)
{
DbHelper.ExecuteUpdate <ExamNote>(examNote);
}
else
{
DbHelper.ExecuteInsert <ExamNote>(examNote);
}
Hashtable hashtable = new Hashtable();
hashtable["error"] = 0;
hashtable["message"] = "";
base.Response.AddHeader("Content-Type", "text/html; charset=UTF-8");
base.Response.Write(JsonMapper.ToJson(hashtable));
base.Response.End();
}
// Token: 0x060000C5 RID: 197 RVA: 0x000133F0 File Offset: 0x000115F0
protected override void View()
{
if (this.ispost)
{
this.examresult = ExamBll.GetExamResult(this.resultid);
if (this.examresult.id == 0)
{
this.ShowErrMsg("对不起，该考试不存在或已被删除。");
return;
}
if (this.examresult.uid != this.userid)
{
this.ShowErrMsg("对不起，您不是该考试的主人。");
return;
}
if (this.examresult.status == 1)
{
this.ShowErrMsg("对不起，该考试已完成，不能重复提交。");
return;
}
this.examresult.utime = FPRequest.GetInt("utime");
if (DbHelper.ExecuteUpdate <ExamResult>(this.examresult) <= 0)
{
this.ShowErrMsg("保存出现错误。");
return;
}
List <ExamResultTopic> examResultTopicList = ExamBll.GetExamResultTopicList(this.resultid);
int num = 0;
foreach (ExamResultTopic examResultTopic in examResultTopicList)
{
if (examResultTopic.questions == 0)
{
num++;
}
else
{
examResultTopicList[num].answerlist = "";
int num2 = 0;
foreach (ExamQuestion examQuestion in QuestionBll.GetQuestionList(examResultTopic.questionlist))
{
string @string = FPRequest.GetString("answer_" + examQuestion.id);
if (num2 == 0)
{
ExamResultTopic examResultTopic2 = examResultTopicList[num];
examResultTopic2.answerlist += @string;
}
else
{
ExamResultTopic examResultTopic3 = examResultTopicList[num];
examResultTopic3.answerlist = examResultTopic3.answerlist + "§" + @string;
}
num2++;
}
DbHelper.ExecuteUpdate <ExamResultTopic>(examResultTopicList[num]);
num++;
}
}
}
Hashtable hashtable = new Hashtable();
hashtable["error"] = 0;
hashtable["message"] = "";
base.Response.AddHeader("Content-Type", "text/html; charset=UTF-8");
base.Response.Write(JsonMapper.ToJson(hashtable));
base.Response.End();
}
// Token: 0x060000C8 RID: 200 RVA: 0x0001373C File Offset: 0x0001193C
protected override void View()
{
base.Response.Expires = 0;
base.Response.CacheControl = "no-cache";
base.Response.Cache.SetNoStore();
this.channelinfo = ChannelBll.GetChannelInfo("exam_question");
if (this.channelinfo.id == 0)
{
this.ShowErr("对不起，目前系统尚未创建题目库频道。");
}
else
{
this.examinfo = DbHelper.ExecuteModel <ExamInfo>(this.examid);
if (this.examinfo.id == 0)
{
this.ShowErr("对不起，该考试不存在或已被删除。");
}
else
{
if (this.examinfo.status == 0)
{
if (!this.isperm && this.examinfo.uid != this.userid)
{
this.ShowErr("对不起，该考试已关闭。");
return;
}
}
this.sortid = this.examinfo.sortid;
this.sortinfo = SortBll.GetSortInfo(this.sortid);
if (this.sortinfo.id == 0)
{
SqlParam sqlParam = DbHelper.MakeAndWhere("sortid", this.sortid);
DbHelper.ExecuteDelete <ExamInfo>(new SqlParam[]
{
sqlParam
});
this.ShowErr("对不起，考试栏目不存在或已被删除。");
}
else if (this.ispost)
{
if (this.examinfo.examroles != "")
{
if (!base.ischecked(this.roleid, this.examinfo.examroles) && !this.isperm)
{
this.ShowErr("对不起，您所在的角色不允许参加本场考试。");
return;
}
}
if (this.examinfo.examdeparts != "")
{
if (!base.ischecked(this.user.departid, this.examinfo.examdeparts) && !this.isperm)
{
this.ShowErr("对不起，您所在的部门不允许参加本场考试。");
return;
}
}
if (this.examinfo.examuser != "")
{
if (!base.ischecked(this.userid, this.examinfo.examuser) && !this.isperm)
{
this.ShowErr("对不起，您不允许参加本场考试。");
return;
}
}
if (this.examinfo.islimit == 1)
{
if (this.examinfo.starttime > DateTime.Now)
{
this.ShowErr("对不起，本场考试尚未到考试时间。");
return;
}
if (this.examinfo.endtime < DateTime.Now)
{
this.ShowErr("对不起，本场考试已超过考试期限。");
return;
}
}
SqlParam[] sqlparams = new SqlParam[]
{
DbHelper.MakeAndWhere("examid", this.examid),
DbHelper.MakeAndWhere("uid", this.userid),
DbHelper.MakeAndWhere("status", 0)
};
int num = DbHelper.ExecuteCount <ExamResult>(sqlparams);
if (num > 0)
{
this.ShowErr("对不起，本场考试您已经考过但尚未完成，请到考试历史那里查找。");
}
else
{
if (this.examinfo.repeats > 0)
{
SqlParam[] sqlparams2 = new SqlParam[]
{
DbHelper.MakeAndWhere("examid", this.examid),
DbHelper.MakeAndWhere("uid", this.userid),
DbHelper.MakeAndWhere("status", WhereType.GreaterThanEqual, 1)
};
num = DbHelper.ExecuteCount <ExamResult>(sqlparams2);
if (num >= this.examinfo.repeats)
{
this.ShowErr("对不起，本场考试限制次数为" + this.examinfo.repeats + "次，您已考完不能再考。");
return;
}
}
if (this.examinfo.credits > 0 && !this.isperm && this.examinfo.uid != this.userid)
{
if (this.user.credits < this.examinfo.credits)
{
this.ShowErr("对不起，您的积分余额不足，不能参加本场考试。");
return;
}
UserBll.UpdateUserCredit(this.userid, "参加考试", 0, this.examinfo.credits * -1);
}
Random random = new Random();
int paper = random.Next(this.examinfo.papers) + 1;
List <ExamTopic> examTopicList = ExamBll.GetExamTopicList(this.examid, paper);
int num2 = 0;
for (int i = 0; i < examTopicList.Count; i++)
{
examTopicList[i].questionlist = QuestionBll.GetTopicQuestion(this.channelinfo.id, examTopicList[i]);
string[] array = FPUtils.SplitString(examTopicList[i].questionlist);
if (this.examinfo.display == 0)
{
examTopicList[i].questionlist = QuestionBll.GetRandom(array, array.Length);
}
examTopicList[i].optionlist = "";
foreach (ExamQuestion examQuestion in QuestionBll.GetQuestionList(examTopicList[i].questionlist))
{
if (examTopicList[i].optionlist != "")
{
ExamTopic examTopic = examTopicList[i];
examTopic.optionlist += "|";
}
if (examQuestion.type == 1 || examQuestion.type == 2)
{
ExamTopic examTopic2 = examTopicList[i];
examTopic2.optionlist += this.OptionInt(examQuestion.ascount, this.examinfo.optiondisplay);
}
else
{
ExamTopic examTopic3 = examTopicList[i];
examTopic3.optionlist += "*";
}
}
num2 += array.Length;
examTopicList[i].questions = array.Length;
}
ExamResult examResult = new ExamResult();
examResult.uid = this.userid;
examResult.examid = this.examid;
examResult.channelid = this.channelinfo.id;
examResult.sortid = this.examinfo.sortid;
examResult.examtype = this.examinfo.examtype;
examResult.showanswer = this.examinfo.showanswer;
examResult.allowdelete = this.examinfo.allowdelete;
examResult.examname = this.examinfo.name;
examResult.examtime = this.examinfo.examtime;
examResult.total = this.examinfo.total;
examResult.passmark = this.examinfo.passmark;
examResult.credits = this.examinfo.credits;
examResult.questions = num2;
examResult.islimit = this.examinfo.islimit;
if (examResult.islimit == 1)
{
examResult.starttime = this.examinfo.starttime;
examResult.endtime = this.examinfo.endtime;
}
else
{
examResult.starttime = DbUtils.GetDateTime();
examResult.endtime = examResult.starttime.AddMinutes((double)this.examinfo.examtime);
}
examResult.examdatetime = DbUtils.GetDateTime();
examResult.status = 0;
examResult.paper = paper;
examResult.ip = this.ip;
examResult.mac = ExamConifgs.GetMacAddress(this.ip);
examResult.id = DbHelper.ExecuteInsert <ExamResult>(examResult);
if (examResult.id > 0)
{
foreach (ExamTopic examTopic4 in examTopicList)
{
DbHelper.ExecuteInsert <ExamResultTopic>(new ExamResultTopic
{
resultid = examResult.id,
type = examTopic4.type,
title = examTopic4.title,
perscore = examTopic4.perscore,
display = examTopic4.display,
questions = examTopic4.questions,
questionlist = examTopic4.questionlist,
optionlist = examTopic4.optionlist
});
}
if (this.examinfo.examdeparts == "" && this.examinfo.examuser == "" && this.examinfo.examroles == "")
{
string text = string.Format("UPDATE [{0}Exam_ExamInfo] SET [exams]=[exams]+1 WHERE [id]={1}", DbConfigs.Prefix, this.examid);
DbHelper.ExecuteSql(text.ToString());
}
}
base.Response.Redirect("exam.aspx?resultid=" + examResult.id);
}
}
}
}
}
// Token: 0x060000E2 RID: 226 RVA: 0x000161B4 File Offset: 0x000143B4
protected override void View()
{
this.channelinfo = ChannelBll.GetChannelInfo("exam_question");
if (this.channelinfo.id == 0)
{
this.ShowErr("对不起，目前系统尚未创建题目库频道。");
}
else if (this.ispost)
{
if (this.qidlist == "")
{
this.ShowErr("对不起，题目为空不能提交。");
}
else
{
List <ExamQuestion> questionList = QuestionBll.GetQuestionList(this.qidlist);
this.examresult.uid = this.userid;
this.examresult.channelid = this.channelinfo.id;
this.examresult.examid = 0;
this.examresult.examtype = 0;
this.examresult.showanswer = 1;
this.examresult.allowdelete = 1;
this.examresult.examname = ((this.testtype == 1) ? "专项智能练习" : "快速智能练习");
this.examresult.examtime = FPRequest.GetInt("utime") / 60;
this.examresult.total = 100.0;
this.examresult.passmark = 60.0;
this.examresult.credits = 0;
this.examresult.questions = questionList.Count;
this.examresult.utime = FPRequest.GetInt("utime");
this.examresult.starttime = FPRequest.GetDateTime("starttime");
this.examresult.endtime = DbUtils.GetDateTime();
this.examresult.status = 1;
this.examresult.id = DbHelper.ExecuteInsert <ExamResult>(this.examresult);
if (this.examresult.id > 0)
{
ExamResultTopic examResultTopic = new ExamResultTopic();
examResultTopic.resultid = this.examresult.id;
examResultTopic.type = 0;
examResultTopic.title = ((this.testtype == 1) ? "专项智能练习" : "快速智能练习");
examResultTopic.perscore = Math.Round(this.examresult.total / (double)this.examresult.questions, 1);
examResultTopic.display = 1;
examResultTopic.questions = questionList.Count;
examResultTopic.questionlist = this.qidlist;
int num = 0;
foreach (ExamQuestion examQuestion in QuestionBll.GetQuestionList(examResultTopic.questionlist))
{
if (examResultTopic.optionlist != "")
{
ExamResultTopic examResultTopic2 = examResultTopic;
examResultTopic2.optionlist += "|";
}
if (examQuestion.type == 1 || examQuestion.type == 2)
{
ExamResultTopic examResultTopic3 = examResultTopic;
examResultTopic3.optionlist += this.OptionInt(examQuestion.ascount);
}
else
{
ExamResultTopic examResultTopic4 = examResultTopic;
examResultTopic4.optionlist += "*";
}
string text = FPRequest.GetString("answer_" + examQuestion.id);
if (num == 0)
{
ExamResultTopic examResultTopic5 = examResultTopic;
examResultTopic5.answerlist += text;
}
else
{
ExamResultTopic examResultTopic6 = examResultTopic;
examResultTopic6.answerlist = examResultTopic6.answerlist + "§" + text;
}
if (examResultTopic.scorelist != "")
{
ExamResultTopic examResultTopic7 = examResultTopic;
examResultTopic7.scorelist += "|";
}
int num2 = 0;
double num3 = 0.0;
if (examQuestion.type <= 3)
{
if (text == examQuestion.answer && text != "")
{
num2 = examQuestion.ascount;
num3 = examResultTopic.perscore;
this.examresult.score1 += num3;
}
}
else if (examQuestion.type == 4)
{
string[] array;
if (examQuestion.upperflg == 1)
{
array = FPUtils.SplitString(examQuestion.answer, ",");
}
else
{
array = FPUtils.SplitString(examQuestion.answer.ToLower(), ",");
}
text = testpost.DelSameAnser(text);
string[] array2;
if (examQuestion.upperflg == 1)
{
array2 = FPUtils.SplitString(text, ",", array.Length);
}
else
{
array2 = FPUtils.SplitString(text.ToLower(), ",", array.Length);
}
if (examQuestion.orderflg == 1)
{
for (int i = 0; i < array2.Length; i++)
{
if (FPUtils.InArray(array2[i], array[i], "|"))
{
num2++;
}
}
}
else
{
for (int i = 0; i < array2.Length; i++)
{
if (FPUtils.InArray(array2[i], examQuestion.answer.Replace("|", ",")))
{
num2++;
}
}
}
if (num2 > 0)
{
if (examQuestion.ascount <= 0)
{
examQuestion.ascount = 1;
}
num3 = Math.Round(examResultTopic.perscore / (double)examQuestion.ascount * (double)num2, 1);
this.examresult.score2 += num3;
}
}
else if (examQuestion.type == 5)
{
foreach (string value in FPUtils.SplitString(examQuestion.answerkey))
{
if (text.IndexOf(value) >= 0)
{
num2++;
}
}
if (num2 > 0 && text != "")
{
if (examQuestion.ascount > 0)
{
examQuestion.ascount = 1;
}
num3 = Math.Round(examResultTopic.perscore / (double)examQuestion.ascount * (double)num2, 1);
this.examresult.score2 += num3;
}
}
else if (examQuestion.type == 6)
{
for (int k = 0; k < examQuestion.title.Length; k++)
{
if (text.IndexOf(examQuestion.title.Substring(k, 1)) >= 0)
{
num2++;
}
}
if (num2 > 0)
{
num3 = Math.Round(examResultTopic.perscore / (double)examQuestion.title.Length * (double)num2, 1);
this.examresult.score2 += num3;
}
}
this.examresult.score += num3;
examResultTopic.score += num3;
ExamResultTopic examResultTopic8 = examResultTopic;
examResultTopic8.scorelist += num3.ToString();
if (examResultTopic.correctlist != "")
{
ExamResultTopic examResultTopic9 = examResultTopic;
examResultTopic9.correctlist += "|";
}
bool flag = false;
if (num3 >= examResultTopic.perscore * 0.6)
{
ExamResultTopic examResultTopic10 = examResultTopic;
examResultTopic10.correctlist += "1";
}
else
{
ExamResultTopic examResultTopic11 = examResultTopic;
examResultTopic11.correctlist += "0";
examResultTopic.wrongs++;
this.examresult.wrongs++;
if (text == "")
{
this.examresult.unanswer++;
}
flag = true;
}
string sqlstring;
if (flag)
{
sqlstring = string.Format("UPDATE [{0}Exam_ExamQuestion] SET [exams]=[exams]+1,[wrongs]=[wrongs]+1 WHERE [id]={1}", DbConfigs.Prefix, examQuestion.id);
}
else
{
sqlstring = string.Format("UPDATE [{0}Exam_ExamQuestion] SET [exams]=[exams]+1 WHERE [id]={1}", DbConfigs.Prefix, examQuestion.id);
}
DbHelper.ExecuteSql(sqlstring);
examQuestion.useranswer = text;
SortInfo sortInfo = SortBll.GetSortInfo(examQuestion.sortid);
ExamBll.UpdateExamLog(sortInfo, this.userid, examQuestion, flag);
num++;
}
DbHelper.ExecuteInsert <ExamResultTopic>(examResultTopic);
SqlParam[] sqlparams = new SqlParam[]
{
DbHelper.MakeSet("score1", this.examresult.score1),
DbHelper.MakeSet("score2", this.examresult.score2),
DbHelper.MakeSet("score", this.examresult.score),
DbHelper.MakeSet("wrongs", this.examresult.wrongs),
DbHelper.MakeAndWhere("id", this.examresult.id)
};
DbHelper.ExecuteUpdate <ExamResult>(sqlparams);
}
}
}
}
// Token: 0x060000CB RID: 203 RVA: 0x0001420C File Offset: 0x0001240C
protected override void View()
{
ExamQuestion examQuestion = DbHelper.ExecuteModel <ExamQuestion>(this.qid);
if (examQuestion.id == 0)
{
this.ShowErrMsg("对不起，该题目不存在或已被删除。");
}
SortInfo sortInfo = SortBll.GetSortInfo(examQuestion.sortid);
if (this.option == 1)
{
foreach (int num in FPUtils.SplitInt(sortInfo.parentlist))
{
if (num != 0)
{
ExamLogInfo examLogInfo = ExamBll.GetExamLogInfo(this.userid, num);
if (examLogInfo.sortid == 0)
{
examLogInfo.sortid = examQuestion.sortid;
examLogInfo.channelid = examQuestion.channelid;
examLogInfo.uid = this.userid;
examLogInfo.favs = 1;
if (num == sortInfo.id)
{
examLogInfo.curfavs = 1;
}
examLogInfo.favlist = this.qid.ToString();
DbHelper.ExecuteInsert <ExamLogInfo>(examLogInfo);
}
else
{
examLogInfo.favs++;
if (num == sortInfo.id)
{
examLogInfo.curfavs++;
}
ExamLogInfo examLogInfo2 = examLogInfo;
examLogInfo2.favlist += ((examLogInfo.favlist == "") ? this.qid.ToString() : ("," + this.qid.ToString()));
DbHelper.ExecuteUpdate <ExamLogInfo>(examLogInfo);
}
}
}
}
else if (this.option == -1)
{
foreach (int num in FPUtils.SplitInt(sortInfo.parentlist))
{
if (num != 0)
{
ExamLogInfo examLogInfo = ExamBll.GetExamLogInfo(this.userid, num);
if (examLogInfo.sortid != 0)
{
if (FPUtils.InArray(this.qid, examLogInfo.favlist))
{
examLogInfo.favs--;
if (num == sortInfo.id)
{
examLogInfo.curfavs--;
}
string text = "";
foreach (int num2 in FPUtils.SplitInt(examLogInfo.favlist))
{
if (num2 != this.qid)
{
text += ((text == "") ? num2.ToString() : ("," + num2.ToString()));
}
}
examLogInfo.favlist = text;
DbHelper.ExecuteUpdate <ExamLogInfo>(examLogInfo);
}
}
}
}
}
Hashtable hashtable = new Hashtable();
hashtable["error"] = 0;
hashtable["message"] = "";
hashtable["action"] = this.option;
base.Response.AddHeader("Content-Type", "text/html; charset=UTF-8");
base.Response.Write(JsonMapper.ToJson(hashtable));
base.Response.End();
}
// Token: 0x060000A4 RID: 164 RVA: 0x0000F8A4 File Offset: 0x0000DAA4
protected override void View()
{
if (this.ispost)
{
this.examresult = ExamBll.GetExamResult(this.resultid);
if (this.examresult.id == 0)
{
this.ShowErr("对不起，该考试不存在或已被删除。");
}
else if (this.examresult.uid != this.userid)
{
this.ShowErr("对不起，您不是该考试的主人。");
}
else if (this.examresult.status == 1)
{
this.ShowErr("对不起，该考试已完成，不能重复提交。");
}
else
{
this.examresult.utime = FPRequest.GetInt("utime");
this.examresult.endtime = DbUtils.GetDateTime();
this.examresult.status = 1;
if (DbHelper.ExecuteUpdate <ExamResult>(this.examresult) > 0)
{
List <ExamResultTopic> examResultTopicList = ExamBll.GetExamResultTopicList(this.resultid);
int num = 0;
foreach (ExamResultTopic examResultTopic in examResultTopicList)
{
if (examResultTopic.questions == 0)
{
num++;
}
else
{
examResultTopicList[num].answerlist = "";
examResultTopicList[num].scorelist = "";
examResultTopicList[num].correctlist = "";
List <ExamQuestion> questionList = QuestionBll.GetQuestionList(examResultTopic.questionlist);
string[] array = FPUtils.SplitString(examResultTopic.optionlist, "|", questionList.Count);
int num2 = 0;
foreach (ExamQuestion examQuestion in questionList)
{
string text = FPRequest.GetString("answer_" + examQuestion.id);
if (num2 == 0)
{
ExamResultTopic examResultTopic2 = examResultTopicList[num];
examResultTopic2.answerlist += text;
}
else
{
ExamResultTopic examResultTopic3 = examResultTopicList[num];
examResultTopic3.answerlist = examResultTopic3.answerlist + "§" + text;
}
if (examResultTopicList[num].scorelist != "")
{
ExamResultTopic examResultTopic4 = examResultTopicList[num];
examResultTopic4.scorelist += "|";
}
examQuestion.optionlist = array[num2];
int num3 = 0;
double num4 = 0.0;
if (examQuestion.type == 1 || examQuestion.type == 2)
{
num3 = examQuestion.ascount;
examQuestion.answer = this.OptionAnswer(array[num2], examQuestion.answer);
if (text == examQuestion.answer && text != "")
{
num4 = examResultTopic.perscore;
}
this.examresult.score1 += num4;
}
else if (examQuestion.type == 3)
{
num3 = examQuestion.ascount;
if (text == examQuestion.answer && text != "")
{
num4 = examResultTopic.perscore;
}
this.examresult.score1 += num4;
}
else if (examQuestion.type == 4)
{
string[] array2;
if (examQuestion.upperflg == 1)
{
array2 = FPUtils.SplitString(examQuestion.answer, ",");
}
else
{
array2 = FPUtils.SplitString(examQuestion.answer.ToLower(), ",");
}
text = exampost.DelSameAnser(text);
string[] array3;
if (examQuestion.upperflg == 1)
{
array3 = FPUtils.SplitString(text, ",", array2.Length);
}
else
{
array3 = FPUtils.SplitString(text.ToLower(), ",", array2.Length);
}
if (examQuestion.orderflg == 1)
{
for (int i = 0; i < array3.Length; i++)
{
if (FPUtils.InArray(array3[i], array2[i], "|"))
{
num3++;
}
}
}
else
{
for (int i = 0; i < array3.Length; i++)
{
if (FPUtils.InArray(array3[i], examQuestion.answer.Replace("|", ",")))
{
num3++;
}
}
}
if (num3 > 0)
{
if (examQuestion.ascount <= 0)
{
examQuestion.ascount = 1;
}
num4 = Math.Round(examResultTopic.perscore / (double)examQuestion.ascount * (double)num3, 1);
this.examresult.score2 += num4;
}
}
else if (examQuestion.type == 5)
{
foreach (string value in FPUtils.SplitString(examQuestion.answerkey))
{
if (text.IndexOf(value) >= 0)
{
num3++;
}
}
if (num3 > 0 && text != "")
{
if (examQuestion.ascount > 0)
{
examQuestion.ascount = 1;
}
num4 = Math.Round(examResultTopic.perscore / (double)examQuestion.ascount * (double)num3, 1);
this.examresult.score2 += num4;
}
}
else if (examQuestion.type == 6)
{
for (int k = 0; k < examQuestion.title.Length; k++)
{
if (text.IndexOf(examQuestion.title.Substring(k, 1)) >= 0)
{
num3++;
}
}
if (num3 > 0)
{
num4 = Math.Round(examResultTopic.perscore / (double)examQuestion.title.Length * (double)num3, 1);
this.examresult.score2 += num4;
}
}
this.examresult.score += num4;
examResultTopicList[num].score += num4;
ExamResultTopic examResultTopic5 = examResultTopicList[num];
examResultTopic5.scorelist += num4.ToString();
if (examResultTopicList[num].correctlist != "")
{
ExamResultTopic examResultTopic6 = examResultTopicList[num];
examResultTopic6.correctlist += "|";
}
bool flag = false;
if (num4 >= examResultTopic.perscore * 0.6)
{
ExamResultTopic examResultTopic7 = examResultTopicList[num];
examResultTopic7.correctlist += "1";
}
else
{
ExamResultTopic examResultTopic8 = examResultTopicList[num];
examResultTopic8.correctlist += "0";
examResultTopicList[num].wrongs++;
this.examresult.wrongs++;
if (text == "")
{
this.examresult.unanswer++;
}
flag = true;
}
string sqlstring;
if (flag)
{
sqlstring = string.Format("UPDATE [{0}Exam_ExamQuestion] SET [exams]=[exams]+1,[wrongs]=[wrongs]+1 WHERE [id]={1}", DbConfigs.Prefix, examQuestion.id);
}
else
{
sqlstring = string.Format("UPDATE [{0}Exam_ExamQuestion] SET [exams]=[exams]+1 WHERE [id]={1}", DbConfigs.Prefix, examQuestion.id);
}
DbHelper.ExecuteSql(sqlstring);
examQuestion.useranswer = text;
SortInfo sortInfo = SortBll.GetSortInfo(examQuestion.sortid);
ExamBll.UpdateExamLog(sortInfo, this.userid, examQuestion, flag);
num2++;
}
DbHelper.ExecuteUpdate <ExamResultTopic>(examResultTopicList[num]);
num++;
}
}
this.expinfo = ExamBll.GetExamExpByScore(this.examresult.score, this.examresult.examid);
this.examresult.exnote = this.expinfo.comment;
this.examresult.exp = this.expinfo.exp;
this.examresult.getcredits = this.expinfo.credits;
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.AppendFormat("UPDATE [{0}Exam_ExamResult] SET [score1]={1},[score2]={2},[score]={3},[wrongs]={4},[exp]={5},[exnote]='{6}' WHERE [id]={7}|", new object[]
{
DbConfigs.Prefix,
this.examresult.score1,
this.examresult.score2,
this.examresult.score,
this.examresult.wrongs,
this.examresult.exp,
this.examresult.exnote,
this.examresult.id
});
stringBuilder.AppendFormat("UPDATE [{0}Exam_ExamInfo] SET [score]=[score]+{1} WHERE [id]={2}", DbConfigs.Prefix, this.examresult.score, this.examresult.examid);
this.msg = DbHelper.ExecuteSql(stringBuilder.ToString());
if (this.examresult.exp > 0)
{
UserBll.UpdateUserExp(this.examresult.uid, this.examresult.exp);
}
if (this.examresult.getcredits > 0)
{
UserBll.UpdateUserCredit(new CreditInfo
{
uid = this.examresult.uid,
name = "考试奖励积分",
type = 0,
credits = this.examresult.getcredits,
doid = this.userid,
doname = this.username
});
}
if (this.msg != "")
{
this.ShowErr(this.msg);
}
}
}
}
}
// Token: 0x060000B8 RID: 184 RVA: 0x00011E2C File Offset: 0x0001002C
protected override void View()
{
if (this.ispost)
{
if (!this.isperm)
{
this.ShowErrMsg("对不起，您没有权限阅卷。");
return;
}
this.examresult = ExamBll.GetExamResult(this.resultid);
if (this.examresult.id == 0)
{
this.ShowErrMsg("对不起，该考试不存在或已被删除。");
return;
}
int status = this.examresult.status;
this.examresult.status = 2;
this.examresult.exnote = FPRequest.GetString("exnote");
if (DbHelper.ExecuteUpdate <ExamResult>(this.examresult) <= 0)
{
this.ShowErrMsg("保存出现错误。");
return;
}
List <ExamResultTopic> examResultTopicList = ExamBll.GetExamResultTopicList(this.resultid);
int num = 0;
double score = this.examresult.score;
this.examresult.score = 0.0;
this.examresult.score1 = 0.0;
this.examresult.score2 = 0.0;
this.examresult.wrongs = 0;
foreach (ExamResultTopic examResultTopic in examResultTopicList)
{
if (examResultTopic.questions == 0)
{
num++;
}
else
{
int[] array = FPUtils.SplitInt(examResultTopic.questionlist);
string[] array2 = FPUtils.SplitString(examResultTopic.answerlist, "§", array.Length);
string[] array3 = FPUtils.SplitString(examResultTopic.scorelist, "|", array.Length);
examResultTopicList[num].scorelist = "";
examResultTopicList[num].correctlist = "";
examResultTopicList[num].score = 0.0;
int num2 = 0;
foreach (ExamQuestion examQuestion in QuestionBll.GetQuestionList(examResultTopic.questionlist))
{
string a = array2[num2];
if (examResultTopicList[num].scorelist != "")
{
ExamResultTopic examResultTopic2 = examResultTopicList[num];
examResultTopic2.scorelist += "|";
}
double num3 = 0.0;
if (examQuestion.type == 1 || examQuestion.type == 2)
{
num3 = (double)FPRequest.GetFloat("score_" + examQuestion.id);
this.examresult.score1 += num3;
}
else if (examQuestion.type == 3)
{
num3 = (double)FPRequest.GetFloat("score_" + examQuestion.id);
this.examresult.score1 += num3;
}
else if (examQuestion.type == 4)
{
num3 = (double)FPRequest.GetFloat("score_" + examQuestion.id);
this.examresult.score1 += num3;
}
else if (examQuestion.type == 5)
{
num3 = (double)FPRequest.GetFloat("score_" + examQuestion.id);
this.examresult.score2 += num3;
}
else if (examQuestion.type == 6)
{
num3 = (double)FPRequest.GetFloat("score_" + examQuestion.id);
this.examresult.score2 += num3;
}
this.examresult.score += num3;
examResultTopicList[num].score += num3;
ExamResultTopic examResultTopic3 = examResultTopicList[num];
examResultTopic3.scorelist += num3.ToString();
if (examResultTopicList[num].correctlist != "")
{
ExamResultTopic examResultTopic4 = examResultTopicList[num];
examResultTopic4.correctlist += "|";
}
bool iswrong = false;
if (num3 >= examResultTopic.perscore * 0.6)
{
ExamResultTopic examResultTopic5 = examResultTopicList[num];
examResultTopic5.correctlist += "1";
}
else
{
ExamResultTopic examResultTopic6 = examResultTopicList[num];
examResultTopic6.correctlist += "0";
examResultTopicList[num].wrongs++;
this.examresult.wrongs++;
if (a == "")
{
this.examresult.unanswer++;
}
iswrong = true;
}
SortInfo sortInfo = SortBll.GetSortInfo(examQuestion.sortid);
ExamBll.UpdateExamLog(sortInfo, this.examresult.uid, examQuestion, iswrong);
num2++;
}
DbHelper.ExecuteUpdate <ExamResultTopic>(examResultTopicList[num]);
num++;
}
}
ExpInfo examExpByScore = ExamBll.GetExamExpByScore(this.examresult.score, this.examresult.examid);
StringBuilder stringBuilder = new StringBuilder();
if (status == 0)
{
stringBuilder.AppendFormat("UPDATE [{0}Exam_ExamResult] SET [score1]={1},[score2]={2},[score]={3},[wrongs]={4},[exp]={5} WHERE [id]={6}|", new object[]
{
DbConfigs.Prefix,
this.examresult.score1,
this.examresult.score2,
this.examresult.score,
this.examresult.wrongs,
examExpByScore.exp,
this.examresult.id
});
stringBuilder.AppendFormat("UPDATE [{0}Exam_ExamInfo] SET [exams]=[exams]+1,[score]=[score]+{1} WHERE [id]={2}", DbConfigs.Prefix, this.examresult.score, this.examresult.examid);
}
else
{
stringBuilder.AppendFormat("UPDATE [{0}Exam_ExamResult] SET [score1]={1},[score2]={2},[score]={3},[exp]={4} WHERE [id]={5}|", new object[]
{
DbConfigs.Prefix,
this.examresult.score1,
this.examresult.score2,
this.examresult.score,
examExpByScore.exp,
this.examresult.id
});
stringBuilder.AppendFormat("UPDATE [{0}Exam_ExamInfo] SET [score]=[score]-{1} WHERE [id]={2}|", DbConfigs.Prefix, score, this.examresult.examid);
stringBuilder.AppendFormat("UPDATE [{0}Exam_ExamInfo] SET [score]=[score]+{1} WHERE [id]={2}", DbConfigs.Prefix, this.examresult.score, this.examresult.examid);
stringBuilder.AppendFormat("UPDATE [{0}WMS_UserInfo] SET [exp]=[exp]-{1} WHERE [id]={2}", DbConfigs.Prefix, this.examresult.exp, this.examresult.uid);
}
this.msg = DbHelper.ExecuteSql(stringBuilder.ToString());
UserBll.UpdateUserExp(this.examresult.uid, examExpByScore.exp);
if (this.msg != "")
{
this.ShowErrMsg(this.msg);
return;
}
}
Hashtable hashtable = new Hashtable();
hashtable["error"] = 0;
hashtable["message"] = "";
base.Response.AddHeader("Content-Type", "text/html; charset=UTF-8");
base.Response.Write(JsonMapper.ToJson(hashtable));
base.Response.End();
}
// Token: 0x060000D9 RID: 217 RVA: 0x000155E0 File Offset: 0x000137E0
protected override void View()
{
this.examconfig = ExamConifgs.GetExamConfig();
this.sortinfo = SortBll.GetSortInfo(this.sortid);
if (this.sortinfo.id == 0)
{
this.ShowErr("对不起，该题库不存在或已被删除。");
}
else
{
SqlParam[] sqlparams = new SqlParam[]
{
DbHelper.MakeAndWhere("sortid", this.sortid),
DbHelper.MakeAndWhere("uid", this.userid)
};
this.examloginfo = DbHelper.ExecuteModel <ExamLogInfo>(sqlparams);
if (this.examloginfo.sortid != 0)
{
this.channelid = this.examloginfo.channelid;
this.examloginfo.questions = this.sortinfo.posts;
this.examloglist = ExamBll.GetExamLogList(this.channelid, this.userid);
string text = "";
if (this.action == "wrong")
{
this.pagenav = string.Concat(new object[]
{
"错题(",
this.sortinfo.name,
")共",
this.examloginfo.wrongs,
"道题目"
});
text = this.examloginfo.wronglist;
}
else if (this.action == "note")
{
this.pagenav = string.Concat(new object[]
{
"笔记(",
this.sortinfo.name,
")共",
this.examloginfo.notes,
"道题目"
});
text = this.examloginfo.notelist;
}
else if (this.action == "fav")
{
this.pagenav = string.Concat(new object[]
{
"收藏(",
this.sortinfo.name,
")共",
this.examloginfo.favs,
"道题目"
});
text = this.examloginfo.favlist;
}
if (text != "")
{
SqlParam sqlParam = DbHelper.MakeAndWhere("id", WhereType.In, text);
OrderByParam orderby = DbHelper.MakeOrderBy("type", OrderBy.ASC);
this.questionlist = DbHelper.ExecuteList <ExamQuestion>(orderby, new SqlParam[]
{
sqlParam
});
SqlParam[] sqlparams2 = new SqlParam[]
{
DbHelper.MakeAndWhere("qid", WhereType.In, text),
DbHelper.MakeAndWhere("uid", this.userid)
};
List <ExamNote> list = DbHelper.ExecuteList <ExamNote>(sqlparams2);
for (int i = 0; i < this.questionlist.Count; i++)
{
if (FPUtils.InArray(this.questionlist[i].id, this.examloginfo.favlist))
{
this.questionlist[i].isfav = 1;
}
foreach (ExamNote examNote in list)
{
if (examNote.qid == this.questionlist[i].id)
{
this.questionlist[i].note = examNote.note;
}
}
if (this.examloglist.ContainsKey(this.questionlist[i].sortid))
{
ExamLogInfo examLogInfo = this.examloglist[this.questionlist[i].sortid];
if (FPUtils.InArray(this.questionlist[i].id, examLogInfo.qidlist))
{
int[] array = FPUtils.SplitInt(examLogInfo.qidlist);
string[] array2 = FPUtils.SplitString(examLogInfo.optionlist, "|", array.Length);
string[] array3 = FPUtils.SplitString(examLogInfo.answerlist, "§", array.Length);
for (int j = 0; j < array.Length; j++)
{
if (array[j] == this.questionlist[i].id)
{
this.questionlist[i].useranswer = array3[j];
this.questionlist[i].optionlist = array2[j];
this.questionlist[i].answer = this.OptionAnswer(array2[j], this.questionlist[i].answer);
}
}
}
}
}
}
}
}
}
// Token: 0x06000061 RID: 97 RVA: 0x00009A40 File Offset: 0x00007C40
protected override void View()
{
this.channelinfo = ChannelBll.GetChannelInfo("exam_question");
if (this.channelinfo.id == 0)
{
this.ShowErr("对不起，目前系统尚未创建题目库频道。");
}
else if (this.ispost)
{
this.examinfo = DbHelper.ExecuteModel <ExamInfo>(this.examid);
this.examinfo.passmark = this.examinfo.passmark * this.examinfo.total / 100.0;
this.examtopiclist = ExamBll.GetExamTopicList(this.examid, this.paper);
int num = 0;
for (int i = 0; i < this.examtopiclist.Count; i++)
{
this.examtopiclist[i].questionlist = QuestionBll.GetTopicQuestion(this.channelinfo.id, this.examtopiclist[i]);
string[] array = FPUtils.SplitString(this.examtopiclist[i].questionlist);
if (this.examinfo.display == 0)
{
this.examtopiclist[i].questionlist = QuestionBll.GetRandom(array, array.Length);
}
num += array.Length;
this.examtopiclist[i].questions = array.Length;
}
this.examinfo.questions = num;
AsposeWordApp asposeWordApp = new AsposeWordApp();
if (this.papersize == "a4")
{
asposeWordApp.Open(FPUtils.GetMapPath("images\\exampaper_a4.doc"));
}
else
{
asposeWordApp.Open(FPUtils.GetMapPath("images\\exampaper_a3.doc"));
}
asposeWordApp.InsertText("examtitle", this.examinfo.name);
asposeWordApp.InsertText("subtitle", this.GetPaper(this.paper));
asposeWordApp.MoveToBookmark("content");
DataTable dataTable = new DataTable();
DataColumn column = new DataColumn("s0", Type.GetType("System.String"));
dataTable.Columns.Add(column);
int num2 = 1;
foreach (ExamTopic examTopic in this.examtopiclist)
{
column = new DataColumn("s" + num2, Type.GetType("System.String"));
dataTable.Columns.Add(column);
num2++;
}
column = new DataColumn("s" + num2, Type.GetType("System.String"));
dataTable.Columns.Add(column);
DataRow dataRow = dataTable.NewRow();
dataRow["s0"] = "题 号";
num2 = 1;
foreach (ExamTopic examTopic in this.examtopiclist)
{
dataRow["s" + num2] = this.GetNum(num2);
num2++;
}
dataRow["s" + num2] = "总 分";
dataTable.Rows.Add(dataRow);
dataRow = dataTable.NewRow();
dataRow["s0"] = "得 分";
num2 = 1;
foreach (ExamTopic examTopic in this.examtopiclist)
{
dataRow["s" + num2] = "";
num2++;
}
dataRow["s" + num2] = "";
dataTable.Rows.Add(dataRow);
asposeWordApp.InsertTable(dataTable, true);
asposeWordApp.InsertLineBreak();
num2 = 1;
foreach (ExamTopic examTopic in this.examtopiclist)
{
asposeWordApp.InsertScoreTable(true, true, string.Concat(new object[]
{
examTopic.title,
" (共",
examTopic.questions,
"题，每题",
examTopic.perscore,
"分，共",
(double)examTopic.questions * examTopic.perscore,
"分)"
}));
foreach (ExamQuestion examQuestion in this.GetQuestionList(examTopic.questionlist))
{
if (examQuestion.type == 1 || examQuestion.type == 2)
{
if (this.papertype == 1)
{
asposeWordApp.Writeln(string.Concat(new object[]
{
num2,
"、",
examQuestion.title,
" ",
examQuestion.answer
}), 12.0, false, "left");
asposeWordApp.Writeln(this.Option(asposeWordApp, examQuestion.option, examQuestion.ascount, examQuestion.optionlist), 12.0, false, "left");
if (examQuestion.explain != "")
{
asposeWordApp.Writeln("答案解析：" + examQuestion.explain, 12.0, false, "left");
}
}
else
{
asposeWordApp.Writeln(num2 + "、" + examQuestion.title, 12.0, false, "left");
asposeWordApp.Writeln(this.Option(asposeWordApp, examQuestion.option, examQuestion.ascount, examQuestion.optionlist), 12.0, false, "left");
}
}
else if (examQuestion.type == 3)
{
if (this.papertype == 1)
{
asposeWordApp.Writeln((string.Concat(new object[]
{
num2,
"、",
examQuestion.title,
" (",
examQuestion.answer
}) == "Y") ? "正确" : "错误)", 12.0, false, "left");
if (examQuestion.explain != "")
{
asposeWordApp.Writeln("答案解析：" + examQuestion.explain, 12.0, false, "left");
}
}
else
{
asposeWordApp.Writeln(string.Concat(new object[]
{
num2,
"、",
examQuestion.title,
" ( )"
}), 12.0, false, "left");
}
}
else if (examQuestion.type == 4)
{
if (this.papertype == 1)
{
asposeWordApp.Writeln(num2 + "、" + this.FmAnswer(examQuestion.title), 12.0, false, "left");
asposeWordApp.Writeln("答案：" + examQuestion.answer, 12.0, false, "left");
if (examQuestion.explain != "")
{
asposeWordApp.Writeln("答案解析：" + examQuestion.explain, 12.0, false, "left");
}
}
else
{
asposeWordApp.Writeln(num2 + "、" + this.FmAnswer(examQuestion.title), 12.0, false, "left");
}
}
else if (examQuestion.type == 5)
{
if (this.papertype == 1)
{
asposeWordApp.Writeln(num2 + "、" + examQuestion.title, 12.0, false, "left");
asposeWordApp.Writeln("答：" + examQuestion.answer, 12.0, false, "left");
if (examQuestion.explain != "")
{
asposeWordApp.Writeln("答案解析：" + examQuestion.explain, 12.0, false, "left");
}
}
else
{
asposeWordApp.Writeln(num2 + "、" + examQuestion.title, 12.0, false, "left");
asposeWordApp.InsertLineBreak(6);
}
}
else if (examQuestion.type == 6)
{
asposeWordApp.Writeln(num2 + "、" + examQuestion.title, 12.0, false, "left");
}
num2++;
}
}
if (this.papertype == 0)
{
asposeWordApp.InsertPagebreak();
asposeWordApp.Writeln("参考答案", 12.0, true, "center");
num2 = 1;
foreach (ExamTopic examTopic in this.examtopiclist)
{
asposeWordApp.InsertLineBreak();
asposeWordApp.Writeln(examTopic.title, 12.0, true, "left");
foreach (ExamQuestion examQuestion in this.GetQuestionList(examTopic.questionlist))
{
if (examQuestion.type == 3)
{
asposeWordApp.Write((num2 + "、" + examQuestion.answer == "Y") ? "正确" : "错误 ", 12.0, false, "left");
}
else if (examQuestion.type == 6)
{
asposeWordApp.Write(num2 + "、请按题目打字 ", 12.0, false, "left");
}
else
{
asposeWordApp.Write(string.Concat(new object[]
{
num2,
"、",
examQuestion.answer,
" "
}), 12.0, false, "left");
}
num2++;
}
}
}
asposeWordApp.Save(base.Response, this.examinfo.name + this.GetPaper(this.paper) + ".doc");
}
}
// Token: 0x0600008E RID: 142 RVA: 0x0000DE5C File Offset: 0x0000C05C
protected override void View()
{
base.Response.Expires = 0;
base.Response.CacheControl = "no-cache";
base.Response.Cache.SetNoStore();
this.examconfig = ExamConifgs.GetExamConfig();
this.examresult = ExamBll.GetExamResult(this.resultid);
if (this.examresult.id == 0)
{
this.ShowErr("对不起，该考试不存在或已被删除。");
}
else if (this.examresult.uid != this.userid)
{
this.ShowErr("对不起，您不是本次考试的主人。");
}
else if (this.examresult.status == 1)
{
this.ShowErr("对不起，该考试已完成。");
}
else
{
this.examinfo = DbHelper.ExecuteModel <ExamInfo>(this.examresult.examid);
if (this.examresult.islimit == 1)
{
if (this.examresult.starttime <= DateTime.Now && DateTime.Now <= this.examresult.endtime)
{
TimeSpan timeSpan = new TimeSpan(DateTime.Now.Ticks);
TimeSpan ts = new TimeSpan(this.examresult.starttime.Ticks);
TimeSpan timeSpan2 = timeSpan.Subtract(ts).Duration();
this.examresult.utime = Convert.ToInt32(timeSpan2.TotalSeconds);
}
else
{
this.examresult.utime = this.examresult.examtime * 60;
}
DbHelper.ExecuteUpdate <ExamResult>(this.examresult);
}
if (this.examresult.examtype == 1)
{
string macAddress = ExamConifgs.GetMacAddress(this.ip);
if (this.examresult.ip != "")
{
if (this.examresult.ip != this.ip || this.examresult.mac != macAddress)
{
this.ShowErr("对不起，请在固定位置上进行考试。");
return;
}
}
else
{
SqlParam[] sqlparams = new SqlParam[]
{
DbHelper.MakeSet("ip", this.ip),
DbHelper.MakeSet("mac", macAddress),
DbHelper.MakeAndWhere("id", this.resultid)
};
DbHelper.ExecuteUpdate <ExamResult>(sqlparams);
}
}
this.sortid = this.examresult.sortid;
this.sortinfo = SortBll.GetSortInfo(this.sortid);
this.examresult.passmark = this.examresult.passmark * this.examresult.total / 100.0;
this.examtopiclist = ExamBll.GetExamResultTopicList(this.resultid);
this.questionlist = new int[this.examresult.questions];
int num = this.examresult.examtime * 60 - this.examresult.utime;
int num2 = num / 3600;
int num3 = (num - num2 * 3600) / 60;
int num4 = (num - num2 * 3600 - num3 * 60) % 60;
this.thetime = string.Concat(new string[]
{
num2.ToString("00"),
":",
num3.ToString("00"),
":",
num4.ToString("00")
});
}
}
// Token: 0x06000036 RID: 54 RVA: 0x00004444 File Offset: 0x00002644
protected override void View()
{
this.examconfig = ExamConifgs.GetExamConfig();
if (this.id > 0)
{
this.examinfo = DbHelper.ExecuteModel <ExamInfo>(this.id);
if (this.examinfo.id == 0)
{
this.ShowErr("对不起，该试卷不存在或已被删除。");
return;
}
this.sortid = this.examinfo.sortid;
}
this.sortinfo = SortBll.GetSortInfo(this.sortid);
if (this.sortinfo.id == 0)
{
this.ShowErr("对不起，该栏目不存在或已被删除。");
}
else
{
if (this.examinfo.islimit == 0)
{
this.examinfo.starttime = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd HH:mm"));
this.examinfo.endtime = this.examinfo.starttime.AddMinutes((double)this.examinfo.examtime);
}
if (this.ispost)
{
if (this.action == "saveas")
{
this.examinfo.name = this.examinfo.name + "_复制";
this.examinfo.score = 0.0;
this.examinfo.exams = 0;
int examid = DbHelper.ExecuteInsert <ExamInfo>(this.examinfo);
SqlParam sqlParam = DbHelper.MakeAndWhere("examid", this.id);
List <ExpInfo> list = DbHelper.ExecuteList <ExpInfo>(OrderBy.ASC, new SqlParam[]
{
sqlParam
});
int num = 0;
foreach (ExpInfo expInfo in list)
{
list[num].examid = examid;
DbHelper.ExecuteInsert <ExpInfo>(list[num]);
num++;
}
List <ExamTopic> list2 = DbHelper.ExecuteList <ExamTopic>(new SqlParam[]
{
sqlParam
});
num = 0;
foreach (ExamTopic examTopic in list2)
{
list2[num].examid = examid;
DbHelper.ExecuteInsert <ExamTopic>(list2[num]);
num++;
}
base.AddMsg("考试另存成功！");
}
else
{
this.examinfo.islimit = 0;
this.examinfo.showanswer = 0;
this.examinfo.allowdelete = 0;
this.examinfo.iscopy = 0;
this.examinfo.examtype = 0;
this.examinfo.channelid = this.sortinfo.channelid;
this.examinfo.examroles = "";
this.examinfo = FPRequest.GetModel <ExamInfo>(this.examinfo);
if (this.examinfo.name == "")
{
this.ShowErr("考试名称不能为空。");
return;
}
if (this.examinfo.papers <= 0)
{
this.examinfo.papers = 1;
}
if (this.examinfo.islimit == 1)
{
if (this.examinfo.endtime <= this.examinfo.starttime)
{
this.ShowErr("对不起，考试结束时间必须大于开始时间。");
return;
}
TimeSpan timeSpan = new TimeSpan(this.examinfo.endtime.Ticks);
TimeSpan ts = new TimeSpan(this.examinfo.starttime.Ticks);
TimeSpan timeSpan2 = timeSpan.Subtract(ts).Duration();
this.examinfo.examtime = Convert.ToInt32(timeSpan2.TotalMinutes);
}
if (this.examinfo.id > 0)
{
DbHelper.ExecuteUpdate <ExamInfo>(this.examinfo);
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.AppendFormat("UPDATE [{0}Exam_ExamResult] SET [examname]='{1}' WHERE [examid]={2}|", DbConfigs.Prefix, DbUtils.RegEsc(this.examinfo.name), this.examinfo.id);
if (DbConfigs.DbType == DbType.Access)
{
stringBuilder.AppendFormat("UPDATE [{0}Exam_ExamResult] SET [passmark]={1},[examtime]={2},[examtype]={3},[showanswer]={4},[allowdelete]={5},[islimit]={6},[endtime]=#{7}# WHERE [examid]={8} AND [status]=0", new object[]
{
DbConfigs.Prefix,
this.examinfo.passmark,
this.examinfo.examtime,
this.examinfo.examtype,
this.examinfo.showanswer,
this.examinfo.allowdelete,
this.examinfo.islimit,
this.examinfo.endtime,
this.examinfo.id
});
}
else
{
stringBuilder.AppendFormat("UPDATE [{0}Exam_ExamResult] SET [passmark]={1},[examtime]={2},[examtype]={3},[showanswer]={4},[allowdelete]={5},[islimit]={6},[endtime]='{7}' WHERE [examid]={8} AND [status]=0", new object[]
{
DbConfigs.Prefix,
this.examinfo.passmark,
this.examinfo.examtime,
this.examinfo.examtype,
this.examinfo.showanswer,
this.examinfo.allowdelete,
this.examinfo.islimit,
this.examinfo.endtime,
this.examinfo.id
});
}
DbHelper.ExecuteSql(stringBuilder.ToString());
base.AddMsg("更新考试成功！");
}
else
{
this.examinfo.uid = this.userid;
this.examinfo.id = DbHelper.ExecuteInsert <ExamInfo>(this.examinfo);
ExamBll.AddExamLarge(this.examinfo.id);
base.AddMsg("添加考试成功！");
}
int num2 = 0;
double num3;
if (this.examinfo.examdeparts == "" && this.examinfo.examuser == "" && this.examinfo.examroles == "")
{
SqlParam sqlParam2 = DbHelper.MakeAndWhere("examid", this.examinfo.id);
num2 = DbHelper.ExecuteCount <ExamResult>(new SqlParam[]
{
sqlParam2
});
num3 = FPUtils.StrToDouble(DbHelper.ExecuteSum <ExamResult>("score", new SqlParam[]
{
sqlParam2
}));
}
else
{
string text = "";
if (this.examinfo.examroles != "")
{
SqlParam sqlParam3 = DbHelper.MakeAndWhere("roleid", WhereType.In, this.examinfo.examroles);
List <UserInfo> list3 = DbHelper.ExecuteList <UserInfo>(new SqlParam[]
{
sqlParam3
});
foreach (UserInfo userInfo in list3)
{
if (!FPUtils.InArray(userInfo.id, text))
{
if (text != "")
{
text += ",";
}
text += userInfo.id;
num2++;
}
}
}
if (this.examinfo.examdeparts != "")
{
SqlParam sqlParam3 = DbHelper.MakeAndWhere("departid", WhereType.In, this.examinfo.examdeparts);
List <UserInfo> list3 = DbHelper.ExecuteList <UserInfo>(new SqlParam[]
{
sqlParam3
});
foreach (UserInfo userInfo in list3)
{
if (!FPUtils.InArray(userInfo.id, text))
{
if (text != "")
{
text += ",";
}
text += userInfo.id;
num2++;
}
}
}
if (this.examinfo.examuser != "")
{
SqlParam sqlParam3 = DbHelper.MakeAndWhere("id", WhereType.In, this.examinfo.examuser);
List <UserInfo> list3 = DbHelper.ExecuteList <UserInfo>(new SqlParam[]
{
sqlParam3
});
foreach (UserInfo userInfo in list3)
{
if (!FPUtils.InArray(userInfo.id, text))
{
if (text != "")
{
text += ",";
}
text += userInfo.id;
num2++;
}
}
}
string sqlstring = string.Format("DELETE FROM [{0}Exam_ExamResult] WHERE [examid]={1} AND [uid] NOT IN({2})", DbConfigs.Prefix, this.examinfo.id, text);
DbHelper.ExecuteSql(sqlstring);
SqlParam[] sqlparams = new SqlParam[]
{
DbHelper.MakeAndWhere("examid", this.examinfo.id),
DbHelper.MakeAndWhere("uid", WhereType.NotIn, text)
};
num3 = FPUtils.StrToDouble(DbHelper.ExecuteSum <ExamResult>("score", sqlparams));
}
string sqlstring2 = string.Format("UPDATE [{0}Exam_ExamInfo] SET [exams]={1},[score]={2} WHERE [id]={3}", new object[]
{
DbConfigs.Prefix,
num2,
num3,
this.examinfo.id
});
DbHelper.ExecuteSql(sqlstring2);
}
if (this.tabactive == 1)
{
this.link = "exammanage.aspx?sortid=" + this.sortid;
}
else
{
this.link = string.Concat(new object[]
{
"examadd.aspx?sortid=",
this.sortid,
"&tabactive=",
this.tabactive,
"&id=",
this.examinfo.id
});
}
}
else
{
this.rolelist = DbHelper.ExecuteList <RoleInfo>();
SqlParam sqlParam4 = DbHelper.MakeAndWhere("id", WhereType.In, this.sortinfo.types);
OrderByParam orderby = DbHelper.MakeOrderBy("display", OrderBy.ASC);
this.typelist = DbHelper.ExecuteList <TypeInfo>(orderby, new SqlParam[]
{
sqlParam4
});
this.zNodes = this.GetDepartTree(0);
base.SaveRightURL();
}
}
}
