DAL/NewsTypeService.cs

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

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

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

namespace DAL
{
	/// <summary>
	/// 数据访问类NewsTypeService。
	/// </summary>
	public class NewsTypeService
	{
		public NewsTypeService()
		{}
		#region  成员方法
        /// <summary>
        /// 获得首页社保知识数据列表
        /// </summary>
        public static List<NewsType> GetListItem(int parentId)
        {
            List<NewsType> list = new List<NewsType>();
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select * FROM NewsType where parentId = " + parentId + " order by id desc ");
            DataSet ds = DBHelperSQL.Query(strSql.ToString());
            if (ds.Tables[0].Rows.Count > 0)
            {
                NewsType model = null;
                for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                {
                    model = new NewsType();
                    if (ds.Tables[0].Rows[i]["id"].ToString() != "")
                    {
                        model.id = int.Parse(ds.Tables[0].Rows[i]["id"].ToString());
                    }
                    model.name = ds.Tables[0].Rows[i]["name"].ToString();
                    if (ds.Tables[0].Rows[i]["parentId"].ToString() != "")
                    {
                        model.parentId = int.Parse(ds.Tables[0].Rows[i]["parentId"].ToString());
                    }
                    model.typedesc = ds.Tables[0].Rows[i]["typeDesc"].ToString();
                    model.pagename = ds.Tables[0].Rows[i]["pagename"].ToString();
                    list.Add(model);
                }
            }
            return list;
        }
		/// <summary>
		/// 是否存在该记录
		/// </summary>
        public static bool Exists(Model.NewsType model)
		{
			StringBuilder strSql=new StringBuilder();
			strSql.Append("select count(1) from NewsType");
			strSql.Append(" where name=@name and parentId = " + model.parentId);
			SqlParameter[] parameters = {
					new SqlParameter("@name", SqlDbType.VarChar,54)};
			parameters[0].Value = model.name;
			return DBHelperSQL.Exists(strSql.ToString(),parameters);