public Result InsertHouseInfos()
{
Result ret = new Result();
using (var smartConn = new SmartWorldEntities())
{
for (int i = 1; i <= 3; i++)
{
D_House r = new D_House()
{
Id = Guid.NewGuid(),
Address = "成都",
Floor = i,
HouseCode = DateTime.Now.Date.ToString(),
HouseTitle = "测试" + i,
Price = 100,
Remark = "说明",
Property = (int)PropertyType.私证,
CreateDate = DateTime.Now,
HouseType = (int)HouseType.出租,
YearPrice = 1000,
IsDelete = false
};
//List<int> GetListEnum = PropertyType.私证.GetListEnum<int>(typeof(int));
//List<string> GetListEnum2 = PropertyType.私证.GetListEnum<string>(typeof(string));
smartConn.D_House.Add(r);
}
ret.Success = smartConn.SaveChanges() > 0;
}
return(ret);
}
public Result <List <RentHouse> > GetRentHouseList(PagingInfo page)
{
Result <List <RentHouse> > ret = new Result <List <RentHouse> >()
{
Data = new List <RentHouse>()
};
using (var smartConn = new SmartWorldEntities())
{
var list = smartConn.D_House.Where(x => x.IsDelete == false);
foreach (var i in list)
{
RentHouse r = new RentHouse()
{
Id = i.Id,
Address = i.Address,
Floor = i.Floor.GetValueOrDefault(0),
HomeCode = i.HouseCode,
HomeTitle = i.HouseTitle,
Price = i.Price.GetValueOrDefault(0),
Text = i.Remark
};
ret.Data.Add(r);
}
}
return(ret);
}
public Result <List <RentHouse> > GetRentHouseList(PagingInfo page)
{
Result <List <RentHouse> > ret = new Result <List <RentHouse> >()
{
Data = new List <RentHouse>()
};
using (var smartConn = new SmartWorldEntities())
{
}
return(ret);
}
public async Task <Result <List <D_House> > > GetHouseInfosAsync()
{
Result <List <D_House> > ret = new Result <List <D_House> >();
using (var smartConn = new SmartWorldEntities())
{
//var res = smartConn.GetAsync(url).Result.Content.tos;
//smartConn.D_House.Add(new D_House()
//{
// Id = Guid.NewGuid(),
// HouseCode = "Test",
// CreateDate = DateTime.Now
//});
//await smartConn.SaveChangesAsync();
ret.Data = await smartConn.D_House.Where(x => x.IsDelete == false).ToListAsync();
}
return(ret);
}
public string GetTimeTest()
{
List <D_House> list1 = new List <D_House>();
List <D_House> list2 = new List <D_House>();
List <D_House> list3 = new List <D_House>();
using (var smartConn = new SmartWorldEntities())
{
Stopwatch watch1 = new Stopwatch();
watch1.Start();
for (int i = 1; i <= 2000; i++)
{
D_House r = new D_House()
{
Id = Guid.NewGuid(),
Address = "成都",
Floor = i,
HouseCode = DateTime.Now.Date.ToString(),
HouseTitle = "测试" + i,
Price = 100,
Remark = "说明",
Property = (int)PropertyType.私证,
CreateDate = DateTime.Now,
HouseType = (int)HouseType.出租,
YearPrice = 1000,
IsDelete = false
};
list1.Add(r);
}
smartConn.D_House.AddRange(list1);
watch1.Stop();
Stopwatch watch2 = new Stopwatch();
watch2.Start();
for (int i = 1; i <= 2000; i++)
{
D_House r = new D_House()
{
Id = Guid.NewGuid(),
Address = "成都",
Floor = i,
HouseCode = DateTime.Now.Date.ToString(),
HouseTitle = "测试" + i,
Price = 100,
Remark = "说明",
Property = (int)PropertyType.私证,
CreateDate = DateTime.Now,
HouseType = (int)HouseType.出租,
YearPrice = 1000,
IsDelete = false
};
list2.Add(r);
}
smartConn.BulkInsert(list2);
smartConn.SaveChanges();
watch2.Stop();
Stopwatch watch3 = new Stopwatch();
//watch3.Start();
//for (int i = 1; i <= 2000; i++)
//{
// D_House r = new D_House()
// {
// Id = Guid.NewGuid(),
// Address = "成都",
// Floor = i,
// HouseCode = DateTime.Now.Date.ToString(),
// HouseTitle = "测试" + i,
// Price = 100,
// Remark = "说明",
// Property = (int)PropertyType.私证,
// CreateDate = DateTime.Now,
// HouseType = (int)HouseType.出租,
// YearPrice = 1000,
// IsDelete = false
// };
// smartConn.D_House.Add(r);
//}
//smartConn.SaveChanges();
watch3.Stop();
string ret = string.Format(@" AddRange:{0}；
BulkInsert:{1}；
先添加后保存:{2}；", watch1.Elapsed, watch2.Elapsed, watch3.Elapsed);
return(ret);
}
}