Dal/DLink.cs

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

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

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

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

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

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

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

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public bool Add(MLink model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into Link(");
            strSql.Append("L_id,L_Sortid,L_Name,L_Language,L_Content,L_Date,L_Order,L_Power,L_Key,L_Click,L_Special,L_Pic,L_Address,L_Editor,L_Keywords,L_Description,L_Abstract)");
            strSql.Append(" values (");
            strSql.Append("@L_id,@L_Sortid,@L_Name,@L_Language,@L_Content,@L_Date,@L_Order,@L_Power,@L_Key,@L_Click,@L_Special,@L_Pic,@L_Address,@L_Editor,@L_Keywords,@L_Description,@L_Abstract)");
            SqlParameter[] parameters = {
					new SqlParameter("@L_id", SqlDbType.Int,4),
					new SqlParameter("@L_Sortid", SqlDbType.Int,4),
					new SqlParameter("@L_Name", SqlDbType.VarChar,300),
					new SqlParameter("@L_Language", SqlDbType.VarChar,300),
					new SqlParameter("@L_Content", SqlDbType.NText),
					new SqlParameter("@L_Date", SqlDbType.DateTime),
					new SqlParameter("@L_Order", SqlDbType.Int,4),
					new SqlParameter("@L_Power", SqlDbType.Int,4),
					new SqlParameter("@L_Key", SqlDbType.VarChar,300),
					new SqlParameter("@L_Click", SqlDbType.Int,4),