public bool EditKeyword(KeywordSaveViewModel item)
{
KeywordQueriedModels queriedObj = GetKeywordQueriedItemByText(item.Text);
if (queriedObj == null)
{
AddSingleKeywordQueried(item.Text, 0);
queriedObj = GetKeywordQueriedItemByText(item.Text);
}
KeywordModels keywordExist = GetKeywordItemByText(item.Text);
if (keywordExist != null && keywordExist.ID != item.ID)
{
return(false);
}
KeywordModels keywordObj = GetKeywordItem(item.ID ?? 0);
SQLData.TableObject tableObj = GetTableObj("Keywords");
tableObj.GetDataFromObject(keywordObj);
tableObj["KeywordQueriedID"] = queriedObj.ID;
tableObj["Modifier"] = Areas.Backend.Models.DataAccess.MemberDAO.SysCurrent.Id;
tableObj["ModifyTime"] = DateTime.Now;
tableObj.Update(keywordObj.ID);
return(true);
}
// 新增自定關鍵字
public bool AddKeyword(KeywordSaveViewModel item)
{
SQLData.TableObject keywordTableObj = GetTableObj("Keywords");
SQLData.TableObject queriedTableObj = GetTableObj("KeywordQueried");
KeywordQueriedModels keywordQueriedObj = GetKeywordQueriedItemByText(item.Text);
bool isNew = keywordQueriedObj == null;
// 如果 KeywordQueried 沒有的話，Keywords、KeywordQueried 各 insert 一筆
if (isNew)
{
queriedTableObj["Text"] = item.Text;
queriedTableObj["Count"] = 0;
queriedTableObj.Insert();
KeywordQueriedModels keyword = GetKeywordQueriedItemByText(item.Text);
long keywordId = keyword.ID;
int keywordCount = (int)db.GetFirstValue(" SELECT count(*) FROM Keywords ");
int maxKeywordSort = keywordCount == 0? 1: (int)db.GetFirstValue("SELECT Sort FROM Keywords ORDER BY Sort Desc");
keywordTableObj["KeywordQueriedID"] = keywordId;
keywordTableObj["Creator"] = Areas.Backend.Models.DataAccess.MemberDAO.SysCurrent.Id;
keywordTableObj["CreateTime"] = DateTime.Now;
keywordTableObj["IsIssue"] = item.IsIssue;
keywordTableObj["Sort"] = maxKeywordSort + 1;
keywordTableObj.Insert();
return(true);
}
else
{
// 如果有的話，判斷是不是已經加入關鍵字
KeywordModels keywordObj = GetKeywordItemByText(item.Text);
// 已經加入的話就不加
if (keywordObj != null)
{
return(false);
}
int keywordCount = (int)db.GetFirstValue(" SELECT count(*) FROM Keywords ");
int maxKeywordSort = keywordCount == 0 ? 1 : (int)db.GetFirstValue("SELECT Sort FROM Keywords ORDER BY Sort Desc");
keywordTableObj["KeywordQueriedID"] = keywordQueriedObj.ID;
keywordTableObj["Modifier"] = Areas.Backend.Models.DataAccess.MemberDAO.SysCurrent.Id;
keywordTableObj["ModifyTime"] = DateTime.Now;
keywordTableObj["IsIssue"] = item.IsIssue;
keywordTableObj["Sort"] = maxKeywordSort + 1;
keywordTableObj.Insert();
return(true);
}
}
public ActionResult Edit(long id)
{
KeywordQueriedModels queriedItem = keywordDao.GetKeywordQueriedItemByKeywordId(id);
KeywordSaveViewModel model = new KeywordSaveViewModel();
KeywordModels keyword = keywordDao.GetKeywordItem(id);
model.ID = id;
model.IsIssue = keyword.IsIssue;
model.Text = queriedItem.Text;
return(View(model));
}
/// <summary>
/// 新增一組使用者搜尋字串
/// </summary>
/// <param name="strSearch">搜尋字串</param>
/// <returns>新增後的 ID ，若已存在也回傳 ID </returns>
public long AddSingleKeywordQueried(string strSearch, int count = 1)
{
KeywordQueriedModels keywordQueriedObj = GetKeywordQueriedItemByText(strSearch);
SQLData.TableObject keywordQueriedTableObj = GetTableObj("KeywordQueried");
if (keywordQueriedObj == null)
{
keywordQueriedTableObj["Text"] = strSearch;
keywordQueriedTableObj["Count"] = count;
keywordQueriedTableObj.Insert();
keywordQueriedObj = GetKeywordQueriedItemByText(strSearch);
return(keywordQueriedObj.ID);
}
else
{
keywordQueriedTableObj.GetDataFromObject(keywordQueriedObj);
keywordQueriedTableObj["Count"] = keywordQueriedObj.Count + 1;
keywordQueriedTableObj.Update(keywordQueriedObj.ID);
return(keywordQueriedObj.ID);
}
}
/// <summary>
/// 以關鍵字全文取得已設定的關鍵字
/// </summary>
/// <param name="str"></param>
/// <returns></returns>
public KeywordModels GetKeywordItemByText(string str)
{
KeywordQueriedModels search = GetKeywordQueriedItemByText(str);
return(GetKeywordItemByQueriedId(search.ID));
}