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