/// <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)); }