Dim dlg As new OpenFileDialog
If dlg.ShowDialog = DialogResult.OK Then
Dim ftp1 As New FtpClient
ftp1.Host=Tables("FTPIP").Current("FTPhost")
ftp1.Account = Tables("FTPIP").Current("FTPAccount")
ftp1.Password = Tables("FTPIP").Current("FTPpassword")
Dim filters As String = "合同号 = '" & e.Form.Controls("合同号").Text & "'And 款号 = '" & e.Form.Controls("款号").Text & "' And 业务担当 = '" & e.Form.Controls("业务担当").Text & "' And 合同交期 = '" & e.Form.Controls("合同交期").Text & "' And 客户名称 = '" & e.Form.Controls("客户名称").Text & "' And 品名 = '" & e.Form.Controls("品名").Text & "'"
cmd.CommandText = "select * Fro m {订单主表} where " & filters
Dim dtsj As DataTable
dtsj = cmd.ExecuteReader(True) '记得将参数设置为True
If dtsj.datarows.count = 0 Then
msgbox("没有数据")
Return
End If
If ftp1.Upload(dlg.FileName, "/kst/"& e.Form.Controls("合同号").Text & e.Form.Controls("款号").Text & ".jpg") = True Then
dtsj.DataRows(0)("款式图片") &= IIF(dtsj.DataRows(0).IsNull("款式图片"), "", vbcrlf) & "/kst/" & e.Form.Controls("合同号").Text & e.Form.Controls("款号").Text & ".jpg"
Messagebox.show("上传完成!","提示",MessageBoxButtons.OK,MessageBoxIcon.Information)
Else
Messagebox.show("上传失败!","提示",MessageBoxButtons.OK,MessageBoxIcon.Information)
End If
dtsj.Save()
Dim pbxk As WinForm.PictureBox = Forms("订单主表").Controls("PictureBox1")
Dim img As String = ProjectPath & "Attachments\暂无图片.jpg"
Dim sfz As String = dtsj.DataRows(0)("款式图片")
Dim fmz As String = ProjectPath & "\RemoteFiles\" & sfz
If FileSys.FileExists(fmz) = False AndAlso dtsj.DataRows(0).IsNull("款式图片") = False AndAlso ftp1.FileExists(sfz) Then
ftp1.Download(sfz,fmz)
End If
If FileSys.FileExists(fmz) Then
pbxk.ImageFile = fmz
Else
pbxk.ImageFile = img
End If
ftp1.close
End If
End If
加好友 
发短信
Post By：2020/1/3 13:56:00 [只看该作者]
此主题相关图片如下：01.jpg
