XS202101146541/PMSUI/UI/库位状态显示/FrmShowWareHouseStatus.cs

using CasunCommon.BaseUI;
using Pms.UserEvent.Model;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace PMSUI.UI.库位状态显示
{
    public partial class FrmShowWareHouseStatus : CasunForm
    {
        public FrmShowWareHouseStatus()
        {
            InitializeComponent();
        }

        private void findData()
        {
            StringBuilder sb = new StringBuilder();
            sb.Append($" SELECT ");
            sb.Append($" * ");
            sb.Append($" from ");
            sb.Append($" UpStation");
            DataTable dt = ConDataBase.reDt(sb.ToString());
            if (dt != null && dt.Rows != null && dt.Rows.Count > 0)
            {
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    int StationSelect = int.Parse(dt.Rows[i]["StationSelect"].ToString());
                    switch (StationSelect)
                    {
                        case 1:
                            {
                                string StationNum = dt.Rows[i]["StationNum"].ToString();
                                int StationValue = int.Parse(dt.Rows[i]["StationValue"].ToString());
                                switch (StationValue)
                                {
                                    case 0:
                                        {
                                            btn_Up1.Text = StationNum;
                                            btn_Up1.BackColor = Color.Red;
                                            break;
                                        }
                                    case 1:
                                        {
                                            btn_Up1.Text = StationNum;
                                            btn_Up1.BackColor = Color.Green;
                                            break;
                                        }
                                }
                                break;
                            }
                        case 2:
                            {
                                string StationNum = dt.Rows[i]["StationNum"].ToString();
                                int StationValue = int.Parse(dt.Rows[i]["StationValue"].ToString());
                                switch (StationValue)
                                {
                                    case 0:
                                        {
                                            btn_Up2.Text = StationNum;
                                            btn_Up2.BackColor = Color.Red;
                                            break;
                                        }
                                    case 1:
                                        {
                                            btn_Up2.Text = StationNum;
                                            btn_Up2.BackColor = Color.Green;
                                            break;
                                        }
                                }
                                break;
                            }
                    }
                }
            }
        }

        private void FrmShowWareHouseStatus_Load(object sender, EventArgs e)
        {
            findData();
        }

        private void btn_Up1_Click(object sender, EventArgs e)
        {
            EditWareHouseMsg sd = new EditWareHouseMsg();
            sd.StationNum = btn_Up1.Text.Trim();
            sd.ShowDialog();
            findData();
        }

        private void btn_Up2_Click(object sender, EventArgs e)
        {
            EditWareHouseMsg sd = new EditWareHouseMsg();
            sd.StationNum = btn_Up2.Text.Trim();
            sd.ShowDialog();
            findData();
        }

        private void FrmShowWareHouseStatus_Activated(object sender, EventArgs e)
        {
            findData();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            findData();
        }
    }
}