From 51c3a5b6f8eead206b00679c274bea06e168dbd2 Mon Sep 17 00:00:00 2001
From: lg <123456>
Date: 星期三, 17 十二月 2025 16:25:38 +0800
Subject: [PATCH] 加上最新版本

---
 DevApp/Gs.DevApp/UserControl/ShowFile.cs |   64 +++++++++++++++++++++++++++----
 1 files changed, 55 insertions(+), 9 deletions(-)

diff --git a/DevApp/Gs.DevApp/UserControl/ShowFile.cs b/DevApp/Gs.DevApp/UserControl/ShowFile.cs
index 479b224..9bef396 100644
--- a/DevApp/Gs.DevApp/UserControl/ShowFile.cs
+++ b/DevApp/Gs.DevApp/UserControl/ShowFile.cs
@@ -1,7 +1,7 @@
-锘縰sing CefSharp;
-using CefSharp.WinForms;
+锘縰sing CefSharp.WinForms;
 using System;
 using System.Configuration;
+using System.Data.SqlClient;
 using System.IO;
 using System.Windows.Forms;
 
@@ -9,6 +9,7 @@
 {
     public partial class ShowFile : DevExpress.XtraEditors.XtraForm
     {
+        string strConn = "Data Source=192.168.1.146,12468;Initial Catalog=GS_MES;User ID=mesUser;Password =qixi1qaz@WSXmes";
         private static readonly string WebApiUrl =
         ConfigurationManager.AppSettings["WebApiUrl"];
         private ChromiumWebBrowser chromeBrowser;
@@ -28,8 +29,24 @@
 
         private void ShowFile_Load(object sender, EventArgs e)
         {
-            string _h5 = GetFileType(urlPath);
-            string _url = WebApiUrl + "upload/" + _h5 + "?filePath=" + urlPath + "&mid=" + Guid.NewGuid().ToString();
+            string fileType = GetFileType(urlPath);
+            string filePath = "";
+            //杩欐槸guid,涓嶆槸璺緞锛屾牴鎹甮uid 璇诲彇鍒板畠鐨勮矾寰�
+            if (urlPath.Length == 36)
+            {
+                System.Text.StringBuilder sb = new System.Text.StringBuilder(" select top 1 url_Path from [dbo].[MES_FILE] where parent_Guid='" + urlPath + "'");
+                object obj = GetSingle(sb.ToString());
+                if (obj != null)
+                {
+                    filePath = System.Uri.EscapeUriString(obj.ToString());
+                    fileType = GetFileType(filePath);
+                }
+                else
+                    filePath = System.Uri.EscapeUriString(urlPath);
+            }
+            else
+                filePath = System.Uri.EscapeUriString(urlPath);
+            string _url = WebApiUrl + "upload/h5/site.html?fileType=" + fileType + "&filePath=" + filePath + "&mid=" + Guid.NewGuid().ToString();
             chromeBrowser = new ChromiumWebBrowser(_url);
             this.pane1.Controls.Add(chromeBrowser);
             chromeBrowser.Dock = DockStyle.Fill;
@@ -47,13 +64,42 @@
                 case ".jpg":
                 case ".jpeg":
                 case ".png":
-                    return "h5Image.html";
+                    return "img";
                 case ".pdf":
-                    return "h5Pdf.html";
-                // 娣诲姞鍏朵粬鏂囦欢绫诲瀷
-                // ...
+                    return "pdf";
+                case ".mp4":
+                    return "mp4";
                 default:
-                    return "h5Other.html";
+                    return "other";
+            }
+        }
+
+
+        /// <summary>
+        ///     鎵ц涓�鏉¤绠楁煡璇㈢粨鏋滆鍙ワ紝杩斿洖鏌ヨ缁撴灉锛坥bject锛夈��
+        /// </summary>
+        /// <param name="SQLString">璁＄畻鏌ヨ缁撴灉璇彞</param>
+        /// <returns>鏌ヨ缁撴灉锛坥bject锛�</returns>
+        private object GetSingle(string SQLString)
+        {
+            using (var connection = new SqlConnection(strConn))
+            {
+                using (var cmd = new SqlCommand(SQLString, connection))
+                {
+                    try
+                    {
+                        connection.Open();
+                        var obj = cmd.ExecuteScalar();
+                        if (Equals(obj, null) || Equals(obj, DBNull.Value))
+                            return null;
+                        return obj;
+                    }
+                    catch (SqlException e)
+                    {
+                        connection.Close();
+                        throw new Exception(e.Message);
+                    }
+                }
             }
         }
     }

--
Gitblit v1.9.3