public string getCommandLine()
{
string comm = command.ToString();
string direc = direction.ToString();
return(comm + "_" + steps + "_" + direc);
}
public void UpdateDB(PersonObject person, COMMAND command, object value, SQLConnectionSettings s)
{
try
{
MySqlConnection con = Connect(s);
string QuerySelect = "select * from " + s.Database + "." + s.TableName + " where " + command.ToString() + "=" + value + ";";
ExecuteSQLCommand(QuerySelect, con);
con = Connect(s);
string QueryUpdate = "update " + s.Database + "." + s.TableName + " SET " +
"Grad='" + person.Grad + "'," +
"Name='" + person.Name + "'," +
"Vorname='" + person.Vorname + "'," +
"PicturePath='" + person.PhotoPath + "'," +
"IsChecked='" + Convert.ToInt32(person.IsCheckedIn) + "'," +
"CardID='" + person.CardID + "'," +
"CheckInTime='" + person.CheckInTime.ToString() + "'," +
"CheckOutTime='" + person.CheckOutTime.ToString() + "'" +
"where " + command.ToString() + " = " + value + ";";
ExecuteSQLCommand(QueryUpdate, con);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private Command MakeCommand(COMMAND command, Dictionary <string, object> parameters, string message, params string[] to)
{
return(new Command(command.ToString(), message, to, parameters, new User(this.ID, this.Nickname)));
}
//---------------------------------------------------------------------------
private void ProcThread(object obj)
{
Queue <pmcPacket> que = obj as Queue <pmcPacket>;
SJob job;
SJobStruct struct_data;
while (true)
{
Thread.Sleep(100);
if (que.Count < 1)
{
continue;
}
pmcPacket stPacket = que.Dequeue();
printf("[Proc. Packet Recv] " + (COMMAND)stPacket.Signal);
switch ((COMMAND)stPacket.Signal)
{
case COMMAND.cmdTimeSync:
TimeSync pmcTime = new TimeSync();
pmcTime = stPacket.GetData <TimeSync>();
//
SetTime(pmcTime);
break;
case COMMAND.cmdVersion:
break;
case COMMAND.cmdAreYouAlive:
stPacket.DataClear();
stPacket.Reply = (int)REPLY.ack_Success;
SendPacket(stPacket);
m_bAlive = !m_bAlive; //Connection Check
break;
case COMMAND.cmdPrepareProc:
job = stPacket.GetData <SJob>();
struct_data = job.getStructData();
//WriteOperationLog("Prepare", true);
m_bPrepare = true;
//SetProcState(0, PROCESS_STATE.IDLE);
//printf("[Prepare Proc] count : " + job.Count + " job id : " + job[0].sjob_id);
//stPacket.Reply = (int)REPLY.ack_Success;
//SendPacket(stPacket);
break;
case COMMAND.cmdLoadStart:
//List<SpecimenInfo> specimen_info = stPacket.GetDataList<SpecimenInfo>(); //List로 올수도 있음. 설비별로 다름.
job = stPacket.GetData <SJob>();
struct_data = job.getStructData();
//SetPortState(0, PORT_STATE.LOADING);
//SetPortState(1, PORT_STATE.IDLE);
//curState.ProcessState.count = 0; //clear
//curState.ProcessState.Add(PROCESS_STATE.READY);
//printf("[Loading Proc] count : " + specimen_info.Count + " specimen id : " + specimen_info[0].specimen_id);
//WriteOperationLog("Load", true);
m_bLoadStart = true;
Thread.Sleep(1500); // 3초간 Loaded상태 유지(Odin - Dashboard)
//SetPortState(0, PORT_STATE.LOADED);
//SetPortState(1, PORT_STATE.IDLE);
//stPacket.Reply = (int)REPLY.ack_Success;
//SendPacket(stPacket);
Thread.Sleep(3000); // 3초간 Loaded상태 유지(Odin - Dashboard)
break;
case COMMAND.cmdRunProc:
//Body Data 없음.
job = stPacket.GetData <SJob>();
struct_data = job.getStructData();
//SetProcState(0, PROCESS_STATE.PROCESSING);
//printf("[Processing Proc]");
//WriteOperationLog("Process");
m_bProcessStart = true;
//SetProcState(0, PROCESS_STATE.PROCESSING_DONE);
//stPacket.Reply = (int)REPLY.ack_Success;
//Unload Ready
//printf("[Unload Ready Proc]");
//WriteOperationLog("Unload Ready");
//data.setValue((int)0);
//SendPacket(stPacket);
//SetPortState(0, PORT_STATE.LOADED);
//SetPortState(1, PORT_STATE.UNLOAD_READY);
Thread.Sleep(3000); // 3초간 UNLOAD_READY 상태 유지(Odin - Dashboard)
break;
case COMMAND.cmdUnloadStart:
//SpecimenInfo specimen_info_unload = stPacket.GetData<SpecimenInfo>(); //List로 올수도 있음. 설비별로 다름.
job = stPacket.GetData <SJob>();
struct_data = job.getStructData();
//SetPortState(0, PORT_STATE.LOADED);
//SetPortState(1, PORT_STATE.UNLOADING);
//printf("[UnLoading Proc] specimen id : " + specimen_info_unload.specimen_id);
//WriteOperationLog("Unload", true);
m_bUnloadStart = true;
//stPacket.Reply = (int)REPLY.ack_Success;
//SendPacket(stPacket);
////TheEnd
//SetPortState(0, PORT_STATE.IDLE);
//SetPortState(1, PORT_STATE.IDLE);
//SetProcState(0, PROCESS_STATE.IDLE);
break;
default:
COMMAND command = (COMMAND)stPacket.Signal;
string str = command.ToString() + ":";
if (command == COMMAND.cmdTimeSync)
{
TimeSync timesync = stPacket.GetData <TimeSync>();
str += timesync.Year + "_" + timesync.Month + "_" + timesync.Day + "_" + timesync.Hour + "_" + timesync.Minute + "_" + timesync.Second;
}
else if (command == (COMMAND.cmdModeChange))
{
int Mode = stPacket.Data[0];
str += Mode;
}
//WriteOperationLog(str);
stPacket.Reply = (int)REPLY.ack_Success;
SendPacket(stPacket);
break;
}
}
}
public PersonObject ReadFromDB(COMMAND command, object value, SQLConnectionSettings s)
{
PersonObject person = new PersonObject();
try
{
string QuerySelect = "select * from " + s.Database + "." + s.TableName + " where " + command.ToString() + "='" + value + "';";
MySqlConnection con = Connect(s);
MySqlCommand sqlCommand = new MySqlCommand(QuerySelect, con);
//For offline connection we weill use MySqlDataAdapter class.
MySqlDataAdapter MyAdapter = new MySqlDataAdapter();
MyAdapter.SelectCommand = sqlCommand;
DataTable dTable = new DataTable();
MyAdapter.Fill(dTable);
DataRow row = dTable.Rows[0];
person.ID = (int)row[0];
person.Grad = (string)row[1];
person.Name = (string)row[2];
person.Vorname = (string)row[3];
person.PhotoPath = (string)row[4];
person.IsCheckedIn = Convert.ToBoolean(row[5]);
person.CardID = (string)row[6];
person.CheckInTime = (string)row[7];
person.CheckOutTime = (string)row[8];
sqlCommand.Connection.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(null);
}
return(person);
}
public void Delete(COMMAND command, object value, SQLConnectionSettings s)
{
try
{
string Query = "delete from " + s.Database + "." + s.TableName + " where " + command.ToString() + "='" + value + "';";
MySqlConnection con = Connect(s);
ExecuteSQLCommand(Query, con);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
