Exemple #1
0
        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;
            //}
        }