/// <summary>
/// 查询收藏的FAQ信息
/// </summary>
/// <param name="query">查询条件</param>
/// <param name="order">排序</param>
/// <param name="currentPage">页号,-1不分页</param>
/// <param name="pageSize">每页记录数</param>
/// <param name="totalCount">总行数</param>
/// <returns>集合</returns>
public DataTable GetCollectedFAQData(QueryKLFavorites query, string order, int currentPage, int pageSize, out int totalCount)
{
string where = string.Empty;
where += getCommonWhere(query);
DataSet ds;
SqlParameter[] parameters =
{
new SqlParameter("@where", SqlDbType.NVarChar, 40000),
new SqlParameter("@order", SqlDbType.NVarChar, 200),
new SqlParameter("@pagesize", SqlDbType.Int, 4),
new SqlParameter("@indexpage", SqlDbType.Int, 4),
new SqlParameter("@totalRecorder", SqlDbType.Int, 4)
};
parameters[0].Value = where;
parameters[1].Value = order;
parameters[2].Value = pageSize;
parameters[3].Value = currentPage;
parameters[4].Direction = ParameterDirection.Output;
ds = SqlHelper.ExecuteDataset(CONNECTIONSTRINGS, CommandType.StoredProcedure, P_PersonalCollection_Select_FAQ, parameters);
totalCount = (int)(parameters[4].Value);
return(ds.Tables[0]);
}
public string getCommonWhere(QueryKLFavorites query)
{
string where = string.Empty;
if (query.Id != Constant.INT_INVALID_VALUE)
{
where += " and Id=" + query.Id;
}
if (query.UserId != Constant.INT_INVALID_VALUE)
{
where += " and UserId=" + query.UserId;
}
if (query.KLRefId != Constant.INT_INVALID_VALUE)
{
where += " and KLRefId=" + query.KLRefId;
}
if (query.Type != Constant.INT_INVALID_VALUE)
{
where += " and Type=" + query.Type;
}
if (query.CreateTime != Constant.DATE_INVALID_VALUE)
{
where += " and CONVERT(VARCHAR(10),CreateTime,120) ='" + query.CreateTime.ToString("yyyy-MM-dd") + "'";
}
return(where);
}
public void BindData()
{
QueryKLFavorites query = new QueryKLFavorites();
query.UserId = BLL.Util.GetLoginUserID();
query.Type = 0;
DataTable dt = BLL.Personalization.Instance.GetCollectedKnowledgeData(query, " CreateDate DESC", BLL.PageCommon.Instance.PageIndex, 10, out RecordCount);
repeaterTableList.DataSource = dt;
repeaterTableList.DataBind();
litPagerDown.Text = BLL.PageCommon.Instance.LinkStringByPost(BLL.Util.GetUrl(), 8, RecordCount, 10, BLL.PageCommon.Instance.PageIndex, 1);
}
public DataTable GetCollectedFAQData(QueryKLFavorites query, string order, int currentPage, int pageSize, out int totalCount)
{
return(Dal.Personalization.Instance.GetCollectedFAQData(query, order, currentPage, pageSize, out totalCount));
}
