private void FormAccVoucher_Load(object sender, EventArgs e)
{
SetupBindingSource();
var HRAdapter = new VoucherExpense.DamaiDataSetTableAdapters.HRTableAdapter();
var operatorAdapter = new VoucherExpense.DamaiDataSetTableAdapters.OperatorTableAdapter();
var accTitleAdapter = new VoucherExpense.DamaiDataSetTableAdapters.AccountingTitleTableAdapter();
operatorAdapter.Connection.ConnectionString = DB.SqlConnectString(MyFunction.HardwareCfg);
accTitleAdapter.Connection.ConnectionString = DB.SqlConnectString(MyFunction.HardwareCfg);
HRAdapter.Fill(m_DataSet.HR);
operatorAdapter.Fill(m_DataSet.Operator);
accTitleAdapter.Fill(m_DataSet.AccountingTitle);
accVoucherAdapter.Fill(m_DataSet.AccVoucher);
dateTimePicker1.MaxDate = new DateTime(MyFunction.IntHeaderYear, 12, 31);
dateTimePicker1.MinDate = new DateTime(MyFunction.IntHeaderYear, 1, 1);
if (CheckMode)
{
this.Text = "傳票查核";
blockEdit();
columnCheck.ReadOnly = false; // DataGridView裏的columnCheck
ckBoxAllowEdit.Visible = true;
}
else
{
ckBoxAllowEdit.Visible = false;
}
if (MyFunction.LockAll)
{
blockEdit();
ckBoxAllowEdit.Visible = false;
}
}
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);
}
private void EditBakeryProduct_Load(object sender, EventArgs e)
{
productAdapter.Connection.ConnectionString = DB.SqlConnectString(MyFunction.HardwareCfg);
productClassTableAdapter.Connection.ConnectionString = DB.SqlConnectString(MyFunction.HardwareCfg);
PhotoAdapter.Connection.ConnectionString = DB.SqlConnectString(MyFunction.HardwareCfg);
this.productClassTableAdapter.Fill(this.damaiDataSet.ProductClass);
var accountingTitleAdapter = new MyAccountingTitleAdapter();
productBindingSource.DataSource = m_DataSet;
m_PhotoDirectoryExist = Directory.Exists(PhotoPath());
photoPictureBox.Visible = true;
accountingTitleBindingSource.DataSource = m_DataSet;
accountingTitleAdapter.Fill(m_DataSet.AccountingTitle);
productAdapter.Fill(m_DataSet.Product);
SetControlLengthFromDB(this, m_DataSet.Product);
}
private void FormBankDetail_Load(object sender, EventArgs e)
{
SetupBindingSource();
var bankAccountAdapter = new VoucherExpense.DamaiDataSetTableAdapters.BankAccountTableAdapter();
var accountingTitleAdapter = new VoucherExpense.DamaiDataSetTableAdapters.AccountingTitleTableAdapter();
accountingTitleAdapter.Connection.ConnectionString = DB.SqlConnectString(MyFunction.HardwareCfg);
bankAccountAdapter.Fill(m_DataSet.BankAccount);
accountingTitleAdapter.Fill(m_DataSet.AccountingTitle);
bankDetailAdapter.Fill(m_DataSet.BankDetail);
//accountingTitleBindingSource.Filter =
// "(TitleCode like '1*' or TitleCode like '2*')";
//int btm = bankDetailBindingNavigator.Bottom + 5;
//dgvBankDetail.Top = btm - Top;
//dgvBankDetail.Height = Height - dgvBankDetail.Top - 5;
calendar.MaxDate = new DateTime(MyFunction.IntHeaderYear, 12, 31);
calendar.MinDate = new DateTime(MyFunction.IntHeaderYear, 1, 1);
MakeBankAccountComboBox();
List <AccTitle> AssetList = new List <AccTitle>();
foreach (var r in m_DataSet.AccountingTitle)
{
if (r.TitleCode.Length == 0)
{
continue;
}
AccTitle item = new AccTitle(r.TitleCode, r.Name);
if (r.IsInitialValueNull())
{
item.Money = 0;
}
else
{
item.Money = r.InitialValue;
}
char c = r.TitleCode[0];
if (c == '1')
{
AssetList.Add(item);
}
}
foreach (var r in m_DataSet.BankAccount)
{
BankDictionary.Add(r.ID, new BankDefault(r.AccountTitleCode, r.DefaultTitleCode));
}
AccTitle defaultAsset = Find(Setup.DefaultAsset, AssetList, null);
foreach (KeyValuePair <int, BankDefault> pair in BankDictionary)
{
BankDefault bank = pair.Value;
bank.DefaultTitle = Find(bank.DefaultCode, AssetList, defaultAsset);
AccTitle title = Find(bank.BankCode, AssetList, defaultAsset);
if (title != null)
{
bank.InitialValue = title.Money;
}
}
if (cbSelectBank.Items.Count > 1)
{
cbSelectBank.SelectedIndex = cbSelectBank.Items.Count - 1;
}
if (MyFunction.LockAll)
{
dgvBankDetail.ReadOnly = true;
}
}
private void Expense_Load(object sender, EventArgs e)
{
SetupBindingSource();
var bankAccountAdapter = new VoucherExpense.DamaiDataSetTableAdapters.BankAccountTableAdapter();
var operatorAdapter = new VoucherExpense.DamaiDataSetTableAdapters.OperatorTableAdapter();
var accTitleAdapter = new VoucherExpense.DamaiDataSetTableAdapters.AccountingTitleTableAdapter();
var HRAdapter = new VoucherExpense.DamaiDataSetTableAdapters.HRTableAdapter();
operatorAdapter.Connection.ConnectionString = DB.SqlConnectString(MyFunction.HardwareCfg);
accTitleAdapter.Connection.ConnectionString = DB.SqlConnectString(MyFunction.HardwareCfg);
bankAccountAdapter.Fill(m_DataSet.BankAccount);
operatorAdapter.Fill(m_DataSet.Operator);
accTitleAdapter.Fill(m_DataSet.AccountingTitle);
HRAdapter.Fill(m_DataSet.HR);
expenseAdapter.Fill(m_DataSet.Expense);
MyFunction.SetControlLengthFromDB(this, m_DataSet.Expense);
if (checkMode)
{
this.Text = "查核費用";
blockEdit();
expenseDataGridView.Columns["columnCheck"].ReadOnly = false;
ckBoxAllowEdit.Visible = true;
}
else
{
ckBoxAllowEdit.Visible = false;
}
if (!零用金mode)
{
bankAccountIDComboBox.Visible = true;
labelBank.Visible = true;
cbSelectBank.Enabled = true;
}
cbSelectBank.Items.Clear();
cbSelectBank.Items.Add("全部");
foreach (var r in m_DataSet.BankAccount)
{
cbSelectBank.Items.Add(r.ShowName);
}
// 資料準備好,再加上EventHandler
this.cbSelectBank.SelectedIndexChanged += new System.EventHandler(this.cbSelectBank_SelectedIndexChanged);
if (cbSelectBank.Items.Count > 1)
{
cbSelectBank.SelectedIndex = 1;
}
comboBoxMonth.SelectedIndex = DateTime.Now.Month;
if (MyFunction.LockAll)
{
blockEdit();
ckBoxAllowEdit.Visible = false;
}
// comboBoxMonth.SelectedIndex = DateTime.Now.Month;
dateTimePicker1.MaxDate = new DateTime(MyFunction.IntHeaderYear, 12, 31);
dateTimePicker1.MinDate = new DateTime(MyFunction.IntHeaderYear, 1, 1);
}
private void ReportByTitle_Load(object sender, EventArgs e)
{
var headerAdapter = new MyHeaderAdapter();
m_OrderSet = m_DataSet;
var accTitleAdapter = new VoucherExpense.DamaiDataSetTableAdapters.AccountingTitleTableAdapter();
var bankAccountAdapter = new VoucherExpense.DamaiDataSetTableAdapters.BankAccountTableAdapter();
var expenseAdapter = new VoucherExpense.DamaiDataSetTableAdapters.ExpenseTableAdapter();
var voucherAdapter = new VoucherExpense.DamaiDataSetTableAdapters.VoucherTableAdapter();
var voucherDetailAdapter = new VoucherExpense.DamaiDataSetTableAdapters.VoucherDetailTableAdapter();
var bankDetailAdapter = new VoucherExpense.DamaiDataSetTableAdapters.BankDetailTableAdapter();
var accVoucherAdapter = new VoucherExpense.DamaiDataSetTableAdapters.AccVoucherTableAdapter();
accTitleAdapter.Connection.ConnectionString = DB.SqlConnectString(MyFunction.HardwareCfg);
try
{
headerAdapter.Fill(m_OrderSet.Header);
}
catch { MessageBox.Show("標頭資料讀取錯誤,你的資料庫版本可能不對"); }
int count = m_OrderSet.Header.Count;
if (count == 0)
{
MessageBox.Show("無資料!");
Close();
return;
}
var row = m_OrderSet.Header[count - 1];
Revenue = new RevenueCalcBakery(row.DataDate, 0);
AccList.NewAll();
BankDictionary = new Dictionary <int, BankDefault>();
RevenueCache = new MonthlyReportData[12];
MonthBalances = new CMonthBalance[13];
for (int i = 0; i < 13; i++)
{
MonthBalances[i] = new CMonthBalance();
MonthBalances[i].Month = i + 1;
}
MonthBalances[12].Month = 0; // 第13月統計用
cMonthBalanceBindingSource.DataSource = MonthBalances;
string[] Name = new string[6] {
"資產", "負債", "收入", "成本", "費用", "股東權益"
};
comboBox1.Items.Clear();
comboBox2.Items.Clear();
foreach (string str in Name)
{
comboBox1.Items.Add(str);
comboBox2.Items.Add(str);
}
try
{
accTitleAdapter.Fill(m_DataSet.AccountingTitle);
bankAccountAdapter.Fill(m_DataSet.BankAccount);
expenseAdapter.Fill(m_DataSet.Expense); // expense檔案小,先全部讀進記憶體
voucherAdapter.Fill(m_DataSet.Voucher);
voucherDetailAdapter.Fill(m_DataSet.VoucherDetail);
bankDetailAdapter.Fill(m_DataSet.BankDetail);
accVoucherAdapter.Fill(m_DataSet.AccVoucher);
foreach (var r in m_DataSet.AccountingTitle)
{
AccTitle item = new AccTitle(r.TitleCode, r.Name);
if (r.IsInitialValueNull())
{
item.Money = 0;
}
else
{
item.Money = r.InitialValue;
}
if (r.TitleCode.Length == 0)
{
continue;
}
AccList.Add(item);
}
AccList1.CopyTableFrom(AccList);
foreach (var r in m_DataSet.BankAccount)
{
BankDictionary.Add(r.ID, new BankDefault(r.AccountTitleCode, r.DefaultTitleCode));
}
comboBox1.SelectedIndex = 0;
comboBox2.SelectedIndex = 1;
comboBoxStart.SelectedIndex = MyFunction.IntHeaderMonth;
Setup.Load();
dataGridView1.Focus();
}
catch
{
MessageBox.Show("資料庫讀取錯誤!");
}
}
