private void btnPrint_Click(object sender, EventArgs e) { if (GlobalClass.GlobalInvItemId == "") { MessageBox.Show("Please select item."); } else if (txtSearch.Text == "") { MessageBox.Show("Please select item."); } else { frmReportViewer PreviewDialog = new frmReportViewer("Property_Card", "SELECT * FROM view_ItemHistory where fk_Inv_Id = '" + GlobalClass.GlobalInvItemId + "' order by Date"); PreviewDialog.ShowDialog(); } }
private void func_Print_Document() { if (Doc_Type == "PAR") { frmReportViewer PreviewDialog = new frmReportViewer("PAR_Report", "SELECT * FROM view_Inventory_Details where Document_No = '" + Doc_No + "'"); PreviewDialog.ShowDialog(); } if (Doc_Type == "ICS") { frmReportViewer PreviewDialog = new frmReportViewer("ICS_Report", "SELECT * FROM view_Inventory_Details where Document_No = '" + Doc_No + "'"); PreviewDialog.ShowDialog(); } cboSearchCriteria.SelectedIndex = 0; txtSearch.Text = ""; cboSearchCriteria.Focus(); Doc_No = ""; }
private void btnGenerate_Click(object sender, EventArgs e) { if (txtCategory.Text == "") { MessageBox.Show("Please select criteria for the report generation"); btnFind.Focus(); } else if (GlobalClass.GlobalArticleId == "") { MessageBox.Show("Please select criteria for the report generation"); btnFind.Focus(); } else { frmReportViewer PreviewDialog = new frmReportViewer("Inventory_Report", "SELECT * FROM view_Inventory_Details where fk_Article_Id = '" + GlobalClass.GlobalArticleId + "' AND (Status != 'FOR DISPOSAL' and Status != 'CANCELLED PROPERTY NO.' and Status != 'RETURN TO SUPPLIER' and Status != 'REPLACED BY SUPPLIER' and Status != 'UNSERVICEABLE' and Status != 'EXPIRED')"); PreviewDialog.ShowDialog(); func_Reset(); } }
private void func_Print_IRRUP() { frmReportViewer PreviewDialog = new frmReportViewer("IRRUP", "SELECT * FROM view_Disposal_Record where Document_No = '" + Doc_No + "'"); PreviewDialog.ShowDialog(); }
private void func_Print_RS() { frmReportViewer PreviewDialog = new frmReportViewer("Return_Slip", "SELECT * FROM view_PullOutRecords where RRP_No = '" + DocNo + "' "); PreviewDialog.ShowDialog(); }
private void func_Print_Tag_Small() { frmReportViewer PreviewDialog = new frmReportViewer("Property_Tag_Small", "SELECT * FROM view_Inventory_Details where Document_No = '" + Document_No + "' and Tag_Size = 'SMALL TAG' "); PreviewDialog.ShowDialog(); }
private void func_Print_PTR() { frmReportViewer PreviewDialog = new frmReportViewer("Transfer_Report", "SELECT * FROM view_Disposal_Record where Document_No = '" + DocNo + "'"); PreviewDialog.ShowDialog(); }
private void pIFToolStripMenuItem_Click(object sender, EventArgs e) { frmReportViewer PreviewDialog = new frmReportViewer("Inventory_PIF", "SELECT * FROM view_Inventory_Details where Category_Name != 'EXPENSE'AND (Status != 'FOR DISPOSAL' and Status != 'CANCELLED PROPERTY NO.' and Status != 'RETURN TO SUPPLIER' and Status != 'REPLACED BY SUPPLIER' and Status != 'UNSERVICEABLE' and Status != 'EXPIRED')"); PreviewDialog.ShowDialog(); }