internal int Delete(int id) { string sql = string.Format("delete from userInfo where userId={0}", id); return(DBUtil.ExecuteNonQuery(sql, new string[] { id + "" })); }
internal int Update(UserInfo u) { StringBuilder sb = new StringBuilder(); sb.AppendLine("update userInfo"); sb.AppendLine("set userName='******', userPwd='{1}', levelId={2},"); sb.AppendLine(" email='{3}', onlineDay={4}"); sb.AppendLine("where userid={5}"); return(DBUtil.ExecuteNonQuery(sb.ToString(), new string[] { u.Name, u.Pwd, u.LevelId + "", u.Email, u.OnlineDay + "", u.Id + "" })); }
internal void UpdateLevel() { DBUtil.ExecuteNonQuery("update userinfo set " + "levelId = (select max(levelId) from level " + "where onlineDays < onlineDay)", null); }