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;
}
