mes-client/UAS-MES/FunctionCode/Query/Query_SnMessage.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.CustomControl.TextBoxWithIcon;
using UAS_MES.CustomControl.ValueLabel;
using UAS_MES.DataOperate;
using UAS_MES.Entity;
using UAS_MES.PublicMethod;

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

        DataHelper dh;

        LogStringBuilder sql = new LogStringBuilder();

        DataTable dt;

        DataTable ms_id;//记录ms_id

        AutoSizeFormClass asc = new AutoSizeFormClass();
        public Query_SnMessage()
        {
            InitializeComponent();
        }

        private void Query_SnMessage_Load(object sender, EventArgs e)
        {
            dh = SystemInf.dh;
            asc.controllInitializeSize(this);
            sn_code.Focus();
        }

        private void sn_code_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            {
                ms_id = (DataTable)dh.ExecuteSql("select beforesn,sn from makesnrelation where beforesn='" + sn_code.Text + "' or sn='" + sn_code.Text + "'", "select");
                if (ms_id.Rows.Count > 0)
                {
                    //说明有过转号
                    ms_id = (DataTable)dh.ExecuteSql("select ms_id,ms_makecode,ms_outboxcode,ms_checkno from makeserial where ms_sncode='" + ms_id.Rows[0]["beforesn"].ToString() + "' or ms_sncode='" + ms_id.Rows[0]["sn"].ToString() + "' order by ms_id", "select");
                }
                else
                {
                    //没有过转号
                    ms_id = (DataTable)dh.ExecuteSql("select ms_id,ms_makecode,ms_outboxcode,ms_checkno from makeserial where ms_sncode='" + sn_code.Text + "' order by ms_id", "select");
                }
                if (ms_id.Rows.Count == 0)
                {
                    //无值则提示
                    MessageBox.Show("序列号" + sn_code.Text + "不存在");
                    return;
                }
                StringBuilder ms_ids = new StringBuilder();//存所有的ms_id
                //设置界面工单号
                ma_makecode.Text = ms_id.Rows[ms_id.Rows.Count - 1]["ms_makecode"].ToString();
                ms_outboxcode.Text = ms_id.Rows[ms_id.Rows.Count - 1]["ms_outboxcode"].ToString();
                ms_checkno.Text = ms_id.Rows[ms_id.Rows.Count - 1]["ms_checkno"].ToString();
            }
        }

        private void Query_SnMessage_SizeChanged(object sender, EventArgs e)
        {
            asc.controlAutoSize(this);
        }

        private void Enter_Click(object sender, EventArgs e)
        {
            sn_code_KeyDown(this,new KeyEventArgs(Keys.Enter));
        }


        public static void CleanForm(Form Form)
        {
            for (int i = 0; i < Form.Controls.Count; i++)
            {
                if ((Form.Controls[i] is SnCollectionBox || Form.Controls[i] is ValueLabel))
                    Form.Controls[i].Text = "";
            }
        }

        private void Clean_Click(object sender, EventArgs e)
        {
            CleanForm(this);
        }
    }
}