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));
}
//修改操作
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);
}
private void Button_Freecar_Search_Click(object sender, EventArgs e)
{
//清除数据
this.dataGridView_freecars.Rows.Clear();
if (this.comboBox_records.SelectedItem.ToString() == "" || this.textBox_records.Text == "")
{
MessageBox.Show("查询方式有误，请重试！");
}
else
{
//返回结果
Model_FreedomCars freecar = BLL_FreedomCars.ReturnSearchBy(this.comboBox_freecar.SelectedItem.ToString(), this.textBox_freecar.Text);
if (freecar != null)
{
int index = this.dataGridView_freecars.Rows.Add();
this.dataGridView_freecars.Rows[index].Cells["freecarnumbers"].Value = freecar.ReturnCarNumbers();
this.dataGridView_freecars.Rows[index].Cells["freeplaceid"].Value = freecar.ReturnPlaceid();
this.dataGridView_freecars.Rows[index].Cells["freemastername"].Value = freecar.ReturnMasterName();
this.dataGridView_freecars.Rows[index].Cells["freetel"].Value = freecar.ReturnContactWay();
this.dataGridView_freecars.Rows[index].Cells["freeentertime"].Value = freecar.ReturnEnetertime();
}
}
}
