private List <MolPayMember> GetAPIRequests(DateTime date)
{
string sql = @"SELECT MI02 AS MemberId, MI07 As MemberName, MI77 AS MerchantId, MI78 As VerifyKey, MI79 As SecretKey
FROM GoodMaji.dbo.MemberInfo ON MI02=MA05
WHERE MI80=1 ";
var cmd = new SqlCommand {
CommandText = sql
};
var dt = SqlDbmanager.queryBySql(cmd);
var transactionApiRequests = new List <MolPayMember>();
if (dt == null || dt.Rows == null || dt.Rows.Count == 0)
{
return(transactionApiRequests);
}
foreach (DataRow dr in dt.Rows)
{
var transactionRequest = new MolPayMember();
transactionRequest.MerchantId = dr["MerchantId"].ToString();
transactionRequest.MemberId = dr["MemberId"].ToString();
transactionRequest.MemberName = dr["MemberName"].ToString();
transactionRequest.SecretKey = dr["SecretKey"].ToString();
transactionRequest.VerifyKey = dr["VerifyKey"].ToString();
transactionApiRequests.Add(transactionRequest);
}
return(transactionApiRequests);
}
private void AddMolPayTransaction(List <TransactionAPIResponse> transactionAPIResponses, MolPayMember member)
{
var cmdList = new List <SqlCommand>();
foreach (var response in transactionAPIResponses)
{
response.SysId = Guid.NewGuid();
if (response.SettlementDate.Contains("0000-00-00"))
{
response.SettlementDate = null;
}
if (response.PaidDate.Contains("0000-00-00"))
{
response.PaidDate = null;
}
response.MemberName = member.MemberName;
response.MemberId = member.MemberId;
cmdList.Add(SqlExtension.GetInsertSqlCmd("MolPayTransaction", response));
}
SqlDbmanager.ExecuteNonQryMutiSqlCmd(cmdList);
}
