/// <summary>
/// 获取列表模型
/// <para>(可通过重写GetByDataRow函数更改填充模型数据方式)</para>
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="model"></param>
/// <param name="wh">sql条件(where字符任意)</param>
/// <returns></returns>
public static List <T> FindList(string wh = "")
{
List <T> rl = new List <T>();
string sql = GetSelectSQL <T>(wh);
if (!string.IsNullOrEmpty(sql))
{
DataTable dt = Dbop.GetDataTable(sql);
foreach (DataRow dr in dt.Rows)
{
rl.Add(GetModelByDataRow <T>(dr));
}
}
return(rl);
}
/// <summary>
/// 获取单个模型
/// <para>(可通过重写GetByDataRow函数更改填充模型数据方式)</para>
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="model"></param>
/// <param name="wh">sql条件(where字符任意)</param>
/// <returns></returns>
public static T Find(string wh = "")
{
string sql = GetSelectSQL <T>(wh);
if (string.IsNullOrEmpty(sql))
{
return(default(T));
}
sql = sql.Insert(6, " TOP 1");
DataTable dt = Dbop.GetDataTable(sql);
if (dt.Rows.Count == 0)
{
return(default(T));
}
return(GetModelByDataRow <T>(dt.Rows[0]));
}
