Beispiel #1
0
        public List <kompetencia_summary_struct> Data_KompetenciaJeloltKapcs() // javítva
        {
            string command = "SELECT coalesce(AVG(k1_val),0) as k1_val,coalesce(AVG(k2_val),0) as k2_val,coalesce(AVG(k3_val),0) as k3_val,coalesce(AVG(k4_val),0) as k4_val,coalesce(AVG(k5_val),0) as k5_val, tamogatom FROM kompetencia_jelolt_kapcs WHERE jelolt_id = " + aControl.ApplicantID + " AND projekt_id = " + pControl.ProjektID + "";
            List <kompetencia_summary_struct> list = mySql.Kompetencia_summary_MySql_listQuery(command);

            mySql.close();
            return(list);
        }