public static DataTable GetListData(String[] macroIDs, MacroDataType type)
{
DataTable table = new DataTable();
DataTransmission item = null;
List <DataTransmission> dtList = null;
try
{
item = new DataTransmission();
item.Filters = new List <Expression>(2);
item.Filters.Add(Expression.In("STR_MACROID", macroIDs));
item.Filters.Add(Expression.Eq("STR_FLAG", "0"));
item.DataSource = MongoDBConstant.DicTreeSource[type];
item.MaxResult = 0x7fffffff;
item.Fields = new String[] { "STR_MACROID", "STR_STARTDATE", "STR_ENDDATE", "STR_GXDATE" };
dtList = new List <DataTransmission>(1);
dtList.Add(item);
table = _uniqueQuery.Query(dtList).Tables[0];
}
catch (Exception exception)
{
//EMLoggerHelper.Write(exception);
}
finally
{
if (item != null)
{
if ((item.Fields != null) && (item.Fields.Length > 0))
{
Array.Clear(item.Fields, 0, item.Fields.Length);
item.Fields = null;
}
item.Clear();
item = null;
}
if (dtList != null)
{
dtList.Clear();
dtList = null;
}
}
return(table);
}
public static DataSet GetGivenFieldMacroData(FindIndicator queryContditon, String[] fields)
{
Stopwatch stopwatch = new Stopwatch();
stopwatch.Start();
DataSet set = new DataSet();
List <DataTransmission> dtList = null;
DataTransmission item = null;
try
{
item = new DataTransmission();
item.MaxResult = 0x7fffffff;
if ((fields != null) && (fields.Length > 0))
{
item.Fields = fields;
}
item.Filters = GetFilterExpress(queryContditon);
dtList = new List <DataTransmission>();
if (queryContditon.findRange == MacroDataType.All)
{
item.DataSource = "EDB_MACRO_INDICATOR_TEST";
dtList.Add(item);
DataTransmission transmission2 = new DataTransmission();
transmission2.MaxResult = 0x7fffffff;
transmission2.Fields = fields;
transmission2.DataSource = "EDB_GLOBAL_INDICATOR_TEST";
transmission2.Filters = item.Filters;
dtList.Add(transmission2);
DataTransmission transmission3 = new DataTransmission();
transmission3.MaxResult = 0x7fffffff;
transmission3.Fields = fields;
transmission3.DataSource = "EDB_INDUSTRY_INDICATOR_TEST";
transmission3.Filters = item.Filters;
dtList.Add(transmission3);
}
else
{
item.DataSource = MongoDBConstant.DicTreeSource[queryContditon.findRange];
dtList.Add(item);
}
set = _uniqueQuery.Query(dtList);
}
catch (Exception exception)
{
//EMLoggerHelper.Write(exception);
}
finally
{
stopwatch.Stop();
//EMLoggerHelper.Write("搜索耗时{0}", new object[] { stopwatch.ElapsedMilliseconds });
if (item != null)
{
item.Clear();
}
if (dtList != null)
{
dtList.Clear();
}
}
return(set);
}
