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;

public?partial?class?_Default?:?System.Web.UI.Page
{
????public?string?sqlncontent;
????public?string?npicsnlinksntexts;
????protected?void?Page_Load（object?sender?EventArgs?e）
????{
????????if?（!IsPostBack）
????????{
????????????sql?=?“select?top?5?idtitleshouyetupian?from?allgonggao?where?shouyetupian<>‘‘?order?by?id?desc“;
????????????getsyt（sql）;
????????????sql?=?“select?top?8?idtitleaddtimeleibie?from?allgonggao?where?leibie=‘我的微博‘?order?by?id?desc“;
????????????getdata（sql）;
????????????sql?=?“select?top?5?*?from?wodetupian???order?by?id?desc“;
????????????getdata2（sql）;
????????????sql?=?“select?content?from?dx?where?leibie=‘系統簡介‘“;
????????????getdataxtjj（sql）;
????????????//sql?=?“select?top?5?*?from?allgonggao??where?leibie=‘簽證告知‘?order?by?id?desc“;
????????????//getdata2（sql）;
????????????//sql?=?“select?top?5?*?from?kaoshizhidao???order?by?id?desc“;
????????????//getdata3（sql）;
????????????//sql?=?“select?top?5?*?from?shangpinxinxi?where?tupian<>‘‘???order?by?id?desc“;
????????????//getdata4（sql）;
????????}
????}
????private?void?getdataxtjj（string?sql）
????{
????????DataSet?result?=?new?DataSet（）;
????????result?=?new?Class1（）.hsggetdata（sql）;
????????if?（result?!=?null）
????????{
????????????if?（result.Tables[0].Rows.Count?>?0）
????????????{
????????????????ncontent?=?result.Tables[0].Rows[0][0].ToString（）.Trim（）;
????????????}
????????}
????}
????private?void?getdata（string?sql）
????{
????????DataSet?result?=?new?DataSet（）;
????????result?=?new?Class1（）.hsggetdata（sql）;
????????if?（result?!=?null）
????????{
????????????if?（result.Tables[0].Rows.Count?>?0）
????????????{
????????????????DataGrid1.DataSource?=?result.Tables[0];
????????????????DataGrid1.DataBind（）;
????????????}
????????????else
????????????{
????????????????DataGrid1.DataSource?=?null;
????????????????DataGrid1.DataBind（）;
????????????}
????????}
????}
????private?void?getdata2（string?sql）
????{
????????DataSet?result?=?new?DataSet（）;
????????result?=?new?Class1（）.hsggetdata（sql）;
????????if?（result?!=?null）
????????{
????????????if?（result.Tables[0].Rows.Count?>?0）
????????????{
????????????????DataList1.DataSource?=?result.Tables[0];
????????????????DataList1.DataBind（）;
????????????}
????????????else
????????????{
????????????????DataList1.DataSource?=?null;
????????????????DataList1.DataBind（）;
????????????}
????????}
????}
????private?void?getsyt（string?sql）
????{
????????DataSet?result?=?new?DataSet（）;
????????result?=?new?Class1（）.hsggetdata（sql）;
????????if?（result?!=?null）
????????{
????????????if?（result.Tables[0].Rows.Count?>?0）
????????????{
????????????????int?i=0;
????????????????for（i=0;i