/// <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);
}
