private void btnFind_Click(object sender, EventArgs e)
{
DataTable dt = null;
string strTemp = " and ";
string strOr = " AND (";
if (txtCardno.Text.Trim() != "")
{
strOr += "(f.patientcardid_chr='" + txtCardno.Text.Trim() + "')" + strTemp;
}
if (txtName.Text.Trim() != "")
{
strOr += "(b.name_vchr like '" + txtName.Text.Trim() + "%')" + strTemp;
}
if (m_deptTbFind.Tag != null)
{
strOr += "(e.deptid_chr='" + m_deptTbFind.Tag.ToString() + "')" + strTemp;
}
if (m_deptTbFind.txtValuse.Trim() != "")
{
strOr += "(e.DEPTNAME_VCHR='" + m_deptTbFind.txtValuse.Trim().ToString() + "')" + strTemp;
}
//
if (m_cboState.Text.Trim() != "")
{
strOr += "(a.STATUS_INT=" + m_strGetIdByStateText(m_cboState.Text.Trim()) + ")" + strTemp;
}
strOr += " (TO_CHAR (a.opsbookingdate_dat, 'yyyy-mm-dd') BETWEEN '" + dtpBegindate.Value.ToString("yyyy-MM-dd") + "' AND '" + dtpEnddate.Value.ToString("yyyy-MM-dd") + "')";
strOr += " )";
long lngRes = objSvc.m_lngGetApplyOPInfoByOrCondition(strOr, out dt);
if (lngRes > 0)
{
DataTable dtTemp = dt.Clone();
DataRow dr = null;
dtTemp.Columns["birth_dat"].DataType = System.Type.GetType("System.String");
for (int j = 0; j < dt.Rows.Count; j++)
{
dr = dtTemp.NewRow();
for (int j2 = 0; j2 < dt.Columns.Count; j2++)
{
if (dt.Columns[j2].ColumnName == "birth_dat")
{
dr[j2] = dt.Rows[j][j2].ToString();
}
else
{
dr[j2] = dt.Rows[j][j2];
}
}
dtTemp.Rows.Add(dr);
}
string strDate = "";
for (int i = 0; i < dtTemp.Rows.Count; i++)
{
strDate = dtTemp.Rows[i]["birth_dat"].ToString();
if (strDate != "")
{
try
{
dtTemp.Rows[i]["birth_dat"] = clsCreatFile.CalcAge(Convert.ToDateTime(strDate));
}
catch
{
dtTemp.Rows[i]["birth_dat"] = "0";
}
}
else
{
dtTemp.Rows[i]["birth_dat"] = "0";
}
}
dataGridView.DataSource = dtTemp;
}
}
