private void InsertOrUpdateLocation(ProductRecommendInfo entity) { ProductRecommendLocation loc = _recommendDA.LoadLocation(entity.Location); if (entity.Location.PageType == 14) { entity.Location.PageID = -1; } if (loc == null) { //如果位置信息不存在就创建 _recommendDA.CreateLocation(entity.Location); } else { entity.Location.SysNo = loc.SysNo; //如果存在就更新描述,更新描述前先验证同一位置是否存在相同的位置描述 if (!string.IsNullOrWhiteSpace(entity.Location.Description)) { if (_recommendDA.ExitsSameDescription(entity.Location) > 0) { //throw new BizException("已存在相同的模块名称。"); throw new BizException(ResouceManager.GetMessageString("MKT.ProductRecommend", "ProductRecommend_ExistsSameModuleName")); } _recommendDA.UpdateLocationDesc(loc.SysNo.Value, entity.Location.Description); } } }
public void CreateLocation(ProductRecommendLocation location) { DataCommand cmd = DataCommandManager.GetDataCommand("ProductRecommend_InsertLocation"); cmd.SetParameterValue(location); cmd.ExecuteNonQuery(); location.SysNo = Convert.ToInt32(cmd.GetParameterValue("@SysNo")); }
public ProductRecommendLocation LoadLocation(ProductRecommendLocation location) { DataCommand cmd = DataCommandManager.GetDataCommand("ProductRecommend_GetProductRecommendLocation"); cmd.SetParameterValue("@PageType", location.PageType); cmd.SetParameterValue("@PageID", location.PageID); cmd.SetParameterValue("@PositionID", location.PositionID); cmd.SetParameterValue("@CompanyCode", location.CompanyCode); //TODO:添加多渠道条件设置 return(cmd.ExecuteEntity <ProductRecommendLocation>()); }
private void CreateLocation(int pageType, int pageID, int positionID, string locDesc, string companyCode, string channelID) { ProductRecommendLocation l = new ProductRecommendLocation(); l.PageType = pageType; l.PageID = pageID; l.PositionID = positionID; l.Description = locDesc; l.CompanyCode = companyCode; l.WebChannel = new BizEntity.Common.WebChannel(); l.WebChannel.ChannelID = channelID; _recommendDA.CreateLocation(l); }
public int ExitsSameDescription(ProductRecommendLocation location) { DataCommand cmd = DataCommandManager.GetDataCommand("ProductRecommend_ExitsSameDescription"); cmd.SetParameterValue("@PageType", location.PageType); cmd.SetParameterValue("@PageID", location.PageID); cmd.SetParameterValue("@PositionID", location.PositionID); cmd.SetParameterValue("@Description", location.Description); cmd.SetParameterValue("@CompanyCode", location.CompanyCode); //TODO:添加多渠道条件设置 return(cmd.ExecuteScalar <int>()); }