Sh-To-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
{
    public CanvasScaler canvasScaler;
    float screenWidth;
    float screenHeight;

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

    public GameObject buttonPrefab;
    public Transform buttonParent;
    public GameObject buttonceneter;
    private List<GameObject> copy = new List<GameObject>();

    public GameObject buttonPrefab1;
    public Transform buttonParent1;
    public GameObject buttonceneter1;
    private List<GameObject> copy1 = new List<GameObject>();


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

    public TMP_Dropdown 年下拉;
    public TMP_Dropdown 月下拉;
    [SerializeField] TextMeshProUGUI 標題;

    // Start is called before the first frame update
    void Start()
    {
        Screen.autorotateToPortrait = false;
        Screen.orientation = ScreenOrientation.LandscapeLeft;
        float rate = 900.0f / 1900.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/shto_main.php?";
        //Main.Global.預設伺服器路徑="official";

        StartCoroutine(AnimateText());
        讀取面板.SetActive(true);

        DateTime currentDate = DateTime.Now;
        年下拉.value = currentDate.Year - 2023;
        月下拉.value = currentDate.Month - 1;
        年下拉.onValueChanged.AddListener(年份改變);
        月下拉.onValueChanged.AddListener(月份改變);
        StartCoroutine(出貨日報表清單(currentDate.Year.ToString(), currentDate.Month.ToString()));
    }
    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 出貨日報表清單(string pa, string pa1)
    {
        if (copy != null)
        {
            DeletetextCopies();
        }
        string strcon = "出貨日報表清單";
        string se = Main.Global.預設伺服器路徑;
        string strUrl = string.Format(Main.Global.阿帕契路徑+"comm={0}&se={1}&PA={2}&PA1={3}", strcon, se, pa, pa1);
        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 = 3;
        for (int i = 0; i < json.Count; i++)
        {
            GameObject buttonObj = Instantiate(buttonPrefab) as GameObject;
            buttonObj.GetComponent<RectTransform>().anchoredPosition = new Vector2(3, -sum);
            buttonObj.transform.SetParent(buttonParent, false);
            TextMeshProUGUI text = buttonObj.GetComponentInChildren<TextMeshProUGUI>();
            Button bt = buttonObj.GetComponentInChildren<Button>();
            int index = i;
            bt.onClick.AddListener(() =>
            {
                string str = json[index][1].ToString().Trim('"');
                StartCoroutine(出貨日報表明細(str));
                DateTime date = DateTime.ParseExact(str, "yyyy/MM/dd", null);
                DayOfWeek dayOfWeek = date.DayOfWeek;
                string weekdayString = dayOfWeek.ToString();
                string week = "";
                if (weekdayString =="Monday")
                {
                    week="一";
                }
                else if (weekdayString =="Tuesday")
                {
                    week="二";
                }
                else if (weekdayString =="Wednesday")
                {
                    week="三";
                }
                else if (weekdayString =="Thursday")
                {
                    week="四";
                }
                else if (weekdayString =="Friday")
                {
                    week="五";
                }
                else if (weekdayString =="Saturday")
                {
                    week="六";
                }
                else if (weekdayString =="Sunday")
                {
                    week="天";
                }
                標題.text=str+"-星期"+week;
            });
            text.text = json[i][1].ToString().Trim('"');
            sum+=75;
            copy.Add(buttonObj);
        }
        buttonceneter.GetComponent<RectTransform>().sizeDelta = new Vector2(buttonceneter.GetComponent<RectTransform>().sizeDelta.x, sum);
        讀取面板.SetActive(false);
    }
    public void 年份改變(int value)
    {
        讀取面板.SetActive(true);
        int a = value + 2023;
        int b = 月下拉.value + 1;
        StartCoroutine(出貨日報表清單(a.ToString(), b.ToString()));
        標題.text="";
        if (copy1 != null)
        {
            DeletetextCopies1();
        }
    }
    private void 月份改變(int value)
    {
        讀取面板.SetActive(true);
        int a = 年下拉.value + 2023;
        int b = value + 1;
        StartCoroutine(出貨日報表清單(a.ToString(), b.ToString()));
        標題.text="";
        if (copy1 != null)
        {
            DeletetextCopies1();
        }
    }
    IEnumerator 出貨日報表明細(string pa)
    {
        讀取面板.SetActive(true);
        if (copy1 != null)
        {
            DeletetextCopies1();
        }
        string strcon = "出貨日報表明細";
        string se = Main.Global.預設伺服器路徑;
        string strUrl = string.Format(Main.Global.阿帕契路徑+"comm={0}&se={1}&PA2={2}", strcon, se, pa);
        Debug.Log(strUrl);
        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);
        Debug.Log(json);
        int sum = 3;
        for (int i = 0; i < json.Count; i++)
        {
            GameObject buttonObj = Instantiate(buttonPrefab1) as GameObject;
            buttonObj.GetComponent<RectTransform>().anchoredPosition = new Vector2(3, -sum);
            buttonObj.transform.SetParent(buttonParent1, false);
            TextMeshProUGUI[] text = buttonObj.GetComponentsInChildren<TextMeshProUGUI>();
            text[0].text = (i+1).ToString();
            text[1].text = json[i][1].ToString().Trim('"');
            text[2].text = json[i][2].ToString().Trim('"');
            text[3].text = json[i][3].ToString().Trim('"');
            sum+=80;
            copy1.Add(buttonObj);
        }
        buttonceneter1.GetComponent<RectTransform>().sizeDelta = new Vector2(buttonceneter1.GetComponent<RectTransform>().sizeDelta.x, sum);
        讀取面板.SetActive(false);

    }
    public void DeletetextCopies()
    {
        // 刪除複製出來的物件
        foreach (GameObject copy in copy)
        {
            Destroy(copy);
        }
        copy.Clear();
    }
    public void DeletetextCopies1()
    {
        // 刪除複製出來的物件
        foreach (GameObject copy in copy1)
        {
            Destroy(copy);
        }
        copy1.Clear();
    }
    public void back()
    {
        change_Secen(12);
    }
    public void change_Secen(int _screenNum)
    {

        SceneManager.LoadScene(_screenNum);
    }
}