예제 #1
0
        private void ChangePatientBtn_Click(object sender, EventArgs e)
        {
            if (listView1.SelectedItems.Count == 0)
            {
                MessageBox.Show("请选择一行");
                return;
            }


            Intent.dict["ADD_OR_CHANGE"] = "CHANGE";

            PatientEdit pe = new PatientEdit();
            Patient     p  = new Patient();

            p.SetValue(
                listView1.SelectedItems[0].SubItems[0].Text,
                listView1.SelectedItems[0].SubItems[1].Text,
                listView1.SelectedItems[0].SubItems[2].Text,
                listView1.SelectedItems[0].SubItems[3].Text
                );
            pe.p = p;
            Intent.dict["OLD_ID"] = p.PID;

            if (pe.ShowDialog() == DialogResult.OK)
            {
                sqlString = @"" +
                            " UPDATE [Patient]" +
                            " SET" +
                            "   [PID]='" + p.PID + "'," +
                            "   [PName]='" + p.PName + "'," +
                            "   [Date]='" + p.Date + "'," +
                            "   [GroupNo]=" + p.GroupNo +
                            " WHERE [PID]='" + Intent.dict["OLD_ID"] + "'";
                db.SetBySQL(sqlString);
            }

            UpdateListView();
        }
예제 #2
0
        /* ################ Tab1 ################ */
        private void AddPatientBtn_Click(object sender, EventArgs e)
        {
            Intent.dict["ADD_OR_CHANGE"] = "ADD";

            PatientEdit pe = new PatientEdit();

            if (pe.ShowDialog() == DialogResult.OK)
            {
                Patient p = pe.p;

                sqlString = @"" +
                            " INSERT INTO [Patient]" +
                            " VALUES" +
                            " (" +
                            "   '" + p.PID + "'," +
                            "   '" + p.PName + "'," +
                            "   '" + p.Date + "'," +
                            "   " + p.GroupNo + "" +
                            " )";
                db.SetBySQL(sqlString);
            }

            UpdateListView();
        }