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"]); } }