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

/// <summary>
/// User 的摘要說明
/// </summary>
public class User
{
     private string Uaccouts;
     private string Upassword;
    private string Uname;
     private string sort;
     private string Cnumber;
    private string Cname;

     private bool exist;
    private bool st;
    private bool xz;
    public User()
	{
		//
		// TODO: 在此處添加構造函數邏輯
		//
        this.Uaccouts = Uaccouts;
        this.Upassword = Upassword;
        this.sort = sort;
	}

    public void Update(String userName, String npassword)
    {
        DataBase db = new DataBase();       //實例化一個  DataBase類
        string sql = "update [UserInformation] set Upassword=" + npassword + " where Uaccouts='" + userName + "'";
       db.ExecuteSQL(sql);          //GetDataRow方法查詢數據
       
    }

    public void LoadData(String userName)
    {
        DataBase db = new DataBase();       //實例化一個  DataBase類
        string sql = "select * from [UserInformation] where Uaccouts='" + userName + "'";
        DataRow dr = db.GetDataRow(sql);          //GetDataRow方法查詢數據
        if (dr != null)
        {
            this.Uaccouts = dr["Uaccouts"].ToString();
            this.Upassword = dr["Upassword"].ToString();
            this.sort = dr["Usort"].ToString();
            this.exist = true;                //根據查詢的數據賦值
        }
        else
            this.exist = false;
    }

    public void Load(String number)
    {
        DataBase db = new DataBase();        //實例化一個  DataBase類
        string sql = "select * from CourseInformation where Cnumber='" + number + "'";
        DataRow dr = db.GetDataRow(sql);          //GetDataRow方法查詢數據
        if (dr != null)
        {
            this.Cnumber = dr["Cnumber"].ToString();
            this.Cname = dr["Cname"].ToString();        //根據查詢的數據賦值
          
            this.st= true;
        }
        else
            this.st = false;
    }
    public void LoadUC(String number)
    {
        DataBase db = new DataBase();        //實例化一個  DataBase類
        string sql = "select * from UserCourseInformation where Cnumber='" + number + "'";
        DataRow dr = db.GetDataRow(sql);          //GetDataRow方法查詢數據
        if (dr != null)
        {
            this.st = true;     //根據查詢的數據賦值          
        }
        else
            this.st = false;
       
    }
    public void LoadUCname(String num)
    {
        DataBase db = new DataBase();        //實例化一個  DataBase類
        string sql = "select * from UserCourseInformation where Cname='" + num + "'";
        DataRow dr = db.GetDataRow(sql);          //GetDataRow方法查詢數據
        if (dr != null)
        {
            this.st = true;     //根據查詢的數據賦值          
        }
        else
            this.st = false;

    }
    public void Lo(String num)
    {
        DataBase db = new DataBase();             //實例化一個  DataBase類
        string sql = "select * from CourseInformation where Cname='" + num + "'";
        DataRow dr = db.GetDataRow(sql);          //GetDataRow方法查詢數據
        if (dr != null)
        {
            this.Cnumber = dr["Cnumber"].ToString();
            this.Cname = dr["Cname"].ToString();            //根據查詢的數據賦值
            this.xz = true;

        }
        else
        {
            this.xz = false;
        }
      
    } 

    public void Data(String Name)
    {
        DataBase db = new DataBase();            //實例化一個  DataBase類
        string sql = "select * from [UserInformation] where Uaccouts='" + Name + "'";
        DataRow dr = db.GetDataRow(sql);          //GetDataRow方法查詢數據
        if (dr != null)
        {
            this.Uaccouts = dr["Uaccouts"].ToString();
            this.Uname = dr["Uname"].ToString();             //根據查詢的數據賦值
           
            
        }
       
    }

    public void Add(int UCnumber,String Cnumber, String Uaccouts, String Uname, String Cname)
    {
        DataBase db = new DataBase();            //實例化一個  DataBase類
        string sql = "insert into UserCourseInformation Values(" + UCnumber + "," + "'" + Cnumber + "'," + "'" + Uaccouts + "'," + "'" + Uname + "'," + "'" + Cname + "')";

        db.ExecuteSQL(sql);          //執行語句
    }                                                                           
                                                                                                  

    public string accouts
    {
        get
        {
            return this.Uaccouts;
        }
        set
        {
            if (value != this.Uaccouts)
                this.Uaccouts = value;
        }
    }
    public string password
    {
        get
        {
            return this.Upassword;
        }
       
    }
    public string sortt
    {
        get
        {
            return this.sort;
        }
       
    }
    public bool existt
    {
        get
        {
            return this.exist;
        }
        
        
    }
    public bool stt
    {
        get
        {
            return this.st;
        }


    }
    public string Cnumbert

    {
        get
        {
            return this.Cnumber;
        }


    }
    public string Cnamet
    {
        get
        {
            return this.Cname;
        }


    }
    public string Unamet
    {
        get
        {
            return this.Uname;
        }


    }
    public bool xzt
    {
        get
        {
            return this.xz;
        }


    }
    
}