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