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; } }