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