public bool InsertToMQCMES_Realtime(string QRMES, string QRID, string line, string item, string data, string Remark) { try { string datetimeserno = DateTime.Now.ToString("yyyyMMdd_HHmmss"); string serno = QRMES; string site = "B01"; string factory = "TECHLINK"; string process = "MQC"; string status = ""; string date_ = DateTime.Now.ToString("yyyy-MM-dd"); string time_ = DateTime.Now.ToString("HH:mm:ss"); string sqlQuerry = ""; // string model = GetModelFromLot(lot,setting); QRMQC_MES qRMQC_MES = QRSpilittoClass.QRstring2MQCFormat(QRMES); QRIDMES qRIDMES = QRSpilittoClass.QRstring2IDFormat(QRID); sqlQuerry += "insert into m_ERPMQC_REALTIME (serno, lot, model, site, factory, line, process,item,inspectdate,inspecttime, data, judge,status,remark ) values( '"; sqlQuerry += serno + "', '" + qRMQC_MES.PO + "', '" + qRMQC_MES.Product + "', '" + site + "', '" + factory + "', '" + line + "', '" + process + "', '" + item + "', '" + date_ + "', '" + time_ + "', '" + data + "', '" + qRIDMES.ID + "', '" + status + "', '" + Remark + "' )"; sqlCON localPLC = new sqlCON(); return(localPLC.sqlExecuteNonQuery(sqlQuerry, false)); } catch (Exception ex) { SystemLog.Output(SystemLog.MSG_TYPE.Err, "InsertToMQC_Realtime(string lot, string line, string item, string data, string Remark, int judge)", ex.Message); return(false); } }
/// <summary> /// /44Z9D075C2O1;TL-0079;Nguyễn Thị Bích Kiều; /// </summary> /// <param name="QRstr"></param> /// <returns></returns> public static QRIDMES QRstring2IDFormat(string QRstr) { QRIDMES qRIDMES = new QRIDMES(); if (QRstr.Length > 0) { var QRArray = QRstr.Split(';'); if (QRArray.Count() == 4) { qRIDMES.str1 = QRArray[0]; qRIDMES.ID = QRArray[1]; qRIDMES.FullName = QRArray[2]; return(qRIDMES); } } return(qRIDMES); }