info.aspx.cs

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

using System;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using BLL.Article;
using CSA.DAL;


public partial class info : System.Web.UI.Page
{
    protected string cur_Code, title, content, cur_id;
    protected DataRow drList;
    protected DataTable dtList, dtKind, dtList2;
    protected void Page_Load(object sender, EventArgs e)
    {
        BindAboutUs();
    }

    protected void BindAboutUs()
    {
        cur_Code = Request.QueryString["code"];   //接收Code
        if (string.IsNullOrEmpty(cur_Code))                //如果没有Code传进，自定义Code
        {
            cur_Code = "010401";
        }

        dtList = BLL.Article.Article.getList(cur_Code, 1);
        drList = dtList.Rows[0];
        title = drList["title"].ToString();
        content = drList["content"].ToString();
        if (cur_Code.Length == 6 && cur_Code.Remove(4, 2) == "0104")
        {
            if (Convert.ToInt16(cur_Code.Remove(0, 4)) < 06)
            {
                string sql = "select  top 5 * from bs_News where bs_newsKindCode like '0104__' order by bs_newsKindCode asc";
                dtList2 = DBAccess.getRS(sql);
            }
            else
            {
                string sql = "select * from bs_News where id not in ";
                sql += " ( select  id  from bs_news where bs_newskindcode like '0104__' order by bs_newskindcode asc limit 5)";
                sql += " and bs_newskindcode like '0104__' order by bs_newsKindcode asc limit 3";
               
                dtList2 = DBAccess.getRS(sql);
            }
        }

    }
}