private void btn_GetValue_Click(object sender, RoutedEventArgs e)
{
try
{
SystemLog.Output(SystemLog.MSG_TYPE.War, "Start read data from PLC", "START");
stopwatch = new Stopwatch();
MachineItem machine = new MachineItem();
machine.IP = "172.16.1.145";
machine.Line = "L03";
int ConnectionPLC = -1;
Sharp.ReadVariablePLC pLC = new Sharp.ReadVariablePLC(machine.IP, 0, 0, out ConnectionPLC);
MQCVariable mQCVariable = new MQCVariable();
mQCVariable.DicSPLCtatus = pLC.ReadStatusPLCMQC();
mQCVariable.QRMES = pLC.ReadAreaByteToString(181, 100, 100);
mQCVariable.QRID = pLC.ReadAreaByteToString(181, 0, 100);
mQCVariable.ListMQCQty = pLC.ReadQuantityMQC();
mQCVariable.ListNG38 = pLC.ReadAreaIntToListInt(3, 4, 76);
mQCVariable.ListRW38 = pLC.ReadAreaIntToListInt(4, 4, 76);
mQCVariable.ListQtyProduced = pLC.ReadQuantityMQCProduced();
SystemLog.Output(SystemLog.MSG_TYPE.War, "ConnectionPLC", ConnectionPLC.ToString());
SystemLog.Output(SystemLog.MSG_TYPE.War, VariablePLC.FlagKT, mQCVariable.DicSPLCtatus[VariablePLC.FlagKT].ToString());
SystemLog.Output(SystemLog.MSG_TYPE.War, VariablePLC.IsReset, mQCVariable.DicSPLCtatus[VariablePLC.IsReset].ToString());
SystemLog.Output(SystemLog.MSG_TYPE.War, VariablePLC.OnOFF, mQCVariable.DicSPLCtatus[VariablePLC.OnOFF].ToString());
SystemLog.Output(SystemLog.MSG_TYPE.War, VariablePLC.WriteReadyStart, mQCVariable.DicSPLCtatus[VariablePLC.WriteReadyStart].ToString());
SystemLog.Output(SystemLog.MSG_TYPE.War, "QR MES", mQCVariable.QRMES);
SystemLog.Output(SystemLog.MSG_TYPE.War, "QR ID", mQCVariable.QRID);
SystemLog.Output(SystemLog.MSG_TYPE.War, "Output", mQCVariable.ListMQCQty[0].ToString());
SystemLog.Output(SystemLog.MSG_TYPE.War, "NG", mQCVariable.ListMQCQty[1].ToString());
SystemLog.Output(SystemLog.MSG_TYPE.War, "RW", mQCVariable.ListMQCQty[2].ToString());
for (int i = 0; i < mQCVariable.ListNG38.Count; i++)
{
SystemLog.Output(SystemLog.MSG_TYPE.War, "NG" + (i + 1).ToString(), mQCVariable.ListNG38[i].ToString());
}
for (int i = 0; i < mQCVariable.ListRW38.Count; i++)
{
SystemLog.Output(SystemLog.MSG_TYPE.War, "RW" + (i + 1).ToString(), mQCVariable.ListRW38[i].ToString());
}
SystemLog.Output(SystemLog.MSG_TYPE.War, "Output Produced", mQCVariable.ListQtyProduced[0].ToString());
SystemLog.Output(SystemLog.MSG_TYPE.War, "NG Produced", mQCVariable.ListQtyProduced [1].ToString());
SystemLog.Output(SystemLog.MSG_TYPE.War, "RW Produced", mQCVariable.ListQtyProduced[2].ToString());
SystemLog.Output(SystemLog.MSG_TYPE.War, "Start read data from PLC", "END");
}
catch (Exception ex)
{
SystemLog.Output(SystemLog.MSG_TYPE.Err, ex.Source, ex.Message);
}
}
private MQCVariable GetMQCVariableRealtime(string IP, MQCVariable mQCOld)
{
MQCVariable qCVariable = new MQCVariable();
try
{
int ConnectionPLC = -1;
Sharp.ReadVariablePLC pLC = new Sharp.ReadVariablePLC(IP, 0, 0, out ConnectionPLC);
qCVariable.Connection = ConnectionPLC;
if (ConnectionPLC == 0)
{
qCVariable.DicSPLCtatus = pLC.ReadStatusPLCMQC();
if (qCVariable.DicSPLCtatus[VariablePLC.FlagKT] == true)
{
if (qCVariable.DicSPLCtatus[VariablePLC.WriteReadyStart] == false)
{
string QRMES = pLC.ReadAreaByteToString(181, 100, 100);
qCVariable.QRMES = QRMES.Trim();
string QRID = pLC.ReadAreaByteToString(181, 0, 100);
qCVariable.QRID = QRID.Trim();
var ResultValidationQRCode = SubFunction.IsValidationQRCode(qCVariable.QRMES, qCVariable.QRID);
pLC.WriteDinttoPLC(ResultValidationQRCode, 181, 206, 2);//write message error to PLC
if (ResultValidationQRCode == 0)
{
SQLUpload.SQLQRUpdate sQLQR = new SQLQRUpdate();
DataTable dtQRRecord = sQLQR.GetQuanityFromQRMES(qCVariable.QRMES);
QRMQC_MES qRMQC_MES = QRSpilittoClass.QRstring2MQCFormat(qCVariable.QRMES);
if (dtQRRecord.Rows.Count == 1)
{
var OutputQty = Int16.Parse(dtQRRecord.Rows[0]["OutputQty"].ToString());
var NGQty = Int16.Parse(dtQRRecord.Rows[0]["NGQty"].ToString());
var RWQty = Int16.Parse(dtQRRecord.Rows[0]["RWQty"].ToString());
var Total = Int16.Parse(dtQRRecord.Rows[0]["TotalQty"].ToString());
if (qRMQC_MES.quantity > (OutputQty + NGQty + RWQty) && qRMQC_MES.quantity > Total)
{
pLC.WriteMQCProducedQuantitytoPLC(OutputQty, NGQty, RWQty);
pLC.WritebittoPLC(true, 181, 204, 1);//Write FlagKT to PLC
}
else
{
//Write to PLC values to know QR production finished
pLC.WriteDinttoPLC(3, 181, 206, 2);//Completed QR MES
}
}
else if (dtQRRecord.Rows.Count == 0)
{
pLC.WriteMQCProducedQuantitytoPLC(0, 0, 0);
pLC.WritebittoPLC(true, 181, 204, 1);//Write FlagKT to PLC
}
}
else
{
pLC.WritebittoPLC(false, 181, 204, 1);//Write FlagKT to PLC
}
//get values from db and write value PLC
qCVariable.ListMQCQty = pLC.ReadQuantityMQC();
qCVariable.ListQtyProduced = pLC.ReadQuantityMQCProduced();
qCVariable.ListNG38 = pLC.ReadAreaIntToListInt(3, 4, 76);
qCVariable.ListRW38 = pLC.ReadAreaIntToListInt(4, 4, 76);
}
else
{
qCVariable.QRMES = mQCOld.QRMES;
qCVariable.QRID = mQCOld.QRID;
qCVariable.ListMQCQty = pLC.ReadQuantityMQC();
if (qCVariable.ListMQCQty[1] > mQCOld.ListMQCQty[1])
{
qCVariable.ListNG38 = pLC.ReadAreaIntToListInt(3, 4, 76);
}
else
{
qCVariable.ListNG38 = mQCOld.ListNG38;
}
if (qCVariable.ListMQCQty[2] > mQCOld.ListMQCQty[2])
{
qCVariable.ListRW38 = pLC.ReadAreaIntToListInt(4, 4, 76);
}
else
{
qCVariable.ListRW38 = mQCOld.ListRW38;
}
}
}
pLC.Diconnect();
}
}
catch (Exception ex)
{
SystemLog.Output(SystemLog.MSG_TYPE.Err, "Get MQC variable realtime fail", ex.Message);
}
return(qCVariable);
}
public void LoadDataMQCStarting()
{
try
{
stopwatch.Start();
LoadAdress();
if (ListMachines.Count > 0)
{
DicMQCVariableIP = new Dictionary <string, MQCVariable>();
foreach (var machine in ListMachines)
{
int ConnectionPLC = -1;
MQCVariable mQCVariable = new MQCVariable();
QRMQC_MES qRMQC_MES = new QRMQC_MES();
QRIDMES qRIDMES = new QRIDMES();
Sharp.ReadVariablePLC pLC = new Sharp.ReadVariablePLC(machine.IP, 0, 0, out ConnectionPLC);
mQCVariable.Connection = ConnectionPLC;
if (ConnectionPLC == 0)
{
Dictionary <string, bool> DicStatusPLC = new Dictionary <string, bool>();
DicStatusPLC = pLC.ReadStatusPLCMQC();
mQCVariable.DicSPLCtatus = DicStatusPLC;
if (DicStatusPLC.Count == 4)
{
if (DicStatusPLC[VariablePLC.FlagKT])
{
string QRMES = pLC.ReadAreaByteToString(181, 100, 100);
mQCVariable.QRMES = QRMES;
string QRID = pLC.ReadAreaByteToString(181, 0, 100);
mQCVariable.QRID = QRID;
var ResultValidationQRCode = SubFunction.IsValidationQRCode(QRMES, QRID);
pLC.WriteDinttoPLC(ResultValidationQRCode, 181, 206, 2);//write message error to PLC
if (ResultValidationQRCode == 0)
{
pLC.WritebittoPLC(true, 181, 204, 1);//Write FlagKT to PLC
}
else
{
pLC.WritebittoPLC(false, 181, 204, 1);//Write FlagKT to PLC
}
qRMQC_MES = QRSpilittoClass.QRstring2MQCFormat(mQCVariable.QRMES);
// get values from db and write value PLC
SQLUpload.SQLQRUpdate sQLQR = new SQLQRUpdate();
DataTable dtQRRecord = sQLQR.GetQuanityFromQRMES(mQCVariable.QRMES);
if (dtQRRecord.Rows.Count == 1)
{
var OutputQty = Int16.Parse(dtQRRecord.Rows[0]["OutputQty"].ToString());
var NGQty = Int16.Parse(dtQRRecord.Rows[0]["NGQty"].ToString());
var RWQty = Int16.Parse(dtQRRecord.Rows[0]["RWQty"].ToString());
var Total = Int16.Parse(dtQRRecord.Rows[0]["TotalQty"].ToString());
if (qRMQC_MES.quantity > (OutputQty + NGQty + RWQty) && qRMQC_MES.quantity > Total)
{
pLC.WriteMQCProducedQuantitytoPLC(OutputQty, NGQty, RWQty);
}
else
{
//Write to PLC values to know QR production finished
pLC.WriteDinttoPLC(4, 181, 206, 2);//Completed QR MES
}
}
else if (dtQRRecord.Rows.Count == 0)
{
pLC.WriteMQCProducedQuantitytoPLC(0, 0, 0);
}
List <int> ListMQCQty = pLC.ReadQuantityMQC();
mQCVariable.ListMQCQty = ListMQCQty;
List <int> ListMQCProduced = pLC.ReadQuantityMQCProduced();
mQCVariable.ListQtyProduced = ListMQCProduced;
List <int> ListNG38 = pLC.ReadAreaIntToListInt(3, 4, 76);
mQCVariable.ListNG38 = ListNG38;
List <int> ListRW38 = pLC.ReadAreaIntToListInt(4, 4, 76);
mQCVariable.ListRW38 = ListRW38;
}
}
}
DicMQCVariableIP.Add(machine.IP, mQCVariable);
pLC.Diconnect();
qRMQC_MES = new QRMQC_MES();
qRMQC_MES = QRSpilittoClass.QRstring2MQCFormat(mQCVariable.QRMES);
qRIDMES = QRSpilittoClass.QRstring2IDFormat(mQCVariable.QRID);
MachineOperation operation = new MachineOperation();
operation.IP = machine.IP;
operation.Line = machine.Line;
operation.Lot = qRMQC_MES.PO;
operation.Inspector = qRIDMES.FullName;
operation.product = qRMQC_MES.Product;
if (mQCVariable.ListMQCQty.Count == 3)
{
operation.Output = mQCVariable.ListMQCQty[0];
operation.NG = mQCVariable.ListMQCQty[1];
operation.Rework = mQCVariable.ListMQCQty[2];
operation.Status = "Updating";
}
else if (mQCVariable.ListMQCQty.Count == 0)
{
operation.Output = 0;
operation.NG = 0;
operation.Rework = 0;
operation.Status = "Waiting";
}
machineOperations.Add(operation);
}
datagridMachines.ItemsSource = machineOperations;
}
}
catch (Exception ex)
{
SystemLog.Output(SystemLog.MSG_TYPE.Err, "Read PLC fail", ex.Message);
}
}