private void btnPrint_Click(object sender, EventArgs e) { if (txtSearch.Text == "") { MessageBox.Show("Please select End-User or Service!"); btnFind.Focus(); } else if (cboSearchCriteria.Text == "End User") { frmReportViewer PreviewDialog = new frmReportViewer("Inventory_Details", "SELECT * FROM view_Inventory_Details where fk_End_User_Id = '" + GlobalClass.GlobalEmployeeId + "' "); PreviewDialog.ShowDialog(); } else if (cboSearchCriteria.Text == "Item Description") { frmReportViewer PreviewDialog = new frmReportViewer("Inventory_Details", "SELECT * FROM view_Inventory_Details where pk_Id = '" + GlobalClass.GlobalInvItemId + "' "); PreviewDialog.ShowDialog(); } else { frmReportViewer PreviewDialog = new frmReportViewer("Inventory_Details", "SELECT * FROM view_Inventory_Details where Service_Code = '" + txtSearch.Text + "' "); PreviewDialog.ShowDialog(); } }
private void func_Print_Tag_Per_Item() { frmReportViewer PreviewDialog = new frmReportViewer("Property_Tag", "SELECT * FROM view_Inventory_Details where pk_Id = '" + GlobalClass.GlobalInvItemId + "' and Tag_Size = 'BIG TAG'"); PreviewDialog.ShowDialog(); frmReportViewer PreviewDialog2 = new frmReportViewer("Property_Tag_Small", "SELECT * FROM view_Inventory_Details where pk_Id = '" + GlobalClass.GlobalInvItemId + "'and Tag_Size = 'SMALL TAG'"); PreviewDialog2.ShowDialog(); }
private void func_Print_Tag_Per_Service() { frmReportViewer PreviewDialog = new frmReportViewer("Property_Tag", "SELECT * FROM view_Inventory_Details where Service_Code = '" + txtSearch.Text + "' and (Status != 'Disposed' and Status != 'Cancelled Property No.' and Status != 'Return to Supplier' and Status != 'Replaced by Supplier') and Tag_Size = 'BIG TAG'"); PreviewDialog.ShowDialog(); frmReportViewer PreviewDialog2 = new frmReportViewer("Property_Tag_Small", "SELECT * FROM view_Inventory_Details where Service_Code = '" + txtSearch.Text + "' and (Status != 'Disposed' and Status != 'Cancelled Property No.' and Status != 'Return to Supplier' and Status != 'Replaced by Supplier') and Tag_Size = 'SMALL TAG'"); PreviewDialog2.ShowDialog(); }
private void func_Print_Tag_Per_User() { frmReportViewer PreviewDialog = new frmReportViewer("Property_Tag", "SELECT * FROM view_Inventory_Details where fk_End_User_Id = '" + GlobalClass.GlobalEmployeeId + "' and (Status != 'Disposed' and Status != 'Cancelled Property No.' and Status != 'Return to Supplier' and Status != 'Replaced by Supplier') and Tag_Size = 'BIG TAG' "); PreviewDialog.ShowDialog(); frmReportViewer PreviewDialog2 = new frmReportViewer("Property_Tag_Small", "SELECT * FROM view_Inventory_Details where fk_End_User_Id = '" + GlobalClass.GlobalEmployeeId + "' and (Status != 'Disposed' and Status != 'Cancelled Property No.' and Status != 'Return to Supplier' and Status != 'Replaced by Supplier') and Tag_Size = 'SMALL TAG'"); PreviewDialog2.ShowDialog(); }
private void func_Print_Document() { frmReportViewer PreviewDialog = new frmReportViewer("Return_Slip", "SELECT * FROM view_PullOutRecords where RRP_No = '" + Doc_No + "' "); PreviewDialog.ShowDialog(); cboSearchCriteria.SelectedIndex = 0; txtSearch.Text = ""; cboSearchCriteria.Focus(); Doc_No = ""; }
private void func_Print_IAR() { frmReportViewer PreviewDialog = new frmReportViewer("Receiving_Report", "SELECT * FROM view_Receiving_Report where IAR_No = '" + IAR_No + "' "); PreviewDialog.ShowDialog(); cboSearchCriteria.SelectedIndex = 0; txtSearch.Text = ""; cboSearchCriteria.Focus(); IAR_No = ""; }
private void btnPrint_Click(object sender, EventArgs e) { if (GlobalClass.GlobalOfficerId == "") { MessageBox.Show("Please select accountable officer!"); btnFind.Focus(); } else { frmReportViewer PreviewDialog = new frmReportViewer("Account_Report", "SELECT * FROM view_Inventory_Details where fk_Accountable_Employee_Id = '" + GlobalClass.GlobalOfficerId + "' order by [End User]"); PreviewDialog.ShowDialog(); } }
private void func_GenerateReport() { if (Doc_Type == "PAR") { frmReportViewer PreviewDialog = new frmReportViewer("PAR_Report", "SELECT * FROM view_Inventory_Details where Document_No = '" + Document_No + "'"); PreviewDialog.ShowDialog(); } if (Doc_Type == "ICS") { frmReportViewer PreviewDialog = new frmReportViewer("ICS_Report", "SELECT * FROM view_Inventory_Details where Document_No = '" + Document_No + "'"); PreviewDialog.ShowDialog(); } }
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(); }