/// <summary> /// 设置返利佣金操作 /// </summary> /// <param name="SysNo">返利佣金列表</param> /// <remarks>2015-10-19 杨云奕 添加</remarks> public override void SetCrCustomerRebatesRecordToCustomerBrokerage(int SysNo) { string sql = "select * from CrCustomerRebatesRecord where SysNo=" + SysNo; CrCustomerRebatesRecord recordMod = Context.Sql(sql).QuerySingle <CrCustomerRebatesRecord>(); //获取返利列表集合 List <CBRcReturn> list = Hyt.DataAccess.RMA.IRcReturnDao.Instance.GetRmaReturnListByOrderSysNo(recordMod.OrderSysNo); //获取客户信息 CBCrCustomer customer = Hyt.DataAccess.CRM.ICrCustomerDao.Instance.GetModel(recordMod.RecommendSysNo); if (list.Count > 0) { //更新返利列表状态,作废的部分 recordMod.Status = "-1"; Update(recordMod); //减去用户的冻结金额部分 customer.BrokerageFreeze -= recordMod.Rebates; Hyt.DataAccess.CRM.ICrCustomerDao.Instance.Update(customer); } else { //更新返利列表状态,完成的部分 recordMod.Status = "1"; Update(recordMod); //增加用户的资金 customer.BrokerageFreeze -= recordMod.Rebates; //customer.BrokerageTotal += recordMod.Rebates; customer.Brokerage += recordMod.Rebates; Hyt.DataAccess.CRM.ICrCustomerDao.Instance.Update(customer); } }
/// <summary> /// 更新会员信息 /// </summary> /// <param name="models">会员信息列表</param> /// <returns>空</returns> /// <remarks>2015-09-10 王耀发 创建</remarks> public override void UpdateExcelCrCustomer(List <CrCustomer> models) { foreach (CrCustomer model in models) { CBCrCustomer crdata = GetCrCustomer(model.Account); int SysNo = crdata.SysNo; Context.Update("CrCustomer") .Column("Name", model.Name) .Column("NickName", model.NickName) .Where("SysNo", SysNo) .Execute(); } }
/// <summary> /// 设置返利佣金操作 /// </summary> /// <param name="customerRebatesRecord">返利日志详情</param> /// <param name="rcReturnItems">退换货扣除返利列表</param> /// <remarks> /// 2015-10-19 杨云奕 添加 /// 2016-1-5 杨浩 重构 /// </remarks> public void SetCrCustomerRebatesRecordToCustomerBrokerage(CrCustomerRebatesRecord customerRebatesRecord, List <CBReurnDeductRebates> rcReturnItems) { //获取推荐人客户信息 CBCrCustomer customer = Hyt.DataAccess.CRM.ICrCustomerDao.Instance.GetModel(customerRebatesRecord.RecommendSysNo); //获当前的返利记录 //rcReturnItems = rcReturnItems.Where(x => x.SysNo == customerRebatesRecord.SysNo).ToList(); foreach (var item in rcReturnItems) { //item.ReturnStatus=0 代表订单无退换货 if (item.ReturnStatus == 0 || item.ReturnStatus == (int)RmaStatus.退换货状态.作废) { //更新返利列表状态,完成的部分 customerRebatesRecord.Status = "1"; Hyt.DataAccess.SellBusiness.ICrCustomerRebatesRecordDao.Instance.Update(customerRebatesRecord); //减去用户的冻结资金 customer.BrokerageFreeze = customer.BrokerageFreeze - customerRebatesRecord.Rebates; //customer.BrokerageTotal += recordMod.Rebates; //增加用户的可提佣金 customer.Brokerage = customer.Brokerage + customerRebatesRecord.Rebates; Hyt.DataAccess.CRM.ICrCustomerDao.Instance.Update(customer); //Hyt.BLL.Distribution.DsPrePaymentItemBo.Instance.UpdatePrePaymentItemStatus(customerRebatesRecord.OrderSysNo,(int)DistributionStatus.预存款明细来源.返利,(int)DistributionStatus.预存款明细状态.完结); //DataAccess.Distribution.IDsPrePaymentDao.Instance.AddAvailableAmount(customerRebatesRecord.DealerSysNo,customerRebatesRecord.Rebates,0); } else if (item.ReturnStatus == (int)RmaStatus.退换货状态.已完成) { //更新返利列表状态,作废的部分 customerRebatesRecord.Status = "2"; //更新返利记录状态 Hyt.DataAccess.SellBusiness.ICrCustomerRebatesRecordDao.Instance.Update(customerRebatesRecord); //减去用户的冻结金额部分 customer.BrokerageFreeze = customer.BrokerageFreeze - item.DeductRebates; Hyt.DataAccess.CRM.ICrCustomerDao.Instance.Update(customer); } } }