private void SaleSpendRatio_Load(object sender, EventArgs e) { m_OrderSet = m_DataSet; SetupBindingSource(); var productAdapter = new VoucherExpense.DamaiDataSetTableAdapters.ProductTableAdapter(); var ingredientAdapter = new VoucherExpense.DamaiDataSetTableAdapters.IngredientTableAdapter(); var voucherAdapter = new VoucherExpense.DamaiDataSetTableAdapters.VoucherTableAdapter(); var voucherDetailAdapter = new VoucherExpense.DamaiDataSetTableAdapters.VoucherDetailTableAdapter(); productAdapter.Connection.ConnectionString = DB.SqlConnectString(MyFunction.HardwareCfg); ingredientAdapter.Connection.ConnectionString = DB.SqlConnectString(MyFunction.HardwareCfg); try { productAdapter.Fill(m_OrderSet.Product); ingredientAdapter.Fill(m_DataSet.Ingredient); voucherAdapter.Fill(m_DataSet.Voucher); voucherDetailAdapter.Fill(m_DataSet.VoucherDetail); } catch (Exception ex) { MessageBox.Show("資料庫讀取錯誤<" + ex.Message + ">, 後續操作無法進行!"); Close(); return; } cSaleItemBindingSource.DataSource = m_SaleList; this.dgViewSale.DataSource = cSaleItemBindingSource; stockItemBindingSource.DataSource = m_StockList; this.dgViewStock.DataSource = stockItemBindingSource; Reload(); }
private void FormSoldIngredients_Load(object sender, EventArgs e) { productBindingSource.DataSource = m_OrderSet; var productAdapter = new VoucherExpense.DamaiDataSetTableAdapters.ProductTableAdapter(); var customerAdapter = new VoucherExpense.DamaiDataSetTableAdapters.CustomerTableAdapter(); productAdapter.Connection.ConnectionString = DB.SqlConnectString(MyFunction.HardwareCfg); productAdapter.Fill(m_OrderSet.Product); customerAdapter.Fill(m_OrderSet.Customer); bind(); cbBoxMonth.Items.Clear(); for (int i = 1; i <= 12; i++) { cbBoxMonth.Items.Add(i.ToString() + "月"); } int month = DateTime.Now.Month; cbBoxMonth.SelectedIndex = month - 1; cSaleItemBindingSource.DataSource = m_SaleList; this.dgViewSale.DataSource = cSaleItemBindingSource; Reload(); if (cbBoxTable.Items.Count > 0) { cbBoxTable.SelectedIndex = 0; } chBoxShowHour_CheckedChanged(chBoxShowHour, null); }
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; }
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; }