//特殊处理获取子表
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 <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 WorkInfo FirstOne(string sql)
{
DataTable dt = SqlServerDBHelper.GetDataSet(sql);
if (dt.Rows.Count == 0)
{
return(null);
}
var data = dt.Select().First();
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")
};
return(dal);
}
