其它入库单据类型改为可维护

lg

4 天以前 8114becd3aa125191bf0ed06cb8b17379b5757aa

 DevApp/Gs.DevApp/UserControl/ShowFile.cs

@@ -1,7 +1,7 @@
using CefSharp;
using CefSharp.WinForms;
using 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,不是路径，根据guid 读取到它的路径
            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>
        ///     执行一条计算查询结果语句，返回查询结果（object）。
        /// </summary>
        /// <param name="SQLString">计算查询结果语句</param>
        /// <returns>查询结果（object）</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);
                    }
                }
            }
        }
    }