資源簡介
1.定時自動生成excel文件,
2.定時發送郵件

代碼片段和文件信息
using?System;
using?System.Collections.Generic;
using?System.Linq;
using?System.Text;
using?System.Configuration;
using?System.Threading;
using?System.Data;
using?System.IO;
namespace?AutoSendMail
{
????public?class?doMain
????{
????????private?bool?isSeneMail?=?ConfigurationManager.AppSettings[“isSendMail“]?==?“true“???true?:?false;
????????private?bool?isSendMailWhenStartProgram?=?ConfigurationManager.AppSettings[“isSendMailWhenStartProgram“]?==?“true“???true?:?false;
????????private?string?fileSavedPath?=?ConfigurationManager.AppSettings[“fileSavedPath“];
????????private?int?doDay?=?Convert.ToInt32(ConfigurationManager.AppSettings[“doDay“]);
????????public?string?threadName;
????????int?times?=?0;
????????///?
????????///?啟動
????????///?
????????public?void?Run()
????????{
????????????DateTime?_dateTime?=?System.DateTime.Now.Date;
????????????double?temp?=?5;
????????????try
????????????{
????????????????temp?=?Convert.ToDouble(ConfigurationManager.AppSettings[“doTime“]);//執行時間點
????????????????if?(temp?0)
????????????????????temp?=?Math.Abs(temp);
????????????????temp?=?temp?%?24;
????????????}
????????????catch
????????????{
????????????}
????????????_dateTime?=?_dateTime.AddHours(temp);//將初次執行時間定位到當天中指定的時間
????????????TimeSpan?ts_day?=?_dateTime?-?DateTime.Now;//比較執行時間和當前時間
????????????if?(ts_day.TotalSeconds?-2?*?60?*?60)//當前時間大時,第doDay天執行
????????????{
????????????????_dateTime?=?_dateTime.AddDays(doDay);
????????????}
????????????Console.WriteLine(string.Format(“線程已啟動,本次執行時間應在{0}“?_dateTime));
????????????while?(true)
????????????{
????????????????//記錄監控的記錄
????????????????string?filepath?=?AppDomain.CurrentDomain.SetupInformation.Applicationbase;
????????????????//比較時間
????????????????TimeSpan?ts?=?DateTime.Now?-?_dateTime;
????????????????string?logStr;
????????????????string?errMsg?=?string.Empty;
????????????????bool?result?=?false;
????????????????if?(Math.Abs(ts.TotalMinutes)?<=?10?||?(times?==?0?&&?isSendMailWhenStartProgram))
????????????????{
????????????????????times++;
????????????????????StringBuilder?sb_log?=?new?StringBuilder(““);
????????????????????try
????????????????????{
????????????????????????logStr?=?string.Format(“開始執行:自動發送郵件---{0}“?DateTime.Now);
????????????????????????sb_log.AppendLine(logStr);
????????????????????????Console.WriteLine(logStr);
????????????????????????string?filePath?=?ConfigurationManager.AppSettings[“logPath“];
????????????????????????if?(filePath.Contains(“~/“))
????????????????????????????filePath?=?filePath.Replace(“~/“?filepath);
????????????????????????//logStr?=?string.Format(“???開始保存excel文件---{0}“?DateTime.Now.ToString(“yyyy-MM-dd?HH:mm:ss“));
????????????????????????//sb_log.AppendLine(logStr);
????????????????????????//Console.WriteLine(logStr);
????????????????????????//數據處理
????????????????????????//1.執行保存excel文件
????????????????????????#region
????????????????????????/*
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件???????1097??2013-07-04?17:46??AutoSendMail\AutoSendMail\App.config
?????文件???????3944??2013-07-01?10:28??AutoSendMail\AutoSendMail\AutoSendMail.csproj
?????文件??????19456??2013-07-04?18:10??AutoSendMail\AutoSendMail\bin\Debug\AutoSendMail.exe
?????文件???????1097??2013-07-04?17:46??AutoSendMail\AutoSendMail\bin\Debug\AutoSendMail.exe.config
?????文件??????34304??2013-07-04?18:10??AutoSendMail\AutoSendMail\bin\Debug\AutoSendMail.pdb
?????文件??????11608??2013-08-05?09:59??AutoSendMail\AutoSendMail\bin\Debug\AutoSendMail.vshost.exe
?????文件???????1097??2013-07-04?17:46??AutoSendMail\AutoSendMail\bin\Debug\AutoSendMail.vshost.exe.config
?????文件????????490??2010-03-17?22:39??AutoSendMail\AutoSendMail\bin\Debug\AutoSendMail.vshost.exe.manifest
?????文件???????7691??2013-06-29?17:17??AutoSendMail\AutoSendMail\bin\Debug\run.log
?????文件??????24542??2013-06-29?17:17??AutoSendMail\AutoSendMail\bin\Debug.rar
?????文件??????12062??2013-07-04?18:10??AutoSendMail\AutoSendMail\doMain.cs
?????文件???????3402??2013-07-04?18:08??AutoSendMail\AutoSendMail\ExlHandler\ExlClass.cs
?????文件???????9247??2013-06-29?10:23??AutoSendMail\AutoSendMail\LogHandler\Logger.cs
?????文件???????3474??2013-06-29?10:24??AutoSendMail\AutoSendMail\MailHandler\SendMail.cs
?????文件???????1161??2013-08-05?10:00??AutoSendMail\AutoSendMail\obj\x86\Debug\AutoSendMail.csproj.FileListAbsolute.txt
?????文件????????874??2013-07-04?18:10??AutoSendMail\AutoSendMail\obj\x86\Debug\AutoSendMail.csproj.ResolveComReference.cache
?????文件??????19456??2013-07-04?18:10??AutoSendMail\AutoSendMail\obj\x86\Debug\AutoSendMail.exe
?????文件??????34304??2013-07-04?18:10??AutoSendMail\AutoSendMail\obj\x86\Debug\AutoSendMail.pdb
?????文件???????6177??2013-07-04?18:10??AutoSendMail\AutoSendMail\obj\x86\Debug\DesignTimeResolveAssemblyReferencesInput.cache
?????文件????????725??2013-06-29?15:15??AutoSendMail\AutoSendMail\Program.cs
?????文件???????1356??2013-06-29?10:20??AutoSendMail\AutoSendMail\Properties\AssemblyInfo.cs
?????文件???????2005??2013-06-29?10:26??AutoSendMail\AutoSendMail\SqlHelper\MssqlDataAccess.cs
?????文件????????878??2013-06-29?10:20??AutoSendMail\AutoSendMail.sln
????..A..H.?????26112??2013-08-05?11:19??AutoSendMail\AutoSendMail.suo
?????目錄??????????0??2013-06-29?10:20??AutoSendMail\AutoSendMail\obj\x86\Debug\TempPE
?????目錄??????????0??2014-04-13?21:45??AutoSendMail\AutoSendMail\obj\x86\Debug
?????目錄??????????0??2014-04-13?21:45??AutoSendMail\AutoSendMail\bin\Debug
?????目錄??????????0??2013-06-29?11:02??AutoSendMail\AutoSendMail\bin\Release
?????目錄??????????0??2014-04-13?21:45??AutoSendMail\AutoSendMail\obj\x86
?????目錄??????????0??2014-04-13?21:45??AutoSendMail\AutoSendMail\bin
............此處省略11個文件信息
- 上一篇:flappybird全套圖片+音效
- 下一篇:時間序列insar技術與應用
評論
共有 條評論