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