Exemple #1
0
 /// <summary>
 /// ��������б�
 /// </summary>
 public List<LearnSite.Model.Result> DataTableToList(DataTable dt)
 {
     List<LearnSite.Model.Result> modelList = new List<LearnSite.Model.Result>();
     int rowsCount = dt.Rows.Count;
     if (rowsCount > 0)
     {
         LearnSite.Model.Result model;
         for (int n = 0; n < rowsCount; n++)
         {
             model = new LearnSite.Model.Result();
             if(dt.Rows[n]["Rid"].ToString()!="")
             {
                 model.Rid=int.Parse(dt.Rows[n]["Rid"].ToString());
             }
             model.Rnum=dt.Rows[n]["Rnum"].ToString();
             if(dt.Rows[n]["Rscore"].ToString()!="")
             {
                 model.Rscore=int.Parse(dt.Rows[n]["Rscore"].ToString());
             }
             if(dt.Rows[n]["Rdate"].ToString()!="")
             {
                 model.Rdate=DateTime.Parse(dt.Rows[n]["Rdate"].ToString());
             }
             modelList.Add(model);
         }
     }
     return modelList;
 }
Exemple #2
0
    private void ListQuiz()
    {
        string Rnum   = cook.Snum;
        int    Qgrade = cook.Sgrade;
        int    Qclass = cook.Sclass;
        string myname = Server.UrlDecode(cook.Sname);

        LearnSite.BLL.QuizGrade qgbll = new LearnSite.BLL.QuizGrade();
        isanswer = qgbll.GetQanswer(Qgrade, Qclass);

        if (Request.QueryString["Rid"] != null)
        {
            int Rid = Int32.Parse(Request.QueryString["Rid"].ToString());
            LearnSite.BLL.Result   rbll   = new LearnSite.BLL.Result();
            LearnSite.Model.Result rmodel = new LearnSite.Model.Result();
            rmodel = rbll.GetModel(Rid);
            if (rmodel != null)
            {
                string mystr = rmodel.Rhistory;
                if (mystr != "")
                {
                    WrongsStr = rmodel.Rwrong.Split(',');
                    string[]           qmystr = mystr.Split(',');
                    LearnSite.BLL.Quiz bll    = new LearnSite.BLL.Quiz();
                    GVQuiz.DataSource = bll.GetListByQidArray(qmystr);
                    GVQuiz.DataBind();
                    Labeltitle.Text = " 〖" + myname + " 随机生成的" + rmodel.Rdate.Value.ToShortDateString() + "号历史记录试卷参考答案〗";
                }
            }
            //显示本次测验试卷参考答案
        }
        else
        {
            if (Session[Rnum + "quizQids"] != null)
            {
                WrongsStr = Session[Rnum + "quizWrong"].ToString().Split(',');//将错题号保存
                string[]           qstr = (string[])Session[Rnum + "quizQids"];
                LearnSite.BLL.Quiz bll  = new LearnSite.BLL.Quiz();
                GVQuiz.DataSource = bll.GetListByQidArray(qstr);
                GVQuiz.DataBind();

                // Labelmsg.Text = "所有题编号:" + Session[Rnum + "quizRightWrong"].ToString() + "<br/>正确题编号:" + Session[Rnum + "quizRight"].ToString() + "<br/>错误题编号:" + Session[Rnum + "quizWrong"].ToString();
            }
            if (Session[Rnum + "quizrnd"] != null)
            {
                Labeltitle.Text           = " 〖" + myname + " 随机生成的" + Session[Rnum + "quizrnd"].ToString() + "号试卷参考答案〗";
                Session[Rnum + "quizrnd"] = null;
            }
        }
    }
    protected void Btnquiz_Click(object sender, EventArgs e)
    {
        string strscore = Labelallscore.Text;
        if (strscore != "")
        {
            int Rscore = Int32.Parse(strscore);
            if (Rscore > 0)
            {
                string Rnum = Request.Cookies["StudentCookies"].Values["Snum"].ToString();
                string odate = DateTime.Now.ToShortDateString();
                DateTime Rdate = DateTime.Parse(odate);
                Labelmsg.Text = Rdate.ToString();

                LearnSite.BLL.Result bll = new LearnSite.BLL.Result();
                if (bll.ExistsBynumdate(Rnum, Rdate))
                {
                    Labelmsg.Text = "今天已经通过测验!";
                }
                else
                {
                    LearnSite.Model.Result model = new LearnSite.Model.Result();
                    model.Rdate = Rdate;
                    model.Rnum = Rnum;
                    model.Rscore = Rscore;
                    bll.Add(model);//增加今天测验成绩记录
                    int Squiz = bll.GetAverage(Rnum);//计算获得该学号的测验成绩总平均值
                    LearnSite.BLL.Students stbll = new LearnSite.BLL.Students();
                    stbll.SetSquiz(Rnum, Squiz);//更新该学号的测验成绩
                    System.Threading.Thread.Sleep(1000);
                    Labelmsg.Text = "测验成绩成功提交!";
                    PrintQids();
                    Btnquiz.Enabled = false;
                    HLanswer.Enabled = true;
                    HLanswer.Visible = true;
                }
            }
            else
            {
                Labelmsg.Text = "测验成绩为零!";
            }
        }
        else
        {
            Labelmsg.Text = "请先进行测验!";
        }
    }
Exemple #4
0
        /// <summary>
        /// 获得数据列表
        /// </summary>
        public List <LearnSite.Model.Result> DataTableToList(DataTable dt)
        {
            List <LearnSite.Model.Result> modelList = new List <LearnSite.Model.Result>();
            int rowsCount = dt.Rows.Count;

            if (rowsCount > 0)
            {
                LearnSite.Model.Result model;
                for (int n = 0; n < rowsCount; n++)
                {
                    model = new LearnSite.Model.Result();
                    if (dt.Rows[n]["Rid"].ToString() != "")
                    {
                        model.Rid = int.Parse(dt.Rows[n]["Rid"].ToString());
                    }
                    model.Rnum = dt.Rows[n]["Rnum"].ToString();
                    if (dt.Rows[n]["Rscore"].ToString() != "")
                    {
                        model.Rscore = int.Parse(dt.Rows[n]["Rscore"].ToString());
                    }
                    if (dt.Rows[n]["Rdate"].ToString() != "")
                    {
                        model.Rdate = DateTime.Parse(dt.Rows[n]["Rdate"].ToString());
                    }
                    model.Rhistory = dt.Rows[n]["Rhistory"].ToString();
                    model.Rwrong   = dt.Rows[n]["Rwrong"].ToString();
                    if (dt.Rows[n]["Rgrade"].ToString() != "")
                    {
                        model.Rgrade = int.Parse(dt.Rows[n]["Rgrade"].ToString());
                    }
                    if (dt.Rows[n]["Rterm"].ToString() != "")
                    {
                        model.Rterm = int.Parse(dt.Rows[n]["Rterm"].ToString());
                    }

                    modelList.Add(model);
                }
            }
            return(modelList);
        }
Exemple #5
0
 /// <summary>
 /// 更新一条数据
 /// </summary>
 public void Update(LearnSite.Model.Result model)
 {
     dal.Update(model);
 }
Exemple #6
0
 /// <summary>
 /// 更新一条数据中的Rscore,Rhistory,Rwrong
 /// </summary>
 public bool UpdateToday(LearnSite.Model.Result model)
 {
     return(dal.UpdateToday(model));
 }
Exemple #7
0
 /// <summary>
 /// 增加一条数据
 /// </summary>
 public int  Add(LearnSite.Model.Result model)
 {
     return(dal.Add(model));
 }
Exemple #8
0
    protected void Btnquiz_Click(object sender, EventArgs e)
    {
        finished();
        string strscore = Labelallscore.Text;

        if (strscore != "")
        {
            int Rscore = Int32.Parse(strscore);
            if (Rscore > 0)
            {
                int      Rsid   = cook.Sid;
                string   Rnum   = cook.Snum;
                int      Rgrade = cook.Sgrade;
                int      Rterm  = cook.ThisTerm;
                DateTime dt     = DateTime.Now;
                string   odate  = dt.Year.ToString() + "-" + dt.Month.ToString() + "-" + dt.Day;
                DateTime Rdate  = DateTime.Parse(odate);
                Labelmsg.Text = Rdate.ToString();
                string Rwrong   = "";
                string Rhistory = "";
                if (Session[Rnum + "quizRightWrong"] != null)
                {
                    Rwrong   = Session[Rnum + "quizWrong"].ToString();
                    Rhistory = Session[Rnum + "quizRightWrong"].ToString();
                }
                LearnSite.Model.Result model = new LearnSite.Model.Result();
                model.Rdate    = Rdate;
                model.Rnum     = Rnum;
                model.Rscore   = Rscore;
                model.Rhistory = Rhistory;
                model.Rwrong   = Rwrong;
                model.Rgrade   = Rgrade;
                model.Rterm    = Rterm;
                model.Rsid     = Rsid;
                LearnSite.BLL.Students stbll = new LearnSite.BLL.Students();
                LearnSite.BLL.Result   bll   = new LearnSite.BLL.Result();
                if (bll.ExistsBynumdate(Rsid, Rdate))
                {
                    if (Session[Rnum + "quizrnd"] != null)
                    {
                        if (bll.UpdateToday(model))
                        {
                            Labelmsg.Text = "你获得了更好的成绩,已经更新成功!";
                            PrintQids();
                            HLanswer.Enabled = true;
                            HLanswer.Visible = true;
                        }
                        else
                        {
                            Labelmsg.Text = "你刚才的成绩比原来的差,不作更新,可以重新再测验!";
                        }
                    }
                    else
                    {
                        Response.Redirect("~/Student/myquiz.aspx", false);//查看过答案
                    }
                }
                else
                {
                    bll.Add(model);//增加今天测验成绩记录
                    Labelmsg.Text = "测验成绩成功提交!";
                    PrintQids();
                    HLanswer.Enabled = true;
                    HLanswer.Visible = true;
                }
                bll.GetAverage(Rsid, Rgrade, Rterm);//计算获得该学号的测验成绩总平均值,更新该学号的测验总成绩
                Btnquiz.Enabled = false;
            }
            else
            {
                Labelmsg.Text = "测验成绩为零,提交无效!";
            }
        }
        else
        {
            Labelmsg.Text = "请先进行测验!";
        }
    }