bool OpenDys(string pStrSQL, ref OleDbDataReader pDataReader)
{
OleDbCommand oleCommand;
bool vCheck = false;
if (oleConn.State == ConnectionState.Open)
{
try
{
oleCommand = new OleDbCommand(pStrSQL, oleConn);
oleCommand.CommandTimeout = 1;
pDataReader = oleCommand.ExecuteReader();
vCheck = true;
}
catch (Exception exp)
{
Logfile logFile = new Logfile();
logFile.WriteErrLog("[ExecuteSQL]" + pStrSQL);
logFile.WriteErrLog("[ExecuteSQL]" + exp.Message);
logFile = null;
}
}
return(vCheck);
}
private bool OpenPort()
{
bool vIsAvailable = true;
try
{
if (ComportMember.IsTCP)
{
comportMsg = "Open comport =" + ComportMember.IP_Address + " : " + ComportMember.IP_Port + ".";
Application.DoEvents();
IPGlobalProperties ipGlobalProperties = IPGlobalProperties.GetIPGlobalProperties();
TcpConnectionInformation[] tcpConnInfoArray = ipGlobalProperties.GetActiveTcpConnections();
foreach (TcpConnectionInformation tcpi in tcpConnInfoArray)
{
if (tcpi.LocalEndPoint.Port == ComportMember.IP_Port)
{
vIsAvailable = false;
break;
}
}
if (vIsAvailable)
{
tc = new TcpClient(ComportMember.IP_Address, ComportMember.IP_Port);
//tc = new TcpClient("192.168.1.193", 7734);
tc.SendTimeout = 1000;
stm = tc.GetStream();
comportMsg = "Comport =" + ComportMember.IP_Address + " : " + ComportMember.IP_Port + " Open successfull.";
RaiseEvents(comportMsg);
ComportMember.IsOpen = true;
}
}
else//serial port
{
if (Sp.IsOpen)
{
//ComportMember.IsOpen = true;
comportMsg = "Port is opened by another application!";
RaiseEvents(comportMsg);
return(true);
}
comportMsg = "Open comport =" + ComportMember.PortNo + ":" + ComportMember.PortSetting + ".";
RaiseEvents(comportMsg);
string[] spli = ComportMember.PortSetting.Split(','); //9600,N,8,1 -> baud,parity,data,stop
if (spli.Length != 4)
{
return(false);
}
//mSp = new SerialPort();
//mSp.DataReceived += SerialPort_DataReceived;
Sp.PortName = ComportMember.PortNo;
Sp.BaudRate = Int32.Parse(spli[0]);
switch (spli[1].ToString().ToUpper().Trim())
{
case "E": Sp.Parity = Parity.Even; break;
case "M": Sp.Parity = Parity.Mark; break;
case "O": Sp.Parity = Parity.Odd; break;
case "S": Sp.Parity = Parity.Space; break;
default: Sp.Parity = Parity.None; break;
}
Sp.DataBits = Int32.Parse(spli[2]);
switch (spli[3].Trim())
{
case "1": Sp.StopBits = StopBits.One; break;
case "1.5": Sp.StopBits = StopBits.OnePointFive; break;
case "2": Sp.StopBits = StopBits.Two; break;
default: Sp.StopBits = StopBits.None; break;
}
Sp.ReadTimeout = 100;
Sp.WriteTimeout = 500;
Sp.Open();
Sp.DiscardInBuffer();
Sp.DiscardOutBuffer();
}
ComportMember.IsOpen = true;
ComportMember.IsIdle = true;
connect = true;
comportMsg = "Comport =" + ComportMember.PortNo + ":" + ComportMember.PortSetting + " Open successfull.";
RaiseEvents(comportMsg);
}
catch (Exception exp)
{
//Addlistbox(exp.Message.ToString());
if (countWriteLog > 120)
{
countWriteLog = 0;
logFile.WriteErrLog("[Comport]" + exp.ToString());
ComportMember.IsOpen = false;
}
else
{
countWriteLog += 1;
}
return(false);
}
InitialCharacterTime();
return(true);
}
