frmhotelmanager.cs

一个简单的旅 游管理系统

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