public void InsertRecord(Model_Records record)
{
string sql = string.Format("INSERT INTO "
+ "records (id,placeid,name,carnumbers,contactway,entertime) "
+ " VALUES('{0}','{1}','{2}','{3}','{4}','{5}')"
, record.ReturnId(),record.ReturnPlaceid(),record.ReturnMasterName(),record.ReturnCarNumbers(),record.ReturnMasterContactWay(),record.ReturnEntertime().ToString());
conn.DBcmd(sql);
}
//结账操作
public void FinishOneRecord(Model_Records record)
{
string sql = "UPDATE records " +
" SET outtime='" + record.ReturnOutertime()
+ "',money='" + record.ReturnMoney() + "'" +
" WHERE carnumbers='" + record.ReturnCarNumbers() + "'";
conn.DBcmd(sql);
}