public string getUserCollection(int currentpage,int num)
        {
            string result = "";

            string sctemp = "<li class=\"clf\"><a href=\"shop_list_detail.aspx?pro_id={0}\"><span class=\"smallImgbox fl\"><img width=\"70px\" src=\"images/smallDefaultPic.png\" alt=\"{1}\" class=\"lazy boxshowdow\"></span><span class=\"Pdesc fl\"><b>{2}</b> <span class=\"Titledesc\">{3}</span> <span class=\"red\">¥{4}</span><span class=\"yj\">¥{5}</span> </span><span class=\"zk\" onclick=\"deleteIt(this,{6})\">取消</span> </a></li>";//0 产品链接地址 1产品图片 2产品名称 3产品描述 4商城价 5市场价 6删除收藏id
            UserCollectionBll ucbll = new UserCollectionBll();
            ProductBll pbll = new ProductBll();
            int userid = 1;
            var uclist = ucbll.GetAll("*", 1, num, " userid=" + userid, null, "id").Entity;
            if (uclist.Items.Count > 0)
            {
                for (int i = 0; i < uclist.Items.Count; i++)
                {
                    var p = pbll.GetByPrimaryKey(uclist.Items[i].Productid.ToString().ToInt()).Entity;
                    if (p != null)
                    {
                        result += string.Format(sctemp, uclist.Items[i].Productid, ApplicationSettings.Get("imgurl") + p.BigThumPic, p.ProductName, p.Keyword, ((decimal)p.OemPrice).ToString("f0"), ((decimal)p.MarketPrice).ToString("f0"), uclist.Items[i].Id);
                    }
                }
                result += "<span id=\"pager\" style=\"display:none\" pagesize=\"" + num + "\" pagecount=\"" + uclist.PageCount + "\" page=\""+currentpage+"\"></span>";
            }
            else
            {
                result += "<span id=\"pager\" style=\"display:none\" pagesize=\"" + num + "\" pagecount=\"1\" page=\"1\"></span>";
            }
            return result;
        }
        public string getPro(int page, int pagesize)
        {
            string result = "";
            string sctemp = @"<li class=""bdradius6""><a href=""shop_list_detail.aspx?pro_id={0}"">
              <span class=""smallImgbox""><img src=""/images/smallPic.png"" alt=""{1}"" class=""lazy"" ></span>
              <span class=""prodTitle"">{2}</span>
              <span class=""prodPrice clf""> {6}<i class=""fl"">已售 {3}</i></span>
              <span class=""prodPrice clf""><i class=""red fl"">¥{4}</i> <i class=""fl"">¥{5}</i></span>
            </a></li>";
               var list= new ProductBll().GetAll("*", page, pagesize, "", "", " newid()").Entity;
            if (list.Items.Count > 0)
            {
                for (int i = 0; i < list.Items.Count; i++)
                {
                    result += string.Format(sctemp, list.Items[i].Id,
                        "/" + ApplicationSettings.Get("imgurl") + list.Items[i].BigThumPic, list.Items[i].ProductName,
                        list.Items[i].Sale ?? new Random().Next(500), list.Items[i].OemPrice.ToString().Split('.')[0],
                        list.Items[i].MarketPrice.ToString().Split('.')[0], list.Items[i].IsFree == true ? "<i class=\"fl\">包邮</i>" : list.Items[i].OemPrice.ToString().Split('.')[0].ToInt() > 199 ? "<i class=\"fl\">包邮</i>" : "");

                }
                result += "<span id=\"pager\" style=\"display:none\" pagesize=\"" + pagesize + "\" pagecount=\"" +
                              list.PageCount + "\" page=\"" + page + "\"></span>";
            }
            else
            {
                result += "<span id=\"pager\" style=\"display:none\" pagesize=\"" + pagesize + "\" pagecount=\"1\" page=\"1\"></span>";
            }
            return result;
        }
        public void LoadUserOrder(int orderId)
        {
            OrderBll obll = new OrderBll();
            OrderListBll olistbll = new OrderListBll();
            ProductBll pbll = new ProductBll();
            if (HttpContext.Current.Request.Cookies["AdminInfo"] != null)
            {
                HttpCookie cookie = Cookie.Get("AdminInfo");
                string useridstr = HttpUtility.UrlDecode(cookie.Values["AdminId"]);
                int userid = useridstr.ToInt();
                orderEntity = obll.GetAll("*", "userid=" + userid + " and status=0 and id=" + orderId, null, "").Entity.SingleOrDefault();

                if (orderEntity != null)
                {
                    orderListEntity = olistbll.GetAll("*", " orderid=" + orderEntity.Id, null, "id desc").Entity;
                }
            }
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            //获取购物车
            string productId = "";
            if (HttpContext.Current.Request.Cookies["shop"] != null)
            {
                //HttpCookie cookie = Cookie.Get("shop");

                //HttpCookie cookie = new HttpCookie("shop");
                //cookie.Expires = DateTime.Now.AddMonths(-10);
                //Response.Cookies.Add(cookie);
                //Request.Cookies.Remove("shop");

                HttpCookie cookies = Cookie.Get("shop");
                productId = cookies.Values["productId"].ToString();
                if (pro_id.NoEmpty() && productId.IndexOf("," + pro_id + ",") == -1)
                    productId += pro_id + ",";
            }
            else
            {
                if (pro_id.NoEmpty())
                    productId = "," + pro_id + ",";
                pro2();
            }

            if (productId.Trim2().Length > 1)
            {
                productId = productId.Substring(1, productId.Length - 2);
                ProductBll pbll = new ProductBll();
                productList = pbll.GetAll("", "id in (" + productId + ")", "", "").Entity;
                foreach (var p in productList)
                {
                    //判断是否在限时抢购里
                    var list = new Bll.Db.TimeSaleBll().GetAllandProduct(1, 1, " A.classid =(select Top 1 Id from TimeSaleClass where GETDATE() between StartTime and EndTime order by EndTime desc) and A.objectid=" + p.Id, null, " A.orderid desc").Entity;
                    if (list.Items != null && list.Items.Count > 0)
                        p.OemPrice = list.Items[0].SalePrice;
                    isLinepayment = true;
                    if (!p.Linepayment)
                    {
                        isLinepayment = false;
                    }
                    isFree = p.Linepayment;

                }

                var model = pbll.GetByPrimaryKey(pro_id.ToInt()).Entity;
                if (model != null)
                {
                    proname = model.ProductName;
                    proimg = ApplicationSettings.Get("imgurl") + model.BigThumPic;
                    proprice = ((decimal)model.OemPrice).ToString("f0");
                    prono = model.ProductNo;
                }
            }

            if (Cookie.Get("AdminInfo") != null)
            {
                HttpCookie cookie = Cookie.Get("AdminInfo");
                string useridstr = HttpUtility.UrlDecode(cookie.Values["AdminId"]);
                int userid = useridstr.ToInt();

                current = new UsersBll().GetByPrimaryKey(userid).Entity;

                var lastorder = new OrderBll().GetAll("*", " userid=" + userid, null, "id desc").Entity;
                if (lastorder != null)
                {
                    if (lastorder.Count > 0)
                    {
                        string address = lastorder[0].RevicerAddress;

                        string[] arr = address.Split(' ');
                        userp = arr[0].Replace("省", "");
                        userc = arr[1].Replace("市", "");
                        if (address.IndexOf("市") > -1)
                        {
                            ads = address.Split('市')[1].Replace(" ", "");
                        }
                    }
                }

            }
        }
        public string AddOrder(int userid, int productid, int pronum)
        {
            string result = "1";
            Order order = new Order();
            OrderBll orderbll = new OrderBll();
            OrderList orderlist = new OrderList();
            OrderListBll orderlistbll = new OrderListBll();

            ProductBll pbll = new ProductBll();
            UsersBll ubll = new UsersBll();
            try
            {
                //检查 当前用户是否有末完成的订单  有不能
                //if (orderbll.GetAll("*", " [status]=1 and userid=" + userid, null, "id").Entity.Count <= 0)
                //{

                var p = pbll.GetByPrimaryKey(productid).Entity;
                var u = ubll.GetByPrimaryKey(userid).Entity;
                order.UserId = userid;
                order.ReciverName = u.UserName;
                order.PayMentTypeId = 1;//货到付款
                order.RevicerAddress = u.Address;
                order.RevicerTel = u.Mobile;
                order.Status = 1;//
                order.RealPrice = pronum * p.OemPrice;
                order.TotalPrice = pronum * p.OemPrice;
                order.Count = 1;
                order.OrderTime = DateTime.Now;
                order.OrderNo = OrderHelper.GetProNo();
                //添加订单
                int orderaddid = orderbll.AddAndReturn(order);

                //添加订单详情
                orderlist.Count = order.Count;
                orderlist.Productid = productid;
                orderlist.Orderid = orderaddid;
                orderlist.OemPrice = p.OemPrice;
                orderlist.MarketPrice = p.MarketPrice;
                orderlistbll.Add(orderlist);
                //}
                //else
                //{
                //    result = "-2";
                //}

            }
            catch
            {

                result = "-1";
            }

            return result;
        }
        public void AddOrderList(Users u, int productid, int num, int orderid)
        {
            OrderList orderlist = new OrderList();
            OrderListBll orderlistbll = new OrderListBll();

            ProductBll pbll = new ProductBll();
            var p = pbll.GetByPrimaryKey(productid).Entity;

            //添加订单详情
            orderlist.Count = num;
            orderlist.Productid = productid;
            orderlist.Orderid = orderid;
            orderlist.OemPrice = p.OemPrice;
            orderlist.MarketPrice = p.MarketPrice;
            orderlistbll.Add(orderlist);
        }
        public string LoadUserOrder(int currentpage, int num, string where, string order)
        {
            string result = "";
            //if (Cookie.Get("AdminInfo") != null)
            //{
            //    string temp = " <li class=\"clf\"><a href=\"#\"><span class=\"smallImgbox fl\"><img src=\"images/smallDefaultPic.png\" alt=\"{0}\" class=\"lazy boxshowdow\"></span> <span class=\"Pdesc fl\"><b>{1}</b> <span class=\"Titledesc\">{2}</span></span><span class=\"zk\">¥{3}</span> </a></li>";//0产品图片 1产品名称 2产品描述 3订单价格
            //    OrderBll obll = new OrderBll();
            //    OrderListBll olistbll = new OrderListBll();
            //    ProductBll pbll = new ProductBll();
            //    int userid = Cookie.Get("AdminInfo").Values["AdminId"].ToInt();
            //    var blllist = obll.GetAll("*", currentpage, num, "userid=" + userid + " " + where + "", null, order).Entity;

            //    if (blllist.Items.Count > 0)
            //    {
            //        for (int i = 0; i < blllist.Items.Count; i++)
            //        {
            //            var olist = olistbll.GetAll("*", " orderid=" + blllist.Items[i].Id, null, "id desc").Entity;
            //            if (olist.Count > 0)
            //            {
            //                var p = pbll.GetByPrimaryKey(olist[0].Productid.ToString().ToInt()).Entity;
            //                if (p != null)
            //                {
            //                    result += string.Format(temp, ApplicationSettings.Get("imgurl") + p.BigThumPic, p.ProductName, p.Keyword, ((decimal)blllist.Items[i].TotalPrice).ToString("f1"));
            //                }
            //            }
            //        }
            //        result += "<span id=\"pager\" page=\"" + currentpage + "\" pagecount=\"" + blllist.PageCount + "\" style=\"display:none\">";
            //    }
            //    else
            //    {
            //        result += "<span id=\"pager\" page=\"1\" pagecount=\"1\" style=\"display:none\">";
            //    }
            //}
            //return result;
            if (Cookie.Get("AdminInfo") != null)
            {
                //string temp = " <li class=\"clf\"><a href=\"#\"><span class=\"smallImgbox fl\"><img src=\"images/smallDefaultPic.png\" alt=\"{0}\" class=\"lazy boxshowdow\"></span> <span class=\"Pdesc fl\"><b>{1}</b> <span class=\"Titledesc\">{2}</span></span><span class=\"zk\">¥{3}</span> </a></li>";//0产品图片 1产品名称 2产品描述 3订单价格
                string temp1 = "<li class=\"clf\"><p class=\"orderTitle\">订单号:<span class=\"red\">{0}</span>金额:<span class=\"red\">¥{1}</span></p>{2}</li>";
                string temp2 = "<a href=\"#\"><span class=\"smallImgbox fl\"><img src=\"images/smallDefaultPic.png\"  alt=\"{0}\" class=\"lazy boxshowdow\"></span><span class=\"Pdesc fl\"><b>{1}</b><span class=\"Titledesc\"><i>单价:¥{2}</i> <i>数量:{3}</i>  </span></span></a>";
                OrderBll obll = new OrderBll();
                OrderListBll olistbll = new OrderListBll();
                ProductBll pbll = new ProductBll();
                HttpCookie cookie = Cookie.Get("AdminInfo");
                string useridstr = HttpUtility.UrlDecode(cookie.Values["AdminId"]);
                int userid = useridstr.ToInt();
                var blllist = obll.GetAll("*", currentpage, num, "userid=" + userid + " " + where + "", null, order).Entity;

                if (blllist.Items.Count > 0)
                {
                    for (int i = 0; i < blllist.Items.Count; i++)
                    {
                        string orderlist = "";
                        var olist = olistbll.GetAll("*", " orderid=" + blllist.Items[i].Id, null, "id desc").Entity;
                        if (olist.Count > 0)
                        {
                            foreach (var o in olist)
                            {
                                var p = pbll.GetByPrimaryKey(o.Productid.ToString().ToInt()).Entity;
                                if (p != null)
                                {
                                    orderlist += string.Format(temp2, ApplicationSettings.Get("imgurl") + p.SmallThumPic, p.ProductName, ((decimal)p.OemPrice).ToString("f0"), o.Count);
                                }
                            }
                        }
                        result += string.Format(temp1, blllist.Items[i].OrderNo, ((decimal)blllist.Items[i].TotalPrice).ToString("f0"), orderlist);
                    }
                    result += "<span id=\"pager\" page=\"" + currentpage + "\"  pagesize=\"" + num + "\" pagecount=\"" + blllist.PageCount + "\" style=\"display:none\">";
                }
                else
                {
                    result += "<span id=\"pager\" page=\"" + currentpage + "\"  pagesize=\"" + num + "\"  pagecount=\"1\" style=\"display:none\">";
                }
            }
            return result;
        }
        public string getprolist(int page, int pagesize, string type,int userid)
        {
            OrderListBll orderlistbll = new OrderListBll();
            ProductBll probll = new ProductBll();
            string result = "";
            string temp = "";
            string sctemp = @" <li class=""clf"">
              <p class=""orderTitle clf""><span class=""fl"">订单号:<i class=""red"">{0}</i></span> </p>
            {2}
            <a class=""fl"">金额:<i class=""red"">¥{1}</i></a>
            <a href=""javascript:void(0);"" class=""fr""  onclick=""btdelete({3})"" >删除</a><a href=""http://m.kuaidi100.com/"" class=""fr""><span class=""red"">查看物流</span></a>

            </li> ";

            string sctemplist = @"<a href=""#"" class=""shop_list_detail"">
            <span class=""smallImgbox fl""><img src=""{0}""  alt=""{0}"" class=""lazy boxshowdow""></span>
            <span class=""Pdesc fl"">
               <b>{1}</b>
               <span class=""Titledesc""><i>单价:¥{2}</i> <i>数量:{3}</i>  </span>
            </span>
            </a>";
            if (type == "待付款")
            {
                type = "0";
            }

            else if (type == "待发货")
            {
                type = "1";
            }
            else if (type == "已完结")
            {
                type = "2";
            }
            else if (type == "")
            {
                type = "0";
            }

            var list = new OrderBll().GetAll("*", page, pagesize, " userid="+userid+" and Status="+type, "", "ordertime desc").Entity;
            if (list.Items.Count > 0)
            {
                for (int i = 0; i < list.Items.Count; i++)
                {
                    var orderlist =
                        orderlistbll.GetAll("productid,count", " orderid=" + list.Items[i].Id, "", " id").Entity;
                    if (orderlist.Count > 0)
                    {
                        for (int j = 0; j < orderlist.Count; j++)
                        {
                           // var prolist = probll.GetAll("*", " id=" + orderlist[j].Productid, "", "").Entity;
                            var prolist = probll.GetByPrimaryKey(orderlist[j].Productid.ToString().ToInt()).Entity;
                            temp+= string.Format(sctemplist,
                                "/" + ApplicationSettings.Get("imgurl") + prolist.BigThumPic,
                                prolist.ProductName, prolist.OemPrice.ToString().Split('.')[0], orderlist[j].Count);

                        }

                    }
                    result += string.Format(sctemp, list.Items[i].OrderNo, list.Items[i].RealPrice, temp,  list.Items[i].Id);
                    temp = "";

                }
                result += "<span id=\"pager\" style=\"display:none\" pagesize=\"" + pagesize + "\" pagecount=\"" +
                          list.PageCount + "\" page=\"" + page + "\"></span>";
            }
            else
            {
                result += "<span id=\"pager\" style=\"display:none\" pagesize=\"" + pagesize + "\" pagecount=\"1\" page=\"1\"></span>";
            }
            return result;
        }
        public string getprolist(int page, int pagesize, string order,string type,string type2)
        {
            string result = "";
            string sctemp = @"<li class=""bdradius6""><a href=""shop_list_detail.aspx?pro_id={0}"">
              <span class=""smallImgbox""><img src=""/images/smallPic.png"" alt=""{1}"" class=""lazy"" ></span>
              <span class=""prodTitle"">{2}</span>
              <span class=""prodPrice clf""> {6}<i class=""fl"">已售 {3}</i></span>
              <span class=""prodPrice clf""><i class=""red fl"">¥{4}</i> <i class=""fl"">¥{5}</i></span>
              </a></li>";

            if (order == "推荐")
            {
                order = "orderid desc";
            }
            else if (order == "价格↑")
            {
                order = "OemPrice asc";
            }
            else if (order == "价格↓")
            {
                order = "OemPrice desc";
            }
            else if (order == "销量↓")
            {
                order = "sale desc";
            }
            else if (order == "销量↑")
            {
                order = "sale asc";
            }
            else
            {
                order = "orderid desc";
            }

            if (type == "男性用品" || type == "男用玩具")
            {
                type = "1";
            }
            else if (type == "女性用品" || type == "女用玩具")
            {
                type = "4";
            }
            else if (type == "延时锻炼" || type == "锁住幸福")
            {
                type = "12";
            }
            else if (type == "情趣服饰" )
            {
                type = "41";
            }
            else if (type == "调情助兴")
            {
                type = "13";
            }
            else if (type == "套套")
            {
                type = "6";
            }

            //var list = new ProductBll().GetJoinAll("*", page, pagesize, " adid=3", "", " " + order + " desc").Entity;

            var list = new ProductBll().GetAll("*", page, pagesize, getQuery(type,type2), "",order).Entity;
            if (list.Items.Count > 0)
            {
                for (int i = 0; i < list.Items.Count; i++)
                {
                    result += string.Format(sctemp, list.Items[i].Id,
                        "/" + ApplicationSettings.Get("imgurl") + list.Items[i].BigThumPic, list.Items[i].ProductName,
                        list.Items[i].Sale ?? new Random().Next(500), list.Items[i].OemPrice.ToString().Split('.')[0],
                        list.Items[i].MarketPrice.ToString().Split('.')[0], list.Items[i].IsFree == true ? "<i class=\"fl\">包邮</i>" : list.Items[i].OemPrice.ToString().Split('.')[0].ToInt() > 199 ? "<i class=\"fl\">包邮</i>" : "");

                }
                result += "<span id=\"pager\" style=\"display:none\" pagesize=\"" + pagesize + "\" pagecount=\"" +
                              list.PageCount + "\" page=\"" + page + "\"></span>";
            }
            else
            {
                result += "<span id=\"pager\" style=\"display:none\" pagesize=\"" + pagesize + "\" pagecount=\"1\" page=\"1\"></span>";
            }
            return result;
        }