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