所属分类：
SQL Server
开发工具：C#
文件大小：1981KB
下载次数：9
上传日期：2015-04-26 09:32:42
说明： SQL Server数据库查询自动导出发送工具,该工具可以在SQL Server数据库中执行SQL查询文件获取数据，并将结果自动保存为Excel 2007格式的文件，同时判断其大小是否大于邮件添加附件的最大容量。如果附件过大，则自动压缩为7z格式，否则立即发送附件给指定邮箱。并再次判断7z压缩包大小是否大于邮件添加附件的最大容量，如附件仍然过大，则发送共享文件路径，否则立即发送7z压缩包，从而省去了等待查询结果的时间。
(SQL Server query is sent automatically export tool that can SQL query file in the SQL Server to obtain data, and the results are automatically saved as Excel 2007 file format, while the message to determine its size is greater than the maximum capacity to add attachments. If the attachment is too large, it is automatically compressed 7z format, or attachments sent immediately to the specified mailbox. And judge again 7z archive size is greater than the maximum capacity of the message to add accessories such as accessories is still too large, it sends a shared file path, or sent immediately 7z archive, thus eliminating the need to wait for the results of the query time.)
文件列表：
QueryExporterAndPoster
......................\QueryExporterAndPoster
......................\......................\App.config,187,2015-04-11
......................\......................\bin
......................\......................\frmConnect.cs,8043,2015-04-11
......................\......................\frmConnect.designer.cs,17237,2015-04-11
......................\......................\frmConnect.resx,6627,2015-04-11
......................\......................\frmMain.cs,16826,2015-04-17
......................\......................\frmMain.Designer.cs,15512,2015-04-16
......................\......................\frmMain.resx,34715,2015-04-16
......................\......................\frmProperty.cs,524,2015-04-11
......................\......................\frmProperty.designer.cs,2230,2015-04-11
......................\......................\frmProperty.resx,5817,2015-04-11
......................\......................\lib-npoi
......................\......................\........\ICSharpCode.SharpZipLib.dll,200704,2014-07-03
......................\......................\........\NPOI.dll,1603072,2014-12-11
......................\......................\........\NPOI.OOXML.dll,421888,2014-12-11
......................\......................\........\NPOI.OOXML.XML,420479,2014-12-11
......................\......................\........\NPOI.OpenXml4Net.dll,85504,2014-12-11
......................\......................\........\NPOI.OpenXml4Net.XML,153211,2014-12-11
......................\......................\........\NPOI.OpenXmlFormats.dll,1873408,2014-12-11
......................\......................\........\NPOI.XML,2134991,2014-12-11
......................\......................\lib-SevenZipSharp
......................\......................\.................\7z.dll,1422336,2010-11-18
......................\......................\.................\SevenZipSharp.dll,151040,2015-04-16
......................\......................\obj
......................\......................\Program.cs,550,2015-04-11
......................\......................\Properties
......................\......................\..........\AssemblyInfo.cs,1476,2015-04-11
......................\......................\..........\Resources.Designer.cs,2874,2015-04-11
......................\......................\..........\Resources.resx,5612,2015-04-11
......................\......................\..........\Settings.Designer.cs,1109,2015-04-11
......................\......................\..........\Settings.settings,249,2015-04-11
......................\......................\QueryExporterAndPoster.csproj,5987,2015-04-17
......................\......................\SMO.cs,154177,2015-04-14
......................\QueryExporterAndPoster.sln,1035,2015-04-11
