public void BindData_old()
{
Entities.QueryKLFAQ query = new QueryKLFAQ();
if (RequestKeywords != "")
{
query.Keywords = RequestKeywords;
#region 添加搜索关键字
Entities.SearchLog searchLog = new Entities.SearchLog();
searchLog.SearchKey = RequestKeywords;
searchLog.Type = 2;
searchLog.CreateTime = DateTime.Now;
searchLog.CreateUserID = BLL.Util.GetLoginUserID();
BLL.SearchLog.Instance.Insert(searchLog);
#endregion
}
if (RequestKCID != "")
{
query.KCIDs = RequestKCID;
}
query.State = "2";
int RecordCount = 0;
DataTable dt = BLL.KLFAQ.Instance.GetKLFAQ(query, "KLFAQ.CreateTime DESC", BLL.PageCommon.Instance.PageIndex, 10, out RecordCount);
Rt_FAQ.DataSource = dt;
Rt_FAQ.DataBind();
litPagerDown.Text = BLL.PageCommon.Instance.LinkStringByPost(BLL.Util.GetUrl(), 10, RecordCount, 10, BLL.PageCommon.Instance.PageIndex, 1);
}
public void BindData()
{
RecordCount = 0;
QueryKLFavorites query = new QueryKLFavorites();
query.UserId = BLL.Util.GetLoginUserID();
query.Type = 1;
DataTable dt = BLL.Personalization.Instance.GetCollectedFAQData(query, "CreateDate DESC", BLL.PageCommon.Instance.PageIndex, 10, out RecordCount);
Rt_FAQ.DataSource = dt;
Rt_FAQ.DataBind();
litPagerDown.Text = BLL.PageCommon.Instance.LinkStringByPost(BLL.Util.GetUrl(), 8, RecordCount, 10, BLL.PageCommon.Instance.PageIndex, 1);
}
public void BindData()
{
#region 添加搜索关键字
if (RequestKeywords != "")
{
Entities.SearchLog searchLog = new Entities.SearchLog();
searchLog.SearchKey = RequestKeywords;
searchLog.Type = 2;
searchLog.CreateTime = DateTime.Now;
searchLog.CreateUserID = BLL.Util.GetLoginUserID();
BLL.SearchLog.Instance.Insert(searchLog);
}
#endregion
#region 整理Where
StringBuilder sb = new StringBuilder();
//sb.Append(BLL.UserGroupDataRigth.Instance.GetSqlRightstr("a", "BGID", "CreateUserID", BLL.Util.GetLoginUserID()));
if (RequestKCPID != "-1")
{
sb.Append(" and c.ppid=");
sb.Append(RequestKCPID.ToString());
}
if (RequestKCID != "-1")
{
sb.Append(" and c.kcid=");
sb.Append(RequestKCID.ToString());
}
if (!string.IsNullOrEmpty(RequestKeywords))
{
var keyWorsArray = RequestKeywords.Split(' ').Where(s => !string.IsNullOrEmpty(s)).ToArray();
if (keyWorsArray.Length > 0)
{
sb.Append(" and (");
foreach (string s in keyWorsArray)
{
sb.Append(string.Format(" a.Ask like '%{0}%' OR a.Question like '%{0}%' or", BitAuto.Utils.StringHelper.SqlFilter(s)));
}
sb.Remove(sb.Length - 3, 3);
sb.Append(") ");
}
}
var orderQuery = Oreder;
if (string.IsNullOrEmpty(orderQuery))
{
orderQuery = "a.CreateTime desc";
}
#endregion
DataSet ds = BLL.KLFAQ.Instance.GetKLFAQReport(BLL.Util.GetLoginUserID(), orderQuery, sb.ToString(), BLL.PageCommon.Instance.PageIndex, 10);
sb = new StringBuilder();
DataTable dt = ds.Tables[0];
if (dt == null || dt.Rows.Count < 1)
{
return;
}
DataRow[] arrayDR = dt.Select("flag=1");
DataRow[] drT;
string idT = "";
try
{
RecordCount = Convert.ToInt32(dt.Select("flag=2")[0]["num"]);
}
catch
{
RecordCount = 0;
}
int i = 0;
foreach (DataRow dr in arrayDR) //flag=1
{
if (i == 0)
{
sb.Append("<ul>");
sb.Append(" <li>全部（" + RecordCount.ToString() + "）</li>");
}
else if (i % 7 == 0)
{
sb.Append("</ul>");
if (i == 7)
{
sb.Append("<span class='more dnowup' id='btnMore'><a href='#'>更多</a></span>");
}
sb.Append("<ul style='display: none;'><li></li>");
}
idT = dr["ppid"].ToString();
sb.Append(string.Format("<li><a class='aC' href='javascript:void(0)' lev='1' did='{0}'>{1}({2})</a>", idT, dr["ppname"].ToString(), dr["num"]));
drT = dt.Select("ppid=" + idT + " and flag=0");
if (drT.Length > 0)
{
sb.Append("<div class='arrow' style='display: none;'></div><ul style='display: none;'>");
foreach (DataRow dr2 in drT)
{
sb.Append(string.Format("<li><a class='aC' href='javascript:void(0)' lev='2' did='{0}'>{1}({2})</a></li>", dr2["KCID"], dr2["kcname"], dr2["num"]));
}
sb.Append("</ul>");
}
sb.Append("</li>");
i++;
}
sb.Append("</ul>");
lbKLC.Text = sb.ToString();
Rt_FAQ.DataSource = ds.Tables[1];
Rt_FAQ.DataBind();
litPagerDown.Text = BLL.PageCommon.Instance.LinkStringByPost(BLL.Util.GetUrl(), 8, RecordCount, 10, BLL.PageCommon.Instance.PageIndex, 1);
}
