com.rimptec.ecr

Class ecr_sfuncs

java.lang.Object

com.rimptec.ecr.ecr_sfuncs

public class ecr_sfuncs
extends java.lang.Object

Constructor Summary

Constructors

Constructor and Description
ecr_sfuncs()

Method Summary

Modifier and Type	Method and Description
static boolean	copyFile(java.lang.String oname, java.lang.String nname)
static java.lang.String	ct(rtececr_sql fhsql)
static java.lang.String	fillZeros(int in, int tot)
static java.lang.String	getAppStatSelect(java.lang.String name, int stat)
static java.lang.String	getCADSysSelect(java.lang.String name, java.lang.String def)
static java.lang.String	getCustomerSelect(java.lang.String name, java.lang.String cust)
static java.util.Vector	getCustVector()
static java.lang.String	getDeptSelect(java.lang.String name, java.lang.String dept)
static java.util.Vector	getDeptVector()
static java.lang.String	getDistSelect(java.lang.String name, java.lang.String uname)
static java.util.Vector	getDistVec(int prog) This function returns a distribution list vector for the Engineering Program.
static java.lang.String	getECemails(int ecrnum) This function returns email addresses from the EC for the program distribution list.
static java.lang.String	getlreason(java.lang.String lreason)
static java.lang.String	getlreasonSelect(java.lang.String name, java.lang.String cust)
static java.util.Vector	getlreasonVector()
static java.lang.String	getPartBaseNumSelect(java.lang.String name, java.lang.String num, java.lang.String pcode)
static java.util.Vector	getPartBaseNumVector(java.lang.String pcode)
static java.lang.String	getPartfileTypesSelect(java.lang.String name, java.lang.String dept)
static java.util.Vector	getPartfileTypesVector()
static java.lang.String	getProductTypesSelect(java.lang.String name, java.lang.String dept)
static java.util.Vector	getProductTypesVector()
static java.lang.String	getProgramsSelect(java.lang.String name, java.lang.String prog)
static java.util.Vector	getProgramsVector()
static java.lang.String	getProject(java.lang.String projectNo)
static java.lang.String	getProjectDescription(java.lang.String projectNo)
static java.lang.String	getProjectsSelect(java.lang.String name, java.lang.String prog)
static java.util.Vector	getProjectsVector()
static java.lang.String	getSearchForm(java.lang.String[] arg, int days)
static java.lang.String	getTypesSelect(java.lang.String name, java.lang.String prog)
static java.util.Vector	getTypesVector()
static boolean	isProgMan(java.lang.String uname, int progid) Checks if the user is the program Manager
static int	logNow(int ecrnum, java.lang.String uname, java.lang.String detail) This function logs EC activity in the database for tracking purposes.
java.util.Vector	updateLabels(java.util.Vector v1, java.lang.String pfile) Updates Labels for the vector created from database query.

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

ecr_sfuncs

public ecr_sfuncs()

Method Detail

copyFile

public static boolean copyFile(java.lang.String oname,
                               java.lang.String nname)

ct

public static java.lang.String ct(rtececr_sql fhsql)

fillZeros

public static java.lang.String fillZeros(int in,
                                         int tot)

getAppStatSelect

public static java.lang.String getAppStatSelect(java.lang.String name,
                                                int stat)

getCADSysSelect

public static java.lang.String getCADSysSelect(java.lang.String name,
                                               java.lang.String def)

getCustomerSelect

public static java.lang.String getCustomerSelect(java.lang.String name,
                                                 java.lang.String cust)

getCustVector

public static java.util.Vector getCustVector()

getDeptSelect

public static java.lang.String getDeptSelect(java.lang.String name,
                                             java.lang.String dept)

getDeptVector

public static java.util.Vector getDeptVector()

getDistSelect

public static java.lang.String getDistSelect(java.lang.String name,
                                             java.lang.String uname)

getDistVec

public static java.util.Vector getDistVec(int prog)

This function returns a distribution list vector for the Engineering Program.

getECemails

public static java.lang.String getECemails(int ecrnum)

This function returns email addresses from the EC for the program distribution list. This includes both required as well as info only.

getlreason

public static java.lang.String getlreason(java.lang.String lreason)

getlreasonSelect

public static java.lang.String getlreasonSelect(java.lang.String name,
                                                java.lang.String cust)

getlreasonVector

public static java.util.Vector getlreasonVector()

getPartBaseNumSelect

public static java.lang.String getPartBaseNumSelect(java.lang.String name,
                                                    java.lang.String num,
                                                    java.lang.String pcode)

getPartBaseNumVector

public static java.util.Vector getPartBaseNumVector(java.lang.String pcode)

getPartfileTypesSelect

public static java.lang.String getPartfileTypesSelect(java.lang.String name,
                                                      java.lang.String dept)

getPartfileTypesVector

public static java.util.Vector getPartfileTypesVector()

getProductTypesSelect

public static java.lang.String getProductTypesSelect(java.lang.String name,
                                                     java.lang.String dept)

getProductTypesVector

public static java.util.Vector getProductTypesVector()

getProgramsSelect

public static java.lang.String getProgramsSelect(java.lang.String name,
                                                 java.lang.String prog)

getProgramsVector

public static java.util.Vector getProgramsVector()

getProject

public static java.lang.String getProject(java.lang.String projectNo)

getProjectDescription

public static java.lang.String getProjectDescription(java.lang.String projectNo)

getProjectsSelect

public static java.lang.String getProjectsSelect(java.lang.String name,
                                                 java.lang.String prog)

getProjectsVector

public static java.util.Vector getProjectsVector()

getSearchForm

public static java.lang.String getSearchForm(java.lang.String[] arg,
                                             int days)

getTypesSelect

public static java.lang.String getTypesSelect(java.lang.String name,
                                              java.lang.String prog)

getTypesVector

public static java.util.Vector getTypesVector()

isProgMan

public static boolean isProgMan(java.lang.String uname,
                                int progid)

Checks if the user is the program Manager

logNow

public static int logNow(int ecrnum,
                         java.lang.String uname,
                         java.lang.String detail)

This function logs EC activity in the database for tracking purposes.

updateLabels

public java.util.Vector updateLabels(java.util.Vector v1,
                                     java.lang.String pfile)

Updates Labels for the vector created from database query. Reads labels from a property file