private void mnuRebuild_Click(object sender, EventArgs e) { try { this.Cursor = Cursors.WaitCursor; if (DBGrid.CurrentRow == null) { return; } dalAccPeriodList dal = new dalAccPeriodList(); if (dal.RebuildStartData(cboAccName.ComboBox.SelectedValue.ToString(), DBGrid.CurrentRow.Cells[1].Value.ToString(), out Util.emsg)) { LoadData(); } else { MessageBox.Show(Util.emsg, 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 toolExport_Click(object sender, EventArgs e) { try { this.Cursor = Cursors.WaitCursor; if (DBGrid1.CurrentRow == null) { return; } IList <modExcelRangeData> list = new List <modExcelRangeData>(); dalAccPeriodList dalp = new dalAccPeriodList(); modAccPeriodList modp = dalp.GetItem(cboAccName.ComboBox.SelectedValue.ToString(), out Util.emsg); list.Add(new modExcelRangeData(modp.EndDate.ToString("yyyy年MM月dd日"), "D3", "F3")); for (int i = 0; i < DBGrid1.RowCount; i++) { modAccAssetDebtReport modd = (modAccAssetDebtReport)DBGrid1.Rows[i].DataBoundItem; list.Add(new modExcelRangeData(modd.SubjectName, "A" + (6 + i).ToString().Trim(), "A" + (6 + i).ToString().Trim())); list.Add(new modExcelRangeData((i + 1).ToString(), "B" + (6 + i).ToString().Trim(), "B" + (6 + i).ToString().Trim())); list.Add(new modExcelRangeData(string.Format("{0:C2}", modd.YearStartMny), "C" + (6 + i).ToString().Trim(), "C" + (6 + i).ToString().Trim())); list.Add(new modExcelRangeData(string.Format("{0:C2}", modd.EndMny), "D" + (6 + i).ToString().Trim(), "D" + (6 + i).ToString().Trim())); } int rowindex = -1; for (int i = 0; i < DBGrid2.RowCount; i++) { modAccAssetDebtReport modd = (modAccAssetDebtReport)DBGrid2.Rows[i].DataBoundItem; if (modd.SubjectId.IndexOf("9135") < 0 || modd.SubjectId.Length != 8) { rowindex++; list.Add(new modExcelRangeData(modd.SubjectName, "F" + (6 + rowindex).ToString().Trim(), "F" + (6 + rowindex).ToString().Trim())); list.Add(new modExcelRangeData((rowindex + 1).ToString(), "G" + (6 + rowindex).ToString().Trim(), "G" + (6 + rowindex).ToString().Trim())); list.Add(new modExcelRangeData(string.Format("{0:C2}", modd.YearStartMny), "H" + (6 + rowindex).ToString().Trim(), "H" + (6 + rowindex).ToString().Trim())); list.Add(new modExcelRangeData(string.Format("{0:C2}", modd.EndMny), "I" + (6 + rowindex).ToString().Trim(), "I" + (6 + rowindex).ToString().Trim())); } } clsExport.ExportByTemplate(list, "资产负债表", 1, Util.Max(DBGrid1.RowCount, rowindex) + 2, 9, 1); } 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; //} }