public async Task Update_SetField_NotAllowedNull_Shortcut() { xx = string.Empty; var agent = await MyDAL_TestDB.SelectOneAsync <Agent>(it => it.Id == Guid.Parse("040afaad-ae07-42fc-9dd0-0165443c847d")); agent.PathId = null; try { var res1 = await MyDAL_TestDB.UpdateAsync <Agent>(it => it.Id == agent.Id, new { agent.PathId }); } catch (Exception ex) { var errStr = "【ERR-054】 -- [[NotAllowedNull -- 字段:[[PathId]]的值不能设为 Null !!!]] ,请 EMail: --> [email protected] <--"; Assert.Equal(errStr, ex.Message, true); } /*****************************************************************************************************************************************************************/ xx = string.Empty; }
public async Task Update_SetField_AllowedNull_Shortcut() { xx = string.Empty; var agent = await MyDAL_TestDB.SelectOneAsync <Agent>(it => it.Id == Guid.Parse("040afaad-ae07-42fc-9dd0-0165443c847d")); agent.PathId = null; var res1 = await MyDAL_TestDB.UpdateAsync <Agent>(it => it.Id == agent.Id, new { agent.PathId }); Assert.True(res1 == 1); var res11 = await MyDAL_TestDB.SelectOneAsync <Agent>(it => it.Id == agent.Id); Assert.Null(res11.PathId); /*****************************************************************************************************************************************************************/ xx = string.Empty; }
public async Task Update_Shortcut_02() { xx = string.Empty; var pk1 = Guid.Parse("8f2cbb64-8356-4482-88ee-016558c05b2d"); var model = new AlipayPaymentRecord(); model.Description = "new desc"; // 修改 AlipayPaymentRecord 字段 Description 的值为: "new desc" model.PaymentUrl = "new url"; // 修改 AlipayPaymentRecord 字段 PaymentUrl 的值为: "new url" // 修改一条数据: AlipayPaymentRecord var res1 = await MyDAL_TestDB.UpdateAsync <AlipayPaymentRecord>(it => it.Id == pk1, // where 条件: it=>it.Id==pk1 , 可输入任意条件的表达式 new { model.Description, // 修改 AlipayPaymentRecord 字段 Description 的值 model.PaymentUrl // 修改 AlipayPaymentRecord 字段 PaymentUrl 的值 }); Assert.True(res1 == 1); // 查询一条数据: AlipayPaymentRecord var res11 = await MyDAL_TestDB.SelectOneAsync <AlipayPaymentRecord>(it => it.Id == pk1); Assert.True(res11.Description == "new desc"); /****************************************************************************************/ xx = string.Empty; }
public async Task History_03() { xx = string.Empty; var agent = await MyDAL_TestDB.SelectOneAsync <Agent>(it => it.Id == Guid.Parse("040afaad-ae07-42fc-9dd0-0165443c847d")); agent.PathId = "yyyyyyy"; agent.ActiveOrderId = null; var res1 = await MyDAL_TestDB.UpdateAsync <Agent>(it => it.Id == agent.Id, new { agent.PathId, agent.ActiveOrderId }); var res11 = await MyDAL_TestDB.SelectOneAsync <Agent>(it => it.Id == agent.Id); Assert.Equal("yyyyyyy", res11.PathId, true); Assert.Null(res11.ActiveOrderId); /*****************************************************************************************************************************************************************/ xx = string.Empty; }
private async Task PreTrim() { var pk1 = Guid.Parse("b3866d7c-2b51-46ae-85cb-0165c9121e8f"); var res1 = await MyDAL_TestDB.UpdateAsync <Product>(it => it.Id == pk1, new { Title = " 演示商品01 " }); }
public async Task History_01() { xx = string.Empty; var pk2 = Guid.Parse("d0a2d3f3-5cfb-4b3b-aeea-016557383999"); var res2 = await MyDAL_TestDB.UpdateAsync <AlipayPaymentRecord>(it => it.Id == pk2, new { Description = "xxxxxx" }); Assert.True(res2 == 1); var res21 = await MyDAL_TestDB.SelectOneAsync <AlipayPaymentRecord>(it => it.Id == pk2); Assert.True(res21.Description == "xxxxxx"); /****************************************************************************************/ xx = string.Empty; }
public async Task Mock_UpdateAll_Shortcut() { xx = string.Empty; var model = new AgentInventoryRecord(); model.LockedCount = 0; var res1 = await MyDAL_TestDB.UpdateAsync <AgentInventoryRecord>(it => true, new { model.LockedCount }); Assert.True(res1 == 574); var res11 = await MyDAL_TestDB.SelectListAsync <AgentInventoryRecord>(it => it.LockedCount != 0); Assert.True(res11.Count == 0); xx = string.Empty; }
private async Task <Agent> Pre02() { xx = string.Empty; // 造数据 var pk1 = Guid.Parse("014c55c3-b371-433c-abc0-016544491da8"); var resx1 = await MyDAL_TestDB.SelectOneAsync <Agent>(it => it.Id == pk1); var resx2 = await MyDAL_TestDB.UpdateAsync <Agent>(it => it.Id == resx1.Id, new { Name = "刘%华" }); var pk3 = Guid.Parse("018a1855-e238-4fb7-82d6-0165442fd654"); var resx3 = await MyDAL_TestDB.SelectOneAsync <Agent>(it => it.Id == pk3); var resx4 = await MyDAL_TestDB.UpdateAsync <Agent>(it => it.Id == resx3.Id, new { Name = "何_伟" }); return(resx1); }