//特殊处理获取子表
public List <WorkInfo> GetWorksWhereWithDetail(string strwhere)
{
List <WorkInfo> dals = new List <WorkInfo>();
string sql = "select * from Ananas_Work where " + strwhere;
SqlDataReader data = SqlServerDBHelper.GetReader(sql);
while (data.Read())
{
WorkInfo dal = new WorkInfo()
{
ID = data["ID"].ToString(),
UID = data["UID"].ToString(),
Content = data["Content"].ToString(),
Title = data["Title"].ToString(),
Type = data["Type"].ToString(),
Cover = data["Cover"].ToString(),
Reading = data["Reading"].ToString(),
Zaning = data["Zaning"].ToString(),
ZanCount = SqlServerDBHelper.GetScalar("select COUNT(*) from Ananas_Comment where WorkID='" + data["ID"].ToString() + "' and Type='" + CommentType.Zan + "'"),
CommentsCount = SqlServerDBHelper.GetScalar("select COUNT(*) from Ananas_Comment where WorkID='" + data["ID"].ToString() + "' and Type='" + CommentType.Commrnt + "'"),
CreateDate = ((DateTime)data["CreateDate"]).ToString(@"yyyy-MM-dd HH:mm")
};
dals.Add(dal);
}
return(dals);
}
//处理收藏目录的文件计算
public List <FilesInfo> GetFileWithDetail(string strwhere)
{
List <FilesInfo> dals = new List <FilesInfo>();
string sql = "select * from Ananas_File where " + strwhere;
SqlDataReader data = SqlServerDBHelper.GetReader(sql);
while (data.Read())
{
FilesInfo dal = new FilesInfo()
{
ID = data["ID"].ToString(),
UID = data["UID"].ToString(),
Name = data["Name"].ToString(),
State = data["State"].ToString(),
Type = data["Type"].ToString(),
Extension = data["Extension"].ToString(),
CreateDate = (DateTime)data["CreateDate"],
Url = data["Url"].ToString(),
Describe = data["Describe"].ToString(),
Owner = data["Owner"].ToString(),
ParentID = data["ParentID"].ToString(),
IsPrivate = data["IsPrivate"].ToString(),
Custom = data["Custom"].ToString(),
Remark = data["Remark"].ToString(),
CoverUrl = data["CoverUrl"].ToString(),
DetailCount = SqlServerDBHelper.GetScalar("select COUNT(*) from Ananas_File where ParentID='" + data["ID"].ToString() + "'"),
FirstFile = this.FirstOne("select * from Ananas_File where ParentID='" + data["ID"].ToString() + "'")
};
dals.Add(dal);
}
return(dals);
}