//插入操作 public void InsertNewCar(Model_FreedomCars newcar) { string sql = string.Format("INSERT INTO " + "freedomcar (placeid,carnumbers,name,contactway,entertime) " + " VALUES('{0}','{1}','{2}','{3}','{4}')" , newcar.ReturnPlaceid(), newcar.ReturnCarNumbers(), newcar.ReturnMasterName(), newcar.ReturnContactWay(), newcar.ReturnEnetertime().ToString()); conn.DBcmd(sql); }
//修改操作 public void UpdateInformation(Model_FreedomCars car) { string sql = "UPDATE freedomcar " + " SET placeid='" + car.ReturnPlaceid() + "',carnumbers='" + car.ReturnCarNumbers() + "',name='" + car.ReturnMasterName() + "',contactway='"+car.ReturnContactWay()+"'"+ " WHERE carnumbers='" + car.ReturnCarNumbers()+ "'"; conn.DBcmd(sql); }
//删除操作 public void DeleteOneCar(Model_FreedomCars leavecar) { string sql = "delete from freedomcar where carnumbers='"+ leavecar.ReturnCarNumbers()+"'"; conn.DBcmd(sql); }
public DataSet ReturnCarExitst(Model_FreedomCars car) { string sql = string.Format("select * from freedomcar where carnumbers='{0}'" + "and placeid='{1}' and name='{2}'" , car.ReturnCarNumbers(), car.ReturnPlaceid(), car.ReturnMasterName()); return conn.DBQuery(sql); }