/// <summary>
/// 大量插入数据。
/// </summary>
/// <param name="sdb"></param>
static void Test4(Sequoiadb sdb)
{
using (AgileHIS.Entities.DbEntities db = new AgileHIS.Entities.DbEntities())
{
var vList = db.HFareDetails.ToList();
var cs = sdb.GetCollecitonSpace("dbo");
var coll = cs.GetCollection <HFareDetail>();
//插入。
foreach (var item in vList)
{
coll.Insert(item);
}
System.Console.WriteLine(string.Format("insert {0} records", vList.Count));
System.Console.ReadLine();
}
}
static void Test2(Sequoiadb sdb)
{
using (AgileHIS.Entities.DbEntities db = new AgileHIS.Entities.DbEntities())
{
var v = db.GBCodes.FirstOrDefault();
BsonDocument doc = new BsonDocument();
using (SequoiaDB.Bson.IO.BsonWriter w = SequoiaDB.Bson.IO.BsonWriter.Create(doc))
{
SequoiaDB.Bson.Serialization.BsonSerializer.Serialize <GBCode>(w, v);
}
var cs = sdb.GetCollecitonSpace("dbo");
DBCollection coll = null;
if (!cs.IsCollectionExist("GBCode"))
{
coll = cs.CreateCollection("GBCode");
}
else
{
coll = cs.GetCollection("GBCode");
}
//插入。
var vValue = coll.Insert(doc);
System.Console.WriteLine(doc);
//
BsonDocument matcher = new BsonDocument();
DBQuery query = new DBQuery();
query.Matcher = matcher;
DBCursor cursor = coll.Query(query);
BsonDocument bson = cursor.Next();
var v2 = SequoiaDB.Bson.Serialization.BsonSerializer.Deserialize <GBCode>(bson);
System.Console.WriteLine(bson);
System.Console.ReadLine();
}
}
static void Test2(Sequoiadb sdb)
{
using (AgileHIS.Entities.DbEntities db = new AgileHIS.Entities.DbEntities())
{
var v = db.GBCodes.FirstOrDefault();
BsonDocument doc = new BsonDocument();
using (SequoiaDB.Bson.IO.BsonWriter w = SequoiaDB.Bson.IO.BsonWriter.Create(doc))
{
SequoiaDB.Bson.Serialization.BsonSerializer.Serialize<GBCode>(w, v);
}
var cs = sdb.GetCollecitonSpace("dbo");
DBCollection coll = null;
if (!cs.IsCollectionExist("GBCode"))
coll = cs.CreateCollection("GBCode");
else
coll = cs.GetCollection("GBCode");
//插入。
var vValue= coll.Insert(doc);
System.Console.WriteLine(doc);
//
BsonDocument matcher = new BsonDocument();
DBQuery query = new DBQuery();
query.Matcher = matcher;
DBCursor cursor = coll.Query(query);
BsonDocument bson = cursor.Next();
var v2 = SequoiaDB.Bson.Serialization.BsonSerializer.Deserialize<GBCode>(bson);
System.Console.WriteLine(bson);
System.Console.ReadLine();
}
}
/// <summary>
/// 大量插入数据。
/// </summary>
/// <param name="sdb"></param>
static void Test4(Sequoiadb sdb)
{
using (AgileHIS.Entities.DbEntities db = new AgileHIS.Entities.DbEntities())
{
var vList = db.HFareDetails.ToList();
var cs = sdb.GetCollecitonSpace("dbo");
var coll = cs.GetCollection<HFareDetail>();
//插入。
foreach (var item in vList)
{
coll.Insert(item);
}
System.Console.WriteLine(string.Format("insert {0} records",vList.Count));
System.Console.ReadLine();
}
}
/// <summary>
/// Linq测试。
/// </summary>
/// <param name="sdb"></param>
static void TestLinq2(Sequoiadb sdb)
{
////create Sequoiadb
//Sequoiadb sdb = new Sequoiadb("192.168.23.57:50000");
//sdb.Connect("", "");
//GetCollecitonSpace。
var cs = sdb.GetCollecitonSpace("dbo");
//GetCollection。
var coll = cs.GetCollection<HFareDetail>();
//insert from rdb。
List<HFareDetail> vList =null;
using (AgileHIS.Entities.DbEntities db = new AgileHIS.Entities.DbEntities())
{
vList = db.HFareDetails.ToList();
//insert。
foreach (var item in vList)
{
coll.Insert(item);
}
System.Console.WriteLine(string.Format("insert {0} records", vList.Count));
System.Console.ReadLine();
}
//update docuemnt by linq。
var v1 = vList.FirstOrDefault();
v1.Name = string.Empty;
v1.Cash = decimal.Zero;
coll.Update(v1, p => p.ID == v1.ID);
//update docuemnt by linq。
coll.Update(p => new HFareDetail { Cash = decimal.Zero, Name = string.Empty, Price = decimal.Zero }, p => p.ChargeTime >DateTime.Now.AddDays(-1));
//delete by linq
coll.Delete(p => p.ChargeTime > DateTime.Now.AddDays(-1));
//get Count
int count = coll.AsQueryable<HFareDetail>()
.Where(p => p.SourceID==0)
.Count();
//Linq query Take\Skip。
var vList2 = coll.AsQueryable<HFareDetail>()
.Where(p => p.CreateTime > DateTime.Now.Date.AddMonths(-12))
.Skip(10).Take(1000)
.ToList();
System.Console.WriteLine(string.Format("query {0} records", vList.Count));
//Linq FirstOrDefault。
var vFare = coll.AsQueryable<HFareDetail>()
.Where(p => p.CreateTime > DateTime.Now.Date.AddMonths(-12))
.FirstOrDefault();
System.Console.WriteLine(vFare);
//Linq aggregate，Not Implemented
var sum = coll.AsQueryable<HFareDetail>()
.Where(p => p.CreateTime > DateTime.Now.Date.AddMonths(-12))
.Sum(p => p.Cash);
System.Console.ReadLine();
}
/// <summary>
/// Linq测试。
/// </summary>
/// <param name="sdb"></param>
static void TestLinq2(Sequoiadb sdb)
{
//求集合空间。
var cs = sdb.GetCollecitonSpace("dbo");
//求集合。
var coll = cs.GetCollection<HFareDetail>();
//执行数据插入。
List<HFareDetail> vList =null;
using (AgileHIS.Entities.DbEntities db = new AgileHIS.Entities.DbEntities())
{
vList = db.HFareDetails.ToList();
//插入。
foreach (var item in vList)
{
coll.Insert(item);
}
System.Console.WriteLine(string.Format("insert {0} records", vList.Count));
System.Console.ReadLine();
}
//按条件修改某一条数据的几个属性值。
var v1 = vList.FirstOrDefault();
v1.Name = string.Empty;
v1.Cash = decimal.Zero;
coll.Update(v1, p => p.ID == v1.ID);
//按条件指量修改,指定某几个必，其他属性全部置空。
coll.Update(p => new HFareDetail { Cash = decimal.Zero, Name = string.Empty, Price = decimal.Zero }, p => p.ChargeTime >DateTime.Now.AddDays(-1));
//依据条件删除
coll.Delete(p => p.ChargeTime > DateTime.Now.AddDays(-1));
//求Count
int count = coll.AsQueryable<HFareDetail>()
.Where(p => p.SourceID==0)
.Count();
//Linq查询Take\Skip。
var vList2 = coll.AsQueryable<HFareDetail>()
.Where(p => p.CreateTime > DateTime.Now.Date.AddMonths(-12))
.Skip(10).Take(1000)
.ToList();
System.Console.WriteLine(string.Format("query {0} records", vList.Count));
//Linq查询过。
var vFare = coll.AsQueryable<HFareDetail>()
.Where(p => p.CreateTime > DateTime.Now.Date.AddMonths(-12))
.FirstOrDefault();
System.Console.WriteLine(vFare);
//Linq\聚合运算，目前因为测试驱动报错，暂未实现
var sum = coll.AsQueryable<HFareDetail>()
.Where(p => p.CreateTime > DateTime.Now.Date.AddMonths(-12))
.Sum(p => p.Cash);
System.Console.ReadLine();
}
/// <summary>
/// Linq测试。
/// </summary>
/// <param name="sdb"></param>
static void TestLinq2(Sequoiadb sdb)
{
////create Sequoiadb
//Sequoiadb sdb = new Sequoiadb("192.168.23.57:50000");
//sdb.Connect("", "");
//GetCollecitonSpace。
var cs = sdb.GetCollecitonSpace("dbo");
//GetCollection。
var coll = cs.GetCollection <HFareDetail>();
//insert from rdb。
List <HFareDetail> vList = null;
using (AgileHIS.Entities.DbEntities db = new AgileHIS.Entities.DbEntities())
{
vList = db.HFareDetails.ToList();
//insert。
foreach (var item in vList)
{
coll.Insert(item);
}
System.Console.WriteLine(string.Format("insert {0} records", vList.Count));
System.Console.ReadLine();
}
//update docuemnt by linq。
var v1 = vList.FirstOrDefault();
v1.Name = string.Empty;
v1.Cash = decimal.Zero;
coll.Update(v1, p => p.ID == v1.ID);
//update docuemnt by linq。
coll.Update(p => new HFareDetail {
Cash = decimal.Zero, Name = string.Empty, Price = decimal.Zero
}, p => p.ChargeTime > DateTime.Now.AddDays(-1));
//delete by linq
coll.Delete(p => p.ChargeTime > DateTime.Now.AddDays(-1));
//get Count
int count = coll.AsQueryable <HFareDetail>()
.Where(p => p.SourceID == 0)
.Count();
//Linq query Take\Skip。
var vList2 = coll.AsQueryable <HFareDetail>()
.Where(p => p.CreateTime > DateTime.Now.Date.AddMonths(-12))
.Skip(10).Take(1000)
.ToList();
System.Console.WriteLine(string.Format("query {0} records", vList.Count));
//Linq FirstOrDefault。
var vFare = coll.AsQueryable <HFareDetail>()
.Where(p => p.CreateTime > DateTime.Now.Date.AddMonths(-12))
.FirstOrDefault();
System.Console.WriteLine(vFare);
//Linq aggregate，Not Implemented
var sum = coll.AsQueryable <HFareDetail>()
.Where(p => p.CreateTime > DateTime.Now.Date.AddMonths(-12))
.Sum(p => p.Cash);
System.Console.ReadLine();
}
