예제 #1
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);
        }
예제 #2
0
        public static void DeleteOverallRemainLastSomeHours(int hours, DateTime currentTime)
        {
            DateTime dateTime = currentTime.AddHours((double)(-(double)hours));

            Convert.ToDateTime(dateTime.ToString("yyyy-MM-dd HH:mm:ss"));
            string text = "delete from rack_effect where insert_time < #" + dateTime.ToString("yyyy-MM-dd HH:mm:ss") + "#";

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

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

                return;
            }
            DBConn    dBConn    = null;
            DbCommand dbCommand = new OleDbCommand();

            try
            {
                dBConn = DBConnPool.getThermalConnection();
                if (dBConn != null && dBConn.con != null)
                {
                    dbCommand             = dBConn.con.CreateCommand();
                    dbCommand.CommandType = CommandType.Text;
                    dbCommand.CommandText = text;
                    dbCommand.ExecuteNonQuery();
                }
                dbCommand.Dispose();
                dBConn.Close();
            }
            catch (Exception ex)
            {
                try
                {
                    dbCommand.Dispose();
                }
                catch
                {
                }
                try
                {
                    dBConn.Close();
                }
                catch
                {
                }
                DebugCenter.GetInstance().appendToFile("Delete Rack effect: " + ex.Message + "\n" + ex.StackTrace);
            }
        }
예제 #3
0
        private static int setExpiry4thermal(string strV, int iType)
        {
            DBConn    dBConn    = null;
            DbCommand dbCommand = null;

            try
            {
                dBConn = DBConnPool.getThermalConnection();
                if (dBConn != null && dBConn.con != null)
                {
                    dbCommand = dBConn.con.CreateCommand();
                    switch (iType)
                    {
                    case 0:
                        try
                        {
                            dbCommand.CommandText = "create table sys_info (sysid varchar(255) )";
                            dbCommand.ExecuteNonQuery();
                            dbCommand.CommandText = "insert into sys_info (sysid ) values ('" + strV + "' )";
                            dbCommand.ExecuteNonQuery();
                            int result = 1;
                            return(result);
                        }
                        catch
                        {
                            int result = -1;
                            return(result);
                        }
                        break;

                    case 1:
                        break;

                    case 2:
                        goto IL_A8;

                    case 3:
                        goto IL_CE;

                    default:
                        goto IL_F4;
                    }
                    try
                    {
                        dbCommand.CommandText = "insert into sys_info (sysid ) values ('" + strV + "' )";
                        dbCommand.ExecuteNonQuery();
                        int result = 1;
                        return(result);
                    }
                    catch
                    {
                        int result = -1;
                        return(result);
                    }
                    try
                    {
IL_A8:
                        dbCommand.CommandText = "update sys_info set sysid = '" + strV + "'";
                        dbCommand.ExecuteNonQuery();
                        int result = 1;
                        return(result);
                    }
                    catch
                    {
                        int result = -1;
                        return(result);
                    }
                    try
                    {
IL_CE:
                        dbCommand.CommandText = "update sys_info set sysid = '" + strV + "'";
                        dbCommand.ExecuteNonQuery();
                        int result = 1;
                        return(result);
                    }
                    catch
                    {
                        int result = -1;
                        return(result);
                    }
                }
                IL_F4 :;
            }
            catch
            {
                int result = -1;
                return(result);
            }
            finally
            {
                try
                {
                    dbCommand.Dispose();
                }
                catch
                {
                }
                if (dBConn != null)
                {
                    try
                    {
                        dBConn.close();
                    }
                    catch
                    {
                    }
                }
            }
            return(-1);
        }
예제 #4
0
        private static string getExpiryfromthermal()
        {
            DBConn    dBConn    = null;
            DbCommand dbCommand = null;

            try
            {
                dBConn = DBConnPool.getThermalConnection();
                if (dBConn != null && dBConn.con != null)
                {
                    string result;
                    if (DBUtil.DetermineTableExist(dBConn.con, "sys_info"))
                    {
                        dbCommand             = dBConn.con.CreateCommand();
                        dbCommand.CommandText = "select * from sys_info ";
                        object obj = dbCommand.ExecuteScalar();
                        if (obj != null && obj != DBNull.Value)
                        {
                            string text = Convert.ToString(obj);
                            if (text.Length == 0)
                            {
                                result = "VALUENULL";
                                return(result);
                            }
                            try
                            {
                                text   = AESEncryptionUtility.Decrypt(text, "evaluate_date-time");
                                result = text;
                                return(result);
                            }
                            catch
                            {
                                result = "FATAL";
                                return(result);
                            }
                        }
                        result = "NOVALUE";
                        return(result);
                    }
                    result = "NOTABLE";
                    return(result);
                }
            }
            catch (Exception)
            {
                string result = "";
                return(result);
            }
            finally
            {
                try
                {
                    dbCommand.Dispose();
                }
                catch
                {
                }
                if (dBConn != null)
                {
                    try
                    {
                        dBConn.close();
                    }
                    catch
                    {
                    }
                }
            }
            return("");
        }