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 MyDAL_TestDB.InsertAsync(m1); Assert.True(res1 == 1); /********************************************************************************************************************************/ xx = string.Empty; }
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 MyDAL_TestDB.DeleteAsync <BodyFitRecord>(it => it.Id == m.Id); // 造数据 var resc = await MyDAL_TestDB.InsertAsync(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> 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 History_03() { xx = string.Empty; var m = new AlipayPaymentRecord { Id = Guid.Parse("8f2cbb64-8356-4482-88ee-016558c05b2d"), CreatedOn = DateTime.Parse("2018-08-20 19:12:05.933786"), PaymentRecordId = Guid.Parse("e94f747e-1a6d-4be6-af51-016558c05b29"), OrderId = Guid.Parse("f60f08e7-9678-41a8-b4aa-016558c05afc"), TotalAmount = 0.010000000000000000000000000000M, Description = null, PaymentSN = "2018082021001004180510465833", PayedOn = DateTime.Parse("2018-08-20 20:36:35.720525"), CanceledOn = null, PaymentUrl = "https://openapi.xxx?charset=UTF-8&app_id=zzz&version=1.0" }; // 删除一条数据: AlipayPaymentRecord await MyDAL_TestDB.DeleteAsync <AlipayPaymentRecord>(it => it.Id == m.Id); // 新增一条数据: AlipayPaymentRecord var res1 = await MyDAL_TestDB.InsertAsync(m); Assert.True(res1 == 1); var res11 = await MyDAL_TestDB.SelectOneAsync <AlipayPaymentRecord>(it => it.Id == m.Id); Assert.NotNull(res11); /****************************************************************************************/ xx = string.Empty; }
public async Task insert_one() { /********************************************************************************************************************************/ var m1 = new AutoIncrementDemo() { col1 = "111", col2 = "3333" }; xx = string.Empty; var res1 = await MyDAL_TestDB.InsertAsync(m1); Assert.True(m1.id == 1); xx = string.Empty; /********************************************************************************************************************************/ var m2 = new AutoIncrementDemo() { col1 = "111", col2 = "3333" }; xx = string.Empty; var res2 = await MyDAL_TestDB.InsertAsync(m2); Assert.True(m2.id == 2); xx = string.Empty; /********************************************************************************************************************************/ var m5 = new AutoIncrementDemo() { id = 5, col1 = "111", col2 = "3333" }; xx = string.Empty; var res5 = await MyDAL_TestDB.InsertAsync(m5); Assert.True(m5.id == 5); xx = string.Empty; /********************************************************************************************************************************/ var m6 = new AutoIncrementDemo() { col1 = "111", col2 = "3333" }; xx = string.Empty; var res6 = await MyDAL_TestDB.InsertAsync(m6); Assert.True(m6.id == 6); xx = string.Empty; }
public async Task History_01() { /********************************************************************************************************************************/ 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 }; xx = string.Empty; var res2 = await MyDAL_TestDB.InsertAsync(m2); Assert.True(res2 == 1); /********************************************************************************************************************************/ xx = string.Empty; var res5 = await MyDAL_TestDB.InsertAsync(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 }); /********************************************************************************************************************************/ xx = string.Empty; 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 MyDAL_TestDB.InsertAsync(m6); var res61 = await MyDAL_TestDB.SelectOneAsync <Agent>(it => it.Id == Guid.Parse("ea1ad309-56f7-4e3e-af12-0165c9121e9b")); Assert.True(res61.AgentLevel == AgentLevel.DistiAgent); /********************************************************************************************************************************/ xx = string.Empty; 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 MyDAL_TestDB.InsertAsync(m7); var res71 = await MyDAL_TestDB.SelectOneAsync <Agent>(it => it.Id == Guid.Parse("08d60369-4fc1-e8e0-44dc-435f31635e6d")); Assert.True(res71.CreatedOn == Convert.ToDateTime("2018-08-16 19:34:25.116759")); /********************************************************************************************************************************/ xx = string.Empty; }
public async Task CreateAsync_SQL() { xx = string.Empty; var m = new AlipayPaymentRecord { Id = Guid.Parse("DDED9817-A73B-490F-9289-016558ECB41C"), CreatedOn = DateTime.Parse("2018-08-20 13:48:03.320317"), PaymentRecordId = Guid.Parse("99b4afd3-9442-4556-a4bf-01655797af73"), OrderId = Guid.Parse("c18aa87e-3367-4813-952d-01655797af41"), TotalAmount = 293.000000000000000000000000000000M, Description = null, PaymentSN = null, PayedOn = null, CanceledOn = null, PaymentUrl = "https://openapi.alipay.com/gateway.do?charset=UTF-8" }; // 删除一条数据: AlipayPaymentRecord await MyDAL_TestDB.DeleteAsync <AlipayPaymentRecord>(it => it.Id == m.Id); var sql = @" insert into `alipaypaymentrecord` (`Id`,`CreatedOn`,`PaymentRecordId`,`OrderId`,`TotalAmount`,`Description`,`PaymentSN`,`PayedOn`,`CanceledOn`,`PaymentUrl`) values (@Id,@CreatedOn,@PaymentRecordId,@OrderId,@TotalAmount,@Description,@PaymentSN,@PayedOn,@CanceledOn,@PaymentUrl); "; var paras = new List <XParam> { new XParam { ParamName = "Id", ParamValue = m.Id }, new XParam { ParamName = "CreatedOn", ParamValue = m.CreatedOn }, new XParam { ParamName = "PaymentRecordId", ParamValue = m.PaymentRecordId }, new XParam { ParamName = "OrderId", ParamValue = m.OrderId }, new XParam { ParamName = "TotalAmount", ParamValue = m.TotalAmount }, new XParam { ParamName = "Description", ParamValue = m.Description }, new XParam { ParamName = "PaymentSN", ParamValue = m.PaymentSN }, new XParam { ParamName = "PayedOn", ParamValue = m.PayedOn }, new XParam { ParamName = "CanceledOn", ParamValue = m.CanceledOn }, new XParam { ParamName = "PaymentUrl", ParamValue = m.PaymentUrl } }; // 新增一条数据: AlipayPaymentRecord var res1 = await MyDAL_TestDB.InsertAsync(sql, paras); Assert.True(res1 == 1); var res11 = await MyDAL_TestDB.SelectOneAsync <AlipayPaymentRecord>(it => it.Id == m.Id); Assert.NotNull(res11); xx = string.Empty; }