protected virtual bool WfExecReport(Stimulsoft.Report.StiReport pReport) { try { return(true); } catch (Exception ex) { throw ex; } }
public MainPage() { if (StiOptions.Silverlight.Themes.CurrentTheme == null) { StiOptions.Silverlight.Themes.CurrentTheme = (StiSilverlightThemes)StiSettings.Get("StimulsoftApplication", "Theme", StiSilverlightThemes.Office2010Silver); } StiThemesHelper.LoadTheme(); InitializeComponent(); stiReport1 = new Stimulsoft.Report.StiReport(); }
/// <summary> /// 報表額外參數要放在這才會有做用 /// </summary> /// <param name="pReport"></param> /// <returns></returns> protected virtual bool WfExecReportEnd(Stimulsoft.Report.StiReport pReport) { try { //pReport["type1Title"] = "XXXXXX"; return(true); } catch (Exception ex) { throw ex; } }
public static StiReport CreateReport(Stream stream, String repName) { var r = new Stimulsoft.Report.StiReport(); r.Load(stream); r.AddReferencedAssemblies(); r.SubstDataSources(); if (!String.IsNullOrEmpty(repName)) { r.ReportName = repName; } return(r); }
private void UserControl_Loaded(object sender, RoutedEventArgs e) { Report = new Stimulsoft.Report.StiReport(); var stream = System.Reflection.Assembly.GetExecutingAssembly().GetManifestResourceStream("CustomViewer.BarCodes.mrt"); Report.Load(stream); stream.Close(); stream.Dispose(); stream = null; btRefresh_Click(null, null); PreviewControl.Report = Report; Init(); }
async private void BlankPage_Loaded(object sender, RoutedEventArgs e) { byte[] buffer = Convert.FromBase64String(reportStr); stiReport1 = new StiReport(); await stiReport1.LoadAsync(buffer); await stiReport1.RenderAsync(); StiComponentsCollection comps = stiReport1.RenderedPages[0].GetComponents(); chart = comps["Chart1"] as StiChart; viewerCotnrol.Report = stiReport1; timer.Start(); }
/// <summary> /// /// </summary> /// <returns></returns> public virtual ActionResult StiReport() { System.Globalization.CultureInfo culture = new System.Globalization.CultureInfo("fa-IR"); // List of persons: // you can change the following list to list of persons that get from database. var persons = new List<Models.Person>() { new Person() {Id = 0, FirstName = "sadar", LastName = "marvati", Gender = true} , new Person() {Id = 1, FirstName = "omid", LastName = "nasri", Gender = true} , new Person() {Id = 2, FirstName = "hana", LastName = "akbari", Gender = false} , new Person() {Id = 3, FirstName = "ali", LastName = "jahani", Gender = true } , new Person() {Id = 4, FirstName = "sara", LastName = "sabori", Gender = false } }; var mainReport = new Stimulsoft.Report.StiReport(); mainReport.Load(Server.MapPath("~/Files/Report.mrt")); mainReport.Compile(); mainReport["DateTimeNow"] = DateTime.UtcNow; mainReport.RegBusinessObject("persons_business", persons); return Stimulsoft.Report.Mvc.StiMvcViewer.GetReportSnapshotResult(mainReport); }
/// <summary> /// /// </summary> /// <returns></returns> public virtual ActionResult StiReport() { System.Globalization.CultureInfo culture = new System.Globalization.CultureInfo("fa-IR"); // List of persons: // you can change the following list to list of persons that get from database. var persons = new List <Models.Person>() { new Person() { Id = 0, FirstName = "sadar", LastName = "marvati", Gender = true } , new Person() { Id = 1, FirstName = "omid", LastName = "nasri", Gender = true } , new Person() { Id = 2, FirstName = "hana", LastName = "akbari", Gender = false } , new Person() { Id = 3, FirstName = "ali", LastName = "jahani", Gender = true } , new Person() { Id = 4, FirstName = "sara", LastName = "sabori", Gender = false } }; var mainReport = new Stimulsoft.Report.StiReport(); mainReport.Load(Server.MapPath("~/Files/Report.mrt")); mainReport.Compile(); mainReport["DateTimeNow"] = DateTime.UtcNow; mainReport.RegBusinessObject("persons_business", persons); return(Stimulsoft.Report.Mvc.StiMvcViewer.GetReportSnapshotResult(mainReport)); }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(Form1)); this.tbName = new System.Windows.Forms.TextBox(); this.tbSurname = new System.Windows.Forms.TextBox(); this.tbEmail = new System.Windows.Forms.TextBox(); this.label1 = new System.Windows.Forms.Label(); this.label2 = new System.Windows.Forms.Label(); this.label3 = new System.Windows.Forms.Label(); this.label5 = new System.Windows.Forms.Label(); this.tbAddress = new System.Windows.Forms.TextBox(); this.button1 = new System.Windows.Forms.Button(); this.button2 = new System.Windows.Forms.Button(); this.stiReport1 = new Stimulsoft.Report.StiReport(); this.label4 = new System.Windows.Forms.Label(); this.dtBirthDay = new System.Windows.Forms.DateTimePicker(); this.label6 = new System.Windows.Forms.Label(); this.rbMale = new System.Windows.Forms.RadioButton(); this.rbFemale = new System.Windows.Forms.RadioButton(); this.groupBox1 = new System.Windows.Forms.GroupBox(); this.button3 = new System.Windows.Forms.Button(); this.groupBox1.SuspendLayout(); this.SuspendLayout(); // // tbName // this.tbName.Location = new System.Drawing.Point(84, 19); this.tbName.Name = "tbName"; this.tbName.Size = new System.Drawing.Size(182, 20); this.tbName.TabIndex = 0; this.tbName.Text = "Name"; // // tbSurname // this.tbSurname.Location = new System.Drawing.Point(84, 43); this.tbSurname.Name = "tbSurname"; this.tbSurname.Size = new System.Drawing.Size(182, 20); this.tbSurname.TabIndex = 1; this.tbSurname.Text = "Surname"; // // tbEmail // this.tbEmail.Location = new System.Drawing.Point(84, 67); this.tbEmail.Name = "tbEmail"; this.tbEmail.Size = new System.Drawing.Size(182, 20); this.tbEmail.TabIndex = 2; this.tbEmail.Text = "*****@*****.**"; // // label1 // this.label1.Location = new System.Drawing.Point(5, 19); this.label1.Name = "label1"; this.label1.Size = new System.Drawing.Size(71, 20); this.label1.TabIndex = 4; this.label1.Text = "Name"; this.label1.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // label2 // this.label2.Location = new System.Drawing.Point(5, 43); this.label2.Name = "label2"; this.label2.Size = new System.Drawing.Size(71, 20); this.label2.TabIndex = 5; this.label2.Text = "Surname"; this.label2.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // label3 // this.label3.Location = new System.Drawing.Point(5, 67); this.label3.Name = "label3"; this.label3.Size = new System.Drawing.Size(71, 20); this.label3.TabIndex = 6; this.label3.Text = "E-mail"; this.label3.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // label5 // this.label5.Location = new System.Drawing.Point(5, 91); this.label5.Name = "label5"; this.label5.Size = new System.Drawing.Size(71, 20); this.label5.TabIndex = 8; this.label5.Text = "Address"; this.label5.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // tbAddress // this.tbAddress.Location = new System.Drawing.Point(84, 91); this.tbAddress.Name = "tbAddress"; this.tbAddress.Size = new System.Drawing.Size(182, 20); this.tbAddress.TabIndex = 3; this.tbAddress.Text = "Address"; // // button1 // this.button1.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Right))); this.button1.Location = new System.Drawing.Point(51, 202); this.button1.Name = "button1"; this.button1.Size = new System.Drawing.Size(75, 26); this.button1.TabIndex = 1; this.button1.Text = "Design"; this.button1.Click += new System.EventHandler(this.button1_Click); // // button2 // this.button2.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Right))); this.button2.Location = new System.Drawing.Point(133, 202); this.button2.Name = "button2"; this.button2.Size = new System.Drawing.Size(75, 26); this.button2.TabIndex = 2; this.button2.Text = "Preview"; this.button2.Click += new System.EventHandler(this.button2_Click); // // stiReport1 // this.stiReport1.CookieContainer = null; this.stiReport1.EngineVersion = Stimulsoft.Report.Engine.StiEngineVersion.EngineV2; this.stiReport1.ReferencedAssemblies = new string[] { "System.Dll", "System.Drawing.Dll", "System.Windows.Forms.Dll", "System.Data.Dll", "System.Xml.Dll", "Stimulsoft.Controls.Dll", "Stimulsoft.Base.Dll", "Stimulsoft.Report.Dll" }; this.stiReport1.ReportAlias = "Report"; this.stiReport1.ReportGuid = "daed7215d2c44878b86b5a0c6b25631c"; this.stiReport1.ReportImage = null; this.stiReport1.ReportName = "Report"; this.stiReport1.ReportSource = null; this.stiReport1.ReportUnit = Stimulsoft.Report.StiReportUnitType.Centimeters; this.stiReport1.ScriptLanguage = Stimulsoft.Report.StiReportLanguageType.CSharp; this.stiReport1.UseProgressInThread = false; // // label4 // this.label4.Location = new System.Drawing.Point(5, 115); this.label4.Name = "label4"; this.label4.Size = new System.Drawing.Size(71, 20); this.label4.TabIndex = 13; this.label4.Text = "Sex"; this.label4.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // dtBirthDay // this.dtBirthDay.Location = new System.Drawing.Point(84, 139); this.dtBirthDay.Name = "dtBirthDay"; this.dtBirthDay.Size = new System.Drawing.Size(182, 20); this.dtBirthDay.TabIndex = 6; // // label6 // this.label6.Location = new System.Drawing.Point(5, 139); this.label6.Name = "label6"; this.label6.Size = new System.Drawing.Size(71, 20); this.label6.TabIndex = 15; this.label6.Text = "Birth Day"; this.label6.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // rbMale // this.rbMale.Checked = true; this.rbMale.Location = new System.Drawing.Point(84, 115); this.rbMale.Name = "rbMale"; this.rbMale.Size = new System.Drawing.Size(48, 24); this.rbMale.TabIndex = 4; this.rbMale.TabStop = true; this.rbMale.Text = "Male"; // // rbFemale // this.rbFemale.Location = new System.Drawing.Point(140, 115); this.rbFemale.Name = "rbFemale"; this.rbFemale.Size = new System.Drawing.Size(104, 24); this.rbFemale.TabIndex = 5; this.rbFemale.Text = "Female"; // // groupBox1 // this.groupBox1.Controls.Add(this.label2); this.groupBox1.Controls.Add(this.rbMale); this.groupBox1.Controls.Add(this.label1); this.groupBox1.Controls.Add(this.tbName); this.groupBox1.Controls.Add(this.rbFemale); this.groupBox1.Controls.Add(this.tbEmail); this.groupBox1.Controls.Add(this.tbAddress); this.groupBox1.Controls.Add(this.tbSurname); this.groupBox1.Controls.Add(this.label5); this.groupBox1.Controls.Add(this.dtBirthDay); this.groupBox1.Controls.Add(this.label3); this.groupBox1.Controls.Add(this.label4); this.groupBox1.Controls.Add(this.label6); this.groupBox1.Location = new System.Drawing.Point(8, 8); this.groupBox1.Name = "groupBox1"; this.groupBox1.Size = new System.Drawing.Size(281, 184); this.groupBox1.TabIndex = 0; this.groupBox1.TabStop = false; this.groupBox1.Text = "Settings"; // // button3 // this.button3.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Right))); this.button3.DialogResult = System.Windows.Forms.DialogResult.Cancel; this.button3.Location = new System.Drawing.Point(215, 202); this.button3.Name = "button3"; this.button3.Size = new System.Drawing.Size(75, 26); this.button3.TabIndex = 3; this.button3.Text = "Close"; this.button3.Click += new System.EventHandler(this.button3_Click); // // Form1 // this.AcceptButton = this.button2; this.AutoScaleBaseSize = new System.Drawing.Size(5, 13); this.CancelButton = this.button3; this.ClientSize = new System.Drawing.Size(297, 235); this.Controls.Add(this.button3); this.Controls.Add(this.groupBox1); this.Controls.Add(this.button2); this.Controls.Add(this.button1); this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedSingle; this.Icon = ((System.Drawing.Icon)(resources.GetObject("$this.Icon"))); this.MaximizeBox = false; this.MinimizeBox = false; this.Name = "Form1"; this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen; this.Text = "Using Report Variables"; this.groupBox1.ResumeLayout(false); this.groupBox1.PerformLayout(); this.ResumeLayout(false); }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(Form1)); this.panel1 = new Stimulsoft.Report.Viewer.StiViewerControl(); this.stiReport1 = new Stimulsoft.Report.StiReport(); this.dataSet1 = new System.Data.DataSet(); ((System.ComponentModel.ISupportInitialize)(this.dataSet1)).BeginInit(); this.SuspendLayout(); // // panel1 // this.panel1.AllowDrop = true; this.panel1.Dock = System.Windows.Forms.DockStyle.Fill; this.panel1.Location = new System.Drawing.Point(0, 0); this.panel1.Name = "panel1"; this.panel1.Report = this.stiReport1; this.panel1.RightToLeft = System.Windows.Forms.RightToLeft.No; this.panel1.ShowZoom = true; this.panel1.Size = new System.Drawing.Size(688, 493); this.panel1.TabIndex = 0; this.panel1.Close += new System.EventHandler(this.panel1_Close); // // stiReport1 // this.stiReport1.CookieContainer = null; this.stiReport1.EngineVersion = Stimulsoft.Report.Engine.StiEngineVersion.EngineV2; this.stiReport1.ReferencedAssemblies = new string[] { "System.Dll", "System.Drawing.Dll", "System.Windows.Forms.Dll", "System.Data.Dll", "System.Xml.Dll", "Stimulsoft.Controls.Dll", "Stimulsoft.Base.Dll", "Stimulsoft.Report.Dll" }; this.stiReport1.ReportAlias = "Report"; this.stiReport1.ReportGuid = "41599dc0625e4d03b314014f8926ee17"; this.stiReport1.ReportImage = null; this.stiReport1.ReportName = "Report"; this.stiReport1.ReportSource = null; this.stiReport1.ReportUnit = Stimulsoft.Report.StiReportUnitType.Centimeters; this.stiReport1.ScriptLanguage = Stimulsoft.Report.StiReportLanguageType.CSharp; this.stiReport1.UseProgressInThread = false; // // dataSet1 // this.dataSet1.DataSetName = "NewDataSet"; this.dataSet1.Locale = new System.Globalization.CultureInfo("ru-RU"); // // Form1 // this.AutoScaleBaseSize = new System.Drawing.Size(5, 13); this.ClientSize = new System.Drawing.Size(688, 493); this.Controls.Add(this.panel1); this.Icon = ((System.Drawing.Icon)(resources.GetObject("$this.Icon"))); this.Name = "Form1"; this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen; this.Text = "Reports Viewer in Right-To-Left"; this.WindowState = System.Windows.Forms.FormWindowState.Maximized; this.Load += new System.EventHandler(this.Form1_Load); ((System.ComponentModel.ISupportInitialize)(this.dataSet1)).EndInit(); this.ResumeLayout(false); }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(Form1)); this.button3 = new System.Windows.Forms.Button(); this.groupBox1 = new System.Windows.Forms.GroupBox(); this.textBox1 = new System.Windows.Forms.TextBox(); this.button2 = new System.Windows.Forms.Button(); this.button1 = new System.Windows.Forms.Button(); this.stiReport1 = new Stimulsoft.Report.StiReport(); this.groupBox1.SuspendLayout(); this.SuspendLayout(); // // button3 // this.button3.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Right))); this.button3.DialogResult = System.Windows.Forms.DialogResult.Cancel; this.button3.Location = new System.Drawing.Point(474, 381); this.button3.Name = "button3"; this.button3.Size = new System.Drawing.Size(150, 48); this.button3.TabIndex = 7; this.button3.Text = "Close"; this.button3.Click += new System.EventHandler(this.button3_Click); // // groupBox1 // this.groupBox1.Controls.Add(this.textBox1); this.groupBox1.Location = new System.Drawing.Point(16, 15); this.groupBox1.Name = "groupBox1"; this.groupBox1.Size = new System.Drawing.Size(608, 349); this.groupBox1.TabIndex = 4; this.groupBox1.TabStop = false; this.groupBox1.Text = "Type Text"; // // textBox1 // this.textBox1.Location = new System.Drawing.Point(16, 30); this.textBox1.Multiline = true; this.textBox1.Name = "textBox1"; this.textBox1.Size = new System.Drawing.Size(576, 300); this.textBox1.TabIndex = 0; this.textBox1.Text = "Sample Text"; // // button2 // this.button2.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Right))); this.button2.Location = new System.Drawing.Point(308, 381); this.button2.Name = "button2"; this.button2.Size = new System.Drawing.Size(150, 48); this.button2.TabIndex = 6; this.button2.Text = "Preview"; this.button2.Click += new System.EventHandler(this.button2_Click); // // button1 // this.button1.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Right))); this.button1.Location = new System.Drawing.Point(142, 381); this.button1.Name = "button1"; this.button1.Size = new System.Drawing.Size(150, 48); this.button1.TabIndex = 5; this.button1.Text = "Design"; this.button1.Click += new System.EventHandler(this.button1_Click); // // stiReport1 // this.stiReport1.CookieContainer = null; this.stiReport1.EngineVersion = Stimulsoft.Report.Engine.StiEngineVersion.EngineV2; this.stiReport1.Key = "1251f444a62b4be883f2b39088f9d32c"; this.stiReport1.ReferencedAssemblies = new string[] { "System.Dll", "System.Drawing.Dll", "System.Windows.Forms.Dll", "System.Data.Dll", "System.Xml.Dll", "Stimulsoft.Controls.Dll", "Stimulsoft.Base.Dll", "Stimulsoft.Report.Dll" }; this.stiReport1.ReportAlias = "Report"; this.stiReport1.ReportGuid = "40db48e618a74c2ba7cc94a6b54a1efd"; this.stiReport1.ReportName = "Report"; this.stiReport1.ReportSource = null; this.stiReport1.ReportUnit = Stimulsoft.Report.StiReportUnitType.Centimeters; this.stiReport1.ScriptLanguage = Stimulsoft.Report.StiReportLanguageType.CSharp; this.stiReport1.StoreImagesInResources = true; this.stiReport1.UseProgressInThread = false; // // Form1 // this.AutoScaleDimensions = new System.Drawing.SizeF(12F, 25F); this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; this.ClientSize = new System.Drawing.Size(638, 445); this.Controls.Add(this.button3); this.Controls.Add(this.groupBox1); this.Controls.Add(this.button2); this.Controls.Add(this.button1); this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedSingle; this.Icon = ((System.Drawing.Icon)(resources.GetObject("$this.Icon"))); this.MaximizeBox = false; this.MinimizeBox = false; this.Name = "Form1"; this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen; this.Text = "Work with Report Components"; this.groupBox1.ResumeLayout(false); this.groupBox1.PerformLayout(); this.ResumeLayout(false); }
protected override bool WfExecReport(Stimulsoft.Report.StiReport pReport) { vw_glar300 glar300Model; StringBuilder sbSql = null; string sqlBody = ""; string sqlOrderBy = ""; DataTable dtMaster; List <Master> masterList; List <QueryInfo> queryInfoList; QueryInfo queryModel; string strQueryRange, strWhere; StringBuilder sbQuerySingle = null; decimal maxPageRows = 5; //每頁限定筆數 List <Master> addMasterList = null; //用來增加空白筆數的集合 List <SqlParameter> sqlParmList; try { if (Vw_Galr300 != null) //他窗引用時 { glar300Model = Vw_Galr300; } else { glar300Model = DrMaster.ToItem <vw_glar300>(); } queryInfoList = new List <QueryInfo>(); #region range 處理 if (!GlobalFn.varIsNull(glar300Model.gfa01)) { queryModel = new QueryInfo(); queryModel.TableName = "gfa_tb"; queryModel.ColumnName = "gfa01"; queryModel.ColumnType = TabMaster.DtSource.Columns["gfa01"].DataType.Name; queryModel.Value = glar300Model.gfa01; queryInfoList.Add(queryModel); } sqlParmList = new List <SqlParameter>(); strQueryRange = BoMaster.WfGetQueryString(queryInfoList, out sqlParmList); #endregion #region single 處理 sbQuerySingle = new StringBuilder(); //他窗引用時,僅查詢單號 if (Vw_Galr300 == null) { if (!GlobalFn.varIsNull(glar300Model.gfa02_s)) { sbQuerySingle.AppendLine("AND gfa02>=@gfa02_s"); sqlParmList.Add(new SqlParameter("@gfa02_s", glar300Model.gfa02_s)); } if (!GlobalFn.varIsNull(glar300Model.gfa02_e)) { sbQuerySingle.AppendLine("AND gfa02<=@gfa02_e"); sqlParmList.Add(new SqlParameter("@gfa02_e", glar300Model.gfa02_e)); } //過帳否 if (glar300Model.gfapost == "1") { sbQuerySingle.AppendLine("AND gfapost='N'"); } else if (glar300Model.gfapost == "2") { sbQuerySingle.AppendLine("AND gfapost='Y'"); } //有效否 if (glar300Model.gfaconf == "1") { sbQuerySingle.AppendLine("AND gfaconf <>'X' "); } else if (glar300Model.gfaconf == "2") { sbQuerySingle.AppendLine("AND gfapost='X' "); } //列印否 if (glar300Model.gfaprno == 1) { sbQuerySingle.AppendLine("AND gfaprno =0"); } else if (glar300Model.gfapost == "2") { sbQuerySingle.AppendLine("AND gfaprno >0 "); } } #endregion strWhere = strQueryRange + " " + sbQuerySingle.ToString(); var strSecurity = WfGetSecurityString(); //取得權限字串 if (!GlobalFn.varIsNull(strSecurity)) { strWhere += strSecurity; } //取得單頭 sqlBody = @"SELECT gfa01,gfa02,gfa03,gfa04,gfa05, gfa06,gfa07,gfa08,gfa09, gfaprno,gfaconf,gfacond,gfaconu, gfapost,gfaposd,gfaposu, gac02 as gfa01_c, gfb02,gfb03,gfb04,gfb05, gfb06,gfb07,gfb08,gfb09,gfb10, gba02 AS gfb03_c, beb03 AS gfb05_c, bek04, gba05 FROM gfa_tb LEFT JOIN gfb_tb ON gfa01=gfb01 LEFT JOIN baa_tb ON 1=1 LEFT JOIN gac_tb ON substring(gfa01,1,baa06)=gac01 LEFT JOIN gba_tb ON gfb03=gba01 LEFT JOIN bek_tb ON gfb08=bek01 LEFT JOIN beb_tb ON gfb05=beb01 WHERE 1=1 "; sqlOrderBy = " ORDER BY gfa01,gfa02"; dtMaster = BoMaster.OfGetDataTable(string.Concat(sqlBody, strWhere, sqlOrderBy), sqlParmList.ToArray()); dtMaster.TableName = "Master"; if (dtMaster == null || dtMaster.Rows.Count == 0) { WfShowErrorMsg("查無資料,請重新過濾條件!"); return(false); } masterList = dtMaster.ToList <Master>(true); //取得本幣資料 var baaModel = BoBas.OfGetBaaModel(); if (baaModel == null) { WfShowErrorMsg("未設定基本參數,請先設定!"); return(false); } var baa04 = baaModel.baa04; var bekUsModel = BoBas.OfGetBekModel(baa04); if (bekUsModel == null) { WfShowErrorMsg("查無本幣資料,請先設定!"); return(false); } //依群組來處理 var gfa01GroupList = from o in masterList group o by o.gfa01 into g select g.First() ; addMasterList = new List <Master>(); foreach (Master groupModel in gfa01GroupList) { var gfa01 = groupModel.gfa01; var groupList = masterList.Where(p => p.gfa01 == gfa01).ToList(); int groupTotalRecs = groupList.Count(); int groupTotalPages = Convert.ToInt16(Math.Ceiling(Convert.ToDecimal(groupTotalRecs / maxPageRows))); for (int i = 0; i < groupList.Count(); i++) { var masterModel = groupList[i]; masterModel.gfa03_str = string.Format("{0:N" + bekUsModel.bek04 + "}", masterModel.gfa03); masterModel.gfa04_str = string.Format("{0:N" + bekUsModel.bek04 + "}", masterModel.gfa04); if (masterModel.gfb06 == "1") { masterModel.gfb07d_str = string.Format("{0:N" + bekUsModel.bek04 + "}", masterModel.gfb07); masterModel.gfb10d_str = string.Format("{0:N" + masterModel.bek04 + "}", masterModel.gfb10); } else { masterModel.gfb07c_str = string.Format("{0:N" + bekUsModel.bek04 + "}", masterModel.gfb07); masterModel.gfb10c_str = string.Format("{0:N" + masterModel.bek04 + "}", masterModel.gfb10); } masterModel.groupPageNo = Convert.ToInt32(Math.Ceiling(Convert.ToDecimal((i + 1) / maxPageRows))); masterModel.groupSeqNo = i + 1; masterModel.groupTotalPages = groupTotalPages; if (masterModel.groupTotalPages != masterModel.groupPageNo) { masterModel.isPageEnd = false; } else { masterModel.isPageEnd = true; } if (i == groupTotalRecs - 1) { //處理要新增的空白筆數 var mod = groupTotalRecs % maxPageRows; if (mod != 0) { var addRecs = maxPageRows - mod; if (addRecs > 0) { for (int j = 0; j < addRecs; j++) { var addMasterModel = new Master(); addMasterModel.gfa01 = masterModel.gfa01; addMasterModel.gfa02 = masterModel.gfa02; addMasterModel.gfa03 = masterModel.gfa03; addMasterModel.gfa04 = masterModel.gfa04; addMasterModel.gfa05 = masterModel.gfa05; addMasterModel.gfa06 = masterModel.gfa06; addMasterModel.gfa07 = masterModel.gfa07; addMasterModel.gfa08 = masterModel.gfa08; addMasterModel.gfa09 = masterModel.gfa09; addMasterModel.gfaprno = masterModel.gfaprno; addMasterModel.gfaconf = masterModel.gfaconf; addMasterModel.gfacond = masterModel.gfacond; addMasterModel.gfaconu = masterModel.gfaconu; addMasterModel.gfapost = masterModel.gfapost; addMasterModel.gfaposd = masterModel.gfaposd; addMasterModel.gfaposu = masterModel.gfaposu; addMasterModel.gfa01_c = masterModel.gfa01_c; addMasterModel.gfb02 = 0; addMasterModel.gfb03 = ""; addMasterModel.gfb04 = ""; addMasterModel.gfb05 = ""; addMasterModel.gfb06 = ""; addMasterModel.gfb07 = 0; addMasterModel.gfb08 = ""; addMasterModel.gfb09 = 0; addMasterModel.gfb10 = 0; addMasterModel.gfb03_c = ""; addMasterModel.gfb05_c = ""; addMasterModel.bek04 = 0; addMasterModel.gba05 = ""; addMasterModel.gfa03_str = masterModel.gfa03_str; addMasterModel.gfa04_str = masterModel.gfa04_str; addMasterModel.gfb07c_str = ""; addMasterModel.gfb07d_str = ""; addMasterModel.gfb10c_str = ""; addMasterModel.gfb10d_str = ""; addMasterModel.groupPageNo = masterModel.groupPageNo; addMasterModel.groupTotalPages = masterModel.groupTotalPages; addMasterModel.groupSeqNo = i + j + 2; addMasterModel.isPageEnd = masterModel.isPageEnd; addMasterList.Add(addMasterModel); } } } } } } if (addMasterList != null && addMasterList.Count > 0) { masterList.AddRange(addMasterList); } pReport.RegData("Master", masterList); pReport.CacheAllData = true; ////處理跳頁 //StiGroupFooterBand footerBand1 = (StiGroupFooterBand)pReport.GetComponents()["GroupFooterBand1"]; //if (glar300Model.jump_yn.ToUpper() == "Y") //{ // footerBand1.NewPageAfter = true; // footerBand1.ResetPageNumber = true; //} //else //{ // footerBand1.NewPageAfter = false; // footerBand1.ResetPageNumber = false; //} return(true); } catch (Exception ex) { throw ex; } }
public FrmReportDisplayBase(StiReport report) { InitializeComponent(); this.stiReport = report; this.stiViewerControl1.Report = stiReport; }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(Form1)); this.button3 = new System.Windows.Forms.Button(); this.button2 = new System.Windows.Forms.Button(); this.button1 = new System.Windows.Forms.Button(); this.stiUserData1 = new Stimulsoft.Report.Dictionary.StiUserData(); this.stiReport1 = new Stimulsoft.Report.StiReport(); this.SuspendLayout(); // // button3 // this.button3.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Right))); this.button3.DialogResult = System.Windows.Forms.DialogResult.Cancel; this.button3.Location = new System.Drawing.Point(218, 42); this.button3.Name = "button3"; this.button3.Size = new System.Drawing.Size(85, 26); this.button3.TabIndex = 11; this.button3.Text = "Close"; this.button3.Click += new System.EventHandler(this.button3_Click); // // button2 // this.button2.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Right))); this.button2.Location = new System.Drawing.Point(126, 42); this.button2.Name = "button2"; this.button2.Size = new System.Drawing.Size(85, 26); this.button2.TabIndex = 10; this.button2.Text = "Preview"; this.button2.Click += new System.EventHandler(this.button2_Click); // // button1 // this.button1.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Right))); this.button1.Location = new System.Drawing.Point(34, 42); this.button1.Name = "button1"; this.button1.Size = new System.Drawing.Size(85, 26); this.button1.TabIndex = 9; this.button1.Text = "Design"; this.button1.Click += new System.EventHandler(this.button1_Click); // // stiUserData1 // this.stiUserData1.Columns.AddRange(new Stimulsoft.Report.Dictionary.StiDataColumn[] { new Stimulsoft.Report.Dictionary.StiDataColumn("Name", "Name", "Name", typeof(object), null), new Stimulsoft.Report.Dictionary.StiDataColumn("ReturnType", "ReturnType", "ReturnType", typeof(object), null), new Stimulsoft.Report.Dictionary.StiDataColumn("IsStatic", "IsStatic", "IsStatic", typeof(object), null), new Stimulsoft.Report.Dictionary.StiDataColumn("Parameters", "Parameters", "Parameters", typeof(object), null) }); this.stiUserData1.Count = 10; this.stiUserData1.GetData += new Stimulsoft.Report.Dictionary.StiUserGetDataEventHandler(this.stiUserData1_GetData); // // stiReport1 // this.stiReport1.CookieContainer = null; this.stiReport1.EngineVersion = Stimulsoft.Report.Engine.StiEngineVersion.EngineV2; this.stiReport1.ReferencedAssemblies = new string[] { "System.Dll", "System.Drawing.Dll", "System.Windows.Forms.Dll", "System.Data.Dll", "System.Xml.Dll", "Stimulsoft.Controls.Dll", "Stimulsoft.Base.Dll", "Stimulsoft.Report.Dll" }; this.stiReport1.ReportAlias = "Report"; this.stiReport1.ReportGuid = "9004eb010eec44b0925867c926808ffa"; this.stiReport1.ReportImage = null; this.stiReport1.ReportName = "Report"; this.stiReport1.ReportSource = null; this.stiReport1.ReportUnit = Stimulsoft.Report.StiReportUnitType.Centimeters; this.stiReport1.ScriptLanguage = Stimulsoft.Report.StiReportLanguageType.CSharp; this.stiReport1.UseProgressInThread = false; // // Form1 // this.AutoScaleBaseSize = new System.Drawing.Size(5, 13); this.ClientSize = new System.Drawing.Size(334, 111); this.Controls.Add(this.button3); this.Controls.Add(this.button2); this.Controls.Add(this.button1); this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedSingle; this.Icon = ((System.Drawing.Icon)(resources.GetObject("$this.Icon"))); this.MaximizeBox = false; this.Name = "Form1"; this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen; this.Text = "User Data in Reports"; this.ResumeLayout(false); }
/// <summary> /// 報表額外參數要放在這才會有做用 /// </summary> /// <param name="pReport"></param> /// <returns></returns> protected override bool WfExecReportEnd(Stimulsoft.Report.StiReport pReport) { vw_glar311 glar311Model = null; try { glar311Model = DrMaster.ToItem <vw_glar311>(); if (!GlobalFn.varIsNull(glar311Model.order1)) { pReport["order1"] = glar311Model.order1; switch (glar311Model.order1) { case "1": pReport["order1_c"] = "傳票編號"; break; case "2": pReport["order1_c"] = "傳票日期"; break; case "3": pReport["order1_c"] = "科目編號"; break; case "4": pReport["order1_c"] = "部門編號"; break; case "5": pReport["order1_c"] = "傳票項次"; break; case "6": pReport["order1_c"] = "借貸方"; break; } } if (!GlobalFn.varIsNull(glar311Model.order2)) { pReport["order2"] = glar311Model.order2; switch (glar311Model.order2) { case "1": pReport["order2_c"] = "傳票編號"; break; case "2": pReport["order2_c"] = "傳票日期"; break; case "3": pReport["order2_c"] = "科目編號"; break; case "4": pReport["order2_c"] = "部門編號"; break; case "5": pReport["order2_c"] = "傳票項次"; break; case "6": pReport["order2_c"] = "借貸方"; break; } } if (!GlobalFn.varIsNull(glar311Model.order3)) { pReport["order3"] = glar311Model.order3; switch (glar311Model.order3) { case "1": pReport["order3"] = "傳票編號"; break; case "2": pReport["order3"] = "傳票日期"; break; case "3": pReport["order3"] = "科目編號"; break; case "4": pReport["order3"] = "部門編號"; break; case "5": pReport["order3"] = "傳票項次"; break; case "6": pReport["order3"] = "借貸方"; break; } } return(true); } catch (Exception ex) { throw ex; } }
protected override bool WfExecReport(Stimulsoft.Report.StiReport pReport) { vw_glar301 glar301Model; StringBuilder sbSql = null; string sqlBody = ""; string sqlOrderBy = ""; DataTable dtMaster; List <Master> masterList; List <QueryInfo> queryInfoList; QueryInfo queryModel; string strQueryRange, strWhere; StringBuilder sbQuerySingle = null; List <SqlParameter> sqlParmList; try { if (Vw_Galr301 != null) //他窗引用時 { glar301Model = Vw_Galr301; } else { glar301Model = DrMaster.ToItem <vw_glar301>(); } queryInfoList = new List <QueryInfo>(); #region range 處理 if (!GlobalFn.varIsNull(glar301Model.gfa01)) { queryModel = new QueryInfo(); queryModel.TableName = "gfa_tb"; queryModel.ColumnName = "gfa01"; queryModel.ColumnType = TabMaster.DtSource.Columns["gfa01"].DataType.Name; queryModel.Value = glar301Model.gfa01; queryInfoList.Add(queryModel); } sqlParmList = new List <SqlParameter>(); strQueryRange = BoMaster.WfGetQueryString(queryInfoList, out sqlParmList); #endregion #region single 處理 sbQuerySingle = new StringBuilder(); if (Vw_Galr301 == null) { if (!GlobalFn.varIsNull(glar301Model.gfa02_s)) { sbQuerySingle.AppendLine("AND gfa02>=@gfa02_s"); sqlParmList.Add(new SqlParameter("@gfa02_s", glar301Model.gfa02_s)); } if (!GlobalFn.varIsNull(glar301Model.gfa02_e)) { sbQuerySingle.AppendLine("AND gfa02<=@gfa02_e"); sqlParmList.Add(new SqlParameter("@gfa02_e", glar301Model.gfa02_e)); } //過帳否 if (glar301Model.gfapost == "1") { sbQuerySingle.AppendLine("AND gfapost='N'"); } else if (glar301Model.gfapost == "2") { sbQuerySingle.AppendLine("AND gfapost='Y'"); } //有效否 if (glar301Model.gfaconf == "1") { sbQuerySingle.AppendLine("AND gfaconf <>'X' "); } else if (glar301Model.gfaconf == "2") { sbQuerySingle.AppendLine("AND gfapost='X' "); } //列印否 if (glar301Model.gfaprno == 1) { sbQuerySingle.AppendLine("AND gfaprno =0"); } else if (glar301Model.gfapost == "2") { sbQuerySingle.AppendLine("AND gfaprno >0 "); } } #endregion strWhere = strQueryRange + " " + sbQuerySingle.ToString(); var strSecurity = WfGetSecurityString(); //取得權限字串 if (!GlobalFn.varIsNull(strSecurity)) { strWhere += strSecurity; } //取得單頭 sqlBody = @"SELECT gfa01,gfa02,gfa03,gfa04,gfa05, gfa06,gfa07,gfa08,gfa09, gfaprno,gfaconf,gfacond,gfaconu, gfapost,gfaposd,gfaposu, gfacreu,gfacred, gac02 as gfa01_c, gfb02,gfb03,gfb04,gfb05, gfb06,gfb07,gfb08,gfb09,gfb10, gba02 AS gfb03_c, beb03 AS gfb05_c, bek04, gba05 FROM gfa_tb LEFT JOIN gfb_tb ON gfa01=gfb01 LEFT JOIN baa_tb ON 1=1 LEFT JOIN gac_tb ON substring(gfa01,1,baa06)=gac01 LEFT JOIN gba_tb ON gfb03=gba01 LEFT JOIN bek_tb ON gfb08=bek01 LEFT JOIN beb_tb ON gfb05=beb01 WHERE 1=1 "; sqlOrderBy = " ORDER BY gfa01,gfa02"; dtMaster = BoMaster.OfGetDataTable(string.Concat(sqlBody, strWhere, sqlOrderBy), sqlParmList.ToArray()); dtMaster.TableName = "Master"; if (dtMaster == null || dtMaster.Rows.Count == 0) { WfShowErrorMsg("查無資料,請重新過濾條件!"); return(false); } masterList = dtMaster.ToList <Master>(true); //取得本幣資料 var baaModel = BoBas.OfGetBaaModel(); if (baaModel == null) { WfShowErrorMsg("未設定基本參數,請先設定!"); return(false); } var baa04 = baaModel.baa04; var bekUsModel = BoBas.OfGetBekModel(baa04); if (bekUsModel == null) { WfShowErrorMsg("查無本幣資料,請先設定!"); return(false); } masterList = dtMaster.ToList <Master>(true); foreach (Master masterModel in masterList) { masterModel.gfa03_str = string.Format("{0:N" + bekUsModel.bek04 + "}", masterModel.gfa03); masterModel.gfa04_str = string.Format("{0:N" + bekUsModel.bek04 + "}", masterModel.gfa04); masterModel.gfb07_str = string.Format("{0:N" + bekUsModel.bek04 + "}", masterModel.gfb07); masterModel.gfb10_str = string.Format("{0:N" + masterModel.bek04 + "}", masterModel.gfb10); } pReport.RegData("Master", masterList); pReport.CacheAllData = true; ////處理跳頁 //StiGroupFooterBand footerBand1 = (StiGroupFooterBand)pReport.GetComponents()["GroupFooterBand1"]; //if (glar300Model.jump_yn.ToUpper() == "Y") //{ // footerBand1.NewPageAfter = true; // footerBand1.ResetPageNumber = true; //} //else //{ // footerBand1.NewPageAfter = false; // footerBand1.ResetPageNumber = false; //} return(true); } catch (Exception ex) { throw ex; } }
protected override bool WfExecReport(Stimulsoft.Report.StiReport pReport) { vw_glar321 glar321Model; string sqlBody = ""; string sqlOrderBy = ""; DataTable dtMaster; List <Master> masterList; List <QueryInfo> queryInfoList; QueryInfo queryModel; string strQueryRange, strWhere; StringBuilder sbQuerySingle = null; List <SqlParameter> sqlParmList; string sqlDistinct = "";//取得會科 DataTable dtDistinct = null; try { glar321Model = DrMaster.ToItem <vw_glar321>(); queryInfoList = new List <QueryInfo>(); sqlParmList = new List <SqlParameter>(); #region range 處理 if (!GlobalFn.varIsNull(glar321Model.gfb03)) { queryModel = new QueryInfo(); queryModel.TableName = "gba_tb"; queryModel.ColumnName = "gba01"; queryModel.ColumnType = TabMaster.DtSource.Columns["gba01"].DataType.Name; queryModel.Value = glar321Model.gfb03; queryInfoList.Add(queryModel); } strQueryRange = BoMaster.WfGetQueryString(queryInfoList, out sqlParmList); #endregion //strWhere = strQueryRange + " " + sbQuerySingle.ToString(); //var strSecurity = WfGetSecurityString(); //取得權限字串 //if (!GlobalFn.varIsNull(strSecurity)) // strWhere += strSecurity; //無異動科目列印時,以會計科目來處理 if (glar321Model.c1 == "Y") { sqlDistinct = @"SELECT gba01 FROM gba_tb WHERE gba06 in ('1','3') "; strWhere = string.Concat(sbQuerySingle.ToString()); } else //以期間內的傳票資料做為處理來源 { sqlDistinct = @"SELECT gba01 FROM gfa_tb INNER JOIN gfb_tb ON gfa01=gfb01 INNER JOIN gba_tb on gfb03=gba01 WHERE gba06 in ('1','3') "; #region single 處理 sbQuerySingle = new StringBuilder(); if (!GlobalFn.varIsNull(glar321Model.gfa02_s)) { sbQuerySingle.AppendLine("AND gfa02>=@gfa02_s"); sqlParmList.Add(new SqlParameter("@gfa02_s", glar321Model.gfa02_s)); } if (!GlobalFn.varIsNull(glar321Model.gfa02_e)) { sbQuerySingle.AppendLine("AND gfa02<=@gfa02_e"); sqlParmList.Add(new SqlParameter("@gfa02_e", glar321Model.gfa02_e)); } #endregion strWhere = string.Concat(sbQuerySingle.ToString(), strQueryRange); } sqlOrderBy = " ORDER BY gba01"; dtDistinct = BoMaster.OfGetDataTable(string.Concat(sqlDistinct, strWhere, sqlOrderBy), sqlParmList.ToArray()); if (dtDistinct == null || dtDistinct.Rows.Count == 0) { WfShowErrorMsg("查無資料!"); return(false); } foreach (DataRow drDistinct in dtDistinct.Rows) { var gba01 = drDistinct[0].ToString(); } //處理排序 //switch (glar321Model.order_by) //{ // case "1"://1.依借出日期 // sqlOrderBy = " ORDER BY ila02"; // break; // case "2"://2.依客戶 // sqlOrderBy = " ORDER BY ila03"; // break; //} //dtMaster.TableName = "Master"; //if (dtMaster == null || dtMaster.Rows.Count == 0) //{ // WfShowErrorMsg("查無資料,請重新過濾條件!"); // return false; //} //masterList = dtMaster.ToList<Master>(true); //foreach (Master masterModel in masterList) //{ // masterModel.ilb05_str = string.Format("{0:N" + masterModel.bej03 + "}", masterModel.ilb05);//數量 //} //pReport.RegData("Master", masterList); //pReport.CacheAllData = true; //////處理跳頁 //StiGroupFooterBand footerBand1 = (StiGroupFooterBand)pReport.GetComponents()["GroupFooterBand1"]; //if (invr401Model.jump_yn.ToUpper() == "Y") //{ // footerBand1.NewPageAfter = true; // footerBand1.ResetPageNumber = true; //} //else //{ // footerBand1.NewPageAfter = false; // footerBand1.ResetPageNumber = false; //} return(true); } catch (Exception ex) { throw ex; } }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(Form1)); this.button1 = new System.Windows.Forms.Button(); this.stiReport1 = new Stimulsoft.Report.StiReport(); this.lbCountries = new System.Windows.Forms.ListBox(); this.stiPreviewControl1 = new Stimulsoft.Report.Viewer.StiViewerControl(); this.SuspendLayout(); // // button1 // this.button1.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Right))); this.button1.Location = new System.Drawing.Point(492, 409); this.button1.Name = "button1"; this.button1.Size = new System.Drawing.Size(75, 26); this.button1.TabIndex = 1; this.button1.Text = "Design"; this.button1.Click += new System.EventHandler(this.button1_Click); // // stiReport1 // this.stiReport1.CookieContainer = null; this.stiReport1.EngineVersion = Stimulsoft.Report.Engine.StiEngineVersion.EngineV2; this.stiReport1.ReferencedAssemblies = new string[] { "System.Dll", "System.Drawing.Dll", "System.Windows.Forms.Dll", "System.Data.Dll", "System.Xml.Dll", "Stimulsoft.Base.Dll", "Stimulsoft.Report.Dll" }; this.stiReport1.ReportAlias = "Report"; this.stiReport1.ReportAuthor = null; this.stiReport1.ReportDescription = null; this.stiReport1.ReportGuid = "4533be36b343412b94379b945c0209fe"; this.stiReport1.ReportImage = null; this.stiReport1.ReportName = "Report"; this.stiReport1.ReportSource = resources.GetString("stiReport1.ReportSource"); this.stiReport1.ReportUnit = Stimulsoft.Report.StiReportUnitType.Centimeters; this.stiReport1.ScriptLanguage = Stimulsoft.Report.StiReportLanguageType.CSharp; this.stiReport1.UseProgressInThread = false; // // lbCountries // this.lbCountries.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) | System.Windows.Forms.AnchorStyles.Left))); this.lbCountries.IntegralHeight = false; this.lbCountries.Items.AddRange(new object[] { "Brazil", "Canada", "Denmark", "Finland", "France", "Germany", "Ireland", "Italy", "Mexico", "Norway", "Poland", "Portugal", "Spain", "Sweden", "Switzerland", "UK", "USA", "Venezuela" }); this.lbCountries.Location = new System.Drawing.Point(8, 8); this.lbCountries.Name = "lbCountries"; this.lbCountries.Size = new System.Drawing.Size(232, 392); this.lbCountries.TabIndex = 0; this.lbCountries.SelectedIndexChanged += new System.EventHandler(this.lbCountries_SelectedIndexChanged); // // stiPreviewControl1 // this.stiPreviewControl1.AllowDrop = true; this.stiPreviewControl1.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) | System.Windows.Forms.AnchorStyles.Left) | System.Windows.Forms.AnchorStyles.Right))); this.stiPreviewControl1.Location = new System.Drawing.Point(240, 8); this.stiPreviewControl1.Name = "stiPreviewControl1"; this.stiPreviewControl1.Report = null; this.stiPreviewControl1.RightToLeft = System.Windows.Forms.RightToLeft.No; this.stiPreviewControl1.ShowBookmarksPanel = false; this.stiPreviewControl1.ShowCloseButton = false; this.stiPreviewControl1.ShowContextMenu = false; this.stiPreviewControl1.ShowEditor = false; this.stiPreviewControl1.ShowExport = false; this.stiPreviewControl1.ShowFind = false; this.stiPreviewControl1.ShowHorScrollBar = false; this.stiPreviewControl1.ShowOpen = false; this.stiPreviewControl1.ShowPageControl = false; this.stiPreviewControl1.ShowPageDelete = false; this.stiPreviewControl1.ShowPageDesign = false; this.stiPreviewControl1.ShowPageNew = false; this.stiPreviewControl1.ShowPageSize = false; this.stiPreviewControl1.ShowPageViewMode = false; this.stiPreviewControl1.ShowPrint = false; this.stiPreviewControl1.ShowSave = false; this.stiPreviewControl1.ShowSendEMail = false; this.stiPreviewControl1.ShowStatusBar = false; this.stiPreviewControl1.ShowThumbsPanel = false; this.stiPreviewControl1.ShowToolbar = false; this.stiPreviewControl1.ShowVertScrollBar = false; this.stiPreviewControl1.ShowViewModeContinuous = false; this.stiPreviewControl1.ShowViewModeMultiplePages = false; this.stiPreviewControl1.ShowViewModeSinglePage = false; this.stiPreviewControl1.ShowZoom = false; this.stiPreviewControl1.ShowZoomMultiplePages = false; this.stiPreviewControl1.ShowZoomOnePage = false; this.stiPreviewControl1.ShowZoomPageWidth = false; this.stiPreviewControl1.ShowZoomTwoPages = false; this.stiPreviewControl1.Size = new System.Drawing.Size(328, 392); this.stiPreviewControl1.TabIndex = 3; this.stiPreviewControl1.ThumbsPanelEnabled = false; // // Form1 // this.AutoScaleBaseSize = new System.Drawing.Size(5, 13); this.ClientSize = new System.Drawing.Size(576, 445); this.Controls.Add(this.stiPreviewControl1); this.Controls.Add(this.button1); this.Controls.Add(this.lbCountries); this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedDialog; this.Icon = ((System.Drawing.Icon)(resources.GetObject("$this.Icon"))); this.Name = "Form1"; this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen; this.Text = "Reports with SQL Parameters"; this.WindowState = System.Windows.Forms.FormWindowState.Maximized; this.ResumeLayout(false); }
protected virtual Boolean WfToolbarExecute() { BindingMaster.EndEdit(); string filePath = ""; try { this.errorProvider.Clear(); if (!TabMaster.IsAutoExecuted) //不做條件檢查 --主要由他窗引用 { if (this.WfFormCheck() == false) { //WfRollback(); return(false); } if (this.WfAfterFormCheck() == false) { //WfRollback(); return(false); } } if (GlobalFn.varIsNull(TabMaster.ReportName)) { WfShowErrorMsg("未設定來源報表"); } filePath = Application.StartupPath + @"\reports\" + TabMaster.ReportName; if (!File.Exists(filePath)) { WfShowErrorMsg("無此來源報表路徑!"); } Stimulsoft.Report.StiReport rpt = new Stimulsoft.Report.StiReport(); rpt.Load(filePath); rpt.ReportName = this.AdoModel.ado10; //產生資料來源 if (this.WfExecReport(rpt) == false) { //WfRollback(); return(false); } rpt.Compile(); rpt["ReportId"] = this.StrFormID; rpt["CompNo"] = this.LoginInfo.CompNo; rpt["CompNameA"] = this.LoginInfo.CompNameA; rpt["DeptNo"] = this.LoginInfo.DeptNo; rpt["DeptName"] = this.LoginInfo.DeptName; rpt["UserNo"] = this.LoginInfo.UserNo; rpt["UserName"] = this.LoginInfo.UserName; if (WfExecReportEnd(rpt) == false) { return(false); } FrmReportDisplayBase rptDisplayBase = new FrmReportDisplayBase(rpt); //rptDisplayBase.stiViewerControl1.ClickPrintButton += stiViewerControl1_ClickPrintButton; //rptDisplayBase.stiViewerControl1.ClickPrintButton += new System.EventHandler(this.stiViewerControl1_ClickPrintButton); rptDisplayBase.stiViewerControl1.Report.CompiledReport.Printed += new EventHandler(report_Print); rptDisplayBase.Show(); if (TabMaster.IsCloseAfterExecuted) { this.Close(); } //if (TabMaster.IsCloseAfterExecuted) // this.Close(); } catch (Exception ex) { throw ex; } finally { //this.Cursor = Cursors.Default; //改到工具列處理 } return(true); }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(Form1)); this.button2 = new System.Windows.Forms.Button(); this.button3 = new System.Windows.Forms.Button(); this.button1 = new System.Windows.Forms.Button(); this.stiReport1 = new Stimulsoft.Report.StiReport(); this.SuspendLayout(); // // button2 // this.button2.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Right))); this.button2.Location = new System.Drawing.Point(125, 43); this.button2.Name = "button2"; this.button2.Size = new System.Drawing.Size(75, 26); this.button2.TabIndex = 6; this.button2.Text = "Preview"; this.button2.Click += new System.EventHandler(this.button2_Click); // // button3 // this.button3.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Right))); this.button3.DialogResult = System.Windows.Forms.DialogResult.Cancel; this.button3.Location = new System.Drawing.Point(208, 43); this.button3.Name = "button3"; this.button3.Size = new System.Drawing.Size(75, 26); this.button3.TabIndex = 7; this.button3.Text = "Close"; this.button3.Click += new System.EventHandler(this.button3_Click); // // button1 // this.button1.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Right))); this.button1.Location = new System.Drawing.Point(42, 43); this.button1.Name = "button1"; this.button1.Size = new System.Drawing.Size(75, 26); this.button1.TabIndex = 5; this.button1.Text = "Design"; this.button1.Click += new System.EventHandler(this.button1_Click); // // stiReport1 // this.stiReport1.CookieContainer = null; this.stiReport1.EngineVersion = Stimulsoft.Report.Engine.StiEngineVersion.EngineV2; this.stiReport1.ReferencedAssemblies = new string[] { "System.Dll", "System.Drawing.Dll", "System.Windows.Forms.Dll", "System.Data.Dll", "System.Xml.Dll", "Stimulsoft.Controls.Dll", "Stimulsoft.Base.Dll", "Stimulsoft.Report.Dll" }; this.stiReport1.ReportAlias = "Report"; this.stiReport1.ReportGuid = "e35ed5d9964044c8933aaf59baa965c0"; this.stiReport1.ReportImage = null; this.stiReport1.ReportName = "Report"; this.stiReport1.ReportSource = null; this.stiReport1.ReportUnit = Stimulsoft.Report.StiReportUnitType.Centimeters; this.stiReport1.ScriptLanguage = Stimulsoft.Report.StiReportLanguageType.CSharp; this.stiReport1.UseProgressInThread = false; // // Form1 // this.AutoScaleBaseSize = new System.Drawing.Size(5, 13); this.ClientSize = new System.Drawing.Size(320, 117); this.Controls.Add(this.button2); this.Controls.Add(this.button3); this.Controls.Add(this.button1); this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedSingle; this.Icon = ((System.Drawing.Icon)(resources.GetObject("$this.Icon"))); this.MaximizeBox = false; this.Name = "Form1"; this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen; this.Text = "Live Reports"; this.ResumeLayout(false); }
protected override bool WfExecReport(Stimulsoft.Report.StiReport pReport) { vw_glar311 glar311Model; StringBuilder sbSql = null; string sqlBody = ""; string sqlOrderBy = ""; DataTable dtMaster; List <Master> masterList; List <QueryInfo> queryInfoList; QueryInfo queryModel; string strQueryRange, strWhere; StringBuilder sbQuerySingle = null; List <SqlParameter> sqlParmList; try { glar311Model = DrMaster.ToItem <vw_glar311>(); queryInfoList = new List <QueryInfo>(); #region range 處理 if (!GlobalFn.varIsNull(glar311Model.gfa01)) { queryModel = new QueryInfo(); queryModel.TableName = "gfa_tb"; queryModel.ColumnName = "gfa01"; queryModel.ColumnType = TabMaster.DtSource.Columns["gfa01"].DataType.Name; queryModel.Value = glar311Model.gfa01; queryInfoList.Add(queryModel); } sqlParmList = new List <SqlParameter>(); strQueryRange = BoMaster.WfGetQueryString(queryInfoList, out sqlParmList); #endregion #region single 處理 sbQuerySingle = new StringBuilder(); if (!GlobalFn.varIsNull(glar311Model.gfa02_s)) { sbQuerySingle.AppendLine("AND gfa02>=@gfa02_s"); sqlParmList.Add(new SqlParameter("@gfa02_s", glar311Model.gfa02_s)); } if (!GlobalFn.varIsNull(glar311Model.gfa02_e)) { sbQuerySingle.AppendLine("AND gfa02<=@gfa02_e"); sqlParmList.Add(new SqlParameter("@gfa02_e", glar311Model.gfa02_e)); } //過帳否 if (glar311Model.gfapost == "1") { sbQuerySingle.AppendLine("AND gfapost='N'"); } else if (glar311Model.gfapost == "2") { sbQuerySingle.AppendLine("AND gfapost='Y'"); } //有效否 if (glar311Model.gfaconf == "1") { sbQuerySingle.AppendLine("AND gfaconf <>'X' "); } else if (glar311Model.gfaconf == "2") { sbQuerySingle.AppendLine("AND gfapost='X' "); } #endregion strWhere = strQueryRange + " " + sbQuerySingle.ToString(); var strSecurity = WfGetSecurityString(); //取得權限字串 if (!GlobalFn.varIsNull(strSecurity)) { strWhere += strSecurity; } //取得單頭 sqlBody = @"SELECT gfa01,gfa02,gfa03,gfa04,gfa05, gfa06,gfa07,gfa08,gfa09, gfaprno,gfaconf,gfacond,gfaconu, gfapost,gfaposd,gfaposu, gfacreu,gfacred, gac02 as gfa01_c, gfb02,gfb03,gfb04,gfb05, gfb06,gfb07,gfb08,gfb09,gfb10, gba02 AS gfb03_c, beb03 AS gfb05_c, bek04, gba05 FROM gfa_tb LEFT JOIN gfb_tb ON gfa01=gfb01 LEFT JOIN baa_tb ON 1=1 LEFT JOIN gac_tb ON substring(gfa01,1,baa06)=gac01 LEFT JOIN gba_tb ON gfb03=gba01 LEFT JOIN bek_tb ON gfb08=bek01 LEFT JOIN beb_tb ON gfb05=beb01 WHERE 1=1 "; #region 排序處理 if (!GlobalFn.varIsNull(glar311Model.order1)) { switch (glar311Model.order1) { case "1": sqlOrderBy = "ORDER BY gfa01"; break; case "2": sqlOrderBy = "ORDER BY gfa02"; break; case "3": sqlOrderBy = "ORDER BY gfb03"; break; case "4": sqlOrderBy = "ORDER BY gfb05"; break; case "5": sqlOrderBy = "ORDER BY gfb02"; break; case "6": sqlOrderBy = "ORDER BY gfa06"; break; } } if (!GlobalFn.varIsNull(glar311Model.order2)) { if (GlobalFn.varIsNull(sqlOrderBy)) { switch (glar311Model.order2) { case "1": sqlOrderBy = "ORDER BY gfa01"; break; case "2": sqlOrderBy = "ORDER BY gfa02"; break; case "3": sqlOrderBy = "ORDER BY gfb03"; break; case "4": sqlOrderBy = "ORDER BY gfb05"; break; case "5": sqlOrderBy = "ORDER BY gfb02"; break; case "6": sqlOrderBy = "ORDER BY gfa06"; break; } } else { switch (glar311Model.order2) { case "1": sqlOrderBy += ",gfa01"; break; case "2": sqlOrderBy += ",gfa02"; break; case "3": sqlOrderBy += ",gfb03"; break; case "4": sqlOrderBy += ",gfb05"; break; case "5": sqlOrderBy += ",gfb02"; break; case "6": sqlOrderBy += ",gfa06"; break; } } } if (!GlobalFn.varIsNull(glar311Model.order3)) { if (GlobalFn.varIsNull(sqlOrderBy)) { switch (glar311Model.order3) { case "1": sqlOrderBy = "ORDER BY gfa01"; break; case "2": sqlOrderBy = "ORDER BY gfa02"; break; case "3": sqlOrderBy = "ORDER BY gfb03"; break; case "4": sqlOrderBy = "ORDER BY gfb05"; break; case "5": sqlOrderBy = "ORDER BY gfb02"; break; case "6": sqlOrderBy = "ORDER BY gfa06"; break; } } else { switch (glar311Model.order3) { case "1": sqlOrderBy += ",gfa01"; break; case "2": sqlOrderBy += ",gfa02"; break; case "3": sqlOrderBy += ",gfb03"; break; case "4": sqlOrderBy += ",gfb05"; break; case "5": sqlOrderBy += ",gfb02"; break; case "6": sqlOrderBy += ",gfa06"; break; } } } #endregion dtMaster = BoMaster.OfGetDataTable(string.Concat(sqlBody, strWhere, sqlOrderBy), sqlParmList.ToArray()); dtMaster.TableName = "Master"; if (dtMaster == null || dtMaster.Rows.Count == 0) { WfShowErrorMsg("查無資料,請重新過濾條件!"); return(false); } masterList = dtMaster.ToList <Master>(true); //取得本幣資料 var baaModel = BoBas.OfGetBaaModel(); if (baaModel == null) { WfShowErrorMsg("未設定基本參數,請先設定!"); return(false); } var baa04 = baaModel.baa04; var bekUsModel = BoBas.OfGetBekModel(baa04); if (bekUsModel == null) { WfShowErrorMsg("查無本幣資料,請先設定!"); return(false); } masterList = dtMaster.ToList <Master>(true); foreach (Master masterModel in masterList) { if (masterModel.gfb06 == "1") { masterModel.gfb07d = masterModel.gfb07; masterModel.gfb07d_str = string.Format("{0:N" + bekUsModel.bek04 + "}", masterModel.gfb07); masterModel.gfb10d = masterModel.gfb10; masterModel.gfb10d_str = string.Format("{0:N" + masterModel.bek04 + "}", masterModel.gfb10); } else { masterModel.gfb07c = masterModel.gfb07; masterModel.gfb07c_str = string.Format("{0:N" + bekUsModel.bek04 + "}", masterModel.gfb07); masterModel.gfb10c = masterModel.gfb10; masterModel.gfb10c_str = string.Format("{0:N" + masterModel.bek04 + "}", masterModel.gfb10); } } pReport.RegData("Master", masterList); pReport.CacheAllData = true; #region 列印選項處理 StiGroupHeaderBand headerBand1 = (StiGroupHeaderBand)pReport.GetComponents()["GroupHeaderBand1"]; StiGroupFooterBand footerBand1 = (StiGroupFooterBand)pReport.GetComponents()["GroupFooterBand1"]; StiGroupHeaderBand headerBand2 = (StiGroupHeaderBand)pReport.GetComponents()["GroupHeaderBand2"]; StiGroupFooterBand footerBand2 = (StiGroupFooterBand)pReport.GetComponents()["GroupFooterBand2"]; StiGroupHeaderBand headerBand3 = (StiGroupHeaderBand)pReport.GetComponents()["GroupHeaderBand3"]; StiGroupFooterBand footerBand3 = (StiGroupFooterBand)pReport.GetComponents()["GroupFooterBand3"]; if (!GlobalFn.varIsNull(glar311Model.order1) && (glar311Model.order1_jump_yn == "Y" || glar311Model.order1_sum_yn == "Y")) { switch (glar311Model.order1) { case "1": headerBand1.Condition.Value = "{Master.gfa01}"; break; case "2": headerBand1.Condition.Value = "{Master.gfa02}"; break; case "3": headerBand1.Condition.Value = "{Master.gfb03}"; break; case "4": headerBand1.Condition.Value = "{Master.gfb05}"; break; case "5": headerBand1.Condition.Value = "{Master.gfb02}"; break; case "6": headerBand1.Condition.Value = "{Master.gfa06}"; break; } //處理跳頁 if (glar311Model.order1_jump_yn == "Y") { headerBand1.NewPageBefore = true; headerBand1.ResetPageNumber = true; } else { headerBand1.NewPageBefore = false; headerBand1.ResetPageNumber = false; } //處理小計 if (glar311Model.order1_sum_yn.ToUpper() != "Y") { footerBand1.Enabled = false; } } else { footerBand1.Enabled = false; } if (!GlobalFn.varIsNull(glar311Model.order2) && (glar311Model.order2_jump_yn == "Y" || glar311Model.order2_sum_yn == "Y")) { switch (glar311Model.order2) { case "1": headerBand2.Condition.Value = "{Master.gfa01}"; break; case "2": headerBand2.Condition.Value = "{Master.gfa02}"; break; case "3": headerBand2.Condition.Value = "{Master.gfb03}"; break; case "4": headerBand2.Condition.Value = "{Master.gfb05}"; break; case "5": headerBand2.Condition.Value = "{Master.gfb02}"; break; case "6": headerBand2.Condition.Value = "{Master.gfa06}"; break; } //處理跳頁 if (glar311Model.order2_jump_yn.ToUpper() == "Y") { headerBand2.NewPageBefore = true; headerBand2.ResetPageNumber = true; } else { headerBand2.NewPageBefore = false; headerBand2.ResetPageNumber = false; } //處理小計 if (glar311Model.order2_sum_yn.ToUpper() != "Y") { footerBand2.Enabled = false; } } else { footerBand2.Enabled = false; } if (!GlobalFn.varIsNull(glar311Model.order3) && (glar311Model.order3_jump_yn == "Y" || glar311Model.order3_sum_yn == "Y")) { switch (glar311Model.order3) { case "1": headerBand3.Condition.Value = "{Master.gfa01}"; break; case "2": headerBand3.Condition.Value = "{Master.gfa02}"; break; case "3": headerBand3.Condition.Value = "{Master.gfb03}"; break; case "4": headerBand3.Condition.Value = "{Master.gfb05}"; break; case "5": headerBand3.Condition.Value = "{Master.gfb02}"; break; case "6": headerBand3.Condition.Value = "{Master.gfa06}"; break; } //處理跳頁 if (glar311Model.order3_jump_yn.ToUpper() == "Y") { headerBand3.NewPageBefore = true; headerBand3.ResetPageNumber = true; } else { headerBand3.NewPageBefore = false; headerBand3.ResetPageNumber = false; } //處理小計 if (glar311Model.order3_sum_yn.ToUpper() != "Y") { footerBand3.Enabled = false; } } else { footerBand3.Enabled = false; } #endregion return(true); } catch (Exception ex) { throw ex; } }