<%@ page language="java" import="java.sql.*, java.io.*, java.util.*, users.databases.*" %> Other Company Information <% /**** VARIABLE DECLARATION and INITIALIZATION *****/ String strTempDB = "product_tmpClientInfoDB"; int intFOfc = 0, intSOfc = 0, intShowRm = 0, intPWhse = 0, intTSvc = 0; int intBrands = 0, intProds = 0, intBranches = 0, intDstrbtrs = 0, intOtherCP = 0; String strUserLogName = request.getParameter("usrLog"); String strCompanyID = request.getParameter("CoID"); String strCompanyName = request.getParameter("CoName"); /***** MAIN *****/ String SQLstmt = "SELECT * FROM tblCoInfoIndicator WHERE Co_ID=" + strCompanyID + ";"; users.connect(strTempDB); ResultSet rs = users.listQuery(SQLstmt); while (rs.next()) { intFOfc = rs.getInt("ForeignOfc"); intSOfc = rs.getInt("SalesOfc"); intShowRm = rs.getInt("ShowRm"); intPWhse = rs.getInt("PlantAndWHse"); intTSvc = rs.getInt("TechlSvc"); intBrands = rs.getInt("Brands"); intProds = rs.getInt("Products"); intBranches = rs.getInt("Branches"); intDstrbtrs = rs.getInt("Distributors"); intOtherCP = rs.getInt("OtherCP"); } users.disconnect(); %>
         

Company registration

 

Log-in Name: <%= strUserLogName %>
Company: <%= strCompanyName %>

For other appropriate information of your company, please select from the buttons below.

Important: Please make sure that you are done before submitting a page (form). Once a page has been submitted, the information thereon can only be accessed for editing when your account has been activated in the main database.

<% if (intFOfc == 0) { %> For detailed information of main office abroad. <% } else { %> Submitted. <% } %>
<% if (intSOfc == 0) { %> For detailed information of main sales office. <% } else { %> Submitted. <% } %>
<% if (intShowRm == 0) { %> For detailed information of main show room. <% } else { %> Submitted. <% } %>
<% if (intPWhse == 0) { %> For detailed information of main plant/warehouse. <% } else { %> Submitted. <% } %>
<% if (intTSvc == 0) { %> For detailed information of main technical services office. <% } else { %> Submitted. <% } %>
<% if (intBrands == 0) { %> For listings of available brands the company carries. <% } else { %> Submitted. <% } %>
<% if (intProds == 0) { %> For the listings of available products for sale. <% } else { %> Submitted. <% } %>
<% if (intBranches == 0) { %> For detailed information of existing branches. <% } else { %> Submitted. <% } %>
<% if (intDstrbtrs == 0) { %> For detailed information of distributors, retailers, etc. <% } else { %> Submitted. <% } %>
<% if (intOtherCP == 0) { %> For listings of contact person on other departments. <% } else { %> Submitted. <% } %>

 

Copyright © 2001-2003 by Grafikoncepts and Designs, Inc.
A joint project of Grafikoncepts and Designs, Inc. and Digital Management and Solutions, Inc.
Layout by MVMG (VPIT), Digital Management and Solutions, Inc.