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