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;
}
}
