protected override StiReport MakeReport(System.Data.DataSet ds) { StiReport report = new StiReport(); report.Load(Resources.Rep_ResidentVacations); report.Compile(); report.RegData((System.Data.DataSet) ds); return report; }
protected override StiReport MakeReport(System.Data.DataSet ds) { StiReport report = new StiReport(); report.Load(Resources.PaymentReportByJn); report.Compile(); report.RegData((System.Data.DataSet) ds); return report; }
protected override StiReport MakeReport(System.Data.DataSet ds) { StiReport report = new StiReport(); report.Load(Resources.Rep_HouseCounters); report.Compile(); report.RegData((System.Data.DataSet) ds); return report; }
protected override StiReport MakeReport(System.Data.DataSet ds) { StiReport report = new StiReport(); report.Load(Resources.ReceiptTerminalReportByParameters); report.Compile(); report.RegData((System.Data.DataSet) ds); return report; }
protected override StiReport MakeReport(System.Data.DataSet ds) { StiReport report = new StiReport(); report.Load(Resources.CounterIndicationStatistics); report.Compile(); report.RegData("ReportData", (System.Data.DataSet) ds); report["period"] = (base.DateBeg.Date == base.DateEnd.Date) ? ("за " + base.DateBeg.Date.ToString("dd.MM.yyyy")) : ("с " + base.DateBeg.Date.ToString("dd.MM.yyyy") + " по " + base.DateEnd.Date.ToString("dd.MM.yyyy")); return report; }
protected override StiReport MakeReport(System.Data.DataSet ds) { StiReport report = new StiReport(); report.Load(Resources.Rep_AccountServicesPaymentByGroupOper); report.EngineVersion = StiEngineVersion.EngineV2; report.ReportCacheMode = StiReportCacheMode.Off; report.Compile(); report.RegData((System.Data.DataSet) ds); return report; }
public static void ShowInspectionActPystografMinReport(System.Windows.Forms.IWin32Window owner, long inspectionId) { System.Data.DataSet ujfApartmentHouseInspectionActPystografMinReport = Mappers.SimpleReportMapper.GetUjfApartmentHouseInspectionActPystografMinReport(inspectionId); ujfApartmentHouseInspectionActPystografMinReport.Tables.get_Item(0).set_TableName("InspectionInfo"); StiReport report = new StiReport(); report.Load(Resources.UjfApartmentHouseInspectionAct_PystografMin); report.Compile(); report.RegData((System.Data.DataSet) ujfApartmentHouseInspectionActPystografMinReport); report.Show((System.Windows.Forms.IWin32Window) owner); }
protected override StiReport MakeReport(System.Data.DataSet ds) { StiReport report = new StiReport(); report.Load(this.rbTypeBySimple.get_Checked() ? Resources.Rep_AccountServicesSaldoSimpleReport : (this.rbTypeByOper.get_Checked() ? Resources.Rep_AccountServicesSaldoByOper : Resources.Rep_AccountServicesSaldo)); report.EngineVersion = StiEngineVersion.EngineV2; report.ReportCacheMode = StiReportCacheMode.Off; report.Compile(); report.RegData((System.Data.DataSet) ds); return report; }
public static void ShowCoordinationVolumesDefectsReport(System.Windows.Forms.IWin32Window owner, long inspectionId) { System.Data.DataSet ujfCoordinationVolumesDefectsReport = Mappers.SimpleReportMapper.GetUjfCoordinationVolumesDefectsReport(inspectionId); ujfCoordinationVolumesDefectsReport.Tables.get_Item(0).set_TableName("CoordinationDefects"); StiReport report = new StiReport(); report.Load(Resources.UJFListCoordinationVolumesDefects); report.Compile(); report.RegData((System.Data.DataSet) ujfCoordinationVolumesDefectsReport); report.Show((System.Windows.Forms.IWin32Window) owner); }
protected override StiReport MakeReport(System.Data.DataSet ds) { StiReport report = new StiReport(); report.Load(Resources.Rep_AccountServicesPersonJnBenefitsNoDebtsReport); report.EngineVersion = StiEngineVersion.EngineV2; report.ReportCacheMode = StiReportCacheMode.Off; report.Compile(); report.RegData((System.Data.DataSet) ds); return report; }
protected override StiReport MakeReport(System.Data.DataSet ds) { System.Data.DataTable table = ds.Tables.get_Item(0); StiReport report = new StiReport(); report.Load(Resources.Rep_ObjLogOper); report.Compile(); report.RegData("obj_log_oper", (System.Data.DataTable) table); report["period"] = (base.DateBeg.Date == base.DateEnd.Date) ? ("за " + base.DateBeg.Date.ToString("dd.MM.yyyy")) : ("с " + base.DateBeg.Date.ToString("dd.MM.yyyy") + " по " + base.DateEnd.Date.ToString("dd.MM.yyyy")); return report; }
protected override StiReport MakeReport(System.Data.DataSet ds) { StiReport report = new StiReport(); AccountReportType byName = AccountReportType.GetByName("Уведомление для Грозного, без долга"); report.LoadFromString(byName.Template); report.EngineVersion = StiEngineVersion.EngineV2; report.ReportCacheMode = StiReportCacheMode.Off; report.Compile(); report.RegData((System.Data.DataSet) ds); return report; }
public static void ShowDefectsDelayWorkReport(System.Windows.Forms.IWin32Window owner, long inspectionId) { System.Data.DataSet ujfApartmentHouseDefectsDelayWorkReport = Mappers.SimpleReportMapper.GetUjfApartmentHouseDefectsDelayWorkReport(inspectionId); ujfApartmentHouseDefectsDelayWorkReport.Tables.get_Item(0).set_TableName("DefectsInfo"); ujfApartmentHouseDefectsDelayWorkReport.Tables.get_Item(1).set_TableName("HouseInfo"); StiReport report = new StiReport(); report.Load(Resources.UjfApartmentHouseInspectionDefectsDelayWorksByInspection); report.Compile(); report.RegData((System.Data.DataSet) ujfApartmentHouseDefectsDelayWorkReport); report.Show((System.Windows.Forms.IWin32Window) owner); }
protected override StiReport MakeReport(System.Data.DataSet ds) { System.Data.DataTable table = ds.Tables.get_Item(0); System.Data.DataTable table2 = ds.Tables.get_Item(1); StiReport rep = new StiReport(); this.LoadReport(rep); rep.Compile(); rep.RegData("Header", (System.Data.DataTable) table); rep.RegData("Data", (System.Data.DataTable) table2); return rep; }
public static void ShowDialog(System.Windows.Forms.IWin32Window owner, System.DateTime date, ObjectList<LocalAddress> addresses) { System.Data.DataSet accountServiceByAddressesReport = GroupOperation.GetAccountServiceByAddressesReport(date, addresses); accountServiceByAddressesReport.Tables.get_Item(0).set_TableName("dataAccountServices"); accountServiceByAddressesReport.Tables.get_Item(1).set_TableName("date"); StiReport report = new StiReport(); report.Load(Resources.Rep_AccountServicesByAddresses); report.Compile(); report.RegData((System.Data.DataSet) accountServiceByAddressesReport); report.Show((System.Windows.Forms.IWin32Window) owner); }
protected override StiReport MakeReport(System.Data.DataSet ds) { StiReport report = new StiReport(); report.Load(Resources.Rep_AccountServicesByAddresses); if (!base.IsOrientationSet) { report.Pages[0].Orientation = base.Orientation; } report.Compile(); report.RegData((System.Data.DataSet) ds); return report; }
protected override StiReport MakeReport(System.Data.DataSet ds) { StiReport report = new StiReport(); report.Load(Resources.Rep_FaktLivingTempRegistration); if (!base.IsOrientationSet) { report.Pages[0].Orientation = base.Orientation; } report.Compile(); report.RegData((System.Data.DataSet) ds); return report; }
public static void ShowExpiredAndCurrentDefectsReport(System.Windows.Forms.IWin32Window owner, long inspectionId, System.DateTime period) { System.Data.DataSet ujfListExpiredAndCurrentDefectsReport = Mappers.SimpleReportMapper.GetUjfListExpiredAndCurrentDefectsReport(inspectionId, period); ujfListExpiredAndCurrentDefectsReport.Tables.get_Item(0).set_TableName("CurentDefects"); ujfListExpiredAndCurrentDefectsReport.Tables.get_Item(1).set_TableName("ExpiredDefects"); ujfListExpiredAndCurrentDefectsReport.Tables.get_Item(2).set_TableName("Period"); StiReport report = new StiReport(); report.Load(Resources.ListExpiredAndCurrentDefects); report.Compile(); report.RegData((System.Data.DataSet) ujfListExpiredAndCurrentDefectsReport); report.Show((System.Windows.Forms.IWin32Window) owner); }
private StiReport GetReport() { var report = new StiReport(); report.Load(GetReportPath()); ChangeConnectString(report); report.Compile(); SetReportParamaters(report); return report; }
public static void ShowDialog(System.Windows.Forms.IWin32Window owner, PayRequest request) { System.Data.DataTable dataTableByRequestIdFormSpScheme; System.Data.DataTable dataTableById; System.Data.DataTable dataTableByRequestId = PayRequestBenefit.GetDataTableByRequestId(request); if ((dataTableByRequestId == null) || (dataTableByRequestId.Rows.get_Count() == 0)) { System.Data.DataRow row = dataTableByRequestId.Rows.Add((object[]) new object[0]); row.set_Item("benefitName", "Льготы отсутствуют"); row.set_Item("PersonsCount", 0); } if (request.Id > 0L) { dataTableByRequestIdFormSpScheme = PayRequestService.GetDataTableByRequestId(request); } else { dataTableByRequestIdFormSpScheme = PayRequestService.GetDataTableByRequestIdFormSpScheme(request); } StiReport report = new StiReport(); string valueByName = Setting.GetValueByName("Глобальные установки", "Шаблон квитанции"); string info = ""; if (valueByName == "ReceiptReportSakhalin") { report.Load(Resources.ReceiptReportSakhalin); long accountId = 0L; if (long.TryParse(request.AccountId, ref accountId) && (accountId > 0L)) { info = Organization.FindHouseHolderByAccountId(accountId).Info; } } else { bool flag = (bool) ((Setting.GetValueByName("Параметры квитанций", "Печатать в кассе колонку ЕДК") ?? "").ToUpper() == "ДА"); report.Load(flag ? Resources.ReceiptReportWithEDK : Resources.ReceiptReport); info = (Organization.CentralOffice == Organization.Null) ? ((string) "Отсутсвует ОРГАНИЗАЦИЯ в глобальных установках") : Organization.CentralOffice.Info; } report.Compile(); report.Dictionary.Variables.Add("orgInfo", info); report.Dictionary.Variables.Add("diffEDKMonth", ("Да" == (Setting.GetValueByName("Параметры расчетов", "Использовать ЕДК за предыдущий период") ?? string.Empty)) ? -1 : 0); if (request.Id > 0L) { dataTableById = PayRequest.GetDataTableById(request); } else { dataTableById = PayRequest.GetDataTableByIdFormSpScheme(request); } report.RegData("dataRequests", (System.Data.DataTable) dataTableById); report.RegData("dataRequestBenefits", (System.Data.DataTable) dataTableByRequestId); report.RegData("dataRequestServices", (System.Data.DataTable) dataTableByRequestIdFormSpScheme); report.Show((System.Windows.Forms.IWin32Window) owner); }
/// <summary> /// /// </summary> /// <returns></returns> public virtual ActionResult StiReport() { using (var db = new Models.DBContext()) { var obj = db.Provinces.Select(z => new {ProvinceName = z.Name, Citys= z.Citys}).ToList(); var mainReport = new StiReport(); mainReport.Load(Server.MapPath("~/Files/Report.mrt")); mainReport.Compile(); mainReport["DateTimeNow"] = DateTime.UtcNow; mainReport.RegBusinessObject("ProvincesWithCitys", obj); return Stimulsoft.Report.Mvc.StiMvcViewer.GetReportSnapshotResult(HttpContext, mainReport); } }
public ActionResult GetContractTemplatePdf(Guid id) { var report = new StiReport(); var path = System.Web.HttpContext.Current.Server.MapPath("~/Reports/Mrts/EMP/EMP_ContractReport.mrt"); report.Load(path); report.Compile(); report.RegBusinessObject("vm", _service.GetContractTemplatePdf(id)); report.Render(false); Stream stream = new MemoryStream(); report.ExportDocument(StiExportFormat.Pdf, stream); stream.Position = 0; return(new FileStreamResult(stream, "application/pdf")); }
public static void ShowDialog(System.Windows.Forms.IWin32Window owner, ObjectList<PayRequest> requests, string caption, bool byCashier) { StiReport report = new StiReport { AutoLocalizeReportOnRun = true }; report.Load(byCashier ? Resources.ReceiptTerminalReportByCashier : Resources.ReceiptTerminalReport); report.Compile(); System.Data.DataTable table = Mappers.PayRequestMapper.ObjectListToDateTable(requests); report.RegData("dataRequests", (System.Data.DataTable) table); System.Data.DataTable table2 = new System.Data.DataTable("captionTable"); table2.Columns.Add("caption"); table2.Rows.Add((object[]) new object[] { caption }); report.RegData(table2.get_TableName(), (System.Data.DataTable) table2); report.Show((System.Windows.Forms.IWin32Window) owner); }
protected void okRadButton_Click(object sender, EventArgs e) { var report = new StiReport(); string path = Server.MapPath("RequestByOrganizationReport.mrt"); report.Load(path); report.Compile(); //var fromDate = Convertor.ToGregorianDate(fromDateRadMaskedTextBox.Text); //var toDate = Convertor.ToGregorianDate(toDateRadMaskedTextBox.Text); var fromDate = fromDateRadMaskedTextBox.Text.ConvertToDateTime(); var toDate = toDateRadMaskedTextBox.Text.ConvertToDateTime(); long value1 = 0; if (firstOrganChartRadComboBox.Items.Count > 0) { long.TryParse(firstOrganChartRadComboBox.SelectedValue, out value1); } long value2 = 0; if (secoundOrganChartRadComboBox.Items.Count > 0) { long.TryParse(secoundOrganChartRadComboBox.SelectedValue, out value2); } long value3 = 0; if (thirdOrganChartRadComboBox.Items.Count > 0) { long.TryParse(thirdOrganChartRadComboBox.SelectedValue, out value3); } var requestBusinessActions = new RequestBusinessActions(); List <RequestInsertUserAction> requestCollection = requestBusinessActions.ReportByOrganization(fromDate, toDate, value1, value2, value3); if (requestCollection != null) { requestCollection = requestCollection.OrderBy(p => p.OrganizationTitle).ToList(); } report.RegBusinessObject("RequestOrganization", "RequestOrganization", requestCollection); var persianDate = ReportTextHelper.GetPersianDate(); report["TodayDate"] = persianDate; report.Dictionary.Synchronize(); requestTypeStiWebViewer.Report = report; }
/// <summary> /// با فشردن این کلید محل آزمون ها نمایش داده می شود /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="EventArgs"/> instance containing the event data.</param> protected void btnExamPlaceList_Click(object sender, EventArgs e) { this.StiWebViewer1.ResetReport(); string tterm = ddl_Term.SelectedValue.ToString(); int iddanesh = int.Parse(ddl_Danesh.SelectedValue.ToString()); string Examdate = "0"; string ExamTime = "0"; int examinerID = int.Parse(Session[sessionNames.userID_Karbar].ToString()); if (ddl_ExamDate.SelectedIndex > 0) { Examdate = ddl_ExamDate.SelectedValue; } if (ddl_ExamTime.SelectedIndex > 0) { ExamTime = ddl_ExamTime.SelectedValue; } DataTable dt = new DataTable(); dt = ExamBusiness.Get_ListClassCityByDate(iddanesh, tterm, Examdate, ExamTime, examinerID); if (dt.Rows.Count > 0) { StiWebViewer1.Visible = true; StiReport rpt = new StiReport(); rpt.Load(Server.MapPath("../Reports/ExamClassList1.mrt")); rpt.Dictionary.Databases.Clear(); rpt.Dictionary.Databases.Add(new StiSqlDatabase("Supplementary", CB.ReportConnection.ToString())); rpt.Compile(); rpt.CompiledReport.DataSources["[Exam].[Sp_GetListClassCityByDate]"].Parameters["@iddanesh"].ParameterValue = int.Parse(ddl_Danesh.SelectedValue.ToString()); rpt.CompiledReport.DataSources["[Exam].[Sp_GetListClassCityByDate]"].Parameters["@tterm"].ParameterValue = tterm; rpt.CompiledReport.DataSources["[Exam].[Sp_GetListClassCityByDate]"].Parameters["@dateexam"].ParameterValue = Examdate; rpt.CompiledReport.DataSources["[Exam].[Sp_GetListClassCityByDate]"].Parameters["@saatexam"].ParameterValue = ExamTime; rpt.CompiledReport.DataSources["[Exam].[Sp_GetListClassCityByDate]"].Parameters["@examinerID"].ParameterValue = examinerID; rpt.RegData(dt); rpt.ReportCacheMode = StiReportCacheMode.On; StiWebViewer1.Report = rpt; StiWebViewer1.Visible = true; CB.InsertIntoUserLog(int.Parse(Session[sessionNames.userID_Karbar].ToString()), DateTime.Now.ToShortTimeString(), int.Parse(Session[sessionNames.appID_Karbar].ToString()), 52, "مشاهده گزارش لیست محل برگزاری"); } else { StiWebViewer1.Visible = false; rwmValidations.RadAlert("رکوردی موجود نیست", null, 100, "پیام", ""); } }
public FileStreamResult ExportTransferZbk([DataSourceRequest] DataSourceRequest request) { StiReport report = new StiReport(); report.Load(Server.MapPath("../Reports/Mrts/OBK/ZBKTransferList.mrt")); report.Compile(); var data = repository.ZBKTransferRegister().ToDataSourceResult(request); report.RegBusinessObject("ZBKList", data.Data); report.Render(false); var stream = new MemoryStream(); report.ExportDocument(StiExportFormat.Excel, stream); stream.Position = 0; return(File(stream, "application/excel", "Список Передачи ЗБК.xls")); }
private void btnPrint_Click(object sender, EventArgs e) { try { StiReport report = new StiReport(); //sakhte Shey report.Load("Report/rptMosafer.mrt"); //masir file MRT report report.Compile(); //ersal Variable ha b Stimulsoft report["strNameAgency"] = NameAgency; report.ShowWithRibbonGUI(); } catch (Exception) { MessageBox.Show("در هنگام گزارش گیری خطایی رخ داده است لطفا مجددا تلاش کنید", "Blit", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
protected void Page_Load(object sender, EventArgs e) { StiReport report = new StiReport(); report.Load(Server.MapPath(@"Reports\Invoice.mrt")); report.Compile(); DataSet data = new DataSet(); data.ReadXml(Server.MapPath(@"Data\Demo.xml")); report.RegData(data); StiWebViewer1.Localization = string.Format("Localization/{0}.xml", (string)Session["lang"]); StiWebViewer1.Report = report; }
public ActionResult ExportSummaryReportTF(DateTime?dateFrom, DateTime?dateTo) { StiReport report = new StiReport(); report.Load(Server.MapPath("../Reports/Mrts/OBK/SummaryReportTF.mrt")); report.Compile(); var data = repository.OBK_SummaryReportTF(dateFrom, dateTo); report.RegBusinessObject("List", data); report.Render(false); var stream = new MemoryStream(); report.ExportDocument(StiExportFormat.Excel, stream); stream.Position = 0; return(File(stream, "application/excel", "Отчет.xls")); }
public FileStreamResult ExportFile([DataSourceRequest] DataSourceRequest request) { StiReport report = new StiReport(); report.Load(Server.MapPath("../Reports/Mrts/OBK/ZBKBlanks.mrt")); report.Compile(); var data = repository.List().ToDataSourceResult(request); report.RegBusinessObject("List", data.Data); report.Render(false); var stream = new MemoryStream(); report.ExportDocument(StiExportFormat.Excel, stream); stream.Position = 0; return(File(stream, "application/excel", "Отчет по бланкам.xls")); }
public ActionResult SubTaskProtokol(int psId) { var report = new StiReport(); var path = System.Web.HttpContext.Current.Server.MapPath("~/Reports/Mrts/OBK/TaskProtocol.mrt"); report.Load(path); report.Compile(); report.RegBusinessObject("tmp", repo.GetTaskProtocolData(psId)); report.RegBusinessObject("tmpExecutors", repo.GetTaskProtocolExecutorListData(psId)); report.Render(false); Stream stream = new MemoryStream(); report.ExportDocument(StiExportFormat.Word2007, stream); stream.Position = 0; return(File(stream, "application/msword", $"Протокол.docx")); }
private void PrintButton_Click(object sender, RoutedEventArgs e) { Report = new StiReport(); UserGrid.Visibility = Visibility.Collapsed; PrintGrid.Visibility = Visibility.Visible; Report.Load(@"ProductsReport.mrt"); Report.Compile(); Report["OrganizationName"] = PublicVariables.Organization.Name; Report["OrganizationAddress"] = PublicVariables.Organization.Address; Report["OrganizationPhoneNumber"] = PublicVariables.Organization.PhoneNumber; Report["DateTime"] = DateTime.Now.ToShortTimeString(); Report.Render(); ProductsReportPrint.Report = Report; }
private void BtnPrint_Click(object sender, EventArgs e) { StiReport Report = new StiReport(); Report.Load("Report/rptGavahi.mrt"); Report.Compile(); Report["strTarikh1"] = mskTarikh1.Text; Report["NameBemar"] = txtName.Text; Report["Bemari"] = txtBemari.Text; Report["Tedad"] = txtTedad.Text; Report["Makan"] = txtMakan.Text; Report["NameMatab"] = lblName.Text; Report["Tel"] = lblTel.Text; Report.ShowWithRibbonGUI(); }
void backgroundWorker1_DoWork(object sender, DoWorkEventArgs e) { DataSet data = new DataSet(); data.ReadXml("..\\..\\Data\\Demo.xml"); report.RegData(data); using (var stream = Assembly.GetExecutingAssembly().GetManifestResourceStream("SampleProgress.Master-Detail-Subdetail.mrt")) { report.Load(stream); } report.Compile(); report.CompiledReport.Rendering += new EventHandler(CompiledReport_Rendering); report.Render(false); }
private void btnPrint_Click(object sender, EventArgs e) { StiReport report = new StiReport(); report.Load("Report/rptReportALL.mrt"); report.Compile(); report["NameAgency"] = NameAgency; report["TelA"] = TelA; report["AddressA"] = AddressA; report["TCity"] = lblCity.Text; report["THavapeyma"] = lblHavapeyma.Text; report["TParvaz"] = lblParvaz.Text; report["TBlit"] = lblTedadBlit.Text; report["TGroup"] = lblTedadGroupha.Text; report["Mojodi"] = lblMojodi.Text; report.ShowWithRibbonGUI(); }
protected void btn_AccessCards_Click(object sender, EventArgs e) { //img_ExportToExcel1.Visible = false; //img_ExportToExcel2.Visible = false; if (ddl_Term.SelectedValue == null || ddl_Term.SelectedValue == "0") { RadWindowManager1.RadAlert("لطفا ترم را انتخاب بفرمایید", 0, 100, "پیام", ""); } else { if (ddl_Cooperation.SelectedIndex == null) { ddl_Cooperation.SelectedValue = "0"; } if (ddl_EducationGroup.SelectedValue == null) { ddl_EducationGroup.SelectedValue = "0"; } dt = FRB.GetAccessCardsProf(ddl_Term.SelectedValue, int.Parse(ddl_EducationGroup.SelectedValue), int.Parse(ddl_Cooperation.SelectedValue)); if (dt.Rows.Count == 0) { RadWindowManager1.RadAlert("رکوردی وجود ندارد", 0, 100, "پیام", ""); } else { //img_ExportToExcel1.Visible = true; this.StiWebViewer1.ResetReport(); StiWebViewer1.Visible = true; StiReport rpt = new StiReport(); rpt.Load(Server.MapPath("../Report/ReportAccessCardsProf.mrt")); rpt.ReportCacheMode = StiReportCacheMode.On; rpt.Dictionary.Databases.Clear(); rpt.Dictionary.Databases.Add(new StiSqlDatabase("Connection1", CB.ReportConnection.ToString())); rpt.Compile(); rpt.CompiledReport.DataSources["[Faculty].[SP_AccessCardsProf]"].Parameters["@Departman"].ParameterValue = int.Parse(ddl_EducationGroup.SelectedValue); rpt.CompiledReport.DataSources["[Faculty].[SP_AccessCardsProf]"].Parameters["@Term"].ParameterValue = ddl_Term.SelectedValue; rpt.CompiledReport.DataSources["[Faculty].[SP_AccessCardsProf]"].Parameters["@Cooperation"].ParameterValue = int.Parse(ddl_Cooperation.SelectedValue); rpt.RegData(dt); rpt.Dictionary.Synchronize(); //rpt.Show(); StiWebViewer1.Report = rpt; StiWebViewer1.Visible = true; //rpt.Print(true); } } }
public ActionResult ExportOBKLaboratoryReport([DataSourceRequest] DataSourceRequest request, Guid?unitLaboratoryId) { StiReport report = new StiReport(); report.Load(Server.MapPath("../Reports/Mrts/OBK/OBKLaboratoryReport.mrt")); report.Compile(); var data = repository.OBK_LaboratoryFunction(unitLaboratoryId); var result = data.ToDataSourceResult(request); report.RegBusinessObject("List", result.Data); report.Render(false); var stream = new MemoryStream(); report.ExportDocument(StiExportFormat.Excel, stream); stream.Position = 0; return(File(stream, "application/excel", "Отчет.xls")); }
private void loadReport() { StiReport report = new StiReport(); report.Load("Reports\\SoMri.mrt"); StiSqlDatabase sqlDB = new StiSqlDatabase(); sqlDB = (StiSqlDatabase)report.Dictionary.Databases["Oracle"]; sqlDB.ConnectionString = FormHISSMS.conn_string; report.Compile(); report["schemamonth"] = datauser(dateEditTuNgay.Text, dateEditDenNgay.Text); report["tungay"] = dateEditTuNgay.Text; report["denngay"] = dateEditDenNgay.Text; report.Render(false); stiViewerControl.Report = report; }
private void BtnPrint_Click(object sender, EventArgs e) { MessageBox.Show(con.ConnectionString); StiReport Report = new StiReport(); //Report.Dictionary.Databases.Clear(); //Report.Dictionary.Databases.Add( // new Stimulsoft.Report.Dictionary.StiOleDbDatabase("NameInReport", con.ConnectionString)); Report.Load("Report/rptBemeh.mrt"); Report.Compile(); Report.ShowWithRibbonGUI(); //cmd = new SqlCommand("ReportBemeh",con); //cmd.CommandType = CommandType.StoredProcedure; //con.Open(); //SqlDataReader reader = cmd.ExecuteReader(); //List<string> Id = new List<string>(); //List<string> NameBemeh = new List<string>(); //List<string> Mablagh = new List<string>(); //List<string> Tozih = new List<string>(); //while (reader.Read()) //{ // Id.Add(reader["Id"].ToString()); // NameBemeh.Add(reader["NameBemeh"].ToString()); // Mablagh.Add(reader["Mablagh"].ToString()); // Tozih.Add(reader["Tozih"].ToString()); //} //List<string> output = new List<string>(); //for (int i = 0; i <= Id.Count; i++) //{ // output.Add(Id[i] + ";" + NameBemeh[i] + ";" + Mablagh[i] + ";" + Tozih[i]); //} //string data = string.Empty; //foreach (var item in output) //{ // data += item + "\n"; //} //MessageBox.Show(data); //con.Close(); }
public ActionResult Print(int id) { using (var db = new KiaGalleryContext()) { var entity = db.PostItem.Single(x => x.Id == id); var sender = db.Settings.SingleOrDefault(x => x.Key == Model.Context.Settings.KeyPostSenderAddress)?.Value; StiReport report = new StiReport(); report.Load(Server.MapPath("~/Report/Post/Report.mrt")); report.Dictionary.Databases.Clear(); report.ScriptLanguage = StiReportLanguageType.CSharp; report.Dictionary.Variables["Count"].Value = entity.Count.ToString(); report.Dictionary.Variables["Weight"].Value = entity.Weight.ToString(); report.Dictionary.Variables["Price"].Value = Core.ToSeparator(entity.Price); report.Dictionary.Variables["Customer"].Value = entity.Customer; report.Dictionary.Variables["Address"].Value = entity.City.Name + " - " + entity.Address; report.Dictionary.Variables["PhoneNumber"].Value = entity.PhoneNumber; report.Dictionary.Variables["MobileNumber"].Value = entity.MobileNumber; report.Dictionary.Variables["PostalCode"].Value = entity.PostalCode; report.Dictionary.Variables["Sender"].Value = sender; //report.Dictionary.Synchronize(); report.Compile(); report.Render(false); MemoryStream stream = new MemoryStream(); StiPdfExportSettings settings = new StiPdfExportSettings(); StiPdfExportService service = new StiPdfExportService(); service.ExportPdf(report, stream, settings); this.Response.Buffer = true; this.Response.ClearContent(); this.Response.ClearHeaders(); this.Response.ContentType = "application/pdf"; this.Response.AddHeader("Content-Disposition", "attachment; filename=\"Kia-Post-" + entity.Id + ".pdf\""); this.Response.ContentEncoding = Encoding.UTF8; this.Response.AddHeader("Content-Length", stream.Length.ToString()); this.Response.BinaryWrite(stream.ToArray()); this.Response.End(); return(new FileStreamResult(stream, "application/pdf")); } }
private void BtnPrint_Click(object sender, EventArgs e) { StiReport Report = new StiReport(); Report.Load("Report/rptAmalkard.mrt"); Report.Compile(); Report["strTarikh1"] = mskTarikh1.Text; Report["strTarikh2"] = mskTarikh2.Text; Report["Tedad"] = lblTedad.Text; Report["Bemeh"] = lblBemeh.Text; Report["Khadamat"] = lblKhadamat.Text; Report["MablaghKol"] = lblMablagh.Text; Report["NameMatab"] = lblName.Text; Report["Tel"] = lblTel.Text; Report.ShowWithRibbonGUI(); }
private void ButtonShow_Click(object sender, RoutedEventArgs e) { var report = new StiReport(); report.Load(@"Reports\Variables.mrt"); // Required to prepare the in compilation mode report.Compile(); // Set Variables report["Name"] = TextBoxName.Text; report["Surname"] = TextBoxSurname.Text; report["Email"] = TextBoxEmail.Text; report["Address"] = TextBoxAddress.Text; report["Sex"] = RadioButtonMale.IsChecked.GetValueOrDefault(); report.ShowWithWpf(); }
private void button1_Click(object sender, EventArgs e) { var report = new StiReport(); report.Load(@"Reports\Variables.mrt"); // Required to prepare the in compilation mode report.Compile(); // Set Variables report["Name"] = textBoxName.Text; report["Surname"] = textBoxSurname.Text; report["Email"] = textBoxEmail.Text; report["Address"] = textBoxAddress.Text; report["Sex"] = radioButtonMale.Checked; report.Show(); }
public static void ClientesXmonedero() { try { report = new StiReport(); report.Load(FClientesXmonedero); report.Compile(); report["creador"] = Ambiente.LoggedUser.UsuarioId; report.RegBusinessObject("clientes", clienteController.SelectAllOrderByMonedero()); report.Show(); } catch (Exception e) { Ambiente.Mensaje(e.Message); } }
protected void Page_Load(object sender, EventArgs e) { if (this.Session.SessionID == Request.QueryString["key"]) { string cmd = null; DataTable dt = new DataTable(); string year = Request.QueryString["year"].ToString(), cat = Request.QueryString["cat"].ToString(), ngaylapbc = Request.QueryString["date"].ToString(); switch (cat) { case "0": cmd = "getRpt0"; break; case "1": cmd = "getRpt1"; break; case "2": cmd = "getRpt2"; break; case "3": cmd = "getRpt3"; break; default: break; } dt = getReportData(year, ngaylapbc, cmd); StiReport report = new StiReport(); report.Load(Server.MapPath("Report" + cat + ".mrt")); report.Compile(); report.RegData(dt); report["namkt"] = year; report["ngaylapbc"] = ngaylapbc; //report.Dictionary.Synchronize(); //StiWebViewerSL1.Report = report; StiWebViewer1.Report = report; } }
/// <summary> /// 导出-打印(根据所选中的行ID获取DATATABLE,用于报表输出) /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void TmPrint_Click(object sender, EventArgs e) { var filename = string.Empty; try { if (gvdtl.Rows.Count == 0) { throw new Exception("没有内容,不能选择."); } if (gvdtl.SelectedRows.Count == 0) { throw new Exception("请至少选择一行"); } task.TaskId = 4; task.FunctionId = "4"; task.Id = Convert.ToInt32(gvdtl.Rows[gvdtl.CurrentCell.RowIndex].Cells[0].Value); //获取所选行的ID主键值 task.FunctionName = Convert.ToString(gvdtl.Rows[gvdtl.CurrentCell.RowIndex].Cells[1].Value); //单据类型:AdornOrder MaterialOrder Start(); var resultdt = task.ResultTable; if (resultdt.Rows.Count == 0) { throw new Exception("导出异常,请联系管理员"); } //调用STI模板并执行导出代码 //加载STI模板 MaterialOrderReport filename = Convert.ToString(gvdtl.Rows[gvdtl.CurrentCell.RowIndex].Cells[1].Value) == "AdornOrder" ? "AdornOrderReport" : "MaterialOrderReport"; var filepath = Application.StartupPath + $"/Report/{filename}.mrt"; var stireport = new StiReport(); stireport.Load(filepath); //加载DATASET 或 DATATABLE stireport.RegData("Order", resultdt); stireport.Compile(); stireport.Show(); //调用预览功能 //stireport.Design(true); //调用设计功能 } catch (Exception ex) { MessageBox.Show(ex.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void button1_Click(object sender, EventArgs e) { try { string filepath = Application.StartupPath + "\\LabelMultiSku.mrt"; StiReport report = new StiReport(); report.Load(filepath); report.Compile(); report["HU"] = "999"; PrinterSettings printerSettings = new PrinterSettings(); report.Print(false, printerSettings); } catch (Exception ex) { LogHelper.WriteLine(ex.Message + "\r\n" + ex.StackTrace); } }
private void BtnPrint_Click(object sender, RoutedEventArgs e) { StiReport report = new StiReport(); IQueryable <AccountingTafsillevelsDetail> t = ak.AccountingTafsillevelsDetails; var iqTafsil = t; if (txt_search.Text.Trim().Length > 0) { iqTafsil = iqTafsil.Where(r => r.ATLName.Contains(txt_search.Text)); } report.Load(@"D:\New folder (2)\accountingKernel\AccountingKernel\Debug_AccountingKernel\Report\modiriate_hesabe_tafsili.mrt"); report.RegData("testt", iqTafsil); report.Compile(); report.Show(); }
protected void Page_Load(object sender, EventArgs e) { try { UserValidate(); ReportObject(ANP.Data.BaseData.Library.Encryption.Decrypt(Request.QueryString["pra"].ToString())); string ConnectionString = _host.ConnectionString; Stimulsoft.Report.StiReport _report = new StiReport(); _report.Load(Resources.mrtFinancialParcelOfFirstState); _report.Dictionary.Databases.Clear(); _report.Dictionary.Databases.Add(new Stimulsoft.Report.Dictionary.StiSqlDatabase("PofficeCOD186", ConnectionString)); _report.Compile(); _report["FirstState"] = (ddlState == string.Empty ? 0 : Convert.ToInt32(ddlState)); _report["FirstCity"] = (ddlCity == string.Empty ? 0 : Convert.ToInt32(ddlCity)); _report["FirstPostNode"] = (ddlPostNode == string.Empty ? 0 : Convert.ToInt32(ddlPostNode)); _report["LastState"] = (ddlLastState == string.Empty ? 0 : Convert.ToInt32(ddlLastState)); _report["LastCity"] = (ddlLastCity == string.Empty ? 0 : Convert.ToInt32(ddlLastCity)); _report["LastPostNode"] = (ddlLastPostNode == string.Empty ? 0 : Convert.ToInt32(ddlLastPostNode)); _report["FirstDate"] = Fdate; _report["LastDate"] = Ldate; _report["PayType"] = (ddlCredit == string.Empty ? 0 : Convert.ToInt32(ddlCredit)); _report["BarcodeStatus"] = (ddlBarcodeStatus == string.Empty ? 0 : Convert.ToInt32(ddlBarcodeStatus)); _report["BarcodeSubStatus"] = (ddlBarcodeSubStatus == string.Empty ? 0 : Convert.ToInt32(ddlBarcodeSubStatus)); _report["UserName"] = _LoginDetails.Pname + " " + _LoginDetails.RolePname + " از " + _LoginDetails.StateName; _report["ReportDate"] = DateAndTime.GetSQLDate10DigitShamsi() + " -- " + DateAndTime.GetSQLTime8Digit(); StiWebViewer1.Report = _report; } catch (Exception ex) { string Query = string.Format(@"EXECUTE sp_FilltblErrorProgrammer @Message=N'{0}' ,@DateError='{1}' ,@PhysicalPath=N'{2}' ,@UserHostAddress='{3}' ,@Browser='{4}'" , "Error For Load Report : rptFinancialParcelOfFirstState ; Detail : " + ex.Message.Replace("'", "''") , DateAndTime.GetDateTime16Digit_Latin(), "", "", ""); _host.SqlExecute(Query); } }
public static void PrintTest() { try { string filepath = Application.StartupPath + "\\LabelMultiSku.mrt"; StiReport report = new StiReport(); report.Load(filepath); report.Compile(); report["HU"] = "999"; PrinterSettings printerSettings = new PrinterSettings(); report.Print(false, printerSettings); } catch (Exception ex) { LogHelper.WriteLine(ex.Message + "\r\n" + ex.StackTrace); } }
public static void CalcHouseCounterServicesReportForPublicSpaceShowDialog(System.Windows.Forms.IWin32Window owner, long calcId, System.DateTime period, string number, string serviceName, long serviceId) { System.Data.DataSet set = Mappers.SimpleReportMapper.GetCalcHouseCounterServicesReportForPublicSpace(calcId, period, serviceId); set.Tables.get_Item(0).set_TableName("dataCalcHouseCounterServices"); set.Tables.get_Item(1).set_TableName("dataCalcHouseCounterAccountServiceCounters"); set.Tables.get_Item(2).set_TableName("dataCalcHouseCounterAccountServiceNormativs"); set.Tables.get_Item(3).set_TableName("dataCalcHouseCounterAccountServiceNonResidentials"); set.Tables.get_Item(4).set_TableName("dataCalcHouseCounterSubCounters"); StiReport report = new StiReport(); report.Load(Resources.CalcHouseCounterServicesReport); report.Compile(); report.RegData((System.Data.DataSet) set); if (serviceName != null) { report.Dictionary.Variables.Add("ServiceName", serviceName); report["ServiceName"] = serviceName; } report.Show((System.Windows.Forms.IWin32Window) owner); }
protected override StiReport MakeReport(System.Data.DataSet ds) { System.DateTime dateBeg = base.DateBeg; System.DateTime time6 = new System.DateTime(base.DateEnd.get_Year(), base.DateEnd.get_Month(), base.DateEnd.get_Day()); System.DateTime time2 = time6.AddDays((double) 1.0).AddMilliseconds((double) -1.0); StiReport report = new StiReport { AutoLocalizeReportOnRun = true }; report.Load(this.m_OnlyByProvider ? Resources.ReceiptTerminalReportOnlyByProvider : Resources.ReceiptTerminalReportByProvider); report.Compile(); report["DateBegin"] = dateBeg; report["DateEnd"] = time2; report.RegData("dataRequests", (System.Data.DataTable) this.m_DtRequests); System.Data.DataTable table = new System.Data.DataTable("captionTable"); table.Columns.Add("caption"); table.Rows.Add((object[]) new object[] { this.m_Caption }); report.RegData(table.get_TableName(), (System.Data.DataTable) table); return report; }
private void btnPrint_Click(object sender, EventArgs e) { try { StiReport report = new StiReport(); report.Load("Report/rptBlit.mrt"); report.Compile(); report["Code"] = Convert.ToInt32(txtCode.Text); report["strNameAgency"] = NameAgency; report["strAddressA"] = AddressA; report["strTelA"] = TelA; report.ShowWithRibbonGUI(); } catch (Exception) { MessageBox.Show("در هنگام گزارش گیری خطایی رخ داده است لطفا مجددا تلاش کنید", "Blit", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void گزارشکلینامههاToolStripMenuItem_Click(object sender, EventArgs e) { if (designReports.CheckState == CheckState.Checked) { StiReport report = new StiReport(); report.Load("Report/ReportAll.mrt"); ((StiSqlDatabase)report.Dictionary.Databases["MS SQL"]).ConnectionString = ApplicationSetting.ConnectionString(); report.Compile(); report.Design(); } else { StiReport report = new StiReport(); report.Load("Report/ReportAll.mrt"); ((StiSqlDatabase)report.Dictionary.Databases["MS SQL"]).ConnectionString = ApplicationSetting.ConnectionString(); report.Compile(); report.ShowWithRibbonGUI(); } }
public static void CalcHouseCounterServicesReportFor354(System.Windows.Forms.IWin32Window owner, long calcId, System.DateTime period, long serviceId) { ObjectList<RepReportTemplate> list = RepReportTemplate.FindByName("09.01.01 Детализация по коллективным приборам учета"); if (list.get_Count() > 0) { RepReportTemplate template = list.get_Item(0); System.Data.SqlClient.SqlParameter[] parameters = new System.Data.SqlClient.SqlParameter[3]; parameters[0] = new System.Data.SqlClient.SqlParameter("@calcId", System.Data.SqlDbType.BigInt); parameters[0].set_Value((long) calcId); parameters[1] = new System.Data.SqlClient.SqlParameter("@period", System.Data.SqlDbType.DateTime); parameters[1].set_Value(period); parameters[2] = new System.Data.SqlClient.SqlParameter("@serviceId", System.Data.SqlDbType.BigInt); if (serviceId > 0L) { parameters[2].set_Value((long) serviceId); } else { parameters[2].set_Value(System.DBNull.Value); } System.Data.DataSet set = DALSql.ExecuteDataSet("exec " + template.Sql + " @calcId, @period, @serviceId", parameters); StiReport report = new StiReport(); report.LoadFromString(template.Template); report.Compile(); report.RegData((System.Data.DataSet) set); if (User.IsMemberOf(RightsEnum.ОтчетыРедактированиеШаблона)) { report.Design(true, (System.Windows.Forms.IWin32Window) owner); if (System.Windows.Forms.DialogResult.Yes == Messages.QuestionYesNo(owner, "Сохранить изменения в шаблоне?")) { template.Template = report.SaveToString(); template.SaveChanges(); } } else { report.Show((System.Windows.Forms.IWin32Window) owner); } } }
internal static void ShowReport(StiReport report, bool wpf, bool design, DataSet dtSet, string vrReportAutor, string vrReportDescricao, string vrEmpresa, string vrCnc, string vrTitulo, string vrUsuario, string vrFiltros, string vrImage) { report.ReportAuthor = vrReportAutor; report.ReportDescription = vrReportDescricao; if (vrImage == null || vrImage == "") report.Dictionary.Variables["vrEmpresa"].ValueObject = vrEmpresa; else { if (System.IO.File.Exists(vrImage)) { report.Dictionary.Variables["vrEmpresa"].ValueObject = sEspacos + vrEmpresa; StiImage stiImage = report.GetComponents()["imgLogo"] as StiImage; Image myImage = Image.FromFile(vrImage); stiImage.Image = myImage; } } report.Dictionary.Variables["vrCnc"].ValueObject = vrCnc; report.Dictionary.Variables["vrTitulo"].ValueObject = vrTitulo; report.Dictionary.Variables["vrUsuario"].ValueObject = vrUsuario; report.Dictionary.Variables["vrFiltros"].ValueObject = vrFiltros; report.RegData(dtSet); report.Compile(); if (design) { if (wpf) report.DesignWithWpf(); else report.Design(); } else { if (wpf) report.ShowWithWpf(); else report.Show(); } }
private void FaktLivingKomunalReport(AccountReportType accountReportType) { Account currentAccount = this.CurrentAccount; if (currentAccount.Id != Account.Null.Id) { System.Data.DataSet set = Mappers.RepReportMapper.FaktLivingKomunal(currentAccount.Id); if (((set != null) && (set.Tables.get_Count() != 0)) && (set.Tables.get_Item(0).Rows.get_Count() != 0)) { StiReport report = new StiReport(); report.Load(Resources.Rep_FaktLivingKomunal); report.Compile(); report.RegData((System.Data.DataSet) set); report.Render(true); report.Show((System.Windows.Forms.IWin32Window) this.ContentControl); } } }
private void AccountServicesJournalCurrentReportSR(AccountReportType accountReportType) { Account currentAccount = this.CurrentAccount; if (currentAccount.Id != Account.Null.Id) { System.DateTime period = System.DateTime.Now.Date.AddDays((double) (1 - System.DateTime.Now.get_Day())); System.Data.DataSet set = Mappers.SimpleReportMapper.GetAccountCurrentJournalReportByPeriod(currentAccount.Id, period, true, true, false); if (((set != null) && (set.Tables.get_Count() == 4)) && (set.Tables.get_Item(0).Rows.get_Count() != 0)) { set.Tables.get_Item(0).set_TableName("dataHeader"); set.Tables.get_Item(1).set_TableName("dataResidents"); set.Tables.get_Item(2).set_TableName("dataBenefits"); set.Tables.get_Item(3).set_TableName("dataAccountServices"); StiReport report = new StiReport(); report.Load(Resources.Rep_AccountServicesJournalCurrentSR); report.Compile(); report.RegData((System.Data.DataSet) set); report.Render(true); report.Show((System.Windows.Forms.IWin32Window) this.ContentControl); } } }
private void AccountServicesNotificationReport(AccountReportType accountReportType) { Account currentAccount = this.CurrentAccount; if (currentAccount.Id != Account.Null.Id) { System.DateTime date = System.DateTime.Now.Date; System.Data.DataSet set = Mappers.SimpleReportMapper.GetAccountServicesNotification(currentAccount.Id, date, 0L, 0L); if (((set != null) && (set.Tables.get_Count() == 2)) && (set.Tables.get_Item(0).Rows.get_Count() != 0)) { set.Tables.get_Item(0).set_TableName("dataHeader"); set.Tables.get_Item(1).set_TableName("dataServices"); StiReport report = new StiReport(); if (accountReportType.Template.get_Length() > 0) { report.LoadFromString(accountReportType.Template); } report.Compile(); report.RegData((System.Data.DataSet) set); report.Render(true); if (accountReportType.Name == "Уведомление для Грозного, без долга") { StimulsoftUtilsOptions options = new StimulsoftUtilsOptions(false); report.Show((System.Windows.Forms.IWin32Window) this.ContentControl); options.RestoreValues(); } else { report.Show((System.Windows.Forms.IWin32Window) this.ContentControl); } } } }
private void btnCreateMeetingResultReport_Click(object sender, System.EventArgs e) { System.Data.DataSet ujfMeetingResultReport = Mappers.SimpleReportMapper.GetUjfMeetingResultReport(this.meetingId); ujfMeetingResultReport.Tables.get_Item(0).set_TableName("dataMeetingAndHouseInfo"); ujfMeetingResultReport.Tables.get_Item(1).set_TableName("dataMeetingQuestionList"); ujfMeetingResultReport.Tables.get_Item(2).set_TableName("dataMeetingResult"); StiReport report = new StiReport(); report.Load(Resources.UjfMeetingResultProtocol); report.Compile(); report.RegData((System.Data.DataSet) ujfMeetingResultReport); report.Show(); }