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;
}
