public void Update(KeywordInfo keywordInfo) { if (keywordInfo != null && keywordInfo.KeywordId > 0) { var parms = new IDataParameter[] { GetParameter(ParmPublishmentSystemId, EDataType.Integer, keywordInfo.PublishmentSystemId), GetParameter(ParmKeywords, EDataType.NVarChar, 255, keywordInfo.Keywords), GetParameter(ParmIsDisabled, EDataType.VarChar, 18, keywordInfo.IsDisabled.ToString()), GetParameter(ParmKeywordType, EDataType.VarChar, 50, EKeywordTypeUtils.GetValue(keywordInfo.KeywordType)), GetParameter(ParmMatchType, EDataType.VarChar, 50, EMatchTypeUtils.GetValue(keywordInfo.MatchType)), GetParameter(ParmReply, EDataType.NText, keywordInfo.Reply), GetParameter(ParmAddDate, EDataType.DateTime, keywordInfo.AddDate), GetParameter(ParmTaxis, EDataType.Integer, keywordInfo.Taxis), GetParameter(ParmKeywordId, EDataType.Integer, keywordInfo.KeywordId) }; ExecuteNonQuery(SqlUpdate, parms); DataProviderWx.KeywordMatchDao.DeleteByKeywordId(keywordInfo.KeywordId); foreach (var str in TranslateUtils.StringCollectionToStringList(keywordInfo.Keywords, ' ')) { var keyword = str.Trim(); if (!string.IsNullOrEmpty(keyword)) { DataProviderWx.KeywordMatchDao.Insert(new KeywordMatchInfo(0, keywordInfo.PublishmentSystemId, keyword, keywordInfo.KeywordId, keywordInfo.IsDisabled, keywordInfo.KeywordType, keywordInfo.MatchType)); } } } }
public void Update(KeywordInfo keywordInfo) { if (keywordInfo != null && keywordInfo.KeywordID > 0) { var parms = new IDataParameter[] { GetParameter(PARM_PUBLISHMENT_SYSTEM_ID, EDataType.Integer, keywordInfo.PublishmentSystemID), GetParameter(PARM_KEYWORDS, EDataType.NVarChar, 255, keywordInfo.Keywords), GetParameter(PARM_IS_DISABLED, EDataType.VarChar, 18, keywordInfo.IsDisabled.ToString()), GetParameter(PARM_KEYWORD_TYPE, EDataType.VarChar, 50, EKeywordTypeUtils.GetValue(keywordInfo.KeywordType)), GetParameter(PARM_MATCH_TYPE, EDataType.VarChar, 50, EMatchTypeUtils.GetValue(keywordInfo.MatchType)), GetParameter(PARM_REPLY, EDataType.NText, keywordInfo.Reply), GetParameter(PARM_ADD_DATE, EDataType.DateTime, keywordInfo.AddDate), GetParameter(PARM_TAXIS, EDataType.Integer, keywordInfo.Taxis), GetParameter(PARM_KEYWORD_ID, EDataType.Integer, keywordInfo.KeywordID) }; ExecuteNonQuery(SQL_UPDATE, parms); DataProviderWX.KeywordMatchDAO.DeleteByKeywordID(keywordInfo.KeywordID); foreach (var str in TranslateUtils.StringCollectionToStringList(keywordInfo.Keywords, ' ')) { var keyword = str.Trim(); if (!string.IsNullOrEmpty(keyword)) { DataProviderWX.KeywordMatchDAO.Insert(new KeywordMatchInfo(0, keywordInfo.PublishmentSystemID, keyword, keywordInfo.KeywordID, keywordInfo.IsDisabled, keywordInfo.KeywordType, keywordInfo.MatchType)); } } } }
void rptContents_ItemDataBound(object sender, RepeaterItemEventArgs e) { if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { var ltlTitle = e.Item.FindControl("ltlTitle") as Literal; var functionID = TranslateUtils.EvalInt(e.Item.DataItem, "ID"); var keywordType = EKeywordTypeUtils.GetEnumType(ddlKeywordType.SelectedValue); var pageTitle = KeywordManager.GetFunctionName(keywordType, functionID); var clickString = string.Empty; if (Request.QueryString["itemIndex"] != null) { clickString = $@"window.parent.{jsMethod}({itemIndex}, '{EKeywordTypeUtils.GetValue(keywordType)}', {functionID}, '{pageTitle}');{JsUtils .OpenWindow.HIDE_POP_WIN}"; } else { clickString = $@"window.parent.{jsMethod}('{EKeywordTypeUtils.GetValue(keywordType)},{functionID},{pageTitle}');{JsUtils .OpenWindow.HIDE_POP_WIN}"; } ltlTitle.Text = $@" <div class=""alert alert-success pull-left"" style=""margin:5px;padding-right:14px; cursor:pointer;"" onclick=""{clickString}""> <strong style=""color: #468847"">{pageTitle}</strong> </div>"; } }
public string GetFunctionOrChannelOrContentSelectScript(WebMenuInfo menuInfo) { if (ENavigationTypeUtils.Equals(menuInfo.NavigationType, ENavigationType.Function)) { if (menuInfo.FunctionId > 0) { var functionName = KeywordManager.GetFunctionName(EKeywordTypeUtils.GetEnumType(menuInfo.KeywordType), menuInfo.FunctionId); return($@"selectKeyword(""{menuInfo.KeywordType},{menuInfo.FunctionId},{functionName}"")"); } } else if (ENavigationTypeUtils.Equals(menuInfo.NavigationType, ENavigationType.Site)) { if (menuInfo.ContentId > 0) { var tableStyle = NodeManager.GetTableStyle(PublishmentSystemInfo, menuInfo.ChannelId); var tableName = NodeManager.GetTableName(PublishmentSystemInfo, menuInfo.ChannelId); var contentInfo = DataProvider.ContentDao.GetContentInfo(tableStyle, tableName, menuInfo.ContentId); var pageUrl = PageUtilityWX.GetContentUrl(PublishmentSystemInfo, contentInfo); return ($@"contentSelect(""{contentInfo.Title}"", ""{menuInfo.ChannelId}"", ""{menuInfo.ContentId}"", ""{pageUrl}"")"); } else if (menuInfo.ChannelId > 0) { var nodeNames = NodeManager.GetNodeNameNavigation(PublishmentSystemId, menuInfo.ChannelId); var pageUrl = PageUtilityWX.GetChannelUrl(PublishmentSystemInfo, NodeManager.GetNodeInfo(PublishmentSystemId, menuInfo.ChannelId)); return($"selectChannel('{nodeNames}', '{menuInfo.ChannelId}', '{pageUrl}');"); } } return(string.Empty); }
public void ReFresh(object sender, EventArgs e) { try { if (!string.IsNullOrEmpty(DdlKeywordType.SelectedValue)) { SpContents.ControlToPaginate = RptContents; var keywordType = EKeywordTypeUtils.GetEnumType(DdlKeywordType.SelectedValue); SpContents.SelectCommand = KeywordManager.GetFunctionSqlString(PublishmentSystemId, keywordType); SpContents.ItemsPerPage = 50; SpContents.SortField = "ID"; SpContents.SortMode = SortMode.DESC; RptContents.ItemDataBound += rptContents_ItemDataBound; SpContents.DataBind(); PhFunction.Visible = RptContents.Items.Count > 0; } } catch (Exception ex) { PageUtils.RedirectToErrorPage(ex.Message); } }
public void ReFresh(object sender, EventArgs e) { try { if (!string.IsNullOrEmpty(ddlKeywordType.SelectedValue)) { spContents.ControlToPaginate = rptContents; spContents.ConnectionString = BaiRongDataProvider.ConnectionString; var keywordType = EKeywordTypeUtils.GetEnumType(ddlKeywordType.SelectedValue); spContents.SelectCommand = KeywordManager.GetFunctionSqlString(PublishmentSystemID, keywordType); spContents.ItemsPerPage = 50; spContents.SortField = "ID"; spContents.SortMode = SortMode.DESC; rptContents.ItemDataBound += new RepeaterItemEventHandler(rptContents_ItemDataBound); spContents.DataBind(); phFunction.Visible = rptContents.Items.Count > 0; } } catch (Exception ex) { PageUtils.RedirectToErrorPage(ex.Message); } }
public IEnumerable GetDataSource(int publishmentSystemId, EKeywordType keywordType) { var parms = new IDataParameter[] { GetParameter(ParmPublishmentSystemId, EDataType.Integer, publishmentSystemId), GetParameter(ParmKeywordType, EDataType.VarChar, 50, EKeywordTypeUtils.GetValue(keywordType)) }; var enumerable = (IEnumerable)ExecuteReader(SqlSelectAllByType, parms); return(enumerable); }
public IEnumerable GetDataSource(int publishmentSystemID, EKeywordType keywordType) { var parms = new IDataParameter[] { GetParameter(PARM_PUBLISHMENT_SYSTEM_ID, EDataType.Integer, publishmentSystemID), GetParameter(PARM_KEYWORD_TYPE, EDataType.VarChar, 50, EKeywordTypeUtils.GetValue(keywordType)) }; var enumerable = (IEnumerable)ExecuteReader(SQL_SELECT_ALL_BY_TYPE, parms); return(enumerable); }
void rptContents_ItemDataBound(object sender, RepeaterItemEventArgs e) { if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { var keywordId = SqlUtils.EvalInt(e.Item.DataItem, "KeywordId"); var keyword = SqlUtils.EvalString(e.Item.DataItem, "Keyword"); var keywordType = EKeywordTypeUtils.GetEnumType(SqlUtils.EvalString(e.Item.DataItem, "KeywordType")); var ltlKeyword = e.Item.FindControl("ltlKeyword") as Literal; ltlKeyword.Text = $@"<div class=""alert alert-success pull-left"" style=""margin:5px;padding-right:14px; cursor:pointer;"" onclick=""window.parent.{_jsMethod}('{keyword}');;window.parent.closeWindow();""><strong style=""color: #468847"">{keyword}</strong> ({EKeywordTypeUtils.GetText(keywordType)})</div>"; } }
public int Insert(KeywordInfo keywordInfo) { var keywordID = 0; var sqlString = "INSERT INTO wx_Keyword (PublishmentSystemID, Keywords, IsDisabled, KeywordType, MatchType, Reply, AddDate, Taxis) VALUES (@PublishmentSystemID, @Keywords, @IsDisabled, @KeywordType, @MatchType, @Reply, @AddDate, @Taxis)"; var taxis = GetMaxTaxis(keywordInfo.PublishmentSystemID, keywordInfo.KeywordType) + 1; var parms = new IDataParameter[] { GetParameter(PARM_PUBLISHMENT_SYSTEM_ID, EDataType.Integer, keywordInfo.PublishmentSystemID), GetParameter(PARM_KEYWORDS, EDataType.NVarChar, 255, keywordInfo.Keywords), GetParameter(PARM_IS_DISABLED, EDataType.VarChar, 18, keywordInfo.IsDisabled.ToString()), GetParameter(PARM_KEYWORD_TYPE, EDataType.VarChar, 50, EKeywordTypeUtils.GetValue(keywordInfo.KeywordType)), GetParameter(PARM_MATCH_TYPE, EDataType.VarChar, 50, EMatchTypeUtils.GetValue(keywordInfo.MatchType)), GetParameter(PARM_REPLY, EDataType.NText, keywordInfo.Reply), GetParameter(PARM_ADD_DATE, EDataType.DateTime, keywordInfo.AddDate), GetParameter(PARM_TAXIS, EDataType.Integer, taxis) }; using (var conn = GetConnection()) { conn.Open(); using (var trans = conn.BeginTransaction()) { try { ExecuteNonQuery(trans, sqlString, parms); keywordID = BaiRongDataProvider.DatabaseDao.GetSequence(trans, "wx_Keyword"); trans.Commit(); } catch { trans.Rollback(); throw; } } } foreach (var str in TranslateUtils.StringCollectionToStringList(keywordInfo.Keywords, ' ')) { var keyword = str.Trim(); if (!string.IsNullOrEmpty(keyword)) { DataProviderWX.KeywordMatchDAO.Insert(new KeywordMatchInfo(0, keywordInfo.PublishmentSystemID, keyword, keywordID, keywordInfo.IsDisabled, keywordInfo.KeywordType, keywordInfo.MatchType)); } } return(keywordID); }
public int Insert(KeywordInfo keywordInfo) { var keywordId = 0; var sqlString = "INSERT INTO wx_Keyword (PublishmentSystemID, Keywords, IsDisabled, KeywordType, MatchType, Reply, AddDate, Taxis) VALUES (@PublishmentSystemID, @Keywords, @IsDisabled, @KeywordType, @MatchType, @Reply, @AddDate, @Taxis)"; var taxis = GetMaxTaxis(keywordInfo.PublishmentSystemId, keywordInfo.KeywordType) + 1; var parms = new IDataParameter[] { GetParameter(ParmPublishmentSystemId, EDataType.Integer, keywordInfo.PublishmentSystemId), GetParameter(ParmKeywords, EDataType.NVarChar, 255, keywordInfo.Keywords), GetParameter(ParmIsDisabled, EDataType.VarChar, 18, keywordInfo.IsDisabled.ToString()), GetParameter(ParmKeywordType, EDataType.VarChar, 50, EKeywordTypeUtils.GetValue(keywordInfo.KeywordType)), GetParameter(ParmMatchType, EDataType.VarChar, 50, EMatchTypeUtils.GetValue(keywordInfo.MatchType)), GetParameter(ParmReply, EDataType.NText, keywordInfo.Reply), GetParameter(ParmAddDate, EDataType.DateTime, keywordInfo.AddDate), GetParameter(ParmTaxis, EDataType.Integer, taxis) }; using (var conn = GetConnection()) { conn.Open(); using (var trans = conn.BeginTransaction()) { try { keywordId = ExecuteNonQueryAndReturnId(trans, sqlString, parms); trans.Commit(); } catch { trans.Rollback(); throw; } } } foreach (var str in TranslateUtils.StringCollectionToStringList(keywordInfo.Keywords, ' ')) { var keyword = str.Trim(); if (!string.IsNullOrEmpty(keyword)) { DataProviderWx.KeywordMatchDao.Insert(new KeywordMatchInfo(0, keywordInfo.PublishmentSystemId, keyword, keywordId, keywordInfo.IsDisabled, keywordInfo.KeywordType, keywordInfo.MatchType)); } } return(keywordId); }
public void Page_Load(object sender, EventArgs e) { if (IsForbidden) { return; } PageUtils.CheckRequestParameter("PublishmentSystemID"); jsMethod = Request.QueryString["jsMethod"]; spContents.ControlToPaginate = rptContents; spContents.ConnectionString = BaiRongDataProvider.ConnectionString; if (Request.QueryString["keywordType"] == null) { spContents.SelectCommand = DataProviderWX.KeywordMatchDAO.GetSelectString(PublishmentSystemID); } else { var keywordType = Request.QueryString["keywordType"]; var keyword = Request.QueryString["keyword"]; spContents.SelectCommand = DataProviderWX.KeywordMatchDAO.GetSelectString(PublishmentSystemID, keywordType, keyword); } spContents.ItemsPerPage = 50; spContents.SortField = DataProviderWX.KeywordMatchDAO.GetSortField(); spContents.SortMode = SortMode.DESC; rptContents.ItemDataBound += new RepeaterItemEventHandler(rptContents_ItemDataBound); if (!IsPostBack) { BreadCrumb(AppManager.CMS.LeftMenu.ID_Content, "关键词搜索", string.Empty); var listItem = new ListItem("所有类型", string.Empty); ddlKeywordType.Items.Add(listItem); EKeywordTypeUtils.AddListItems(ddlKeywordType); if (Request.QueryString["keywordType"] != null) { var keywordType = Request.QueryString["keywordType"]; var keyword = Request.QueryString["keyword"]; ControlUtils.SelectListItems(ddlKeywordType, keywordType); tbKeyword.Text = keyword; } spContents.DataBind(); } }
public void Insert(KeywordMatchInfo matchInfo) { var sqlString = "INSERT INTO wx_KeywordMatch (PublishmentSystemID, Keyword, KeywordID, IsDisabled, KeywordType, MatchType) VALUES (@PublishmentSystemID, @Keyword, @KeywordID, @IsDisabled, @KeywordType, @MatchType)"; var parms = new IDataParameter[] { GetParameter(ParmPublishmentSystemId, EDataType.Integer, matchInfo.PublishmentSystemId), GetParameter(ParmKeyword, EDataType.NVarChar, 255, matchInfo.Keyword), GetParameter(ParmKeywordId, EDataType.Integer, matchInfo.KeywordId), GetParameter(ParmIsDisabled, EDataType.VarChar, 18, matchInfo.IsDisabled.ToString()), GetParameter(ParmKeywordType, EDataType.VarChar, 50, EKeywordTypeUtils.GetValue(matchInfo.KeywordType)), GetParameter(ParmMatchType, EDataType.VarChar, 50, EMatchTypeUtils.GetValue(matchInfo.MatchType)) }; ExecuteNonQuery(sqlString, parms); }
public void Insert(KeywordMatchInfo matchInfo) { var sqlString = "INSERT INTO wx_KeywordMatch (PublishmentSystemID, Keyword, KeywordID, IsDisabled, KeywordType, MatchType) VALUES (@PublishmentSystemID, @Keyword, @KeywordID, @IsDisabled, @KeywordType, @MatchType)"; var parms = new IDataParameter[] { GetParameter(PARM_PUBLISHMENT_SYSTEM_ID, EDataType.Integer, matchInfo.PublishmentSystemID), GetParameter(PARM_KEYWORD, EDataType.NVarChar, 255, matchInfo.Keyword), GetParameter(PARM_KEYWORD_ID, EDataType.Integer, matchInfo.KeywordID), GetParameter(PARM_IS_DISABLED, EDataType.VarChar, 18, matchInfo.IsDisabled.ToString()), GetParameter(PARM_KEYWORD_TYPE, EDataType.VarChar, 50, EKeywordTypeUtils.GetValue(matchInfo.KeywordType)), GetParameter(PARM_MATCH_TYPE, EDataType.VarChar, 50, EMatchTypeUtils.GetValue(matchInfo.MatchType)) }; ExecuteNonQuery(sqlString, parms); }
public void Page_Load(object sender, EventArgs e) { if (IsForbidden) { return; } PageUtils.CheckRequestParameter("PublishmentSystemId"); _jsMethod = Request.QueryString["jsMethod"]; SpContents.ControlToPaginate = RptContents; if (Request.QueryString["keywordType"] == null) { SpContents.SelectCommand = DataProviderWx.KeywordMatchDao.GetSelectString(PublishmentSystemId); } else { var keywordType = Request.QueryString["keywordType"]; var keyword = Request.QueryString["keyword"]; SpContents.SelectCommand = DataProviderWx.KeywordMatchDao.GetSelectString(PublishmentSystemId, keywordType, keyword); } SpContents.ItemsPerPage = 50; SpContents.SortField = DataProviderWx.KeywordMatchDao.GetSortField(); SpContents.SortMode = SortMode.DESC; RptContents.ItemDataBound += rptContents_ItemDataBound; if (!IsPostBack) { var listItem = new ListItem("所有类型", string.Empty); DdlKeywordType.Items.Add(listItem); EKeywordTypeUtils.AddListItems(DdlKeywordType); if (Request.QueryString["keywordType"] != null) { var keywordType = Request.QueryString["keywordType"]; var keyword = Request.QueryString["keyword"]; ControlUtils.SelectListItems(DdlKeywordType, keywordType); TbKeyword.Text = keyword; } SpContents.DataBind(); } }
public void Page_Load(object sender, EventArgs e) { if (IsForbidden) { return; } PageUtils.CheckRequestParameter("PublishmentSystemId"); _jsMethod = Request.QueryString["jsMethod"]; _itemIndex = Body.GetQueryInt("itemIndex"); if (!IsPostBack) { EKeywordTypeUtils.AddListItemsUrlOnly(DdlKeywordType); DdlKeywordType.Items.Insert(0, new ListItem("<选择微功能类型>", string.Empty)); ReFresh(null, EventArgs.Empty); } }
void rptContents_ItemDataBound(object sender, RepeaterItemEventArgs e) { if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { var keywordID = TranslateUtils.EvalInt(e.Item.DataItem, "KeywordID"); var keyword = TranslateUtils.EvalString(e.Item.DataItem, "Keyword"); var keywordType = EKeywordTypeUtils.GetEnumType(TranslateUtils.EvalString(e.Item.DataItem, "KeywordType")); var ltlKeyword = e.Item.FindControl("ltlKeyword") as Literal; string urlDelete = $@"{GetRedirectUrl(PublishmentSystemID)}&delete=true&deleteKeywordID={keywordID}&deleteKeyword={keyword}"; ltlKeyword.Text = $@"<div class=""alert alert-success pull-left"" style=""margin:5px;padding-right:14px;""><strong style=""color: #468847"">{keyword}</strong> ({EKeywordTypeUtils .GetText(keywordType)}) <a href=""javascript:;"" onclick=""{Modal.KeywordEdit .GetOpenWindowString(PublishmentSystemID, keywordID, keyword)}""><i class=""icon-edit""></i></a> <a href=""{urlDelete}"" onclick=""javascript:return confirm('此操作将删除关键字“{keyword}”,确认吗?');""><i class=""icon-remove""></i></a></div>"; } }
public List <string> GetKeywordList(int publishmentSystemId, EKeywordType keywordType) { var list = new List <string>(); var parms = new IDataParameter[] { GetParameter(ParmPublishmentSystemId, EDataType.Integer, publishmentSystemId), GetParameter(ParmKeywordType, EDataType.VarChar, 50, EKeywordTypeUtils.GetValue(keywordType)) }; using (var rdr = ExecuteReader(SqlSelectKeyowrdByType, parms)) { while (rdr.Read()) { list.Add(rdr.GetValue(0).ToString()); } rdr.Close(); } return(list); }
public void Page_Load(object sender, EventArgs e) { if (IsForbidden) { return; } PageUtils.CheckRequestParameter("PublishmentSystemID"); jsMethod = Request.QueryString["jsMethod"]; itemIndex = TranslateUtils.ToInt(GetQueryString("itemIndex")); if (!IsPostBack) { BreadCrumb(AppManager.CMS.LeftMenu.ID_Content, "微功能搜索", string.Empty); EKeywordTypeUtils.AddListItemsUrlOnly(ddlKeywordType); ddlKeywordType.Items.Insert(0, new ListItem("<选择微功能类型>", string.Empty)); ReFresh(null, EventArgs.Empty); } }
public object GetValue(string attributeName) { foreach (var name in AllAttributes) { if (StringUtils.EqualsIgnoreCase(name, attributeName)) { var nameVlaue = GetType().GetProperty(name).GetValue(this, null); if (attributeName == "KeywordType") { return(EKeywordTypeUtils.GetEnumType(nameVlaue.ToString())); } if (attributeName == "MatchType") { return(EMatchTypeUtils.GetEnumType(nameVlaue.ToString())); } return(nameVlaue); } } return(null); }
public List <string> GetKeywordList(int publishmentSystemID, EKeywordType keywordType) { var list = new List <string>(); var parms = new IDataParameter[] { GetParameter(PARM_PUBLISHMENT_SYSTEM_ID, EDataType.Integer, publishmentSystemID), GetParameter(PARM_KEYWORD_TYPE, EDataType.VarChar, 50, EKeywordTypeUtils.GetValue(keywordType)) }; using (var rdr = ExecuteReader(SQL_SELECT_KEYOWRD_BY_TYPE, parms)) { while (rdr.Read()) { list.Add(rdr.GetValue(0).ToString()); } rdr.Close(); } return(list); }
public void Update(int publishmentSystemId, int keywordId, EKeywordType keywordType, EMatchType matchType, string keywords) { var parms = new IDataParameter[] { GetParameter(ParmKeywords, EDataType.NVarChar, 255, keywords), GetParameter(ParmKeywordType, EDataType.VarChar, 50, EKeywordTypeUtils.GetValue(keywordType)), GetParameter(ParmKeywordId, EDataType.Integer, keywordId) }; ExecuteNonQuery(SqlUpdateKeywrods, parms); DataProviderWx.KeywordMatchDao.DeleteByKeywordId(keywordId); foreach (var str in TranslateUtils.StringCollectionToStringList(keywords, ' ')) { var keyword = str.Trim(); if (!string.IsNullOrEmpty(keyword)) { DataProviderWx.KeywordMatchDao.Insert(new KeywordMatchInfo(0, publishmentSystemId, keyword, keywordId, false, keywordType, matchType)); } } }
public KeywordInfo GetAvaliableKeywordInfo(int publishmentSystemId, EKeywordType keywordType) { KeywordInfo keywordInfo = null; var parms = new IDataParameter[] { GetParameter(ParmPublishmentSystemId, EDataType.Integer, publishmentSystemId), GetParameter(ParmIsDisabled, EDataType.VarChar, 18, false.ToString()), GetParameter(ParmKeywordType, EDataType.VarChar, 50, EKeywordTypeUtils.GetValue(keywordType)) }; using (var rdr = ExecuteReader(SqlSelectAvaliable, parms)) { if (rdr.Read()) { keywordInfo = new KeywordInfo(rdr.GetInt32(0), rdr.GetInt32(1), rdr.GetValue(2).ToString(), TranslateUtils.ToBool(rdr.GetValue(3).ToString()), EKeywordTypeUtils.GetEnumType(rdr.GetValue(4).ToString()), EMatchTypeUtils.GetEnumType(rdr.GetValue(5).ToString()), rdr.GetValue(6).ToString(), rdr.GetDateTime(7), rdr.GetInt32(8)); } rdr.Close(); } return(keywordInfo); }
public List <KeywordInfo> GetKeywordInfoList(int publishmentSystemId, EKeywordType keywordType) { var list = new List <KeywordInfo>(); var parms = new IDataParameter[] { GetParameter(ParmPublishmentSystemId, EDataType.Integer, publishmentSystemId), GetParameter(ParmKeywordType, EDataType.VarChar, 50, EKeywordTypeUtils.GetValue(keywordType)) }; using (var rdr = ExecuteReader(SqlSelectAllByType, parms)) { while (rdr.Read()) { var keywordInfo = new KeywordInfo(rdr.GetInt32(0), rdr.GetInt32(1), rdr.GetValue(2).ToString(), TranslateUtils.ToBool(rdr.GetValue(3).ToString()), EKeywordTypeUtils.GetEnumType(rdr.GetValue(4).ToString()), EMatchTypeUtils.GetEnumType(rdr.GetValue(5).ToString()), rdr.GetValue(6).ToString(), rdr.GetDateTime(7), rdr.GetInt32(8)); list.Add(keywordInfo); } rdr.Close(); } return(list); }
public List <KeywordInfo> GetKeywordInfoList(int publishmentSystemID, EKeywordType keywordType) { var list = new List <KeywordInfo>(); var parms = new IDataParameter[] { GetParameter(PARM_PUBLISHMENT_SYSTEM_ID, EDataType.Integer, publishmentSystemID), GetParameter(PARM_KEYWORD_TYPE, EDataType.VarChar, 50, EKeywordTypeUtils.GetValue(keywordType)) }; using (var rdr = ExecuteReader(SQL_SELECT_ALL_BY_TYPE, parms)) { while (rdr.Read()) { var keywordInfo = new KeywordInfo(rdr.GetInt32(0), rdr.GetInt32(1), rdr.GetValue(2).ToString(), TranslateUtils.ToBool(rdr.GetValue(3).ToString()), EKeywordTypeUtils.GetEnumType(rdr.GetValue(4).ToString()), EMatchTypeUtils.GetEnumType(rdr.GetValue(5).ToString()), rdr.GetValue(6).ToString(), rdr.GetDateTime(7), rdr.GetInt32(8)); list.Add(keywordInfo); } rdr.Close(); } return(list); }
public void Update(int publishmentSystemID, int keywordID, EKeywordType keywordType, EMatchType matchType, string keywords) { var parms = new IDataParameter[] { GetParameter(PARM_KEYWORDS, EDataType.NVarChar, 255, keywords), GetParameter(PARM_KEYWORD_TYPE, EDataType.VarChar, 50, EKeywordTypeUtils.GetValue(keywordType)), GetParameter(PARM_KEYWORD_ID, EDataType.Integer, keywordID) }; ExecuteNonQuery(SQL_UPDATE_KEYWRODS, parms); DataProviderWX.KeywordMatchDAO.DeleteByKeywordID(keywordID); foreach (var str in TranslateUtils.StringCollectionToStringList(keywords, ' ')) { var keyword = str.Trim(); if (!string.IsNullOrEmpty(keyword)) { DataProviderWX.KeywordMatchDAO.Insert(new KeywordMatchInfo(0, publishmentSystemID, keyword, keywordID, false, keywordType, matchType)); } } }
public KeywordInfo GetAvaliableKeywordInfo(int publishmentSystemID, EKeywordType keywordType) { KeywordInfo keywordInfo = null; var parms = new IDataParameter[] { GetParameter(PARM_PUBLISHMENT_SYSTEM_ID, EDataType.Integer, publishmentSystemID), GetParameter(PARM_IS_DISABLED, EDataType.VarChar, 18, false.ToString()), GetParameter(PARM_KEYWORD_TYPE, EDataType.VarChar, 50, EKeywordTypeUtils.GetValue(keywordType)) }; using (var rdr = ExecuteReader(SQL_SELECT_AVALIABLE, parms)) { if (rdr.Read()) { keywordInfo = new KeywordInfo(rdr.GetInt32(0), rdr.GetInt32(1), rdr.GetValue(2).ToString(), TranslateUtils.ToBool(rdr.GetValue(3).ToString()), EKeywordTypeUtils.GetEnumType(rdr.GetValue(4).ToString()), EMatchTypeUtils.GetEnumType(rdr.GetValue(5).ToString()), rdr.GetValue(6).ToString(), rdr.GetDateTime(7), rdr.GetInt32(8)); } rdr.Close(); } return(keywordInfo); }
private IResponseMessageBase GetResponseMessage(string keyword) { KeywordInfo keywordInfo = null; var keywordID = DataProviderWX.KeywordMatchDAO.GetKeywordIDByMPController(publishmentSystemInfo.PublishmentSystemId, keyword); if (keywordID == 0 && StringUtils.StartsWith(keyword, "GX_")) { var keywordType = EKeywordTypeUtils.GetEnumType(keyword.Substring(3)); keywordInfo = new KeywordInfo(0, publishmentSystemInfo.PublishmentSystemId, keyword, false, keywordType, EMatchType.Exact, string.Empty, DateTime.Now, 0); } if (keywordID == 0 && keywordInfo == null && accountInfo.IsDefaultReply && !string.IsNullOrEmpty(accountInfo.DefaultReplyKeyword)) { keywordID = DataProviderWX.KeywordMatchDAO.GetKeywordIDByMPController(publishmentSystemInfo.PublishmentSystemId, accountInfo.DefaultReplyKeyword); } if (keywordInfo == null && keywordID > 0) { keywordInfo = DataProviderWX.KeywordDAO.GetKeywordInfo(keywordID); } return(GetResponseMessage(keywordInfo, keyword)); }
public void Page_Load(object sender, EventArgs e) { if (IsForbidden) { return; } PageUtils.CheckRequestParameter("PublishmentSystemId"); _appointmentId = Body.GetQueryInt("appointmentID"); _appointmentItemId = Body.GetQueryInt("appointmentItemID"); SpContents.ControlToPaginate = RptContents; SpContents.ItemsPerPage = 30; SpContents.SelectCommand = DataProviderWx.AppointmentItemDao.GetSelectString(PublishmentSystemId, _appointmentId); SpContents.SortField = AlbumAttribute.Id; SpContents.SortMode = SortMode.ASC; RptContents.ItemDataBound += rptContents_ItemDataBound; if (!IsPostBack) { var pageTitle = _appointmentId > 0 ? "编辑微预约" : "添加微预约"; BreadCrumb(AppManager.WeiXin.LeftMenu.IdFunction, AppManager.WeiXin.LeftMenu.Function.IdAppointment, pageTitle, AppManager.WeiXin.Permission.WebSite.Appointment); LtlPageTitle.Text = pageTitle; LtlImageUrl.Text = $@"<img id=""preview_imageUrl"" src=""{AppointmentManager.GetImageUrl(PublishmentSystemInfo, string.Empty)}"" width=""370"" align=""middle"" />"; LtlContentImageUrl.Text = $@"<img id=""preview_contentImageUrl"" src=""{AppointmentManager.GetContentImageUrl( PublishmentSystemInfo, string.Empty)}"" width=""370"" align=""middle"" />"; LtlContentResultTopImageUrl.Text = $@"<img id=""preview_contentResultTopImageUrl"" src=""{AppointmentManager.GetContentResultTopImageUrl( PublishmentSystemInfo, string.Empty)}"" width=""370"" align=""middle"" />"; LtlEndImageUrl.Text = $@"<img id=""preview_endImageUrl"" src=""{AppointmentManager.GetEndImageUrl(PublishmentSystemInfo, string.Empty)}"" width=""370"" align=""middle"" />"; SpContents.DataBind(); BtnAdd.Attributes.Add("onclick", ModalAppointmentItemAdd.GetOpenWindowStringToAdd(PublishmentSystemId, _appointmentId, 0)); //string urlDelete = PageUtils.AddQueryString(BackgroundAppointmentMultipleAdd.GetRedirectUrl(base.PublishmentSystemId, this.appointmentID,this.tbTitle.Text), "Delete", "True"); //this.btnDelete.Attributes.Add("onclick", PageUtils.GetRedirectStringWithCheckBoxValueAndAlert(urlDelete, "IDCollection", "IDCollection", "请选择需要删除的微预约项目", "此操作将删除所选微预约项目,确认吗?")); if (_appointmentId == 0) { DtbEndDate.DateTime = DateTime.Now.AddMonths(1); } else { var appointmentInfo = DataProviderWx.AppointmentDao.GetAppointmentInfo(_appointmentId); if (appointmentInfo != null) { TbKeywords.Text = DataProviderWx.KeywordDao.GetKeywords(appointmentInfo.KeywordId); CbIsEnabled.Checked = !appointmentInfo.IsDisabled; DtbStartDate.DateTime = appointmentInfo.StartDate; DtbEndDate.DateTime = appointmentInfo.EndDate; TbTitle.Text = appointmentInfo.Title; if (!string.IsNullOrEmpty(appointmentInfo.ImageUrl)) { LtlImageUrl.Text = $@"<img id=""preview_imageUrl"" src=""{PageUtility.ParseNavigationUrl( PublishmentSystemInfo, appointmentInfo.ImageUrl)}"" width=""370"" align=""middle"" />"; } TbSummary.Text = appointmentInfo.Summary; if (!string.IsNullOrEmpty(appointmentInfo.ContentImageUrl)) { LtlContentImageUrl.Text = $@"<img id=""preview_contentImageUrl"" src=""{PageUtility.ParseNavigationUrl( PublishmentSystemInfo, appointmentInfo.ContentImageUrl)}"" width=""370"" align=""middle"" />"; } if (!string.IsNullOrEmpty(appointmentInfo.ContentResultTopImageUrl)) { LtlContentResultTopImageUrl.Text = $@"<img id=""preview_contentResultTopImageUrl"" src=""{PageUtility.ParseNavigationUrl( PublishmentSystemInfo, appointmentInfo.ContentResultTopImageUrl)}"" width=""370"" align=""middle"" />"; } TbContentDescription.Text = appointmentInfo.ContentDescription; TbEndTitle.Text = appointmentInfo.EndTitle; TbEndSummary.Text = appointmentInfo.EndSummary; if (!string.IsNullOrEmpty(appointmentInfo.EndImageUrl)) { LtlEndImageUrl.Text = $@"<img id=""preview_endImageUrl"" src=""{PageUtility.ParseNavigationUrl( PublishmentSystemInfo, appointmentInfo.EndImageUrl)}"" width=""370"" align=""middle"" />"; } ImageUrl.Value = appointmentInfo.ImageUrl; ContentImageUrl.Value = appointmentInfo.ContentImageUrl; ContentResultTopImageUrl.Value = appointmentInfo.ContentResultTopImageUrl; EndImageUrl.Value = appointmentInfo.EndImageUrl; #region 拓展属性 #region 姓名 if (appointmentInfo.IsFormRealName == "True") { CbIsFormRealName.Checked = true; TbFormRealNameTitle.Text = appointmentInfo.FormRealNameTitle; } else if (string.IsNullOrEmpty(appointmentInfo.IsFormRealName)) { CbIsFormRealName.Checked = true; TbFormRealNameTitle.Text = "姓名"; } else { CbIsFormRealName.Checked = false; TbFormRealNameTitle.Text = appointmentInfo.FormRealNameTitle; } #endregion #region 电话 if (appointmentInfo.IsFormMobile == "True") { CbIsFormMobile.Checked = true; TbFormMobileTitle.Text = appointmentInfo.FormMobileTitle; } else if (string.IsNullOrEmpty(appointmentInfo.IsFormMobile)) { CbIsFormMobile.Checked = true; TbFormMobileTitle.Text = "电话"; } else { CbIsFormMobile.Checked = false; TbFormMobileTitle.Text = appointmentInfo.FormMobileTitle; } #endregion #region 邮箱 if (appointmentInfo.IsFormEmail == "True") { CbIsFormEmail.Checked = true; TbFormEmailTitle.Text = appointmentInfo.FormEmailTitle; } else if (string.IsNullOrEmpty(appointmentInfo.IsFormEmail)) { CbIsFormEmail.Checked = true; TbFormEmailTitle.Text = "邮箱"; } else { CbIsFormEmail.Checked = false; TbFormEmailTitle.Text = appointmentInfo.FormEmailTitle; } #endregion _appointmentItemId = DataProviderWx.AppointmentItemDao.GetItemId(PublishmentSystemId, _appointmentId); var configExtendInfoList = DataProviderWx.ConfigExtendDao.GetConfigExtendInfoList(PublishmentSystemId, appointmentInfo.Id, EKeywordTypeUtils.GetValue(EKeywordType.Appointment)); var itemBuilder = new StringBuilder(); foreach (var configExtendInfo in configExtendInfoList) { if (string.IsNullOrEmpty(configExtendInfo.IsVisible)) { configExtendInfo.IsVisible = "checked=checked"; } else if (configExtendInfo.IsVisible == "True") { configExtendInfo.IsVisible = "checked=checked"; } else { configExtendInfo.IsVisible = ""; } itemBuilder.AppendFormat(@"{{id: '{0}', attributeName: '{1}',isVisible:'{2}'}},", configExtendInfo.Id, configExtendInfo.AttributeName, configExtendInfo.IsVisible); } if (itemBuilder.Length > 0) { itemBuilder.Length--; } LtlAwardItems.Text = $@"itemController.itemCount = {configExtendInfoList.Count};itemController.items = [{itemBuilder}];"; #endregion } } BtnReturn.Attributes.Add("onclick", $@"location.href=""{PageAppointment.GetRedirectUrl(PublishmentSystemId)}"";return false"); } }
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; } else if (PhStep4.Visible) { selectedStep = 4; } else if (PhStep5.Visible) { selectedStep = 5; } PhStep1.Visible = false; PhStep2.Visible = false; PhStep3.Visible = false; PhStep4.Visible = false; PhStep5.Visible = false; if (selectedStep == 1) { var isConflict = false; var conflictKeywords = string.Empty; if (!string.IsNullOrEmpty(TbKeywords.Text)) { if (_appointmentId > 0) { var appointmentInfo = DataProviderWx.AppointmentDao.GetAppointmentInfo(_appointmentId); isConflict = KeywordManager.IsKeywordUpdateConflict(PublishmentSystemId, appointmentInfo.KeywordId, TbKeywords.Text, out conflictKeywords); } else { isConflict = KeywordManager.IsKeywordInsertConflict(PublishmentSystemId, TbKeywords.Text, out conflictKeywords); } } if (isConflict) { FailMessage($"触发关键词“{conflictKeywords}”已存在,请设置其他关键词"); PhStep1.Visible = true; } else { PhStep2.Visible = true; } } else if (selectedStep == 2) { PhStep3.Visible = true; } else if (selectedStep == 3) { PhStep4.Visible = true; } else if (selectedStep == 4) { var isItemReady = true; var itemCount = TranslateUtils.ToInt(Request.Form["itemCount"]); var itemIdList = TranslateUtils.StringCollectionToIntList(Request.Form["itemID"]); var attributeNameList = TranslateUtils.StringCollectionToStringList(Request.Form["itemAttributeName"]); var itemIsVisible = "off"; if (!string.IsNullOrEmpty(Request.Form["itemIsVisible"])) { itemIsVisible = Request.Form["itemIsVisible"]; } var isVisibleList = TranslateUtils.StringCollectionToStringList(itemIsVisible); if (isVisibleList.Count < itemIdList.Count) { for (var i = isVisibleList.Count; i < itemIdList.Count; i++) { isVisibleList.Add("off"); } } var configExtendInfoList = new List <ConfigExtendInfo>(); for (var i = 0; i < itemCount; i++) { var configExtendInfo = new ConfigExtendInfo { Id = itemIdList[i], PublishmentSystemId = PublishmentSystemId, KeywordType = EKeywordTypeUtils.GetValue(EKeywordType.Appointment), FunctionId = _appointmentId, AttributeName = attributeNameList[i], IsVisible = isVisibleList[i] }; if (string.IsNullOrEmpty(configExtendInfo.AttributeName)) { FailMessage("保存失败,属性名称为必填项"); isItemReady = false; } if (string.IsNullOrEmpty(configExtendInfo.IsVisible)) { FailMessage("保存失败,是否必填为显示项"); isItemReady = false; } if (configExtendInfo.IsVisible == "on") { configExtendInfo.IsVisible = "True"; } else { configExtendInfo.IsVisible = "False"; } configExtendInfoList.Add(configExtendInfo); } if (isItemReady) { DataProviderWx.ConfigExtendDao.DeleteAllNotInIdList(PublishmentSystemId, _appointmentId, itemIdList); foreach (var configExtendInfo in configExtendInfoList) { if (configExtendInfo.Id > 0) { DataProviderWx.ConfigExtendDao.Update(configExtendInfo); } else { DataProviderWx.ConfigExtendDao.Insert(configExtendInfo); } } } if (isItemReady) { PhStep5.Visible = true; BtnSubmit.Text = "确 认"; } else { PhStep4.Visible = true; } } else if (selectedStep == 5) { var appointmentInfo = new AppointmentInfo(); appointmentInfo.PublishmentSystemId = PublishmentSystemId; if (_appointmentId > 0) { appointmentInfo = DataProviderWx.AppointmentDao.GetAppointmentInfo(_appointmentId); DataProviderWx.KeywordDao.Update(PublishmentSystemId, appointmentInfo.KeywordId, EKeywordType.Appointment, EMatchType.Exact, TbKeywords.Text, !CbIsEnabled.Checked); } else { var keywordInfo = new KeywordInfo(); keywordInfo.KeywordId = 0; keywordInfo.PublishmentSystemId = PublishmentSystemId; keywordInfo.Keywords = TbKeywords.Text; keywordInfo.IsDisabled = !CbIsEnabled.Checked; keywordInfo.KeywordType = EKeywordType.Appointment; keywordInfo.MatchType = EMatchType.Exact; keywordInfo.Reply = string.Empty; keywordInfo.AddDate = DateTime.Now; keywordInfo.Taxis = 0; appointmentInfo.KeywordId = DataProviderWx.KeywordDao.Insert(keywordInfo); } appointmentInfo.StartDate = DtbStartDate.DateTime; appointmentInfo.EndDate = DtbEndDate.DateTime; appointmentInfo.Title = TbTitle.Text; appointmentInfo.ImageUrl = ImageUrl.Value; ; appointmentInfo.Summary = TbSummary.Text; appointmentInfo.ContentImageUrl = ContentImageUrl.Value; appointmentInfo.ContentDescription = TbContentDescription.Text; appointmentInfo.ContentResultTopImageUrl = ContentResultTopImageUrl.Value; appointmentInfo.ContentIsSingle = false; appointmentInfo.EndTitle = TbEndTitle.Text; appointmentInfo.EndImageUrl = EndImageUrl.Value; appointmentInfo.EndSummary = TbEndSummary.Text; appointmentInfo.IsFormRealName = CbIsFormRealName.Checked ? "True" : "False"; appointmentInfo.FormRealNameTitle = TbFormRealNameTitle.Text; appointmentInfo.IsFormMobile = CbIsFormMobile.Checked ? "True" : "False"; appointmentInfo.FormMobileTitle = TbFormMobileTitle.Text; appointmentInfo.IsFormEmail = CbIsFormEmail.Checked ? "True" : "False"; appointmentInfo.FormEmailTitle = TbFormEmailTitle.Text; try { if (_appointmentId > 0) { DataProviderWx.AppointmentDao.Update(appointmentInfo); Body.AddSiteLog(PublishmentSystemId, "修改微预约", $"微预约:{TbTitle.Text}"); SuccessMessage("修改微预约成功!"); } else { _appointmentId = DataProviderWx.AppointmentDao.Insert(appointmentInfo); DataProviderWx.AppointmentItemDao.UpdateAppointmentId(PublishmentSystemId, _appointmentId); Body.AddSiteLog(PublishmentSystemId, "添加微预约", $"微预约:{TbTitle.Text}"); SuccessMessage("添加微预约成功!"); } AddWaitAndRedirectScript(PageAppointment.GetRedirectUrl(PublishmentSystemId)); } catch (Exception ex) { FailMessage(ex, "微预约设置失败!"); } BtnSubmit.Visible = false; BtnReturn.Visible = false; } } }