91av视频/亚洲h视频/操亚洲美女/外国一级黄色毛片 - 国产三级三级三级三级

  • 大小: 82KB
    文件類型: .rar
    金幣: 2
    下載: 0 次
    發布日期: 2023-04-29
  • 語言: 其他
  • 標簽: C#??生成Excel??

資源簡介

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?????????????????????temp?=?Math.Abs(temp);
????????????????temp?=?temp?%?24;
????????????}
????????????catch
????????????{
????????????}
????????????_dateTime?=?_dateTime.AddHours(temp);//將初次執行時間定位到當天中指定的時間
????????????TimeSpan?ts_day?=?_dateTime?-?DateTime.Now;//比較執行時間和當前時間
????????????if?(ts_day.TotalSeconds?????????????{
????????????????_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個文件信息

評論

共有 條評論