public bool insertVehicleInfo(DAO.VehicleInfoDao dao)
{
string sql = "insert into t_vehicle(vehicle_num,vehicle_owner,vehicle_grand,vehicle_kind,vehicle_color,is_temp) values " +
" ('" + dao.Vehiclenum + "'," + dao.Vehicleowner + ",'" + dao.Vehiclegrand + "','" + dao.Vehiclekind + "','" + dao.Vehiclecolor + "'," + dao.Istemp + ") ";
return(this.InsertQuery(sql));
}
public DAO.VehicleInfoDao selectVehicleInfoID(string id)
{
string tablename = "t_vehicle";
string sql = "select a.id,a.vehicle_num,b.name as vehicleownername,a.vehicle_grand,a.vehicle_kind,a.vehicle_color,c.groupname " +
" from " + tablename + " a " +
" left join t_passenger b on b.id=a.vehicle_owner " +
" left join t_group c on c.id=b.group where a.id=" + id + " ";
DataTable _dt = this.SelectQuery(sql);
if (_dt == null || _dt.Rows.Count <= 0)
{
return(null);
}
else
{
DAO.VehicleInfoDao dao = new DAO.VehicleInfoDao();
dao.Vehiclenum = _dt.Rows[0]["vehicle_num"].ToString();
dao.Vehicleowner = _dt.Rows[0]["vehicleownername"].ToString();
dao.Vehiclegrand = _dt.Rows[0]["vehicle_grand"].ToString();
dao.Vehiclekind = _dt.Rows[0]["vehicle_kind"].ToString();
dao.Vehiclecolor = _dt.Rows[0]["vehicle_color"].ToString();
return(dao);
}
}
