28,391
社区成员
发帖
与我相关
我的任务
分享
<!doctype html>
<!--#include file="../Include/conig.asp"-->
<!--#include file="Admin_check.asp"-->
<%
if Instr(session("AdminPurview"),"|2018,")=0 then
response.write ("<font color='red')>你不具有该管理模块的操作权限,请返回!</font>")
response.end
end if
'========判断是否具有管理权限
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<meta http-equiv="X-UA-Compatible" content="IE=EmulateIE7">
<meta name="viewport" content="width=device-width,initial-scale=1.0,maximum-scale=1.0,minimum-scale=1.0,user-scalable=no" />
<meta name="apple-mobile-web-app-capable" content="yes">
<meta name="apple-mobile-web-app-status-bar-style" content="black">
<meta name="format-detection" content="telephone=no">
<meta name="keywords" content="">
<meta name="description" content="">
<title>导出</title>
<body>
<body>
<%
'dim conn,strconn
'strconn="driver={SQL Server};server=wen;uid=sa;pwd=;database=DB_Test"
'set conn=server.CreateObject("adodb.connection")
'conn.Open strconn
dim s,sql,filename,fs,myfile,x
Set fs = server.CreateObject("scripting.filesystemobject")
'--假设你想让生成的EXCEL文件做如下的存放
filename = Server.MapPath("../BookXls/export.xls")
'--如果原来的EXCEL文件存在的话删除它
if fs.FileExists(filename) then
fs.DeleteFile(filename)
end if
'--创建EXCEL文件
set myfile = fs.CreateTextFile(filename,true)
'Set rs = Server.CreateObject("ADODB.Recordset")
'--从数据库中把你想放到EXCEL中的数据查出来
'sql = "select * from Tb_Execl order by id desc"
'rs.Open sql,conn
StartTime = Request("start_date")
EndTime = Request("end_date")
StartEndTime = "AddTime between #"& StartTime &" 00:00:00# and #"& EndTime &" 23:59:59#"
strSql = "select * from Tru_s_Dossier"& StartEndTime & " order by id desc"
' where " & StartEndTime & " order by ID desc"
Set rstData = DataToRsStatic(conn,strSql)
if not rstData.EOF and not rstData.BOF then
dim trLine,responsestr
strLine = "编号" & chr(9) & "VIN" & chr(9) & "ND号" & chr(9) & "客户类别" & chr(9) & "车型" & chr(9) & "责任单位" & chr(9) & "故障描述" & chr(9) & "故障产生阶段" & chr(9) & "返修措施"& chr(9) & "添加时间"
'objSpreadsheet.Range("A1:F1").merge '合并单元格(单元区域)
'--将表的列名先写入EXCEL
myfile.writeline strLine
Do while Not rstData.EOF
strLine=""
strLine = rstData("id") & chr(9) & rstData("sVIN") & chr(9) & rstData("ND") & chr(9) & rstData("CustCate") & chr(9) & rstData("Frstdegree") & chr(9) & rstData("Cityid") & chr(9) &rstData("Fdescribe") & chr(9) &rstData("gzcsjd") & chr(9) &rstData("fxcs") & chr(9) &formatdate(rstData("AddTime")) & chr(9) & IfSendStr
myfile.writeline strLine
rstData.MoveNext
loop
end if
Response.Write "生成EXCEL文件成功,点击<a href=""../BookXls/export.xls"" target=""_blank"">下载</a>!"
rstData.Close
set rstData = nothing
Conn.Close
Set Conn = nothing
Function DataToRsStatic(Conn,strSql)
Dim RsStatic
Set DataToRsStatic = Nothing
If Conn Is Nothing Then
Exit Function
End If
Set RsStatic = CreateObject("ADODB.RecordSet")
RsStatic.CursorLocation = 3
RsStatic.Open strSql,Conn,3,3
If Err.Number <> 0 Then
Exit Function
End If
Set DataToRsStatic = RsStatic
End Function
%>
</BODY>
</HTML>
<!--#include file="../Include/conig.asp"-->
<!--#include file="Admin_check.asp"-->
<%
if Instr(session("AdminPurview"),"|2018,")=0 then
response.write ("<font color='red')>你不具有该管理模块的操作权限,请返回!</font>")
response.end
end if
'========判断是否具有管理权限
%>
<!doctype html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<meta http-equiv="X-UA-Compatible" content="IE=EmulateIE7">
<meta name="viewport" content="width=device-width,initial-scale=1.0,maximum-scale=1.0,minimum-scale=1.0,user-scalable=no" />
<meta name="apple-mobile-web-app-capable" content="yes">
<meta name="apple-mobile-web-app-status-bar-style" content="black">
<meta name="format-detection" content="telephone=no">
<meta name="keywords" content="">
<meta name="description" content="">
<title>报名导出</title>
<body>
<body>
<%
'dim conn,strconn
'strconn="driver={SQL Server};server=wen;uid=sa;pwd=;database=DB_Test"
'set conn=server.CreateObject("adodb.connection")
'conn.Open strconn
dim s,sql,filename,fs,myfile,x
Set fs = server.CreateObject("scripting.filesystemobject")
'--假设你想让生成的EXCEL文件做如下的存放
filename = Server.MapPath("../BookXls/export.xls")
'--如果原来的EXCEL文件存在的话删除它
if fs.FileExists(filename) then
fs.DeleteFile(filename)
end if
'--创建EXCEL文件
set myfile = fs.CreateTextFile(filename,true)
'Set rs = Server.CreateObject("ADODB.Recordset")
'--从数据库中把你想放到EXCEL中的数据查出来
'sql = "select * from Tb_Execl order by id desc"
rs.Open sql,conn
StartTime = Request("start_date")
EndTime = Request("end_date")
StartEndTime = "AddTime between #"& StartTime &" 00:00:00# and #"& EndTime &" 23:59:59#"
strSql = "select * from Tru_s_Dossier "& StartEndTime & " order by id desc"
' where " & StartEndTime & " order by ID desc"
'Set rstData = DataToRsStatic(conn,strSql)
'if not rstData.EOF and not rstData.BOF then
if not (rstData.EOF and rstData.BOF) then
dim strLine,responsestr
'strLine=""
'For each x in rstData.fields
' strLine = strLine & x.name & chr(9)
'Next
strLine = "编号" & chr(9) & "VIN" & chr(9) & "ND号" & chr(9) & "客户类别" & chr(9) & "车型" & chr(9) & "责任单位" & chr(9) & "故障描述" & chr(9) & "故障产生阶段" & chr(9) & "返修措施"& chr(9) & "添加时间"
'objSpreadsheet.Range("A1:F1").merge '合并单元格(单元区域)
'--将表的列名先写入EXCEL
myfile.writeline strLine
Do while Not rstData.EOF
strLine=""
'for each x in rstData.Fields
' strLine = strLine & x.value & chr(9)
'next
'--将表的数据写入EXCEL
'IfSendStr = "未"
'If rstData("IfSend") = 1 Then IfSendStr = "已"
'Remark = Replace(rstData("Remark"), vbCrlf, "")
'strLine = rstData("ID") & chr(9) & GetTableString("tb_User","username","ID",rstData("UserID")) & chr(9) & GetTableString("tb_Product","name","ID",rstData("ProductID")) & chr(9) & rstData("NeedNum") & chr(9) & rstData("NeedTime") & chr(9) & rstData("address") & chr(9) & Remark & chr(9) & rstData("AddTime") & chr(9) & IfSendStr
strLine = rstData("id") & chr(9) & rstData("sVIN") & chr(9) & rstData("ND") & chr(9) & rstData("CustCate") & chr(9) & rstData("Frstdegree") & chr(9) & rstData("Cityid") & chr(9) &rstData("Fdescribe") & chr(9) &rstData("gzcsjd") & chr(9) &rstData("fxcs") & chr(9) &formatdate(rstData("AddTime")) & chr(9) & IfSendStr
myfile.writeline strLine
rstData.MoveNext
loop
end if
Response.Write "生成EXCEL文件成功,点击<a href=""../BookXls/export.xls"" target=""_blank"">下载</a>!"
rstData.Close
set rstData = nothing
Conn.Close
Set Conn = nothing
Function DataToRsStatic(Conn,strSql)
Dim RsStatic
Set DataToRsStatic = Nothing
If Conn Is Nothing Then
Exit Function
End If
Set RsStatic = CreateObject("ADODB.RecordSet")
RsStatic.CursorLocation = 3
RsStatic.Open strSql,Conn,3,3
If Err.Number <> 0 Then
Exit Function
End If
Set DataToRsStatic = RsStatic
End Function
%>
</BODY>
</HTML>