public int Delete(CourseScore model)
{
if (SelectById(model).deleted == 1)
{
//如果deleted==1，已经删除，返回-2
return(-2);
}
//修改
string sql = "update course_score set deleted=1 where id=@id";
SQLiteParameter[] ps =
{
new SQLiteParameter("@id", model.id),
};
return(SqliteHelper.Delete(sql, ps));
}
/// <summary>
/// 逻辑删除，返回-2则表示已经删除
/// </summary>
/// <param name="model"></param>
/// <returns>-2，已经删除</returns>
public int Delete(Student model)
{
if (SelectById(model).deleted == 1)
{
//如果deleted==1，已经删除，返回-2
return(-2);
}
string sql = "update student set deleted=1 where id=@id";
SQLiteParameter[] ps =
{
new SQLiteParameter("@id", model.id),
};
return(SqliteHelper.Delete(sql, ps));
}
