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

namespace UAS_MES_NEW.Make
{
    public partial class Make_SMTSStencil : Form
    {

        DataTable Dbfind;
        bool ifUsed = false;
        AutoSizeFormClass asc = new AutoSizeFormClass();

        DataHelper dh = SystemInf.dh;

        StringBuilder sql = new StringBuilder();

        public Make_SMTSStencil()
        {
            InitializeComponent();
            SU_DEVCODE.Enabled = false;
            st_combinenumber.Enabled = false;
            SU_DEVCODE1.Enabled = false;

            st_table.Enabled = false;
            su_singlepringqty1.Enabled = false;
            Receive.Enabled = false;
            Return.Enabled = false;

            SU_DEVCODE.Enabled = false;
            SU_DEVCODE1.Enabled = false;
            ST_ENSIONA.Enabled = false;
            ST_ENSIONB.Enabled = false;
            ST_ENSIONC.Enabled = false;
            ST_ENSIOND.Enabled = false;
            ST_ENSIONE.Enabled = false;
            Scrap.Enabled = false;

        }

        private void Make_SMTStencil_Load(object sender, EventArgs e)
        {
            asc.controllInitializeSize(this);
            li_code.Text = User.UserLineCode;
            //工单号放大镜配置
            ma_code.TableName = "make left join product on ma_prodcode=pr_code";
            ma_code.SelectField = "ma_code # 工单号,ma_prodcode # 产品编号,ma_qty # 工单数量,pr_detail # 产品名称,ma_softversion # 软件版本,ma_salecode # 销售单号,pr_sendchecktype # 产品送检方式";
            ma_code.FormName = Name;
            ma_code.SetValueField = new string[] { "ma_code", "ma_prodcode", "ma_qty", "pr_detail", "ma_softversion", "ma_salecode", "nvl(pr_sendchecktype,'LineCode')pr_sendchecktype" };
            ma_code.DbChange += Ma_code_DbChange;

            li_code.TableName = "Line";
            li_code.SelectField = "li_code # 线别编号,li_name # 线别名称";
            li_code.Condition = "li_wccode='SMT'";
            li_code.FormName = Name;
            li_code.SetValueField = new string[] { "li_code", "li_name" };
            li_code.DbChange += Li_code_DbChange;
            ma_code.Controls["TextBox"].Focus();
        }

        private void Li_code_DbChange(object sender, EventArgs e)
        {
            Dbfind = li_code.ReturnData;
            BaseUtil.SetFormValue(this.Controls, Dbfind);
        }

        private void Ma_code_DbChange(object sender, EventArgs e)
        {
            Dbfind = ma_code.ReturnData;
            BaseUtil.SetFormValue(this.Controls, Dbfind);
            Confirm.PerformClick();
        }

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

        private void LoadGridData()
        {
            sql.Clear();
            sql.Append("select St_PCBCODE,su_stcode,su_table,su_status,su_linecode,su_usemacode,su_singlepringqty,su_stverison ");
            sql.Append("from StencilUse left join stencil on st_code=su_stcode where su_usemacode='" + ma_code.Text + "' and su_status='在线' and st_kind = '刮刀'");
            DataTable dt = (DataTable)dh.ExecuteSql(sql.ToString(), "select");
            BaseUtil.FillDgvWithDataTable(ToolsBom, dt);
        }

        private void Confirm_Click(object sender, EventArgs e)
        {
            LoadGridData();
        }

        private void Receive_Click(object sender, EventArgs e)
        {
            if (ma_code.Text == "")
            {
                MessageBox.Show("工单号不能为空");
                return;
            }
            DataTable dt1 = (DataTable)dh.ExecuteSql($@"SELECT * FROM stenciluse, stencil WHERE su_status = '上线' 
                AND su_usemacode = '{ma_code.Text}' AND su_linecode = '{li_code.Text}' AND su_stcode = st_code AND st_kind = '刮刀'", "select");
            if (dt1.Rows.Count > 0)
            {
                string suid = dt1.Rows[0]["SU_ID"].ToString();
                string stcode = dt1.Rows[0]["SU_STCODE"].ToString();

                dt1 = (DataTable)dh.ExecuteSql($"select max(su_id) SU_ID from stenciluse where su_stcode = '{stcode}' and su_status = '下线'", "select");
                if (dt1.Rows.Count > 0)
                {
                    string currSuid = dt1.Rows[0]["SU_ID"].ToString();
                    if (Convert.ToInt32(currSuid) < Convert.ToInt32(suid))
                    {
                        MessageBox.Show($"工单:{ma_code.Text} 已有上线刮刀:{stcode},请下线后再上线");
                        return;
                    }
                }
                else
                {
                    MessageBox.Show($"工单:{ma_code.Text} 已有上线刮刀:{stcode},请下线后再上线");
                    return;
                }
            }

            int WaringCount = int.Parse(dh.GetConfig("WaringCount", "Stencil").ToString());
            DataTable dt = (DataTable)dh.ExecuteSql("select ST_USESTATUS,st_version,nvl(st_maxusecount,0)st_maxusecount,nvl(st_usecount,0)st_usecount from Stencil where st_code='" + SU_DEVCODE.Text + "' and st_statuscode='AUDITED' and st_kind = '刮刀'", "select");
            string status = "";
            string version = "";
            double st_maxusecount = 0;
            double st_usecount = 0;
            if (dt.Rows.Count > 0)
            {
                status = dt.Rows[0]["ST_USESTATUS"].ToString();
                version = dt.Rows[0]["st_version"].ToString();
                st_maxusecount = Convert.ToDouble(dt.Rows[0]["st_maxusecount"].ToString());
                st_usecount = Convert.ToDouble(dt.Rows[0]["st_usecount"].ToString());
                if (status == "在线" || status == "报废" || status == "在仓")
                {
                    MessageBox.Show("当前刮刀" + SU_DEVCODE.Text + "处于" + status + "状态,无法领用");
                    return;
                }
            }
            else
            {
                MessageBox.Show("刮刀编号" + SU_DEVCODE.Text + "不存在或者未审核");
                return;
            }
            //使用次数预警
            if (st_maxusecount - st_usecount < WaringCount)
            {
                string close = MessageBox.Show(this.ParentForm, "刮刀已使用" + st_usecount + "，距离使用上限还有" + (st_maxusecount - st_usecount) + "次", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question).ToString();
                if (close != "Yes")
                {
                    return;
                }
            }
            //限制钢网使用的产品
            String pr_spec = dh.getFieldDataByCondition("product", "pr_spec", "pr_code = '" + ma_prodcode.Text + "'").ToString();
            String st_vendcode = dh.getFieldDataByCondition("STENCIL", "nvl(st_vendcode,'aabbcc')", "st_code = '" + SU_DEVCODE.Text + "'").ToString();
            //if (!pr_spec.Contains(st_vendcode))
            //{
            //    MessageBox.Show("钢网编号" + SU_DEVCODE.Text + "不能在产品" + ma_prodcode.Text + "中使用");
            //    return;
            //}
            //dt = (DataTable)dh.ExecuteSql("select 1 from STENILCANUSEPRO where sp_stcode='" + SU_DEVCODE.Text + "' and sp_prodcode='" + ma_prodcode.Text + "'", "select");
            //if (dt.Rows.Count == 0)
            //{
            //    MessageBox.Show("钢网编号" + SU_DEVCODE.Text + "不能在产品" + ma_prodcode.Text + "中使用");
            //    return;
            //}
            //一条线只能在线一个钢网
            //dt = (DataTable)dh.ExecuteSql("select su_stcode from stenciluse where su_linecode='" + li_code.Text + "' and su_status='在线'", "select");
            //if (dt.Rows.Count > 0)
            //{
            //    MessageBox.Show("线别" + li_code.Text + "已有领用的钢网" + dt.Rows[0]["su_stcode"].ToString() + ",请先退回");
            //    return;
            //}
            //else
            //{
            string maxSuid = dh.getFieldDataByCondition("stenciluse", "max(su_id)", "su_stcode = '" + SU_DEVCODE.Text + "'").ToString();
            string pr_status = dh.getFieldDataByCondition("stenciluse", "su_status", "su_id = '" + maxSuid + "'").ToString();
            if (pr_status == "上线")
            {
                MessageBox.Show("刮刀编号" + SU_DEVCODE.Text + "已上线,请先清洗回库");
                return;
            }

            dt = (DataTable)dh.ExecuteSql("select em_name from employee where em_code='" + User.UserCode + "'", "select");
            if (dt.Rows.Count > 0)
            {
                string em_name = dt.Rows[0]["em_name"].ToString();
                sql.Clear();
                sql.Append("insert into StencilUse(su_id,SU_USEPRODCODE,SU_CLEANNUMS,su_stid,su_linecode,su_stcode,su_usedate,su_useman,SU_USEMANCODE,SU_TABLE,su_usemacode,su_singlepringqty,su_stverison,SU_STATUS,su_indate)");
                sql.Append("select StencilUse_seq.nextval,'" + ma_prodcode.Text + "',ST_CLEANNUMS,st_id,'" + li_code.Text + "','" + SU_DEVCODE.Text + "',sysdate,'" + em_name + "','" + User.UserCode + "','" + st_table.Text + "','" + ma_code.Text + "'");
                sql.Append(",'" + su_singlepringqty1.Text + "',st_version,'上线',sysdate from ");
                sql.Append("Stencil where st_code='" + SU_DEVCODE.Text + "'");
                dh.ExecuteSql(sql.ToString(), "insert");
                dh.ExecuteSql($"update Stencil set ST_USESTATUS='在线',ST_LINE = '{li_code.Text}' where st_code='" + SU_DEVCODE.Text + "'", "update");
                MessageBox.Show("上线成功");
                st_table.SelectedItem = null;
                SU_DEVCODE.Text = "";
                em_code.Text = "";
                //Receive.Enabled = false;
                LoadGridData();

                /*if (int.Parse(su_singlepringqty1.Text) > 0)
                {
                }
                else
                {
                    MessageBox.Show("单片次数必须大于0");
                }*/
            }
            else
            {
                MessageBox.Show("人员编号" + User.UserCode + "不存在");
            }
            //        }
        }

        private void Return_Click(object sender, EventArgs e)
        {
            //if (ST_ENSIONA.Text != "" && ST_ENSIONB.Text != "" && ST_ENSIONC.Text != "" && ST_ENSIOND.Text != "" && ST_ENSIONE.Text != "")
            //{
            DataTable dt = (DataTable)dh.ExecuteSql("select ST_USESTATUS,St_USECOUNT from Stencil where st_code='" + SU_DEVCODE1.Text + "' and st_statuscode='AUDITED' and st_kind = '刮刀' ", "select");
            if (dt.Rows.Count > 0)
            {
                string status = dt.Rows[0]["ST_USESTATUS"].ToString();
                if (status == "在仓" || status == "借出")
                {
                    MessageBox.Show("当前刮刀" + SU_DEVCODE.Text + "未在线,无需归还");
                    return;
                }
                if (status == "报废")
                {
                    MessageBox.Show("当前刮刀" + SU_DEVCODE.Text + "处于" + status + "状态,无法退回");
                    return;
                }
            }
            else
            {
                MessageBox.Show("刮刀编号" + SU_DEVCODE1.Text + "不存在或者未审核");
            }
            string St_USECOUNT = dt.Rows[0]["St_USECOUNT"].ToString();
            dt = (DataTable)dh.ExecuteSql("select em_name from employee where em_code='" + User.UserCode + "'", "select");
            if (dt.Rows.Count > 0)
            {
                //if (int.Parse(st_combinenumber.Text) >= 0)
                //{
                /*sql.Clear();
                sql.Append("update StencilUse set SU_ENSIONA='" + ST_ENSIONA.Text + "',SU_ENSIONB='" + ST_ENSIONB.Text + "',SU_ENSIONC='" + ST_ENSIONC.Text + "',SU_ENSIOND='" + ST_ENSIOND.Text + "',SU_ENSIONE='" + ST_ENSIONE.Text + "', su_cleannums=nvl(su_cleannums,0)+1, SU_BACKDATE=sysdate,su_returnman='" + dt.Rows[0]["em_name"].ToString() + "',su_returnmancode='" + em_code1.Text + "',");
                sql.Append("SU_THISUSETIMES='" + (st_combinenumber.Text == "" ? "0" : st_combinenumber.Text) + "',SU_STATUS='借出'");
                sql.Append(",SU_RETURNIFCLEAN='" + (SU_RETURNIFCLEAN.Checked ? "-1" : "0") + "' where su_id=(select max(su_id) from stenciluse where su_stcode='" + SU_DEVCODE1.Text + "' and su_status='在线')");
                dh.ExecuteSql(sql.ToString(), "update");
                sql.Clear();
                sql.Append("update Stencil set st_cleannums=nvl(st_cleannums,0)+1,ST_ENSIONA='" + ST_ENSIONA.Text + "',ST_ENSIONB='" + ST_ENSIONB.Text + "',ST_ENSIONC='" + ST_ENSIONC.Text + "',ST_ENSIOND='" + ST_ENSIOND.Text + "',ST_ENSIONE='" + ST_ENSIONE.Text + "',St_USECOUNT=nvl(St_USECOUNT,0)+" + (st_combinenumber.Text == "" ? "0" : st_combinenumber.Text) + ",ST_USESTATUS='借出' where st_code='" + SU_DEVCODE1.Text + "'");
                dh.ExecuteSql(sql.ToString(), "update");*/

                sql.Clear();
                sql.Append($@"INSERT INTO stenciluse (su_id,su_ensiona,su_ensionb,su_ensionc,su_ensiond,su_ensione,su_stid,su_stcode,su_indate,su_useman,
                            su_cleannums,su_backdate,su_returnman,su_returnmancode,su_status,su_returnifclean)
                            SELECT stenciluse_seq.NEXTVAL,'{ST_ENSIONA.Text}', '{ST_ENSIONB.Text}', '{ST_ENSIONC.Text}','{ST_ENSIOND.Text}','{ST_ENSIONE.Text}',st_id,'{SU_DEVCODE1.Text.Trim()}',sysdate,'{dt.Rows[0]["em_name"].ToString()}',
                            '{(SU_RETURNIFCLEAN.Checked ? 1 : 0)}', sysdate,'{User.UserName}','{User.UserCode}','下线', '{(SU_RETURNIFCLEAN.Checked ? "-1" : "0")}'
                            FROM stencil WHERE st_code = '" + SU_DEVCODE1.Text.Trim() + "'");
                dh.ExecuteSql(sql.ToString(), "insert");

                dh.ExecuteSql($@"UPDATE stencil SET st_ensiona = '{ST_ENSIONA.Text}',st_ensionb = '{ST_ENSIONB.Text}',
                            st_ensionc = '{ST_ENSIONC.Text}',st_ensiond = '{ST_ENSIOND.Text}',st_ensione = '{ST_ENSIONE.Text}',st_usestatus = '借出',ST_LINE = ''
                            WHERE st_code = '{SU_DEVCODE1.Text}'", "update");


                MessageBox.Show("刮刀" + SU_DEVCODE1.Text + "下线成功！");
                SU_DEVCODE1.Text = "";
                st_combinenumber.Text = "";
                em_code1.Text = "";
                ST_ENSIONA.Text = "";
                ST_ENSIONB.Text = "";
                ST_ENSIONC.Text = "";
                ST_ENSIOND.Text = "";
                ST_ENSIONE.Text = "";
                SU_RETURNIFCLEAN.Checked = false;
                //Return.Enabled = false;
                Confirm.PerformClick();
                //}
                //else
                //{
                //    MessageBox.Show("加工小板数必须大于等于0");
                //}
            }
            else
            {
                MessageBox.Show("人员编号" + User.UserCode + "不存在");
            }
            /*if (SU_RETURNIFCLEAN.Checked)
            {
                
            }
            else
            {
                MessageBox.Show("请确认是否清洗刮刀");
            }*/
            //}
            //    else
            //    {
            //        MessageBox.Show("请维护完成的测试参数");
            //    }
        }

        private void Radio_CheckedChanged(object sender, EventArgs e)
        {
            switch ((sender as Control).Name)
            {
                case "RadioReceive":
                    if ((sender as RadioButton).Checked)
                    {
                        SU_DEVCODE.Enabled = true;
                        Receive.Enabled = true;
                        st_table.Enabled = true;
                        su_singlepringqty1.Enabled = true;
                        Receive.Enabled = true;
                        st_combinenumber.Enabled = false;
                        SU_DEVCODE1.Enabled = false;
                        Return.Enabled = false;
                        ST_ENSIONA.Enabled = false;
                        ST_ENSIONB.Enabled = false;
                        ST_ENSIONC.Enabled = false;
                        ST_ENSIOND.Enabled = false;
                        ST_ENSIONE.Enabled = false;
                        Return.Enabled = false;
                        Scrap.Enabled = false;
                    }
                    break;
                case "RadioReturn":
                    if ((sender as RadioButton).Checked)
                    {
                        SU_DEVCODE1.Enabled = true;
                        st_combinenumber.Enabled = true;
                        Return.Enabled = true;
                        SU_DEVCODE.Enabled = false;
                        st_table.Enabled = false;
                        su_singlepringqty1.Enabled = false;
                        Receive.Enabled = false;
                        ST_ENSIONA.Enabled = true;
                        ST_ENSIONB.Enabled = true;
                        ST_ENSIONC.Enabled = true;
                        ST_ENSIOND.Enabled = true;
                        ST_ENSIONE.Enabled = true;
                        SU_DEVCODE.Enabled = false;
                        Return.Enabled = true;
                        Scrap.Enabled = true;
                    }
                    break;
                default:
                    break;
            }
        }

        private void SU_DEVCODE_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            {
                DataTable dt = (DataTable)dh.ExecuteSql("select st_usestatus,st_table from stencil where st_code='" + SU_DEVCODE.Text + "' and st_statuscode='AUDITED' and st_kind = '刮刀' ", "select");
                if (dt.Rows.Count == 0)
                {
                    MessageBox.Show("刮刀编号" + SU_DEVCODE.Text + "不存在或者未审核");
                }
                if (dt.Rows.Count > 0)
                {
                    for (int i = 0; i < st_table.Items.Count; i++)
                    {
                        if (st_table.Items[i].ToString() == dt.Rows[0]["st_table"].ToString())
                        {
                            st_table.SelectedItem = st_table.Items[i];
                        }
                    }
                    Receive.Enabled = true;
                    if (dt.Rows[0]["st_usestatus"].ToString() == "报废")
                    {
                        MessageBox.Show("刮刀编号" + SU_DEVCODE.Text + "已报废");
                    }
                }
            }
        }

        private void SU_DEVCODE1_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            {
                DataTable dt = (DataTable)dh.ExecuteSql("select case when nvl(ST_COMBINENUMBER,1)=0 then 1 else nvl(ST_COMBINENUMBER,1) end from STENCIL where st_code='" + SU_DEVCODE1.Text + "' and st_statuscode='AUDITED' and st_kind = '刮刀'", "select");
                //if (dt.Rows.Count > 0)
                //{
                //    try
                //    {
                //        st_combinenumber.Text = (Math.Ceiling(decimal.Parse(ma_qty.Text) / decimal.Parse(dt.Rows[0][0].ToString()))).ToString();
                //    }
                //    catch (Exception)
                //    {

                //    }
                //}
                //else
                //{
                //    MessageBox.Show("钢网编号" + SU_DEVCODE1.Text + "不存在或者未审核");
                //}


                dt = (DataTable)dh.ExecuteSql("select nvl(st_usecount,0)st_usecount,case when nvl(ST_COMBINENUMBER,1)=0 then 1 else nvl(ST_COMBINENUMBER,1) end from STENCIL where st_code='" + SU_DEVCODE1.Text + "' and st_statuscode='AUDITED' and st_kind = '刮刀'", "select");
                if (dt.Rows.Count == 0)
                {
                    MessageBox.Show("刮刀编号" + SU_DEVCODE1.Text + "不存在或者未审核");
                }
                else
                {
                    st_usecount.Text = dt.Rows[0]["st_usecount"].ToString();
                    if (int.Parse(st_usecount.Text) > 0)
                    {
                        ifUsed = true;
                    }
                    else
                    {
                        ifUsed = false;
                    }
                }

            }
        }


        //默认范围39-55，如不在范围内则可以报废
        private void ST_ENSION_TextChanged(object sender, EventArgs e)
        {
            //double Range = 0;
            //List<string> Num = new List<string>();
            //Num.Add(ST_ENSIONA.Text);
            //Num.Add(ST_ENSIONB.Text);
            //Num.Add(ST_ENSIONC.Text);
            //Num.Add(ST_ENSIOND.Text);
            //Num.Add(ST_ENSIONE.Text);
            //int CheckCount = 0;
            //int FillCount = 0;
            //foreach (string item in Num)
            //{
            //    if (item != "")
            //    {
            //        FillCount = FillCount + 1;
            //        if (double.TryParse(item, out Range))
            //        {
            //            //如果使用过张力范围39-55，使用过30-55
            //            if (ifUsed)
            //            {
            //                if (Range > 30 && Range <= 50)
            //                {
            //                    CheckCount = CheckCount + 1;
            //                }
            //            }
            //            else
            //            {
            //                if (Range > 30 && Range <= 50)
            //                {
            //                    CheckCount = CheckCount + 1;
            //                }
            //            }
            //        }
            //    }
            //}
            //if (FillCount == 5)
            //{
            //    if (CheckCount == 5)
            //    {
            //        Return.Enabled = true;
            //        Scrap.Enabled = false;
            //    }
            //    else
            //    {
            //        Return.Enabled = false;
            //        Scrap.Enabled = true;
            //    }
            //}
        }



        Make_StencilScrapReason form;
        private void Scrap_Click(object sender, EventArgs e)
        {
            DataTable dt = (DataTable)dh.ExecuteSql("select st_usestatus,st_status from stencil where st_code='" + SU_DEVCODE1.Text + "' and st_statuscode='AUDITED' and st_kind = '刮刀'", "select");
            if (dt.Rows.Count > 0)
            {
                if (dt.Rows[0]["st_usestatus"].ToString() == "报废")
                {
                    MessageBox.Show("刮刀" + SU_DEVCODE1.Text + "已处于报废状态");
                    return;
                }
                if (dt.Rows[0]["st_usestatus"].ToString() != "在仓")
                {
                    MessageBox.Show("报废刮刀必须" + SU_DEVCODE1.Text + "处于在仓状态");
                    return;
                }
                string closetab_confirm = MessageBox.Show(this.ParentForm, "报废后不可撤销，是否确认报废", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question).ToString();
                if (closetab_confirm != "Yes")
                {
                    return;
                }
                form = new Make_StencilScrapReason();
                BaseUtil.SetFormCenter(form);
                form.Controls["ConfirmScrap"].Click += Make_SMTStencil_Click;
                form.ShowDialog();
            }
            else
            {
                MessageBox.Show("刮刀编号" + SU_DEVCODE1.Text + "不存在或者未审核");
            }
        }

        private void Make_SMTStencil_Click(object sender, EventArgs e)
        {
            string Code = "";
            string scrapreason = form.Controls["Reason"].Text;
            if (scrapreason == "")
            {
                MessageBox.Show("报废原因不能为空");
                return;
            }
            sql.Clear();
            sql.Append("update StencilUse set SU_IFSCRAPOLD=-1,SU_STATUS='报废',SU_ENSIONA='" + ST_ENSIONA.Text + "',SU_ENSIONB='" + ST_ENSIONB.Text + "',SU_ENSIONC='" + ST_ENSIONC.Text + "',SU_ENSIOND='" + ST_ENSIOND.Text + "',SU_ENSIONE='" + ST_ENSIONE.Text + "'");
            sql.Append(",SU_RETURNIFCLEAN='" + (SU_RETURNIFCLEAN.Checked ? "-1" : "0") + "' where su_id=(select max(su_id) from stenciluse where su_stcode='" + SU_DEVCODE1.Text + "')");
            dh.ExecuteSql(sql.ToString(), "update");
            sql.Clear();
            sql.Append("update Stencil set ST_SCRAPREASON='" + scrapreason + "',ST_SCRAPMANCODE='" + User.UserCode + "',st_scrapman='" + User.UserName + "',st_scrapdate=sysdate,ST_USESTATUS='报废',ST_ENSIONA='" + ST_ENSIONA.Text + "',ST_ENSIONB='" + ST_ENSIONB.Text + "',");
            sql.Append("ST_ENSIONC='" + ST_ENSIONC.Text + "',ST_ENSIOND='" + ST_ENSIOND.Text + "',ST_ENSIONE='" + ST_ENSIONE.Text + "' ");
            sql.Append("where st_code='" + SU_DEVCODE1.Text + "'");
            dh.ExecuteSql(sql.ToString(), "insert");
            ////推送人员信息
            //string[] emid = dh.GetConfig("sendEmp", "Stencil").ToString().Replace("\n", "#").Split('#');
            //for (int i = 0; i < emid.Length; i++)
            //{
            //    string em_name = dh.getFieldDataByCondition("employee", "em_name", "em_id='" + emid[i] + "'").ToString();
            //   // LogicHandler.SendMessage(emid[i], em_name, "钢网" + SU_DEVCODE1.Text + "已报废" + ",原因" + scrapreason + ",人员" + User.UserName);
            //}
            form.Close();
            SU_DEVCODE1.Text = "";
            ST_ENSIONA.Text = "";
            ST_ENSIONB.Text = "";
            ST_ENSIONC.Text = "";
            ST_ENSIOND.Text = "";
            ST_ENSIONE.Text = "";
            SU_RETURNIFCLEAN.Checked = false;
            Scrap.Enabled = false;
            MessageBox.Show("报废成功！");
        }

        private void ma_code_TextKeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            {
                Confirm.PerformClick();
            }
        }

        private void Scrap_Click_1(object sender, EventArgs e)
        {

        }

        private void normalButton1_Click(object sender, EventArgs e)
        {
            if (string.IsNullOrEmpty(cleanEmpVal.Text))
            {
                MessageBox.Show("请填写清洗人员");
                return;
            }
            if (string.IsNullOrEmpty(cleanCodeVal.Text))
            {
                MessageBox.Show("请扫描刮刀编号");
                return;
            }
            DataTable dt = (DataTable)dh.ExecuteSql("select ST_USESTATUS,St_USECOUNT from Stencil where st_code='" + cleanCodeVal.Text + "' and st_statuscode='AUDITED' and st_kind = '刮刀'", "select");
            if (dt.Rows.Count > 0)
            {
                string status = dt.Rows[0]["ST_USESTATUS"].ToString();
                if (status == "在仓" || status == "借出")
                {
                    MessageBox.Show("当前刮刀" + cleanCodeVal.Text + "未在线,无法操作");
                    return;
                }
                if (status == "报废")
                {
                    MessageBox.Show("当前刮刀" + cleanCodeVal.Text + "处于" + status + "状态,无法操作");
                    return;
                }
            }
            else
            {
                MessageBox.Show("刮刀编号" + cleanCodeVal.Text + "不存在或者未审核");
                return;
            }
            sql.Clear();
            sql.Append("select nvl(su_cleannums,0)+1 su_cleannums from StencilUse nvl where su_id = (select max(su_id) from stenciluse where su_stcode='" + cleanCodeVal.Text + "')");
            dt = (DataTable)dh.ExecuteSql(sql.ToString(), "select");
            string su_cleannums = dt.Rows[0]["su_cleannums"].ToString();

            sql.Clear();
            sql.Append($@"INSERT INTO stenciluse (su_id,su_stid,su_stcode,su_indate,su_useman,su_status,
                su_returnifclean,su_cleannums)
                SELECT stenciluse_seq.NEXTVAL,st_id,'{cleanCodeVal.Text.Trim()}',sysdate,'{cleanEmpVal.Text}','12小时清洗',
                '-1', '{su_cleannums}' FROM stencil WHERE st_code = '" + cleanCodeVal.Text.Trim() + "'");
            dh.ExecuteSql(sql.ToString(), "insert");

            dh.ExecuteSql($@"UPDATE stencil SET st_cleannums = nvl(st_cleannums, 0) + 1 WHERE st_code = '{cleanCodeVal.Text.Trim()}'", "update");
            /*sql.Clear();
            sql.Append("update StencilUse set  su_cleannums=nvl(su_cleannums,0)+1, su_auditdate=sysdate");
            sql.Append("  where su_id=(select max(su_id) from stenciluse where su_stcode='" + SU_DEVCODE1.Text + "' and su_status='在线')");
            dh.ExecuteSql(sql.ToString(), "update");*/
            MessageBox.Show("刮刀" + cleanCodeVal.Text + "12小时清洗成功！");
            cleanCodeVal.Text = "";
            //cleanEmpVal.Text = "";

            /*SU_DEVCODE1.Text = "";
            st_combinenumber.Text = "";
            em_code1.Text = "";
            ST_ENSIONA.Text = "";
            ST_ENSIONB.Text = "";
            ST_ENSIONC.Text = "";
            ST_ENSIOND.Text = "";
            ST_ENSIONE.Text = "";
            Confirm.PerformClick();*/
        }

        private void Confrim_Click(object sender, EventArgs e)
        {
            if (string.IsNullOrEmpty(qaConfrimVal.Text))
            {
                MessageBox.Show("请填写品质确认人员");
                return;
            }
            if (string.IsNullOrEmpty(qaConfrimCodeVal.Text))
            {
                MessageBox.Show("请扫描确认刮刀编号");
                return;
            }
            DataTable dt = (DataTable)dh.ExecuteSql($"SELECT * FROM stenciluse WHERE su_stcode = '{qaConfrimCodeVal.Text}' AND su_status = '12小时清洗'", "select");
            if (dt.Rows.Count == 0)
            {
                MessageBox.Show("刮刀:" + qaConfrimCodeVal.Text + "没有清洗记录");
                return;
            }

            dt = (DataTable)dh.ExecuteSql("select ST_USESTATUS,St_USECOUNT from Stencil where st_code='" + qaConfrimCodeVal.Text + "' and st_statuscode='AUDITED' and st_kind = '刮刀'", "select");
            if (dt.Rows.Count > 0)
            {
                string status = dt.Rows[0]["ST_USESTATUS"].ToString();
                if (status == "在仓" || status == "借出")
                {
                    MessageBox.Show("当前刮刀" + qaConfrimCodeVal.Text + "未在线,无法操作");
                    return;
                }
                if (status == "报废")
                {
                    MessageBox.Show("当前刮刀" + qaConfrimCodeVal.Text + "处于" + status + "状态,无法操作");
                    return;
                }
            }
            else
            {
                MessageBox.Show("刮刀编号" + qaConfrimCodeVal.Text + "不存在或者未审核");
                return;
            }

            dh.ExecuteSql($@"INSERT INTO stenciluse (su_id,su_stid,su_stcode,su_indate,su_useman,su_status)
                SELECT stenciluse_seq.NEXTVAL,st_id,'{qaConfrimCodeVal.Text.Trim()}',sysdate,'{qaConfrimVal.Text}','品质确认'
                FROM stencil WHERE st_code = '" + qaConfrimCodeVal.Text.Trim() + "'", "insert");

            MessageBox.Show("刮刀" + qaConfrimCodeVal.Text + "已确认！");
            //qaConfrimVal.Text = "";
            qaConfrimCodeVal.Text = "";
        }
    }
}