Ejemplo n.º 1
0
 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();
     }
 }
Ejemplo n.º 2
0
        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 = "";
        }
Ejemplo n.º 3
0
 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();
     }
 }
Ejemplo n.º 4
0
        private void func_Print_IRRUP()
        {
            frmReportViewer PreviewDialog = new frmReportViewer("IRRUP", "SELECT * FROM view_Disposal_Record where Document_No = '" + Doc_No + "'");

            PreviewDialog.ShowDialog();
        }
Ejemplo n.º 5
0
        private void func_Print_RS()
        {
            frmReportViewer PreviewDialog = new frmReportViewer("Return_Slip", "SELECT * FROM view_PullOutRecords where RRP_No = '" + DocNo + "' ");

            PreviewDialog.ShowDialog();
        }
Ejemplo n.º 6
0
        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();
        }
Ejemplo n.º 7
0
        private void func_Print_PTR()
        {
            frmReportViewer PreviewDialog = new frmReportViewer("Transfer_Report", "SELECT * FROM view_Disposal_Record where Document_No = '" + DocNo + "'");

            PreviewDialog.ShowDialog();
        }
Ejemplo n.º 8
0
        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();
        }