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