public void RemoveMaintain(maintain m) { maintains.Remove(m); DatabaseUtil dbu = new DatabaseUtil(); string sql = "delete from t_maintainForm where id=" + m.getMID(); dbu.Open(); dbu.Excute(sql); dbu.Close(); }
public void AddMaintain(maintain m) { maintains.Add(m); DatabaseUtil dbu = new DatabaseUtil(); string sql = "insert into t_maintainForm values " + m.getTime() + "," + m.getName() + "," + m.getAddress() + "," + m.getType() + "," + m.getText() + "," + m.getState() + "," + m.getWorker() + "," + m.getFeederivate() + "," + m.getFee() + ")"; dbu.Open(); dbu.Excute(sql); dbu.Close(); }