/// <summary>
/// 查询历史备注
/// </summary>
/// <param name="filter">查询条件</param>
/// <returns>结果集合</returns>
public List <PayableInfo> PayableQuery(PayableCriteriaInfo filter)
{
CustomDataCommand cmd = DataCommandManager.CreateCustomDataCommandFromConfig("QueryPayable");
using (DynamicQuerySqlBuilder sb = new DynamicQuerySqlBuilder(
cmd.CommandText, cmd, null, "SysNo desc"))
{
sb.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "OrderSysNo",
DbType.Int32, "@OrderSysNo", QueryConditionOperatorType.Equal, filter.OrderSysNo);
sb.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "OrderType",
DbType.Int32, "@OrderType", QueryConditionOperatorType.Equal, filter.OrderType);
sb.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "PayStatus",
DbType.Int32, "@PayStatus", QueryConditionOperatorType.Equal, filter.PayStatus);
sb.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "SysNo",
DbType.Int32, "@SysNo", QueryConditionOperatorType.Equal, filter.SysNo);
sb.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "CompanyCode",
DbType.AnsiStringFixedLength, "@CompanyCode", QueryConditionOperatorType.Equal, filter.CompanyCode);
sb.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "BatchNumber",
DbType.Int32, "@BatchNumber", QueryConditionOperatorType.Equal, filter.BatchNumber);
cmd.CommandText = sb.BuildQuerySql();
var result = cmd.ExecuteEntityList <PayableInfo>();
return(result);
}
}
public List<PayableInfo> PayableQuery(PayableCriteriaInfo info)
{
return ObjectFactory<FinanceAppService>.Instance.PayableQuery(info);
}
/// <summary>
/// 查询备注
/// </summary>
/// <param name="filter"></param>
/// <returns></returns>
public virtual List <PayableInfo> PayableQuery(PayableCriteriaInfo info)
{
return(m_FinanceDA.PayableQuery(info));
}
/// <summary>
/// 查询备注
/// </summary>
/// <param name="filter"></param>
/// <returns></returns>
public virtual List <PayableInfo> PayableQuery(PayableCriteriaInfo info)
{
return(processor.PayableQuery(info));
}
