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); }
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); }
/// <summary> /// 将查询实体转换为Order语句 /// <param name="query">查询实体</param> /// <returns>获取Order语句,不包含Order</returns> /// </summary> public string FlowNodeConditionQueryToSQLOrder(FlowNodeConditionQuery query) { return(" FlowConditionID DESC"); }
/// <summary> /// 将查询实体转换为Where语句 /// <param name="query">查询实体</param> /// <returns>获取Where语句,不包含Where</returns> /// </summary> public string FlowNodeConditionQueryToSQLWhere(FlowNodeConditionQuery query) { return(string.Empty); }
/// <summary> /// 获取所有符合查询条件的数据 /// </summary> /// <param name="flowNodeConditionQuery">FlowNodeConditionQuery查询实体对象</param> /// <returns>List<FlowNodeConditionEntity></returns> public List <FlowNodeConditionEntity> GetFlowNodeConditionList(FlowNodeConditionQuery flowNodeConditionQuery) { return(FlowNodeConditionBusProvider.GetFlowNodeConditionList(flowNodeConditionQuery)); }
/// <summary> /// 分页获取符合查询条件的数据 /// </summary> /// <param name="flowNodeConditionQuery">FlowNodeConditionQuery查询实体对象</param> /// <returns>Pager<FlowNodeConditionEntity></returns> public Pager <FlowNodeConditionEntity> GetFlowNodeConditionPageList(FlowNodeConditionQuery flowNodeConditionQuery) { return(FlowNodeConditionDataAccess.Instance.GetFlowNodeConditionPageList(flowNodeConditionQuery)); }