yx_cms.txt

易想系统的功能类

using System;
using System.Collections.Generic;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Text;
using System.Text.RegularExpressions;
using System.IO;
using System.Collections;
using System.Drawing;
using ChangHope.InterfaseHtml;
using System.Net.Mail;
using System.Net;
using System.Web.Util;
using System.Data.OleDb;
using CHP.Pages;
namespace ChangeHope
{
    public class ChangeHope_CMS : IHtmlTag
    {
        YX_sql Exsql = new YX_sql();
        public string Hope_Title, Hope_Email,Hope_Open, Hope_SitUrl, Hope_KeysWord, Hope_SiteExc, Hope_Post, Hope_Tel, Hope_Addr, Hope_Code, Hope_Moble, Hope_Copyright, Hope_OpenExc;
        private int ClassID = 0, sitopen = 0;
        public int bbsopen = 0;
        #region 构造函数
        public ChangeHope_CMS()
        {
            Exsql.Open();
            string sql = "select YX_WebName,YX_WebUrl,YX_Key,YX_Ex,YX_Post,YX_Tel,YX_Addr,YX_Email,YX_Fac,YX_Moble,YX_Copy,YX_Open,YX_Open_Exc,yx_bbsopen from YX_WebInfo";
            SqlDataReader dr = Exsql.Re_dr(sql);
            try
            {
                if (dr.Read())
                {
                    this.Hope_Title = dr["YX_WebName"].ToString();
                    this.Hope_SitUrl = dr["YX_WebUrl"].ToString();
                    this.Hope_KeysWord = dr["YX_Key"].ToString();
                    this.Hope_SiteExc = dr["YX_Ex"].ToString();
                    this.Hope_Post = dr["YX_Post"].ToString();
                    this.Hope_Tel = dr["YX_Tel"].ToString();
                    this.Hope_Addr = dr["YX_Addr"].ToString();
                    this.Hope_Email = dr["YX_Email"].ToString();
                    this.Hope_Code = dr["YX_Fac"].ToString();
                    this.Hope_Moble = dr["YX_Moble"].ToString();
                    this.Hope_Copyright = dr["YX_Copy"].ToString();
                    this.sitopen = Convert.ToInt16(dr["YX_Open"]);
                    this.Hope_OpenExc = dr["YX_Open_Exc"].ToString();
                    this.bbsopen = Convert.ToInt16(dr["yx_bbsopen"]);
                }               
            }
            catch
            {

            }
            finally
            {
                dr.Close();
                Exsql.Close();                
            }          
        }
        #endregion        

        /// <summary>
        /// 通过Classid找到该类别下的分类,此方法不能当标签使用 
        /// </summary>
        /// <param name="YX_ID"></param>
        /// <returns></returns>
        public string YX_ParentPath(int YX_ID)
        {
            string strpath = "", strid = "";
            int child = 0;
            Exsql.Open();
            SqlDataReader dr = Exsql.Re_dr("select YX_ParentPath,YX_Child from YX_ProductClass where YX_ID=" + YX_ID);
            if (dr.Read())
            {
                strpath = dr["YX_ParentPath"].ToString() + "," + YX_ID.ToString();
                child = Convert.ToInt16(dr["YX_Child"]);
            }
            dr.Close();
            if (child != 0)
            {
                SqlDataReader dr1 = Exsql.Re_dr("select YX_ID from YX_ProductClass where ','+YX_ParentPath+',' like '," + strpath + ",%'");
                while (dr1.Read())
                {
                    strid += dr1["YX_ID"].ToString() + ",";
                }
                if (strid != "")
                {
                    //去掉点最后的","
                    int wz = strid.Length - 1;
                    strid = strid.Substring(0, wz);
                }
                dr1.Close();
                Exsql.Close();
            }
            else
            {
                strid = YX_ID.ToString();
            }
            return strid;
        }

        #region 促销
        public string Shop_ChuXiao()
        {
            StringBuilder html = new StringBuilder();
            html.Append("<table width='100%' border='0' cellspacing='0' cellpadding='0'>");
            html.Append("<tr>");
            html.Append("<td>");
            html.Append("<table width='25%' border='0' cellspacing='0' cellpadding='0' style='font-family:宋体; font-size:12px'>");
            html.Append("<tr>");
            html.Append("<td>&nbsp;</td>");
            html.Append("</tr>");
            html.Append("<tr>");
            html.Append("<td>&nbsp;</td>");
            html.Append("</tr>");
            html.Append("</table>");
            html.Append("</td>");
            html.Append("</tr>");
            html.Append("</table>");
            return html.ToString();
        }
        #endregion 

        #region 通过ID找出对应的分类名称
        public string RetParent_Name(int ClassID)
        {
            Exsql.Open();
            string retname = "";
            string sql = "Select YX_ClassName from YX_ProductClass where YX_ID=" + ClassID;
            SqlCommand com = new SqlCommand(sql, Exsql.con);
            SqlDataReader dr = com.ExecuteReader(CommandBehavior.CloseConnection);
            if (dr.Read())
            {
                retname = dr[0].ToString();
            }
            dr.Close();
            Exsql.Close();
            return retname;
        }
        #endregion

        #region 首页搜索关键字
        /// <summary>
        /// 首页搜索关键字
        /// </summary>
        /// <param name="order">显示顺序：1表示将用户自然搜索的结果显示在前面，其他表示将后台管理员录入的结果显示在前面</param>
        /// <param name="zr">用户自然搜索的热门关键词显示个数</param>
        /// <param name="ht">后台管理员添加的关键词的显示个数</param>
        /// <param name="Tstyle">标题样式</param>
        /// <returns></returns>
        public static string YX_SearchKeyWord(int order, int zr, int ht,string Tstyle)
        {           
            YX_sql EXSQL = new YX_sql();
            ChangeHope_CMS cms = new ChangeHope_CMS();
            string selectzr = "select top " + zr + " K_Content from YX_SearchKeyWord where k_type='自然搜索' order by K_Num desc,K_Order";
            string selectht = "select top " + ht + " K_Content from YX_SearchKeyWord where k_type='后台添加' order by K_Num desc,K_Order";
            StringBuilder html = new StringBuilder();//自然搜索的关键字            
            //查询自然搜索的关键字
            SqlDataReader sdr = EXSQL.Re_dr(selectzr); 
            while (sdr.Read())
            {
                html.Append("<a href='" + cms.Hope_SitUrl + "Productlist_1.aspx?SearchKind=1&SearchText=" + sdr["K_Content"].ToString() + "' class=" + Tstyle + " target=_blank>" + newstr(sdr["K_Content"].ToString(), 10) + "</a>&nbsp;&nbsp;");
            }
            sdr.Close();
            sdr.Dispose();
            StringBuilder html2 = new StringBuilder();//后台管理员添加的关键字
            //查询后台管理员添加的关键字
            SqlDataReader sdr2 = EXSQL.Re_dr(selectht); 
            while (sdr2.Read())
            {
                html2.Append("<a href='"+cms.Hope_SitUrl+"Productlist_1.aspx?SearchKind=1&SearchText=" + sdr2["K_Content"].ToString() + "' class=" + Tstyle + " target=_blank>" + newstr(sdr2["K_Content"].ToString(),10) + "</a>&nbsp;&nbsp;");
            }
            sdr2.Close();
            sdr2.Dispose();
            if (order == 1)
            {
                return html.ToString() + html2.ToString();
            }
            else
            {
                return html2.ToString() + html.ToString();
            }
        }
        #endregion

        #region 商品品牌列表{#Hope_BrandList*每行显示多少个商品品牌，每个商品品牌名字的显示字数}
        /// <summary>
        /// 商品品牌列表
        /// </summary>
        /// <param name="col">每行显示多少个商品品牌，建议为1或2</param>
        /// <param name="ZiShu">每个商品品牌名字的显示字数，建议为5</param>
        /// <returns></returns>
        public string Hope_BrandList(int col, int ZiShu)
        {
            StringBuilder html = new StringBuilder();
            html.Append("<table width=\"100%\" border=\"0\"><tr>");
            int i = 0;
            Exsql.Open();
            string sql = "select YX_ID,YX_PinPaiName  from yx_pinpai";
            SqlDataReader sdr = Exsql.Re_dr(sql); 
            while (sdr.Read())
            {
                if (sdr["YX_PinPaiName"].ToString().Length > ZiShu)
                {
                    html.Append("<td><li><a href='BrandArea.aspx?&YX_PinPaiName=" + sdr["YX_ID"].ToString() + "'>" + sdr["YX_PinPaiName"].ToString().Substring(0, ZiShu) + "</a>&nbsp;</td>");
                }
                else
                {
                    html.Append("<td><li><a href='BrandArea.aspx?&YX_PinPaiName=" + sdr["YX_ID"].ToString() + "'>" + sdr["YX_PinPaiName"].ToString() + "</a>&nbsp;</td>");
                }
                i += 1;
                if (i % col == 0)
                {
                    html.Append("</tr><tr>");
                }
            }
            html.Append("</tr></table>");
            sdr.Close();
            sdr.Dispose();
            Exsql.Close();
            Exsql.Dispose();
            return html.ToString();
        }
        #endregion

        #region  厂商列表{#Hope_BrandList*每行显示多少个 厂商，每个 厂商名字的显示字数}
        /// <summary>
        ///  厂商列表
        /// </summary>
        /// <param name="col">每行显示多少个商品厂商，建议为1或2</param>
        /// <param name="ZiShu">每个厂商名字的显示字数，建议为5</param>
        /// <returns></returns>
        public string Hope_ChanShang(int col, int ZiShu)
        {
            string[] ChangShangFL = new string[] { "大陆厂商", "港台厂商", "日韩厂商", "欧美厂商", "其他厂商" };
            Exsql.Open();
            StringBuilder html = new StringBuilder();
            for (int j = 0; j < ChangShangFL.Length; j++)
            {
                html.Append("<table width=\"100%\" border=\"0\"><tr><td colspan=" + col + "><b><a href=BrandArea.aspx?chanshangfl=" + ChangShangFL[j] + ">" + ChangShangFL[j] + "</a></b></tr><tr>");
                int i = 0;                
                string sql = "select yx_id,yx_csname from YX_ChanShang where yx_csfenlei='" + ChangShangFL[j]+ "'";
                SqlDataReader sdr = Exsql.Re_dr(sql);
                while (sdr.Read())
                {
                    html.Append("<td><li><a href='BrandArea.aspx?chanshangid=" + sdr["YX_ID"].ToString() + "'>" + ChangeHope_CMS.newstr(sdr["yx_csname"].ToString(), ZiShu) + "</a>&nbsp;</td>");
                    i += 1;
                    if (i % col == 0)
                    {