/// <summary>
/// 2.3 提现
/// </summary>
/// <param name="platformUserNo"></param>
/// <param name="requestNo"></param>
/// <returns></returns>
public bool ToWithdraw(string platformUserNo, string requestNo)
{
RQProcParam proc = new RQProcParam();
proc.ProcName = "pro_Withdraw";
proc.DicParam.Add("Uid", platformUserNo);
proc.DicParam.Add("PayNo", requestNo);
BaseHelper baseHelper = new BaseHelper();
return(baseHelper.ExecByProc(proc) > 0 ? true : false);
}
/// <summary>
/// 2.1 注册
/// </summary>
/// <param name="platformUserNo"></param>
/// <returns></returns>
public bool ToRegister(string platformUserNo)
{
RQProcParam proc = new RQProcParam();
proc.ProcName = "Pro_ToRegister";
proc.DicParam.Add("Uid", platformUserNo);
BaseHelper baseHelper = new BaseHelper();
return(baseHelper.ExecByProc(proc) > 0 ? true : false);
//SystemUsersOper systemUsersOper = new SystemUsersOper();
//return systemUsersOper.UpdateById(platformUserNo,1);
}
/// <summary>
/// 2.4 绑卡
/// </summary>
/// <param name="bankCardNo">卡号</param>
/// <param name="bank">开户行</param>
/// <param name="platformUserNo">商户号</param>
/// <param name="requestNo">请求流水号</param>
/// <returns></returns>
public bool ToBindBank(string bankCardNo, string bank, string platformUserNo, string requestNo)
{
RQProcParam proc = new RQProcParam();
proc.ProcName = "Pro_BankCard";
proc.DicParam.Add("Uid", platformUserNo);
proc.DicParam.Add("BankCardNumber", bankCardNo);
proc.DicParam.Add("OpenAnAccountBankCard", bank);
proc.DicParam.Add("PayNo", requestNo);
BaseHelper baseHelper = new BaseHelper();
return(baseHelper.ExecByProc(proc) > 0 ? true : false);
}
public BaseResultDto <StatisticalDto> GetStatistical()
{
BaseResultDto <StatisticalDto> result = new BaseResultDto <StatisticalDto>();
try
{
RQProcParam proc = new RQProcParam();
proc.ProcName = "proc_Statistical";
StatisticalDto statisticalDto = helper.GetDataByProc <StatisticalDto>(proc).FirstOrDefault();
result.Tag = statisticalDto;
}
catch (Exception ex)
{
result.ErrorMsg = ex.Message;
result.ErrorCode = -1;
}
return(result);
}
/// <summary>
/// 执行存储过程 带返回值
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public object ExecReturnByProc(RQProcParam param)
{
List <SqlParameter> sqlParamterList = new List <SqlParameter>();
foreach (KeyValuePair <string, object> item in param.DicParam)
{
if (item.Value != null)
{
sqlParamterList.Add(new SqlParameter(string.Format("@{0}", item.Key), item.Value));
}
}
foreach (KeyValuePair <string, TVPItem> item in param.DicTvpParam)
{
if (item.Value.Value != null && !string.IsNullOrEmpty(item.Key))
{
SqlParameter sqlParameter = new SqlParameter(string.Format("@{0}", item.Key), item.Value.Value);
sqlParameter.SqlDbType = SqlDbType.Structured;
sqlParameter.TypeName = item.Value.TypeName;
}
}
return(sqlhelper.ExecReturnByProc(param.ProcName, sqlParamterList.ToArray()));
}
public BaseResultDto <string> GiveVirtualMoney(GiveVirtualMoneyDto model)
{
BaseResultDto <string> resultDto = new BaseResultDto <string>();
try
{
RQProcParam proc = new RQProcParam();
proc.ProcName = "Proc_GiveVirtualMoney";
proc.DicParam.Add("Ids", model.Ids);
proc.DicParam.Add("IsAllUser", model.IsAllUser);
proc.DicParam.Add("GiveMoney", model.GiveMoney);
proc.DicParam.Add("BountyType", model.BountyType);
proc.DicParam.Add("BountyRes", model.BountyRes);
proc.DicParam.Add("OverTime", model.OverTime);
proc.DicParam.Add("OperatorUserId", model.OperatorUserId);
proc.DicParam.Add("OperatorUserName", model.OperatorUserName);
proc.DicParam.Add("IP", model.IP);
int status = helper.ExecReturnByProc(proc).ToInt();
if (status == 0)
{
resultDto.ErrorMsg = "赠送成功";
resultDto.ErrorCode = 1;
resultDto.IsSeccess = true;
}
else
{
resultDto.ErrorMsg = "赠送失败";
resultDto.ErrorCode = 0;
}
}
catch (Exception ex)
{
resultDto.ErrorMsg = ex.Message;
resultDto.ErrorCode = -1;
}
return(resultDto);
}
/// <summary>
/// 调用存储过程 返回列表
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="procName"></param>
/// <returns></returns>
public List <T> GetDataByProc <T>(RQProcParam param)
{
DataTable table = GetDataTableByProc(param);
return(Mapper.DynamicMap <IDataReader, List <T> >(table.CreateDataReader()));
}
