internal void Delete(VipIntegralEntity dbEntity)
{
using (var conn = new SqlConnection(ConnectionString.XgxInsert))
{
conn.Open();
conn.Delete(dbEntity);
}
}
internal void Create(VipIntegralEntity dbEntity)
{
using (var conn = new SqlConnection(ConnectionString.XgxInsert))
{
dbEntity.CreateTime = System.DateTime.Now;
dbEntity.LastUpdateTime = System.DateTime.Now;
//dbEntity.CreateBy = "ERP";
conn.Open();
conn.Insert(dbEntity);
}
}
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);
}
public void Deal(AmountIntergralContract contract)
{
var vipIntegralFacade = new VipIntegralFacade();
var vipIntegralDetailFacade = new VipIntegralDetailFacade();
var vipAmountFacade = new VipAmountFacade();
var vipAmountDetailFacade = new VipAmountDetailFacade();
var vipCardVipMappingFacade = new VipCardVipMappingFacade();
var vipIntegralDetailEntity = ConvertToVipIntegralDetailEntity(contract);
var vipAmountDetailEntity = ConvertToVipAmountDetailEntity(contract);
switch (contract.Operation)
{
case OptEnum.Create:
if (contract.VipIntegral != 0)
{
vipIntegralDetailFacade.Create(vipIntegralDetailEntity);
if (vipIntegralFacade.GetVipIntegralCountByVipId(contract.VipId) == 0)
{
var vipIntegral = new VipIntegralEntity
{
VipID = contract.VipId,
VipCardCode = vipCardVipMappingFacade.GetVipCardCodeByVipId(contract.VipId),
BeginIntegral = contract.VipIntegral,
InIntegral = contract.VipIntegral,
OutIntegral = 0,
EndIntegral = contract.VipIntegral,
InvalidIntegral = 0,
ImminentInvalidIntegral = 0,
ValidIntegral = contract.VipIntegral,
CumulativeIntegral = contract.VipIntegral,
CustomerID = ConfigMgr.CustomerId,
CreateTime = contract.CreateTime == null ? DateTime.Now : contract.CreateTime,
CreateBy = "xgx",
LastUpdateBy = "xgx",
LastUpdateTime = contract.ModifyTime == null ? DateTime.Now : contract.ModifyTime,
IsDelete = 0
};
vipIntegralFacade.Create(vipIntegral);
}
else
{
vipIntegralFacade.UpdateVipIntegral(contract.VipId, contract.VipIntegral);
}
}
if (contract.VipAmount != 0)
{
vipAmountDetailFacade.Create(vipAmountDetailEntity);
if (vipAmountFacade.GetVipAmountCountByVipId(contract.VipId) == 0)
{
var vipAmount = new VipAmountEntity
{
VipId = contract.VipId,
VipCardCode = vipCardVipMappingFacade.GetVipCardCodeByVipId(contract.VipId),
BeginAmount = contract.VipAmount,
InAmount = contract.VipAmount,
OutAmount = 0,
EndAmount = contract.VipAmount,
TotalAmount = contract.VipAmount,
BeginReturnAmount = 0,
ReturnAmount = 0,
InReturnAmount = 0,
OutReturnAmount = 0,
ImminentInvalidRAmount = 0,
InvalidReturnAmount = 0,
ValidReturnAmount = 0,
TotalReturnAmount = 0,
CustomerID = ConfigMgr.CustomerId,
CreateTime = contract.CreateTime == null ? DateTime.Now : contract.CreateTime,
CreateBy = "xgx",
LastUpdateBy = "xgx",
LastUpdateTime = contract.ModifyTime == null ? DateTime.Now : contract.ModifyTime,
IsDelete = 0,
IsLocking = 0
};
vipAmountFacade.Create(vipAmount);
}
else
{
vipAmountFacade.UpdateVipAmount(contract.VipId, contract.VipAmount);
}
}
break;
case OptEnum.Update:
break;
case OptEnum.Delete:
break;
}
}
/// <summary>
/// 创建一个新实例
/// </summary>
/// <param name="pEntity">实体实例</param>
public void Create(VipIntegralEntity pEntity)
{
_currentDAO.Create(pEntity);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="pEntity">实体实例</param>
/// <param name="pTran">事务实例,可为null,如果为null,则不使用事务来更新</param>
public void Update(VipIntegralEntity pEntity, IDbTransaction pTran)
{
_currentDAO.Update(pEntity, pTran);
}
/// <summary>
/// 根据实体条件查询实体
/// </summary>
/// <param name="pQueryEntity">以实体形式传入的参数</param>
/// <param name="pOrderBys">排序组合</param>
/// <returns>符合条件的实体集</returns>
public VipIntegralEntity[] QueryByEntity(VipIntegralEntity pQueryEntity, OrderBy[] pOrderBys)
{
return(_currentDAO.QueryByEntity(pQueryEntity, pOrderBys));
}
/// <summary>
/// 分页根据实体条件查询实体
/// </summary>
/// <param name="pQueryEntity">以实体形式传入的参数</param>
/// <param name="pOrderBys">排序组合</param>
/// <returns>符合条件的实体集</returns>
public PagedQueryResult <VipIntegralEntity> PagedQueryByEntity(VipIntegralEntity pQueryEntity, OrderBy[] pOrderBys, int pPageSize, int pCurrentPageIndex)
{
return(_currentDAO.PagedQueryByEntity(pQueryEntity, pOrderBys, pPageSize, pCurrentPageIndex));
}
/// <summary>
/// 更新
/// </summary>
/// <param name="pEntity">实体实例</param>
public void Update(VipIntegralEntity pEntity)
{
_currentDAO.Update(pEntity);
}
/// <summary>
/// 删除
/// </summary>
/// <param name="pEntity"></param>
public void Delete(VipIntegralEntity pEntity)
{
_currentDAO.Delete(pEntity);
}
public void setJiKeGift(string UserID, string vipID)
{
//如果扫码用户有上线会员就不给扫码奖励。
VipDAO vipDao = new VipDAO(loggingSessionInfo);
var vip = vipDao.QueryByEntity(
new VipEntity()
{
VIPID = vipID
},
null
).FirstOrDefault();
if (vip != null && !string.IsNullOrWhiteSpace(vip.CouponInfo))
{
Loggers.Debug(new DebugLogInfo()
{
Message = "集客反还积分:返回"
});
return;
}
////查询集客奖励设置
//int GiftIntegral = 0;
//CustomerBasicSettingDAO CustomerBasicSettingDao = new CustomerBasicSettingDAO(loggingSessionInfo);
//CustomerBasicSettingEntity CustomerBasicSettingEntity = CustomerBasicSettingDao.GetBasicSettings(UserID, "GetVipIntegral").FirstOrDefault();
//if (CustomerBasicSettingEntity!=null&&!string.IsNullOrWhiteSpace(CustomerBasicSettingEntity.SettingValue))
//{
// int.TryParse(CustomerBasicSettingEntity.SettingValue, out GiftIntegral);
//}
//if (GiftIntegral == 0)
//{
// GiftIntegral = 100;
//}
////积分换算为金额
//decimal GiftAmount = GiftIntegral / 100;
////保存
//VipAmountDAO VipAmountDao = new VipAmountDAO(loggingSessionInfo);
//VipAmountDetailDAO VipAmountDetailDao = new VipAmountDetailDAO(loggingSessionInfo);
//VipAmountEntity amountEntity = VipAmountDao.QueryByEntity(
// new VipAmountEntity()
// {
// VipId = UserID
// }
// , null
// ).FirstOrDefault();
//if (amountEntity==null)
//{
// VipAmountDao.Create(
// new VipAmountEntity(){
// VipId = UserID,
// BeginAmount = 0,
// EndAmount = GiftAmount,
// InAmount = GiftAmount,
// OutAmount = 0,
// IsLocking =0,
// TotalAmount = GiftAmount
// }
// );
//}
//else
//{
// try
// {
// Loggers.Debug(new DebugLogInfo()
// {
// Message = "集客反积分:" + "集客信息有" + amountEntity.TotalAmount == null ? "00000" : amountEntity.TotalAmount.ToString()
// });
// amountEntity.TotalAmount = amountEntity.TotalAmount + GiftAmount;
// amountEntity.InAmount = amountEntity.InAmount + GiftAmount;
// amountEntity.EndAmount = amountEntity.EndAmount + GiftAmount;
// VipAmountDao.Update(amountEntity);
// }
// catch (Exception ex)
// {
// Loggers.Debug(new DebugLogInfo()
// {
// Message = "集客反还积分:" + ex.Message.ToString()
// }); ;
// }
//}
//VipAmountDetailDao.Create(
// new VipAmountDetailEntity(){
// VipAmountDetailId = Guid.NewGuid(),
// VipId = UserID,
// Amount = GiftAmount,
// AmountSourceId = "12",
// ObjectId = string.Empty,
// Remark ="集客反积分兑换为余额"
// }
//);
//查询集客奖励设置
int GiftIntegral = 0;
CustomerBasicSettingDAO CustomerBasicSettingDao = new CustomerBasicSettingDAO(loggingSessionInfo);
CustomerBasicSettingEntity CustomerBasicSettingEntity = CustomerBasicSettingDao.GetBasicSettings(UserID, "GetVipIntegral").FirstOrDefault();
if (CustomerBasicSettingEntity != null && !string.IsNullOrWhiteSpace(CustomerBasicSettingEntity.SettingValue))
{
int.TryParse(CustomerBasicSettingEntity.SettingValue, out GiftIntegral);
}
if (GiftIntegral == 0)
{
GiftIntegral = 100;
}
Loggers.Debug(new DebugLogInfo()
{
Message = "集客反还积分:得到积分" + GiftIntegral.ToString()
});
//保存
VipIntegralDAO VipIntegralDao = new VipIntegralDAO(loggingSessionInfo);
VipIntegralDetailDAO vipIntegralDetailDao = new VipIntegralDetailDAO(loggingSessionInfo);
VipIntegralEntity integralEntity = VipIntegralDao.QueryByEntity(
new VipIntegralEntity()
{
VipID = UserID
}
, null
).FirstOrDefault();
if (integralEntity == null)
{
VipIntegralDao.Create(
new VipIntegralEntity()
{
VipID = UserID,
BeginIntegral = GiftIntegral,
InIntegral = GiftIntegral,
OutIntegral = 0,
EndIntegral = GiftIntegral,
InvalidIntegral = 0,
ValidIntegral = 0,
IsDelete = 0
}
);
}
else
{
try
{
Loggers.Debug(new DebugLogInfo()
{
Message = "集客反积分:" + "集客信息有" + integralEntity.EndIntegral == null ? "00000" : integralEntity.EndIntegral.ToString()
});
integralEntity.BeginIntegral += GiftIntegral;
integralEntity.InvalidIntegral += GiftIntegral;
integralEntity.EndIntegral += GiftIntegral;
VipIntegralDao.Update(integralEntity);
}
catch (Exception ex)
{
Loggers.Debug(new DebugLogInfo()
{
Message = "集客反还积分:" + ex.Message.ToString()
});
}
}
try
{
vipIntegralDetailDao.Create(
new VipIntegralDetailEntity()
{
VipIntegralDetailID = Guid.NewGuid().ToString().Replace("-", ""),
VIPID = UserID,
SalesAmount = 0,
Integral = GiftIntegral,
IntegralSourceID = "25",
IsDelete = 0
}
);
}
catch (Exception ex)
{
Loggers.Debug(new DebugLogInfo()
{
Message = "集客反还积分:" + ex.Message.ToString()
});
}
}
public void Create(VipIntegralEntity dbEntity)
{
_cmd.Create(dbEntity);
}
public void Delete(VipIntegralEntity dbEntity)
{
_cmd.Delete(dbEntity);
}
public void Update(VipIntegralEntity dbEntity)
{
_cmd.Update(dbEntity);
}
/// <summary>
/// 验证真伪得积分
/// </summary>
public string SetCheckReal()
{
string content = string.Empty;
var respData = new SetCheckRealRespData();
try
{
string openId = Request["openID"];
//openId = "o8Y7Ejl1zl5RHXDvPONCNqoC5Md8";
Loggers.Debug(new DebugLogInfo()
{
Message = string.Format(
"OpenID:{0}", openId)
});
var currentUser = Default.GetLoggingSession();
VipBLL vipBLL = new VipBLL(currentUser);
IntegralRuleBLL integralRuleBLL = new IntegralRuleBLL(currentUser);
VipIntegralDetailBLL vipIntegralDetailBLL = new VipIntegralDetailBLL(currentUser);
VipIntegralBLL vipIntegralBLL = new VipIntegralBLL(currentUser);
string vipId = null;
if (true)
{
VipEntity vipIdData = null;
var vipIdDataList = vipBLL.QueryByEntity(new VipEntity()
{
WeiXinUserId = openId
}, null);
if (vipIdDataList == null || vipIdDataList.Length == 0 || vipIdDataList[0] == null ||
vipIdDataList[0].VIPID == null)
{
respData.Code = "103";
respData.Description = "数据库操作错误";
respData.Exception = "未查询到Vip会员";
return(respData.ToJSON());
}
else
{
vipIdData = vipIdDataList[0];
vipId = vipIdData.VIPID;
}
}
// SysIntegralSource: 10
string integralSourceId = "10";
int integralValue = 0;
if (true)
{
IntegralRuleEntity integralRuleData = null;
var integralRuleDataList = integralRuleBLL.QueryByEntity(new IntegralRuleEntity()
{
IntegralSourceID = integralSourceId
}, null);
if (integralRuleDataList == null || integralRuleDataList.Length == 0 || integralRuleDataList[0] == null)
{
respData.Code = "103";
respData.Description = "数据库操作错误";
respData.Exception = "未查询到积分规则";
return(respData.ToJSON());
}
else
{
integralRuleData = integralRuleDataList[0];
integralValue = int.Parse(integralRuleData.Integral);
}
}
#region 保存积分
if (true)
{
string tmpVipId = vipId;
int tmpIntegralValue = integralValue;
string tmpIntegralSourceId = integralSourceId;
string tmpOpenId = openId;
string msgModel = "【验真品，送积分】活动，您本次验证赢得{0}点积分。您当前的总积分是{1}点。";
// 插入积分明细
VipIntegralDetailEntity vipIntegralDetailEntity = new VipIntegralDetailEntity();
vipIntegralDetailEntity.VipIntegralDetailID = CPOS.Common.Utils.NewGuid();
vipIntegralDetailEntity.VIPID = tmpVipId;
vipIntegralDetailEntity.FromVipID = tmpVipId;
vipIntegralDetailEntity.SalesAmount = 0;
vipIntegralDetailEntity.Integral = tmpIntegralValue;
vipIntegralDetailEntity.IntegralSourceID = tmpIntegralSourceId;
vipIntegralDetailEntity.IsAdd = 1;
//vipIntegralDetailBLL.Create(vipIntegralDetailEntity);
// 更新积分
VipIntegralEntity vipIntegralEntity = new VipIntegralEntity();
var vipIntegralDataList = vipIntegralBLL.QueryByEntity(
new VipIntegralEntity()
{
VipID = vipId
}, null);
if (vipIntegralDataList == null || vipIntegralDataList.Length == 0 || vipIntegralDataList[0] == null)
{
vipIntegralEntity.VipID = tmpVipId;
vipIntegralEntity.BeginIntegral = 0; // 期初积分
vipIntegralEntity.InIntegral = tmpIntegralValue; // 增加积分
vipIntegralEntity.OutIntegral = 0; //消费积分
vipIntegralEntity.EndIntegral = tmpIntegralValue; //积分余额
vipIntegralEntity.InvalidIntegral = 0; // 累计失效积分
vipIntegralEntity.ValidIntegral = tmpIntegralValue; // 当前有效积分
//vipIntegralBLL.Create(vipIntegralEntity);
}
else
{
vipIntegralEntity.VipID = tmpVipId;
vipIntegralEntity.InIntegral = vipIntegralDataList[0].InIntegral + tmpIntegralValue;; // 增加积分
//vipIntegralEntity.OutIntegral = 0; //消费积分
vipIntegralEntity.EndIntegral = vipIntegralDataList[0].EndIntegral + tmpIntegralValue; //积分余额
//vipIntegralEntity.InvalidIntegral = 0; // 累计失效积分
vipIntegralEntity.ValidIntegral = vipIntegralDataList[0].ValidIntegral + tmpIntegralValue; // 当前有效积分
//vipIntegralBLL.Update(vipIntegralEntity, false);
}
// 更新VIP
VipEntity vipEntity = new VipEntity();
var vipEntityDataList = vipBLL.QueryByEntity(
new VipEntity()
{
VIPID = tmpVipId
}, null);
if (vipEntityDataList == null || vipEntityDataList.Length == 0 || vipEntityDataList[0] == null)
{
vipEntity.VIPID = tmpVipId;
vipEntity.Integration = vipIntegralEntity.ValidIntegral;
//vipEntity.HigherVipID = highOpenId;
vipEntity.ClientID = currentUser.CurrentUser.customer_id;
vipEntity.Status = 1;
vipBLL.Create(vipEntity);
}
else
{
vipEntity.VIPID = tmpVipId;
vipEntity.Integration = vipIntegralEntity.ValidIntegral;
//vipEntity.HigherVipID = highOpenId;
vipEntity.ClientID = currentUser.CurrentUser.customer_id;
vipBLL.Update(vipEntity, false);
}
// 推送消息
string msgUrl = ConfigurationManager.AppSettings["push_weixin_msg_url"].Trim();
string msgText = string.Format(msgModel, tmpIntegralValue, vipEntity.Integration);
string msgData = "<xml><OpenID><![CDATA[" + tmpOpenId + "]]></OpenID><Content><![CDATA[" + msgText + "]]></Content></xml>";
var msgResult = Common.Utils.GetRemoteData(msgUrl, "POST", msgData);
Loggers.Debug(new DebugLogInfo()
{
Message = string.Format("PushMsgResult:{0}", msgResult)
});
respData.Data = tmpIntegralValue.ToString();
}
#endregion
}
catch (Exception ex)
{
respData.Code = "103";
respData.Description = "数据库操作错误";
respData.Exception = ex.ToString();
}
content = respData.ToJSON();
return(content);
}
