/// <summary>
/// 有则浏览记录数+1，无则新加
/// </summary>
/// <param name="model">商品浏览记录实体</param>
/// <returns>成功返回true,失败返回false</returns>
/// <remarks>
/// 2013-09-10 郑荣华 创建
/// </remarks>
public bool AddCrBrowseHistory(CrBrowseHistory model)
{
var filter = new ParaCrBrowseHistoryFilter
{
BrowseType = model.BrowseType,
CategorySysNo = model.CategorySysNo,
CustomerSysNo = model.CustomerSysNo,
IsPageDown = model.IsPageDown,
KeyWord = model.KeyWord ?? "",
ProductSysNo = model.ProductSysNo
}; //所有查询字段不能为null
var r = GetCrBrowseHistory(filter);
if (null == r)
{
//新加商品浏览记录
model.BrowseNum = 1;
return(Create(model) > 0);
}
//浏览次数加1
model.BrowseNum = r.BrowseNum + 1;
model.SysNo = r.SysNo;
return(Update(model) > 0);
}
/// <summary>
/// 获取商品浏览记录
/// </summary>
/// <param name="filter">商品浏览历史查询条件实体</param>
/// <returns>商品浏览记录</returns>
/// <remarks>
/// 2013-09-10 郑荣华 创建
/// </remarks>
public override CrBrowseHistory GetCrBrowseHistory(ParaCrBrowseHistoryFilter filter)
{
const string sqlWhere = @"
(@BrowseType is null or t.BrowseType= @BrowseType)
and (@CategorySysNo is null or t.CategorySysNo= @CategorySysNo)
and (@CustomerSysNo is null or t.CustomerSysNo= @CustomerSysNo)
and (@IsPageDown is null or t.IsPageDown=@IsPageDown)
and (@KeyWord is null or t.KeyWord=@KeyWord)
and (@ProductSysNo is null or t.ProductSysNo=@ProductSysNo)
";
const string sql = "select t.* from CrBrowseHistory t where " + sqlWhere;
return(Context.Sql(sql)
.Parameter("BrowseType", filter.BrowseType)
.Parameter("CategorySysNo", filter.CategorySysNo)
.Parameter("CustomerSysNo", filter.CustomerSysNo)
.Parameter("IsPageDown", filter.IsPageDown)
.Parameter("KeyWord", filter.KeyWord)
.Parameter("ProductSysNo", filter.ProductSysNo)
.QuerySingle <CrBrowseHistory>());
}
/// <summary>
/// 获取商品浏览记录
/// </summary>
/// <param name="filter">商品浏览历史查询条件实体</param>
/// <returns>商品浏览记录</returns>
/// <remarks>
/// 2013-09-10 郑荣华 创建
/// </remarks>
public CrBrowseHistory GetCrBrowseHistory(ParaCrBrowseHistoryFilter filter)
{
return(ICrBrowseHistoryDao.Instance.GetCrBrowseHistory(filter));
}
/// <summary> /// 获取商品浏览记录 /// </summary> /// <param name="filter">商品浏览历史查询条件实体</param> /// <returns>商品浏览记录</returns> /// <remarks> /// 2013-09-10 郑荣华 创建 /// </remarks> public abstract CrBrowseHistory GetCrBrowseHistory(ParaCrBrowseHistoryFilter filter);