GeneralWeb.DALSQLServer/NT_Links.cs

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

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

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.OleDb;
using System.Data.SqlClient;

using System.Text;
using GeneralWeb.DALFactory;
namespace GeneralWeb.DALSQLServer
{
    //NT_Links
    public class NT_Links : INT_Links
    {
        private string tableName = "NT_Links";

        public NT_Links()
        { }

        /// <summary>
        /// 添加一条数据
        /// </summary>
        /// <param name="model">要添加的数据model</param>
        /// <returns>添加成功则返回true；添加失败则返回false</returns>
        public bool Add(GeneralWeb.Model.NT_Links model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into " + tableName + "(");
            strSql.Append(" ItemId , ");
            strSql.Append(" ClassId , ");
            strSql.Append(" LinkType , ");
            strSql.Append(" Sort , ");
            strSql.Append(" Show , ");
            strSql.Append(" LinkName , ");
            strSql.Append(" LinkText , ");
            strSql.Append(" LinkUrl , ");
            strSql.Append(" LinkPicUrl , ");
            strSql.Append(" LinkPicWidth , ");
            strSql.Append(" LinkPicHeight , ");
            strSql.Append(" Hits , ");
            strSql.Append(" Description  ");
            strSql.Append(") values (");
            strSql.Append(" @ItemId , ");
            strSql.Append(" @ClassId , ");
            strSql.Append(" @LinkType , ");
            strSql.Append(" @Sort , ");
            strSql.Append(" @Show , ");
            strSql.Append(" @LinkName , ");
            strSql.Append(" @LinkText , ");
            strSql.Append(" @LinkUrl , ");
            strSql.Append(" @LinkPicUrl , ");
            strSql.Append(" @LinkPicWidth , ");
            strSql.Append(" @LinkPicHeight , ");
            strSql.Append(" @Hits , ");
            strSql.Append(" @Description  ");
            strSql.Append(") ");


            SqlParameter[] parameters = {
                new SqlParameter("@Id", SqlDbType.Int,4), 
                new SqlParameter("@ItemId", SqlDbType.NVarChar,12),