public int Insert(KeywordResourceInfo resourceInfo)
{
var resourceID = 0;
var sqlString = "INSERT INTO wx_KeywordResource (PublishmentSystemID, KeywordID, Title, ImageUrl, Summary, ResourceType, IsShowCoverPic, Content, NavigationUrl, ChannelID, ContentID, Taxis) VALUES (@PublishmentSystemID, @KeywordID, @Title, @ImageUrl, @Summary, @ResourceType, @IsShowCoverPic, @Content, @NavigationUrl, @ChannelID, @ContentID, @Taxis)";
var taxis = GetMaxTaxis(resourceInfo.KeywordID) + 1;
var parms = new IDataParameter[]
{
GetParameter(PARM_PUBLISHMENT_SYSTEM_ID, EDataType.Integer, resourceInfo.PublishmentSystemID),
GetParameter(PARM_KEYWORD_ID, EDataType.Integer, resourceInfo.KeywordID),
GetParameter(PARM_TITLE, EDataType.NVarChar, 255, resourceInfo.Title),
GetParameter(PARM_IMAGE_URL, EDataType.VarChar, 200, resourceInfo.ImageUrl),
GetParameter(PARM_SUMMARY, EDataType.NVarChar, 255, resourceInfo.Summary),
GetParameter(PARM_RESOURCE_TYPE, EDataType.VarChar, 50, EResourceTypeUtils.GetValue(resourceInfo.ResourceType)),
GetParameter(PARM_IS_SHOW_COVER_PIC, EDataType.VarChar, 18, resourceInfo.IsShowCoverPic.ToString()),
GetParameter(PARM_CONTENT, EDataType.NText, resourceInfo.Content),
GetParameter(PARM_NAVIGATION_URL, EDataType.VarChar, 200, resourceInfo.NavigationUrl),
GetParameter(PARM_CHANNEL_ID, EDataType.Integer, resourceInfo.ChannelID),
GetParameter(PARM_CONTENT_ID, EDataType.Integer, resourceInfo.ContentID),
GetParameter(PARM_TAXIS, EDataType.Integer, taxis)
};
using (var conn = GetConnection())
{
conn.Open();
using (var trans = conn.BeginTransaction())
{
try
{
ExecuteNonQuery(trans, sqlString, parms);
resourceID = BaiRongDataProvider.DatabaseDao.GetSequence(trans, "wx_KeywordResource");
trans.Commit();
}
catch
{
trans.Rollback();
throw;
}
}
}
return(resourceID);
}
public int Insert(KeywordResourceInfo resourceInfo)
{
var resourceId = 0;
var sqlString = "INSERT INTO wx_KeywordResource (PublishmentSystemID, KeywordID, Title, ImageUrl, Summary, ResourceType, IsShowCoverPic, Content, NavigationUrl, ChannelID, ContentID, Taxis) VALUES (@PublishmentSystemID, @KeywordID, @Title, @ImageUrl, @Summary, @ResourceType, @IsShowCoverPic, @Content, @NavigationUrl, @ChannelID, @ContentID, @Taxis)";
var taxis = GetMaxTaxis(resourceInfo.KeywordId) + 1;
var parms = new IDataParameter[]
{
GetParameter(ParmPublishmentSystemId, EDataType.Integer, resourceInfo.PublishmentSystemId),
GetParameter(ParmKeywordId, EDataType.Integer, resourceInfo.KeywordId),
GetParameter(ParmTitle, EDataType.NVarChar, 255, resourceInfo.Title),
GetParameter(ParmImageUrl, EDataType.VarChar, 200, resourceInfo.ImageUrl),
GetParameter(ParmSummary, EDataType.NVarChar, 255, resourceInfo.Summary),
GetParameter(ParmResourceType, EDataType.VarChar, 50, EResourceTypeUtils.GetValue(resourceInfo.ResourceType)),
GetParameter(ParmIsShowCoverPic, EDataType.VarChar, 18, resourceInfo.IsShowCoverPic.ToString()),
GetParameter(ParmContent, EDataType.NText, resourceInfo.Content),
GetParameter(ParmNavigationUrl, EDataType.VarChar, 200, resourceInfo.NavigationUrl),
GetParameter(ParmChannelId, EDataType.Integer, resourceInfo.ChannelId),
GetParameter(ParmContentId, EDataType.Integer, resourceInfo.ContentId),
GetParameter(ParmTaxis, EDataType.Integer, taxis)
};
using (var conn = GetConnection())
{
conn.Open();
using (var trans = conn.BeginTransaction())
{
try
{
resourceId = ExecuteNonQueryAndReturnId(trans, sqlString, parms);
trans.Commit();
}
catch
{
trans.Rollback();
throw;
}
}
}
return(resourceId);
}
private string GetNavHtml(EResourceType resourceType)
{
var nav = string.Empty;
var list = new List <EResourceType>();
list.Add(EResourceType.Site);
list.Add(EResourceType.Content);
list.Add(EResourceType.Url);
foreach (var rType in list)
{
nav +=
$@"<li class=""{(rType == resourceType ? "active" : string.Empty)}""><a href=""javascript:;"" class=""{EResourceTypeUtils
.GetValue(rType)}"" resourceType=""{EResourceTypeUtils.GetValue(rType)}"">显示{EResourceTypeUtils
.GetText(rType)}</a></li>";
}
return(nav);
}
public void Update(KeywordResourceInfo resourceInfo)
{
var parms = new IDataParameter[]
{
GetParameter(ParmPublishmentSystemId, EDataType.Integer, resourceInfo.PublishmentSystemId),
GetParameter(ParmKeywordId, EDataType.Integer, resourceInfo.KeywordId),
GetParameter(ParmTitle, EDataType.NVarChar, 255, resourceInfo.Title),
GetParameter(ParmImageUrl, EDataType.VarChar, 200, resourceInfo.ImageUrl),
GetParameter(ParmSummary, EDataType.NVarChar, 255, resourceInfo.Summary),
GetParameter(ParmResourceType, EDataType.VarChar, 50, EResourceTypeUtils.GetValue(resourceInfo.ResourceType)),
GetParameter(ParmIsShowCoverPic, EDataType.VarChar, 18, resourceInfo.IsShowCoverPic.ToString()),
GetParameter(ParmContent, EDataType.NText, resourceInfo.Content),
GetParameter(ParmNavigationUrl, EDataType.VarChar, 200, resourceInfo.NavigationUrl),
GetParameter(ParmChannelId, EDataType.Integer, resourceInfo.ChannelId),
GetParameter(ParmContentId, EDataType.Integer, resourceInfo.ContentId),
GetParameter(ParmTaxis, EDataType.Integer, resourceInfo.Taxis),
GetParameter(ParmResourceId, EDataType.Integer, resourceInfo.ResourceId)
};
ExecuteNonQuery(SqlUpdate, parms);
}
public void Update(KeywordResourceInfo resourceInfo)
{
var parms = new IDataParameter[]
{
GetParameter(PARM_PUBLISHMENT_SYSTEM_ID, EDataType.Integer, resourceInfo.PublishmentSystemID),
GetParameter(PARM_KEYWORD_ID, EDataType.Integer, resourceInfo.KeywordID),
GetParameter(PARM_TITLE, EDataType.NVarChar, 255, resourceInfo.Title),
GetParameter(PARM_IMAGE_URL, EDataType.VarChar, 200, resourceInfo.ImageUrl),
GetParameter(PARM_SUMMARY, EDataType.NVarChar, 255, resourceInfo.Summary),
GetParameter(PARM_RESOURCE_TYPE, EDataType.VarChar, 50, EResourceTypeUtils.GetValue(resourceInfo.ResourceType)),
GetParameter(PARM_IS_SHOW_COVER_PIC, EDataType.VarChar, 18, resourceInfo.IsShowCoverPic.ToString()),
GetParameter(PARM_CONTENT, EDataType.NText, resourceInfo.Content),
GetParameter(PARM_NAVIGATION_URL, EDataType.VarChar, 200, resourceInfo.NavigationUrl),
GetParameter(PARM_CHANNEL_ID, EDataType.Integer, resourceInfo.ChannelID),
GetParameter(PARM_CONTENT_ID, EDataType.Integer, resourceInfo.ContentID),
GetParameter(PARM_TAXIS, EDataType.Integer, resourceInfo.Taxis),
GetParameter(PARM_RESOURCE_ID, EDataType.Integer, resourceInfo.ResourceID)
};
ExecuteNonQuery(SQL_UPDATE, parms);
}
public void Page_Load(object sender, EventArgs e)
{
if (IsForbidden)
{
return;
}
PageUtils.CheckRequestParameter("PublishmentSystemID");
keywordID = TranslateUtils.ToInt(GetQueryString("keywordID"));
resourceID = TranslateUtils.ToInt(GetQueryString("resourceID"));
floor = TranslateUtils.ToInt(GetQueryString("floor"));
isSingle = TranslateUtils.ToBool(GetQueryString("isSingle"));
if (!IsPostBack)
{
ltlPreview.Text = @"
<p class=""js_cover upload_preview"" style=""display:none"">
<input type=""hidden"" id=""imageUrl"" name=""imageUrl"" value="""" />
<img src="""" width=""64"">
<a class=""js_removeCover"" href=""javascript:;"" onclick=""deleteImageUrl();return false;"">删除</a>
</p>";
ltlNav.Text = GetNavHtml(EResourceType.Site);
ltlSite.Text = @"
<div id=""titles"" class=""well well-small"" style=""display:none""></div>
<input id=""channelID"" name=""channelID"" type=""hidden"" value="""" />
<input id=""contentID"" name=""contentID"" type=""hidden"" value="""" />";
if (resourceID > 0)
{
var resourceInfo = DataProviderWX.KeywordResourceDAO.GetResourceInfo(resourceID);
if (resourceInfo.ResourceType == EResourceType.Site)
{
var siteHtml = MPUtils.GetSitePreivewHtml(PublishmentSystemInfo, resourceInfo.ChannelID, resourceInfo.ContentID);
if (!string.IsNullOrEmpty(siteHtml))
{
ltlSite.Text = $@"
<div id=""titles"" class=""well well-small"">{siteHtml}</div>
<input id=""channelID"" name=""channelID"" type=""hidden"" value=""{resourceInfo.ChannelID}"" />
<input id=""contentID"" name=""contentID"" type=""hidden"" value=""{resourceInfo.ContentID}"" />";
}
}
tbTitle.Text = resourceInfo.Title;
tbTaxis.Text = resourceInfo.Taxis.ToString();
if (!string.IsNullOrEmpty(resourceInfo.ImageUrl))
{
ltlPreview.Text = $@"
<p class=""js_cover upload_preview"">
<input type=""hidden"" id=""imageUrl"" name=""imageUrl"" value=""{resourceInfo.ImageUrl}"" />
<img src=""{PageUtility.ParseNavigationUrl(PublishmentSystemInfo, resourceInfo.ImageUrl)}"" width=""64"">
<a class=""js_removeCover"" href=""javascript:;"" onclick=""deleteImageUrl();return false;"">删除</a>
</p>";
}
tbSummary.Text = resourceInfo.Summary;
if (resourceInfo.IsShowCoverPic == false)
{
ltlScript.Text += "<script>$('.js_show_cover_pic').click();</script>";
}
breContent.Text = resourceInfo.Content;
tbNavigationUrl.Text = resourceInfo.NavigationUrl;
ltlScript.Text +=
$@"<script>$('.nav a.{EResourceTypeUtils.GetValue(resourceInfo.ResourceType)}').click();</script>";
}
btnContentSelect.Attributes.Add("onclick", "parent." + Modal.ContentSelect.GetOpenWindowString(PublishmentSystemID, false, "contentSelect"));
btnChannelSelect.Attributes.Add("onclick", "parent." + CMS.BackgroundPages.Modal.ChannelSelect.GetOpenWindowString(PublishmentSystemID));
var top = 0;
if (floor > 1)
{
top = 67 + (floor - 1) * 103;
}
ltlArrow.Text =
$@"<i class=""arrow arrow_out"" style=""margin-top: {top}px;""></i><i class=""arrow arrow_in"" style=""margin-top: {top}px;""></i>";
}
}
public override void Submit_OnClick(object sender, EventArgs e)
{
if (Page.IsPostBack && Page.IsValid)
{
try
{
var resourceInfo = new KeywordResourceInfo();
resourceInfo.PublishmentSystemID = PublishmentSystemID;
resourceInfo.KeywordID = keywordID;
if (resourceID > 0)
{
resourceInfo = DataProviderWX.KeywordResourceDAO.GetResourceInfo(resourceID);
}
resourceInfo.Title = tbTitle.Text;
resourceInfo.Taxis = Convert.ToInt32(tbTaxis.Text);
resourceInfo.ResourceType = EResourceTypeUtils.GetEnumType(Request.Form["resourceType"]);
resourceInfo.ImageUrl = Request.Form["imageUrl"];
resourceInfo.Summary = tbSummary.Text;
resourceInfo.IsShowCoverPic = TranslateUtils.ToBool(Request.Form["isShowCoverPic"]);
resourceInfo.Content = breContent.Text;
resourceInfo.NavigationUrl = tbNavigationUrl.Text;
resourceInfo.ChannelID = TranslateUtils.ToInt(Request.Form["channelID"]);
resourceInfo.ContentID = TranslateUtils.ToInt(Request.Form["contentID"]);
var isError = false;
if (resourceInfo.ResourceType == EResourceType.Site)
{
if (resourceInfo.ChannelID == 0)
{
FailMessage("图文回复保存失败，请选择需要显示的微网站页面！");
ltlScript.Text +=
$@"<script>$('.nav a.{EResourceTypeUtils.GetValue(EResourceType.Site)}').click();</script>";
isError = true;
}
}
else if (resourceInfo.ResourceType == EResourceType.Url)
{
if (string.IsNullOrEmpty(resourceInfo.NavigationUrl))
{
FailMessage("图文回复保存失败，请填写需要链接的网址！");
ltlScript.Text +=
$@"<script>$('.nav a.{EResourceTypeUtils.GetValue(EResourceType.Url)}').click();</script>";
isError = true;
}
}
if (!isError)
{
if (resourceID > 0)
{
DataProviderWX.KeywordResourceDAO.Update(resourceInfo);
StringUtility.AddLog(PublishmentSystemID, "修改关键词图文回复");
SuccessMessage("关键词图文回复修改成功！");
}
else
{
resourceID = DataProviderWX.KeywordResourceDAO.Insert(resourceInfo);
StringUtility.AddLog(PublishmentSystemID, "新增关键词图文回复");
SuccessMessage("关键词图文回复新增成功！");
}
FileUtilityWX.CreateWeiXinContent(PublishmentSystemInfo, keywordID, resourceID);
var redirectUrl = BackgroundKeywordNewsAdd.GetRedirectUrl(PublishmentSystemID, keywordID, resourceID, isSingle);
ltlScript.Text +=
$@"<script>setTimeout(""parent.redirect('{redirectUrl}')"", 1500);</script>";
}
}
catch (Exception ex)
{
FailMessage(ex, "关键词图文回复配置失败！");
}
}
}