mes-client/UAS_MES_NEW/FunctionCode/Special/Special_Changesn.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_NEW.DataOperate;
using UAS_MES_NEW.Entity;
using UAS_MES_NEW.Make;
using UAS_MES_NEW.PublicMethod;

namespace UAS_MES_NEW.Special
{
    public partial class Special_Changesn : Form
    {
        DataHelper dh;

        LogStringBuilder sql = new LogStringBuilder();

        DataTable dt;

        public Special_Changesn()
        {
            InitializeComponent();
        }

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

        private void Split_Click(object sender, EventArgs e)
        {
            
        }

        private void SN_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            {
                sql.Clear();
                sql.Append("select ms_makecode makecode  from makeserial left join make ");
                sql.Append("on ms_makecode=ma_code where ms_sncode = '" + SN.Text + "' order by ms_id desc");
                dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
                BaseUtil.SetFormValue(this.Controls, dt);
                string ms_paststep = "";
                if (!(dt.Rows.Count > 0))
                {
                    OperatResult.AppendText(">>序列号:" + SN.Text + "不存在\n", Color.Red);
                    BaseUtil.CleanForm(this);
                    return;
                }
                newsn.Focus();
                newsn.SelectAll();

            }
        }


        private void newsn_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            {
                sql.Clear();
                sql.Append("select ms_makecode makecode  from makeserial left join make ");
                sql.Append("on ms_makecode=ma_code where ms_sncode = '" + newsn.Text + "' order by ms_id desc");
                dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
                BaseUtil.SetFormValue(this.Controls, dt);
                string ms_paststep = "";
                if ((dt.Rows.Count > 0))
                {
                    OperatResult.AppendText(">>序列号:" + newsn.Text + "已存在，不允许采集\n", Color.Red);
                    BaseUtil.CleanForm(this);
                    return;
                }
                if (SN.Text != "" && newsn.Text != "" && SN.Text.Length == newsn.Text.Length)
                {
                    dh.ExecuteSql("update makeserial set ms_sncode = '" + newsn.Text + "' where ms_sncode = '"+SN.Text+"' ", "update");
                    OperatResult.AppendText(">>序列号:" + SN.Text + "更新为"+newsn.Text+"\n", Color.Green);
                    BaseUtil.CleanForm(this);
                    SN.Focus();
                    SN.SelectAll();
                    return;
                }
                else
                {
                    OperatResult.AppendText(">>序列号:" + newsn.Text + "不允许转换，请重新采集\n", Color.Red);
                    BaseUtil.CleanForm(this);
                    return;
                }
            }
        }

        private void NewBadCode_Click(object sender, EventArgs e)
        {

        }
    }
}