/// <summary>
/// 添加数据
/// </summary>
/// <param name="data">数据</param>
public static void AddData(List <Dic> data)
{
// 初始化数据库
MongoDatabase mongoDatabase = MongoFactory.GetMongoDatabaseByDic();
// 初始化表
MongoCollection mongoCollection = mongoDatabase.GetCollection("dicTable");
// 插入数据
foreach (var item in data)
{
mongoCollection.Insert(item);
}
}
/// <summary>
/// 更新数据
/// </summary>
/// <param name="data">数据</param>
public static void UpdateData(List <Dic> data)
{
// 初始化数据库
MongoDatabase mongoDatabase = MongoFactory.GetMongoDatabaseByDic();
// 初始化表
MongoCollection mongoCollection = mongoDatabase.GetCollection("dicTable");
foreach (var item in data)
{
var query = GetQueryCondition(item);
mongoCollection.Remove(query);
mongoCollection.Insert(item);
}
}
/// <summary>
/// 根据key查看数据
/// </summary>
/// <param name="key">key</param>
/// <returns>数据</returns>
public static List <Dic> ViewTheData(string key)
{
// 初始化数据库
MongoDatabase mongoDatabase = MongoFactory.GetMongoDatabaseByDic();
// 初始化表
MongoCollection mongoCollection = mongoDatabase.GetCollection("dicTable");
List <IMongoQuery> queryList = new List <IMongoQuery>
{
Query.EQ("Key", key)
};
IMongoQuery query = Query.And(queryList);
List <Dic> dics = mongoCollection.FindAs <Dic>(query).ToList();
return(dics);
}
/// <summary>
/// 设置更新时间
/// </summary>
/// <param name="code">业务代码</param>
/// <param name="dateTime">更新时间</param>
public static void SetUpdateTime(string code, DateTime dateTime)
{
MongoDatabase mongoDatabase = MongoFactory.GetMongoDatabaseByDic();
MongoCollection mongoCollection = mongoDatabase.GetCollection("UpdateTime");
List <IMongoQuery> queryList = new List <IMongoQuery>
{
Query.EQ("Key", code)
};
var query = Query.And(queryList);
mongoCollection.Remove(query);
UpdateTime updateTime = new UpdateTime
{
Key = code,
Time = dateTime
};
mongoCollection.Insert(updateTime);
}
/// <summary>
/// 获取最后更新时间
/// </summary>
/// <param name="code">业务代码</param>
/// <returns>时间</returns>
public static DateTime GetLastUpdateTime(string code)
{
MongoDatabase mongoDatabase = MongoFactory.GetMongoDatabaseByDic();
MongoCollection mongoCollection = mongoDatabase.GetCollection("UpdateTime");
List <IMongoQuery> queryList = new List <IMongoQuery>
{
Query.EQ("Key", code)
};
var query = Query.And(queryList);
List <UpdateTime> time = mongoCollection.FindAs <UpdateTime>(query).ToList();
if (time.Count == 0)
{
return(default(DateTime));
}
else
{
return(time[0].Time);
}
}