mes-client/UAS-MES/FunctionCode/Query/Query_OperationInstruction.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using UAS_MES.DataOperate;
using UAS_MES.Entity;
using UAS_MES.PublicMethod;

namespace UAS_MES.Query
{
    public partial class Query_OperationInstruction : Form
    {

        DataHelper dh;

        public Query_OperationInstruction()
        {
            InitializeComponent();
        }

        private void Query_OperationInstruction_Load(object sender, EventArgs e)
        {
            dh = SystemInf.dh;
        }

        private void Query_OperationInstruction_SizeChanged(object sender, EventArgs e)
        {
            sn_label.Location = new Point(20, 20);
            SnCode.Location = new Point(sn_label.Location.X + sn_label.Width + 20, 20);
            FileList_label.Location = new Point(SnCode.Location.X + SnCode.Width + 20, 20);
            FileList.Location = new Point(FileList_label.Location.X + FileList_label.Width + 20, 20);
        }

        private void SnCode_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            {
                string MachineType = dh.getFieldDataByCondition("makeserial left join product on pr_code=ms_prodcode", "pr_machinetype", "ms_id=(select max(ms_id) from makeserial where ms_sncode='" + SnCode.Text + "')").ToString();
                //string FilePath = dh.getFieldDataByCondition("", "", "").ToString();
            }
        }

        private void OpenFile_Click(object sender, EventArgs e)
        {
            Query.Query_ShowInstruction showin = new Query_ShowInstruction(FileList.Text);
            showin.Show();
        }
    }
}