//private void MakeBankAccountComboBox() //{ // BankAccountAdapter.Fill(this.m_DataSet.BankAccount); // List<CBankAccountForComboBox> list = new List<CBankAccountForComboBox>(); // CBankAccountForComboBox acc = new CBankAccountForComboBox(); // list.Add(acc); // foreach (var r in m_DataSet.BankAccount) // { // if (r.ID != 1) // ID 1是給零用金的特殊帳號 // { // acc = new CBankAccountForComboBox(); // acc.Name = r.ShowName; // acc.ID = r.ID; // list.Add(acc); // } // } // cbBankAccount.DataSource = list; //} private void FormImportBankExcel_Load(object sender, EventArgs e) { string[] names = null; if (openFileDialog1.ShowDialog() != DialogResult.OK) { m_CloseForm = true; return; } m_FileName = openFileDialog1.FileName; try { excel = new ExcelLib(); names = excel.SheetNames(m_FileName); if (names == null || names.Length < 1) { MessageBox.Show("找不到<" + m_FileName + ">!"); m_CloseForm = true; return; } cbSheetNames.Items.Clear(); foreach (string name in names) { cbSheetNames.Items.Add(name); } } catch { MessageBox.Show("轉換Excel表過程出錯! 是否沒有安裝Excel或 Microsoft.Office.Interop.Excel.dll不存在!"); m_CloseForm = true; } var bankAccountAdapter = new VoucherExpense.DamaiDataSetTableAdapters.BankAccountTableAdapter(); // MakeBankAccountComboBox(); bankAccountAdapter.Fill(this.m_DataSet.BankAccount); List <CBankAccountForComboBox> list = new List <CBankAccountForComboBox>(); CBankAccountForComboBox acc = new CBankAccountForComboBox(); list.Add(acc); foreach (var r in m_DataSet.BankAccount) { if (r.ID != 1) // ID 1是給零用金的特殊帳號 { acc = new CBankAccountForComboBox(); acc.Name = r.ShowName; acc.ID = r.ID; list.Add(acc); } } cbBankAccount.DataSource = list; }
private void MakeBankAccountComboBox() { List <CBankAccountForComboBox> list = new List <CBankAccountForComboBox>(); CBankAccountForComboBox acc = new CBankAccountForComboBox(); acc.Name = "全部"; list.Add(acc); foreach (var r in m_DataSet.BankAccount) { if (r.ID != 1) // ID 1是給零用金的特殊帳號 { acc = new CBankAccountForComboBox(); acc.Name = r.ShowName; acc.ID = r.ID; list.Add(acc); } } cbSelectBank.DataSource = list; }
private void btnConvert_Click(object sender, EventArgs e) { if (cbBankAccount.SelectedIndex < 1) { MessageBox.Show("請先選擇轉入的戶頭!"); return; } if (m_ImportDataList == null) { MessageBox.Show("請選擇有資料的xls表!"); return; } BankDetailAdapter.Fill(m_DataSet.BankDetail); CBankAccountForComboBox acc = new CBankAccountForComboBox(); try { acc = (CBankAccountForComboBox)cbBankAccount.SelectedItem; } catch { MessageBox.Show("銀行帳號資料庫有誤! 無法設定BankID!"); return; } int maxId = 1; foreach (var r in m_DataSet.BankDetail) { if (r.ID > maxId) { maxId = r.ID; } } int count = 0; var table = new MyBankDetailTable(); int maxNoteLen = table.NoteColumn.MaxLength; foreach (CBankDetail d in m_ImportDataList) { count++; foreach (var r in m_DataSet.BankDetail) { if (r.BankID != acc.ID) { continue; } if (r.Day != d.Date) { continue; } if (MessageBox.Show("日期" + d.Date.ToShortDateString() + "己有資料! 按OK繼續, 按取消中斷操作", "<" + count.ToString() + "> " + r.Day.ToString("MM/dd") + " " + r.Money.ToString(), MessageBoxButtons.OKCancel) != DialogResult.OK) { MessageBox.Show("所有資料都沒有轉入! "); return; } break; } var row = table.NewBankDetailRow(); maxId++; row.ID = maxId; row.BankID = acc.ID; row.Day = d.Date; if (d.Debt > 0) { row.IsCredit = true; // 定義反了 row.Money = d.Debt; } else { row.IsCredit = false; row.Money = d.Credit; } string s = d.Note; if (s != null) { if (s.Length <= maxNoteLen) { row.Note = s; } else { row.Note = s.Substring(0, maxNoteLen); } } row.TitleCode = "";/// table.Rows.Add(row); } if (table == null || table.Count == 0) { MessageBox.Show("沒有新資料加入,不需要存!"); return; } BankDetailAdapter.Update(table); btnConvert.Enabled = false; MessageBox.Show("成功轉入<" + acc.Name + "> 共" + count.ToString() + "筆資料!"); }