/// <summary>
///
/// </summary>
/// <param name="userId"></param>
/// <param name="debitMoney"></param>
/// <param name="debitPeroid"></param>
/// <param name="bankId"></param>
/// <param name="description"></param>
/// <returns></returns>
public static DataProviderResultModel SubmitDebitReuqestV2(int userId, float debitMoney, int debitPeroid, int bankId, string description, string deviceId)
{
DataBaseOperator dbo = null;
DataProviderResultModel result = new DataProviderResultModel();
try
{
dbo = new DataBaseOperator();
ParamCollections pc = new ParamCollections();
pc.Add("@iUserId", userId);
pc.Add("@dDebitMoney", debitMoney);
pc.Add("@iDebitPeroid", debitPeroid);
pc.Add("@iBankId", bankId);
pc.Add("@sDescription", description);
pc.Add("@sDeviceId", deviceId);
Hashtable table = new Hashtable();
DataTable dt = dbo.ExecProcedure("p_debit_submitrequest_v2", pc.GetParams(), out table);
if (null != dt && dt.Rows.Count == 1)
{
int.TryParse(Convert.ToString(dt.Rows[0][0]), out result.result);
if (result.result < 0)
{
result.message = Convert.ToString(dt.Rows[0][1]);
result.data = new { debitRecordId = -1 };
Log.WriteErrorLog("DebitProvider::SubmitDebitReuqest", "提交申请失败：{0}|{1}|{2}|{3}|{4},结果是：{5}", userId, debitMoney, debitPeroid, bankId, description, dt.Rows[0][1]);
}
else
{
result.result = Result.SUCCESS;
///记录ID
result.data = new { debitRecordId = Convert.ToString(dt.Rows[0][2]) };
}
}
else
{
result.result = MainErrorModels.LOGIC_ERROR;
result.message = "error from the submit debit request.";
}
return(result);
}
catch (Exception ex)
{
result.result = MainErrorModels.DATABASE_REQUEST_ERROR;
result.message = "The database logic error.The function is SubmitDebitReuqest";
Log.WriteErrorLog("DebitProvider::GetUserBankInfo", "获取失败：{0}，异常：{1}", userId, ex.Message);
}
finally
{
if (null != dbo)
{
dbo.Close();
dbo = null;
}
}
return(result);
}
/// <summary>
///
/// </summary>
/// <param name="userId"></param>
/// <param name="debitId"></param>
/// <param name="payBackDebitMoney"></param>
/// <param name="certificateUrl"></param>
/// <returns></returns>
public static DataProviderResultModel PayBackDebitRequest(int userId, int debitId, float payBackDebitMoney, string certificateUrl)
{
DataBaseOperator dbo = null;
DataProviderResultModel result = new DataProviderResultModel();
List <DebitInfoModel> infos = new List <DebitInfoModel>();
try
{
dbo = new DataBaseOperator();
ParamCollections pc = new ParamCollections();
pc.Add("@iUserId", userId);
pc.Add("@iDebitId", debitId);
pc.Add("@dPayBackDebitMoney", payBackDebitMoney);
pc.Add("@sCertificateUrl", certificateUrl);
Hashtable table = new Hashtable();
DataTable dt = dbo.ExecProcedure("p_debit_paybackrequest", pc.GetParams(), out table);
if (null != dt && dt.Rows.Count == 1)
{
int.TryParse(Convert.ToString(dt.Rows[0][0]), out result.result);
result.message = Convert.ToString(dt.Rows[0][1]);
}
else
{
result.result = MainErrorModels.LOGIC_ERROR;
result.message = "error from the submit payback debit request.";
}
return(result);
}
catch (Exception ex)
{
Log.WriteErrorLog("DebitProvider::PayBackDebitRequest", "获取失败：{0}|{1}，异常：{2}", userId, ex.Message);
}
finally
{
if (null != dbo)
{
dbo.Close();
dbo = null;
}
}
return(result);
}