/// <summary>
/// 修改
/// </summary>
/// <returns></returns>
private int Update()
{
tuberculosis_follow_record info = GetData();
info.name = Names;
info.aichive_no = aichive_no;
info.Cardcode = id_number;
info.update_user = frmLogin.userCode;
info.update_name = frmLogin.name;
info.update_time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
string issql = @"update tuberculosis_follow_record set upload_status=0,visit_date=@visit_date,month_order=@month_order,supervisor_type=@supervisor_type,visit_type=@visit_type,symptom=@symptom,symptom_other=@symptom_other,smoke_now=@smoke_now,smoke_next=@smoke_next,drink_now=@drink_now,drink_next=@drink_next,chemotherapy_plan=@chemotherapy_plan,`usage`=@usage,drugs_type=@drugs_type,miss=@miss,untoward_effect=@untoward_effect,untoward_effect_info=@untoward_effect_info,complication=@complication,complication_info=@complication_info,transfer_treatment_department=@transfer_treatment_department,transfer_treatment_reason=@transfer_treatment_reason,twoweek_visit_result=@twoweek_visit_result,handling_suggestion=@handling_suggestion,next_visit_date=@next_visit_date,visit_doctor=@visit_doctor,stop_date=@stop_date,stop_reason=@stop_reason,must_visit_num=@must_visit_num,actual_visit_num=@actual_visit_num,must_medicine_num=@must_medicine_num,actual_medicine_num=@actual_medicine_num,medicine_rate=@medicine_rate,estimate_doctor=@estimate_doctor,update_user=@update_user,update_name=@update_name,update_time=@update_time where id=(select a.id from( select id from tuberculosis_follow_record where `name`=@name and aichive_no=@aichive_no and Cardcode=@Cardcode order by create_time desc LIMIT 1)a)";
MySqlParameter[] args = new MySqlParameter[] {
new MySqlParameter("@name", info.name),
new MySqlParameter("@aichive_no", info.aichive_no),
new MySqlParameter("@Cardcode", info.Cardcode),
new MySqlParameter("@visit_date", info.visit_date),
new MySqlParameter("@month_order", info.month_order),
new MySqlParameter("@supervisor_type", info.supervisor_type),
new MySqlParameter("@visit_type", info.visit_type),
new MySqlParameter("@symptom", info.symptom),
new MySqlParameter("@symptom_other", info.symptom_other),
new MySqlParameter("@smoke_now", info.smoke_now),
new MySqlParameter("@smoke_next", info.smoke_next),
new MySqlParameter("@drink_now", info.drink_now),
new MySqlParameter("@drink_next", info.drink_next),
new MySqlParameter("@chemotherapy_plan", info.chemotherapy_plan),
new MySqlParameter("@usage", info.usage),
new MySqlParameter("@drugs_type", info.drugs_type),
new MySqlParameter("@miss", info.miss),
new MySqlParameter("@untoward_effect", info.untoward_effect),
new MySqlParameter("@untoward_effect_info", info.untoward_effect_info),
new MySqlParameter("@complication", info.complication),
new MySqlParameter("@complication_info", info.complication_info),
new MySqlParameter("@transfer_treatment_department", info.transfer_treatment_department),
new MySqlParameter("@transfer_treatment_reason", info.transfer_treatment_reason),
new MySqlParameter("@twoweek_visit_result", info.twoweek_visit_result),
new MySqlParameter("@handling_suggestion", info.handling_suggestion),
new MySqlParameter("@next_visit_date", info.next_visit_date),
new MySqlParameter("@visit_doctor", info.visit_doctor),
new MySqlParameter("@stop_date", info.stop_date),
new MySqlParameter("@stop_reason", info.stop_reason),
new MySqlParameter("@must_visit_num", info.must_visit_num),
new MySqlParameter("@actual_visit_num", info.actual_visit_num),
new MySqlParameter("@must_medicine_num", info.must_medicine_num),
new MySqlParameter("@actual_medicine_num", info.actual_medicine_num),
new MySqlParameter("@medicine_rate", info.medicine_rate),
new MySqlParameter("@estimate_doctor", info.estimate_doctor),
new MySqlParameter("@update_user", info.update_user),
new MySqlParameter("@update_name", info.update_name),
new MySqlParameter("@update_time", info.update_time),
};
return(DbHelperMySQL.ExecuteSql(issql, args));
}
/// <summary>
/// 新增
/// </summary>
/// <returns></returns>
private int Insert()
{
if (GetCount() >= 4)
{
MessageBox.Show("已添加四次，无法再添加");
return(0);
}
tuberculosis_follow_record info = GetData();
info.name = Names;
info.aichive_no = aichive_no;
info.Cardcode = id_number;
info.id_number = id_number;
info.create_user = frmLogin.userCode;
info.create_name = frmLogin.name;
info.create_time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
info.create_org = frmLogin.organCode;
info.create_org_name = frmLogin.organName;
string issql = @"insert into tuberculosis_follow_record(id,name,aichive_no,Cardcode,id_number,visit_date,month_order,supervisor_type,visit_type,symptom,symptom_other,smoke_now,smoke_next,drink_now,drink_next,chemotherapy_plan,`usage`,drugs_type,miss,untoward_effect,untoward_effect_info,complication,complication_info,transfer_treatment_department,transfer_treatment_reason,twoweek_visit_result,handling_suggestion,next_visit_date,visit_doctor,stop_date,stop_reason,must_visit_num,actual_visit_num,must_medicine_num,actual_medicine_num,medicine_rate,estimate_doctor,create_user,create_name,create_time,create_org,create_org_name,upload_status) values(@id,@name,@aichive_no,@Cardcode,@id_number,@visit_date,@month_order,@supervisor_type,@visit_type,@symptom,@symptom_other,@smoke_now,@smoke_next,@drink_now,@drink_next,@chemotherapy_plan,@usage,@drugs_type,@miss,@untoward_effect,@untoward_effect_info,@complication,@complication_info,@transfer_treatment_department,@transfer_treatment_reason,@twoweek_visit_result,@handling_suggestion,@next_visit_date,@visit_doctor,@stop_date,@stop_reason,@must_visit_num,@actual_visit_num,@must_medicine_num,@actual_medicine_num,@medicine_rate,@estimate_doctor,@create_user,@create_name,@create_time,@create_org,@create_org_name,@upload_status)";
MySqlParameter[] args = new MySqlParameter[] {
new MySqlParameter("@id", info.id),
new MySqlParameter("@name", info.name),
new MySqlParameter("@aichive_no", info.aichive_no),
new MySqlParameter("@Cardcode", info.Cardcode),
new MySqlParameter("@id_number", info.id_number),
new MySqlParameter("@visit_date", info.visit_date),
new MySqlParameter("@month_order", info.month_order),
new MySqlParameter("@supervisor_type", info.supervisor_type),
new MySqlParameter("@visit_type", info.visit_type),
new MySqlParameter("@symptom", info.symptom),
new MySqlParameter("@symptom_other", info.symptom_other),
new MySqlParameter("@smoke_now", info.smoke_now),
new MySqlParameter("@smoke_next", info.smoke_next),
new MySqlParameter("@drink_now", info.drink_now),
new MySqlParameter("@drink_next", info.drink_next),
new MySqlParameter("@chemotherapy_plan", info.chemotherapy_plan),
new MySqlParameter("@usage", info.usage),
new MySqlParameter("@drugs_type", info.drugs_type),
new MySqlParameter("@miss", info.miss),
new MySqlParameter("@untoward_effect", info.untoward_effect),
new MySqlParameter("@untoward_effect_info", info.untoward_effect_info),
new MySqlParameter("@complication", info.complication),
new MySqlParameter("@complication_info", info.complication_info),
new MySqlParameter("@transfer_treatment_department", info.transfer_treatment_department),
new MySqlParameter("@transfer_treatment_reason", info.transfer_treatment_reason),
new MySqlParameter("@twoweek_visit_result", info.twoweek_visit_result),
new MySqlParameter("@handling_suggestion", info.handling_suggestion),
new MySqlParameter("@next_visit_date", info.next_visit_date),
new MySqlParameter("@visit_doctor", info.visit_doctor),
new MySqlParameter("@stop_date", info.stop_date),
new MySqlParameter("@stop_reason", info.stop_reason),
new MySqlParameter("@must_visit_num", info.must_visit_num),
new MySqlParameter("@actual_visit_num", info.actual_visit_num),
new MySqlParameter("@must_medicine_num", info.must_medicine_num),
new MySqlParameter("@actual_medicine_num", info.actual_medicine_num),
new MySqlParameter("@medicine_rate", info.medicine_rate),
new MySqlParameter("@estimate_doctor", info.estimate_doctor),
new MySqlParameter("@create_user", info.create_user),
new MySqlParameter("@create_name", info.create_name),
new MySqlParameter("@create_org", info.create_org),
new MySqlParameter("@create_org_name", info.create_org_name),
new MySqlParameter("@create_time", info.create_time),
new MySqlParameter("@upload_status", "0"),
};
return(DbHelperMySQL.ExecuteSql(issql, args));
}
/// <summary>
/// 获取界面数据
/// </summary>
/// <returns></returns>
private tuberculosis_follow_record GetData()
{
tuberculosis_follow_record info = new tuberculosis_follow_record();
info.visit_date = 随访时间1.Value.ToString("yyyy-MM-dd HH:mm:ss");
info.month_order = string.IsNullOrWhiteSpace(治疗月序1.Text) ? 0 : Convert.ToInt32(治疗月序1.Text);
foreach (Control item in 督导人员1.Controls)
{
if (item is RadioButton)
{
if (((RadioButton)item).Checked)
{
info.supervisor_type = ((RadioButton)item).Tag.ToString();
}
}
}
foreach (Control item in 随访方式1.Controls)
{
if (item is RadioButton)
{
if (((RadioButton)item).Checked)
{
info.visit_type = ((RadioButton)item).Tag.ToString();
}
}
}
string symptom = string.Empty;
foreach (Control item in 症状及体征1.Controls)
{
if (item is CheckBox)
{
if (((CheckBox)item).Checked)
{
symptom += ((CheckBox)item).Tag.ToString() + ",";
}
}
else if (item is RichTextBox)
{
info.symptom_other = ((RichTextBox)item).Text;
}
}
info.symptom = symptom.TrimEnd(',');
info.smoke_now = string.IsNullOrWhiteSpace(吸烟a1.Text) ? 0 : Convert.ToInt32(吸烟a1.Text);
info.smoke_next = string.IsNullOrWhiteSpace(吸烟a2.Text) ? 0 : Convert.ToInt32(吸烟a2.Text);
info.drink_now = string.IsNullOrWhiteSpace(饮酒a1.Text) ? 0 : Convert.ToInt32(饮酒a1.Text);
info.drink_next = string.IsNullOrWhiteSpace(饮酒a2.Text) ? 0 : Convert.ToInt32(饮酒a2.Text);
info.chemotherapy_plan = 化疗方案1.Text;
foreach (Control item in 用法1.Controls)
{
if (item is RadioButton)
{
if (((RadioButton)item).Checked)
{
info.usage = ((RadioButton)item).Tag.ToString();
}
}
}
foreach (Control item in 药品剂型1.Controls)
{
if (item is RadioButton)
{
if (((RadioButton)item).Checked)
{
info.drugs_type = ((RadioButton)item).Tag.ToString();
}
}
}
info.miss = Convert.ToInt32(string.IsNullOrWhiteSpace(漏服药次数1.Text) ? "0" : 漏服药次数1.Text);
foreach (Control item in 药物不良反应1.Controls)
{
if (item is RadioButton)
{
if (((RadioButton)item).Checked)
{
info.untoward_effect = ((RadioButton)item).Tag.ToString();
}
}
else if (item is TextBox)
{
if (((TextBox)item).Name == "药物不良反应有1")
{
info.untoward_effect_info = ((TextBox)item).Text.ToString();
}
}
}
info.transfer_treatment_department = 转诊科别1.Text;
info.transfer_treatment_reason = 转诊原因1.Text;
info.twoweek_visit_result = 转诊结果1.Text;
info.handling_suggestion = 处理意见1.Text;
info.next_visit_date = 次随访时间1.Value.ToString("yyyy-MM-dd HH:mm:ss");
info.visit_doctor = 随访医生签名1.Text;
string stop_reason = string.Empty;
foreach (Control item in 停止治疗原因1.Controls)
{
if (item is CheckBox)
{
if (((CheckBox)item).Checked)
{
stop_reason += ((CheckBox)item).Tag.ToString() + ",";
}
}
}
info.stop_reason = stop_reason.TrimEnd(',');
info.stop_date = 出现停止治疗时间1.Value.ToString("yyyy-MM-dd HH:mm:ss");
info.must_visit_num = string.IsNullOrWhiteSpace(应访视患者次数1.Text) ? 0 : Convert.ToInt32(应访视患者次数1.Text);
info.actual_visit_num = string.IsNullOrWhiteSpace(实际访视次数1.Text) ? 0 : Convert.ToInt32(实际访视次数1.Text);
info.must_medicine_num = string.IsNullOrWhiteSpace(应服药次数1.Text) ? 0 : Convert.ToInt32(应服药次数1.Text);
info.actual_medicine_num = string.IsNullOrWhiteSpace(实际服药次数1.Text) ? 0 : Convert.ToInt32(实际服药次数1.Text);
info.medicine_rate = 药率1.Text;
return(info);
}