com.eshop.www.DAL/MemberLevelDAO.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 MemberLevelDAO
    {
        public bool Add(MemberLevel memberLevel)
        {
            Database database = DatabaseFactory.CreateDatabase();
            string sql = "insert into member_level(max_integral,min_integral,level_name,discount) values (@max_integral,@min_integral,@level_name,@discount)";
            DbCommand cmd = database.GetSqlStringCommand(sql);
            database.AddInParameter(cmd, "@max_integral", DbType.Int32, memberLevel.MaxIntegral);
            database.AddInParameter(cmd, "@min_integral", DbType.Int32, memberLevel.MinIntegral);
            database.AddInParameter(cmd, "@level_name", DbType.String, memberLevel.LevelName);
            database.AddInParameter(cmd, "@discount", DbType.Decimal, memberLevel.Discount);
            int row = database.ExecuteNonQuery(cmd);
            return row > 0;
        }

        public bool Delete(int Id)
        {
            Database database = DatabaseFactory.CreateDatabase();
            string sql = "delete from member_level 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(MemberLevel memberLevel)
        {
            Database database = DatabaseFactory.CreateDatabase();
            string sql = "update member_level set max_integral=@max_integral,min_integral=@min_integral,level_name=@level_name,discount=@discount where Id=@Id";
            DbCommand cmd = database.GetSqlStringCommand(sql);
            database.AddInParameter(cmd, "@max_integral", DbType.Int32, memberLevel.MaxIntegral);
            database.AddInParameter(cmd, "@min_integral", DbType.Int32, memberLevel.MinIntegral);
            database.AddInParameter(cmd, "@level_name", DbType.String, memberLevel.LevelName);
            database.AddInParameter(cmd, "@discount", DbType.Decimal, memberLevel.Discount);
            database.AddInParameter(cmd, "@Id", DbType.Int32, memberLevel.Id);
            int row = database.ExecuteNonQuery(cmd);
            return row > 0;
        }