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);
}