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