//解析存储全国区域网格表
public static void PraseGridUnitConfigAllChina(string computernode)
{
//！！取出当前key值
string keyString = "china";
//! 数据库表类型对应的表名
//！2\创建个map容器，key:value（表类型：数据库表名）
Dictionary <string, DataTable> tableTypes = new Dictionary <string, DataTable>();
//！遍历table，存储起来
string[] tbnames = { "GRID_HSFX_UNIT", "HSFX_ComputeUnit" };
int tableNum = tbnames.Length;
for (int i = 0; i != tableNum; ++i)
{
//!当前表名类型
string tableTypeName = tbnames[i];
string sql = String.Format("SELECT * from {0}", tbnames[i]);
if (tableTypeName == "GRID_HSFX_UNIT")
{
sql = String.Format(@"SELECT
T1.*
FROM
{0} T1
INNER JOIN(
SELECT
a.ComputeUnit,
b.bswatacd
FROM
HSFX_ComputeUnit a
LEFT JOIN HSFX_Computer b ON a.ComputeNode = b.ComputeNode
WHERE
a.ComputeNode = '{1}'
) T2 ON T1.GroupID = T2.ComputeUnit
AND T1.bswatacd = T2.bswatacd
ORDER BY province asc", tbnames[i], computernode);
}
else if (tableTypeName == "HSFX_ComputeUnit")
{
sql = String.Format(@"SELECT
*
FROM
{0}
WHERE
ComputeNode = '{1}'
AND ComputeUnit > 100
ORDER BY
ComputeUnit ", tbnames[i], computernode);
}
DataTable value = Dal_Rain.GetDataBySql(keyString, sql);
tableTypes.Add(tableTypeName, value);
}
//! 存储
m_dbTableConfig.Add(keyString, tableTypes);
}
public static bool IsValidDat(string datName)
{
String errinfoSQL = String.Format("select * from Grid_TaiFeng_ErrorCALC where DATName = '{0}'", datName);
string keyString = "china";
DataTable dt = Dal_Rain.GetDataBySql(keyString, errinfoSQL);
if (dt.Rows.Count > 0)
{
return(false);
}
return(true);
}
public static void PraseComputerTableConfig()
{
//！！取出当前key值
string keyString = "china";
string tableTypeName = "HSFX_COMPUTER_Group";
string sql = String.Format("SELECT * from {0}", tableTypeName);
DataTable value = Dal_Rain.GetDataBySql(keyString, sql);
//! 遍历DataTable存储
for (int i = 0; i < value.Rows.Count; ++i)
{
string ip = value.Rows[i]["ComputerIP"].ToString();
string node = value.Rows[i]["ComputeNode"].ToString();
m_computerValues.Add(ip, node);
}
}
public static void PraseGridUnitConfig()
{
m_dbTableConfig.Clear();
int num = m_dataBaseConnects.Count;
foreach (var curDB in m_dataBaseConnects)
{
//！！取出当前key值
string keyString = curDB.Key;
//! 数据库表类型对应的表名
//！2\创建个map容器，key:value（表类型：数据库表名）
Dictionary <string, DataTable> tableTypes = new Dictionary <string, DataTable>();
//！遍历table，存储起来
string[] tbnames = { "GRID_HSFX_UNIT", "HSFX_ComputeUnit" };
int tableNum = tbnames.Length;
for (int i = 0; i != tableNum; ++i)
{
//!当前表名类型
string tableTypeName = tbnames[i];
string sql = String.Format("SELECT * from {0}", tbnames[i]);
if (tableTypeName == "GRID_HSFX_UNIT")
{
sql = String.Format("SELECT * from {0} where GroupID <> 9999 order by ID", tbnames[i]);
}
else if (tableTypeName == "HSFX_ComputeUnit")
{
sql = String.Format("select * from {0} where ComputeUnit > 100 ORDER BY ComputeUnit", tbnames[i]);
}
DataTable value = Dal_Rain.GetDataBySql(keyString, sql);
tableTypes.Add(tableTypeName, value);
}
//! 存储
m_dbTableConfig.Add(keyString, tableTypes);
}
}