/// <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))); }
/// <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))); }