///<summary>
///分页查询一个集合
///</summary>
///<param name="index">页码</param>
///<param name="size">页大小</param>
///<param name="wheres">条件匿名类</param>
///<param name="orderField">排序字段</param>
///<param name="isDesc">是否降序排序</param>
///<returns>实体集合</returns>
public IEnumerable <authData> QueryList(int index, int size, object wheres = null, string orderField = "objectId", bool isDesc = true)
{
List <SqlParameter> list = null;
string where = wheres.parseWheres(out list);
orderField = string.IsNullOrEmpty(orderField) ? "objectId" : orderField;
var sql = SqlHelper.GenerateQuerySql("authData", new string[] { "objectId", "weiboId", "qqId", "alibabaId", "wechatId" }, index, size, where, orderField, isDesc);
using (var reader = SqlHelper.ExecuteReader(sql, list.ToArray()))
{
if (reader.HasRows)
{
while (reader.Read())
{
authData model = SqlHelper.MapEntity <authData>(reader);
if (reader["weiboId"] != DBNull.Value)
{
weiboDAO weiboDAO = new weiboDAO();
model.weibo = weiboDAO.QuerySingleById((string)reader["weiboId"]);
}
if (reader["qqId"] != DBNull.Value)
{
qqDAO qqDAO = new qqDAO();
model.qq = qqDAO.QuerySingleById((string)reader["qqId"]);
}
if (reader["alibabaId"] != DBNull.Value)
{
alibabaDAO alibabaDAO = new alibabaDAO();
model.alibaba = alibabaDAO.QuerySingleById((string)reader["alibabaId"]);
}
if (reader["wechatId"] != DBNull.Value)
{
wechatDAO wechatDAO = new wechatDAO();
model.wechat = wechatDAO.QuerySingleById((string)reader["wechatId"]);
}
yield return(model);
}
}
}
}
/// <summary>
/// 查询单个模型实体
/// </summary>
/// <param name="id">objectId</param>);
/// <returns>实体</returns>);
public authData QuerySingleById(string objectId)
{
const string sql = "SELECT TOP 1 objectId,weiboId,qqId,alibabaId,wechatId from authData WHERE [objectId] = @objectId";
using (var reader = SqlHelper.ExecuteReader(sql, new SqlParameter("@objectId", objectId)))
{
if (reader.HasRows)
{
reader.Read();
authData model = SqlHelper.MapEntity <authData>(reader);
if (reader["weiboId"] != DBNull.Value)
{
weiboDAO weiboDAO = new weiboDAO();
model.weibo = weiboDAO.QuerySingleById((string)reader["weiboId"]);
}
if (reader["qqId"] != DBNull.Value)
{
qqDAO qqDAO = new qqDAO();
model.qq = qqDAO.QuerySingleById((string)reader["qqId"]);
}
if (reader["alibabaId"] != DBNull.Value)
{
alibabaDAO alibabaDAO = new alibabaDAO();
model.alibaba = alibabaDAO.QuerySingleById((string)reader["alibabaId"]);
}
if (reader["wechatId"] != DBNull.Value)
{
wechatDAO wechatDAO = new wechatDAO();
model.wechat = wechatDAO.QuerySingleById((string)reader["wechatId"]);
}
return(model);
}
else
{
return(null);
}
}
}