public async Task TestMethod1()
{
InvoicesReturnDapperRepository dr = new InvoicesReturnDapperRepository();
InvoicesReturn invoiceReturn = new InvoicesReturn();
invoiceReturn.ZFPDM = "tset";
invoiceReturn.ZFPHM = "1111";
invoiceReturn.ZFPJE = 542;
invoiceReturn.ZFPZT = "N";
invoiceReturn.ZKPRQ = DateTime.Now;
var rt = await dr.Save(invoiceReturn);
Assert.AreEqual(rt.Code, 0);
}
public async Task <SaveResult> Save(InvoicesReturn InvoicesReturn)
{
SaveResult saveRlt = new SaveResult();
saveRlt.UniqueKey = InvoicesReturn.ZFPHM;//回传接收方的主键
using (IDbConnection conn = SqlConnectionFactory.CreateSqlConnection())
{
conn.Open();
IDbTransaction dbTransaction = conn.BeginTransaction();
try
{
string insertSql = $@"INSERT INTO [@AVA_INVRETURN] (Code,Name,U_ZFPDM,U_ZKPRQ,U_ZFPZT,U_ZFPJE,U_ZSKPH)
VALUES (
'{InvoicesReturn.ZFPHM}',
'{InvoicesReturn.ZFPHM}',
'{InvoicesReturn.ZFPDM}',
'{InvoicesReturn.ZKPRQ}',
'{InvoicesReturn.ZFPZT}',
'{InvoicesReturn.ZFPJE}',
'{InvoicesReturn.ZSKPH}')";
//string insertSql = $@"INSERT INTO [@AVA_INVRETURN] (Code,Name,U_ZFPDM,U_ZKPRQ,U_ZFPZT,U_ZFPJE,U_ZSKPH)
// VALUES (@Code,@Name,@U_ZFPDM,@U_ZKPRQ,@U_ZFPZT,@U_ZFPJE,@U_ZSKPH)";
var rt = await conn.ExecuteScalarAsync(insertSql, null, dbTransaction);
//await conn.ExecuteAsync(insertSql);
saveRlt.ReturnUniqueKey = InvoicesReturn.ZFPHM;//回传保存订单的主键
dbTransaction.Commit();
saveRlt.Code = 0;
}
catch (Exception ex)
{
dbTransaction.Rollback();
saveRlt.Code = 1;
saveRlt.Message = ex.Message;
throw ex;
}
finally
{
conn.Close();
}
return(saveRlt);
}
}
public async Task <SaveResult> PostInvoicesReturnAsync(InvoicesReturn oInvoicesReturn)
{
return(await InvoicesReturnRepository.Save(oInvoicesReturn));
}
