javascript
1.Response.Write("<script>alert(\"Session已過期,請重新登入\");top.location.href=\"default.aspx\";</script>");
2. scriptClientId = controlToFocus.ClientID
scriptFunction.Append("<script language='javascript'>")
scriptFunction.Append("document.getElementById('" & scriptClientId & "').focus();")
scriptFunction.Append("</script>")
Return scriptFunction.ToString()
3.在子页面的保存代码里调用父页面的js脚本里的刷新函数子页面代码：
Response.Write("<script language='javascript'>window.parent.Refresh()</script>");//parent改爲openerwindow.opener.refresh()
父页面的js脚本<SCRIPT type="text/javascript">
function Refresh()
{
window.location.href=window.location.href;
}
<\SCRIPT >
4.<td><asp:label id="zzchina_time" runat="server" Font-Bold="True" Font-Size="X-Small" ForeColor="Blue"
Width="374px">
<script>setInterval("zzchina_time.innerHTML=new Date().toLocaleString()+''.charAt(new Date().getDay());",1000);</script>
</asp:label></td>
Response.Write("<script language='javascript'> window.open ('./LicenseExpiring.aspx', 'LicenseExpiring', 'height=650, width=960, toolbar=no, menubar=no, scrollbars=yes, resizable=yes, location=no, status=no');</script>")
5.<body>
<script language="javascript">
function showSending()
{
sending.style.visibility="visible";
}
</script>
<div id="sending" style="Z-INDEX:10; VISIBILITY:hidden; WIDTH:400px; POSITION:absolute">
<table width="400" height="80" border="0" cellspacing="2" cellpadding="0" bgcolor="#8fa8e9">
<tr>
<td bgcolor="#eeeeee" align="center">
報修記錄正在提交中 , 請稍候...
</td>
</tr>
</table>
</div>
</body>
System.Text.StringBuilder script = new System.Text.StringBuilder();
script.Append("<script language=JavaScript> function SureSubmit(){");
script.Append("return confirm('確認要報修該條記錄');} </script>");
string js = script.ToString();
if(!IsClientScriptBlockRegistered("SureSubmit"))
{
}
Button1.Attributes.Add("onclick","SureSubmit();return showSending();");
6. private void getdata()
{
OracleConnection conn = new OracleConnection("Data Source=E4MT.INNOLUX.COM.TW;User id=mis;Password=mis");
// OracleCommand com =new OracleCommand();
// com.Connection = conn;
conn.Open();
string str="select depart,name,fenji,tel from oa_duty";
try
{
OracleDataAdapter da = new OracleDataAdapter(str,conn);
DataTable dt = new DataTable();
da.Fill(dt);
this.DataGrid1.DataSource = dt;
this.DataGrid1.DataBind();
WriteTableToExcel(dt,"Title","CopyRight","Duty");
}
catch(Exception ed)
{
string Error= ed.Message;
}
}
private void Button1_Click(object sender, System.EventArgs e)
{
getdata();
}
#region 將DataTable導出成Execl文件
/// <summary>
/// 將DataTable導出成Execl文件
/// </summary>
/// <param name="dtData">DataTable</param>
/// <param name="strContentTitle">表頭</param>
/// <param name="strAuthor">標題</param>
/// <param name="FileName">文件名</param>
/// <returns>返回bool</returns>
public void WriteTableToExcel(DataTable dtData,string strContentTitle,string strCopyright,string FileName)
{
//--以下是excel文件保存部分------------------------------
string strFileName=FileName+".xls"; //你要保存的文件名
string strFilePath=@"d:\web\webtest\dttranexl\exl\"; //你要保存的文件目錄
string strPhysicalFileName=strFilePath+strFileName;
if(System.IO.File.Exists(strPhysicalFileName)==false)
{
//--以下是創建excel對象實例------------------------------
object missing=System.Reflection.Missing.Value;
//Excel.Application OB = new Excel.ApplicationClass();webtest\dttranexl\exl
Excel.Application objExcel=new Excel.ApplicationClass();
Excel.Workbook objWorkbook=objExcel.Application.Workbooks.Add(missing);
Excel.Worksheet objSheet=(Excel.Worksheet)objWorkbook.Sheets[1];
objExcel.Visible=false;
//--以上是創建excel對象實例-------------------------------
//--以下是excel生成數據標題格式控制部分------------------------------
Excel.Range objTitleRange=objSheet.get_Range(objSheet.Cells[1,1],objSheet.Cells[1,dtData.Columns.Count]);
objTitleRange.Merge(true);
objTitleRange.WrapText=false;
objTitleRange.Font.Name="宋体";
objTitleRange.Font.Size=16;
objTitleRange.Font.Shadow=false;
objTitleRange.Font.ColorIndex=3;
objTitleRange.Font.Bold=true;
objTitleRange.Font.Underline=false;
objTitleRange.Font.Italic=false;
objTitleRange.Font.Strikethrough=false;
objTitleRange.Font.Subscript=false;
objTitleRange.Font.OutlineFont=false;
objTitleRange.Cells[1,1]=strContentTitle;
//--以上是excel生成數據標題格式控制部分------------------------------
//--以下是excel生成數據版權作者格式控制部分------------------------------
Excel.Range objCopyrightRange=objSheet.get_Range(objSheet.Cells[2,1],objSheet.Cells[2,dtData.Columns.Count]);
objCopyrightRange.Merge(true);
objCopyrightRange.WrapText=false;
objCopyrightRange.Font.Name="宋体";
objCopyrightRange.Font.Size=10;
objCopyrightRange.Font.Shadow=false;
objCopyrightRange.Font.ColorIndex=11;
objCopyrightRange.Font.Bold=false;
objCopyrightRange.Font.Underline=false;
objCopyrightRange.Font.Italic=false;
objCopyrightRange.Font.Strikethrough=false;
objCopyrightRange.Font.Subscript=false;
objCopyrightRange.Font.OutlineFont=false;
objCopyrightRange.Cells[1,1]=strCopyright;
//--以上是excel生成數據版權作者格式控制部分------------------------------
//--以下是excel生成數據表標題格式控制部分------------------------------
Excel.Range objHeadRange=objSheet.get_Range(objSheet.Cells[3,1],objSheet.Cells[3,dtData.Columns.Count]);
//objHeadRange.Merge(false);
objHeadRange.WrapText=false;
objHeadRange.Font.Name="宋体";
objHeadRange.Font.Size=10;
objHeadRange.Font.Shadow=false;
objHeadRange.Font.ColorIndex=11;
objHeadRange.Font.Bold=false;
objHeadRange.Font.Underline=false;
objHeadRange.Font.Italic=false;
objHeadRange.Font.Strikethrough=false;
objHeadRange.Font.Subscript=false;
objHeadRange.Font.OutlineFont=false;
//--以上是excel生成數據表標題格式控制部分------------------------------
//--以下是excel生成數據表內容格式控制部分------------------------------
Excel.Range objBodyRange=objSheet.get_Range(objSheet.Cells[4,1],objSheet.Cells[dtData.Rows.Count+4,dtData.Columns.Count]);
//objBodyRange.Merge(false);
objBodyRange.WrapText=false;
objBodyRange.Font.Name="宋体";
objBodyRange.Font.Size=10;
objBodyRange.Font.Shadow=false;
objBodyRange.Font.ColorIndex=1;
objBodyRange.Font.Bold=false;
objBodyRange.Font.Underline=false;
objBodyRange.Font.Italic=false;
objBodyRange.Font.Strikethrough=false;
objBodyRange.Font.Subscript=false;
objBodyRange.Font.OutlineFont=false;
//--以上是excel生成數據表內容格式控制部分------------------------------
//--以下是excel生成數據表標題部分------------------------------
for(int J=0;J<=dtData.Columns.Count-1;J++)
{
objSheet.Cells[3,J+1]="'"+dtData.Columns[J].Caption;
}
//--以上是excel生成數據表標題部分------------------------------
//--以下是excel生成數據部分------------------------------
for(Int32 N=0;N<=dtData.Rows.Count-1;N++)
{
for(int I=0;I<=dtData.Columns.Count-1;I++)
{
//objSheet.Cells[N+4,I+1]="'"+dtData.Rows[N].ItemArray[I].ToString();
objSheet.Cells[N+4,I+1]=dtData.Rows[N].ItemArray[I].ToString();
}
}
//--以上是excel生成數據部分------------------------------
dtData.Dispose();
objSheet.SaveAs(strPhysicalFileName,missing,missing,missing,missing,missing,missing,missing,missing,missing);
//--以上是excel文件保存部分------------------------------
//--以下是退出excel部分------------------------------
objWorkbook.Close(missing,missing,missing);
objExcel.Quit();
//--以下是退出excel部分------------------------------
}
}
#endregion
private void btn_ReadXLS_Click(object sender, System.EventArgs e)
{
string strCon="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath("Exl/Duty.xls")+";Extended Properties='Excel 8.0;HDR=YES;IMEX=1'";
OleDbConnection oleCon=new OleDbConnection(strCon);
OleDbDataAdapter oleDA=new OleDbDataAdapter("select depart,name,fenji,tel from [Sheet1$]",oleCon);
DataTable dt=new DataTable();
oleDA.Fill(dt);
dgBang.DataSource=dt;
dgBang.DataBind();
ViewState["dt"] =dt;
//dgBang.CurrentPageIndex;
//dgBang.PageSize
}
private void btn_InsertDB_Click(object sender, System.EventArgs e)
{
DataTable dt = (DataTable)ViewState["dt"];
OracleConnection conn = new OracleConnection("Data Source=E4MT.INNOLUX.COM.TW;User id=mis;Password=mis");
OracleCommand com =new OracleCommand();
com.Connection = conn;
conn.Open();
string strInsert="";
for(int i=0;i<dt.Rows.Count;i++)
{
strInsert = "insert into OA_DUTY_TEST(depart,name,fenji,tel) values('"+dt.Rows[i]["depart"].ToString()+"','"+dt.Rows[i]["name"].ToString()+"','"+dt.Rows[i]["fenji"].ToString()+"','"+dt.Rows[i]["tel"].ToString()+"')";
com.CommandText = strInsert;
com.ExecuteNonQuery();
}
}
浙公网安备 33010602011771号