/// <summary>
/// 洗车表中查找洗车记录
/// </summary>
/// <param name="plateBO"></param>
/// <returns></returns>
public List <string> PriciseSelectCarWashRecord(WashRecordBO washRecordBO)
{
string plate = washRecordBO.plate;
// string plate = "苏K225CA";
string query = "SELECT * FROM `ocr`.`car_wash_record` WHERE plate='" + plate + "' ORDER BY `wash_time`";
// 创建list存储数据
List <string> list = new List <string>();
//Open connection
if (this.OpenConnection() == true)
{
// 创建命令
MySqlCommand cmd = new MySqlCommand(query, connection);
// 读取数据
MySqlDataReader dataReader = cmd.ExecuteReader();
// 存储数据
while (dataReader.Read())
{
string str = dataReader["id"] + ","
+ dataReader["plate"] + ","
+ dataReader["wash_time"] + "";
string[] strArray = str.Split(',');
list.Add(str);
}
//close Data Reader
dataReader.Close();
//close Connection
this.CloseConnection();
//return list to be displayed
return(list);
}
else
{
return(list);
}
}
// INSERT INTO `ocr`.`car_wash_record`(`id`, `plate`) VALUES ('3', '苏K225CA')
public void InsertIntoWashRecord(WashRecordBO washRecordBO)
{
string id = washRecordBO.id;
string plate = washRecordBO.plate;
string washTime = washRecordBO.washTime;
string query = "INSERT INTO `ocr`.`car_wash_record`(`id`, `plate`) VALUES ('" + id + "', '" + plate + "')";
//open connection
if (this.OpenConnection() == true)
{
//create command and assign the query and connection from the constructor
MySqlCommand cmd = new MySqlCommand(query, connection);
//Execute command
cmd.ExecuteNonQuery();
//close connection
this.CloseConnection();
}
}
