Private Sub UPFILE()
Dim lstrFileName As String
Dim lstrFileNamePath As String
Dim lstrFileFolder As String
Dim allfiles As HttpPostedFile
Dim i As Integer
Dim folder As String = Now.Year().ToString + Now.Month.ToString
lstrFileFolder = Server.MapPath("fj") + "\" + folder
' 判断上传目录是否存在,不存在就建立
If (Not Directory.Exists(lstrFileFolder)) Then
Directory.CreateDirectory(lstrFileFolder)
End If
For i = 0 To Request.Files.Count - 1
allfiles = Request.Files(i)
'上传文件到服务器
lstrFileNamePath = lstrFileFolder & lstrFileName
' 得到上传目录及文件名称
allfiles.SaveAs(lstrFileFolder + "\" + lstrFileName)
Dim wjlj As String = lstrFileFolder + "\" + lstrFileName
'调用邮件序号
yjxh()
'把记录插入附件表
If lstrFileName <> "" Then
Dim c_a As New class_data()
Dim sqltext1 As String = "INSERT INTO T_YJFJB (V_YJBSH ,V_FJMC,v_fjxh ) VALUES ('" & num1 & "','" & lstrFileName & "','" & num2 & "')"
Response.Write(sqltext1)
Dim zt2 As String = c_a.operation(sqltext1)
'Response.Write(zt)
End If
Next
End Sub
'保存到草稿夹
Private Sub btn2_ServerClick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btn2.ServerClick
wjj = "草稿夹"
add()
Dim sqltext2 As String = "INSERT INTO T_DZYJKZB(V_DZYJBSH ,V_SJRBS ,V_WJJ ,V_ZT ,V_NR ,V_FJR ,V_CS ,V_CSJB,V_FSRQ ) VALUES('" & num1 & "','" & tbx2.Text & "','" & wjj & "','" & tbx3.Text & "','" & tbx1.Text & "','" & xm & "','" & tbx4.Text & "','1','" & Now() & "')"
Dim c_a As New class_data()
Response.Write(sqltext2)
Dim zt3 As String = c_a.operation(sqltext2)
If zt3 = "ok" Then
Response.Write("<script>alert('保存成功')</script>")
Else
Response.Write("<script>alert('保存失败')</script>")
Response.Write(zt)
End If
.aspx.vb中
Private postfile As String
postfile = myfile.Value '获取文件名步骤一
Dim tempfilename() As String = Split(postfile, "\") '获取文件名步骤二
Dim lastfilename As String = tempfilename(tempfilename.Length - 1) '获取文件名步骤三
Dim directory As System.IO.Directory
Dim file As System.IO.File
If directory.Exists(MapPath("/upload/" & CheckPerson.SelectedItem.Text)) Then
file.Copy(myfile.Value, MapPath("/upload/" & CheckPerson.SelectedItem.Text & "/" & lastfilename))
Else
directory.CreateDirectory(MapPath("/upload/" & CheckPerson.SelectedItem.Text))
file.Copy(myfile.Value, MapPath("/upload/" & CheckPerson.SelectedItem.Text & "/" & lastfilename))
End If
Response.Write("<script>alert('上传成功!');</script>")