Web/MasterPage.master.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using Wld.DBCore;

public partial class template_nongye_MasterPage : System.Web.UI.MasterPage
{
    public string companyname = string.Empty;
    public string address = string.Empty;
    public string fax = string.Empty;
    public string tel = string.Empty;
    public string bah = string.Empty;

    public string gzh1 = string.Empty;
    public string gzh2 = string.Empty;

    public string catagory = string.Empty;


    protected void Page_Load(object sender, EventArgs e)
    {
        DBHelperSql bll = new DBHelperSql();
        DataTable t = bll.Select("select * from webset");
        DataTable c = bll.Select("select * from catagory order by sort desc");
        if (t.Rows.Count > 0)
        {
            companyname = t.Rows[0]["Txtqymc"].ToString();
            address = t.Rows[0]["Txtaddress"].ToString();
            fax = t.Rows[0]["Txtfax"].ToString();
            tel = t.Rows[0]["Txttel"].ToString();
            bah = t.Rows[0]["TxtwebBAH"].ToString();

            gzh1 = "<img class=\"erweima\" src=" + t.Rows[0]["Txtgzh1"].ToString() + " />";
            gzh2 = "<img class=\"erweima\" src=" + t.Rows[0]["Txtgzh2"].ToString() + " />";


        }
        if (c.Rows.Count > 0)
        {
            for (int i = 0; i < c.Rows.Count; i++)
                catagory += "<li><a href=\"ListShow.aspx?type=" + c.Rows[i]["id"].ToString()+ "\">"+c.Rows[i]["catagoryName"].ToString()+"</a></li>";


        }

    }
}