public InnerLinkInfo GetInnerLinkInfo(string innerLinkName, int publishmentSystemId) { InnerLinkInfo innerLinkInfo = null; var sqlString = "SELECT InnerLinkName, PublishmentSystemID, LinkUrl FROM siteserver_InnerLink WHERE InnerLinkName = @InnerLinkName AND PublishmentSystemID = 0"; if (publishmentSystemId != 0) { sqlString = "SELECT InnerLinkName, PublishmentSystemID, LinkUrl FROM siteserver_InnerLink WHERE InnerLinkName = @InnerLinkName AND (PublishmentSystemID = 0 OR PublishmentSystemID = @PublishmentSystemID)"; } var selectParms = new IDataParameter[] { GetParameter(ParmInnerLinkName, EDataType.NVarChar, 255, innerLinkName), GetParameter(ParmPublishmentsystemid, EDataType.Integer, publishmentSystemId) }; using (var rdr = ExecuteReader(sqlString, selectParms)) { if (rdr.Read()) { var i = 0; innerLinkInfo = new InnerLinkInfo(GetString(rdr, i++), GetInt(rdr, i++), GetString(rdr, i)); } rdr.Close(); } return(innerLinkInfo); }
public void Update(InnerLinkInfo innerLinkInfo) { var updateParms = new IDataParameter[] { GetParameter(ParmLinkUrl, EDataType.VarChar, 200, innerLinkInfo.LinkUrl), GetParameter(ParmInnerLinkName, EDataType.NVarChar, 255, innerLinkInfo.InnerLinkName), GetParameter(ParmPublishmentsystemid, EDataType.Integer, innerLinkInfo.PublishmentSystemID) }; ExecuteNonQuery(SqlUpdateInnerLink, updateParms); }
public override void Submit_OnClick(object sender, EventArgs e) { var isChanged = false; var innerLinkInfo = new InnerLinkInfo(); innerLinkInfo.InnerLinkName = InnerLinkName.Text; innerLinkInfo.PublishmentSystemID = PublishmentSystemId; innerLinkInfo.LinkUrl = LinkUrl.Text; if (Body.IsQueryExists("InnerLinkName")) { try { if (Body.GetQueryString("InnerLinkName") == innerLinkInfo.InnerLinkName) { DataProvider.InnerLinkDao.Update(innerLinkInfo); Body.AddSiteLog(PublishmentSystemId, "修改站内链接", $"站内链接:{innerLinkInfo.InnerLinkName}"); isChanged = true; } else { var innerLinkNameList = DataProvider.InnerLinkDao.GetInnerLinkNameList(PublishmentSystemId); if (innerLinkNameList.IndexOf(InnerLinkName.Text) != -1) { FailMessage("站内链接修改失败,站内链接名称已存在!"); } else { DataProvider.InnerLinkDao.Delete(Body.GetQueryString("InnerLinkName"), PublishmentSystemId); DataProvider.InnerLinkDao.Insert(innerLinkInfo); Body.AddSiteLog(PublishmentSystemId, "修改站内链接", $"站内链接:{innerLinkInfo.InnerLinkName}"); isChanged = true; } } } catch (Exception ex) { FailMessage(ex, "站内链接修改失败!"); } } else { var innerLinkNameList = DataProvider.InnerLinkDao.GetInnerLinkNameList(PublishmentSystemId); if (innerLinkNameList.IndexOf(InnerLinkName.Text) != -1) { FailMessage("站内链接添加失败,站内链接名称已存在!"); } else { try { DataProvider.InnerLinkDao.Insert(innerLinkInfo); Body.AddSiteLog(PublishmentSystemId, "添加站内链接", $"站内链接:{innerLinkInfo.InnerLinkName}"); isChanged = true; } catch (Exception ex) { FailMessage(ex, "站内链接添加失败!"); } } } if (isChanged) { PageUtils.CloseModalPage(Page); } }