public double ZHLXFillScore(string FillPNo_A, string LibraryNo) { var system = new jc_System(); if (system.FillAutoScore) { var num = 0.0; if (!(system.getFillAutoScore() == "true")) { return 0.0; } if (!(FillPNo_A != "")) { return 0.0; } num = getFillScore(FillPNo_A, LibraryNo); if (HttpContext.Current.Session["StartLxTime"] != null) { string str = HttpContext.Current.Session["StartLxTime"].ToString(); var strsql = string.Concat("update jc_ExerciseLog set Score=[Score]+", num, " where StartLxTime='", str, "'"); try { DbHelperSQL.ExecuteSql(strsql); HttpContext.Current.Session.Remove("StartLxTime"); } catch { return 0.0; } } return num; } return 0.0; }
public bool TestSumbit(string TestInfo) { double num = 0.0; jc_System system = new jc_System(); try { double num3; string str2; double num4; string str3; double num5; string str4; string str5; double num6; string str6; double num7; string str13; SqlDataReader reader; string str18; string[] strArray = new string[1]; strArray = TestInfo.Split(new char[] { '|' }); double num2 = 0.0; string str = ""; if (strArray[0].ToString() != "Empty") { num3 = Convert.ToDouble(strArray[0].ToString()); num2 += num3; } else { num3 = -1.0; } if (!(num3 == -1.0)) { str2 = strArray[1].ToString(); } else { str2 = ""; } if (strArray[2].ToString() != "Empty") { num4 = Convert.ToDouble(strArray[2].ToString()); num2 += num4; } else { num4 = -1.0; } if (!(num4 == -1.0)) { str3 = strArray[3].ToString(); } else { str3 = ""; } if (strArray[4].ToString() != "Empty") { num5 = Convert.ToDouble(strArray[4].ToString()); num2 += num5; } else { num5 = -1.0; } if (!(num5 == -1.0)) { str4 = strArray[5].ToString(); } else { str4 = ""; } if (strArray[6].ToString() != "Empty") { str5 = strArray[6].ToString(); num6 = 0.0; } else { str5 = ""; num6 = -1.0; } if (strArray[7].ToString() != "Empty") { str6 = strArray[7].ToString(); num7 = 0.0; } else { str6 = ""; num7 = -1.0; } double num8 = Convert.ToDouble(strArray[12].ToString()); string str7 = strArray[8].ToString(); strArray[9].ToString(); string librayNo = strArray[10].ToString(); strArray[11].ToString(); string str9 = strArray[13].ToString(); strArray[14].ToString(); string str10 = strArray[15].ToString(); int num9 = Convert.ToInt32(strArray[0x10].ToString()); strArray[0x11].ToString(); string str11 = strArray[0x12].ToString(); int length = str11.Length; for (int i = 0; i < length; i++) { char ch = str11[i]; if (ch.ToString() == "&") { str = str + "|"; } else { str = str + str11[i].ToString(); } } string strcmd = ""; if (num2 >= num8) { str13 = "及格"; } else { str13 = "不及格"; } if ((str5 == "") && (str6 == "")) { if (num2 >= num8) { str13 = "及格"; } else { str13 = "不及格"; } string TestLogGuid = Guid.NewGuid().ToString(); strcmd = string.Concat(new object[] { "INSERT INTO [jc_TestLog]\r\n ([SubjectNo],[LibraryNo],[UserIdCard],[TestTime],[TimerLong],[RadioScore],[MoreScore],[BoolScore],[FillScore],[QAScore],[TotalScore]\r\n ,[FillNo_Answer],[QANo_Answer],[Pass],[Already],[PaperLog],[TestLogGuid])\r\n VALUES (\r\n '", str7, "',", librayNo, ",'", str9, "','", str10, "',", num9, ",", num3, ",", num4, ",", num5, ",", num6, ",", num7, ",", num2, ",'','','", str13, "',1,'", str, "'"+",'"+TestLogGuid+"')" }); AddTestDetails(TestLogGuid, str7, int.Parse(librayNo), str); } else if (system.FillAutoScore) { if (system.getFillAutoScore() == "true") { if ((str5 != "") && (str6 != "")) { num = this.getFillScore(str5, librayNo); num2 += num; if (num2 >= num8) { str13 = "及格"; } else { str13 = "不及格"; } string TestLogGuid = Guid.NewGuid().ToString(); HttpContext.Current.Session["FillResult"] = num.ToString("F1"); strcmd = string.Concat(new object[] { "INSERT INTO [jc_TestLog]\r\n ([SubjectNo],[LibraryNo],[UserIdCard],[TestTime],[TimerLong],[RadioScore],[MoreScore],[BoolScore],[FillScore],[QAScore],[TotalScore]\r\n ,[FillNo_Answer],[QANo_Answer],[Pass],[Already],[PaperLog],[TestLogGuid])\r\n VALUES (\r\n '", str7, "',", librayNo, ",'", str9, "','", str10, "',", num9, ",", num3, ",", num4, ",", num5, ",", num, ",", num7, ",0,'','", str6, "','", str13, "',0,'", str, "')" }); AddTestDetails(TestLogGuid, str7, int.Parse(librayNo), str); } else if ((str5 != "") && (str6 == "")) { num = this.getFillScore(str5, librayNo); num2 += num; if (num2 >= num8) { str13 = "及格"; } else { str13 = "不及格"; } HttpContext.Current.Session["FillResult"] = num.ToString("F1"); string TestLogGuid = Guid.NewGuid().ToString(); strcmd = string.Concat(new object[] { "INSERT INTO [jc_TestLog]\r\n ([SubjectNo],[LibraryNo],[UserIdCard],[TestTime],[TimerLong],[RadioScore],[MoreScore],[BoolScore],[FillScore],[QAScore],[TotalScore]\r\n ,[FillNo_Answer],[QANo_Answer],[Pass],[Already],[PaperLog],[TestLogGuid])\r\n VALUES (\r\n '", str7, "',", librayNo, ",'", str9, "','", str10, "',", num9, ",", num3, ",", num4, ",", num5, ",", num, ",", num7, ",", num2, ",'','','", str13, "',1,'",str, "'"+",'"+TestLogGuid+"')" }); AddTestDetails(TestLogGuid, str7, int.Parse(librayNo), str); } else if ((str5 == "") && (str6 != "")) { string TestLogGuid = Guid.NewGuid().ToString(); strcmd = string.Concat(new object[] { "INSERT INTO [jc_TestLog]\r\n ([SubjectNo],[LibraryNo],[UserIdCard],[TestTime],[TimerLong],[RadioScore],[MoreScore],[BoolScore],[FillScore],[QAScore],[TotalScore]\r\n ,[FillNo_Answer],[QANo_Answer],[Pass],[Already],[PaperLog],[TestLogGuid])\r\n VALUES (\r\n '", str7, "',", librayNo, ",'", str9, "','", str10, "',", num9, ",", num3, ",", num4, ",", num5, ",", num6, ",", num7, ",0,'','", str6, "','", str13, "',0,'", str, "'"+",'"+TestLogGuid+"')" }); AddTestDetails(TestLogGuid, str7, int.Parse(librayNo), str); } } else { string TestLogGuid = Guid.NewGuid().ToString(); strcmd = string.Concat(new object[] { "INSERT INTO [jc_TestLog]\r\n ([SubjectNo],[LibraryNo],[UserIdCard],[TestTime],[TimerLong],[RadioScore],[MoreScore],[BoolScore],[FillScore],[QAScore],[TotalScore]\r\n ,[FillNo_Answer],[QANo_Answer],[Pass],[Already],[PaperLog],[TestLogGuid])\r\n VALUES (\r\n '", str7, "',", librayNo, ",'", str9, "','", str10, "',", num9, ",", num3, ",", num4, ",", num5, ",", num6, ",", num7, ",0,'", str5, "','", str6, "','", str13, "',0,'", str, "'"+",'"+TestLogGuid+"')" }); AddTestDetails(TestLogGuid, str7, int.Parse(librayNo), str); } } else { string TestLogGuid = Guid.NewGuid().ToString(); strcmd = string.Concat(new object[] { "INSERT INTO [jc_TestLog]\r\n ([SubjectNo],[LibraryNo],[UserIdCard],[TestTime],[TimerLong],[RadioScore],[MoreScore],[BoolScore],[FillScore],[QAScore],[TotalScore]\r\n ,[FillNo_Answer],[QANo_Answer],[Pass],[Already],[PaperLog],[TestLogGuid])\r\n VALUES (\r\n '", str7, "',", librayNo, ",'", str9, "','", str10, "',", num9, ",", num3, ",", num4, ",", num5, ",", num6, ",", num7, ",0,'", str5, "','", str6, "','", str13, "',0,'", str, "'"+",'"+TestLogGuid+"')" }); AddTestDetails(TestLogGuid, str7, int.Parse(librayNo), str); } SqlCommand command = this.db.getcmd(strcmd); try { command.ExecuteNonQuery(); command.Dispose(); } catch { command.Dispose(); this.db.CnClose(); return false; } this.db.CnClose(); string[] strArray2 = new string[1]; string str14 = ""; string str15 = "delete from jc_AutoSave where UserIdCard='" + str9 + "'"; SqlCommand command2 = this.db.getcmd(str15); try { command2.ExecuteNonQuery(); command2.Dispose(); } catch { command2.Dispose(); this.db.CnClose(); } if (system.Reexam) { string str16 = ""; string str17 = "select Reexam from jc_Library where LibraryNo=" + librayNo; command2 = this.db.getcmd(str17); reader = command2.ExecuteReader(); try { reader.Read(); str16 = reader["Reexam"].ToString(); reader.Close(); command2.Dispose(); this.db.CnClose(); } catch { reader.Close(); command2.Dispose(); this.db.CnClose(); return false; } if (!(str16 == "False")) { goto Label_0E6C; } str18 = ""; str15 = "select ProhibitLibrary from jc_User where UserIdCard='" + str9 + "'"; command2 = this.db.getcmd(str15); reader = command2.ExecuteReader(); try { reader.Read(); str18 = reader["ProhibitLibrary"].ToString(); reader.Close(); command2.Dispose(); this.db.CnClose(); } catch { reader.Close(); command2.Dispose(); this.db.CnClose(); return false; } if (str18.IndexOf(librayNo) >= 0) { goto Label_0E6C; } str18 = str18 + librayNo + ","; str15 = "update jc_User set ProhibitLibrary='" + str18 + "' where UserIdCard='" + str9 + "'"; command2 = this.db.getcmd(str15); try { command2.ExecuteNonQuery(); this.db.CnClose(); goto Label_0E6C; } catch { command2.Dispose(); this.db.CnClose(); return false; } } str15 = "select ProhibitLibrary from jc_User where UserIdCard='" + str9 + "'"; str18 = ""; command2 = this.db.getcmd(str15); reader = command2.ExecuteReader(); try { reader.Read(); str18 = reader["ProhibitLibrary"].ToString(); reader.Close(); command2.Dispose(); this.db.CnClose(); } catch { reader.Close(); command2.Dispose(); this.db.CnClose(); return false; } if (str18.IndexOf(librayNo + ",") < 0) { str18 = str18 + librayNo + ","; str15 = "update jc_User set ProhibitLibrary='" + str18 + "' where UserIdCard='" + str9 + "'"; command2 = this.db.getcmd(str15); try { command2.ExecuteNonQuery(); this.db.CnClose(); } catch { command2.Dispose(); this.db.CnClose(); return false; } } Label_0E6C: if (str2 != "") { strArray2 = str2.Split(new char[] { '^' }); int index = 0; while (true) { if (index >= (strArray2.Length - 1)) { break; } if (this.getPType(strArray2[index].ToString()) != "Error") { str14 = "Insert into jc_ErrorPaper\r\n (PaperNo,UserIdCard)\r\n values(\r\n " + strArray2[index].ToString() + ",'" + str9 + "')"; command2 = this.db.getcmd(str14); try { command2.ExecuteNonQuery(); command2.Dispose(); } catch { command2.Dispose(); this.db.CnClose(); } } index++; } this.db.CnClose(); } strArray2 = null; if (str3 != "") { strArray2 = str3.Split(new char[] { '^' }); int num13 = 0; while (true) { if (num13 >= (strArray2.Length - 1)) { break; } if (this.getPType(strArray2[num13].ToString()) != "Error") { str14 = "Insert into jc_ErrorPaper\r\n (PaperNo,UserIdCard)\r\n values(\r\n " + strArray2[num13].ToString() + ",'" + str9 + "')"; command2 = this.db.getcmd(str14); try { command2.ExecuteNonQuery(); command2.Dispose(); } catch { command2.Dispose(); this.db.CnClose(); } } num13++; } this.db.CnClose(); } strArray2 = null; if (str4 != "") { strArray2 = str4.Split(new char[] { '^' }); int num14 = 0; while (true) { if (num14 >= (strArray2.Length - 1)) { break; } if (this.getPType(strArray2[num14].ToString()) != "Error") { str14 = "Insert into jc_ErrorPaper\r\n (PaperNo,UserIdCard)\r\n values(\r\n " + strArray2[num14].ToString() + ",'" + str9 + "')"; command2 = this.db.getcmd(str14); try { command2.ExecuteNonQuery(); command2.Dispose(); } catch { command2.Dispose(); } } num14++; } this.db.CnClose(); } HttpContext.Current.Session["UserIdCard"] = str9; return true; } catch { return false; } }
public string getLibraryList(string sql, string OperateType) { string str = ""; jc_System system = new jc_System(); SqlDataReader reader = DbHelperSQL.ExecuteReader(sql); try { while (reader.Read()) { string str2; if (reader["LibraryType"].ToString() == "B") { if (OperateType == "modify") { str2 = str; str = str2 + "<tr style='color:#00572c; font-weight:bold; background-color:#ffe8e8;' id=\"tr" + reader["LibraryNo"].ToString() + "\" onmousemove=changetr('" + reader["LibraryNo"].ToString() + "') onmouseout=backtr('" + reader["LibraryNo"].ToString() + "') onclick=SelectDel('" + reader["LibraryNo"].ToString() + "')>"; str2 = str; str = str2 + "<td class=\"td_bg\" style=\"text-align:center;\"><input id=\"chk_" + reader["LibraryNo"].ToString() + "\" type=\"checkbox\" onclick=SelectDel('" + reader["LibraryNo"].ToString() + "') /></td>"; } else { str = str + "<tr style='color:#00572c; font-weight:bold; background-color:#ffe8e8;'>"; } } else if (OperateType == "modify") { str2 = str; str = str2 + "<tr id=\"tr" + reader["LibraryNo"].ToString() + "\" onmousemove=changetr('" + reader["LibraryNo"].ToString() + "') onmouseout=backtr('" + reader["LibraryNo"].ToString() + "') class=\"trr_bg1\" onclick=SelectDel('" + reader["LibraryNo"].ToString() + "')>"; str2 = str; str = str2 + "<td style=\"text-align:center;\"><input id=\"chk_" + reader["LibraryNo"].ToString() + "\" type=\"checkbox\" onclick=SelectDel('" + reader["LibraryNo"].ToString() + "') /></td>"; } else { str = str + "<tr>"; } str = str + "<td class=\"td_bg\">" + reader["LibraryName"].ToString() + "</td>"; if (reader["LibraryType"].ToString() == "A") { str = str + "<td class=\"td_bg\">练习试卷</td>"; } else if (reader["LibraryType"].ToString() == "B") { str = str + "<td class=\"td_bg\">考试试卷</td>"; } if (reader["LibraryProperties"].ToString() == "A") { str = str + "<td class=\"td_bg\">固定试卷</td>"; } else if (reader["LibraryProperties"].ToString() == "B") { str = str + "<td class=\"td_bg\">随机试卷</td>"; } string str3 = "<span style='color:#808080;'>0</span>"; if (reader["Radio"].ToString() == "0") { str = str + "<td class=\"td_bg\">" + str3 + "道</td>"; } else { str = str + "<td class=\"td_bg\">" + reader["Radio"].ToString() + "道</td>"; } if (reader["More"].ToString() == "0") { str = str + "<td class=\"td_bg\">" + str3 + "道</td>"; } else { str = str + "<td class=\"td_bg\">" + reader["More"].ToString() + "道</td>"; } if (reader["Bool"].ToString() == "0") { str = str + "<td class=\"td_bg\">" + str3 + "道</td>"; } else { str = str + "<td class=\"td_bg\">" + reader["Bool"].ToString() + "道</td>"; } if (reader["Fill"].ToString() == "0") { str = str + "<td class=\"td_bg\">" + str3 + "道</td>"; } else { str = str + "<td class=\"td_bg\">" + reader["Fill"].ToString() + "道</td>"; } str = str + "<td class=\"td_bg\">" + reader["Total"].ToString() + "道</td>"; string[] strArray2 = reader["LibraryScore"].ToString().Split(new char[] { ',' }); str3 = ""; if (strArray2[0] == "0") { str3 = "单选:<span style='color:#808080;'>未抽题</span><br />"; } else { str3 = "单选:" + strArray2[0] + "分<br />"; } if (strArray2[1] == "0") { str3 = str3 + "多选:<span style='color:#808080;'>未抽题</span><br />"; } else { str3 = str3 + "多选:" + strArray2[1] + "分<br />"; } if (strArray2[2] == "0") { str3 = str3 + "判断:<span style='color:#808080;'>未抽题</span><br />"; } else { str3 = str3 + "判断:" + strArray2[2] + "分<br />"; } if (strArray2[3] == "0") { str3 = str3 + "排序:<span style='color:#808080;'>未抽题</span><br />"; } else { str3 = str3 + "排序:" + strArray2[3] + "分<br />"; } if (strArray2[4] == "0") { str3 = str3 + "问答:<span style='color:#808080;'>未抽题</span><br />"; } else { str3 = str3 + "问答:" + strArray2[4] + "分<br />"; } str = str + "<td class=\"td_bg\">" + str3 + "</td>"; str = str + "<td class=\"td_bg\">" + reader["TotalScore"].ToString() + "分</td>"; str = str + "<td class=\"td_bg\">" + reader["PassingGrade"].ToString() + "分</td>"; str = str + "<td class=\"td_bg\">" + reader["TestTime"].ToString() + "分钟</td>"; string str4 = reader["fixedNo"].ToString(); if (str4 != "") { str = str + "<td class=\"td_bg\"><span style=' cursor:pointer;' onclick='showFixNo(\"" + str4 + "\");'>显示编号</span></td>"; } else { str = str + "<td class=\"td_bg\"><span style='color:#808080;'>无</span></td>"; } if (reader["LibraryLayout"].ToString() == "More") { str = str + "<td class=\"td_bg\">题型模式</td>"; } else { str = str + "<td class=\"td_bg\">单题模式</td>"; } if (system.Reexam) { if (reader["Reexam"].ToString() == "True") { str = str + "<td class=\"td_bg\">可复考</td>"; } else { str = str + "<td class=\"td_bg\">禁止复考</td>"; } } if ((reader["StartDate"].ToString() != "") && (reader["EndDate"].ToString() != "")) { str2 = str; str = str2 + "<td class=\"td_bg\">" + reader["StartDate"].ToString() + "<br />至<br />" + reader["EndDate"].ToString() + "</td>"; } else { str = str + "<td class=\"td_bg\"><span style='color:red;text-align:center;'>任何时间</span></td>"; } if (OperateType == "modify") { str = str + "<td class=\"td_bg\"><a href=Md_Library.aspx?LibraryNo=" + reader["LibraryNo"].ToString() + " name='a_md'><img src=\"../images/Modiy.gif\" border=\"0\" /></a><br />"; str = str + "<img src=\"../images/delete.gif\" style=\" cursor:pointer;\" border=\"0\" onclick=\"del('" + reader["LibraryNo"].ToString() + "');\" /></td></tr>"; } str = str + "</tr>"; } reader.Close(); } catch { reader.Close(); } return str; }
public string getLibraryMaxtime(string strParameters) { jc_System system = new jc_System(); if (strParameters == "zjlx") { return system.getSystemValue("UnitLxTime"); } if (strParameters == "txlx") { return system.getSystemValue("PtypeLxTime"); } if (strParameters == "ctlx") { return system.getSystemValue("ErrorLxTime"); } string strSql = "select TestTime from jc_Library where LibraryNo=" + strParameters; object obj = DbHelperSQL.GetSingle(strSql.ToString()); if (obj == null) { return ""; } else { return obj.ToString(); } }
public string getLibraryLayout(string strParameters) { jc_System system = new jc_System(); if (strParameters == "zjlx") { return system.getSystemValue("zjLxLayout"); } if (strParameters == "txlx") { return system.getSystemValue("txlxLayout"); } if (strParameters == "ctlx") { return system.getSystemValue("ctlxLayout"); } string strSql = "select LibraryLayout from jc_Library where LibraryNo=" + strParameters; object obj = DbHelperSQL.GetSingle(strSql.ToString()); if (obj == null) { return ""; } else { return obj.ToString(); } }