/// <summary>
/// 用于频道页逻辑
/// </summary>
/// <param name="recommendBrand"></param>
/// <returns></returns>
public int InsertSWfsSpChannelRecommendBrandChannel(SWfsSpHomeRecommendBrand recommendBrand)
{
if (UpdateSWfsSpChannelRecommendBrandChannel(recommendBrand, PresentationHelper.GetPassport().UserName))
{
return(DapperUtil.Insert <SWfsSpHomeRecommendBrand>(recommendBrand, true));
}
return(-1);
}
/// <summary>
/// 如果添加品牌存在（或被逻辑删除），则更新品牌状态
/// </summary>
/// <param name="recommendBrand"></param>
/// <param name="userId"></param>
/// <returns></returns>
private bool UpdateSWfsSpChannelRecommendBrand(SWfsSpHomeRecommendBrand recommendBrand, string userId)
{
var dic = new Dictionary <string, object>();
dic.Add("PageNo", recommendBrand.PageNo);
dic.Add("PagePositionNo", recommendBrand.PagePositionNo);
dic.Add("BrandNO", recommendBrand.IsRecommendBrand == 1 ? "" : recommendBrand.BrandNO);
dic.Add("IsRecommendBrand", recommendBrand.IsRecommendBrand);
//查询品牌
var originalBrand = DapperUtil.Query <SWfsSpHomeRecommendBrand>("ComBeziWfs_SWfsSpHomeRecommendBrand_GetRecommendBrand", dic, new
{
PageNo = recommendBrand.PageNo,
PagePositionNo = recommendBrand.PagePositionNo,
BrandNO = recommendBrand.BrandNO,
IsRecommendBrand = recommendBrand.IsRecommendBrand
}).FirstOrDefault();
//如果存在则修改，如果不存在则返回
if (originalBrand == null)
{
return(true);
}
else
{
var result = DapperUtil.UpdatePartialColumns <SWfsSpHomeRecommendBrand>(new
{
RecommendBrandID = originalBrand.RecommendBrandID,
Status = recommendBrand.Status,
DataState = 1,
UpdateOperateUserId = userId,
UpdateDate = DateTime.Now,
SortId = 0,
PictureFileNo = recommendBrand.PictureFileNo,
BrandNo = recommendBrand.BrandNO,
DateBegin = recommendBrand.DateBegin,
PictureIndex = recommendBrand.PictureIndex,
PictureFileTitle = recommendBrand.PictureFileTitle
});
return(false);
}
}
public bool UpDateHomeBrand(SWfsSpHomeRecommendBrand brand)
{
return(DapperUtil.UpdatePartialColumns <SWfsSpHomeRecommendBrand>(brand));
}
public int InsertSWfsSpHomeRecommendBrand(SWfsSpHomeRecommendBrand recommendBrand)
{
return(DapperUtil.Insert <SWfsSpHomeRecommendBrand>(recommendBrand, true));
}
