дÁËÒ»¸ö´´½¨ÐéÄâĿ¼µÄ WebService ³ÌÐò£¬ÔÚ²âÊÔÔËÐÐʱ¿ÉÒԳɹ¦´´½¨£¬µ«ÆäËü³ÌÐòµ÷ÓÃʱ£¬ÌáʾûÓÐȨÏÞ´´½¨¡£
²éÁËһЩ×ÊÁÏ£¬ÔÚweb.configÀïÃæµÄ<system.web>ºó¼ÓÉÏÅäÖãº
<identity impersonate="true" userName="²Ù×÷ϵͳÓû§Ãû" password="Óû§¶ÔÓ¦µÄÃÜÂë" />
ÎÊÌâ½â¾ö¡£Ìش˼Ǽ£¬È¨×÷±¸Íü¡£ ......
×î½ü×ö¸öÏîÄ¿£¬ÐèÒªµ¼³öexcel£¬ÒªÖ÷´Ó±íÒ»Æðµ¼³öµÄ£¬¾Í´óÖÂдÁËÒ»¸ö·½·¨£¬¿ÉÄܸñʽ·½Ã滹ÊÇ»á½øÐÐÐ޸ģ¬ÏÈÌù³öÀ´·½±ãÒÔºó²é¿´
ÏîÄ¿ÒýÓÃ΢ÈíexcelµÄcomµÄdll¼´¿É
/// <summary>
/// ¹¦ÄÜ£ºµ¼³öÎļþ£¨Í¨¹ýÊý¾ÝÔ´µ¼³ö,¿ÉÖ÷´Ó±íµ¼³ö£©
/// </summary>
/// <param name="strTitle">ÎļþÃû×Ö</param>
/// <param name="mainDT">Ö÷±íÊý¾ÝÔ´</param>
/// <param name="dtParams">´Ó±íÊý¾ÝÔ´¼¯ºÏ</param>
public static void Export(string strTitle, System.Data.DataTable mainDT, params System.Data.DataTable[] dtParams)
{
GC.Collect();
Application oApp = new Application();
Workbooks oBooks = oApp.Workbooks;
Workbook oBook = oBooks.Add(true);
Worksheet oSheet = (Worksheet)oBook.ActiveSheet;
int _rowIndex = 4;//ÐÐË÷Òý
int _cellIndex = 1;//ÁÐË÷Òý
int _maxCellIndex = 1;//×î´óÁÐË÷Òý
int _mainRowIndex = 4;//Ö ......
ÏîÄ¿Öо³£»áÓõ½°ÑexcelµÄÎļþÄÚÈݵ¼Èëµ½Êý¾Ý¿âÖеÄ,¸Õ¸Õ»¨Á˵ãʱ¼ä,×öÁ˸öÀý×Ó,»ù±¾ÉÏÄÜʵÏÖµ¼ÈëExcelºóÏÔʾµÄ¹¦ÄÜ°É,µ¼ÈëµÄexcelÎļþµÃÊÇxls,¼´ÊÇ2003µÄ.
´úÂë˼·ÈçÏÂ:Òª¶ÁÈ¡µÄexcelÎļþ±ØµÃµÃÊÇÔÚ±¾µØÓ²ÅÌ,ËùÒÔÒ»°ãÀ´Ëµ¶¼ÊÇÈÃÔ¶³ÌÓû§Ñ¡Ôñ×Ô¼ºÓ²ÅÌÉϵÄExcelÎļþ,È»ºó°ÑÓû§Ñ¡ÔñµÄÎļþÉÏ´«µ½±¾µØ·þÎñÆ÷ÉÏ,ÔÙÔÚ±¾µØ·þÎñÆ÷ÉϽøÐвÙ×÷.ÎҰѽçÃæºóÖôúÂëÖØÒª²¿·ÖÌù³öÀ´,´ó¼Ò×Ô¼ºÂýÂý¿´°É,¶¼ÓÐ×¢ÊÍÁË.
C#´úÂë
// ÉÏ´«°´Å¥
protected void btnUp_Click(object sender, EventArgs e)
{
bool b = Upload(fuExcel); // ÉÏ´«excelÎļþ
if (!b)
{
return;
&nb ......
ASP.NET,AJAXÎļþÉÏ´«µÄÒÉÎÊ
Ô±¾ÒÔΪÓÃÕâÖÖ·½Ê½£¬°Ñ´Ë·½·¨·Åµ½Ò»¸öHttphandlerÖУ¬È»ºó´ÓJAVASCRIPT·ÃÎÊHttphandlerÀ´ÊµÏÖÎÞˢеÄÎļþÉÏ´«¡£Ã»Ïëµ½£¬ÕâÑùͬÑùÊDz»Ðеģ¬Ö»ÄÜÔÚ±¾»ú²âÊÔͨ¹ý£¬Èç¹û·Åµ½ÍøÉÏ£¬»òÕß´ÓÆäËûµØ·½·ÃÎʾͻáÌáʾÎÞ·¨ÕÒµ½Îļþ£¬¿É¼ûÔÚASP.NETÖÐËüÖ»ÄÜÓÃÓÚÉÏ´«·þÎñÆ÷¶ËµÄÎļþ¡£
֮ǰÔÚÍøÕ¾Ò²ËÑË÷µ½Ò»ÆªÎÄÕÂÊÇдÔõôÔÚHttphandlerÖÐÀ´ÊµÏÖÎļþÉÏ´«µÄ£¬ÊǹúÍâµÄÒ»¸öBLOG£¬Ã»Ôõô¿´Ã÷°×£¬Ã²ËÆ»¹½èÖúÓÚÒ»¸öapplet¡£ºóÀ´ÓÉÓÚû×ÊÔ´ÎÒҲûȥÊÔ¹ýÄÇ·½·¨µ½µ×ÊÇ·ñ¿ÉÐÐÁË¡£
ÎÒÏÖÔÚ»¹ÕæµÄ²»ÖªµÀÔÚASP.NETÔõôÄܹ»´¿ÊÖ¹¤µÄʵÏÖAJAXµÄÎÞË¢ÐÂÉÏ´«Îļþ£¬ÒòΪ´ÓJavaScript´ÓÌá½»±íµ¥·ÃÎÊHttphandler£¬ÔÚÀïÃæ¸ù±¾ÎÞ·¨»ñÈ¡µ½±íµ¥µÄÐÅÏ¢,HttpFileCollection,HttpPostedFile,ÀïÃ涼Êǿյġ£ÎÒ¾õµÃASP.NETÖеÄHttphandlerÓëJSPÖеÄServerletµ½ÓÐһЩÏàËÆÖ®´¦,¿ÉÊÇÔÚJSPÖÐÓÃServerletÀ´ÊµÏÖÒ»¸öAJAXÎÞË¢ÐÂÉÏ´«ºÜÈÝÒ×£¬ÏÖÔÚÕæµÄÓеãÀ§»óÁË£¬ÄѵÀASP.NETҪʵÏÖÎÞˢеÄÉÏ´«Ò»¶¨µÃÒªÓÃUpdatePanel¡£¶¼²»ÖªµÀ.NETµ½Ê²Ã´¶¼·â×°µ½¿Ø¼þ£¬ÎÒÃÇÖ»ÄÜÎÞÄÔµÄÍϳöÀ´Ê¹Ó㬾Ͳ»ÄÜÏñJSPÒ»Ñù£¬¶àÈÃÎÒÃdzÌÐòÔ±°´ÕÕ×Ô¼ºµÄ˼·ȥʵÏÖÒ»¸ö¶«Î÷¡£
private void Uploadfile(string filepath ......
ASP.NET,AJAXÎļþÉÏ´«µÄÒÉÎÊ
Ô±¾ÒÔΪÓÃÕâÖÖ·½Ê½£¬°Ñ´Ë·½·¨·Åµ½Ò»¸öHttphandlerÖУ¬È»ºó´ÓJAVASCRIPT·ÃÎÊHttphandlerÀ´ÊµÏÖÎÞˢеÄÎļþÉÏ´«¡£Ã»Ïëµ½£¬ÕâÑùͬÑùÊDz»Ðеģ¬Ö»ÄÜÔÚ±¾»ú²âÊÔͨ¹ý£¬Èç¹û·Åµ½ÍøÉÏ£¬»òÕß´ÓÆäËûµØ·½·ÃÎʾͻáÌáʾÎÞ·¨ÕÒµ½Îļþ£¬¿É¼ûÔÚASP.NETÖÐËüÖ»ÄÜÓÃÓÚÉÏ´«·þÎñÆ÷¶ËµÄÎļþ¡£
֮ǰÔÚÍøÕ¾Ò²ËÑË÷µ½Ò»ÆªÎÄÕÂÊÇдÔõôÔÚHttphandlerÖÐÀ´ÊµÏÖÎļþÉÏ´«µÄ£¬ÊǹúÍâµÄÒ»¸öBLOG£¬Ã»Ôõô¿´Ã÷°×£¬Ã²ËÆ»¹½èÖúÓÚÒ»¸öapplet¡£ºóÀ´ÓÉÓÚû×ÊÔ´ÎÒҲûȥÊÔ¹ýÄÇ·½·¨µ½µ×ÊÇ·ñ¿ÉÐÐÁË¡£
ÎÒÏÖÔÚ»¹ÕæµÄ²»ÖªµÀÔÚASP.NETÔõôÄܹ»´¿ÊÖ¹¤µÄʵÏÖAJAXµÄÎÞË¢ÐÂÉÏ´«Îļþ£¬ÒòΪ´ÓJavaScript´ÓÌá½»±íµ¥·ÃÎÊHttphandler£¬ÔÚÀïÃæ¸ù±¾ÎÞ·¨»ñÈ¡µ½±íµ¥µÄÐÅÏ¢,HttpFileCollection,HttpPostedFile,ÀïÃ涼Êǿյġ£ÎÒ¾õµÃASP.NETÖеÄHttphandlerÓëJSPÖеÄServerletµ½ÓÐһЩÏàËÆÖ®´¦,¿ÉÊÇÔÚJSPÖÐÓÃServerletÀ´ÊµÏÖÒ»¸öAJAXÎÞË¢ÐÂÉÏ´«ºÜÈÝÒ×£¬ÏÖÔÚÕæµÄÓеãÀ§»óÁË£¬ÄѵÀASP.NETҪʵÏÖÎÞˢеÄÉÏ´«Ò»¶¨µÃÒªÓÃUpdatePanel¡£¶¼²»ÖªµÀ.NETµ½Ê²Ã´¶¼·â×°µ½¿Ø¼þ£¬ÎÒÃÇÖ»ÄÜÎÞÄÔµÄÍϳöÀ´Ê¹Ó㬾Ͳ»ÄÜÏñJSPÒ»Ñù£¬¶àÈÃÎÒÃdzÌÐòÔ±°´ÕÕ×Ô¼ºµÄ˼·ȥʵÏÖÒ»¸ö¶«Î÷¡£
private void Uploadfile(string filepath ......
Õâ¸öÐèÒªµ½ gougou ÉÏÕÒһϠJMail °²×°ÅäÖÃÒ»ÏÂ
°²×°
[¸úʹÓñð¸ö×é¼þÒ»Ñù£¬ÔÚʹÓÃJmailÓʼþ×é¼þ֮ǰҪÏÈ°²×°»ò×¢²á¸Ã×é¼þJmail.dll¡£
¾ßÌå×¢²á·½·¨£¬ÊÇÏÈ°ÑJmail.dllÎļþ¿½±´µ½Ó²Å̵ÄijһĿ¼Ï£¨ÈçC:\Jmail\Jmail.dll£©
È»ºóÖ´ÐÐÃüÁîRegsvr32 C:\Jmail\Jmail.dll¼´¿É]
ÉÏÔ´Âë
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
/// <summary>
/// Common µÄժҪ˵Ã÷
/// </summary>
public class Common
{
#region --Ⱥ·¢Óʼþ
/// <summary>
/// ·¢ËÍÓʼþ·½·¨
/// </summary>
/// <param name="mailfromAddress">·¢¼þÈ˵ØÖ·</param>
/// <param name="mailFormPwd">·¢¼þÈËÓÊÏäÃÜÂë</param>
/// <param name="mailSMTPType">ʹÓÃÓÊÏä·þÎñÆ÷µÄSMTPµØÖ·</param>
/// <param name="topic">ÎÄÕ±êÌâ</param>
/// <param na ......
1¡¢aspx
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="TransferMoney.aspx.cs" Inherits="BtmsWebApp.report.TransferMoney" MasterPageFile="~/ReportPage.master" %>
<%@ Register Assembly="Microsoft.ReportViewer.WebForms, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %>
<asp:Content ID="Content1" ContentPlaceHolderID="TitleContent" runat="server">
ÅúÁ¿½»Ò×ÐÅÏ¢±¨±í
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">
<script>
function show() {
var s = document.getElementsByTagName("input");
var test = /^\d{4}-\d{2}-\d{2}$/;
&nb ......