C# 同步工作站与SQL服务器的时间,设置本机时间

本文转载：http://www.csframework.com/archive/2/arc-2-20130101-1971.htm

 

   C# Code: 
  

/// 
    
  <summary> 
   
 
  /// 
   设置本机时间 
 
  /// 
    
  </summary> 
    
  
 
  public  
  class LocalTimeSync 
  
{ 
  
   [DllImport( 
  " 
  Kernel32.dll 
  ")] 
  
    
  public  
  static  
  extern  
  bool SetSystemTime( 
  ref SystemTime sysTime); 
  
    
  
   [DllImport( 
  " 
  Kernel32.dll 
  ")] 
  
    
  public  
  static  
  extern  
  void GetSystemTime( 
  ref SystemTime sysTime); 
  
    
  
   [StructLayout(LayoutKind.Sequential)] 
  
    
  public  
  struct SystemTime 
  
   { 
  
       
  public  
  ushort wYear; 
  
       
  public  
  ushort wMonth; 
  
       
  public  
  ushort wDayOfWeek; 
  
       
  public  
  ushort wDay; 
  
       
  public  
  ushort wHour; 
  
       
  public  
  ushort wMinute; 
  
       
  public  
  ushort wSecond; 
  
       
  public  
  ushort wMiliseconds; 
  
   } 
  
    
  /// 
    
  <summary> 
   
    
  /// 
   设置本机时间 
    
  /// 
    
  </summary> 
    
  
    
  public  
  static  
  void SyncTime(DateTime currentTime) 
  
   { 
  
      SystemTime sysTime =  
  new SystemTime(); 
  
      sysTime.wYear = Convert.ToUInt16(currentTime.Year); 
  
      sysTime.wMonth = Convert.ToUInt16(currentTime.Month); 
  
      sysTime.wDay = Convert.ToUInt16(currentTime.Day); 
  
      sysTime.wDayOfWeek = Convert.ToUInt16(currentTime.DayOfWeek); 
  
      sysTime.wMinute = Convert.ToUInt16(currentTime.Minute); 
  
      sysTime.wSecond = Convert.ToUInt16(currentTime.Second); 
  
      sysTime.wMiliseconds = Convert.ToUInt16(currentTime.Millisecond); 
  
       
  
       
  // 
  处理北京时间  
  
       
  int nBeijingHour = currentTime.Hour -  
  8; 
  
       
  if (nBeijingHour <=  
  0) 
  
      { 
  
         nBeijingHour =  
  24; 
  
         sysTime.wDay = Convert.ToUInt16(currentTime.Day -  
  1); 
  
          
  // 
  sysTime.wDayOfWeek = Convert.ToUInt16(current.DayOfWeek - 1);  
  
      } 
  
       
  else 
  
      { 
  
         sysTime.wDay = Convert.ToUInt16(currentTime.Day); 
  
         sysTime.wDayOfWeek = Convert.ToUInt16(currentTime.DayOfWeek); 
  
      } 
  
      sysTime.wHour = Convert.ToUInt16(nBeijingHour); 
  
       
  
      SetSystemTime( 
  ref sysTime); 
  // 
  设置本机时间  
  
   } 
  
} 
  

// 
  来源:C/S框架网(www.csframework.com) QQ:1980854898 
  
 
  




  
  
C# Code: 
  


/// 
    
  <summary> 
   
 
  /// 
   同步服务器时间 
 
  /// 
    
  </summary> 
    
  
 
  public  
  void SyncServerTime() 
  
{ 
  
    
  string sql =  
  " 
  SELECT GETDATE() 
  "; 
  
    
  object o = DataProvider.Instance.ExecuteScalar(Globals.DEF_ATTEND_SYSTEM_DB, sql); 
  
   DateTime dt = ConvertEx.ToDateTimeEx(o); 
  
    
  // 
  LocalTimeSync.SyncTime(dt); 
   
    
  // 
  比较时间一致性  
  
    
  if (ConvertEx.ToCharYYYYMMDDHHMM(DateTime.Now) != ConvertEx.ToCharYYYYMMDDHHMM(dt)) 
  
   LocalTimeSync.SyncTime(dt); 
  // 
  同步服务器的时间  
  
}