/// <summary>
/// 获取有效的支付方式列表
/// </summary>
/// <returns>支付方式列表</returns>
/// <remarks>
/// 2013-08-20 郑荣华 创建
/// </remarks>
public IList <CBBsPaymentType> GetUsedPaymentTypeList()
{
var filter = new ParaPaymentTypeFilter {
Status = (int)BasicStatus.支付方式状态.启用
};
return(IBasicPayDao.Instance.GetPaymentTypeList(filter));
}
/// <summary>
/// 获取支付方式列表
/// </summary>
/// <param name="filter">查询条件</param>
/// <returns>支付方式列表</returns>
/// <remarks>
/// 2013-08-20 郑荣华 创建
/// </remarks>
/// <remarks>2013-09-09 周唐炬 加入支付名称PaymentName模糊查询</remarks>
public override IList <CBBsPaymentType> GetPaymentTypeList(ParaPaymentTypeFilter filter)
{
// const string sqlWhere = @"
// (@PaymentName IS NULL OR REGEXP_charindex(t.PaymentName, @PaymentName, 1, 1, 1, 'i') > 0)
// AND (@IsOnlinePay is null or t.IsOnlinePay= @IsOnlinePay)
// and (@isonlinevisible is null or t.isonlinevisible= @isonlinevisible)
// and (@status is null or t.status= @status)
// and (@PaymentType is null or t.PaymentType=@PaymentType)
// and (@RequiredCardNumber is null or t.RequiredCardNumber=@RequiredCardNumber)
// ";
const string sqlWhere = @"
(@PaymentName IS NULL OR t.PaymentName=@PaymentName)
AND (@IsOnlinePay is null or t.IsOnlinePay= @IsOnlinePay)
and (@isonlinevisible is null or t.isonlinevisible= @isonlinevisible)
and (@status is null or t.status= @status)
and (@PaymentType is null or t.PaymentType=@PaymentType)
and (@RequiredCardNumber is null or t.RequiredCardNumber=@RequiredCardNumber)
";
return(Context.Select <CBBsPaymentType>("t.*")
.From("BsPaymentType t")
.Where(sqlWhere)
.Parameter("PaymentName", filter.PaymentName)
//.Parameter("PaymentName", filter.PaymentName)
.Parameter("IsOnlinePay", filter.IsOnlinePay)
//.Parameter("IsOnlinePay", filter.IsOnlinePay)
.Parameter("isonlinevisible", filter.IsOnlineVisible)
//.Parameter("isonlinevisible", filter.IsOnlineVisible)
.Parameter("status", filter.Status)
//.Parameter("status", filter.Status)
.Parameter("PaymentType", filter.PaymentType)
//.Parameter("PaymentType", filter.PaymentType)
.Parameter("RequiredCardNumber", filter.RequiredCardNumber)
//.Parameter("RequiredCardNumber", filter.RequiredCardNumber)
.QueryMany());
}
/// <summary> /// 获取支付方式列表 /// </summary> /// <param name="filter">查询条件</param> /// <returns>支付方式列表</returns> /// <remarks> /// 2013-08-20 郑荣华 创建 /// </remarks> public abstract IList <CBBsPaymentType> GetPaymentTypeList(ParaPaymentTypeFilter filter);
/// <summary>
/// 获取支付方式列表
/// </summary>
/// <param name="filter">查询条件</param>
/// <returns>支付方式列表</returns>
/// <remarks>
/// 2013-08-20 郑荣华 创建
/// </remarks>
public IList <CBBsPaymentType> GetPaymentTypeList(ParaPaymentTypeFilter filter)
{
return(IBasicPayDao.Instance.GetPaymentTypeList(filter));
}
