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.UpperCollection)
                {
                    if (SystemInf.SplitStr)
                    {
                        return base.Text.ToUpper().Split(';')[0];
                    }
                    else
                    {
                        return base.Text.ToUpper();
                    }
                }
                else
                {
                    if (SystemInf.SplitStr)
                    {
                        return base.Text.Split(';')[0];
                    }
                    else
                    {
                        return base.Text;
                    }
                }
            }

            set
            {
                base.Text = value;
            }
        }

        private void SnCollectionBox_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            {
                if (SystemInf.GetRelation && base.Text != "")
                {
                    string sn = dh.getFieldDataByCondition("SNRELATION_VIEW", "sr_sn", "sr_code='" + base.Text + "'").ToString();
                    int count = int.Parse(dh.getFieldDataByCondition("SNRELATION_VIEW", "count(1) cn", "sr_code='" + base.Text + "'").ToString());
                    if (sn == "" || count > 1)
                    {
                        MessageBox.Show("SN:" + base.Text + "未找到关联信息");
                        base.Text = "";
                        return;
                    }
                    else
                    {
                        if (SystemInf.UpperCollection)
                            base.Text = sn.ToUpper();
                        else
                            base.Text = sn;
                    }
                }
                this.SelectAll();
            }
        }
    }
}