DAL/LinksService.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Data;
using System.Text;
using System.Data.SqlClient;
using Model;
using System.Collections.Generic;

namespace DAL
{
	/// <summary>
	/// 数据访问类LinksService。
	/// </summary>
	public class LinksService
	{
		public LinksService()
		{}
		#region  成员方法
        /// <summary>
        /// 获得前几行数据
        /// </summary>
        public static List<Links> GetListItem(int num)
        {
            List<Links> list = new List<Links>();
            StringBuilder strSql = new StringBuilder();
            if (num == 1)
            {
                strSql.Append("select id,linkname,linkurl FROM Links where isTj = 1 order by id desc");    
            }
            else
            {
                strSql.Append("select id,linkname,linkurl FROM Links where isTj <> 1 order by id desc");    
            }
                  
            DataSet ds = DBHelperSQL.Query(strSql.ToString());
            if(ds.Tables[0].Rows.Count > 0)
            {
                Links model = null;
                for (int i = 0; i < ds.Tables[0].Rows.Count;i++ )
                {
                    model = new Links();
                    if (ds.Tables[0].Rows[i]["id"].ToString() != "")
                    {
                        model.id = int.Parse(ds.Tables[0].Rows[i]["id"].ToString());
                    }                    
                    model.linkname = ds.Tables[0].Rows[i]["linkname"].ToString();                  
                    model.linkurl = ds.Tables[0].Rows[i]["linkurl"].ToString();
                    list.Add(model);
                }
            }
            return list;
        }


		/// <summary>
		/// 是否存在该记录
		/// </summary>
		public bool Exists(int id)
		{
			StringBuilder strSql=new StringBuilder();
			strSql.Append("select count(1) from Links");