/// <summary>
/// 获取所有符合查询条件的数据
/// </summary>
/// <param name="flowNodeConditionQuery">FlowNodeConditionQuery查询实体对象</param>
/// <returns>List<FlowNodeConditionEntity></returns>
public List<FlowNodeConditionEntity> GetFlowNodeConditionList(FlowNodeConditionQuery flowNodeConditionQuery)
{
return FlowNodeConditionDataAccess.Instance.GetFlowNodeConditionList(flowNodeConditionQuery);
}
/// <summary>
/// 分页获取符合查询条件的数据
/// </summary>
/// <param name="flowNodeConditionQuery">FlowNodeConditionQuery查询实体对象</param>
/// <returns>Pager<FlowNodeConditionEntity></returns>
public Pager<FlowNodeConditionEntity> GetFlowNodeConditionPageList(FlowNodeConditionQuery flowNodeConditionQuery)
{
return FlowNodeConditionBusProvider.GetFlowNodeConditionPageList(flowNodeConditionQuery);
}
public Pager<FlowNodeConditionEntity> GetFlowNodeConditionPageList(FlowNodeConditionQuery query)
{
int recordCount=0;
string whereSQL=FlowNodeConditionQueryToSQLWhere(query);
string orderBy=FlowNodeConditionQueryToSQLOrder(query);
DataSet ds=db.GetPagingData("FlowNodeCondition","FlowConditionID,JournalID,OperationID,ConditionType,ConditionExp,AddDate",orderBy,whereSQL,query.CurrentPage,query.PageSize,out recordCount);
Pager<FlowNodeConditionEntity> pager=new Pager<FlowNodeConditionEntity>();
if(ds!=null && ds.Tables.Count>0)
{
pager.ItemList= MakeFlowNodeConditionList(ds.Tables[0]);
}
pager.CurrentPage=query.CurrentPage;
pager.PageSize=query.PageSize;
pager.TotalRecords=recordCount;
return pager;
}
public List<FlowNodeConditionEntity> GetFlowNodeConditionList(FlowNodeConditionQuery query)
{
List<FlowNodeConditionEntity> list = new List<FlowNodeConditionEntity>();
StringBuilder sqlCommandText = new StringBuilder();
sqlCommandText.Append("SELECT FlowConditionID,JournalID,OperationID,ConditionType,ConditionExp,AddDate FROM dbo.FlowNodeCondition WITH(NOLOCK)");
string whereSQL = FlowNodeConditionQueryToSQLWhere(query);
string orderBy=FlowNodeConditionQueryToSQLOrder(query);
if(!string.IsNullOrEmpty(whereSQL)) sqlCommandText.Append(" WHERE " + whereSQL);
if(!string.IsNullOrEmpty(orderBy)) sqlCommandText.Append(" ORDER BY " + orderBy);
DbCommand cmd = db.GetSqlStringCommand(sqlCommandText.ToString());
using(IDataReader dr = db.ExecuteReader(cmd))
{
list = MakeFlowNodeConditionList(dr);
}
return list;
}
/// <summary>
/// 将查询实体转换为Where语句
/// <param name="query">查询实体</param>
/// <returns>获取Where语句，不包含Where</returns>
/// </summary>
public string FlowNodeConditionQueryToSQLWhere(FlowNodeConditionQuery query)
{
return string.Empty;
}
/// <summary>
/// 将查询实体转换为Order语句
/// <param name="query">查询实体</param>
/// <returns>获取Order语句，不包含Order</returns>
/// </summary>
public string FlowNodeConditionQueryToSQLOrder(FlowNodeConditionQuery query)
{
return " FlowConditionID DESC";
}