reasoning.cs

一个用于两地间交通方案选择的小决策支持系统

using System;
using System.Collections.Generic;
using System.Text;

namespace AIToSH
{
    class Reasoning
    {
        private bool time;
        private bool seat;
        private bool quick;
        private bool price;
        private bool town;
        private bool special;

        public Reasoning(bool time,
                          bool seat,
                          bool quick,
                          bool price,
                          bool town,
                          bool special)
        {
            this.time = time;
            this.seat = seat;
            this.quick =quick;
            this.price = price;
            this.town = town;
            this.special = special;
        }

        public string getTrainSql()
        {
            if (special)
                return "Select TNO,LeaveTime,ArriveTime,RunTime,Type,Price FROM TRAIN WHERE run=137";
            /*if (!time)
                return "Select TNO,LeaveTime,ArriveTime,RunTime,Type,Price FROM TRAIN WHERE TNO='0000'";
            if (time)
            {
                if (seat && quick && price)
                    return "Select TNO,LeaveTime,ArriveTime,RunTime,Type,Price From TRAIN where first = true AND TNO like 'T%' AND Price<=47";
                if (seat && quick && !price)
                    return "Select TNO,LeaveTime,ArriveTime,RunTime,Type,Price From TRAIN WHERE first = true AND TNO like 'T%'";
                if (seat && !quick && !price)
                    return "Select TNO,LeaveTime,ArriveTime,RunTime,Type,Price From TRAIN WHERE first = true";
                if (seat && !quick && price)
                    return "Select TNO,LeaveTime,ArriveTime,RunTime,Type,Price From TRAIN WHERE first = true AND Price<=47";
                if (!seat && quick && price)
                    return "Select TNO,LeaveTime,ArriveTime,RunTime,Type,Price From TRAIN WHERE TNO like 'T%' AND Price<=47";
                if (!seat && quick && !price)
                    return "Select TNO,LeaveTime,ArriveTime,RunTime,Type,Price FROM TRAIN WHERE TNO like 'T%'";
                if (!seat && !quick && !price)
                    return "Select TNO,LeaveTime,ArriveTime,RunTime,Type,Price FROM TRAIN";
                if (!seat && !quick && price)
                    return "Select TNO,LeaveTime,ArriveTime,RunTime,Type,Price FROM TRAIN WHERE Price<=47";
            }*/
            else
            {
                if (seat && quick && price)
                    return "Select TNO,LeaveTime,ArriveTime,RunTime,Type,Price From TRAIN where first = true AND TNO like 'T%' AND Price<=47";
                if (seat && quick && !price)
                    return "Select TNO,LeaveTime,ArriveTime,RunTime,Type,Price From TRAIN WHERE first = true AND TNO like 'T%'";
                if (seat && !quick && !price)
                    return "Select TNO,LeaveTime,ArriveTime,RunTime,Type,Price From TRAIN WHERE first = true";
                if (seat && !quick && price)
                    return "Select TNO,LeaveTime,ArriveTime,RunTime,Type,Price From TRAIN WHERE first = true AND Price<=47";
                if (!seat && quick && price)
                    return "Select TNO,LeaveTime,ArriveTime,RunTime,Type,Price From TRAIN WHERE TNO like 'T%' AND Price<=47";
                if (!seat && quick && !price)
                    return "Select TNO,LeaveTime,ArriveTime,RunTime,Type,Price FROM TRAIN WHERE TNO like 'T%'";
                if (!seat && !quick && !price)
                    return "Select TNO,LeaveTime,ArriveTime,RunTime,Type,Price FROM TRAIN";
                if (!seat && !quick && price)
                    return "Select TNO,LeaveTime,ArriveTime,RunTime,Type,Price FROM TRAIN WHERE Price<=47";
            }

            return "Select TNO,LeaveTime,ArriveTime,RunTime,Type,Price FROM TRAIN WHERE TNO='0000'";
        }

        public string getCarSql()
        {
            if (special)
                return "SELECT CNO,LeaveTime,ArriveTime,RunTime,LeaveStation,Type,Price FROM CAR WHERE CNO='0000'";
            if (time)
                return "SELECT CNO,LeaveTime,ArriveTime,RunTime,LeaveStation,Type,Price FROM CAR WHERE CNO='0000'";
            else if (!time)
            {
                if (town && quick && price)
                    return "SELECT CNO,LeaveTime,ArriveTime,RunTime,LeaveStation,Type,Price FROM CAR WHERE CNO like 'K%' AND LeaveStation='南京中央门站' AND Price<=82";
                if (town && !quick && price)
                    return "SELECT CNO,LeaveTime,ArriveTime,RunTime,LeaveStation,Type,Price FROM CAR WHERE LeaveStation='南京中央门站' AND Price<=82";
                if (town && quick && !price)
                    return "SELECT CNO,LeaveTime,ArriveTime,RunTime,LeaveStation,Type,Price FROM CAR WHERE CNO like 'K%' AND LeaveStation='南京中央门站'";
                if (town && !quick && !price)
                    return "SELECT CNO,LeaveTime,ArriveTime,RunTime,LeaveStation,Type,Price FROM CAR WHERE LeaveStation='南京中央门站'";
                if (!town && quick && price)
                    return "SELECT CNO,LeaveTime,ArriveTime,RunTime,LeaveStation,Type,Price FROM CAR WHERE CNO like 'K%' AND Price<=82";
                if (!town && !quick && price)
                    return "SELECT CNO,LeaveTime,ArriveTime,RunTime,LeaveStation,Type,Price FROM CAR WHERE Price<=82";
                if (!town && quick && !price)
                    return "SELECT CNO,LeaveTime,ArriveTime,RunTime,LeaveStation,Type,Price FROM CAR WHERE CNO like 'K%'";
                if (!town && !quick && !price)
                    return "SELECT CNO,LeaveTime,ArriveTime,RunTime,LeaveStation,Type,Price FROM CAR";
            }
            return "SELECT CNO,LeaveTime,ArriveTime,RunTime,LeaveStation,Type,Price FROM CAR WHERE CNO='0000'";
        }
    }
}