Пример #1
0
        /// <summary>
        /// 获取指定anditems条件数组为并且的查询对象
        /// </summary>
        /// <param name="view"></param>
        /// <param name="modelType">数据模型类型</param>
        /// <param name="anditems">并且表达式</param>
        /// <param name="paramets">表达式参数数组</param>
        /// <param name="selectFieldNames">SELECT部分的字段名称数组,传null指示使用*选择</param>
        /// <returns></returns>
        public static object GetDataByAndFilterExpress(this IDataSelector view, Type modelType, IEnumerable <string> anditems, IEnumerable <IDataParamet> paramets, IEnumerable <string> selectFieldNames)
        {
            IEnumerable <IDataParamet> pvs;
            string andfilter = QuerySqlFactory.UnionWhereForAnd(view.DbTypeName, anditems, paramets, out pvs);

            return(view.ExecuteReaderOfFirstFor(QuerySqlFactory.CreateQuerySqlByFilters(view.DbTypeName, modelType, andfilter, pvs, selectFieldNames, 1)));
        }
Пример #2
0
 /// <summary>
 /// 获取指定Id的数据
 /// </summary>
 /// <param name="view"></param>
 /// <param name="modelType">数据模型类型</param>
 /// <param name="selectFieldNames">SELECT部分的字段名称数组,传null指示使用*选择</param>
 /// <param name="id">要获取数据的Id</param>
 /// <returns></returns>
 public static object GetDataById(this IDataSelector view, Type modelType, IEnumerable <string> selectFieldNames, long id)
 {
     return(view.ExecuteReaderOfFirstFor(QuerySqlFactory.CreateQuerySqlByIdValue(view.DbTypeName, modelType, selectFieldNames, id)));
 }