//特殊处理获取子表 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); }