예제 #1
0
        private void button1_Click(object sender, EventArgs e)
        {
            bool      details = false;
            opd       opd     = new opd();
            dbconnect db      = new dbconnect();

            opd.getPatientDetailsHistory(textBox1.Text, db);
            if (opd.dr.Read())
            {
                id         = textBox1.Text;
                name       = opd.dr[0].ToString();
                gender     = opd.dr[1].ToString();
                familyHead = opd.dr[2].ToString();
                details    = true;
            }
            else
            {
                MessageBox.Show("Invalid Patient ID!!");
                db.dbclose();
            }
            db.reader_close();
            if (details)
            {
                opdCount      = 0;
                medicineCount = 0;
                opd.patientAge(id);
                age = opd.age.ToString();
                opd.getPatientOPDHistory(textBox1.Text, db);
                while (opd.dr.Read())
                {
                    medicine_id    = opd.dr[2].ToString().Split(',');
                    medicineCount += medicine_id.Length;
                    opdCount      += 1;
                }
                db.dbclose();
                printPreviewDialog1.ShowDialog();
            }
        }