public static void SaveDirectInsertDataIntoTable(
DataSourceInfor dataSourceInfor,
string cnnString)
{
string sql = UpgradeSqlProducer.GetSqlDirectSaveDataSourceIntoTable(dataSourceInfor);
SqlHelper.ExecuteNonQuery(cnnString, sql);
Trace.WriteLine("直接写入表BD_BusinessObjects，成功保存数据源! ID:" + dataSourceInfor.MetaID);
}
private DataTable GetLevelExpandInfor()
{
string sql = UpgradeSqlProducer.GetSqlLevelExpandInforUpgrade(_ReportId);
DataSet ds = SqlHelper.ExecuteDataSet(_UfDataCnnString, sql);
DataRow dr = SqlHelper.GetDataRowFrom(0, ds);
if (dr != null)
{
return(ds.Tables[0]);
}
return(null);
}
// 计算列时cell的Name取的中文下的Name字段
// 而非简体下的可能不一样会导致计算列在非简体
// 下没有该计算列
public string GetCaculateColumnName(
string id,
string orderEx,
string topEx)
{
string sql = UpgradeSqlProducer.GetSqlCaculateColumnName(id, orderEx, topEx);
DataSet ds = SqlHelper.ExecuteDataSet(_UfDataConnString, sql);
DataRow dr = SqlHelper.GetDataRowFrom(0, ds);
if (dr != null)
{
return(SqlHelper.GetStringFrom(dr[0]));
}
return(string.Empty);
}
public static string GetFieldNote(
string ufDataCnnString,
string reportId)
{
string note = string.Empty;
string sql = UpgradeSqlProducer.GetSqlOldReportInfor(reportId, "zh-CN");
DataSet ds = SqlHelper.ExecuteDataSet(ufDataCnnString, sql);
DataRow dr = SqlHelper.GetDataRowFrom(0, ds);
if (dr != null)
{
return(SqlHelper.GetStringFrom(dr["Note"]));
}
return(string.Empty);
}
private void PrepareDataColumnInfor()
{
string sql = UpgradeSqlProducer.GetSqlFldDefInfors(_ReportID, _LocaleID, "0");
DataSet ds = SqlHelper.ExecuteDataSet(_UfDataConnString, sql);
if (ds != null)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
DataColumnInfor col = new DataColumnInfor();
DataRow dr = ds.Tables[0].Rows[i];
col.Name = SqlHelper.GetStringFrom(dr["Expression"]);
col.Description = SqlHelper.GetStringFrom(dr["Name"]);
col.FormatEx = SqlHelper.GetStringFrom(dr["FormatEx"]);
if (col.Name == string.Empty)
{
col.Name = col.Description;
}
_DataColumnInfors.Add(col);
}
_DataColumnInfors.Sort();
}
sql = UpgradeSqlProducer.GetSqlSummaryColInfor(_ReportID);
ds = SqlHelper.ExecuteDataSet(_UfDataConnString, sql);
if (ds != null)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
DataColumnInfor col = new DataColumnInfor();
DataRow dr = ds.Tables[0].Rows[i];
col.Name = SqlHelper.GetStringFrom(dr["Name"]);
col.OperatorType = SqlHelper.GetStringFrom(dr["OperatorTypeType"]);
// 这步处理与GetSqlSummaryColInfor中ORDER BY OperatorTypeType呼应
if (_SummaryTypeInfors[col.Name] == null)
{
_SummaryTypeInfors.Add(col);
}
}
}
_IsFilledData = true;
}
public static string GetSqlBaseTableOldId(
string ufDataCnnString,
string reportId,
string subId)
{
string note = GetFieldNote(ufDataCnnString, reportId);
if (note != string.Empty)
{
string sql = UpgradeSqlProducer.GetSqlOldReportInfor(note, subId, "zh-CN");
DataSet ds = SqlHelper.ExecuteDataSet(ufDataCnnString, sql);
DataRow dr = SqlHelper.GetDataRowFrom(0, ds);
if (dr != null)
{
return(SqlHelper.GetStringFrom(dr["ID"]));
}
}
return(string.Empty);
}