//绑定Gridview protected void ExScoreGridView_DataBind() { ExtendBLL.Score sco = new ExtendBLL.Score(); DataSet ds = new DataSet(); ds = sco.ScoreQueryByStudentCode(UserCode,YearDDL.SelectedValue,TermDDL.SelectedValue); ExScoreGridView.DataSource = ds; ExScoreGridView.DataBind(); }
//绑定gridview protected void ScoreGridView_DataBind(int ClassID, int ProjectID) { ExtendBLL.Score score = new ExtendBLL.Score(); DataSet ds = new DataSet(); int proCouID; proCouID = GetProCourseIDByProID(ProjectID,int.Parse(IDHF.Value)); try { ds = score.GetScoreInfo(ClassID, proCouID); } catch (Exception ex) { throw ex; } if (ds.Tables.Count != 0) { ScoreGridView.DataSource = ds; ScoreGridView.DataBind(); } else { SaveBtn.Visible = false; ConcelBtn.Visible=false; MessLbl.Visible = true; MessLbl.Text = "暂无学生数据"; } }
//绑定实验项目 protected void SubjectDDL_DataBind(int CourseID) { ExtendBLL.Score score = new ExtendBLL.Score(); DataSet ds = new DataSet(); ds = score.GetSubjectInfoByCourseID(CourseID); if (ds.Tables.Count != 0) { SubjectDDL.DataSource = ds; SubjectDDL.DataBind(); } }
//保存成绩 protected void Save_OnClick(object sender, EventArgs e) { List<LabMS.Model.Score> list = new List<LabMS.Model.Score>(); string[] str = new string[4]; int count = ScoreGridView.Rows.Count; if (count == 0) { return; } int[] iarray = new int[count]; for (int i = 0; i < count; i++) { LabMS.Model.Score scoreModel = new LabMS.Model.Score(); TextBox optb = (TextBox)ScoreGridView.Rows[i].FindControl("OpScoreTBX"); TextBox pretb = (TextBox)ScoreGridView.Rows[i].FindControl("PreScoreTBX"); TextBox extb = (TextBox)ScoreGridView.Rows[i].FindControl("ExScoreTBX"); TextBox stb = (TextBox)ScoreGridView.Rows[i].FindControl("ScoreTBX"); int IsScore; scoreModel.ProjectCourseID = GetProCourseIDByProID(int.Parse(SubjectDDL.SelectedValue), int.Parse(IDHF.Value)); scoreModel.StudentID = int.Parse(ScoreGridView.DataKeys[i]["StudentID"].ToString()); IsScore = CheckIsScore(scoreModel.ProjectCourseID, scoreModel.StudentID); if (IsScore>0)//更新 { iarray[i] = 1; int iOut; if(optb.Text.Trim() != "") { if (int.TryParse(optb.Text.Trim(), out iOut)) scoreModel.Score_Op = iOut; } if(pretb.Text.Trim() != "") { if (int.TryParse(pretb.Text.Trim(), out iOut)) scoreModel.Score_Pre = iOut; } if (extb.Text.Trim() != "") { if (int.TryParse(extb.Text.Trim(), out iOut)) scoreModel.Score_Ex = iOut; } if (stb.Text.Trim() != "") { if (int.TryParse(stb.Text.Trim(), out iOut)) scoreModel.MScore = iOut; } scoreModel.ID = IsScore; list.Add(scoreModel); } else//插入 { iarray[i] = 0; int iOut; if (optb.Text.Trim() != "") { if (int.TryParse(optb.Text.Trim(), out iOut)) scoreModel.Score_Op = iOut; } if (pretb.Text.Trim() != "") { if (int.TryParse(pretb.Text.Trim(), out iOut)) scoreModel.Score_Pre = iOut; } if (extb.Text.Trim() != "") { if (int.TryParse(extb.Text.Trim(), out iOut)) scoreModel.Score_Ex = iOut; } if (stb.Text.Trim() != "") { if (int.TryParse(stb.Text.Trim(), out iOut)) scoreModel.MScore = iOut; } if (IDHF.Value != "0") { scoreModel.CourseID = int.Parse(IDHF.Value); } scoreModel.CourseName = CourseNameTBX.Text.Trim(); if (ClassDDL.SelectedValue != "") { if (int.TryParse(ClassDDL.SelectedValue, out iOut)) scoreModel.ClassID = iOut; } //scoreModel.ProjectCourseID = GetProCourseIDByProID(int.Parse(SubjectDDL.SelectedValue), int.Parse(IDHF.Value)); scoreModel.ClassItemID = GetCouClaIDByClaID(int.Parse(ClassDDL.SelectedValue), int.Parse(IDHF.Value)); scoreModel.Score_Percent = ""; scoreModel.StudentCode = ScoreGridView.Rows[i].Cells[0].Text; //scoreModel.StudentID = int.Parse(ScoreGridView.DataKeys[i]["StudentID"].ToString()); //scoreModel.ID = int.Parse(ScoreGridView.DataKeys[i]["ID"].ToString()); scoreModel.StudentName = ScoreGridView.Rows[i].Cells[1].Text; list.Add(scoreModel); } } ExtendBLL.Score scoreExt = new ExtendBLL.Score(); try { scoreExt.AddScore(iarray, list); LabMS.Common.JShelper.JSAlert(Page, "script", "添加成功!"); } catch { LabMS.Common.JShelper.JSAlert(Page, "script", "添加失败!"); } }