//绑定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", "添加失败!");
}
}
