//修改操作
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 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 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);
}
