/// <summary>
/// 插入
/// </summary>
/// <param name="model">插入的数据模型</param>
/// <returns>返回受影响行</returns>
/// <remarks>2017-01-16 杨浩 创建</remarks>
public int Insert(CrCustomerShipCard model)
{
int sysNo = ICrCustomerShipCardDao.Instance.Insert(model);
if (sysNo > 0)
{
var balanceInfo = BLL.Balance.CrRechargeBo.Instance.GetCrABalanceEntity(model.CustomerSysNo);
if (balanceInfo == null)
{
var _model = new CrAccountBalance()
{
CustomerSysNo = model.CustomerSysNo,
AvailableBalance = 0,
FrozenBalance = 0,
TolBlance = 0,
Remark = "",
State = 0,
AddTime = DateTime.Now,
};
BLL.Balance.CrRechargeBo.Instance.CreateCrAccountBalance(_model);
}
}
return(sysNo);
}
/// <summary>
/// 创建余额记录
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public override int CreateCrAccountBalance(CrAccountBalance model)
{
return(Context.Insert <CrAccountBalance>("CrAccountBalance", model).AutoMap(x => x.SysNo).ExecuteReturnLastId <int>("SysNo"));
}
/// <summary> /// 更新会员余额 /// </summary> /// <param name="model"></param> /// <returns></returns> public abstract int UpdateABalance(CrAccountBalance model);
/// <summary>
/// 更新会员余额
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public override int UpdateABalance(CrAccountBalance model)
{
return(Context.Update <CrAccountBalance>("CrAccountBalance", model).AutoMap(x => x.CustomerSysNo).Where(x => x.CustomerSysNo).Execute());
}
/// <summary> /// 创建余额记录 /// </summary> /// <param name="model"></param> /// <returns></returns> public abstract int CreateCrAccountBalance(CrAccountBalance model);
public JsonResult Audit(int SysNo, int Status)
{
var result = new Result
{
Status = false
};
try
{
string IsSellBusiness = "";
result.Status = true;
//更新状态
DsDealerBailOrderBo.Instance.UpdateStatus(SysNo, 0, Status);
DsDealerBailOrder Model = DsDealerBailOrderBo.Instance.GetModel(SysNo);
//更新会员是否为分销商的状态
if (Status == (int)Hyt.Model.WorkflowStatus.StoresStatus.保证金订单状态.待审核)
{
IsSellBusiness = "0";
Hyt.BLL.CRM.CrCustomerBo.Instance.UpdateIsSellBusiness(Model.CustomerSysNo, IsSellBusiness);
}
if (Status == (int)Hyt.Model.WorkflowStatus.StoresStatus.保证金订单状态.已审核)
{
IsSellBusiness = "1";
Hyt.BLL.CRM.CrCustomerBo.Instance.UpdateIsSellBusiness(Model.CustomerSysNo, IsSellBusiness);
string OutTradeNo = "DsDealerBailOrder_" + Model.SysNo;
int Recharge = BLL.Balance.CrRechargeBo.Instance.IsDealerCrRecharge(Model.CustomerSysNo, OutTradeNo);
if (Recharge == 0)
{
decimal amount = 10;
CrRecharge model = new CrRecharge();
model.TradeNo = "RechargeWX_" + DateTime.Now.ToString("yyyyMMddHHmmss");
model.OutTradeNo = "DsDealerBailOrder_" + Model.SysNo;
model.CustomerSysNo = Model.CustomerSysNo;
model.ReAmount = amount;
model.RePaymentName = "保证金返回";
model.RePaymentId = Hyt.Model.SystemPredefined.PaymentType.分销商预存;
model.ReAddTime = DateTime.Now;
model.ReMark = "分销商审核通过返回：" + amount + "元";
model.State = 1;
Hyt.BLL.Balance.CrRechargeBo.Instance.CreateCrRecharge(model);
int isb = Hyt.BLL.Balance.CrRechargeBo.Instance.IsExistenceABalance(Model.CustomerSysNo);
if (isb == 0)
{
CrAccountBalance balance = new CrAccountBalance();
balance.CustomerSysNo = Model.CustomerSysNo;
balance.AvailableBalance = 10;
balance.FrozenBalance = 0M;
balance.TolBlance = 10;
balance.Remark = "";
balance.State = 0;
balance.AddTime = DateTime.Now;
Hyt.BLL.Balance.CrRechargeBo.Instance.CreateCrAccountBalance(balance);
}
else
{
Hyt.BLL.Balance.CrRechargeBo.Instance.UpdateAccountBalance(amount, Model.CustomerSysNo);
}
}
}
if (Status == (int)Hyt.Model.WorkflowStatus.StoresStatus.保证金订单状态.作废)
{
//插入记录到付款单
FnPaymentVoucher paymentVoucher = new FnPaymentVoucher();
paymentVoucher.Source = 20;
paymentVoucher.SourceSysNo = SysNo;
paymentVoucher.PayableAmount = Model.Money;
paymentVoucher.PaidAmount = 0;
paymentVoucher.CustomerSysNo = Model.CustomerSysNo;
paymentVoucher.Status = 10;
paymentVoucher.Remarks = "保证金作废";
paymentVoucher.CreatedDate = DateTime.Now;
paymentVoucher.CreatedBy = CurrentUser.Base.SysNo;
paymentVoucher.PayerSysNo = 0;
paymentVoucher.PayDate = (DateTime)System.Data.SqlTypes.SqlDateTime.MinValue;;
paymentVoucher.LastUpdateDate = DateTime.Now;
paymentVoucher.LastUpdateBy = CurrentUser.Base.SysNo;
paymentVoucher.PaymentType = 0;
int vSysNo = FinanceBo.Instance.InsertPaymentVoucher(paymentVoucher);
}
}
catch (Exception ex)
{
result.Message = ex.Message;
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 审核提现订单
/// </summary>
/// <param name="sysNo">提现订单系统编号</param>
/// <returns></returns>
/// <remarks>2016-1-10 杨浩 创建</remarks>
public bool AduitPredepositCash(int sysNo)
{
using (var tran = new TransactionScope())
{
ICrPredepositCashDao.Instance.UpdateStatus(sysNo, 1);
#region 付款单
var predepositCashInfo = GetModel(sysNo);
var pvEntity = new FnPaymentVoucher();
pvEntity.Source = (int)FinanceStatus.付款来源类型.会员提现单;
pvEntity.SourceSysNo = sysNo;
pvEntity.PayableAmount = predepositCashInfo.PdcAmount;
pvEntity.PaidAmount = 0;
pvEntity.CustomerSysNo = predepositCashInfo.PdcUserId;
pvEntity.RefundBank = predepositCashInfo.PdcToBank;
pvEntity.RefundAccountName = predepositCashInfo.PdcToName;
pvEntity.RefundAccount = predepositCashInfo.PdcCashAccount;
pvEntity.Status = (int)FinanceStatus.付款单状态.待付款;
pvEntity.CreatedDate = DateTime.Now;
pvEntity.PayDate = (DateTime)System.Data.SqlTypes.SqlDateTime.MinValue;
pvEntity.LastUpdateDate = DateTime.Now;
pvEntity.PaymentType = predepositCashInfo.PdcPaymentId;
var paymentVoucherItem = new List <FnPaymentVoucherItem>();
#region 提现到余额
if (predepositCashInfo.PdcPaymentId == (int)FinanceStatus.付款单付款方式.余额)
{
var customerInfo = BLL.CRM.CrCustomerBo.Instance.GetModel(pvEntity.CustomerSysNo);
pvEntity.Status = (int)FinanceStatus.付款单状态.已付款;
pvEntity.PayDate = DateTime.Now;
pvEntity.PayableAmount = 0;
pvEntity.PaidAmount = predepositCashInfo.PdcAmount;
var item = new FnPaymentVoucherItem();
item.PaymentType = pvEntity.PaymentType;
item.Amount = pvEntity.PayableAmount;
item.VoucherNo = Guid.NewGuid().ToString("N");
item.Status = (int)FinanceStatus.付款单状态.已付款;
item.RefundBank = "转为商城余额";
item.RefundAccountName = customerInfo.NickName;
item.RefundAccount = customerInfo.Account;
item.CreatedDate = DateTime.Now;
item.PayDate = DateTime.Now;
item.LastUpdateDate = DateTime.Now;
paymentVoucherItem.Add(item);
//充值记录
var model = new CrRecharge();
model.TradeNo = Guid.NewGuid().ToString("N"); //"RechargeWX_" + dtNow.ToString("yyMMddHHmmssfff");
model.OutTradeNo = predepositCashInfo.PdcOutTradeNo;
model.CustomerSysNo = customerInfo.SysNo;
model.ReAmount = predepositCashInfo.PdcAmount;
model.RePaymentName = "佣金转余额";
model.RePaymentId = Hyt.Model.SystemPredefined.PaymentType.转账;
model.ReAddTime = DateTime.Now;
model.State = 1;
model.ReMark = "佣金：" + predepositCashInfo.PdcAmount + "元,转为余额";
int res = Hyt.BLL.Balance.CrRechargeBo.Instance.CreateCrRecharge(model);
//更新余额
int isb = Hyt.BLL.Balance.CrRechargeBo.Instance.IsExistenceABalance(customerInfo.SysNo);
if (isb == 0)
{
var balance = new CrAccountBalance();
balance.CustomerSysNo = customerInfo.SysNo;
balance.AvailableBalance = predepositCashInfo.PdcAmount;
balance.FrozenBalance = 0M;
balance.TolBlance = predepositCashInfo.PdcAmount;
balance.Remark = "";
balance.State = 0;
balance.AddTime = DateTime.Now;
int ba = Hyt.BLL.Balance.CrRechargeBo.Instance.CreateCrAccountBalance(balance);
}
else
{
//更新会员余额
Hyt.BLL.Balance.CrRechargeBo.Instance.UpdateAccountBalance(predepositCashInfo.PdcAmount, customerInfo.SysNo);
}
BLL.CRM.CrCustomerBo.Instance.UpdateCustomerBrokerageFreeze(customerInfo.SysNo, predepositCashInfo.PdcAmount);
}
#endregion
int voucher = Hyt.BLL.Finance.FinanceBo.Instance.CreatePaymentVoucher(pvEntity, paymentVoucherItem);
tran.Complete();
#endregion
return(true);
}
}
/// <summary>
/// 更新会员余额
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int UpdateABalance(CrAccountBalance model)
{
return(CrRechargeDao.Instance.UpdateABalance(model));
}
/// <summary>
/// 创建余额记录
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int CreateCrAccountBalance(CrAccountBalance model)
{
return(CrRechargeDao.Instance.CreateCrAccountBalance(model));
}
