public bool aUfuv_hypertension(bean.fuv_hypertensionBean hm, string id, DataTable goodsList) { int ret = 0; String sql = ""; String sql0 = ""; if (id == "") { id = Result.GetNewId(); sql = @"insert into fuv_hypertension (id,aichive_no,Cardcode,Codebar,SocialSecuritycode,patientName,patientAge,dataSate,hypertension_code,visit_date,visit_type,symptom,other_symptom,sbp,dbp,weight,target_weight,bmi,target_bmi,heart_rate,other_sign,smoken,target_somken,wine,target_wine,sport_week,sport_once,target_sport_week,target_sport_once,salt_intake,target_salt_intake,mind_adjust,doctor_obey,assist_examine,drug_obey,untoward_effect,untoward_effect_drug,visit_class,referral_code,next_visit_date,visit_doctor,advice,create_name,create_time,update_name,update_time,transfer_organ,transfer_reason) values "; sql += @" ('" + id + "','" + hm.aichive_no + "', '" + hm.Cardcode + "', '" + hm.Codebar + "', '" + hm.SocialSecuritycode + "', '" + hm.patientName + "', '" + hm.patientAge + "', '" + hm.dataSate + "', '" + hm.hypertension_code + "', '" + hm.visit_date + "', '" + hm.visit_type + "','" + hm.symptom + "', '" + hm.other_symptom + "', '" + hm.sbp + "', '" + hm.dbp + "', '" + hm.weight + "', '" + hm.target_weight + "', '" + hm.bmi + "', '" + hm.target_bmi + "', '" + hm.heart_rate + "', '" + hm.other_sign + "','" + hm.smoken + "', '" + hm.target_somken + "', '" + hm.wine + "', '" + hm.target_wine + "', '" + hm.sport_week + "', '" + hm.sport_once + "', '" + hm.target_sport_week + "', '" + hm.target_sport_once + "', '" + hm.salt_intake + "', '" + hm.target_salt_intake + "','" + hm.mind_adjust + "', '" + hm.doctor_obey + "', '" + hm.assist_examine + "', '" + hm.drug_obey + "', '" + hm.untoward_effect + "', '" + hm.untoward_effect_drug + "', '" + hm.visit_class + "', '" + hm.referral_code + "', '" + hm.next_visit_date + "', '" + hm.visit_doctor + "','" + hm.advice + "', '" + hm.create_name + "', '" + hm.create_time + "', '" + hm.update_name + "', '" + hm.update_time + "', '" + hm.transfer_organ + "', '" + hm.transfer_reason + "')"; if (goodsList.Rows.Count > 0) { for (int i = 0; i < goodsList.Rows.Count; i++) { if (i == 0) { sql0 += "insert into follow_medicine_record(follow_id,drug_name,num,dosage) values ('" + id + "','" + goodsList.Rows[i]["drug_name"] + "','" + goodsList.Rows[i]["num"] + "','" + goodsList.Rows[i]["dosage"] + "')"; } else { sql0 += ",('" + id + "','" + goodsList.Rows[i]["drug_name"] + "','" + goodsList.Rows[i]["num"] + "','" + goodsList.Rows[i]["dosage"] + "')"; } } } } else { sql = @"update fuv_hypertension set aichive_no ='" + hm.aichive_no + "',Cardcode='" + hm.Cardcode + "',Codebar='" + hm.Codebar + "',SocialSecuritycode='" + hm.SocialSecuritycode + "',patientName='" + hm.patientName + "',patientAge='" + hm.patientAge + "',dataSate='" + hm.dataSate + "',hypertension_code='" + hm.hypertension_code + "',visit_date='" + hm.visit_date + "',visit_type='" + hm.visit_type + "',symptom='" + hm.symptom + "',other_symptom='" + hm.other_symptom + "',sbp='" + hm.sbp + "',dbp='" + hm.dbp + "',weight='" + hm.weight + "',target_weight='" + hm.target_weight + "',bmi='" + hm.bmi + "',target_bmi='" + hm.target_bmi + "',heart_rate='" + hm.heart_rate + "',other_sign= '" + hm.other_sign + "',smoken='" + hm.smoken + "',target_somken='" + hm.target_somken + "',wine= '" + hm.wine + "',target_wine= '" + hm.target_wine + "',sport_week='" + hm.sport_week + "',sport_once='" + hm.sport_once + "',target_sport_week= '" + hm.target_sport_week + "',target_sport_once='" + hm.target_sport_once + "',salt_intake='" + hm.salt_intake + "',target_salt_intake='" + hm.target_salt_intake + "',mind_adjust='" + hm.mind_adjust + "',doctor_obey= '" + hm.doctor_obey + "',assist_examine='" + hm.assist_examine + "',drug_obey='" + hm.drug_obey + "',untoward_effect='" + hm.untoward_effect + "',untoward_effect_drug='" + hm.untoward_effect_drug + "',visit_class='" + hm.visit_class + "',referral_code='" + hm.referral_code + "',next_visit_date='" + hm.next_visit_date + "',visit_doctor='" + hm.visit_doctor + "',advice='" + hm.advice + "',create_name='" + hm.create_name + "',create_time='" + hm.create_time + "',update_name='" + hm.update_name + "',update_time='" + hm.update_time + "',transfer_organ='" + hm.transfer_organ + "',transfer_reason='" + hm.transfer_reason + "' where id = '" + id + "'"; sql0 = @"delete from follow_medicine_record where follow_id = '" + id + "';"; if (goodsList.Rows.Count > 0) { for (int i = 0; i < goodsList.Rows.Count; i++) { if (i == 0) { sql0 += "insert into follow_medicine_record(follow_id,drug_name,num,dosage) values ('" + id + "','" + goodsList.Rows[i]["drug_name"] + "','" + goodsList.Rows[i]["num"] + "','" + goodsList.Rows[i]["dosage"] + "')"; } else { sql0 += ",('" + id + "','" + goodsList.Rows[i]["drug_name"] + "','" + goodsList.Rows[i]["num"] + "','" + goodsList.Rows[i]["dosage"] + "')"; } } } } if (sql0 != "") { DbHelperMySQL.ExecuteSql(sql0); } ret = DbHelperMySQL.ExecuteSql(sql); return(ret == 0 ? false : true); }
private void button4_Click(object sender, EventArgs e) { bean.fuv_hypertensionBean fuv_hypertensionBean = new bean.fuv_hypertensionBean(); fuv_hypertensionBean.patientName = this.textBox1.Text.Replace(" ", ""); fuv_hypertensionBean.aichive_no = this.textBox2.Text.Replace(" ", ""); fuv_hypertensionBean.visit_date = this.dateTimePicker1.Value.ToString(); if (this.radioButton1.Checked == true) { fuv_hypertensionBean.visit_type = this.radioButton1.Text; } ; if (this.radioButton2.Checked == true) { fuv_hypertensionBean.visit_type = this.radioButton2.Text; } ; if (this.radioButton3.Checked == true) { fuv_hypertensionBean.visit_type = this.radioButton3.Text; } ; foreach (Control ctr in this.panel2.Controls) { //判断该控件是不是CheckBox if (ctr is CheckBox) { //将ctr转换成CheckBox并赋值给ck CheckBox ck = ctr as CheckBox; if (ck.Checked) { fuv_hypertensionBean.symptom += "," + ck.Text; } } } if (fuv_hypertensionBean.symptom != null && fuv_hypertensionBean.symptom != "") { fuv_hypertensionBean.symptom = fuv_hypertensionBean.symptom.Substring(1); } fuv_hypertensionBean.other_symptom = this.richTextBox1.Text; fuv_hypertensionBean.sbp = this.numericUpDown9.Value.ToString(); fuv_hypertensionBean.dbp = this.numericUpDown10.Value.ToString(); fuv_hypertensionBean.weight = this.numericUpDown11.Value.ToString(); fuv_hypertensionBean.target_weight = this.numericUpDown12.Value.ToString(); fuv_hypertensionBean.bmi = this.numericUpDown14.Value.ToString(); fuv_hypertensionBean.target_bmi = this.numericUpDown15.Value.ToString(); fuv_hypertensionBean.heart_rate = this.numericUpDown16.Value.ToString(); fuv_hypertensionBean.other_sign = this.richTextBox3.Text; fuv_hypertensionBean.smoken = this.numericUpDown1.Value.ToString(); fuv_hypertensionBean.target_somken = this.numericUpDown2.Value.ToString(); fuv_hypertensionBean.wine = this.numericUpDown3.Value.ToString(); fuv_hypertensionBean.target_wine = this.numericUpDown4.Value.ToString(); fuv_hypertensionBean.sport_week = this.numericUpDown5.Value.ToString(); fuv_hypertensionBean.sport_once = this.numericUpDown6.Value.ToString(); fuv_hypertensionBean.target_sport_week = this.numericUpDown7.Value.ToString(); fuv_hypertensionBean.target_sport_once = this.numericUpDown8.Value.ToString(); if (this.radioButton4.Checked == true) { fuv_hypertensionBean.salt_intake = this.radioButton4.Text; } ; if (this.radioButton5.Checked == true) { fuv_hypertensionBean.salt_intake = this.radioButton5.Text; } ; if (this.radioButton6.Checked == true) { fuv_hypertensionBean.salt_intake = this.radioButton6.Text; } ; if (this.radioButton7.Checked == true) { fuv_hypertensionBean.target_salt_intake = this.radioButton7.Text; } ; if (this.radioButton8.Checked == true) { fuv_hypertensionBean.target_salt_intake = this.radioButton8.Text; } ; if (this.radioButton9.Checked == true) { fuv_hypertensionBean.target_salt_intake = this.radioButton9.Text; } ; if (this.radioButton10.Checked == true) { fuv_hypertensionBean.mind_adjust = this.radioButton10.Text; } ; if (this.radioButton11.Checked == true) { fuv_hypertensionBean.mind_adjust = this.radioButton11.Text; } ; if (this.radioButton12.Checked == true) { fuv_hypertensionBean.mind_adjust = this.radioButton12.Text; } ; if (this.radioButton13.Checked == true) { fuv_hypertensionBean.doctor_obey = this.radioButton13.Text; } ; if (this.radioButton14.Checked == true) { fuv_hypertensionBean.doctor_obey = this.radioButton14.Text; } ; if (this.radioButton15.Checked == true) { fuv_hypertensionBean.doctor_obey = this.radioButton15.Text; } ; fuv_hypertensionBean.assist_examine = this.textBox3.Text.Replace(" ", ""); if (this.radioButton22.Checked == true) { fuv_hypertensionBean.drug_obey = this.radioButton22.Text; } ; if (this.radioButton23.Checked == true) { fuv_hypertensionBean.drug_obey = this.radioButton23.Text; } ; if (this.radioButton24.Checked == true) { fuv_hypertensionBean.drug_obey = this.radioButton24.Text; } ; if (this.radioButton16.Checked == true) { fuv_hypertensionBean.untoward_effect = this.radioButton16.Text; } ; if (this.radioButton17.Checked == true) { fuv_hypertensionBean.untoward_effect = this.radioButton17.Text; } ; fuv_hypertensionBean.untoward_effect_drug = this.textBox8.Text.Replace(" ", ""); if (this.radioButton18.Checked == true) { fuv_hypertensionBean.visit_class = this.radioButton18.Text; } ; if (this.radioButton19.Checked == true) { fuv_hypertensionBean.visit_class = this.radioButton19.Text; } ; if (this.radioButton20.Checked == true) { fuv_hypertensionBean.visit_class = this.radioButton20.Text; } ; if (this.radioButton21.Checked == true) { fuv_hypertensionBean.visit_class = this.radioButton21.Text; } ; if (fuv_hypertensionBean.visit_class == "") { MessageBox.Show("随访分类不能为空!"); return; } ; fuv_hypertensionBean.advice = this.richTextBox2.Text; fuv_hypertensionBean.transfer_reason = this.textBox5.Text.Replace(" ", ""); fuv_hypertensionBean.transfer_organ = this.textBox6.Text.Replace(" ", ""); fuv_hypertensionBean.next_visit_date = this.dateTimePicker2.Value.ToString(); fuv_hypertensionBean.visit_doctor = this.textBox7.Text.Replace(" ", ""); //以下页面未用 数据库字段格式要求 //Cardcode,Codebar,SocialSecuritycode,patientAge,dataSate,hypertension_code,referral_code,create_name,create_time,update_name,update_time fuv_hypertensionBean.create_time = DateTime.Now.ToString(); fuv_hypertensionBean.update_time = DateTime.Now.ToString(); bool isfalse = hypertensionPatient.aUfuv_hypertension(fuv_hypertensionBean, id, goodsList); if (isfalse) { this.DialogResult = DialogResult.OK; } }
public bool aUfuv_hypertension(bean.fuv_hypertensionBean hm, string id, DataTable goodsList) { return(hPD.aUfuv_hypertension(hm, id, goodsList)); }