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