yx_cms.txt

易想系统的功能类

                str += "<a href='?startnum=" + (pernum * (pagernum1 - 1)) + "&" + Wname + "=" + ClassId + "&ActionShow=" + ActionShow + "'>尾页</a>&nbsp;&nbsp;";
            }
            else
            {

                str += "下一页&nbsp;&nbsp;";

            }
            str += "跳至<select name=startnum size=1 onchange=gono(this.options[this.options.selectedIndex].value);>";
            for (int i = 1; i <= pagernum1; i++)
            {
                str += "<option ";
                if (i == curpage)
                {
                    str += "  selected ";
                }
                str += "value=" + (pernum * i - pernum) + ">第" + i + "页</option>";
            }
            str += "</select>\n";
            str += "</td></tr>\n";
            return str;
        }
        #endregion

        #region 暂时无用 带分页{#Hope_PagePro*行数,列数,标题显示字数,状态1,参数名称#} 
        /// <summary>
        /// 商品列表页,带分页
        /// </summary>
        /// <param name="row">显示的行数</param>
        /// <param name="col">显示的列数</param>
        /// <param name="tnum">标题显示的字数</param>
        /// <param name="start">显示商品的状态 1推荐 2特价 3热卖</param>
        /// <param name="wh">参数名称 如:网址?classid=5 那classid就为参数名称</param>
        /// <param name="width">显示商品图片的宽度</param>
        /// <param name="height">显示商品图片的高度</param>
        /// <param name="s1">是否显示商品称 等于1表示显示</param>
        /// <param name="s3">是否显示商品市场价 等于1表示显示</param>
        /// <param name="s5">是否显示商品商城价 等于1表示显示</param>
        /// <param name="s7">是否显示折扣 等于1表示显示</param>
        /// <param name="display">是否显示购卖按钮 等于true表示显示</param>
        /// <param name="kz1">扩展字段ID序列号1 一共有10个</param>
        /// <param name="kz2">扩展字段ID序列号2 一共有10个</param>
        /// <param name="kz3">扩展字段ID序列号3 一共有10个</param>
        /// <param name="diskz">是否显示扩展字段 扩展字段可以参照发布商品</param>
        /// <returns></returns>
        public string Hope_PagePro(int row, int col, int tnum, int start, string wh, int width, int height, int s1, int s3, int s5, int s7, bool display, string kz1, string kz2, string kz3, bool diskz)
        {
            if (Convert.ToInt16(kz1) > 10 || Convert.ToInt16(kz1) < 1)
            {
                kz1 = "1";
            }
            if (Convert.ToInt16(kz2) > 10 || Convert.ToInt16(kz2) < 1)
            {
                kz2 = "1";
            }
            if (Convert.ToInt16(kz3) > 10 || Convert.ToInt16(kz3) < 1)
            {
                kz3 = "1";
            }
            string strid = "";
            //查询具体的类别的商品的传递参数：
            int classId = 0;
            if (HttpContext.Current.Request.QueryString["ClassId"] == null || HttpContext.Current.Request.QueryString["ClassId"] == "")
            {

                classId = 0;
            }
            else
            {
                if (RteNum(HttpContext.Current.Request.QueryString["ClassId"].ToString()))
                {

                    classId = Convert.ToInt32(HttpContext.Current.Request.QueryString["ClassId"].ToString());
                    strid = YX_ParentPath(classId);
                }
                else
                {

                    Show_Msg("非法操作！");
                }

            }
            int startnum = 0;
            if (HttpContext.Current.Request.QueryString["startnum"] != null)
            {
                if (RteNum(HttpContext.Current.Request["startnum"].ToString()))
                {
                    startnum = Convert.ToInt32(HttpContext.Current.Request.QueryString["startnum"].ToString());
                }
                else
                {
                    Show_Msg("非法操作！");
                }
            } 
            //初始化分页参数1(从记录中开始取数据的位置)
            int pernum = col * row;
            Exsql.Open();
            string sql = "";
            StringBuilder Sbuilder = new StringBuilder();
            Sbuilder.Append(@"<TABLE cellSpacing=0 cellPadding=0 width='98%' border='0' style='b' class='tab01'> <TBODY> <TR> ");
            if (classId == 0)
            {
                sql = "select * from YX_Product where YX_Veri=1 ";
            }
            else
            {
                sql = "select * from YX_Product where YX_Veri=1 and YX_Class in (" + strid + ")";
            }
            int order = 0;
            if (HttpContext.Current.Request["order"] == null)
            {

                order = start;
            }
            else
            {
                if (RteNum(HttpContext.Current.Request["order"]))
                {
                    order = Convert.ToInt16(HttpContext.Current.Request["order"]);
                }
                else
                {
                    order = 0;
                }
            }
            switch (order)
            {
                case 0:
                    break;
                case 1:
                    sql = sql + " and YX_Tj=1";
                    break;
                case 2:
                    sql = sql + " and YX_TPrice=1";
                    break;
                case 3:
                    sql = sql + " and YX_Sm=1";
                    break;                    
            }
            sql = sql + " order by YX_Addtime desc,YX_ID desc";
            DataSet ds = new DataSet();
            SqlDataAdapter da = new SqlDataAdapter(sql, Exsql.con);
            da.Fill(ds, startnum, pernum, "table");
            int i = 1;
            foreach (DataRow dr in ds.Tables["table"].Rows)
            {
                Sbuilder.Append(@" <TD align=center><TABLE cellSpacing=0  border=0 align=center>");
                Sbuilder.Append(@"  <TR>  <TD align=center> <a href='ShowProduct.aspx?YX_MID=" + dr["YX_ID"].ToString() + "'>");
                Sbuilder.Append(@" <IMG height='" + height.ToString() + "' src='" + dr["YX_Spic"].ToString() + "' alt='" + dr["YX_Spic"].ToString() + "' width='" + width.ToString() + "' border=0></a>");
                Sbuilder.Append(@"</TD></TR>");
                if (s1 == 1)
                {
                    Sbuilder.Append(@" <TR> <TD align=center><a href='ShowProduct.aspx?YX_MID=" + dr["YX_ID"].ToString() + "' target=_blank>" + newstr(dr["YX_ProductName"].ToString(), tnum) + "</a>\n </TD></TR> ");
                }
                if (s3 == 1)
                {
                    Sbuilder.Append(@"<TR><TD class='DZ' align=center> &nbsp;市价:" + C1Round(Convert.ToDouble(dr["YX_ProPrice"].ToString()), 1) + dr["YX_ProDw"].ToString() + "</TD></TR>");
                }
                if (s5 == 1)
                {
                    Sbuilder.Append(@"<TR><TD align=center>&nbsp;商城价:" + C1Round(propic(DZ(dr["YX_ProDZ"].ToString()), Convert.ToDouble(dr["YX_ProPrice"])), 1) + dr["YX_ProDw"].ToString() + " </TD></TR>");
                    //计算会员打折价格
                    if (HttpContext.Current.Session["userrank"] != null)
                    {
                        Sbuilder.Append(MemberPrice(dr["YX_ProPrice"].ToString(), dr["YX_ProDw"].ToString(), dr["YX_ProDZ"].ToString()));
                    }
                }
                if (diskz == true)
                {
                    if (dr["zdname" + kz1].ToString() != "" && dr["zdvalue" + kz1].ToString() != "")
                    {
                        Sbuilder.Append(@"<TR><TD align=center>&nbsp;" + dr["zdname" + kz1].ToString() + ":" +
                            dr["zdvalue" + kz1].ToString() + "</TD></TR>");
                    }
                    if (dr["zdname" + kz2].ToString() != "" && dr["zdvalue" + kz2].ToString() != "")
                    {
                        Sbuilder.Append(@"<TR><TD align=center>&nbsp;" + dr["zdname" + kz2].ToString() + ":" +
                            dr["zdvalue" + kz2].ToString() + "</TD></TR>");
                    }
                    if (dr["zdname" + kz3].ToString() != "" && dr["zdvalue" + kz3].ToString() != "")
                    {
                        Sbuilder.Append(@"<TR><TD align=center>&nbsp;" + dr["zdname" + kz3].ToString() + ":" +
                            dr["zdvalue" + kz3].ToString() + "</TD></TR>");
                    }
                }
                if (s7 == 1)
                {
                    Sbuilder.Append(@"<TR><TD align=center>&nbsp;打折:" + DZ(dr["YX_ProDZ"].ToString()) + "折</TD></TR>");
                }
                if (display == true)
                {
                    Sbuilder.Append(@"<TR><TD align=center>&nbsp;<a href=Basket.aspx?YX_ID=" + dr["YX_ID"].ToString() + "><IMG height=19 src='{$Hope_SitUrl$}{$Hope_Skin$}images/buy_1.gif' width=32 border=0></a> <a href=ShowProduct.aspx?YX_MID=" + dr["YX_ID"].ToString() + "> <IMG height=19 src='{$Hope_SitUrl$}{$Hope_Skin$}images/buy_2.gif' width=32 border=0> </a><span onclick=\"javascript:add('" + dr["YX_Class"].ToString() + "','" + dr["YX_ID"].ToString() + "','" + dr["YX_ProductName"].ToString() + "');\" style='cursor:hand'> <IMG height=19 src='{$Hope_SitUrl$}{$Hope_Skin$}images/buy_3.gif' width=32 border=0> </span></TD></TR>");
                }
                Sbuilder.Append(@" </TABLE></TD>");
                if (i % col == 0)
                {
                    Sbuilder.Append("<TR>");
                }
                i++;
            }
            Sbuilder.Append(@"</TBODY></TABLE>");
            if (i == 1)
            { Sbuilder.Append("<br><font color=red>无相关产品！</font>&nbsp;&nbsp;<a href='#' onclick='javascript:history.back(-1)'>返回 </a><br>"); }
            int Pnum = 0;
            //取得数据库中的总记录
            string sqlnum = "select Count(*) from YX_Product";
            if (classId == 0)
            {
                sqlnum = "select Count(*) from YX_Product where YX_Veri=1 ";
            }
            else
            {
                sqlnum = "select Count(*) from YX_Product where YX_Veri=1 and YX_Class in (" + strid + ")";
            }
            switch (order)
            {
                case 0:
                    sqlnum = sqlnum;
                    break;
                case 1:
                    sqlnum = sqlnum + " and YX_Tj=1";
                    break;
                case 2:
                    sqlnum = sqlnum + " and YX_TPrice=1";
                    break;
                case 3:
                    sqlnum = sqlnum + " and YX_Sm=1";
                    break;
            }
            SqlCommand com = new SqlCommand(sqlnum, Exsql.con);
            Pnum = Convert.ToInt32(com.ExecuteScalar());
            if (startnum > Pnum - 1)
            {
                startnum = Pnum - pernum - 1;                          //处理超出总记录数
            }
            if (startnum - pernum < 0)                                //处理记录不足
            {
                startnum = 0;
            }
            if (i != 1)
            {
               Sbuilder.Append("<Table>"+Pager(startnum, Pnum, pernum, wh, "order")+"</Table>");
            }
            Exsql.Close();
            return Sbuilder.ToString();
        }
        #endregion 

        #region 商品横排显示，带分页{#Hope_PagePro_List*行数，标题显示字数，状态，参数名称,网站内容子数,标题样式,内容样式，是否显示分页}
        /// <summary>
        ///  商品横排显示，带分页
        /// </summary>
        /// <param name="row">每页显示的条数</param>
        /// <param name="Tnum">商品标题显示的字数</param>
        /// <param name="start">商品状态 1推荐 2特价 3热卖</param>
        /// <param name="Par">参数名称</param>