/// <summary>
/// 新增友情链接
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Insertfriendlink(FriendlinksModel model)
{
string sqltxt = @"INSERT INTO ShoppingStore.dbo.bsp_friendlinks
( name ,
title ,
logo ,
url ,
[target] ,
displayorder
)
VALUES (@name,
@title,
@logo,
@url,
@target,
@Displayorder
)";
SqlParameter[] paramter =
{
new SqlParameter("@name", SqlDbType.NVarChar),
new SqlParameter("@title", SqlDbType.NVarChar),
new SqlParameter("@logo", SqlDbType.NVarChar),
new SqlParameter("@url", SqlDbType.NVarChar),
new SqlParameter("@target", SqlDbType.NVarChar),
new SqlParameter("@Displayorder", SqlDbType.NVarChar)
};
paramter[0].Value = model.Name;
paramter[1].Value = model.Title;
paramter[2].Value = model.Logo;
paramter[3].Value = model.Url;
paramter[4].Value = model.Target;
paramter[5].Value = model.Displayorder;
return(helper.ExecuteSql(sqltxt, paramter));
}
public List <FriendlinksModel> FriendLinkList()
{
DataTable dt = dal.GetAllfriendlinks();
List <FriendlinksModel> modellist = new List <FriendlinksModel>();
if (dt.Rows.Count > 0)
{
foreach (DataRow item in dt.Rows)
{
FriendlinksModel model = new FriendlinksModel();
model.Name = item["name"].ToString();
model.Logo = item["logo"].ToString();
model.Target = item["target"].ToString();
model.Title = item["title"].ToString();
model.Url = item["url"].ToString();
model.Displayorder = item["Displayorder"].ToString();
modellist.Add(model);
}
}
return(modellist);
}
