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