void GetOptionList()
        {
            string subid = string.Empty;

            if (Request["subid"] != null && Request["subid"] != "")
            {
                subid = Common.Common.NoHtml(Request["subid"]);
            }
            else
            {
                return;
            }
            if (subid.Trim() != null && subid.Trim() != "")
            {
                MSProductCategoryDAL categoryDal = new MSProductCategoryDAL();
                DataSet optionds;
                optionds = categoryDal.GetMSPCList(" and [SID]='" + subid + "' ");
                Response.Write(Dataset2Json(optionds));
            }
            else
            {
                Response.Write("{\"success\":\"操作失败\"}");
            }
            Response.End();
        }
示例#2
0
        /// <summary>
        /// 获取店铺商品信息
        /// </summary>
        void GetInfo()
        {
            #region 获取店铺详细
            MSShopDAL shopdal   = new MSShopDAL();
            DataSet   shopds    = shopdal.GetMSShopDetail(shopid);
            MSShop    shopmodel = new MSShop();
            string    pagetitle = string.Empty;
            if (null != shopds && shopds.Tables.Count > 0 && shopds.Tables[0].Rows.Count > 0)
            {
                shopmodel = DataConvert.DataRowToModel <MSShop>(shopds.Tables[0].Rows[0]);
                pagetitle = shopmodel.ShopName;
            }
            #endregion

            List <MSProduct> ProductModel = new List <MSProduct>();
            MSProductDAL     productdal   = new MSProductDAL();

            MSProductAtlasDAL     atlasDal   = new MSProductAtlasDAL();
            List <MSProductAtlas> AtlasModel = new List <MSProductAtlas>();

            List <ProductPara> ParaListModel = new List <ProductPara>();
            MSProductParaDAL   paraDal       = new MSProductParaDAL();

            string thpid = string.Empty;
            #region 获取产品列表
            DataSet productds = null; string cid = string.Empty; string like = string.Empty;
            if (Request["cid"] != null && Request["cid"] != "")
            {
                cid = Common.Common.NoHtml(Request["cid"]);
            }
            if (cid.Trim() != null && cid.Trim() != "")
            {
                cid = " and a.[CID]='" + cid + "' ";
            }
            if (Request["like"] != null && Request["like"] != "")
            {
                like = Common.Common.NoHtml(Request["like"]);
            }
            if (like.Trim() != null && like.Trim() != "")
            {
                like = " and a.Ptitle like '%" + like + "%' ";
            }
            productds = productdal.GetProductList(" and a.[SID]='" + shopid + "' " + cid + like);
            DataSet atlasDs = null;
            foreach (DataRow row in productds.Tables[0].Rows)
            {
                MSProduct model = DataConvert.DataRowToModel <MSProduct>(row);
                string    pdesc = model.Pcontent;
                pdesc = JQDialog.GetTextFromHTML(pdesc);
                if (pdesc.Length > 50)
                {
                    pdesc = pdesc.ToString().Substring(0, 50) + "...";
                }
                model.Pcontent = pdesc;
                ProductModel.Add(model);
                thpid = model.ID;

                #region 获取产品默认展示图
                atlasDs = atlasDal.GetDefaultAtlasByPid(thpid);
                foreach (DataRow atlasrow in atlasDs.Tables[0].Rows)
                {
                    MSProductAtlas atlasdetailmodel = DataConvert.DataRowToModel <MSProductAtlas>(atlasrow);
                    AtlasModel.Add(atlasdetailmodel);
                }
                #endregion

                #region -------获取产品型号及价格------------
                DataSet parads = paraDal.GetMaxMinPrice(thpid);
                if (parads != null && parads.Tables.Count > 0 && parads.Tables[0].Rows.Count > 0)
                {
                    foreach (DataRow pararow in parads.Tables[0].Rows)
                    {
                        ProductPara paramodel = DataConvert.DataRowToModel <ProductPara>(pararow);
                        ParaListModel.Add(paramodel);
                    }
                }
                #endregion
            }
            #endregion

            #region 获取产品类别
            List <MSProductCategory> CategoryModel = new List <MSProductCategory>();
            MSProductCategoryDAL     categorydal   = new MSProductCategoryDAL();
            DataSet categoryds = categorydal.GetMSPCList(" and a.[SID]='" + shopid + "' ");
            foreach (DataRow row in categoryds.Tables[0].Rows)
            {
                MSProductCategory model = DataConvert.DataRowToModel <MSProductCategory>(row);
                CategoryModel.Add(model);
            }
            #endregion

            string text = System.IO.File.ReadAllText(Server.MapPath("../ShopPage/MyShop.html"));
            JinianNet.JNTemplate.TemplateContext context = new JinianNet.JNTemplate.TemplateContext();

            context.TempData["title"]        = pagetitle;
            context.TempData["ShopDetail"]   = shopmodel;
            context.TempData["shopid"]       = shopid;
            context.TempData["productlist"]  = ProductModel;
            context.TempData["defaultatlas"] = AtlasModel;
            context.TempData["categorylist"] = CategoryModel;
            context.TempData["paralist"]     = ParaListModel;
            context.TempData["errormsg"]     = errormsg;
            context.TempData["customerid"]   = customerid;
            if (Session["customerID"] != null && Session["customerID"].ToString() != "")
            {
                context.TempData["uid"] = Session["customerID"].ToString();
            }
            context.TempData["footer"] = "奥琦微商易";

            JinianNet.JNTemplate.Template t = new JinianNet.JNTemplate.Template(context, text);
            t.Render(Response.Output);
        }