/// <summary> /// 查询并获得实体 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="SQLString">查询语句</param> /// <param name="cmdParms">参数列表</param> /// <returns></returns> public static T QueryEntity <T>(string SQLString, params OleDbParameter[] cmdParms) where T : new() { DataSet ds = Query(SQLString, cmdParms); if (ds.Tables[0].Rows.Count > 0) { return(EntityConverter.ToEntity <T>(ds.Tables[0].Rows[0])); } else { return(default(T)); } }
/// <summary> /// 查询并获得实体 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="SQLString">查询语句</param> /// <param name="cmdParms">参数列表</param> /// <returns></returns> public static List <T> QueryEntList <T>(string SQLString, params OleDbParameter[] cmdParms) where T : new() { DataSet ds = Query(SQLString, cmdParms); return(EntityConverter.ToList <T>(ds.Tables[0])); }
/// <summary> /// 获取实体 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="SQLString">查询语句</param> /// <param name="cmdParms">参数列表</param> /// <returns></returns> public static T ExeReaEntity <T>(string SQLString, params SqlParameter[] cmdParms) where T : new() { return(EntityConverter.ToEntity <T>(ExecuteReader(SQLString, cmdParms))); }
/// <summary> /// 获取实体集合 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="SQLString">查询语句</param> /// <param name="cmdParms">参数列表</param> /// <returns></returns> public static List <T> ExeReaEntList <T>(string SQLString, params OleDbParameter[] cmdParms) where T : new() { return(EntityConverter.ToList <T>(ExecuteReader(SQLString, cmdParms))); }
/// <summary> /// 数据库分页 /// </summary> /// <param name="SQLString">SQL</param> /// <param name="PageSize">分页大小</param> /// <param name="PageIndex">页号</param> /// <param name="cmdParms">参数</param> /// <returns></returns> public static List <T> DBPagEntList <T>(string SQLString, int PageSize, int PageIndex, params MySqlParameter[] cmdParms) where T : new() { return(EntityConverter.ToList <T>(DBPaging(SQLString, PageSize, PageIndex, cmdParms).Tables[0])); }