/// <summary> /// 设置视图级信息 /// </summary> private void SetViewMeta(UpgradeReport ur) { UpgradeReportView urv = new UpgradeReportView(ur); ur.ReportViews.Add(urv); urv.ID = this.GetArgString(UpgradeReportMetaWrapper.ViewId); urv.bSystem = this.GetArgBoolean(UpgradeReportMetaWrapper.ViewIsSystem); urv.ViewType = this.GetArgInt(UpgradeReportMetaWrapper.ViewViewType); urv.GroupSchemas = this.GetArgString(UpgradeReportMetaWrapper.ViewGroupSchemas); urv.CommonFormat = this.GetArgString(UpgradeReportMetaWrapper.ViewCommonFormat); urv.LevelExpand = this.GetArgString(UpgradeReportMetaWrapper.ViewLevelExpand); urv.Columns = this.GetArgString(UpgradeReportMetaWrapper.ViewColumns); urv.BlandScape = this.GetArgBoolean(UpgradeReportMetaWrapper.ViewBlandScape); urv.PageMargins = this.GetArgString(UpgradeReportMetaWrapper.ViewPageMargins, "80,80,80,80"); urv.PaperType = this.GetArgInt(UpgradeReportMetaWrapper.ViewPaperType); this.AddViewLoacleInfo("zh-CN", this.GetArgString(UpgradeReportMetaWrapper.ViewLocaleFormatCN), urv); this.AddViewLoacleInfo("zh-TW", this.GetArgString(UpgradeReportMetaWrapper.ViewLocaleFormatTW), urv); this.AddViewLoacleInfo("en-US", this.GetArgString(UpgradeReportMetaWrapper.ViewLocaleFormatEN), urv); }
/// <summary> /// 设置报表级基础信息 /// </summary> private void SetReportBase(UpgradeReport ur) { ur.ID = this.GetArgString(UpgradeReportMetaWrapper.ReportId); ur.SubProjectID = this.GetArgString(UpgradeReportMetaWrapper.ReportSubId); ur.FilterID = this.GetArgString(UpgradeReportMetaWrapper.ReportFilterId); ur.ClassName = this.GetArgString(UpgradeReportMetaWrapper.ReportClassName); ur.FilterClass = this.GetArgString(UpgradeReportMetaWrapper.ReportFilterClass); ur.bSystem = this.GetArgBoolean(UpgradeReportMetaWrapper.ReportIsSystem); ur.HelpFileName = this.GetArgString(UpgradeReportMetaWrapper.ReportHelpFileName); ur.HelpIndex = this.GetArgString(UpgradeReportMetaWrapper.ReportHelpIndex); ur.HelpKeyWord = this.GetArgString(UpgradeReportMetaWrapper.ReportHelpKeyWord); ur.ReportName861 = this.GetArgString(UpgradeReportMetaWrapper.ReportName861); ur.MappingMenuId = this.GetArgString(UpgradeReportMetaWrapper.MappingMenuId); ur.Description = this.GetArgString(UpgradeReportMetaWrapper.Description); this.AddReportLoacleInfo("zh-CN", this.GetArgString(UpgradeReportMetaWrapper.ReportNameCN), ur); this.AddReportLoacleInfo("zh-TW", this.GetArgString(UpgradeReportMetaWrapper.ReportNameTW), ur); this.AddReportLoacleInfo("en-US", this.GetArgString(UpgradeReportMetaWrapper.ReportNameEN), ur); ur.AppServer = this.GetArgString(UpgradeReportMetaWrapper.DBAppServer); ur.DbConnString = this.GetArgString(UpgradeReportMetaWrapper.DBUfMetaConnString); ur.cAccId = this.GetArgString(UpgradeReportMetaWrapper.DBcAccId); ur.cYear = this.GetArgString(UpgradeReportMetaWrapper.DBcYear); ur.DataSourceInfo.DataSourceBO = (BusinessObject)this._meta[UpgradeReportMetaWrapper.ReportDataSourceBO]; ur.RootReportId = this.GetArgString(UpgradeReportMetaWrapper.RootReportId); ur.IsNeedExpandEN = this.GetArgBoolean(UpgradeReportMetaWrapper.IsNeedExpandEN); ur.IsNeedExpandTW = this.GetArgBoolean(UpgradeReportMetaWrapper.IsNeedExpandTW); }
public bool Upgrade() { ColumnCollection oldcolumns = null; BusinessObject BO = null; object dsid = SqlHelper.ExecuteScalar(_metastring, "select DataSourceID from uap_report where id='" + _reportid + "'"); if (dsid != null) { oldcolumns = ((QueryFunction)BO.Functions[0]).QuerySettings[0].QueryResultTable.Columns; //((QueryFunction)BO.Functions[0]).QuerySettings[0].QueryResultTable.Columns=new ColumnCollection(); } else { //new bo } ColumnCollection newcolumns = ((QueryFunction)BO.Functions[0]).QuerySettings[0].QueryResultTable.Columns; //获取老报表数据,考虑列的顺序 SqlDataReader reader = SqlHelper.ExecuteReader(_datastring, "select ,, from rpt order by orderid"); while (reader.Read()) { string columnname = reader["ColumnName"].ToString(); TableColumn column = AlreadyInColumns(columnname, oldcolumns); if (column != null) { newcolumns.Add(column); } else//不存在则加进去 { DataTypeEnum dt = GetDataType(); string desc = null; column = new TableColumn(columnname, dt, desc); newcolumns.Add(column); } } ConfigureServiceProxy c = new ConfigureServiceProxy(); c.UpdateBusinessObject(BO); UpgradeReport ur = new UpgradeReport(); ur.DataSourceID = BO.MetaID; //创建BusinessObject对象,并调用Save方法 //创建Report对象,并调用Save方法 //reportengine //Report report=reportengine.DesignReport() //reportengine.UpgradeSave(report,ref commonxml,ref cnxml,ref twxml,ref enxml); //if rpt_id在meta库中UAP_Report表不存在 //BusinessObject BO = new BusinessObject(); //else rpt_id在meta库中UAP_Report表存在 //ConfigureServiceProxy proxy =new ConfigureServiceProxy(); //proxy.GetBusinessObject() ur.Save(); return(true); }
/// <summary> /// 根据已填充的数据构造一个UpgradeReport对象 /// </summary> public UpgradeReport WrapData2Object() { //this.Check(); UpgradeReport ur = new UpgradeReport(); this.SetReportBase(ur); this.SetViewMeta(ur); return(ur); }
private void AddReportLoacleInfo( string locale, string name, UpgradeReport ur) { ReportLocaleInfo rli = new ReportLocaleInfo(); rli.LocaleID = locale; rli.Name = name; ur.ReportLocaleInfos.Add(rli); }
public void UpgradeFactoryBak(string id) { try { string[] elements = this.GetSubIdAndReportName(id); UpgradeReportMetaWrapper urmw = new UpgradeReportMetaWrapper(); urmw.SetArgument(UpgradeReportMetaWrapper.ReportId, id); urmw.SetArgument(UpgradeReportMetaWrapper.ReportName861, elements[1]); urmw.SetArgument(UpgradeReportMetaWrapper.ReportSubId, elements[0]); urmw.SetArgument(UpgradeReportMetaWrapper.DBAppServer, this._loginInfor.AppServer); urmw.SetArgument(UpgradeReportMetaWrapper.DBUfMetaConnString, this._loginInfor.UfMetaCnnString); urmw.SetArgument(UpgradeReportMetaWrapper.DBcAccId, this._loginInfor.cAccId); urmw.SetArgument(UpgradeReportMetaWrapper.DBcYear, this._loginInfor.cYear); // 升级数据源,格式.... Hashtable infos = new Hashtable(); infos[Upgrade872Controller.InfoKeyLoginInfo] = this._loginInfor; infos[Upgrade872Controller.InfoKeyReportSubId] = elements[0]; infos[Upgrade872Controller.InfoKeyReportName861] = elements[1]; UpgradeFormatService ufs = new UpgradeFormatService(); ufs.DeliverEnvironmentInfos(infos); //升级出厂设置的视图数据 ufs.SetMeta(urmw, true); UpgradeReport ur = urmw.WrapData2Object(); ur.SaveFactoryView(); } catch (Exception e) { Logger logger = Logger.GetLogger("Report872UpradeError"); logger.Error(e); throw e; } finally { GC.Collect(); } }
public void Upgrade(string id, string filterstring, string classname) { try { UpgradeReportMetaWrapper urmw = new UpgradeReportMetaWrapper(); urmw.SetArgument(UpgradeReportMetaWrapper.ReportId, id); urmw.SetArgument(UpgradeReportMetaWrapper.ReportName861, id); urmw.SetArgument(UpgradeReportMetaWrapper.ReportSubId, _loginInfor.SubID); urmw.SetArgument(UpgradeReportMetaWrapper.DBAppServer, this._loginInfor.AppServer); urmw.SetArgument(UpgradeReportMetaWrapper.DBUfMetaConnString, this._loginInfor.UfMetaCnnString); urmw.SetArgument(UpgradeReportMetaWrapper.DBcAccId, this._loginInfor.cAccId); urmw.SetArgument(UpgradeReportMetaWrapper.DBcYear, this._loginInfor.cYear); // 升级数据源,格式.... Hashtable infos = new Hashtable(); infos[Upgrade872Controller.InfoKeyLoginInfo] = this._loginInfor; infos[Upgrade872Controller.InfoKeyReportSubId] = _loginInfor.SubID; infos[Upgrade872Controller.InfoKeyReportName861] = id; UpgradeFormatServiceOutU8 ufs = new UpgradeFormatServiceOutU8(); ufs.DeliverEnvironmentInfos(infos); ufs.SetMeta(urmw, filterstring, classname); UpgradeReport ur = urmw.WrapData2Object(); ur.Save(); } catch (Exception e) { Logger logger = Logger.GetLogger("Report872UpradeError"); logger.Error(e); throw e; } finally { GC.Collect(); } }
public UpgradeReportView(UpgradeReport report) { this._ViewLocaleInfos = new ReportViewLocaleInfoCollection(this); this._Report = report; }
internal ReportLocaleInfoCollection(UpgradeReport report) { this.Report = report; }