/// <summary> /// 查找 /// </summary> public void m_mthFind() { string SqlWhereMZ = "", SqlWhereZY = ""; this.m_mthGetsqlwhere(out SqlWhereZY, out SqlWhereMZ); //门诊 SqlWhereMZ = SqlWhereMZ.Trim(); if (SqlWhereMZ.StartsWith("or")) { SqlWhereMZ = SqlWhereMZ.Substring(2); } else if (SqlWhereMZ.StartsWith("and")) { SqlWhereMZ = SqlWhereMZ.Substring(3); } bool IsIncludeMZ = this.m_objViewer.chkMZ.Checked; //住院 SqlWhereZY = SqlWhereZY.Trim(); if (SqlWhereZY.StartsWith("or")) { SqlWhereZY = SqlWhereZY.Substring(2); } else if (SqlWhereZY.StartsWith("and")) { SqlWhereZY = SqlWhereZY.Substring(3); } if (!SqlWhereZY.Trim().StartsWith("(to_char")) { SqlWhereZY = "(" + SqlWhereZY + ")"; } if (SqlWhereZY.Length > 8) { SqlWhereZY = " and " + SqlWhereZY; } else { SqlWhereZY = ""; } clsPublic.PlayAvi("正在查找病人资料库,请稍候..."); clsCommonQueryDate_VO CommonQueryDate_VO = new clsCommonQueryDate_VO(); if (this.m_objViewer.chkInDate.Checked == false && this.m_objViewer.chkOutDate.Checked == false) { CommonQueryDate_VO.QueryType = 0; } else { if (this.m_objViewer.chkInDate.Checked && this.m_objViewer.chkOutDate.Checked) { CommonQueryDate_VO.QueryType = 3; CommonQueryDate_VO.BeginDate_In = this.m_objViewer.dtBegin_in.Value.ToString("yyyy-MM-dd") + " 00:00:00"; CommonQueryDate_VO.EndDate_In = this.m_objViewer.dtEnd_in.Value.ToString("yyyy-MM-dd") + " 23:59:59"; CommonQueryDate_VO.BeginDate_Out = this.m_objViewer.dtBegin_out.Value.ToString("yyyy-MM-dd") + " 00:00:00"; CommonQueryDate_VO.EndDate_Out = this.m_objViewer.dtEnd_out.Value.ToString("yyyy-MM-dd") + " 23:59:59"; } else { if (this.m_objViewer.chkInDate.Checked) { CommonQueryDate_VO.QueryType = 1; CommonQueryDate_VO.BeginDate_In = this.m_objViewer.dtBegin_in.Value.ToString("yyyy-MM-dd") + " 00:00:00"; CommonQueryDate_VO.EndDate_In = this.m_objViewer.dtEnd_in.Value.ToString("yyyy-MM-dd") + " 23:59:59"; } else if (this.m_objViewer.chkOutDate.Checked) { CommonQueryDate_VO.QueryType = 2; CommonQueryDate_VO.BeginDate_Out = this.m_objViewer.dtBegin_out.Value.ToString("yyyy-MM-dd") + " 00:00:00"; CommonQueryDate_VO.EndDate_Out = this.m_objViewer.dtEnd_out.Value.ToString("yyyy-MM-dd") + " 23:59:59"; } } } DataTable dt = new DataTable(); long l = this.objSvc.m_lngGetPatientinfo(SqlWhereZY, this.m_objViewer.Status, IsIncludeMZ, SqlWhereMZ, CommonQueryDate_VO, out dt); if (l > 0 && dt.Rows.Count > 0) { this.m_mthSetval(dt); clsPublic.CloseAvi(); } else { this.m_objViewer.lsvPatient.BeginUpdate(); this.m_objViewer.lsvPatient.Items.Clear(); this.m_objViewer.lsvPatient.EndUpdate(); clsPublic.CloseAvi(); MessageBox.Show("没有找到满足查询条件的病人信息。", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information); this.m_objViewer.lblInfo.Text = "找到满足条件的记录数: 0条"; if (this.m_objViewer.txtCardNo.Text.Trim() != "") { this.m_objViewer.txtCardNo.Focus(); this.m_objViewer.txtCardNo.SelectAll(); } else if (this.m_objViewer.txtZyh.Text.Trim() != "") { this.m_objViewer.txtZyh.Focus(); this.m_objViewer.txtZyh.SelectAll(); } else if (this.m_objViewer.txtName.Text.Trim() != "") { this.m_objViewer.txtName.Focus(); this.m_objViewer.txtName.SelectAll(); } } }
/// <summary> /// 通用查找窗口用 /// </summary> /// <param name="SqlWhereZY"></param> /// <param name="Status">0 全部 1 在院 2 出院</param> /// <param name="IsIncludeMZ"></param> /// <param name="SqlWhereMZ"></param> /// <param name="dt"></param> /// <returns></returns> public long m_lngGetPatientinfo(string SqlWhereZY, int Status, bool IsIncludeMZ, string SqlWhereMZ, clsCommonQueryDate_VO CommonQueryDate_VO, out DataTable dt) { com.digitalwave.iCare.middletier.HIS.Report.clsReportZY_Svc objSvc = (com.digitalwave.iCare.middletier.HIS.Report.clsReportZY_Svc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(com.digitalwave.iCare.middletier.HIS.Report.clsReportZY_Svc)); long l = objSvc.m_lngGetPatientinfo(SqlWhereZY, Status, IsIncludeMZ, SqlWhereMZ, CommonQueryDate_VO, out dt); objSvc.Dispose(); return(l); }