Ejemplo n.º 1
0
        public static bool saveSNRecord(SNData snData)
        {
            bool   ret       = false;
            string updateSql = "insert into Label_Print " +
                               "([CurrentTestingLabel],[BurnedDateCode],[BurnedTimeSN],[CustomerDate],[Shijinzhisn]," +
                               "[Sample],[SN],[midVar_time_date],[ReportNo],[strFSN]," +
                               "[CustomerSN],[PrintCount],[PrintDate],[MO],[PN]," +
                               "[Station],[Computer],[Operater],[Remark1],[Remark2],[Remark3]) " +
                               "values (?,?,?,?,?" +
                               ",?,?,?,?,?" +
                               ",?,?,?,?,?" +
                               ",?,?,?,?,?,?" +
                               ")";

            OleDbParameter[] b = new OleDbParameter[21];
            b[0]  = new OleDbParameter("0", snData.label);
            b[1]  = new OleDbParameter("1", "");
            b[2]  = new OleDbParameter("2", "");
            b[3]  = new OleDbParameter("3", snData.customerData);
            b[4]  = new OleDbParameter("4", snData.snDec);
            b[5]  = new OleDbParameter("5", getSample(snData.sn));
            b[6]  = new OleDbParameter("6", getSample(snData.sn));
            b[7]  = new OleDbParameter("7", DateTime.Now.ToString());
            b[8]  = new OleDbParameter("8", getReportNo(snData.sn));
            b[9]  = new OleDbParameter("9", snData.FSN);
            b[10] = new OleDbParameter("10", snData.sn);
            b[11] = new OleDbParameter("11", 1);
            b[12] = new OleDbParameter("12", DateTime.Now);
            b[13] = new OleDbParameter("13", snData.MO);
            b[14] = new OleDbParameter("14", snData.PN);
            b[15] = new OleDbParameter("15", "S32P");
            b[16] = new OleDbParameter("16", Environment.MachineName);
            b[17] = new OleDbParameter("17", "Operater");
            b[18] = new OleDbParameter("18", "Remark1");
            b[19] = new OleDbParameter("19", "Remark2");
            b[20] = new OleDbParameter("20", "Remark3");

            int insertCount = DbHelperOleDb.ExecuteSql(updateSql, DB_MesDataCenterConnectionString, b);

            if (insertCount == 1)
            {
                ret = true;
            }
            return(ret);
        }
Ejemplo n.º 2
0
        public static SNData getITSN(string MO, string PN)
        {
            SNData          ret          = new SNData();
            string          stationID    = "HT001";
            string          userID       = "TestID";
            string          factoryID    = "LXXT";
            string          profitCenter = "SEE-D";
            string          strFSN       = "";
            MESDataServices a            = new MESDataServices();
            string          b            = a.GetSFCNewFSN(MO, "", stationID, true, true, userID, factoryID, profitCenter, ref strFSN);

            string[] aret = strFSN.Split('#');
            ret.FSN          = strFSN;
            ret.label        = aret[0];
            ret.showDate     = aret[1];
            ret.sn           = aret[2];
            ret.customerData = aret[3];
            ret.snDec        = aret[4];
            ret.MO           = MO;
            ret.PN           = PN;
            return(ret);
        }