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; }
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 + " 所应用的成绩审核规则为: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(); } } }