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