void dledev_OnReport(object sender, Comm.TextPackage txtObj)
{
// throw new Exception("The method or operation is not implemented.");
try
{
if (txtObj.Text[0] == 0x10 || txtObj.Text[0]==0x11 || txtObj.Text[0]==0x13)
{
System.Data.DataSet ds = protocol.GetSendDsByTextPackage(txtObj, Comm.CmdType.CmdReport);
string mesg = "";
for (int i = 1; i < ds.Tables[0].Columns.Count; i++)
{
mesg += ds.Tables[0].Columns[i].ColumnName + ":" + ds.Tables[0].Rows[0][ds.Tables[0].Columns[i].ColumnName].ToString() + "\t";
}
ConsoleServer.WriteLine(mesg);
SVWS_Status svws_status = new SVWS_Status(ds);
Program.mfcc_svws.stausmgr.AddSVWS_Status(svws_status);
}
//if (txtObj.Text[0] == 0x11)
//{
// System.Data.DataSet ds = protocol.GetSendDsByTextPackage(txtObj, Comm.CmdType.CmdReport);
// string mesg = "";
// for (int i = 1; i < ds.Tables[0].Columns.Count; i++)
// {
// mesg += ds.Tables[0].Columns[i].ColumnName + ":" + ds.Tables[0].Rows[0][ds.Tables[0].Columns[i].ColumnName].ToString() + "\t";
// }
// ConsoleServer.WriteLine(mesg);
// SVWS_Status svws_status = new SVWS_Status(ds);
// Program.mfcc_svws.stausmgr.AddSVWS_Status(svws_status);
//}
//else if (txtObj.Text[0] == 0x13)
//{
// System.Data.DataSet ds = protocol.GetSendDsByTextPackage(txtObj, Comm.CmdType.CmdReport);
// string mesg = "";
// for (int i = 1; i < ds.Tables[0].Columns.Count; i++)
// {
// mesg += ds.Tables[0].Columns[i].ColumnName + ":" + ds.Tables[0].Rows[0][ds.Tables[0].Columns[i].ColumnName].ToString() + "\t";
// }
// ConsoleServer.WriteLine(mesg);
// SVWS_Status svws_status = new SVWS_Status(ds);
// Program.mfcc_svws.stausmgr.AddSVWS_Status(svws_status);
//}
else if (txtObj.Text[0] == 0x12)
{
lock (dledev.GetStream())
{
byte[] data = dledev.PackData(0xffff, new byte[]{0x12,(byte)(DateTime.Now.Year%100),(byte)DateTime.Now.Month,(byte) DateTime.Now.Day,
(byte) DateTime.Now.Hour, (byte) DateTime.Now.Minute, (byte) DateTime.Now.Second}, (byte)txtObj.Seq);
dledev.GetStream().Write(data, 0, data.Length);
}
}
}
catch (Exception ex)
{
ConsoleServer.WriteLine(ex.Message + "," + ex.StackTrace);
}
}
public void AddSVWS_Status(SVWS_Status svws_status)
{
if (Program.mfcc_svws == null)
return;
#if DEBUG
//if (svws_status.place != 22 || svws_status.group != 6 || svws_status.kind != 2 || svws_status.dir != 1 || svws_status.type != "A")
// return;
#endif
if (!hs_status.Contains(svws_status.Key))
{
hs_status.Add(svws_status.Key, svws_status);
Program.mfcc_svws.dbServer.SendSqlCmd(svws_status.GetInsertStatement());
Program.mfcc_svws.dbServer.SendSqlCmd(svws_status.GetInsertLogSql());
}
else
{
if (((SVWS_Status)hs_status[svws_status.Key]).Equals(svws_status))
return;
hs_status.Remove(svws_status.Key);
hs_status.Add(svws_status.Key, svws_status);
Program.mfcc_svws.dbServer.SendSqlCmd(svws_status.GetUpdateStatement());
}
}
//public bool IsMatch(string key)
//{
// return hs_status.Contains(key);
//}
public void loadStatus()
{
System.Data.Odbc.OdbcConnection cn = new System.Data.Odbc.OdbcConnection(DbCmdServer.getDbConnectStr());
System.Data.Odbc.OdbcCommand cmd = new System.Data.Odbc.OdbcCommand();
cmd.Connection = cn;
cmd.CommandText= "select type,place,group,kind,dir,run_status,hw_status,density,level,no from tblsvwsconfig";
try
{
cn.Open();
System.Data.Odbc.OdbcDataReader rd = cmd.ExecuteReader();
while (rd.Read())
{
string type;
int place, group, kind, dir, run_status, hw_status, density, level, no;
type = rd[0].ToString();
place = System.Convert.ToInt32(rd[1]);
group = System.Convert.ToInt32(rd[2]);
kind = System.Convert.ToInt32(rd[3]);
dir = System.Convert.ToInt32(rd[4]);
run_status = System.Convert.ToInt32(rd[5]);
hw_status = System.Convert.ToInt32(rd[6]);
density = System.Convert.ToInt32(rd[7]);
level = System.Convert.ToInt32(rd[8]);
no = System.Convert.ToInt32(rd[9]);
#if DEBUG
//if (place != 22 || group != 6 || kind != 2 || dir != 1 || type!="A")
// continue;
#endif
SVWS_Status svws_status=new SVWS_Status();
if (type == "A")
svws_status.SetAnalogStatus(place, group, kind, dir, density, level);
else if (type == "D")
svws_status.SetDigitalStatus(place, group, kind, dir, run_status, hw_status);
else if (type == "P")
svws_status.setPDStatus(place, group, kind, dir, run_status, hw_status,no);
this.hs_status.Add(svws_status.Key, svws_status);
}
rd.Close();
}
catch (Exception ex)
{
ConsoleServer.WriteLine(ex.Message + "," + ex.StackTrace);
}
finally
{
try { cn.Close(); }
catch { ;}
}
}
public void AddSVWS_Status(SVWS_Status svws_status)
{
if (!hs_status.Contains(svws_status.Key))
{
hs_status.Add(svws_status.Key, svws_status);
Program.mfcc_svws.dbServer.SendSqlCmd(svws_status.GetInsertStatement());
Program.mfcc_svws.dbServer.SendSqlCmd(svws_status.GetInsertLogSql());
}
else
{
if (((SVWS_Status)hs_status[svws_status.Key]).Equals(svws_status))
return;
hs_status.Remove(svws_status.Key);
hs_status.Add(svws_status.Key, svws_status);
Program.mfcc_svws.dbServer.SendSqlCmd(svws_status.GetUpdateStatement());
}
}
