1using System;
  2using System.Data;
  3using System.Configuration;
  4using System.Collections;
  5using System.Web;
  6using System.Web.Security;
  7using System.Web.UI;
  8using System.Web.UI.WebControls;
  9using System.Web.UI.WebControls.WebParts;
 10using System.Web.UI.HtmlControls;
 11
 12public partial class admin_webhww_showall : System.Web.UI.Page
 13...{
 14
 15    public string _webhww_hybh0 = "";
 16    public string _webhww_hybh1 = "";
 17    public string _webhww_hybh2 = "";
 18    public string _webhww_hybh3 = "";
 19    public string _webhww_hybh4 = "";
 20    public string _webhww_hybh5 = "";
 21    protected void Page_Load(object sender, EventArgs e)
 22    ...{
 23        if (!IsPostBack)
 24        ...{ bind(); }
 25    }
 26    public void bind()
 27    ...{
 28        string sql = "";
 29        if (Request.QueryString["hid"] != null)
 30        ...{
 31            sql = "select top 1 * from webhww_hy where webhww_hybh='" + Request.QueryString["hid"] + "'";
 32        }
 33        else
 34        ...{
 35            sql = "select top 1 * from webhww_hy where webhww_hybh='0'";
 36
 37        }
 38        DataTable dt1 = new DataTable();
 39        dt1 = access.GreatDs(sql).Tables[0];
 40        Label1.Text = dt1.Rows[0]["webhww_hyxm"].ToString();
 41        Label2.Text = dt1.Rows[0]["webhww_jrsj"].ToString();
 42
 43        string sql2 = "select * from webhww_hy where webhww_tjrbh='" + dt1.Rows[0]["webhww_hybh"].ToString() + "'";
 44        DataTable dt = new DataTable();
 45        dt = access.GreatDs(sql2).Tables[0];
 46        DataRow[] dr0 = dt.Select("webhww_hywz=0");
 47        if (dr0.Length > 0)
 48        ...{
 49            Label3.Text = dr0[0]["webhww_hyxm"].ToString();
 50            Label4.Text = dr0[0]["webhww_jrsj"].ToString();
 51            _webhww_hybh0 ="?hid="+dr0[0]["webhww_hybh"].ToString();
 52        }
 53        else
 54        ...{
 55            Label3.Text = "注册";
 56            Label4.Text = "注册";
 57            _webhww_hybh0 = "../webhww_register.aspx";
 58
 59        }
 60
 61        DataRow[] dr1 = dt.Select("webhww_hywz=1");
 62        if (dr1.Length > 0)
 63        ...{
 64            Label5.Text = dr1[0]["webhww_hyxm"].ToString();
 65            Label6.Text = dr1[0]["webhww_jrsj"].ToString();
 66            _webhww_hybh1 = "?hid=" + dr1[0]["webhww_hybh"].ToString();
 67        }
 68        else
 69        ...{
 70            Label5.Text = "注册";
 71            Label6.Text = "注册";
 72            _webhww_hybh1 = "../webhww_register.aspx";
 73
 74        }
 75
 76        DataRow[] dr2 = dt.Select("webhww_hywz=2");
 77        if (dr2.Length > 0)
 78        ...{
 79            Label7.Text = dr2[0]["webhww_hyxm"].ToString();
 80            Label8.Text = dr2[0]["webhww_jrsj"].ToString();
 81            _webhww_hybh2 = "?hid=" + dr2[0]["webhww_hybh"].ToString();
 82
 83        }
 84        else
 85        ...{
 86            Label7.Text = "注册";
 87            Label8.Text = "注册";
 88            _webhww_hybh2 = "../webhww_register.aspx";
 89
 90        }
 91
 92        DataRow[] dr3 = dt.Select("webhww_hywz=3");
 93        if (dr3.Length > 0)
 94        ...{
 95            Label9.Text = dr3[0]["webhww_hyxm"].ToString();
 96            Label10.Text = dr3[0]["webhww_jrsj"].ToString();
 97            _webhww_hybh3 = "?hid=" + dr3[0]["webhww_hybh"].ToString();
 98
 99        }
100        else
101        ...{
102            Label9.Text = "注册";
103            Label10.Text = "注册";
104            _webhww_hybh3 = "../webhww_register.aspx";
105
106        }
107
108        DataRow[] dr4 = dt.Select("webhww_hywz=4");
109        if (dr4.Length > 0)
110        ...{
111            Label11.Text = dr4[0]["webhww_hyxm"].ToString();
112            Label12.Text = dr4[0]["webhww_jrsj"].ToString();
113            _webhww_hybh4= "?hid=" + dr4[0]["webhww_hybh"].ToString();
114
115        }
116        else
117        ...{
118            Label11.Text = "注册";
119            Label13.Text = "注册";
120            _webhww_hybh4= "../webhww_register.aspx";
121
122        }
123
124        DataRow[] dr5 = dt.Select("webhww_hywz=5");
125        if (dr5.Length > 0)
126        ...{
127            Label13.Text = dr5[0]["webhww_hyxm"].ToString();
128            Label14.Text = dr5[0]["webhww_jrsj"].ToString();
129            _webhww_hybh5 = "?hid=" + dr5[0]["webhww_hybh"].ToString();
130
131        }
132        else
133        ...{
134            Label13.Text = "注册";
135            Label14.Text = "注册";
136            _webhww_hybh5 = "../webhww_register.aspx";
137
138        }
139    }
140}
141