/// <summary> /// �õ�һ������ʵ�� /// </summary> public LabMS.Model.Score GetModel(int ID) { StringBuilder strSql=new StringBuilder(); strSql.Append("select top 1 ID,MScore,ClassID,StudentID,StudentName,StudentCode,CourseID,CourseName,Score_Op,Score_Pre,Score_Ex,Score_Percent,ProjectCourseID,ClassItemID from Score "); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int,4)}; parameters[0].Value = ID; LabMS.Model.Score model=new LabMS.Model.Score(); DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters); if(ds.Tables[0].Rows.Count>0) { if(ds.Tables[0].Rows[0]["ID"].ToString()!="") { model.ID=int.Parse(ds.Tables[0].Rows[0]["ID"].ToString()); } if(ds.Tables[0].Rows[0]["MScore"].ToString()!="") { model.MScore=int.Parse(ds.Tables[0].Rows[0]["MScore"].ToString()); } if(ds.Tables[0].Rows[0]["ClassID"].ToString()!="") { model.ClassID=int.Parse(ds.Tables[0].Rows[0]["ClassID"].ToString()); } if(ds.Tables[0].Rows[0]["StudentID"].ToString()!="") { model.StudentID=int.Parse(ds.Tables[0].Rows[0]["StudentID"].ToString()); } model.StudentName=ds.Tables[0].Rows[0]["StudentName"].ToString(); model.StudentCode=ds.Tables[0].Rows[0]["StudentCode"].ToString(); if(ds.Tables[0].Rows[0]["CourseID"].ToString()!="") { model.CourseID=int.Parse(ds.Tables[0].Rows[0]["CourseID"].ToString()); } model.CourseName=ds.Tables[0].Rows[0]["CourseName"].ToString(); if(ds.Tables[0].Rows[0]["Score_Op"].ToString()!="") { model.Score_Op=int.Parse(ds.Tables[0].Rows[0]["Score_Op"].ToString()); } if(ds.Tables[0].Rows[0]["Score_Pre"].ToString()!="") { model.Score_Pre=int.Parse(ds.Tables[0].Rows[0]["Score_Pre"].ToString()); } if(ds.Tables[0].Rows[0]["Score_Ex"].ToString()!="") { model.Score_Ex=int.Parse(ds.Tables[0].Rows[0]["Score_Ex"].ToString()); } model.Score_Percent=ds.Tables[0].Rows[0]["Score_Percent"].ToString(); if(ds.Tables[0].Rows[0]["ProjectCourseID"].ToString()!="") { model.ProjectCourseID=int.Parse(ds.Tables[0].Rows[0]["ProjectCourseID"].ToString()); } if(ds.Tables[0].Rows[0]["ClassItemID"].ToString()!="") { model.ClassItemID=int.Parse(ds.Tables[0].Rows[0]["ClassItemID"].ToString()); } return model; } else { return null; } }
//保存成绩 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", "添加失败!"); } }