/// <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;
}
