/// <summary>
/// 按条件查询获取实体信息
/// </summary>
/// <param name="strWhere"></param>
/// <param name="strCols"></param>
/// <param name="paras"></param>
/// <returns></returns>
public T GetModel(string strWhere, string strCols, params SqlParameter[] paras)
{
//生成查询语句
string selSql = CreateSql.CreateSelectSql <T>(strWhere, strCols);
//生成Reader对象
SqlDataReader reader = SqlHelper.ExecuteReader(selSql, 1, paras);
//转换为实体对象
T model = DbConvert.SqlDataReaderToModel <T>(reader, strCols);
//关闭阅读器
reader.Close();
return(model);
}
/// <summary>
/// 按条件查询返回实体列表
/// </summary>
/// <param name="strWhere">条件</param>
/// <param name="strCols">查询字段</param>
/// <param name="paras">参数数组</param>
/// <returns>List<T></returns>
public List <T> GetModelList(string strWhere, string strCols, params SqlParameter[] paras)
{
if (string.IsNullOrEmpty(strWhere))
{
strWhere = "1=1";
}
//生成查询语句
string selSql = CreateSql.CreateSelectSql <T>(strWhere, strCols);
//生成Reader
SqlDataReader reader = SqlHelper.ExecuteReader(selSql, 1, paras);
//转换为List<T>列表
List <T> list = DbConvert.SqlDataReaderToList <T>(reader, strCols);
//关闭阅读器
reader.Close();
return(list);
}