private void FormShrink_Load(object sender, EventArgs e) { try { var inventoryTableAdapter = new VoucherExpense.DamaiDataSetTableAdapters.InventoryTableAdapter(); var productTableAdapter = new VoucherExpense.DamaiDataSetTableAdapters.ProductTableAdapter(); var ProductScrappedTableAdapter = new VoucherExpense.DamaiDataSetTableAdapters.ProductScrappedTableAdapter(); productTableAdapter.Connection.ConnectionString = DB.SqlConnectString(MyFunction.HardwareCfg); inventoryTableAdapter.Fill(Inventory); productTableAdapter.Fill(Product); ProductScrappedTableAdapter.Fill(ProductScrapped); InventoryData(); } catch (Exception ex) { MessageBox.Show(" " + ex.Message); } }
private void FormScraps_Load(object sender, EventArgs e) { m_OrderSet = m_DataSet; var productAdapter = new VoucherExpense.DamaiDataSetTableAdapters.ProductTableAdapter(); var operatorAdapter = new VoucherExpense.DamaiDataSetTableAdapters.OperatorTableAdapter(); productAdapter.Connection.ConnectionString = DB.SqlConnectString(MyFunction.HardwareCfg); operatorAdapter.Connection.ConnectionString = DB.SqlConnectString(MyFunction.HardwareCfg); SetupBindingSource(); productScrappedDetailBindingSource1.DataSource = productScrappedBindingSource; dgvScrappedDetail.DataSource = this.productScrappedDetailBindingSource1; try { productAdapter.Fill(m_OrderSet.Product); operatorAdapter.Fill(m_DataSet.Operator); ProductScrappedAdapter.Fill(m_DataSet.ProductScrapped); ProductScrappedDetailAdapter.Fill(m_DataSet.ProductScrappedDetail); } catch (Exception ex) { MessageBox.Show("錯誤:" + ex.Message); } List <string> scrapeTypeList = new List <string> { " ", "日報癈", "試吃", "其他" }; int i = 0; foreach (string s in scrapeTypeList) { m_TableTypeList.Add(new CNameIDForComboBox(i++, s)); } checkBox1.Text = scrapeTypeList[1]; checkBox2.Text = scrapeTypeList[2]; checkBox3.Text = scrapeTypeList[3]; fromPicker.MaxDate = toPicker.MaxDate = new DateTime(MyFunction.IntHeaderYear, 12, 31); toPicker.MinDate = toPicker.MinDate = new DateTime(MyFunction.IntHeaderYear, 1, 1); cNameIDForComboBoxBindingSource.DataSource = m_TableTypeList; ColumnLocked.ReadOnly = !MyFunction.LockInventory; }