public static bool CreateFriendlyLink(FriendlyLinksInfo friendlyLink)
{
if (null == friendlyLink)
{
return false;
}
return StoreProvider.Instance().CreateUpdateDeleteFriendlyLink(friendlyLink, DataProviderAction.Create);
}
private void AddNewFriendlyLink(FriendlyLinksInfo friendlyLink)
{
if (SubsiteStoreHelper.CreateFriendlyLink(friendlyLink))
{
ShowMsg("成功添加了一个友情链接", true);
}
else
{
ShowMsg("未知错误", false);
}
}
private void btnSubmitLinks_Click(object sender, EventArgs e)
{
string str = string.Empty;
if (!(uploadImageUrl.HasFile || !string.IsNullOrEmpty(txtaddTitle.Text.Trim())))
{
ShowMsg("友情链接Logo和网站名称不能同时为空", false);
}
else
{
FriendlyLinksInfo target = new FriendlyLinksInfo();
if (uploadImageUrl.HasFile)
{
try
{
str = SubsiteStoreHelper.UploadLinkImage(uploadImageUrl.PostedFile);
}
catch
{
ShowMsg("图片上传失败，您选择的不是图片类型的文件，或者网站的虚拟目录没有写入文件的权限", false);
return;
}
}
target.ImageUrl = str;
target.LinkUrl = txtaddLinkUrl.Text;
target.Title = Globals.HtmlEncode(txtaddTitle.Text.Trim());
target.Visible = radioShowLinks.SelectedValue;
ValidationResults results = Hishop.Components.Validation.Validation.Validate<FriendlyLinksInfo>(target, new string[] { "ValFriendlyLinksInfo" });
string msg = string.Empty;
if (results.IsValid)
{
AddNewFriendlyLink(target);
Reset();
}
else
{
foreach (ValidationResult result in (IEnumerable<ValidationResult>)results)
{
msg = msg + Formatter.FormatErrorMessage(result.Message);
}
ShowMsg(msg, false);
}
}
}
public override bool CreateUpdateDeleteFriendlyLink(FriendlyLinksInfo friendlyLink, DataProviderAction action)
{
if (null == friendlyLink)
{
return false;
}
DbCommand storedProcCommand = database.GetStoredProcCommand("cp_FriendlyLink_CreateUpdateDelete");
database.AddInParameter(storedProcCommand, "Action", DbType.Int32, (int)action);
database.AddOutParameter(storedProcCommand, "Status", DbType.Int32, 4);
if (action != DataProviderAction.Create)
{
database.AddInParameter(storedProcCommand, "LinkId", DbType.Int32, friendlyLink.LinkId);
}
if (action != DataProviderAction.Delete)
{
database.AddInParameter(storedProcCommand, "ImageUrl", DbType.String, friendlyLink.ImageUrl);
database.AddInParameter(storedProcCommand, "LinkUrl", DbType.String, friendlyLink.LinkUrl);
database.AddInParameter(storedProcCommand, "Title", DbType.String, friendlyLink.Title);
database.AddInParameter(storedProcCommand, "Visible", DbType.Boolean, friendlyLink.Visible);
}
database.ExecuteNonQuery(storedProcCommand);
return (((int)database.GetParameterValue(storedProcCommand, "Status")) == 0);
}
public abstract bool CreateUpdateDeleteFriendlyLink(FriendlyLinksInfo friendlyLink, DataProviderAction action);
public static FriendlyLinksInfo PopulateFriendlyLink(IDataRecord reader)
{
if (null == reader)
{
return null;
}
FriendlyLinksInfo info = new FriendlyLinksInfo();
info.LinkId = new int?((int) reader["LinkId"]);
info.Visible = (bool) reader["Visible"];
info.DisplaySequence = (int) reader["DisplaySequence"];
if (reader["ImageUrl"] != DBNull.Value)
{
info.ImageUrl = (string) reader["ImageUrl"];
}
if (reader["Title"] != DBNull.Value)
{
info.Title = (string) reader["Title"];
}
if (reader["LinkUrl"] != DBNull.Value)
{
info.LinkUrl = (string) reader["LinkUrl"];
}
return info;
}
private void UpdateFriendlyLink(FriendlyLinksInfo friendlyLink)
{
if (SubsiteStoreHelper.UpdateFriendlyLink(friendlyLink))
{
imgPic.ImageUrl = string.Empty;
ShowMsg("修改友情链接信息成功", true);
}
else
{
ShowMsg("修改友情链接信息失败", false);
}
}
public override FriendlyLinksInfo GetFriendlyLink(int linkId)
{
FriendlyLinksInfo info = new FriendlyLinksInfo();
DbCommand sqlStringCommand = database.GetSqlStringCommand("SELECT * FROM Hishop_FriendlyLinks WHERE LinkId=@LinkId");
database.AddInParameter(sqlStringCommand, "LinkId", DbType.Int32, linkId);
using (IDataReader reader = database.ExecuteReader(sqlStringCommand))
{
if (reader.Read())
{
info = DataMapper.PopulateFriendlyLink(reader);
}
}
return info;
}