/// <summary>
/// 添加学生
/// </summary>
/// <param name="stu"></param>
/// <returns></returns>
public static int Add(Student stu)
{
SqlParameter[] param =
{
new SqlParameter("@id", SqlDbType.Int),
new SqlParameter("@name", SqlDbType.NVarChar, 20),
new SqlParameter("@address", SqlDbType.NVarChar, 20)
};
param[0].Value = stu.StudnetNo;
param[1].Value = stu.StudentName;
param[2].Value = stu.Address;
////
return(SQLHELPER.ExecuteNoQueryBYStoredProc("createstu", param));
}
/// <summary>
/// 更新
/// </summary>
/// <param name="stu"></param>
public static int Update(Student stu)
{
SqlParameter [] param =
{
new SqlParameter("@id", SqlDbType.Int),
new SqlParameter("@name", SqlDbType.NVarChar, 20),
new SqlParameter("@phone", SqlDbType.NVarChar, 20),
new SqlParameter("@address", SqlDbType.NVarChar, 20)
};
param[0].Value = stu.StudnetNo;
param[1].Value = stu.StudentName;
param[2].Value = stu.Phone;
param[3].Value = "四川成都";
return(SQLHELPER.ExecuteNoQueryBYStoredProc("updatenamephoneaddressbyid", param));
}
