link.ascx.cs

内容管理 内容管理 内容管理 内容管理 内容管理

using System;
using System.Data;
using System.Configuration;
using System.Collections;
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;

public partial class WebUserControl_Link : System.Web.UI.UserControl
{

     /// <summary>
    /// 参数数组。如果参数为空，就把strURl直接赋给链接．
    /// </summary>
    public bool boolAddDate;

    /// <summary>
    /// 参数数组。如果参数为空，就把strURl直接赋给链接．
    /// </summary>
    public ArrayList arrayParam = new ArrayList();

    /// <summary>
    /// "webform2.aspx" '跳转地址(总的跳转页)
    /// </summary>
    public string strURL;

    /// <summary>
    /// 标题显示长度
    /// </summary>
    public int strLen = 20;

    /// <summary>
    /// 每页显示多少行记录！
    /// </summary>
    public int MyPageSize;

    /// <summary>
    /// 查看内容表的sql,用来传递给readNews组件查看具体内容用的sql语句
    /// </summary>
    public string ChildSQL;

    /// <summary>
    /// 查看更多跳转路径
    /// </summary>
    public string morePath = "#";

    /// <summary>
    /// 网站虚拟目录
    /// </summary>
    private string Vritual_Path;

    public string VritualPath
    {
        set
        {
            Vritual_Path = value;

        }
        get
        {
            return Vritual_Path;
        }
    }
    

    protected void Page_Load(object sender, EventArgs e)
    {
        try
        {
            if (!IsPostBack)
            {              
                GetNewMessage();               
            }
        }
        catch (System.Exception ex)
        {
            throw ex;
        }
    }




    private void GetNewMessage()
    {
        DataSet ds = new DataSet();
        DAL.boBusiness bo = new DAL.boBusiness();
        DAL.MakeConnection Conn = new DAL.MakeConnection();
        DAL.clsDBConnkey ConnKey = new DAL.clsDBConnkey();
        ConnKey = bo.loadkey();//得到config数据库连接


        string sql = "select * from Link  order by  ReleaseTime desc";
        ds = (DataSet)Conn.MakeConnectionMethod(sql, ConnKey, DAL.executeMethod.execute_DataSet, DAL.
       EnumDBType.Sql, VritualPath);
        if (ds.Tables[0].Rows.Count > 0)
        {
            DataTable dt = ds.Tables[0];
            string html = makeHtml2(dt);
            this.lab.InnerHtml = html;
        }
            
    }


      #region "友情连接"
      /// <summary>
      /// 
      /// </summary>
      /// <param name="row"></param>
      /// <param name="arrayParam"></param>
      /// <param name="strlen"></param>
      /// <param name="strUrl">总的跳转</param>
      /// <returns></returns>
      private string makeHtml2(DataTable dt)
      {
          string HTML = "";
          HTML += "<TABLE id='Table1' width='100%' style='FONT-SIZE: 10pt' cellSpacing='2' cellPadding='2'  border='0' >\r\n";
          //HTML+="<TR  border='0'>\r\n";
          //HTML+="<TD width='7px' height='10'></TD>\r\n";
          //HTML+="<TD ></TD>\r\n";
          HTML += "</TR>\r\n";

          string Title = "", AllTitle = "";
          for (int i = 0; i < dt.Rows.Count; i++)
          {
              Title = ""; AllTitle = "";
              AllTitle = dt.Rows[i]["LinkTitle"].ToString();
              Title += (i + 1) + ".";
              if (AllTitle.Length > 10)
              {             
                  Title += AllTitle.Substring(0, 8);
                  Title += "..";               
              }
              else
              {
                  Title += AllTitle;
              }

              string ahref1 = "";

              ahref1 = "a href= ";
              ahref1 += dt.Rows[i]["LinkUrl"].ToString();

              HTML += "<TR  border='1' >\r\n";
              HTML += "<TD width='2px' height=24></TD>\r\n";
              HTML += "<TD width='100px' Title='" + AllTitle + "'><" + ahref1 + ">" + Title + "</a></TD>\r\n";
              HTML += "</TR>\r\n";

          }
          HTML += "<TR  border='0'>\r\n";
          HTML += "<TD width='2px' height=24></TD>\r\n";
          HTML += "<TD width='100px'Title='更多留言...' align='right'></TD>\r\n";
          HTML += "</TR>\r\n";
          HTML += "</TABLE>";

          return HTML;
      }
      #endregion



}