예제 #1
0
    /// <summary>
    /// 获取实体对应表的信息集,并以数据表的信息形式返回
    /// </summary>
    /// <param name="dbCore">数据库访问核心类DbCore实例(用于DbCore事务)</param>
    /// <param name="colNames">实体字段名数组</param>
    /// <param name="operates">比较操作符数组</param>
    /// <param name="colValues">实体字段名对应的值数组</param>
    /// <param name="orderColumns">排序字段数组</param>
    /// <param name="orderDirections">对应排序方向数组</param>
    /// <returns>返回符合条件的数据表信息</returns>
    public DataTable GetDataTable(DbCore dbCore, string[] colNames, Operation[] operates, object[] colValues,
                                  string[] orderColumns, OrderDirection[] orderDirections)
    {
        ORMap <BaseEntity> ormap = new ORMap <BaseEntity>(this);

        return(ormap.GetDataTable(dbCore, colNames, operates, colValues, orderColumns, orderDirections));
    }
예제 #2
0
    /// <summary>
    /// 获取实体对应表的信息集,并以数据表的信息形式返回
    /// </summary>
    /// <param name="dbCore">数据库访问核心类DbCore实例(用于DbCore事务)</param>
    /// <param name="colName">实体字段名</param>
    /// <param name="operate">比较操作符</param>
    /// <param name="colValue">实体字段名对应的值</param>
    /// <param name="orderColumn">排序字段</param>
    /// <param name="orderDirection">对应排序方向</param>
    /// <returns>返回符合条件的数据表信息</returns>
    public DataTable GetDataTable(DbCore dbCore, string colName, Operation operate, object colValue,
                                  string orderColumn, OrderDirection orderDirection)
    {
        ORMap <BaseEntity> ormap = new ORMap <BaseEntity>(this);

        return(ormap.GetDataTable(dbCore, colName, operate, colValue, orderColumn, orderDirection));
    }
예제 #3
0
 /// <summary>
 /// 获取实体对应表指定排序的信息集,并以数据表的信息形式返回
 /// </summary>
 /// <param name="listColAndValue">获取数据表信息的条件值</param>
 /// <param name="operates">条件字段名对应比较操作符</param>
 /// <param name="orderColNames">排序字段数组</param>
 /// <param name="orderDirections">排序字段对应排序方向</param>
 /// <returns>返回符合排序条件数据表的信息</returns>
 public DataTable GetDataTable(ListDictionary listColAndValue, Operation[] operates, string[] orderColNames, OrderDirection[] orderDirections)
 {
     if (listColAndValue.Count == operates.Length)
     {
         ORMap <BaseEntity> ormap = new ORMap <BaseEntity>(this);
         return(ormap.GetDataTable(listColAndValue, operates, orderColNames, orderDirections));
     }
     else
     {
         return(null);
     }
 }
예제 #4
0
    /// <summary>
    /// 获取实体对应表的信息集,并以数据表的信息形式返回
    /// </summary>
    /// <param name="colNames">实体字段名数组</param>
    /// <param name="colValues">实体字段名数组对应的相等值</param>
    /// <returns>返回符合条件的数据表信息</returns>
    public DataTable GetDataTable(string[] colNames, object[] colValues)
    {
        ORMap <BaseEntity> ormap = new ORMap <BaseEntity>(this);

        return(ormap.GetDataTable(colNames, colValues));
    }
예제 #5
0
    /// <summary>
    /// 获取实体对应表的信息集,并以数据表的信息形式返回
    /// </summary>
    /// <param name="colName">实体字段名</param>
    /// <param name="colValue">实体字段名对应的相等值</param>
    /// <returns>返回符合条件的数据表信息</returns>
    public DataTable GetDataTable(string colName, object colValue)
    {
        ORMap <BaseEntity> ormap = new ORMap <BaseEntity>(this);

        return(ormap.GetDataTable(colName, colValue));
    }
예제 #6
0
    /// <summary>
    /// 获取实体对应表指定排序的信息集,并以数据表的信息形式返回
    /// </summary>
    /// <param name="colNames">排序字段数组</param>
    /// <param name="order">排序方向</param>
    /// <returns>返回符合排序条件数据表的信息</returns>
    public DataTable GetDataTable(string[] colNames, OrderDirection order)
    {
        ORMap <BaseEntity> ormap = new ORMap <BaseEntity>(this);

        return(ormap.GetDataTable(colNames, order));
    }
예제 #7
0
    /// <summary>
    /// 获取实体对应表指定排序的信息集,并以数据表的信息形式返回
    /// </summary>
    /// <param name="orderColumns">排序字段数组</param>
    /// <param name="orderDirections">排序方向数组</param>
    /// <returns>返回符合排序条件数据表的信息</returns>
    public DataTable GetDataTable(string[] orderColumns, OrderDirection[] orderDirections)
    {
        ORMap <BaseEntity> ormap = new ORMap <BaseEntity>(this);

        return(ormap.GetDataTable(new string[] { }, new Operation[] { }, new object[] { }, orderColumns, orderDirections));
    }
예제 #8
0
    /// <summary>
    /// 获取实体对应表指定排序的信息集,并以数据表的信息形式返回
    /// </summary>
    /// <param name="colName1">排序字段1</param>
    /// <param name="order1">排序方向1</param>
    /// <param name="colName2">排序字段2</param>
    /// <param name="order2">排序方向2</param>
    /// <returns>返回符合排序条件数据表的信息</returns>
    public DataTable GetDataTable(string colName1, OrderDirection order1, string colName2, OrderDirection order2)
    {
        ORMap <BaseEntity> ormap = new ORMap <BaseEntity>(this);

        return(ormap.GetDataTable(colName1, order1, colName2, order2));
    }
예제 #9
0
    /// <summary>
    /// 获取实体对应表指定排序的信息集,并以数据表的信息形式返回
    /// </summary>
    /// <param name="colName">排序字段(默认升序排序)</param>
    /// <returns>返回符合排序条件数据表的信息</returns>
    public DataTable GetDataTable(string colName)
    {
        ORMap <BaseEntity> ormap = new ORMap <BaseEntity>(this);

        return(ormap.GetDataTable(colName, OrderDirection.Asc));
    }
예제 #10
0
    /// <summary>
    /// 获取实体对应表的信息集,并以数据表的信息形式返回
    /// </summary>
    /// <param name="listColAndValue">获取数据表信息的条件值(=)</param>
    /// <returns>返回符合并条件数据表的信息</returns>
    public DataTable GetDataTable(ListDictionary listColAndValue)
    {
        ORMap <BaseEntity> ormap = new ORMap <BaseEntity>(this);

        return(ormap.GetDataTable(listColAndValue));
    }
예제 #11
0
    /// <summary>
    /// 获取实体对应表的信息集,并以数据表的信息形式返回
    /// </summary>
    /// <param name="hashCondition">获取数据表信息的条件值(=)</param>
    /// <returns>返回符合并条件数据表的信息</returns>
    public DataTable GetDataTable(Hashtable hashCondition)
    {
        ORMap <BaseEntity> ormap = new ORMap <BaseEntity>(this);

        return(ormap.GetDataTable(hashCondition));
    }
예제 #12
0
    /// <summary>
    ///  获取实体对应表的所有信息集合,并以数据表的信息形式返回
    /// </summary>
    /// <returns>返回数据表的所有信息</returns>
    public DataTable GetDataTable()
    {
        ORMap <BaseEntity> ormap = new ORMap <BaseEntity>(this);

        return(ormap.GetDataTable(new ListDictionary()));
    }