OW-ERP-SYS-APP/Assets/scripts/配方製成表.cs

using System.Collections;
using System.Collections.Generic;
using UnityEngine;
using UnityEngine.SceneManagement;
using UnityEngine.UI;
using UnityEngine.Networking;
using System.Text.RegularExpressions;
using System.Data.SqlClient;
using TMPro;
using System;
using System.IO;
using ZXing;
using ZXing.QrCode;
using System.Net;
using SimpleJSON;
using System.ComponentModel;
using System.Runtime.InteropServices;

public class 配方製成表 : MonoBehaviour
{
    [SerializeField] TextMeshProUGUI 比例;
    [SerializeField] TextMeshProUGUI 溫度;
    [SerializeField] TextMeshProUGUI 時間;
    [SerializeField] TextMeshProUGUI 淨重;
    [SerializeField] TextMeshProUGUI 單位;
    [SerializeField] TextMeshProUGUI 包材;
    [SerializeField] TextMeshProUGUI 打包;
    [SerializeField] TextMeshProUGUI 條件;
    [SerializeField] TextMeshProUGUI 期限;
    [SerializeField] TextMeshProUGUI 有效;
    [SerializeField] TextMeshProUGUI 過敏;

    public GameObject buttonPrefab1;
    public Transform buttonParent1;
    public GameObject buttonceneter1;
    private List<GameObject> copy1 = new List<GameObject>();
    public GameObject buttonPrefab2;
    public Transform buttonParent2;
    public GameObject buttonceneter2;
    private List<GameObject> copy2 = new List<GameObject>();
    public GameObject buttonPrefab3;
    public Transform buttonParent3;
    public GameObject buttonceneter3;
    private List<GameObject> copy3 = new List<GameObject>();
    public GameObject buttonPrefab4;
    public Transform buttonParent4;
    public GameObject buttonceneter4;
    private List<GameObject> copy4 = new List<GameObject>();
    public GameObject buttonPrefab5;
    public Transform buttonParent5;
    public GameObject buttonceneter5;
    private List<GameObject> copy5 = new List<GameObject>();
    public GameObject buttonPrefab6;
    public Transform buttonParent6;
    public GameObject buttonceneter6;
    private List<GameObject> copy6 = new List<GameObject>();
    public GameObject buttonPrefab7;
    public Transform buttonParent7;
    public GameObject buttonceneter7;
    private List<GameObject> copy7 = new List<GameObject>();

    public GameObject buttonPrefab8;
    public Transform buttonParent8;
    public GameObject buttonceneter8;
    private List<GameObject> copy8 = new List<GameObject>();

    [SerializeField] TextMeshProUGUI 原料小計1;
    [SerializeField] TextMeshProUGUI 原料小計2;
    [SerializeField] TextMeshProUGUI 原料小計3;
    [SerializeField] TextMeshProUGUI 乳化小計1;
    [SerializeField] TextMeshProUGUI 乳化小計2;
    [SerializeField] TextMeshProUGUI 香料小計1;
    [SerializeField] TextMeshProUGUI 香料小計2;
    [SerializeField] TextMeshProUGUI 其他小計1;
    [SerializeField] TextMeshProUGUI 其他小計2;
    [SerializeField] TextMeshProUGUI 著色小計1;
    [SerializeField] TextMeshProUGUI 著色小計2;
    [SerializeField] TextMeshProUGUI 合計產品;
    [SerializeField] TextMeshProUGUI 合計產品重量;

    [SerializeField] RawImage 已核准;
    [SerializeField] RawImage 已發行;
    public Sprite 紅燈;
    public Sprite 綠燈;

    [SerializeField] TextMeshProUGUI 名稱;
    [SerializeField] TextMeshProUGUI 編號;
    [SerializeField] TextMeshProUGUI 種類;
    [SerializeField] TextMeshProUGUI 噸數;
    [SerializeField] TextMeshProUGUI 季節;
    [SerializeField] TextMeshProUGUI 版本;
    [SerializeField] TextMeshProUGUI 標章;
    [SerializeField] TextMeshProUGUI 日期;
    [SerializeField] TextMeshProUGUI 出貨;
    [SerializeField] TextMeshProUGUI 備註;
    [SerializeField] Toggle 代工;

    [SerializeField] GameObject 清單;
    [SerializeField] GameObject 明細;

    public GameObject buttonPrefab;
    public Transform buttonParent;
    public GameObject buttonceneter;
    private List<GameObject> copy = new List<GameObject>();
    double 產品和;
    double 重量和;
    public CanvasScaler canvasScaler;

    private string loadingText = "";
    private int dotCount = 0;

    [SerializeField] GameObject 讀取面板;
    [SerializeField] TextMeshProUGUI 讀取;

    [SerializeField] GameObject 彈跳面板;
    [SerializeField] TextMeshProUGUI 彈跳文字;
    // Start is called before the first frame update
    void Start()
    {
        Screen.autorotateToPortrait = false;
        Screen.orientation = ScreenOrientation.LandscapeLeft;
        float rate = 1600.0f / 1000.0f;
        if (Main.Global.rate>rate)
        {
            canvasScaler.matchWidthOrHeight = 1f;
        }
        else
        {
            canvasScaler.matchWidthOrHeight = 0f;
        }
        //Main.Global.阿帕契路徑="http://106.1.48.106:8080/wp-content/themes/event-star/ow_main.php?";
        //Main.Global.預設伺服器路徑="official";
        清單.SetActive(true);
        明細.SetActive(false);

        StartCoroutine(AnimateText());
        StartCoroutine(油脂種類下拉清單());
    }
    public void 截圖()
    {
        string fileName = string.Format("{0}/screenshot_{1}.png", Application.persistentDataPath, System.DateTime.Now.ToString("yyyyMMdd_HHmmss"));
        ScreenCapture.CaptureScreenshot(fileName);
    }
    IEnumerator AnimateText()
    {
        string qqq = 讀取.text.ToString();
        while (true)
        {
            yield return new WaitForSeconds(0.5f);

            if (dotCount < 3)
            {
                loadingText += ".";
                dotCount++;
            }
            else
            {
                loadingText = "";
                dotCount = 0;
            }

            讀取.text = qqq+loadingText;
        }
    }
    IEnumerator 油脂種類下拉清單()
    {
        讀取面板.SetActive(true);
        if (copy8 != null)
        {
            DeleteCopies(copy8);
        }
        string strcon = "油脂種類下拉清單";
        string se = Main.Global.預設伺服器路徑;
        string strUrl = string.Format(Main.Global.阿帕契路徑+"comm={0}&se={1}", strcon, se);
        UnityWebRequest request = UnityWebRequest.Get(strUrl);
        Debug.Log(strUrl);
        yield return request.SendWebRequest();
        if (request.result == UnityWebRequest.Result.ConnectionError)
        {
            Debug.Log(request.error);
            yield break;
        }
        JSONNode json = JSON.Parse(request.downloadHandler.text);
        Debug.Log(json);
        int sum = 5;
        GameObject selectedButton = null;
        for (int i = 0; i < json.Count; i++)
        {
            GameObject buttonObj = Instantiate(buttonPrefab8) as GameObject;
            buttonObj.GetComponent<RectTransform>().anchoredPosition = new Vector2(2, -sum);
            buttonObj.transform.SetParent(buttonParent8, false);
            TextMeshProUGUI text = buttonObj.GetComponentInChildren<TextMeshProUGUI>();
            Button bt = buttonObj.GetComponentInChildren<Button>();
            Image[] im = buttonObj.GetComponentsInChildren<Image>();
            int index = i;
            bt.onClick.AddListener(() =>
            {
                string str = json[index].ToString().Trim('"');
                StartCoroutine(配方控制表(str));
                if (selectedButton != null)
                {
                    Image[] prevButtonImages = selectedButton.GetComponentsInChildren<Image>();
                    prevButtonImages[1].color = Color.white;
                }

                // 設定當前按鈕為選中狀態
                im[1].color = new Color32(160, 255, 160, 255);
                selectedButton = buttonObj;
            });
            text.text = json[i].ToString().Trim('"');
            sum+=100;
            copy8.Add(buttonObj);
        }
        buttonceneter8.GetComponent<RectTransform>().sizeDelta = new Vector2(buttonceneter8.GetComponent<RectTransform>().sizeDelta.x, sum);
        讀取面板.SetActive(false);
    }

    IEnumerator 配方控制表(string str)
    {
        讀取面板.SetActive(true);
        if (copy != null)
        {
            DeleteCopies(copy);
        }
        string strcon = "配方控制表";
        string se = Main.Global.預設伺服器路徑;
        string strUrl = string.Format(Main.Global.阿帕契路徑+"comm={0}&se={1}&PA={2}", strcon, se,str);
        UnityWebRequest request = UnityWebRequest.Get(strUrl);
        Debug.Log(strUrl);
        yield return request.SendWebRequest();
        if (request.result == UnityWebRequest.Result.ConnectionError)
        {
            Debug.Log(request.error);
            yield break;
        }
        JSONNode json = JSON.Parse(request.downloadHandler.text);
        Debug.Log(json);
        int sum = 5;
        for (int i = 0; i < json.Count; i++)
        {
            GameObject buttonObj = Instantiate(buttonPrefab) as GameObject;
            buttonObj.GetComponent<RectTransform>().anchoredPosition = new Vector2(2, -sum);
            buttonObj.transform.SetParent(buttonParent, false);
            TextMeshProUGUI[] text = buttonObj.GetComponentsInChildren<TextMeshProUGUI>();
            Button bt = buttonObj.GetComponentInChildren<Button>();
            int index = i;
            bt.onClick.AddListener(() =>
            {
                SetTextValue(名稱, json[index][2]);
                SetTextValue(編號, json[index][1]);
                SetTextValue(種類, json[index][3]);
                SetTextValue(噸數, json[index][7]);
                SetTextValue(季節, json[index][4]);
                SetTextValue(版本, json[index][17]);
                SetTextValue(標章, json[index][8]);
                SetTextValue(日期, json[index][6]);
                SetTextValue(出貨, json[index][5]);
                SetTextValue(比例, json[index][19]);
                SetTextValue(溫度, json[index][20]);
                SetTextValue(時間, json[index][21]);
                SetTextValue(淨重, json[index][24]);
                SetTextValue(單位, json[index][25]);
                SetTextValue(包材, json[index][22]);
                SetTextValue(打包, json[index][23]);
                SetTextValue(條件, json[index][26]);
                SetTextValue(期限, json[index][27]);
                SetTextValue(有效, json[index][28]);
                SetTextValue(過敏, json[index][29]);
                
                string jsonString = json[index][10].ToString().Trim('"');
                string unescapedString = Regex.Unescape(jsonString);
                備註.text=unescapedString;
                if (json[index][9] == 1)
                {
                    代工.isOn = true;
                }
                else
                {
                    代工.isOn = false;
                }
                if (json[index][13]!= null && json[index][13].ToString().Trim('"')!= "")
                {
                    已核准.texture = 綠燈.texture;
                }
                else
                {
                    已核准.texture = 紅燈.texture;
                }
                if (json[index][14]!= null && json[index][14].ToString().Trim('"')!= "")
                {
                    已發行.texture = 綠燈.texture;
                }
                else
                {
                    已發行.texture = 紅燈.texture;
                }
                讀取面板.SetActive(true);
                產品和=0;
                重量和=0;
                StartCoroutine(配方明細表源料油());
                清單.SetActive(!清單.activeSelf);
                明細.SetActive(!明細.activeSelf);
            });

            text[0].text = (i+1).ToString();
            text[1].text = json[i][2].ToString().Trim('"');
            text[2].text = json[i][4].ToString().Trim('"');
            text[3].text = json[i][17].ToString().Trim('"');
            sum+=75;
            copy.Add(buttonObj);
        }
        buttonceneter.GetComponent<RectTransform>().sizeDelta = new Vector2(buttonceneter.GetComponent<RectTransform>().sizeDelta.x, sum);
        讀取面板.SetActive(false);
    }
    private void SetTextValue(TextMeshProUGUI text, string value)
    {
        if (value == null)
        {
            text.text = "";
        }
        else
        {
            string jsonString = value.Trim('"');
            string unescapedString = Regex.Unescape(jsonString);
            text.text = unescapedString;
        }
    }
    IEnumerator 配方明細表源料油()
    {
        if (copy1 != null)
        {
            DeleteCopies(copy1);
        }
        string strcon = "配方明細表源料油";
        string se = Main.Global.預設伺服器路徑;
        string str = 編號.text;
        string strUrl = string.Format(Main.Global.阿帕契路徑+"comm={0}&se={1}&PA={2}", strcon, se, str);
        UnityWebRequest request = UnityWebRequest.Get(strUrl);
        yield return request.SendWebRequest();
        if (request.result == UnityWebRequest.Result.ConnectionError)
        {
            Debug.Log(request.error);
            yield break;
        }
        JSONNode json = JSON.Parse(request.downloadHandler.text);
        int sum = 5;
        double tt1 = 0;
        double tt2 = 0;
        double tt3 = 0;

        for (int i = 0; i < json.Count; i++)
        {
            GameObject buttonObj = Instantiate(buttonPrefab1) as GameObject;
            buttonObj.GetComponent<RectTransform>().anchoredPosition = new Vector2(2, -sum);
            buttonObj.transform.SetParent(buttonParent1, false);
            TextMeshProUGUI[] text = buttonObj.GetComponentsInChildren<TextMeshProUGUI>();
            text[0].text = (i+1).ToString();
            text[1].text = json[i][2].ToString().Trim('"');
            text[2].text = json[i][3].ToString().Trim('"');
            double value2;
            if (double.TryParse(json[i][3], out value2))
            {
                tt1 +=value2;
                
            }
            double value;
            if (double.TryParse(json[i][4], out value))
            {
                tt2 +=value;
                產品和+=value;
                text[3].text = value.ToString("#,##0.###");
            }
            else
            {
                // 解析失敗的處理邏輯
                text[3].text = json[i][4].ToString().Trim('"');
            }
            double value1;
            if (double.TryParse(json[i][5], out value1))
            {
                tt3 +=value1;
                重量和+=value1;
                text[4].text = value1.ToString("#,##0.###");
            }
            else
            {
                // 解析失敗的處理邏輯
                text[4].text = json[i][5].ToString().Trim('"');
            }
            sum+=40;
            copy1.Add(buttonObj);
        }
        原料小計1.text=tt1.ToString("#,##0.###");
        原料小計2.text=tt2.ToString("#,##0.###");
        原料小計3.text=tt3.ToString("#,##0.###");

        buttonceneter1.GetComponent<RectTransform>().sizeDelta = new Vector2(buttonceneter1.GetComponent<RectTransform>().sizeDelta.x, sum);
        yield return StartCoroutine(配方明細表乳化劑());
    }
    IEnumerator 配方明細表乳化劑()
    {
        if (copy2 != null)
        {
            DeleteCopies(copy2);
        }
        string strcon = "配方明細表乳化劑";
        string se = Main.Global.預設伺服器路徑;
        string str = 編號.text;
        string strUrl = string.Format(Main.Global.阿帕契路徑+"comm={0}&se={1}&PA={2}", strcon, se, str);
        UnityWebRequest request = UnityWebRequest.Get(strUrl);
        yield return request.SendWebRequest();
        if (request.result == UnityWebRequest.Result.ConnectionError)
        {
            Debug.Log(request.error);
            yield break;
        }
        JSONNode json = JSON.Parse(request.downloadHandler.text);
        int sum = 5;
        double tt1 = 0;
        double tt2 = 0;
        for (int i = 0; i < json.Count; i++)
        {
            GameObject buttonObj = Instantiate(buttonPrefab2) as GameObject;
            buttonObj.GetComponent<RectTransform>().anchoredPosition = new Vector2(2, -sum);
            buttonObj.transform.SetParent(buttonParent2, false);
            TextMeshProUGUI[] text = buttonObj.GetComponentsInChildren<TextMeshProUGUI>();
            text[0].text = (i+1).ToString();
            text[1].text = json[i][2].ToString().Trim('"');
            text[2].text = json[i][3].ToString().Trim('"');
            double value;
            if (double.TryParse(json[i][4], out value))
            {
                tt1 +=value;
                產品和+=value;
                text[3].text = value.ToString("#,##0.###");
            }
            else
            {
                // 解析失敗的處理邏輯
                text[3].text = json[i][4].ToString().Trim('"');
            }
            double value1;
            if (double.TryParse(json[i][5], out value1))
            {
                tt2 +=value1;
                重量和+=value1;
                text[4].text = value1.ToString("#,##0.###");
            }
            else
            {
                // 解析失敗的處理邏輯
                text[4].text = json[i][5].ToString().Trim('"');
            }
            sum+=40;
            copy2.Add(buttonObj);
        }
        乳化小計1.text = tt1.ToString("#,##0.###");
        乳化小計2.text = tt2.ToString("#,##0.###");

        buttonceneter2.GetComponent<RectTransform>().sizeDelta = new Vector2(buttonceneter2.GetComponent<RectTransform>().sizeDelta.x, sum);
        yield return StartCoroutine(配方明細表香料());
    }
    IEnumerator 配方明細表香料()
    {
        if (copy3 != null)
        {
            DeleteCopies(copy3);
        }
        string strcon = "配方明細表香料";
        string se = Main.Global.預設伺服器路徑;
        string str = 編號.text;
        string strUrl = string.Format(Main.Global.阿帕契路徑+"comm={0}&se={1}&PA={2}", strcon, se, str);
        UnityWebRequest request = UnityWebRequest.Get(strUrl);
        yield return request.SendWebRequest();
        if (request.result == UnityWebRequest.Result.ConnectionError)
        {
            Debug.Log(request.error);
            yield break;
        }
        JSONNode json = JSON.Parse(request.downloadHandler.text);
        int sum = 5;
        double tt1 = 0;
        double tt2 = 0;
        for (int i = 0; i < json.Count; i++)
        {
            GameObject buttonObj = Instantiate(buttonPrefab3) as GameObject;
            buttonObj.GetComponent<RectTransform>().anchoredPosition = new Vector2(2, -sum);
            buttonObj.transform.SetParent(buttonParent3, false);
            TextMeshProUGUI[] text = buttonObj.GetComponentsInChildren<TextMeshProUGUI>();
            text[0].text = (i+1).ToString();
            text[1].text = json[i][2].ToString().Trim('"');
            text[2].text = json[i][3].ToString().Trim('"');
            double value;
            if (double.TryParse(json[i][4], out value))
            {
                tt1 +=value;
                產品和+=value;
                text[3].text = value.ToString("#,##0.###");
            }
            else
            {
                // 解析失敗的處理邏輯
                text[3].text = json[i][4].ToString().Trim('"');
            }
            double value1;
            if (double.TryParse(json[i][5], out value1))
            {
                tt2 +=value1;
                重量和+=value1;
                text[4].text = value1.ToString("#,##0.###");
            }
            else
            {
                // 解析失敗的處理邏輯
                text[4].text = json[i][5].ToString().Trim('"');
            }
            sum+=40;
            copy3.Add(buttonObj);
        }
        香料小計1.text = tt1.ToString("#,##0.###");
        香料小計2.text = tt2.ToString("#,##0.###");
        buttonceneter3.GetComponent<RectTransform>().sizeDelta = new Vector2(buttonceneter3.GetComponent<RectTransform>().sizeDelta.x, sum);
        yield return StartCoroutine(配方明細表其他());
    }
    IEnumerator 配方明細表其他()
    {
        if (copy4 != null)
        {
            DeleteCopies(copy4);
        }
        string strcon = "配方明細表其他";
        string se = Main.Global.預設伺服器路徑;
        string str = 編號.text;
        string strUrl = string.Format(Main.Global.阿帕契路徑+"comm={0}&se={1}&PA={2}", strcon, se, str);
        UnityWebRequest request = UnityWebRequest.Get(strUrl);
        yield return request.SendWebRequest();
        if (request.result == UnityWebRequest.Result.ConnectionError)
        {
            Debug.Log(request.error);
            yield break;
        }
        JSONNode json = JSON.Parse(request.downloadHandler.text);
        int sum = 5;
        double tt1 = 0;
        double tt2 = 0;
        for (int i = 0; i < json.Count; i++)
        {
            GameObject buttonObj = Instantiate(buttonPrefab4) as GameObject;
            buttonObj.GetComponent<RectTransform>().anchoredPosition = new Vector2(2, -sum);
            buttonObj.transform.SetParent(buttonParent4, false);
            TextMeshProUGUI[] text = buttonObj.GetComponentsInChildren<TextMeshProUGUI>();
            text[0].text = (i+1).ToString();
            text[1].text = json[i][2].ToString().Trim('"');
            text[2].text = json[i][3].ToString().Trim('"');
            double value;
            if (double.TryParse(json[i][4], out value))
            {
                tt1 +=value;
                產品和+=value;
                text[3].text = value.ToString("#,##0.###");
            }
            else
            {
                // 解析失敗的處理邏輯
                text[3].text = json[i][4].ToString().Trim('"');
            }
            double value1;
            if (double.TryParse(json[i][5], out value1))
            {
                tt2 +=value1;
                重量和+=value1;
                text[4].text = value1.ToString("#,##0.###");
            }
            else
            {
                // 解析失敗的處理邏輯
                text[4].text = json[i][5].ToString().Trim('"');
            }
            sum+=40;
            copy4.Add(buttonObj);
        }
        其他小計1.text = tt1.ToString("#,##0.###");
        其他小計2.text = tt2.ToString("#,##0.###");
        buttonceneter4.GetComponent<RectTransform>().sizeDelta = new Vector2(buttonceneter4.GetComponent<RectTransform>().sizeDelta.x, sum);
        yield return StartCoroutine(配方明細表著色劑());
    }
    IEnumerator 配方明細表著色劑()
    {
        if (copy5 != null)
        {
            DeleteCopies(copy5);
        }
        string strcon = "配方明細表著色劑";
        string se = Main.Global.預設伺服器路徑;
        string str = 編號.text;
        string strUrl = string.Format(Main.Global.阿帕契路徑+"comm={0}&se={1}&PA={2}", strcon, se, str);
        UnityWebRequest request = UnityWebRequest.Get(strUrl);
        yield return request.SendWebRequest();
        if (request.result == UnityWebRequest.Result.ConnectionError)
        {
            Debug.Log(request.error);
            yield break;
        }
        JSONNode json = JSON.Parse(request.downloadHandler.text);
        int sum = 5;
        double tt1 = 0;
        double tt2 = 0;
        for (int i = 0; i < json.Count; i++)
        {
            GameObject buttonObj = Instantiate(buttonPrefab5) as GameObject;
            buttonObj.GetComponent<RectTransform>().anchoredPosition = new Vector2(2, -sum);
            buttonObj.transform.SetParent(buttonParent5, false);
            TextMeshProUGUI[] text = buttonObj.GetComponentsInChildren<TextMeshProUGUI>();
            text[0].text = (i+1).ToString();
            text[1].text = json[i][2].ToString().Trim('"');
            text[2].text = json[i][3].ToString().Trim('"');
            double value;
            if (double.TryParse(json[i][4], out value))
            {
                tt1 +=value;
                產品和+=value;
                text[3].text = value.ToString("#,##0.###");
            }
            else
            {
                // 解析失敗的處理邏輯
                text[3].text = json[i][4].ToString().Trim('"');
            }
            double value1;
            if (double.TryParse(json[i][5], out value1))
            {
                tt2 +=value1;
                重量和+=(value1/1000);
                text[4].text = value1.ToString("#,##0.###");
            }
            else
            {
                // 解析失敗的處理邏輯
                text[4].text = json[i][5].ToString().Trim('"');
            }
            sum+=40;
            copy5.Add(buttonObj);
        }
        著色小計1.text = tt1.ToString("#,##0.###");
        著色小計2.text = tt2.ToString("#,##0.###");
        合計產品.text = 產品和.ToString("#,##0.##") + " %";
        合計產品重量.text = 重量和.ToString("#,##0.##") + " kg";
        buttonceneter5.GetComponent<RectTransform>().sizeDelta = new Vector2(buttonceneter5.GetComponent<RectTransform>().sizeDelta.x, sum);
        yield return StartCoroutine(配方明細表油脂規格());
    }
    IEnumerator 配方明細表油脂規格()
    {
        if (copy6 != null)
        {
            DeleteCopies(copy6);
        }
        string strcon = "配方明細表油脂規格";
        string se = Main.Global.預設伺服器路徑;
        string str = 編號.text;
        string strUrl = string.Format(Main.Global.阿帕契路徑+"comm={0}&se={1}&PA={2}", strcon, se, str);
        UnityWebRequest request = UnityWebRequest.Get(strUrl);
        yield return request.SendWebRequest();
        if (request.result == UnityWebRequest.Result.ConnectionError)
        {
            Debug.Log(request.error);
            yield break;
        }
        JSONNode json = JSON.Parse(request.downloadHandler.text);
        int sum = 5;
        for (int i = 0; i < json.Count; i++)
        {
            GameObject buttonObj = Instantiate(buttonPrefab6) as GameObject;
            buttonObj.GetComponent<RectTransform>().anchoredPosition = new Vector2(2, -sum);
            buttonObj.transform.SetParent(buttonParent6, false);
            TextMeshProUGUI[] text = buttonObj.GetComponentsInChildren<TextMeshProUGUI>();
            text[0].text = (i+1).ToString();
            text[1].text = json[i][2].ToString().Trim('"');
            text[2].text = json[i][3].ToString().Trim('"');
            sum+=40;
            copy6.Add(buttonObj);
        }
        buttonceneter6.GetComponent<RectTransform>().sizeDelta = new Vector2(buttonceneter6.GetComponent<RectTransform>().sizeDelta.x, sum);
        yield return StartCoroutine(配方明細表產品規格());
    }
    IEnumerator 配方明細表產品規格()
    {
        if (copy7 != null)
        {
            DeleteCopies(copy7);
        }
        string strcon = "配方明細表產品規格";
        string se = Main.Global.預設伺服器路徑;
        string str = 編號.text;
        string strUrl = string.Format(Main.Global.阿帕契路徑+"comm={0}&se={1}&PA={2}", strcon, se, str);
        UnityWebRequest request = UnityWebRequest.Get(strUrl);
        yield return request.SendWebRequest();
        if (request.result == UnityWebRequest.Result.ConnectionError)
        {
            Debug.Log(request.error);
            yield break;
        }
        JSONNode json = JSON.Parse(request.downloadHandler.text);
        int sum = 5;
        for (int i = 0; i < json.Count; i++)
        {
            GameObject buttonObj = Instantiate(buttonPrefab7) as GameObject;
            buttonObj.GetComponent<RectTransform>().anchoredPosition = new Vector2(2, -sum);
            buttonObj.transform.SetParent(buttonParent7, false);
            TextMeshProUGUI[] text = buttonObj.GetComponentsInChildren<TextMeshProUGUI>();
            text[0].text = (i+1).ToString();
            text[1].text = json[i][2].ToString().Trim('"');
            text[2].text = json[i][3].ToString().Trim('"');
            sum+=40;
            copy7.Add(buttonObj);
        }
        buttonceneter7.GetComponent<RectTransform>().sizeDelta = new Vector2(buttonceneter7.GetComponent<RectTransform>().sizeDelta.x, sum);
        讀取面板.SetActive(false);
    }
    public void 清單按鈕()
    {
        清單.SetActive(!清單.activeSelf);
        明細.SetActive(!明細.activeSelf);
    }

    private void DeleteCopies(List<GameObject> copyList)
    {
        foreach (GameObject copy in copyList)
        {
            Destroy(copy);
        }
        copyList.Clear();
    }
    public void back()
    {
        change_Secen(1);
    }
    public void change_Secen(int _screenNum)
    {

        SceneManager.LoadScene(_screenNum);
    }
}