public int SaveCustomerBasicInfo(string strCustomerId, List <CustomerBasicSettingEntity> list) { int i = this._currentDAO.SaveustomerBasicrInfo(list); if (i > 0)///2016-05-17 wujx 种植缓存 { RedisOperationBLL.BasicSetting.BasicSettingBLL bllBasicSetting = new RedisOperationBLL.BasicSetting.BasicSettingBLL(); bllBasicSetting.SetBasicSetting(strCustomerId); } return(i); }
/// <summary> /// 定时全量种植 /// </summary> public void TimeSetBasicSetting() { CC_Connection connection = new CC_Connection(); LoggingSessionInfo _loggingSessionInfo = new LoggingSessionInfo(); LoggingManager CurrentLoggingManager = new LoggingManager(); var customerIDs = CustomerBLL.Instance.GetCustomerList(); foreach (var customer in customerIDs) { connection = new RedisConnectionBLL().GetConnection(customer.Key); BasicSettingBLL redisBasicSettingBll = new BasicSettingBLL(); redisBasicSettingBll.DelBasicSetting(customer.Key); redisBasicSettingBll.SetBasicSetting(customer.Key); } }
/// <summary> /// 获取当前商户的基础配置信息 /// </summary> /// <param name="customerID"></param> /// <returns></returns> public List <CustomerBasicSettingEntity> GetBusinessBasisConfigInfo(string customerID) { ///2016-05-17 wujx 缓存读取 RedisOperationBLL.BasicSetting.BasicSettingBLL bllBasicSetting = new RedisOperationBLL.BasicSetting.BasicSettingBLL(); var basicSettingList = bllBasicSetting.GetBasicSetting(customerID); if (basicSettingList != null) { var listKey = new List <string> { "CustomerShortName", "WebLogo", "CustomerPhone", "ForwardingMessageTitle", "ForwardingMessageLogo", "ForwardingMessageSummary", "GuideLinkUrl", "GuideQRCode", "CustomerGreeting" }; var query = from q in basicSettingList.AsEnumerable() from t in listKey where q.SettingCode.Contains(t) select q; return(query.ToList()); } else { List <IWhereCondition> complexCondition = new List <IWhereCondition> { }; complexCondition.Add(new EqualsCondition() { FieldName = "CustomerID", Value = customerID }); StringBuilder WhereStr = new StringBuilder(); /*Modified by sun@2016-01-06*/ //WhereStr.Append(" (SettingCode='BusinessNickname' or SettingCode='BusinessLogo' or SettingCode='CustomerPhone' "); WhereStr.Append(" (SettingCode='CustomerShortName' or SettingCode='WebLogo' or SettingCode='CustomerPhone' "); /*Modified by sun@2016-01-06*/ //WhereStr.Append("or SettingCode='ShareTitle' or SettingCode='ShareImageUrl' or SettingCode='ShareContent' "); WhereStr.Append("or SettingCode='ForwardingMessageTitle' or SettingCode='ForwardingMessageLogo' or SettingCode='ForwardingMessageSummary' "); WhereStr.Append("or SettingCode='GuideLinkUrl' or SettingCode='GuideQRCode' or SettingCode='CustomerGreeting') "); complexCondition.Add(new DirectCondition(WhereStr.ToString())); return(this._currentDAO.Query(complexCondition.ToArray(), null).ToList()); } }
public DataTable GetBaiscSettingInfoFromRedis(string strCustomerId) { DataTable dt = new DataTable(); RedisOperationBLL.BasicSetting.BasicSettingBLL bllBasicSetting = new RedisOperationBLL.BasicSetting.BasicSettingBLL(); var basicSettingList = bllBasicSetting.GetBasicSetting(strCustomerId); if (basicSettingList != null) { var listKey = new List <string> { "CustomerShortName", "WebLogo", "CustomerPhone", "ForwardingMessageTitle", "ForwardingMessageLogo", "ForwardingMessageSummary", "GuideLinkUrl", "GuideQRCode", "CustomerGreeting" }; var query = from q in basicSettingList.AsEnumerable() from t in listKey where q.SettingCode.Contains(t) select q; dt = DataTableToObject.ConvertToDataTableFromList(query.ToList()); } else { dt = this._currentDAO.GetCustomerBaiscSettingInfoRedisBackUp(strCustomerId).Tables[0]; } return(dt); }
/// <summary> /// 获取社会化销售配置和积分返现配置 /// </summary> /// <param name="salesPrice"></param> /// <param name="channelId"></param> /// <returns></returns> public Hashtable GetSocialSetting() { //所有商户配置 //var settingList =this._currentDAO.QueryByEntity(new CustomerBasicSettingEntity() { CustomerID = this.CurrentUserInfo.ClientID }, null); RedisOperationBLL.BasicSetting.BasicSettingBLL bllBasicSetting = new RedisOperationBLL.BasicSetting.BasicSettingBLL(); var settingList = bllBasicSetting.GetBasicSetting(this.CurrentUserInfo.ClientID); if (settingList == null && settingList.Count == 0) { bllBasicSetting.SetBasicSetting(this.CurrentUserInfo.ClientID); } else { settingList = this._currentDAO.QueryByEntity(new CustomerBasicSettingEntity() { CustomerID = this.CurrentUserInfo.ClientID }, null).ToList(); } #region 社会化销售配置 //社会化销售设置类型 0=按订单;1=按商品 int socialSalesType = 0; var socialSalesTypeSetting = settingList.Where(t => t.SettingCode == "SocialSalesType").FirstOrDefault(); //启用员工分销设置(0=不启用;1=启用) int enableEmployeeSales = 0; CustomerBasicSettingEntity enableEmployeeSalesSetting = settingList.Where(t => t.SettingCode == "EnableEmployeeSales").FirstOrDefault(); //员工的商品分销价比例 decimal eDistributionPricePer = 0; CustomerBasicSettingEntity EDistributionPricePerSetting = settingList.Where(t => t.SettingCode == "EDistributionPricePer").FirstOrDefault(); //启用会员分销设置(0=不启用;1=启用) int enableVipSales = 0; var EnableVipSalesSetting = settingList.Where(t => t.SettingCode == "EnableVipSales").FirstOrDefault(); //会员的商品分销价比例 decimal vDistributionPricePer = 0; var VDistributionPricePerSetting = settingList.Where(t => t.SettingCode == "VDistributionPricePer").FirstOrDefault(); //员工的订单金额提成比例 decimal eOrderCommissionPer = 0; var eOrderCommissionPerSetting = settingList.Where(t => t.SettingCode == "EOrderCommissionPer").FirstOrDefault(); //会员的订单金额提成比例 decimal vOrderCommissionPer = 0; var vOrderCommissionPerSetting = settingList.Where(t => t.SettingCode == "VOrderCommissionPer").FirstOrDefault(); if (socialSalesTypeSetting != null) { socialSalesType = int.Parse(socialSalesTypeSetting.SettingValue); } if (enableEmployeeSalesSetting != null) { enableEmployeeSales = int.Parse(enableEmployeeSalesSetting.SettingValue); } if (EDistributionPricePerSetting != null) { eDistributionPricePer = decimal.Parse(EDistributionPricePerSetting.SettingValue); } if (EnableVipSalesSetting != null) { enableVipSales = int.Parse(EnableVipSalesSetting.SettingValue); } if (VDistributionPricePerSetting != null) { vDistributionPricePer = decimal.Parse(VDistributionPricePerSetting.SettingValue); } if (eOrderCommissionPerSetting != null) { eOrderCommissionPer = decimal.Parse(eOrderCommissionPerSetting.SettingValue); } if (vOrderCommissionPerSetting != null) { vOrderCommissionPer = decimal.Parse(vOrderCommissionPerSetting.SettingValue); } #endregion #region 积分返现配置 //奖励类型 0=按订单;1=按商品 var rewardsTypeSetting = settingList.Where(t => t.SettingCode == "RewardsType").FirstOrDefault(); //积分启用配置 var enableIntegralSetting = settingList.Where(t => t.SettingCode == "EnableIntegral").FirstOrDefault(); //返现启用配置 var enableRewardCashSetting = settingList.Where(t => t.SettingCode == "EnableRewardCash").FirstOrDefault(); //返回积分比例 var rewardPointsPerSetting = settingList.Where(t => t.SettingCode == "RewardPointsPer").FirstOrDefault(); //积分最低使用限制 var pointsRedeemLowestLimitSetting = settingList.Where(t => t.SettingCode == "PointsRedeemLowestLimit").FirstOrDefault(); //每单赠送积分上限 var pointsOrderUpLimitSetting = settingList.Where(t => t.SettingCode == "PointsOrderUpLimit").FirstOrDefault(); //返现比例 var rewardCashPerSetting = settingList.Where(t => t.SettingCode == "RewardCashPer").FirstOrDefault(); //返现最低使用限制 var cashRedeemLowestLimitSetting = settingList.Where(t => t.SettingCode == "CashRedeemLowestLimit").FirstOrDefault(); //每单返现上限 var cashOrderUpLimitSetting = settingList.Where(t => t.SettingCode == "CashOrderUpLimit").FirstOrDefault(); //积分使用上限比例 var pointsRedeemUpLimitSetting = settingList.Where(t => t.SettingCode == "PointsRedeemUpLimit").FirstOrDefault(); //返现使用上限比例 var cashRedeemUpLimitSetting = settingList.Where(t => t.SettingCode == "CashRedeemUpLimit").FirstOrDefault(); int rewardsType = 0; int enableIntegral = 0; int enableRewardCash = 0; decimal rewardPointsPer = 0; decimal rewardCashPer = 0; decimal pointsRedeemLowestLimit = 0; decimal cashRedeemLowestLimit = 0; int pointsOrderUpLimit = 0; decimal cashOrderUpLimit = 0; decimal pointsRedeemUpLimit = 0; decimal cashRedeemUpLimit = 0; if (rewardsTypeSetting != null) { rewardsType = int.Parse(rewardsTypeSetting.SettingValue); } if (enableIntegralSetting != null) { enableIntegral = int.Parse(enableIntegralSetting.SettingValue); } if (enableRewardCashSetting != null) { enableRewardCash = int.Parse(enableRewardCashSetting.SettingValue); } if (rewardPointsPerSetting != null) { rewardPointsPer = decimal.Parse(rewardPointsPerSetting.SettingValue); } if (rewardCashPerSetting != null) { rewardCashPer = decimal.Parse(rewardCashPerSetting.SettingValue); } if (pointsRedeemLowestLimitSetting != null) { pointsRedeemLowestLimit = decimal.Parse(pointsRedeemLowestLimitSetting.SettingValue); } if (cashRedeemLowestLimitSetting != null) { cashRedeemLowestLimit = decimal.Parse(cashRedeemLowestLimitSetting.SettingValue); } if (pointsOrderUpLimitSetting != null) { pointsOrderUpLimit = int.Parse(pointsOrderUpLimitSetting.SettingValue); } if (cashOrderUpLimitSetting != null) { cashOrderUpLimit = decimal.Parse(cashOrderUpLimitSetting.SettingValue); } if (pointsRedeemUpLimitSetting != null) { pointsRedeemUpLimit = decimal.Parse(pointsRedeemUpLimitSetting.SettingValue); } if (cashRedeemUpLimitSetting != null) { cashRedeemUpLimit = decimal.Parse(cashRedeemUpLimitSetting.SettingValue); } #endregion Hashtable htSetting = new Hashtable(); htSetting["socialSalesType"] = socialSalesType; htSetting["enableEmployeeSales"] = enableEmployeeSales; htSetting["eDistributionPricePer"] = eDistributionPricePer; htSetting["enableVipSales"] = enableVipSales; htSetting["vDistributionPricePer"] = vDistributionPricePer; htSetting["eOrderCommissionPer"] = eOrderCommissionPer; htSetting["vOrderCommissionPer"] = vOrderCommissionPer; htSetting["rewardsType"] = rewardsType; htSetting["enableIntegral"] = enableIntegral; htSetting["enableRewardCash"] = enableRewardCash; htSetting["rewardPointsPer"] = rewardPointsPer; htSetting["rewardCashPer"] = rewardCashPer; htSetting["pointsRedeemLowestLimit"] = pointsRedeemLowestLimit; htSetting["cashRedeemLowestLimit"] = cashRedeemLowestLimit; htSetting["pointsOrderUpLimit"] = pointsOrderUpLimit; htSetting["cashOrderUpLimit"] = cashOrderUpLimit; htSetting["pointsRedeemUpLimit"] = pointsRedeemUpLimit; htSetting["cashRedeemUpLimit"] = cashRedeemUpLimit; return(htSetting); }