public static ExControlStyles GetStyle(WebbReport webbReport)
{
ExControlStyles excontrolStyle = new ExControlStyles();
Band band = webbReport.Bands[BandKind.Detail];
foreach (XRControl xrControl in band.Controls)
{
if (!(xrControl is WinControlContainer))
{
continue;
}
Control c = (xrControl as WinControlContainer).WinControl;
if (c is GridControl)
{
GridView gridView = (c as GridControl).GridView;
excontrolStyle.ApplyStyle(gridView.Styles);
return(excontrolStyle);
}
else if (c is GroupingControl)
{
GroupView groupView = (c as GroupingControl)._GroupView;
excontrolStyle.ApplyStyle(groupView.Styles);
return(excontrolStyle);
}
}
return(excontrolStyle);
}
public static ExControlView GetView(TemplateType templateType, WebbReport webbReport)
{
Band detailband = webbReport.Bands[BandKind.Detail];
foreach (XRControl xrControl in detailband.Controls)
{
if (!(xrControl is WinControlContainer))
{
continue;
}
Control c = (xrControl as WinControlContainer).WinControl;
if (templateType == TemplateType.PlayList)
{
if (!(c is GridControl))
{
continue;
}
return((c as GridControl).GridView);
}
else if (templateType == TemplateType.Group)
{
if (!(c is GroupingControl))
{
continue;
}
return((c as GroupingControl)._GroupView);
}
}
return(null);
}
public void LoadReport(WebbReport i_Report)
{
if (this.PrintingSystem == null)
{
this.PrintingSystem = new DevExpress.XtraPrinting.PrintingSystem();
}
this.PrintingSystem.ClearContent();
this.Invalidate();
this.Update();
i_Report.PrintingSystem = this.PrintingSystem;
i_Report.CreateDocument();
}
public bool UpdateSampleReportStyle(WebbReport webbReport)
{
if (this._SerializableWatermark != null)
{
webbReport.Watermark = this._SerializableWatermark.ConvertTo();
}
Band band = webbReport.Bands[BandKind.Detail];
foreach (XRControl xrControl in band.Controls)
{
if (!(xrControl is WinControlContainer))
{
continue;
}
Control c = (xrControl as WinControlContainer).WinControl;
if (WizardCustomStylesCollection.AvailbleWizardStyles.TemplateType == TemplateType.PlayList)
{
if (!(c is GridControl))
{
continue;
}
GridView gridView = (c as GridControl).GridView;
gridView.Styles.ApplyStyle(this.ExcontrolStyles);
return(true);
}
else if (WizardCustomStylesCollection.AvailbleWizardStyles.TemplateType == TemplateType.Group)
{
if (!(c is GroupingControl))
{
continue;
}
if (this.ExcontrolStyles != null)
{
GroupView groupView = (c as GroupingControl)._GroupView;
groupView.Styles.ApplyStyle(this.ExcontrolStyles);
}
}
}
return(true);
}
public void SetPrintSetting(WebbReport webbReport, GridView _GridView)
{
Size size = webbReport.GetNoDealedSizePerPage();
pageSize = size;
size.Width += 100;
this.picHeader.Size = size;
this.pageMargins = webbReport.Margins;
this.picHeader.Invalidate();
gridView = _GridView;
}
public static WebbReport LoadReport(string i_ReportID)
{
if (i_ReportID == null || i_ReportID == string.Empty)
{
return(null);
}
string m_FilePath = ReportTemplate.GetTemplateFilePath(i_ReportID);
WebbReport m_Report = new WebbReport();
if (File.Exists(m_FilePath))
{
m_Report.LoadLayout(m_FilePath);
}
return(m_Report);
}
private WebbDataSource GetWebbDataSource()
{
if (this.ExControl == null)
{
return(null);
}
if (this.ExControl.Report == null)
{
return(null);
}
WebbReport m_WebbReport = this.ExControl.Report as WebbReport;
if (m_WebbReport == null)
{
return(null);
}
return(m_WebbReport.WebbDataSource);
}
public Webb.Reports.WebbReport CreateReport(string exePath, string templatePath)
{
if (!this._IsCommandInitialized)
{
return(null);
}
string strXtraReportFilePath = templatePath;
WebbReport m_Report = null;
bool ClickEvent = VideoPlayBackManager.ClickEvent;
if (strXtraReportFilePath != string.Empty)
{
m_Report = new WebbReport();
if (File.Exists(strXtraReportFilePath))
{
Webb.Utility.ReplaceRefPathInRepxFile(strXtraReportFilePath, exePath); //Modify template file
m_Report.LoadLayout(strXtraReportFilePath);
Webb.Utility.CurFileName = strXtraReportFilePath; //06-23-2008@Scott
#region Modify codes at 2009-4-9 10:26:35@Simon //
string strWebbReportTemplateFilePath = strXtraReportFilePath.Replace(Webb.Utility.ReportExt, Webb.Utility.WebbReportExt);
if (strWebbReportTemplateFilePath.EndsWith(Webb.Utility.WebbReportExt) && File.Exists(strWebbReportTemplateFilePath))
{
File.Delete(strWebbReportTemplateFilePath);
}
#endregion //End Modify
}
}
VideoPlayBackManager.ClickEvent = ClickEvent;
return(m_Report);
}
public Webb.Reports.WebbReport CreateReport(string exePath, string templatePath)
{
if (!this._IsCommandInitialized)
{
return(null);
}
string strXtraReportFilePath = templatePath;
WebbReport m_Report = null;
if (strXtraReportFilePath != string.Empty)
{
m_Report = new WebbReport();
if (File.Exists(strXtraReportFilePath))
{
Webb.Utility.ReplaceRefPathInRepxFile(strXtraReportFilePath, exePath); //Modify template file
m_Report.LoadLayout(strXtraReportFilePath);
Webb.Utility.CurFileName = strXtraReportFilePath; //06-23-2008@Scott
string strWebbReportTemplateFilePath = strXtraReportFilePath.Replace(Webb.Utility.ReportExt, Webb.Utility.WebbReportExt);
if (File.Exists(strWebbReportTemplateFilePath))
{
WebbReportTemplate template = new WebbReportTemplate();
template.Load(strWebbReportTemplateFilePath);
m_Report.ApplyTemplate(template);
}
}
}
return(m_Report);
}
private void CheckSectionFilters()
{ //need change
if (this.ExControl == null)
{
return;
}
if (this.ExControl.Report == null)
{
return;
}
WebbReport m_WebbReport = this.ExControl.Report as WebbReport;
if (m_WebbReport == null)
{
return;
}
if (m_WebbReport.Template.SectionFilters.Count <= 0)
{
this.RemoveSectionFilters();
}
else
{
SectionFilterCollection reportSections = m_WebbReport.Template.SectionFilters;
AdvFilterConvertor convertor = new AdvFilterConvertor();
if (DataProvider.VideoPlayBackManager.AdvSectionType != AdvScoutType.None && m_WebbReport.Template.ReportScType != ReportScType.Custom)
{
ReportScType sctype = AdvFilterConvertor.GetScType(m_WebbReport.Template.ReportScType, DataProvider.VideoPlayBackManager.AdvSectionType); //2009-6-16 10:18:47@Simon Add this Code
reportSections = convertor.GetReportFilters(Webb.Reports.DataProvider.VideoPlayBackManager.AdvReportFilters, sctype); //add 1-19-2008 scott
}
this.CreateSectionGroupInfo(reportSections);
}
}
//10-14-2011 Scott Read
public string CreatePlayerReport(DataSet ds, string strDestineFile, string dllpath, string strUserFolder, string[] templateFiles)
{
WebbLog.Instance.WriteLog("AdjustPDFFile");
strDestineFile = AdjustPDFFile(strDestineFile);
WebbLog.Instance.WriteLog("AdjustPDFFile Complete");
if (!strUserFolder.EndsWith(@"\"))
{
strUserFolder += @"\";
}
WebbLog.Instance.WriteLog("new WebbReport");
XtraReport[] preparedReports = new WebbReport[templateFiles.Length];
WebbLog.Instance.WriteLog("new WebbReport Complete");
try
{
if (System.IO.File.Exists(strDestineFile))
{
System.IO.File.Delete(strDestineFile);
}
WebbLog.Instance.WriteLog("ReplaceImagePathAndUnionTable");
ds = this.ReplaceImagePathAndUnionTable(ds, strUserFolder);
WebbLog.Instance.WriteLog("ReplaceImagePathAndUnionTable Complete");
DBSourceConfig dBSourceConfig = new DBSourceConfig();
dBSourceConfig.WebbDBType = WebbDBTypes.CoachCRM;
Webb.Reports.DataProvider.VideoPlayBackManager.PublicDBProvider = new WebbDataProvider(dBSourceConfig);
WebbLog.Instance.WriteLog("for");
for (int i = 0; i < templateFiles.Length; i++)
{
WebbLog.Instance.WriteLog("1");
templateFiles[i] = templateFiles[i].Replace(@"/", @"\");
string strTemplate = strUserFolder + templateFiles[i];
if (strTemplate != string.Empty)
{
WebbLog.Instance.WriteLog("2");
WebbDataSource m_DBSource = new WebbDataSource();
m_DBSource.DataSource = ds.Copy();
WebbLog.Instance.WriteLog("3");
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);
}
WebbLog.Instance.WriteLog("5");
Webb.Data.PublicDBFieldConverter.SetAvailableFields(m_Fields);
WebbLog.Instance.WriteLog("6");
Webb.Reports.DataProvider.VideoPlayBackManager.DataSource = m_DBSource.DataSource; //Set dataset for click event
WebbReport m_Report = new WebbReport();
WebbLog.Instance.WriteLog("7");
Webb.Utility.ReplaceRefPathInRepxFile(strTemplate, dllpath); //Modify template file
WebbLog.Instance.WriteLog("8");
m_Report.LoadLayout(strTemplate);
WebbLog.Instance.WriteLog("9");
Webb.Utility.CurFileName = strTemplate; //06-23-2008@Scott
m_Report.SetDataSource(m_DBSource);
preparedReports[i] = m_Report;
WebbLog.Instance.WriteLog("10");
}
}
WebbLog.Instance.WriteLog("for complete");
}
catch (Exception ex)
{
return("Failed:in create report|" + ex.Message);
}
try
{
WebbLog.Instance.WriteLog("11");
if (preparedReports.Length == 1)
{
WebbLog.Instance.WriteLog("22");
preparedReports[0].CreatePdfDocument(strDestineFile);
WebbLog.Instance.WriteLog("33");
}
else
{
WebbLog.Instance.WriteLog("44");
XtraReport.UnionReportsToPdf(preparedReports, strDestineFile);
WebbLog.Instance.WriteLog("55");
}
}
catch (Exception ex2)
{
return("Failed:in create PDf Document|" + ex2.Message);
}
if (!System.IO.File.Exists(strDestineFile))
{
return("Failed:Undestine Pdf Error in create PDF");
}
return(strDestineFile);
}
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 string CreateReport(DataSet ds, string strDestineFile, string dllpath, string strUserFolder, string TemplateFileName, int[] TablesIndex)
{
strDestineFile = AdjustPDFFile(strDestineFile);
if (!strUserFolder.EndsWith(@"\"))
{
strUserFolder += @"\";
}
string[] templateFiles = TemplateFileName.Split(new char[] { ',' });
XtraReport[] preparedReports = new WebbReport[templateFiles.Length];
if (System.IO.File.Exists(strDestineFile))
{
System.IO.File.Delete(strDestineFile);
}
try
{
for (int i = 0; i < templateFiles.Length; i++)
{
templateFiles[i] = strUserFolder + templateFiles[i];
string strTemplate = templateFiles[i];
if (strTemplate != string.Empty)
{
int index = 0;
if (i < TablesIndex.Length)
{
index = TablesIndex[i];
}
DataTable table = ds.Tables[index].Copy();
WebbDataSource m_DBSource = new WebbDataSource();
m_DBSource.DataSource.Tables.Add(table);
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
WebbReport m_Report = new WebbReport();
Webb.Utility.ReplaceRefPathInRepxFile(strTemplate, dllpath); //Modify template file
m_Report.LoadLayout(strTemplate);
Webb.Utility.CurFileName = strTemplate; //06-23-2008@Scott
m_Report.SetDataSource(m_DBSource);
preparedReports[i] = m_Report;
}
}
}
catch (Exception ex)
{
return("Failed:in create report|" + ex.Message);
}
try
{
if (preparedReports.Length == 1)
{
preparedReports[0].CreatePdfDocument(strDestineFile);
}
else
{
XtraReport.UnionReportsToPdf(preparedReports, strDestineFile);
}
}
catch (Exception ex2)
{
return("Failed:in create PDf Document|" + ex2.Message);
}
if (!System.IO.File.Exists(strDestineFile))
{
return("Failed:Undestine Pdf Error in create PDF");
}
return(strDestineFile);
}
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();
}
}
public static void SetReportHeader(DBSourceConfig config, WebbReport webbReport, string strHeader)
{
//09-01-2011@Scott
if (strHeader == string.Empty)
{
return;
}
//End
string strReportHeader = strHeader;
if (strReportHeader == null || strReportHeader.Trim() == string.Empty || strReportHeader.ToLower() == "none")
{
return;
}
// report header
DevExpress.XtraReports.UI.Band band = webbReport.Bands[DevExpress.XtraReports.UI.BandKind.ReportHeader];
if (band != null)
{
foreach (DevExpress.XtraReports.UI.XRControl xrControl in band.Controls)
{
if (!(xrControl is DevExpress.XtraReports.UI.WinControlContainer))
{
continue;
}
Control c = (xrControl as DevExpress.XtraReports.UI.WinControlContainer).WinControl;
if (c is LabelControl)
{
if (config.WebbDBType == WebbDBTypes.WebbPlaybook || (c as LabelControl).IsTitle) //09-01-2011 Scott
{
(c as LabelControl).LabelControlView.Text = strReportHeader;
return;
}
}
}
}
// page header
band = webbReport.Bands[DevExpress.XtraReports.UI.BandKind.PageHeader];
if (band == null)
{
return;
}
foreach (DevExpress.XtraReports.UI.XRControl xrControl in band.Controls)
{
if (!(xrControl is DevExpress.XtraReports.UI.WinControlContainer))
{
continue;
}
Control c = (xrControl as DevExpress.XtraReports.UI.WinControlContainer).WinControl;
if (c is LabelControl && (config.WebbDBType == WebbDBTypes.WebbPlaybook || (c as LabelControl).IsTitle)) //09-01-2011 Scott
{
(c as LabelControl).LabelControlView.Text = strReportHeader;
return;
}
}
}
public bool UpdateControlStyle(ref ReportSetting setting)
{
if (setting.WebbReport == null)
{
return(false);
}
WebbReport webbReport = setting.WebbReport;
if (!this.StyleName.ToLower().StartsWith("basic"))
{
if (this._SerializableWatermark != null && setting.WaterMarkOption.UseWaterMark)
{
setting.WebbReport.Watermark = this._SerializableWatermark.ConvertTo();
}
}
Band band = webbReport.Bands[BandKind.Detail];
foreach (XRControl xrControl in band.Controls)
{
if (!(xrControl is WinControlContainer))
{
continue;
}
Control c = (xrControl as WinControlContainer).WinControl;
if (setting.TemplateType == TemplateType.PlayList)
{
if (!(c is GridControl))
{
continue;
}
if (this.ExcontrolStyles != null)
{
GridView gridView = (c as GridControl).GridView;
Font rowFont = gridView.Styles.RowStyle.Font;
if (!this.ExcontrolStyles.IsAllStyleFontEdited())
{
this.ExcontrolStyles.RowStyle.Font = (Font)rowFont.Clone();
this.ExcontrolStyles.AlternateStyle.Font = (Font)rowFont.Clone();
this.ExcontrolStyles.HeaderStyle.Font = (Font)rowFont.Clone();
}
if (!this.ExcontrolStyles.IsFontEdit(this.ExcontrolStyles.SectionStyle.Font))
{
this.ExcontrolStyles.SectionStyle.Font = new Font(this.ExcontrolStyles.RowStyle.Font.FontFamily.Name, this.ExcontrolStyles.RowStyle.Font.Size + 2, this.ExcontrolStyles.RowStyle.Font.Style | FontStyle.Bold);
}
this.ExcontrolStyles.SectionStyle.HorzAlignment = DevExpress.Utils.HorzAlignment.Near;
DevExpress.XtraPrinting.BorderSide sides = this.ExcontrolStyles.RowStyle.Sides;
if (sides == DevExpress.XtraPrinting.BorderSide.None)
{
foreach (GridColumn column in gridView.GridInfo.Columns)
{
if (column.Style.IsEdited())
{
column.Style.Sides = DevExpress.XtraPrinting.BorderSide.None;
}
}
}
gridView.Styles.ApplyStyle(this.ExcontrolStyles);
}
return(true);
}
else if (setting.TemplateType == TemplateType.Group)
{
if (!(c is GroupingControl))
{
continue;
}
if (this.ExcontrolStyles != null)
{
GroupView groupView = (c as GroupingControl)._GroupView;
Font rowFont = groupView.Styles.RowStyle.Font;
if (!this.ExcontrolStyles.IsAllStyleFontEdited())
{
this.ExcontrolStyles.RowStyle.Font = (Font)rowFont.Clone();
this.ExcontrolStyles.AlternateStyle.Font = (Font)rowFont.Clone();
this.ExcontrolStyles.HeaderStyle.Font = (Font)rowFont.Clone();
}
if (!this.ExcontrolStyles.IsFontEdit(this.ExcontrolStyles.SectionStyle.Font))
{
this.ExcontrolStyles.SectionStyle.Font = new Font(this.ExcontrolStyles.RowStyle.Font.FontFamily.Name, this.ExcontrolStyles.RowStyle.Font.Size + 2, this.ExcontrolStyles.RowStyle.Font.Style | FontStyle.Bold);
}
this.ExcontrolStyles.SectionStyle.HorzAlignment = DevExpress.Utils.HorzAlignment.Near;
DevExpress.XtraPrinting.BorderSide sides = this.ExcontrolStyles.RowStyle.Sides;
if (sides == DevExpress.XtraPrinting.BorderSide.None)
{
RemoveSides(groupView.RootGroupInfo);
}
groupView.Styles.ApplyStyle(this.ExcontrolStyles);
}
}
}
return(true);
}
