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() { /************************************************************************************************************/ await Pre01(); xx = string.Empty; // 默认 "%"+"xx"+"%" var res1 = await MyDAL_TestDB.SelectOneAsync <BodyFitRecord>(it => it.BodyMeasureProperty.Contains("xx")); Assert.NotNull(res1); /************************************************************************************************************/ xx = string.Empty; // 默认 "%"+"~00-d-3-1-"+"%" var res3 = await MyDAL_TestDB .Selecter <Agent>() .Where(it => it.CreatedOn >= Convert.ToDateTime("2018-08-23 13:36:58").AddDays(-30)) .And(it => it.PathId.Contains("~00-d-3-1-")) .SelectPagingAsync(1, 10); Assert.True(res3.TotalCount == 5680); /************************************************************************************************************/ }
private async Task xxx(Guid id) { xx = string.Empty; // where method parameter var res1 = await MyDAL_TestDB.SelectOneAsync <Agent>(it => it.Id == id); Assert.NotNull(res1); xx = string.Empty; // where method parameter var resR1 = await MyDAL_TestDB.SelectOneAsync <Agent>(it => id == it.Id); Assert.NotNull(resR1); Assert.True(res1.Id.Equals(Guid.Parse("000a9465-8665-40bf-90e3-0165442d9120"))); Assert.True(resR1.Id.Equals(Guid.Parse("000a9465-8665-40bf-90e3-0165442d9120"))); 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 SelectVM_SQL() { xx = string.Empty; var sql = @" select agent.`PathId` as nn, record.`Id` as yy, agent.`Id` as xx, agent.`Name` as zz, record.`LockedCount` as mm from `agent` as agent inner join `agentinventoryrecord` as record on agent.`Id`=record.`AgentId` where agent.`Id`=@Id limit 0,1; "; var paras = new List <XParam> { new XParam { ParamName = "Id", ParamValue = Guid.Parse("544b9053-322e-4857-89a0-0165443dcbef") } }; var res1 = await MyDAL_TestDB.SelectOneAsync <AgentVM>(sql, paras); Assert.NotNull(res1); Assert.Equal("夏明君", res1.zz); xx = string.Empty; }
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 SelectVM_SQL_NoneParam() { xx = string.Empty; var sql = @" select agent.`PathId` as nn, record.`Id` as yy, agent.`Id` as xx, agent.`Name` as zz, record.`LockedCount` as mm from `agent` as agent inner join `agentinventoryrecord` as record on agent.`Id`=record.`AgentId` where agent.`Id`='544b9053-322e-4857-89a0-0165443dcbef' limit 0,1; "; var res1 = await MyDAL_TestDB.SelectOneAsync <AgentVM>(sql); Assert.NotNull(res1); Assert.Equal("夏明君", res1.zz); xx = string.Empty; }
public async Task SelectSingleColumn_SQL() { xx = string.Empty; var sql = @" select agent.`Name` from `agent` as agent inner join `agentinventoryrecord` as agentRecord on agent.`Id`=agentRecord.`AgentId` where agent.`AgentLevel`=@AgentLevel limit 0,1; "; var paras = new List <XParam> { new XParam { ParamName = "AgentLevel", ParamValue = AgentLevel.DistiAgent } }; var res1 = await MyDAL_TestDB.SelectOneAsync <string>(sql, paras); Assert.True(res1.Length > 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; }
public async Task MethodParam() { var pk = Guid.Parse("000a9465-8665-40bf-90e3-0165442d9120"); var res = await MyDAL_TestDB.SelectOneAsync <Agent>(it => it.Id == pk); Assert.NotNull(res); await xxx(res.Id); var id = Guid.Parse("000a9465-8665-40bf-90e3-0165442d9120"); await xxx(id); }
public async Task SelectSingleColumn_Shortcut() { xx = string.Empty; var pk = Guid.Parse("8f2cbb64-8356-4482-88ee-016558c05b2d"); var date = DateTime.Parse("2018-08-20 19:12:05.933786"); var res1 = await MyDAL_TestDB // .OpenDebug() .SelectOneAsync <AlipayPaymentRecord, Guid>(it => it.Id == pk && it.CreatedOn == date, it => it.Id); Assert.True(res1 == pk); xx = string.Empty; }
public async Task SelectVM_SQL() { xx = string.Empty; var totalSql = @" select count(*) from ( select agent9.`Name` as XXXX, agent9.`PathId` as YYYY from `agent` as agent9 inner join `agentinventoryrecord` as record9 on agent9.`Id`=record9.`AgentId` where agent9.`AgentLevel`=@AgentLevel ) temp; "; var dataSql = @" select agent9.`Name` as XXXX, agent9.`PathId` as YYYY from `agent` as agent9 inner join `agentinventoryrecord` as record9 on agent9.`Id`=record9.`AgentId` where agent9.`AgentLevel`=@AgentLevel order by agent9.`Id` desc limit 0,10; "; var paras = new List <XParam> { new XParam { ParamName = "AgentLevel", ParamValue = AgentLevel.DistiAgent, ParamType = ParamTypeEnum.Int_MySQL_SqlServer } }; var paging = new PagingResult <AgentVM>(); paging.PageIndex = 1; paging.PageSize = 10; paging.TotalCount = await MyDAL_TestDB.SelectOneAsync <int>(totalSql, paras); paging.Data = await MyDAL_TestDB.SelectListAsync <AgentVM>(dataSql, paras); Assert.True(paging.Data.Count == 10); xx = string.Empty; }
public async Task SelectVM_Shortcut() { xx = string.Empty; var pk = Guid.Parse("8f2cbb64-8356-4482-88ee-016558c05b2d"); var date = DateTime.Parse("2018-08-20 19:12:05.933786"); var res1 = await MyDAL_TestDB.SelectOneAsync <AlipayPaymentRecord, AlipayPaymentRecordVM>(it => it.Id == pk && it.CreatedOn == date); Assert.NotNull(res1); /****************************************************************************************/ xx = string.Empty; }
public async Task Delete_Shortcut() { xx = string.Empty; var res1 = await MyDAL_TestDB.DeleteAsync <AlipayPaymentRecord>(it => it.Id == Guid.Parse("8f2cbb64-8356-4482-88ee-016558c05b2d")); Assert.True(res1 == 1); var res11 = await MyDAL_TestDB.SelectOneAsync <AlipayPaymentRecord>(it => it.Id == Guid.Parse("8f2cbb64-8356-4482-88ee-016558c05b2d")); Assert.Null(res11); /****************************************************************************************/ xx = string.Empty; }
public async Task SelectSingleColumn_SQL() { xx = string.Empty; var totalSql = @" select count(agent1.`Id`) from `agent` as agent1 inner join `agentinventoryrecord` as record1 on agent1.`Id`=record1.`AgentId` where agent1.`AgentLevel`=@AgentLevel; "; var dataSql = @" select agent1.`Id` from `agent` as agent1 inner join `agentinventoryrecord` as record1 on agent1.`Id`=record1.`AgentId` where agent1.`AgentLevel`=@AgentLevel order by agent1.`Id` desc limit 0,10; "; var paras = new List <XParam> { new XParam { ParamName = "AgentLevel", ParamValue = AgentLevel.DistiAgent, ParamType = ParamTypeEnum.Int_MySQL_SqlServer } }; var paging = new PagingResult <Guid>(); paging.PageIndex = 1; paging.PageSize = 10; paging.TotalCount = await MyDAL_TestDB.SelectOneAsync <int>(totalSql, paras); paging.Data = await MyDAL_TestDB.SelectListAsync <Guid>(dataSql, paras); Assert.True(paging.TotalPage == 58); xx = string.Empty; }
public async Task History_01() { xx = string.Empty; var pk2 = Guid.Parse("72d551bf-d9f4-4817-800f-01655794cf42"); var res2 = await MyDAL_TestDB.DeleteAsync <AlipayPaymentRecord>(it => it.Id == pk2); Assert.True(res2 == 1); var res21 = await MyDAL_TestDB.SelectOneAsync <AlipayPaymentRecord>(it => it.Id == pk2); Assert.Null(res21); /****************************************************************************************/ 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 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; }
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); }
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 SelectOne_SingleColumn_ST() { var pk = 'A'; await MySQL_PreData(pk, 1); xx = string.Empty; var res1 = await MyDAL_TestDB.SelectOneAsync <MySQL_EveryType>(it => it.Char == $"{pk}-char"); Assert.NotNull(res1); var res_char = await MyDAL_TestDB.SelectOneAsync <MySQL_EveryType>(it => it.Char == $"{pk}-char", it => it.Char.ToString()); Assert.Equal(res_char, $"{pk}-char"); var res_VarChar = await MyDAL_TestDB.SelectOneAsync <MySQL_EveryType>(it => it.Char == $"{pk}-char", it => it.VarChar.ToString()); Assert.Equal(res_VarChar, $"{pk}-var char"); var res_TinyText = await MyDAL_TestDB.SelectOneAsync <MySQL_EveryType>(it => it.Char == $"{pk}-char", it => it.TinyText.ToString()); Assert.Equal(res_TinyText, $"{pk}-tiny text"); var res_Text = await MyDAL_TestDB.SelectOneAsync <MySQL_EveryType>(it => it.Char == $"{pk}-char", it => it.Text.ToString()); Assert.Equal(res_Text, $"{pk}-text"); var res_MediumText = await MyDAL_TestDB.SelectOneAsync <MySQL_EveryType>(it => it.Char == $"{pk}-char", it => it.MediumText.ToString()); Assert.Equal(res_MediumText, $"{pk}-medium text"); var res_LongText = await MyDAL_TestDB.SelectOneAsync <MySQL_EveryType>(it => it.Char == $"{pk}-char", it => it.LongText.ToString()); Assert.Equal(res_LongText, $"{pk}-long text"); var res_TinyBlob = await MyDAL_TestDB.SelectOneAsync <MySQL_EveryType>(it => it.Char == $"{pk}-char", it => it.TinyBlob); Assert.Equal(Encoding.UTF8.GetString(res_TinyBlob), $"{pk}-tiny blob"); try { var res_Blob = await MyDAL_TestDB.SelectOneAsync <MySQL_EveryType>(it => it.Char == $"{pk}-char", it => it.Blob.ToString()); } catch (Exception ex) { var err = "【ERR-093】 -- [[【byte[]】对应 DB column 不能使用 C# .ToString() 函数!表达式--【it.Blob.ToString()】]] ,请 EMail: --> [email protected] <--"; Assert.Equal(ex.Message, err); } var res_MediumBlob = await MyDAL_TestDB.SelectOneAsync <MySQL_EveryType>(it => it.Char == $"{pk}-char", it => it.MediumBlob); Assert.Equal(Encoding.UTF8.GetString(res_MediumBlob), $"{pk}-medium blob"); var res_LongBlob = await MyDAL_TestDB.SelectOneAsync <MySQL_EveryType>(it => it.Char == $"{pk}-char", it => it.LongBlob); Assert.Equal(Encoding.UTF8.GetString(res_LongBlob), $"{pk}-long blob"); var res_Binary = await MyDAL_TestDB.SelectOneAsync <MySQL_EveryType>(it => it.Char == $"{pk}-char", it => it.Binary); Assert.StartsWith($"{pk}-binary", Encoding.UTF8.GetString(res_Binary)); var res_VarBinary = await MyDAL_TestDB.SelectOneAsync <MySQL_EveryType>(it => it.Char == $"{pk}-char", it => it.VarBinary); Assert.Equal($"{pk}-var binary", Encoding.UTF8.GetString(res_VarBinary)); var res_Enum = await MyDAL_TestDB.SelectOneAsync <MySQL_EveryType>(it => it.Char == $"{pk}-char", it => it.Enum.ToString()); Assert.Equal(MySQL_Enum.A.ToString(), res_Enum); var res_Enum_Null = await MyDAL_TestDB.SelectOneAsync <MySQL_EveryType>(it => it.Char == $"{pk}-char", it => it.Enum_Null.ToString()); Assert.Equal(MySQL_Enum.B.ToString(), res_Enum_Null); var res_Set = await MyDAL_TestDB.SelectOneAsync <MySQL_EveryType>(it => it.Char == $"{pk}-char", it => it.Set.ToString()); Assert.Equal(string.Join(",", new List <string> { "music", "movie" }), res_Set); var res_Set_Null = await MyDAL_TestDB.SelectOneAsync <MySQL_EveryType>(it => it.Char == $"{pk}-char", it => it.Set_Null.ToString()); Assert.Equal(string.Join(",", new List <string> { "swimming" }), res_Set_Null); var res_TinyInt = await MyDAL_TestDB.SelectOneAsync <MySQL_EveryType>(it => it.Char == $"{pk}-char", it => it.TinyInt.ToString()); Assert.Equal("65", res_TinyInt); var res_TinyInt_Null = await MyDAL_TestDB.SelectOneAsync <MySQL_EveryType>(it => it.Char == $"{pk}-char", it => it.TinyInt_Null.ToString()); Assert.Equal("65", res_TinyInt_Null); var res_SmallInt = await MyDAL_TestDB.SelectOneAsync <MySQL_EveryType>(it => it.Char == $"{pk}-char", it => it.SmallInt.ToString()); Assert.Equal("32767", res_SmallInt); var res_SmallInt_Null = await MyDAL_TestDB.SelectOneAsync <MySQL_EveryType>(it => it.Char == $"{pk}-char", it => it.SmallInt_Null.ToString()); Assert.Equal("-32768", res_SmallInt_Null); var res_MediumInt = await MyDAL_TestDB.SelectOneAsync <MySQL_EveryType>(it => it.Char == $"{pk}-char", it => it.MediumInt.ToString()); Assert.Equal("1000000", res_MediumInt); var res_MediumInt_Null = await MyDAL_TestDB.SelectOneAsync <MySQL_EveryType>(it => it.Char == $"{pk}-char", it => it.MediumInt_Null.ToString()); Assert.Equal("1000000", res_MediumInt_Null); var res_Int = await MyDAL_TestDB.SelectOneAsync <MySQL_EveryType>(it => it.Char == $"{pk}-char", it => it.Int.ToString()); Assert.Equal("2147483647", res_Int); var res_Int_Null = await MyDAL_TestDB.SelectOneAsync <MySQL_EveryType>(it => it.Char == $"{pk}-char", it => it.Int_Null.ToString()); Assert.Equal("-2147483648", res_Int_Null); var res_BigInt = await MyDAL_TestDB.SelectOneAsync <MySQL_EveryType>(it => it.Char == $"{pk}-char", it => it.BigInt.ToString()); Assert.Equal("9223372036854775807", res_BigInt); var res_BigInt_Null = await MyDAL_TestDB.SelectOneAsync <MySQL_EveryType>(it => it.Char == $"{pk}-char", it => it.BigInt_Null.ToString()); Assert.Equal("-9223372036854775808", res_BigInt_Null); var res_Float = await MyDAL_TestDB.SelectOneAsync <MySQL_EveryType>(it => it.Char == $"{pk}-char", it => it.Float.ToString()); Assert.Equal("50", res_Float); var res_Float_Null = await MyDAL_TestDB.SelectOneAsync <MySQL_EveryType>(it => it.Char == $"{pk}-char", it => it.Float_Null.ToString()); Assert.Equal("50", res_Float_Null); var res_Double = await MyDAL_TestDB.SelectOneAsync <MySQL_EveryType>(it => it.Char == $"{pk}-char", it => it.Double.ToString()); Assert.Equal("1.7976931348623157E+308", res_Double); var res_Double_Null = await MyDAL_TestDB.SelectOneAsync <MySQL_EveryType>(it => it.Char == $"{pk}-char", it => it.Double_Null.ToString()); Assert.Equal("-1.7976931348623157E+308", res_Double_Null); var res_Decimal = await MyDAL_TestDB.SelectOneAsync <MySQL_EveryType>(it => it.Char == $"{pk}-char", it => it.Decimal.ToString()); Assert.Equal("600", res_Decimal); var res_Decimal_Null = await MyDAL_TestDB.SelectOneAsync <MySQL_EveryType>(it => it.Char == $"{pk}-char", it => it.Decimal_Null.ToString()); Assert.Equal("600", res_Decimal_Null); 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; }
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; }