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