Esempio n. 1
0
        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;
        }
Esempio n. 2
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;
            }
        }