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);
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(SqlTransaction sqltran, Entities.SearchLog model)
{
SqlParameter[] parameters =
{
new SqlParameter("@RecID", SqlDbType.BigInt, 8),
new SqlParameter("@SearchKey", SqlDbType.NVarChar, 900),
new SqlParameter("@Type", SqlDbType.Int, 4),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@CreateUserID", SqlDbType.Int, 4)
};
parameters[0].Value = model.RecID;
parameters[1].Value = model.SearchKey;
parameters[2].Value = model.Type;
parameters[3].Value = model.CreateTime;
parameters[4].Value = model.CreateUserID;
return(SqlHelper.ExecuteNonQuery(sqltran, CONNECTIONSTRINGS, CommandType.StoredProcedure, P_SEARCHLOG_UPDATE, parameters));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Insert(Entities.SearchLog model)
{
SqlParameter[] parameters =
{
new SqlParameter("@RecID", SqlDbType.BigInt, 8),
new SqlParameter("@SearchKey", SqlDbType.NVarChar, 900),
new SqlParameter("@Type", SqlDbType.Int, 4),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@CreateUserID", SqlDbType.Int, 4)
};
parameters[0].Direction = ParameterDirection.Output;
parameters[1].Value = model.SearchKey;
parameters[2].Value = model.Type;
parameters[3].Value = model.CreateTime;
parameters[4].Value = model.CreateUserID;
SqlHelper.ExecuteNonQuery(CONNECTIONSTRINGS, CommandType.StoredProcedure, P_SEARCHLOG_INSERT, parameters);
return(Convert.ToInt32(parameters[0].Value));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Insert(SqlTransaction sqltran, Entities.SearchLog model)
{
SqlParameter[] parameters =
{
new SqlParameter("@RecID", SqlDbType.BigInt, 8),
new SqlParameter("@SearchKey", SqlDbType.NVarChar, 900),
new SqlParameter("@Type", SqlDbType.Int, 4),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@CreateUserID", SqlDbType.Int, 4)
};
parameters[0].Direction = ParameterDirection.Output;
parameters[1].Value = model.SearchKey;
parameters[2].Value = model.Type;
parameters[3].Value = model.CreateTime;
parameters[4].Value = model.CreateUserID;
SqlHelper.ExecuteNonQuery(sqltran, CommandType.StoredProcedure, P_SEARCHLOG_INSERT, parameters);
int id = CommonFunction.ObjectToInteger(parameters[0].Value);
return(id);
}
private Entities.SearchLog LoadSingleSearchLog(DataRow row)
{
Entities.SearchLog model = new Entities.SearchLog();
if (row["RecID"].ToString() != "")
{
model.RecID = long.Parse(row["RecID"].ToString());
}
model.SearchKey = row["SearchKey"].ToString();
if (row["Type"].ToString() != "")
{
model.Type = int.Parse(row["Type"].ToString());
}
if (row["CreateTime"].ToString() != "")
{
model.CreateTime = DateTime.Parse(row["CreateTime"].ToString());
}
if (row["CreateUserID"].ToString() != "")
{
model.CreateUserID = int.Parse(row["CreateUserID"].ToString());
}
return(model);
}
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);
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(SqlTransaction sqltran, Entities.SearchLog model)
{
return(Dal.SearchLog.Instance.Update(sqltran, model));
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(Entities.SearchLog model)
{
return(Dal.SearchLog.Instance.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Insert(Entities.SearchLog model)
{
return(Dal.SearchLog.Instance.Insert(model));
}