private void lstFirst_DoubleClick(object sender, EventArgs e)
{
if (lstFirst.SelectedIndex > -1)
{
objData.OpenConnection("AatickPC-Office", ref strErr);
var sql = "";
if (lstFirst.SelectedValue.ToString() == "1")
{
sql = "USP_Admission_DischageList '" + dateFrom.Value.ToShortDateString() + "','" + dateTo.Value.AddDays(1).ToShortDateString() + "'";
}
else if (lstFirst.SelectedValue.ToString() == "2")
{
sql = "rpt_USP_Hospital_Monthly_Collection '" + dateFrom.Value.ToShortDateString() + "','" + dateTo.Value.AddDays(0).ToShortDateString() + "'";
}
else if (lstFirst.SelectedValue.ToString() == "3")
{
sql = "rpt_USP_Hospital_Marketing_Total_sales_Commission '" + dateFrom.Value.ToShortDateString() + "','" + dateTo.Value.AddDays(0).ToShortDateString() + "'";
}
var dtReport = objData.RetriveData(sql, ref strErr);
objData.CloseConnection();
if (strErr == "" && dtReport.Rows.Count > 0)
{
var rptpath = Utility.ReportPath;
if (lstFirst.SelectedValue.ToString() == "1")
{
rptpath += "rptDischargedPatientList.rpt";
}
else if (lstFirst.SelectedValue.ToString() == "2")
{
rptpath += "rptHospitalMonthlyCollection.rpt";
}
else if (lstFirst.SelectedValue.ToString() == "3")
{
rptpath += "rptAPTotalSalesCommistionMarketing.rpt";
}
var dataset = new DataSet();
dataset.Tables.Add(dtReport);
var reportviewer = new frmReport {
ReportPath = rptpath, Reportds = dataset
};
reportviewer.Show(this);
}
}
//if (lstFirst.SelectedIndex > -2)
//{
// objData.OpenConnection("AatickPC-Office", ref strErr);
// var sql = "";
// if (lstFirst.SelectedValue.ToString() == "2")
// sql = "rpt_USP_Hospital_Monthly_Collection '" + dateFrom.Value.ToShortDateString() + "','" + dateTo.Value.AddDays(1).ToShortDateString() + "'";
// var dtReport = objData.RetriveData(sql, ref strErr);
// objData.CloseConnection();
// if (strErr == "" && dtReport.Rows.Count > 0)
// {
// var rptpath = Utility.ReportPath;
// if (lstFirst.SelectedValue.ToString() == "2")
// rptpath += "rptHospitalMonthlyCollection.rpt";
// var dataset = new DataSet();
// dataset.Tables.Add(dtReport);
// var reportviewer = new frmReport { ReportPath = rptpath, Reportds = dataset };
// reportviewer.Show(this);
// }
//}
}