static void MoveMail(object source, System.Timers.ElapsedEventArgs e) { NotesUtils pNotesUtils = null; Console.WriteLine("Notes Move!"); System.Timers.Timer pp = (System.Timers.Timer)source; pp.Enabled = false; try { //pNotesUtils = new NotesUtils(pNotesSession, "mail9you/runstar", "mail\\费亚平.nsf"); pNotesUtils = new NotesUtils(pNotesSession, "mail9you/runstar", "mail\\netadmin.nsf"); if (pNotesUtils.OpenDataBase("netadmin", "12341234")) { if (pNotesUtils.MoveMailInfo()) { } else { Console.ForegroundColor = ConsoleColor.Yellow; Console.WriteLine("Notes Move Exception : " + pNotesUtils.Message); Console.ForegroundColor = ConsoleColor.Gray; Console.WriteLine(""); } } else { Console.ForegroundColor = ConsoleColor.Yellow; Console.WriteLine("Notes Connect Exception : " + pNotesUtils.Message); Console.ForegroundColor = ConsoleColor.Gray; Console.WriteLine(""); } } catch (Exception ex) { Console.ForegroundColor = ConsoleColor.Yellow; Console.WriteLine("Notes Save Exception : " + ex.Message); Console.ForegroundColor = ConsoleColor.Gray; Console.WriteLine(""); } finally { if (pNotesUtils != null) { pNotesUtils.Dispose(); } } pp.Enabled = true; }
static void SendAuLog(object source, System.Timers.ElapsedEventArgs e) { NotesUtils pNotesUtils = null; try { string str_sql = "SELECT * FROM Au_Log"; MSSQLOperate pSendLog = new MSSQLOperate(strAnalyse); pSendLog.Connect(false); pSendLog.ExecuteQuery(str_sql); pSendLog.GetResult(RecordStyle.DATASET); DataSet pSet = (DataSet)pSendLog.RecordData; string _str = null; if (pSendLog.AffectRow > 0) { for (int i = 0; i < pSendLog.AffectRow; i++) { for (int j = 0; j < pSet.Tables[0].Columns.Count; j++) { _str += pSet.Tables[0].Rows[i][j].ToString(); _str += "\a\t\a\t"; } _str += "\r\n"; } //pNotesUtils = new NotesUtils(pNotesSession, "mail9you/runstar", "mail\\费亚平.nsf"); pNotesUtils = new NotesUtils(pNotesSession, "mail9you/runstar", "mail\\netadmin.nsf"); if (pNotesUtils.OpenDataBase("黄恒泰", "12341234")) { pNotesUtils.SendMailInfo("", "", "Au日志", _str); } } } catch { } finally { if (pNotesUtils != null) { pNotesUtils.Dispose(); } } }
static void CheckMail(object source, System.Timers.ElapsedEventArgs e) { NotesUtils pNotesUtils = null; Console.WriteLine("Notes Check:"); System.Timers.Timer pp = (System.Timers.Timer)source; pp.Enabled = false; try { //pNotesUtils = new NotesUtils(pNotesSession, "mail9you/runstar", "mail\\费亚平.nsf"); pNotesUtils = new NotesUtils(pNotesSession, "mail9you/runstar", "mail\\netadmin.nsf"); if (pNotesUtils.OpenDataBase("netadmin", "12341234")) { if (pNotesUtils.GetMailInfo()) { MSSQLOperate pSaveMail = new MSSQLOperate(strAnalyse); CustomDataCollection pMailStruct = (CustomDataCollection)pNotesUtils.Records; CustomData[,] pMailInfo = pMailStruct[-1]; for (int i = 0; i < pMailStruct.RowCount; i++) { pSaveMail.Connect(false); string strProcParams = "SP_PUT_NOTESCONTENT"; DbParameter[] paramCache = DataUtilities.GetParameters(strProcParams); #region if (paramCache == null) { paramCache = new SqlParameter[] { new SqlParameter("@iFailure", SqlDbType.Int, 4), new SqlParameter("@iCategory", SqlDbType.Int, 4), new SqlParameter("@strUID", SqlDbType.VarChar, 100), new SqlParameter("@strPUID", SqlDbType.VarChar, 100), new SqlParameter("@strSubject", SqlDbType.VarChar, 100), new SqlParameter("@dtPost", SqlDbType.DateTime), new SqlParameter("@strSender", SqlDbType.VarChar, 50), new SqlParameter("@strRecive", SqlDbType.Text), new SqlParameter("@strContent", SqlDbType.Text), new SqlParameter("@strCount", SqlDbType.VarChar, 100), new SqlParameter("@iView", SqlDbType.Int, 4), new SqlParameter("@iGroup", SqlDbType.Int, 4) }; DataUtilities.SetParameters(strProcParams, paramCache); } paramCache[0].Value = 0; paramCache[1].Value = 0; paramCache[2].Value = pMailInfo[i, 0].Content; paramCache[3].Value = pMailInfo[i, 1].Content; paramCache[4].Value = pMailInfo[i, 2].Content; paramCache[5].Value = pMailInfo[i, 4].Content; paramCache[6].Value = pMailInfo[i, 3].Content; paramCache[7].Value = pMailInfo[i, 5].Content; paramCache[8].Value = pMailInfo[i, 6].Content; paramCache[9].Value = pMailInfo[i, 7].Content; paramCache[10].Value = 0; paramCache[11].Value = 2; #endregion pSaveMail.ExecuteQuery(false, strProcParams, paramCache); pSaveMail.GetResult(RecordStyle.NONE); } #region Console.ForegroundColor = ConsoleColor.Yellow; Console.WriteLine("Notes Recive Count : " + pMailStruct.RowCount); Console.ForegroundColor = ConsoleColor.Gray; Console.WriteLine(""); #endregion } else { #region Console.ForegroundColor = ConsoleColor.Yellow; Console.WriteLine("Notes Recive Exception : " + pNotesUtils.Message); Console.ForegroundColor = ConsoleColor.Gray; Console.WriteLine(""); #endregion } } else { #region Console.ForegroundColor = ConsoleColor.Yellow; Console.WriteLine("Notes Connect Exception : " + pNotesUtils.Message); Console.ForegroundColor = ConsoleColor.Gray; Console.WriteLine(""); #endregion } } catch (Exception ex) { #region Console.ForegroundColor = ConsoleColor.Yellow; Console.WriteLine("Notes Save Exception : " + ex.Message); Console.ForegroundColor = ConsoleColor.Gray; Console.WriteLine(""); #endregion } finally { if (pNotesUtils != null) { pNotesUtils.Dispose(); } } pp.Enabled = true; }