public void OnRunningSalesAndBuyInvoicesReport(Entity reportEntity, Stimulsoft.Report.StiReport report, Dictionary <string, object> parameters) { var reportDataTable = new DataTable("ReportTable"); var invoiceType = parameters["InvoiceType"] as string; EntityList salesAndBuysList = new EntityList(); //var accountReviewType = parameters["AccountReviewType"]; reportDataTable.Columns.Add("IssueDate"); reportDataTable.Columns.Add("DocType_PersianText"); reportDataTable.Columns.Add("InvoiceNumber"); reportDataTable.Columns.Add("TotalStuffAndServicesPrice", typeof(decimal)); reportDataTable.Columns.Add("GeneralDiscount", typeof(decimal)); reportDataTable.Columns.Add("StuffAndServicesTotalAmountAfterDiscount", typeof(decimal)); reportDataTable.Columns.Add("TotalTaxAndToll", typeof(decimal)); reportDataTable.Columns.Add("FinalAmount", typeof(decimal)); for (int i = 0; i < ps.SalesAndBuyInvoices.Entities.Count; i++) { Entity saleAndBuyEntity = ps.SalesAndBuyInvoices.Entities[i]; var docType = saleAndBuyEntity.GetFieldValue <string>("DocType"); if (docType == invoiceType) { salesAndBuysList.Entities.Add(saleAndBuyEntity); } } foreach (var entity in salesAndBuysList.Entities) { var row = reportDataTable.NewRow(); row["IssueDate"] = entity.GetFieldValue <string>("IssueDate"); row["DocType_PersianText"] = entity.GetFieldValue <string>("DocType_PersianText"); row["InvoiceNumber"] = entity.GetFieldValue <string>("InvoiceNumber"); row["TotalStuffAndServicesPrice"] = entity.GetFieldValue <decimal>("TotalStuffAndServicesPrice"); row["GeneralDiscount"] = entity.GetFieldValue <decimal>("GeneralDiscount"); row["StuffAndServicesTotalAmountAfterDiscount"] = entity.GetFieldValue <decimal>("StuffAndServicesTotalAmountAfterDiscount"); row["TotalTaxAndToll"] = entity.GetFieldValue <decimal>("TotalTaxAndToll"); row["FinalAmount"] = entity.GetFieldValue <decimal>("FinalAmount"); reportDataTable.Rows.Add(row); } report.Dictionary.DataSources.Clear(); report.RegData("DataSource1", reportDataTable); report.Dictionary.Synchronize(); StiDataBand dataBand1 = (StiDataBand)report.GetComponentByName("DataBand1"); dataBand1.DataSourceName = "ReportTable"; //report.DataSources.Clear(); //var list = (StiDataBand)report.GetComponentByName("DataBand1"); }
public void OnRunningSalesInvoice1Report(Entity reportEntity, Stimulsoft.Report.StiReport report, Dictionary <string, object> parameters) { var dbHelper = CoreComponent.Instance.MainDbHelper; var logoImage = report.GetComponentByName("LogoImage") as Stimulsoft.Report.Components.StiImage; var invoiceID = Guid.Parse(parameters["InvoiceID"] as string); var invoice = dbHelper.FetchSingleByID("ps.BuyInvoice", invoiceID, null); }
public void OnRunningConnectedAccountsrReport(Entity reportEntity, Stimulsoft.Report.StiReport report, Dictionary <string, object> parameters) { DataTable connectedAccountstDataTable = new DataTable("ReportTable"); var core = CoreComponent.Instance; var connectedAccounts = core.TryGetUserSessionKeyValue("acc", "ConnectedAccounts"); EntityList connectedAccountsEntityList = (EntityList)connectedAccounts; //var accountReviewType = parameters["AccountReviewType"]; connectedAccountstDataTable.Columns.Add("CodeAndName"); connectedAccountstDataTable.Columns.Add("AccountName"); connectedAccountstDataTable.Columns.Add("DebtorAmount", typeof(decimal)); connectedAccountstDataTable.Columns.Add("CreditorAmount", typeof(decimal)); //connectedAccountstDataTable.Columns.Add("RemainingDebtorAmount", typeof(decimal)); //connectedAccountstDataTable.Columns.Add("RemainingCreditorAmount", typeof(decimal)); foreach (var entity in connectedAccountsEntityList.Entities) { var row = connectedAccountstDataTable.NewRow(); row["CodeAndName"] = entity.GetFieldValue <string>("CodeAndName"); row["AccountName"] = entity.GetFieldValue <string>("AccountName"); //row["DebtorAmount"] = entity.GetFieldValue<string>("AccountCode"); //row["CreditorAmount"] = entity.GetFieldValue<string>("FarsiAccountReviewType"); row["DebtorAmount"] = entity.GetFieldValue <decimal>("DebtorAmount"); row["CreditorAmount"] = entity.GetFieldValue <decimal>("CreditorAmount"); //row["RemainingDebtorAmount"] = entity.GetFieldValue<decimal>("RemainingDebtorAmount"); //row["RemainingCreditorAmount"] = entity.GetFieldValue<decimal>("RemainingCreditorAmount"); connectedAccountstDataTable.Rows.Add(row); } report.Dictionary.DataSources.Clear(); report.RegData("ReportTable", connectedAccountstDataTable); report.Dictionary.Synchronize(); StiDataBand dataBand1 = (StiDataBand)report.GetComponentByName("DataBand1"); dataBand1.DataSourceName = "ReportTable"; }
public void OnRunningAccountReviewShenavarReport(Entity reportEntity, Stimulsoft.Report.StiReport report, Dictionary <string, object> parameters) { var dbHelper = CoreComponent.Instance.MainDbHelper; EntityList accountReview = new EntityList(); var test = report.DataSources; var query = string.Format(""); DataTable shenavarReportDataTable = new DataTable("ReportTable"); var reportParameterAccountReview = new Guid?(); if (parameters["AccountReview"] != null) { reportParameterAccountReview = Guid.Parse(parameters["AccountReview"].ToString()); } var shenavarType = parameters["ShenavarType"]; shenavarReportDataTable.Columns.Add("ShenavarName"); shenavarReportDataTable.Columns.Add("DebtorAmount_Shenavar"); shenavarReportDataTable.Columns.Add("CreditorAmount_Shenavar"); shenavarReportDataTable.Columns.Add("AccountCode"); shenavarReportDataTable.Columns.Add("FarsiAccountReviewType_Shenavar"); shenavarReportDataTable.Columns.Add("RemainingDebtorAmount_Shenavar", typeof(decimal)); shenavarReportDataTable.Columns.Add("RemainingCreditorAmount_Shenavar", typeof(decimal)); shenavarReportDataTable.Columns.Add("FarsiShenavarType"); shenavarReportDataTable.Columns.Add("AccountReviewName_Shenavar"); for (int i = 0; i < acc.AccountReview1.Entities.Count; i++) { Entity accountReviewEntity = acc.AccountReview1.Entities[i]; var accountReview_Shenavar = accountReviewEntity.GetFieldValue <Guid?>("AccountReview_Shenavar"); if (reportParameterAccountReview != null) { if (shenavarType as string == "Person") { if (accountReview_Shenavar == reportParameterAccountReview) { if (accountReviewEntity.GetFieldValue <string>("ShenavarType") == "Person") { accountReview.Entities.Add(accountReviewEntity); } } } else if (shenavarType as string == "CostCenter") { if (accountReview_Shenavar == reportParameterAccountReview) { if (accountReviewEntity.GetFieldValue <string>("ShenavarType") == "CostCenter") { accountReview.Entities.Add(accountReviewEntity); } } } else if (shenavarType as string == "Project") { if (accountReview_Shenavar == reportParameterAccountReview) { if (accountReviewEntity.GetFieldValue <string>("ShenavarType") == "Project") { accountReview.Entities.Add(accountReviewEntity); } } } } } foreach (var entity in accountReview.Entities) { var row = shenavarReportDataTable.NewRow(); row["ShenavarName"] = entity.GetFieldValue <string>("ShenavarName"); row["RemainingDebtorAmount_Shenavar"] = entity.GetFieldValue <decimal>("RemainingDebtorAmount_Shenavar"); row["RemainingCreditorAmount_Shenavar"] = entity.GetFieldValue <decimal>("RemainingCreditorAmount_Shenavar"); row["FarsiAccountReviewType_Shenavar"] = entity.GetFieldValue <string>("FarsiAccountReviewType_Shenavar"); row["FarsiShenavarType"] = entity.GetFieldValue <string>("FarsiShenavarType"); row["AccountReviewName_Shenavar"] = entity.GetFieldValue <string>("AccountReviewName_Shenavar"); shenavarReportDataTable.Rows.Add(row); } report.Dictionary.DataSources.Clear(); report.RegData("DataSource", shenavarReportDataTable); report.Dictionary.Synchronize(); StiDataBand dataBand1 = (StiDataBand)report.GetComponentByName("DataBand1"); dataBand1.DataSourceName = "ReportTable"; }