shop.DAL/NewsCategoryDAO.cs

（开头部分） 15KB

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

using System;
using System.Collections.Generic;
using System.Text;
using shop.Model;
using Microsoft.Practices.EnterpriseLibrary.Data;
using System.Data.Common;
using System.Data;

namespace shop.DAL
{
    public class NewsCategoryDAO
    {
        public int Add(NewsCategory newsCategory)
        {
            Database database = DatabaseFactory.CreateDatabase();
            string sql = "insert into news_category(category_name,is_show,order_by,father_id,path,image,alt,remark) values (@category_name,@is_show,@order_by,@father_id,@path,@image,@alt,@remark) select @@identity";
            DbCommand cmd = database.GetSqlStringCommand(sql);
            database.AddInParameter(cmd, "@category_name", DbType.String, newsCategory.CategoryName);
            database.AddInParameter(cmd, "@is_show", DbType.Boolean, newsCategory.IsShow);
            database.AddInParameter(cmd, "@order_by", DbType.Int32, newsCategory.OrderBy);
            database.AddInParameter(cmd, "@father_id", DbType.Int32, newsCategory.FatherId);
            database.AddInParameter(cmd, "@path", DbType.String, newsCategory.Path);
            database.AddInParameter(cmd, "@image", DbType.String, newsCategory.Image);
            database.AddInParameter(cmd, "@alt", DbType.String, newsCategory.Alt);
            database.AddInParameter(cmd, "@remark", DbType.String, newsCategory.Remark);
            return int.Parse(database.ExecuteScalar(cmd).ToString());
        }

        public bool Delete(int Id)
        {
            Database database = DatabaseFactory.CreateDatabase();
            string sql = "delete from news_category 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 IsHaveSonCategory(int Id)
        {
            Database database = DatabaseFactory.CreateDatabase();
            string sql = "select count(Id) cnt from news_category where father_id=@Id";
            DbCommand cmd = database.GetSqlStringCommand(sql);
            database.AddInParameter(cmd,"@Id",DbType.Int32,Id);
            object obj = database.ExecuteScalar(cmd);
            if (obj == null || obj.ToString().Length == 0)
                return false;
            return int.Parse(obj.ToString()) > 0;
        }
        public bool IsHaveSameName(string categoryName)
        {
            Database database = DatabaseFactory.CreateDatabase();
            string sql = "select count(Id) cnt from news_category where category_name=@category_name";
            DbCommand cmd = database.GetSqlStringCommand(sql);
            database.AddInParameter(cmd, "@category_name", DbType.String, categoryName);
            object obj = database.ExecuteScalar(cmd);
            if (obj == null || obj.ToString().Length == 0)
                return false;
            return int.Parse(obj.ToString())>0;
        }
        public bool Update(NewsCategory newsCategory)
后面还有 225 行代码，购买后查看完整代码

24 小时内免费解锁 3 个项目，之后 1 积分/个。 规则说明

AI 解读 AI

登录后可用，每次 10 积分，解读结果公开显示在下面。

还没有人解读过这个文件。