public int Insert(SearchNavigationInfo searchNavigationInfo) { var searchNavigationId = 0; IDataParameter[] parms = null; var sqlInsert = BaiRongDataProvider.TableStructureDao.GetInsertSqlString(searchNavigationInfo.ToNameValueCollection(), ConnectionString, TableName, out parms); using (var conn = GetConnection()) { conn.Open(); using (var trans = conn.BeginTransaction()) { try { searchNavigationId = ExecuteNonQueryAndReturnId(trans, sqlInsert, parms); trans.Commit(); } catch { trans.Rollback(); throw; } } } return(searchNavigationId); }
public void Update(SearchNavigationInfo searchNavigationInfo) { IDataParameter[] parms = null; var sqlUpdate = BaiRongDataProvider.TableStructureDao.GetUpdateSqlString(searchNavigationInfo.ToNameValueCollection(), ConnectionString, TableName, out parms); ExecuteNonQuery(sqlUpdate, parms); }
public int Insert(SearchNavigationInfo searchNavigationInfo) { var searchNavigationID = 0; IDataParameter[] parms = null; var SQL_INSERT = BaiRongDataProvider.TableStructureDao.GetInsertSqlString(searchNavigationInfo.ToNameValueCollection(), ConnectionString, TABLE_NAME, out parms); using (var conn = GetConnection()) { conn.Open(); using (var trans = conn.BeginTransaction()) { try { ExecuteNonQuery(trans, SQL_INSERT, parms); searchNavigationID = BaiRongDataProvider.DatabaseDao.GetSequence(trans, TABLE_NAME); trans.Commit(); } catch { trans.Rollback(); throw; } } } return(searchNavigationID); }
public SearchNavigationInfo GetSearchNavigationInfo(int searchNavigationId) { SearchNavigationInfo searchNavigationInfo = null; string sqlWhere = $"WHERE ID = {searchNavigationId}"; var sqlSelect = BaiRongDataProvider.TableStructureDao.GetSelectSqlString(ConnectionString, TableName, 0, SqlUtils.Asterisk, sqlWhere, null); using (var rdr = ExecuteReader(sqlSelect)) { if (rdr.Read()) { searchNavigationInfo = new SearchNavigationInfo(rdr); } rdr.Close(); } return(searchNavigationInfo); }
public SearchNavigationInfo GetSearchNavigationInfo(int SearchNavigationID) { SearchNavigationInfo searchNavigationInfo = null; string SQL_WHERE = $"WHERE ID = {SearchNavigationID}"; var SQL_SELECT = BaiRongDataProvider.TableStructureDao.GetSelectSqlString(ConnectionString, TABLE_NAME, 0, SqlUtils.Asterisk, SQL_WHERE, null); using (var rdr = ExecuteReader(SQL_SELECT)) { if (rdr.Read()) { searchNavigationInfo = new SearchNavigationInfo(rdr); } rdr.Close(); } return(searchNavigationInfo); }
public List <SearchNavigationInfo> GetSearchNavigationInfoList(int publishmentSystemId) { var searchNavigationInfoList = new List <SearchNavigationInfo>(); string sqlWhere = $"WHERE {SearchNavigationAttribute.PublishmentSystemId} = {publishmentSystemId}"; var sqlSelect = BaiRongDataProvider.TableStructureDao.GetSelectSqlString(ConnectionString, TableName, 0, SqlUtils.Asterisk, sqlWhere, null); using (var rdr = ExecuteReader(sqlSelect)) { while (rdr.Read()) { var searchNavigationInfo = new SearchNavigationInfo(rdr); searchNavigationInfoList.Add(searchNavigationInfo); } rdr.Close(); } return(searchNavigationInfoList); }
public List <SearchNavigationInfo> GetSearchNavigationInfoList(int publishmentSystemID) { var searchNavigationInfoList = new List <SearchNavigationInfo>(); string SQL_WHERE = $"WHERE {SearchNavigationAttribute.PublishmentSystemID} = {publishmentSystemID}"; var SQL_SELECT = BaiRongDataProvider.TableStructureDao.GetSelectSqlString(ConnectionString, TABLE_NAME, 0, SqlUtils.Asterisk, SQL_WHERE, null); using (var rdr = ExecuteReader(SQL_SELECT)) { while (rdr.Read()) { var searchNavigationInfo = new SearchNavigationInfo(rdr); searchNavigationInfoList.Add(searchNavigationInfo); } rdr.Close(); } return(searchNavigationInfoList); }
public override void Submit_OnClick(object sender, EventArgs e) { if (Page.IsPostBack && Page.IsValid) { var selectedStep = 0; if (phStep1.Visible) { selectedStep = 1; } else if (phStep2.Visible) { selectedStep = 2; } else if (phStep3.Visible) { selectedStep = 3; } phStep1.Visible = phStep2.Visible = phStep3.Visible = false; if (selectedStep == 1) { var isConflict = false; var conflictKeywords = string.Empty; if (!string.IsNullOrEmpty(tbKeywords.Text)) { if (searchID > 0) { var searchInfo = DataProviderWX.SearchDAO.GetSearchInfo(searchID); isConflict = KeywordManager.IsKeywordUpdateConflict(PublishmentSystemID, searchInfo.KeywordID, PageUtils.FilterXSS(tbKeywords.Text), out conflictKeywords); } else { isConflict = KeywordManager.IsKeywordInsertConflict(PublishmentSystemID, PageUtils.FilterXSS(tbKeywords.Text), out conflictKeywords); } } if (isConflict) { FailMessage($"触发关键词“{conflictKeywords}”已存在,请设置其他关键词"); phStep1.Visible = true; } else { phStep2.Visible = true; } } else if (selectedStep == 2) { var isItemReady = true; if (isItemReady) { var itemCount = TranslateUtils.ToInt(Request.Form["itemCount"]); if (itemCount > 0) { var itemIDList = TranslateUtils.StringCollectionToIntList(Request.Form["itemID"]); var imageCssClassList = TranslateUtils.StringCollectionToStringList(Request.Form["itemImageCssClass"]); var keywordTypeList = TranslateUtils.StringCollectionToStringList(Request.Form["itemKeywordType"]); var functionIDList = TranslateUtils.StringCollectionToIntList(Request.Form["itemFunctionID"]); var channelIDList = TranslateUtils.StringCollectionToIntList(Request.Form["itemChannelID"]); var contentIDList = TranslateUtils.StringCollectionToIntList(Request.Form["itemContentID"]); var titleList = TranslateUtils.StringCollectionToStringList(Request.Form["itemTitle"]); var navigationTypeList = TranslateUtils.StringCollectionToStringList(Request.Form["itemNavigationType"]); var urlList = TranslateUtils.StringCollectionToStringList(Request.Form["itemUrl"]); var navigationInfoList = new List <SearchNavigationInfo>(); for (var i = 0; i < itemCount; i++) { var navigationInfo = new SearchNavigationInfo { ID = itemIDList[i], PublishmentSystemID = PublishmentSystemID, SearchID = searchID, Title = titleList[i], Url = urlList[i], ImageCssClass = imageCssClassList[i], NavigationType = navigationTypeList[i], KeywordType = keywordTypeList[i], FunctionID = functionIDList[i], ChannelID = channelIDList[i], ContentID = contentIDList[i] }; if (string.IsNullOrEmpty(navigationInfo.Title)) { FailMessage("保存失败,导航链接名称为必填项"); isItemReady = false; } if (string.IsNullOrEmpty(navigationInfo.ImageCssClass)) { FailMessage("保存失败,导航链接图标为必填项"); isItemReady = false; } if (navigationInfo.NavigationType == ENavigationTypeUtils.GetValue(ENavigationType.Url) && string.IsNullOrEmpty(navigationInfo.Url)) { FailMessage("保存失败,导航链接地址为必填项"); isItemReady = false; } navigationInfoList.Add(navigationInfo); } if (isItemReady) { DataProviderWX.SearchNavigationDAO.DeleteAllNotInIDList(PublishmentSystemID, searchID, itemIDList); foreach (var navigationInfo in navigationInfoList) { if (navigationInfo.ID > 0) { DataProviderWX.SearchNavigationDAO.Update(navigationInfo); } else { DataProviderWX.SearchNavigationDAO.Insert(navigationInfo); } } } } } if (isItemReady) { phStep3.Visible = true; btnSubmit.Text = "确 认"; } else { phStep2.Visible = true; } } else if (selectedStep == 3) { var searchInfo = new SearchInfo(); if (searchID > 0) { searchInfo = DataProviderWX.SearchDAO.GetSearchInfo(searchID); } searchInfo.PublishmentSystemID = PublishmentSystemID; searchInfo.KeywordID = DataProviderWX.KeywordDAO.GetKeywordID(PublishmentSystemID, searchID > 0, tbKeywords.Text, EKeywordType.Search, searchInfo.KeywordID); searchInfo.IsDisabled = !cbIsEnabled.Checked; searchInfo.Title = PageUtils.FilterXSS(tbTitle.Text); searchInfo.ImageUrl = imageUrl.Value;; searchInfo.Summary = tbSummary.Text; searchInfo.ContentImageUrl = contentImageUrl.Value; searchInfo.IsOutsiteSearch = cbIsOutsiteSearch.Checked; searchInfo.IsNavigation = cbIsNavigation.Checked; searchInfo.NavTitleColor = tbNavTitleColor.Text; searchInfo.NavImageColor = tbNavImageColor.Text; searchInfo.ImageAreaTitle = tbImageAreaTitle.Text; searchInfo.ImageAreaChannelID = TranslateUtils.ToInt(Request.Form["imageChannelID"]); searchInfo.TextAreaTitle = tbTextAreaTitle.Text; searchInfo.TextAreaChannelID = TranslateUtils.ToInt(Request.Form["textChannelID"]); try { if (searchID > 0) { DataProviderWX.SearchDAO.Update(searchInfo); LogUtils.AddLog(BaiRongDataProvider.AdministratorDao.UserName, "修改微搜索", $"微搜索:{tbTitle.Text}"); SuccessMessage("修改微搜索成功!"); } else { searchID = DataProviderWX.SearchDAO.Insert(searchInfo); DataProviderWX.SearchNavigationDAO.UpdateSearchID(PublishmentSystemID, searchID); LogUtils.AddLog(BaiRongDataProvider.AdministratorDao.UserName, "添加微搜索", $"微搜索:{tbTitle.Text}"); SuccessMessage("添加微搜索成功!"); } var redirectUrl = BackgroundSearch.GetRedirectUrl(PublishmentSystemID); AddWaitAndRedirectScript(redirectUrl); } catch (Exception ex) { FailMessage(ex, "微搜索设置失败!"); } } } }