public async Task Update_SetField_NotAllowedNull_ST() { xx = string.Empty; var agent = await MyDAL_TestDB.SelectOneAsync <Agent>(it => it.Id == Guid.Parse("040afaad-ae07-42fc-9dd0-0165443c847d")); try { var res1 = await MyDAL_TestDB .Updater <Agent>() .Set(it => it.PathId, null) .Where(it => it.Id == agent.Id) .UpdateAsync(); } 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_SetObject_ST_02() { xx = string.Empty; // 要更新的 model 字段 赋值 var model = new AgentInventoryRecord(); model.TotalSaleCount = 1000; // var res1 = await MyDAL_TestDB .Updater <AgentInventoryRecord>() //更新表 AgentInventoryRecord .Set(new { model.TotalSaleCount, // 更新 字段 TotalSaleCount xxx = 2000 // 字段 xxx 在表中无对应 ,自动忽略 }) .Where(it => it.Id == Guid.Parse("032ce51f-1034-4fb2-9741-01655202ecbc")) .UpdateAsync(); Assert.True(res1 == 1); /***************************************************************************************************************************/ xx = string.Empty; }
public async Task History_04() { xx = string.Empty; var agent = await MyDAL_TestDB.SelectOneAsync <Agent>(it => it.Id == Guid.Parse("040afaad-ae07-42fc-9dd0-0165443c847d")); agent.PathId = "xxxxxxx"; agent.ActiveOrderId = null; var res1 = await MyDAL_TestDB .Updater <Agent>() .Set(new { agent.PathId, agent.ActiveOrderId }) .Where(it => it.Id == agent.Id) .UpdateAsync(); var res11 = await MyDAL_TestDB.SelectOneAsync <Agent>(it => it.Id == agent.Id); Assert.Equal("xxxxxxx", res11.PathId, true); Assert.Null(res11.ActiveOrderId); /*****************************************************************************************************************************************************************/ xx = string.Empty; }
private async Task PreRTrim() { var res1 = await MyDAL_TestDB .Updater <Product>() .Set(it => it.Title, "演示商品01 ") .Where(it => it.Id == Guid.Parse("b3866d7c-2b51-46ae-85cb-0165c9121e8f")) .UpdateAsync(); }
private async Task ClearData3(Agent m) { await MyDAL_TestDB .Updater <Agent>() .Set(it => it.AgentLevel, m.AgentLevel) .Where(it => it.Id == m.Id) .UpdateAsync(); }
public async Task <Agent> PreData3() { var m = await MyDAL_TestDB .Selecter <Agent>() .Where(it => it.Id == Guid.Parse("0001c614-dbef-4335-94b4-01654433a215")) .SelectOneAsync(); await MyDAL_TestDB .Updater <Agent>() .Set(it => it.AgentLevel, WhereTest.AgentLevelNull) .Where(it => it.Id == m.Id) .UpdateAsync(); return(m); }
public async Task Mock_UpdateAll_SetField_ST() { xx = string.Empty; var res1 = await MyDAL_TestDB .Updater <AgentInventoryRecord>() .Set(it => it.LockedCount, 0) .UpdateAsync(); Assert.True(res1 == 574); var res11 = await MyDAL_TestDB.SelectListAsync <AgentInventoryRecord>(it => it.LockedCount != 0); Assert.True(res11.Count == 0); xx = string.Empty; }
public async Task Update_SetField_ChangeMinus_ST() { xx = string.Empty; // var res5 = await MyDAL_TestDB .Updater <AgentInventoryRecord>() .Change(it => it.LockedCount, 10, ChangeEnum.Minus) .Where(it => it.AgentId == Guid.Parse("0ce552c0-2f5e-4c22-b26d-01654443b30e")) .And(it => it.ProductId == Guid.Parse("85ce17c1-10d9-4784-b054-016551e5e109")) .UpdateAsync(); Assert.True(res5 == 1); /***************************************************************************************************************************/ xx = string.Empty; }
public async Task Update_SetField_AllowedNull_ST() { xx = string.Empty; var agent = await MyDAL_TestDB.SelectOneAsync <Agent>(it => it.Id == Guid.Parse("040afaad-ae07-42fc-9dd0-0165443c847d")); var res1 = await MyDAL_TestDB .Updater <Agent>() .Set(it => it.PathId, null) .Where(it => it.Id == agent.Id) .UpdateAsync(); var res11 = await MyDAL_TestDB.SelectOneAsync <Agent>(it => it.Id == agent.Id); Assert.Null(res11.PathId); /*****************************************************************************************************************************************************************/ xx = string.Empty; }
public async Task Update_SetField_Segment_ST() { xx = string.Empty; var m = await CreateDbData(); // update 要赋值的变量 var time = DateTime.Now.ToString(); var propertyVal = "{xxx:yyy,mmm:nnn,zzz:aaa}"; // 使用 SetSegment 动态 拼接 set field 起点 var set = MyDAL_TestDB.Updater <BodyFitRecord>().SetSegment; // 根据 条件 判断 是否要对字段 CreatedOn 进行 update if (time.IsNotBlank()) { set = set.Set(it => it.CreatedOn, DateTime.Parse(time)); } // 根据 条件 判断 是否要对字段 BodyMeasureProperty 进行 update if (propertyVal.IsNotBlank()) { set = set.Set(it => it.BodyMeasureProperty, propertyVal); } // 对 SetSegment 设定的字段 进行 update 动作 var res1 = await set .Where(it => it.Id == m.Id) .UpdateAsync(); Assert.True(res1 == 1); /***************************************************************************************************************************/ xx = string.Empty; }
public async Task Update_SetDynamic_ST() { xx = string.Empty; dynamic obj = new ExpandoObject(); obj.TotalSaleCount = 2000; obj.xxx = 3000; // var res1 = await MyDAL_TestDB .Updater <AgentInventoryRecord>() .Set(obj as object) .Where(it => it.Id == Guid.Parse("032ce51f-1034-4fb2-9741-01655202ecbc")) .UpdateAsync(); Assert.True(res1 == 1); /***************************************************************************************************************************/ xx = string.Empty; }
private async Task PereValue() { var res1 = await MyDAL_TestDB .Selecter <Agent>() .Where(it => it.Id == Guid.Parse("03f0a7b4-acd3-4003-b686-01654436e906")) .SelectOneAsync(); var res2 = await MyDAL_TestDB .Updater <Agent>() .Set(it => it.DirectorStarCount, 10) .Where(it => it.Id == res1.Id) .UpdateAsync(); var res3 = await MyDAL_TestDB .Selecter <Agent>() .Where(it => it.Id == Guid.Parse("03fc18e2-4b1e-4aa2-832b-0165443388bd")) .SelectOneAsync(); var res4 = await MyDAL_TestDB .Updater <Agent>() .Set(it => it.DirectorStarCount, 5) .Where(it => it.Id == res3.Id) .UpdateAsync(); }
public async Task History_02() { xx = string.Empty; // set field 2 var res2 = await MyDAL_TestDB .Updater <AgentInventoryRecord>() .Set(it => it.LockedCount, 100) .Where(it => it.AgentId == Guid.Parse("0ce552c0-2f5e-4c22-b26d-01654443b30e")) .Or(it => it.CreatedOn == Convert.ToDateTime("2018-08-19 11:34:42.577074")) .UpdateAsync(); Assert.True(res2 == 2); /***************************************************************************************************************************/ xx = string.Empty; var resx6 = await MyDAL_TestDB .Selecter <Agent>() .Where(it => it.Id == Guid.Parse("000c1569-a6f7-4140-89a7-0165443b5a4b")) .SelectOneAsync(); resx6.ActivedOn = null; // update set null var res6 = await MyDAL_TestDB .Updater <Agent>() .Set(it => it.ActivedOn, resx6.ActivedOn) .Where(it => it.Id == resx6.Id) .UpdateAsync(); Assert.True(res6 == 1); /***************************************************************************************************************************/ xx = string.Empty; var guid7 = Guid.Parse("b3866d7c-2b51-46ae-85cb-0165c9121e8f"); var resxxx7 = await MyDAL_TestDB .Updater <Product>() .Set(it => it.VipProduct, false) .Where(it => it.Id == guid7) .UpdateAsync(); var resx7 = await MyDAL_TestDB .Selecter <Product>() .Where(it => it.Id == guid7) .SelectOneAsync(); Assert.NotNull(resx7); Assert.False(resx7.VipProduct); resx7.VipProduct = true; // update set bool bit var res7 = await MyDAL_TestDB .Updater <Product>() .Set(it => it.VipProduct, resx7.VipProduct) .Where(it => it.Id == resx7.Id) .UpdateAsync(); Assert.True(res7 == 1); var resxx7 = await MyDAL_TestDB .Selecter <Product>() .Where(it => it.Id == guid7) .SelectOneAsync(); Assert.True(resxx7.VipProduct); /***************************************************************************************************************************/ xx = string.Empty; var res8 = await MyDAL_TestDB .Updater <Agent>() .Set(it => it.AgentLevel, AgentLevel.NewCustomer) .Where(it => it.Id == Guid.Parse("0014f62d-2a96-4b5b-b4bd-01654438e3d4")) .UpdateAsync(); var res81 = await MyDAL_TestDB .Selecter <Agent>() .Where(it => it.Id == Guid.Parse("0014f62d-2a96-4b5b-b4bd-01654438e3d4")) .SelectOneAsync(); Assert.True(res81.AgentLevel == AgentLevel.NewCustomer); /***************************************************************************************************************************/ xx = string.Empty; }