private async Task <BodyFitRecord> Pre01()
{
// 造数据
var m = new BodyFitRecord
{
Id = Guid.Parse("1fbd8a41-c75b-45c0-9186-016544284e2e"),
CreatedOn = DateTime.Now,
UserId = Guid.NewGuid(),
BodyMeasureProperty = "{xxx:yyy,mmm:nnn}"
};
// 清理数据
var resx1 = await Conn
.Selecter <BodyFitRecord>()
.Where(it => it.Id == m.Id)
.FirstOrDefaultAsync();
if (resx1 != null)
{
var resx2 = await Conn
.Deleter <BodyFitRecord>()
.Where(it => it.Id == resx1.Id)
.DeleteAsync();
}
// 新建
var res0 = await Conn
.Creater <BodyFitRecord>()
.CreateAsync(m);
return(m);
}
public async Task Create_Shotcut()
{
var m1 = new BodyFitRecord
{
Id = Guid.Parse("1fbd8a41-c75b-45c0-9186-016544284e2e"),
CreatedOn = DateTime.Now,
UserId = Guid.NewGuid(),
BodyMeasureProperty = "{xxx:yyy,mmm:nnn}"
};
await PreCreate(m1);
xx = string.Empty;
// 新建
var res1 = await Conn.CreateAsync(m1);
Assert.True(res1 == 1);
/********************************************************************************************************************************/
xx = string.Empty;
}
private async Task PreCreate(BodyFitRecord m)
{
// 清除数据
xx = string.Empty;
var res2 = await Conn
.Deleter <BodyFitRecord>()
.Where(it => it.Id == Guid.Parse("1fbd8a41-c75b-45c0-9186-016544284e2e"))
.DeleteAsync();
}
private async Task <BodyFitRecord> PreQuery()
{
var m = new BodyFitRecord
{
Id = Guid.Parse("1fbd8a41-c75b-45c0-9186-016544284e2e"),
CreatedOn = Convert.ToDateTime("2018-08-23 13:36:58"),
UserId = Guid.NewGuid(),
BodyMeasureProperty = "xxxx"
};
// 清理数据
var resd = await Conn.DeleteAsync <BodyFitRecord>(it => it.Id == m.Id);
// 造数据
var resc = await Conn.CreateAsync(m);
return(m);
}
private async Task <BodyFitRecord> CreateDbData()
{
var m = new BodyFitRecord
{
Id = Guid.Parse("1fbd8a41-c75b-45c0-9186-016544284e2e"),
CreatedOn = DateTime.Now,
UserId = Guid.NewGuid(),
BodyMeasureProperty = "{xxx:yyy,mmm:nnn}"
};
// 删
var res1 = await MyDAL_TestDB
.Deleter <BodyFitRecord>()
.Where(it => it.Id == m.Id)
.DeleteAsync();
// 建
var res2 = await MyDAL_TestDB.InsertAsync(m);
return(m);
}
private async Task <BodyFitRecord> PreDelete()
{
xx = string.Empty;
// 造数据
var m = new BodyFitRecord
{
Id = Guid.Parse("1fbd8a41-c75b-45c0-9186-016544284e2e"),
CreatedOn = DateTime.Now,
UserId = Guid.NewGuid(),
BodyMeasureProperty = "{xxx:yyy,mmm:nnn}"
};
var res = await Conn
.Deleter <BodyFitRecord>()
.Where(it => it.Id == m.Id)
.DeleteAsync();
var res0 = await Conn.CreateAsync(m);
return(m);
}
private async Task <BodyFitRecord> Pre01()
{
// 造数据
var m = new BodyFitRecord
{
Id = Guid.Parse("1fbd8a41-c75b-45c0-9186-016544284e2e"),
CreatedOn = DateTime.Now,
UserId = Guid.NewGuid(),
BodyMeasureProperty = "{xxx:yyy,mmm:nnn}"
};
// 清理数据
var resx1 = await MyDAL_TestDB.SelectOneAsync <BodyFitRecord>(it => it.Id == m.Id);
if (resx1 != null)
{
var resx2 = await MyDAL_TestDB.DeleteAsync <BodyFitRecord>(it => it.Id == resx1.Id);
}
// 新建
var res0 = await MyDAL_TestDB.InsertAsync(m);
return(m);
}
public async Task CreateAsyncTest()
{
/********************************************************************************************************************************/
var m1 = new BodyFitRecord
{
Id = Guid.Parse("1fbd8a41-c75b-45c0-9186-016544284e2e"),
CreatedOn = DateTime.Now,
UserId = Guid.NewGuid(),
BodyMeasureProperty = "{xxx:yyy,mmm:nnn}"
};
await PreCreate(m1);
var xx1 = "";
// 新建
var res1 = await Conn.OpenDebug()
.Creater <BodyFitRecord>()
.CreateAsync(m1);
Assert.True(res1 == 1);
var tuple1 = (XDebug.SQL, XDebug.Parameters);
/********************************************************************************************************************************/
var m2 = new Agent
{
Id = Guid.NewGuid(),
CreatedOn = DateTime.Now,
UserId = Guid.NewGuid(),
PathId = "x-xx-xxx-xxxx",
Name = "张三",
Phone = "18088889999",
IdCardNo = "No.12345",
CrmUserId = "yyyyy",
AgentLevel = AgentLevel.DistiAgent,
ActivedOn = null, // DateTime?
ActiveOrderId = null, // Guid?
DirectorStarCount = 5
};
var xx2 = "";
var res2 = await Conn.OpenDebug()
.Creater <Agent>()
.CreateAsync(m2);
Assert.True(res2 == 1);
var tuple2 = (XDebug.SQL, XDebug.Parameters);
/********************************************************************************************************************************/
var list3 = await PreCreateBatch();
var xx3 = "";
var res3 = await Conn.OpenDebug()
.Creater <AddressInfo>()
.CreateBatchAsync(list3);
Assert.True(res3 == 10);
var tuple3 = (XDebug.SQL, XDebug.Parameters);
var xx = "";
}
public async Task CreateAsyncTest()
{
/********************************************************************************************************************************/
var m1 = new BodyFitRecord
{
Id = Guid.Parse("1fbd8a41-c75b-45c0-9186-016544284e2e"),
CreatedOn = DateTime.Now,
UserId = Guid.NewGuid(),
BodyMeasureProperty = "{xxx:yyy,mmm:nnn}"
};
await PreCreate(m1);
var xx1 = "";
// 新建
var res1 = await Conn
.Creater <BodyFitRecord>()
.CreateAsync(m1);
Assert.True(res1 == 1);
var tuple1 = (XDebug.SQL, XDebug.Parameters);
/********************************************************************************************************************************/
var m2 = new Agent
{
Id = Guid.NewGuid(),
CreatedOn = DateTime.Now,
UserId = Guid.NewGuid(),
PathId = "x-xx-xxx-xxxx",
Name = "张三",
Phone = "18088889999",
IdCardNo = "No.12345",
CrmUserId = "yyyyy",
AgentLevel = AgentLevel.DistiAgent,
ActivedOn = null, // DateTime?
ActiveOrderId = null, // Guid?
DirectorStarCount = 5
};
var xx2 = "";
var res2 = await Conn
.Creater <Agent>()
.CreateAsync(m2);
Assert.True(res2 == 1);
var tuple2 = (XDebug.SQL, XDebug.Parameters);
/********************************************************************************************************************************/
var xx5 = "";
var res5 = await Conn
.Creater <Agent>()
.CreateAsync(new Agent
{
Id = Guid.NewGuid(),
CreatedOn = Convert.ToDateTime("2018-10-07 17:02:05"),
UserId = Guid.NewGuid(),
PathId = "xx-yy-zz-mm-nn",
Name = "meng-net",
Phone = "17600000000",
IdCardNo = "876987698798",
CrmUserId = Guid.NewGuid().ToString(),
AgentLevel = null,
ActivedOn = null,
ActiveOrderId = null,
DirectorStarCount = 1
});
var tuple5 = (XDebug.SQL, XDebug.Parameters);
/********************************************************************************************************************************/
var xx6 = "";
await ClearData6();
var m6 = new Agent
{
Id = Guid.Parse("ea1ad309-56f7-4e3e-af12-0165c9121e9b"),
CreatedOn = Convert.ToDateTime("2018-10-07 17:02:05"),
UserId = Guid.NewGuid(),
PathId = "xx-yy-zz-mm-nn",
Name = "meng-net",
Phone = "17600000000",
IdCardNo = "876987698798",
CrmUserId = Guid.NewGuid().ToString(),
AgentLevel = AgentLevel.DistiAgent,
ActivedOn = null,
ActiveOrderId = null,
DirectorStarCount = 1
};
var res6 = await Conn
.Creater <Agent>()
.CreateAsync(m6);
var res61 = await Conn
.Selecter <Agent>()
.Where(it => it.Id == Guid.Parse("ea1ad309-56f7-4e3e-af12-0165c9121e9b"))
.FirstOrDefaultAsync();
Assert.True(res61.AgentLevel == AgentLevel.DistiAgent);
var tuple6 = (XDebug.SQL, XDebug.Parameters);
/********************************************************************************************************************************/
var xx7 = "";
await ClearData7();
var m7 = new Agent
{
Id = Guid.Parse("08d60369-4fc1-e8e0-44dc-435f31635e6d"),
CreatedOn = Convert.ToDateTime("2018-08-16 19:34:25.116759"),
UserId = Guid.NewGuid(),
PathId = "xx-yy-zz-mm-nn",
Name = "meng-net",
Phone = "17600000000",
IdCardNo = "876987698798",
CrmUserId = Guid.NewGuid().ToString(),
AgentLevel = AgentLevel.DistiAgent,
ActivedOn = null,
ActiveOrderId = null,
DirectorStarCount = 1
};
var res7 = await Conn
.Creater <Agent>()
.CreateAsync(m7);
var res71 = await Conn
.Selecter <Agent>()
.Where(it => it.Id == Guid.Parse("08d60369-4fc1-e8e0-44dc-435f31635e6d"))
.FirstOrDefaultAsync();
Assert.True(res71.CreatedOn == Convert.ToDateTime("2018-08-16 19:34:25.116759"));
var tuple7 = (XDebug.SQL, XDebug.Parameters);
/********************************************************************************************************************************/
var xx = "";
}
public async Task UpdateAsyncTest()
{
var xx0 = "";
var m = await CreateDbData();
var Id = Guid.Parse("1fbd8a41-c75b-45c0-9186-016544284e2e");
var m2 = 10;
var id2 = Guid.Parse("0ce552c0-2f5e-4c22-b26d-01654443b30e");
/***************************************************************************************************************************/
var xx1 = "";
// DB data
var m1 = new BodyFitRecord
{
Id = Guid.Parse("1fbd8a41-c75b-45c0-9186-016544284e2e"),
CreatedOn = DateTime.Now, // new value
UserId = Guid.NewGuid(),
BodyMeasureProperty = "{xxx:yyy,mmm:nnn,zzz:aaa}" // new value
};
// 修改
// set field 1
var res1 = await Conn.OpenDebug()
.Updater <BodyFitRecord>()
.Set(it => it.CreatedOn, m1.CreatedOn)
.Set(it => it.BodyMeasureProperty, m1.BodyMeasureProperty)
.Where(it => it.Id == m.Id)
.UpdateAsync();
Assert.True(res1 == 1);
var tuple1 = (XDebug.SQL, XDebug.Parameters);
/***************************************************************************************************************************/
var xx2 = "";
// set field 2
var res2 = await Conn
.Updater <AgentInventoryRecord>()
.Set(it => it.LockedCount, 100)
.Where(it => it.AgentId == id2)
.Or(it => it.CreatedOn == Convert.ToDateTime("2018-08-19 11:34:42.577074"))
.UpdateAsync();
Assert.True(res2 == 2);
var tuple2 = (XDebug.SQL, XDebug.Parameters);
/***************************************************************************************************************************/
var xx3 = "";
// set dynamic
var res3 = await Conn.OpenDebug()
.Updater <AgentInventoryRecord>()
.Set(new
{
TotalSaleCount = 1000,
xxx = 2000
})
.Where(it => it.Id == Guid.Parse("032ce51f-1034-4fb2-9741-01655202ecbc"))
.UpdateAsync();
Assert.True(res3 == 1);
var tuple3 = (XDebug.SQL, XDebug.Parameters);
/***************************************************************************************************************************/
var xx4 = "";
dynamic obj = new ExpandoObject();
obj.TotalSaleCount = 2000;
obj.xxx = 3000;
// set expand object
var res4 = await Conn.OpenDebug()
.Updater <AgentInventoryRecord>()
.Set(obj as object)
.Where(it => it.Id == Guid.Parse("032ce51f-1034-4fb2-9741-01655202ecbc"))
.UpdateAsync();
Assert.True(res4 == 1);
var tuple4 = (XDebug.SQL, XDebug.Parameters);
/***************************************************************************************************************************/
var xx5 = "";
// where change
var res5 = await Conn
.Updater <AgentInventoryRecord>()
.Change(it => it.LockedCount, m2, ChangeEnum.Add)
.Where(it => it.AgentId == id2)
.And(it => it.ProductId == Guid.Parse("85ce17c1-10d9-4784-b054-016551e5e109"))
.UpdateAsync();
Assert.True(res5 == 1);
var tuple5 = (XDebug.SQL, XDebug.Parameters);
/***************************************************************************************************************************/
var xx6 = "";
var resx6 = await Conn
.Selecter <Agent>()
.Where(it => it.Id == Guid.Parse("000c1569-a6f7-4140-89a7-0165443b5a4b"))
.QueryFirstOrDefaultAsync();
resx6.ActivedOn = null;
// update set null
var res6 = await Conn
.Updater <Agent>()
.Set(it => it.ActivedOn, resx6.ActivedOn)
.Where(it => it.Id == resx6.Id)
.UpdateAsync();
Assert.True(res6 == 1);
var tuple6 = (XDebug.SQL, XDebug.Parameters);
/***************************************************************************************************************************/
var xx7 = "";
var guid7 = Guid.Parse("b3866d7c-2b51-46ae-85cb-0165c9121e8f");
var resxxx7 = await Conn
.Updater <Product>()
.Set(it => it.VipProduct, false)
.Where(it => it.Id == guid7)
.UpdateAsync();
var resx7 = await Conn
.Selecter <Product>()
.Where(it => it.Id == guid7)
.QueryFirstOrDefaultAsync();
Assert.NotNull(resx7);
Assert.False(resx7.VipProduct);
resx7.VipProduct = true;
// update set bool bit
var res7 = await Conn
.Updater <Product>()
.Set(it => it.VipProduct, resx7.VipProduct)
.Where(it => it.Id == resx7.Id)
.UpdateAsync();
Assert.True(res7 == 1);
var tuple7 = (XDebug.SQL, XDebug.Parameters);
var resxx7 = await Conn
.Selecter <Product>()
.Where(it => it.Id == guid7)
.QueryFirstOrDefaultAsync();
Assert.True(resxx7.VipProduct);
/***************************************************************************************************************************/
var xx = "";
}
public async Task CreateAsyncTest()
{
/********************************************************************************************************************************/
var m1 = new BodyFitRecord
{
Id = Guid.Parse("1fbd8a41-c75b-45c0-9186-016544284e2e"),
CreatedOn = DateTime.Now,
UserId = Guid.NewGuid(),
BodyMeasureProperty = "{xxx:yyy,mmm:nnn}"
};
await PreCreate(m1);
var xx1 = "";
// 新建
var res1 = await Conn.OpenDebug()
.Creater <BodyFitRecord>()
.CreateAsync(m1);
Assert.True(res1 == 1);
var tuple1 = (XDebug.SQL, XDebug.Parameters);
/********************************************************************************************************************************/
var m2 = new Agent
{
Id = Guid.NewGuid(),
CreatedOn = DateTime.Now,
UserId = Guid.NewGuid(),
PathId = "x-xx-xxx-xxxx",
Name = "张三",
Phone = "18088889999",
IdCardNo = "No.12345",
CrmUserId = "yyyyy",
AgentLevel = AgentLevel.DistiAgent,
ActivedOn = null, // DateTime?
ActiveOrderId = null, // Guid?
DirectorStarCount = 5
};
var xx2 = "";
var res2 = await Conn.OpenDebug()
.Creater <Agent>()
.CreateAsync(m2);
Assert.True(res2 == 1);
var tuple2 = (XDebug.SQL, XDebug.Parameters);
/********************************************************************************************************************************/
var list3 = await PreCreateBatch();
var xx3 = "";
var res3 = await Conn.OpenDebug()
.Creater <AddressInfo>()
.CreateBatchAsync(list3);
Assert.True(res3 == 10);
var tuple3 = (XDebug.SQL, XDebug.Parameters);
/********************************************************************************************************************************/
var json = File.ReadAllText(@"C:\Users\Administrator.DESKTOP-UH5FN5U\Desktop\工作\DalTestDB\ProfileData.json");
var list = JsonConvert.DeserializeObject <List <UserInfo> >(json);
foreach (var item in list)
{
item.Id = Guid.NewGuid();
item.CreatedOn = DateTime.Now;
}
var xx4 = "";
var res4 = await Conn.OpenDebug()
.Creater <UserInfo>()
.CreateBatchAsync(list);
Assert.True(res4 == list.Count);
var tuple4 = (XDebug.SQL, XDebug.Parameters);
/********************************************************************************************************************************/
var xx = "";
}
