函数写入数据库时​​，它不应该

Question

我有一个间隔为1秒的计时器。我每秒都会调用这个函数来检查操作系统的最后输入时间。如果函数返回的时间超过600（10分钟），我会调用另一个函数将内容写入数据库。

问题出现在这里，而不是插入一行到数据库中，该函数将在同一秒内创建许多记录。我不知道为什么会发生这种情况。调试时不会发生这种情况。

public void elapsedGetIdleCount(object source, ElapsedEventArgs e) 
    { 
     uint result = GetLastInputTime(); 

     if (result >= 600) 
     { 
      result = 0; 
      tmrIdle.Stop(); 

      try 
      { 
       XmlDocument xDoc = new XmlDocument(); 
       xDoc.Load(@"C:/Users/" + Environment.UserName + "/AppData/Roaming/3CXPhone for Windows/3CXPhone.xml"); 
       var element = xDoc.SelectSingleNode("Accounts/Profiles/Profile/AuthUser"); 
       var extension = element.InnerText.ToString(); 

       SetQueueStatus("LoggedOUT", "Inactivity"); 

       DialogResult mb = MessageBox.Show("You have been Logged Out of the Queues due to inactivity!", "WARNING", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); 

       if (mb == DialogResult.OK) 
       { 
        ChangeQueueStatusColor(); 
       } 
      } 
      catch (Exception ex) 
      { 
       MessageBox.Show(ex.Message); 
      } 
     } 
    } 

public void SetQueueStatus(string status, string eventDesc) 
    { 
     try 
     { 
      XmlDocument xDoc = new XmlDocument(); 
      xDoc.Load(@"C:/Users/" + Environment.UserName + "/AppData/Roaming/3CXPhone for Windows/3CXPhone.xml"); 
      var element = xDoc.SelectSingleNode("Accounts/Profiles/Profile/AuthUser"); 
      var extension = element.InnerText.ToString(); 

      string conString = "Data Source = lewcomp1\\COMPLIANCE; Initial Catalog = ComplianceData; Integrated Security = True"; 

      using (SqlConnection myCon = new SqlConnection(conString)) 
      { 
       using (SqlCommand myCMD = new SqlCommand()) 
       { 
        myCMD.Connection = myCon; 
        myCMD.CommandText = "UPDATE eData SET QueueStatus = '" + status + "', Extension = '" + extension + "' WHERE UserName LIKE '" + lblUserName.Text + "';"; 
        SqlDataReader myReader; 

        myCon.Open(); 
        myReader = myCMD.ExecuteReader(); 
        myReader.Read(); 
        myCon.Close(); 

        myCMD.CommandText = "INSERT INTO eQueueData (Date_Time, UserName, Extension, EventID, EventDesc) VALUES ('" + DateTime.Now + "','" + lblUserName.Text + "','" + extension + "','" + status + "','" + eventDesc + "');"; 
        myCon.Open(); 
        myReader = myCMD.ExecuteReader(); 
        myReader.Read(); 
        myCon.Close(); 
       } 
      } 
     } 
     catch (Exception ex) 
     { 
      MessageBox.Show(ex.Message); 
     } 
    } 

static uint GetLastInputTime() 
    { 
     uint idleTime = 0; 
     LASTINPUTINFO lastInputInfo = new LASTINPUTINFO(); 
     lastInputInfo.cbSize = (uint)Marshal.SizeOf(lastInputInfo); 
     lastInputInfo.dwTime = 0; 

     uint envTicks = (uint)Environment.TickCount; 

     if (GetLastInputInfo(ref lastInputInfo)) 
     { 
      uint lastInputTick = lastInputInfo.dwTime; 

      idleTime = envTicks - lastInputTick; 
     } 
     return ((idleTime > 0) ? (idleTime/1000) : 0); 
    } 

Answer 1

从你的代码，我敢肯定，这个程序被调用多次。可能的原因：

• 事件
• 几个地方调用这个独立

放置一个破发点，并观察调用栈的多个abonnement ...

一个想法可能是要么使用要标记的静态标记，由于不活动而注销的过程正在运行并拒绝再次进入该过程。

另一个想法是设置一个值，你lastInputTick保证，下一次通话将获得低于600的答案...