예제 #1
0
 protected void Page_Load( object sender , EventArgs e )
 {
     Security s = Session["sec"] as Security;
     if (s == null)
     {
         Response.Redirect("error.aspx");
     }
     dbModule dm = new dbModule();
     SqlDataSource1.SelectCommand = "SELECT [ID], [GLYXM], [SYSID], [GLYID], [SYSMC], [SYSDD] FROM [V_SYSGLY] where sysid in (select sysid from t_sysxxb where syslxid =" + dm.getZrSYSID( s.getUserCode()) +")";
     SqlDataSource4.SelectCommand = "select id ,sysmc from t_sysxxb where syslxid =" + dm.getZrSYSID( s.getUserCode() );
     if ( !IsPostBack )
     {
         GLYDDL.DataSource = SqlDataSource3;
         GLYDDL.DataTextField = "GLYXM";
         GLYDDL.DataValueField = "DLM";
         GLYDDL.DataBind();
         SYSDDL.DataSource = SqlDataSource4;
         SYSDDL.DataTextField = "SYSMC";
         SYSDDL.DataValueField = "ID";
         SYSDDL.DataBind();
     }
 }