blogimage.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_BlogImage : System.Web.UI.UserControl
{
    public int lenWord = 0, meWidth = 0;
    public string sql = "", Param = "", NewTitle = "", VirtualPath = "";//, strUrl = "";

    protected void Page_Load(object sender, EventArgs e)
    {
        string strReader2 = "";
        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数据库连接


        sql = "select Top 1 * from PhotoAlbum where IsAffiche=1 and IsNominate=1 order by CreateTime desc ";

        ds = (DataSet)Conn.MakeConnectionMethod(sql, ConnKey, DAL.executeMethod.execute_DataSet, DAL.
                 EnumDBType.Sql, VirtualPath);
        DataTable dt = ds.Tables[0];
        if (dt.Rows.Count > 0)
        {
            if (dt.Rows[0]["PhotoUrl"] != System.DBNull.Value)
            {
                strReader2 = dt.Rows[0]["PhotoUrl"].ToString();
            }
            else
            {
                strReader2 = "";
            }

            //照片说明
            if (dt.Rows[0]["PhotoExplain"] != System.DBNull.Value)
            {
                if (dt.Rows[0]["PhotoExplain"].ToString().Length > 26)
                {
                    NewTitle = dt.Rows[0]["PhotoExplain"].ToString().Substring(0, 26) + "...";
                }
                else
                {
                    NewTitle = dt.Rows[0]["PhotoExplain"].ToString();
                }
            }
            else
            {
                NewTitle = "";
            }
            if (meWidth == 0)
            {
                meWidth = 156;
            }

            this.Label1.Width = Unit.Pixel(meWidth);
            this.Label1.Text = seachHtml(strReader2);
        }
    }


    private string seachHtml(string strHtml)
    {

        string strHtml2 = "";

        //调整图片宽度
        //----------------------------------------------------------
        if (strHtml != "")
        {

            string imgUrl = DeleteSymbol(strHtml);   //删除图片路径中的引号。
            if (imgUrl.LastIndexOf("\\") == imgUrl.Length - 1)
            {
                imgUrl = imgUrl.Substring(0, imgUrl.Length - 2);
            }
            string AppPath =  System.Web.HttpContext.Current.Request.PhysicalApplicationPath;
            imgUrl = imgUrl.Replace("..", "");
            string TestImgUrl = AppPath.Substring(0, AppPath.Length - 1) + imgUrl;
            TestImgUrl = TestImgUrl.Replace("/", "\\");
            if (System.IO.File.Exists(TestImgUrl))
            {
                strHtml2 += "src=" + TestImgUrl;

            }
            else
            {
                //如果图片不存在使用默认图片。
                strHtml2 += "src=image/DefaultNews.jpg";
            }



            //'这里是控制图片大小的地方！
            strHtml2 = strHtml2.Replace(">", "");
            strHtml2 = "<img " + strHtml2;
            strHtml2 += " width=146 height=180 align=Center >";
          
        }
        else
        {
            strHtml2 = "<img src=\"/image/DefaultNews.jpg\" width=146 height=180 align=left >";
        }


        string strHtml3 = "";
        strHtml3 += "<table border=0 cellpadding=0 cellspacing=0 align=center width=154>";
        strHtml3 += "<tr><td height=153 align=center>";
        strHtml3 += "<table border=0 cellpadding=3 cellspacing=0 class=newspic>";
        //新闻图片在这里
        strHtml3 += "<tr><td>" + strHtml2 + "</a></td>";
        strHtml3 += "</tr></table></td></tr><tr>";
        //新闻标题在这里
        strHtml3 += "<td height=50 align=center valign=top>" + NewTitle + "</td>";
        strHtml3 += "</tr></table>";

        return strHtml3;
    }



    //删除图片路径中的引号。
    private string DeleteSymbol(string imgUrl)
    {
        imgUrl = imgUrl.Replace("<", "");
        imgUrl = imgUrl.Replace(">", "");
        if (imgUrl.IndexOf("\"") == 0)  //去掉第一个”
        {
            imgUrl = imgUrl.Substring(1);
        }
        if (imgUrl.LastIndexOf("\"") == imgUrl.Length - 1)  //去掉最后一个”
        {
            imgUrl = imgUrl.Substring(0, imgUrl.Length - 1);
        }

        return imgUrl.Trim();
    }



}