//更新优惠价和优惠比例 public void UpdateProductChannelMemberPrice(ProductChannelMemberPriceInfo entity) { StringBuilder result = new StringBuilder(); try { entity.MemberPricePercent = entity.MemberPricePercent != null ? entity.MemberPricePercent / 100 : entity.MemberPricePercent; ProductChannelMemberPriceLogInfo log = new ProductChannelMemberPriceLogInfo() { ProductSysNo = entity.ProductSysNo, ChannelName = entity.ChannelName, MemberPrice = entity.MemberPrice, MemberPricePercent = entity.MemberPricePercent, OperationType = "E", InDate = DateTime.Now, InUser = entity.EditUser, CompanyCode = entity.CompanyCode, StoreCompanyCode = entity.StoreCompanyCode, LanguageCode = entity.LanguageCode }; ObjectFactory <ProductChannelMemberInfoProcessor> .Instance .UpdateProductChannelMemberPrice(entity); InsertProductChannelMemberPriceLog(log); } catch (BizException ex) { result.AppendLine(string.Format(ResouceManager.GetMessageString("IM.Category", "FailReason") + ":{0}", ex.Message)); throw new BizException(result.ToString()); } }
// 插入渠道会员表 public void InsertProductChannelMemberPrices(List <ProductChannelMemberPriceInfo> entityList) { StringBuilder result = new StringBuilder(); foreach (var entity in entityList) { try { entity.ChannelName = ChannelMemberInfoByChannelNo[entity.ChannelSysNO]; ProductChannelMemberPriceLogInfo log = new ProductChannelMemberPriceLogInfo() { ProductSysNo = entity.ProductSysNo, ChannelName = entity.ChannelName, MemberPrice = entity.MemberPrice, MemberPricePercent = entity.MemberPricePercent, OperationType = "A", InDate = DateTime.Now, InUser = entity.InUser, CompanyCode = entity.CompanyCode, StoreCompanyCode = entity.StoreCompanyCode, LanguageCode = entity.LanguageCode }; //插入会员渠道价格表 ObjectFactory <ProductChannelMemberInfoProcessor> .Instance .InsertProductChannelMemberPricesBiz(entity); //插入会员渠道日志 InsertProductChannelMemberPriceLog(log); successCount++; } catch (BizException ex) { string message = ResouceManager.GetMessageString("IM.Category", "ProductSysNo"); message += ":{0},"; message += ResouceManager.GetMessageString("IM.Category", "FailReason"); message += ":{1}"; result.AppendLine(string.Format(message , entity.ProductSysNo, ex.Message)); errorCount++; } } string resMessage = ResouceManager.GetMessageString("IM.ProductChannelInfo", "AddSuccess"); resMessage += ":{0},"; resMessage += ResouceManager.GetMessageString("IM.Category", "NumberUnit"); resMessage += ResouceManager.GetMessageString("IM.ProductChannelInfo", "AddFail"); resMessage += ":{1}"; resMessage += ResouceManager.GetMessageString("IM.Category", "NumberUnit"); resMessage += "。\r\n"; result.Insert(0, string.Format(resMessage , successCount, errorCount)); _ChannelMemberInfoByChannelNo = null; ClearNum(); throw new BizException(result.ToString()); }
//成批删除渠道会员表 public void DeleteProductChannelMemberPrices(List <ProductChannelMemberPriceInfo> entityList) { StringBuilder result = new StringBuilder(); foreach (var entity in entityList) { try { DeleteProductChannelMemberPrice(int.Parse(entity.SysNo.ToString())); entity.MemberPricePercent = entity.MemberPricePercent != null ? entity.MemberPricePercent / 100 : entity.MemberPricePercent; ProductChannelMemberPriceLogInfo log = new ProductChannelMemberPriceLogInfo() { ProductSysNo = entity.ProductSysNo, ChannelName = entity.ChannelName, MemberPrice = entity.MemberPrice, MemberPricePercent = entity.MemberPricePercent, OperationType = "D", InDate = DateTime.Now, InUser = entity.EditUser, CompanyCode = entity.CompanyCode, StoreCompanyCode = entity.StoreCompanyCode, LanguageCode = entity.LanguageCode }; InsertProductChannelMemberPriceLog(log); successCount++; } catch (BizException ex) { string message = ResouceManager.GetMessageString("IM.ProductChannelInfo", "SystemNo"); message += ":{0},"; message += ResouceManager.GetMessageString("IM.Category", "FailReason"); message += ":{1}"; result.AppendLine(string.Format(message , entity.SysNo, ex.Message)); errorCount++; } } string resMessage = ResouceManager.GetMessageString("IM.ProductChannelInfo", "DeleteSuccess"); resMessage += ":{0},"; resMessage += ResouceManager.GetMessageString("IM.Category", "NumberUnit"); resMessage += ResouceManager.GetMessageString("IM.ProductChannelInfo", "DeleteFail"); resMessage += ":{1}"; resMessage += ResouceManager.GetMessageString("IM.Category", "NumberUnit"); resMessage += "。\r\n"; result.Insert(0, string.Format(resMessage , successCount, errorCount)); _ChannelMemberInfoByChannelNo = null; ClearNum(); throw new BizException(result.ToString()); }
//添加日志记录 public Int32 InsertProductChannelMemberPriceLog(ProductChannelMemberPriceLogInfo entity) { DataCommand cmd = DataCommandManager.GetDataCommand("InsertProductChannelMemberPriceLog"); cmd.SetParameterValue("@ProductSysNo", entity.ProductSysNo); cmd.SetParameterValue("@ChannelName", entity.ChannelName); cmd.SetParameterValue("@MemberPrice", entity.MemberPrice); cmd.SetParameterValue("@MemberPricePercent", entity.MemberPricePercent); cmd.SetParameterValue("@OperationType", entity.OperationType); cmd.SetParameterValue("@InUser", entity.InUser); cmd.SetParameterValue("@CompanyCode", entity.CompanyCode); cmd.SetParameterValue("@StoreCompanyCode", entity.StoreCompanyCode); cmd.SetParameterValue("@LanguageCode", entity.LanguageCode); return(cmd.ExecuteNonQuery()); }
//插入日志 public Int32 InsertProductChannelMemberPriceLog(ProductChannelMemberPriceLogInfo entity) { return(ObjectFactory <ProductChannelMemberInfoProcessor> .Instance.InsertProductChannelMemberPriceLogBiz(entity)); }
//插入日志 public Int32 InsertProductChannelMemberPriceLogBiz(ProductChannelMemberPriceLogInfo entity) { return(_ProductChannelInfoDA.InsertProductChannelMemberPriceLog(entity)); }