void InitList() { NewList = new AccTitleList(); NewList.CopyTableFrom(AccList1); NewList.SetDefaultTitle(Setup.DefaultAsset, Setup.DefualtLiability, Setup.DefaultIncome, Setup.DefaultCost, Setup.DefaultExpense, Setup.DefaultOwnersEquity); foreach (KeyValuePair <int, BankDefault> pair in BankDictionary) { BankDefault bank = pair.Value; bank.DefaultTitle = AccTitleList.Find(bank.DefaultCode, NewList.Assets, NewList.defaultAsset); } }
AccTitleList InitList(AccTitleList sourceList) { AccTitleList List4Calc = new AccTitleList(); List4Calc.CopyTableFrom(sourceList); List4Calc.defaultCost = AccTitleList.Find(Setup.DefaultCost, List4Calc.Costs, null); List4Calc.defaultExpense = AccTitleList.Find(Setup.DefaultExpense, List4Calc.Expenses, null); List4Calc.defaultIncome = AccTitleList.Find(Setup.DefaultIncome, List4Calc.Revenues, null); List4Calc.defaultAsset = AccTitleList.Find(Setup.DefaultAsset, List4Calc.Assets, null); List4Calc.defaultLiability = AccTitleList.Find(Setup.DefualtLiability, List4Calc.Liabilitys, null); BankDictionary = new Dictionary <int, BankDefault>(); foreach (var r in m_DataSet.BankAccount) { BankDictionary.Add(r.ID, new BankDefault(r.AccountTitleCode, r.DefaultTitleCode)); } foreach (KeyValuePair <int, BankDefault> pair in BankDictionary) { BankDefault bank = pair.Value; bank.DefaultTitle = AccTitleList.Find(bank.DefaultCode, List4Calc.Assets, List4Calc.defaultAsset); } return(List4Calc); }
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 }