public int Update(CourseScore model)
{
if (SelectById(model).deleted == 1)
{
return(-2);
}
List <Object> obj = updateSQL(model);
string sql = obj[0].ToString();
List <SQLiteParameter> ps = (List <SQLiteParameter>)obj[1];
return(SqliteHelper.update(sql, ps.ToArray()));
}
public int Update(Student model)
{
if (SelectById(model).deleted == 1)
{
//如果deleted==1，已经删除，返回-2
return(-2);
}
List <Object> obj = updateSQL(model);
string sql = obj[0].ToString();
List <SQLiteParameter> ps = (List <SQLiteParameter>)obj[1];
return(SqliteHelper.update(sql, ps.ToArray()));
}
public int UpdateScore(CourseScore model)
{
if (SelectById(model).deleted == 1)
{
return(-2);
}
List <SQLiteParameter> ps = new List <SQLiteParameter>();
string sql = "update course_score set score=@score where id=@id";
ps.Add(new SQLiteParameter("@score", model.score));
ps.Add(new SQLiteParameter("@id", model.id));
return(SqliteHelper.update(sql, ps.ToArray()));
}
