/// <summary>
/// 根据取款信息Id获取取款信息
/// </summary>
/// <param name="AccountWithdrawalsId">取款信息Id</param>
/// <returns>返回取款信息</returns>
public AccountWithdrawals GetAccountWithdrawalsByAccountWithdrawalsId(string AccountWithdrawalsId)
{
AccountWithdrawals accountWithdrawals = null;
accountWithdrawals = new AccountWithdrawalsDAL().GetAccountWithdrawalsByWithdrawalsId(AccountWithdrawalsId);
return(accountWithdrawals);
}
public int AccountWithdrawals(string HolderName, string WWTrading_account, string WWPhone, string WWEmail, string WWAddress, string WWCountry, string WWProvince,
string WWCity, string WWZipCode, string WWMoney, string WWAccountHolder, string IsCloseAccountY, string IsCloseAccountText,
string WWBankName, string WWBankAccount, string AccountHolderName, string WWSWIFT_Code, string WWBankAddress, string WWBankCountry,
string WWBankProvince, string WWBankCity, string WWBankZipCode, string RadioIsTransitBankN, string WWTransitBankName,
string WWTransitBankAcoount, string WWTransitAcoountHolderName, string WWTransitSWIFTCode, string WWTransitBankAddress,
string WWTransitCountry, string WWTransitProvince, string WWTransitCity, string WWTransitZipCode, string WWMainAccountHolderName)
{
AccountWithdrawals acc = new AccountWithdrawals
{
WithdrawalsAccountHolder = HolderName, //账户持有人姓名
WithdrawalsAccount = WWTrading_account, //交易账号
Phone = WWPhone, //联系电话
WithdrawalsEmail = WWEmail, //电子邮箱
WithdrawalsAddress = WWAddress, //地址
WithdrawalsCountry = WWCountry, //个人居住国家
WithdrawalsProvince = WWProvince, //个人居住州
WithdrawalsCity = WWCity, //个人居住城市
WithdrawalsCityZipCode = WWZipCode, //个人居住城市邮编
Money = WWMoney, //取款金额
BelongsPlatform = WWAccountHolder, //平台meta trader 4
IsCloseAccount = IsCloseAccountY, //是否关闭交易账户
CloseReason = IsCloseAccountText, //关闭账户原因
BankName = WWBankName, //银行名称
BankAccount = WWBankAccount, //银行账号
BankHolder = AccountHolderName, //银行账户持有人姓名
SWIFT_Code = WWSWIFT_Code, //国际银行代码（SWIFT Code）
BankAddress = WWBankAddress, //银行地址
BankCountry = WWBankCountry, //银行所在国家
BankProvince = WWBankProvince, //银行所在州，省
BankCity = WWBankCity, //银行所在城市
BankCityZipCode = WWBankZipCode, //银行所在城市邮编
IsTransitBank = RadioIsTransitBankN, //是否有中转银行
TransitBankName = WWTransitBankName, //中转银行名称
TransitBankAccount = WWTransitBankAcoount, //中转银行账号
TransitBankHolder = WWTransitAcoountHolderName, //中转银行账户持有人姓名
TransitBankAddress = WWTransitSWIFTCode, //中转银行国际银行代码
TransitBankSWIFICode = WWTransitBankAddress, //中转银行地址
TransitBankCountry = WWTransitCountry, //中转银行所在国家
TransitBankProvince = WWTransitProvince, //中转银行所在州省
TransitBankCity = WWTransitCity, //中转银行所在城市
TransitBankCityZipCode = WWTransitZipCode, //中转银行所在城市右邮编
MainAccountName = WWMainAccountHolderName, //主要账户持有人姓名
MinorAccountName = "", //次要账户持有人姓名
WithdrawalsDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"),
ProcessingStatus = "未处理",
Explanation = ""
};
InsertLogs(new UserLog {
Account = WWTrading_account, LogIP = IPHelper.GetIp(), LogDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), Explain = "出金操作", Property1 = "出金" + WWMoney + ",申请已提交,正在处理中..."
});
bool flag = new DepositAccountBll().AddAccountWithdrawals(acc);
return(Convert.ToInt32(flag));
}
/// <summary>
/// 添加账户取款信息
/// </summary>
/// <param name="accountWithdrawals">要添加的取款信息</param>
/// <returns>添加取款结果</returns>
public bool AddAccountWithdrawals(AccountWithdrawals accountWithdrawals)
{
bool result = false;
try
{
accountWithdrawals = new AccountWithdrawalsDAL().AddAccount(accountWithdrawals);
if (accountWithdrawals != null)
{
result = true;
}
else
{
result = false;
}
}
catch (Exception)
{
result = false;
}
return(result);
}
/// <summary>
/// 根据取款信息Id查询取款信息
/// </summary>
/// <param name="ClassesID"></param>
/// <returns></returns>
public AccountWithdrawals GetAccountWithdrawalsByWithdrawalsId(string WithdrawalsId)
{
AccountWithdrawals accountWithdrawals = null;
param.Add("[@WithdrawalsId],[" + WithdrawalsId + "]");
try
{
ws_mysql.Credentials = new System.Net.NetworkCredential(PublicConst.WS_USERNAME, PublicConst.WS_USERPWD);
DataSet myDataset = ws_mysql.ExecuteDataSet(param.ToArray(), "", selSql, "dgm");
foreach (DataRow mDr in myDataset.Tables[0].Rows)
{
accountWithdrawals = new AccountWithdrawals();
accountWithdrawals.WithdrawalsId = WithdrawalsId;
accountWithdrawals.WithdrawalsAccountHolder = mDr["WithdrawalsAccountHolder"].ToString();
accountWithdrawals.WithdrawalsAccount = mDr["WithdrawalsAccount"].ToString();
accountWithdrawals.WithdrawalsDate = mDr["WithdrawalsDate"].ToString();
accountWithdrawals.Phone = mDr["Phone"].ToString();
accountWithdrawals.WithdrawalsEmail = mDr["WithdrawalsEmail"].ToString();
accountWithdrawals.WithdrawalsAddress = mDr["WithdrawalsAddress"].ToString();
accountWithdrawals.WithdrawalsCountry = mDr["WithdrawalsCountry"].ToString();
accountWithdrawals.WithdrawalsProvince = mDr["WithdrawalsProvince"].ToString();
accountWithdrawals.WithdrawalsCity = mDr["WithdrawalsCity"].ToString();
accountWithdrawals.WithdrawalsCityZipCode = mDr["WithdrawalsCityZipCode"].ToString();
accountWithdrawals.Money = mDr["Money"].ToString();
accountWithdrawals.BelongsPlatform = mDr["BelongsPlatform"].ToString();
accountWithdrawals.IsCloseAccount = mDr["IsCloseAccount"].ToString();
accountWithdrawals.CloseReason = mDr["CloseReason"].ToString();
accountWithdrawals.BankName = mDr["BankName"].ToString();
accountWithdrawals.BankAccount = mDr["BankAccount"].ToString();
accountWithdrawals.BankHolder = mDr["BankHolder"].ToString();
accountWithdrawals.BankAddress = mDr["BankAddress"].ToString();
accountWithdrawals.SWIFT_Code = mDr["SWIFT_Code"].ToString();
accountWithdrawals.BankCountry = mDr["BankCountry"].ToString();
accountWithdrawals.BankProvince = mDr["BankProvince"].ToString();
accountWithdrawals.BankCity = mDr["BankCity"].ToString();
accountWithdrawals.BankCityZipCode = mDr["BankCityZipCode"].ToString();
accountWithdrawals.IsTransitBank = mDr["IsTransitBank"].ToString();
accountWithdrawals.TransitBankName = mDr["TransitBankName"].ToString();
accountWithdrawals.TransitBankAccount = mDr["TransitBankAccount"].ToString();
accountWithdrawals.TransitBankHolder = mDr["TransitBankHolder"].ToString();
accountWithdrawals.TransitBankAddress = mDr["TransitBankAddress"].ToString();
accountWithdrawals.TransitBankSWIFICode = mDr["TransitBankSWIFICode"].ToString();
accountWithdrawals.TransitBankCountry = mDr["TransitBankCountry"].ToString();
accountWithdrawals.TransitBankProvince = mDr["TransitBankProvince"].ToString();
accountWithdrawals.TransitBankCity = mDr["TransitBankCity"].ToString();
accountWithdrawals.TransitBankCityZipCode = mDr["TransitBankCityZipCode"].ToString();
accountWithdrawals.MainAccountName = mDr["MainAccountName"].ToString();
accountWithdrawals.MinorAccountName = mDr["MinorAccountName"].ToString();
accountWithdrawals.Explanation = mDr["Explanation"].ToString();
accountWithdrawals.ProcessingStatus = mDr["ProcessingStatus"].ToString();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
param.Clear();
}
return(accountWithdrawals);
}
/// <summary>
/// 添加取款信息
/// </summary>
/// <param name="Model">取款信息</param>
/// <returns>新添加的取款信息</returns>
public AccountWithdrawals AddAccount(AccountWithdrawals Model)
{
AccountWithdrawals accountWithdrawals = null;
param.Add("[@WithdrawalsAccountHolder],[" + Model.WithdrawalsAccountHolder + "]");
param.Add("[@WithdrawalsAccount],[" + Model.WithdrawalsAccount + "]");
param.Add("[@WithdrawalsDate],[" + Model.WithdrawalsDate + "]");
param.Add("[@Phone],[" + Model.Phone + "]");
param.Add("[@WithdrawalsEmail],[" + Model.WithdrawalsEmail + "]");
param.Add("[@WithdrawalsAddress],[" + Model.WithdrawalsAddress + "]");
param.Add("[@WithdrawalsCountry],[" + Model.WithdrawalsCountry + "]");
param.Add("[@WithdrawalsProvince],[" + Model.WithdrawalsProvince + "]");
param.Add("[@WithdrawalsCity],[" + Model.WithdrawalsCity + "]");
param.Add("[@WithdrawalsCityZipCode],[" + Model.WithdrawalsCityZipCode + "]");
param.Add("[@Money],[" + Model.Money + "]");
param.Add("[@BelongsPlatform],[" + Model.BelongsPlatform + "]");
param.Add("[@IsCloseAccount],[" + Model.IsCloseAccount + "]");
param.Add("[@CloseReason],[" + Model.CloseReason + " ]");
param.Add("[@BankName],[" + Model.BankName + "]");
param.Add("[@BankAccount],[" + Model.BankAccount + "]");
param.Add("[@BankHolder],[" + Model.BankHolder + "]");
param.Add("[@BankAddress],[" + Model.BankAddress + "]");
param.Add("[@SWIFT_Code],[" + Model.SWIFT_Code + "]");
param.Add("[@BankCountry],[" + Model.BankCountry + "]");
param.Add("[@BankProvince],[" + Model.BankProvince + "]");
param.Add("[@BankCity],[" + Model.BankCity + "]");
param.Add("[@BankCityZipCode],[" + Model.BankCityZipCode + "]");
param.Add("[@IsTransitBank],[" + Model.IsTransitBank + "]");
param.Add("[@TransitBankName],[" + Model.TransitBankName + "]");
param.Add("[@TransitBankAccount],[" + Model.TransitBankAccount + "]");
param.Add("[@TransitBankHolder],[" + Model.TransitBankHolder + "]");
param.Add("[@TransitBankAddress],[" + Model.TransitBankAddress + "]");
param.Add("[@TransitBankSWIFICode],[" + Model.TransitBankSWIFICode + "]");
param.Add("[@TransitBankCountry],[" + Model.TransitBankCountry + "]");
param.Add("[@TransitBankProvince],[" + Model.TransitBankProvince + "]");
param.Add("[@TransitBankCity],[" + Model.TransitBankCity + "]");
param.Add("[@TransitBankCityZipCode],[" + Model.TransitBankCityZipCode + "]");
param.Add("[@MainAccountName],[" + Model.MainAccountName + "]");
param.Add("[@MinorAccountName],[" + Model.MinorAccountName + "]");
param.Add("[@Explanation],[" + Model.Explanation + "]");
param.Add("[@ProcessingStatus],[" + Model.ProcessingStatus + "]");
try
{
ws_mysql.Credentials = new System.Net.NetworkCredential(PublicConst.WS_USERNAME, PublicConst.WS_USERPWD);
string obj = ws_mysql.ExecuteScalar(param.ToArray(), "", addSql, "dgm");
if (!string.IsNullOrEmpty(obj))
{
accountWithdrawals = GetAccountWithdrawalsByWithdrawalsId(Convert.ToString(obj));
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
param.Clear();
}
return(accountWithdrawals);
}
