Exemplo n.º 1
0
    def __init__(self):
        QtGui.QMainWindow.__init__(self)
        self.ui = Ui_Addstu_window()
        self.ui.setupUi(self)
        self.conn()  #need cathch exeption
        Addstu_query = QSqlQuery()

        Addstu_query.exec_("Select Class_name from Class")
        model = QSqlQueryModel()
        model.setQuery(Addstu_query)
        self.ui.Class_listView.setModel(model)
        self.ui.Class_listView.clicked.connect(self.show_student)
        self.ui.Stu_listView.clicked.connect(self.select_student)
        self.ui.Remove_stu_btn.clicked.connect(self.remove_student)
        self.ui.Add_stu_btn.clicked.connect(self.add_student)

        self.ui.Remove_stu_btn.setEnabled(False)
        self.ui.Add_stu_btn.setEnabled(False)
Exemplo n.º 2
0
    def __init__(self, name=None):
        QtGui.QMainWindow.__init__(self)
        self.ui = Ui_Addstu_window()
        self.ui.setupUi(self)
        self.conn()  #need catch exeption
        Addstu_query = QSqlQuery()
        #get list of class
        Addstu_query.exec_("Select Class_name from Class ORDER BY Class_name")
        model = QSqlQueryModel()
        model.setQuery(Addstu_query)
        #populate classes to listview
        self.ui.Class_listView.setModel(model)
        self.ui.Class_listView.clicked.connect(self.show_student)
        self.ui.Stu_tableView.clicked.connect(self.select_student)
        self.ui.Remove_stu_btn.clicked.connect(self.remove_student)
        self.ui.Add_stu_btn.clicked.connect(self.add_student)

        self.ui.Remove_stu_btn.setEnabled(False)
        self.ui.Add_stu_btn.setEnabled(False)
Exemplo n.º 3
0
    def __init__(self, name=None):
        QtGui.QMainWindow.__init__(self)
        self.ui = Ui_Addstu_window()
        self.ui.setupUi(self)
        self.conn()  #need catch exeption
        Addstu_query = QSqlQuery()
        Addstu_query.exec_(
            "Select Class_name from Class as C, Teacher_Class as\
                           TC, Teacher as T where T.Teacher_id = TC.Teacher_id and \
                           T.Teacher_id = (select Teacher_id from Account where User_name = \
                           '%s') and TC.Class_id = C.Class_id ORDER BY Class_name"
            % name)
        model = QSqlQueryModel()
        model.setQuery(Addstu_query)
        self.ui.Class_listView.setModel(model)
        self.ui.Class_listView.clicked.connect(self.show_student)
        self.ui.Stu_tableView.clicked.connect(self.select_student)
        self.ui.Remove_stu_btn.clicked.connect(self.remove_student)
        self.ui.Add_stu_btn.clicked.connect(self.add_student)

        self.ui.Remove_stu_btn.setEnabled(False)
        self.ui.Add_stu_btn.setEnabled(False)
 def __init__(self, name = None):
     QtGui.QMainWindow.__init__(self)
     self.ui = Ui_Addstu_window()
     self.ui.setupUi(self)
     self.conn() #need catch exeption
     Addstu_query = QSqlQuery()
     #get list of class
     Addstu_query.exec_("Select Class_name from Class ORDER BY Class_name")
     model = QSqlQueryModel()
     model.setQuery(Addstu_query)
     #populate classes to listview
     self.ui.Class_listView.setModel(model)
     self.ui.Class_listView.clicked.connect(self.show_student)
     self.ui.Stu_tableView.clicked.connect(self.select_student)
     self.ui.Remove_stu_btn.clicked.connect(self.remove_student)
     self.ui.Add_stu_btn.clicked.connect(self.add_student)
     
     self.ui.Remove_stu_btn.setEnabled(False)
     self.ui.Add_stu_btn.setEnabled(False)
Exemplo n.º 5
0
 def __init__(self, name = None):
     QtGui.QMainWindow.__init__(self)       
     self.ui = Ui_Addstu_window()
     self.ui.setupUi(self)
     self.conn() #need catch exeption
     Addstu_query = QSqlQuery()
     Addstu_query.exec_("Select Class_name from Class as C, Teacher_Class as\
                        TC, Teacher as T where T.Teacher_id = TC.Teacher_id and \
                        T.Teacher_id = (select Teacher_id from Account where User_name = \
                        '%s') and TC.Class_id = C.Class_id ORDER BY Class_name" % name)
     model = QSqlQueryModel()
     model.setQuery(Addstu_query)
     self.ui.Class_listView.setModel(model)
     self.ui.Class_listView.clicked.connect(self.show_student)
     self.ui.Stu_tableView.clicked.connect(self.select_student)
     self.ui.Remove_stu_btn.clicked.connect(self.remove_student)
     self.ui.Add_stu_btn.clicked.connect(self.add_student)
     
     self.ui.Remove_stu_btn.setEnabled(False)
     self.ui.Add_stu_btn.setEnabled(False)
class Addstu_window(QtGui.QMainWindow):
    def __init__(self, name = None):
        QtGui.QMainWindow.__init__(self)
        self.ui = Ui_Addstu_window()
        self.ui.setupUi(self)
        self.conn() #need catch exeption
        Addstu_query = QSqlQuery()
        #get list of class
        Addstu_query.exec_("Select Class_name from Class ORDER BY Class_name")
        model = QSqlQueryModel()
        model.setQuery(Addstu_query)
        #populate classes to listview
        self.ui.Class_listView.setModel(model)
        self.ui.Class_listView.clicked.connect(self.show_student)
        self.ui.Stu_tableView.clicked.connect(self.select_student)
        self.ui.Remove_stu_btn.clicked.connect(self.remove_student)
        self.ui.Add_stu_btn.clicked.connect(self.add_student)
        
        self.ui.Remove_stu_btn.setEnabled(False)
        self.ui.Add_stu_btn.setEnabled(False)

    #get new window to select student
    def add_student(self):
        self.ui.detail = Addstu_detail_dialog(self.class_name)
        self.ui.detail.show()

    #revome student from the class
    def remove_student(self):
        Remove_query = QSqlQuery()
        
        if Remove_query.exec_("Update Student_Class Set Class_approval = -1 Where\
                            Student_id = (Select Student_id from Student Where Student_name = \
                            '%s') and Class_id = (Select Class_id from Class where \
                            Class_name = '%s')" % (self.stu_name, self.class_name)):
            #get corresponding refund
            refund(self.class_name, self.stu_name)
            QtGui.QMessageBox.information(
                self, 'Success', 'Remove student from class successfully')

    
    def select_student(self, index):
        status = -1
        
        status_query = QSqlQuery()
        status_query.exec_("Select SC.Class_approval from Student_Class as SC,Student as S where\
                            SC.Class_id = (Select Class_id from Class where Class_name = '%s') \
                            and SC.Student_id = S.Student_id and SC.Class_finished <> 1 \
                            and S.Student_name = '%s' ORDER BY S.Student_name" \
                           % (self.selectedClass, index.data()))
        if(status_query.next()):
            record = status_query.record()
            status = int(record.value(0));

        if (status != -1):
            self.ui.Remove_stu_btn.setEnabled(True)

        else:
            self.ui.Remove_stu_btn.setEnabled(False)
            
        self.stu_name = index.data()
        
    def show_student(self, index):
        self.selectedClass = index.data();
        
        self.ui.Remove_stu_btn.setEnabled(False)
        self.ui.Add_stu_btn.setEnabled(True)
        Student_query = QSqlQuery()
        Student_query.exec_("Select S.Student_name, SC.Class_approval from Student_Class as SC,Student as S where\
                            SC.Class_id = (Select Class_id from Class where Class_name = '%s') \
                            and SC.Student_id = S.Student_id and SC.Class_finished <> 1 \
                            ORDER BY S.Student_name" % index.data())
        self.class_name = index.data()
        model = QSqlQueryModel()
        model.setQuery(Student_query)      
        self.ui.Stu_tableView.setModel(model)

    def conn(self):
        self.db = QSqlDatabase.addDatabase("QMYSQL")
        self.db.setHostName("services1.mcs.sdsmt.edu")
        self.db.setDatabaseName("db_dancesoft_f15")
        self.db.setUserName("dancesoft_f15")
        self.db.setPassword("DanceSoft")
        return self.db.open()
Exemplo n.º 7
0
class Addstu_window(QtGui.QMainWindow):
    def __init__(self, name=None):
        QtGui.QMainWindow.__init__(self)
        self.ui = Ui_Addstu_window()
        self.ui.setupUi(self)
        self.conn()  #need catch exeption
        Addstu_query = QSqlQuery()
        Addstu_query.exec_(
            "Select Class_name from Class as C, Teacher_Class as\
                           TC, Teacher as T where T.Teacher_id = TC.Teacher_id and \
                           T.Teacher_id = (select Teacher_id from Account where User_name = \
                           '%s') and TC.Class_id = C.Class_id ORDER BY Class_name"
            % name)
        model = QSqlQueryModel()
        model.setQuery(Addstu_query)
        self.ui.Class_listView.setModel(model)
        self.ui.Class_listView.clicked.connect(self.show_student)
        self.ui.Stu_tableView.clicked.connect(self.select_student)
        self.ui.Remove_stu_btn.clicked.connect(self.remove_student)
        self.ui.Add_stu_btn.clicked.connect(self.add_student)

        self.ui.Remove_stu_btn.setEnabled(False)
        self.ui.Add_stu_btn.setEnabled(False)

    def add_student(self):
        self.ui.detail = Addstu_detail_dialog(self.class_name)
        self.ui.detail.show()

    def remove_student(self):
        Remove_query = QSqlQuery()

        if Remove_query.exec_(
                "Update Student_Class Set Class_approval = -1 Where\
                            Student_id = (Select Student_id from Student Where Student_name = \
                            '%s') and Class_id = (Select Class_id from Class where \
                            Class_name = '%s')" %
            (self.stu_name, self.class_name)):

            refund(self.class_name, self.stu_name)

            QtGui.QMessageBox.information(
                self, 'Success', 'Remove student from class successfully')

    def select_student(self, index):
        status = -1

        status_query = QSqlQuery()
        status_query.exec_("Select SC.Class_approval from Student_Class as SC,Student as S where\
                            SC.Class_id = (Select Class_id from Class where Class_name = '%s') \
                            and SC.Student_id = S.Student_id and SC.Class_finished <> 1 \
                            and S.Student_name = '%s' ORDER BY S.Student_name" \
                           % (self.selectedClass, index.data()))
        if (status_query.next()):
            record = status_query.record()
            status = int(record.value(0))

        if (status != -1):
            self.ui.Remove_stu_btn.setEnabled(True)

        else:
            self.ui.Remove_stu_btn.setEnabled(False)

        self.stu_name = index.data()

    def show_student(self, index):
        self.selectedClass = index.data()

        self.ui.Remove_stu_btn.setEnabled(False)
        self.ui.Add_stu_btn.setEnabled(True)
        Student_query = QSqlQuery()
        Student_query.exec_(
            "Select S.Student_name, SC.Class_approval from Student_Class as SC,Student as S where\
                            SC.Class_id = (Select Class_id from Class where Class_name = '%s') \
                            and SC.Student_id = S.Student_id and SC.Class_finished <> 1 \
                            ORDER BY S.Student_name" % index.data())
        self.class_name = index.data()
        model = QSqlQueryModel()
        model.setQuery(Student_query)
        self.ui.Stu_tableView.setModel(model)

    def conn(self):
        self.db = QSqlDatabase.addDatabase("QMYSQL")
        self.db.setHostName("services1.mcs.sdsmt.edu")
        self.db.setDatabaseName("db_dancesoft_f15")
        self.db.setUserName("dancesoft_f15")
        self.db.setPassword("DanceSoft")
        return self.db.open()
Exemplo n.º 8
0
class Addstu_window(QtGui.QMainWindow):
    def __init__(self):
        QtGui.QMainWindow.__init__(self)
        self.ui = Ui_Addstu_window()
        self.ui.setupUi(self)
        self.conn()  #need cathch exeption
        Addstu_query = QSqlQuery()

        Addstu_query.exec_("Select Class_name from Class")
        model = QSqlQueryModel()
        model.setQuery(Addstu_query)
        self.ui.Class_listView.setModel(model)
        self.ui.Class_listView.clicked.connect(self.show_student)
        self.ui.Stu_listView.clicked.connect(self.select_student)
        self.ui.Remove_stu_btn.clicked.connect(self.remove_student)
        self.ui.Add_stu_btn.clicked.connect(self.add_student)

        self.ui.Remove_stu_btn.setEnabled(False)
        self.ui.Add_stu_btn.setEnabled(False)

    def add_student(self):
        self.ui.detail = Addstu_detail_dialog(self.class_name)
        self.ui.detail.show()

    def remove_student(self):
        Remove_query = QSqlQuery()

        if Remove_query.exec_(
                "Update Student_Class Set Class_approval = -1 Where\
                            Student_id = (Select Student_id from Student Where Student_name = \
                            '%s') and Class_id = (Select Class_id from Class where \
                            Class_name = '%s')" %
            (self.stu_name, self.class_name)):
            QtGui.QMessageBox.information(
                self, 'Success', 'Remove student from class successfully')

    def select_student(self, index):
        self.ui.Remove_stu_btn.setEnabled(True)
        self.stu_name = index.data()

    def show_student(self, index):
        self.ui.Remove_stu_btn.setEnabled(False)
        self.ui.Add_stu_btn.setEnabled(True)
        Student_query = QSqlQuery()
        Student_query.exec_(
            "Select S.Student_name from Student_Class as SC,Student as S where\
                            SC.Class_id = (Select Class_id from Class where Class_name = '%s') \
                            and SC.Student_id = S.Student_id and SC.Class_finished <> 1 and \
                            SC.Class_approval <> -1" % index.data())
        self.class_name = index.data()
        model = QSqlQueryModel()
        model.setQuery(Student_query)
        self.ui.Stu_listView.setModel(model)

    def conn(self):
        self.db = QSqlDatabase.addDatabase("QMYSQL")
        self.db.setHostName("services1.mcs.sdsmt.edu")
        self.db.setDatabaseName("db_dancesoft_f15")
        self.db.setUserName("dancesoft_f15")
        self.db.setPassword("DanceSoft")
        return self.db.open()