default.aspx.cs

易想商城系统

        {
            List<Model.Provinces> list = B_Provinces.GetListByColumn("Fid=" + Fid + " Order by orderid");
            if (list.Count > 0)
            {
                for (int i = 0; i < list.Count; i++)
                {
                    B_Provinces.Amend(list[i].ID, "OrderID", i + 1);
                }
            }
        }        /*
        private void Up(int ID)
        {
            int previd = 0;
            int nextid = 0;
            int child = 0;
            int orderid = 0;
            int parentid = 0;
            int rootid = 0;
            string parentpath = "";

            //上移项值
            int up_classid = 0;
            int up_previd = 0;
            int up_nextid = 0;
            int up_child = 0;
            int up_orderid = 0;
            int up_parentid = 0;
            string up_parentpath = "";
            int up_rootid = 0;
            int up_sonorderid = 0;

            int minroot = //Exsql.YX_Execint("select min(yx_rootid) from yx_productclass");
            B_Provinces.GetValue("MinTaxis", null);
            List<Model.Provinces> listProv = B_Provinces.GetListByColumn("ID", ID);

            if (listProv.Count > 0)
            {
                parentid = (int)listProv[0].Fid;// Convert.ToInt32(sdr["yx_parentid"]);
                rootid = (int)listProv[0].Taxis;//Convert.ToInt32(sdr["yx_rootid"]);
                if (rootid == minroot && parentid == 0)
                {
                    alert.showOnly("你已经在最顶级");
                    Response.End();
                }
                if (listProv[0].PrevID == 0 && parentid != 0)
                {
                    alert.showOnly("你已经在最顶级");
                    Response.End();
                }

                previd = listProv[0].PrevID;
                nextid = listProv[0].NextID;             // Convert.ToInt32(sdr["yx_nextid"]);
                child = (int)listProv[0].Child;               // Convert.ToInt32(sdr["yx_child"]);
                orderid = listProv[0].OrderID;           // Convert.ToInt32(sdr["yx_orderid"]);
                rootid = (int)listProv[0].Taxis;              // Convert.ToInt32(sdr["yx_rootid"]);
                parentpath = listProv[0].ParentPath;     // Convert.ToString(sdr["yx_parentpath"]);            

            }

            List<Model.Provinces> listProvNext = B_Provinces.GetListByColumn("NextId", ID);
            if (listProv.Count > 0)
            {
                up_classid = listProvNext[0].ID;            // Convert.ToInt32(up_sdr["yx_id"]);
                up_previd = listProvNext[0].PrevID;         //Convert.ToInt32(up_sdr["yx_previd"]);
                up_nextid = listProvNext[0].NextID;         // Convert.ToInt32(up_sdr["yx_nextid"]);
                up_child = (int)listProvNext[0].Child;           // Convert.ToInt32(up_sdr["yx_child"]);
                up_orderid = listProvNext[0].OrderID;       // Convert.ToInt32(up_sdr["yx_orderid"]);
                up_parentid = (int)listProvNext[0].Fid;          // Convert.ToInt32(up_sdr["yx_parentid"]);
                up_parentpath = listProvNext[0].ParentPath; // Convert.ToString(up_sdr["yx_parentpath"]);
                up_rootid = (int)listProvNext[0].Taxis;          // Convert.ToInt32(up_sdr["yx_rootid"]);
            }


            //下一项值
            int down_classid = 0;
            if (nextid != 0)
            {
                try
                {
                    down_classid = B_Provinces.GetListByColumn("Previd=" + ID)[0].ID;
                }
                catch (Exception ex)
                {
                    alert.showOnly(ex.ToString());
                    Response.End();
                }
            }

            //更新 下 下顶值
            if (nextid != 0)
            {
                B_Provinces.Amend(down_classid, "previd", up_classid);
            }

            //更新 上 上项
            if (up_previd != 0)
            {
                B_Provinces.Amend(up_previd, "nextid", ID);

            }

            //如果是顶级栏目则///
            if (parentid == 0)
            {
                B_Provinces.Amend(ID, "previd", up_previd);
                B_Provinces.Amend(ID, "nextid", up_classid);
                B_Provinces.Amend(ID, "Taxis", up_rootid);

                B_Provinces.Amend("Taxis=" + rootid, "Taxis", up_rootid);

                B_Provinces.Amend(up_classid, "previd", ID);
                B_Provinces.Amend(up_classid, "nextid", nextid);
                B_Provinces.Amend(up_classid, "Taxis", rootid);

                B_Provinces.Amend("Taxis=" + up_rootid + " and parentpath like '0," + up_classid + "%'", "Taxis", rootid);

                alert.showOnly("修改成功");
                Response.End();
            }

            //更新自已栏目
            B_Provinces.Amend(ID, "previd", up_previd);
            B_Provinces.Amend(ID, "nextid", up_classid);
            B_Provinces.Amend(ID, "orderid", up_orderid);


            //查出自已栏目所有的子栏目
            int sonorderid = up_orderid;
            if (child > 0)
            {
                string sonparentpath = parentpath + "," + ID;
                List<Model.Provinces> listProvChild = B_Provinces.GetListByColumn("parentpath like '" + sonparentpath + "%' and Taxis=" + rootid + " order by orderid");
                if (listProvChild.Count > 0)
                {
                    for (int i = 0; i < listProvChild.Count; i++)
                    {
                        sonorderid += 1;
                        B_Provinces.Amend(listProvChild[i].ID, "orderid", sonorderid);
                    }
                }

                //上移order值
                up_sonorderid = sonorderid + Convert.ToInt32(listProvChild.Count);
            }
            else
            {
                up_sonorderid = sonorderid + 1;
            }

            //更新上移项值
            B_Provinces.Amend(up_classid, "previd", ID);
            B_Provinces.Amend(up_classid, "nextid", nextid);
            B_Provinces.Amend(up_classid, "orderid", up_sonorderid);

            //查出上移项 栏目所有的子栏目
            if (up_child > 0)
            {
                string up_sonparentpath = up_parentpath + "," + up_classid;

                List<Model.Provinces> listProvChild = B_Provinces.GetListByColumn("parentpath like '" + up_sonparentpath + "%' and Taxis=" + up_rootid + " order by orderid");
                if (listProvChild.Count > 0)
                {
                    for (int i = 0; i < listProvChild.Count; i++)
                    {
                        up_sonorderid += 1;
                        B_Provinces.Amend(listProvChild[i].ID, "orderid", up_sonorderid);
                    }
                }
            }
            alert.showOnly("修改成功");
            Response.End();
        }*/

        void CreateAreaJs()
        {
            //if (!PowerTree.PowerPass.isPass("009006006", PowerTree.PowerPanel.PowerType.other))
            //{
            //    bp = new BasePage();
            //    bp.PageError("对不起，你没有＂生成JS＂的权限！", "../index.aspx");
            //}
            //else
            //{
                try
                {
                    string strArea = "document.write(\"" + Areas(0) + "\")";
                    YXShop.Common.FileAccessHelper.WriteTextFile(HttpContext.Current.Server.MapPath("~") + "/JS/Area.js", strArea, false, true, System.Text.Encoding.GetEncoding("GB2312"));
                    alert.showOnly("生成地区JS成功");
                }
                catch (Exception ex)
                {
                    alert.showOnly("生成地区JS失败"+ex.ToString());
                }
            //}
        }

        string Areas(int FID)
        {
            BLL.Provinces provinces = new YXShop.BLL.Provinces();
            StringBuilder sb = new StringBuilder();
            List<Model.Provinces> listProvinces = provinces.GetListByColumn(string.Format("Fid={0} Order By OrderID", FID));
            if (listProvinces.Count > 0)
            {
                for (int i = 0; i < listProvinces.Count; i++)
                {
                    if (listProvinces[i].Fid == 0)
                    {
                        sb.Append("<a target='_parent' href='" + "/" + "Cookie.aspx?ConversionCity=" + listProvinces[i].ID + "'>"
                            + "<span class=\\\"Big_City\\\">" + listProvinces[i].Province_city + "</span>"
                            + "</a><br>");
                    }
                    //else
                    //{
                    //    sb.Append("<a target='_parent' href='/Cookie.aspx?ConversionCity=" + listProvinces[i].ID + "'>"
                    //        + "<span class=\\\"Small_City\\\">" + listProvinces[i].Province_city + "</span>"
                    //        + "</a>");
                    //}

                    sb.Append(Areas(listProvinces[i].ID));
                }
            }
            return sb.ToString();
        }
    }
}