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