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