private void btnPrint_Click(object sender, EventArgs e)
{
string statusFilter=cboStatus.SelectedItem.ToString();
DataView dvw = (gridDetailReport.DataSource as DataTable).AsDataView();
string filterString = "";
if (statusFilter != "All")
filterString = "[Status] = '" + statusFilter + "'";
if (ckExclude.Checked)
{
filterString += (filterString == "") ? "" : " AND";
filterString += " [Received] <> 0";
}
if (ckExcNeverIssued.Checked)
{
filterString += (filterString == "") ? "" : " AND";
filterString += " [Issued] <> 0";
}
if (chkOnlyVital.Checked)
{
filterString += filterString == "" ? string.Format("[VENID]={0}", VEN.Constants.VITAL) : string.Format(" AND [VENID] = {0}", VEN.Constants.VITAL);
}
try
{
dvw.RowFilter = filterString;
}
catch
{
}
dvw.Sort = "Type";
DataTable dtbl = dvw.ToTable();
//Add a row number
dtbl.Columns.Add("LineNo", typeof(int));
int i = 1;
foreach (DataRow dRow in dtbl.Rows)
{
dRow["LineNo"]=i;
i++;
}
if (dtbl != null)
{
HCMIS.Desktop.Reports.StockStatus ss = new HCMIS.Desktop.Reports.StockStatus();
ss.HubName.Text = GeneralInfo.Current.HospitalName;
if (statusFilter != "Normal" && statusFilter != "All")
ss.ItemFilter.Text = statusFilter;
else if (statusFilter == "Normal")
ss.ItemFilter.Text = "Normal Stock Items";
else if (statusFilter == "All")
ss.ItemFilter.Text = "All Items";
if (chkOnlyVital.Checked)
ss.ItemFilter.Text = "Vital Items";
ss.DataSource = dtbl;
ss.ShowPreviewDialog();
}
}
private void btnPrint_Click(object sender, EventArgs e)
{
string statusFilter = cboStatus.SelectedItem.ToString();
DataView dvw = (gridDetailReport.DataSource as DataTable).AsDataView();
string filterString = "";
if (statusFilter != "All")
{
filterString = "[Status] = '" + statusFilter + "'";
}
if (ckExclude.Checked)
{
filterString += (filterString == "") ? "" : " AND";
filterString += " [Received] <> 0";
}
if (ckExcNeverIssued.Checked)
{
filterString += (filterString == "") ? "" : " AND";
filterString += " [Issued] <> 0";
}
if (chkOnlyVital.Checked)
{
filterString += filterString == "" ? string.Format("[VENID]={0}", VEN.Constants.VITAL) : string.Format(" AND [VENID] = {0}", VEN.Constants.VITAL);
}
try
{
dvw.RowFilter = filterString;
}
catch
{
}
dvw.Sort = "Type";
DataTable dtbl = dvw.ToTable();
//Add a row number
dtbl.Columns.Add("LineNo", typeof(int));
int i = 1;
foreach (DataRow dRow in dtbl.Rows)
{
dRow["LineNo"] = i;
i++;
}
if (dtbl != null)
{
HCMIS.Desktop.Reports.StockStatus ss = new HCMIS.Desktop.Reports.StockStatus();
ss.HubName.Text = GeneralInfo.Current.HospitalName;
if (statusFilter != "Normal" && statusFilter != "All")
{
ss.ItemFilter.Text = statusFilter;
}
else if (statusFilter == "Normal")
{
ss.ItemFilter.Text = "Normal Stock Items";
}
else if (statusFilter == "All")
{
ss.ItemFilter.Text = "All Items";
}
if (chkOnlyVital.Checked)
{
ss.ItemFilter.Text = "Vital Items";
}
ss.DataSource = dtbl;
ss.ShowPreviewDialog();
}
}
