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

            return(view.ExecuteReaderOfFirst <T>(QuerySqlFactory.CreateQuerySqlByFilters(view.DbTypeName, typeof(T), andfilter, pvs, selectFieldNames, 1)));
        }
示例#2
0
 /// <summary>
 /// 获取指定Id的数据
 /// </summary>
 /// <typeparam name="T">数据模型类型</typeparam>
 /// <param name="view"></param>
 /// <param name="selectFieldNames">SELECT部分的字段名称数组,传null指示使用*选择</param>
 /// <param name="id">要获取数据的Id</param>
 /// <returns></returns>
 public static T GetDataById <T>(this IDataSelector view, IEnumerable <string> selectFieldNames, long id)
     where T : class, new()
 {
     return(view.ExecuteReaderOfFirst <T>(QuerySqlFactory.CreateQuerySqlByIdValue(view.DbTypeName, typeof(T), selectFieldNames, id)));
 }