protected void MarkRepeater_ItemCommand(object source, RepeaterCommandEventArgs e) { if (e.CommandName == "update") { int id = Convert.ToInt16(e.CommandArgument); Response.Redirect("EditApply.aspx?id=" + id); } if (e.CommandName == "delete") { int id = Convert.ToInt16(e.CommandArgument); mark = bllMark.GetModel(id); mark.BonusPoint = null; mark.CheckStep = 0; mark.Reason = null; if (bllMark.Update(mark)) { Bing(); Maticsoft.Common.MessageBox.Show(this, "删除成功!"); } else { Maticsoft.Common.MessageBox.Show(this, "删除失败!"); } } }
protected void Save_Click(object sender, EventArgs e) { mark = Session["mark"] as Eva.Model.Mark; string strErr = ""; if (txtBonusPoint.Text.Trim().Length == 0) { strErr += "加分的分数不能为空!"; } if (txtReson.Text.Trim().Length==0) { strErr += "理由不能为空!"; } if (strErr != "") { Maticsoft.Common.MessageBox.Show(this, strErr); return; } mark.BonusPoint = Convert.ToDecimal(txtBonusPoint.Text); mark.Reason = txtReson.Text; mark.CheckStep = 1; if (bllMark.Update(mark)) { Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "ShowMark.aspx"); } else { Maticsoft.Common.MessageBox.Show(this, "保存失败!"); } }
protected void Save_Click(object sender, EventArgs e) { string strErr = ""; if (txtBonusPoint.Text.Trim().Length == 0) { strErr += "加分不能为空!\\n"; } if (txtReson.Text.Trim().Length==0) { strErr += "理由不能为空!\\n"; } if (strErr != "") { Maticsoft.Common.MessageBox.Show(this, strErr); return; } int id = int.Parse(Request["id"]); mark = bll.GetModel(id); mark.BonusPoint = Convert.ToDecimal(txtBonusPoint.Text); mark.Reason = txtReson.Text; if (bll.Update(mark)) { Maticsoft.Common.MessageBox.ShowAndRedirect(this, "修改成功!", "ApplyList.aspx"); } else { Maticsoft.Common.MessageBox.Show(this, "修改失败!"); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { int id = int.Parse(Request["id"]); mark = bll.GetModel(id); txtCourseName.Text = bllCourse.GetModel(Convert.ToInt16(mark.CourseId)).Name; txtBonusPoint.Text = mark.BonusPoint.ToString(); txtScore.Text = mark.Score.ToString(); txtReson.Text = mark.Reason; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { int id = int.Parse(Request["id"]); mark = bllMark.GetModel(id); Session["mark"] = mark; txtCourseName.Text = Eva.BLL.Utils.GetCourseName(Convert.ToInt16(mark.CourseId)); txtScore.Text = mark.Score.ToString(); } }
public void btnSave_Click(object sender, EventArgs e) { string strErr=""; if(!PageValidate.IsNumber(txtCourseId.Text)) { strErr+="CourseId格式错误!\\n"; } if(!PageValidate.IsNumber(txtStudentId.Text)) { strErr+="StudentId格式错误!\\n"; } if(!PageValidate.IsNumber(txtEvalutionId.Text)) { strErr+="EvalutionId格式错误!\\n"; } if(!PageValidate.IsDecimal(txtScore.Text)) { strErr+="Score格式错误!\\n"; } if(!PageValidate.IsDecimal(txtBonusPoint.Text)) { strErr+="BonusPoint格式错误!\\n"; } if(!PageValidate.IsNumber(txtAcademicYear.Text)) { strErr+="AcademicYear格式错误!\\n"; } if(!PageValidate.IsNumber(txtSchoolTerm.Text)) { strErr+="SchoolTerm格式错误!\\n"; } if(!PageValidate.IsNumber(txtCheckStep.Text)) { strErr+="CheckStep格式错误!\\n"; } if(this.txtReason.Text.Trim().Length==0) { strErr+="Reason不能为空!\\n"; } if(!PageValidate.IsDecimal(txtGpa.Text)) { strErr+="Gpa格式错误!\\n"; } if(strErr!="") { MessageBox.Show(this,strErr); return; } int Id=int.Parse(this.lblId.Text); int CourseId=int.Parse(this.txtCourseId.Text); int StudentId=int.Parse(this.txtStudentId.Text); int EvalutionId=int.Parse(this.txtEvalutionId.Text); decimal Score=decimal.Parse(this.txtScore.Text); decimal BonusPoint=decimal.Parse(this.txtBonusPoint.Text); int AcademicYear=int.Parse(this.txtAcademicYear.Text); int SchoolTerm=int.Parse(this.txtSchoolTerm.Text); int CheckStep=int.Parse(this.txtCheckStep.Text); string Reason=this.txtReason.Text; decimal Gpa=decimal.Parse(this.txtGpa.Text); Eva.Model.Mark model=new Eva.Model.Mark(); model.Id=Id; model.CourseId=CourseId; model.StudentId=StudentId; model.EvalutionId=EvalutionId; model.Score=Score; model.BonusPoint=BonusPoint; model.AcademicYear=AcademicYear; model.SchoolTerm=SchoolTerm; model.CheckStep=CheckStep; model.Reason=Reason; model.Gpa=Gpa; Eva.BLL.Mark bll=new Eva.BLL.Mark(); bll.Update(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this,"保存成功!","list.aspx"); }
/// <summary> /// 得到一个对象实体 /// </summary> public Eva.Model.Mark DataRowToModel(DataRow row) { Eva.Model.Mark model=new Eva.Model.Mark(); if (row != null) { if(row["Id"]!=null && row["Id"].ToString()!="") { model.Id=int.Parse(row["Id"].ToString()); } if(row["CourseId"]!=null && row["CourseId"].ToString()!="") { model.CourseId=int.Parse(row["CourseId"].ToString()); } if(row["StudentId"]!=null && row["StudentId"].ToString()!="") { model.StudentId=int.Parse(row["StudentId"].ToString()); } if(row["EvalutionId"]!=null && row["EvalutionId"].ToString()!="") { model.EvalutionId=int.Parse(row["EvalutionId"].ToString()); } if(row["Score"]!=null && row["Score"].ToString()!="") { model.Score=decimal.Parse(row["Score"].ToString()); } if(row["BonusPoint"]!=null && row["BonusPoint"].ToString()!="") { model.BonusPoint=decimal.Parse(row["BonusPoint"].ToString()); } if(row["AcademicYear"]!=null && row["AcademicYear"].ToString()!="") { model.AcademicYear=int.Parse(row["AcademicYear"].ToString()); } if(row["SchoolTerm"]!=null && row["SchoolTerm"].ToString()!="") { model.SchoolTerm=int.Parse(row["SchoolTerm"].ToString()); } if(row["CheckStep"]!=null && row["CheckStep"].ToString()!="") { model.CheckStep=int.Parse(row["CheckStep"].ToString()); } if(row["Reason"]!=null) { model.Reason=row["Reason"].ToString(); } if(row["Gpa"]!=null && row["Gpa"].ToString()!="") { model.Gpa=decimal.Parse(row["Gpa"].ToString()); } } return model; }
/// <summary> /// 得到一个对象实体 /// </summary> public Eva.Model.Mark GetModel(int Id) { StringBuilder strSql=new StringBuilder(); strSql.Append("select top 1 Id,CourseId,StudentId,EvalutionId,Score,BonusPoint,AcademicYear,SchoolTerm,CheckStep,Reason,Gpa from Mark "); strSql.Append(" where Id=@Id"); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.Int,4) }; parameters[0].Value = Id; Eva.Model.Mark model=new Eva.Model.Mark(); DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters); if(ds.Tables[0].Rows.Count>0) { return DataRowToModel(ds.Tables[0].Rows[0]); } else { return null; } }