/// <summary>
/// 更新索引
/// </summary>
/// <param name="questionId"></param>
public void SetQuestionFullSearch(int questionId)
{
try
{
var selectSql = @"SELECT q.QuestionId,q.Title,q.Question,q.Tags,q.NewAnswer,
q.isThematic,q.IsDelete,q.answerCount,
q.QuestionTime,q.AnswerId,q.Integration,q.SortId,q.LastAnswerTime,u.Realname, u1.Realname AS answerName,
q.LastAnswerUserId
FROM Int_Question q
LEFT JOIN Sys_Users u ON q.UserId=u.UserId
LEFT JOIN sys_users u1 ON q.LastAnswerUserId=u1.UserId
WHERE q.QuestionId=" + questionId;
FullTextIndexQuestion question = _dataAccess.FetchListBySql <FullTextIndexQuestion>(selectSql).First();
if (question.IsThematic == 1)
{
return;
}
if (question.IsDelete == 1)
{
FullTextSearchProvider.DelIndex <FullTextIndexQuestion>("intquestion", questionId);
}
else
{
FullTextSearchProvider.Index(question, "intquestion", questionId, true);
}
}
catch { }
}
internal static void IndexCourse(int courseId)
{
try
{
var dataAccess = DataAccessProvider.DataAccess;
var course = dataAccess.Get <FullTextSearchCourse>(courseId);
FullTextSearchProvider.Index(course, "course", courseId, true);
}
catch { }
}
public JsonResult InitCourseSearchIndex()
{
var list = RetechWing.DataAccess.DataAccessProvider.DataAccess.GetList <FullTextSearchCourse>();
int count = 0;
list.ForEach((t, i) =>
{
FullTextSearchProvider.Index(t, "course", t.CourseId, true);
count++;
});
return(Json(new { result = 1, msg = "初始化完成，共索引" + count + "条记录" }, JsonRequestBehavior.AllowGet));
}
public void IndexKnowledge(int id)
{
var model = GetModel(id);
var filecontent = GetFileContent(model.FileId);
if (!string.IsNullOrEmpty(filecontent))
{
model.FileContent = filecontent;
DeleteFileContent(model.FileId);
}
FullTextSearchProvider.Index(model, "knowledge", id, true);
}
public JsonResult InitTrainSearchIndex()
{
var list =
RetechWing.DataAccess.DataAccessProvider.DataAccess.FetchListBySql <TrainSearchModel>(
TrainSearchModel.GetSelectSql());
int count = 0;
list.ForEach((t, i) =>
{
FullTextSearchProvider.Index(t, "traininfo", t.TrainId, true);
count++;
});
return(Json(new { result = 1, msg = "初始化完成，共索引" + count + "条记录" }, JsonRequestBehavior.AllowGet));
}
