/// <summary>
/// 获取列表
/// </summary>
/// <returns>IList</returns>
public List <PostInfo> GetPostList()
{
string cmdText = "select * from Loachs_Posts order by postid desc";
return(DataReaderToCommentList(SqliteHelper.ExecuteReader(cmdText)));
}
public List <PostInfo> GetPostList(int pageSize, int pageIndex, out int recordCount, int categoryId, int tagId, int userId, int recommend, int status, int topstatus, int hidestatus, string begindate, string enddate, string keyword)
{
string condition = " 1=1 ";
if (categoryId != -1)
{
condition += " and categoryId=" + categoryId;
}
if (tagId != -1)
{
condition += " and tag like '%{" + tagId + "}%'";
}
if (userId != -1)
{
condition += " and userid=" + userId;
}
if (recommend != -1)
{
condition += " and recommend=" + recommend;
}
if (status != -1)
{
condition += " and status=" + status;
}
if (topstatus != -1)
{
condition += " and topstatus=" + topstatus;
}
if (hidestatus != -1)
{
condition += " and hidestatus=" + hidestatus;
}
if (!string.IsNullOrEmpty(begindate))
{
condition += " and createdate>=#" + begindate + "#";
}
if (!string.IsNullOrEmpty(enddate))
{
condition += " and createdate<#" + enddate + "#";
}
if (!string.IsNullOrEmpty(keyword))
{
condition += string.Format(" and (summary like '%{0}%' or title like '%{0}%' )", keyword);
}
string cmdTotalRecord = "select count(1) from Loachs_Posts where " + condition;
// throw new Exception(cmdTotalRecord);
recordCount = StringHelper.ObjectToInt(SqliteHelper.ExecuteScalar(CommandType.Text, cmdTotalRecord));
string cmdText = SqliteHelper.GetPageSql("Loachs_Posts", "PostId", "*", pageSize, pageIndex, 1, condition);
return(DataReaderToCommentList(SqliteHelper.ExecuteReader(cmdText)));
}
//public LinkInfo GetLink(int linkid)
//{
// string cmdText = "select * from [Loachs_Links] where [linkid] = @linkid";
// SQLiteParameter[] prams = {
// SqliteHelper.MakeInParam("@linkid",DbType.Int32,4,linkid)
// };
// List<LinkInfo> list = DataReaderToList(SqliteHelper.ExecuteReader(CommandType.Text, cmdText, prams));
// return list.Count > 0 ? list[0] : null;
//}
//public List<LinkInfo> GetLinkList(int type, int position, int status)
//{
// string condition = " 1=1 ";
// if (type != -1)
// {
// condition += " and [type]=" + type;
// }
// if (position != -1)
// {
// condition += " and [position]=" + position;
// }
// if (status != -1)
// {
// condition += " and [status]=" + status;
// }
// string cmdText = "select * from [Loachs_Links] where " + condition + " order by [displayorder] asc";
// return DataReaderToList(SqliteHelper.ExecuteReader(cmdText));
//}
public List <LinkInfo> GetLinkList()
{
string cmdText = "select * from Loachs_Links order by displayorder asc,linkid asc";
return(DataReaderToList(SqliteHelper.ExecuteReader(cmdText)));
}
