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 FormIngredientInventories_Load(object sender, EventArgs e) { SetupBindingSource(); dgvInventories.DataSource = inventoryBindingSource; dgvInventoryDetail.DataSource = fKInventoryDetailInventoryBindingSource; dgvProducts.DataSource = fKInventoryProductsInventoryBindingSource; var productAdapter = new VoucherExpense.DamaiDataSetTableAdapters.ProductTableAdapter(); var operatorAdapter = new VoucherExpense.DamaiDataSetTableAdapters.OperatorTableAdapter(); var ingredientAdapter = new VoucherExpense.DamaiDataSetTableAdapters.IngredientTableAdapter(); productAdapter.Connection.ConnectionString = DB.SqlConnectString(MyFunction.HardwareCfg); operatorAdapter.Connection.ConnectionString = DB.SqlConnectString(MyFunction.HardwareCfg); ingredientAdapter.Connection.ConnectionString = DB.SqlConnectString(MyFunction.HardwareCfg); try { productAdapter.Fill(m_OrderSet.Product); operatorAdapter.Fill(m_DataSet.Operator); ingredientAdapter.Fill(m_DataSet.Ingredient); InventoryAdapter.Fill(m_DataSet.Inventory); InventoryDetailAdapter.Fill(m_DataSet.InventoryDetail); InventoryProductsAdapter.Fill(m_DataSet.InventoryProducts); } catch (Exception ex) { MessageBox.Show("錯誤訊息:" + ex.Message); } ColumnLocked.ReadOnly = !MyFunction.LockInventory; if (MyFunction.LockInventory) { dgvColumnCurrentIn.Visible = true; dgvColumnLostMoney.Visible = true; dgvColumnPrevStockVolume.Visible = true; } else { dgvColumnCurrentIn.Visible = false; dgvColumnLostMoney.Visible = false; dgvColumnPrevStockVolume.Visible = false; } // tabControl1.DrawMode = TabDrawMode.OwnerDrawFixed; }