예제 #1
0
        private void AutoSuggestPartCode()
        {
            DataTable dt = new DataTable();

            _dbpo = new BusPOMonitoring();

            dt = _dbpo.GetPartsByCustomerDT(Convert.ToInt32(cboCustomer.SelectedValue.ToString()));

            if (dt.Rows.Count > 0)
            {
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    coll.Add(dt.Rows[i]["Part_ID"].ToString());
                }
            }
            else
            {
            }

            tbPartCode.AutoCompleteMode = AutoCompleteMode.Suggest;

            tbPartCode.AutoCompleteSource = AutoCompleteSource.CustomSource;

            tbPartCode.AutoCompleteCustomSource = coll;
        }
예제 #2
0
        private void LoadCustomers()
        {
            _dbpo = new BusPOMonitoring();

            cboCustomer.DisplayMember = "ModifiedCustomer";

            cboCustomer.ValueMember = "Cust_ID";

            cboCustomer.DataSource = _dbpo.GetAllCustomersDT();
        }
예제 #3
0
        private void GetPartName()
        {
            _dbpo = new BusPOMonitoring();

            if (_dbpo.GetPartNameByPartIDDT(Convert.ToInt32(cboCustomer.SelectedValue.ToString()), tbPartCode.Text).Rows.Count == 0)
            {
                MessageBox.Show("No Part Name Found");
            }
            else
            {
                foreach (DataRow dr in _dbpo.GetPartNameByPartIDDT(Convert.ToInt32(cboCustomer.SelectedValue.ToString()), tbPartCode.Text).Rows)
                {
                    tbPartName.Text = dr["Part_Description"].ToString();
                }
            }
        }