public static WebbDataSource CreateDataSource() { WebbDataProvider dataProvider = new WebbDataProvider(); WebbDataSource m_DBSource = new WebbDataSource(); //Show wizard DialogResult m_Result = dataProvider.ShowWizard(null, m_DBSource); if (m_Result != DialogResult.OK) { return(null); } Webb.Utilities.WaitingForm.ShowWaitingForm(); Webb.Utilities.WaitingForm.SetWaitingMessage("Loading Datasource...."); bool m_result = dataProvider.GetDataSource(m_DBSource); if (!m_result || m_DBSource.DataSource.Tables.Count == 0) { MessageBox.Show("No data in you selected dataSource!", "Failed", MessageBoxButtons.OK, MessageBoxIcon.Information); return(null); } SetDataSource(dataProvider, m_DBSource); Webb.Utilities.WaitingForm.CloseWaitingForm(); return(m_DBSource); }
public DBConfigWizardForm(WebbDataProvider i_DataProvider) { // This call is required by the Windows Form Designer. InitializeComponent(); this._DataProvider = i_DataProvider; // TODO: Add any initialization after the InitializeComponent call }
public void SetGamesAndEdlsView() { WebbDataProvider provider = new WebbDataProvider(); if (!System.IO.File.Exists(this.C_SelectedFile.Text)) { return; } this._DbSourceConfig.DBFilePath = this.C_SelectedFile.Text; provider.InitializeDBManager(this._DbSourceConfig); DataTable m_Games = provider.LoadWebbGames(); this.SetGames(m_Games); DataTable m_Edls = provider.LoadWebbEdls(); this.SetEdls(m_Edls); }
public CResolveFieldValue(string strField) { _Field = strField; _DisplayAsImage = false; WebbDataProvider dataProvider = VideoPlayBackManager.PublicDBProvider; if (dataProvider != null && dataProvider.DBSourceConfig != null) { if (dataProvider.DBSourceConfig.WebbDBType == WebbDBTypes.WebbPlaybook) { if (strField == "ImagePath") { _DisplayAsImage = true; this._ColumnWidth = 300; } } else if (dataProvider.DBSourceConfig.WebbDBType == WebbDBTypes.CoachCRM) { if (strField == "Logo(TeamInfo)" || strField == "Photo(Coach)" || strField == "Photo(Player)") { _DisplayAsImage = true; this._ColumnWidth = 80; } } else if ((int)dataProvider.DBSourceConfig.WebbDBType < 10) { PlayBookData playBookdata = new PlayBookData(); if (playBookdata.CheckIsPlaybookImageField(strField)) { _DisplayAsImage = true; this._ColumnWidth = 300; } } } }
public static WebbDataSource GetDefaultDataSource() { string dir = Webb.Utility.ApplicationDirectory + @"Template\Styles\StyleReports"; if (!Directory.Exists(dir)) { Directory.CreateDirectory(dir); } string DataSourceFile = string.Format(@"{0}\data.wrdf", dir); WebbDataSource dataSource = WrdfFileManager.ReadDataConfig(DataSourceFile, ""); if (dataSource != null) { WebbDataProvider provider = new WebbDataProvider(); ReportSetting.SetDataSource(provider, dataSource); } return(dataSource); }
public static WebbDataSource CreateDataSourse(string[] args, bool throwException) { if (args == null || args.Length != 10) { return(null); } if (args[3] == "DBConn:" && args[8] == @"Files:") { return(null); } try { CommandManager m_CmdManager = new CommandManager(args); DBSourceConfig m_Config = m_CmdManager.CreateDBConfig(); WebbDataProvider m_DBProvider = new WebbDataProvider(m_Config); WebbDataSource m_DBSource = new WebbDataSource(); m_DBProvider.GetDataSource(m_Config, m_DBSource); Webb.Reports.DataProvider.VideoPlayBackManager.PublicDBProvider = m_DBProvider; return(m_DBSource); } catch (Exception ex) { if (throwException) { MessageBox.Show("Bad parameters in Config File!\r\n" + ex.Message); } return(null); } }
private static void SetDataSource(WebbDataProvider m_DBProvider, WebbDataSource m_DBSource) { ArrayList m_Fields = new ArrayList(); foreach (System.Data.DataColumn m_col in m_DBSource.DataSource.Tables[0].Columns) { if (m_col.Caption == "{EXTENDCOLUMNS}" && m_col.ColumnName.StartsWith("C_")) { continue; } m_Fields.Add(m_col.ColumnName); } Webb.Data.PublicDBFieldConverter.SetAvailableFields(m_Fields); Webb.Reports.DataProvider.VideoPlayBackManager.DataSource = m_DBSource.DataSource; //Set dataset for click event Webb.Reports.DataProvider.VideoPlayBackManager.PublicDBProvider = m_DBProvider; Webb.Reports.DataProvider.VideoPlayBackManager.LoadAdvScFilters(); //Modified at 2009-1-19 13:48:30@Scott Webb.Reports.DataProvider.VideoPlayBackManager.ReadPictureDirFromRegistry(); }
private void GetOneValueImage(DataTable dt) { int nWidth = this.ExControl.Width, nHeight = this.ExControl.Height; nHeight = (int)((float)nWidth * 2 / 3); string strField = string.Empty; string strValue = "<NULLVALUES>"; strValue = this.GetFieldValue(dt); if (strValue == "<NULLVALUES>") { if (this.Repeat) { strValue = this.RepeatFilter.FilterName; } else { strValue = this.OneValueScFilter.FilterName; } } if (this.OneValue) { #region OneValue this.Image = null; strField = this.Field; string strScoutType = string.Empty; if (Webb.Utility.CurReportMode == 0) { strScoutType = this.ExControl.Report.Template.DiagramScoutType.ToString(); } else { strScoutType = Webb.Reports.DataProvider.VideoPlayBackManager.DiagramScoutType; } bool IsAddingPlayBookGames = false; bool IsAddingCCRMData = false; WebbDataProvider dataProvider = Webb.Reports.DataProvider.VideoPlayBackManager.PublicDBProvider; string strUserFolder = string.Empty; if (dataProvider != null && dataProvider.DBSourceConfig != null) { strUserFolder = dataProvider.DBSourceConfig.UserFolder; if (strUserFolder == null) { strUserFolder = string.Empty; } IsAddingPlayBookGames = (dataProvider.DBSourceConfig.WebbDBType == WebbDBTypes.WebbPlaybook); IsAddingCCRMData = (dataProvider.DBSourceConfig.WebbDBType == WebbDBTypes.CoachCRM); } int index = strUserFolder.IndexOf(";"); if (index >= 0) { strUserFolder = strUserFolder.Substring(0, index); } if (Webb.Reports.DataProvider.VideoPlayBackManager.DiaPath != string.Empty) { strUserFolder = Webb.Reports.DataProvider.VideoPlayBackManager.DiaPath; strUserFolder = strUserFolder.TrimEnd(@"\".ToCharArray()); } string strImageFilePath = string.Format(@"{0}\Diagrams\{1}\{2}\{3}.dia", strUserFolder, strScoutType, strField, strValue); PlayBookData playBookData = new PlayBookData(); if (IsAddingPlayBookGames) { nWidth = this.ExControl.Width; nHeight = this.ExControl.Height; string strGetImagePath = this.GetPlayBookImagePath(dt); #region Play Book Games if (System.IO.File.Exists(strGetImagePath)) { this.Image = Webb.Utility.ReadImageFromPath(strGetImagePath); } #endregion } else if (IsAddingCCRMData) { nWidth = this.ExControl.Width; nHeight = this.ExControl.Height; if (System.IO.File.Exists(strValue)) { this.Image = Webb.Utility.ReadImageFromPath(strValue); } } else if (this._ReadDiagramFromPlaybook) { #region PlayBook Diagram if (this._PlayBookScoutType == PlayBookScoutType.Default) { strScoutType = playBookData.CheckOffensiveField(strScoutType, strField); if (playBookData.CheckIsPlaybookImageField(strField)) { this.Image = Webb.Utility.ReadImageFromPath(strValue); } else { this.Image = playBookData.ReadPictureFromValue(strScoutType, strField, strValue); } } else if (this._PlayBookScoutType == PlayBookScoutType.OffenseBaseFormation) { this.Image = playBookData.ReadBaseFormation("Offense"); } else if (this._PlayBookScoutType == PlayBookScoutType.DefenseBaseFormation) { this.Image = playBookData.ReadBaseFormation("Defense"); } else { strScoutType = this._PlayBookScoutType.ToString(); if (playBookData.CheckIsPlaybookImageField(strField)) { this.Image = Webb.Utility.ReadImageFromPath(strValue); } else { this.Image = playBookData.ReadPictureFromValue(strScoutType, strField, strValue); } } #endregion } else if (this._UsePicDir) { #region Use Picture in destine-Directory strUserFolder = Webb.Reports.DataProvider.VideoPlayBackManager.PictureDir; strImageFilePath = string.Format(@"{0}\SavePic\{1}\{2}.bmp", strUserFolder, strField, strValue); if (File.Exists(strImageFilePath)) { this.Image = Webb.Utility.ReadImageFromPath(strImageFilePath); } #endregion } else if (playBookData.CheckIsPlaybookImageField(strField)) { this.Image = Webb.Utility.ReadImageFromPath(strValue); } else { #region Advantage Diagram if (File.Exists(strImageFilePath)) { Image image = new Bitmap(nWidth, nHeight); Graphics g = Graphics.FromImage(image); g.Clear(Color.White); //Modify at 2009-2-24 10:27:26@Simon AdvDiagram diagram = new AdvDiagram(); diagram.OpenDiagram(strImageFilePath); diagram.DrawDiagram(g, nWidth, nHeight); this.Image = image; } #endregion } #endregion } else { if (this._DiagramImage.ToLower().EndsWith(".dia") && File.Exists(this._DiagramImage)) { Image image = new Bitmap(nWidth, nHeight); Graphics g = Graphics.FromImage(image); g.Clear(Color.White); //Modify at 2009-2-24 10:27:30@Simon AdvDiagram diagram = new AdvDiagram(); diagram.OpenDiagram(this._DiagramImage); diagram.DrawDiagram(g, nWidth, nHeight); this.Image = image; } } }
public string CreateGameReport(string[] strCommands, string strDestinePdfFile, string strDllPath) { Webb.Utility.CurReportMode = 2; strDestinePdfFile = AdjustPDFFile(strDestinePdfFile); if (strCommands == null) { return("Failed"); } CommandManager m_CmdManager = new CommandManager(strCommands); DBSourceConfig m_Config = m_CmdManager.CreateDBConfig(); WebbDataProvider m_DBProvider = new WebbDataProvider(m_Config); WebbDataSource m_DBSource = new WebbDataSource(); try { m_DBProvider.GetDataSource(m_Config, m_DBSource); ArrayList m_Fields = new ArrayList(); foreach (System.Data.DataColumn m_col in m_DBSource.DataSource.Tables[0].Columns) { if (m_col.Caption == "{EXTENDCOLUMNS}" && m_col.ColumnName.StartsWith("C_")) { continue; } m_Fields.Add(m_col.ColumnName); } Webb.Data.PublicDBFieldConverter.SetAvailableFields(m_Fields); Webb.Reports.DataProvider.VideoPlayBackManager.DataSource = m_DBSource.DataSource; //Set dataset for click event Webb.Reports.DataProvider.VideoPlayBackManager.PublicDBProvider = m_DBProvider; Webb.Reports.DataProvider.VideoPlayBackManager.LoadAdvScFilters(); //Modified at 2009-1-19 13:48:30@Scott m_DBProvider.UpdateEFFDataSource(m_DBSource); } catch (Exception e) { return("Failed:at addding datasouce|" + e.Message); } if (m_Config.Templates.Count <= 0) { return("Failed:No tempaltes"); } XtraReport[] preparedReports = new WebbReport[m_Config.Templates.Count]; for (int i = 0; i < m_Config.Templates.Count; i++) { string strTemplateName = m_Config.Templates[i]; WebbReport m_Report = null; try { m_Report = m_CmdManager.CreateReport(strDllPath, strTemplateName); //1 //create report with template } catch (Exception ex) { return("Failed:Can't load report template" + ex.Message); } try { m_Report.LoadAdvSectionFilters(m_Config.UserFolder); m_Report.SetWatermark(m_Config.WartermarkImagePath); //06-19-2008@Scott m_Report.SetDataSource(m_DBSource); preparedReports[i] = m_Report; } catch (Exception ex2) { return("Failed:in create PDf Documnet\r\n" + strTemplateName + "\r\n" + ex2.Message); } } try { if (System.IO.File.Exists(strDestinePdfFile)) { System.IO.File.Delete(strDestinePdfFile); } XtraReport.UnionReportsToPdf(preparedReports, strDestinePdfFile); } catch (Exception ex3) { return("Failed:in create PDf Documnet|" + ex3.Message); } if (!System.IO.File.Exists(strDestinePdfFile)) { return("Failed:some error happed,and report could not be created!"); } return(strDestinePdfFile); }
public string CreateReport(string strInwFile, string strFile, string dllpath) { Webb.Utility.CurReportMode = 2; strFile = AdjustPDFFile(strFile); string[] args = InwManager.ReadInwFile(strInwFile); if (args == null) { return("Failed"); } CommandManager m_CmdManager = new CommandManager(args); DBSourceConfig m_Config = m_CmdManager.CreateDBConfig(); WebbDataProvider m_DBProvider = new WebbDataProvider(m_Config); WebbDataSource m_DBSource = new WebbDataSource(); try { m_DBProvider.GetDataSource(m_Config, m_DBSource); ArrayList m_Fields = new ArrayList(); foreach (System.Data.DataColumn m_col in m_DBSource.DataSource.Tables[0].Columns) { if (m_col.Caption == "{EXTENDCOLUMNS}" && m_col.ColumnName.StartsWith("C_")) { continue; } m_Fields.Add(m_col.ColumnName); } Webb.Data.PublicDBFieldConverter.SetAvailableFields(m_Fields); Webb.Reports.DataProvider.VideoPlayBackManager.DataSource = m_DBSource.DataSource; //Set dataset for click event Webb.Reports.DataProvider.VideoPlayBackManager.PublicDBProvider = m_DBProvider; Webb.Reports.DataProvider.VideoPlayBackManager.LoadAdvScFilters(); //Modified at 2009-1-19 13:48:30@Scott m_DBProvider.UpdateEFFDataSource(m_DBSource); Webb.Reports.DataProvider.VideoPlayBackManager.ReadPictureDirFromRegistry(); } catch (Exception e) { return("Failed:at addding datasouce|" + e.Message); } FilterInfoCollection filterInfos = m_DBSource.Filters; //2009-7-1 11:09:08@Simon Add this Code For Union Print if (filterInfos == null) { filterInfos = new FilterInfoCollection(); } if (m_Config.Templates.Count <= 0) { return("Failed:No tempaltes"); } string strTemplate = m_Config.Templates[0]; string strTemplateName = m_CmdManager.GetTemplateName(strTemplate, '@'); //Modified at 2009-2-3 9:17:34@Scott WebbReport m_Report = null; try { m_Report = m_CmdManager.CreateReport(dllpath, strTemplateName); //1 //create report with template } catch (Exception ex) { return("Failed:Can't load report template" + ex.Message); } //Add attached filter here #region Modified Area m_DBSource.Filters = filterInfos.Copy(); //2009-7-1 11:09:04@Simon Add this Code For Union Print string strFilterName = m_CmdManager.GetAttachedFilter(strTemplate, '@'); if (strFilterName != string.Empty) //2009-7-1 11:09:04@Simon For display Filternames In GameListInfo { if (!m_DBProvider.DBSourceConfig.Filters.Contains(strFilterName)) { FilterInfo filterInfo = new FilterInfo(); filterInfo.FilterName = strFilterName; m_DBSource.Filters.Add(filterInfo); } } ScAFilter scaFilter = Webb.Reports.DataProvider.VideoPlayBackManager.AdvReportFilters.GetFilter(strFilterName); //Modified at 2009-1-19 14:25:30@Scott AdvFilterConvertor convertor = new AdvFilterConvertor(); DBFilter AdvFilter = convertor.GetReportFilter(scaFilter).Filter; if (AdvFilter != null || AdvFilter.Count > 0) //2009-5-6 9:38:37@Simon Add this Code { AdvFilter.Add(m_Report.Template.Filter); m_Report.Template.Filter = AdvFilter; } SectionFilterCollection sectionFilter = m_Report.Template.SectionFilters.Copy(); if (m_Report.Template.ReportScType == ReportScType.Custom) { m_Report.Template.SectionFilters = AdvFilterConvertor.GetCustomFilters(Webb.Reports.DataProvider.VideoPlayBackManager.AdvReportFilters, sectionFilter); } #endregion //Modify at 2008-11-24 16:04:05@Scott try { if (System.IO.File.Exists(strFile)) { System.IO.File.Delete(strFile); } m_Report.LoadAdvSectionFilters(m_Config.UserFolder); m_Report.SetWatermark(m_Config.WartermarkImagePath); //06-19-2008@Scott m_Report.SetDataSource(m_DBSource); m_Report.CreatePdfDocument(strFile); if (!System.IO.File.Exists(strFile)) { return("Failed:dll path " + dllpath); } } catch (Exception ex2) { return("Failed:in create PDf Documnet|" + ex2.Message); } return(strFile); }
public string ExportUnionReportToPdf(string strInwFile, string DestinationPdfFile) { Webb.Utility.CurReportMode = 2; DestinationPdfFile = AdjustPDFFile(DestinationPdfFile); string[] args = InwManager.ReadInwFile(strInwFile); if (args == null) { return("Failed"); } CommandManager m_CmdManager = new CommandManager(args); DBSourceConfig m_Config = m_CmdManager.CreateDBConfig(); WebbDataProvider m_DBProvider = new WebbDataProvider(m_Config); WebbDataSource m_DBSource = new WebbDataSource(); try { m_DBProvider.GetDataSource(m_Config, m_DBSource); ArrayList m_Fields = new ArrayList(); foreach (System.Data.DataColumn m_col in m_DBSource.DataSource.Tables[0].Columns) { if (m_col.Caption == "{EXTENDCOLUMNS}" && m_col.ColumnName.StartsWith("C_")) { continue; } m_Fields.Add(m_col.ColumnName); } Webb.Data.PublicDBFieldConverter.SetAvailableFields(m_Fields); Webb.Reports.DataProvider.VideoPlayBackManager.DataSource = m_DBSource.DataSource; //Set dataset for click event Webb.Reports.DataProvider.VideoPlayBackManager.PublicDBProvider = m_DBProvider; //Webb.Reports.DataProvider.VideoPlayBackManager.ReadPictureDirFromRegistry(); Webb.Reports.DataProvider.VideoPlayBackManager.LoadAdvScFilters(); //Modified at 2009-1-19 13:48:30@Scott m_DBProvider.UpdateEFFDataSource(m_DBSource); } catch (Exception e) { return("Failed:at addding datasouce|" + e.Message); } FilterInfoCollection filterInfos = m_DBSource.Filters; //2009-7-1 11:09:08@Simon Add this Code For Union Print if (filterInfos == null) { filterInfos = new FilterInfoCollection(); } if (m_Config.Templates.Count <= 0) { return("Failed"); } XtraReport[] preparedReports = new WebbReport[m_Config.Templates.Count]; if (System.IO.File.Exists(DestinationPdfFile)) { System.IO.File.Delete(DestinationPdfFile); } System.Reflection.Assembly asm = System.Reflection.Assembly.GetExecutingAssembly(); string dllPath = System.IO.Path.GetDirectoryName(asm.Location); if (!dllPath.EndsWith(@"\")) { dllPath += @"\"; } for (int i = 0; i < m_Config.Templates.Count; i++) { string strTemplate = m_Config.Templates[i]; string strTemplateName = m_CmdManager.GetTemplateName(strTemplate, '@'); //Modified at 2009-2-3 9:17:34@Scott WebbReport m_Report = null; try { m_Report = m_CmdManager.CreateReport(dllPath, strTemplateName); //1 //create report with template } catch (Exception ex) { return("Failed:in create report" + ex.Message); } //Add attached filter here #region Modified Area m_DBSource.Filters = filterInfos.Copy(); //2009-7-1 11:09:04@Simon Add this Code For Union Print string strFilterName = m_CmdManager.GetAttachedFilter(strTemplate, '@'); if (strFilterName != string.Empty) //2009-7-1 11:09:04@Simon For display Filternames In GameListInfo { if (!m_DBProvider.DBSourceConfig.Filters.Contains(strFilterName)) { FilterInfo filterInfo = new FilterInfo(); filterInfo.FilterName = strFilterName; m_DBSource.Filters.Add(filterInfo); } } ScAFilter scaFilter = Webb.Reports.DataProvider.VideoPlayBackManager.AdvReportFilters.GetFilter(strFilterName); //Modified at 2009-1-19 14:25:30@Scott AdvFilterConvertor convertor = new AdvFilterConvertor(); DBFilter AdvFilter = convertor.GetReportFilter(scaFilter).Filter; if (AdvFilter != null || AdvFilter.Count > 0) //2009-5-6 9:38:37@Simon Add this Code { AdvFilter.Add(m_Report.Template.Filter); m_Report.Template.Filter = AdvFilter; } #endregion //Modify at 2008-11-24 16:04:05@Scott try { m_Report.LoadAdvSectionFilters(m_Config.UserFolder); m_Report.SetWatermark(m_Config.WartermarkImagePath); //06-19-2008@Scott m_Report.SetDataSource(m_DBSource); preparedReports[i] = m_Report; } catch (Exception ex2) { return("Failed:load report|" + ex2.Message); } } try { XtraReport.UnionReportsToPdf(preparedReports, DestinationPdfFile); } catch (Exception ex3) { return("Failed:in create PDf Documnet|" + ex3.Message); } if (!System.IO.File.Exists(DestinationPdfFile)) { return("Failed:file didn't exist"); } return(DestinationPdfFile); }
public static WebbDataSource ReadDataConfig(string DataConfigFile, string filename) { if (!File.Exists(DataConfigFile)) { return(null); } WebbDataSource m_DBSource = new WebbDataSource(); DataSet ds = new DataSet(); try { ds.ReadXml(DataConfigFile); if (ds.Tables.Count == 0) { return(null); } int lastCount = ds.Tables.Count - 1; if (lastCount == 0) { m_DBSource.DataSource = ds; } else if (ds.Tables[lastCount].TableName == "[TableStructure]") { DBSourceConfig m_Config = new DBSourceConfig(); m_Config.WebbDBType = WebbDBTypes.CoachCRM; m_Config.DBFilePath = DataConfigFile; Webb.Reports.DataProvider.VideoPlayBackManager.PublicDBProvider = new WebbDataProvider(m_Config); m_DBSource.DataSource = ds; } else { DataTable dt = ds.Tables[lastCount]; filename = "Path:" + filename; DataRow dr = dt.Rows[dt.Rows.Count - 1]; if (dr == null || dt.Columns.Count != 10) { return(null); } string[] strConfigs = new string[dt.Columns.Count]; strConfigs[0] = "Path:" + filename; for (int i = 1; i < dt.Columns.Count; i++) { strConfigs[i] = dr[i].ToString(); } CommandManager m_CmdManager = new CommandManager(strConfigs); DBSourceConfig m_Config = m_CmdManager.CreateDBConfig(); WebbDataProvider m_DBProvider = new WebbDataProvider(m_Config); Webb.Reports.DataProvider.VideoPlayBackManager.PublicDBProvider = m_DBProvider; ds.Tables.RemoveAt(lastCount); AdvGameData.FillGamesAndFilters(m_DBSource, m_Config); m_DBSource.DataSource = ds; } return(m_DBSource); } catch (Exception ex) { ds.Dispose(); MessageBox.Show(ex.Message); return(null); } }
static void Main(string[] args) { if (args == null || (args.Length != 1 && args.Length != 10)) { return; } ReportFileType fileType = ReportFileType.Report; DataSet dsDataset = null; if (args.Length == 1) { string filename = args[0]; if (filename.IndexOf("\n") > 0) { args = filename.Split("\n".ToCharArray()); if (args.Length != 10) { return; } } else if (filename.EndsWith(".wmks")) { wmksFileManager.WriteFile(filename); return; } else if (filename.EndsWith(".repx")) { string Inwfilename = filename.Replace(".repx", ".inw"); args = InwManager.ReadInwFile(Inwfilename); fileType = ReportFileType.InwFile; if (args == null) { args = ConfigFileManager.ReadDataConfig(filename); fileType = ReportFileType.BaseXmlFile; } } else if (filename.EndsWith(".repw")) { string Inwfilename = filename.Replace(".repw", ".inw"); args = InwManager.ReadInwFile(Inwfilename); fileType = ReportFileType.InwFile; if (args == null) { args = ConfigFileManager.ReadDataConfig(filename); fileType = ReportFileType.BaseXmlFile; } } else if (filename.EndsWith(".inw")) { args = InwManager.ReadInwFile(filename); fileType = ReportFileType.InwFile; } else if (filename.EndsWith(".wrdf")) { WrdfFileManager.ReadDataConfig(filename, out dsDataset, out args); fileType = ReportFileType.WebbDataFile; } else { return; } if (args == null) { return; } } if (args[3] == "DBConn:" && args[8] == @"Files:") { return; } Webb.Utility.CurReportMode = 1; //set browser mode ThreadStart ts = new ThreadStart(LoadingThreadProc); Thread thread = new Thread(ts); thread.Start(); CommandManager m_CmdManager = new CommandManager(args); //Calculate data source if (thread.IsAlive) { LoadingForm.MessageText = "Loading Data Source..."; } DBSourceConfig m_Config = m_CmdManager.CreateDBConfig(); if (m_Config.Templates.Count == 0) { if (thread.IsAlive) { LoadingForm.Close(); thread.Abort(); } Webb.Utilities.TopMostMessageBox.ShowMessage("Invalid template report name!", MessageBoxButtons.OK); Environment.Exit(0); } if (m_CmdManager.PrintDirectly) { if (PrinterSettings.InstalledPrinters.Count == 0) { if (thread.IsAlive) { LoadingForm.Close(); thread.Abort(); } Webb.Utilities.TopMostMessageBox.ShowMessage("No printer driver is installed!", MessageBoxButtons.OK); Environment.Exit(0); } } WebbDataProvider m_DBProvider = new WebbDataProvider(m_Config); WebbDataSource m_DBSource = new WebbDataSource(); if (fileType == ReportFileType.WebbDataFile && dsDataset == null) { m_DBSource.DataSource = dsDataset.Copy(); } else { m_DBProvider.GetDataSource(m_Config, m_DBSource); } ArrayList m_Fields = new ArrayList(); foreach (System.Data.DataColumn m_col in m_DBSource.DataSource.Tables[0].Columns) { if (m_col.Caption == "{EXTENDCOLUMNS}" && m_col.ColumnName.StartsWith("C_")) { continue; } m_Fields.Add(m_col.ColumnName); } Webb.Reports.DataProvider.VideoPlayBackManager.PublicDBProvider = m_DBProvider; Webb.Data.PublicDBFieldConverter.SetAvailableFields(m_Fields); Webb.Reports.DataProvider.VideoPlayBackManager.LoadAdvScFilters(); //Modified at 2009-1-19 13:48:30@Scott Webb.Reports.DataProvider.VideoPlayBackManager.ReadPictureDirFromRegistry(); m_DBProvider.UpdateEFFDataSource(m_DBSource); Webb.Reports.DataProvider.VideoPlayBackManager.DataSource = m_DBSource.DataSource; //Set dataset for click event //Loading report template if (thread.IsAlive) { LoadingForm.MessageText = "Loading Report Template..."; } #region Modified Area ArrayList printedReports = new ArrayList(); ArrayList invalidateReports = new ArrayList(); bool unionprint = m_CmdManager.UnionPrint; #endregion //End Modify at 2008-10-10 14:29:49@Simon FilterInfoCollection filterInfos = m_DBSource.Filters; //2009-7-1 11:09:08@Simon Add this Code For Union Print if (filterInfos == null) { filterInfos = new FilterInfoCollection(); } string printerName = m_CmdManager.PrinterName; foreach (string strTemplate in m_Config.Templates) { string strTemplateName = m_CmdManager.GetTemplateName(strTemplate, '@'); //Modified at 2009-2-3 9:17:34@Scott WebbReport m_Report = null; try { m_Report = m_CmdManager.CreateReport(Application.ExecutablePath, strTemplateName); //1 //create report with template //09-01-2011@Scott if (m_Config.WebbDBType == WebbDBTypes.WebbPlaybook) { SetReportHeader(m_Config, m_Report, m_Config.HeaderName); //Add this code at 2011-7-28 16:23:41@simon } else { string strHeader = m_CmdManager.GetAttachedHeader(strTemplate, '@'); SetReportHeader(m_Config, m_Report, strHeader); } //End } catch (Exception ex) { Webb.Utilities.TopMostMessageBox.ShowMessage("Error", "Can't load report template!\r\n" + ex.Message, MessageBoxButtons.OK); m_Report = new WebbReport(); } bool Canopen = CheckedUserRight(m_Report.LicenseLevel, m_Config.WebbDBType); string filename = System.IO.Path.GetFileNameWithoutExtension(strTemplateName); if (!Canopen) { invalidateReports.Add(filename); } else { //Add attached filter here #region Modified Area m_DBSource.Filters = filterInfos.Copy(); //2009-7-1 11:09:04@Simon Add this Code For Union Print string strFilterName = m_CmdManager.GetAttachedFilter(strTemplate, '@'); if (strFilterName != string.Empty) //2009-7-1 11:09:04@Simon For display Filternames In GameListInfo { if (!m_DBProvider.DBSourceConfig.Filters.Contains(strFilterName)) { FilterInfo filterInfo = new FilterInfo(); filterInfo.FilterName = strFilterName; m_DBSource.Filters.Add(filterInfo); } } ScAFilter scaFilter = Webb.Reports.DataProvider.VideoPlayBackManager.AdvReportFilters.GetFilter(strFilterName); //Modified at 2009-1-19 14:25:30@Scott AdvFilterConvertor convertor = new AdvFilterConvertor(); DBFilter AdvFilter = convertor.GetReportFilter(scaFilter).Filter; if (AdvFilter != null || AdvFilter.Count > 0) //2009-5-6 9:38:37@Simon Add this Code { AdvFilter.Add(m_Report.Template.Filter); m_Report.Template.Filter = AdvFilter; } SectionFilterCollection sectionFilter = m_Report.Template.SectionFilters.Copy(); if (m_Report.Template.ReportScType == ReportScType.Custom) { m_Report.Template.SectionFilters = AdvFilterConvertor.GetCustomFilters(Webb.Reports.DataProvider.VideoPlayBackManager.AdvReportFilters, sectionFilter); } #endregion //Modify at 2008-11-24 16:04:05@Scott //Set data source if (thread.IsAlive) { LoadingForm.MessageText = "Set Data Source..."; LoadingForm.ProcessText = Webb.Utility.GetCurFileName(); } m_Report.LoadAdvSectionFilters(m_Config.UserFolder); m_Report.SetWatermark(m_Config.WartermarkImagePath); //06-19-2008@Scott m_Report.SetDataSource(m_DBSource); } if (m_CmdManager.PrintDirectly) { if (!Canopen) { if (!unionprint) { Webb.Utilities.TopMostMessageBox.ShowMessage("LicenseLevel Error", "This report is not designed for your Webb application!" + "", MessageBoxButtons.OK); } continue; } else { printedReports.Add(m_Report); } #region Modified Area if (unionprint) { continue; //Modified at 2008-10-10 10:04:37@Simon } //Print if (Webb.Utility.CancelPrint) { if (thread.IsAlive) { LoadingForm.Close(); thread.Join(); } return; } if (thread.IsAlive) { LoadingForm.MessageText = "Printing..."; } if (printerName != string.Empty) { if (!PrinterExist(printerName)) { Webb.Utilities.TopMostMessageBox.ShowMessage("Failed to Print", "WRB Cann't Find The Printer '" + printerName + "' in you system,please check the printer setting!", MessageBoxButtons.OK); Environment.Exit(-1); } m_Report.Print(printerName); } else { m_Report.Print(); } #endregion //End Modify at 2008-10-9 16:54:58@Simon } else { //Browser //Create report if (thread.IsAlive) { LoadingForm.MessageText = "Creating Report Browser..."; } WebbRepBrowser m_Browser = new WebbRepBrowser(); //m_Browser.LoadReport(new WebbReport[]{m_Report,m_Report}); //multiply report if (m_Config.WebbDBType.ToString().ToLower().StartsWith("webbvictory")) { m_Browser.TopMost = true; } else { m_Browser.TopMost = false; } if (Canopen) { m_Browser.LoadReport(m_Report); } if (thread.IsAlive) { LoadingForm.Close(); thread.Join(); } Webb.Reports.DataProvider.VideoPlayBackManager.PublicBrowser = m_Browser; //05-04-2008@Scott if (!Canopen) { m_Browser.ReportName = filename; m_Browser.InvertZorder(); // Webb.Utilities.TopMostMessageBox.ShowMessage("LicenseLevel Error", "This report is not designed for your Webb application!\n So it would not open" + "", MessageBoxButtons.OK); } Application.Run(m_Browser); } } //add these codes for join all reports to print in only one document #region Modified Area WebbReport[] AllReportsToPrint = new WebbReport[printedReports.Count]; for (int i = 0; i < printedReports.Count; i++) { AllReportsToPrint[i] = printedReports[i] as WebbReport; } if (m_CmdManager.PrintDirectly && unionprint) { if (AllReportsToPrint.Length == 0) { Webb.Utilities.TopMostMessageBox.ShowMessage("No document", "No document could be print!", MessageBoxButtons.OK); } else { if (thread.IsAlive) { LoadingForm.MessageText = "Printing..."; LoadingForm.ProcessText = "Union Printing Documents"; } if (invalidateReports.Count > 0) { Webb.Utilities.AutoClosedMessageBox.ShowMessage(invalidateReports); } if (printerName != string.Empty) { if (!PrinterExist(printerName)) { Webb.Utilities.TopMostMessageBox.ShowMessage("Failed to Print", "WRB Cann'i Find The Printer '" + printerName + "' in you system,\nplease check the printer setting!", MessageBoxButtons.OK); Environment.Exit(-1); } WebbReport.Print(printerName, AllReportsToPrint); } else { WebbReport.Print(AllReportsToPrint); } } } #endregion //End Modify at 2008-10-10 9:42:07@Simon if (thread.IsAlive) { LoadingForm.Close(); thread.Join(); } }