コード例 #1
0
        private void btnDelete_Click(object sender, EventArgs e)
        {
            if (MessageBox.Show("OK to delete this information it flights?", "Tips", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
            {
                if (dgridView.CurrentRow.Index > -1)
                {
                    int nID = (int)dgridView[0, dgridView.CurrentRow.Index].Value;

                    TicketInfo ticket = new TicketInfo();
                    ticket.Id = nID;


                    if (access.DeleteTicket(ticket))
                    {
                        MessageBox.Show("Removal Information Success!!!", "Tips", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
                        LoadData();
                    }
                    else
                    {
                        MessageBox.Show("Delete information failed!!!", "Tips", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
                    }
                }
                else
                {
                    MessageBox.Show("Please select the information to be deleted!!!", "Tips", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
                }
            }
        }
コード例 #2
0
        private void btnAdd_Click(object sender, EventArgs e)
        {
            TicketInfo ticket = new TicketInfo();

            ticket.FlightNo    = this.txtFeightNo.Text.Trim();
            ticket.SeatCount   = Convert.ToInt32(this.txtSeatCount.Text.Trim());
            ticket.LeaveCity   = this.txtLeaveCity.Text.Trim();
            ticket.Destination = this.txtArriveCity.Text.Trim();
            ticket.LeaveTime   = Convert.ToDateTime(this.dtpLeaveTime.Text.Trim());
            ticket.ArriveTime  = Convert.ToDateTime(this.dtpLeaveTime.Text.Trim());
            ticket.SecondClass = Convert.ToSingle(this.txtSecondPrice.Text.Trim());
            ticket.FirstClass  = Convert.ToSingle(this.txtFirstPrice.Text.Trim());


            if (access.InsertTicket(ticket))
            {
                MessageBox.Show("Add Success!!!", "Tips", MessageBoxButtons.OK, MessageBoxIcon.Information);
                main.LoadData();
                this.Close();
            }
            else
            {
                MessageBox.Show("Add Failed!!!", "Tips", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
        }
コード例 #3
0
        public DataTable InquireTicket(TicketInfo ticket)
        {
            string Sql = "SELECT Id, FlightNO, SeatCount,LeaveCity," +
                         " Destination, LeaveTime,arriveTime, SecondClass" +
                         ", FirstClass FROM TicketInfo Where LeaveCity like '%" + ticket.LeaveCity + "%' and " +
                         "Destination like'%" + ticket.Destination + "%'";

            return(GetDataSource(Sql, "Query"));
        }
コード例 #4
0
        private void btnQuery_Click(object sender, EventArgs e)
        {
            TicketInfo ticket = new TicketInfo();

            ticket.LeaveCity   = txtLeaveCity.Text.Trim();
            ticket.Destination = txtArriveCity.Text.Trim();

            dgridView.DataSource = access.InquireTicket(ticket);
        }
コード例 #5
0
        public bool UpdateTicket(TicketInfo ticket)
        {
            string Sql = string.Format("Update TicketInfo Set FlightNO='{0}', LeaveCity='{1}',Destination='{2}',LeaveTime='{3}',arriveTime='{4}',SecondClass={5},FirstClass={6},SeatCount={7} Where Id={8}", ticket.FlightNo, ticket.LeaveCity, ticket.Destination, ticket.LeaveTime, ticket.ArriveTime, ticket.SecondClass, ticket.FirstClass, ticket.SeatCount, ticket.Id);

            return(ExcuteSql(Sql));
        }
コード例 #6
0
        public bool InsertTicket(TicketInfo ticket)
        {
            string Sql = string.Format("Insert into TicketInfo values('{0}','{1}','{2}','{3}','{4}','{5}',{6},{7})", ticket.FlightNo, ticket.LeaveCity, ticket.Destination, ticket.LeaveTime, ticket.ArriveTime, ticket.SecondClass, ticket.FirstClass, ticket.SeatCount);

            return(ExcuteSql(Sql));
        }
コード例 #7
0
        public bool DeleteTicket(TicketInfo ticket)
        {
            string Sql = "Delete From TicketInfo Where Id=" + ticket.Id;

            return(ExcuteSql(Sql));
        }