icent.SQLServerDAL/Catalog.cs

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

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

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using icent.IDAL;
using icent.DBUtility;
using icent.Model;

namespace icent.SQLServerDAL
{
    public class Catalog : ICatalog
    {
        public int Insert(CatalogInfo catalog)
        {
            SqlParameter[] commandParameters = new SqlParameter[] {
           new SqlParameter("@name",SqlDbType.VarChar,20),
           new SqlParameter("@displayName",SqlDbType.NVarChar,20),
           new SqlParameter("@image",SqlDbType.VarChar,50),
           new SqlParameter("@url",SqlDbType.VarChar,50),
           new SqlParameter("@domain",SqlDbType.VarChar,30),
           new SqlParameter("@modelId",SqlDbType.Int),
           new SqlParameter("@parentId",SqlDbType.Int),
           new SqlParameter("@permissionGroupId",SqlDbType.Int),
           new SqlParameter("@linkType",SqlDbType.VarChar,20),
           new SqlParameter("@isHot",SqlDbType.Bit),
           new SqlParameter("@isTop",SqlDbType.Bit),
           new SqlParameter("@isRecommend",SqlDbType.Bit),
           new SqlParameter("@isColor",SqlDbType.Bit),
           new SqlParameter("@isDisplay",SqlDbType.Bit),
           new SqlParameter("@isAllowComment",SqlDbType.Bit),
           new SqlParameter("@isCreateHtml",SqlDbType.Bit),
           new SqlParameter("@isAllowUserWriter",SqlDbType.Bit),
           new SqlParameter("@description",SqlDbType.NText),
           new SqlParameter("@seoTitle",SqlDbType.NVarChar,50),
           new SqlParameter("@seoKeys",SqlDbType.NVarChar,100),
           new SqlParameter("@seoDescription",SqlDbType.NVarChar,200),
           new SqlParameter("@userId",SqlDbType.Int),
           new SqlParameter("@orders",SqlDbType.Int)
           };
            commandParameters[0].Value = catalog.Name;
            commandParameters[1].Value = catalog.DisplayName;
            commandParameters[2].Value = catalog.Image;
            commandParameters[3].Value = catalog.Url;
            commandParameters[4].Value = catalog.Domain;
            commandParameters[5].Value = catalog.ModelId;
            commandParameters[6].Value = catalog.ParentId;
            commandParameters[7].Value = catalog.PermissionGroupId;
            commandParameters[8].Value = catalog.LinkType;
            commandParameters[9].Value = catalog.IsHot;
            commandParameters[10].Value = catalog.IsTop;
            commandParameters[11].Value = catalog.IsRecommend;
            commandParameters[12].Value = catalog.IsColor;
            commandParameters[13].Value = catalog.IsDisplay;
            commandParameters[14].Value = catalog.IsAllowComment;
            commandParameters[15].Value = catalog.IsCreateHtml;
            commandParameters[16].Value = catalog.IsAllowUserWriter;
            commandParameters[17].Value = catalog.Description;
            commandParameters[18].Value = catalog.SeoTitle;
            commandParameters[19].Value = catalog.SeoKeys;
            commandParameters[20].Value = catalog.SeoDescription;