private void ShowApplyImage_Form_Load(object sender, EventArgs e)
{
try
{
// 'WindowState = FormWindowState.Maximized
ApplyImage_Class d_applyimage = new ApplyImage_Class();
if (d_applyimage.OpenPath())
{
Bitmap d_dmp =(Bitmap) Image.FromFile(CurPath);
string d_GetValue = RisSetup_Class.GetINI("setup", "ApplyImageBig");
if (d_GetValue == "")
{
d_GetValue = "0.5";
}
image_PictureBox.Width =Convert .ToInt32 ( d_dmp.Width * Convert.ToSingle(d_GetValue));
image_PictureBox.Height = Convert .ToInt32 ( d_dmp.Height * Convert.ToSingle(d_GetValue));
image_PictureBox.Image = d_dmp;
}
else
{
ShowErr_Form d_ErrForm = new ShowErr_Form("无法调出申请单图片", "错误");
d_ErrForm.ShowDialog();
Close();
}
}
catch
{
ShowErr_Form d_ErrForm = new ShowErr_Form("无法调出申请单图片", "错误");
d_ErrForm.ShowDialog();
Close();
}
Radio_doctor_TextEdit.Text = CurRadio_doctor;
}
private void Print_SimpleButton_Click(object sender, EventArgs e)
{
string d_tel, d_content, d_result;
d_tel = telephone_ComboBoxEdit.Text.Trim();
if (d_tel == "")
{
ShowErr_Form d_form = new ShowErr_Form("请填写手机号码", "错误");
d_form.ShowDialog();
telephone_ComboBoxEdit.Focus();
return;
}
try
{
d_content = Remark_MemoEdit.Text.Trim();
//KY.Interface.Message.fey_message_Class.sendMessage(d_tel, d_content);
string insertsql = "insert into sms_sendHistory(accession_no,type,SMSINFO,OPERATOR,remark) values('" + d_patexam.accessno + "','" + type_ComboBoxEdit.Text + "','" + d_content + "','" + Share_Class.User.user_id + "','" + Share_Class.GetIPAndAddress() + "')";
if (RISOracle_Class.Exec_Cand(insertsql, insertsql) == true)
{
ShowErr_Form d_form = new ShowErr_Form("发送成功", "提示");
d_form.ShowDialog();
Close();
}
}
catch (Exception ex)
{
ShowErr_Form d_form = new ShowErr_Form(ex.Message, "错误");
d_form.ShowDialog();
}
}
public ApplyImage_Class()
{
string d_strSql = "Select * from imageroad_setup";
DataSet ds =RISOracle_Class .GetDS(d_strSql, "查询imageroad_setup表出错" + "\r\n" + d_strSql);
if (ds == null)
{
ShowErr_Form d_form = new ShowErr_Form("无法得到申请单保存服务器的信息", "错误");
d_form.ShowDialog();
return;
}
if (ds.Tables.Count == 0)
{
ShowErr_Form d_form = new ShowErr_Form("申请单保存服务器的信息被破坏", "错误");
d_form.ShowDialog();
return;
}
if (ds.Tables[0].Rows.Count == 0)
{
ShowErr_Form d_form = new ShowErr_Form("申请单保存服务器的信息被破坏", "错误");
d_form.ShowDialog();
return;
}
strimage_server = ds.Tables[0].Rows[0]["image_server"].ToString().Trim();
strserver_password = ds.Tables[0].Rows[0]["server_password"].ToString().Trim();
strimage_disk = ds.Tables[0].Rows[0]["image_disk"].ToString().Trim();
strimage_file = ds.Tables[0].Rows[0]["image_file"].ToString().Trim();
}
private void LoadDataByID(string p_checkid)
{
string d_strSql = "";
d_strSql = "Select * from ReportXml where accessno='" + p_checkid.ToString().Trim() + "'";
DataSet Ds = new DataSet();
Ds = RISOracle_Class.GetDS(d_strSql, "查询ReportXml表出错" + "\r\n" + d_strSql);
if (Ds == null)
{
ShowErr_Form d_form = new ShowErr_Form("无法从数据库中取得数据", "错误");
d_form.ShowDialog();
return;
}
if (Ds.Tables.Count == 0)
{
return;
}
if (Ds.Tables[0].Rows.Count == 0)
{
return;
}
SetPropertyByDs(Ds.Tables[0].Rows[0]);
}
private void OK_SimpleButton_Click(Object sender, EventArgs e)
{
//'得到当前要处理的Dmb的信息()
CurReport_rewrite.giveup_cause = giveup_cause_ComboBoxEdit.Text.Trim();
CurReport_rewrite.result = result_ComboBoxEdit.Text.Trim();
CurReport_rewrite.describle = describle_MemoEdit.Text.Trim();
if (CurReport_rewrite.CheckErr_BeforeInsert() == false)
{ //'检查重写的数据是否有错
if (CurReport_rewrite.report_rewrite() == false)
{// '重写过程是否有错
ShowErr_Form d_form = new ShowErr_Form("重写失败", "错误");
d_form.ShowDialog();
}
else
{
ShowErr_Form d_form = new ShowErr_Form("重写成功", "提示");
d_form.ShowDialog();
// 'Share_Forms_Class.PatexamListViewForm.SetListViewRowBypatexam(CurReport_rewrite.patexam, New patregister_Class(CurReport_rewrite.patexam.patid))
Close();
}
}
else
{ //'数据有错，显示错误
try
{
ShowErr_Form d_form = new ShowErr_Form(CurReport_rewrite.Err, "错误");
d_form.ShowDialog();
}
catch { }
}
}
private void ICD10_TreeList_DoubleClick(object sender, EventArgs e)
{
try
{
if (ICD10_TreeList.Selection.Count == 0)
return;
//'取得选中的结点
TreeListNode d_Node = ICD10_TreeList.Selection[0];
if (d_Node.ParentNode == null)
{// '当前结点是部位
firstDir_typeNodeBytemplate_partNode(d_Node);
}
else if (d_Node.ParentNode.ParentNode == null)
{// '当前结点是结果归类
secondDir_nameNodeBydisease_typeNode(d_Node);
}
else if (d_Node.ParentNode.ParentNode.ParentNode == null)
{// '当前结点是结果归类
THIRD_LEVEL_NAMENodeBydisease_typeNode(d_Node);
}
else
{
if (d_Node.Nodes.Count == 0)
{
//CurReportForm.Filldiseasetype(d_Node.GetValue(0).ToString());
diseasetype_ComboBoxEdit.Text = d_Node.GetValue(0).ToString();// '得到模板
}
}
return;
}
catch (Exception ex)
{
ShowErr_Form d_form = new ShowErr_Form(ex.Message, "错误");
d_form.ShowDialog();
return;
}
}
private void Template_TreeList_Click(object sender, EventArgs e)
{
try
{
if (Template_TreeList.Selection.Count == 0)
return;
// '取得选中的结点
TreeListNode d_Node = Template_TreeList.Selection[0];
string d_strpart, d_strdisease_type, d_strtemplate;
if (d_Node.ParentNode == null)
{// ){ '当前结点是部位
}
else if (d_Node.ParentNode.ParentNode == null)
{//'当前结点是结果归类
}
else if (d_Node.Nodes.Count == 0)
{
d_strtemplate = d_Node.GetValue(0).ToString();// '得到模板
d_strdisease_type = d_Node.ParentNode.GetValue(0).ToString();// '得到结果
d_strpart = d_Node.ParentNode.ParentNode.GetValue(0).ToString();// '得到部位
report_template_Class d_template = new report_template_Class(template_grade_ComboBoxEdit.Text.Trim(), CurReportForm.CurPatexam.dep, d_strpart, d_strdisease_type, d_strtemplate);
template_describle_MemoEdit.Text = d_template.template_describle;
template_diag_MemoEdit.Text = d_template.template_diag;
}
}
catch (Exception ex)
{
ShowErr_Form d_form = new ShowErr_Form(ex.Message, "错误");
d_form.ShowDialog();
}
}
private void Newpatexam_SimpleButton_Click(object sender, EventArgs e)
{
if (clinicend_MemoEdit.Text.Length > 50)
{
ShowErr_Form d_form = new ShowErr_Form("临床诊断输入框字数太多，请重新确认", "错误");
d_form.ShowDialog();
return;
}
else
clinicend_MemoEdit.Text = Set_Special_Charcter(clinicend_MemoEdit.Text);
if (sqdep_ComboBoxEdit.Text.Length > 14)
{
ShowErr_Form d_form = new ShowErr_Form("申请科室输入框字数太多，请重新确认", "错误");
d_form.ShowDialog();
return;
}
else
sqdep_ComboBoxEdit.Text = Set_Special_Charcter(sqdep_ComboBoxEdit.Text);
if (wardno_ComboBoxEdit.Text.Length > 14)
{
ShowErr_Form d_form = new ShowErr_Form("病区输入框字数太多，请重新确认", "错误");
d_form.ShowDialog();
return;
}
else
wardno_ComboBoxEdit.Text = Set_Special_Charcter(wardno_ComboBoxEdit.Text);
if (bedno_TextEdit.Text.Length > 9)
{
ShowErr_Form d_form = new ShowErr_Form("床号输入框字数太多，请重新确认", "错误");
d_form.ShowDialog();
return;
}
else
bedno_TextEdit.Text = Set_Special_Charcter(bedno_TextEdit.Text);
if (telephone_TextEdit.Text.Length > 46)
{
ShowErr_Form d_form = new ShowErr_Form("联系电话输入框字数太多，请重新确认", "错误");
d_form.ShowDialog();
return;
}
else
telephone_TextEdit.Text = Set_Special_Charcter(telephone_TextEdit.Text);
//if (Modify_SimpleButton.Text == "修改")
//{
// patexam_Class d_patexam = new patexam_Class(CurPatexam.accessno);
// patregister_Class d_patregister = new patregister_Class(CurPatregister.clinicno);
// FillClassByInput(ref d_patexam, ref d_patregister);
// if (d_patregister.Update() == false)
// {
// ShowErr_Form d_form = new ShowErr_Form("patregister修改失败", "错误");
// d_form.ShowDialog();
// return;
// }
// else
// {
// if (d_patexam.UpdateRegister() == false)
// {
// ShowErr_Form d_form = new ShowErr_Form("patexam修改失败", "错误");
// d_form.ShowDialog();
// return;
// }
// else
// {
// ShowErr_Form d_form = new ShowErr_Form("修改成功", "提示");
// d_form.ShowDialog();
// }
// }
//}
//else
//{
// patexam_Class d_patexam = new patexam_Class();
// patregister_Class d_patregister = new patregister_Class();
// FillClassByInput(ref d_patexam, ref d_patregister);
// if (d_patregister.Insert() == false)
// {
// Public_Class.ShowErr_Form("patregister保存失败", "错误");
// ShowErr_Form d_form = new ShowErr_Form("patregister保存失败", "错误");
// d_form.ShowDialog();
// return;
// }
// else
// {
// d_patexam.accessno = d_patregister.clinicno;
// d_patexam.patid = d_patregister.clinicno;
// if (d_patexam.AddRegister("0", "") == false)
// {
// ShowErr_Form d_form = new ShowErr_Form("patexam保存失败", "错误");
// d_form.ShowDialog();
// return;
// }
// else
// {
// ShowErr_Form d_form = new ShowErr_Form("保存成功", "提示");
// d_form.ShowDialog();
// turnperson(d_patexam.patid);
// }
// }
//}
}
private bool BeforeSave(string p_status, bool p_tempflag)
{
try
{
patexam_Class p_patexam = new patexam_Class(CurReportForm.CurPatexam.accessno);
string showstr = "";
if (p_patexam.check_status == "已审核")
{
if (CurReportForm.CurPatexam.check_status != "已审核")
{
if (p_status == "保存")
{
showstr = "该报告已审核无法再保存，请退出报告界面或者重新审核";
showstr += "\r\n" + "审核医生：" + p_patexam.advancedoc + "审核时间：" + p_patexam.advancedate.ToString();
}
else
{
showstr = "该报告已审核,是否继续审核";
showstr += "\r\n" + "审核医生：" + p_patexam.advancedoc + "审核时间：" + p_patexam.advancedate.ToString();
ShowErr_Form d_form = new ShowErr_Form(showstr, "是", "否");
if (d_form.ShowDialog() == DialogResult.OK)
{
showstr = "";
}
else
return false;
}
}
}
else if (p_patexam.check_status == "未审核")
{
if ((p_patexam.reportdoc != "") && (p_patexam.reportdoc != Share_Class.User.user_id) && (p_status == "保存"))
{
showstr = "该报告已保存无法再保存，请退出报告界面或者重新审核";
showstr += "\r\n" + "报告医生：" + p_patexam.reportdoc + "报告时间：" + p_patexam.reportdate.ToString();
}
}
if (showstr != "")
{
ShowErr_Form d_form = new ShowErr_Form(showstr, "错误");
d_form.ShowDialog();
return false;
}
if (p_tempflag == true)
{
if (p_status == "保存")
{
if (Share_Class.User.HaveFunction("b") == false)
{
ShowErr_Form d_form = new ShowErr_Form("用户无此操作权限", "错误");
d_form.ShowDialog();
return false;
}
}
else
{
if (Share_Class.User.HaveFunction("c") == false)
{
ShowErr_Form d_form = new ShowErr_Form("用户无此操作权限", "错误");
d_form.ShowDialog();
return false;
}
}
}
if (CurShowApplyImage_Form != null)
{
CurShowApplyImage_Form.Close();
}
string d_template_diag = "";
string d_template_describle = "";
patexam_Class d_patexam = new patexam_Class();
CurReportForm.getTemplateContent(ref d_template_diag, ref d_template_describle, ref d_patexam);
string d_reportdisease = "";// this.ICD_10_ComboBoxEdit.Text.Trim();
if (d_reportdisease == "")
{
for (int i = 0; i < reportdisease_CheckedListBoxControl.Items.Count; i++)
{
if (reportdisease_CheckedListBoxControl.Items[i].CheckState == CheckState.Checked)
d_reportdisease += reportdisease_CheckedListBoxControl.Items[i].Value.ToString().Trim() + ",";
}
if (d_reportdisease != "")
d_reportdisease = d_reportdisease.TrimEnd(new char[] { ',' });
}
d_patexam.reportdisease = d_reportdisease;
string d_disease = diseasetype_ComboBoxEdit.Text.Trim();
if (d_disease == "")
{
for (int i = 0; i < diseasetype_CheckedListBoxControl.Items.Count; i++)
{
if (diseasetype_CheckedListBoxControl.Items[i].CheckState == CheckState.Checked)
d_disease += diseasetype_CheckedListBoxControl.Items[i].Value.ToString().Trim() + ",";
}
if (d_disease != "")
d_disease = d_disease.TrimEnd(new char[] { ',' });
}
d_patexam.diseasetype = d_disease;
if (p_tempflag == true)
{
if ((d_patexam.reportdisease != "临时报告") && (d_patexam.diseasetype == ""))
{
ShowErr_Form d_form = new ShowErr_Form("结果归类未选", "错误");
d_form.ShowDialog();
return false;
}
else
{
string d_values = RisSetup_Class.GetINI_Oracle(CurReportForm.CurPatexam.dep, "diseasetype_show");
if (d_values == "yes")
{
ShowErr_Form d_form = new ShowErr_Form("报告的结果归类为" + d_patexam.diseasetype + ",是否继续?", "是", "否");
if ((d_form.ShowDialog() != System.Windows.Forms.DialogResult.OK))
{
this.Right_XtraTabControl.SelectedTabPageIndex = 0;
return false;
}
}
else if (d_values == "")
{
RisSetup_Class.WriteINI_Oracle(CurReportForm.CurPatexam.dep, "diseasetype_show", "no");
}
}
}
// FillClassByInputXML();
if (d_template_diag == "")
{
ShowErr_Form d_form = new ShowErr_Form("诊断描述未填", "错误");
d_form.ShowDialog();
return false;
}
//else if (d_template_diag.Length > 2000)
//{
// ShowErr_Form d_form = new ShowErr_Form("诊断描述字符长度过长", "错误");
// d_form.ShowDialog();
// return false;
//}
if (d_template_describle == "")
{
ShowErr_Form d_form = new ShowErr_Form("诊断结果未填", "错误");
d_form.ShowDialog();
return false;
}
//else if (d_template_describle.Length > 2000)
//{
// Public_Class.ShowErr_Form("诊断结果字符长度过长", "错误");
// return false;
//}
else if ((p_tempflag == true) && (d_template_describle.IndexOf("左") > -1) && (d_template_describle.IndexOf("右") > -1))
{
ShowErr_Form d_form = new ShowErr_Form("报告中含有左右描述，请确认是否正确?", "是", "否");
if (d_form.ShowDialog() != System.Windows.Forms.DialogResult.OK)
{
return false;
}
}
if (p_tempflag == true)
{
ValueValidateResultList list = (ValueValidateResultList)CurReportForm.ReturnExecuteCommand("DocumentValueValidate", false, null);
if (list != null && list.Count > 0)
{ // 校验不成功
StringBuilder str = new StringBuilder();
foreach (ValueValidateResult item in list)
{
if (str.Length > 0)
{
str.Append(Environment.NewLine);
}
str.Append(item.Element.ID + ":" + item.Message);
}
ShowErr_Form d_form = new ShowErr_Form(str.ToString() + "是否继续?", "是", "否");
if (d_form.ShowDialog() != System.Windows.Forms.DialogResult.OK)
{
return false;
}
}
}
CurReportForm.CurPatexam.diseasetype = d_disease;
CurReportForm.CurPatexam.reportdisease = d_reportdisease;
////DataSet ds = Setup_Dict.setup_item_dic_dmb_Class.GetITEM("XRAY", "", CurReportForm.CurPatregister.Sex + "性错误纠正", "");
////if (ds != null)
////{
//// if (ds.Tables.Count > 0)
//// {
//// if (ds.Tables[0].Rows.Count > 0)
//// {
//// for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
//// {
//// string d_item = ds.Tables[0].Rows[i]["item"].ToString().Trim();
//// if (d_template_describle.IndexOf(d_item) > -1)
//// {
//// if (Public_Class.ShowErr_Form("该患者性别为" + CurReportForm.CurPatregister.Sex + "性，报告描述中存在" + d_item + "描述，请确认是否正确?", "是", "否") != System.Windows.Forms.DialogResult.OK)
//// {
//// return false;
//// }
//// }
//// else if (d_template_diag.IndexOf(d_item) > -1)
//// {
//// if (Public_Class.ShowErr_Form("该患者性别为" + CurReportForm.CurPatregister.Sex + "性，诊断提示中存在" + d_item + "诊断，请确认是否正确?", "是", "否") != System.Windows.Forms.DialogResult.OK)
//// {
//// return false;
//// }
//// }
//// }
//// }
//// }
////}
}
catch
{
return false;
}
return true;
}
//'根据checkid得到病人基本资料
private void LoadDataByID(int p_checkid)
{
string d_strSql = "Select * from giveup where checkid=" + p_checkid.ToString().Trim() + "";
DataSet Ds = RISOracle_Class.GetDS(d_strSql, "查询giveup表出错" + "\r\n" + d_strSql);
if (Ds == null)
{
ShowErr_Form d_form = new ShowErr_Form("重写时出错", "错误");
d_form.ShowDialog();
return;
}
if (Ds.Tables[0].Rows.Count == 0)
{
return;
}
intid = Convert.ToInt32(Ds.Tables[0].Rows[0]["id"]);
strgiveup_cause = Ds.Tables[0].Rows[0]["giveup_cause"].ToString().Trim();
strresult = Ds.Tables[0].Rows[0]["result"].ToString().Trim();
strdescrible = Ds.Tables[0].Rows[0]["describle"].ToString();
}
private void LoadModelPlanByName(string p_template_grade, string p_dep, string p_template_part, string p_disease_type, string p_template_name)
{
string d_strSql = "";
string d_Table = "";
if (p_template_grade == "公有")
{
d_Table = "report_template";
}
else
{
d_Table = "report_template_private";
}
d_strSql = "Select * from " + d_Table + " where template_name='" + p_template_name
+ "' and template_part='" + p_template_part
+ "' and dep='" + p_dep.Trim()
+ "' and disease_type='" + p_disease_type
+ "' and template_grade='" + p_template_grade + "' ";
//d_strSql += "and hospital_code='" + Share_Class.User.hospital_code + "' ";
DataSet Ds = RISOracle_Class.GetDS(d_strSql, "插入" + d_Table + "表出错" + "\r\n" + d_strSql);
if (Ds == null)
{
ShowErr_Form d_form = new ShowErr_Form("无法得到模板", "提示");
d_form.ShowDialog();
return;
}
if (Ds.Tables[0].Rows.Count == 0)
{
ShowErr_Form d_form = new ShowErr_Form("无法得到模板", "提示");
d_form.ShowDialog();
return;
}
SetPropertyByDs(Ds.Tables[0]);
}
private void LoadModelPlanByID(string p_template_grade, int p_ID)
{
string d_strSql = "";
string d_Table = "";
if (p_template_grade == "公有")
{
d_Table = "report_template";
}
else
{
d_Table = "report_template_private";
}
d_strSql = "Select * from " + d_Table + " where template_id=" + p_ID.ToString();
DataSet Ds = RISOracle_Class.GetDS(d_strSql, "查询" + d_Table + "表出错" + "\r\n" + d_strSql);
if (Ds == null)
{
ShowErr_Form d_form = new ShowErr_Form("无法得到模板", "提示");
d_form.ShowDialog();
return;
}
if (Ds.Tables[0].Rows.Count == 0)
{
ShowErr_Form d_form = new ShowErr_Form("无法得到模板", "提示");
return;
}
SetPropertyByDs(Ds.Tables[0]);
}
//引用
private void toolStripuItem1_Click(object sender, EventArgs e)
{
string d_reportinfo = "";
string d_reportend = "";
FillClassByInputXML(ref d_reportinfo, ref d_reportend);
//d_reportform.FillTemplate(d_reportinfo, d_reportend);
d_ReportEdit.CurReportForm.FillTemplate(d_reportinfo, d_reportend);
ShowErr_Form d_form = new ShowErr_Form("调用成功", "提示");
d_form.ShowDialog();
d_ReportEdit.Report_XtraTabControl.SelectedTabPage = d_ReportEdit.Report_XtraTabPage;
//d_reportform.Report_XtraTabControl.SelectedTabPage = d_reportform.Report_XtraTabPage ;
//d_ReportEdit_UserControl.Report_XtraTabControl.SelectedTabPage = d_DG_ReportEdit_UserControl.Report_XtraTabPage;
//d_ReportEdit.Report_XtraTabControlSelectedTabPage("Report_XtraTabPage");
}
private void SetPropertyByDs(DataSet Ds)
{
try
{
if (Ds == null)
{
ShowErr_Form d_form = new ShowErr_Form("无法从数据库中取得数据", "错误");
d_form.ShowDialog();
return;
}
if (Ds.Tables.Count == 0)
{
return;
}
if (Ds.Tables[0].Rows.Count == 0)
{
return;
}
intid = Convert.ToInt32(Ds.Tables[0].Rows[0]["ID"]);
strACCESSION_NO = Ds.Tables[0].Rows[0]["ACCESSION_NO"].ToString().Trim();
strPATIENT_ID = Ds.Tables[0].Rows[0]["PATIENT_ID"].ToString().Trim();
strREQUEST_DOCTOR = Ds.Tables[0].Rows[0]["REQUEST_DOCTOR"].ToString().Trim();
dateREQUEST_DTTM = Convert.IsDBNull(Ds.Tables[0].Rows[0]["REQUEST_DTTM"]) ? Convert.ToDateTime("1900-1-1") : Convert.ToDateTime(Ds.Tables[0].Rows[0]["REQUEST_DTTM"]);
strREQUEST_CAUSE = Ds.Tables[0].Rows[0]["REQUEST_CAUSE"].ToString().Trim();
strPATIENT_NAME = Ds.Tables[0].Rows[0]["PATIENT_NAME"].ToString().Trim();
strPATIENT_SEX = Ds.Tables[0].Rows[0]["PATIENT_SEX"].ToString().Trim();
strPATIENT_AGE = Ds.Tables[0].Rows[0]["PATIENT_AGE"].ToString().Trim();
strPATIENT_ADDRRESS = Ds.Tables[0].Rows[0]["PATIENT_ADDRRESS"].ToString().Trim();
strPATIENT_TELEPHONE = Ds.Tables[0].Rows[0]["PATIENT_TELEPHONE"].ToString().Trim();
strPATIENT_BIRTHDAY = Ds.Tables[0].Rows[0]["PATIENT_BIRTHDAY"].ToString().Trim();
strCHARGE_TYPE = Ds.Tables[0].Rows[0]["CHARGE_TYPE"].ToString().Trim();
strPRINT_STATUS = Ds.Tables[0].Rows[0]["PRINT_STATUS"].ToString().Trim();
strXNO = Ds.Tables[0].Rows[0]["XNO"].ToString().Trim();
strMODALITY = Ds.Tables[0].Rows[0]["MODALITY"].ToString().Trim();
strCHECK_TYPE = Ds.Tables[0].Rows[0]["CHECK_TYPE"].ToString().Trim();
dateAPPOINT_DATE = Convert.IsDBNull(Ds.Tables[0].Rows[0]["APPOINT_DATE"]) ? Convert.ToDateTime("1900-1-1") : Convert.ToDateTime(Ds.Tables[0].Rows[0]["APPOINT_DATE"]);
strEXPERT_DOCTOR = Ds.Tables[0].Rows[0]["EXPERT_DOCTOR"].ToString().Trim();
strCONSULTATION_INFO = Ds.Tables[0].Rows[0]["CONSULTATION_INFO"].ToString().Trim();
strCONSULTATION_END = Ds.Tables[0].Rows[0]["CONSULTATION_END"].ToString().Trim();
dateCONSULTATION_DATE = Convert.IsDBNull(Ds.Tables[0].Rows[0]["CONSULTATION_DATE"]) ? Convert.ToDateTime("1900-1-1") : Convert.ToDateTime(Ds.Tables[0].Rows[0]["CONSULTATION_DATE"]);
strSTATUS = Ds.Tables[0].Rows[0]["STATUS"].ToString().Trim();
strREMARK = Ds.Tables[0].Rows[0]["REMARK"].ToString().Trim();
strREMARK2 = Ds.Tables[0].Rows[0]["REMARK2"].ToString().Trim();
}
catch (Exception ex)
{
flog_Class.WriteFlog(ex.Message);
ShowErr_Form d_form = new ShowErr_Form(ex.Message, "错误");
d_form.ShowDialog();
}
}
private void ReportStyle_Form_FormClosing(object sender, FormClosingEventArgs e)
{
ShowErr_Form d_from = new ShowErr_Form("窗口将要关闭,文件还未保存,是否继续关闭","是","否");
if (d_from.ShowDialog() != DialogResult.OK)
{
e.Cancel = true ;
}
}
public void SetPropertyByDs(DataSet p_Ds)
{
if (p_Ds == null)
{
ShowErr_Form d_form = new ShowErr_Form("无法从数据库中取得数据", "错误");
d_form.ShowDialog();
return;
}
if (p_Ds.Tables.Count == 0)
{
return;
}
if (p_Ds.Tables[0].Rows.Count == 0)
{
return;
}
intid = Convert.ToInt32(p_Ds.Tables[0].Rows[0]["ID"]);
strBITMAP_ONE = p_Ds.Tables[0].Rows[0]["BITMAP_ONE"].ToString().Trim();
strBITMAP_TWO = p_Ds.Tables[0].Rows[0]["BITMAP_TWO"].ToString().Trim();
strBITMAP_THREE = p_Ds.Tables[0].Rows[0]["BITMAP_THREE"].ToString().Trim();
strBITMAP_FOUR = p_Ds.Tables[0].Rows[0]["BITMAP_FOUR"].ToString().Trim();
strBITMAP_FIVE = p_Ds.Tables[0].Rows[0]["BITMAP_FIVE"].ToString().Trim();
strBITMAP_SIX = p_Ds.Tables[0].Rows[0]["BITMAP_SIX"].ToString().Trim();
strBITMAP_SEVEN = p_Ds.Tables[0].Rows[0]["BITMAP_SEVEN"].ToString().Trim();
strBITMAP_EIGHT = p_Ds.Tables[0].Rows[0]["BITMAP_EIGHT"].ToString().Trim();
strACCESSION_NO = p_Ds.Tables[0].Rows[0]["ACCESSION_NO"].ToString().Trim();
}
public bool SaveBitmap()
{
DataSet Ds = SelectBitmapByAccessno(strACCESSION_NO);
if (Ds == null)
{
ShowErr_Form d_form = new ShowErr_Form("无法从数据库中取得数据", "错误");
d_form.ShowDialog();
return false;
}
if (Ds.Tables.Count == 0)
{
return false;
}
if (Ds.Tables[0].Rows.Count == 0)
{
return Insert();
}
else
{
return Update();
}
}
public int Insert()
{
string d_Table = "report_template";
if ((strtemplate_grade == "公有模版") || (strtemplate_grade == "公有"))
{
strtemplate_grade = "公有";
d_Table = "report_template";
}
else
{
strtemplate_grade = Share_Class.User.user_id;
d_Table = "Report_Template_private";
}
if (Exists(0, strtemplate_part, strdisease_type, strtemplate_name, strdep, strtemplate_grade))
{
ShowErr_Form d_form = new ShowErr_Form("已经存在相同的模版名称,无法新增!", "错误");
d_form.ShowDialog();
return 0;
}
string SqlStr = "";
SqlStr = "insert into " + d_Table + "(template_part,disease_type,template_name,template_describle,template_diag ,template_grade,dep";
//SqlStr += ",hospital_code";
SqlStr += ") values ('" + strtemplate_part.Trim() + "','" + strdisease_type.Trim() + "','" + strtemplate_name.Trim() + "','" + strtemplate_describle.Trim() + "','" + strtemplate_diag.Trim() + "' ,'" + strtemplate_grade + "','" + strdep + "'";
// SqlStr += ",'" + Share_Class.User.hospital_code + "';
SqlStr += ")";
if (RISOracle_Class.Exec_Cand(SqlStr, "查询report_template表出错" + "\r\n " + SqlStr) == false)
{
ShowErr_Form d_form = new ShowErr_Form("模版插入失败", "错误");
d_form.ShowDialog();
return 0;
}
else
{
SqlStr = "select max(template_id) as id from " + d_Table + "";
// SqlStr += " where hospital_code='" + Share_Class.User.hospital_code + "' ";
DataSet ds = RISOracle_Class.GetDS(SqlStr, "查询report_template表出错" + "\r\n " + SqlStr);
if (ds.Tables == null)
{
return 0;
}
if (ds.Tables[0].Rows.Count == 0)
{
return 0;
}
return Convert.ToInt32(ds.Tables[0].Rows[0]["id"]);
}
// '执行语句并返回结果记录集()
}
private void temp_Save_SimpleButton_Click(object sender, EventArgs e)
{
if ((CurReportForm.CurPatexam.check_status != "未审核") && (CurReportForm.CurPatexam.check_status != "已审核"))
{
string p_diseasetype, p_name, p_describe, p_diagnose, p_part;
p_diseasetype = "";
p_name = "";
p_describe = "";
p_diagnose = "";
p_part = "";
CurReportForm.getTemplateContent(ref p_diagnose, ref p_describe, ref p_diagnose, ref p_part);
if (CurReportForm.CurPatexam.TempReportSave(p_describe, p_diagnose, CurReportForm.CurPatexam.accessno) == true)
{
ShowErr_Form d_ErrForm = new ShowErr_Form("报告暂存成功", "提示");
d_ErrForm.ShowDialog();
}
else
{
ShowErr_Form d_ErrForm = new ShowErr_Form("报告暂存失败", "提示");
d_ErrForm.ShowDialog();
}
}
}
public bool Modify()
{
string d_Table = "report_template";
if ((strtemplate_grade == "公有模版") || (strtemplate_grade == "公有"))
{
strtemplate_grade = "公有模版";
d_Table = "report_template";
}
else
{
strtemplate_grade = Share_Class.User.user_id;
d_Table = "Report_Template_private";
}
if (Exists(inttemplate_id, strtemplate_part, strdisease_type, strtemplate_name, strdep, strtemplate_grade))
{
ShowErr_Form d_form = new ShowErr_Form("已经存在相同的模版名称,无法修改!", "错误");
d_form.ShowDialog();
return false;
}
string SqlStr = "";
SqlStr = "update " + d_Table + " set template_part='" + strtemplate_part.Trim() + "',disease_type='" + strdisease_type.Trim() + "',template_name='" + strtemplate_name.Trim() + "',template_describle='" + strtemplate_describle.Trim() + "',template_diag='" + strtemplate_diag.Trim() + "' where template_id='" + inttemplate_id.ToString() + "' ";
return RISOracle_Class.Exec_Cand(SqlStr, "更新report_template表出错" + "\r\n " + SqlStr);
}
private bool AfterSave(string p_status)
{
try
{
// ''危急值判定
//flog_Class.WriteFlog("危急值判定：" + Convert.ToString(Share_Class.GetTickCount() - CurTickCount))
UpdatePic();
Setup_Dict.danger_patient_info_class.judgeDanger(CurReportForm.CurPatexam.accessno, Share_Class.User.user_des);
if (CurReportForm.CurPatexam.reportdisease.IndexOf("会诊") > -1)
{
string _hospital_code = "";
string _hospital_name = "";
_hospital_code = Share_Class.hospital_code;
_hospital_name = Share_Class.hospital_name;
if (_hospital_code == "")
_hospital_code = RisSetup_Class.GetINI("setup", "hospital_code");
if (_hospital_name == "")
_hospital_name = RisSetup_Class.GetINI("setup", "hospital_name");
if (_hospital_code == "")
{
ShowErr_Form d_form = new ShowErr_Form("医疗机构代码未设置", "警告");
d_form.ShowDialog();
return false;
}
if (_hospital_name == "")
{
ShowErr_Form d_form = new ShowErr_Form("医疗机构名称未设置", "警告");
d_form.ShowDialog();
return false;
}
Setup_Dict.transfer_operate d_form1 = new Setup_Dict.transfer_operate(Share_Class.User.user_id, Share_Class.User.userflag, _hospital_name, _hospital_code, CurReportForm.CurPatexam.accessno);
d_form1.ShowDialog();
}
// patregister_Class.UpdateROUTE_STATUS(CurReportForm.CurPatexam.accessno);
//'Share_Forms_Class.PatexamListViewForm.SetListViewRowBypatexam(CurReportForm.CurPatexam, New patregister_Class(CurReportForm.CurPatexam.patid))
string d_GetValue = "";// '从配置文件取得的内容
string d_value = "";
//'审核成功后是否关闭报告窗口
if (p_status == "保存")
{
d_value = RisSetup_Class.GetINI_Oracle(CurReportForm.CurPatexam.dep, "save_show");
if (d_value == "yes")
{
ShowErr_Form d_from = new ShowErr_Form("报告信息" + p_status + "成功。", "提示");
d_from.ShowDialog();
}
else if (d_value == "")
RisSetup_Class.WriteINI_Oracle(CurReportForm.CurPatexam.dep, "save_show", "yes");
d_GetValue = RisSetup_Class.GetINI("setup", "save_Whether");
}
else
{
d_value = RisSetup_Class.GetINI_Oracle(CurReportForm.CurPatexam.dep, "advance_show");
if (d_value == "")
{
RisSetup_Class.WriteINI_Oracle(CurReportForm.CurPatexam.dep, "advance_show", "yes");
d_value = "yes";
}
ShowErr_Form d_from = new ShowErr_Form("报告信息" + p_status + "成功,是否立即打印?", "是", "否");
if ((d_value == "print") || ((d_value == "yes") && (d_from.ShowDialog() == DialogResult.OK)))
{//'弹出提示是否更新数据库中病人基本信息
Print_SimpleButton_Click(null, null);
}
d_GetValue = RisSetup_Class.GetINI("setup", "advance_Whether");
}
if (d_GetValue == "yes")
{
Close_SimpleButton_Click(null, null);
}
initPermission();
}
catch
{
return false;
}
return true;
}
public static DataTable GetTemplateList(string p_template_grade, string p_dep, string p_Part)
{
string d_strSql = "";
string d_Table = "REPORT_TEMPLATE_ORDER";
string[] strRowFilter = new string[1] { "" };
if (p_Part != "")
strRowFilter[0] = " t_part='" + p_Part + "'";
if ((p_template_grade == "公有") || (p_template_grade == "公有模版"))
{
setup_REPORT_TEMPLATE_ORDER_Class.Update_REPORT_TEMPLATE_ORDER(p_dep);
setup_REPORT_TEMPLATE_ORDER_Class.Delete_REPORT_TEMPLATE_ORDER(p_dep);
d_Table = "REPORT_TEMPLATE_ORDER";
d_strSql = "Select t_name as t_part from " + d_Table.Trim() + " where t_dept='" + p_dep + "' and t_grade='部位排序' ";
// d_strSql += " and hospital_code='" + Share_Class.User.hospital_code + "' ";
d_strSql = d_strSql + " order by t_search_id asc";
//strRowFilter[0] = " t_part='" + p_Part + "'";
}
else
{
d_Table = "Report_Template_private";
d_strSql = "Select Distinct template_part t_part from " + d_Table.Trim() + " where 1=1 and dep='" + p_dep + "' ";
// d_strSql += " and hospital_code='" + Share_Class.User.hospital_code + "' ";
d_strSql = d_strSql + " and template_grade='" + p_template_grade + "'";
}
DataSet Ds = new DataSet();
Ds = RISOracle_Class.GetDS(d_strSql, "查询ReportStyle表出错" + "\r\n" + d_strSql);
if (Ds == null)
{
ShowErr_Form d_form = new ShowErr_Form("无法从数据库中取得数据", "错误");
return null;
}
if (Ds.Tables.Count == 0)
{
return null;
}
if (Ds.Tables[0].Rows.Count == 0)
{
return null;
}
if (Ds.Tables[0].Rows.Count == 1)
{
return Ds.Tables[0];
}
return TableByFilter(Ds.Tables[0], 0, strRowFilter);
}
public void Fillhistroy()
{
string d_name = "";
string d_accessno = "";
string d_patient_id = "";
string d_patid = "";
string d_xno = "";
d_accessno = CurReportForm.CurPatexam.accessno;
d_patient_id = CurReportForm.CurPatexam.Patient_id;
d_patid = CurReportForm.CurPatexam.patid;
d_xno = CurReportForm.CurPatexam.xno;
d_name = CurReportForm.CurPatregister.Name.Trim();
//if ( d_PatRegister.Is_Write.ToLower == "yes" )
// yz_PictureBox.Visible = true;
// '得到历史记录
DataSet Ds = patexam_Class.Findpatexamhistroy(d_name, d_patient_id, d_accessno, d_xno);
if (Ds == null)
{
ShowErr_Form d_form = new ShowErr_Form("不能取得数据", "错误");
d_form.ShowDialog();
return;
}
//'把得到的数据加到列表中
patexam_GridControl.DataSource = Ds.Tables[0];
patexam_GridView.RefreshData();
Ds = patexam_Class.Findpatexamhistroy(d_name, d_accessno); // 'ma速度变慢
if (Ds == null)
{
ShowErr_Form d_form = new ShowErr_Form("不能取得数据", "错误");
d_form.ShowDialog();
return;
}
//'把得到的数据加到列表中
name_GridControl.DataSource = Ds.Tables[0];
name_GridView.RefreshData();
}
public static DataTable Get_template_nameBydisease_type(string p_template_grade, string p_dep, string p_Part, string p_disease_type)
{
string d_strSql = "";
string d_Table = "REPORT_TEMPLATE_ORDER";
if ((p_template_grade == "公有") || (p_template_grade == "公有模版"))
{
p_template_grade = "公有";
//{
setup_REPORT_TEMPLATE_ORDER_Class.Update_t_Name(p_Part.Trim(), p_disease_type, p_dep);
setup_REPORT_TEMPLATE_ORDER_Class.Delete_t_Name(p_Part.Trim(), p_disease_type, p_dep);
d_Table = "REPORT_TEMPLATE_ORDER";
d_strSql = "Select id,t_name from " + d_Table.Trim() + " where t_disease_type='" + p_disease_type + "' and t_part='" + p_Part + "' and t_dept='" + p_dep + "' and t_grade='模版名称排序' ";
d_strSql = d_strSql + " order by t_search_id asc";
//}
//else
//{
//d_Table = "report_template";
}
else
{
d_Table = "Report_Template_private";
d_strSql = "Select template_id ,template_name from " + d_Table.Trim() + " where 1=1 and disease_type='" + p_disease_type + "' and dep='" + p_dep + "' ";
d_strSql = d_strSql + " and template_grade='" + p_template_grade + "' and template_part='" + p_Part + "'";
if (Share_Class.User.hospital_code != "")
d_strSql = d_strSql + "and hospital_code='" + Share_Class.User.hospital_code + "' ";
d_strSql = d_strSql + " order by template_id desc";
}
//}
DataSet Ds = new DataSet();
Ds = RISOracle_Class.GetDS(d_strSql, "查询ReportStyle表出错" + "\r\n" + d_strSql);
if (Ds == null)
{
ShowErr_Form d_form = new ShowErr_Form("无法从数据库中取得数据", "错误");
d_form.ShowDialog();
return null;
}
if (Ds.Tables.Count == 0)
{
return null;
}
//if (Ds.Tables[0].Rows.Count == 0)
//{
// return null;
//}
return Ds.Tables[0];
}
private void ICD10_TreeList_Click(object sender, EventArgs e)
{
try
{
if (ICD10_TreeList.Selection.Count == 0)
return;
//'取得选中的结点
TreeListNode d_Node = ICD10_TreeList.Selection[0];
if (d_Node.ParentNode == null)
{// '当前结点是部位
return;
}
else if (d_Node.ParentNode.ParentNode == null)
{// '当前结点是结果归类
return;
}
else if (d_Node.ParentNode.ParentNode.ParentNode == null)
{// '当前结点是结果归类
return;
}
else
{
if (d_Node.Nodes.Count == 0)
{
//diseasetype_ComboBoxEdit.Text = d_Node.GetValue[0].ToString();// '得到模板
}
}
return;
}
catch (Exception ex)
{
ShowErr_Form d_form = new ShowErr_Form(ex.Message, "错误");
d_form.ShowDialog();
return;
}
}
private void add_SimpleButton_Click(object sender, EventArgs e)
{
if ((template_grade_ComboBoxEdit.Text.Trim() == "公有") && (Share_Class.User.HaveFunction("o") == false))
{
ShowErr_Form d_ErrForm = new ShowErr_Form("用户无此操作权限", "提示");
d_ErrForm.ShowDialog();
return;
}
if (!ValidateData())
return;
Curtemplate = new report_template_Class();
// '得到当前要处理的Dmb的信息()
SetClassByInput();
try
{
string p_xml_describe = template_Control_describe.GetTemplateXML();
string p_xml_diagnose = template_Control_diagnose.GetTemplateXML();
//Curtemplate.dep = toolStripComboBox_DEP.Text.Trim();
int newid = Curtemplate.Insert();
if (newid > 0)
{
d_id = newid;
Curtemplate.Update(p_xml_describe, p_xml_diagnose, d_id.ToString());
FillTemplate();
ShowErr_Form d_ErrForm = new ShowErr_Form("增加模板成功", "提示");
d_ErrForm.ShowDialog();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "新增模版", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void again_SimpleButton_Click(object sender, EventArgs e)
{
if (Share_Class.User.HaveFunction("n") == false)
{
ShowErr_Form d_form1 = new ShowErr_Form("用户无此操作权限", "提示");
d_form1.ShowDialog();
return;
}
// '弹出重写框
report_rewrite_form d_form = new report_rewrite_form(CurReportForm.CurPatexam);
d_form.ShowDialog();
// '清除报告界面中的重写内容
CurReportForm.report_rewrite();
}
private void Update_SimpleButton_Click(object sender, EventArgs e)
{
if ((template_grade_ComboBoxEdit.Text.Trim() == "公有") && (Share_Class.User.HaveFunction("s") == false))
{
ShowErr_Form d_ErrForm = new ShowErr_Form("用户无此操作权限", "提示");
d_ErrForm.ShowDialog();
return;
}
// '得到当前要处理的Dmb的信息()
SetClassByInput();
if (Curtemplate.template_id == 0)
return;
if (!ValidateData())
return;
try
{
int id = Curtemplate.template_id;
if (MessageBox.Show("确定要修改模版吗?", "修改模版", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
{
return;
}
string p_xml_describe = template_Control_describe.GetTemplateXML();
string p_xml_diagnose = template_Control_diagnose.GetTemplateXML();
if (Curtemplate.Modify())
{
Curtemplate.Update(p_xml_describe, p_xml_diagnose, id.ToString());
SetInputByClass();
FillTemplate();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "新增模版", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void SetPropertyByDs(DataSet p_Ds)
{
if (p_Ds == null)
{
ShowErr_Form d_form = new ShowErr_Form("无法从数据库中取得数据", "错误");
d_form.ShowDialog();
return;
}
if (p_Ds.Tables.Count == 0)
{
return;
}
if (p_Ds.Tables[0].Rows.Count == 0)
{
return;
}
intid = Convert.ToInt32(p_Ds.Tables[0].Rows[0]["ID"]);
strFTPHost = p_Ds.Tables[0].Rows[0]["FTPHost"].ToString().Trim();
strFTPPort = p_Ds.Tables[0].Rows[0]["FTPPort"].ToString().Trim();
strFTPUserName = p_Ds.Tables[0].Rows[0]["FTPUserName"].ToString().Trim();
strFTPPassword = p_Ds.Tables[0].Rows[0]["FTPPassword"].ToString().Trim();
strFTPFileName = p_Ds.Tables[0].Rows[0]["FTPFileName"].ToString().Trim();
strFTPServiceFileName = p_Ds.Tables[0].Rows[0]["FTPServiceFileName"].ToString().Trim();
strFTPCode = p_Ds.Tables[0].Rows[0]["FTPCode"].ToString().Trim();
strFTPThr = p_Ds.Tables[0].Rows[0]["FTPThr"].ToString().Trim();
strFTPStatus = p_Ds.Tables[0].Rows[0]["FTPStatus"].ToString().Trim();
strFTPRemark = p_Ds.Tables[0].Rows[0]["FTPRemark"].ToString().Trim();
}
private void Delete_SimpleButton_Click(object sender, EventArgs e)
{
if ((template_grade_ComboBoxEdit.Text.Trim() == "公有") && (Share_Class.User.HaveFunction("p") == false))
{
ShowErr_Form d_ErrForm = new ShowErr_Form("用户无此操作权限", "提示");
d_ErrForm.ShowDialog();
return;
}
// '得到当前要处理的Dmb的信息()
if (Curtemplate.Delete() == false)
{// '增加过程是否有错
ShowErr_Form d_ErrForm = new ShowErr_Form("操作失败", "错误");
d_ErrForm.ShowDialog();
return;
}
else
{
ShowErr_Form d_ErrForm = new ShowErr_Form("删除部位成功", "提示");
d_ErrForm.ShowDialog();
FillTemplate();
}
}
