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 test()
{
/****************************************************************************************/
var xx15 = "";
var pk = Guid.Parse("8f2cbb64-8356-4482-88ee-016558c05b2d");
var m15 = new AlipayPaymentRecord
{
Id = pk,
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=xxx&biz_content=xxx&charset=UTF-8&format=JSON&method=zzz&return_url=xxx&sign_type=yyy×tamp=zzz&version=1.0"
};
await Conn.DeleteAsync <AlipayPaymentRecord>(pk);
var res15 = await Conn.CreateAsync <AlipayPaymentRecord>(m15);
Assert.True(res15 == 1);
var tuple15 = (XDebug.SQL, XDebug.Parameters, XDebug.SqlWithParams);
var res151 = await Conn.GetAsync <AlipayPaymentRecord>(pk);
Assert.NotNull(res151);
/****************************************************************************************/
var xx16 = "";
var json = File.ReadAllText(@"C:\Users\liume\Desktop\Work\DalTestDB\ProfileData.json");
var list16 = JsonConvert.DeserializeObject <List <UserInfo> >(json);
foreach (var item in list16)
{
item.Id = Guid.NewGuid();
item.CreatedOn = DateTime.Now;
}
var res16 = await Conn.CreateBatchAsync <UserInfo>(list16);
Assert.True(list16.Count == res16);
var tuple16 = (XDebug.SQL, XDebug.Parameters, XDebug.SqlWithParams);
/****************************************************************************************/
}
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 Conn.DeleteAsync <AlipayPaymentRecord>(it => it.Id == m.Id);
// 新增一条数据: AlipayPaymentRecord
var res1 = await Conn.CreateAsync(m);
Assert.True(res1 == 1);
var res11 = await Conn.QueryOneAsync <AlipayPaymentRecord>(it => it.Id == m.Id);
Assert.NotNull(res11);
/****************************************************************************************/
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 Conn.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 Conn.CreateAsync(sql, paras);
Assert.True(res1 == 1);
var res11 = await Conn.QueryOneAsync <AlipayPaymentRecord>(it => it.Id == m.Id);
Assert.NotNull(res11);
xx = string.Empty;
}
