Esempio n. 1
0
        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);
        }
Esempio n. 2
0
        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);
        }
Esempio n. 3
0
        public MySqlDataReader SearchApartId(string apart)
        {
            MySqlDataReader rdr = DBManager.GetInstance().select("SELECT ID FROM erp_school.부서 WHERE 부서명='" + apart + "';");

            return(rdr);
        }
Esempio n. 4
0
        public MySqlDataReader SetRank(int apart)
        {
            MySqlDataReader rdr = DBManager.GetInstance().select("SELECT DISTINCT position FROM erp_school.Employee WHERE department=" + apart);

            return(rdr);
        }
Esempio n. 5
0
        public MySqlDataReader SetApart()
        {
            MySqlDataReader rdr = DBManager.GetInstance().select("SELECT 부서명 FROM erp_school.부서 WHERE valid=1;");

            return(rdr);
        }