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

namespace AutoComplete
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }
        DataTable dt = new DataTable();
        private void Form1_Load(object sender, EventArgs e)
        {
            BindDataList();
        }

        private void NewMethod(string CodeName)
        {
            DataTable dt_New = new DataTable();
            dt_New = dt.Clone();
            try
            {
                //克隆一张Table对其进行筛选，条件则是用户输入的字符串，模糊查询。
                DataRow[] dr = dt.Select("TCode like '%" + CodeName + "%'");
                for (int i = 0; i < dr.Length; i++)
                {
                    dt_New.ImportRow((DataRow)dr[i]);
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("Error!  " + ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                return;
            }
            if (dt_New.Rows.Count > 0)
            {
                //如果数据为空则不显示ListBox
                this.lsbCode1.Visible = true;
                this.lsbCode1.Items.Clear();
                for (int i = 0; i < dt_New.Rows.Count; i++)
                {
                    //有时候字符长度不一致导致布局很难看，这里统一增加一些空格，看上去整齐一点。
                    this.lsbCode1.Items.Add(dt_New.Rows[i][0].ToString().Trim().PadRight(10) + dt_New.Rows[i][1].ToString());
                }
            }
            else
            {
                this.lsbCode1.Visible = false;
            }

        }

        /// <summary>
        /// 测试数据，实际应用中可以指定数据库里面的数据。
        /// </summary>
        void BindDataList()
        {
            dt.Columns.Add("TCode");
            dt.Columns.Add("Description");

            dt.Rows.Add("AL01", "SAP Alert Monitor SAP报警监视器");
            dt.Rows.Add("AL02", "Database alert monitor 数据库警报监测器");
            dt.Rows.Add("AL03", "Operating system alert monitor 操作系统警告监视器");
            dt.Rows.Add("AL04", "Monitor call distribution 监视呼叫分配");
            dt.Rows.Add("AL05", "Monitor current workload 监视当前的工作负荷");
            dt.Rows.Add("CO03", "显示生产订单");
            dt.Rows.Add("C005N", "Collective Release");
            dt.Rows.Add("CO11N", "Time Ticket");
            dt.Rows.Add("CO12", "Confirmation - Collective");
            dt.Rows.Add("CO13", "Confirmation - Cancel");
            dt.Rows.Add("COOIS", "Production order information system");
            dt.Rows.Add("SE01", "Transport Organizer 传送组织者");
            dt.Rows.Add("SE03", "Workbench Organizer: Tools 工作台组织器：工具");
            dt.Rows.Add("SE06", "Set Up Workbench Organizer 设置工作台组织器");
            dt.Rows.Add("SE07", "Transport System Status Display 传输系统状态显示");
            dt.Rows.Add("SE09", "Workbench Organizer 工作平台组织者");
            dt.Rows.Add("SE10", "Customizing Organizer 自定义组织者");
            dt.Rows.Add("SE11", "数据库浏览");
            dt.Rows.Add("SE16", "Data Browser: Initial Screen");
            dt.Rows.Add("SE16N", "Table Browser (the N stands for New, it replaces SE16)");
            dt.Rows.Add("SE17", "General Table Display 通用表显示");
            dt.Rows.Add("MM01", "Create Material 创建物料信息");
            dt.Rows.Add("MM02", "Modify Material 修改物料信息");
            dt.Rows.Add("MM03", "Display Material 显示物料信息");
            dt.Rows.Add("ME11", "创建采购信息记录");
            dt.Rows.Add("ME01", "维护货源清单");
            dt.Rows.Add("ME51N", "创建采购申请");
            dt.Rows.Add("ME5A", "显示采购申请清单");

        }

        private void txtCode_TextChanged(object sender, EventArgs e)
        {
            this.lsbCode1.Visible = false;
            if (txtCode.Text == "")
            {
                //如果条件为空则清空已有数据，并隐藏ListBox
                this.lsbCode1.Items.Clear();
                this.lsbCode1.Visible = false;
            }
            else
            {
                //条件不为空则执行筛选数据的函数。
                NewMethod(this.txtCode.Text.Trim());
            }
        }
    }
}