就闪耀-个人博客

效果图

使用图标

SQL语句


/****** 对象:  Table [dbo].[GoodsCate]    脚本日期: 04/24/2013 21:30:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[GoodsCate](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[PC_UniqueID] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[PC_Title] [nvarchar](500) COLLATE Chinese_PRC_CI_AS NULL,
	[PC_Sign] [nvarchar](500) COLLATE Chinese_PRC_CI_AS NULL,
	[PC_Short] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[PC_Sort] [int] NULL,
	[PC_Remarks] [nvarchar](2000) COLLATE Chinese_PRC_CI_AS NULL,
	[ProductCategory_ID] [int] NULL,
	[PC_Level] [int] NULL,
	[PC_PIC] [nvarchar](2000) COLLATE Chinese_PRC_CI_AS NULL,
	[PC_MaxPIC] [nvarchar](2000) COLLATE Chinese_PRC_CI_AS NULL,
	[PC_IsHomeShow] [bit] NULL,
	[PC_HomeShowSort] [int] NULL,
	[PC_SEOTitle] [nvarchar](500) COLLATE Chinese_PRC_CI_AS NULL,
	[PC_SEOKeyword] [nvarchar](500) COLLATE Chinese_PRC_CI_AS NULL,
	[PC_SEODescription] [nvarchar](1000) COLLATE Chinese_PRC_CI_AS NULL,
	[BrandNameList] [nvarchar](2000) COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT [DF_GoodsCate_BrandID]  DEFAULT ((0)),
	[BrandIdList] [nvarchar](2000) COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT [DF_GoodsCate_BrandNameList1]  DEFAULT ((0)),
 CONSTRAINT [PK__XShop_ProductCat__0F975522] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键--标识ID' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'GoodsCate', @level2type=N'COLUMN', @level2name=N'id'

GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'唯一编号' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'GoodsCate', @level2type=N'COLUMN', @level2name=N'PC_UniqueID'

GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'分类名称' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'GoodsCate', @level2type=N'COLUMN', @level2name=N'PC_Title'

GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'标识' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'GoodsCate', @level2type=N'COLUMN', @level2name=N'PC_Sign'

GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'缩写' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'GoodsCate', @level2type=N'COLUMN', @level2name=N'PC_Short'

GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'正常排序号' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'GoodsCate', @level2type=N'COLUMN', @level2name=N'PC_Sort'

GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'GoodsCate', @level2type=N'COLUMN', @level2name=N'PC_Remarks'

GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'上级分类' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'GoodsCate', @level2type=N'COLUMN', @level2name=N'ProductCategory_ID'

GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'级别' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'GoodsCate', @level2type=N'COLUMN', @level2name=N'PC_Level'

GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'分类图标' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'GoodsCate', @level2type=N'COLUMN', @level2name=N'PC_PIC'

GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'商品大图标' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'GoodsCate', @level2type=N'COLUMN', @level2name=N'PC_MaxPIC'

GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'首页是否显示' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'GoodsCate', @level2type=N'COLUMN', @level2name=N'PC_IsHomeShow'

GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'首页排序号' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'GoodsCate', @level2type=N'COLUMN', @level2name=N'PC_HomeShowSort'

GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'SEO标题' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'GoodsCate', @level2type=N'COLUMN', @level2name=N'PC_SEOTitle'

GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'SEO关键字' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'GoodsCate', @level2type=N'COLUMN', @level2name=N'PC_SEOKeyword'

GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'SEO描述' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'GoodsCate', @level2type=N'COLUMN', @level2name=N'PC_SEODescription'

GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'关联品牌' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'GoodsCate', @level2type=N'COLUMN', @level2name=N'BrandNameList'

GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'关联品牌IdList' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'GoodsCate', @level2type=N'COLUMN', @level2name=N'BrandIdList'

GO
EXEC sys.sp_addextendedproperty @name=N'TableDescription', @value=N'商品分类表' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'GoodsCate'

HTML代码

<div id="Main">
    <div class="Sell">
        <div class="SGameType">
            <div class="Box">
                <div class="Bitem">
                    <div> 
                    </div>
                </div>
                <div class="Bitem">
                    <div> 
                    </div>
                </div>
                <div class="Bitem">
                    <div> 
                    </div>
                </div>                  
                <br class="Cls" />
            </div>
        </div>
        <div class="SelectGame">
	        您当前选择的是： 
        </div> 
        <form action='<%=Url.Action("GoodsLibraryFrm") %>' method="get" id="nextFrom"> 
            <input type="text" name="ProductCategoryID" id="ProductCategoryID"  style="display:none" />
            <input type="text" id="Frm_IsOK"  style="display:none" />
            <input type="text" name="BrandID" id="BrandID"  style="display:none" value="<%=b_model.id %>" />
            <center><a class="CP nextFromBtn"><img style="padding:25px 0px 30px;" src="/JS/Product/images/ok.jpg" alt=" " /></a></center>
        </form>
    </div>
</div>

CSS代码

#Main{width:960px;margin:10px;overflow:hidden;font-family:"宋体";font-size:12px;color:#333333;}
#Main .Sell{width:100%;padding-top:5px;overflow:hidden;}
#Main .Sell .Stilte{font-size:14px;font-weight:bold;color:#333333;line-height:25px; overflow:hidden;}
#Main .Sell .SGameType{width:934px;border:1px solid #c4dcec;background:url(images/l8.jpg) top repeat-x #e9f5fd;padding:10px 12px; overflow:hidden;}
#Main .Sell .SGameType .Box{width:932px;border:1px solid #7f9db9;background-color:#e5effe; overflow:hidden;}
#Main .Sell .SGameType .Box .Bitem{width:142px;+width:150px;border-left:1px solid #cccccc;border-right:1px solid #cccccc;float:left;overflow:hidden;background-color:#FFF;padding:3px 3px;margin-left:6px;}
#Main .Sell .SGameType .Box .Bitem input{width:120px;border:1px solid #7f9db9;line-height:22px;height:22px;background:url(images/l9.jpg) left center no-repeat;padding-left:20px;color:#cccccc;}
#Main .Sell .SGameType .Box .Bitem div{width:100%;height:200px;line-height:24px;overflow:hidden;overflow-y:auto}
#Main .Sell .SGameType .Box .Bitem div a{width:136px;float:left;color:#333333;background:url(images/l1.gif) right center no-repeat;padding-left:4px}
#Main .Sell .SGameType .Box .Bitem div a:hover{background-color:#eff5fe;color:#0066cc;border:1px solid #cbe0ff;text-decoration:none;}
#Main .Sell .SGameType .Box .Bitem div .ahover{background-color:#eff5fe;color:#0066cc;border:1px solid #cbe0ff;text-decoration:none;}
#Main .Sell .SelectGame {width:920px;padding:4px 19px;border:1px solid #d0eaf9;background-color:#e7f5fe;margin-top:5px;line-height:24px;color:#3384bc;font-size:13px;font-weight:bold}
#Main .Sell .SelectGame a{color:#e64100;font-weight:normal;}

JS代码

//加载第一级
$(function () {
    GetGame(1, "");
    $("#ProductCategoryID").val("");
    $("#ProductTypesID").val("");
    $("#Frm_IsOK").val("0");
    //<input type="text" value="请输入字母" onfocus="this.value='';"/>
    //$(".SGameType .Box .Bitem:eq(0) :text").keyup(function () {
    //    var objs = $(this).next().find("." + $(this).val());
    //    var all = $(this).next().find("a");
    //    if (objs.length < 1)
    //        all.show();
    //    else {
    //        all.hide();
    //        objs.show();
    //    }
    //});
});
function GetGame(gC, pcid) {

    $(".SGameType .Box .Bitem:gt(" + (gC - 2) + ") div").html("");
    $(".SelectGame a:gt(" + (gC - 2) + ")").remove();
    $.ajax({
        url: '/Comm/GetPCList',
        async: false,
        dataType: 'json',
        type: "POST",
        data: { gCase: gC, pcid: pcid, bid: $("#BrandID").val(), r: new Date().getTime() },
        success: function (data) {
            var html = "";
            $.each(data, function (ii, vv) {
                html += "<a href='#' pcid='" + vv.pcid + "' gc=" + gC + " isok='" + vv.isok + "' >" + vv.pcName + "</a>";
            });
            $(".SGameType .Box .Bitem:eq(" + (gC - 1) + ") div").html(html == "" ? "没有分类" : html);

            AttEvent();
        }
    });
}

function AttEvent() {
    $(".SGameType .Box .Bitem a").each(function (i, v) {
        $(v).unbind("click");
        $(v).click(function () {

            GetGame(parseInt($(this).attr("gc")) + 1, $(this).attr("pcid"));
            if ($(this).attr("gc") == "3") {
                $("#ProductCategoryID").val($(this).attr("pcid"));
                $("#Frm_IsOK").val($(this).attr("isok"));
            } else {
                $("#ProductCategoryID").val("");
                $("#Frm_IsOK").val("0");
            }
            var obj = $(".SelectGame a:eq(" + (parseInt($(this).attr("gc")) - 1) + ")");
            var tag = $(this).attr("gc") == "3" ? "" : " &gt; ";
            if (obj.length < 1)
                $(".SelectGame").append("<a href='javascript:void(0);'>" + $(this).text() + tag + "</a>");
            else
                obj.html($(this).text() + tag);

            $(this).parent().find(".ahover").removeClass("ahover");
            $(this).addClass("ahover");

            return false;
        });
    });
}
$(function () {
    $(".nextFromBtn").click(function () {
        if ($("#ProductCategoryID").val() == "") {
            alert("请选择商品三级分类");
            return false;
        }
        if ($("#Frm_IsOK").val() == "0") {
            alert("很抱歉该分类无法发布");
            return false;
        }

        $("#nextFrom").submit();
        return false;
    });
});

Code代码

/// <summary>
/// 商品分类处理类
/// </summary>
public class PCModelClass
{
    /// <summary>
    /// 分类ID
    /// </summary>
    public int? pcid { get; set; }
    /// <summary>
    /// 分类级别
    /// </summary>
    public int? pclevel { get; set; }
    /// <summary>
    /// 分类名称
    /// </summary>
    public string pcName { get; set; }
    /// <summary>
    /// 是否成功
    /// </summary>
    public string isok { get; set; }
}

/// <summary>
/// 获得批定级的商品分类
/// </summary>
/// <param name="gCase">分类级别</param>
/// <param name="pcid">上级分类ID</param>
/// <param name="bid">品牌ID</param>
/// <returns></returns>
public ActionResult GetPCList(int? gCase, int? pcid, int? bid)
{
    //System.Threading.Thread.Sleep(1000);
    List<GoodsCate> pcmodellist = GoodsCate.GetModelList(int.MaxValue, t =>
            t.PC_Level == gCase.ToInt32() && t.ProductCategory_ID == pcid.ToInt32(),
            t => t.PC_Sort.lb_Desc() && t.id.lb_Desc()).List;
    List<PCModelClass> PCModelClassList = new List<PCModelClass>();
    foreach (GoodsCate item in pcmodellist)
    {
        bool b_isok = false;
        switch ((DealMvc.CommonEnumHelper.LevelCate)item.PC_Level)
        {
            case CommonEnumHelper.LevelCate.一级:
                break;
            case CommonEnumHelper.LevelCate.二级:
                break;
            case CommonEnumHelper.LevelCate.三级:
                if (item.GetListBrandInt().Contains(bid.ToInt32()))
                    b_isok = true;
                break;
            case CommonEnumHelper.LevelCate.四级:
                break;
        }
        //pcId pcName pcLevel ptId ptName
        PCModelClassList.Add(new PCModelClass()
        {
            pcid = item.id.ToInt32(),
            pcName = item.PC_Title.ToString2(),
            pclevel = item.PC_Level.ToInt32(),
            isok = b_isok ? "1" : "0"
        });
    }
    return Json(PCModelClassList, JsonRequestBehavior.AllowGet);
}