private void barButtonItem1_ItemClick(object sender, ItemClickEventArgs e) { if (grdViewReceipt.FocusedRowHandle < 0) { return; } Cursor.Current = Cursors.WaitCursor; int p_RecpId = Convert.ToInt32(grdViewReceipt.GetRowCellValue(grdViewReceipt.FocusedRowHandle, "ReceiptId")); int iCCId = Convert.ToInt32(grdViewReceipt.GetRowCellValue(grdViewReceipt.FocusedRowHandle, "CostCentreId")); string sFlatNo = grdViewReceipt.GetRowCellValue(grdViewReceipt.FocusedRowHandle, "FlatNo").ToString(); string sAns = ReceiptDetailBL.GetReceiptPrint(sFlatNo, iCCId, p_RecpId); ReportDocument cryRpt = new ReportDocument(); string strReportPath = Application.StartupPath + "\\CRMReceiptPrePrint.Rpt"; cryRpt.Load(strReportPath); string s = "{ReceiptRegister.ReceiptId}=" + p_RecpId + " "; string[] DataFiles = new string[] { BsfGlobal.g_sCRMDBName, BsfGlobal.g_sCRMDBName, BsfGlobal.g_sCRMDBName, BsfGlobal.g_sCRMDBName, BsfGlobal.g_sCRMDBName, BsfGlobal.g_sWorkFlowDBName, BsfGlobal.g_sWorkFlowDBName, BsfGlobal.g_sWorkFlowDBName, BsfGlobal.g_sCRMDBName, BsfGlobal.g_sWorkFlowDBName, BsfGlobal.g_sCRMDBName, BsfGlobal.g_sCRMDBName, BsfGlobal.g_sCRMDBName }; frmReport objReport = new frmReport(); objReport.ReportConvert(cryRpt, DataFiles); if (s.Length > 0) { cryRpt.RecordSelectionFormula = s; } objReport.rptViewer.ReportSource = null; objReport.rptViewer.SelectionFormula = s; objReport.rptViewer.ReportSource = cryRpt; cryRpt.DataDefinition.FormulaFields["Decimal"].Text = string.Format(CommFun.g_iCurrencyDigit.ToString()); cryRpt.DataDefinition.FormulaFields["Payment"].Text = "'" + string.Format(sAns.ToString()) + "'";// string.Format(sAns.ToString()); objReport.WindowState = FormWindowState.Maximized; objReport.rptViewer.Refresh(); objReport.Show(); Cursor.Current = Cursors.Default; }
private void btnOK_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { grdViewDemand.FocusedRowHandle = grdViewDemand.FocusedRowHandle + 1; if (grdViewDemand.RowCount == 0) { Close(); return; } if (grdViewDemand.FocusedRowHandle < 0) { Close(); return; } Cursor.Current = Cursors.WaitCursor; if (m_sType == "DL") { GetLeadId(); GetBillId(); if (m_sLeadId == "") { Close(); return; } ReportDocument cryRpt = new ReportDocument(); string strReportPath = ""; if (m_sReportName == "") { strReportPath = Application.StartupPath + "\\DemandLetter.Rpt"; } else { strReportPath = Application.StartupPath + "\\" + m_sReportName + ""; } cryRpt.Load(strReportPath); string[] DataFiles = new string[] { BsfGlobal.g_sCRMDBName, BsfGlobal.g_sCRMDBName, BsfGlobal.g_sCRMDBName, BsfGlobal.g_sCRMDBName, BsfGlobal.g_sCRMDBName, BsfGlobal.g_sCRMDBName, BsfGlobal.g_sWorkFlowDBName, BsfGlobal.g_sWorkFlowDBName, BsfGlobal.g_sWorkFlowDBName, BsfGlobal.g_sWorkFlowDBName, BsfGlobal.g_sCRMDBName, BsfGlobal.g_sCRMDBName, BsfGlobal.g_sRateAnalDBName, BsfGlobal.g_sCRMDBName, BsfGlobal.g_sRateAnalDBName }; frmReport objReport = new frmReport(); objReport.Text = "Report : " + strReportPath; objReport.ReportConvert(cryRpt, DataFiles); objReport.rptViewer.ReportSource = null; objReport.rptViewer.ReportSource = cryRpt; if (cryRpt.Database.Tables.Count > 1) { string s = "{ProgressBillRegister.LeadId} In [" + m_sLeadId.TrimEnd(',') + "] And {ProgressBillRegister.PBillId} In [" + m_sBillId.TrimEnd(',') + "]"; if (s.Length > 0) { cryRpt.RecordSelectionFormula = s; } objReport.rptViewer.SelectionFormula = s; } else { DataTable dt = new DataTable(); dt = ProgBillBL.GetDemandLetterFirstPrint(m_iCCId, m_sBillId, m_sLeadId); cryRpt.SetDataSource(dt); } if (cryRpt.Subreports.Count != 0) { string[] Sub_DataFiles = new string[] { BsfGlobal.g_sCRMDBName, BsfGlobal.g_sCRMDBName, BsfGlobal.g_sCRMDBName }; objReport.Sub_ReportConvert(cryRpt, DataFiles, 0); } objReport.WindowState = FormWindowState.Maximized; objReport.rptViewer.Refresh(); objReport.Show(); } else { if (grdViewDemand.RowCount == 0) { Close(); return; } ProgBillBL.InsertDLStatus(dtStatus, m_iAgeId); FillGridStatus(); } grdViewDemand.FocusedRowHandle = grdViewDemand.FocusedRowHandle - 1; Cursor.Current = Cursors.Default; }
private void barButtonItem5_ItemClick(object sender, ItemClickEventArgs e) { if (DGvTransView.FocusedRowHandle < 0) { return; } int p_FlatId = 0; DataTable dt = new DataTable(); int p_MaintanceId = 0; string s = ""; frmReport objReport; ReportDocument cryRpt; decimal dBillAmount = 0, dArrear = 0; DateTime dStartDate = DateTime.Today;; DateTime dEndDate = DateTime.Today;; string[] DataFiles; string sHeader = ""; int sMonth = 0; int sYear = 0; DateTime sFifetDate = DateTime.Today; p_FlatId = Convert.ToInt32(DGvTransView.GetRowCellValue(DGvTransView.FocusedRowHandle, "FlatId")); p_MaintanceId = Convert.ToInt32(DGvTransView.GetRowCellValue(DGvTransView.FocusedRowHandle, "MaintenanceId")); dt = MaintenanceBL.GetReport(p_FlatId, p_MaintanceId); if (dt.Rows.Count > 0) { dBillAmount = Convert.ToDecimal(CommFun.IsNullCheck(dt.Rows[0]["BillAmount"], CommFun.datatypes.vartypenumeric)); dArrear = Convert.ToDecimal(CommFun.IsNullCheck(dt.Rows[0]["Arrear"], CommFun.datatypes.vartypenumeric)); if (dArrear == 0) { dStartDate = Convert.ToDateTime(CommFun.IsNullCheck(DGvTransView.GetRowCellValue(DGvTransView.FocusedRowHandle, "StartDate"), CommFun.datatypes.VarTypeDate)); dEndDate = Convert.ToDateTime(CommFun.IsNullCheck(DGvTransView.GetRowCellValue(DGvTransView.FocusedRowHandle, "EndDate"), CommFun.datatypes.VarTypeDate)); sMonth = dStartDate.Month; sYear = dStartDate.Year; sFifetDate = Convert.ToDateTime("15" + "/" + sMonth + "/" + sYear); } else { dStartDate = Convert.ToDateTime(CommFun.IsNullCheck(dt.Rows[0]["FromDate"], CommFun.datatypes.VarTypeDate)); dEndDate = Convert.ToDateTime(CommFun.IsNullCheck(dt.Rows[0]["ToDate"], CommFun.datatypes.VarTypeDate)); sMonth = dEndDate.Month; sYear = dEndDate.Year; sFifetDate = Convert.ToDateTime("15" + "/" + sMonth + "/" + sYear); } //dEndDate = Convert.ToDateTime(CommFun.IsNullCheck(dt.Rows[0]["ToDate"], CommFun.datatypes.VarTypeDate)); } decimal dTotalPayAmt = Convert.ToDecimal(dBillAmount + dArrear); objReport = new frmReport(); string strReportPath = Application.StartupPath + "\\Maintenance.Rpt"; cryRpt = new ReportDocument(); cryRpt.Load(strReportPath); s = "{MaintenanceDet.FlatId}=" + p_FlatId + " "; DataFiles = new string[] { BsfGlobal.g_sCRMDBName, BsfGlobal.g_sCRMDBName, BsfGlobal.g_sCRMDBName, BsfGlobal.g_sCRMDBName, BsfGlobal.g_sWorkFlowDBName, BsfGlobal.g_sWorkFlowDBName, BsfGlobal.g_sWorkFlowDBName, BsfGlobal.g_sWorkFlowDBName, BsfGlobal.g_sCRMDBName }; objReport.ReportConvert(cryRpt, DataFiles); if (s.Length > 0) { cryRpt.RecordSelectionFormula = s; } objReport.rptViewer.ReportSource = null; objReport.rptViewer.SelectionFormula = s; objReport.rptViewer.ReportSource = cryRpt; cryRpt.DataDefinition.FormulaFields["Decimal"].Text = string.Format(CommFun.g_iCurrencyDigit.ToString()); cryRpt.DataDefinition.FormulaFields["MainAmt"].Text = "'" + string.Format(dBillAmount.ToString()) + "'"; cryRpt.DataDefinition.FormulaFields["Arrear"].Text = "'" + string.Format(dArrear.ToString()) + "'"; cryRpt.DataDefinition.FormulaFields["TotalPay"].Text = "'" + string.Format(dTotalPayAmt.ToString()) + "'"; if (dArrear == 0) { cryRpt.DataDefinition.FormulaFields["EndFiftenDate"].Text = String.Format("'{0}'", sHeader = sHeader = String.Format(" {0} ", sFifetDate.ToString("dd-MMM-yyyy"))); cryRpt.DataDefinition.FormulaFields["StartfiftenDate"].Text = String.Format("'{0}'", sHeader = sHeader = String.Format(" {0} ", sFifetDate.ToString("dd-MMM-yyyy"))); } else { cryRpt.DataDefinition.FormulaFields["EndFiftenDate"].Text = String.Format("'{0}'", sHeader = sHeader = String.Format(" {0} ", sFifetDate.ToString("dd-MMM-yyyy"))); cryRpt.DataDefinition.FormulaFields["StartfiftenDate"].Text = String.Format("'{0}'", sHeader = sHeader = String.Format(" {0} ", sFifetDate.ToString("dd-MMM-yyyy"))); } cryRpt.DataDefinition.FormulaFields["Period"].Text = String.Format("'{0}'", sHeader = sHeader = String.Format(" {0} to {1} ", dStartDate.ToString("dd-MMM-yyyy"), dEndDate.ToString("dd-MMM-yyyy"))); objReport.WindowState = FormWindowState.Maximized; objReport.rptViewer.Refresh(); objReport.Show(); }