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;
}
