/// <summary>
/// 修改友情链接
/// </summary>
/// <param name="LinkInfo">Model</param>
/// <returns></returns>
public bool ModfiyLink(Tz888.Model.Link.LinkInfoTab LinkInfo)
{
string sql = "update LinkInfoTab set ChannelId=@ChannelId,LinkId=@LinkId,LinkInfoName=@LinkInfoName,LinkUrl=@LinkUrl,Sort=@Sort,Logo=@Logo,Remarks=@Remarks where LinkInfoId=@LinkInfoId";
SqlParameter[] Paras = new SqlParameter[] {
new SqlParameter("@ChannelId", SqlDbType.Int, 4),
new SqlParameter("@LinkId", SqlDbType.Int, 4),
new SqlParameter("@LinkInfoName", SqlDbType.NVarChar, 100),
new SqlParameter("@LinkUrl", SqlDbType.NVarChar, 200),
new SqlParameter("@Sort", SqlDbType.Int, 4),
new SqlParameter("@Logo", SqlDbType.NVarChar, 200),
new SqlParameter("@Remarks", SqlDbType.NVarChar, 200),
new SqlParameter("@LinkInfoId", SqlDbType.Int, 4)
};
Paras[0].Value = LinkInfo.ChannelId;
Paras[1].Value = LinkInfo.LinkId;
Paras[2].Value = LinkInfo.LinkInfoName;
Paras[3].Value = LinkInfo.LinkUrl;
Paras[4].Value = LinkInfo.Sort;
Paras[5].Value = LinkInfo.Logo;
Paras[6].Value = LinkInfo.Remarks;
Paras[7].Value = LinkInfo.LinkInfoId;
int row = crm.ExecuteSql(sql, Paras);
if (row > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 添加友情链接
/// </summary>
/// <param name="LinkInfoTab">LinkInfoTab</param>
/// <returns></returns>
public bool AddLink(Tz888.Model.Link.LinkInfoTab Type)
{
string sql = "insert into LinkInfoTab(ChannelId,LinkId,LinkInfoName,LinkUrl,Sort,Logo,Remarks) " +
"values(@ChannelId,@LinkId,@LinkInfoName,@LinkUrl,@Sort,@Logo,@Remarks)";
SqlParameter[] Paras = new SqlParameter[] {
new SqlParameter("@ChannelId", SqlDbType.Int, 4),
new SqlParameter("@LinkId", SqlDbType.Int, 4),
new SqlParameter("@LinkInfoName", SqlDbType.NVarChar, 100),
new SqlParameter("@LinkUrl", SqlDbType.NVarChar, 200),
new SqlParameter("@Sort", SqlDbType.Int, 4),
new SqlParameter("@Logo", SqlDbType.NVarChar, 200),
new SqlParameter("@Remarks", SqlDbType.NVarChar, 200)
};
Paras[0].Value = Type.ChannelId;
Paras[1].Value = Type.LinkId;
Paras[2].Value = Type.LinkInfoName;
Paras[3].Value = Type.LinkUrl;
Paras[4].Value = Type.Sort;
Paras[5].Value = Type.Logo;
Paras[6].Value = Type.Remarks;
int row = crm.ExecuteSql(sql, Paras);
if (row > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 修改链接
/// </summary>
/// <param name="LinkInfo">Model</param>
/// <returns></returns>
public bool ModfiyLink(Tz888.Model.Link.LinkInfoTab LinkInfo)
{
return(dal.ModfiyLink(LinkInfo));
}
/// <summary>
/// 添加友情链接
/// </summary>
/// <param name="LinkInfoTab">LinkInfoTab</param>
/// <returns></returns>
public bool AddLink(Tz888.Model.Link.LinkInfoTab LinkInfo)
{
return(dal.AddLink(LinkInfo));
}
