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