Beispiel #1
0
    protected string GetStudentGradeCheckConfirm(DateTime updateTime)
    {
        DalOperationAboutGradeCheck dalOperationAboutGradeCheck = new DalOperationAboutGradeCheck();
        DataSet ds = dalOperationAboutGradeCheck.GetStudentGradeCheckConfirm(studentNo, updateTime);

        string isAccord = string.Empty;

        for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
        {
            isAccord = ds.Tables[0].Rows[i]["isAccord"].ToString().Trim();
        }
        return isAccord;
    }
Beispiel #2
0
    protected string GetStudentGradeCheckConfirmAboutRemark(DateTime updateTime)
    {
        DalOperationAboutGradeCheck dalOperationAboutGradeCheck = new DalOperationAboutGradeCheck();
        DataSet ds = dalOperationAboutGradeCheck.GetStudentGradeCheckConfirm(studentNo, updateTime);

        string remark = string.Empty;

        for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
        {
            remark = ds.Tables[0].Rows[i]["remark"].ToString().Trim();
        }
        return remark;
    }
        protected void Page_Load(object sender, EventArgs e)
        {
            DalOperationAboutGradeCheck dal = new DalOperationAboutGradeCheck();

            DalOperationAboutStudent stu = new DalOperationAboutStudent();

            StudentsList model = stu.GetStudentById(studentNo);

            DataSet ds = dal.GetAllGradeCheckDetailByStudentNoAndUpdateTime(studentNo, updateTime);

            List<string> listColumn = new List<string>();

            //for (int i=0;i<ds.Tables[0].Rows.Count;i++)
            //{
            //    listColumn.Add(ds.Tables[0].Columns[i].ToString());
            //}

            //for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            //{
            //    LiteralControl ltl = new LiteralControl();
            //    ltl.Text = "<br />" + ds.Tables[0].Rows[i]["gradeCheckItemName"];
            //    PlaceHolder1.Controls.Add(ltl);
            //    TextBox txt = new TextBox();
            //    txt.ID = "txt_" + ds.Tables[0].Rows[i]["gradeCheckId"];
            //    txt.Text = ds.Tables[0].Rows[i]["gradeCheckDetailValue"].ToString().Trim();
            //    PlaceHolder1.Controls.Add(txt);
            //}
            Table tb = new Table();
            tb.CssClass = "tableAddStyleNone";
            tb.Width = Unit.Percentage(100);

            TableRow tr1 = new TableRow();
            TableCell td1 = new TableCell();
            td1.HorizontalAlign = HorizontalAlign.Left;
            td1.CssClass = "border";
            td1.Width = Unit.Percentage(25);
            td1.Text = "当前学生所属班级:";
            tr1.Cells.Add(td1);
            td1 = new TableCell();
            td1.CssClass = "border";
            td1.Text = model.SchoolClassName + "&nbsp;&nbsp;所应用的成绩审核规则为:20"+ model.SchoolClassName.Trim().Substring(0,2) +"学年成绩审核规则";
            tr1.Cells.Add(td1);

            tb.Rows.Add(tr1);

            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                TableRow tr = new TableRow();
                TableCell td = new TableCell();
                td.HorizontalAlign = HorizontalAlign.Left;
                td.CssClass = "border";
                td.Width = Unit.Percentage(25);

                LiteralControl ltl = new LiteralControl();
                ltl.Text = "<br />" + ds.Tables[0].Rows[i]["gradeCheckItemName"].ToString().Trim();

                td.Controls.Add(ltl);
                tr.Cells.Add(td);

                td = new TableCell();
                td.HorizontalAlign = HorizontalAlign.Left;
                td.CssClass = "border";

                TextBox txt = new TextBox();
                txt.ID = "txt_" + ds.Tables[0].Rows[i]["gradeCheckId"].ToString().Trim();
                txt.Text = ds.Tables[0].Rows[i]["gradeCheckDetailValue"].ToString().Trim();
                td.Controls.Add(txt);
                tr.Cells.Add(td);

                tb.Rows.Add(tr);
            }
            PlaceHolder1.Controls.Add(tb);

            if (!IsPostBack)
            {
                ds = dal.GetStudentGradeCheckConfirm(studentNo, Convert.ToDateTime(updateTime));

                for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                {
                    while (ddlIsAccord.Items.Count > 0)
                    {
                        ddlIsAccord.Items.RemoveAt(0);
                    }

                    if (ds.Tables[0].Rows[i]["isAccord"].ToString().Trim() == "1")
                    {
                        ddlIsAccord.Items.Add(new ListItem("符合", "1"));
                        ddlIsAccord.Items.Add(new ListItem("不符合", "0"));
                    }
                    else
                    {
                        ddlIsAccord.Items.Add(new ListItem("不符合", "0"));
                        ddlIsAccord.Items.Add(new ListItem("符合", "1"));
                    }

                    remark.Text = ds.Tables[0].Rows[i]["remark"].ToString().Trim();
                }
            }
        }