Example #1
0
 public static bool CheckGroupName(long l_gid, string str_gname)
 {
     try
     {
         Hashtable groupCache = DBCache.GetGroupCache();
         if (groupCache != null && groupCache.Count > 0)
         {
             ICollection values = groupCache.Values;
             foreach (GroupInfo groupInfo in values)
             {
                 if (groupInfo.group_name.Equals(str_gname))
                 {
                     bool result;
                     if (groupInfo.id == l_gid)
                     {
                         result = true;
                         return(result);
                     }
                     result = false;
                     return(result);
                 }
             }
         }
     }
     catch (Exception ex)
     {
         DebugCenter.GetInstance().appendToFile("DBERROR~~~~~~~~~~~DBERROR : " + ex.Message + "\n" + ex.StackTrace);
         bool result = false;
         return(result);
     }
     return(true);
 }
Example #2
0
        public static List <GroupInfo> GetPartGroup(int i_selectflag)
        {
            List <GroupInfo> list = new List <GroupInfo>();

            try
            {
                Hashtable groupCache = DBCache.GetGroupCache();
                if (groupCache != null && groupCache.Count > 0)
                {
                    ICollection values = groupCache.Values;
                    foreach (GroupInfo groupInfo in values)
                    {
                        if (i_selectflag == 2)
                        {
                            GroupInfo item = new GroupInfo(groupInfo);
                            list.Add(item);
                        }
                        else
                        {
                            if (groupInfo.SelectedFlag == i_selectflag)
                            {
                                GroupInfo item2 = new GroupInfo(groupInfo);
                                list.Add(item2);
                            }
                        }
                    }
                }
                list.Sort((GroupInfo x, GroupInfo y) => x.group_name.CompareTo(y.group_name));
            }
            catch (Exception ex)
            {
                DebugCenter.GetInstance().appendToFile("DBERROR~~~~~~~~~~~DBERROR : " + ex.Message + "\n" + ex.StackTrace);
            }
            return(list);
        }
Example #3
0
 public SMTPSetting()
 {
     try
     {
         SMTPSetting sMTPSetting = DBCache.GetSMTPSetting();
         if (sMTPSetting != null)
         {
             this.smtp_enable  = sMTPSetting.Status;
             this.smtp_server  = sMTPSetting.ServerIP;
             this.smtp_port    = sMTPSetting.Port;
             this.smtp_from    = sMTPSetting.Sender;
             this.smtp_to      = sMTPSetting.Receiver;
             this.smtp_event   = sMTPSetting.EVENT;
             this.smtp_auth    = sMTPSetting.AuthenticationFlag;
             this.smtp_account = sMTPSetting.AccountName;
             this.smtp_pwd     = sMTPSetting.AccountPwd;
         }
         else
         {
             this.smtp_enable  = 0;
             this.smtp_server  = "";
             this.smtp_port    = 25;
             this.smtp_from    = "";
             this.smtp_to      = "";
             this.smtp_event   = "";
             this.smtp_auth    = 0;
             this.smtp_account = "";
             this.smtp_pwd     = "";
         }
     }
     catch (Exception ex)
     {
         DebugCenter.GetInstance().appendToFile("DBERROR~~~~~~~~~~~DBERROR : " + ex.Message + "\n" + ex.StackTrace);
     }
 }
Example #4
0
        public static ArrayList getAllZone()
        {
            List <ZoneInfo> list = new List <ZoneInfo>();

            try
            {
                Hashtable zoneCache = DBCache.GetZoneCache();
                if (zoneCache != null && zoneCache.Count > 0)
                {
                    ICollection values = zoneCache.Values;
                    foreach (ZoneInfo item in values)
                    {
                        list.Add(item);
                    }
                }
            }
            catch (Exception ex)
            {
                DebugCenter.GetInstance().appendToFile("DBERROR~~~~~~~~~~~Get all zone error : " + ex.Message + "\n" + ex.StackTrace);
            }
            list.Sort((ZoneInfo x, ZoneInfo y) => x.z_name.CompareTo(y.z_name));
            ArrayList arrayList = new ArrayList();

            foreach (ZoneInfo current in list)
            {
                arrayList.Add(current);
            }
            return(arrayList);
        }
Example #5
0
 public static bool IsLocalIP(string str_ip)
 {
     try
     {
         NetworkInterface[] allNetworkInterfaces = NetworkInterface.GetAllNetworkInterfaces();
         NetworkInterface[] array = allNetworkInterfaces;
         for (int i = 0; i < array.Length; i++)
         {
             NetworkInterface      networkInterface = array[i];
             IPInterfaceProperties iPProperties     = networkInterface.GetIPProperties();
             UnicastIPAddressInformationCollection unicastAddresses = iPProperties.UnicastAddresses;
             foreach (UnicastIPAddressInformation current in unicastAddresses)
             {
                 if (str_ip.Equals(current.Address.ToString()))
                 {
                     return(true);
                 }
             }
         }
     }
     catch (Exception ex)
     {
         DebugCenter.GetInstance().appendToFile(ex.Message);
     }
     return(false);
 }
Example #6
0
 public void Info(string message)
 {
     if (this.open)
     {
         try
         {
             bool flag = false;
             try
             {
                 Monitor.Enter(this, ref flag);
                 string str = DateTime.Now.ToString("HH:mm:ss");
                 File.AppendAllText(this.path + DateTime.Now.ToString("yyyy-MM-dd") + ".log", str + " '" + message + "'\r\n", Encoding.Default);
             }
             finally
             {
                 if (flag)
                 {
                     Monitor.Exit(this);
                 }
             }
         }
         catch (Exception ex)
         {
             DebugCenter.GetInstance().appendToFile("DBERROR~~~~~~~~~~~DBERROR : " + ex.Message + "\n" + ex.StackTrace);
         }
     }
 }
Example #7
0
 public static bool CheckColor(long l_id, int i_color)
 {
     try
     {
         Hashtable zoneCache = DBCache.GetZoneCache();
         if (zoneCache != null && zoneCache.Count > 0)
         {
             ICollection values = zoneCache.Values;
             foreach (ZoneInfo zoneInfo in values)
             {
                 long   zoneID    = zoneInfo.ZoneID;
                 string zoneColor = zoneInfo.ZoneColor;
                 if (zoneColor.Equals(string.Concat(i_color)))
                 {
                     bool result;
                     if (zoneID == l_id)
                     {
                         result = true;
                         return(result);
                     }
                     result = false;
                     return(result);
                 }
             }
         }
     }
     catch (Exception ex)
     {
         DebugCenter.GetInstance().appendToFile("DBERROR~~~~~~~~~~~DBERROR : " + ex.Message + "\n" + ex.StackTrace);
     }
     return(true);
 }
Example #8
0
        private static IntPtr RegisterForDeviceNotifications(IntPtr parent)
        {
            IntPtr intPtr = IntPtr.Zero;
            BroadcastDeviceInterface broadcastDeviceInterface = default(BroadcastDeviceInterface);

            broadcastDeviceInterface.dbcc_size           = Marshal.SizeOf(broadcastDeviceInterface);
            broadcastDeviceInterface.BroadcastDeviceType = BroadcastDeviceType.DBT_DEVTYP_DEVICEINTERFACE;
            broadcastDeviceInterface.dbcc_classguid      = RawInput.AllUsbDeviceInterfaceHid;
            IntPtr intPtr2 = IntPtr.Zero;

            try
            {
                intPtr2 = Marshal.AllocHGlobal(Marshal.SizeOf(typeof(BroadcastDeviceInterface)));
                Marshal.StructureToPtr(broadcastDeviceInterface, intPtr2, false);
                intPtr = Win32.RegisterDeviceNotification(parent, intPtr2, DeviceNotification.DEVICE_NOTIFY_ALL_INTERFACE_CLASSES);
            }
            catch (Exception ex)
            {
                DebugCenter.GetInstance().appendToFile(ex.Message + "\r\n" + ex.StackTrace);
            }
            finally
            {
                Marshal.FreeHGlobal(intPtr2);
            }
            if (intPtr == IntPtr.Zero)
            {
                DebugCenter.GetInstance().appendToFile("Registration for device notifications Failed. Error: " + Marshal.GetLastWin32Error().ToString());
            }
            return(intPtr);
        }
Example #9
0
        private static long GetMySqlPacketLength(string connectString)
        {
            long result = 0L;

            try
            {
                MySqlConnection mySqlConnection = new MySqlConnection(connectString);
                mySqlConnection.Open();
                MySqlCommand mySqlCommand = mySqlConnection.CreateCommand();
                mySqlCommand.CommandText = "SHOW VARIABLES LIKE 'max_allowed_packet'";
                DbDataReader dbDataReader = mySqlCommand.ExecuteReader();
                if (dbDataReader.Read())
                {
                    result = (long)Convert.ToInt32(dbDataReader.GetValue(1));
                }
                dbDataReader.Close();
                mySqlCommand.Dispose();
                mySqlConnection.Close();
            }
            catch (Exception ex)
            {
                DebugCenter.GetInstance().appendToFile("getMySQLPath: " + ex.Message);
                result = 0L;
            }
            return(result);
        }
Example #10
0
 public void showRpt(int selpage, int needinit)
 {
     if (selpage == 1)
     {
         if (needinit == 1)
         {
             this.thermGenRptPara1.pageInit(this);
         }
         this.thermGenRptPara1.Visible = true;
         this.thermRptShow1.Visible    = false;
         this.thermGenRptPara1.resettime();
         this.m_inAnalysisFlg = 1;
         return;
     }
     if (selpage == 2)
     {
         Program.IdleTimer_Pause(4);
         this.thermGenRptPara1.Visible = false;
         this.thermRptShow1.Visible    = true;
         this.thermRptShow1.pageInit(this, this.thermGenRptPara1);
         DebugCenter.GetInstance().appendToFile("ThermalAnalysis Finish.");
         this.m_inAnalysisFlg = 4;
         return;
     }
     if (selpage == 4)
     {
         this.thermGenRptPara1.Visible = false;
         this.thermRptShow1.Visible    = true;
         Program.IdleTimer_Run(4);
         this.m_inAnalysisFlg = 4;
     }
 }
Example #11
0
 public PresentValue GetPresentValue(System.Collections.Generic.List <ValueMessage> values, System.Collections.Generic.IDictionary <string, System.Collections.Generic.IDictionary <int, OutletMapping> > outletIdMapper, System.Collections.Generic.IDictionary <string, System.Collections.Generic.IDictionary <int, BankMapping> > bankIdMapper, System.Collections.Generic.IDictionary <string, System.Collections.Generic.IDictionary <int, SensorMapping> > sensorIdMapper, System.Collections.Generic.IDictionary <string, System.Collections.Generic.IDictionary <int, LineMapping> > lineIdMapper)
 {
     if (values == null || values.Count < 1)
     {
         return(new PresentValue());
     }
     if (this.presentValue == null)
     {
         this.presentValue = new PresentValue();
     }
     foreach (ValueMessage current in values)
     {
         try
         {
             this.setDeviceTable(current.CreateTime, current.DeviceValue, current.DeviceID);
             this.setSensorTable(current.CreateTime, current.SensorValue, current.DeviceID, current.SensorNums, current.DeviceMac, sensorIdMapper);
             this.setOutletTable(current.CreateTime, current.OutletValue, current.DeviceID, current.PortNums, current.DeviceMac, outletIdMapper);
             this.setBankTable(current.CreateTime, current.BankValue, current.DeviceID, current.BankNums, current.DeviceMac, bankIdMapper);
             this.setLineTable(current.CreateTime, current.LineValue, current.DeviceID, current.LineNums, current.DeviceMac, lineIdMapper);
         }
         catch (System.Exception ex)
         {
             DebugCenter.GetInstance().appendToFile("Skip device: " + current.DeviceMac + ", " + ex.Message);
         }
     }
     return(this.presentValue);
 }
Example #12
0
        public static void InsertBankPower(int i_bankid, double f_power, DateTime dt_inserttime, DBConn conn)
        {
            try
            {
                long num = Convert.ToInt64(f_power * 10000.0);
                if (DBUrl.SERVERMODE)
                {
                    string item = string.Concat(new object[]
                    {
                        "insert into bank_auto_info",
                        dt_inserttime.ToString("yyyyMMdd"),
                        " (bank_id,power,insert_time ) values(",
                        i_bankid,
                        ",",
                        num,
                        ",#",
                        dt_inserttime.ToString("yyyy-MM-dd HH:mm:ss"),
                        "#)"
                    });
                    WorkQueue <string> .getInstance().WorkSequential = true;

                    WorkQueue <string> .getInstance().EnqueueItem(item);
                }
                else
                {
                    if (DBUrl.DB_CURRENT_TYPE.Equals("MYSQL"))
                    {
                        string item2 = string.Concat(new object[]
                        {
                            "insert into bank_auto_info",
                            dt_inserttime.ToString("yyyyMMdd"),
                            " (bank_id,power,insert_time ) values(",
                            i_bankid,
                            ",",
                            num,
                            ",#",
                            dt_inserttime.ToString("yyyy-MM-dd HH:mm:ss"),
                            "#)"
                        });
                        WorkQueue <string> .getInstance().WorkSequential = true;

                        WorkQueue <string> .getInstance().EnqueueItem(item2);
                    }
                    else
                    {
                        List <string> list = new List <string>();
                        list.Add(string.Concat(i_bankid));
                        list.Add(dt_inserttime.ToString("yyyy-MM-dd HH:mm:ss"));
                        list.Add("bank_auto_info");
                        list.Add(string.Concat(num));
                        PDDataProcess.GetInstance().PutItem(list);
                    }
                }
            }
            catch (Exception ex)
            {
                DebugCenter.GetInstance().appendToFile("DBERROR~~~~~~~~~~~DBERROR : " + ex.Message + "\n" + ex.StackTrace);
            }
        }
Example #13
0
        public int Update()
        {
            if (this.id < 1)
            {
                return(-1);
            }
            if (this.device_id < 1)
            {
                return(-1);
            }
            DBConn    dBConn    = null;
            DbCommand dbCommand = null;

            try
            {
                dBConn = DBConnPool.getConnection();
                if (dBConn.con != null)
                {
                    dbCommand             = DBConn.GetCommandObject(dBConn.con);
                    dbCommand.CommandType = CommandType.Text;
                    string commandText = "update line_info set max_voltage=?,min_voltage=?,max_power=?,min_power=?,max_current=?,min_current=?  where id=" + this.id;
                    dbCommand.CommandText = commandText;
                    dbCommand.Parameters.Add(DBTools.GetParameter("@max_voltage", this.max_voltage, dbCommand));
                    dbCommand.Parameters.Add(DBTools.GetParameter("@min_voltage", this.min_voltage, dbCommand));
                    dbCommand.Parameters.Add(DBTools.GetParameter("@max_power", this.max_power, dbCommand));
                    dbCommand.Parameters.Add(DBTools.GetParameter("@min_power", this.min_power, dbCommand));
                    dbCommand.Parameters.Add(DBTools.GetParameter("@max_current", this.max_current, dbCommand));
                    dbCommand.Parameters.Add(DBTools.GetParameter("@min_current", this.min_current, dbCommand));
                    int result = dbCommand.ExecuteNonQuery();
                    dbCommand.Parameters.Clear();
                    DBCacheStatus.Device = true;
                    DBCacheStatus.DBSyncEventSet(true, new string[]
                    {
                        "DBSyncEventName_Service_Device"
                    });
                    return(result);
                }
            }
            catch (Exception ex)
            {
                DebugCenter.GetInstance().appendToFile("DBERROR~~~~~~~~~~~DBERROR : " + ex.Message + "\n" + ex.StackTrace);
            }
            finally
            {
                try
                {
                    dbCommand.Dispose();
                }
                catch
                {
                }
                if (dBConn != null)
                {
                    dBConn.close();
                }
            }
            return(-1);
        }
Example #14
0
        public static long DeleteLogByRecords(int records)
        {
            long      result      = 0L;
            string    commandText = "select min(log.id) from (select top " + records + " id from logrecords order by id desc ) as log";
            string    arg         = "delete from logrecords where id < ";
            DBConn    dBConn      = null;
            DbCommand dbCommand   = new OleDbCommand();

            try
            {
                dBConn = DBConnPool.getLogConnection();
                if (dBConn.con != null)
                {
                    dbCommand             = DBConn.GetCommandObject(dBConn.con);
                    dbCommand.CommandType = CommandType.Text;
                    if (DBUrl.SERVERMODE)
                    {
                        commandText = "select min(logg.id) from (select id from logrecords order by id desc LIMIT " + records + " OFFSET 0 ) as logg";
                    }
                    dbCommand.CommandText = commandText;
                    object obj = dbCommand.ExecuteScalar();
                    if (obj != null && obj != DBNull.Value)
                    {
                        int num = 0;
                        try
                        {
                            num = Convert.ToInt32(obj);
                        }
                        catch
                        {
                        }
                        dbCommand.CommandText = arg + num;
                        result = (long)dbCommand.ExecuteNonQuery();
                    }
                    dbCommand.Dispose();
                }
            }
            catch (Exception ex)
            {
                DebugCenter.GetInstance().appendToFile("DBERROR~~~~~~~~~~~DBERROR : " + ex.Message + "\n" + ex.StackTrace);
            }
            finally
            {
                try
                {
                    dbCommand.Dispose();
                }
                catch
                {
                }
                if (dBConn != null)
                {
                    dBConn.close();
                }
            }
            return(result);
        }
Example #15
0
        public int UpdateLineThreshold(DBConn conn)
        {
            if (this.id < 1)
            {
                return(-1);
            }
            if (this.device_id < 1)
            {
                return(-1);
            }
            DbCommand dbCommand = null;

            try
            {
                if (conn.con != null)
                {
                    dbCommand             = DBConn.GetCommandObject(conn.con);
                    dbCommand.Connection  = conn.con;
                    dbCommand.CommandType = CommandType.Text;
                    string text = "update line_info set ";
                    text = text + "max_voltage=" + CultureTransfer.ToString(this.max_voltage);
                    text = text + ",min_voltage=" + CultureTransfer.ToString(this.min_voltage);
                    text = text + ",max_power=" + CultureTransfer.ToString(this.max_power);
                    text = text + ",min_power=" + CultureTransfer.ToString(this.min_power);
                    text = text + ",max_current=" + CultureTransfer.ToString(this.max_current);
                    text = text + ",min_current=" + CultureTransfer.ToString(this.min_current);
                    text = text + "  where id= " + this.id;
                    dbCommand.CommandText = text;
                    int result = dbCommand.ExecuteNonQuery();
                    dbCommand.Parameters.Clear();
                    dbCommand.Dispose();
                    return(result);
                }
            }
            catch (Exception ex)
            {
                try
                {
                    dbCommand.Dispose();
                }
                catch
                {
                }
                DebugCenter.GetInstance().appendToFile("DBERROR~~~~~~~~~~~DBERROR : " + ex.Message + "\n" + ex.StackTrace);
            }
            finally
            {
                try
                {
                    dbCommand.Dispose();
                }
                catch
                {
                }
            }
            return(-1);
        }
Example #16
0
        public static bool SetEventInfo(DataTable eventlist)
        {
            bool      result    = false;
            DBConn    dBConn    = null;
            DbCommand dbCommand = new OleDbCommand();

            try
            {
                dBConn = DBConnPool.getConnection();
                if (dBConn.con != null)
                {
                    dbCommand = DBConn.GetCommandObject(dBConn.con);
                    foreach (DataRow dataRow in eventlist.Rows)
                    {
                        dbCommand.CommandType = CommandType.Text;
                        dbCommand.CommandText = string.Concat(new object[]
                        {
                            "update event_info set logflag = ",
                            Convert.ToInt16(dataRow["logflag"]),
                            ", mailflag = ",
                            Convert.ToInt16(dataRow["mailflag"]),
                            " where eventid = '",
                            Convert.ToString(dataRow["eventid"]),
                            "' "
                        });
                        dbCommand.ExecuteNonQuery();
                    }
                    dbCommand.Dispose();
                    DBCacheStatus.Event = true;
                    DBCacheStatus.DBSyncEventSet(true, new string[]
                    {
                        "DBSyncEventName_Service_Event"
                    });
                    return(true);
                }
            }
            catch (Exception ex)
            {
                DebugCenter.GetInstance().appendToFile("DBERROR~~~~~~~~~~~DBERROR : " + ex.Message + "\n" + ex.StackTrace);
            }
            finally
            {
                try
                {
                    dbCommand.Dispose();
                }
                catch
                {
                }
                if (dBConn != null)
                {
                    dBConn.close();
                }
            }
            return(result);
        }
Example #17
0
 public string[] directoryListDetailed(string directory)
 {
     try
     {
         this.ftpRequest = (FtpWebRequest)WebRequest.Create(string.Concat(new object[]
         {
             "ftp://",
             this.host,
             ":",
             this.port,
             "/",
             directory
         }));
         this.ftpRequest.Credentials = new NetworkCredential(this.user, this.pass);
         this.ftpRequest.UseBinary   = true;
         this.ftpRequest.UsePassive  = true;
         this.ftpRequest.KeepAlive   = true;
         this.ftpRequest.Method      = "LIST";
         this.ftpResponse            = (FtpWebResponse)this.ftpRequest.GetResponse();
         this.ftpStream = this.ftpResponse.GetResponseStream();
         StreamReader streamReader = new StreamReader(this.ftpStream);
         string       text         = null;
         try
         {
             while (streamReader.Peek() != -1)
             {
                 text = text + streamReader.ReadLine() + "|";
             }
         }
         catch (Exception ex)
         {
             Console.WriteLine(ex.ToString());
         }
         streamReader.Close();
         this.ftpStream.Close();
         this.ftpResponse.Close();
         this.ftpRequest = null;
         try
         {
             return(text.Split("|".ToCharArray()));
         }
         catch (Exception ex2)
         {
             Console.WriteLine(ex2.ToString());
         }
     }
     catch (Exception ex3)
     {
         DebugCenter.GetInstance().appendToFile("DBERROR~~~~~~~~~~~DBERROR : " + ex3.Message + "\n" + ex3.StackTrace);
         Console.WriteLine(ex3.ToString());
     }
     return(new string[]
     {
         ""
     });
 }
Example #18
0
        public int CloseDBConnection()
        {
            if (this.DBTYPE == 1)
            {
                return(1);
            }
            if (this.con != null)
            {
                int i = 0;
                while (i < 600)
                {
                    if (this.con.State == ConnectionState.Closed)
                    {
                        goto IL_38;
                    }
                    if (this.con.State == ConnectionState.Open)
                    {
                        goto Block_4;
                    }
IL_8B:
                    DebugCenter.GetInstance().appendToFile("Close DBConnection exception : " + this.con.State);
                    i++;
                    Thread.Sleep(50);
                    continue;
Block_4:
                    try
                    {
                        try
                        {
IL_38:
                            this.con.Close();
                        }
                        catch
                        {
                        }
                        try
                        {
                            this.con.Dispose();
                        }
                        catch
                        {
                        }
                        this.con = null;
                        return(1);
                    }
                    catch (Exception ex)
                    {
                        DebugCenter.GetInstance().appendToFile("Close DBConnection exception : " + ex.Message + "\n" + ex.StackTrace);
                        break;
                    }
                    goto IL_8B;
                }
                return(-1);
            }
            return(1);
        }
Example #19
0
        public void showRpt(int selpage, int needinit)
        {
            switch (selpage)
            {
            case 1:
                if (needinit == 1)
                {
                    this.genRptPara1.pageInit_1(this);
                }
                else
                {
                    this.genRptPara1.pageInit_2(0);
                }
                this.genRptPara1.Visible  = true;
                this.EgenRptShow1.Visible = false;
                this.genRptPara1.resettime();
                this.m_inAnalysisFlg = 1;
                return;

            case 2:
                Program.IdleTimer_Pause(2);
                this.genRptPara1.pageInit_2(1);
                this.genRptPara1.Visible  = true;
                this.EgenRptShow1.Visible = false;
                if (this.m_inAnalysisFlg == 2)
                {
                    return;
                }
                this.m_pParaClass = new EGenRptParaClass();
                this.m_pParaClass.pageInit(this.genRptPara1);
                this.m_inAnalysisFlg  = 2;
                this.m_oldAnalysisFlg = 2;
                System.Threading.ThreadPool.QueueUserWorkItem(new System.Threading.WaitCallback(this.prepare_dataProc), this.m_pParaClass);
                this.dTimer.Enabled = true;
                return;

            case 3:
                this.genRptPara1.Visible  = false;
                this.EgenRptShow1.Visible = true;
                this.EgenRptShow1.pageInit(this, this.m_pParaClass, this.m_retDataSet);
                DebugCenter.GetInstance().appendToFile("PowerAnalysis Finish.");
                Program.IdleTimer_Run(2);
                this.m_inAnalysisFlg = 4;
                return;

            case 4:
                this.genRptPara1.Visible  = false;
                this.EgenRptShow1.Visible = true;
                this.m_inAnalysisFlg      = 4;
                return;

            default:
                return;
            }
        }
Example #20
0
        public int UpdatePortThreshold(DBConn conn)
        {
            if (this.id < 1)
            {
                return(-1);
            }
            if (this.device_id < 1)
            {
                return(-1);
            }
            DbCommand dbCommand = new OleDbCommand();

            try
            {
                if (conn.con != null)
                {
                    dbCommand             = DBConn.GetCommandObject(conn.con);
                    dbCommand.CommandType = CommandType.Text;
                    string text = "update port_info set port_nm=?,port_confirmation=?,port_ondelay_time=?,port_offdelay_time=?,max_voltage=?,min_voltage=?,max_power_diss=?,min_power_diss=?,max_power=?,min_power=?,max_current=?,min_current=?,shutdown_method=?,mac=? where id=" + this.id;
                    text = "update port_info set ";
                    text = text + "port_nm='" + this.port_nm + "'";
                    text = text + ",port_confirmation=" + CultureTransfer.ToString(this.port_confirmation);
                    text = text + ",port_ondelay_time=" + CultureTransfer.ToString(this.port_ondelay_time);
                    text = text + ",port_offdelay_time=" + CultureTransfer.ToString(this.port_offdelay_time);
                    text = text + ",max_voltage=" + CultureTransfer.ToString(this.max_voltage);
                    text = text + ",min_voltage=" + CultureTransfer.ToString(this.min_voltage);
                    text = text + ",max_power_diss=" + CultureTransfer.ToString(this.max_power_diss);
                    text = text + ",min_power_diss=" + CultureTransfer.ToString(this.min_power_diss);
                    text = text + ",max_power=" + CultureTransfer.ToString(this.max_power);
                    text = text + ",min_power=" + CultureTransfer.ToString(this.min_power);
                    text = text + ",max_current=" + CultureTransfer.ToString(this.max_current);
                    text = text + ",min_current=" + CultureTransfer.ToString(this.min_current);
                    text = text + ",shutdown_method=" + CultureTransfer.ToString(this.shutdown_method);
                    text = text + ",mac='" + this.port_mac + "'";
                    text = text + "  where id= " + this.id;
                    dbCommand.CommandText = text;
                    int result = dbCommand.ExecuteNonQuery();
                    dbCommand.Parameters.Clear();
                    dbCommand.Dispose();
                    return(result);
                }
            }
            catch (Exception ex)
            {
                DebugCenter.GetInstance().appendToFile("DBERROR~~~~~~~~~~~DBERROR : " + ex.Message + "\n" + ex.StackTrace);
                try
                {
                    dbCommand.Dispose();
                }
                catch
                {
                }
            }
            return(-1);
        }
Example #21
0
        public static int InsertRackEffect(string str_sql, DateTime dt_inserttime)
        {
            if (DBUrl.SERVERMODE)
            {
                WorkQueue <string> .getInstance_rackeffect().WorkSequential = true;

                WorkQueue <string> .getInstance_rackeffect().EnqueueItem(str_sql);

                return(1);
            }
            if (DBUrl.DB_CURRENT_TYPE.ToUpper().Equals("MYSQL"))
            {
                WorkQueue <string> .getInstance_rackeffect().WorkSequential = true;

                WorkQueue <string> .getInstance_rackeffect().EnqueueItem(str_sql);

                return(1);
            }
            DBConn    dBConn    = null;
            DbCommand dbCommand = null;

            try
            {
                dBConn = DBConnPool.getThermalConnection();
                if (dBConn != null && dBConn.con != null)
                {
                    dbCommand = dBConn.con.CreateCommand();
                }
                dbCommand.CommandText = str_sql.Replace("'", "#");
                dbCommand.ExecuteNonQuery();
                dbCommand.Dispose();
                dBConn.Close();
                return(1);
            }
            catch (Exception ex)
            {
                try
                {
                    dbCommand.Dispose();
                }
                catch
                {
                }
                try
                {
                    dBConn.Close();
                }
                catch
                {
                }
                DebugCenter.GetInstance().appendToFile("DBERROR~~~~~~~~~~~Generate RackEffect Error : " + ex.Message + "\n" + ex.StackTrace);
            }
            return(-1);
        }
Example #22
0
        private void baseListen()
        {
            bool flag = true;

            while (this.isListening)
            {
                byte[] array = new byte[63488];
                System.Net.EndPoint endPoint = null;
                try
                {
                    endPoint          = new System.Net.IPEndPoint(this.ipAddress, this.port);
                    this.serverSocket = new System.Net.Sockets.Socket(System.Net.Sockets.AddressFamily.InterNetwork, System.Net.Sockets.SocketType.Dgram, System.Net.Sockets.ProtocolType.Udp);
                    this.serverSocket.Bind(endPoint);
                    if (flag)
                    {
                        DebugCenter.GetInstance().clearStatusCode(DebugCenter.ST_TrapPortNA, true);
                        flag = false;
                    }
                    this.serverSocket.SetSocketOption(System.Net.Sockets.SocketOptionLevel.Socket, System.Net.Sockets.SocketOptionName.ReceiveTimeout, 0);
                    int num = this.serverSocket.ReceiveFrom(array, System.Net.Sockets.SocketFlags.None, ref endPoint);
                    if (num > 0 && this.isListening)
                    {
                        string[] separator = new string[]
                        {
                            ":"
                        };
                        string[]       array2         = endPoint.ToString().Split(separator, System.StringSplitOptions.None);
                        SocketMessager socketMessager = new SocketMessager();
                        socketMessager.Target    = array2[0];
                        socketMessager.Port      = System.Convert.ToInt32(array2[1]);
                        socketMessager.DataLenth = num;
                        socketMessager.DataBytes = array;
                        System.Threading.ThreadPool.QueueUserWorkItem(new System.Threading.WaitCallback(this.waitCallback), socketMessager);
                    }
                }
                catch (System.Exception)
                {
                    try
                    {
                        System.Threading.Thread.Sleep(100);
                    }
                    catch (System.Exception)
                    {
                    }
                }
                finally
                {
                    if (this.serverSocket != null)
                    {
                        this.serverSocket.Close();
                    }
                }
            }
        }
Example #23
0
 public EnqueueEventArgs(object item)
 {
     try
     {
         this.Item = (T)((object)item);
     }
     catch (Exception ex)
     {
         DebugCenter.GetInstance().appendToFile("DBERROR~~~~~~~~~~~DBERROR : " + ex.Message + "\n" + ex.StackTrace);
         throw new InvalidCastException("object to T failed");
     }
 }
Example #24
0
        public static int InsertBillReport(string str_title, string str_writer, DateTime dt_time, string str_path)
        {
            int       result    = -1;
            DBConn    dBConn    = null;
            DbCommand dbCommand = null;

            try
            {
                dBConn = DBConnPool.getConnection();
                if (dBConn.con != null)
                {
                    dbCommand = DBConn.GetCommandObject(dBConn.con);
                    if (DBUrl.SERVERMODE)
                    {
                        string commandText = "insert into reportbill(Title,Writer,ReportTime,ReportPath) values(?Title,?Writer,?ReportTime,?ReportPath)";
                        dbCommand.CommandText = commandText;
                        dbCommand.Parameters.Add(DBTools.GetParameter("?Title", str_title, dbCommand));
                        dbCommand.Parameters.Add(DBTools.GetParameter("?Writer", str_writer, dbCommand));
                        dbCommand.Parameters.Add(DBTools.GetParameter("?ReportTime", dt_time.ToString("yyyy-MM-dd HH:mm:ss"), dbCommand));
                        dbCommand.Parameters.Add(DBTools.GetParameter("?ReportPath", str_path, dbCommand));
                    }
                    else
                    {
                        string commandText = "insert into reportbill(Title,Writer,ReportTime,ReportPath) values(?,?,?,?)";
                        dbCommand.CommandText = commandText;
                        dbCommand.Parameters.Add(DBTools.GetParameter("@Title", str_title, dbCommand));
                        dbCommand.Parameters.Add(DBTools.GetParameter("@Writer", str_writer, dbCommand));
                        dbCommand.Parameters.Add(DBTools.GetParameter("@ReportTime", dt_time.ToString("yyyy-MM-dd HH:mm:ss"), dbCommand));
                        dbCommand.Parameters.Add(DBTools.GetParameter("@ReportPath", str_path, dbCommand));
                    }
                    result = dbCommand.ExecuteNonQuery();
                    return(result);
                }
            }
            catch (Exception ex)
            {
                DebugCenter.GetInstance().appendToFile("DBERROR~~~~~~~~~~~DBERROR : " + ex.Message + "\n" + ex.StackTrace);
            }
            finally
            {
                if (dbCommand != null)
                {
                    dbCommand.Dispose();
                }
                if (dBConn.con != null)
                {
                    dBConn.Close();
                }
            }
            return(result);
        }
Example #25
0
 public void QueueWork(object sender, WorkQueue <Dictionary <string, Dictionary <string, Dictionary <string, string> > > > .EnqueueEventArgs e)
 {
     if (this.con == null || this.con.State != ConnectionState.Open)
     {
         if (this.con != null)
         {
             try
             {
                 this.con.Close();
             }
             catch (Exception)
             {
             }
         }
         try
         {
             if (DBUrl.SERVERMODE)
             {
                 this.con = this.getConnection();
             }
             else
             {
                 string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + DBUrl.DEFAULT_HOST_PATH + ";Jet OLEDB:Database Password="******"DBERROR~~~~~~~~~~~DBERROR : " + ex.Message + "\n" + ex.StackTrace);
         }
     }
     try
     {
         Dictionary <string, Dictionary <string, Dictionary <string, string> > > item = e.Item;
         foreach (KeyValuePair <string, Dictionary <string, Dictionary <string, string> > > current in item)
         {
             string key = current.Key;
             Dictionary <string, Dictionary <string, string> > value = current.Value;
             InSnergyGateway.RefreshGateWay(key, value, this.con);
             if (GateWayRefreshQueue.CBWork != null)
             {
                 GateWayRefreshQueue.CBWork(key);
             }
         }
     }
     catch (Exception ex2)
     {
         DebugCenter.GetInstance().appendToFile("DBERROR~~~~~~~~~~~DBERROR : " + ex2.Message + "\n" + ex2.StackTrace);
     }
 }
Example #26
0
 public bool Start()
 {
     DebugCenter.GetInstance().appendToFile("Start DBCache Event Processor " + this._threadName + " thread");
     Interlocked.Exchange(ref this._stopping, 0);
     this._stoppedEvent.Reset();
     this._abortEvent.Reset();
     DBCacheStatus._dbSyncEvent.Reset();
     this._waitHandles[0]  = this._abortEvent;
     this._waitHandles[1]  = DBCacheStatus._dbSyncEvent;
     this._procThread      = new Thread(new ParameterizedThreadStart(this.WorkThread));
     this._procThread.Name = this._threadName;
     this._procThread.Start();
     return(true);
 }
Example #27
0
 public PortInfo(int l_did, int i_portnum)
 {
     try
     {
         Hashtable devicePortMap = DBCache.GetDevicePortMap();
         Hashtable portCache     = DBCache.GetPortCache();
         if (devicePortMap != null && devicePortMap.Count > 0 && portCache != null && portCache.Count > 0 && devicePortMap.ContainsKey(l_did))
         {
             List <int> list = (List <int>)devicePortMap[l_did];
             if (list != null)
             {
                 foreach (int current in list)
                 {
                     PortInfo portInfo = (PortInfo)portCache[current];
                     if (portInfo != null && portInfo.PortNum == i_portnum)
                     {
                         this.id                 = portInfo.ID;
                         this.device_id          = portInfo.DeviceID;
                         this.port_num           = portInfo.PortNum;
                         this.port_nm            = portInfo.PortName;
                         this.max_voltage        = portInfo.Max_voltage;
                         this.min_voltage        = portInfo.Min_voltage;
                         this.max_power_diss     = portInfo.Max_power_diss;
                         this.min_power_diss     = portInfo.Min_power_diss;
                         this.max_power          = portInfo.Max_power;
                         this.min_power          = portInfo.Min_power;
                         this.max_current        = portInfo.Max_current;
                         this.min_current        = portInfo.Min_current;
                         this.port_confirmation  = portInfo.OutletConfirmation;
                         this.port_ondelay_time  = portInfo.OutletOnDelayTime;
                         this.port_offdelay_time = portInfo.OutletOffDelayTime;
                         this.shutdown_method    = portInfo.OutletShutdownMethod;
                         try
                         {
                             this.port_mac = portInfo.OutletMAC;
                         }
                         catch
                         {
                             this.port_mac = "";
                         }
                     }
                 }
             }
         }
     }
     catch (Exception ex)
     {
         DebugCenter.GetInstance().appendToFile("DBERROR~~~~~~~~~~~DBERROR : " + ex.Message + "\n" + ex.StackTrace);
     }
 }
Example #28
0
 public RawInput(IntPtr parentHandle)
 {
     try
     {
         base.AssignHandle(parentHandle);
         RawInput._rawinputDriver = new RawInputDriver(parentHandle);
         RawInput._rawinputDriver.EnumerateDevices();
         this._devNotifyHandle = RawInput.RegisterForDeviceNotifications(parentHandle);
     }
     catch (Exception ex)
     {
         DebugCenter.GetInstance().appendToFile(ex.Message + "\r\n" + ex.StackTrace);
     }
 }
Example #29
0
 private void createDirection()
 {
     try
     {
         if (!Directory.Exists(this.path))
         {
             Directory.CreateDirectory(this.path);
         }
     }
     catch (Exception ex)
     {
         DebugCenter.GetInstance().appendToFile("DBERROR~~~~~~~~~~~DBERROR : " + ex.Message + "\n" + ex.StackTrace);
     }
 }
Example #30
0
        public static int UpdateGroupStatus(int i_selectflag, string str_groups)
        {
            int       result    = -1;
            DBConn    dBConn    = null;
            DbCommand dbCommand = null;

            try
            {
                dBConn = DBConnPool.getConnection();
                if (dBConn.con != null)
                {
                    dbCommand             = DBConn.GetCommandObject(dBConn.con);
                    dbCommand.CommandType = CommandType.Text;
                    string commandText = string.Concat(new object[]
                    {
                        "update data_group set isselect = ",
                        i_selectflag,
                        " where id in (",
                        str_groups,
                        " )"
                    });
                    dbCommand.CommandText = commandText;
                    result = dbCommand.ExecuteNonQuery();
                    DBCacheStatus.Group = true;
                    DBCacheStatus.DBSyncEventSet(true, new string[]
                    {
                        "DBSyncEventName_Service_Group"
                    });
                }
            }
            catch (Exception ex)
            {
                DebugCenter.GetInstance().appendToFile("DBERROR~~~~~~~~~~~DBERROR : " + ex.Message + "\n" + ex.StackTrace);
            }
            finally
            {
                try
                {
                    dbCommand.Dispose();
                }
                catch
                {
                }
                if (dBConn != null)
                {
                    dBConn.close();
                }
            }
            return(result);
        }