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>());
}
