public MySqlDataReader SearchId(int apartid, string rank, string name)
{
MySqlDataReader rdr = DBManager.GetInstance().select("SELECT identification FROM erp_school.Employee WHERE department=" + apartid + " AND position='" + rank + "' AND name='" + name + "';");
return(rdr);
}
public MySqlDataReader SetName(int apartid, string rank)
{
MySqlDataReader rdr = DBManager.GetInstance().select("SELECT name FROM erp_school.Employee WHERE department=" + apartid + " AND position='" + rank + "' AND valid=1;");
return(rdr);
}
public MySqlDataReader SearchApartId(string apart)
{
MySqlDataReader rdr = DBManager.GetInstance().select("SELECT ID FROM erp_school.부서 WHERE 부서명='" + apart + "';");
return(rdr);
}
public MySqlDataReader SetRank(int apart)
{
MySqlDataReader rdr = DBManager.GetInstance().select("SELECT DISTINCT position FROM erp_school.Employee WHERE department=" + apart);
return(rdr);
}
public MySqlDataReader SetApart()
{
MySqlDataReader rdr = DBManager.GetInstance().select("SELECT 부서명 FROM erp_school.부서 WHERE valid=1;");
return(rdr);
}