public void Del(User user) { dbConn.Open(); dbCom.CommandText = "delete from users where id=?"; dbCom.Parameters.Add(new OleDbParameter("id", user.Id)); dbCom.ExecuteNonQuery(); dbConn.Close(); }
public void Add(User user) { dbConn.Open(); dbCom.CommandText = "insert into users(code,name) values(?,?)"; dbCom.Parameters.Add(new OleDbParameter("code", user.Code)); dbCom.Parameters.Add(new OleDbParameter("name", user.Name)); dbCom.ExecuteNonQuery(); dbConn.Close(); }
public void Update(User user) { dal.Update(user); }
public void Del(User user) { dal.Del(user); }
public void Add(User user) { dal.Add(user); }
public void Update(User user) { dbConn.Open(); dbCom.CommandText = "update users set code=?,name=? where id=?"; dbCom.Parameters.Add(new OleDbParameter("code", user.Code)); dbCom.Parameters.Add(new OleDbParameter("name", user.Name)); dbCom.Parameters.Add(new OleDbParameter("id", user.Id)); dbCom.ExecuteNonQuery(); dbConn.Close(); }