static void Main(string[] args)
{
using (CommonDBContext db = new CommonDBContext())
{
int total = db.Spotting.Count();
Console.WriteLine("路口总行数：{0}", total);
var fDisItem = db.Spotting.FirstOrDefault(e => e.Disabled == true);
Console.WriteLine("第一条禁用路口：{0}", fDisItem.SpottingName);
//分页查询演示
var pageList = db.Spotting.Where(e => e.Disabled == true)
.OrderBy(e => e.SpottingName).Skip(10).Take(20).ToList();
Console.WriteLine("分页查询禁用路口：{0}", pageList.Count);
var list = db.Spotting.ToList();
string[] arrSpottingNo = new string[] { "123", "34" };
db.Spotting.Where(e => arrSpottingNo.Contains(e.SpottingNo)).ToList();
string minSpottingNo = db.Spotting.Min(e => e.SpottingNo);
string maxSpottingNo = db.Spotting.Max(e => e.SpottingNo);
string[] arrAreaCode = db.Spotting.Select(e => e.AreaCode).Distinct().ToArray();
db.Spotting.Average(e => e.Longitude);
var dt = DateTime.Now.AddDays(-100);
//日期过滤
db.Spotting.Where(e =>
e.Createdtime >= dt && e.Createdtime <= DateTime.Now && e.Disabled == true).ToList();
var itemNew = new Spotting
{
SpottingId = Guid.NewGuid().ToString("N"),
SpottingName = "test",
SpottingNo = "test",
Creator = "admin",
Createdtime = DateTime.Now,
DepartmentId = Guid.NewGuid().ToString("N")
};
db.Entry(itemNew).State = EntityState.Added;
Console.WriteLine("新增一条路口Id：{0} 数据", itemNew.SpottingId);
//var itemModify = db.Spotting.Find(itemNew.SpottingId);
//itemModify.SpottingName = "testModify";
//db.Entry(itemModify).State = EntityState.Modified;
//Console.WriteLine("修改路口Id：{0} 数据的名称为：{1}", itemNew.SpottingId,itemModify.SpottingName);
var dItem = db.Spotting.Find(itemNew.SpottingId);
db.Remove(dItem);
Console.WriteLine("删除路口Id：{0} 数据", itemNew.SpottingId);
//关联查询
var x = (from p in db.Spotting
join q in db.Department
on p.DepartmentId equals q.DepartmentId
select new { p.SpottingName, p.SpottingId, p.DepartmentId, q.BuName }).OrderBy(e => e.SpottingName)
.Skip(10).Take(20).ToList();
db.SaveChanges();
}
Console.Read();
}
static void Main(string[] args)
{
using (CommonDBContext db = new CommonDBContext())
{
int total = db.Spotting.Count();
var x1 = db.Spotting.GroupBy(e => e.DepartmentId).Select(e => new { e.Key, count = e.Count() }).ToList();
Console.WriteLine("路口总行数：{0}", total);
var fDisItem = db.Spotting.FirstOrDefault(e => e.Disabled == true);
Console.WriteLine("第一条禁用路口：{0}", fDisItem.SpottingName);
//分页查询演示
var pageList = db.Spotting.Where(e => e.Disabled == true)
.OrderBy(e => e.SpottingName).Skip(10).Take(20).ToList();
Console.WriteLine("分页查询禁用路口：{0}", pageList.Count);
var list = db.Spotting.ToList();
string[] arrSpottingNo = new string[] { "123", "34" };
db.Spotting.Where(e => arrSpottingNo.Contains(e.SpottingNo)).ToList();
//var cmd = db.Database.GetDbConnection().CreateCommand();
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.CommandText = "procName";
//OracleParameter guest_type = new OracleParameter(":i_guest_type", OracleDbType.Int32);
//guest_type.Value = 10;
//guest_type.Direction = ParameterDirection.Input;
//cmd.Parameters.Add(guest_type);
//cmd.Connection.Open();
////int retCode = cmd.ExecuteNonQuery();
//var reader = cmd.ExecuteReader();
//cmd.Connection.Close();
string minSpottingNo = db.Spotting.Min(e => e.SpottingNo);
string maxSpottingNo = db.Spotting.Max(e => e.SpottingNo);
string[] arrAreaCode = db.Spotting.Select(e => e.AreaCode).Distinct().ToArray();
db.Spotting.Average(e => e.Longitude);
var dt = DateTime.Now.AddDays(-100);
//日期过滤
db.Spotting.Where(e =>
e.Createdtime >= dt && e.Createdtime <= DateTime.Now && e.Disabled == true).ToList();
var listSpotting = new List <Spotting>();
for (int i = 0; i < 1; i++)
{
var itemNew = new Spotting
{
SpottingId = Guid.NewGuid().ToString("N"),
SpottingName = "test",
SpottingNo = "test",
Creator = "admin",
SourceKind = "local",
ApplicationName = "ims",
//Createdtime = DateTime.Now,
DepartmentId = Guid.NewGuid().ToString("N")
};
listSpotting.Add(itemNew);
}
db.AddRange(listSpotting);
db.SaveChanges();
db.RemoveRange(db.Spotting.Where(e => listSpotting.Select(t => t.SpottingId).Contains(e.SpottingId)));
db.SaveChanges();
//db.Entry(itemNew).State = EntityState.Added;
//Console.WriteLine("新增一条路口Id：{0} 数据", itemNew.SpottingId);
////var itemModify = db.Spotting.Find(itemNew.SpottingId);
////itemModify.SpottingName = "testModify";
////db.Entry(itemModify).State = EntityState.Modified;
////Console.WriteLine("修改路口Id：{0} 数据的名称为：{1}", itemNew.SpottingId,itemModify.SpottingName);
//var dItem = db.Spotting.Find(itemNew.SpottingId);
//db.Remove(dItem);
//Console.WriteLine("删除路口Id：{0} 数据", itemNew.SpottingId);
//关联查询
var x = (from p in db.Spotting
join q in db.Department
on p.DepartmentId equals q.DepartmentId
select new { p.SpottingName, p.SpottingId, p.DepartmentId, q.BuName }).OrderBy(e => e.SpottingName)
.Skip(10).Take(20).ToList();
db.SaveChanges();
}
Console.Read();
}