OleDbDAL/type_1.cs

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

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

using System;
using System.Collections.Generic;
using System.Text;
using ClothesShop;
using ClothesShop.DBUtility;
using System.Data;
using System.Data.OleDb;

namespace ClothesShop.OleDbDAL
{
    public class type_1 : IDAL.Itype_1
    {
        /// <summary>
        /// 创建一个一级分类
        /// </summary>
        /// <param name="typename">一级分类名称</param>
        /// <returns></returns>
        public int createtype_1(string typename)
        {
            StringBuilder sb = new StringBuilder();
            sb.Append("insert into type_1 (typename) values (@typename)");
            OleDbParameter[] param = { OleDbHelper.GetParameter("@typename", OleDbType.Char, 50, "typename", typename) };
            return OleDbHelper.ExecuteSql(sb.ToString(),param);
        }

        /// <summary>
        /// 删除一级分类
        /// </summary>
        /// <param name="type_1">一级分类编号</param>
        /// <returns></returns>
        public int deletetype_1(int type_1)
        {
            StringBuilder sb = new StringBuilder();
            sb.Append("delete from type_1 where typeid_1=@type_1");
            OleDbParameter[] param = { OleDbHelper.GetParameter("@type_1", OleDbType.Integer, 4, "type_1", type_1) };
            return OleDbHelper.ExecuteSql(sb.ToString(), param);
        }

        /// <summary>
        /// 更新一级分类
        /// </summary>
        /// <param name="type_1">一级分类编号</param>
        /// <param name="typename">一级分类名称</param>
        /// <returns></returns>
        public int updatetype_1(int type_1, string typename)
        {
            StringBuilder sb = new StringBuilder();
            sb.Append("update type_1 set typename=@typename where typeid_1=@type_1");
            OleDbParameter[] param = 
                                   { 
                                       OleDbHelper.GetParameter("@typename", OleDbType.Char, 50, "typename", typename),
                                       OleDbHelper.GetParameter("@type_1", OleDbType.Integer, 4, "typeid_1", type_1)
                                     
                                   };
            return OleDbHelper.ExecuteSql(sb.ToString(), param);
        }

        /// <summary>
        /// 根据类型名称查询商品一级分类
        /// </summary>