private void btnSearch_Click(object sender, EventArgs e)
{
string strSQL = "";
string varCode = "";
string varName = "";
string varPhys = "";
if (txtPatientID.Text.Length > 0)
{
varCode = "%" + txtPatientID.Text + "%";
}
if (txtFirstName.Text.Length > 0)
{
varName = "%" + txtFirstName.Text + "%";
}
if (txtReferringMD.Text.Length > 0)
{
varPhys = "%" + txtReferringMD.Text + "%";
}
if (chkSearchDate.Checked)
{
strSQL = "SELECT * FROM PatientStudyView WHERE (PatientID LIKE '" + varCode + "' OR PatientName_DICOM LIKE '" + varName + "' or ReferringPhysician_DICOM like '" + varPhys + "') and convert(date,StudyDate) BETWEEN '" + dtpDateFrom.Value.ToString("yyyy-MM-dd") + "' and '" + dtpDateTo.Value.ToString("yyyy-MM-dd") + "' order by StudyDate desc";
}
else
{
strSQL = "SELECT * FROM PatientStudyView WHERE PatientID LIKE '" + varCode + "' OR PatientName_DICOM LIKE '" + varName + "' or ReferringPhysician_DICOM like '" + varPhys + "' order by StudyDate desc";
}
if (string.IsNullOrEmpty(varCode) && string.IsNullOrEmpty(varName) && string.IsNullOrEmpty(varPhys) && chkSearchDate.Checked)
{
strSQL = "SELECT * FROM PatientStudyView WHERE convert(date,StudyDate) BETWEEN '" + dtpDateFrom.Value.ToString("yyyy-MM-dd") + "' and '" + dtpDateTo.Value.ToString("yyyy-MM-dd") + "' order by StudyDate desc";
}
CN1.OpenConnection();
CMD1 = new System.Data.Odbc.OdbcCommand(strSQL, CN1.DBConnection);
//Dim dtst As New DataSet
DicomServerDBDataSet1.PatientStudyViewDataTable table = new DicomServerDBDataSet1.PatientStudyViewDataTable();
System.Data.Odbc.OdbcDataAdapter adptr = new System.Data.Odbc.OdbcDataAdapter();
adptr.SelectCommand = CMD1;
adptr.Fill(table);
DataGridView1.Refresh();
DataGridView1.DataSource = null;
DataGridView1.DataSource = table;
this.Cursor = Cursors.Default;
GridDesign();
CMD1.Dispose();
CN1.closeconnection();
}
private void btnYesterday_Click(object sender, EventArgs e)
{
CN1.OpenConnection();
CMD1 = new System.Data.Odbc.OdbcCommand("select * from PatientStudyView where datepart(dd,StudyDate)=" + DateTime.Now.AddDays(-1).Day.ToString() + " and datepart(MM,StudyDate)=" + DateTime.Now.AddDays(-1).Month.ToString() + " and datepart(yy,StudyDate)=" + DateTime.Now.AddDays(-1).Year.ToString() + "", CN1.DBConnection);
//Dim dtst As New DataSet
DicomServerDBDataSet1.PatientStudyViewDataTable table = new DicomServerDBDataSet1.PatientStudyViewDataTable();
System.Data.Odbc.OdbcDataAdapter adptr = new System.Data.Odbc.OdbcDataAdapter();
adptr.SelectCommand = CMD1;
adptr.Fill(table);
DataGridView1.Refresh();
DataGridView1.DataSource = null;
DataGridView1.DataSource = table;
this.Cursor = Cursors.Default;
GridDesign();
CMD1.Dispose();
CN1.closeconnection();
}
private void btnSearch_Click(object sender, EventArgs e)
{
if (txtPatientID.Text.Length <= 0 && txtFirstName.Text.Length <= 0 && txtReferringMD.Text.Length <= 0 && chkSearchDate.Checked == false)
{
return;
}
string strSQL = "";
string varCode = "";
string varName = "";
string varPhys = "";
if (txtPatientID.Text.Length > 0)
{
varCode = "%" + txtPatientID.Text + "%";
}
if (txtFirstName.Text.Length > 0)
{
varName = "%" + txtFirstName.Text + "%";
}
if (txtReferringMD.Text.Length > 0)
{
varPhys = "%" + txtReferringMD.Text + "%";
}
if (chkAll.Checked)
{
if (chkSearchDate.Checked)
{
strSQL = "SELECT * FROM PatientStudyView WHERE (PatientID LIKE '" + varCode + "' OR PatientName_DICOM LIKE '" + varName + "' or ReferringPhysician_DICOM like '" + varPhys + "') and convert(date,StudyDate) BETWEEN '" + dtpDateFrom.Value.ToString("yyyy-MM-dd") + "' and '" + dtpDateTo.Value.ToString("yyyy-MM-dd") + "' order by StudyDate desc";
}
else
{
strSQL = "SELECT * FROM PatientStudyView WHERE PatientID LIKE '" + varCode + "' OR PatientName_DICOM LIKE '" + varName + "' or ReferringPhysician_DICOM like '" + varPhys + "' order by StudyDate desc";
}
if (string.IsNullOrEmpty(varCode) && string.IsNullOrEmpty(varName) && string.IsNullOrEmpty(varPhys) && chkSearchDate.Checked)
{
strSQL = "SELECT * FROM PatientStudyView WHERE convert(date,StudyDate) BETWEEN '" + dtpDateFrom.Value.ToString("yyyy-MM-dd") + "' and '" + dtpDateTo.Value.ToString("yyyy-MM-dd") + "' order by StudyDate desc";
}
}
else
{
string Mod = "";
bool MoreThanOne = false;
if (chkCR.Checked)
{
Mod = "Modality='CR'";
MoreThanOne = true;
}
if (chkCT.Checked)
{
if (MoreThanOne)
{
Mod = Mod + " OR Modality='CT'";
}
else
{
Mod = "Modality='CT'";
}
MoreThanOne = true;
}
if (chkDX.Checked)
{
if (MoreThanOne)
{
Mod = Mod + " OR Modality='DX'";
}
else
{
Mod = "Modality='DX'";
}
MoreThanOne = true;
}
if (chkES.Checked)
{
if (MoreThanOne)
{
Mod = Mod + " OR Modality='ES'";
}
else
{
Mod = "Modality='ES'";
}
MoreThanOne = true;
}
if (chkMG.Checked)
{
if (MoreThanOne)
{
Mod = Mod + " OR Modality='MG'";
}
else
{
Mod = "Modality='MG'";
}
MoreThanOne = true;
}
if (chkMR.Checked)
{
if (MoreThanOne)
{
Mod = Mod + " OR Modality='MR'";
}
else
{
Mod = "Modality='MR'";
}
MoreThanOne = true;
}
if (chkNM.Checked)
{
if (MoreThanOne)
{
Mod = Mod + " OR Modality='NM'";
}
else
{
Mod = "Modality='NM'";
}
MoreThanOne = true;
}
if (chkOT.Checked)
{
if (MoreThanOne)
{
Mod = Mod + " OR Modality='OT'";
}
else
{
Mod = "Modality='OT'";
}
MoreThanOne = true;
}
if (chkPT.Checked)
{
if (MoreThanOne)
{
Mod = Mod + " OR Modality='PT'";
}
else
{
Mod = "Modality='PT'";
}
MoreThanOne = true;
}
if (chkRF.Checked)
{
if (MoreThanOne)
{
Mod = Mod + " OR Modality='RF'";
}
else
{
Mod = "Modality='RF'";
}
MoreThanOne = true;
}
if (chkRT.Checked)
{
if (MoreThanOne)
{
Mod = Mod + " OR Modality='RT'";
}
else
{
Mod = "Modality='RT'";
}
MoreThanOne = true;
}
if (chkSC.Checked)
{
if (MoreThanOne)
{
Mod = Mod + " OR Modality='SC'";
}
else
{
Mod = "Modality='SC'";
}
MoreThanOne = true;
}
if (chkUS.Checked)
{
if (MoreThanOne)
{
Mod = Mod + " OR Modality='US'";
}
else
{
Mod = "Modality='US'";
}
MoreThanOne = true;
}
if (chkXA.Checked)
{
if (MoreThanOne)
{
Mod = Mod + " OR Modality='XA'";
}
else
{
Mod = "Modality='XA'";
}
MoreThanOne = true;
}
if (chkSearchDate.Checked)
{
strSQL = "SELECT * FROM PatientStudyView WHERE (PatientID LIKE '" + varCode + "' OR PatientName_DICOM LIKE '" + varName + "' or ReferringPhysician_DICOM like '" + varPhys + "') and convert(date,StudyDate) BETWEEN '" + dtpDateFrom.Value.ToString("yyyy-MM-dd") + "' and '" + dtpDateTo.Value.ToString("yyyy-MM-dd") + "' AND (" + Mod + ") order by StudyDate desc";
}
else
{
strSQL = "SELECT * FROM PatientStudyView WHERE PatientID LIKE '" + varCode + "' OR PatientName_DICOM LIKE '" + varName + "' or ReferringPhysician_DICOM like '" + varPhys + "' AND (" + Mod + ") order by StudyDate desc";
}
if (varCode.Length <= 0 && varName.Length <= 0 && varPhys.Length <= 0 && chkSearchDate.Checked)
{
strSQL = "SELECT * FROM PatientStudyView WHERE convert(date,StudyDate) BETWEEN '" + dtpDateFrom.Value.ToString("yyyy-MM-dd") + "' and '" + dtpDateTo.Value.ToString("yyyy-MM-dd") + "' AND (" + Mod + ") order by StudyDate desc";
}
}
CN1.OpenConnection();
CMD1 = new System.Data.Odbc.OdbcCommand(strSQL, CN1.DBConnection);
//Dim dtst As New DataSet
DicomServerDBDataSet1.PatientStudyViewDataTable table = new DicomServerDBDataSet1.PatientStudyViewDataTable();
System.Data.Odbc.OdbcDataAdapter adptr = new System.Data.Odbc.OdbcDataAdapter();
adptr.SelectCommand = CMD1;
adptr.Fill(table);
DataGridView1.Refresh();
DataGridView1.DataSource = null;
DataGridView1.DataSource = table;
this.Cursor = Cursors.Default;
GridDesign();
CMD1.Dispose();
CN1.closeconnection();
}
private void btnYesterday_Click(object sender, EventArgs e)
{
string sqlQuery = "";
if (chkAll.Checked)
{
sqlQuery = "select * from PatientStudyView where datepart(dd,StudyDate)=" + DateTime.Now.AddDays(-1).Day.ToString() + " and datepart(MM,StudyDate)=" + DateTime.Now.AddDays(-1).Month.ToString() + " and datepart(yy,StudyDate)=" + DateTime.Now.AddDays(-1).Year.ToString() + "";
}
else
{
string Mod = "";
bool MoreThanOne = false;
if (chkCR.Checked)
{
Mod = "Modality='CR'";
MoreThanOne = true;
}
if (chkCT.Checked)
{
if (MoreThanOne)
{
Mod = Mod + " OR Modality='CT'";
}
else
{
Mod = "Modality='CT'";
}
MoreThanOne = true;
}
if (chkDX.Checked)
{
if (MoreThanOne)
{
Mod = Mod + " OR Modality='DX'";
}
else
{
Mod = "Modality='DX'";
}
MoreThanOne = true;
}
if (chkES.Checked)
{
if (MoreThanOne)
{
Mod = Mod + " OR Modality='ES'";
}
else
{
Mod = "Modality='ES'";
}
MoreThanOne = true;
}
if (chkMG.Checked)
{
if (MoreThanOne)
{
Mod = Mod + " OR Modality='MG'";
}
else
{
Mod = "Modality='MG'";
}
MoreThanOne = true;
}
if (chkMR.Checked)
{
if (MoreThanOne)
{
Mod = Mod + " OR Modality='MR'";
}
else
{
Mod = "Modality='MR'";
}
MoreThanOne = true;
}
if (chkNM.Checked)
{
if (MoreThanOne)
{
Mod = Mod + " OR Modality='NM'";
}
else
{
Mod = "Modality='NM'";
}
MoreThanOne = true;
}
if (chkOT.Checked)
{
if (MoreThanOne)
{
Mod = Mod + " OR Modality='OT'";
}
else
{
Mod = "Modality='OT'";
}
MoreThanOne = true;
}
if (chkPT.Checked)
{
if (MoreThanOne)
{
Mod = Mod + " OR Modality='PT'";
}
else
{
Mod = "Modality='PT'";
}
MoreThanOne = true;
}
if (chkRF.Checked)
{
if (MoreThanOne)
{
Mod = Mod + " OR Modality='RF'";
}
else
{
Mod = "Modality='RF'";
}
MoreThanOne = true;
}
if (chkRT.Checked)
{
if (MoreThanOne)
{
Mod = Mod + " OR Modality='RT'";
}
else
{
Mod = "Modality='RT'";
}
MoreThanOne = true;
}
if (chkSC.Checked)
{
if (MoreThanOne)
{
Mod = Mod + " OR Modality='SC'";
}
else
{
Mod = "Modality='SC'";
}
MoreThanOne = true;
}
if (chkUS.Checked)
{
if (MoreThanOne)
{
Mod = Mod + " OR Modality='US'";
}
else
{
Mod = "Modality='US'";
}
MoreThanOne = true;
}
if (chkXA.Checked)
{
if (MoreThanOne)
{
Mod = Mod + " OR Modality='XA'";
}
else
{
Mod = "Modality='XA'";
}
MoreThanOne = true;
}
sqlQuery = "select * from PatientStudyView where datepart(dd,StudyDate)=" + DateTime.Now.AddDays(-1).Day.ToString() + " and datepart(MM,StudyDate)=" + DateTime.Now.AddDays(-1).Month.ToString() + " and datepart(yy,StudyDate)=" + DateTime.Now.AddDays(-1).Year.ToString() + " AND (" + Mod + ")";
}
CN1.OpenConnection();
CMD1 = new System.Data.Odbc.OdbcCommand(sqlQuery, CN1.DBConnection);
//Dim dtst As New DataSet
DicomServerDBDataSet1.PatientStudyViewDataTable table = new DicomServerDBDataSet1.PatientStudyViewDataTable();
System.Data.Odbc.OdbcDataAdapter adptr = new System.Data.Odbc.OdbcDataAdapter();
adptr.SelectCommand = CMD1;
adptr.Fill(table);
DataGridView1.Refresh();
DataGridView1.DataSource = null;
DataGridView1.DataSource = table;
this.Cursor = Cursors.Default;
GridDesign();
CMD1.Dispose();
CN1.closeconnection();
}
