public override ExpectList <T> ReadHistory <T>(string begt, string endt)
{
DateTime dt = DateTime.Parse(begt);
MongoDataDictionary <ExchangeMongoData> res = GetAllCodeDateSerialDataList <ExchangeMongoData>(begt, endt, true);
Dictionary <string, MongoReturnDataList <ExchangeMongoData> > data = res;
ExpectList <ExchangeMongoData> ret = new ExpectList <ExchangeMongoData>(data, true);
ExpectList <T> retlist = new ExpectList <T>();
ret.DataList.ForEach(a => {
ExpectData <T> ed = new ExpectData <T>();
ed.CurrTime = null;
ed.Key = "Security";
foreach (string code in a.Keys)
{
if (ed.CurrTime == null)
{
ed.CurrTime = a[code].date;
}
ed.Expect = MongoDateTime.StampToDate(a[code].date_stamp).Ticks.ToString();
ed.Add(code, a[code] as T);
}
retlist.Add(ed);
});
return(retlist);
}
public override MongoReturnDataList <T> getData <T>(string begT, string endT, bool Asc)
{
////FilterDefinition<T> filter = Builders<T>.Filter.Empty;
////if (Codes.Length == 1)
//// filter = filter & Builders<T>.Filter.Eq(a => (a as ICodeData).code, Codes[0]);
////else
////{
//// //filter = filter & Builders<T>.Filter.In(a => (a as ICodeData).code, Codes);
//// FieldDefinition<T> existsval = "{code:{$exist:{0}}}".Replace("{0}",string.Join(",", Codes));
//// filter = filter & Builders<T>.Filter.Exists(existsval, true);
////}
////filter = filter & Builders<T>.Filter.Gte(a => (a as IDateStampData).date_stamp, MongoDateTime.Stamp(begT));
////filter = filter & Builders<T>.Filter.Lte(a => (a as IDateStampData).date_stamp, MongoDateTime.Stamp(endT));
////SortDefinition<T> sort = null;
////FieldDefinition<T> fd = "{code:1,date_stamp:1}";
////if (Asc)
////{
//// // var sort = SortBy.Ascending("surname").Descending("email");
//// sort = Builders<T>.Sort.Ascending(fd);
////}
////else
////{
//// sort = Builders<T>.Sort.Descending(fd);
////}
//查询字段
//string[] fileds = null;
MongoReturnDataList <T> ret = new MongoReturnDataList <T>();
if (Codes == null || Codes.Length == 0)
{
return(ret);
}
string sql = "{date_stamp:{$lte:{1},$gte:{2}},code:'{0}'}".Replace("{0}", Codes[0]).Replace("{1}", MongoDateTime.Stamp(endT).ToString()).Replace("{2}", MongoDateTime.Stamp(begT).ToString());
if (Codes.Length > 1)
{
sql = "{date_stamp:{$lte:{1},$gte:{2}},code:{$in:['{0}']}}".Replace("{0}", string.Join("','", Codes)).Replace("{1}", MongoDateTime.Stamp(endT).ToString()).Replace("{2}", MongoDateTime.Stamp(begT).ToString());;
}
string sort = "{code_1_date_stamp_1:1}";
return(new MongoReturnDataList <T>(_mongoDB.FindList <T>(this.TableName, sql, sort)));
}
public override MongoReturnDataList <T> getData <T>(string begT, bool Asc)
{
FilterDefinition <T> filter = Builders <T> .Filter.Empty;
if (Codes.Length == 1)
{
filter = filter & Builders <T> .Filter.Eq(a => (a as ICodeData).code, Codes[0]);
}
else
{
filter = filter & Builders <T> .Filter.In(a => (a as ICodeData).code, Codes);
}
filter = filter & Builders <T> .Filter.Gte(a => (a as IDateStampData).date_stamp, MongoDateTime.Stamp(begT));
SortDefinition <T> sort = null;
FieldDefinition <T> fd = "{code_1_date_stamp_1:1}";
if (Asc)
{
//sort = Builders<T>.Sort.Ascending(a => (a as IDateStampData).date_stamp);
sort = Builders <T> .Sort.Ascending(fd);
}
else
{
//sort = Builders<T>.Sort.Descending(a => (a as IDateStampData).date_stamp);
sort = Builders <T> .Sort.Descending(fd);
}
//查询字段
string[] fileds = null;
return(new MongoReturnDataList <T>(_mongoDB.FindList <T>(this.TableName, filter, fileds, sort)));
}
