com.eshop.www.DAL/ProductAttributeDAO.cs

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

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

//
// 
// 网址：http://.taobao.com
// QQ：



using System;
using System.Collections.Generic;
using System.Text;

using com.eshop.www.Model;
using Microsoft.Practices.EnterpriseLibrary.Data;
using System.Data.Common;
using System.Data;

namespace com.eshop.www.DAL
{
    public class ProductAttributeDAO
    {
        public int Add(ProductAttribute productAttribute)
        {
            Database database = DatabaseFactory.CreateDatabase();
            string sql = "insert into product_attribute(attribute,values_list,is_multiple,is_filter) values (@attribute,@values_list,@is_multiple,@is_filter) select @@identity";
            DbCommand cmd = database.GetSqlStringCommand(sql);
            database.AddInParameter(cmd, "@attribute", DbType.String, productAttribute.Attribute);
            database.AddInParameter(cmd, "@values_list", DbType.String, productAttribute.ValuesList);
            database.AddInParameter(cmd, "@is_multiple", DbType.Boolean, productAttribute.isMultiple);
            database.AddInParameter(cmd, "@is_filter", DbType.Boolean, productAttribute.IsFilter);
            return int.Parse(database.ExecuteScalar(cmd).ToString());
        }
        public bool IsHaveSameName(string attributeName)
        {
            Database database = DatabaseFactory.CreateDatabase();
            string sql = "select count(Id) cnt from product_attribute where attribute=@attribute";
            DbCommand cmd = database.GetSqlStringCommand(sql);
            database.AddInParameter(cmd, "@attribute", DbType.String, attributeName);
            return int.Parse(database.ExecuteScalar(cmd).ToString())>0;
        }
        public bool Delete(int Id)
        {
            Database database = DatabaseFactory.CreateDatabase();
            string sql = "delete from product_attribute where Id=@Id";
            DbCommand cmd = database.GetSqlStringCommand(sql);
            database.AddInParameter(cmd, "@Id", DbType.Int32, Id);
            int row = database.ExecuteNonQuery(cmd);
            return row > 0;
        }

        public bool Update(ProductAttribute productAttribute)
        {
            Database database = DatabaseFactory.CreateDatabase();
            string sql = "update product_attribute set attribute=@attribute,values_list=@values_list,is_multiple=@is_multiple,is_filter=@is_filter where Id=@Id";
            DbCommand cmd = database.GetSqlStringCommand(sql);
            database.AddInParameter(cmd, "@attribute", DbType.String, productAttribute.Attribute);
            database.AddInParameter(cmd, "@values_list", DbType.String, productAttribute.ValuesList);