コード例 #1
0
        public List <string> GetAllVehicleNumbers()
        {
            DataTable dt = new DataTable();

            using (SqlCommand command = new SqlCommand())
            {
                dt = GetMultipleQuery(VehicleStringsSql.GetAllVehicleNumbers());
            }

            List <VehicleModel> arrVehicle = new List <VehicleModel>();

            foreach (DataRow ms in dt.Rows)
            {
                arrVehicle.Add(VehicleModel.ToObject(ms));
            }

            List <string> vehicleNumbers = new List <string>();

            foreach (var vehicle in arrVehicle)
            {
                vehicleNumbers.Add(vehicle.vehicleNumber);
            }

            return(vehicleNumbers);
        }