public bool addPhysicalExaminationRecord1(physical_examination_recordBean per)
{
int ret = 0;
String sql = @"update physical_examination_record set symptom='" + per.symptom + "',symptom_other='" + per.symptom_other + "',base_temperature='"
+ per.base_temperature + "',base_heartbeat='" + per.base_heartbeat + "',base_respiratory='" + per.base_respiratory + "',base_blood_pressure_left_high='"
+ per.base_blood_pressure_left_high + "',base_blood_pressure_left_low='" + per.base_blood_pressure_left_low + "',base_blood_pressure_right_high='"
+ per.base_blood_pressure_right_high + "',base_blood_pressure_right_low= '" + per.base_blood_pressure_right_low + "',base_height='"
+ per.base_height + "',base_weight='" + per.base_weight + "',base_waist='" + per.base_waist + "',base_bmi= '" + per.base_bmi
+ "',base_health_estimate= '" + per.base_health_estimate + "',base_selfcare_estimate= '" + per.base_selfcare_estimate + "',base_cognition_estimate='"
+ per.base_cognition_estimate + "',base_cognition_score= '" + per.base_cognition_score + "',base_feeling_estimate='" + per.base_feeling_estimate
+ "',base_feeling_score='" + per.base_feeling_score + "',base_doctor='" + per.base_doctor + "',lifeway_exercise_frequency='" + per.lifeway_exercise_frequency
+ "',lifeway_exercise_time='" + per.lifeway_exercise_time + "',lifeway_exercise_year='" + per.lifeway_exercise_year + "',lifeway_exercise_type='" + per.lifeway_exercise_type
+ "',lifeway_diet='" + per.lifeway_diet + "',lifeway_smoke_status='" + per.lifeway_smoke_status + "',lifeway_smoke_number='" + per.lifeway_smoke_number
+ "',lifeway_smoke_startage='" + per.lifeway_smoke_startage + "',lifeway_smoke_endage='" + per.lifeway_smoke_endage + "',lifeway_drink_status='" + per.lifeway_drink_status
+ "',lifeway_drink_number='" + per.lifeway_drink_number + "',lifeway_drink_stop='" + per.lifeway_drink_stop + "',lifeway_drink_stopage='" + per.lifeway_drink_stopage
+ "',lifeway_drink_startage='" + per.lifeway_drink_startage + "',lifeway_drink_oneyear='" + per.lifeway_drink_oneyear + "',lifeway_drink_type='" + per.lifeway_drink_type
+ "',lifeway_drink_other='" + per.lifeway_drink_other + "',lifeway_occupational_disease='" + per.lifeway_occupational_disease + "',lifeway_job='" + per.lifeway_job
+ "',lifeway_job_period='" + per.lifeway_job_period + "',lifeway_hazardous_dust='" + per.lifeway_hazardous_dust + "',lifeway_dust_preventive='" + per.lifeway_dust_preventive
+ "',lifeway_hazardous_radiation='" + per.lifeway_hazardous_radiation + "',lifeway_radiation_preventive='" + per.lifeway_radiation_preventive + "',lifeway_hazardous_physical='"
+ per.lifeway_hazardous_physical + "',lifeway_physical_preventive='" + per.lifeway_physical_preventive + "',lifeway_hazardous_chemical='" + per.lifeway_hazardous_chemical
+ "',lifeway_chemical_preventive='" + per.lifeway_chemical_preventive + "',lifeway_hazardous_other='" + per.lifeway_hazardous_other + "',lifeway_other_preventive='" + per.lifeway_other_preventive
+ "',lifeway_doctor='" + per.lifeway_doctor + "',upload_status =0 where id = '" + per.id + "'";
ret = DbHelperMySQL.ExecuteSql(sql);
using (System.IO.StreamWriter sw = new System.IO.StreamWriter(Application.StartupPath + "/log.txt", true))
{
sw.WriteLine(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss ") + "\r\n" + sql);
}
return(ret == 0 ? false : true);
}
//添加健康体检表 第二页
public bool addPhysicalExaminationRecord2(physical_examination_recordBean per)
{
int ret = 0;
String sql = @"update physical_examination_record set organ_lips='" + per.organ_lips + "',organ_tooth='" + per.organ_tooth + "',organ_hypodontia='"
+ per.organ_hypodontia + "',organ_hypodontia_topleft='" + per.organ_hypodontia_topleft + "',organ_hypodontia_topright='" + per.organ_hypodontia_topright + "',organ_hypodontia_bottomleft='" + per.organ_hypodontia_bottomleft + "',organ_hypodontia_bottomright='" + per.organ_hypodontia_bottomright
+ "',organ_caries='" + per.organ_caries + "',organ_caries_topleft='" + per.organ_caries_topleft + "',organ_caries_topright='" + per.organ_caries_topright + "',organ_caries_bottomleft='" + per.organ_caries_bottomleft + "',organ_caries_bottomright='" + per.organ_caries_bottomright
+ "',organ_denture='" + per.organ_denture + "',organ_denture_topleft='" + per.organ_denture_topleft + "',organ_denture_topright='" + per.organ_denture_topright + "',organ_denture_bottomleft='" + per.organ_denture_bottomleft + "',organ_denture_bottomright='" + per.organ_denture_bottomright
+ "',organ_guttur='" + per.organ_guttur + "',organ_vision_left='" + per.organ_vision_left + "',organ_vision_right='"
+ per.organ_vision_right + "',organ_correctedvision_left= '" + per.organ_correctedvision_left + "',organ_correctedvision_right='"
+ per.organ_correctedvision_right + "',organ_hearing='" + per.organ_hearing + "',organ_movement='" + per.organ_movement + "',examination_eye= '" + per.examination_eye
+ "',examination_eye_other= '" + per.examination_eye_other + "',examination_skin= '" + per.examination_skin + "',examination_skin_other='"
+ per.examination_skin_other + "',examination_sclera= '" + per.examination_sclera + "',examination_sclera_other='" + per.examination_sclera_other
+ "',examination_lymph='" + per.examination_lymph + "',examination_lymph_other='" + per.examination_lymph_other + "',examination_barrel_chest='" + per.examination_barrel_chest
+ "',examination_breath_sounds='" + per.examination_breath_sounds + "',examination_breath_other='" + per.examination_breath_other + "',examination_rale='" + per.examination_rale
+ "',examination_rale_other='" + per.examination_rale_other + "',examination_heart_rate='" + per.examination_heart_rate + "',examination_heart_rhythm='" + per.examination_heart_rhythm
+ "',examination_heart_noise='" + per.examination_heart_noise + "',examination_noise_other='" + per.examination_noise_other + "',examination_abdomen_tenderness='" + per.examination_abdomen_tenderness
+ "',examination_tenderness_memo='" + per.examination_tenderness_memo + "',examination_abdomen_mass='" + per.examination_abdomen_mass + "',examination_mass_memo='" + per.examination_mass_memo
+ "',examination_abdomen_hepatomegaly='" + per.examination_abdomen_hepatomegaly + "',examination_hepatomegaly_memo='" + per.examination_hepatomegaly_memo + "',examination_abdomen_splenomegaly='" + per.examination_abdomen_splenomegaly
+ "',examination_splenomegaly_memo='" + per.examination_splenomegaly_memo + "',examination_abdomen_shiftingdullness='" + per.examination_abdomen_shiftingdullness + "',examination_shiftingdullness_memo='" + per.examination_shiftingdullness_memo
+ "',examination_lowerextremity_edema='" + per.examination_lowerextremity_edema + "',examination_dorsal_artery='" + per.examination_dorsal_artery + "',examination_anus='" + per.examination_anus
+ "',examination_anus_other='" + per.examination_anus_other + "',examination_breast='" + per.examination_breast + "',examination_breast_other='"
+ per.examination_breast_other + "',examination_woman_vulva='" + per.examination_woman_vulva + "',examination_vulva_memo='" + per.examination_vulva_memo
+ "',examination_woman_vagina='" + per.examination_woman_vagina + "',examination_vagina_memo='" + per.examination_vagina_memo + "',examination_woman_cervix='" + per.examination_woman_cervix
+ "',examination_cervix_memo='" + per.examination_cervix_memo + "',examination_woman_corpus='" + per.examination_woman_corpus + "',examination_corpus_memo='" + per.examination_corpus_memo + "',examination_woman_accessories='" + per.examination_woman_accessories
+ "',examination_accessories_memo='" + per.examination_accessories_memo + "',examination_other='" + per.examination_other + "',blood_hemoglobin ='" + per.blood_hemoglobin + "',blood_leukocyte='" + per.blood_leukocyte + "',blood_platelet='" + per.blood_platelet + "',blood_other='" + per.blood_other + "',urine_protein='" +
per.urine_protein + "',glycosuria='" + per.glycosuria + "',urine_acetone_bodies='" + per.urine_acetone_bodies + "',bld='" + per.bld + "',urine_other='" + per.urine_other + "',blood_glucose_mmol='" + per.blood_glucose_mmol + "' ,blood_glucose_mg='" + per.blood_glucose_mg + "',cardiogram='" + per.cardiogram
+ "',cardiogram_memo='" + per.cardiogram_memo + "',upload_status=0 where id = '" + per.id + "'";
ret = DbHelperMySQL.ExecuteSql(sql);
return(ret == 0 ? false : true);
}
//添加健康体检表 第四页
public bool addPhysicalExaminationRecord4(physical_examination_recordBean per, DataTable goodsList, DataTable goodsListym)
{
int ret = 0;
String sql = @"update physical_examination_record set health_evaluation='" + per.health_evaluation + "',abnormal1='" + per.abnormal1 + "',abnormal2='"
+ per.abnormal2 + "',abnormal3='" + per.abnormal3 + "',abnormal4='" + per.abnormal4 + "',health_guidance='"
+ per.health_guidance + "',danger_controlling='" + per.danger_controlling + "',target_weight='"
+ per.target_weight + "',advise_bacterin= '" + per.advise_bacterin + "',danger_controlling_other='"
+ per.danger_controlling_other + "',healthAdvice='" + per.healthAdvice + "',create_user='******',create_name='" + frmLogin.name + "',create_org='" + frmLogin.organCode + "',create_org_name='" + frmLogin.organName + "',update_user='******',update_name='" + frmLogin.name + "',update_time='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "',upload_status=0 where id = '" + per.id + "'";
ret = DbHelperMySQL.ExecuteSql(sql);
if (ret > 0)
{
if (goodsList.Rows.Count > 0)
{
string sql1 = "delete from take_medicine_record where exam_id = '" + per.id + "';";
DbHelperMySQL.ExecuteSql(sql1);
string sql0 = "";
for (int i = 0; i < goodsList.Rows.Count; i++)
{
if (i == 0)
{
sql0 += "insert into take_medicine_record(id,exam_id,archive_no,id_number,medicine_name,medicine_usage,medicine_dosage,medicine_time,medicine_compliance,create_org,create_name,create_time) values ('" + Result.GetNewId() + "','" + per.id + "','" + per.aichive_no + "','" + per.id_number + "','" + goodsList.Rows[i]["drug_name"] + "','" + goodsList.Rows[i]["drug_usage"] + "','" + goodsList.Rows[i]["drug_use"] + "','" + goodsList.Rows[i]["drug_time"] + "','" + goodsList.Rows[i]["drug_type"] + "','" + frmLogin.userCode + "','" + frmLogin.name + "','" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "')";
}
else
{
sql0 += ",('" + Result.GetNewId() + "','" + per.id + "','" + per.aichive_no + "','" + per.id_number + "','" + goodsList.Rows[i]["drug_name"] + "','" + goodsList.Rows[i]["drug_usage"] + "','" + goodsList.Rows[i]["drug_use"] + "','" + goodsList.Rows[i]["drug_time"] + "','" + goodsList.Rows[i]["drug_type"] + "','" + frmLogin.userCode + "','" + frmLogin.name + "','" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "')";
}
}
DbHelperMySQL.ExecuteSql(sql0);
}
if (goodsListym.Rows.Count > 0)
{
string sql1 = "delete from vaccination_record where exam_id = '" + per.id + "';";
DbHelperMySQL.ExecuteSql(sql1);
string sql0 = "";
for (int i = 0; i < goodsListym.Rows.Count; i++)
{
if (i == 0)
{
sql0 += "insert into vaccination_record(id,exam_id,archive_no,id_number,vaccination_name,vaccination_time,vaccination_organ_name,create_name,create_time) values ('" + Result.GetNewId() + "','" + per.id + "','" + per.aichive_no + "','" + per.id_number + "','" + goodsListym.Rows[i]["vaccination_name"] + "','" + goodsListym.Rows[i]["vaccination_time"] + "','" + goodsListym.Rows[i]["vaccination_organ_name"] + "','" + frmLogin.name + "','" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "')";
}
else
{
sql0 += ",('" + Result.GetNewId() + "','" + per.id + "','" + per.aichive_no + "','" + per.id_number + "','" + goodsListym.Rows[i]["vaccination_name"] + "','" + goodsListym.Rows[i]["vaccination_time"] + "','" + goodsListym.Rows[i]["vaccination_organ_name"] + "','" + frmLogin.name + "','" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "')";
}
}
DbHelperMySQL.ExecuteSql(sql0);
}
}
return(ret == 0 ? false : true);
}
//添加健康体检表 第三页
public bool addPhysicalExaminationRecord3(physical_examination_recordBean per)
{
int ret = 0;
String sql = @"update physical_examination_record set microalbuminuria='" + per.microalbuminuria + "',fob='" + per.fob + "',glycosylated_hemoglobin='"
+ per.glycosylated_hemoglobin + "',hb='" + per.hb + "',sgft='" + per.sgft + "',ast='"
+ per.ast + "',albumin='" + per.albumin + "',total_bilirubin='"
+ per.total_bilirubin + "',conjugated_bilirubin= '" + per.conjugated_bilirubin + "',scr='"
+ per.scr + "',blood_urea='" + per.blood_urea + "',blood_k='" + per.blood_k + "',blood_na= '" + per.blood_na
+ "',tc= '" + per.tc + "',tg= '" + per.tg + "',ldl='" + per.ldl + "',hdl= '" + per.hdl + "',chest_x='" + per.chest_x
+ "',chestx_memo='" + per.chestx_memo + "',ultrasound_abdomen='" + per.ultrasound_abdomen + "',ultrasound_memo='" + per.ultrasound_memo
+ "',other_b='" + per.other_b + "',otherb_memo='" + per.otherb_memo + "',cervical_smear='" + per.cervical_smear
+ "',cervical_smear_memo='" + per.cervical_smear_memo + "',other='" + per.other + "',cerebrovascular_disease='" + per.cerebrovascular_disease
+ "',cerebrovascular_disease_other='" + per.cerebrovascular_disease_other + "',kidney_disease='" + per.kidney_disease + "',kidney_disease_other='" + per.kidney_disease_other
+ "',heart_disease='" + per.heart_disease + "',heart_disease_other ='" + per.heart_disease_other + "',vascular_disease='" + per.vascular_disease + "',vascular_disease_other='" + per.vascular_disease_other
+ "',ocular_diseases='" + per.ocular_diseases + "',ocular_diseases_other='" + per.ocular_diseases_other + "',nervous_system_disease='" + per.nervous_system_disease
+ "',nervous_disease_memo='" + per.nervous_disease_memo + "',other_disease='" + per.other_disease + "',other_disease_memo='" + per.other_disease_memo + "',upload_status=0 where id = '" + per.id + "'";
ret = DbHelperMySQL.ExecuteSql(sql);
return(ret == 0 ? false : true);
}
//添加健康体检表 第一页
public string GetaddPhysicalExaminationRecordSql1(physical_examination_recordBean per)
{
String sql = @"update physical_examination_record set symptom='" + per.symptom + "',symptom_other='" + per.symptom_other + "',base_temperature='"
+ per.base_temperature + "',base_heartbeat='" + per.base_heartbeat + "',base_respiratory='" + per.base_respiratory + "',base_blood_pressure_left_high='"
+ per.base_blood_pressure_left_high + "',base_blood_pressure_left_low='" + per.base_blood_pressure_left_low + "',base_blood_pressure_right_high='"
+ per.base_blood_pressure_right_high + "',base_blood_pressure_right_low= '" + per.base_blood_pressure_right_low + "',base_height='"
+ per.base_height + "',base_weight='" + per.base_weight + "',base_waist='" + per.base_waist + "',base_bmi= '" + per.base_bmi
+ "',base_health_estimate= '" + per.base_health_estimate + "',base_selfcare_estimate= '" + per.base_selfcare_estimate + "',base_cognition_estimate='"
+ per.base_cognition_estimate + "',base_cognition_score= '" + per.base_cognition_score + "',base_feeling_estimate='" + per.base_feeling_estimate
+ "',base_feeling_score='" + per.base_feeling_score + "',base_doctor='" + per.base_doctor + "',lifeway_exercise_frequency='" + per.lifeway_exercise_frequency
+ "',lifeway_exercise_time='" + per.lifeway_exercise_time + "',lifeway_exercise_year='" + per.lifeway_exercise_year + "',lifeway_exercise_type='" + per.lifeway_exercise_type
+ "',lifeway_diet='" + per.lifeway_diet + "',lifeway_smoke_status='" + per.lifeway_smoke_status + "',lifeway_smoke_number='" + per.lifeway_smoke_number
+ "',lifeway_smoke_startage='" + per.lifeway_smoke_startage + "',lifeway_smoke_endage='" + per.lifeway_smoke_endage + "',lifeway_drink_status='" + per.lifeway_drink_status
+ "',lifeway_drink_number='" + per.lifeway_drink_number + "',lifeway_drink_stop='" + per.lifeway_drink_stop + "',lifeway_drink_stopage='" + per.lifeway_drink_stopage
+ "',lifeway_drink_startage='" + per.lifeway_drink_startage + "',lifeway_drink_oneyear='" + per.lifeway_drink_oneyear + "',lifeway_drink_type='" + per.lifeway_drink_type
+ "',lifeway_drink_other='" + per.lifeway_drink_other + "',lifeway_occupational_disease='" + per.lifeway_occupational_disease + "',lifeway_job='" + per.lifeway_job
+ "',lifeway_job_period='" + per.lifeway_job_period + "',lifeway_hazardous_dust='" + per.lifeway_hazardous_dust + "',lifeway_dust_preventive='" + per.lifeway_dust_preventive
+ "',lifeway_hazardous_radiation='" + per.lifeway_hazardous_radiation + "',lifeway_radiation_preventive='" + per.lifeway_radiation_preventive + "',lifeway_hazardous_physical='"
+ per.lifeway_hazardous_physical + "',lifeway_physical_preventive='" + per.lifeway_physical_preventive + "',lifeway_hazardous_chemical='" + per.lifeway_hazardous_chemical
+ "',lifeway_chemical_preventive='" + per.lifeway_chemical_preventive + "',lifeway_hazardous_other='" + per.lifeway_hazardous_other + "',lifeway_other_preventive='" + per.lifeway_other_preventive
+ "',lifeway_doctor='" + per.lifeway_doctor + "',upload_status =0 where id = '" + per.id + "'";
return(sql);
}
