Hidistro.SqlDal/zbCommodities/BrandCategoryDao.cs

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

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

namespace Hidistro.SqlDal.zbCommodities
{
    using Hidistro.Core;
    using Hidistro.Core.Entities;
    using Hidistro.Core.Enums;
    using Hidistro.Entities;
    using Hidistro.Entities.Commodities;
    using Hidistro.Entities.Sales;
    using Microsoft.Practices.EnterpriseLibrary.Data;
    using System;
    using System.Collections.Generic;
    using System.Data;
    using System.Data.Common;
    using System.Text;

    public class BrandCategoryDao
    {
        private Database database = DatabaseFactory.CreateDatabase();

        public int AddBrandCategory(BrandCategoryInfo brandCategory)
        {
            DbCommand sqlStringCommand = this.database.GetSqlStringCommand(@"
declare @RoleId int ;
declare @MemberId int ;
declare @UserName nvarchar(50);
declare @ShopName nvarchar(50);

select @MemberId=MemberId,@RoleId=RoleId from aspnet_Managers where userid=@userID;
IF(@RoleId=1)
BEGIN
SET @userID=0;
END
ELSE
BEGIN
select  @ShopName=StoreName from aspnet_Distributors where UserId=@MemberId;
select  @UserName=UserName from aspnet_Members where UserId=@MemberId;
END;
            
            DECLARE @DisplaySequence AS INT SELECT @DisplaySequence = (CASE WHEN MAX(DisplaySequence) IS NULL THEN 1 ELSE MAX(DisplaySequence) + 1 END) FROM Hishop_zbBrandCategories;INSERT INTO Hishop_zbBrandCategories(BrandName, Logo, CompanyUrl,RewriteName,MetaKeywords,MetaDescription, Description, DisplaySequence,userid,userName,ShopName) VALUES(@BrandName, @Logo, @CompanyUrl,@RewriteName,@MetaKeywords,@MetaDescription, @Description, @DisplaySequence,@userid,@userName,@ShopName); SELECT @@IDENTITY");
            this.database.AddInParameter(sqlStringCommand, "BrandName", DbType.String, brandCategory.BrandName);
            this.database.AddInParameter(sqlStringCommand, "Logo", DbType.String, brandCategory.Logo);
            this.database.AddInParameter(sqlStringCommand, "CompanyUrl", DbType.String, brandCategory.CompanyUrl);
            this.database.AddInParameter(sqlStringCommand, "RewriteName", DbType.String, brandCategory.RewriteName);
            this.database.AddInParameter(sqlStringCommand, "MetaKeywords", DbType.String, brandCategory.MetaKeywords);
            this.database.AddInParameter(sqlStringCommand, "MetaDescription", DbType.String, brandCategory.MetaDescription);
            this.database.AddInParameter(sqlStringCommand, "Description", DbType.String, brandCategory.Description);
            this.database.AddInParameter(sqlStringCommand, "userID", DbType.Int32, Globals.GetCurrentManagerUserId());
            object obj2 = this.database.ExecuteScalar(sqlStringCommand);
            if (obj2 != null)
            {
                return Convert.ToInt32(obj2);
            }
            return 0;
        }

        public void AddBrandProductTypes(int brandId, IList<int> productTypes)
        {