info.aspx.cs

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

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

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

public partial class info : System.Web.UI.Page
{
    DB dbobj = new DB();
    Bind bind = new Bind();
    protected void Page_Load(object sender, EventArgs e)
    {
       
        if (Request["id"] != null)
        {
            int id = Convert.ToInt32(Request["id"]);
            switch (id)
            {

                case 1:
                    {
                        bind.DLBind(dlinfo, "select top 31 id,title,type,hits,format(times,'yyyy-mm-dd') as times  from info where type='吃在大悟'order by id desc ");
                        this.title.Text = "吃在大悟" + "－－＞" + "新闻列表";

                        Page.Title = "大悟外事侨务旅游网----吃在大悟";
                        break;
                    }

                case 2:
                    {
                        bind.DLBind(dlinfo, "select top 31 id,title,type,hits,format(times,'yyyy-mm-dd') as times  from info where type='住在大悟'order by id desc ");
                        this.title.Text = "住在大悟" + "－－＞" + "新闻列表";
                        Page.Title = "大悟外事侨务旅游网----住在大悟";
                        break;
                    }
                case 3:
                    {
                        bind.DLBind(dlinfo, "select top 31 id,title,type,hits,format(times,'yyyy-mm-dd') as times  from info where type='绿色旅游' order by id desc");
                        this.title.Text = "绿色旅游" + "－－＞" + "新闻列表";
                        Page.Title = "大悟外事侨务旅游网----绿色旅游";
                        break;
                    }
                case 4:
                    {
                        bind.DLBind(dlinfo, "select  top 31 id,title,type,hits,format(times,'yyyy-mm-dd') as times   from info where type='购在大悟' order by id desc");
                        this.title.Text = "购在大悟" + "－－＞" + "新闻列表";
                        Page.Title = "大悟外事侨务旅游网----购在大悟";
                        break;
                    }
                case 5:
                    {
                        bind.DLBind(dlinfo, "select top 31 id,title,type,hits,format(times,'yyyy-mm-dd') as times  from info where type='行在大悟' order by id desc");
                        this.title.Text = "行在大悟" + "－－＞" + "新闻列表";
                        Page.Title = "大悟外事侨务旅游网----行在大悟";