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 FormTitleSetup_Load(object sender, EventArgs e) { AccTitleAdapter.Connection.ConnectionString = DB.SqlConnectString(MyFunction.HardwareCfg); AccTitleAdapter.Fill(m_DataSet.AccountingTitle); SetupBindingSource(); Setup.Load(); titleSetupBindingSource.DataSource = Setup; }
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("資料庫讀取錯誤!"); } }