public async Task <bool> Delete(string Id)
{
using (var conn = SqlConnectionFactory.CreateSqlConnection())
{
conn.Open();
string sql = $"delete FROM T_RefreshToken where Id = '{Id}' ";
try
{
var rtCount = await conn.ExecuteAsync(sql, null);
if (rtCount == 1)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
}
}
public async Task <List <PurchaseReturn> > GetPurchaseReturn(QueryParam queryParam)
{
List <PurchaseReturn> collection = null;
using (var conn = SqlConnectionFactory.CreateSqlConnection())
{
conn.Open();
string sql = $@"SELECT top {queryParam.limit} {queryParam.select} FROM T_PurchaseReturn t0 left JOIN T_PurchaseReturnItem t1 on t0.DocEntry = t1.DocEntry
{queryParam.filter + " " + queryParam.orderby} ";
try
{
var purchaseReturnList = await conn.QueryParentChildAsync <PurchaseReturn, PurchaseReturnItem, int>(sql, p => p.DocEntry, p => p.PurchaseReturnItems, splitOn : "DocEntry");
collection = purchaseReturnList.ToList();
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
return(collection);
}
}
public async Task <bool> ModifyJournalRelationMapPositive(DocumentSync documentSyncData)
{
bool isSuccessOperate = false;
using (var conn = SqlConnectionFactory.CreateSqlConnection())
{
string sql = $@"update T_JournalRelationMap set IsPositiveSync = '{documentSyncData.SyncResult}',
NewPositiveTransId = '{documentSyncData.SAPDocEntry}',
PositiveSyncMessage = '{documentSyncData.SyncMsg}',
PositiveSyncDate='{DateTime.Now}'
where DocEntry in ( {documentSyncData.DocEntry} )";
try
{
var rtCount = await conn.ExecuteAsync(sql);
if (rtCount >= 1)
{
isSuccessOperate = true;
}
else if (rtCount == 0)
{
throw new Exception($"can't found the journalSource info by docentry:{documentSyncData.DocEntry}");
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
return(isSuccessOperate);
}
}
public async Task <List <JournalRelationMap> > GetJournalRelationMapList(QueryParam queryParam)
{
List <JournalRelationMap> collection = null;
using (var conn = SqlConnectionFactory.CreateSqlConnection())
{
conn.Open();
string sql = $"select * from(SELECT top {queryParam.limit} {queryParam.select} FROM T_JournalRelationMap t0 {queryParam.filter + " " + queryParam.orderby}) t2 inner JOIN T_JournalRelationMapItem t1 on t2.DocEntry = t1.DocEntry ";
try
{
var coll = await conn.QueryParentChildAsync <JournalRelationMap, JournalRelationMapLine, int>(sql, p => p.DocEntry, p => p.JournalRelationMapLines, splitOn : "DocEntry");
collection = coll.ToList();
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
return(collection);
}
}
public async Task <RefreshToken> FindById(string Id)
{
RefreshToken collection = null;
using (var conn = SqlConnectionFactory.CreateSqlConnection())
{
conn.Open();
string sql = $"SELECT * FROM T_RefreshToken where Id = '{Id}' ";
try
{
var queryResult = await conn.QueryAsync <RefreshToken>(sql, null);
collection = queryResult.FirstOrDefault();
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
return(collection);
}
}
public async Task <User> GetUser(string UserName)
{
User client = null;
using (var conn = SqlConnectionFactory.CreateSqlConnection())
{
conn.Open();
string sql = $"SELECT * FROM T_User where UserName = @UserName";
try
{
var queryResult = await conn.QueryAsync <User>(sql, new { UserName = UserName });
client = queryResult.FirstOrDefault();
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
return(client);
}
}
public async Task <Client> FindById(string Id)
{
Client client = null;
using (var conn = SqlConnectionFactory.CreateSqlConnection())
{
conn.Open();
string sql = $"SELECT * FROM T_Client where Id = @Id ";
try
{
var queryResult = await conn.QueryAsync <Client>(sql, new { Id = Id });
client = queryResult.FirstOrDefault();
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
return(client);
}
}
public async Task <bool> Update(SerialNumber serialNumber)
{
bool isSuccessOperate = false;
using (var conn = SqlConnectionFactory.CreateSqlConnection())
{
string sql = $@"update T_SerialNumber set CurrentNumber = '{serialNumber.CurrentNumber}'
where ObjectKey in ( {serialNumber.ObjectKey} )";
try
{
var rtCount = await conn.ExecuteAsync(sql);
if (rtCount >= 1)
{
isSuccessOperate = true;
}
else if (rtCount == 0)
{
throw new Exception($"can't found the refund document by docentry:{serialNumber.ObjectKey}");
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
return(isSuccessOperate);
}
}
public async Task <List <PurchaseDelivery> > GetPurchaseDeliveryList(QueryParam Param)
{
List <PurchaseDelivery> collection = null;
using (var conn = SqlConnectionFactory.CreateSqlConnection())
{
conn.Open();
string sql = $"SELECT top {Param.limit} {Param.select} FROM AVA_SP_VIEW_PURCHASE_OPOR t0 left JOIN AVA_SP_VIEW_PURCHASE_OPORLINE t1 on t0.DocEntry = t1.DocEntry {Param.filter + " " + Param.orderby} ";
try
{
var coll = await conn.QueryParentChildAsync <PurchaseDelivery, PurchaseDeliveryItem, int>(sql, p => p.DocEntry, p => p.PurchaseDeliveryItems, splitOn : "DocEntry");
collection = coll.ToList();
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
return(collection);
}
}
public async Task <bool> Insert(User User)
{
using (IDbConnection conn = SqlConnectionFactory.CreateSqlConnection())
{
conn.Open();
IDbTransaction dbTransaction = conn.BeginTransaction();
try
{
string insertSql = @"INSERT INTO T_User(Id,UserName,Password,IsActive,Creator,CreateDate,UpdateTime,Updator,IsDelete)VALUES
(@Id,@UserName,@Password,@IsActive,@Creator,@CreateDate,@UpdateTime,@Updator,@IsDelete)";
int rtCount = await conn.ExecuteAsync(insertSql, User, dbTransaction);
dbTransaction.Commit();
if (rtCount == 1)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
dbTransaction.Rollback();
throw ex;
}
finally
{
conn.Close();
}
}
}
public async Task <List <Refund> > GetRefund(QueryParam Param)
{
List <Refund> collection = null;
using (var conn = SqlConnectionFactory.CreateSqlConnection())
{
conn.Open();
string sql = $"SELECT top {Param.limit} {Param.select} FROM T_Refund t0 left JOIN T_RefundItem t1 on t0.DocEntry = t1.DocEntry {Param.filter + " " + Param.orderby} ";
try
{
var coll = await conn.QueryParentChildAsync <Refund, RefundItem, int>(sql, p => p.DocEntry, p => p.RefundItems, splitOn : "DocEntry");
collection = coll.ToList();
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
return(collection);
}
}
public async Task <bool> UpdateSyncData(DocumentSync documentSyncResult)
{
bool isSuccessOperate = false;
using (var conn = SqlConnectionFactory.CreateSqlConnection())
{
string sql = "update T_Refund set IsSync = @SyncResult,SAPDocEntry = @SAPDocEntry,SyncMsg = @SyncMsg where DocEntry = @DocEntry";
try
{
var rtCount = await conn.ExecuteAsync(sql, new { DocEntry = documentSyncResult.DocEntry,
SAPDocEntry = documentSyncResult.SAPDocEntry,
SyncMsg = documentSyncResult.SyncMsg,
SyncResult = documentSyncResult.SyncResult });
if (rtCount == 1)
{
isSuccessOperate = true;
}
else if (rtCount == 0)
{
throw new Exception($"can't found the refund document by docentry:{documentSyncResult.DocEntry}");
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
return(isSuccessOperate);
}
}
public async Task <List <Material> > GetMaterial(QueryParam queryParam)
{
List <Material> collection = null;
using (var conn = SqlConnectionFactory.CreateSqlConnection())
{
conn.Open();
string sql = $"SELECT top {queryParam.limit} {queryParam.select} FROM T_Materials t0 {queryParam.filter + " " + queryParam.orderby} ";
try
{
var materialList = await conn.QueryAsync <Material>(sql);
collection = materialList.ToList();
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
return(collection);
}
}
public async Task <PurchaseDelivery> GetPurchaseDelivery(int DocEntry)
{
List <PurchaseDelivery> collection = null;
using (var conn = SqlConnectionFactory.CreateSqlConnection())
{
conn.Open();
string sql = $"SELECT * FROM AVA_SP_VIEW_PURCHASE_OPOR t0 left JOIN AVA_SP_VIEW_PURCHASE_OPORLINE t1 on t0.DocEntry = t1.DocEntry where t0.DocEntry = {DocEntry} ";
try
{
var coll = await conn.QueryParentChildAsync <PurchaseDelivery, PurchaseDeliveryItem, int>(sql, p => p.DocEntry, p => p.PurchaseDeliveryItems, splitOn : "DocEntry");
collection = coll.ToList();
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
return(collection.FirstOrDefault());
}
}
public async Task <bool> UpdateSyncData(string ItemCode)
{
bool isSuccessOperate = false;
using (var conn = SqlConnectionFactory.CreateSqlConnection())
{
string sql = $"update T_Materials set IsSync = 'Y',SyncDate = '{DateTime.Now}' where ItemCode = @ItemCode";
try
{
var rtCount = await conn.ExecuteAsync(sql, new { ItemCode = ItemCode });
if (rtCount == 1)
{
isSuccessOperate = true;
}
else if (rtCount == 0)
{
throw new Exception($"can't found the customer by cardcode:{ItemCode}");
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
return(isSuccessOperate);
}
}
public async Task <SerialNumber> GetSerialNumber()
{
List <SerialNumber> customerList = null;
using (var conn = SqlConnectionFactory.CreateSqlConnection())
{
conn.Open();
string sql = $"SELECT * FROM T_SerialNumber where Year = {DateTime.Now.Year} and Month = {DateTime.Now.Month}";
try
{
var collection = await conn.QueryAsync <SerialNumber>(sql);
customerList = collection.ToList();
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
return(customerList.FirstOrDefault());
}
}
public async Task <bool> UpdateINSyncDataBatch(DocumentSync documentSyncData)
{
bool isSuccessOperate = false;
using (var conn = SqlConnectionFactory.CreateSqlConnection())
{
string sql = $@"update T_SalesOrder set IsINSync = '{documentSyncData.SyncResult}',
INSAPDocEntry = '{documentSyncData.SAPDocEntry}',
INMsg = '{documentSyncData.SyncMsg}',
INSyncDate='{DateTime.Now}'
where DocEntry in ( {documentSyncData.DocEntry} )";
try
{
var rtCount = await conn.ExecuteAsync(sql);
if (rtCount >= 1)
{
isSuccessOperate = true;
}
else if (rtCount == 0)
{
throw new Exception($"can't found the refund document by docentry:{documentSyncData.DocEntry}");
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
return(isSuccessOperate);
}
}
public async Task <List <BusinessPartner> > Fetch(QueryParam queryParam)
{
List <BusinessPartner> customerList = null;
using (var conn = SqlConnectionFactory.CreateSqlConnection())
{
conn.Open();
string sql = $"SELECT top {queryParam.limit} {queryParam.select} FROM T_BusinessPartner t0 {queryParam.filter + " " + queryParam.orderby} ";
try
{
var collection = await conn.QueryAsync <BusinessPartner>(sql);
customerList = collection.ToList();
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
return(customerList);
}
}
public async Task <List <JournalSource> > GetJournalSourceList(QueryParam queryParam)
{
List <JournalSource> collection = null;
using (var conn = SqlConnectionFactory.CreateSqlConnection())
{
conn.Open();
string sql = $"select * from(SELECT top {queryParam.limit} {queryParam.select} FROM T_VIEW_JOURNAL_SOURCE t0 {queryParam.filter + " " + queryParam.orderby}) t2 inner JOIN T_View_JournalSourceItem t1 on t2.TransId = t1.TransId ";
try
{
var coll = await conn.QueryParentChildAsync <JournalSource, JournalSourceLine, int>(sql, p => p.TransId, p => p.JournalSourceLines, splitOn : "TransId");
collection = coll.ToList();
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
return(collection);
}
}
public async Task <SaveResult> Save(Refund Refund)
{
SaveResult saveRlt = new SaveResult();
saveRlt.UniqueKey = Refund.OMSDocEntry.ToString();//回传接收方的主键
using (IDbConnection conn = SqlConnectionFactory.CreateSqlConnection())
{
conn.Open();
IDbTransaction dbTransaction = conn.BeginTransaction();
try
{
string insertSql = @"INSERT INTO T_Refund (OMSDocEntry,PlatformCode,DocType,BusinessType,RefundType,RefundReason,CardCode,GrossRefund,Freight,FrghtVendor,PayMethod,Comments,CreateDate,UpdateDate,Creator,UpDator)
VALUES (@OMSDocEntry,@PlatformCode,@DocType,@BusinessType,@RefundType,@RefundReason,@CardCode,@GrossRefund,@Freight,@FrghtVendor,@PayMethod,@Comments,@CreateDate,@UpdateDate,@Creator,@UpDator)select SCOPE_IDENTITY();";
string insertItemSql = @"INSERT INTO T_RefundItem (DocEntry,LineNum,OMSDocEntry,OMSLineNum,ItemCode,Quantity,Price,ItemRefund)
VALUES (@DocEntry,@LineNum,@OMSDocEntry,@OMSLineNum,@ItemCode,@Quantity,@Price,@ItemRefund)";
object DocEntry = await conn.ExecuteScalarAsync(insertSql,
new
{
OMSDocEntry = Refund.OMSDocEntry,
PlatformCode = Refund.PlatformCode,
DocType = Refund.DocType,
BusinessType = Refund.BusinessType,
RefundType = Refund.RefundType,
RefundReason = Refund.RefundReason,
CardCode = Refund.CardCode,
GrossRefund = Refund.GrossRefund,
Freight = Refund.Freight,
FrghtVendor = Refund.FrghtVendor,
PayMethod = Refund.PayMethod,
Comments = Refund.Comments,
CreateDate = DateTime.Now,
UpdateDate = Refund.UpdateDate,
Creator = Refund.Creator,
UpDator = Refund.UpDator
}, dbTransaction);
saveRlt.ReturnUniqueKey = DocEntry.ToString();//回传保存订单的主键
conn.Execute(insertItemSql, DocumentItemHandle <RefundItem> .GetDocumentItems(Refund.RefundItems, Convert.ToInt32(DocEntry)), dbTransaction);
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 void TestMethod1()
{
using (var sqlConnection = SqlConnectionFactory.CreateSqlConnection())
{
sqlConnection.Open();
var query = new GetInvoicesDbQuery();
var queryHandler = new GetInvoicesDbQueryHandler(sqlConnection, transaction: null);
var queryResult = queryHandler.Handle(query);
}
}
public void TestMethod1()
{
using (var sqlConnection = SqlConnectionFactory.CreateSqlConnection())
{
sqlConnection.Open();
var query = new GetCustomerInvoicesDbQuery(customerId: 1, invoiceDate: DateTime.Today);
var queryHandler = new GetCustomerInvoicesDbQueryHandler(sqlConnection, transaction: null);
var queryResult = queryHandler.Handle(query);
}
}
public async Task TestMethod2()
{
using (var sqlConnection = SqlConnectionFactory.CreateSqlConnection())
{
await sqlConnection.OpenAsync();
var query = new GetInvoicesDbQuery();
var queryHandler = new GetInvoicesDbQueryHandler(sqlConnection, transaction: null);
var queryResult = await queryHandler.HandleAsync(query, CancellationToken.None);
}
}
public async Task <SaveResult> Save(SalesOrder SalesOrder)
{
SaveResult saveRlt = new SaveResult();
saveRlt.UniqueKey = SalesOrder.OMSDocEntry.ToString();//回传接收方的主键
using (IDbConnection conn = SqlConnectionFactory.CreateSqlConnection())
{
conn.Open();
IDbTransaction dbTransaction = conn.BeginTransaction();
try
{
string insertSql = @"insert into T_SalesOrder(OMSDocEntry,OMSDocDate,DocType,BusinessType,PlatformCode,CardCode,OrderPaied,Freight,PayMethod,Comments,CreateDate,UpdateDate)
values(@OMSDocEntry,@OMSDocDate,@DocType,@BusinessType,@PlatfromCode,@CardCode,@OrderPaied,@Freight,@Paymenthod,@Comments,@CreateDate,@UpdateDate)select SCOPE_IDENTITY();";
string insertItemSql = @"insert into T_SalesOrderItem(DocEntry,LineNum,OMSDocEntry,OMSLineNum,ItemCode,Quantity,Price,ItemPaied)
values(@DocEntry,@LineNum,@OMSDocEntry,@OMSLineNum,@ItemCode,@Quantity,@Price,@ItemPaied)";
object DocEntry = await conn.ExecuteScalarAsync(insertSql,
new { OMSDocEntry = SalesOrder.OMSDocEntry,
OMSDocDate = SalesOrder.OMSDocDate,
DocType = SalesOrder.DocType,
BusinessType = SalesOrder.BusinessType,
PlatfromCode = SalesOrder.PlatformCode,
CardCode = SalesOrder.CardCode,
OrderPaied = SalesOrder.OrderPaied,
Freight = SalesOrder.Freight,
Paymenthod = SalesOrder.PayMethod,
Comments = SalesOrder.Comments,
CreateDate = DateTime.Now,
UpdateDate = DateTime.Now }, dbTransaction);
saveRlt.ReturnUniqueKey = DocEntry.ToString();//回传保存订单的主键
await conn.ExecuteAsync(insertItemSql, DocumentItemHandle <SalesOrderItem> .GetDocumentItems(SalesOrder.SalesOrderItems, Convert.ToInt32(DocEntry)), dbTransaction);
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 TransactionScope(string connKey = "ConnectionString", IsolationLevel isolationLevel = IsolationLevel.Unspecified)
{
if (null == transaction)
{
IDbConnection connection = SqlConnectionFactory.CreateSqlConnection(connKey);
connection.Open();
IDbTransaction dbTransaction = connection.BeginTransaction(isolationLevel);
Transaction.Current = new CommittableTransaction(dbTransaction);
}
else
{
Transaction.Current = transaction.DependentClone();
}
}
public async Task <SaveResult> Save(Material Material)
{
SaveResult saveRlt = new SaveResult();
saveRlt.UniqueKey = Material.ItemCode;//回传接收方的主键
using (IDbConnection conn = SqlConnectionFactory.CreateSqlConnection())
{
conn.Open();
IDbTransaction dbTransaction = conn.BeginTransaction();
try
{
string insertSql = @"INSERT INTO T_Materials (ItemCode,ItemName,VatGourpSa,VatGourpPu,InitialCost,RealCost,SalesPrice,InvntItem,Consignment,Vendor,OMSGroupNum,CreateDate,UpdateDate)
VALUES (@ItemCode,@ItemName,@VatGourpSa,@VatGourpPu,@InitialCost,@RealCost,@SalesPrice,@InvntItem,@Consignment,@Vendor,@OMSGroupNum,@CreateDate,@UpdateDate)";
await conn.ExecuteScalarAsync(insertSql,
new
{
ItemCode = Material.ItemCode,
ItemName = Material.ItemName,
VatGourpSa = Material.VatGourpSa,
VatGourpPu = Material.VatGourpPu,
InitialCost = Material.InitialCost,
RealCost = Material.RealCost,
SalesPrice = Material.SalesPrice,
InvntItem = Material.InvntItem,
Consignment = Material.Consignment,
Vendor = Material.Vendor,
CreateDate = DateTime.Now,
UpdateDate = DateTime.Now,
OMSGroupNum = Material.OMSGroupNum
}, dbTransaction);
saveRlt.ReturnUniqueKey = Material.ItemCode;//回传保存订单的主键
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> 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 <bool> ModifyJournalRelationMapStatus(DocumentSync documentSyncData)
{
bool isSuccessOperate = false;
using (var conn = SqlConnectionFactory.CreateSqlConnection())
{
//string sql = $@"update T_JournalRelationMap set IsSync = '{documentSyncData.SyncResult}',
// NewTransId = '{documentSyncData.SAPDocEntry}',
// SyncMessage = '{documentSyncData.SyncMsg}',
// SyncDate='{DateTime.Now}'
// where DocEntry in ( {documentSyncData.DocEntry} )";
string sql = $@"update T_JournalRelationMap set IsSync = @IsSync,
NewTransId = @NewTransId,
SyncMessage = @SyncMessage,
SyncDate= @SyncDate
where DocEntry in ( @DocEntry )";
try
{
var rtCount = await conn.ExecuteAsync(sql, new {
IsSync = documentSyncData.SyncResult,
NewTransId = documentSyncData.SAPDocEntry,
SyncMessage = documentSyncData.SyncMsg,
SyncDate = DateTime.Now,
DocEntry = documentSyncData.DocEntry
});
if (rtCount >= 1)
{
isSuccessOperate = true;
}
else if (rtCount == 0)
{
throw new Exception($"can't found the journalSource info by docentry:{documentSyncData.DocEntry}");
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
return(isSuccessOperate);
}
}
public async Task <bool> Insert(RefreshToken refreshToken)
{
using (IDbConnection conn = SqlConnectionFactory.CreateSqlConnection())
{
conn.Open();
IDbTransaction dbTransaction = conn.BeginTransaction();
try
{
string insertSql = @"INSERT INTO T_RefreshToken(Id,UserName,ClientId,IssuedUtc,ExpiresUtc,ProtectedTicket)
VALUES(@Id,@UserName,@ClientId,@IssuedUtc,@ExpiresUtc,@ProtectedTicket)";
string sql = $@"INSERT INTO T_RefreshToken(Id,UserName,ClientId,IssuedUtc,ExpiresUtc,ProtectedTicket)
VALUES('{refreshToken.Id}','{refreshToken.UserName}','{refreshToken.ClientId}',{refreshToken.IssuedUtc},
{refreshToken.ExpiresUtc},'{refreshToken.ProtectedTicket}')";
int rtCount = await conn.ExecuteAsync(insertSql,
new
{
Id = refreshToken.Id,
UserName = refreshToken.UserName,
ClientId = refreshToken.ClientId,
IssuedUtc = refreshToken.IssuedUtc,
ExpiresUtc = refreshToken.ExpiresUtc,
ProtectedTicket = refreshToken.ProtectedTicket
}, dbTransaction);
dbTransaction.Commit();
if (rtCount == 1)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
dbTransaction.Rollback();
throw ex;
}
finally
{
conn.Close();
}
}
}
public async Task <bool> Save(Client client)
{
using (IDbConnection conn = SqlConnectionFactory.CreateSqlConnection())
{
conn.Open();
IDbTransaction dbTransaction = conn.BeginTransaction();
try
{
string insertSql = @"INSERT INTO T_Client(Id, Secret, Name, IsActive, RefreshTokenLifeTime, DateAdded)
VALUES( @Id, @Secret, @Name, @IsActive, @RefreshTokenLifeTime, @DateAdded)";
int rtCount = await conn.ExecuteAsync(insertSql,
new
{
Id = client.Id,
Secret = client.Secret,
Name = client.Name,
IsActive = client.IsActive,
RefreshTokenLifeTime = client.RefreshTokenLifeTime,
DateAdded = client.DateAdded
}, dbTransaction);
dbTransaction.Commit();
if (rtCount == 1)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
dbTransaction.Rollback();
throw ex;
}
finally
{
conn.Close();
}
}
}
