public List <WorkInfo> GetWorksWhere(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(),
CreateDate = ((DateTime)data["CreateDate"]).ToString(@"yyyy-MM-dd HH:mm")
};
dals.Add(dal);
}
return(dals);
}
//特殊处理获取子表
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 <UserInfo> GetAll()
{
List <UserInfo> dals = new List <UserInfo>();
string sql = "select * from Ananas_User";
SqlDataReader data = SqlServerDBHelper.GetReader(sql);
while (data.Read())
{
UserInfo dal = new UserInfo()
{
ID = data["ID"].ToString(),
Name = data["Name"].ToString(),
sName = data["sName"].ToString(),
Password = data["Password"].ToString(),
Role = (int)data["RoleID"],
Skin = data["Skin"].ToString(),
Email = data["Email"].ToString(),
Introduction = data["Introduction"].ToString(),
ImageUrl = data["ImageUrl"].ToString(),
Projects = data["Projects"].ToString(),
Background = data["Background"].ToString()
};
dals.Add(dal);
}
return(dals);
}
//特殊处理图片子表
public List <FilesInfo> GetImageWithDetail(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(),
FirstSize = this.GetFirstSize(data["Custom"].ToString()),
SizeList = this.GetSizeList(data["Custom"].ToString()),
Remark = data["Remark"].ToString(),
CoverUrl = data["CoverUrl"].ToString()
};
dals.Add(dal);
}
return(dals);
}
public List <HomeInfo> GetHomeWhere(string strwhere)
{
List <HomeInfo> dals = new List <HomeInfo>();
string sql = "select * from Ananas_Home where " + strwhere;
SqlDataReader data = SqlServerDBHelper.GetReader(sql);
while (data.Read())
{
HomeInfo dal = new HomeInfo()
{
ID = data["ID"].ToString(),
UID = data["UID"].ToString(),
Name = data["Name"].ToString(),
Value = data["Value"].ToString(),
Type = data["Type"].ToString(),
Url = data["Url"].ToString(),
Color = data["Color"].ToString(),
PluginType = data["PluginType"].ToString(),
Plugin = data["Plugin"].ToString(),
WidthStyle = data["WidthStyle"].ToString(),
HeightClass = data["HeightClass"].ToString(),
GroupID = data["GroupID"].ToString(),
Order = data["Order"].ToString(),
ContentStyle = data["ContentStyle"].ToString(),
Remark = data["Remark"].ToString()
};
dals.Add(dal);
}
return(dals);
}
public List <HomeList> GetHomeWhereWithBlock(string strwhere)
{
List <HomeList> dals = new List <HomeList>();
string sql = "select * from Ananas_Home where " + strwhere;
SqlDataReader data = SqlServerDBHelper.GetReader(sql);
while (data.Read())
{
HomeList dal = new HomeList()
{
ID = data["ID"].ToString(),
UID = data["UID"].ToString(),
Type = data["Type"].ToString(),
Order = data["Order"].ToString(),
GroupClass = data["Value"].ToString(),
Blocks = this.GetHomeWhere("GroupID ='" + data["ID"].ToString() + "'").OrderBy(d => d.Order).ToList()
};
dals.Add(dal);
}
return(dals);
}
public List <CommentInfo> GetCommentSql(string sql)
{
List <CommentInfo> dals = new List <CommentInfo>();
//string sql = "select * from Ananas_Comment where " + strwhere;
SqlDataReader data = SqlServerDBHelper.GetReader(sql);
while (data.Read())
{
CommentInfo dal = new CommentInfo()
{
ID = data["ID"].ToString(),
WorkID = data["WorkID"].ToString(),
Content = data["Content"].ToString(),
IP = data["IP"].ToString(),
Type = data["Type"].ToString(),
Remark = data["Remark"].ToString(),
UID = data["UID"].ToString(),
CreateDate = ((DateTime)data["CreateDate"]).ToString(@"yyyy-MM-dd HH:mm")
};
dals.Add(dal);
}
return(dals);
}