index.aspx.cs

大中型酒店管理系统

using System;
using System.Data;
using System.Data.SqlClient;
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 index : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        SqlConnection conn = db.createconn();
        //这里是新闻
        SqlDataAdapter myAdapter = new SqlDataAdapter("select top 6 *  from news order by newsdate desc", conn);
        DataSet ds1 = new DataSet();
        myAdapter.Fill(ds1, "news");
        Repeaternews.DataSource = ds1;
        Repeaternews.DataMember = "news";
        Repeaternews.DataBind();
        //这里是留言
        SqlDataAdapter myAdapterl = new SqlDataAdapter("select top 6 *  from liuyan order by date1 desc", conn);
        DataSet ds2 = new DataSet();
        myAdapterl.Fill(ds2, "liuyan");
        liuyan.DataSource = ds2;
        liuyan.DataMember = "liuyan";
        liuyan.DataBind();
        //这里是厂家
       // SqlDataAdapter myAdapter2 = new SqlDataAdapter("select top 6 *  from user1 order by u_date desc", conn);
       // DataSet ds3 = new DataSet();
       // myAdapter2.Fill(ds3, "user");
       //shop.DataSource = ds3;
       // shop.DataMember = "user";
       // shop.DataBind();
        //这里是友情链接
        SqlDataAdapter myAdapter3 = new SqlDataAdapter("select top 6 *  from links order by id desc", conn);
        DataSet ds4 = new DataSet();
        myAdapter3.Fill(ds4, "links");
        links.DataSource = ds4;
        links.DataMember = "links";
        links.DataBind();
        conn.Open();
        SqlCommand cmd = new SqlCommand("select * from company",conn);
        SqlDataReader dr = cmd.ExecuteReader();
        if (dr.Read())
        {
            string chr = dr["content"].ToString().Trim();//add by 51aspx
            if (dr["content"].ToString().Trim().Length > 120)
            {
                chr = dr["content"].ToString().Trim().Substring(0, 120);
            }


            lblcontent.Text = "        " + chr + "......";
        }
    }
}