在 page_load 里加上如下代碼:
?string beforeSubmitJS = "\nvar exportRequested = false; \n";?
? beforeSubmitJS += "var beforeFormSubmitFunction = theForm.onsubmit;\n";?
? beforeSubmitJS += "theForm.onsubmit = function(){ \n";?
? beforeSubmitJS += "var returnVal = beforeFormSubmitFunction(); \n";?
? beforeSubmitJS += "if(exportRequested && returnVal) {_spFormOnSubmitCalled=false; exportRequested=false;} \n";?
? beforeSubmitJS += "return returnVal; \n";?
? beforeSubmitJS += "}; \n";?
? this.Page.ClientScript.RegisterStartupScript(this.GetType(), "alterFormSubmitEvent", beforeSubmitJS, true);?
注冊javascript程序,然后再按鈕提交時發送一個參數:?
this._btnSubmit.Attributes["onclick"] = "javascript:exportRequested=true;";?
這樣可以解決這個問題。?
原理:頁面按鈕提交時會調用一個內置的方法并修改一個內置變量_spFormOnSubmitCalled,我們通過按鈕來調用方法重置?
這個參數的值,達到系統檢索頁面時,一直默認為未提交狀態。
?================注意點1=====================================
但是,如果是ascx 控件上 點擊導出按鈕,而不是aspx頁面上點擊按鈕,那么 上面的方法會報錯,
._btnSubmit為導出Excel文件的Button;
RegisterClientScriptBlock將代碼注冊到源文件后面,RegisterStartupScript的話,由于theForm.onsubmit 沒有聲明,會報錯
?
================注意點2=====================================
生成的excel文件如果選擇"打開",是很正常的;
選擇“保存”,頁面上的所有腳本失效,前題還必須是target為_self
錯誤信息為“未知錯誤“
個人分析認為這個是生成的頁面雖然彈出打開,但設置的setHeader已經默認為excel文件格式,這個引響到了IE調用JS的方式(猜測),現在解決的方法為將target設為_blank,不過結果是會多一個白色的頁面
================注意點2=====================================
? protected void Page_Load(object sender, EventArgs e)
??????? {
??????????? btnExcel = (Button)FindControl("btnExcel");
??????????? #region [moss里用Response生成Excel或word以后頁面按鈕失效問題,解決辦法]
??????????? string beforeSubmitJS = "/nvar exportRequested = false; /n";
??????????? beforeSubmitJS += "var beforeFormSubmitFunction = theForm.onsubmit;/n";
??????????? beforeSubmitJS += "theForm.onsubmit = function(){ /n";
??????????? beforeSubmitJS += "var returnVal = beforeFormSubmitFunction(); /n";
??????????? beforeSubmitJS += "if(exportRequested && returnVal) {_spFormOnSubmitCalled=false; exportRequested=false;} /n";
??????????? beforeSubmitJS += "return returnVal; /n";
??????????? beforeSubmitJS += "}; /n";
??????????? this.Page.ClientScript.RegisterStartupScript(this.GetType(), "alterFormSubmitEvent", beforeSubmitJS, true);
??????????? this.btnExcel.Attributes["onclick"] = "javascript:exportRequested=true;";
??????????? #endregion
??????????? if (!Page.IsPostBack)
??????????? {
??????????????? Page.DataBind();
??????????? }
??????? }
?