private void نوبتدومToolStripMenuItem_Click(object sender, EventArgs e) { try { if (dgv1.RowCount > 0 && dgv1.SelectedRows.Count == 1) { string Student_id = dgv1.CurrentRow.Cells["codeMelliDataGridViewTextBoxColumn"].Value.ToString(); int Years_id_FK = (from a in db.tbl_Years orderby a.id descending select a).FirstOrDefault().id; var N2 = (from a in db.tbl_Karnameh where a.Student_id_FK == Student_id && a.Nobat == 2 && a.Years_id_FK == Years_id_FK select a).FirstOrDefault(); var N1 = (from a in db.tbl_Karnameh where a.Student_id_FK == Student_id && a.Nobat == 1 && a.Years_id_FK == Years_id_FK select a).FirstOrDefault(); if (N2 != null) { int?TosifAmalkard = (from a in db.tbl_Classes where a.id == Classid select a).FirstOrDefault().tbl_Payeh.TosifAmalkard_id_FK; Stimulsoft.Report.StiReport Sti = new Stimulsoft.Report.StiReport(); if (TosifAmalkard != null) { Sti.Load(Application.StartupPath + "\\Reports\\rptNobat2TosifKarnameh.mrt"); Sti.Compile(); Sti["str_Student_id"] = Student_id; Sti["lng_Karnameh_id_1"] = N1.id; Sti["lng_Karnameh_id_2"] = N2.id; Sti.ShowWithRibbonGUI(); } else { Sti.Load(Application.StartupPath + "\\Reports\\rptNobat2MarkKarnameh.mrt"); Sti.Compile(); Sti["str_Student_id"] = Student_id; Sti["lng_Karnameh_id_1"] = N1.id; Sti["lng_Karnameh_id_2"] = N2.id; Sti.ShowWithRibbonGUI(); } } else { MessageBox.Show("کارنامه نوبت دوم ثبت نهایی نشده است", "اخطار", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show("لطفا یک سطر را انتخاب نمایید", "اخطار", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception ex) { MessageBox.Show(ex.Message, "اخطار", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void ShowReport(Infrastructure.Report.ExportType reportType) { var varList = (InstallmentPerLoanGridControl.ItemsSource as System.Collections.Generic.List <ViewModels.InstallmentViewModel>) .Select(current => new { current.AmountRialFormat, current.PersianInstallmentDate, current.PersianPaymentDate, current.IsPayedDescription, }) .ToList(); Stimulsoft.Report.StiReport oStiReport = new Stimulsoft.Report.StiReport(); oStiReport.Load(Properties.Resources.InstallmentListReport); oStiReport.Dictionary.Variables.Add("Today", System.DateTime.Now.ToPersianDate()); oStiReport.Dictionary.Variables.Add("FundName", Utility.CurrentFund.Name); oStiReport.Dictionary.Variables.Add("FundManagerName", Utility.CurrentFund.ManagerName); oStiReport.Dictionary.Variables.Add("MemberName", Utility.CurrentLoan.Member.FullName.ToString()); oStiReport.Dictionary.Variables.Add("LoanAmount", (new ViewModels.LoanViewModel { LoanAmount = Utility.CurrentLoan.LoanAmount }).LoanAmountRialFormat); oStiReport.Dictionary.Variables.Add("RefundAmount", (new ViewModels.LoanViewModel { RefundAmount = Utility.CurrentLoan.RefundAmount }).RefundAmountRialFormat); oStiReport.RegBusinessObject("InstallmentsList", varList); oStiReport.Compile(); oStiReport.RenderWithWpf(); oStiReport.DoAction(action: reportType, fileName: "گزارش لیست اقساط"); }
protected void SetandoRelExcel() { Stimulsoft.Report.StiReport Report = new Stimulsoft.Report.StiReport(); DataTable dt = new DataTable(); string nomeRelatorio = string.Empty; if (Convert.ToString(Request.QueryString["Rel"]) == "frmFechamentoRel") { FechamentoFolhaSrv fechamentoFolhaSrv = new FechamentoFolhaSrv(); dt = new DataTable(); dt = fechamentoFolhaSrv.GetDadosImprimir(Request.QueryString["Mes"].ToString()); nomeRelatorio = "FechamentoFolha.xls"; Report.Load(Server.MapPath(@"~/Relatorio/STF/FechamentoFolha.mrt")); Report.Compile(); } Report.RegData("DADOS", dt); Report.Render(); System.IO.MemoryStream memStream = new System.IO.MemoryStream(); HttpContext.Current.Response.ClearContent(); HttpContext.Current.Response.ClearHeaders(); HttpContext.Current.Response.ContentType = "application/xls"; HttpContext.Current.Response.AddHeader(nomeRelatorio, ""); Stimulsoft.Report.Export.StiExcelExportService ExportXSL = new Stimulsoft.Report.Export.StiExcelExportService(); ExportXSL.ExportExcel(Report, memStream, Stimulsoft.Report.StiPagesRange.All, false, false, true, true); Response.ContentType = "application/xls"; Response.AddHeader("content-disposition", "inline; filename=" + nomeRelatorio + ""); Response.BinaryWrite(memStream.ToArray()); }
private void ShowReport(Infrastructure.Report.ExportType reportType) { var varList = (GridControl.ItemsSource as System.Collections.Generic.List <ViewModels.MemberTransactionViewModel>) .OrderBy(current => current.Date) .Select(current => new { current.AmountRialFormat, current.PersianDate, current.TransactionDescription, }) .ToList(); Stimulsoft.Report.StiReport oStiReport = new Stimulsoft.Report.StiReport(); oStiReport.Load(Properties.Resources.MemberTransactionsReport); oStiReport.Dictionary.Variables.Add("Today", System.DateTime.Now.ToPersianDate()); oStiReport.Dictionary.Variables.Add("FundName", Utility.CurrentFund.Name); oStiReport.Dictionary.Variables.Add("FundManagerName", Utility.CurrentFund.ManagerName); oStiReport.Dictionary.Variables.Add("MemberName", Utility.CurrentMember.FullName.ToString()); oStiReport.RegBusinessObject("Transactions", varList); oStiReport.Compile(); oStiReport.RenderWithWpf(); oStiReport.DoAction(action: reportType, fileName: "گزارش واریز اعضا"); }
private void ShowReport(Infrastructure.Report.ExportType reportType) { var varObject = new { LoansCount = LoansCountLabel.Content, LoansAmount = LoansAmountLabel.Content, PayedLoansCount = PayedLoansCountLabel.Content, PayedLoansAmount = PayedLoansAmountLabel.Content, InstallmentsCount = InstallmentsCountLabel.Content, InstallmentsAmount = InstallmentsAmountLabel.Content, PayedInstallmentsCount = PayedInstallmentsCountLabel.Content, PayedInstallmentsAmount = PayedInstallmentsAmountLabel.Content, }; Stimulsoft.Report.StiReport oStiReport = new Stimulsoft.Report.StiReport(); oStiReport.Load(Properties.Resources.FundBalanceReport); oStiReport.Dictionary.Variables.Add("Today", System.DateTime.Now.ToPersianDate()); oStiReport.Dictionary.Variables.Add("FundName", Utility.CurrentFund.Name); oStiReport.Dictionary.Variables.Add("FundManagerName", Utility.CurrentFund.ManagerName); oStiReport.Dictionary.Variables.Add("FundBalance", Utility.CurrentFund.Balance.ToRialStringFormat()); oStiReport.RegBusinessObject("MemberBalance", varObject); oStiReport.Compile(); oStiReport.RenderWithWpf(); oStiReport.DoAction(action: reportType, fileName: "تراز مالی " + Utility.CurrentMember.FullName.ToString()); }
public virtual ActionResult GetReportSnapshot(string fileName, string sourceName, string sourceData) { PrintModel model = new PrintModel(); model.fileName = fileName; model.sourceName = "Source"; model.sourceData = null; if (fileName == "packListB") { model.sourceData = BLLFactory <PackList_Head> .Instance.GetPrint(sourceData); model.sourceName = sourceName; model.fileName = fileName; } // 创建报表对象 Stimulsoft.Report.StiReport report = new Stimulsoft.Report.StiReport(); //读取文件 report.Load(Server.MapPath(string.Format("~/Content/reports/{0}.mrt", model.fileName))); //截止读取 report.Compile(); if (!string.IsNullOrEmpty(model.sourceName) && model.sourceData != null) { //注册数据源P report.RegData(model.sourceName, model.sourceData); } //返回报表 return(Stimulsoft.Report.Mvc.StiMvcViewer.GetReportSnapshotResult(report)); }
private void ShowReport(Infrastructure.Report.ExportType reportType) { DAL.UnitOfWork oUnitOfWork = null; try { oUnitOfWork = new DAL.UnitOfWork(); var varList = oUnitOfWork.UserRepository .Get() .OrderBy(current => current.Username) .Select(current => new ViewModels.UserViewModel() { Id = current.Id, Username = current.Username, RegisterationDate = current.RegisterationDate, IsAdmin = current.IsAdmin, LastLoginTime = current.LastLoginTime, }) .ToList(); var varListToReport = varList .OrderBy(current => current.Username) .Select(current => new { Username = current.Username, PersianRegisterationDate = current.PersianRegisterationDate, IsAdminDescription = current.IsAdminDescription, PersianLastLoginTime = current.PersianLastLoginTime, }) .ToList(); Stimulsoft.Report.StiReport usersReport = new Stimulsoft.Report.StiReport(); usersReport.Load(Properties.Resources.UsersViewReport); usersReport.Dictionary.Variables.Add("Today", System.DateTime.Now.ToPersianDate()); usersReport.RegBusinessObject("Users", varListToReport); usersReport.Compile(); usersReport.RenderWithWpf(); usersReport.DoAction(reportType, "گزارش کاربران"); oUnitOfWork.Save(); } catch (System.Exception ex) { Infrastructure.MessageBox.Show(ex.Message); } finally { if (oUnitOfWork != null) { oUnitOfWork.Dispose(); oUnitOfWork = null; } } }
private void Form1_Load(object sender, System.EventArgs e) { using (var stream = System.Reflection.Assembly.GetExecutingAssembly().GetManifestResourceStream("CustomViewer.CustomPreview.mrt")) { Report.Load(stream); } Report.Compile(); btRefresh_Click(sender, e); }
private void OBackgroundWorker_DoWork(object sender, System.ComponentModel.DoWorkEventArgs e) { this.Dispatcher.Invoke(() => { EnterEmailPasswordWindow oEnterEmailPasswordWindow = e.Argument as EnterEmailPasswordWindow; var varList = (InstallmentPerLoanGridControl.ItemsSource as System.Collections.Generic.List <ViewModels.InstallmentViewModel>) .Select(current => new { current.AmountRialFormat, current.PersianInstallmentDate, current.PersianPaymentDate, current.IsPayedDescription, }) .ToList(); Stimulsoft.Report.StiReport oStiReport = new Stimulsoft.Report.StiReport(); oStiReport.Load(Properties.Resources.InstallmentListReport); oStiReport.Dictionary.Variables.Add("Today", System.DateTime.Now.ToPersianDate()); oStiReport.Dictionary.Variables.Add("FundName", Utility.CurrentFund.Name); oStiReport.Dictionary.Variables.Add("FundManagerName", Utility.CurrentFund.ManagerName); oStiReport.Dictionary.Variables.Add("MemberName", Utility.CurrentLoan.Member.FullName.ToString()); oStiReport.Dictionary.Variables.Add("LoanAmount", (new ViewModels.LoanViewModel { LoanAmount = Utility.CurrentLoan.LoanAmount }).LoanAmountRialFormat); oStiReport.Dictionary.Variables.Add("RefundAmount", (new ViewModels.LoanViewModel { RefundAmount = Utility.CurrentLoan.RefundAmount }).RefundAmountRialFormat); oStiReport.RegBusinessObject("InstallmentsList", varList); oStiReport.Compile(); oStiReport.RenderWithWpf(); System.IO.MemoryStream oMemoryStream = new System.IO.MemoryStream(); oStiReport.ExportDocument(Stimulsoft.Report.StiExportFormat.Pdf, oMemoryStream); oMemoryStream.Seek(0, System.IO.SeekOrigin.Begin); Utility.SendEmail ( senderEmail: Utility.CurrentUser.EmailAddress, senderPassword: oEnterEmailPasswordWindow.EmailPassword, displayName: Utility.CurrentUser.FullName.ToString(), receiverEmail: Utility.CurrentMember.EmailAddress, subject: Utility.CurrentFund.Name + " | " + "لیست اقساط " + Utility.CurrentMember.FullName.ToString(), body: "لیست اقساط " + Utility.CurrentMember.FullName.ToString() + System.Environment.NewLine + new FarsiLibrary.Utils.PersianDate(System.DateTime.Now).ToString(), attachment: oMemoryStream, attachmentName: "لیست اقساط " + Utility.CurrentMember.FullName.ToString() ); }); }
public ActionResult LoadReport() { var product = db.Products.OrderByDescending(p => p.Quantity).Take(8).ToList(); var R = new Stimulsoft.Report.StiReport(); R.Load(Server.MapPath("/Reports/QtyReport.mrt")); R.Compile(); R.RegBusinessObject("myData", product); return(Stimulsoft.Report.Mvc.StiMvcViewer.GetReportSnapshotResult(R)); }
private void buttonX2_Click(object sender, EventArgs e) { try { Stimulsoft.Report.StiReport Sti = new Stimulsoft.Report.StiReport(); Sti.Load(Application.StartupPath + "\\Reports\\rptMoavenEjraei.mrt"); Sti.Compile(); Sti.ShowWithRibbonGUI(); } catch (Exception ex) { MessageBox.Show(ex.Message, "اخطار", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void backgroundWorker1_DoWork(object sender, DoWorkEventArgs e) { using (var stream = Assembly.GetExecutingAssembly().GetManifestResourceStream("RenderInThread.MasterDetailSubdetail.mrt")) { report.Load(stream); } report.IsRendered = false; report.Compile(); report.CompiledReport.Rendering += new EventHandler(CompiledReport_Rendering); report.Render(false); }
private void OBackgroundWorker_DoWork(object sender, System.ComponentModel.DoWorkEventArgs e) { this.Dispatcher.Invoke(() => { EnterEmailPasswordWindow oEnterEmailPasswordWindow = e.Argument as EnterEmailPasswordWindow; var varObject = new { LoansCount = LoansCountLabel.Content, LoansAmount = LoansAmountLabel.Content, PayedLoansCount = PayedLoansCountLabel.Content, PayedLoansAmount = PayedLoansAmountLabel.Content, InstallmentsCount = InstallmentsCountLabel.Content, InstallmentsAmount = InstallmentsAmountLabel.Content, PayedInstallmentsCount = PayedInstallmentsCountLabel.Content, PayedInstallmentsAmount = PayedInstallmentsAmountLabel.Content, }; Stimulsoft.Report.StiReport oStiReport = new Stimulsoft.Report.StiReport(); oStiReport.Load(Properties.Resources.FundBalanceReport); oStiReport.Dictionary.Variables.Add("Today", System.DateTime.Now.ToPersianDate()); oStiReport.Dictionary.Variables.Add("FundName", Utility.CurrentFund.Name); oStiReport.Dictionary.Variables.Add("FundManagerName", Utility.CurrentFund.ManagerName); oStiReport.Dictionary.Variables.Add("FundBalance", Utility.CurrentFund.Balance.ToRialStringFormat()); oStiReport.RegBusinessObject("MemberBalance", varObject); oStiReport.Compile(); oStiReport.RenderWithWpf(); System.IO.MemoryStream oMemoryStream = new System.IO.MemoryStream(); oStiReport.ExportDocument(Stimulsoft.Report.StiExportFormat.Pdf, oMemoryStream); oMemoryStream.Seek(0, System.IO.SeekOrigin.Begin); Utility.SendEmail ( senderEmail: Utility.CurrentUser.EmailAddress, senderPassword: oEnterEmailPasswordWindow.EmailPassword, displayName: Utility.CurrentUser.FullName.ToString(), receiverEmail: Utility.CurrentMember.EmailAddress, subject: Utility.CurrentFund.Name + " | " + "تراز مالی عضو " + Utility.CurrentMember.FullName.ToString(), body: "تراز مالی " + Utility.CurrentMember.FullName.ToString() + System.Environment.NewLine + new FarsiLibrary.Utils.PersianDate(System.DateTime.Now).ToString(), attachment: oMemoryStream, attachmentName: "تراز مالی " + Utility.CurrentMember.FullName.ToString() ); }); }
private void buttonX4_Click(object sender, EventArgs e) { try { Stimulsoft.Report.StiReport Sti = new Stimulsoft.Report.StiReport(); Sti.Load(Application.StartupPath + "\\Reports\\rptClasses.mrt"); Sti.Compile(); Sti["lng_School_id"] = Frm_Main.School_id; Sti.ShowWithRibbonGUI(); } catch (Exception ex) { MessageBox.Show(ex.Message, "اخطار", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void backgroundWorker1_DoWork(object sender, DoWorkEventArgs e) { using (var stream = Assembly.GetExecutingAssembly().GetManifestResourceStream("RenderInThread.Master-Detail-Subdetail.mrt")) { report.Load(stream); } DataSet data = new DataSet(); data.ReadXmlSchema("..\\..\\Data\\demo.xsd"); data.ReadXml("..\\..\\Data\\demo.xml"); report.RegData(data); report.IsRendered = false; report.Compile(); report.CompiledReport.Rendering += new EventHandler(CompiledReport_Rendering); report.Render(false); }
private void toolStripButtonDesign_Click(object sender, EventArgs e) { if (treeViewReports.SelectedNode.Index != -1) { using (Stimulsoft.Report.StiReport report = new Stimulsoft.Report.StiReport()) { report.Load(ReportsPath + treeViewReports.SelectedNode.Text + ".mrt"); report.Dictionary.Databases.Clear(); report.RegData("Demo", "Demo", dataSetInvoice); report.Compile(); report.Design(true); } } else { MessageBox.Show("Select invoice first to proceed!"); } }
private void buttonDesign_Click(object sender, RoutedEventArgs e) { if (treeViewReports.SelectedItem != null) { using (Stimulsoft.Report.StiReport report = new Stimulsoft.Report.StiReport()) { report.Load(ReportsPath + treeViewReports.SelectedItem.ToString() + ".mrt"); report.Dictionary.Databases.Clear(); report.RegData("Demo", "Demo", dataSetInvoice); report.Compile(); report.DesignWithWpf(); } } else { Stimulsoft.Report.Wpf.StiMessageBox.Show("Select invoice first to proceed!"); } }
private void ShowReport(Infrastructure.Report.ExportType reportType) { var varList = (MembersLoanGridControl.ItemsSource as System.Collections.Generic.List <ViewModels.LoanViewModel>) .OrderBy(current => current.StartDate) .Select(current => new { current.LoanAmountRialFormat, current.RefundAmountRialFormat, current.PersianEndDate, current.PersianStartDate, current.InstallmentsCount, current.IsPayedDescrption, current.Description, }) .ToList(); if (varList.Count == 0) { Infrastructure.MessageBox.Show ( caption: Infrastructure.MessageBox.Caption.Error, text: "اطلاعاتی برای تهیه گزارش در جدول موجود نمیباشد. " ); return; } Stimulsoft.Report.StiReport oStiReport = new Stimulsoft.Report.StiReport(); oStiReport.Load(Properties.Resources.MembersLoansListReport); oStiReport.Dictionary.Variables.Add("Today", System.DateTime.Now.ToPersianDate()); oStiReport.Dictionary.Variables.Add("FundName", Utility.CurrentFund.Name); oStiReport.Dictionary.Variables.Add("FundManagerName", Utility.CurrentFund.ManagerName); oStiReport.Dictionary.Variables.Add("MemberName", Utility.CurrentMember.FullName.ToString()); oStiReport.Dictionary.Variables.Add("LoanStatus", LoanStatusComboBox.Text); oStiReport.RegBusinessObject("Loans", varList); oStiReport.Compile(); oStiReport.RenderWithWpf(); string fileName = string.Format("گزارش {0} {1}", LoanStatusComboBox.Text, Utility.CurrentMember.FullName.ToString()); oStiReport.DoAction(action: reportType, fileName: fileName); }
private void ShowReport(Infrastructure.Report.ExportType reportType) { var varList = (LoansGridControl.ItemsSource as System.Collections.Generic.List <Models.Loan>) .OrderBy(current => current.StartDate) .Select(current => new ViewModels.LoanViewModel() { IsPayed = current.IsPayed, IsActive = current.IsActive, LoanAmount = current.LoanAmount, RefundAmount = current.RefundAmount, EndDate = current.EndDate, StartDate = current.StartDate, InstallmentsCount = current.InstallmentsCount, MemberId = current.MemberId, }) .Select(current => new { current.LoanAmountRialFormat, current.RefundAmountRialFormat, current.PersianEndDate, current.PersianStartDate, current.InstallmentsCount, current.IsPayedDescrption, FullName = current.FullName.ToString(), }) .ToList(); ; Stimulsoft.Report.StiReport oStiReport = new Stimulsoft.Report.StiReport(); oStiReport.Load(Properties.Resources.ConfirmedLoansListReport); oStiReport.Dictionary.Variables.Add("Today", System.DateTime.Now.ToPersianDate()); oStiReport.Dictionary.Variables.Add("FundName", Utility.CurrentFund.Name); oStiReport.Dictionary.Variables.Add("FundManagerName", Utility.CurrentFund.ManagerName); oStiReport.RegBusinessObject("Loans", varList); oStiReport.Compile(); oStiReport.RenderWithWpf(); oStiReport.DoAction(action: reportType, fileName: "گزارش وامهای پرداختی"); }
protected void SetandoRel() { //Report da stimulsoft Stimulsoft.Report.StiReport Report = new Stimulsoft.Report.StiReport(); //Stimulsoft.Report.Web.StiWebDesigner st1 = new Stimulsoft.Report.Web.StiWebDesigner(); if (Convert.ToString(Request.QueryString["Rel"]) == "frmZuxa") { Report.Load(Server.MapPath(@"~/Relatorio/STF/EspelhoPonto.mrt")); Report.Compile(); Report["DiasMes"] = TotalDiasMes.ToString(); Report["DiasCumpridos"] = TotalDiasCumprido.ToString(); Report["TotalHorasMes"] = TotalHoraMes.ToString(); Report["HorasCumpridas"] = HorasCumpridas.ToString(); } Report.RegData("DatasetPontoFrequencia", ds); Report.Render(); System.IO.MemoryStream memStream = new System.IO.MemoryStream(); HttpContext.Current.Response.ClearContent(); HttpContext.Current.Response.ClearHeaders(); HttpContext.Current.Response.ContentType = "application/pdf"; HttpContext.Current.Response.AddHeader("Pontoweb.pdf", ""); Stimulsoft.Report.Export.StiPdfExportService Export = new Stimulsoft.Report.Export.StiPdfExportService(); Export.ExportPdf(Report, memStream, Stimulsoft.Report.StiPagesRange.All, 100, 100, false, false, true, true, "", "", Stimulsoft.Report.Export.StiUserAccessPrivileges.All, Stimulsoft.Report.Export.StiPdfEncryptionKeyLength.Bit40, false); Response.ContentType = "application/pdf"; Response.AddHeader("content-disposition", "inline; filename=Pontoweb.pdf"); Response.BinaryWrite(memStream.ToArray()); }
private void buttonX2_Click(object sender, EventArgs e) { try { var Q = (from a in db.tbl_Years orderby a.id descending select a).FirstOrDefault(); int YearsId = 0; if (Q != null) { YearsId = Q.id; } Stimulsoft.Report.StiReport Sti = new Stimulsoft.Report.StiReport(); Sti.Load(Application.StartupPath + "\\Reports\\rptStudentClasses.mrt"); Sti.Compile(); Sti["int_Yearsid"] = YearsId; Sti["lng_Classid"] = Classid; Sti.ShowWithRibbonGUI(); } catch (Exception ex) { MessageBox.Show(ex.Message, "اخطار", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void ShowReport(Infrastructure.Report.ExportType reportType) { var varList = (GridControl.ItemsSource as System.Collections.Generic.List <ViewModels.TransactionViewModel>) .OrderBy(current => current.Date) .Select(current => new { current.AmountRialFormat, current.BalanceRialFormat, current.PersianDate, current.TransactionDescription, MemberFullName = current.MemberFullName.ToString(), }) .ToList(); if (varList.Count == 0) { Infrastructure.MessageBox.Show ( caption: Infrastructure.MessageBox.Caption.Error, text: "اطلاعاتی برای تهیه گزارش در جدول موجود نمیباشد. " + System.Environment.NewLine + "لطفا بازه زمانی دیگری را انتخاب نمایید." ); return; } Stimulsoft.Report.StiReport oStiReport = new Stimulsoft.Report.StiReport(); oStiReport.Load(Properties.Resources.TransactionsReport); oStiReport.Dictionary.Variables.Add("Today", System.DateTime.Now.ToPersianDate()); oStiReport.Dictionary.Variables.Add("FundName", Utility.CurrentFund.Name); oStiReport.Dictionary.Variables.Add("FundManagerName", Utility.CurrentFund.ManagerName); oStiReport.Dictionary.Variables.Add("FromDate", varList.Select(current => current.PersianDate).FirstOrDefault()); oStiReport.Dictionary.Variables.Add("ToDate", varList.Select(current => current.PersianDate).LastOrDefault()); oStiReport.RegBusinessObject("Transactions", varList); oStiReport.Compile(); oStiReport.RenderWithWpf(); oStiReport.DoAction(action: reportType, fileName: "گزارش ریز حساب صندوق"); }
private void ShowReport(Infrastructure.Report.ExportType reportType) { DAL.UnitOfWork oUnitOfWork = null; try { oUnitOfWork = new DAL.UnitOfWork(); var varList = oUnitOfWork.MemberRepository .MembersToReport() .ToList(); Stimulsoft.Report.StiReport oReport = new Stimulsoft.Report.StiReport(); oReport.Load(Properties.Resources.MembersViewReport); oReport.Dictionary.Variables.Add("Today", System.DateTime.Now.ToPersianDate()); oReport.Dictionary.Variables.Add("FundName", Utility.CurrentFund.Name); oReport.Dictionary.Variables.Add("FundManagerName", Utility.CurrentFund.ManagerName); oReport.RegBusinessObject("Members", varList); oReport.Compile(); oReport.RenderWithWpf(); oReport.DoAction(reportType, string.Format("گزارش اعضا ({0}) ", Utility.CurrentFund.Name)); oUnitOfWork.Save(); } catch (System.Exception ex) { Infrastructure.MessageBox.Show(ex.Message); } finally { if (oUnitOfWork != null) { oUnitOfWork.Dispose(); oUnitOfWork = null; } } }
protected override bool WfExecReport(Stimulsoft.Report.StiReport pReport) { //DataSet ds; vw_invr215 invr215Model; StringBuilder sbSql = null; string sqlBody = ""; DataTable dtMaster; List <QueryInfo> queryInfoList; QueryInfo queryModel; string strQueryRange, strWhere; StringBuilder sbQuerySingle = null; List <SqlParameter> sqlParmList; List <Master> resultList = null; try { invr215Model = DrMaster.ToItem <vw_invr215>(); resultList = new List <Master>(); #region 處理類型 queryInfoList = new List <QueryInfo>(); #region range 處理 if (!GlobalFn.varIsNull(invr215Model.icc01)) { queryModel = new QueryInfo(); queryModel.TableName = "icc_tb"; queryModel.ColumnName = "icc01"; queryModel.ColumnType = TabMaster.DtSource.Columns["icc01"].DataType.Name; queryModel.Value = invr215Model.icc01; queryInfoList.Add(queryModel); } if (!GlobalFn.varIsNull(invr215Model.icc02)) { queryModel = new QueryInfo(); queryModel.TableName = "icc_tb"; queryModel.ColumnName = "icc02"; queryModel.ColumnType = TabMaster.DtSource.Columns["icc02"].DataType.Name; queryModel.Value = invr215Model.icc02; queryInfoList.Add(queryModel); } sqlParmList = new List <SqlParameter>(); strQueryRange = BoMaster.WfGetQueryString(queryInfoList, out sqlParmList); #endregion sbQuerySingle = new StringBuilder(); strWhere = strQueryRange + " " + sbQuerySingle.ToString(); var strSecurity = WfGetSecurityString(); //取得權限字串 if (!GlobalFn.varIsNull(strSecurity)) { strWhere += strSecurity; } //取得單頭 if (invr215Model.show_warehouse_yn == "Y") { sqlBody = @" SELECT icc01,icc02,icc03,icc05, ica02,ica03,ica07, bej03,'' as icc05_str FROM icc_tb LEFT JOIN ica_tb ON icc01=ica01 LEFT JOIN bej_tb ON ica07=bej01 WHERE ica05>0 "; dtMaster = BoMaster.OfGetDataTable(string.Concat(sqlBody, strWhere), sqlParmList.ToArray()); } else { sqlBody = @" SELECT icc01,'' AS icc02,icc03,sum(icc05) as icc05, ica02,ica03,ica07, bej03,'' as icc05_str FROM icc_tb LEFT JOIN ica_tb ON icc01=ica01 LEFT JOIN bej_tb ON ica07=bej01 WHERE ica05>0 "; var sqlGroupBy = @" GROUP BY icc01,icc03, ica02,ica03,ica07, bej03"; dtMaster = BoMaster.OfGetDataTable(string.Concat(sqlBody, strWhere, sqlGroupBy), sqlParmList.ToArray()); } dtMaster.TableName = "Master"; if (dtMaster != null) { resultList.AddRange(dtMaster.ToList <Master>()); } #endregion if (resultList == null || resultList.Count == 0) { WfShowErrorMsg("查無資料,請重新過濾條件!"); return(false); } foreach (Master masterModel in resultList) { //數量處理 masterModel.icc05_str = string.Format("{0:N" + masterModel.bej03 + "}", masterModel.icc05);//數量 } pReport.RegData("master", resultList); pReport.CacheAllData = true; pReport.Compile(); return(true); } catch (Exception ex) { throw ex; } }
private void ShowReport(Infrastructure.Report.ExportType reportType) { Stimulsoft.Report.StiReport oStiReport = new Stimulsoft.Report.StiReport(); DAL.UnitOfWork oUnitOfWork = null; try { oUnitOfWork = new DAL.UnitOfWork(); Models.Member oMember = oUnitOfWork.MemberRepository .GetById(CurrentId); ViewModels.MembershipCardViewModel oViewModel = new ViewModels.MembershipCardViewModel(); oViewModel.FirstName = oMember.FullName.FirstName; oViewModel.LastName = oMember.FullName.LastName; oViewModel.FatherName = oMember.FatherName; oViewModel.Gender = oMember.Gender; oViewModel.NationalCode = oMember.NationalCode; oViewModel.EmailAddress = oMember.EmailAddress; oViewModel.FundName = oMember.Fund.Name; oViewModel.PhoneNumber = oMember.PhoneNumber; oViewModel.MembershipDate = oMember.MembershipDate; if (oMember.Picture != null) { System.IO.MemoryStream oMemoryStream = new System.IO.MemoryStream(oMember.Picture); System.Drawing.Image oImage = System.Drawing.Image.FromStream(oMemoryStream); oViewModel.Picture = oImage; } else { System.Drawing.Image oImage = Properties.Resources.ImageNull; oViewModel.Picture = oImage; } var varData = new { FirstName = oViewModel.FirstName, LastName = oViewModel.LastName, Picture = oViewModel.Picture, FatherName = oViewModel.FatherName, GenderDescription = oViewModel.GenderDescription, FundName = oViewModel.FundName, PhoneNumber = oViewModel.PhoneNumber, PersianMembershipDate = oViewModel.PersianMembershipDate, EmailAddress = oViewModel.EmailAddress, NationalCode = oViewModel.NationalCode, }; oStiReport.Load(Properties.Resources.MembershipCardReport); oStiReport.RegBusinessObject("MembershipCard", varData); oStiReport.Compile(); oStiReport.RenderWithWpf(); oStiReport.DoAction(reportType, string.Format("{0} {1}", "کارت عضویت", oMember.FullName.FirstName + "" + oMember.FullName.LastName)); oUnitOfWork.Save(); } catch (System.Exception ex) { Infrastructure.MessageBox.Show(ex.Message);; } finally { if (oUnitOfWork != null) { oUnitOfWork.Dispose(); oUnitOfWork = null; } } }
protected override bool WfExecReport(Stimulsoft.Report.StiReport pReport) { //DataSet ds; vw_invr336 invr336Model; StringBuilder sbSql = null; string sqlBody = ""; DataTable dtIlaTb; List <QueryInfo> queryInfoList; QueryInfo queryModel; string strQueryRange, strWhere; StringBuilder sbQuerySingle = null; List <SqlParameter> sqlParmList; List <Master> resultList = null; try { invr336Model = DrMaster.ToItem <vw_invr336>(); resultList = new List <Master>(); queryInfoList = new List <QueryInfo>(); #region range 處理 if (!GlobalFn.varIsNull(invr336Model.ifa01)) { queryModel = new QueryInfo(); queryModel.TableName = "ifa_tb"; queryModel.ColumnName = "ifa01"; queryModel.ColumnType = TabMaster.DtSource.Columns["ifa01"].DataType.Name; queryModel.Value = invr336Model.ifa01; queryInfoList.Add(queryModel); } if (!GlobalFn.varIsNull(invr336Model.ifa03)) { queryModel = new QueryInfo(); queryModel.TableName = "ifa_tb"; queryModel.ColumnName = "ifa03"; queryModel.ColumnType = TabMaster.DtSource.Columns["ifa03"].DataType.Name; queryModel.Value = invr336Model.ifa03; queryInfoList.Add(queryModel); } if (!GlobalFn.varIsNull(invr336Model.ifa04)) { queryModel = new QueryInfo(); queryModel.TableName = "ifa_tb"; queryModel.ColumnName = "ifa04"; queryModel.ColumnType = TabMaster.DtSource.Columns["ifa04"].DataType.Name; queryModel.Value = invr336Model.ifa04; queryInfoList.Add(queryModel); } sqlParmList = new List <SqlParameter>(); strQueryRange = BoMaster.WfGetQueryString(queryInfoList, out sqlParmList); #endregion #region single 處理 sbQuerySingle = new StringBuilder(); if (!GlobalFn.varIsNull(invr336Model.ifa02_s)) { sbQuerySingle.AppendLine("AND ifa02>=@ifa02_s"); sqlParmList.Add(new SqlParameter("@ifa02_s", invr336Model.ifa02_s)); } if (!GlobalFn.varIsNull(invr336Model.ifa02_e)) { sbQuerySingle.AppendLine("AND ifa02<=@ifa02_e"); sqlParmList.Add(new SqlParameter("@ifa02_s", invr336Model.ifa02_e)); } if (invr336Model.conf_yn != "0") { if (invr336Model.conf_yn == "1") { sbQuerySingle.AppendLine("AND ifaconf = 'Y'"); } if (invr336Model.conf_yn == "2") { sbQuerySingle.AppendLine("AND ifaconf = 'N'"); } } #endregion strWhere = strQueryRange + " " + sbQuerySingle.ToString(); var strSecurity = WfGetSecurityString(); //取得權限字串 if (!GlobalFn.varIsNull(strSecurity)) { strWhere += strSecurity; } //取得單頭 sqlBody = @" SELECT ifa01,ifa02,ifa03,bec02 as ifa03_c , ifa04,beb03 AS ifa04_c,ifa05,ifaconf, ifb02,ifb03,ifb04,ifb05,'' as ifb05_str,ifb06, bej03,ifb07, ifb08,'' as ifb08_str,ifb09,ifb10, ica03 FROM ifa_tb LEFT JOIN ifb_tb ON ifa01=ifb01 LEFT JOIN bec_tb ON ifa03=bec01 LEFT JOIN beb_tb ON ifa04=beb01 LEFT JOIN bej_tb ON ifb06=bej01 LEFT JOIN ica_tb ON ifb03=ica01 WHERE ifa00='1' AND ifb01 IS NOT NULL "; dtIlaTb = BoMaster.OfGetDataTable(string.Concat(sqlBody, strWhere), sqlParmList.ToArray()); dtIlaTb.TableName = "Master"; if (dtIlaTb != null) { resultList.AddRange(dtIlaTb.ToList <Master>()); } if (resultList == null || resultList.Count == 0) { WfShowErrorMsg("查無資料,請重新過濾條件!"); return(false); } foreach (Master masterModel in resultList) { //數量處理 masterModel.ifb05_str = string.Format("{0:N" + masterModel.bej03 + "}", masterModel.ifb05); //數量 masterModel.ifb08_str = string.Format("{0:N" + masterModel.bej03 + "}", masterModel.ifb08); //數量 } pReport.RegData("master", resultList); pReport.CacheAllData = true; pReport.Compile(); return(true); } catch (Exception ex) { throw ex; } }
protected override bool WfExecReport(Stimulsoft.Report.StiReport pReport) { //DataSet ds; vw_invr522 invr522Model; string sqlBody = ""; DataTable dtIlaTb; List<QueryInfo> queryInfoList; QueryInfo queryModel; string strQueryRange, strWhere, strOrderBy; StringBuilder sbQuerySingle = null; List<SqlParameter> sqlParmList; List<Master> resultList = null; try { invr522Model = DrMaster.ToItem<vw_invr522>(); resultList = new List<Master>(); queryInfoList = new List<QueryInfo>(); #region range 處理 if (!GlobalFn.varIsNull(invr522Model.ipa01)) { queryModel = new QueryInfo(); queryModel.TableName = "ipa_tb"; queryModel.ColumnName = "ipa01"; queryModel.ColumnType = TabMaster.DtSource.Columns["ipa01"].DataType.Name; queryModel.Value = invr522Model.ipa01; queryInfoList.Add(queryModel); } if (!GlobalFn.varIsNull(invr522Model.ipacreu)) { queryModel = new QueryInfo(); queryModel.TableName = "ipa_tb"; queryModel.ColumnName = "ipacreu"; queryModel.ColumnType = TabMaster.DtSource.Columns["ipacreu"].DataType.Name; queryModel.Value = invr522Model.ipacreu; queryInfoList.Add(queryModel); } if (!GlobalFn.varIsNull(invr522Model.ipacreg)) { queryModel = new QueryInfo(); queryModel.TableName = "ipa_tb"; queryModel.ColumnName = "ipacreg"; queryModel.ColumnType = TabMaster.DtSource.Columns["ipacreg"].DataType.Name; queryModel.Value = invr522Model.ipacreg; queryInfoList.Add(queryModel); } sqlParmList = new List<SqlParameter>(); strQueryRange = BoMaster.WfGetQueryString(queryInfoList, out sqlParmList); #endregion #region single 處理 sbQuerySingle = new StringBuilder(); if (!GlobalFn.varIsNull(invr522Model.ipa03_s)) { sbQuerySingle.AppendLine("AND ipa03>=@ipa03_s"); sqlParmList.Add(new SqlParameter("@ila02_s", invr522Model.ipa03_s)); } if (!GlobalFn.varIsNull(invr522Model.ipa03_e)) { sbQuerySingle.AppendLine("AND ipa03<=@ipa03_e"); sqlParmList.Add(new SqlParameter("@ipa03_e", invr522Model.ipa03_e)); } #endregion strWhere = strQueryRange + " " + sbQuerySingle.ToString(); var strSecurity = WfGetSecurityString(); //取得權限字串 if (!GlobalFn.varIsNull(strSecurity)) strWhere += strSecurity; //取得單頭 sqlBody = @" SELECT ipa01,ipb02,ipb03,ipb04,ipb05, ipb06,ipb07,ipb30,ipb40,ipb50, ica02,ica03, bej03, CONVERT(DECIMAL,0) AS qty1, CONVERT(DECIMAL,0) AS qty2, CONVERT(DECIMAL,0) AS dif_qty, CONVERT(NVARCHAR(20),0) AS qty1_str, CONVERT(NVARCHAR(20),0) AS qty2_str, CONVERT(NVARCHAR(20),0) AS dif_qty_str FROM ipa_tb INNER JOIN ipb_tb ON ipa01=ipb01 LEFT JOIN ica_tb ON ipb03=ica01 LEFT JOIN bej_tb ON ipb07=bej01 WHERE ipa05='Y' "; strOrderBy = " ORDER BY ipa01,ipb02"; dtIlaTb = BoMaster.OfGetDataTable(string.Concat(sqlBody, strWhere, strOrderBy), sqlParmList.ToArray()); dtIlaTb.TableName = "Master"; if (dtIlaTb != null) { resultList.AddRange(dtIlaTb.ToList<Master>()); } if (resultList == null || resultList.Count == 0) { WfShowErrorMsg("查無資料,請重新過濾條件!"); return false; } foreach (Master masterModel in resultList) { switch (invr522Model.type1) { case "1": masterModel.qty1 = masterModel.ipb30; break; case "2": masterModel.qty1 = masterModel.ipb40; break; case "3": masterModel.qty1 = masterModel.ipb50; break; case "4": masterModel.qty1 = masterModel.ipb06; break; } switch (invr522Model.type2) { case "1": masterModel.qty2 = masterModel.ipb30; break; case "2": masterModel.qty2 = masterModel.ipb40; break; case "3": masterModel.qty2 = masterModel.ipb50; break; case "4": masterModel.qty2 = masterModel.ipb06; break; } masterModel.dif_qty = masterModel.qty2 - masterModel.qty1; masterModel.qty1_str = string.Format("{0:N" + masterModel.bej03 + "}", masterModel.qty1); masterModel.qty2_str = string.Format("{0:N" + masterModel.bej03 + "}", masterModel.qty2); masterModel.dif_qty_str = string.Format("{0:N" + masterModel.bej03 + "}", masterModel.dif_qty); } if (invr522Model.dif_yn == "Y")//只顯示差異 { if (resultList.Where(x => x.dif_qty != 0).Count() == 0) { WfShowErrorMsg("查無資料,請重新過濾條件!"); return false; } pReport.RegData("master", resultList.Where(x => x.dif_qty != 0)); } else { pReport.RegData("master", resultList); } pReport.CacheAllData = true; StiGroupFooterBand footerBand1 = (StiGroupFooterBand)pReport.GetComponents()["GroupFooterBand1"]; footerBand1.NewPageAfter = true; footerBand1.ResetPageNumber = true; pReport.Compile(); return true; } catch (Exception ex) { throw ex; } }
protected void SetandoRel() { //Report da stimulsoft Stimulsoft.Report.StiReport Report = new Stimulsoft.Report.StiReport(); //Stimulsoft.Report.Web.StiWebDesigner st1 = new Stimulsoft.Report.Web.StiWebDesigner(); if (Convert.ToString(Request.QueryString["Rel"]) == "frmZurel") { Report.Load(Server.MapPath(@"~/Relatorio/STF/folhafrequencia.mrt")); Report.Compile(); Report["DiasMes"] = TotalDiasMes.ToString(); Report["DiasCumpridos"] = TotalDiasCumprido.ToString(); Report["TotalHorasMes"] = TotalHoraMes.ToString(); Report["HorasCumpridas"] = HorasCumpridas; Report["HorasRealizadas"] = HorasRealizadas; } else if (Convert.ToString(Request.QueryString["Rel"]) == "frmZuxa") { Report.Load(Server.MapPath(@"~/Relatorio/STF/EspelhoPonto.mrt")); Report.Compile(); Report["DiasMes"] = TotalDiasMes.ToString(); Report["DiasCumpridos"] = TotalDiasCumprido.ToString(); Report["TotalHorasMes"] = TotalHoraMes.ToString(); Report["HorasCumpridas"] = HorasCumpridas.ToString(); } else if (Convert.ToString(Request.QueryString["Rel"]) == "frmsitu") { Report.Load(Server.MapPath(@"~/Relatorio/STF/situacaousuario.mrt")); } else if (Convert.ToString(Request.QueryString["Rel"]) == "frmbco") { Report.Load(Server.MapPath(@"~/Relatorio/STF/totalhorasdiarias.mrt")); Report.Compile(); //Report["Teste"] = 932; } else if (Convert.ToString(Request.QueryString["Rel"]) == "frmbcoHoraMes") { Report.Load(Server.MapPath(@"~/Relatorio/STF/bancoHoraMes.mrt")); } else if (Convert.ToString(Request.QueryString["Rel"]) == "frmRelacDia") { Report.Load(Server.MapPath(@"~/Relatorio/STF/relacaopontoDia.mrt")); Report.Compile(); Report["DTInicio"] = INICIO; Report["DTFim"] = FIM; } else if (Convert.ToString(Request.QueryString["Rel"]) == "frmLocalRegistro") { Report.Load(Server.MapPath(@"~/Relatorio/STF/LocalRegistro.mrt")); Report.Compile(); Report["DTInicio"] = INICIO; Report["DTFim"] = FIM; } else if (Convert.ToString(Request.QueryString["Rel"]) == "frmMotivoFalta") { Report.Load(Server.MapPath(@"~/Relatorio/STF/RelacaoMotivoFalta.mrt")); Report.Compile(); Report["DTInicio"] = INICIO; Report["DTFim"] = FIM; } else if (Convert.ToString(Request.QueryString["Rel"]) == "frmfca") { Report.Load(Server.MapPath(@"~/Relatorio/STF/FichaCadastral.mrt")); Report.Compile(); } else if (Convert.ToString(Request.QueryString["Rel"]) == "frmfi") { Report.Load(Server.MapPath(@"~/Relatorio/STF/FichaCadastral.mrt")); Report.Compile(); } else if (Convert.ToString(Request.QueryString["Rel"]) == "frmdesc") { Report.Load(Server.MapPath(@"~/Relatorio/STF/RelRelacaoRegistroPeriodo.mrt")); Report.Compile(); Report["DTInicio"] = INICIO; Report["DTFim"] = FIM; } else if (Convert.ToString(Request.QueryString["Rel"]) == "frmfaltaInjust") { if (RelUtilizado == 0) { Report.Load(Server.MapPath(@"~/Relatorio/STF/RelDataInjustificada.mrt")); } else { Report.Load(Server.MapPath(@"~/Relatorio/STF/RelRegistroAusente.mrt")); } //o Outro Aqui Report.Compile(); Report["DTInicio"] = INICIO; Report["DTFim"] = FIM; } else if (Convert.ToString(Request.QueryString["Rel"]) == "frmAuditRel") { Report.Load(Server.MapPath(@"~/Relatorio/STF/RelatorioAuditoriaJustificativa.mrt")); Report.Compile(); Report["DTInicio"] = INICIO; Report["DTFim"] = FIM; } else if (Convert.ToString(Request.QueryString["Rel"]) == "frmLogMaqRel") { Report.Load(Server.MapPath(@"~/Relatorio/STF/AuditoriaGeralDasConexoes.mrt")); Report.Compile(); } else if (Convert.ToString(Request.QueryString["Rel"]) == "frmInfoMaqRel") { Report.Load(Server.MapPath(@"~/Relatorio/STF/InformacoesMaquinasColetorLocal.mrt")); Report.Compile(); } Report.RegData("DatasetPontoFrequencia", ds); Report.Render(); System.IO.MemoryStream memStream = new System.IO.MemoryStream(); HttpContext.Current.Response.ClearContent(); HttpContext.Current.Response.ClearHeaders(); HttpContext.Current.Response.ContentType = "application/pdf"; HttpContext.Current.Response.AddHeader("Pontoweb.pdf", ""); Stimulsoft.Report.Export.StiPdfExportService Export = new Stimulsoft.Report.Export.StiPdfExportService(); Export.ExportPdf(Report, memStream, Stimulsoft.Report.StiPagesRange.All, 100, 100, false, false, true, true, "", "", Stimulsoft.Report.Export.StiUserAccessPrivileges.All, Stimulsoft.Report.Export.StiPdfEncryptionKeyLength.Bit40, false); Response.ContentType = "application/pdf"; Response.AddHeader("content-disposition", "inline; filename=Pontoweb.pdf"); Response.BinaryWrite(memStream.ToArray()); }
public virtual ActionResult GetReportSnapshot(string fileName, string sourceName, string sourceData) { if (string.IsNullOrEmpty(fileName)) { return(Content("未能获取到打印格式信息!")); } DataTable dt = new DataTable(); if (sourceName == "goods") { dt = BLLFactory <Mst_Goods> .Instance.GetPrint(sourceData);// } if (sourceName == "printInStock") { dt = BLLFactory <PI_Head> .Instance.GetPrint(sourceData); } if (sourceName == "printOutstock") { dt = BLLFactory <SO_Head> .Instance.GetPrint(sourceData); } if (sourceName == "PrintMask") { //将object类强转list集合 List <SO_StockMakeBodyInfo> list = Session["MaskList"] as List <SO_StockMakeBodyInfo>; //实例化dataTable dt = new DataTable(); //给datatable添加列 dt.Columns.Add("F_GoodsName"); dt.Columns.Add("F_SellingPrice"); dt.Columns.Add("F_RealNumber"); dt.Columns.Add("F_Unit"); dt.Columns.Add("F_CargoPositionName"); dt.Columns.Add("F_WarehouseName"); //添加数据 foreach (SO_StockMakeBodyInfo item in list) { DataRow dr = dt.NewRow(); dr["F_GoodsName"] = item.F_GoodsName; dr["F_SellingPrice"] = item.F_SellingPrice; dr["F_RealNumber"] = item.F_RealNumber; dr["F_Unit"] = item.F_Unit; dr["F_RealNumber"] = item.F_RealNumber; dr["F_CargoPositionName"] = item.F_CargoPositionName; dr["F_WarehouseName"] = item.F_WarehouseName; dt.Rows.Add(dr); } } PrintModel model = new PrintModel(); model.fileName = fileName; model.sourceName = "Source"; model.sourceData = dt; // 创建报表对象 Stimulsoft.Report.StiReport report1 = new Stimulsoft.Report.StiReport(); //读取文件 report1.Load(Server.MapPath(string.Format("~/Content/reports/{0}.mrt", model.fileName))); //截止读取 report1.Compile(); if (!string.IsNullOrEmpty(model.sourceName) && model.sourceData != null) { //注册数据源P report1.RegData(model.sourceName, model.sourceData); } //返回报表 return(Stimulsoft.Report.Mvc.StiMvcViewer.GetReportSnapshotResult(report1)); }
protected override bool WfExecReport(Stimulsoft.Report.StiReport pReport) { //DataSet ds; vw_manr311 manr311Model; StringBuilder sbSql = null; string sqlBody = ""; DataTable dtMaster; List <YR.ERP.DAL.YRModel.Reports.Man.Manr311.Master> masterList; List <QueryInfo> queryInfoList; QueryInfo queryModel; string strQueryRange, strWhere; StringBuilder sbQuerySingle = null; List <SqlParameter> sqlParmList; try { if (Vw_Manr311 != null) //他窗引用時 { manr311Model = Vw_Manr311; } else { manr311Model = DrMaster.ToItem <vw_manr311>(); } queryInfoList = new List <QueryInfo>(); #region range 處理 if (!GlobalFn.varIsNull(manr311Model.mfa01)) { queryModel = new QueryInfo(); queryModel.TableName = "mfa_tb"; queryModel.ColumnName = "mfa01"; queryModel.ColumnType = TabMaster.DtSource.Columns["mfa01"].DataType.Name; queryModel.Value = manr311Model.mfa01; queryInfoList.Add(queryModel); } if (!GlobalFn.varIsNull(manr311Model.mfa03)) { queryModel = new QueryInfo(); queryModel.TableName = "mfa_tb"; queryModel.ColumnName = "mfa03"; queryModel.ColumnType = TabMaster.DtSource.Columns["mfa03"].DataType.Name; queryModel.Value = manr311Model.mfa03; queryInfoList.Add(queryModel); } sqlParmList = new List <SqlParameter>(); if (!GlobalFn.varIsNull(manr311Model.mfa06)) { queryModel = new QueryInfo(); queryModel.TableName = "mfa_tb"; queryModel.ColumnName = "mfa06"; queryModel.ColumnType = TabMaster.DtSource.Columns["mfa06"].DataType.Name; queryModel.Value = manr311Model.mfa06; queryInfoList.Add(queryModel); } sqlParmList = new List <SqlParameter>(); strQueryRange = BoMaster.WfGetQueryString(queryInfoList, out sqlParmList); #endregion #region single 處理 sbQuerySingle = new StringBuilder(); if (!GlobalFn.varIsNull(manr311Model.mfa02_s)) { sbQuerySingle.AppendLine("AND mfa02>=@mfa02_s"); sqlParmList.Add(new SqlParameter("@mfa02_s", manr311Model.mfa02_s)); } if (!GlobalFn.varIsNull(manr311Model.mfa02_e)) { sbQuerySingle.AppendLine("AND mfa02<=@mfa02_e"); sqlParmList.Add(new SqlParameter("@mfa02_e", manr311Model.mfa02_e)); } #endregion strWhere = strQueryRange + " " + sbQuerySingle.ToString(); var strSecurity = WfGetSecurityString(); //取得權限字串 if (!GlobalFn.varIsNull(strSecurity)) { strWhere += strSecurity; } //取得單頭 sqlBody = @"SELECT mfa00,mfa01,mfa02,mfa03,mfa04,mfa05, mfa06,mfa07,mfa08, bab02 as mfa01_c, pca02 as mfa03_c, bec02 as mfa04_c,beb02 as mfa05_c, mfb02,mfb03,mfb04,mfb05,mfb06, mfb07,mfb09, ica.ica03 as ica03, bej.bej03 as bej03, '' as mfb05_str, pcb03,pcb04,pcb06,pcb07 FROM mfa_tb LEFT JOIN mfb_tb On mfa01=mfb01 LEFT JOIN baa_tb ON 1=1 LEFT JOIN bab_tb ON substring(mfa01,1,baa06)=bab01 LEFT JOIN pca_tb ON mfa03=pca01 --廠商 LEFT JOIN bec_tb ON mfa04=bec01 --員工 LEFT JOIN beb_tb ON mfa05=beb01 --部門 LEFT JOIN ica_tb ica ON mfb03=ica.ica01 LEFT JOIN bej_tb bej ON mfb06=bej.bej01 LEFT JOIN pcb_tb ON mfa03=pcb01 and mfa07=pcb02 WHERE 1=1 AND mfaconf='Y' AND mfa00='2' "; dtMaster = BoMaster.OfGetDataTable(string.Concat(sqlBody, strWhere), sqlParmList.ToArray()); dtMaster.TableName = "Master"; if (dtMaster == null || dtMaster.Rows.Count == 0) { WfShowErrorMsg("查無資料,請重新過濾條件!"); return(false); } masterList = dtMaster.ToList <Master>(); foreach (Master masterModel in masterList) { masterModel.mfb05_str = string.Format("{0:N" + masterModel.bej03 + "}", masterModel.mfb05);//子件數量 } pReport.RegData(dtMaster); pReport.RegData("Master", masterList); pReport.CacheAllData = true; //處理排序 StiDataBand stiDataBand1 = (StiDataBand)pReport.GetComponents()["DataBand1"]; switch (manr311Model.order_by) { case "1": //1.依出庫日期 stiDataBand1.Sort = new string[] { "ASC", "mfa02" }; break; case "2": //2.依廠商 stiDataBand1.Sort = new string[] { "ASC", "mfa03" }; break; } //處理跳頁 StiGroupFooterBand grouperBand1 = (StiGroupFooterBand)pReport.GetComponents()["GroupFooterBand1"]; if (manr311Model.jump_yn.ToUpper() == "Y") { grouperBand1.NewPageAfter = true; grouperBand1.ResetPageNumber = true; } else { grouperBand1.NewPageAfter = false; grouperBand1.ResetPageNumber = false; } pReport.Compile(); return(true); } catch (Exception ex) { throw ex; } }