/// <summary> /// 读取数据对 /// </summary> /// <param name="dBHelper">数据库链接对象</param> /// <param name="primaryKey">主键名,用于更新和寻找唯一依据字段</param> /// <param name="tableName">SQL表名</param> /// <param name="whereCondition">SQL条件判断条件【Where语句后的内容 包括排序等】</param> /// <param name="fieldNames">SQL字段名【默认为:*】</param> /// <param name="topNum">SQL取值数量【默认为:-1 无限】</param> /// <param name="isNoLock">是否不锁Sql,默认锁表</param> /// <returns></returns> public static DataEntityRows Load(SqlServerDbHelper dBHelper, string primaryKey, string tableName, string whereCondition, string fieldNames = "*", int topNum = -1, bool isNoLock = false) { if (dBHelper != null) { CommandResult result = dBHelper.CommandSQL($"SELECT {(topNum > -1 ? ("TOP(" + topNum + ")") : "")} {fieldNames} FROM {tableName} {(isNoLock ? "WITH(NOLOCK)" : "")} {(whereCondition != null && whereCondition != "" ? ("WHERE " + whereCondition) : "")}"); if (result != null && result.EffectNum > 0) { DataEntityRows dataPairs = new DataEntityRows(dBHelper, result.Collection, primaryKey, tableName, fieldNames); return(dataPairs); } } return(null); }
internal DataEntityRow(DataEntityRows p) { parent = p; }