From 8114becd3aa125191bf0ed06cb8b17379b5757aa Mon Sep 17 00:00:00 2001
From: lg <123456>
Date: 星期五, 12 十二月 2025 13:38:48 +0800
Subject: [PATCH] 其它入库单据类型改为可维护
---
DevApp/Gs.DevApp/UserControl/ShowFile.cs | 52 ++++++++++++++++++++++++++++++++++++++++++++++++----
1 files changed, 48 insertions(+), 4 deletions(-)
diff --git a/DevApp/Gs.DevApp/UserControl/ShowFile.cs b/DevApp/Gs.DevApp/UserControl/ShowFile.cs
index 6313f8a..9bef396 100644
--- a/DevApp/Gs.DevApp/UserControl/ShowFile.cs
+++ b/DevApp/Gs.DevApp/UserControl/ShowFile.cs
@@ -1,15 +1,15 @@
-锘縰sing CefSharp;
-using CefSharp.WinForms;
+锘縰sing CefSharp.WinForms;
using System;
using System.Configuration;
+using System.Data.SqlClient;
using System.IO;
-using System.Net;
using System.Windows.Forms;
namespace Gs.DevApp.UserControl
{
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;
@@ -29,8 +29,23 @@
private void ShowFile_Load(object sender, EventArgs e)
{
- string filePath = System.Uri.EscapeUriString(urlPath);
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);
@@ -58,5 +73,34 @@
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);
+ }
+ }
+ }
+ }
}
}
\ No newline at end of file
--
Gitblit v1.9.3