/// <summary> /// 获取团购数量 /// </summary> /// <param name="type">团购类型</param> /// <param name="status">团购状态</param> /// <param name="startTime">起始时间</param> /// <param name="endTime">结束时间</param> /// <returns>团购数量</returns> /// <remarks>2013-09-04 杨晗 创建</remarks> public override int GetCount(GroupShoppingStatus.团购类型 type, GroupShoppingStatus.团购状态 status, DateTime?startTime, DateTime?endTime) { #region sql条件 const string sqlWhere = @"(@GroupType is null or ggs.GroupType =@GroupType) and (@Status is null or ggs.Status =@Status) and (@StartTime is null or ggs.StartTime >= @StartTime) and (@EndTime is null or ggs.EndTime <= @EndTime)"; #endregion return(Context.Select <int>("count(1)") .From("GsGroupShopping ggs") .Where(sqlWhere) .Parameter("GroupType", (int)type) //.Parameter("GroupType", (int) type) //.Parameter("Status", (int) status) .Parameter("Status", (int)status) //.Parameter("StartTime", startTime) .Parameter("StartTime", startTime) //.Parameter("EndTime", endTime) .Parameter("EndTime", endTime) .QuerySingle()); }
/// <summary> /// 获取团购数量 /// </summary> /// <param name="type">团购类型</param> /// <param name="status">团购状态</param> /// <param name="startTime">起始时间</param> /// <param name="endTime">结束时间</param> /// <returns>团购数量</returns> /// <remarks>2013-09-04 杨晗 创建</remarks> public abstract int GetCount(GroupShoppingStatus.团购类型 type, GroupShoppingStatus.团购状态 status, DateTime?startTime, DateTime?endTime);