/// <summary>
/// 短信记录分页索引，从0起始
/// 短信记录分页大小,最大是1000
/// </summary>
/// <param name="sms"></param>
public SmsPageQuery Post([FromBody] SmsQuery sms)
{
var readPreference = new ReadPreference(ReadPreferenceMode.SecondaryPreferred);
MongoDatabaseSettings mdSetting = new MongoDatabaseSettings();
mdSetting.ReadPreference = readPreference;
var connectionString = ConfigurationManager.AppSettings["dbCon"];
var database = ConfigurationManager.AppSettings["dbName"];
MongoClient client = new MongoClient(connectionString); //连接mogodb数据库
IMongoDatabase db = client.GetDatabase(database, mdSetting); //数据库
var smsCollection = db.GetCollection <SmsInfo>("tblSMS"); //表
var query = new BsonDocument("cNo", sms.cNo);
var sort = sms.sort == 0 ? new BsonDocument("oDate", 1) : new BsonDocument("oDate", -1);
if (sms.pageSize > 1000)
{
sms.pageSize = 1000;
}
if (sms.pageIndex < 0)
{
sms.pageIndex = 0;
}
var pageData = smsCollection.Find(query).Sort(sort).Skip(sms.pageSize * sms.pageIndex).Limit(sms.pageSize).ToList().ToArray();
SmsPageQuery smsPageQuery = new SmsPageQuery();
smsPageQuery.pageIndex = sms.pageIndex;
smsPageQuery.total = smsCollection.CountAsync(query).Result;
smsPageQuery.SmsInfos = pageData;
return(smsPageQuery);
}
public async Task <QueryResult <Sms> > Get(SmsQuery smsQuery)
{
var result = new QueryResult <Sms>();
var query = _context.Sms.Where(e => e.DateTime >= smsQuery.DateTimeFrom && e.DateTime <= smsQuery.DateTimeTo);
result.TotalCount = await query.CountAsync();
result.Items = await query.Skip(smsQuery.Skip).Take(smsQuery.Take).ToListAsync();
return(result);
}
public async Task <QueryResult <Sms> > GetSentSmsJSON([FromQuery] SmsQuery req)
{
//var sms = _mapper.Map<Model.Sms>(req);
return(await _business.GetSentSms(req));
}
public async Task <QueryResult <Sms> > GetSentSms(SmsQuery smsQuery)
{
smsQuery.SortBy = "DateTime";
smsQuery.IsSortAscending = true;
return(await _uow.Sms.GetPagedAsync(smsQuery));
}
public string SmsQuery(SmsQuery query)
{
return "TEST QUERY";
}
