mes-client/UAS_MES_ODLF/FunctionCode/Special/Special_Repair.cs

using System;
using System.Collections;
using System.Collections.Generic;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using UAS_MES_NEW.CustomControl.DataGrid_View;
using UAS_MES_NEW.CustomControl.TextBoxWithIcon;
using UAS_MES_NEW.DataOperate;
using UAS_MES_NEW.Entity;
using UAS_MES_NEW.PublicMethod;

namespace UAS_MES_NEW.Special
{
    public partial class Special_Repair : Form
    {
        DataHelper dh = null;

        LogStringBuilder sql = new LogStringBuilder();

        List<string> sqls = new List<string>();

        DataTable dt = null;

        AutoSizeFormClass asc = new AutoSizeFormClass();

        public Special_Repair()
        {
            InitializeComponent();
        }

        private void Make_Repair_Load(object sender, EventArgs e)
        {
            dh = SystemInf.dh;
            GetSNCode.Focus();

            dt = (DataTable)dh.ExecuteSql("select distinct NR_NAME from qua_ngreason", "select");
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                as_reason.Properties.Items.Add(dt.Rows[i][0].ToString());
            }

            dt = (DataTable)dh.ExecuteSql("select distinct so_name from solution", "select");
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                as_method.Properties.Items.Add(dt.Rows[i][0].ToString());
            }

            dt = (DataTable)dh.ExecuteSql("select distinct bc_name from badcode", "select");
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                as_badpro.Properties.Items.Add(dt.Rows[i][0].ToString());
            }
        }

        private void Prodcode_DbChange(object sender, EventArgs e)
        {

        }

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

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

        private void GetSNCode_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            {
                if (GetSNCode.Text == "")
                {
                    OperatResult.AppendText(">>序列号不允许为空\n", Color.Red);
                    BaseUtil.CleanForm(this);
                    return;
                }
                sql.Clear();
                sql.Append("select * from aftersale left join makeserial on as_sn=ms_sncode left join make ");
                sql.Append("on ms_makecode=ma_code where as_sn = '" + GetSNCode.Text + "' order by ms_id desc");
                DataTable dt_ = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
                if (dt_.Rows.Count == 0)
                {
                    OperatResult.AppendText(">>序列号:" + GetSNCode.Text + "不存在导入清单中\n", Color.Red);
                    BaseUtil.CleanForm(this);
                    return;
                }

                dt = (DataTable)dh.ExecuteSql("select * from prodiomac where pim_mac='" + GetSNCode.Text + "' and PIM_INOROUT='OUT' and sysdate-180<PIM_INDATE ", "select");
                if (dt.Rows.Count == 0)
                {
                    OperatResult.AppendText(">>序列号:" + GetSNCode.Text + "出货已超过180天\n", Color.Red);
                    BaseUtil.CleanForm(this);
                    return;
                }

                BaseUtil.SetFormValue(this.Controls, dt_);

            }
        }

        private void Make_Repair_SizeChanged(object sender, EventArgs e)
        {


            asc.controlAutoSize(this);
        }

        private void RepairComplete_Click(object sender, EventArgs e)
        {
            if (GetSNCode.Text == "")
            {
                OperatResult.AppendText(">>序列号不允许为空\n", Color.Red);
                return;
            }
        }

        private void SaveRepairInf_Click(object sender, EventArgs e)
        {

        }

        private void Clean_Click(object sender, EventArgs e)
        {
            OperatResult.Clear();
        }

        private void Make_Repair_FormClosing(object sender, FormClosingEventArgs e)
        {
            dh.Dispose();
        }

        private void ms_prodcode_TextChanged(object sender, EventArgs e)
        {

        }

        public void RefreshData()
        {
            GetSNCode_KeyDown(new object(), new KeyEventArgs(Keys.Enter));
        }
    }
}