private void QueryIDs(string[] dataSets)
{
long setID, prdsID;
double selfFillValue, dayFillValue, dayInvalidValue;
string set;
foreach (string setName in dataSets)
{
set = setName.Replace("_", "");
if (_dbCon.QueryDatasetsID("AIRS", set, out prdsID, out setID))
{
_pro._datasetsIDs.Add(set, setID);
_pro._datasetsPrdsIDs.Add(set, prdsID);
}
if (_dbCon.QueryDatasetsInvalidValue("AIRS", set, out selfFillValue, out dayFillValue, out dayInvalidValue))
{
_pro._selfFillValue.Add(set, selfFillValue);
_pro._dayFillValue.Add(set, dayFillValue);
_pro._dayInvalidValue.Add(set, dayInvalidValue);
}
}
long regionID;
foreach (PrjEnvelopeItem prjItem in _prjEnvelopes)
{
if (!_dbCon.IshasDataRegionRecord(prjItem, out regionID)) //!_dbCon.IshasRecord(tableName, "regionName", prjItem.Name.ToLower()))
{
regionID = _dbCon.InsertRegionTable(prjItem.Name.ToLower(), prjItem.PrjEnvelope.MinX, prjItem.PrjEnvelope.MaxX, prjItem.PrjEnvelope.MinY, prjItem.PrjEnvelope.MaxY);
}
_pro._regionIDs.Add(prjItem.Name, regionID);
}
}