mes-client/UAS-MES/CustomControl/TextBoxWithIcon/SnCollectionBox.cs

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

namespace UAS_MES.CustomControl.TextBoxWithIcon
{
    public partial class SnCollectionBox : EnterTextBox
    {
        public SnCollectionBox()
        {
            InitializeComponent();
        }

        DataHelper dh = SystemInf.dh;

        public override string Text
        {
            get
            {
                if (SystemInf.GetRelation&&base.Text!="")
                {

                   string sn = dh.getFieldDataByCondition("SNRELATION_VIEW", "sr_sn", "content like '%"+base.Text+"%'").ToString();
                   int count = int.Parse(dh.getFieldDataByCondition("SNRELATION_VIEW", "count(1) cn", "content like '%" + base.Text + "%'").ToString());
                    if (sn == ""||count>1)
                    {
                        MessageBox.Show("SN:" + base.Text + "未找到关联信息");
                        return "";
                    }
                    else
                    {

                        if (SystemInf.UpperCollection)
                            return sn.ToUpper();
                        else
                            return sn;
                    }
                }
                else
                {
                    if (SystemInf.UpperCollection)
                        return base.Text.ToUpper();
                    else
                        return base.Text;
                }
            }

            set
            {
                base.Text = value;
            }
        }

        private void SnCollectionBox_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            {
                this.SelectAll();
            }
        }
    }
}