Exemple #1
0
        // generate production batch string
        public List <string> GenerateProductionBatch()
        {
            List <string> batch = new List <string>();
            // add detail record
            DetailRecord detail = new DetailRecord();

            detail.department.SetString(depCode);
            detail.resource.SetString(resCode);
            detail.part.SetString(part);
            detail.workOrder.SetString(woNum);
            detail.seq.SetString(seqNum.ToString("D3"));
            if (actualTime > 99.0)
            {
                actualTime = 99.0;
            }
            string hours   = ((int)actualTime).ToString("D2");
            string minutes = (((int)(actualTime * 100.0) % 100) * 60 / 100).ToString("D2");

            detail.totalMachTime.SetString(hours + minutes);
            batch.Add(detail.BuildString());
            // add production record
            ProductionRecord product = new ProductionRecord();

            product.part.SetString(part);
            product.quaGood.SetString("0000000001");
            product.units.SetString("EA");
            product.empDep.SetString(depCode);
            product.empNum.SetString((empNum % 100000).ToString());
            product.reversing.SetString("N");
            batch.Add(product.BuildString());
            return(batch);
        }
Exemple #2
0
        // generate material batch string
        public List <string> GenerateMaterialBatch()
        {
            List <string> batch = new List <string>();
            // add detail record
            DetailRecord detail = new DetailRecord();

            detail.department.SetString(depCode);
            detail.resource.SetString(resCode);
            detail.part.SetString(part);
            detail.workOrder.SetString(woNum);
            detail.seq.SetString(seqNum.ToString("D3"));
            string hours   = ((int)actualTime).ToString("D2");
            string minutes = (((int)(actualTime * 100.0) % 100) * 60 / 100).ToString("D2");

            detail.totalMachTime.SetString(hours + minutes);
            batch.Add(detail.BuildString());
            // add production record
            ProductionRecord product = new ProductionRecord();

            product.part.SetString(part);
            product.quaGood.SetString("0000000001");
            product.units.SetString("EA");
            product.empDep.SetString(depCode);
            product.empNum.SetString((empNum % 100000).ToString());
            product.noBackFlush.SetString("Y");
            batch.Add(product.BuildString());
            // add material steel record
            MaterialRecord matSteel       = new MaterialRecord();
            string         query          = "select efmtlp, efqppc from cmsdat.cjobdm where efjob#='" + woNum + "'";
            ExcoODBC       odbcConnection = ExcoODBC.Instance;

            odbcConnection.Open(Database.CMSDAT);
            OdbcDataReader reader = odbcConnection.RunQuery(query);

            if (reader.Read())
            {
                matSteel.part.SetString(reader[0].ToString().Trim());
                matSteel.quantity.SetString(Convert.ToInt32((Convert.ToDouble(reader[1]) * 100000.0)).ToString("D15"));
            }
            reader.Close();
            matSteel.stoRoom.SetString("STL");
            matSteel.required.SetString("R");
            matSteel.backFlush.SetString("Y");
            matSteel.matScr.SetString("N");
            matSteel.units.SetString("IN");
            batch.Add(matSteel.BuildString());
            // add material production record
            query  = "select * from cmsdat.cjobdr where edjob#='" + woNum + "' and edseq#=30";
            reader = odbcConnection.RunQuery(query);
            if (reader.Read())
            {
                MaterialRecord matProd = new MaterialRecord();
                matProd.part.SetString(part);
                matProd.quantity.SetString("000000000100000");
                matProd.stoRoom.SetString("PRD");
                matProd.required.SetString("R");
                matProd.backFlush.SetString("Y");
                matProd.matScr.SetString("N");
                matProd.units.SetString("EA");
                matProd.seqNum.SetString("030");
                batch.Add(matProd.BuildString());
            }
            reader.Close();
            return(batch);
        }