Пример #1
0
        private void cbxSeries_SelectedIndexChanged(object sender, EventArgs e)
        {
            if (cbxSeries.SelectedIndex != -1 && bsSeriesCbx.DataSource != null)
            {
                int series = (int)cbxSeries.SelectedValue;

                DatabaseSet.產品品號ViewDataTable table = new DatabaseSet.產品品號ViewDataTable();
                產品品號ViewTableAdapter.Instance.FillBy系列編號(table, series);

                bsPart.DataSource = table;
                dgvPart.AutoResizeColumns();
            }
        }
Пример #2
0
        void StorePart()
        {
            try
            {
                if (bsPart.DataSource != null)
                {
                    DatabaseSet.產品品號ViewDataTable table = bsPart.DataSource as DatabaseSet.產品品號ViewDataTable;

                    MessageBox.Show("更新了 " + 產品品號ViewTableAdapter.Instance.Update(table) + " 筆資料");

                    LoadPart(false);

                    NeedSave = false;
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
Пример #3
0
 public virtual DatabaseSet.產品品號ViewDataTable GetAll() {
     this.Adapter.SelectCommand = this.CommandCollection[2];
     DatabaseSet.產品品號ViewDataTable dataTable = new DatabaseSet.產品品號ViewDataTable();
     this.Adapter.Fill(dataTable);
     return dataTable;
 }
Пример #4
0
 public virtual DatabaseSet.產品品號ViewDataTable GetBy系列編號(int 系列編號) {
     this.Adapter.SelectCommand = this.CommandCollection[0];
     this.Adapter.SelectCommand.Parameters[0].Value = ((int)(系列編號));
     DatabaseSet.產品品號ViewDataTable dataTable = new DatabaseSet.產品品號ViewDataTable();
     this.Adapter.Fill(dataTable);
     return dataTable;
 }