/// <summary>
/// 查询一个实体类
/// </summary>
/// <returns></returns>
internal T QueryEntity <T>(string sqlStr) where T : new()
{
if (CurrentOperate == OperateEnum.None)
{
_tradstr = sqlStr;
}
SqlPageParms(1);
DbHelper.Parameters = Parameters;
DataTable dt = DbHelper.ExeDataTable(sqlStr);
if (dt != null)
{
Dictionary <string, PropertyInfo> pInfos = Sqlcom.MappingToProperty <T>(dt);
foreach (DataRow dr in dt.Rows)
{
if (dr == null)
{
return(default(T));
}
return(Sqlcom.GetFromReader <T>(dr, pInfos));
}
}
return(default(T));
}
/// <summary>
/// 查询一个实体类
/// </summary>
/// <returns></returns>
internal T QueryEntity <T>(string sqlStr) where T : new()
{
if (CurrentOperate == OperateEnum.None)
{
_tradstr = sqlStr;
}
SqlPageParms(1);
DbHelper.Parameters = Parameters;
DataTable dt = DbHelper.ExeDataTable(sqlStr);
if (dt != null)
{
Dictionary <string, PropertyInfo> pInfos = Sqlcom.MappingToProperty <T>(dt);
foreach (DataRow dr in dt.Rows)
{
if (dr == null)
{
return(default(T));
}
if (CacheHelper.IsOpenCache)
{
string cachekey = string.Format("entity_{2}_{0}_key_{1}",
TbName,
Cachekeyvalue, _appindex);
if (!IsNeedCache)
{
CacheHelper.Remove(cachekey);
T entity = Sqlcom.GetFromReader <T>(dr, pInfos);
return(entity);
}
else
{
T entity = CacheHelper.Get <T>(cachekey);
if (entity == null)
{
entity = Sqlcom.GetFromReader <T>(dr, pInfos);
CacheHelper.Insert(cachekey, entity);
}
return(entity);
}
}
return(Sqlcom.GetFromReader <T>(dr, pInfos));
}
}
return(default(T));
}