コード例 #1
0
ファイル: TreatDBO.cs プロジェクト: lihinilakma/NewTest
        public void addTreat(Treat treat)
        {
            string doc_nic = treat.getdoc_nic();

            string patient_nic    = treat.getpatient_nic();
            string treatment_date = treat.gettreatment_date();
            float  treatment_fee  = treat.gettreatment_fee();

            string treatment_code    = treat.gettreatment_code();
            string treatment_details = treat.gettreatment_details();
            bool   is_paid           = treat.getis_paid();



            conn.Open();

            SqlCommand cmd = new SqlCommand("insert into treatments values ('" + doc_nic + "', '" + patient_nic + "','" + treatment_date + "','" + treatment_fee + "','" + treatment_code + "','" + treatment_details + "','" + is_paid + "')", conn);

            cmd.ExecuteNonQuery();

            conn.Close();
        }