Dal/DJiaYuan.cs

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

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

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

namespace Dal
{
    public class DJiaYuan
    {
        public bool HasRecord(int N_Id)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select * from JiaYuan");
            strSql.Append(" where ");
            strSql.Append(" N_Id = @N_Id  ");
            SqlParameter[] parameters = {
					new SqlParameter("@N_Id", SqlDbType.Int,4)};
            parameters[0].Value = N_Id;

            return OLEDBHelper.HasRecord(strSql.ToString(), parameters, CommandType.Text);
        }

        public void AddClick(int N_Id)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("Update JiaYuan");
            strSql.Append(" Set N_Click=N_Click+1 ");
            strSql.Append(" where ");
            strSql.Append(" N_Id = @N_Id  ");
            SqlParameter[] parameters = {
					new SqlParameter("@N_Id", SqlDbType.Int,4)};
            parameters[0].Value = N_Id;

            OLEDBHelper.HasRecord(strSql.ToString(), parameters, CommandType.Text);
        }

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public bool Add(MJiaYuan model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into JiaYuan(");
            strSql.Append("N_Id,N_Url,N_Memo,N_Content,N_Title,N_Keywords,N_Description,N_Order,N_Special,N_Show,N_Color,N_Name,N_Name2,N_SortId,N_Date,N_Click,N_Pic,N_Pic2,N_InfoFrom,N_Author");
            strSql.Append(") values (");
            strSql.Append("@N_Id,@N_Url,@N_Memo,@N_Content,@N_Title,@N_Keywords,@N_Description,@N_Order,@N_Special,@N_Show,@N_Color,@N_Name,@N_Name2,@N_SortId,@N_Date,@N_Click,@N_Pic,@N_Pic2,@N_InfoFrom,@N_Author");
            strSql.Append(") ");

            SqlParameter[] parameters = {
			            new SqlParameter("@N_Id", SqlDbType.Int,4) ,            
                        new SqlParameter("@N_Url", SqlDbType.Text) ,            
                        new SqlParameter("@N_Memo", SqlDbType.Text) ,            
                        new SqlParameter("@N_Content", SqlDbType.Text) ,            
                        new SqlParameter("@N_Title", SqlDbType.Text) ,            
                        new SqlParameter("@N_Keywords", SqlDbType.Text) ,            
                        new SqlParameter("@N_Description", SqlDbType.Text) ,            
                        new SqlParameter("@N_Order", SqlDbType.Int,4) ,