linkaccessor.cs

新闻网站

using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;
using System.Data;
using Common.Entities;
using Common;

namespace DAL.Accessor
{
    public class LinkAccessor
    {
        //添加友情链接
        public void Add(LinkData linkData)
        {
            SqlParameter[] sqlParameters = {
					new SqlParameter("@LinkName", SqlDbType.NVarChar),
					new SqlParameter("@LinkUrl", SqlDbType.NVarChar),
                    new SqlParameter("@MemberName", SqlDbType.NVarChar),
					};
            sqlParameters[0].Value = linkData.LinkName;
            sqlParameters[1].Value = linkData.LinkUrl;
            sqlParameters[2].Value = linkData.MemeberName;

            using (SqlConnection conn = new SqlConnection())
            {
                conn.ConnectionString = SqlHelper.ConnectionStringLocalTransaction;
                SqlHelper.ExecuteNonQuery(conn, CommandType.StoredProcedure, "Link_ADD", sqlParameters);
            }
        }
        //查询友情链接
        public List<LinkData> GetList()
        {
            List<LinkData> list = new List<LinkData>();
            SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "Link_GetList", null);
            while (reader.Read())
            {
                LinkData linkData = new LinkData();
                linkData.LinkId = int.Parse(reader["LinkId"].ToString());
                linkData.LinkName = reader["LinkName"].ToString();
                linkData.LinkUrl = reader["LinkUrl"].ToString();
                list.Add(linkData);
            }
            return list;
        }
        //删除友情链接
        public void Delete(int id)
        {
            SqlParameter[] sqlParameters = { 
                new SqlParameter("@LinkId",SqlDbType.Int)
            };
            sqlParameters[0].Value = id;
            using (SqlConnection conn = new SqlConnection())
            {
                conn.ConnectionString = SqlHelper.ConnectionStringLocalTransaction;
                SqlHelper.ExecuteNonQuery(conn, CommandType.StoredProcedure, "Link_Delete", sqlParameters);
            }
        }
    }
}