index.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

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

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

public partial class index : System.Web.UI.Page
{
    public string notice = "";
    public string Introduction = "";
    protected void Page_Load(object sender, EventArgs e)
    {
        if (IsPostBack)
            return;
        note();
        Intro();
        GetNewsList();
        GetKnowledge();
        Information();
    }
    #region 数据绑定
    #region 公告
    private void note()
    {
        string sqlNot = "select notice from KY_announcement where isUse=1 order by date desc";
        DataTable dt = KYSql.ExecuteQuery(sqlNot);
        if (dt.Rows.Count > 0)
        {
            notice = dt.Rows[0]["notice"].ToString();
        }
        else
        {
            notice = "目前没有公告信息...";
        }
    } 
    #endregion

    #region 关于我们
    private void Intro()
    {
        string sqlNot = "select * from KY_Article where typeID=21 and isUse=1 order by datetime desc";
        DataTable dtt = KYSql.ExecuteQuery(sqlNot);
        Introduction = Server.HtmlDecode(dtt.Rows[0]["contents"].ToString());

    } 
    #endregion

    #region 新闻动态
    private void GetNewsList()
    {
        string SQL = "select top 7 * from KY_Article Where typeID = 11 and isUse=1 ORDER BY id DESC ";
        dlInform.DataSource = KYSql.ExecuteQuery(SQL);
        dlInform.DataBind();
    } 
    #endregion

    #region 行业知识
    private void GetKnowledge()