//private void vendorBindingNavigatorSaveItem_Click(object sender, EventArgs e)
//{
// this.Validate();
// this.vendorBindingSource.EndEdit();
// vendorAdapter.Update(m_DataSet.Vendor);
//}
private void FormPrintSelect_Load(object sender, EventArgs e)
{
var vendorAdapter = new VoucherExpense.DamaiDataSetTableAdapters.VendorTableAdapter();
vendorAdapter.Connection.ConnectionString = DB.SqlConnectString(MyFunction.HardwareCfg);
try
{
vendorAdapter.Fill(m_DataSet.Vendor);
}
catch (Exception ex)
{
MessageBox.Show("讀取供貨商時出錯,原因:" + ex.Message);
Close();
return;
}
vendorBindingSource.DataSource = m_DataSet;
dgViewUserSelected.DataSource = m_FormVoucher.m_SelectedVoucher;
decimal sum = 0;
foreach (Voucher.CSelectedVoucher v in m_FormVoucher.m_SelectedVoucher)
{
sum += v.Cost;
}
labelSum.Text = sum.ToString("f1");
int count = this.m_FormVoucher.m_SelectedVoucher.Count;
labelCount.Text = "共 " + count.ToString() + "單";
if (count == 0)
{
btnPrintUserSelected.Enabled = false;
}
ShowSelectedVenders();
}
private void ReportByVender_Load(object sender, EventArgs e)
{
SetupBindingSource();
var vendorAdapter = new VoucherExpense.DamaiDataSetTableAdapters.VendorTableAdapter();
var voucherAdapter = new VoucherExpense.DamaiDataSetTableAdapters.VoucherTableAdapter();
var voucherDetailAdapter = new VoucherExpense.DamaiDataSetTableAdapters.VoucherDetailTableAdapter();
var IngredientAdapter = new VoucherExpense.DamaiDataSetTableAdapters.IngredientTableAdapter();
vendorAdapter.Connection.ConnectionString = DB.SqlConnectString(MyFunction.HardwareCfg);
IngredientAdapter.Connection.ConnectionString = DB.SqlConnectString(MyFunction.HardwareCfg);
try
{
vendorAdapter.Fill(m_DataSet.Vendor);
voucherAdapter.Fill(m_DataSet.Voucher);
voucherDetailAdapter.Fill(m_DataSet.VoucherDetail);
IngredientAdapter.Fill(m_DataSet.Ingredient);
}
catch (Exception ex)
{
MessageBox.Show("載入資料庫發生錯誤! 原因:" + ex.Message);
}
vendors.Add(new CNameIDForComboBox(0, " "));
foreach (var v in m_DataSet.Vendor)
{
vendors.Add(new CNameIDForComboBox(v.VendorID, v.Name));
}
vendors.Add(new CNameIDForComboBox(int.MaxValue, "全部"));
vendorIDComboBox.DataSource = vendors;
cbBoxMonth.SelectedIndex = DateTime.Now.Month;
this.voucherDGView.DataSource = null; // 原本先用了 vEDataSet.Voucher做格式
}
private void FormMonthlyPay_Load(object sender, EventArgs e)
{
vendorBindingSource.DataSource = m_DataSet;
var vendorAdapter = new VoucherExpense.DamaiDataSetTableAdapters.VendorTableAdapter();
var voucherAdapter = new VoucherExpense.DamaiDataSetTableAdapters.VoucherTableAdapter();
vendorAdapter.Connection.ConnectionString = DB.SqlConnectString(MyFunction.HardwareCfg);
vendorAdapter.Fill(m_DataSet.Vendor);
voucherAdapter.Fill(m_DataSet.Voucher);
}
private void Voucher_Load(object sender, EventArgs e)
{
var accountingTitleAdapter = new VoucherExpense.DamaiDataSetTableAdapters.AccountingTitleTableAdapter();
var vendorAdapter = new VoucherExpense.DamaiDataSetTableAdapters.VendorTableAdapter();
var operatorAdapter = new VoucherExpense.DamaiDataSetTableAdapters.OperatorTableAdapter();
IngredientAdapter.Connection.ConnectionString = DB.SqlConnectString(MyFunction.HardwareCfg);
vendorAdapter.Connection.ConnectionString = DB.SqlConnectString(MyFunction.HardwareCfg);
operatorAdapter.Connection.ConnectionString = DB.SqlConnectString(MyFunction.HardwareCfg);
accountingTitleAdapter.Connection.ConnectionString = DB.SqlConnectString(MyFunction.HardwareCfg);
SetupBindingSource();
try
{
voucherDetailAdapter.Fill(m_DataSet.VoucherDetail);
operatorAdapter.Fill(m_DataSet.Operator);
IngredientAdapter.Fill(m_DataSet.Ingredient);
accountingTitleAdapter.Fill(m_DataSet.AccountingTitle);
vendorAdapter.Fill(m_DataSet.Vendor);
voucherAdapter.Fill(m_DataSet.Voucher);
MyFunction.SetControlLengthFromDB(this, m_DataSet.Voucher);
}
catch (Exception ex)
{
MessageBox.Show("載入資料出錯:" + ex.Message);
}
if (checkMode)
{
this.Text = "查核進貨";
blockEdit();
dgvVoucher.Columns["columnCheck"].ReadOnly = false;
ckBoxAllowEdit.Visible = true;
}
if (MyFunction.LockAll)
{
blockEdit();
ckBoxAllowEdit.Visible = false;
}
if (MyFunction.IntHeaderYear != DateTime.Now.Year)
{
comboBoxMonth.SelectedIndex = comboBoxMonth.Items.Count - 1;
}
else
{
comboBoxMonth.SelectedIndex = DateTime.Now.Month;
}
// this.btnEditable.BringToFront();
BuildTitleCodeMenu();
dateTimePicker1.MaxDate = new DateTime(MyFunction.IntHeaderYear, 12, 31);
dateTimePicker1.MinDate = new DateTime(MyFunction.IntHeaderYear, 1, 1);
}
