using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;

namespace Database.v4
{
    public partial class frmHotelManager : Form
    {
        private string CondTion = "";

        public frmHotelManager()
        {
            InitializeComponent();
            cmb_seachColumn.Items.Add("酒店編號");
            cmb_seachColumn.Items.Add("酒店名稱");
            cmb_seachColumn.SelectedItem = "酒店名稱";
        }

        private void frmHotelManager_Load(object sender, EventArgs e)
        {

        }

        private void btnsearch_Click(object sender, EventArgs e)
        {
            CondTion = "";
            if (this.txt_search.Text.Trim() != "")
            {
                if ((string)cmb_seachColumn.SelectedItem == "酒店編號")
                {
                    this.CondTion = " and Hotelid like '%" + this.txt_search.Text + "%'";
                }
                else if ((string )cmb_seachColumn.SelectedItem == "酒店名稱")
                {
                    this.CondTion = " and Hotelname like '%" + this.txt_search.Text + "%'";
                }
            }
            pageControl1.PageSize = 6;
            load_Data();
        }
        public void load_Data()
        {

            try
            {
                //查詢記錄總條數
                int RCount = 0;

                //設置表控件不可自調節列
                dgwHotel.AutoGenerateColumns = false;

                //業務邏輯類
                DataTable dt = BussinessFacade.hotel._hotel.GetInfo(CondTion, pageControl1.PageIndex, pageControl1.PageSize, out RCount);

                //將數據表格用數據集中的數據填充
                dgwHotel.DataSource = dt;


                //設置當前記錄數
                this.pageControl1.RecordCount = RCount;  
            }
            catch (Exception es)
            {
                MessageBox.Show("錯誤:" + es.Message.ToString());
            }
        }
    }
}