Example #1
0
    protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
    {
        //~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
        ZWL.BLL.ERPTiKuKaoShi Model0 = new ZWL.BLL.ERPTiKuKaoShi();
        Model0.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName");
        Model0.TimeStr = DateTime.Now;
        Model0.ShiJuanName = this.DropDownList1.SelectedItem.Text;
        Model0.ShiJuanID = int.Parse(this.DropDownList1.SelectedValue);
        int MaxID=Model0.Add();

        this.Panel1.Visible = false;
        //��ȡ�Ծ���Ϣ
        ZWL.BLL.ERPTiKuShiJuan Model = new ZWL.BLL.ERPTiKuShiJuan();
        Model.GetModel(int.Parse(this.DropDownList1.SelectedItem.Value.ToString()));
        MaxTime = int.Parse(Model.KaoShiXianShi.ToString()) * 60;//������ʱ

        string[] FenLeiSunXu = Model.FenLeiShunXu.Split('|');
        for (int j = 0; j < FenLeiSunXu.Length; j++)
        {
            //�󶨵�ǰ��Ŀ���е���Ŀ
            string TiMuIDList = "0";
            if (FenLeiSunXu[j].ToString() == "���")
            {
                TiMuIDList = this.Lab1.Text;
                DataSet MYDT = ZWL.DBUtility.DbHelperSQL.GetDataSet("select * from ERPTiKu where ID in('" + TiMuIDList.Replace(",", "','") + "')");
                for (int i = 0; i < MYDT.Tables[0].Rows.Count; i++)
                {
                    ZWL.BLL.ERPTiKuKaoShiJieGuo Model1 = new ZWL.BLL.ERPTiKuKaoShiJieGuo();

                    Model1.KaoShiID = MaxID;
                    Model1.TiMuID =int.Parse(MYDT.Tables[0].Rows[i]["ID"].ToString());
                    Model1.DaAn = MYDT.Tables[0].Rows[i]["AnswerStr"].ToString();
                    string UserDaAnStr = "";
                    try
                    {
                        UserDaAnStr= Request.Form["rad-" + MYDT.Tables[0].Rows[i]["ID"].ToString()].ToString();
                    }
                    catch { }
                    Model1.UserDaAn = UserDaAnStr;
                    if (UserDaAnStr == MYDT.Tables[0].Rows[i]["AnswerStr"].ToString())
                    {
                        Model1.DeFen = Model.PanDuanFenShu;
                    }
                    else
                    {
                        Model1.DeFen = 0;
                    }
                    Model1.Add();
                }
            }
            else if (FenLeiSunXu[j].ToString() == "����ѡ����")
            {
                TiMuIDList = this.Lab2.Text;
                DataSet MYDT = ZWL.DBUtility.DbHelperSQL.GetDataSet("select * from ERPTiKu where ID in('" + TiMuIDList.Replace(",", "','") + "')");
                for (int i = 0; i < MYDT.Tables[0].Rows.Count; i++)
                {
                    ZWL.BLL.ERPTiKuKaoShiJieGuo Model1 = new ZWL.BLL.ERPTiKuKaoShiJieGuo();

                    Model1.KaoShiID = MaxID;
                    Model1.TiMuID = int.Parse(MYDT.Tables[0].Rows[i]["ID"].ToString());
                    Model1.DaAn = MYDT.Tables[0].Rows[i]["AnswerStr"].ToString();
                    string UserDaAnStr = "";
                    try
                    {
                        UserDaAnStr = Request.Form["rad-" + MYDT.Tables[0].Rows[i]["ID"].ToString()].ToString();
                    }
                    catch { }
                    Model1.UserDaAn = UserDaAnStr;
                    if (UserDaAnStr == MYDT.Tables[0].Rows[i]["AnswerStr"].ToString())
                    {
                        Model1.DeFen = Model.DanXuanFenShu;
                    }
                    else
                    {
                        Model1.DeFen = 0;
                    }
                    Model1.Add();
                }
            }
            else if (FenLeiSunXu[j].ToString() == "����ѡ����")
            {
                TiMuIDList = this.Lab3.Text;
                DataSet MYDT = ZWL.DBUtility.DbHelperSQL.GetDataSet("select * from ERPTiKu where ID in('" + TiMuIDList.Replace(",", "','") + "')");
                for (int i = 0; i < MYDT.Tables[0].Rows.Count; i++)
                {
                    ZWL.BLL.ERPTiKuKaoShiJieGuo Model1 = new ZWL.BLL.ERPTiKuKaoShiJieGuo();

                    Model1.KaoShiID = MaxID;
                    Model1.TiMuID = int.Parse(MYDT.Tables[0].Rows[i]["ID"].ToString());
                    Model1.DaAn = MYDT.Tables[0].Rows[i]["AnswerStr"].ToString();

                    string DangQianDaAnStr = "";
                    try
                    {
                        DangQianDaAnStr = DangQianDaAnStr + Request.Form["CHK-" + MYDT.Tables[0].Rows[i]["ID"].ToString() + "-A"].ToString();
                    }
                    catch { }
                    try
                    {
                        DangQianDaAnStr = DangQianDaAnStr + Request.Form["CHK-" + MYDT.Tables[0].Rows[i]["ID"].ToString() + "-B"].ToString();
                    }
                    catch { }
                    try
                    {
                        DangQianDaAnStr = DangQianDaAnStr + Request.Form["CHK-" + MYDT.Tables[0].Rows[i]["ID"].ToString() + "-C"].ToString();
                    }
                    catch { }
                    try
                    {
                        DangQianDaAnStr = DangQianDaAnStr + Request.Form["CHK-" + MYDT.Tables[0].Rows[i]["ID"].ToString() + "-D"].ToString();
                    }
                    catch { }
                    try
                    {
                        DangQianDaAnStr = DangQianDaAnStr + Request.Form["CHK-" + MYDT.Tables[0].Rows[i]["ID"].ToString() + "-E"].ToString();
                    }
                    catch { }
                    try
                    {
                        DangQianDaAnStr = DangQianDaAnStr + Request.Form["CHK-" + MYDT.Tables[0].Rows[i]["ID"].ToString() + "-F"].ToString();
                    }
                    catch { }
                    try
                    {
                        DangQianDaAnStr = DangQianDaAnStr + Request.Form["CHK-" + MYDT.Tables[0].Rows[i]["ID"].ToString() + "-G"].ToString();
                    }
                    catch { }
                    try
                    {
                        DangQianDaAnStr = DangQianDaAnStr + Request.Form["CHK-" + MYDT.Tables[0].Rows[i]["ID"].ToString() + "-H"].ToString();
                    }
                    catch { }

                    Model1.UserDaAn = DangQianDaAnStr;
                    if (DangQianDaAnStr == MYDT.Tables[0].Rows[i]["AnswerStr"].ToString())
                    {
                        Model1.DeFen = Model.DuoXuanFenShu;
                    }
                    else
                    {
                        Model1.DeFen = 0;
                    }
                    Model1.Add();
                }
            }
            else if (FenLeiSunXu[j].ToString() == "�����")
            {
                TiMuIDList = this.Lab4.Text;
                DataSet MYDT = ZWL.DBUtility.DbHelperSQL.GetDataSet("select * from ERPTiKu where ID in('" + TiMuIDList.Replace(",", "','") + "')");
                for (int i = 0; i < MYDT.Tables[0].Rows.Count; i++)
                {
                    ZWL.BLL.ERPTiKuKaoShiJieGuo Model1 = new ZWL.BLL.ERPTiKuKaoShiJieGuo();

                    Model1.KaoShiID = MaxID;
                    Model1.TiMuID = int.Parse(MYDT.Tables[0].Rows[i]["ID"].ToString());
                    Model1.DaAn = MYDT.Tables[0].Rows[i]["AnswerStr"].ToString();
                    string UserDaAnStr = "";
                    try
                    {
                        UserDaAnStr = Request.Form["text-" + MYDT.Tables[0].Rows[i]["ID"].ToString()].ToString();
                    }
                    catch { }
                    Model1.UserDaAn = UserDaAnStr;
                    if (UserDaAnStr == MYDT.Tables[0].Rows[i]["AnswerStr"].ToString())
                    {
                        Model1.DeFen = Model.TianKongFenShu;
                    }
                    else
                    {
                        Model1.DeFen = 0;
                    }
                    Model1.Add();
                }
            }
            else if (FenLeiSunXu[j].ToString() == "�����")
            {
                TiMuIDList = this.Lab5.Text;
                DataSet MYDT = ZWL.DBUtility.DbHelperSQL.GetDataSet("select * from ERPTiKu where ID in('" + TiMuIDList.Replace(",", "','") + "')");
                for (int i = 0; i < MYDT.Tables[0].Rows.Count; i++)
                {
                    ZWL.BLL.ERPTiKuKaoShiJieGuo Model1 = new ZWL.BLL.ERPTiKuKaoShiJieGuo();

                    Model1.KaoShiID = MaxID;
                    Model1.TiMuID = int.Parse(MYDT.Tables[0].Rows[i]["ID"].ToString());
                    Model1.DaAn = MYDT.Tables[0].Rows[i]["AnswerStr"].ToString();
                    string UserDaAnStr = "";
                    try
                    {
                        UserDaAnStr = Request.Form["textarea-" + MYDT.Tables[0].Rows[i]["ID"].ToString()].ToString();
                    }
                    catch { }
                    Model1.UserDaAn = UserDaAnStr;

                    Model1.DeFen =null;
                    Model1.Add();
                }
            }
        }

        //дϵͳ��־
        ZWL.BLL.ERPRiZhi MyRiZhi = new ZWL.BLL.ERPRiZhi();
        MyRiZhi.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName");
        MyRiZhi.DoSomething = "�û�������߿�����Ϣ(" + this.DropDownList1.SelectedItem.Text + ")";
        MyRiZhi.IpStr = System.Web.HttpContext.Current.Request.UserHostAddress.ToString();
        MyRiZhi.Add();

        ZWL.Common.MessageBox.ShowAndRedirect(this, "���߿�����Ϣ��ӳɹ�����ǰ�����ľ�÷֣�" + ZWL.DBUtility.DbHelperSQL.GetSHSLInt("select sum(DeFen)  from ERPTiKuKaoShiJieGuo where KaoShiID=" + MaxID.ToString()) + "���˷����������˹��ľ������", "TiKuKaoShi.aspx");
    }
Example #2
0
    protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
    {
        //~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
        ZWL.BLL.ERPTiKuKaoShi Model0 = new ZWL.BLL.ERPTiKuKaoShi();
        Model0.UserName    = ZWL.Common.PublicMethod.GetSessionValue("UserName");
        Model0.TimeStr     = DateTime.Now;
        Model0.ShiJuanName = this.DropDownList1.SelectedItem.Text;
        Model0.ShiJuanID   = int.Parse(this.DropDownList1.SelectedValue);
        int MaxID = Model0.Add();

        this.Panel1.Visible = false;
        //读取试卷信息
        ZWL.BLL.ERPTiKuShiJuan Model = new ZWL.BLL.ERPTiKuShiJuan();
        Model.GetModel(int.Parse(this.DropDownList1.SelectedItem.Value.ToString()));
        MaxTime = int.Parse(Model.KaoShiXianShi.ToString()) * 60;//考试限时

        string[] FenLeiSunXu = Model.FenLeiShunXu.Split('|');
        for (int j = 0; j < FenLeiSunXu.Length; j++)
        {
            //绑定当前题目已有的题目
            string TiMuIDList = "0";
            if (FenLeiSunXu[j].ToString() == "判断题")
            {
                TiMuIDList = this.Lab1.Text;
                DataSet MYDT = ZWL.DBUtility.DbHelperSQL.GetDataSet("select * from ERPTiKu where ID in('" + TiMuIDList.Replace(",", "','") + "')");
                for (int i = 0; i < MYDT.Tables[0].Rows.Count; i++)
                {
                    ZWL.BLL.ERPTiKuKaoShiJieGuo Model1 = new ZWL.BLL.ERPTiKuKaoShiJieGuo();

                    Model1.KaoShiID = MaxID;
                    Model1.TiMuID   = int.Parse(MYDT.Tables[0].Rows[i]["ID"].ToString());
                    Model1.DaAn     = MYDT.Tables[0].Rows[i]["AnswerStr"].ToString();
                    string UserDaAnStr = "";
                    try
                    {
                        UserDaAnStr = Request.Form["rad-" + MYDT.Tables[0].Rows[i]["ID"].ToString()].ToString();
                    }
                    catch { }
                    Model1.UserDaAn = UserDaAnStr;
                    if (UserDaAnStr == MYDT.Tables[0].Rows[i]["AnswerStr"].ToString())
                    {
                        Model1.DeFen = Model.PanDuanFenShu;
                    }
                    else
                    {
                        Model1.DeFen = 0;
                    }
                    Model1.Add();
                }
            }
            else if (FenLeiSunXu[j].ToString() == "单项选择题")
            {
                TiMuIDList = this.Lab2.Text;
                DataSet MYDT = ZWL.DBUtility.DbHelperSQL.GetDataSet("select * from ERPTiKu where ID in('" + TiMuIDList.Replace(",", "','") + "')");
                for (int i = 0; i < MYDT.Tables[0].Rows.Count; i++)
                {
                    ZWL.BLL.ERPTiKuKaoShiJieGuo Model1 = new ZWL.BLL.ERPTiKuKaoShiJieGuo();

                    Model1.KaoShiID = MaxID;
                    Model1.TiMuID   = int.Parse(MYDT.Tables[0].Rows[i]["ID"].ToString());
                    Model1.DaAn     = MYDT.Tables[0].Rows[i]["AnswerStr"].ToString();
                    string UserDaAnStr = "";
                    try
                    {
                        UserDaAnStr = Request.Form["rad-" + MYDT.Tables[0].Rows[i]["ID"].ToString()].ToString();
                    }
                    catch { }
                    Model1.UserDaAn = UserDaAnStr;
                    if (UserDaAnStr == MYDT.Tables[0].Rows[i]["AnswerStr"].ToString())
                    {
                        Model1.DeFen = Model.DanXuanFenShu;
                    }
                    else
                    {
                        Model1.DeFen = 0;
                    }
                    Model1.Add();
                }
            }
            else if (FenLeiSunXu[j].ToString() == "多项选择题")
            {
                TiMuIDList = this.Lab3.Text;
                DataSet MYDT = ZWL.DBUtility.DbHelperSQL.GetDataSet("select * from ERPTiKu where ID in('" + TiMuIDList.Replace(",", "','") + "')");
                for (int i = 0; i < MYDT.Tables[0].Rows.Count; i++)
                {
                    ZWL.BLL.ERPTiKuKaoShiJieGuo Model1 = new ZWL.BLL.ERPTiKuKaoShiJieGuo();

                    Model1.KaoShiID = MaxID;
                    Model1.TiMuID   = int.Parse(MYDT.Tables[0].Rows[i]["ID"].ToString());
                    Model1.DaAn     = MYDT.Tables[0].Rows[i]["AnswerStr"].ToString();

                    string DangQianDaAnStr = "";
                    try
                    {
                        DangQianDaAnStr = DangQianDaAnStr + Request.Form["CHK-" + MYDT.Tables[0].Rows[i]["ID"].ToString() + "-A"].ToString();
                    }
                    catch { }
                    try
                    {
                        DangQianDaAnStr = DangQianDaAnStr + Request.Form["CHK-" + MYDT.Tables[0].Rows[i]["ID"].ToString() + "-B"].ToString();
                    }
                    catch { }
                    try
                    {
                        DangQianDaAnStr = DangQianDaAnStr + Request.Form["CHK-" + MYDT.Tables[0].Rows[i]["ID"].ToString() + "-C"].ToString();
                    }
                    catch { }
                    try
                    {
                        DangQianDaAnStr = DangQianDaAnStr + Request.Form["CHK-" + MYDT.Tables[0].Rows[i]["ID"].ToString() + "-D"].ToString();
                    }
                    catch { }
                    try
                    {
                        DangQianDaAnStr = DangQianDaAnStr + Request.Form["CHK-" + MYDT.Tables[0].Rows[i]["ID"].ToString() + "-E"].ToString();
                    }
                    catch { }
                    try
                    {
                        DangQianDaAnStr = DangQianDaAnStr + Request.Form["CHK-" + MYDT.Tables[0].Rows[i]["ID"].ToString() + "-F"].ToString();
                    }
                    catch { }
                    try
                    {
                        DangQianDaAnStr = DangQianDaAnStr + Request.Form["CHK-" + MYDT.Tables[0].Rows[i]["ID"].ToString() + "-G"].ToString();
                    }
                    catch { }
                    try
                    {
                        DangQianDaAnStr = DangQianDaAnStr + Request.Form["CHK-" + MYDT.Tables[0].Rows[i]["ID"].ToString() + "-H"].ToString();
                    }
                    catch { }


                    Model1.UserDaAn = DangQianDaAnStr;
                    if (DangQianDaAnStr == MYDT.Tables[0].Rows[i]["AnswerStr"].ToString())
                    {
                        Model1.DeFen = Model.DuoXuanFenShu;
                    }
                    else
                    {
                        Model1.DeFen = 0;
                    }
                    Model1.Add();
                }
            }
            else if (FenLeiSunXu[j].ToString() == "填空题")
            {
                TiMuIDList = this.Lab4.Text;
                DataSet MYDT = ZWL.DBUtility.DbHelperSQL.GetDataSet("select * from ERPTiKu where ID in('" + TiMuIDList.Replace(",", "','") + "')");
                for (int i = 0; i < MYDT.Tables[0].Rows.Count; i++)
                {
                    ZWL.BLL.ERPTiKuKaoShiJieGuo Model1 = new ZWL.BLL.ERPTiKuKaoShiJieGuo();

                    Model1.KaoShiID = MaxID;
                    Model1.TiMuID   = int.Parse(MYDT.Tables[0].Rows[i]["ID"].ToString());
                    Model1.DaAn     = MYDT.Tables[0].Rows[i]["AnswerStr"].ToString();
                    string UserDaAnStr = "";
                    try
                    {
                        UserDaAnStr = Request.Form["text-" + MYDT.Tables[0].Rows[i]["ID"].ToString()].ToString();
                    }
                    catch { }
                    Model1.UserDaAn = UserDaAnStr;
                    if (UserDaAnStr == MYDT.Tables[0].Rows[i]["AnswerStr"].ToString())
                    {
                        Model1.DeFen = Model.TianKongFenShu;
                    }
                    else
                    {
                        Model1.DeFen = 0;
                    }
                    Model1.Add();
                }
            }
            else if (FenLeiSunXu[j].ToString() == "简答题")
            {
                TiMuIDList = this.Lab5.Text;
                DataSet MYDT = ZWL.DBUtility.DbHelperSQL.GetDataSet("select * from ERPTiKu where ID in('" + TiMuIDList.Replace(",", "','") + "')");
                for (int i = 0; i < MYDT.Tables[0].Rows.Count; i++)
                {
                    ZWL.BLL.ERPTiKuKaoShiJieGuo Model1 = new ZWL.BLL.ERPTiKuKaoShiJieGuo();

                    Model1.KaoShiID = MaxID;
                    Model1.TiMuID   = int.Parse(MYDT.Tables[0].Rows[i]["ID"].ToString());
                    Model1.DaAn     = MYDT.Tables[0].Rows[i]["AnswerStr"].ToString();
                    string UserDaAnStr = "";
                    try
                    {
                        UserDaAnStr = Request.Form["textarea-" + MYDT.Tables[0].Rows[i]["ID"].ToString()].ToString();
                    }
                    catch { }
                    Model1.UserDaAn = UserDaAnStr;

                    Model1.DeFen = null;
                    Model1.Add();
                }
            }
        }

        //写系统日志
        ZWL.BLL.ERPRiZhi MyRiZhi = new ZWL.BLL.ERPRiZhi();
        MyRiZhi.UserName    = ZWL.Common.PublicMethod.GetSessionValue("UserName");
        MyRiZhi.DoSomething = "用户添加在线考试信息(" + this.DropDownList1.SelectedItem.Text + ")";
        MyRiZhi.IpStr       = System.Web.HttpContext.Current.Request.UserHostAddress.ToString();
        MyRiZhi.Add();

        ZWL.Common.MessageBox.ShowAndRedirect(this, "在线考试信息添加成功!当前电脑阅卷得分:" + ZWL.DBUtility.DbHelperSQL.GetSHSLInt("select sum(DeFen)  from ERPTiKuKaoShiJieGuo where KaoShiID=" + MaxID.ToString()) + ",此分数不包含人工阅卷分数!", "TiKuKaoShi.aspx");
    }