asp.net²Ù×÷word
http://www.cnblogs.com/jinglelin/archive/2005/09/02/228486.html
Éæ¼°µ½asp.net²Ù×÷wordµÄÎÊÌâ
½ñÄêÂ½ÐøÓÖÅöµ½²Ù×÷excel¡¢wordµÈofficeÎĵµ
ʹÓõͼÊÇInteropÏà¹Ødll£¬´ò¿ªofficeÏà¹Ø½ø³Ì½øÐвÙ×÷
ΪÃâÍü¼Ç£¬½«Ïà¹ØtipÕûÀíÈçÏ£º
1. ÒýÓÃÎļþ,¼¸¸ödll´ò°üÁË
2. ²Ù×÷word´úÂëʾÀý:
using ImportExportToOffice;
using Microsoft.ApplicationBlocks.Data;
protected void btnJianJie_Click(object sender, EventArgs e)
{
string sYear = DropDownList2.SelectedValue;
string sMonth = DropDownList1.SelectedValue;
string sDate1 = String.Format("{0}-{1}-{2}", sYear, sMonth, "1");
string sDate2 = String.Format("{0}-{1}-{2}", sYear, sMonth, System.DateTime.DaysInMonth(int.Parse(sYear), int.Parse(sMonth)).ToString());
word = new ImportExportToWord();
string sTmpUrl = "../Report/" + Guid.NewGuid().ToString() + ".Doc";
string sTmpFile = Server.MapPath(sTmpUrl);
string sModelDoc = Server.MapPath("../Report/¹ú¼ÊÂþÓμò±¨Ä£°å.doc");
System.IO.File.Copy(sModelDoc, sTmpFile, true);
try
{
word.Open(sTmpFile);
object sBookMark = "";
//GSM À´·Ãǰʮ ·Ö¹«Ë¾
sBookMark = "GSM_1";
if (word.Document.Bookmarks.Exists(sBookMark.ToString()))
{
word.Document.Bookmarks.get_Item(ref sBookMark).Select();
string sSql = "SELECT TOP 10 t1.ToCarrier, COUNT(t1.ToCarrier) AS Num, t2.ShortName AS Name" +
" from BiteGSM t1 INNER JOIN" +
" BranchInfo t2 ON t1.ToCarrier = t2.ID" +
" INNER JOIN DispatchInfo t3 ON t1.DispatchID = t3.ID" +
" Where t3.SendTime >='" + sDate1 + "'" +
" And t3.SendTime <='" + sDate2 + "'" +
" And t1.SimType=1" +
" GROUP BY t1.ToCarrier, t2.ShortName" +
" ORDER BY COUNT(t1.ToCarrier) DESC";
SqlDa
Ïà¹ØÎĵµ£º
×î½ü£¬Òª°ÑÒ»¸öC/S½á¹¹µÄ³ÌÐò¸Ä³ÉB/S½á¹¹¡£ÆäÖоÍÓöµ½ÁË´òÓ¡µÄÎÊÌâ¡£Ñо¿ÁËһϣ¬webÏ´òÓ¡·½·¨´ó¸ÅÓÐÕâô¼¸ÖÖ£º
1¡¢ÀûÓÃIEÖ±½Ó´òÓ¡£¬ÕâÖÖ·½Ê½×î·½±ã£¬µ«ÊÇ¿ØÖÆÄÜÁ¦½Ï²î¡£
2¡¢ÀûÓÃACTIVE¿Ø¼þ£¬¿ÉÒÔ×Ô¼º×öÒ»¸öIEµÄ¿Ø¼þÀ´¿ØÖÆ´òÓ¡¡£
3¡¢Ë®¾§±¨±íµÈµÚÈý·½¹¤¾ß£¬¹ºÂò¼Û¸ñ°º¹ó¡£
¸ù¾ÝÎÒµÄÐèÇóÇé¿ö£¬ÓÃIEÖ ......
IIS×ÔÉíÊDz»ÄÜ´¦ÀíÏñASPXÀ©Õ¹ÃûÕâÑùµÄÒ³Ãæ£¬Ö»ÄÜÖ±½ÓÇëÇóÏñHTMLÕâÑùµÄ¾²Ì¬Îļþ£¬Ö®ËùÒÔÄÜ´¦ÀíASPXÕâÑùÀ©Õ¹ÃûµÄÒ³Ãæ£¬ÊÇÒòΪIISÓÐÒ»¸öISAPI¹ýÂËÆ÷£¬ËüÊÇÒ»¸öCOM×é¼þ¡£ASP.NET·þÎñÔÚ×¢²áµ½IISµÄʱºò£¬¾Í»áÌí¼ÓÒ»¸öWin32µÄÀ©Õ¹¶¯Ì¬¿âaspnet_isapi.dll¡£²¢½«À©Õ¹¿ÉÒÔ´¦ÀíµÄÒ³ÃæÀ©Õ¹Ãû£¨ÈçASPX£©×¢²áµ½IISÀïÃæ¡£À©Õ¹Æô¶¯ºó£¬¾Í¸ù ......
ʲôÊÇMVCģʽ
MVC£¨Model-View-Controller£¬Ä£ÐÍ—ÊÓͼ—¿ØÖÆÆ÷ģʽ£©ÓÃÓÚ±íʾһÖÖÈí¼þ¼Ü¹¹Ä£Ê½¡£Ëü°ÑÈí¼þϵͳ·ÖΪÈý¸ö»ù±¾²¿·Ö£ºÄ£ÐÍ£¨Model£©£¬ÊÓͼ£¨View£©ºÍ¿ØÖÆÆ÷£¨Controller£©¡£
ÄÇôMVCģʽºÍÎÒÃÇÊìϤµÄWebFormģʽÓÐʲô²»Í¬ÄØ£¿ËûµÄ¸÷¸ö²¿·ÖÓÖÊÇÔõÑù·Ö¹¤µÄÄØ£¿
ÎÒÃÇÏÈÀ´¿´Ò»ÏÂÆÕͨµÄWebFormģʽÏ£ ......
´Ë½Ì³ÌÏòÄãÌṩ ASP.NET MVC ÊÓͼ¼ò½é, ÊÓͼÊý¾Ý, ºÍ HTML Helpers¡£½Ì³Ì×îºó£¬ÄãÓ¦¸Ã»áÀí½âÈçºÎ´´½¨ÐÂÊÓͼ£¬´Ó¿ØÖÆÆ÷´«µÝÊý¾Ýµ½ÊÓͼ£¬ºÍʹÓà use HTML Helpers ÔÚÊÓͼÖÐÉú³ÉÄÚÈÝ¡£
Àí½âÊÓͼ
²»Ïñ ASP.NET »òÕßASP, ASP.NET MVC ²¢²»°üÀ¨ÈκÎÖ±½Ó¶ÔÓ¦Ò³ÃæµÄ¶«Î÷¡£ ÔÚ ASP.NET MVC Ó¦ÓóÌÐòÖУ¬Ó²ÅÌÉϲ¢²»´ ......
Ò³ÃæÖÐÒýÈ룺
using System.Net;
using System.IO;
ÏÂÃæÁ½¸ö·½·¨£¬½á¹û¶¼ÊÇÒ»Ñù£¬¶¼¿ÉÒÔÏÂÔØÍøÕ¾ÉϵÄͼƬ£»
private void Sava1()
{
string url = "http://192.234.86.15/Maplink//05/000/000/013/000/000/006.png";
WebRequest wreq = WebRequest.Create(url);
HttpWebResp ......