新闻

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using ZeroStudio.DBUtility;

namespace ZeroStudio.DAL
{
    public class News
    {
        public News()
        { }
        #region  成员方法

        /// <summary>
        /// 是否存在该记录
        /// </summary>
        public bool Exists(int N_Id)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select count(1) from News");
            strSql.Append(" where N_Id=" + N_Id + " ");
            return DbHelperOledb.Exists(strSql.ToString());
        }

        /// <summary>
        /// 返回记录总数
        /// </summary>
        public int Count()
        {
            StringBuilder sql = new StringBuilder();
            sql.Append("Select count(1) from News");
            return Convert.ToInt32(DbHelperOledb.ExecuteScalar(sql.ToString()));
        }

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public void Add(ZeroStudio.Model.News model)
        {
            StringBuilder strSql = new StringBuilder();
            StringBuilder strSql1 = new StringBuilder();
            StringBuilder strSql2 = new StringBuilder();
           
            if (model.N_title != null)
            {
                strSql1.Append("N_title,");
                strSql2.Append("'" + model.N_title + "',");
            }
            if (model.N_ClassID != null)
            {
                strSql1.Append("N_ClassID,");
                strSql2.Append("" + model.N_ClassID + ",");
            }
            if (model.N_Content != null)
            {
                strSql1.Append("N_Content,");
                strSql2.Append("'" + model.N_Content + "',");
            }
           
            strSql.Append("insert into News(");
            strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1));
            strSql.Append(")");
            strSql.Append(" values (");
            strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1));
            strSql.Append(")");
            DbHelperOledb.ExecuteSql(strSql.ToString());
        }

        /// <summary>
        /// 更新一条数据
        /// </summary>
        public void Update(ZeroStudio.Model.News model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("update News set ");
           
            if (model.N_title != null)
            {
                strSql.Append("N_title='" + model.N_title + "',");
            }
            if (model.N_ClassID != null)
            {
                strSql.Append("N_ClassID=" + model.N_ClassID + ",");
            }
            if (model.N_Content != null)
            {
                strSql.Append("N_Content='" + model.N_Content + "',");
            }
            if (model.N_DateTime != null)
            {
                strSql.Append("N_DateTime='" + model.N_DateTime + "',");
            }
            strSql.Append(" where N_Id=" + model.N_Id + " ");
            int n = strSql.ToString().LastIndexOf(",");
            strSql.Remove(n, 1);
            DbHelperOledb.ExecuteSql(strSql.ToString());
        }

        /// <summary>
        /// 删除一条数据
        /// </summary>
        public void Delete(int N_Id)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("delete from News ");
            strSql.Append(" where N_Id=" + N_Id + " ");
            DbHelperOledb.ExecuteSql(strSql.ToString());
        }

        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public ZeroStudio.Model.News GetModel(int N_Id)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select  ");
            strSql.Append(" N_Id,N_title,N_ClassID,N_Content,N_DateTime ");
            strSql.Append(" from News ");
            strSql.Append(" where N_Id=" + N_Id + " ");
            ZeroStudio.Model.News model = new ZeroStudio.Model.News();
            DataSet ds = DbHelperOledb.Query(strSql.ToString());
            if (ds.Tables[0].Rows.Count > 0)
            {
                if (ds.Tables[0].Rows[0]["N_Id"].ToString() != "")
                {
                    model.N_Id = int.Parse(ds.Tables[0].Rows[0]["N_Id"].ToString());
                }
                model.N_title = ds.Tables[0].Rows[0]["N_title"].ToString();
                if (ds.Tables[0].Rows[0]["N_ClassID"].ToString() != "")
                {
                    model.N_ClassID = int.Parse(ds.Tables[0].Rows[0]["N_ClassID"].ToString());
                }
                model.N_Content = ds.Tables[0].Rows[0]["N_Content"].ToString();
                if (ds.Tables[0].Rows[0]["N_DateTime"].ToString() != "")
                {
                    model.N_DateTime = DateTime.Parse(ds.Tables[0].Rows[0]["N_DateTime"].ToString());
                }
                return model;
            }
            else
            {
                return null;
            }
        }
        /// <summary>
        /// 获得数据列表
        /// </summary>
        public DataSet GetList(string strWhere)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select N_Id,N_title,N_ClassID,N_Content,N_DateTime ");
            strSql.Append(" FROM News ");
            if (strWhere.Trim() != "")
            {
                strSql.Append(" where " + strWhere);
            }
            return DbHelperOledb.Query(strSql.ToString());
        }

        /// <summary>
        /// 按条件返回前num条新闻列表
        /// </summary>
        /// <param name="num">num新闻条数</param>
        /// <param name="strWhere">查询条件</param>
        /// <returns></returns>
        public DataSet GetList(int num,string strWhere)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select top "+ num +" N_Id,N_title,N_ClassID,N_Content,N_DateTime ");
            strSql.Append(" FROM News ");
            if (strWhere.Trim() != "")
            {
                strSql.Append(" where " + strWhere);
            }
            return DbHelperOledb.Query(strSql.ToString());
        }

        /// <summary>
        /// 返回含类名的数据列表
        /// </summary>
        /// <param name="strWhere"></param>
        /// <returns></returns>
        public DataSet GetList_ClassName(string strWhere)
        {
            StringBuilder sql = new StringBuilder();
            sql.Append("select [News].*,[NewsClass].NC_Classname ");
            sql.Append(" from [News] inner join [NewsClass] ");
            sql.Append(" on [News].N_Classid=[NewsClass].NC_Id ");
            if (strWhere.Trim() != "")
            {
                sql.Append(" where " + strWhere);
            }
            sql.Append(" order by [News].N_id desc");
            return DbHelperOledb.Query(sql.ToString());
        }

        /*
        */

        #endregion  成员方法
    }
}

 

using System;
using System.Data;
using System.Collections.Generic;
using ZeroStudio.Model;

namespace ZeroStudio.BLL
{
    /// <summary>
    /// 业务逻辑类News 的摘要说明。
    /// </summary>
    public class News
    {
        private readonly ZeroStudio.DAL.News dal = new ZeroStudio.DAL.News();
        public News()
        { }
        #region  成员方法
        /// <summary>
        /// 是否存在该记录
        /// </summary>
        public bool Exists(int N_Id)
        {
            return dal.Exists(N_Id);
        }

        public int Count()
        {
            return dal.Count();
        }

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public void Add(ZeroStudio.Model.News model)
        {
            dal.Add(model);
        }

        /// <summary>
        /// 更新一条数据
        /// </summary>
        public void Update(ZeroStudio.Model.News model)
        {
            dal.Update(model);
        }

        /// <summary>
        /// 删除一条数据
        /// </summary>
        public void Delete(int N_Id)
        {

            dal.Delete(N_Id);
        }

        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public ZeroStudio.Model.News GetModel(int N_Id)
        {

            return dal.GetModel(N_Id);
        }

       

        /// <summary>
        /// 获得数据列表
        /// </summary>
        public DataSet GetList(string strWhere)
        {
            return dal.GetList(strWhere);
        }

        /// <summary>
        /// 按条件返回前num条新闻列表
        /// </summary>
        /// <param name="num">num新闻条数</param>
        /// <param name="strWhere">查询条件</param>
        /// <returns></returns>
        public DataSet GetList(int num,string strWhere)
        {
            return dal.GetList(num,strWhere);
        }
        /// <summary>
        /// 获得数据列表
        /// </summary>
        public List<ZeroStudio.Model.News> GetModelList(string strWhere)
        {
            DataSet ds = dal.GetList(strWhere);
            return DataTableToList(ds.Tables[0]);
        }
        /// <summary>
        /// 获得数据列表
        /// </summary>
        public List<ZeroStudio.Model.News> DataTableToList(DataTable dt)
        {
            List<ZeroStudio.Model.News> modelList = new List<ZeroStudio.Model.News>();
            int rowsCount = dt.Rows.Count;
            if (rowsCount > 0)
            {
                ZeroStudio.Model.News model;
                for (int n = 0; n < rowsCount; n++)
                {
                    model = new ZeroStudio.Model.News();
                    if (dt.Rows[n]["N_Id"].ToString() != "")
                    {
                        model.N_Id = int.Parse(dt.Rows[n]["N_Id"].ToString());
                    }
                    model.N_title = dt.Rows[n]["N_title"].ToString();
                    if (dt.Rows[n]["N_ClassID"].ToString() != "")
                    {
                        model.N_ClassID = int.Parse(dt.Rows[n]["N_ClassID"].ToString());
                    }
                    model.N_Content = dt.Rows[n]["N_Content"].ToString();
                    if (dt.Rows[n]["N_DateTime"].ToString() != "")
                    {
                        model.N_DateTime = DateTime.Parse(dt.Rows[n]["N_DateTime"].ToString());
                    }
                    modelList.Add(model);
                }
            }
            return modelList;
        }

        /// <summary>
        /// 获得数据列表
        /// </summary>
        public DataSet GetAllList()
        {
            return GetList("");
        }

        /// <summary>
        /// 返回含类名的新闻列表
        /// </summary>
        /// <param name="strWhere">查询SQL语句</param>
        /// <returns></returns>
        public DataSet GetList_ClassName(string strWhere)
        {
            return dal.GetList_ClassName(strWhere);
        }

        public DataSet GetList_ClassName()
        {
            return dal.GetList_ClassName("");
        }

        /// <summary>
        /// 获得数据列表
        /// </summary>
        //public DataSet GetList(int PageSize,int PageIndex,string strWhere)
        //{
        //return dal.GetList(PageSize,PageIndex,strWhere);
        //}

        #endregion  成员方法
    }
}

 

using System;
using System.Collections.Generic;
using System.Text;

namespace ZeroStudio.Model
{
    public class News
    {
        public News()
        { }
        #region Model
        private int? _n_id;
        private string _n_title;
        private int _n_classid;
        private string _n_content;
        private DateTime _n_datetime;
        /// <summary>
        ///
        /// </summary>
        public int? N_Id
        {
            set { _n_id = value; }
            get { return _n_id; }
        }
        /// <summary>
        ///
        /// </summary>
        public string N_title
        {
            set { _n_title = value; }
            get { return _n_title; }
        }
        /// <summary>
        ///
        /// </summary>
        public int N_ClassID
        {
            set { _n_classid = value; }
            get { return _n_classid; }
        }
        /// <summary>
        ///
        /// </summary>
        public string N_Content
        {
            set { _n_content = value; }
            get { return _n_content; }
        }
        /// <summary>
        ///
        /// </summary>
        public DateTime N_DateTime
        {
            set { _n_datetime = value; }
            get { return _n_datetime; }
        }
        #endregion Model
    }
}

 

 

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.OleDb;
using ZeroStudio.DBUtility;

namespace ZeroStudio.DAL
{
    public class NewsClass
    {
        /// <summary>
        /// 判断类名是否存在
        /// </summary>
        /// <param name="Classname"></param>
        /// <returns></returns>
        public bool Exists(Model.NewsClass model)
        {
            StringBuilder sql = new StringBuilder();
            sql.Append("select count(*) from NewsClass");
            sql.Append(" where NC_ClassName='" + model.ClassName + "'");
            int i = Convert.ToInt32(DbHelperOledb.ExecuteScalar(sql.ToString()));
            if (i > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }

        /// <summary>
        /// 增加一条数据
        /// </summary>
        /// <param name="model"></param>
        public bool Add(Model.NewsClass model)
        {
            StringBuilder sql = new StringBuilder();
            sql.Append("insert into NewsClass(");
            sql.Append("NC_ClassName,NC_Sort)");
            sql.Append(" values (");
            sql.Append("@NC_ClassName,@NC_Sort)");
            OleDbParameter[] parameters = {
                new OleDbParameter("@NC_ClassName",OleDbType.VarChar,50),
                new OleDbParameter("@NC_Sort",OleDbType.Integer,4)};
            parameters[0].Value = model.ClassName;
            parameters[1].Value = model.Sort;

            int i = Convert.ToInt32(DbHelperOledb.ExecuteSql(sql.ToString(),parameters));
            if (i > 0)
                return true;
            else
                return false;
        }

        /// <summary>
        /// 修改一条数据
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool Update(Model.NewsClass model)
        {
            StringBuilder sql = new StringBuilder();
            sql.Append("Update NewsClass Set ");
            sql.Append("NC_ClassName='" + model.ClassName + "',");
            sql.Append("NC_Sort="+ model.Sort +" ");
            sql.Append(" where NC_Id="+ model.Id +"");

            int i = Convert.ToInt32(DbHelperOledb.ExecuteSql(sql.ToString()));
            if (i > 0)
                return true;
            else
                return false;
        }

        /// <summary>
        /// 删除一条数据
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public bool Delete(int id)
        {
            StringBuilder sql = new StringBuilder();
            sql.Append("delete from NewsClass ");
            sql.Append(" where NC_Id=@NC_Id");
            OleDbParameter[] parameters ={
                new OleDbParameter("@NC_Id",OleDbType.Integer,4)};
            parameters[0].Value = id;

            int i = Convert.ToInt32(DbHelperOledb.ExecuteSql(sql.ToString(),parameters));
            if (i > 0)
                return true;
            else
                return false;
        }

        /// <summary>
        /// 得到所有数据列表
        /// </summary>
        /// <returns></returns>
        public DataSet GetAll()
        {
            StringBuilder sql = new StringBuilder();
            sql.Append("Select * from NewsClass order by NC_Sort");
            return DbHelperOledb.Query(sql.ToString());
        }

        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public Model.NewsClass GetModel(int nc_Id)
        {

            StringBuilder strSql = new StringBuilder();
            strSql.Append("select nc_Id,nc_ClassName,nc_Sort from NewsClass ");
            strSql.Append(" where nc_Id=@nc_Id ");
            OleDbParameter[] parameters = {
     new OleDbParameter("@nc_Id", OleDbType.Integer,4)};
            parameters[0].Value = nc_Id;

            Model.NewsClass model = new Model.NewsClass();
            DataSet ds = DbHelperOledb.Query(strSql.ToString(), parameters);
            if (ds.Tables[0].Rows.Count > 0)
            {
                if (ds.Tables[0].Rows[0]["nc_Id"].ToString() != "")
                {
                    model.Id = int.Parse(ds.Tables[0].Rows[0]["nc_Id"].ToString());
                }
                model.ClassName = ds.Tables[0].Rows[0]["nc_ClassName"].ToString();
                if (ds.Tables[0].Rows[0]["nc_Sort"].ToString() != "")
                {
                    model.Sort = int.Parse(ds.Tables[0].Rows[0]["nc_Sort"].ToString());
                }
                return model;
            }
            else
            {
                return null;
            }
        }
    }
}

 

 

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

namespace ZeroStudio.BLL
{
    public class NewsClass
    {
        private readonly DAL.NewsClass dal = new DAL.NewsClass();

        public NewsClass() { }

        /// <summary>
        /// 判断类名是否存在
        /// </summary>
        /// <param name="ClassName"></param>
        /// <returns></returns>
        public bool Exists(string ClassName)
        {
            Model.NewsClass model = new Model.NewsClass();
            model.ClassName = ClassName;
            return dal.Exists(model);
        }

        /// <summary>
        /// 增加一条数据
        /// </summary>
        /// <param name="model"></param>
        public bool Add(Model.NewsClass model)
        {
            return dal.Add(model);
        }

        /// <summary>
        /// 修改一条数据
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool Update(Model.NewsClass model)
        {
            return dal.Update(model);
        }

        /// <summary>
        /// 修改一条数据
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public bool Delete(int id)
        {
            return dal.Delete(id);
        }

        /// <summary>
        /// 得到所有数据列表
        /// </summary>
        /// <returns></returns>
        public DataSet GetAll()
        {
            return dal.GetAll();
        }

        public Model.NewsClass GetModel(int NC_Id)
        {
            return dal.GetModel(NC_Id);
        }
    }
}

 

 

using System;
using System.Collections.Generic;
using System.Text;

namespace ZeroStudio.Model
{
    public class NewsClass
    {
        public NewsClass()
        { }
        #region Model
        private int nc_id;
        private string nc_classname;
        private int nc_sort;
        /// <summary>
        ///
        /// </summary>
        public int Id
        {
            set { nc_id = value; }
            get { return nc_id; }
        }
        /// <summary>
        ///
        /// </summary>
        public string ClassName
        {
            set { nc_classname = value; }
            get { return nc_classname; }
        }
        /// <summary>
        ///
        /// </summary>
        public int Sort
        {
            set { nc_sort = value; }
            get { return nc_sort; }
        }
        #endregion Model
    }
}