示例#1
0
        private void button4_Click(object sender, EventArgs e)
        {
            Connection con = new Connection();

            con.OpenConection();



            string[] param_names = new string[] {
                "@doc_code"                // كود الدكتور فورن كي من الدكتور
                , "@inventry_id "          // كود الزياره من جدول الزياره
                , "@follow_up_sheet_date " // تاريخ الروشته
                , "@observer_doctor"       // اسم الدكتور اللي كتب الروشته
                , "@examination_notes"     // الملاحظات الطبيه في الروشته
                , "@medicin "              // الادويه
                , "@sol "                  // التحاليل
                , "@investigation"         // التشخيص // المنظار مش عارفه فين
                , "@operations "           // العمليات
                , "@rays"                  // الاشعه
            };                             // الامراض الوراثسيه والعائليه للمريض

            //@doc_code            @age   اسم الدكتور               @name       اسمالمريض             @iventry id                @date                                 @present                          @past                            @family
            string[]    param_values = new string[]      { textBox3.Text, textBox4.Text, dateTimePicker1.Value.ToString("yyyy-MM-dd"), comboBox7.SelectedItem.ToString(), textBox1.Text, listBox3.Items.ToString(), listBox4.Items.ToString(), listBox6.Items.ToString(), listBox5.Items.ToString(), listBox1.Items.ToString() };
            SqlDbType[] param_types  = new SqlDbType[] { SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.Date, SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.VarChar };
            con.ExecuteInsertOrUpdateOrDeleteUsingStoredProc("insert_follow_up_sheet", param_names, param_values, param_types);


            validation v = new validation();
        }
示例#2
0
        private void textBox30_TextChanged(object sender, EventArgs e)
        {
            validation v = new validation();

            v.stringvalidation(textBox30, "this value");
            //
        }
示例#3
0
        private void textBox3_TextChanged(object sender, EventArgs e)
        {
            validation v = new validation();

            v.numbervalidation(textBox3, "this value");
            //     textBox3.Text = "";
        }
示例#4
0
        private void button1_Click(object sender, EventArgs e)
        {
            Connection con = new Connection();

            con.OpenConection();



            string[] param_names = new string[] {
                "@doc_code"
                , "@age" // دا اسم الدكتور بس مش عاوز اغير الاسم في الداتا بيز
                , "@name"
                , "@inventry_id"

                , "@admission_Date"  // تاريخ كتابة الحاله الصحيه للمريض
                , "@present_history" // الحاله الصحيه الحاليه للمريض
                , "@past_history "   // التاريخ المرضي للمريض
                , "@familay_history"
            };                       // الامراض الوراثسيه والعائليه للمريض
            s = comboBox1.SelectedItem.ToString();

            textBox6.Text = s;

            //@doc_code            @age   اسم الدكتور               @name       اسمالمريض             @iventry id                @date                                 @present                          @past                            @family
            string[]    param_values = new string[]      { textBox3.Text, comboBox2.SelectedItem.ToString(), comboBox1.SelectedItem.ToString(), textBox2.Text, dateTimePicker1.Value.ToString("yyyy-MM-dd"), textBox4.Text, textBox5.Text, textBox6.Text };
            SqlDbType[] param_types  = new SqlDbType[] { SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.Int, SqlDbType.Date, SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.VarChar };
            con.ExecuteInsertOrUpdateOrDeleteUsingStoredProc("insert_case_sheet", param_names, param_values, param_types);


            validation v = new validation();


            v.stringvalidation(textBox4, "this value ");
            v.stringvalidation(textBox5, "this value ");
            v.stringvalidation(textBox6, "this value ");


            textBox4.Text = "";
            textBox5.Text = "";
            textBox6.Text = "";
        }
示例#5
0
        private void button1_Click(object sender, EventArgs e)
        {
            Connection con = new Connection();

            con.OpenConection();


            string[] param_names = new string[] {
                "@intial_assesment_date"
                , "@inventry_id"
                , "@doc_code"
                , "@weightt"
                , "@head"
                , "@lenght"
                , "@abdominalc"
                , "@void_urine "
                , "@tempreture "
                , "@heart_rate"
                , "@respiratory"
                , "@pass_stool"
                , "@physical_examination_color"
                , "@physical_examination_head"
                , "@physical_examination_fontanels"
                , "@physical_examination_eyes"
                , "@physical_examination_ears"
                , "@physical_examination_nose"
                , "@physical_examination_mouth"
                , "@physical_examination_neck"
                , "@physical_examination_calavicles "
                , "@physical_examination_breast "
                , "@physical_examination_thorax "
                , "@physical_examination_activity"
                , "@physical_examination_heart "
                , "@physical_examination_abdomen"
                , "@physical_examination_liver "
                , "@physical_examination_spleen "
                , "@physical_examination_lungs "
                , "@physical_examination_hernia "
                , "@physical_examination_umbilicus "
                , "@physical_examination_genitilia "
                , "@physical_examination_anus "
                , "@physical_examination_deformit"
                , "@physical_examination_skin "
                , "@physical_examination_extemities"
                , "@physical_examination_solo_crease "
                , "@physical_examination_reflexes "
                , "@physical_examination_moro "
                , "@physical_examination_grasp "
                , "@physical_examination_light "
                , "@physical_examination_glabellar"
                , "@physical_examination_rooting "
                , "@physical_examination_suckling "
                , "@immpression_tatitional_age "
                , "@immpression_weeks "
                , "@immpression_provisional_diagnosis "
                , "@immpression_date"
            }; // الامراض الوراثسيه والعائليه للمريض


            //@doc_code            @age   اسم الدكتور               @name       اسمالمريض             @iventry id                @date                                 @present                          @past                            @family
            string[] param_values = new string[]

            {
                dateTimePicker1.Value.ToString("yyyy-MM-dd"),
                textBox45.Text,                  //   "@initial_assessment_date" ,
                textBox46.Text,                  //    "@doc_code" ,                                                  //   weight ,
                textBox15.Text,                  // head
                textBox1.Text,
                textBox14.Text,                  //   length
                textBox2.Text,                   //   "@patient_id"  ,
                textBox7.Text,                   //    "@general_apperance_age" ,
                textBox8.Text,                   //   "@general_apperance_conscious_level" ,
                textBox3.Text,                   //   "@general_apperance_glass_coma_score" ,
                textBox4.Text,                   //   "@general_apperance_h_r" ,
                textBox6.Text,                   //   "@general_apperance_r_r" ,
                textBox5.Text,                   //   "@general_apperance_tempreture" ,
                textBox17.Text,                  //   "@general_apperance_blood_pressure" ,
                textBox16.Text,                  //   "@general_apperance_color" ,
                textBox11.Text,                  //   "@general_apperance_turgor",
                textBox9.Text,                   //  "@general_apperance_eruption" ,
                textBox10.Text,                  //   "@head_neck_fascies" ,
                textBox18.Text,                  //    "@head_neck_eyes" ,
                textBox12.Text,                  //   "@head_neck_mouth_tongue" ,
                textBox13.Text,                  //   "@head_neck_pharynx" ,
                textBox19.Text,                  //   "@head_neck_lymph_nodes" ,
                textBox40.Text,                  //   "@head_neck_oters" ,
                textBox29.Text,                  //   "@heart_precordial_bulge" ,
                textBox27.Text,                  //   "@heart_apex_beat" ,
                textBox28.Text,                  //   "@heart_thrill",
                textBox26.Text,                  //    "@heart_heart_sound" ,
                textBox24.Text,                  //    "@heart_murmurs",
                textBox25.Text,                  //    "@heart_others" ,
                textBox21.Text,                  //    "@chest_shape" ,
                textBox22.Text,                  //    "@chest_movement" ,
                textBox20.Text,
                textBox23.Text,                  //     "@chest_reactions" ,
                textBox39.Text,                  //     "@chest_air_entry" ,
                textBox37.Text,                  //    "@chest_breath_sounds" ,
                textBox38.Text,                  //    "@chest_adventure_sounds" ,
                textBox36.Text,                  //    "@abdomen_liver",
                textBox34.Text,                  //    "@abdomen_spleen" ,
                textBox35.Text,                  //     "@abdomen_kidneys" ,
                textBox33.Text,                  //    "@abdomen_ascites" ,
                textBox31.Text,                  //   "@abdomen_others" ,
                textBox32.Text,                  //    "@back_spine_deformity" ,
                textBox30.Text,                  //     "@back_spine_sweling" ,
                textBox43.Text,                  //     "@neurological_examination_mentality" ,
                textBox44.Text,
                textBox42.Text,
                textBox41.Text,
                dateTimePicker2.Value.ToString("yyyy-MM-dd")
                //     "@neurological_examination_cranial_nerves"
            };
            SqlDbType[] param_types = new SqlDbType[]
            {
                SqlDbType.Date,
                SqlDbType.Int,
                SqlDbType.VarChar,
                SqlDbType.Float,
                SqlDbType.VarChar,
                SqlDbType.Float,
                SqlDbType.VarChar,
                SqlDbType.VarChar,
                SqlDbType.Float,
                SqlDbType.VarChar,
                SqlDbType.VarChar,
                SqlDbType.VarChar,
                SqlDbType.VarChar,
                SqlDbType.VarChar,
                SqlDbType.VarChar,
                SqlDbType.VarChar,
                SqlDbType.VarChar,
                SqlDbType.VarChar,
                SqlDbType.VarChar,
                SqlDbType.VarChar,
                SqlDbType.VarChar,
                SqlDbType.VarChar,
                SqlDbType.VarChar,
                SqlDbType.VarChar,
                SqlDbType.VarChar,
                SqlDbType.VarChar,
                SqlDbType.VarChar,
                SqlDbType.VarChar,
                SqlDbType.VarChar,
                SqlDbType.VarChar,
                SqlDbType.VarChar,
                SqlDbType.VarChar,
                SqlDbType.VarChar,
                SqlDbType.VarChar,
                SqlDbType.VarChar,
                SqlDbType.VarChar,
                SqlDbType.VarChar,
                SqlDbType.VarChar,
                SqlDbType.VarChar,
                SqlDbType.VarChar,
                SqlDbType.VarChar,
                SqlDbType.VarChar,
                SqlDbType.VarChar,
                SqlDbType.VarChar,
                SqlDbType.VarChar,
                SqlDbType.VarChar,
                SqlDbType.VarChar,
                SqlDbType.Date
            };
            con.ExecuteInsertOrUpdateOrDeleteUsingStoredProc("insert_initial_assessment", param_names, param_values, param_types);



            validation v = new validation();

            v.numbervalidation(textBox15, "this value");
            v.numbervalidation(textBox8, "this value");
            v.numbervalidation(textBox1, "this value");
            v.numbervalidation(textBox3, "this value");
            v.numbervalidation(textBox6, "this value");
            v.numbervalidation(textBox14, "this value");
            v.numbervalidation(textBox4, "this value");
            v.numbervalidation(textBox2, "this value");
            v.numbervalidation(textBox6, "this value");
            v.numbervalidation(textBox7, "this value");
            v.stringvalidation(textBox5, "this value");
            v.stringvalidation(textBox17, "this value");
            v.stringvalidation(textBox16, "this value");
            v.stringvalidation(textBox11, "this value");
            v.stringvalidation(textBox9, "this value");
            v.stringvalidation(textBox10, "this value");
            v.stringvalidation(textBox18, "this value");
            v.stringvalidation(textBox12, "this value");
            v.stringvalidation(textBox13, "this value");
            v.stringvalidation(textBox19, "this value");
            v.stringvalidation(textBox40, "this value");
            v.stringvalidation(textBox23, "this value");
            v.stringvalidation(textBox20, "this value");
            v.stringvalidation(textBox22, "this value");
            v.stringvalidation(textBox21, "this value");
            v.stringvalidation(textBox25, "this value");
            v.stringvalidation(textBox24, "this value");
            v.stringvalidation(textBox23, "this value");
            v.stringvalidation(textBox24, "this value");
            v.stringvalidation(textBox27, "this value");
            v.stringvalidation(textBox28, "this value");
            v.stringvalidation(textBox29, "this value");
            v.stringvalidation(textBox30, "this value");
            v.stringvalidation(textBox31, "this value");
            v.stringvalidation(textBox32, "this value");
            v.stringvalidation(textBox33, "this value");
            v.stringvalidation(textBox34, "this value");
            v.stringvalidation(textBox35, "this value");
            v.stringvalidation(textBox36, "this value");
            v.stringvalidation(textBox37, "this value");
            v.stringvalidation(textBox38, "this value");
            v.stringvalidation(textBox39, "this value");
            v.stringvalidation(textBox40, "this value");
            v.stringvalidation(textBox41, "this value");
            v.stringvalidation(textBox42, "this value");
            v.stringvalidation(textBox43, "this value");
            v.stringvalidation(textBox44, "this value");

            textBox1.Text  = "";
            textBox2.Text  = "";
            textBox3.Text  = "";
            textBox4.Text  = "";
            textBox5.Text  = "";
            textBox6.Text  = "";
            textBox7.Text  = "";
            textBox8.Text  = "";
            textBox9.Text  = "";
            textBox10.Text = "";
            textBox11.Text = "";
            textBox12.Text = "";
            textBox13.Text = "";
            textBox14.Text = "";
            textBox15.Text = "";
            textBox16.Text = "";
            textBox17.Text = "";
            textBox18.Text = "";
            textBox19.Text = "";
            textBox20.Text = "";
            textBox21.Text = "";
            textBox22.Text = "";
            textBox23.Text = "";
            textBox24.Text = "";
            textBox25.Text = "";
            textBox26.Text = "";
            textBox27.Text = "";
            textBox28.Text = "";
            textBox29.Text = "";
            textBox30.Text = "";
            textBox31.Text = "";
            textBox32.Text = "";
            textBox33.Text = "";
            textBox34.Text = "";
            textBox35.Text = "";
            textBox36.Text = "";
            textBox37.Text = "";
            textBox38.Text = "";
            textBox39.Text = "";
            textBox40.Text = "";
            textBox41.Text = "";
            textBox42.Text = "";
            textBox43.Text = "";
            textBox44.Text = "";
        }
示例#6
0
        private void button1_Click(object sender, EventArgs e)
        {
            Connection con = new Connection();

            con.OpenConection();


            string[] param_names = new string[] {
                "@doc_code"
                , "@inventry_id "
                , "@examination "
                , "@examination_weight "
                , "@examination_cosiciouslevl "
                , "@vitalsign_hr "
                , "@vitalsign_rr "
                , "@vitalsign_tempreture "
                , "@vitalsign_blood_pressure "
                , "@progress_note_date "
                , "@head_neck "
                , "@chest "
                , "@heart "
                , "@abdomen"
                , "@upper_and_lower_limbs "
                , "@current_medicine "
                , "@observer_doctor "
            }; // الامراض الوراثسيه والعائليه للمريض



            //  @doc_code1      @iventry id2    @examonation3          @weight4            @cosiciouslevl5        @hr 6             @rr 7              @tempreture 8          @blood pressure  9           @date10                                @head_neck11          @chest 12             @heart13            @abdomen 14            @limbs15          @current_medicine16  @DOCTOR17
            string[]    param_values = new string[]      { textBox16.Text, textBox17.Text, textBox1.Text, textBox6.Text, textBox8.Text, textBox2.Text, textBox5.Text, textBox3.Text, textBox4.Text, dateTimePicker1.Value.ToString("yyyy-MM-dd"), textBox9.Text, textBox10.Text, textBox11.Text, textBox12.Text, textBox13.Text, textBox14.Text, comboBox2.SelectedItem.ToString() };
            SqlDbType[] param_types  = new SqlDbType[] { SqlDbType.VarChar, SqlDbType.Int, SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.Date, SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.VarChar };
            con.ExecuteInsertOrUpdateOrDeleteUsingStoredProc("insert_progress_notes", param_names, param_values, param_types);


            validation v = new validation();

            v.stringvalidation(textBox1, "this value ");
            v.numbervalidation(textBox2, "this value");
            v.numbervalidation(textBox3, "this value");
            v.numbervalidation(textBox4, "this value");
            v.numbervalidation(textBox5, "this value");
            v.numbervalidation(textBox6, "this value");

            v.numbervalidation(textBox8, "this value");
            v.stringvalidation(textBox9, "this value");
            v.stringvalidation(textBox10, "this value");
            v.stringvalidation(textBox11, "this value");
            v.stringvalidation(textBox12, "this value");
            v.stringvalidation(textBox14, "this value");
            v.stringvalidation(textBox13, "this value");


            textBox1.Text = "";
            textBox2.Text = "";
            textBox3.Text = "";
            textBox4.Text = "";
            textBox5.Text = "";
            textBox6.Text = "";

            textBox8.Text  = "";
            textBox9.Text  = "";
            textBox10.Text = "";
            textBox11.Text = "";
            textBox12.Text = "";
            textBox13.Text = "";
            textBox14.Text = "";
        }