protected override GetUnitInfoRD ProcessRequest(DTO.Base.APIRequest <GetUnitInfoRP> pRequest)
{
var rd = new GetUnitInfoRD();
var para = pRequest.Parameters;
var loggingSessionInfo = new SessionManager().CurrentUserLoginInfo;
var UnitBLL = new t_unitBLL(loggingSessionInfo);
#region
var Data = UnitBLL.GetByID(para.UnitID);
if (Data != null)
{
rd.UnitID = Data.unit_id;
rd.UnitName = Data.unit_name;
rd.UnitAddress = Data.unit_address;
rd.UnitPhone = Data.unit_tel;
}
#endregion
return(rd);
}
protected override SetRechargeOrderRD ProcessRequest(APIRequest <SetRechargeOrderRP> pRequest)
{
SetRechargeOrderRP rp = pRequest.Parameters;
SetRechargeOrderRD rd = new SetRechargeOrderRD();
var rechargeOrderBll = new RechargeOrderBLL(CurrentUserInfo);
TUnitExpandBLL serviceUnitExpandBll = new TUnitExpandBLL(CurrentUserInfo);
var vipBll = new VipBLL(CurrentUserInfo);
var vipCardVipMappingBll = new VipCardVipMappingBLL(CurrentUserInfo);
var vipCardBll = new VipCardBLL(CurrentUserInfo);
var sysVipCardTypeBll = new SysVipCardTypeBLL(CurrentUserInfo);
var vipCardUpgradeRuleBll = new VipCardUpgradeRuleBLL(CurrentUserInfo);
//获取会员信息
VipEntity vipInfo;
string userId = "";
//微信
if (pRequest.ChannelId == "2")
{
vipInfo = vipBll.GetByID(pRequest.UserID);
UnitService unitServer = new UnitService(CurrentUserInfo);
rp.UnitId = unitServer.GetUnitByUnitTypeForWX("OnlineShopping", null).Id; //获取在线商城的门店标识
}
//掌柜App
else
{
vipInfo = vipBll.GetByID(rp.VipId);
userId = pRequest.UserID;
}
string OrderDesc = "ReRecharge"; //"升级","充值"
int? VipCardTypeId = null; //会员卡类型
decimal returnAmount = 0; //赠送金额
//会员卡类型条件
List <IWhereCondition> complexConditionOne = new List <IWhereCondition> {
};
//获取会员与会员卡关系表
var vipCardVipMappingEntity = vipCardVipMappingBll.QueryByEntity(new VipCardVipMappingEntity()
{
CustomerID = CurrentUserInfo.ClientID, VIPID = vipInfo.VIPID
}, null).FirstOrDefault();
//该会员有会员卡
if (vipCardVipMappingEntity != null)
{
//获取该会员会员卡信息
var vipCardEntity = vipCardBll.QueryByEntity(new VipCardEntity()
{
CustomerID = CurrentUserInfo.ClientID, VipCardID = vipCardVipMappingEntity.VipCardID
}, null).FirstOrDefault();
//获取该会员卡类型
var sysVipCardTypeEntity = sysVipCardTypeBll.GetByID(vipCardEntity.VipCardTypeID);
VipCardTypeId = vipCardEntity.VipCardTypeID;
//获取会员卡的会员活动
var rechargeStrategyBLL = new RechargeStrategyBLL(CurrentUserInfo);
var RechargeActivityDS = rechargeStrategyBLL.GetRechargeActivityList(CurrentUserInfo.ClientID, VipCardTypeId.ToString(), 3);
var RechargeStrategy = new RechargeStrategyInfo();
if (RechargeActivityDS != null && RechargeActivityDS.Tables[0].Rows.Count > 0)
{
var RechargeStrategyList = DataTableToObject.ConvertToList <RechargeStrategyInfo>(RechargeActivityDS.Tables[0]);
//获取与充值金额最接近的活动
RechargeStrategy = RechargeStrategyList.Where(n => n.RechargeAmount <= rp.ActuallyPaid).OrderByDescending(n => n.RechargeAmount).FirstOrDefault();
if (RechargeStrategy != null)
{
//梯度
if (RechargeStrategy.RuleType == "Step")
{
//赠送金额 = 会员活动梯度设置赠送金额
returnAmount = RechargeStrategy.GiftAmount;
}
//叠加
if (RechargeStrategy.RuleType == "Superposition")
{
//赠送金额与满赠条件金额比例
decimal discount = RechargeStrategy.GiftAmount / RechargeStrategy.RechargeAmount;
//赠送金额 = 充值金额 * （设置赠送金额 / 设置满赠条件金额）
returnAmount = rp.ActuallyPaid * RechargeStrategy.GiftAmount / RechargeStrategy.RechargeAmount;
}
}
}
//获取等级高的会员卡类型条件
complexConditionOne.Add(new MoreThanCondition()
{
FieldName = "VipCardLevel", Value = sysVipCardTypeEntity.VipCardLevel, IncludeEquals = false
});
complexConditionOne.Add(new EqualsCondition()
{
FieldName = "CustomerID", Value = CurrentUserInfo.ClientID
});
}
//该会员没有会员卡
else
{
//获取所有的会员卡类型条件
complexConditionOne.Add(new EqualsCondition()
{
FieldName = "CustomerID", Value = CurrentUserInfo.ClientID
});
}
var sysVipCardTypeList = sysVipCardTypeBll.Query(complexConditionOne.ToArray(), null).ToList();
if (sysVipCardTypeList == null)
{
throw new APIException("没有建立会员体系")
{
ErrorCode = 200
};
}
//获取会员卡类型升级规则
List <IWhereCondition> complexConditionTwo = new List <IWhereCondition> {
};
complexConditionTwo.Add(new EqualsCondition()
{
FieldName = "CustomerID", Value = CurrentUserInfo.ClientID
});
complexConditionTwo.Add(new EqualsCondition()
{
FieldName = "IsRecharge", Value = 1
});
var vipCardUpgradeRuleList = vipCardUpgradeRuleBll.Query(complexConditionTwo.ToArray(), null);
//将升级卡规则和可升级的会员卡匹配
var vipCardTypeDetailList = vipCardUpgradeRuleList.Join(sysVipCardTypeList, n => n.VipCardTypeID, m => m.VipCardTypeID, (n, m) => new { n, m }).OrderByDescending(t => t.m.VipCardLevel).ToList();
//判断是否满充值条件
bool isUpgrade = false;
for (int i = 0; i < vipCardTypeDetailList.Count; i++)
{
//实付金额 >= 可升级金额
if (vipCardTypeDetailList[i].n.OnceRechargeAmount <= rp.ActuallyPaid)
{
isUpgrade = true;
VipCardTypeId = vipCardTypeDetailList[i].n.VipCardTypeID ?? 0;
break;
}
}
if (isUpgrade)
{
OrderDesc = "Upgrade"; //升级
}
//充值订单
var rechargeOrderEntity = new RechargeOrderEntity()
{
OrderID = Guid.NewGuid(),
OrderNo = serviceUnitExpandBll.GetUnitOrderNo(),
OrderDesc = OrderDesc,
VipID = vipInfo.VIPID,
VipCardNo = vipInfo.VipCode,
UnitId = rp.UnitId,
UserId = userId,
TotalAmount = rp.ActuallyPaid,
ActuallyPaid = rp.ActuallyPaid,
PosSourceName = rp.PosSourceName,
ReturnAmount = returnAmount,
PayerID = vipInfo.VIPID,
Status = 0,
CustomerID = CurrentUserInfo.ClientID,
VipCardTypeId = VipCardTypeId
};
rechargeOrderBll.Create(rechargeOrderEntity);
rd.orderId = rechargeOrderEntity.OrderID.ToString();
//支付完成
if (rp.PayStatus == 1)
{
//获取门店信息
t_unitBLL unitBLL = new t_unitBLL(CurrentUserInfo);
t_unitEntity unitInfo = null;
if (!string.IsNullOrEmpty(rechargeOrderEntity.UnitId))
{
unitInfo = unitBLL.GetByID(rechargeOrderEntity.UnitId);
}
//充值
rechargeOrderBll.Recharge(rechargeOrderEntity, vipInfo, unitInfo, "");
}
return(rd);
}
protected override EmptyResponseData ProcessRequest(APIRequest <SetVipAmountRP> pRequest)
{
var rd = new EmptyResponseData();
var para = pRequest.Parameters;
var loggingSessionInfo = new SessionManager().CurrentUserLoginInfo; //登录状态信息
var vipAmountBLL = new VipAmountBLL(loggingSessionInfo);
var vipAmountDetailBLL = new VipAmountDetailBLL(loggingSessionInfo);
var objectImagesBLL = new ObjectImagesBLL(loggingSessionInfo); //图片表业务对象实例化
var unitBLL = new t_unitBLL(loggingSessionInfo);
var vipBLL = new VipBLL(loggingSessionInfo);
var vipInfo = vipBLL.GetByID(para.VipID);
var unitInfo = unitBLL.GetByID(loggingSessionInfo.CurrentUserRole.UnitId);
var pTran = vipAmountBLL.GetTran(); //事务
var vipAmountEntity = vipAmountBLL.QueryByEntity(new VipAmountEntity()
{
VipId = vipInfo.VIPID, VipCardCode = vipInfo.VipCode
}, null).FirstOrDefault();
using (pTran.Connection)
{
try
{
var amountDetail = new VipAmountDetailEntity()
{
Amount = para.Amount,
AmountSourceId = para.AmountSourceID,
ObjectId = "",
Reason = para.Reason,
Remark = para.Remark
};
string vipAmountDetailId = string.Empty;
if (para.AmountSourceID == "23")
{ //人工调整余额
vipAmountDetailId = vipAmountBLL.AddVipAmount(vipInfo, unitInfo, ref vipAmountEntity, amountDetail, pTran, loggingSessionInfo);
if (!string.IsNullOrWhiteSpace(vipAmountDetailId))
{//发送微信账户余额变动模板消息
var CommonBLL = new CommonBLL();
CommonBLL.BalanceChangedMessage("人工调整", vipAmountEntity, amountDetail, vipInfo.WeiXinUserId, vipInfo.VIPID, loggingSessionInfo);
}
}
else if (para.AmountSourceID == "24")
{ //人工调整返现
vipAmountDetailId = vipAmountBLL.AddReturnAmount(vipInfo, unitInfo, vipAmountEntity, ref amountDetail, pTran, loggingSessionInfo);
if (!string.IsNullOrWhiteSpace(vipAmountDetailId))
{//发送返现到账通知微信模板消息
var CommonBLL = new CommonBLL();
CommonBLL.CashBackMessage("人工调整", amountDetail.Amount, vipInfo.WeiXinUserId, vipInfo.VIPID, loggingSessionInfo);
}
}
//增加图片上传
if (!string.IsNullOrEmpty(para.ImageUrl))
{
var objectImagesEntity = new ObjectImagesEntity()
{
ImageId = Guid.NewGuid().ToString(),
ObjectId = vipAmountDetailId,
ImageURL = para.ImageUrl
};
objectImagesBLL.Create(objectImagesEntity);
}
pTran.Commit(); //提交事物
}
catch (APIException apiEx)
{
pTran.Rollback();//回滚事物
throw new APIException(apiEx.ErrorCode, apiEx.Message);
}
catch (Exception ex)
{
pTran.Rollback();//回滚事物
throw new Exception(ex.Message);
}
}
return(rd);
}
protected override GetVIPCardRD ProcessRequest(DTO.Base.APIRequest <GetVIPCardRP> pRequest)
{
GetVIPCardRD Data = new GetVIPCardRD();
var rd = new GetVIPCardListRD();
var para = pRequest.Parameters;
var loggingSessionInfo = new SessionManager().CurrentUserLoginInfo;
#region 业务对象
//会员卡
var VipCardBLL = new VipCardBLL(loggingSessionInfo);
//会员
var VipBLL = new VipBLL(loggingSessionInfo);
//卡状态变更记录
var VipCardStatusChangeLogBLL = new VipCardStatusChangeLogBLL(loggingSessionInfo);
//卡与Vip关系
var VipCardVipMappingBLL = new VipCardVipMappingBLL(loggingSessionInfo);
//门店
var unitBll = new t_unitBLL(loggingSessionInfo);
//员工
var UserBLL = new T_UserBLL(loggingSessionInfo);
//卡类型
var SysVipCardTypeBLL = new SysVipCardTypeBLL(loggingSessionInfo);
//商户配置
var CustomerBasicSettingBLL = new CustomerBasicSettingBLL(loggingSessionInfo);
//积分
var VipIntegralBLL = new VipIntegralBLL(loggingSessionInfo);
#endregion
#region 会员卡
VipCardEntity resultData = null;
if (!string.IsNullOrWhiteSpace(para.VipID))
{
//会员编号获取详情
VipCardVipMappingEntity m_VipMappingData = VipCardVipMappingBLL.QueryByEntity(new VipCardVipMappingEntity()
{
VIPID = para.VipID
}, null).FirstOrDefault();
if (m_VipMappingData != null && !string.IsNullOrWhiteSpace(m_VipMappingData.VipCardID))
{
resultData = VipCardBLL.GetByID(para.VipCardID);
}
}
else
{
if (!string.IsNullOrWhiteSpace(para.VipCardID))
{
//卡ID获取详情
resultData = VipCardBLL.GetByID(para.VipCardID);
}
else
{
//刷卡获取详情
List <IWhereCondition> complexCondition = new List <IWhereCondition> {
};
if (!string.IsNullOrEmpty(para.VipCardISN))
{
complexCondition.Add(new DirectCondition("VipCardCode='" + para.VipCardISN + "' or VipCardISN='" + para.VipCardISN.ToString() + "' "));
}
resultData = VipCardBLL.Query(complexCondition.ToArray(), null).FirstOrDefault();
}
}
//try
//{
// if (resultData == null)
// throw new APIException("该卡不存在！") { ErrorCode = ERROR_CODES.INVALID_BUSINESS };
//}
//catch (APIException apiEx)
//{
// throw new APIException(apiEx.ErrorCode, apiEx.Message);
//}
#endregion
#region 卡关系
VipCardVipMappingEntity VipCardVipMappingData = null;
if (resultData != null)
{
VipCardVipMappingData = VipCardVipMappingBLL.QueryByEntity(new VipCardVipMappingEntity()
{
VipCardID = resultData.VipCardID
}, null).FirstOrDefault();
}
//else
//{
// return Data;
//}
#endregion
#region 门店
t_unitEntity unidData = null;
if (resultData != null && !string.IsNullOrWhiteSpace(resultData.MembershipUnit))
{
unidData = unitBll.GetByID(resultData.MembershipUnit);
}
#endregion
#region 会员,积分
VipEntity VipData = null;
VipIntegralEntity IntegralData = null;
//string VIPID = VipCardVipMappingData == null ? "" : VipCardVipMappingData.VIPID;
string VIPID = para.VipID;
if (!string.IsNullOrWhiteSpace(VIPID))
{
VipData = VipBLL.NewGetByID(VIPID);
//IntegralData = VipIntegralBLL.GetByID(VIPID);
IntegralData = VipIntegralBLL.QueryByEntity(new VipIntegralEntity()
{
VipID = VipData.VIPID, VipCardCode = VipData.VipCode
}, null).FirstOrDefault();
}
#endregion
#region 员工
T_UserEntity UserData = null;
if (resultData != null && !string.IsNullOrWhiteSpace(resultData.CreateBy))
{
UserData = UserBLL.GetByID(resultData.CreateBy);
}
#endregion
#region 响应对象赋值
if (resultData != null)
{
//卡
Data.VipCardID = resultData.VipCardID;
Data.VipCardCode = resultData.VipCardCode;
Data.VipCardISN = resultData.VipCardISN;
Data.CraeteUserName = UserData == null ? "" : UserData.user_name;
Data.VipCardStatusId = resultData.VipCardStatusId.Value;
Data.MembershipTime = resultData.MembershipTime == null ? "" : resultData.MembershipTime.Value.ToString("yyyy-MM-dd");
Data.MembershipUnitName = unidData == null ? "" : unidData.unit_name;
//Data.TotalAmount = resultData.RechargeTotalAmount == null ? 0 : resultData.RechargeTotalAmount.Value;
//Data.BalanceAmount = resultData.BalanceAmount == null ? 0 : resultData.BalanceAmount.Value;
Data.BeginDate = resultData.BeginDate;
Data.EndDate = "永久有效";
Data.SalesUserName = resultData.SalesUserName == null ? "" : resultData.SalesUserName;
#region 卡类型名称
SysVipCardTypeEntity SysVipCardTypeData = SysVipCardTypeBLL.GetByID(resultData.VipCardTypeID);
Data.VipCardName = SysVipCardTypeData == null ? "" : SysVipCardTypeData.VipCardTypeName;
#endregion
#region 状态变更记录列表
var VipCardStatusChangeLogArray = VipCardStatusChangeLogBLL.Query
(new IWhereCondition[] { new EqualsCondition()
{
FieldName = "VipCardID", Value = resultData.VipCardID
} },
new OrderBy[] { new OrderBy()
{
FieldName = "CreateTime", Direction = OrderByDirections.Desc
} }).ToList();
//转换业务对象
Data.StatusLogList = (from t in VipCardStatusChangeLogArray
select new VipCardStatusChangeLog()
{
CreateTime = t.CreateTime.Value.ToString("yyyy-MM-dd"),
UnitName = t.UnitName == null ? "" : t.UnitName,
Action = t.Action == null ? "" : t.Action,
ChangeReason = t.Reason == null ? "" : t.Reason,
Remark = t.Remark == null ? "" : t.Remark,
CreateBy = t.CreateByName,
ImageUrl = t.PicUrl == null ? "" : t.PicUrl
}).ToList();
#endregion
}
#region 会员
if (VipData != null)
{
Data.VipID = VipData.VIPID;
Data.VipCode = VipData.VipCode;
if (Data.VipCardCode == null)
{
Data.VipCardCode = VipData.VipCode;
}
if (!string.IsNullOrWhiteSpace(VipData.VipRealName))
{
Data.VipName = VipData.VipRealName;
}
else
{
Data.VipName = VipData.VipName ?? "";
}
Data.Phone = VipData.Phone;
Data.Birthday = VipData.Birthday == null ? "" : VipData.Birthday;
Data.Gender = VipData.Gender ?? 0;
//Data.Integration = VipData.Integration == null ? 0 : VipData.Integration.Value;
//会员创建人姓名
T_UserEntity VipUserData = null;
if (resultData != null && !string.IsNullOrWhiteSpace(resultData.CreateBy))
{
VipUserData = UserBLL.GetByID(resultData.CreateBy);
}
Data.VipCreateByName = VipUserData == null ? "" : VipUserData.user_name;
Data.IDNumber = VipData.IDNumber == null ? "" : VipData.IDNumber;
#region 会员生日是否可修改字段赋值
//Col22 字段赋值
////CustomerBasicSettingEntity SettingData = CustomerBasicSettingBLL.QueryByEntity(new CustomerBasicSettingEntity() { SettingCode = "FSR_NotTwoUpdateVipBirthday" }, null).FirstOrDefault();
////if (SettingData != null)
Data.Col22 = VipData.Col22 == null ? "Y" : VipData.Col22;
#endregion
}
#endregion
#region 积分
if (IntegralData != null)
{
Data.Integration = IntegralData.ValidIntegral != null ? IntegralData.ValidIntegral.Value : 0;
Data.CumulativeIntegral = IntegralData.CumulativeIntegral != null ? IntegralData.CumulativeIntegral.Value : 0;
}
#endregion
#region 余额和返现
var vipAmountBLL = new VipAmountBLL(loggingSessionInfo);
var vipAmountInfo = vipAmountBLL.QueryByEntity(new VipAmountEntity()
{
VipId = VipData.VIPID, VipCardCode = VipData.VipCode
}, null).FirstOrDefault();
if (vipAmountInfo != null)
{
Data.TotalAmount = vipAmountInfo.TotalAmount == null ? 0 : vipAmountInfo.TotalAmount.Value;
Data.BalanceAmount = vipAmountInfo.EndAmount == null ? 0 : vipAmountInfo.EndAmount.Value;
Data.ValidReturnAmount = vipAmountInfo.ValidReturnAmount == null ? 0 : vipAmountInfo.ValidReturnAmount.Value;
Data.TotalReturnAmount = vipAmountInfo.TotalReturnAmount == null ? 0 : vipAmountInfo.TotalReturnAmount.Value;
}
#endregion
#endregion
return(Data);
}
protected override SetReceiveAmountOrderRD ProcessRequest(APIRequest <SetReceiveAmountOrderRP> pRequest)
{
SetReceiveAmountOrderRP rp = pRequest.Parameters;
SetReceiveAmountOrderRD rd = new SetReceiveAmountOrderRD();
var receiveAmountOrderBll = new ReceiveAmountOrderBLL(CurrentUserInfo);
var sysVipCardGradeBLL = new SysVipCardGradeBLL(CurrentUserInfo); //获取折扣表
var vipBLL = new VipBLL(CurrentUserInfo);
var unitBLL = new t_unitBLL(CurrentUserInfo);
var vipInfo = vipBLL.GetByID(pRequest.UserID); //获取会员信息
if (vipInfo == null)
{
throw new APIException("没有会员信息")
{
ErrorCode = 101
};
}
var unitInfo = unitBLL.GetByID(rp.UnitId);
if (unitInfo == null)
{
throw new APIException("没有服务门店信息")
{
ErrorCode = 101
};
}
decimal discountAmount = 0; //抵扣金额汇总
decimal couponAmount = 0; //优惠券抵用金额
decimal endAmount = rp.VipEndAmount; //余额
decimal integralAmount = rp.Integral;
//获取订单号
TUnitExpandBLL serviceUnitExpand = new TUnitExpandBLL(CurrentUserInfo);
string orderNo = serviceUnitExpand.GetUnitOrderNo();
//折扣
decimal discount = 1;
if (rp.VipDiscount > 0)
{
discount = sysVipCardGradeBLL.GetVipDiscount() / 10;//会员折扣
}
decimal tempAmount = Math.Round((discount == 0 ? 1 : discount) * rp.TotalAmount, 2, MidpointRounding.AwayFromZero);
Guid orderId = Guid.NewGuid();
//积分处理
if (rp.IntegralFlag == 1)
{
//加入折扣金额
discountAmount = discountAmount + rp.IntegralAmount;
}
else
{
integralAmount = 0;
}
//使用优惠券
if (rp.CouponFlag == 1)
{
#region 判断优惠券是否是该会员的
var vipcouponMappingBll = new VipCouponMappingBLL(CurrentUserInfo);
var vipcouponmappingList = vipcouponMappingBll.QueryByEntity(new VipCouponMappingEntity()
{
VIPID = vipInfo.VIPID,
CouponID = rp.CouponId
}, null);
if (vipcouponmappingList == null || vipcouponmappingList.Length == 0)
{
throw new APIException("此张优惠券不是该会员的")
{
ErrorCode = 103
};
}
#endregion
#region 判断优惠券是否有效
var couponBll = new CouponBLL(CurrentUserInfo);
var couponEntity = couponBll.GetByID(rp.CouponId);
if (couponEntity == null)
{
throw new APIException("无效的优惠券")
{
ErrorCode = 103
};
}
if (couponEntity.Status == 1)
{
throw new APIException("优惠券已使用")
{
ErrorCode = 103
};
}
if (couponEntity.EndDate < DateTime.Now)
{
throw new APIException("优惠券已过期")
{
ErrorCode = 103
};
}
var couponTypeBll = new CouponTypeBLL(CurrentUserInfo);
var couponTypeEntity = couponTypeBll.GetByID(couponEntity.CouponTypeID);
if (couponTypeEntity == null)
{
throw new APIException("无效的优惠券类型")
{
ErrorCode = 103
};
}
#endregion
discountAmount = discountAmount + couponTypeEntity.ParValue ?? 0;
couponAmount = couponTypeEntity.ParValue ?? 0;
//更新使用记录
var couponUseBll = new CouponUseBLL(CurrentUserInfo);
var couponUseEntity = new CouponUseEntity()
{
CouponUseID = Guid.NewGuid(),
CouponID = rp.CouponId,
VipID = vipInfo.VIPID,
UnitID = rp.UnitId,
OrderID = orderId.ToString(),
Comment = "商城使用电子券",
CustomerID = CurrentUserInfo.ClientID,
CreateBy = CurrentUserInfo.UserID,
CreateTime = DateTime.Now,
LastUpdateBy = CurrentUserInfo.UserID,
LastUpdateTime = DateTime.Now,
IsDelete = 0
};
couponUseBll.Create(couponUseEntity);
//更新CouponType数量
var conponTypeBll = new CouponTypeBLL(CurrentUserInfo);
var conponTypeEntity = conponTypeBll.QueryByEntity(new CouponTypeEntity()
{
CouponTypeID = new Guid(couponEntity.CouponTypeID), CustomerId = CurrentUserInfo.ClientID
}, null).FirstOrDefault();
conponTypeEntity.IsVoucher += 1;
conponTypeBll.Update(conponTypeEntity);
//停用该优惠券
couponEntity.Status = 1;
couponBll.Update(couponEntity);
}
//使用余额
if (rp.VipEndAmountFlag == 1)
{
var vipAmountBll = new VipAmountBLL(CurrentUserInfo);
var vipAmountDetailBll = new VipAmountDetailBLL(CurrentUserInfo);
var vipAmountEntity = vipAmountBll.QueryByEntity(new VipAmountEntity()
{
VipId = vipInfo.VIPID, VipCardCode = vipInfo.VipCode
}, null).FirstOrDefault();
if (vipAmountEntity != null)
{
//判断该会员账户是否被冻结
if (vipAmountEntity.IsLocking == 1)
{
throw new APIException("账户已被冻结，请先解冻")
{
ErrorCode = 103
}
}
;
//判断该会员的账户余额是否大于本次使用的余额
if (vipAmountEntity.EndAmount < rp.VipEndAmount)
{
throw new APIException(string.Format("账户余额不足，当前余额为【{0}】", vipAmountEntity.EndAmount))
{
ErrorCode = 103
}
}
;
//所剩余额大于商品价格，扣除余额的数量为商品价格
if (tempAmount < rp.VipEndAmount)
{
rp.VipEndAmount = endAmount = Convert.ToDecimal(tempAmount);
}
}
}
//不使用余额，余额为0
else
{
endAmount = 0;
}
//实付金额
decimal transAmount = tempAmount - discountAmount;
//支付状态
string payStatus = "0";
//支付时间
DateTime?PayDatetTime = null;
//实付金额全是由余额支付，支付状态和支付时间全部更新，积分扣减、余额扣减、优惠券使用
if (transAmount == endAmount || transAmount == 0)
{
payStatus = "10";
PayDatetTime = DateTime.Now;
//处理积分抵扣
if (rp.IntegralFlag == 1)
{
var vipIntegralBll = new VipIntegralBLL(CurrentUserInfo);
string sourceId = "20"; //积分抵扣
var IntegralDetail = new VipIntegralDetailEntity()
{
Integral = -Convert.ToInt32(rp.Integral),
IntegralSourceID = sourceId,
ObjectId = orderId.ToString()
};
if (IntegralDetail.Integral != 0)
{
//变动前积分
string OldIntegral = (vipInfo.Integration ?? 0).ToString();
//变动积分
string ChangeIntegral = (IntegralDetail.Integral ?? 0).ToString();
var vipIntegralDetailId = vipIntegralBll.AddIntegral(ref vipInfo, unitInfo, IntegralDetail, CurrentUserInfo);
//发送微信积分变动通知模板消息
if (!string.IsNullOrWhiteSpace(vipIntegralDetailId))
{
var CommonBLL = new CommonBLL();
CommonBLL.PointsChangeMessage(OldIntegral, vipInfo, ChangeIntegral, vipInfo.WeiXinUserId, CurrentUserInfo);
}
}
}
//处理余额抵扣
if (rp.VipEndAmountFlag == 1)
{
var vipAmountBll = new VipAmountBLL(CurrentUserInfo);
var vipAmountDetailBll = new VipAmountDetailBLL(CurrentUserInfo);
var vipAmountEntity = vipAmountBll.QueryByEntity(new VipAmountEntity()
{
VipId = vipInfo.VIPID, VipCardCode = vipInfo.VipCode
}, null).FirstOrDefault();
if (vipAmountEntity != null)
{
var detailInfo = new VipAmountDetailEntity()
{
Amount = -rp.VipEndAmount,
AmountSourceId = "1",
ObjectId = orderId.ToString()
};
var vipAmountDetailId = vipAmountBll.AddVipAmount(vipInfo, unitInfo, ref vipAmountEntity, detailInfo, CurrentUserInfo);
if (!string.IsNullOrWhiteSpace(vipAmountDetailId))
{//发送微信账户余额变动模板消息
var CommonBLL = new CommonBLL();
CommonBLL.BalanceChangedMessage(orderNo, vipAmountEntity, detailInfo, vipInfo.WeiXinUserId, vipInfo.VIPID, CurrentUserInfo);
}
}
}
}
//收款订单
ReceiveAmountOrderEntity receiveAmountOrderEntity = new ReceiveAmountOrderEntity()
{
OrderId = orderId,
OrderNo = orderNo,
VipId = vipInfo.VIPID,
ServiceUnitId = unitInfo.unit_id,
ServiceUserId = rp.EmployeeID,
TotalAmount = rp.TotalAmount,
VipDiscount = discount * 100,
TransAmount = transAmount,
PayPoints = integralAmount,
AmountFromPayPoints = rp.IntegralAmount,
CouponUsePay = couponAmount,
AmountAcctPay = endAmount,
PayStatus = payStatus,
TimeStamp = rp.TimeStamp,
PayDatetTime = PayDatetTime,
CustomerId = CurrentUserInfo.ClientID
};
receiveAmountOrderBll.Create(receiveAmountOrderEntity);
//订单奖励
if (transAmount == endAmount || transAmount == 0)
{
var vipIntegralBll = new VipIntegralBLL(CurrentUserInfo);
vipIntegralBll.OrderReward(receiveAmountOrderEntity, null);
}
rd.orderId = orderId.ToString();
return(rd);
}
}
}
protected override EmptyResponseData ProcessRequest(APIRequest <SetVipIntegralRP> pRequest)
{
var rd = new EmptyResponseData();
var para = pRequest.Parameters;
var loggingSessionInfo = new SessionManager().CurrentUserLoginInfo; //登录状态信息
var vipIntegralDetail = new VipIntegralDetailBLL(loggingSessionInfo); //积分变更业务对象实例化
var objectImagesBLL = new ObjectImagesBLL(loggingSessionInfo); //图片表业务对象实例化
var unitBLL = new t_unitBLL(loggingSessionInfo);
var vipIntegralBLL = new VipIntegralBLL(loggingSessionInfo);
var vipBLL = new VipBLL(loggingSessionInfo);
var vipInfo = vipBLL.GetByID(para.VipID);
var unitInfo = unitBLL.GetByID(loggingSessionInfo.CurrentUserRole.UnitId);
var pTran = vipIntegralDetail.GetTran(); //事务
var vipIntegral = vipIntegralBLL.GetByID(para.VipID);
using (pTran.Connection)
{
try
{
var IntegralDetail = new VipIntegralDetailEntity()
{
Integral = para.Qty,
IntegralSourceID = para.IntegralSourceID,
ObjectId = "",
Reason = para.Reason,
Remark = para.Remark
};
if (IntegralDetail.Integral != 0)
{
//变动前积分
string OldIntegral = string.Empty;
if (vipIntegral != null)
{
OldIntegral = (vipIntegral.ValidIntegral ?? 0).ToString();
}
else
{
OldIntegral = "0";
}
//变动积分
string ChangeIntegral = (IntegralDetail.Integral ?? 0).ToString();
string vipIntegralDetailId = vipIntegralBLL.AddIntegral(ref vipInfo, unitInfo, IntegralDetail, pTran, loggingSessionInfo);
//发送微信积分变动通知模板消息
if (!string.IsNullOrWhiteSpace(vipIntegralDetailId))
{
var CommonBLL = new CommonBLL();
CommonBLL.PointsChangeMessage(OldIntegral, vipInfo, ChangeIntegral, vipInfo.WeiXinUserId, loggingSessionInfo);
}
//增加图片上传
if (!string.IsNullOrEmpty(para.ImageUrl))
{
var objectImagesEntity = new ObjectImagesEntity()
{
ImageId = Guid.NewGuid().ToString(),
ObjectId = vipIntegralDetailId,
ImageURL = para.ImageUrl
};
objectImagesBLL.Create(objectImagesEntity);
}
}
pTran.Commit(); //提交事物
}
catch (APIException apiEx)
{
pTran.Rollback();//回滚事物
throw new APIException(apiEx.ErrorCode, apiEx.Message);
}
catch (Exception ex)
{
pTran.Rollback();//回滚事物
throw new Exception(ex.Message);
}
}
return(rd);
}
/// <summary>
/// 查询角色列表
/// </summary>
public string QueryRoleListData()
{
var responseData = new ResponseData();
LoggingSessionInfo loggingSessionInfo = null;
if (CurrentUserInfo != null)
{
loggingSessionInfo = CurrentUserInfo;
}
else
{
if (string.IsNullOrEmpty(Request("CustomerID")))
{
responseData.success = false;
responseData.msg = "缺少商户标识";
return(responseData.ToString());
}
else if (string.IsNullOrEmpty(Request("CustomerUserID")))
{
responseData.success = false;
responseData.msg = "缺少登陆员工的标识";
return(responseData.ToString());
}
else if (string.IsNullOrEmpty(Request("CustomerUserID")))
{
responseData.success = false;
responseData.msg = "缺少登陆员工的标识";
return(responseData.ToString());
}
else
{
loggingSessionInfo = Default.GetBSLoggingSession(Request("CustomerID"), Request("CustomerUserID"));
}
}
var form = Request("form").DeserializeJSONTo <RoleQueryEntity>();
var appSysService = new AppSysService(loggingSessionInfo);//使用兼容模式
RoleModel list = new RoleModel();
string content = string.Empty;
string key = string.Empty;
if (form.app_sys_id != null && form.app_sys_id != string.Empty)
{
key = form.app_sys_id.Trim();
}
int maxRowCount = PageSize; //每页数量
int limit = Utils.GetIntVal(Request("limit")); //传过来的参数
if (limit != 0)
{
maxRowCount = PageSize = limit;
}
int page = Utils.GetIntVal(Request("page"));//第几页面
if (page == 0)
{
page = 1;
}
int startRowIndex = (page - 1) * PageSize + 1;//因为row_number()从1开始
list = appSysService.GetRolesByAppSysId(key, maxRowCount, startRowIndex
, form.type_id ?? "", form.role_name ?? "", loggingSessionInfo.UserID);
//在为用户配置门店角色关系时
//多加一个参数，在这里选择门店，必须重新加载角色列表，因为创建用户角色门店关系时，角色必须和门店同一个type_level上
if (!string.IsNullOrEmpty(form.unit_id))
{
t_unitBLL t_unitBll = new t_unitBLL(CurrentUserInfo);
t_unitEntity t_unitEn = t_unitBll.GetByID(form.unit_id);
if (t_unitEn != null)
{
T_TypeBLL T_TypeBLL = new T_TypeBLL(CurrentUserInfo);
T_TypeEntity t_typeEn = T_TypeBLL.GetByID(t_unitEn.type_id);
list.RoleInfoList = list.RoleInfoList.Where(p => p.org_level == t_typeEn.type_Level).ToList();
}
}
var jsonData = new JsonData();
jsonData.totalCount = list.RoleInfoList.Count.ToString();
jsonData.data = list.RoleInfoList;
content = string.Format("{{\"totalCount\":{1},\"TotalPage\":{2},\"topics\":{0}}}",
list.RoleInfoList.ToJSON(),
list.ICount,
list.TotalPage);
return(content);
}
protected override EmptyResponseData ProcessRequest(DTO.Base.APIRequest <GetRefundOrderDetailRP> pRequest)
{
var rd = new EmptyResponseData();
var para = pRequest.Parameters;
var loggingSessionInfo = new SessionManager().CurrentUserLoginInfo;
var salesReturnBLL = new T_SalesReturnBLL(loggingSessionInfo);
var historyBLL = new T_SalesReturnHistoryBLL(loggingSessionInfo);
var refundOrderBLL = new T_RefundOrderBLL(loggingSessionInfo);
var vipAmountBLL = new VipAmountBLL(loggingSessionInfo); //余额返现BLL实例化
var vipAmountDetailBLL = new VipAmountDetailBLL(loggingSessionInfo); //余额返现BLL实例化
var pTran = salesReturnBLL.GetTran();//事务
T_SalesReturnEntity salesReturnEntity = null;
T_SalesReturnHistoryEntity historyEntity = null;
T_RefundOrderEntity refundEntity = null;
var vipBll = new VipBLL(loggingSessionInfo); //会员BLL实例化
var userBll = new T_UserBLL(loggingSessionInfo); //店员BLL实例化
T_UserEntity userEntity = null; //店员信息
var unitBLL = new t_unitBLL(loggingSessionInfo);
refundEntity = refundOrderBLL.GetByID(para.RefundID);
userEntity = userBll.GetByID(loggingSessionInfo.UserID);
using (pTran.Connection)
{
try
{
if (refundEntity != null)
{
//获取会员信息
var vipInfo = vipBll.GetByID(refundEntity.VipID);
//获取会员的会员上线
VipEntity userInfo = vipBll.GetByID(vipInfo.HigherVipID);
if (userInfo == null)
{
//获取会员的员工上线
var tempUser = userBll.GetByID(vipInfo.SetoffUserId);
if (tempUser != null)
{
userInfo = new VipEntity();
userInfo.VIPID = tempUser.user_id;
}
}
//获取门店信息
t_unitEntity unitInfo = null;
if (!string.IsNullOrEmpty(refundEntity.UnitID))
{
unitInfo = unitBLL.GetByID(refundEntity.UnitID);
}
userEntity = userBll.GetByID(loggingSessionInfo.UserID);
refundEntity.Status = 2;//已退款
refundOrderBLL.Update(refundEntity, pTran);
salesReturnEntity = salesReturnBLL.GetByID(refundEntity.SalesReturnID);
if (salesReturnEntity != null)
{
salesReturnEntity.Status = 7;//已完成
salesReturnBLL.Update(salesReturnEntity, pTran);
historyEntity = new T_SalesReturnHistoryEntity()
{
SalesReturnID = salesReturnEntity.SalesReturnID,
OperationType = 7,
OperationDesc = "退款",
OperatorID = loggingSessionInfo.UserID,
HisRemark = "您的服务单财务已退款，请注意查收",
OperatorName = userEntity.user_name,
OperatorType = 1
};
historyBLL.Create(historyEntity, pTran);
}
#region 退回集客订单分润
//上线员工和线上会员不为空
if (userInfo != null)
{
var vipAmountEntity = vipAmountBLL.QueryByEntity(new VipAmountEntity()
{
VipId = userInfo.VIPID, VipCardCode = userInfo.VipCode
}, null).FirstOrDefault();
var vipAmountDetail = vipAmountDetailBLL.QueryByEntity(new VipAmountDetailEntity()
{
ObjectId = refundEntity.OrderID, AmountSourceId = "20"
}, null).FirstOrDefault();
if (vipAmountDetail != null)
{
var detailInfo = new VipAmountDetailEntity()
{
Amount = -vipAmountDetail.Amount.Value,
ObjectId = refundEntity.RefundID.ToString(),
AmountSourceId = "25"
};
var vipAmountDetailId = vipAmountBLL.AddVipAmount(userInfo, unitInfo, ref vipAmountEntity, detailInfo, pTran, loggingSessionInfo);
}
}
#endregion
}
pTran.Commit(); //提交事物
}
catch (Exception ex)
{
pTran.Rollback();//回滚事务
throw new APIException(ex.Message);
}
}
return(rd);
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
var OrderID = context.Request["OrderID"];
var OrderStatus = context.Request["OrderStatus"];
var CustomerID = context.Request["CustomerID"];
var UserID = context.Request["UserID"];
var ChannelID = context.Request["ChannelID"];
var SerialPay = context.Request["SerialPay"];
try
{
if (string.IsNullOrEmpty(OrderID) || string.IsNullOrEmpty(OrderStatus) || string.IsNullOrEmpty(CustomerID) || string.IsNullOrEmpty(UserID) || string.IsNullOrEmpty(ChannelID))
{
throw new Exception("参数不全:OrderID,OrderStatus,CustomerID,UserID");
}
else
{
if (OrderStatus == "2")
{
//支付成功，更新卡的支付状态
//OrderID就是VIPCardID
//
//var rp = pRequest.DeserializeJSONTo<APIRequest<SetVipCardRP>>();
//if (string.IsNullOrEmpty(rp.Parameters.PayID))
//{
// throw new APIException("缺少参数【PayID】或参数值为空") { ErrorCode = 135 };
//}
var loggingSessionInfo = Default.GetBSLoggingSession(CustomerID, UserID);
//会员
var vipBll = new VipBLL(loggingSessionInfo);
var vipAmountBll = new VipAmountBLL(loggingSessionInfo);
var vipCardVipMappingBll = new VipCardVipMappingBLL(loggingSessionInfo);
//支付
var tPaymentTypeCustomerMappingBll = new TPaymentTypeCustomerMappingBLL(loggingSessionInfo);
var tPaymentTypeBll = new T_Payment_TypeBLL(loggingSessionInfo);
var paymentDetailBll = new T_Payment_detailBLL(loggingSessionInfo);
//门店
var unitBLL = new t_unitBLL(loggingSessionInfo);
//商品订单支付
//更新积分和状态
//var loggingSessionInfo = Default.GetBSLoggingSession(CustomerID, "1");
var inoutBll = new T_InoutBLL(loggingSessionInfo);//订单业务对象实例化
var trrBll = new T_RewardRecordBLL(loggingSessionInfo);
//辨别打赏订单
var rewardOrderPrefix = "REWARD|";
if (OrderID.Contains(rewardOrderPrefix))
{
OrderID = OrderID.Substring(rewardOrderPrefix.Length, OrderID.Length - rewardOrderPrefix.Length);
var trrEntity = trrBll.GetByID(OrderID);
trrEntity.PayStatus = 2;
trrEntity.LastUpdateTime = DateTime.Now;
trrEntity.LastUpdateBy = loggingSessionInfo.UserID;
trrBll.Update(trrEntity);
#region 员工余额变更--需要独立出来处理
var userAmountBll = new VipAmountBLL(loggingSessionInfo); //作为员工余额使用
var employeeId = trrEntity.RewardedOP;
var rewardAmount = trrEntity.RewardAmount == null ? 0 : (decimal)trrEntity.RewardAmount; //转为非null的decimal类型
//门店
var unitService = new UnitService(loggingSessionInfo);
var unitInfo = unitService.GetUnitByUser(CustomerID, employeeId).FirstOrDefault();//获取员工所属门店
var tran = userAmountBll.GetTran();
using (tran.Connection)//事务
{
try
{
var userAmountEntity = userAmountBll.GetByID(trrEntity.RewardedOP);
if (userAmountEntity == null)
{
//创建
userAmountEntity = new VipAmountEntity
{
VipId = employeeId,//员工ID
VipCardCode = string.Empty,
BeginAmount = 0,
InAmount = rewardAmount,
OutAmount = 0,
EndAmount = rewardAmount,
TotalAmount = rewardAmount,
BeginReturnAmount = 0,
InReturnAmount = 0,
OutReturnAmount = 0,
ReturnAmount = 0,
ImminentInvalidRAmount = 0,
InvalidReturnAmount = 0,
ValidReturnAmount = 0,
TotalReturnAmount = 0,
IsLocking = 0,
CustomerID = CustomerID
};
userAmountBll.Create(userAmountEntity, tran);//创建员工余额表
}
else
{
//修改
if (rewardAmount > 0)
{
userAmountEntity.InAmount = (userAmountEntity.InAmount == null ? 0 : userAmountEntity.InAmount.Value) + rewardAmount;
userAmountEntity.TotalAmount = (userAmountEntity.TotalAmount == null ? 0 : userAmountEntity.TotalAmount.Value) + rewardAmount;
}
else
{
userAmountEntity.OutAmount = (userAmountEntity.OutAmount == null ? 0 : userAmountEntity.OutAmount.Value) + Math.Abs(rewardAmount);
}
userAmountEntity.EndAmount = (userAmountEntity.EndAmount == null ? 0 : userAmountEntity.EndAmount.Value) + rewardAmount;
userAmountBll.Update(userAmountEntity, tran);//更新余额
}
var vipamountDetailBll = new VipAmountDetailBLL(loggingSessionInfo);
var vipAmountDetailEntity = new VipAmountDetailEntity
{
VipAmountDetailId = Guid.NewGuid(),
VipCardCode = string.Empty,
VipId = employeeId,//员工ID
UnitID = unitInfo != null ? unitInfo.unit_id : string.Empty,
UnitName = unitInfo != null ? unitInfo.Name : string.Empty,
Amount = rewardAmount,
UsedReturnAmount = 0,
EffectiveDate = DateTime.Now,
DeadlineDate = Convert.ToDateTime("9999-12-31 23:59:59"),
AmountSourceId = "26",
Reason = "Reward",
CustomerID = CustomerID
};
vipamountDetailBll.Create(vipAmountDetailEntity, tran); //创建余额详情
tran.Commit(); //提交事务
}
catch (Exception ex)
{
tran.Rollback();
Loggers.Debug(new DebugLogInfo()
{
Message = "异常-->支付成功回调时更新会员打赏金额出错(PayNotify.ashx)：" + ex
});
}
}
#endregion
if (trrEntity != null)
{
context.Response.Write("SUCCESS");
}
else
{
context.Response.Write("FAIL");
}
return;
}
//获取会员信息
var vipInfo = vipBll.GetByID(loggingSessionInfo.UserID);
//支付信息 Bear
//var tPaymentTypeCustomerMappingEntity = tPaymentTypeCustomerMappingBll.QueryByEntity(new TPaymentTypeCustomerMappingEntity(){ChannelId = ChannelID,CustomerId = loggingSessionInfo.ClientID },null).FirstOrDefault();
var paymentTypeList = tPaymentTypeBll.GetAll();
var tPaymentType =
paymentTypeList.ToList()
.Find(t => t.Payment_Type_Code == "WXJS");
//var tPaymentType = tPaymentTypeBll.GetByID(tPaymentTypeCustomerMappingEntity.PaymentTypeID);
//获取订单信息
var inoutInfo = inoutBll.GetByID(OrderID);
if (inoutInfo != null)
{
var bll = new TInOutStatusNodeBLL(loggingSessionInfo);
string msg;
if (!bll.SetOrderPayment(OrderID, out msg, ChannelID, SerialPay))
//if (!bll.SetOrderPayment(OrderID, out msg, ChannelID))
{
throw new Exception(msg);
}
else if (string.IsNullOrEmpty(inoutInfo.Field17) && string.IsNullOrEmpty(inoutInfo.Field18))
{
#region 发送订单支付成功微信模板消息
var SuccessCommonBLL = new CommonBLL();
//SuccessCommonBLL.SentPaymentMessage(inoutInfo, vipInfo.WeiXinUserId,vipInfo.VIPID, loggingSessionInfo);
new SendOrderPaySuccessMsgBLL().SentPaymentMessage(inoutInfo, vipInfo.WeiXinUserId, vipInfo.VIPID, loggingSessionInfo);
#endregion
Loggers.Debug(new DebugLogInfo()
{
Message = "调用SetOrderPayment方法更新订单成功"
});
}
//获取订单信息,根据Field3==1判断,如果是ALD订单,则调用ALD接口更新ALD订单的状态
#region 更新ALD状态
//var orderbll = new InoutService(loggingSessionInfo);
//var orderInfo = orderbll.GetInoutInfoById(OrderID);
//if (orderInfo.Field3 == "1")
//{
// Loggers.Debug(new DebugLogInfo() { Message = string.Format("更新O2OMarketing订单状态成功[OrderID={0}].", OrderID) });
// //更新阿拉丁的订单状态
// JIT.CPOS.Web.OnlineShopping.data.DataOnlineShoppingHandler.ALDChangeOrderStatus aldChangeOrder = new data.DataOnlineShoppingHandler.ALDChangeOrderStatus();
// if (string.IsNullOrEmpty(orderInfo.vip_no))
// throw new Exception("会员ID不能为空,OrderID:" + OrderID);
// aldChangeOrder.MemberID = new Guid(orderInfo.vip_no);
// aldChangeOrder.SourceOrdersID = OrderID;
// aldChangeOrder.Status = int.Parse(orderInfo.status);
// aldChangeOrder.IsPaid = true;
// JIT.CPOS.Web.OnlineShopping.data.DataOnlineShoppingHandler.ALDChangeOrderStatusRequest aldRequest = new data.DataOnlineShoppingHandler.ALDChangeOrderStatusRequest();
// aldRequest.BusinessZoneID = 1;//写死
// aldRequest.Locale = 1;
// aldRequest.UserID = new Guid(orderInfo.vip_no);
// aldRequest.Parameters = aldChangeOrder;
// var url = ConfigurationManager.AppSettings["ALDGatewayURL"];
// var postContent = string.Format("Action=ChangeOrderStatus&ReqContent={0}", aldRequest.ToJSON());
// Loggers.Debug(new DebugLogInfo() { Message = "通知ALD更改状态:" + postContent });
// var strAldRsp = HttpWebClient.DoHttpRequest(url, postContent);
// var aldRsp = strAldRsp.DeserializeJSONTo<JIT.CPOS.Web.OnlineShopping.data.DataOnlineShoppingHandler.ALDResponse>();
// if (!aldRsp.IsSuccess())
// {
// Loggers.Debug(new DebugLogInfo() { Message = string.Format("更新阿拉丁订单状态失败[Request ={0}][Response={1}]", aldRequest.ToJSON(), strAldRsp) });
// }
//}
#endregion
#region 格力推送通知
//try
//{
// GLServiceOrderBLL glsobll = new GLServiceOrderBLL(loggingSessionInfo);
// if (glsobll.ValidateGree(CustomerID, "cpos_bs_lj"))//先写死
// glsobll.GreePushPaymentOorder(CustomerID, OrderID, loggingSessionInfo);
//}
//catch (Exception ex)
//{
// Loggers.Debug(new DebugLogInfo() { Message = string.Format("付款推送评价师傅链接失败[OrderID={0}].", OrderID) });
//}
#endregion
#region ALD生活服务处理
//var rechargeBll = new RechargeStrategyBLL(loggingSessionInfo);
//var vipAmountBll = new VipAmountBLL(loggingSessionInfo);
//var couponBll = new CouponBLL(loggingSessionInfo);
//var vipCouponMappingBll = new VipCouponMappingBLL(loggingSessionInfo);
//var unitBll = new UnitBLL(loggingSessionInfo);
//DataSet dsOrderInfo = rechargeBll.GetInoutOrderItems(OrderID);
//int itemSort = 0; //商品业务分类
//string skuId = string.Empty; //商品SkuId
//string vipId = string.Empty; //会员ID
//string itemId = string.Empty;//商品ID
//string couponId = string.Empty;//优惠券ID
//if (dsOrderInfo.Tables[0].Rows.Count > 0)
//{
// //if (dsOrderInfo.Tables[0].Rows[0]["ItemSort"] != DBNull.Value && Convert.ToString(dsOrderInfo.Tables[0].Rows[0]["ItemSort"]) != "0")
// itemSort = int.Parse(dsOrderInfo.Tables[0].Rows[0]["ItemSort"].ToString());
// switch (itemSort)
// {
// case 2://充
// #region 充值金额处理
// VipAmountDetailBLL vipAmountDetailBll = new VipAmountDetailBLL(loggingSessionInfo);
// List<IWhereCondition> complexCondition = new List<IWhereCondition> { };
// complexCondition.Add(new EqualsCondition() { FieldName = "ObjectId", Value = OrderID });
// var vipAmountDetal = vipAmountDetailBll.Query(complexCondition.ToArray(), null);
// if (vipAmountDetal.Count() == 0)//确认没有多次执行回调
// {
// ////查询
// //RechargeStrategyEntity[] rechargeList = rechargeBll.Query(complexCondition.ToArray(), lstOrder.ToArray());
// skuId = dsOrderInfo.Tables[0].Rows[0]["SkuId"].ToString();
// //RechargeStrategyEntity rechargeEntity = rechargeBll.GetByID(skuId);
// DataSet dsSkuPirce = unitBll.GetSkuPirce(skuId);
// decimal salePrice = 0;//购买金额
// decimal returnCash = 0;//奖励金额
// if (dsSkuPirce.Tables[0].Rows.Count > 0)
// {
// salePrice = Convert.ToDecimal(dsSkuPirce.Tables[0].Rows[0]["SalesPrice"].ToString());
// returnCash = Convert.ToDecimal(dsSkuPirce.Tables[0].Rows[0]["ReturnCash"].ToString());
// InoutService server = new InoutService(loggingSessionInfo);
// #region 充值金额
// var tran = server.GetTran();
// using (tran.Connection)//事物
// {
// try
// {
// //充值金额
// vipAmountBll.AddVipEndAmount(UserID, salePrice, tran, "4", OrderID, loggingSessionInfo);//4=充值
// tran.Commit();
// }
// catch (Exception)
// {
// tran.Rollback();
// throw;
// }
// }
// #endregion
// #region 奖励金额
// var tran2 = server.GetTran();
// using (tran2.Connection)//事物
// {
// try
// {
// //奖励金额
// vipAmountBll.AddVipEndAmount(UserID, returnCash, tran2, "6", OrderID, loggingSessionInfo);//6=奖励金额
// tran2.Commit();
// }
// catch (Exception)
// {
// tran2.Rollback();
// throw;
// }
// }
// #endregion
// }
// }
// #endregion
// break;
// case 3://券
// #region 券类商品绑定到会员
// itemId = dsOrderInfo.Tables[0].Rows[0]["ItemId"].ToString();
// vipId = dsOrderInfo.Tables[0].Rows[0]["VipId"].ToString();
// couponId = couponBll.GetCouponByItemId(itemId);
// if (!string.IsNullOrEmpty(couponId))
// {
// VipCouponMappingEntity coupon = new VipCouponMappingEntity
// {
// VIPID = vipId,
// CouponID = couponId,
// };
// vipCouponMappingBll.Create(coupon);
// }
// #endregion
// break;
// default:
// break;
// }
//}
#endregion
#region 订单与分润关系处理 add by Henry 2014-10-10
//var orderSubBll = new OrderOrderSubRunObjectMappingBLL(loggingSessionInfo);
//dynamic o = orderSubBll.SetOrderSub(CustomerID, OrderID);
//Type t = o.GetType();
//var Desc = t.GetProperty("Desc").GetValue(o, null).ToString();
//var IsSuccess = t.GetProperty("IsSuccess").GetValue(o, null).ToString();
//if (int.Parse(IsSuccess.ToString()) == 0) //失败
// Loggers.Debug(new DebugLogInfo() { Message = string.Format("订单与分润关系处理失败:{0}", Desc) });
#endregion
CustomerBasicSettingBLL customerBasicSettingBll = new CustomerBasicSettingBLL(loggingSessionInfo);
string AfterPaySetStock = customerBasicSettingBll.GetSettingValueByCode("AfterPaySetStock");
if (AfterPaySetStock == "1")
{
var inoutServiceBLL = new InoutService(loggingSessionInfo);
var inoutDetailList = inoutServiceBLL.GetInoutDetailInfoByOrderId(OrderID);
inoutBll.SetStock(OrderID, inoutDetailList, 1, loggingSessionInfo);
}
///超级分销商订单入队列
if (inoutInfo.data_from_id == "35" || inoutInfo.data_from_id == "36")
{
BS.BLL.RedisOperationBLL.Order.SuperRetailTraderOrderBLL bllSuperRetailTraderOrder = new BS.BLL.RedisOperationBLL.Order.SuperRetailTraderOrderBLL();
bllSuperRetailTraderOrder.SetRedisToSuperRetailTraderOrder(loggingSessionInfo, inoutInfo);
}
//购卡
if (!string.IsNullOrEmpty(inoutInfo.Field17) && !string.IsNullOrEmpty(inoutInfo.Field18))
{
//更新订单状态
inoutInfo = inoutBll.GetByID(OrderID);
inoutInfo.Field7 = "700";
inoutInfo.status = "700";
inoutInfo.status_desc = "已完成";
inoutInfo.Field10 = "已完成";
inoutBll.Update(inoutInfo);
//会员卡升级
vipCardVipMappingBll.BindVirtualItem(vipInfo.VIPID, vipInfo.VipCode, inoutInfo.sales_unit_id, Convert.ToInt32(inoutInfo.Field18), orderId: inoutInfo.order_id);
//分润计算
RedisSalesVipCardOrderBLL redisSalesVipCardOrderBll = new RedisSalesVipCardOrderBLL();
redisSalesVipCardOrderBll.SetRedisSalesVipCardOrder(loggingSessionInfo, inoutInfo);
//售卡处理积分、返现、佣金[完成订单]
new SendOrderRewardMsgBLL().OrderReward(inoutInfo, loggingSessionInfo, null);//存入到缓存
}
else
{
//订单入队列
RedisCalculateVipConsumeForUpgrade redisCalculateVipConsumeForUpgrade = new RedisCalculateVipConsumeForUpgrade();
redisCalculateVipConsumeForUpgrade.SetVipConsumeForUpgradeList(loggingSessionInfo, inoutInfo);
}
// add by liangx 2016-09-27 获取订单中的虚拟商品 start
CouponTypeBLL couponTypeBLL = new CouponTypeBLL(loggingSessionInfo);
RedisVipMappingCouponBLL redisVipMappingCouponBLL = new RedisVipMappingCouponBLL();
var couponTypes = couponTypeBLL.GetVirtualItemCouponTypes(inoutInfo.order_id);
if (couponTypes.Any())
{
redisVipMappingCouponBLL.SetVipMappingCoupon(couponTypes, "", couponTypes.FirstOrDefault().VipId, "PayVirtualItem");
}
// add by liangx 2016-09-27 获取订单中的虚拟商品 end
//获取门店信息
t_unitEntity unitInfo = null;
if (!string.IsNullOrEmpty(inoutInfo.sales_unit_id))
{
unitInfo = unitBLL.GetByID(inoutInfo.sales_unit_id);
}
//入支付明细表
var paymentDetail = new T_Payment_detailEntity()
{
Payment_Id = Guid.NewGuid().ToString(),
Inout_Id = inoutInfo.order_id,
UnitCode = unitInfo == null ? "" : unitInfo.unit_code,
Payment_Type_Id = tPaymentType.Payment_Type_Id,
Payment_Type_Code = tPaymentType.Payment_Type_Code,
Payment_Type_Name = tPaymentType.Payment_Type_Name,
Price = inoutInfo.actual_amount,
Total_Amount = inoutInfo.total_amount,
Pay_Points = inoutInfo.pay_points,
CustomerId = loggingSessionInfo.ClientID
};
paymentDetailBll.Create(paymentDetail);
List <IWhereCondition> complexCondition = new List <IWhereCondition> {
};
complexCondition.Add(new EqualsCondition()
{
FieldName = "Inout_Id", Value = inoutInfo.order_id
});
var paymentDetailList = paymentDetailBll.Query(complexCondition.ToArray(), null);
try
{
var msgRabbitMQ = new EventContract
{
Operation = OptEnum.Create,
EntityType = EntityTypeEnum.Order,
Id = inoutInfo.order_id
};
var service = new EventService();
service.PublishMsg(msgRabbitMQ);
foreach (var detail in paymentDetailList)
{
var paymentMQ = new EventContract
{
Operation = OptEnum.Create,
EntityType = EntityTypeEnum.OrderPayment,
Id = detail.Payment_Id
};
service.PublishMsg(paymentMQ);
}
}
catch (Exception)
{
throw new Exception("RabbitMQ Error");
}
}
else//充值订单
{
var rechargeOrderBll = new RechargeOrderBLL(loggingSessionInfo);
var vipamountDetailBll = new VipAmountDetailBLL(loggingSessionInfo);
var rechargeOrderInfo = rechargeOrderBll.GetByID(OrderID);
if (rechargeOrderInfo != null)
{
//获取门店信息
t_unitEntity unitInfo = null;
if (!string.IsNullOrEmpty(rechargeOrderInfo.UnitId))
{
unitInfo = unitBLL.GetByID(rechargeOrderInfo.UnitId);
}
//充值
rechargeOrderBll.Recharge(rechargeOrderInfo, vipInfo, unitInfo, tPaymentType.Payment_Type_Id);
//入支付明细表
var paymentDetail = new T_Payment_detailEntity()
{
Payment_Id = Guid.NewGuid().ToString(),
Inout_Id = rechargeOrderInfo.OrderID.ToString(),
UnitCode = unitInfo == null ? "" : unitInfo.unit_code,
Payment_Type_Id = tPaymentType.Payment_Type_Id,
Payment_Type_Code = tPaymentType.Payment_Type_Code,
Payment_Type_Name = tPaymentType.Payment_Type_Name,
Price = rechargeOrderInfo.ActuallyPaid,
Total_Amount = rechargeOrderInfo.TotalAmount,
Pay_Points = rechargeOrderInfo.PayPoints,
CustomerId = loggingSessionInfo.ClientID
};
paymentDetailBll.Create(paymentDetail);
}
else
{
var receiveAmountOrderBll = new ReceiveAmountOrderBLL(loggingSessionInfo);
var receiveAmountOrderEntity = receiveAmountOrderBll.GetByID(OrderID);
//更新订单状态
if (receiveAmountOrderEntity != null)
{
VipIntegralBLL vipIntegralBll = new VipIntegralBLL(loggingSessionInfo);
//更新订单
receiveAmountOrderEntity.PayStatus = "10";
// Bear
//receiveAmountOrderEntity.PayTypeId = tPaymentTypeCustomerMappingEntity.PaymentTypeID;
receiveAmountOrderEntity.PayTypeId = tPaymentType.Payment_Type_Id;
receiveAmountOrderEntity.PayDatetTime = DateTime.Now;
receiveAmountOrderBll.Update(receiveAmountOrderEntity);
//获取门店信息
t_unitEntity unitInfo = null;
if (!string.IsNullOrEmpty(receiveAmountOrderEntity.ServiceUnitId))
{
unitInfo = unitBLL.GetByID(receiveAmountOrderEntity.ServiceUnitId);
}
//使用过积分，处理积分
if (receiveAmountOrderEntity.PayPoints != 0 && receiveAmountOrderEntity.PayPoints != null)
{
string sourceId = "20"; //积分抵扣
var IntegralDetail = new VipIntegralDetailEntity()
{
Integral = -Convert.ToInt32(receiveAmountOrderEntity.PayPoints),
IntegralSourceID = sourceId,
ObjectId = receiveAmountOrderEntity.OrderId.ToString()
};
if (IntegralDetail.Integral != 0)
{
//变动前积分
string OldIntegral = (vipInfo.Integration ?? 0).ToString();
//变动积分
string ChangeIntegral = (IntegralDetail.Integral ?? 0).ToString();
var vipIntegralDetailId = vipIntegralBll.AddIntegral(ref vipInfo, unitInfo, IntegralDetail, loggingSessionInfo);
//发送微信积分变动通知模板消息
if (!string.IsNullOrWhiteSpace(vipIntegralDetailId))
{
var CommonBLL = new CommonBLL();
CommonBLL.PointsChangeMessage(OldIntegral, vipInfo, ChangeIntegral, vipInfo.WeiXinUserId, loggingSessionInfo);
}
}
}
//if (receiveAmountOrderEntity.CouponUsePay != 0 || receiveAmountOrderEntity.CouponUsePay != null)
//{
// //更新使用记录
// var couponUseBll = new CouponUseBLL(loggingSessionInfo);
// var couponUseEntity = new CouponUseEntity()
// {
// CouponUseID = Guid.NewGuid(),
// CouponID = rp.CouponId,
// VipID = vipInfo.VIPID,
// UnitID = rp.UnitId,
// OrderID = orderId.ToString(),
// Comment = "商城使用电子券",
// CustomerID = CurrentUserInfo.ClientID,
// CreateBy = CurrentUserInfo.UserID,
// CreateTime = DateTime.Now,
// LastUpdateBy = CurrentUserInfo.UserID,
// LastUpdateTime = DateTime.Now,
// IsDelete = 0
// };
// couponUseBll.Create(couponUseEntity);
// var couponBll = new CouponBLL(CurrentUserInfo);
// var couponEntity = couponBll.GetByID(rp.CouponId);
// //更新CouponType数量
// var conponTypeBll = new CouponTypeBLL(CurrentUserInfo);
// var conponTypeEntity = conponTypeBll.QueryByEntity(new CouponTypeEntity() { CouponTypeID = new Guid(couponEntity.CouponTypeID), CustomerId = CurrentUserInfo.ClientID }, null).FirstOrDefault();
// conponTypeEntity.IsVoucher += 1;
// conponTypeBll.Update(conponTypeEntity);
// //停用该优惠券
// couponEntity.Status = 1;
// couponBll.Update(couponEntity);
//}
//处理余额
if (receiveAmountOrderEntity.AmountAcctPay != null && receiveAmountOrderEntity.AmountAcctPay != 0)
{
var vipAmountDetailBll = new VipAmountDetailBLL(loggingSessionInfo);
var vipAmountEntity = vipAmountBll.QueryByEntity(new VipAmountEntity()
{
VipId = vipInfo.VIPID, VipCardCode = vipInfo.VipCode
}, null).FirstOrDefault();
if (vipAmountEntity != null)
{
var detailInfo = new VipAmountDetailEntity()
{
Amount = -receiveAmountOrderEntity.AmountAcctPay,
AmountSourceId = "1",
ObjectId = receiveAmountOrderEntity.OrderId.ToString()
};
var vipAmountDetailId = vipAmountBll.AddVipAmount(vipInfo, unitInfo, ref vipAmountEntity, detailInfo, loggingSessionInfo);
if (!string.IsNullOrWhiteSpace(vipAmountDetailId))
{//发送微信账户余额变动模板消息
var CommonBLL = new CommonBLL();
CommonBLL.BalanceChangedMessage(receiveAmountOrderEntity.OrderNo, vipAmountEntity, detailInfo, vipInfo.WeiXinUserId, vipInfo.VIPID, loggingSessionInfo);
}
}
}
//收款订单积分奖励
vipIntegralBll.OrderReward(receiveAmountOrderEntity, null);
var paymentDetail = new T_Payment_detailEntity()
{
Payment_Id = Guid.NewGuid().ToString(),
Inout_Id = receiveAmountOrderEntity.OrderId.ToString(),
UnitCode = unitInfo == null ? "" : unitInfo.unit_code,
Payment_Type_Id = tPaymentType.Payment_Type_Id,
Payment_Type_Code = tPaymentType.Payment_Type_Code,
Payment_Type_Name = tPaymentType.Payment_Type_Name,
Price = receiveAmountOrderEntity.TransAmount,
Total_Amount = receiveAmountOrderEntity.TotalAmount,
Pay_Points = receiveAmountOrderEntity.PayPoints,
CustomerId = loggingSessionInfo.ClientID
};
paymentDetailBll.Create(paymentDetail);
}
}
}
context.Response.Write("SUCCESS");
}
}
}
catch (Exception ex)
{
Loggers.Exception(new ExceptionLogInfo(ex));
context.Response.Write("ERROR:" + ex.Message);
}
}
protected override GetVIPCardListRD ProcessRequest(DTO.Base.APIRequest <GetVIPCardListRP> pRequest)
{
var rd = new GetVIPCardListRD();
var para = pRequest.Parameters;
var loggingSessionInfo = new SessionManager().CurrentUserLoginInfo;
var VipCardBLL = new VipCardBLL(loggingSessionInfo);
var unitBLL = new t_unitBLL(loggingSessionInfo);
//查询参数
List <IWhereCondition> complexCondition = new List <IWhereCondition> {
};
//商户条件
complexCondition.Add(new EqualsCondition()
{
FieldName = "a.CustomerID", Value = loggingSessionInfo.ClientID
});
//if (!string.IsNullOrEmpty(para.Phone))
// complexCondition.Add(new EqualsCondition() { FieldName = "g.Phone", Value = para.Phone });
if (!string.IsNullOrEmpty(para.VipCardCode))
{
complexCondition.Add(new EqualsCondition()
{
FieldName = "a.VipCardCode", Value = para.VipCardCode
});
}
if (!string.IsNullOrEmpty(para.VipCardTypeID))
{
complexCondition.Add(new EqualsCondition()
{
FieldName = "a.VipCardTypeID", Value = para.VipCardTypeID
});
}
if (!string.IsNullOrEmpty(para.VipCardStatusId))
{
complexCondition.Add(new EqualsCondition()
{
FieldName = "a.VipCardStatusId", Value = para.VipCardStatusId
});
}
if (!string.IsNullOrEmpty(para.BeginDate))
{
complexCondition.Add(new DirectCondition("a.BeginDate>=" + para.BeginDate + " "));
}
if (!string.IsNullOrEmpty(para.EndDate))
{
complexCondition.Add(new DirectCondition("a.EndDate<=" + para.EndDate + " "));
}
if (!string.IsNullOrEmpty(para.UnitID))
{
//门店对象
t_unitEntity unitData = unitBLL.GetByID(para.UnitID);
string type_id = unitData == null ? "" : unitData.type_id;
//总部
if (type_id != "2F35F85CF7FF4DF087188A7FB05DED1D")
{
complexCondition.Add(new EqualsCondition()
{
FieldName = "u.Unit_ID", Value = para.UnitID
});
}
}
else
{
//门店对象
t_unitEntity D_unitData = unitBLL.GetByID(loggingSessionInfo.CurrentUserRole.UnitId);
string D_type_id = D_unitData == null ? "" : D_unitData.type_id;
if (D_type_id != "2F35F85CF7FF4DF087188A7FB05DED1D")
{
complexCondition.Add(new EqualsCondition()
{
FieldName = "u.Unit_ID", Value = loggingSessionInfo.CurrentUserRole.UnitId
});
}
}
if (!string.IsNullOrWhiteSpace(para.VIPID))
{
complexCondition.RemoveAt(complexCondition.Count() - 1);
}
//排序参数
List <OrderBy> lstOrder = new List <OrderBy> {
};
lstOrder.Add(new OrderBy()
{
FieldName = "LastUpdateTime", Direction = OrderByDirections.Desc
});
//调用会员卡管理列表查询
var tempList = VipCardBLL.GetVipCardList(para.VIPID, para.Phone, complexCondition.ToArray(), lstOrder.ToArray(), para.PageSize, para.PageIndex);
rd.TotalPageCount = tempList.PageCount;
rd.TotalCount = tempList.RowCount;
rd.VipCardList = tempList.Entities.Select(t => new VipCardInfo()
{
VipCardID = t.VipCardID,
VipCardCode = t.VipCardCode,
VipCardName = t.VipCardTypeName,
VipName = t.VipName,
Phone = t.Phone,
MembershipTime = t.MembershipTime == null ? "" : t.MembershipTime.Value.ToString("yyyy-MM-dd"),
MembershipUnitName = t.UnitName == null ? "" : t.UnitName,
VipCardStatusID = t.VipCardStatusId.Value,
SalesUserName = t.SalesUserName == null?"":t.SalesUserName,
ImageUrl = t.picUrl,
BalanceAmount = t.BalanceAmount == null ? 0 : t.BalanceAmount.Value,
VIPID = t.VIPID
}).ToList();
return(rd);
}
protected override EmptyResponseData ProcessRequest(DTO.Base.APIRequest <SetSalesReturnRP> pRequest)
{
var rd = new EmptyResponseData();
var para = pRequest.Parameters;
var loggingSessionInfo = new SessionManager().CurrentUserLoginInfo;
var salesReturnBLL = new T_SalesReturnBLL(loggingSessionInfo);
var historyBLL = new T_SalesReturnHistoryBLL(loggingSessionInfo);
var refundOrderBLL = new T_RefundOrderBLL(loggingSessionInfo);
var inoutBLL = new T_InoutBLL(loggingSessionInfo);
var inoutService = new InoutService(loggingSessionInfo);
var vipAmountBLL = new VipAmountBLL(loggingSessionInfo); //余额返现BLL实例化
var vipIntegralBLL = new VipIntegralBLL(loggingSessionInfo); //积分BLL实例化
var pTran = salesReturnBLL.GetTran(); //事务
T_SalesReturnEntity salesReturnEntity = null;
T_SalesReturnHistoryEntity historyEntity = null;
T_RefundOrderEntity refundEntity = null;
var vipBll = new VipBLL(loggingSessionInfo); //会员BLL实例化
var userBll = new T_UserBLL(loggingSessionInfo); //店员BLL实例化
T_UserEntity userEntity = null; //店员信息
var unitBLL = new t_unitBLL(loggingSessionInfo);
salesReturnEntity = salesReturnBLL.GetByID(para.SalesReturnID);
//获取订单信息
var inoutInfo = inoutBLL.GetInoutInfo(salesReturnEntity.OrderID, loggingSessionInfo);
//获取会员信息
var vipInfo = vipBll.GetByID(inoutInfo.vip_no);
//获取门店信息
t_unitEntity unitInfo = null;
if (!string.IsNullOrEmpty(inoutInfo.sales_unit_id))
{
unitInfo = unitBLL.GetByID(inoutInfo.sales_unit_id);
}
userEntity = userBll.GetByID(loggingSessionInfo.UserID);
using (pTran.Connection)
{
try
{
switch (para.OperationType)
{
case 1:
#region 审核通过
salesReturnEntity.Status = 4; //审核通过
#region 计算应退金额
decimal payable = 0; //计算后应退金额
//根据订单ID获取订单明细[复用]
DataRow drItem = inoutService.GetOrderDetailByOrderId(salesReturnEntity.OrderID).Tables[0].Select(" item_id= '" + salesReturnEntity.ItemID + "'").FirstOrDefault();
decimal salesPrice = Convert.ToDecimal(drItem["enter_price"]);
if (inoutInfo != null)
{
//订单总金额-运费
decimal tempAmount = inoutInfo.total_amount.Value - inoutInfo.DeliveryAmount;
//计算会员折扣
decimal discount = 1;
if (inoutInfo.discount_rate.Value > 0)
{
discount = inoutInfo.discount_rate.Value / 100;
}
//计算后应退金额
//payable = (((tempAmount - inoutInfo.CouponAmount) * discount) / tempAmount) * (salesPrice * salesReturnEntity.ActualQty.Value);
//公式：比例 =（应付金额 * 会员折扣 - 优惠券）/ 应付金额
// 应退金额 = 退货数量 * 销售价 * 比例
payable = ((tempAmount * discount - inoutInfo.CouponAmount) / tempAmount) * (salesPrice * salesReturnEntity.ActualQty.Value);
}
salesReturnEntity.RefundAmount = payable; //应退金额
salesReturnEntity.ConfirmAmount = payable; //实退金额，默认为应退金额，可支持修改
#endregion
salesReturnBLL.Update(salesReturnEntity, pTran);
historyEntity = new T_SalesReturnHistoryEntity()
{
SalesReturnID = salesReturnEntity.SalesReturnID,
OperationType = 4,
OperationDesc = "审核",
OperatorID = loggingSessionInfo.UserID,
HisRemark = "您的服务单已审核通过，请将商品寄回",
OperatorName = userEntity.user_name,
OperatorType = 1
};
historyBLL.Create(historyEntity, pTran);
#endregion
break;
case 2:
#region 审核不通过
salesReturnEntity.Status = 3; //审核不通过
salesReturnBLL.Update(salesReturnEntity, pTran);
historyEntity = new T_SalesReturnHistoryEntity()
{
SalesReturnID = salesReturnEntity.SalesReturnID,
OperationType = 3,
OperationDesc = "审核",
OperatorID = loggingSessionInfo.UserID,
HisRemark = para.Desc,
OperatorName = userEntity.user_name,
OperatorType = 1
};
historyBLL.Create(historyEntity, pTran);
break;
#endregion
case 3:
#region 确认收货
salesReturnEntity.Status = 6; //确认收货
salesReturnBLL.Update(salesReturnEntity, pTran);
historyEntity = new T_SalesReturnHistoryEntity()
{
SalesReturnID = salesReturnEntity.SalesReturnID,
OperationType = 6,
OperationDesc = "收货",
OperatorID = loggingSessionInfo.UserID,
HisRemark = "您的服务单" + salesReturnEntity.SalesReturnNo + "的商品已经收到",
OperatorName = userEntity.user_name,
OperatorType = 1
};
historyBLL.Create(historyEntity, pTran);
//退货时生成退款单
if (salesReturnEntity.ServicesType == 1)
{
refundEntity = new T_RefundOrderEntity();
refundEntity.SalesReturnID = salesReturnEntity.SalesReturnID;
refundEntity.RefundNo = DateTime.Now.ToString("yyyyMMddhhmmfff");
refundEntity.VipID = salesReturnEntity.VipID;
refundEntity.DeliveryType = salesReturnEntity.DeliveryType;
refundEntity.OrderID = salesReturnEntity.OrderID;
refundEntity.ItemID = salesReturnEntity.ItemID;
refundEntity.SkuID = salesReturnEntity.SkuID;
refundEntity.Qty = salesReturnEntity.Qty;
refundEntity.ActualQty = salesReturnEntity.ActualQty;
refundEntity.UnitID = salesReturnEntity.UnitID;
refundEntity.UnitName = salesReturnEntity.UnitName;
refundEntity.UnitTel = salesReturnEntity.UnitTel;
refundEntity.Address = salesReturnEntity.Address;
refundEntity.Contacts = salesReturnEntity.Contacts;
refundEntity.Phone = salesReturnEntity.Phone;
refundEntity.RefundAmount = salesReturnEntity.RefundAmount; //退款金额
refundEntity.ConfirmAmount = salesReturnEntity.ConfirmAmount; //确认退款金额
#region 计算应退现金金额、余额、积分、返现
var inoutDetail = inoutBLL.GetInoutInfo(salesReturnEntity.OrderID, loggingSessionInfo);
if (inoutDetail != null)
{
//订单实付金额-运费 >= 应退金额
if (inoutDetail.actual_amount - inoutDetail.DeliveryAmount >= salesReturnEntity.ConfirmAmount)
{
refundEntity.ActualRefundAmount = salesReturnEntity.ConfirmAmount;
}
//订单实付金额-运费+余额抵扣 >= 应退金额
else if (inoutDetail.actual_amount - inoutDetail.DeliveryAmount + inoutDetail.VipEndAmount >= salesReturnEntity.ConfirmAmount)
{
refundEntity.ActualRefundAmount = inoutDetail.actual_amount - inoutDetail.DeliveryAmount; //实付金额
//refundEntity.Amount = salesReturnEntity.ConfirmAmount - inoutDetail.actual_amount; //退回余额
refundEntity.Amount = salesReturnEntity.ConfirmAmount - refundEntity.ActualRefundAmount; //退回余额
}
//订单实付金额-运费+余额抵扣+积分抵扣 >= 应退金额
else if (inoutDetail.actual_amount - inoutDetail.DeliveryAmount + inoutDetail.VipEndAmount + inoutDetail.IntegralAmount >= salesReturnEntity.ConfirmAmount)
{
refundEntity.ActualRefundAmount = inoutDetail.actual_amount - inoutDetail.DeliveryAmount; //实付金额
refundEntity.Amount = inoutDetail.VipEndAmount; //退回余额
//退回积分抵扣金额
refundEntity.PointsAmount = salesReturnEntity.ConfirmAmount.Value - (inoutDetail.actual_amount.Value - inoutDetail.DeliveryAmount) - inoutDetail.VipEndAmount;
//退回积分
refundEntity.Points = (int)Math.Round(refundEntity.PointsAmount.Value * (inoutDetail.pay_points.Value / inoutDetail.IntegralAmount), 1);
}
else //订单实付金额-运费+余额抵扣+积分抵扣 < 应退金额
{
refundEntity.Points = (int)Math.Round(inoutDetail.pay_points.Value, 1); //退回积分
refundEntity.PointsAmount = inoutDetail.IntegralAmount; //退回积分抵扣金额
refundEntity.Amount = inoutDetail.VipEndAmount; //退回余额
refundEntity.ActualRefundAmount = salesReturnEntity.ConfirmAmount; //实付金额
}
//订单实付金额-运费+余额抵扣+积分抵扣 >= 应退金额
//取消返现
//else if (inoutDetail.actual_amount - inoutDetail.DeliveryAmount + inoutDetail.VipEndAmount + inoutDetail.IntegralAmount + inoutDetail.ReturnAmount >= salesReturnEntity.ConfirmAmount)
//{
// refundEntity.ActualRefundAmount = inoutDetail.actual_amount - inoutDetail.DeliveryAmount;//实付金额
// refundEntity.Amount = inoutDetail.VipEndAmount; //退回余额
// refundEntity.Points = (int)Math.Round(inoutDetail.pay_points.Value, 1);//退回积分
// refundEntity.PointsAmount = inoutDetail.IntegralAmount; //退回积分抵扣金额
// //退回的返现
// refundEntity.ReturnAmount = salesReturnEntity.ConfirmAmount.Value - (inoutDetail.actual_amount.Value - inoutDetail.DeliveryAmount) - inoutDetail.VipEndAmount - inoutDetail.IntegralAmount;
//}
}
#endregion
refundEntity.Status = 1; //待退款
refundEntity.CustomerID = loggingSessionInfo.ClientID;
refundOrderBLL.Create(refundEntity, pTran);
var vipAmountEntity = vipAmountBLL.QueryByEntity(new VipAmountEntity()
{
VipId = vipInfo.VIPID, VipCardCode = vipInfo.VipCode
}, null).FirstOrDefault();
//退货返回余额
if (refundEntity.Amount > 0)
{
//变更余额和余额记录
var detailInfo = new VipAmountDetailEntity()
{
Amount = refundEntity.Amount.Value,
AmountSourceId = "21",
ObjectId = refundEntity.RefundID.ToString()
};
var vipAmountDetailId = vipAmountBLL.AddVipAmount(vipInfo, unitInfo, ref vipAmountEntity, detailInfo, pTran, loggingSessionInfo);
if (!string.IsNullOrWhiteSpace(vipAmountDetailId))
{ //发送微信账户余额变动模板消息
var CommonBLL = new CommonBLL();
CommonBLL.BalanceChangedMessage(inoutInfo.order_no, vipAmountEntity, detailInfo, vipInfo.WeiXinUserId, vipInfo.VIPID, loggingSessionInfo);
}
}
//退货返回返现
if (refundEntity.ReturnAmount > 0)
{
var detailInfo = new VipAmountDetailEntity()
{
Amount = refundEntity.ReturnAmount.Value,
ObjectId = refundEntity.RefundID.ToString(),
AmountSourceId = "22"
};
var vipAmountDetailId = vipAmountBLL.AddReturnAmount(vipInfo, unitInfo, vipAmountEntity, ref detailInfo, pTran, loggingSessionInfo);
if (!string.IsNullOrWhiteSpace(vipAmountDetailId))
{ //发送返现到账通知微信模板消息
var CommonBLL = new CommonBLL();
CommonBLL.CashBackMessage(salesReturnEntity.OrderNo, detailInfo.Amount, vipInfo.WeiXinUserId, vipInfo.VIPID, loggingSessionInfo);
}
}
//退货返回积分
if (refundEntity.Points > 0)
{
var IntegralDetail = new VipIntegralDetailEntity()
{
Integral = refundEntity.Points.Value,
IntegralSourceID = "26",
ObjectId = refundEntity.RefundID.ToString()
};
if (IntegralDetail.Integral != 0)
{
//变动前积分
string OldIntegral = (vipInfo.Integration ?? 0).ToString();
//变动积分
string ChangeIntegral = (IntegralDetail.Integral ?? 0).ToString();
var vipIntegralDetailId = vipIntegralBLL.AddIntegral(ref vipInfo, unitInfo, IntegralDetail, pTran, loggingSessionInfo);
//发送微信积分变动通知模板消息
if (!string.IsNullOrWhiteSpace(vipIntegralDetailId))
{
var CommonBLL = new CommonBLL();
CommonBLL.PointsChangeMessage(OldIntegral, vipInfo, ChangeIntegral, vipInfo.WeiXinUserId, loggingSessionInfo);
}
}
}
//确认收货时退回订单奖励积分、返现和佣金
vipIntegralBLL.CancelReward(inoutInfo, vipInfo, pTran);
}
#endregion
break;
case 4:
#region 拒绝收货
salesReturnEntity.Status = 5; //拒绝收货
salesReturnBLL.Update(salesReturnEntity, pTran);
historyEntity = new T_SalesReturnHistoryEntity()
{
SalesReturnID = salesReturnEntity.SalesReturnID,
OperationType = 5,
OperationDesc = "收货",
OperatorID = loggingSessionInfo.UserID,
HisRemark = para.Desc,
OperatorName = userEntity.user_name,
OperatorType = 1
};
historyBLL.Create(historyEntity, pTran);
#endregion
break;
case 5:
#region 修改信息
if (para.ServicesType > 0) //修改服务方式
{
salesReturnEntity.ServicesType = para.ServicesType;
string servicesTypeDesc = para.ServicesType == 1 ? "退货" : "换货";
historyEntity = new T_SalesReturnHistoryEntity()
{
SalesReturnID = salesReturnEntity.SalesReturnID,
OperationType = 11,
OperationDesc = "修改信息",
OperatorID = loggingSessionInfo.UserID,
HisRemark = "修改服务方式为" + servicesTypeDesc,
OperatorName = userEntity.user_name,
OperatorType = 1,
IsDelete = 1
};
historyBLL.Create(historyEntity, pTran);
}
if (para.ActualQty > 0) //修改申请数量
{
salesReturnEntity.ActualQty = para.ActualQty;
historyEntity = new T_SalesReturnHistoryEntity()
{
SalesReturnID = salesReturnEntity.SalesReturnID,
OperationType = 11,
OperationDesc = "修改信息",
OperatorID = loggingSessionInfo.UserID,
HisRemark = "修改确认退货数量为" + para.ActualQty,
OperatorName = userEntity.user_name,
OperatorType = 1,
IsDelete = 1
};
historyBLL.Create(historyEntity, pTran);
}
if (para.ConfirmAmount >= 0) //处理实退金额
{
salesReturnEntity.ConfirmAmount = para.ConfirmAmount;
historyEntity = new T_SalesReturnHistoryEntity()
{
SalesReturnID = salesReturnEntity.SalesReturnID,
OperationType = 13,
OperationDesc = "修改信息",
OperatorID = loggingSessionInfo.UserID,
HisRemark = "修改实退金额为" + para.ConfirmAmount,
OperatorName = userEntity.user_name,
OperatorType = 1,
IsDelete = 1
};
historyBLL.Create(historyEntity, pTran);
}
salesReturnBLL.Update(salesReturnEntity, pTran);
#endregion
break;
case 6:
#region 取消
salesReturnEntity.Status = 2; //取消申请
salesReturnBLL.Update(salesReturnEntity, pTran);
historyEntity = new T_SalesReturnHistoryEntity()
{
SalesReturnID = salesReturnEntity.SalesReturnID,
OperationType = 2,
OperationDesc = "取消申请",
OperatorID = CurrentUserInfo.UserID,
HisRemark = para.Desc,
OperatorName = userEntity.user_name,
OperatorType = 0
};
historyBLL.Create(historyEntity, pTran);
#endregion
break;
default:
break;
}
pTran.Commit(); //提交事物
}
catch (Exception ex)
{
pTran.Rollback();//回滚事务
throw new APIException(ex.Message);
}
}
return(rd);
}
protected override GetOrderDetailRD ProcessRequest(DTO.Base.APIRequest <GetOrderDetailRP> pRequest)
{
GetOrderDetailRD rd = new GetOrderDetailRD();
string orderId = pRequest.Parameters.OrderId;
rd.OrderListInfo = new OrderListInfo();
#region 获取订单列表
T_InoutBLL orderBll = new T_InoutBLL(this.CurrentUserInfo);
var orderList = orderBll.QueryByEntity(new T_InoutEntity()
{
order_id = orderId
}, null);
#endregion
#region 获取会员信息
string vipNo = orderList[0].vip_no;
VipBLL vipBll = new VipBLL(this.CurrentUserInfo);
var vipList = vipBll.QueryByEntity(new VipEntity()
{
VIPID = vipNo
}, null);
#endregion
#region 获取配方式
//Bear 20160928 注释 更具商品信息获取对应配送
string deliveryId = orderList[0].Field8;
DeliveryBLL deliverBll = new DeliveryBLL(this.CurrentUserInfo);
var deliverList = deliverBll.QueryByEntity(new DeliveryEntity()
{
DeliveryId = deliveryId
}, null);
#endregion
#region 获取门店信息
string storeId = orderList[0].sales_unit_id;
if (!string.IsNullOrEmpty(orderList[0].purchase_unit_id))//如果有发货门店，则显示发货门店信息
{
storeId = orderList[0].purchase_unit_id;
}
TInoutBLL tInoutBll = new TInoutBLL(this.CurrentUserInfo);
//string storeName = tInoutBll.GetStoreName(storeId);
DataSet storeDs = tInoutBll.GetStoreInfo(storeId);
rd.OrderListInfo.StoreID = storeId;
#endregion
//配送商
string carrierId = orderList[0].carrier_id;
//DataSet carrierDs = tInoutBll.GetStoreInfo(carrierId);
//if (carrierDs.Tables[0].Rows.Count > 0)
//{
// rd.OrderListInfo.CarrierID = carrierId;
// rd.OrderListInfo.CarrierName = carrierDs.Tables[0].Rows[0]["unit_name"].ToString();
//}
if (!string.IsNullOrEmpty(carrierId))
{
//配送方式 1.送货到家;2.到店提货
if (deliveryId == "1")
{
var logisticsCompanyBLL = new T_LogisticsCompanyBLL(this.CurrentUserInfo);
Guid m_carrierId = Guid.Parse(carrierId);
var logCompInfo = logisticsCompanyBLL.GetByID(m_carrierId);
if (logCompInfo != null)
{
rd.OrderListInfo.CarrierID = carrierId;
rd.OrderListInfo.CarrierName = logCompInfo.LogisticsName;
}
}
else if (deliveryId == "2")
{
var unitBLL = new t_unitBLL(this.CurrentUserInfo);
var unitInfo = unitBLL.GetByID(carrierId);
if (unitInfo != null)
{
rd.OrderListInfo.CarrierID = carrierId;
rd.OrderListInfo.CarrierName = unitInfo.unit_name;
}
}
else if (deliveryId == "4")
{
var unitBLL = new t_unitBLL(this.CurrentUserInfo);
var unitInfo = unitBLL.GetByID(carrierId);
if (unitInfo != null)
{
rd.OrderListInfo.CarrierID = carrierId;
rd.OrderListInfo.CarrierName = unitInfo.unit_name;
}
}
}
rd.OrderListInfo.CourierNumber = orderList[0].Field2; //配送单号
rd.OrderListInfo.Invoice = orderList[0].Field19 == null ? "" : orderList[0].Field19; //发票信息
if (vipList.Count() > 0)
{
rd.OrderListInfo.VipID = vipList[0].VIPID;
rd.OrderListInfo.Phone = vipList[0].Phone;
rd.OrderListInfo.UserName = vipList[0].VipName;
rd.OrderListInfo.VipRealName = vipList[0].VipRealName;
rd.OrderListInfo.VipLevelDesc = vipList[0].VipLevelDesc;
rd.OrderListInfo.VipCode = vipList[0].VipCode;
rd.OrderListInfo.Email = vipList[0].Email;
rd.OrderListInfo.VipLevel = Convert.ToInt32(vipList[0].VipLevel);
}
if (storeDs.Tables[0].Rows.Count > 0)
{
rd.OrderListInfo.StoreName = storeDs.Tables[0].Rows[0]["unit_name"].ToString();
rd.OrderListInfo.StoreAddress = storeDs.Tables[0].Rows[0]["unit_address"].ToString();
rd.OrderListInfo.StoreTel = storeDs.Tables[0].Rows[0]["unit_tel"].ToString();
}
if (orderList.Count() > 0)
{
rd.OrderListInfo.discount_rate = orderList[0].discount_rate ?? 100;//订单折扣
rd.OrderListInfo.OrderID = orderList[0].order_id;
rd.OrderListInfo.OrderCode = orderList[0].order_no;
rd.OrderListInfo.OrderDate = orderList[0].order_date;
rd.OrderListInfo.ReceiverName = orderList[0].Field14; //收件人
rd.OrderListInfo.TotalQty = Convert.ToDecimal(orderList[0].total_qty);
string TotalAmount = String.Format("{0:F}", orderList[0].total_amount ?? 0);
rd.OrderListInfo.TotalAmount = TotalAmount;
rd.OrderListInfo.Total_Retail = Convert.ToDecimal(orderList[0].total_retail);
rd.OrderListInfo.Remark = orderList[0].remark;
rd.OrderListInfo.Status = orderList[0].status;
rd.OrderListInfo.OrderStatus = int.Parse(orderList[0].Field7);
rd.OrderListInfo.StatusDesc = orderList[0].status_desc;
rd.OrderListInfo.DeliveryAddress = orderList[0].Field4;
rd.OrderListInfo.DeliveryTime = orderList[0].Field9;
rd.OrderListInfo.ClinchTime = orderList[0].create_time;
rd.OrderListInfo.ReceiptTime = orderList[0].accpect_time;
rd.OrderListInfo.CouponsPrompt = orderList[0].Field16;
rd.OrderListInfo.DeliveryID = orderList[0].Field8;
rd.OrderListInfo.IsPayment = orderList[0].Field1;
rd.OrderListInfo.ReceivePoints = orderList[0].receive_points;
rd.OrderListInfo.PaymentTime = orderList[0].Field1 == "1" ? orderList[0].complete_date : null;
rd.OrderListInfo.OrderReasonTypeId = orderList[0].order_reason_id;
rd.OrderListInfo.ActualDecimal = orderList[0].actual_amount ?? 0;
rd.OrderListInfo.PaymentTypeCode = orderList[0].Payment_Type_Code;
rd.OrderListInfo.PaymentTypeName = orderList[0].Payment_Type_Name;
rd.OrderListInfo.ReserveTime = orderList[0].reserveDay + " " + orderList[0].reserveQuantum;
var deliveryBll = new TOrderCustomerDeliveryStrategyMappingBLL(this.CurrentUserInfo);
rd.OrderListInfo.DeliveryAmount = deliveryBll.GetDeliverAmount(orderId); //配送费 add by henry***
if (!string.IsNullOrEmpty(orderList[0].Field15) && orderList[0].Field15 != "0") //是否是团购商品 add by Henry 2014-12-22
{
rd.OrderListInfo.IsEvent = 1; //团购商品
}
else
{
rd.OrderListInfo.IsEvent = 0; //普通商品
}
#region update by changjian.tian
rd.OrderListInfo.Mobile = orderList[0].Field6; //配送联系电话
rd.OrderListInfo.DeliveryRemark = orderList[0].remark;
rd.OrderListInfo.IsEvaluation = orderList[0].IsEvaluation == null ? 0 : orderList[0].IsEvaluation.Value;//评论
#endregion
}
if (deliverList.Count() > 0)
{
rd.OrderListInfo.DeliveryName = deliverList[0].DeliveryName;
}
T_Inout_DetailBLL orderDetailBll = new T_Inout_DetailBLL(this.CurrentUserInfo);
//退换货Bll实例化
T_SalesReturnBLL salesReturnBll = new T_SalesReturnBLL(this.CurrentUserInfo);
var orderDetailList = orderDetailBll.QueryByEntity(new T_Inout_DetailEntity()
{
order_id = orderId
}, null);
var inoutService = new InoutService(this.CurrentUserInfo);
#region 根据订单ID获取订单明细
var ds = inoutService.GetOrderDetailByOrderId(orderId);
#endregion
#region 获取订单详细列表中的商品规格
var ggDs = inoutService.GetInoutDetailGgByOrderId(orderId);
#endregion
if (ds.Tables[0].Rows.Count > 0)
{
string ItemIdList =
ds.Tables[0].AsEnumerable().Aggregate("", (x, j) =>
{
x += string.Format("'{0}',", j["item_id"].ToString());
return(x);
}).Trim(',');
TInoutDetailBLL tInoutDetailBll = new TInoutDetailBLL(this.CurrentUserInfo);
//获取商品的图片
DataSet imageDs = tInoutDetailBll.GetOrderDetailImageList(ItemIdList);
var tmp = ds.Tables[0].AsEnumerable().Select(t => new OrderDetailEntity()
{
ItemID = t["item_id"].ToString(),
ItemName = t["item_name"].ToString(),
SkuID = t["sku_id"].ToString(),
SalesReturnFlag = salesReturnBll.CheckSalesReturn(orderId, t["sku_id"].ToString()),//是否可申请退换货
//GG = t["prop_1_detail_name"].ToString()+t["prop_2_detail_name"].ToString()+t["prop_3_detail_name"].ToString()
//+t["prop_4_detail_name"].ToString()+t["prop_5_detail_name"].ToString(),
Field9 = t["Field9"].ToString(),
isGB = Convert.ToInt32(t["isGB"]),
GG =
ggDs.Tables[0].AsEnumerable()
.Where(tt => tt["sku_id"].ToString() == t["sku_id"].ToString())
.Select(tt => new GuiGeInfo
{
PropName1 = tt["prop_1_name"].ToString(),
PropDetailName1 = tt["prop_1_detail_name"].ToString(),
PropName2 = tt["prop_2_name"].ToString(),
PropDetailName2 = tt["prop_2_detail_name"].ToString(),
PropName3 = tt["prop_3_name"].ToString(),
PropDetailName3 = tt["prop_3_detail_name"].ToString(),
PropName4 = tt["prop_4_name"].ToString(),
PropDetailName4 = tt["prop_4_detail_name"].ToString(),
PropName5 = tt["prop_5_name"].ToString(),
PropDetailName5 = tt["prop_5_detail_name"].ToString()
}).FirstOrDefault(),
SalesPrice = Convert.ToDecimal(t["enter_price"]),
//DiscountRate = Convert.ToDecimal(t["discount_rate"]),
DiscountRate = Convert.ToDecimal(t["order_discount_rate"]),
ItemCategoryName = t["itemCategoryName"].ToString(),
BeginDate = t["Field1"].ToString(),
EndDate = t["Field2"].ToString(),
DayCount = Convert.ToInt32(t["DayCount"]),
Qty = Convert.ToDecimal(t["enter_qty"]),
ImageInfo =
imageDs.Tables[0].AsEnumerable()
.Where(c => c["ObjectId"].ToString() == t["item_id"].ToString())
.OrderBy(c => c["displayIndex"])
.Select(c => new OrderDetailImage
{
ImageID = c["imageId"].ToString(),
ImageUrl = ImagePathUtil.GetImagePathStr(c["imageUrl"].ToString(), "240")
}).ToArray(),
IfService = Convert.ToInt32(t["IfService"])
});
int tempCount = 0;
foreach (var i in tmp)
{
if (i.IfService == 0)
{
tempCount++;
}
}
if (tempCount == 0)
{
rd.OrderListInfo.IsAllService = 3; // 3-全部为虚拟商品
}
else if (tempCount == tmp.Count())
{
rd.OrderListInfo.IsAllService = 1; // 1-全部为实物商品
}
else
{
rd.OrderListInfo.IsAllService = 2; // 2-包含实物商品和虚拟商品
}
#region 根据商品获取配送方式
var deliveryIds = new List <int?>();
if (rd.OrderListInfo.IsAllService == 3)
{
deliveryIds.Add(1);
deliveryIds.Add(2);
deliveryIds.Add(4);
rd.OrderListInfo.CanUseDeliveryIDs = deliveryIds;
}
else
{
T_Item_Delivery_MappingBLL mappingBll = new T_Item_Delivery_MappingBLL(this.CurrentUserInfo);
var complexCondition = new List <IWhereCondition> {
};
var itemIdArray = ItemIdList.Replace("'", "").Split(',');
complexCondition.Add(new InCondition <string>()
{
FieldName = "Item_Id", Values = itemIdArray
});
var itemDeliveryList = mappingBll.Query(complexCondition.ToArray(), null);
bool needAddDelivery4 = false;
bool needAddDelivery2 = false;
if (itemDeliveryList.ToList().Find(d => d.DeliveryId == 4) != null)
{
needAddDelivery4 = true;
}
else
{
if (itemDeliveryList.ToList().Find(d => d.DeliveryId == 2) != null)
{
needAddDelivery2 = true;
}
}
var itemDeliveryGroupList = itemDeliveryList.GroupBy(d => d.Item_Id);
var index = 0;
foreach (var info in itemDeliveryGroupList)
{
var tmpList = info.ToList <T_Item_Delivery_MappingEntity>(); //分组后的集合
if (index == 0)
{
deliveryIds.AddRange(tmpList.Select(d => d.DeliveryId));
index++;
continue;
}
deliveryIds = deliveryIds.Intersect(tmpList.Select(d => d.DeliveryId)).ToList();
if (deliveryIds.Count <= 0)
{
break; // 后面的不用求了
}
index++;
}
if (!deliveryIds.Contains(4) && needAddDelivery4)
{
deliveryIds.Add(4);
}
if (!deliveryIds.Contains(2) && needAddDelivery2)
{
deliveryIds.Add(2);
}
rd.OrderListInfo.CanUseDeliveryIDs = deliveryIds.OrderBy(t => t.Value).ToList();
}
#endregion
rd.OrderListInfo.OrderDetailInfo = tmp.ToArray();
}
var vipIntegralDetailBll = new VipIntegralDetailBLL(this.CurrentUserInfo);
// var integral = vipIntegralDetailBll.GetVipIntegralByOrder(orderId, pRequest.UserID);
//使用积分
rd.OrderListInfo.OrderIntegral = Math.Abs(vipIntegralDetailBll.GetVipIntegralByOrder(orderId, vipNo));
//积分抵扣金额 add by Henry 2014-10-8
//decimal integralAmountPre = vipBll.GetIntegralAmountPre(this.CurrentUserInfo.ClientID);//获取积分金额比例
//rd.OrderListInfo.UseIntegralToAmount =rd.OrderListInfo.OrderIntegral*(integralAmountPre>0?integralAmountPre:0.01M);
rd.OrderListInfo.UseIntegralToAmount = vipBll.GetAmountByIntegralPer(CurrentUserInfo.ClientID, rd.OrderListInfo.OrderIntegral);
var couponUseBll = new CouponUseBLL(this.CurrentUserInfo);
var couponParValue = couponUseBll.GetCouponParValue(orderId);
rd.OrderListInfo.CouponAmount = couponParValue;
var vipAmountDetailBll = new VipAmountDetailBLL(this.CurrentUserInfo);
//使用的账户余额
rd.OrderListInfo.VipEndAmount = Math.Abs(vipAmountDetailBll.GetVipAmountByOrderId(orderId, vipNo, 1));
//使用余额，将余额从实付款中分开
if (rd.OrderListInfo.VipEndAmount != 0)
{
rd.OrderListInfo.ActualDecimal = rd.OrderListInfo.ActualDecimal - rd.OrderListInfo.VipEndAmount;
}
//使用的返现金额
rd.OrderListInfo.ReturnAmount = Math.Abs(vipAmountDetailBll.GetVipAmountByOrderId(orderId, vipNo, 13));
//使用阿拉币和阿拉币抵扣 add by Henry 2014-10-13
if (pRequest.ChannelId == "4")//阿拉丁APP调用
{
decimal aldAmount = Math.Abs(vipAmountDetailBll.GetVipAmountByOrderId(orderId, vipNo, 11));
rd.OrderListInfo.ALDAmount = aldAmount;
rd.OrderListInfo.ALDAmountMoney = aldAmount * 0.01M;
}
#region 获取订单积分，优惠券金额，使用余额
//var vipIntegralDetailBll = new VipIntegralDetailBLL(this.CurrentUserInfo);
//var vipIntegralList = vipIntegralDetailBll.QueryByEntity(new VipIntegralDetailEntity()
//{
// VIPID = pRequest.UserID,
// ObjectId = orderId
//}, null);
//if (vipIntegralList != null && vipIntegralList.Length > 0)
//{
// rd.OrderListInfo.OrderIntegral = Math.Abs(vipIntegralList[0].Integral??0);
//}
//var tOrderCouponMappingBll = new TOrderCouponMappingBLL(this.CurrentUserInfo);
//var tOrderCouponMappingList = tOrderCouponMappingBll.QueryByEntity(new TOrderCouponMappingEntity()
//{
// OrderId = orderId
//}, null);
//if (tOrderCouponMappingList != null && tOrderCouponMappingList.Length > 0)
//{
// var couponId = tOrderCouponMappingList[0].CouponId;
// var couponBll = new CouponBLL(this.CurrentUserInfo);
// var couponEntity = couponBll.GetByID(couponId);
// if (couponEntity != null)
// {
// var couponTypeId = couponEntity.CouponTypeID;
// var couponTypeBll = new CouponTypeBLL(this.CurrentUserInfo);
// var couponTypeEntity = couponTypeBll.GetByID(couponTypeId);
// if (couponTypeEntity != null)
// {
// rd.OrderListInfo.CouponAmount = couponTypeEntity.ParValue ?? 0;
// }
// }
//}
//var vipAmountDetailBll = new VipAmountDetailBLL(this.CurrentUserInfo);
//var vipAmountDetailList = vipAmountDetailBll.QueryByEntity(new VipAmountDetailEntity()
//{
// VipId = pRequest.UserID,
// ObjectId = orderId
//}, null);
//if (vipAmountDetailList != null && vipAmountDetailList.Length > 0)
//{
// rd.OrderListInfo.VipEndAmount = Math.Abs(vipAmountDetailList[0].Amount ?? 0);
//}
#endregion
return(rd);
}