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()
});
}
}
/// <summary>
/// 装载实体
/// </summary>
/// <param name="pReader">向前只读器</param>
/// <param name="pInstance">实体实例</param>
protected void Load(IDataReader pReader, out ObjectEvaluationEntity pInstance)
{
//将所有的数据从SqlDataReader中读取到Entity中
pInstance = new ObjectEvaluationEntity();
pInstance.PersistenceHandle = new PersistenceHandle();
pInstance.PersistenceHandle.Load();
if (pReader["EvaluationID"] != DBNull.Value)
{
pInstance.EvaluationID = Convert.ToString(pReader["EvaluationID"]);
}
if (pReader["ObjectID"] != DBNull.Value)
{
pInstance.ObjectID = Convert.ToString(pReader["ObjectID"]);
}
if (pReader["Type"] != DBNull.Value)
{
pInstance.Type = Convert.ToInt32(pReader["Type"]);
}
if (pReader["VipID"] != DBNull.Value)
{
pInstance.VipID = Convert.ToString(pReader["VipID"]);
var vipDao = new VipDAO(CurrentUserInfo);
var vipInfo = vipDao.GetByID(pInstance.VipID);
if (vipInfo != null)
{
pInstance.VipName = vipInfo.VipName;
pInstance.HeadImgUrl = vipInfo.HeadImgUrl;
}
}
if (pReader["CustomerID"] != DBNull.Value)
{
pInstance.CustomerID = Convert.ToString(pReader["CustomerID"]);
}
if (pReader["Content"] != DBNull.Value)
{
pInstance.Content = Convert.ToString(pReader["Content"]);
}
if (pReader["StarLevel"] != DBNull.Value)
{
pInstance.StarLevel = Convert.ToInt32(pReader["StarLevel"]);
}
if (pReader["StarLevel1"] != DBNull.Value)
{
pInstance.StarLevel1 = Convert.ToInt32(pReader["StarLevel1"]);
}
if (pReader["StarLevel2"] != DBNull.Value)
{
pInstance.StarLevel2 = Convert.ToInt32(pReader["StarLevel2"]);
}
if (pReader["StarLevel3"] != DBNull.Value)
{
pInstance.StarLevel3 = Convert.ToInt32(pReader["StarLevel3"]);
}
if (pReader["StarLevel4"] != DBNull.Value)
{
pInstance.StarLevel4 = Convert.ToInt32(pReader["StarLevel4"]);
}
if (pReader["StarLevel5"] != DBNull.Value)
{
pInstance.StarLevel5 = Convert.ToInt32(pReader["StarLevel5"]);
}
if (pReader["Platform"] != DBNull.Value)
{
pInstance.Platform = Convert.ToString(pReader["Platform"]);
}
if (pReader["CreateTime"] != DBNull.Value)
{
pInstance.CreateTime = Convert.ToDateTime(pReader["CreateTime"]);
}
if (pReader["CreateBy"] != DBNull.Value)
{
pInstance.CreateBy = Convert.ToString(pReader["CreateBy"]);
}
if (pReader["LastUpdateBy"] != DBNull.Value)
{
pInstance.LastUpdateBy = Convert.ToString(pReader["LastUpdateBy"]);
}
if (pReader["LastUpdateTime"] != DBNull.Value)
{
pInstance.LastUpdateTime = Convert.ToDateTime(pReader["LastUpdateTime"]);
}
if (pReader["IsDelete"] != DBNull.Value)
{
pInstance.IsDelete = Convert.ToInt32(pReader["IsDelete"]);
}
if (pReader["OrderID"] != DBNull.Value)
{
pInstance.OrderID = Convert.ToString(pReader["OrderID"]);
}
if (pReader["Remark"] != DBNull.Value)
{
pInstance.Remark = Convert.ToString(pReader["Remark"]);
}
if (pReader["IsAnonymity"] != DBNull.Value)
{
pInstance.IsAnonymity = Convert.ToInt32(pReader["IsAnonymity"]);
}
}
/// <summary>
/// 装载实体
/// </summary>
/// <param name="pReader">向前只读器</param>
/// <param name="pInstance">实体实例</param>
protected void Load(IDataReader pReader, out T_SalesReturnEntity pInstance)
{
//将所有的数据从SqlDataReader中读取到Entity中
pInstance = new T_SalesReturnEntity();
pInstance.PersistenceHandle = new PersistenceHandle();
pInstance.PersistenceHandle.Load();
if (pReader["SalesReturnID"] != DBNull.Value)
{
pInstance.SalesReturnID = (Guid)pReader["SalesReturnID"];
}
if (pReader["SalesReturnNo"] != DBNull.Value)
{
pInstance.SalesReturnNo = Convert.ToString(pReader["SalesReturnNo"]);
}
if (pReader["VipID"] != DBNull.Value)
{
pInstance.VipID = Convert.ToString(pReader["VipID"]);
var vipDao = new VipDAO(this.CurrentUserInfo);
var vipInfo = vipDao.GetByID(pInstance.VipID);
if (vipInfo != null)
{
pInstance.VipName = vipInfo.VipName;
}
}
if (pReader["ServicesType"] != DBNull.Value)
{
pInstance.ServicesType = Convert.ToInt32(pReader["ServicesType"]);
}
if (pReader["DeliveryType"] != DBNull.Value)
{
pInstance.DeliveryType = Convert.ToInt32(pReader["DeliveryType"]);
}
if (pReader["OrderID"] != DBNull.Value)
{
pInstance.OrderID = Convert.ToString(pReader["OrderID"]);
}
if (pReader["ItemID"] != DBNull.Value)
{
pInstance.ItemID = Convert.ToString(pReader["ItemID"]);
}
if (pReader["SkuID"] != DBNull.Value)
{
pInstance.SkuID = Convert.ToString(pReader["SkuID"]);
}
if (pReader["Qty"] != DBNull.Value)
{
pInstance.Qty = Convert.ToInt32(pReader["Qty"]);
}
if (pReader["ActualQty"] != DBNull.Value)
{
pInstance.ActualQty = Convert.ToInt32(pReader["ActualQty"]);
}
if (pReader["RefundAmount"] != DBNull.Value)
{
pInstance.RefundAmount = Convert.ToDecimal(pReader["RefundAmount"]);
}
if (pReader["ConfirmAmount"] != DBNull.Value)
{
pInstance.ConfirmAmount = Convert.ToDecimal(pReader["ConfirmAmount"]);
}
if (pReader["UnitID"] != DBNull.Value)
{
pInstance.UnitID = Convert.ToString(pReader["UnitID"]);
}
if (pReader["UnitName"] != DBNull.Value)
{
pInstance.UnitName = Convert.ToString(pReader["UnitName"]);
}
if (pReader["UnitTel"] != DBNull.Value)
{
pInstance.UnitTel = Convert.ToString(pReader["UnitTel"]);
}
if (pReader["Address"] != DBNull.Value)
{
pInstance.Address = Convert.ToString(pReader["Address"]);
}
if (pReader["Contacts"] != DBNull.Value)
{
pInstance.Contacts = Convert.ToString(pReader["Contacts"]);
}
if (pReader["Phone"] != DBNull.Value)
{
pInstance.Phone = Convert.ToString(pReader["Phone"]);
}
if (pReader["Reason"] != DBNull.Value)
{
pInstance.Reason = Convert.ToString(pReader["Reason"]);
}
if (pReader["Status"] != DBNull.Value)
{
pInstance.Status = Convert.ToInt32(pReader["Status"]);
}
if (pReader["CustomerID"] != DBNull.Value)
{
pInstance.CustomerID = Convert.ToString(pReader["CustomerID"]);
}
if (pReader["CreateTime"] != DBNull.Value)
{
pInstance.CreateTime = Convert.ToDateTime(pReader["CreateTime"]);
}
if (pReader["CreateBy"] != DBNull.Value)
{
pInstance.CreateBy = Convert.ToString(pReader["CreateBy"]);
}
if (pReader["LastUpdateTime"] != DBNull.Value)
{
pInstance.LastUpdateTime = Convert.ToDateTime(pReader["LastUpdateTime"]);
}
if (pReader["LastUpdateBy"] != DBNull.Value)
{
pInstance.LastUpdateBy = Convert.ToString(pReader["LastUpdateBy"]);
}
if (pReader["IsDelete"] != DBNull.Value)
{
pInstance.IsDelete = Convert.ToInt32(pReader["IsDelete"]);
}
//if (pReader["paymentcenter_id"] != DBNull.Value)
//{
// pInstance.paymentcenterId = Convert.ToString(pReader["paymentcenter_id"]);
//}
//if (pReader["Payment_Type_Name"] != DBNull.Value)
//{
// pInstance.PayTypeName = Convert.ToString(pReader["Payment_Type_Name"]);
//}
}
public VipInfoMaillBLL(LoggingSessionInfo pUserInfo)
{
this.CurrentUserInfo = pUserInfo;
this._currentDAO = new VipDAO(pUserInfo);
}
/// <summary>
/// 装载实体
/// </summary>
/// <param name="pReader">向前只读器</param>
/// <param name="pInstance">实体实例</param>
protected void Load(IDataReader pReader, out T_RefundOrderEntity pInstance)
{
//将所有的数据从SqlDataReader中读取到Entity中
pInstance = new T_RefundOrderEntity();
pInstance.PersistenceHandle = new PersistenceHandle();
pInstance.PersistenceHandle.Load();
if (pReader["RefundID"] != DBNull.Value)
{
pInstance.RefundID = (Guid)pReader["RefundID"];
}
if (pReader["SalesReturnID"] != DBNull.Value)
{
pInstance.SalesReturnID = (Guid)pReader["SalesReturnID"];
}
if (pReader["RefundNo"] != DBNull.Value)
{
pInstance.RefundNo = Convert.ToString(pReader["RefundNo"]);
}
if (pReader["VipID"] != DBNull.Value)
{
pInstance.VipID = Convert.ToString(pReader["VipID"]);
var vipDao = new VipDAO(this.CurrentUserInfo);
var vipInfo = vipDao.GetByID(pInstance.VipID);
if (vipInfo != null)
{
pInstance.VipName = vipInfo.VipName;
}
}
if (pReader["DeliveryType"] != DBNull.Value)
{
pInstance.DeliveryType = Convert.ToInt32(pReader["DeliveryType"]);
}
if (pReader["OrderID"] != DBNull.Value)
{
pInstance.OrderID = Convert.ToString(pReader["OrderID"]);
var inoutDAO = new T_InoutDAO(CurrentUserInfo);
var inoutInfo = inoutDAO.GetByID(pInstance.OrderID);
if (inoutInfo != null)
{
pInstance.OrderNo = inoutInfo.order_no; //订单号
pInstance.PayOrderID = inoutInfo.paymentcenter_id; //支付回调标识,商户单号
}
}
if (pReader["ItemID"] != DBNull.Value)
{
pInstance.ItemID = Convert.ToString(pReader["ItemID"]);
}
if (pReader["SkuID"] != DBNull.Value)
{
pInstance.SkuID = Convert.ToString(pReader["SkuID"]);
}
if (pReader["Qty"] != DBNull.Value)
{
pInstance.Qty = Convert.ToInt32(pReader["Qty"]);
}
if (pReader["ActualQty"] != DBNull.Value)
{
pInstance.ActualQty = Convert.ToInt32(pReader["ActualQty"]);
}
if (pReader["UnitID"] != DBNull.Value)
{
pInstance.UnitID = Convert.ToString(pReader["UnitID"]);
}
if (pReader["UnitName"] != DBNull.Value)
{
pInstance.UnitName = Convert.ToString(pReader["UnitName"]);
}
if (pReader["UnitTel"] != DBNull.Value)
{
pInstance.UnitTel = Convert.ToString(pReader["UnitTel"]);
}
if (pReader["Address"] != DBNull.Value)
{
pInstance.Address = Convert.ToString(pReader["Address"]);
}
if (pReader["Contacts"] != DBNull.Value)
{
pInstance.Contacts = Convert.ToString(pReader["Contacts"]);
}
if (pReader["Phone"] != DBNull.Value)
{
pInstance.Phone = Convert.ToString(pReader["Phone"]);
}
if (pReader["RefundAmount"] != DBNull.Value)
{
pInstance.RefundAmount = Convert.ToDecimal(pReader["RefundAmount"]);
}
if (pReader["ConfirmAmount"] != DBNull.Value)
{
pInstance.ConfirmAmount = Convert.ToDecimal(pReader["ConfirmAmount"]);
}
if (pReader["ActualRefundAmount"] != DBNull.Value)
{
pInstance.ActualRefundAmount = Convert.ToDecimal(pReader["ActualRefundAmount"]);
}
if (pReader["Points"] != DBNull.Value)
{
pInstance.Points = Convert.ToInt32(pReader["Points"]);
}
if (pReader["PointsAmount"] != DBNull.Value)
{
pInstance.PointsAmount = Convert.ToDecimal(pReader["PointsAmount"]);
}
if (pReader["ReturnAmount"] != DBNull.Value)
{
pInstance.ReturnAmount = Convert.ToDecimal(pReader["ReturnAmount"]);
}
if (pReader["Amount"] != DBNull.Value)
{
pInstance.Amount = Convert.ToDecimal(pReader["Amount"]);
}
if (pReader["CouponID"] != DBNull.Value)
{
pInstance.CouponID = Convert.ToString(pReader["CouponID"]);
}
if (pReader["PayOrderID"] != DBNull.Value)
{
pInstance.PayOrderID = Convert.ToString(pReader["PayOrderID"]);
}
if (pReader["Status"] != DBNull.Value)
{
pInstance.Status = Convert.ToInt32(pReader["Status"]);
}
if (pReader["CustomerID"] != DBNull.Value)
{
pInstance.CustomerID = Convert.ToString(pReader["CustomerID"]);
}
if (pReader["CreateTime"] != DBNull.Value)
{
pInstance.CreateTime = Convert.ToDateTime(pReader["CreateTime"]);
}
if (pReader["CreateBy"] != DBNull.Value)
{
pInstance.CreateBy = Convert.ToString(pReader["CreateBy"]);
}
if (pReader["LastUpdateTime"] != DBNull.Value)
{
pInstance.LastUpdateTime = Convert.ToDateTime(pReader["LastUpdateTime"]);
}
if (pReader["LastUpdateBy"] != DBNull.Value)
{
pInstance.LastUpdateBy = Convert.ToString(pReader["LastUpdateBy"]);
}
if (pReader["IsDelete"] != DBNull.Value)
{
pInstance.IsDelete = Convert.ToInt32(pReader["IsDelete"]);
}
}
