在DAL文件夹下添加一个MyStudentsdal类
public class MyStudentsdal
{
//本方法实现某条记录的Fage字段的值加1
public int AgeAddById(int Fid)
{
string sql = "update MyStudents set FAge=FAge+1 where FId=@sId";
SqlParameter pms = new SqlParameter("@sId",Fid);
return SqlHelper.ExcuteNonQuery(sql,pms );
}
}
在Bll文件夹下添加一个MyStudentsBll类
public class MyStudentsBll
{
/// <summary>
/// //调用数据访问层的方法,根据逻辑判断更新是否成功,返回bool类型的值
/// 业务逻辑层返回什么值,取决于表现层要什么值,要什么值就返回什么值
/// </summary>
/// <param name="fid"></param>
/// <returns></returns>
public bool AgeAddID(int fid)
{
MyStudents dal = new MyStudents();
int r = dal.AgeAddById(fid );
if (r > 0)
{
return true;
}
else
{
return false;
}
}
}
在Uil.aspx中
后台:
protected void Button1_Click(object sender, EventArgs e)
{
int fid = Convert.ToInt32(txtid.Text .Trim ());
MyStudentsBll bll = new MyStudentsBll();
bool b = bll.AgeAddID(fid);
if (b)
{
Response.Write("修改成功");
}
else
{
Response.Write("修改失败");
}
}