private void DBGrid2_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { frmViewList frm; modAccAssetDebtReport mod = (modAccAssetDebtReport)DBGrid2.CurrentRow.DataBoundItem; switch (mod.SubjectId) { case "5145": //应付帐款 dalAccPayableList dalpay = new dalAccPayableList(); BindingCollection <modVendorPayableSummary> listpay = dalpay.GetVendorPayableSummary(cboAccName.ComboBox.SelectedValue.ToString(), out Util.emsg); if (listpay != null && listpay.Count > 0) { frm = new frmViewList(); frm.InitViewList(mod.SubjectName, listpay); frm.ShowDialog(); } break; case "5125": //应付票据 dalAccCheckList dalcheck = new dalAccCheckList(); BindingCollection <modAccCheckList> listcheck = dalcheck.GetIList("0", string.Empty, mod.SubjectId, string.Empty, string.Empty, string.Empty, out Util.emsg); frm = new frmViewList(); frm.InitViewList(mod.SubjectName, listcheck); frm.ShowDialog(); break; case "5155": //其它应付款 dalAccOtherPayable dalopay = new dalAccOtherPayable(); BindingCollection <modOtherPayableSummary> listopay = dalopay.GetOtherPayableSummary(cboAccName.ComboBox.SelectedValue.ToString(), out Util.emsg); if (listopay != null && listopay.Count > 0) { frm = new frmViewList(); frm.InitViewList(mod.SubjectName, listopay); frm.ShowDialog(); } break; default: dalAccReport dalrpt = new dalAccReport(); BindingCollection <modAccCredenceDetail> listrpt = new BindingCollection <modAccCredenceDetail>(); dalrpt.GetCredenceDetail(true, cboAccName.ComboBox.SelectedValue.ToString(), mod.SubjectId, Util.IsTrialBalance, ref listrpt, out Util.emsg); if (listrpt != null && listrpt.Count > 0) { frm = new frmViewList(); frm.InitViewList(mod.SubjectName, listrpt); frm.ShowDialog(); } else { if (!string.IsNullOrEmpty(Util.emsg)) { MessageBox.Show(Util.emsg, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); } } break; } }
private void DBGrid_DoubleClick(object sender, EventArgs e) { try { this.Cursor = Cursors.WaitCursor; if (DBGrid.CurrentRow == null) { return; } dalAccReport dal = new dalAccReport(); modAccExpenseReport mod = (modAccExpenseReport)DBGrid.CurrentRow.DataBoundItem; if (mod.SubjectId.IndexOf("9135") == 0) { BindingCollection <modAccCredenceDetail> list = new BindingCollection <modAccCredenceDetail>(); dal.GetCredenceDetail(true, cboAccName.ComboBox.SelectedValue.ToString(), mod.SubjectId, Util.IsTrialBalance, ref list, out Util.emsg); if (list != null && list.Count > 0) { frmViewList frm = new frmViewList(); frm.InitViewList(mod.SubjectName, list); frm.ShowDialog(); } else { if (!string.IsNullOrEmpty(Util.emsg)) { MessageBox.Show(Util.emsg, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show(clsTranslate.TranslateString("No data found!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); } } } } catch (Exception ex) { MessageBox.Show(ex.Message, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); return; } finally { this.Cursor = Cursors.Default; } }
private void DBGrid1_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { frmViewList frm; modAccAssetDebtReport mod = (modAccAssetDebtReport)DBGrid1.CurrentRow.DataBoundItem; switch (mod.SubjectId) { case "1055": //应收帐款 dalAccReceivableList dalrec = new dalAccReceivableList(); BindingCollection <modCustReceivableSummary> listrec = dalrec.GetCustReceivableSummary(cboAccName.ComboBox.SelectedValue.ToString(), out Util.emsg); if (listrec != null && listrec.Count > 0) { frm = new frmViewList(); frm.InitViewList(mod.SubjectName, listrec); frm.ShowDialog(); } break; case "1060": //其它应收款 dalAccOtherReceivable dalorec = new dalAccOtherReceivable(); BindingCollection <modOtherReceivableSummary> listorec = dalorec.GetOtherReceivableSummary(cboAccName.ComboBox.SelectedValue.ToString(), out Util.emsg); if (listorec != null && listorec.Count > 0) { frm = new frmViewList(); frm.InitViewList(mod.SubjectName, listorec); frm.ShowDialog(); } break; case "1075": //应收票据 dalAccCheckList dalcheck = new dalAccCheckList(); BindingCollection <modAccCheckList> listcheck = dalcheck.GetIList("0", string.Empty, mod.SubjectId, string.Empty, string.Empty, string.Empty, out Util.emsg); frm = new frmViewList(); frm.InitViewList(mod.SubjectName, listcheck); frm.ShowDialog(); break; case "1235": //库存商品 dalAccProductInout dalio = new dalAccProductInout(); BindingCollection <modAccProductSummary> listio = dalio.GetAccProductSummary(cboAccName.ComboBox.SelectedValue.ToString(), Util.IsTrialBalance, out Util.emsg); if (listio != null && listio.Count > 0) { frm = new frmViewList(); frm.InitViewList(mod.SubjectName, listio); frm.ShowDialog(); } break; default: dalAccReport dalrpt = new dalAccReport(); BindingCollection <modAccCredenceDetail> listrpt = new BindingCollection <modAccCredenceDetail>(); dalrpt.GetCredenceDetail(true, cboAccName.ComboBox.SelectedValue.ToString(), mod.SubjectId, Util.IsTrialBalance, ref listrpt, out Util.emsg); if (listrpt != null && listrpt.Count > 0) { frm = new frmViewList(); frm.InitViewList(mod.SubjectName, listrpt); frm.ShowDialog(); } else { if (!string.IsNullOrEmpty(Util.emsg)) { MessageBox.Show(Util.emsg, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); } } break; } }
private void tvSubject_AfterSelect(object sender, TreeViewEventArgs e) { try { this.Cursor = Cursors.WaitCursor; if (tvSubject.SelectedNode == null) { return; } //decimal startsum = 0; //decimal borrowsum = 0; //decimal lendsum = 0; //decimal endsum = 0; dalAccReport dal = new dalAccReport(); switch (cboSubjectType.SelectedIndex) { case 0: BindingCollection <modAccCredenceDetail> list0 = dal.GetCashAndBankDetail(cboAccName.SelectedValue.ToString(), tvSubject.SelectedNode.Name, Util.IsTrialBalance, out Util.emsg); DBGrid.DataSource = list0; if (list0 == null && !string.IsNullOrEmpty(Util.emsg)) { MessageBox.Show(Util.emsg, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); } else if (list0.Count > 0) { DBGrid.Columns["LastBalance"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; DBGrid.Columns["ThisBalance"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; DBGrid.Columns["LendMoney"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; DBGrid.Columns["BorrowMoney"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; Status1.Text = clsTranslate.TranslateString("Start Money") + " : " + string.Format("{0:C2}", list0[list0.Count - 1].LastBalance); Status2.Text = clsTranslate.TranslateString("Borrow Money") + " : " + string.Format("{0:C2}", list0[list0.Count - 1].BorrowMoney); Status3.Text = clsTranslate.TranslateString("Lend Money") + " : " + string.Format("{0:C2}", list0[list0.Count - 1].LendMoney); Status4.Text = clsTranslate.TranslateString("End Money") + " : " + string.Format("{0:C2}", list0[list0.Count - 1].ThisBalance); } break; case 1: BindingCollection <modAccCredenceDetail> list1 = new BindingCollection <modAccCredenceDetail>(); dal.GetCredenceDetail(true, cboAccName.SelectedValue.ToString(), tvSubject.SelectedNode.Name, Util.IsTrialBalance, ref list1, out Util.emsg); DBGrid.DataSource = list1; if (list1 == null && !string.IsNullOrEmpty(Util.emsg)) { MessageBox.Show(Util.emsg, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); } else if (list1.Count > 0) { DBGrid.Columns["LastBalance"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; DBGrid.Columns["ThisBalance"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; DBGrid.Columns["LendMoney"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; DBGrid.Columns["BorrowMoney"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; Status1.Text = clsTranslate.TranslateString("Start Money") + " : " + string.Format("{0:C2}", list1[list1.Count - 1].LastBalance); Status2.Text = clsTranslate.TranslateString("Borrow Money") + " : " + string.Format("{0:C2}", list1[list1.Count - 1].BorrowMoney); Status3.Text = clsTranslate.TranslateString("Lend Money") + " : " + string.Format("{0:C2}", list1[list1.Count - 1].LendMoney); Status4.Text = clsTranslate.TranslateString("End Money") + " : " + string.Format("{0:C2}", list1[list1.Count - 1].ThisBalance); } break; } } catch (Exception ex) { MessageBox.Show(ex.Message, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); return; } finally { this.Cursor = Cursors.Default; } }