private void LoadTree() { try { this.Cursor = Cursors.WaitCursor; tvSubject.ImageList = clsLxms.GetImageList(); DBGrid.DataSource = null; tvSubject.Nodes.Clear(); tvSubject.BackColor = frmOptions.BACKCOLOR; switch (cboSubjectType.SelectedIndex) { case 0: dalAccBankAccount dal0 = new dalAccBankAccount(); BindingCollection <modAccBankAccount> list0 = dal0.GetIList(out Util.emsg); if (list0 != null && list0.Count > 0) { foreach (modAccBankAccount mod in list0) { tvSubject.Nodes.Add(mod.AccountNo, mod.AccountNo + "(" + mod.BankName + ")", 0, 1); } } break; case 1: dalAccSubjectList dal1 = new dalAccSubjectList(); BindingCollection <modAccSubjectList> list1 = dal1.GetChildrenList(out Util.emsg); if (list1 != null && list1.Count > 0) { foreach (modAccSubjectList mod in list1) { tvSubject.Nodes.Add(mod.SubjectId, mod.SubjectName, 0, 1); } } break; } } catch (Exception ex) { MessageBox.Show(ex.Message, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); return; } finally { this.Cursor = Cursors.Default; } }
public void LoadData() { //try //{ // this.Cursor = Cursors.WaitCursor; dalAccPeriodList dalperiod = new dalAccPeriodList(); modAccPeriodList modYearStartPeriod = dalperiod.GetYearStartItem(cboAccName.ComboBox.SelectedValue.ToString(), out Util.emsg); //if(modYearStartPeriod == null) // modYearStartPeriod = dalperiod.GetFirstItem(out Util.emsg); dalAccSubjectList dalsubject = new dalAccSubjectList(); dalAccReport.staticSubjectList = dalsubject.GetAllList(true, out Util.emsg); dalAccReport.staticYearSubjectBalance = _dal.GetSubjectBalance(modYearStartPeriod.AccName, true, Util.IsTrialBalance, out Util.emsg); //上月结存 dalAccReport.staticEndSubjectBalance = _dal.GetSubjectBalance(cboAccName.ComboBox.SelectedValue.ToString(), false, Util.IsTrialBalance, out Util.emsg); List <modAccAssetDebtReport> list1 = new List <modAccAssetDebtReport>(); _dal.GetAccAssetDebtReport(cboAccName.ComboBox.SelectedValue.ToString(), "1", Util.IsTrialBalance, ref list1, out Util.emsg); DBGrid1.DataSource = list1; if (list1 == null && !string.IsNullOrEmpty(Util.emsg)) { MessageBox.Show(Util.emsg, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } else { DBGrid1.AlternatingRowsDefaultCellStyle.BackColor = Color.Empty; DBGrid1.Columns[0].Visible = false; DBGrid1.Columns[1].Visible = false; DBGrid1.Columns[3].Visible = false; DBGrid1.Columns[6].Visible = false; DBGrid1.Columns[7].Visible = false; DBGrid1.Columns[4].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; DBGrid1.Columns[5].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; DBGrid1.Columns[4].Width = 168; DBGrid1.Columns[5].Width = 168; Status1.Text = "资产总计: " + list1[0].EndMny.ToString(); } List <modAccAssetDebtReport> list2 = new List <modAccAssetDebtReport>(); _dal.GetAccAssetDebtReport(cboAccName.ComboBox.SelectedValue.ToString(), "5", Util.IsTrialBalance, ref list2, out Util.emsg); DBGrid2.DataSource = list2; if (list2 == null && !string.IsNullOrEmpty(Util.emsg)) { MessageBox.Show(Util.emsg, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } else { DBGrid2.AlternatingRowsDefaultCellStyle.BackColor = Color.Empty; DBGrid2.Columns[0].Visible = false; DBGrid2.Columns[1].Visible = false; DBGrid2.Columns[3].Visible = false; DBGrid2.Columns[6].Visible = false; DBGrid2.Columns[7].Visible = false; DBGrid2.Columns[4].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; DBGrid2.Columns[5].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; DBGrid2.Columns[4].Width = 168; DBGrid2.Columns[5].Width = 168; Status2.Text = "负债及权益总计: " + list2[0].EndMny.ToString(); } SetGridColor(); //} //catch (Exception ex) //{ // MessageBox.Show(ex.Message, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); // return; //} //finally //{ // this.Cursor = Cursors.Default; //} }