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); }
private MemberData() { Phone = ""; Password = ""; Name = ""; Wage = ""; AuthorityData = new AuthorityData(); Task = -1; }