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