protected void btnSave_Click(object sender, EventArgs e) { string strErr=""; if(this.txtName.Text.Trim().Length==0) { strErr+="Name不能为空!\\n"; } if(this.txtGrade.Text.Trim().Length==0) { strErr+="Grade不能为空!\\n"; } if(this.txtScore.Text.Trim().Length==0) { strErr+="Score不能为空!\\n"; } if(!PageValidate.IsNumber(txtStudentId.Text)) { strErr+="StudentId格式错误!\\n"; } if(!PageValidate.IsNumber(txtAcademicYear.Text)) { strErr+="AcademicYear格式错误!\\n"; } if(!PageValidate.IsNumber(txtSchoolTerm.Text)) { strErr+="SchoolTerm格式错误!\\n"; } if(this.txtIsCheck.Text.Trim().Length==0) { strErr+="IsCheck不能为空!\\n"; } if(!PageValidate.IsNumber(txtTotal.Text)) { strErr+="Total格式错误!\\n"; } if(strErr!="") { MessageBox.Show(this,strErr); return; } string Name=this.txtName.Text; string Grade=this.txtGrade.Text; string Score=this.txtScore.Text; int StudentId=int.Parse(this.txtStudentId.Text); int AcademicYear=int.Parse(this.txtAcademicYear.Text); int SchoolTerm=int.Parse(this.txtSchoolTerm.Text); string IsCheck=this.txtIsCheck.Text; int Total=int.Parse(this.txtTotal.Text); Eva.Model.Awards model=new Eva.Model.Awards(); model.Name=Name; model.Grade=Grade; model.Score=Score; model.StudentId=StudentId; model.AcademicYear=AcademicYear; model.SchoolTerm=SchoolTerm; model.IsCheck=IsCheck; model.Total=Total; Eva.BLL.Awards bll=new Eva.BLL.Awards(); bll.Add(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this,"保存成功!","add.aspx"); }
/// <summary> /// 得到一个对象实体 /// </summary> public Eva.Model.Awards GetModel(int Id) { StringBuilder strSql=new StringBuilder(); strSql.Append("select top 1 Id,Name,Grade,Score,StudentId,AcademicYear,SchoolTerm,IsCheck,Total from Awards "); strSql.Append(" where Id=@Id"); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.Int,4) }; parameters[0].Value = Id; Eva.Model.Awards model=new Eva.Model.Awards(); DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters); if(ds.Tables[0].Rows.Count>0) { if(ds.Tables[0].Rows[0]["Id"]!=null && ds.Tables[0].Rows[0]["Id"].ToString()!="") { model.Id=int.Parse(ds.Tables[0].Rows[0]["Id"].ToString()); } if(ds.Tables[0].Rows[0]["Name"]!=null && ds.Tables[0].Rows[0]["Name"].ToString()!="") { model.Name=ds.Tables[0].Rows[0]["Name"].ToString(); } if(ds.Tables[0].Rows[0]["Grade"]!=null && ds.Tables[0].Rows[0]["Grade"].ToString()!="") { model.Grade=ds.Tables[0].Rows[0]["Grade"].ToString(); } if(ds.Tables[0].Rows[0]["Score"]!=null && ds.Tables[0].Rows[0]["Score"].ToString()!="") { model.Score=ds.Tables[0].Rows[0]["Score"].ToString(); } if(ds.Tables[0].Rows[0]["StudentId"]!=null && ds.Tables[0].Rows[0]["StudentId"].ToString()!="") { model.StudentId=int.Parse(ds.Tables[0].Rows[0]["StudentId"].ToString()); } if(ds.Tables[0].Rows[0]["AcademicYear"]!=null && ds.Tables[0].Rows[0]["AcademicYear"].ToString()!="") { model.AcademicYear=int.Parse(ds.Tables[0].Rows[0]["AcademicYear"].ToString()); } if(ds.Tables[0].Rows[0]["SchoolTerm"]!=null && ds.Tables[0].Rows[0]["SchoolTerm"].ToString()!="") { model.SchoolTerm=int.Parse(ds.Tables[0].Rows[0]["SchoolTerm"].ToString()); } if(ds.Tables[0].Rows[0]["IsCheck"]!=null && ds.Tables[0].Rows[0]["IsCheck"].ToString()!="") { model.IsCheck=ds.Tables[0].Rows[0]["IsCheck"].ToString(); } if(ds.Tables[0].Rows[0]["Total"]!=null && ds.Tables[0].Rows[0]["Total"].ToString()!="") { model.Total=int.Parse(ds.Tables[0].Rows[0]["Total"].ToString()); } return model; } else { return null; } }