private void MonthlyReportBakery_Load(object sender, EventArgs e)
{
decimal FeeRate = 1.8m;
try
{
var headerAdapter = new MyHeaderAdapter();
headerAdapter.Fill(m_DataSet.Header);
TitleSetup Setup = new TitleSetup();
Setup.Load();
FeeRate = Setup.FeeRate();
}
catch
{
MessageBox.Show("標頭資料讀取錯誤,你的資料庫版本可能不對");
}
int count = m_DataSet.Header.Count;
if (count == 0)
{
MessageBox.Show("無資料!");
m_CloseOnLoad = true; // OnLoad時無法呼叫Close(), 設置變數在OnShown呼叫
// Close
return;
}
var row = m_DataSet.Header[count - 1];
Revenue = new RevenueCalcBakery(row.DataDate, FeeRate / 100);
comboBoxMonth.SelectedIndex = row.DataDate.Month - 1;
labelFeeRate.Text = FeeRate.ToString() + "%";
}
private void LoadLedgerData()
{
if (DataPrepared)
{
return;
}
try
{
var headerSQLAdapter = new DamaiDataSetTableAdapters.HeaderTableAdapter();
headerSQLAdapter.Fill(damaiDataSet.Header);
}
catch { MessageBox.Show("標頭資料讀取錯誤,你的資料庫版本可能不對"); }
int count = damaiDataSet.Header.Count;
if (count == 0)
{
MessageBox.Show("無資料!");
Close();
return;
}
var row = damaiDataSet.Header[count - 1];
m_Revenue = new RevenueCalcBakery(row.DataDate, 0);
AccList.NewAll();
var expenseSQLAdapter = new DamaiDataSetTableAdapters.ExpenseTableAdapter();
var voucherSQLAdapter = new DamaiDataSetTableAdapters.VoucherTableAdapter();
var voucherDetailSQLAdapter = new DamaiDataSetTableAdapters.VoucherDetailTableAdapter();
var bankDetailSQLAdapter = new DamaiDataSetTableAdapters.BankDetailTableAdapter();
var accVoucherSQLAdapter = new DamaiDataSetTableAdapters.AccVoucherTableAdapter();
var ingredientSQLAdapter = new DamaiDataSetTableAdapters.IngredientTableAdapter();
var bankAccountSQLAdapter = new DamaiDataSetTableAdapters.BankAccountTableAdapter();
var vendorSQLAdapter = new DamaiDataSetTableAdapters.VendorTableAdapter();
ingredientSQLAdapter.Connection.ConnectionString = DB.SqlConnectString(MyFunction.HardwareCfg);
vendorSQLAdapter.Connection.ConnectionString = DB.SqlConnectString(MyFunction.HardwareCfg);
DamaiDataSet.AccountingTitleDataTable accTitleTable = damaiDataSet.AccountingTitle;
try
{
bankAccountSQLAdapter.Fill(damaiDataSet.BankAccount);
vendorSQLAdapter.Fill(damaiDataSet.Vendor);
expenseSQLAdapter.Fill(damaiDataSet.Expense); // expense檔案小,先全部讀進記憶體
voucherSQLAdapter.Fill(damaiDataSet.Voucher);
voucherDetailSQLAdapter.Fill(damaiDataSet.VoucherDetail);
bankDetailSQLAdapter.Fill(damaiDataSet.BankDetail);
accVoucherSQLAdapter.Fill(damaiDataSet.AccVoucher);
ingredientSQLAdapter.Fill(damaiDataSet.Ingredient);
foreach (var r in accTitleTable)
{
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);
Setup.Load();
m_Generator = new LedgerTableGenerator(labelMessage, Setup, damaiDataSet, new CalcRevenueDelegate(CalcRevenue));
}
catch (Exception ex)
{
MessageBox.Show("資料庫讀取錯誤! 原因:" + ex.Message);
return;
}
DataPrepared = true;
}
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("資料庫讀取錯誤!");
}
}
private void FormLedger_Load(object sender, EventArgs e)
{
accountingTitleBindingSource.DataSource = m_DataSet;
m_OrderSet = m_DataSet;
try
{
headerAdapter.Fill(m_DataSet.Header);
}
catch { MessageBox.Show("標頭資料讀取錯誤,你的資料庫版本可能不對"); }
int count = m_DataSet.Header.Count;
if (count == 0)
{
MessageBox.Show("無資料!");
Close();
return;
}
var row = m_DataSet.Header[count - 1];
m_Revenue = new RevenueCalcBakery(row.DataDate, 0);
AccList.NewAll();
var accTitleAdapter = new DamaiDataSetTableAdapters.AccountingTitleTableAdapter();
var bankAccountAdapter = new DamaiDataSetTableAdapters.BankAccountTableAdapter();
var expenseAdapter = new DamaiDataSetTableAdapters.ExpenseTableAdapter();
var voucherAdapter = new DamaiDataSetTableAdapters.VoucherTableAdapter();
var voucherDetailAdapter = new DamaiDataSetTableAdapters.VoucherDetailTableAdapter();
var bankDetailAdapter = new DamaiDataSetTableAdapters.BankDetailTableAdapter();
var accVoucherAdapter = new DamaiDataSetTableAdapters.AccVoucherTableAdapter();
var vendorAdapter = new DamaiDataSetTableAdapters.VendorTableAdapter();
var ingredientAdapter = new DamaiDataSetTableAdapters.IngredientTableAdapter();
try
{
ingredientAdapter.Connection.ConnectionString = DB.SqlConnectString(MyFunction.HardwareCfg);
accTitleAdapter.Connection.ConnectionString = DB.SqlConnectString(MyFunction.HardwareCfg);
vendorAdapter.Connection.ConnectionString = DB.SqlConnectString(MyFunction.HardwareCfg);
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);
vendorAdapter.Fill(m_DataSet.Vendor);
ingredientAdapter.Fill(m_DataSet.Ingredient);
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);
Setup.Load();
m_Generator = new LedgerTableGenerator(labelMessage, Setup, m_DataSet, new CalcRevenueDelegate(CalcRevenue));
cLedgerTableDataGridView.Focus();
}
catch (Exception ex)
{
MessageBox.Show("資料庫讀取錯誤! 原因:" + ex.Message);
}
// 設置comboBoxAccTitle的初值為 <零用金>
if (m_DataSet.BankAccount.Rows.Count > 1)
{
var bank = m_DataSet.BankAccount[0];
if (bank.IsAccountTitleCodeNull())
{
comboBoxAccTitle.SelectedIndex = 0;
}
else
{
comboBoxAccTitle.SelectedValue = bank.AccountTitleCode;
}
}
DontRefresh = false; // Form剛Load不Refresh DataGridView
}
