/// <summary>
/// 获取指定公司的友情链接列表
/// </summary>
/// <param name="CompanyID">公司编号 为空返回全部否则返回指定公司的记录</param>
/// <returns>友情链接列表</returns>
public virtual IList <EyouSoft.Model.ShopStructure.HighShopFriendLink> GetList(string CompanyID)
{
IList <EyouSoft.Model.ShopStructure.HighShopFriendLink> list = new List <EyouSoft.Model.ShopStructure.HighShopFriendLink>();
DbCommand dc = null;
if (string.IsNullOrEmpty(CompanyID))
{
dc = this._database.GetSqlStringCommand(string.Format(SQL_HighShopFriendLink_SELECT, string.Empty));
}
else
{
dc = this._database.GetSqlStringCommand(string.Format(SQL_HighShopFriendLink_SELECT, " where CompanyID=@CompanyID "));
}
if (dc != null)
{
this._database.AddInParameter(dc, "CompanyID", DbType.AnsiStringFixedLength, CompanyID);
using (IDataReader dr = DbHelper.ExecuteReader(dc, this._database))
{
while (dr.Read())
{
EyouSoft.Model.ShopStructure.HighShopFriendLink model = new EyouSoft.Model.ShopStructure.HighShopFriendLink();
model.ID = dr.GetString(0);
model.LinkName = dr.GetString(1);
model.LinkAddress = dr.GetString(2);
if (!dr.IsDBNull(3))
{
model.SortID = dr.GetInt32(3);
}
list.Add(model);
model = null;
}
}
}
return(list);
}
/// <summary>
/// 修改
/// </summary>
/// <param name="model">友情链接实体</param>
/// <returns>false:失败 true:成功</returns>
public virtual bool Update(EyouSoft.Model.ShopStructure.HighShopFriendLink model)
{
DbCommand dc = this._database.GetSqlStringCommand(SQL_HighShopFriendLink_UPDATE);
this._database.AddInParameter(dc, "ID", DbType.AnsiStringFixedLength, model.ID);
this._database.AddInParameter(dc, "LinkName", DbType.String, model.LinkName);
this._database.AddInParameter(dc, "LinkAddress", DbType.String, model.LinkAddress);
this._database.AddInParameter(dc, "SortID", DbType.Int32, model.SortID);
return(DbHelper.ExecuteSql(dc, this._database) > 0?true:false);
}
/// <summary>
/// 添加
/// </summary>
/// <param name="model">友情链接实体</param>
/// <returns>false:失败 true:成功</returns>
public virtual bool Add(EyouSoft.Model.ShopStructure.HighShopFriendLink model)
{
DbCommand dc = this._database.GetSqlStringCommand(SQL_HighShopFriendLink_ADD);
model.ID = Guid.NewGuid().ToString();
this._database.AddInParameter(dc, "ID", DbType.AnsiStringFixedLength, model.ID);
this._database.AddInParameter(dc, "CompanyID", DbType.AnsiStringFixedLength, model.CompanyID);
this._database.AddInParameter(dc, "OperatorID", DbType.AnsiStringFixedLength, model.OperatorID);
this._database.AddInParameter(dc, "LinkName", DbType.String, model.LinkName);
this._database.AddInParameter(dc, "LinkAddress", DbType.String, model.LinkAddress);
this._database.AddInParameter(dc, "SortID", DbType.Int32, model.SortID);
return(DbHelper.ExecuteSql(dc, this._database) > 0?true:false);
}
/// <summary>
/// 修改友情链接
/// </summary>
private void UpdateFriendLink()
{
string LinkAddress = Utils.InputText(Request.QueryString["LinkAddress"]);
LinkAddress = LinkAddress.ToLower().Contains("http://") ? LinkAddress : "http://" + LinkAddress;
string LinkName = Server.HtmlDecode(Utils.InputText(Request.QueryString["LinkName"]));
string errorMsg = string.Empty;
if (string.IsNullOrEmpty(LinkName))
{
errorMsg = "链接名称为空或输入错误！";
}
if (string.IsNullOrEmpty(LinkAddress))
{
errorMsg = errorMsg == "" ? "链接地址不能为空！" : errorMsg + "，链接地址不能为空！";
}
else
{
if (!StringValidate.IsUrl(LinkAddress))
{
errorMsg = errorMsg == "" ? "链接地址输入错误！" : errorMsg + "，链接地址输入错误！";
}
}
if (errorMsg == "")
{
EyouSoft.Model.ShopStructure.HighShopFriendLink link = new EyouSoft.Model.ShopStructure.HighShopFriendLink();
link.ID = StringValidate.SafeRequest(Request.QueryString["FriendLinkId"]);
link.CompanyID = CompanyId;
link.LinkAddress = LinkAddress;
link.OperatorID = this.SiteUserInfo.ID;
link.LinkName = StringValidate.SafeRequest(LinkName);
link.SortID = Utils.GetInt(Request.QueryString["SortId"], 0);
if (EyouSoft.BLL.ShopStructure.HighShopFriendLink.CreateInstance().Update(link))
{
link = null;
Response.Clear();
Response.Write("1");
Response.End();
}
}
else
{
Response.Clear();
Response.Write("{errorMsg:\"" + errorMsg + "\"}");
Response.End();
}
}
/// <summary>
/// 修改
/// </summary>
/// <param name="model">友情链接实体</param>
/// <returns>false:失败 true:成功</returns>
public bool Update(EyouSoft.Model.ShopStructure.HighShopFriendLink model)
{
return(dal.Update(model));
}
/// <summary>
/// 添加
/// </summary>
/// <param name="model">友情链接实体</param>
/// <returns>false:失败 true:成功</returns>
public bool Add(EyouSoft.Model.ShopStructure.HighShopFriendLink model)
{
return(dal.Add(model));
}
