public AuthorityData Select()
        {
            SQLiteDataReader rdr;
            SQLiteCommand    command;
            string           sql = " where Authority=" + MemberData.GetMemberData.AuthorityData.Authority;

            dBConn.DBOpen();

            command = dBConn.Select(SQLiteData.TableAuthority, sql);
            rdr     = command.ExecuteReader();

            AuthorityData authorityData = new AuthorityData();

            while (rdr.Read())
            {
                authorityData.Authority = Convert.ToInt32(rdr["Authority"]);
                authorityData.SignUp    = Convert.ToInt32(rdr["SignUp"]);
                authorityData.Remove    = Convert.ToInt32(rdr["Remove"]);
                authorityData.Modify    = Convert.ToInt32(rdr["Modify"]);
                authorityData.Search    = Convert.ToInt32(rdr["Search"]);
                authorityData.Schedule  = Convert.ToInt32(rdr["Schedule"]);
            }

            dBConn.DBClose();

            return(authorityData);
        }
Exemple #2
0
 private MemberData()
 {
     Phone         = "";
     Password      = "";
     Name          = "";
     Wage          = "";
     AuthorityData = new AuthorityData();
     Task          = -1;
 }