icent.SQLServerDAL/UTab_Cate_CatalogFieldValue.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 UTab_Cate_CatalogFieldValue : IUTab_Cate_CatalogFieldValue
    {

        public int Insert(UTab_Cate_CatalogFieldValueInfo uTab_Cate_CatalogFieldValueInfo)
        {
            SqlParameter[] commandParameters = new SqlParameter[] {
           new SqlParameter("@fieldId",SqlDbType.Int),
           new SqlParameter("@values",SqlDbType.VarChar,20),
           new SqlParameter("@description",SqlDbType.NVarChar,200),
           new SqlParameter("@orders",SqlDbType.Int)
           };
            commandParameters[0].Value = uTab_Cate_CatalogFieldValueInfo.FieldId;
            commandParameters[1].Value = uTab_Cate_CatalogFieldValueInfo.Values;
            commandParameters[2].Value = uTab_Cate_CatalogFieldValueInfo.Description;
            commandParameters[3].Value = uTab_Cate_CatalogFieldValueInfo.Orders;

            int result = 0;

            result = SqlHelper.ExecuteNonQuery(SqlHelper.connectionString, CommandType.StoredProcedure, "UTab_Cate_CatalogFieldValue_Insert", commandParameters);

            return result;
        }

        public int Delete(int id)
        {
            SqlParameter[] commandParameters = new SqlParameter[] { 
            new SqlParameter("@id",SqlDbType.Int)
            };
            commandParameters[0].Value = id;

            int result = 0;

            result = SqlHelper.ExecuteNonQuery(SqlHelper.connectionString, CommandType.StoredProcedure, "UTab_Cate_CatalogFieldValue_Delete", commandParameters);

            return result;
        }


        public int Update(UTab_Cate_CatalogFieldValueInfo uTab_Cate_CatalogFieldValueInfo)
        {
            SqlParameter[] commandParameters = new SqlParameter[] {
           new SqlParameter("@id",SqlDbType.Int),
           new SqlParameter("@fieldId",SqlDbType.Int),
           new SqlParameter("@values",SqlDbType.VarChar,20),
           new SqlParameter("@description",SqlDbType.NVarChar,200),
           new SqlParameter("@orders",SqlDbType.Int)
           };

            commandParameters[0].Value = uTab_Cate_CatalogFieldValueInfo.Id;
            commandParameters[1].Value = uTab_Cate_CatalogFieldValueInfo.FieldId;