public FoxProAmplifs(string wc)
{
this.workCode = wc;
dbAccess.SetConnStr(DBConnectionStr.FoxProODBCConnStr("amplifs"));
//dbAccess.SetConnStr(DBConnectionStr.FoxProOLEConnStr("amplifs"));
}
public TestDataTestTracker(string sn)
{
this.SerialNumber = sn;
dbAccess.SetConnStr(DBConnectionStr.ConnStrTestData());
SelectTblAllOps();
}
public TestDataTestTracker(string sn, int op)
{
this.SerialNumber = sn;
this.Operation = op;
dbAccess.SetConnStr(DBConnectionStr.ConnStrTestData());
SelectTbl();
}
public TestDataTestOps(string pn, string ver)
{
this.PartNumber = pn;
this.Version = ver;
dbAccess.SetConnStr(DBConnectionStr.ConnStrTestData());
SelectTbl();
}
public EpicorVPartWhereUsedFGAllRev(string pn, string ver)
{
this.partNum = pn;
this.partRev = ver;
dbAccess.SetConnStr(DBConnectionStr.SQLEpicorConnStr());
SetAllParts();
}
public MfgDataJob(string wc, string pn, string ver, int ct)
{
this.jobNum = wc;
this.PartNumber = pn;
this.PartVersion = ver;
// How to use Quantity is TBD
this.InProcessCt = ct;
dbAccess.SetConnStr(DBConnectionStr.ConnStrMfgData());
}
public ProdmanProto()
{
dbAccess.SetConnStr(DBConnectionStr.ConnStrProdmanData());
}
public MfgDataAssociatedSubAssembly(int partID)
{
this.pID = partID;
dbAccess.SetConnStr(DBConnectionStr.ConnStrMfgData());
}
public ProdmanHistory()
{
dbAccess.SetConnStr(DBConnectionStr.ConnStrProdmanData());
}
public MfgDataPart(string SN)
{
this.SerialNumber = SN;
dbAccess.SetConnStr(DBConnectionStr.ConnStrMfgData());
}
public MfgDataPart()
{
dbAccess.SetConnStr(DBConnectionStr.ConnStrMfgData());
}
public ProdmanCurrent()
{
dbAccess.SetConnStr(DBConnectionStr.ConnStrProdmanData());
}
public TestDataTestOps(int pID)
{
this.pID = pID;
dbAccess.SetConnStr(DBConnectionStr.ConnStrTestData());
}
public MfgDataPLDDevice()
{
dbAccess.SetConnStr(DBConnectionStr.ConnStrMfgData());
}
public MfgDataNotSerializedSub()
{
dbAccess.SetConnStr(DBConnectionStr.ConnStrMfgData());
}
public MfgDataUnmarryHistory()
{
dbAccess.SetConnStr(DBConnectionStr.ConnStrMfgData());
}
public EpicorPart()
{
dbAccess.SetConnStr(DBConnectionStr.SQLEpicorConnStr());
}
public MfgDataApplicationParam(string an)
{
this.AppName = an;
dbAccess.SetConnStr(DBConnectionStr.ConnStrMfgData());
}
public MfgDataPart(int jobID)
{
this.jID = jobID;
dbAccess.SetConnStr(DBConnectionStr.ConnStrMfgData());
}
// The static constructor
static MfgDataTraceRecord()
{
dbAccess.SetConnStr(DBConnectionStr.ConnStrMfgData());
}
public TestDataTestTracker()
{
dbAccess.SetConnStr(DBConnectionStr.ConnStrTestData());
}
public EpicorVPartSearch()
{
dbAccess.SetConnStr(DBConnectionStr.SQLEpicorConnStr());
}
private string JobNum; // aka workcode
public EpicorJobMtl(string JN)
{
this.JobNum = JN;
dbAccess.SetConnStr(DBConnectionStr.SQLEpicorConnStr());
}
public EpicorSerialMatch()
{
dbAccess.SetConnStr(DBConnectionStr.SQLEpicorConnStr());
}
public MfgDataPLDParameter()
{
dbAccess.SetConnStr(DBConnectionStr.ConnStrMfgData());
}
public MfgDataAssociatedSubAssembly()
{
dbAccess.SetConnStr(DBConnectionStr.ConnStrMfgData());
}