mes-client/UAS_MES_HYSX/FunctionCode/Make/Make_SMTStencil.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_SMTStencil : Form
    {

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

        DataHelper dh = SystemInf.dh;

        StringBuilder sql = new StringBuilder();

        public Make_SMTStencil()
        {
            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_wcname = 'SMT车间' and instr(li_name,'YAMAHA') = 0 order by li_indate,li_code";
            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='在线'");
            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("工单号不能为空");
            }
            DataTable dt;

            int WaringCount = int.Parse(dh.GetConfig("WaringCount", "Stencil").ToString());
            dt = (DataTable)dh.ExecuteSql("select st_kind,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'", "select");
            string st_kind = "";
            string status = "";
            string version = "";
            int st_maxusecount = 0;
            int st_usecount = 0;
            if (dt.Rows.Count > 0)
            {
                st_kind = dt.Rows[0]["st_kind"].ToString();
                status = dt.Rows[0]["ST_USESTATUS"].ToString();
                version = dt.Rows[0]["st_version"].ToString();
                st_maxusecount = int.Parse(dt.Rows[0]["st_maxusecount"].ToString());
                st_usecount = int.Parse(dt.Rows[0]["st_usecount"].ToString());
                if (status == "在线" || status == "报废"/* || status == "在仓"*/)
                {
                    MessageBox.Show("当前" + st_kind + 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;
                }
            }
            if (st_kind == "钢网")
            {
                //限制钢网使用的产品
                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)
                {
                    dt = (DataTable)dh.ExecuteSql("select 1 from makematerial where mm_code='" + ma_code.Text + "' and mm_prodcode in (select SP_PRODCODE from " +
                        "STENILCANUSEPRO where SP_STCODE='" + SU_DEVCODE.Text + "')", "select");
                    if (dt.Rows.Count == 0)
                    {
                        MessageBox.Show("钢网编号" + SU_DEVCODE.Text + "不能在产品" + ma_prodcode.Text + "中使用");
                        return;
                    }
                }
            }
            dt = (DataTable)dh.ExecuteSql("select em_name from employee where em_code='" + em_code.Text + "'", "select");
            if (dt.Rows.Count > 0)
            {
                if (int.Parse(su_singlepringqty1.Text) > 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)");
                    sql.Append("select StencilUse_seq.nextval,'" + ma_prodcode.Text + "',ST_CLEANNUMS,st_id,'" + li_code.Text + "','" + SU_DEVCODE.Text + "',sysdate,'" + em_name + "','" + em_code.Text + "','" + st_table.Text + "','" + ma_code.Text + "'");
                    sql.Append(",'" + su_singlepringqty1.Text + "',st_version,'在线' from ");
                    sql.Append("Stencil where st_code='" + SU_DEVCODE.Text + "'");
                    dh.ExecuteSql(sql.ToString(), "insert");
                    dt = (DataTable)dh.ExecuteSql("select ST_USESTATUS,St_USECOUNT from Stencil where st_code='" + SU_DEVCODE.Text + "' and st_statuscode='AUDITED'", "select");
                    string St_USECOUNT = dt.Rows[0]["St_USECOUNT"].ToString();
                    dt = (DataTable)dh.ExecuteSql("select em_name from employee where em_code='" + em_code.Text + "'", "select");
                    if (dt.Rows.Count > 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 + "' ");
                        sql.Append("where su_id=(select max(su_id) from stenciluse where su_stcode='" + SU_DEVCODE.Text + "' and su_status='在线')");
                        dh.ExecuteSql(sql.ToString(), "update");
                    }
                    dh.ExecuteSql("update Stencil set ST_USESTATUS='在线' where st_code='" + SU_DEVCODE.Text + "'", "update");
                    MessageBox.Show("领用成功");
                    st_table.SelectedItem = null;
                    SU_DEVCODE.Text = "";
                    em_code.Text = "";
                    Receive.Enabled = false;
                    LoadGridData();

                }
                else
                {
                    MessageBox.Show("单片印刷次数必须大于0");
                }
            }
            else
            {
                MessageBox.Show("人员编号" + em_code.Text + "不存在");
            }
        }

        private void Return_Click(object sender, EventArgs e)
        {
            if (string.IsNullOrEmpty(st_combinenumber.Text))
            {
                MessageBox.Show("请维护印刷次数");
                return;
            }
            if (CheckTension()) return;
            if (SU_RETURNIFCLEAN.Checked)
            {
                DataTable dt = (DataTable)dh.ExecuteSql("select st_kind,ST_USESTATUS,St_USECOUNT from Stencil where st_code='" + SU_DEVCODE1.Text + "' and st_statuscode='AUDITED'", "select");
                if (dt.Rows.Count > 0)
                {
                    string status = dt.Rows[0]["ST_USESTATUS"].ToString();
                    string st_kind = dt.Rows[0]["st_kind"].ToString();
                    if (status == "在仓" || status == "在仓")
                    {
                        MessageBox.Show("当前" + st_kind + SU_DEVCODE.Text + "未在线,无需归还");
                        return;
                    }
                    if (status == "报废")
                    {
                        MessageBox.Show("当前" + st_kind + 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='" + em_code1.Text + "'", "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='在仓',su_usecount=" + (St_USECOUNT == "" ? "0" : St_USECOUNT) + "+" + st_combinenumber.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 + "' and su_status='在线')");
                        dh.ExecuteSql(sql.ToString(), "update");
                        sql.Clear();
                        sql.Append("update Stencil set st_cleannums=nvl(st_cleannums,0)+1,ST_USESTATUS='在仓',st_usecount=nvl(st_usecount,0)+" + (st_combinenumber.Text == "" ? "0" : st_combinenumber.Text) + " where st_code='" + SU_DEVCODE1.Text + "'");
                        dh.ExecuteSql(sql.ToString(), "update");
                        MessageBox.Show(SU_DEVCODE1.Text + "退回成功！");
                        SU_DEVCODE1.Text = "";
                        st_combinenumber.Text = "";
                        em_code1.Text = "";
                        SU_RETURNIFCLEAN.Checked = false;
                        Return.Enabled = false;
                        Confirm.PerformClick();
                    }
                    else
                    {
                        MessageBox.Show("加工小板数必须大于等于0");
                    }
                }
                else
                {
                    MessageBox.Show("人员编号" + em_code1.Text + "不存在");
                }
            }
            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;
                    }
                    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;
                    }
                    break;
                default:
                    break;
            }
        }

        private void SU_DEVCODE_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            {
                SU_DEVCODE.Text = SU_DEVCODE.Text.Replace(" ", "");
                DataTable dt = (DataTable)dh.ExecuteSql("select st_kind,st_usestatus,st_table from stencil where st_code='" + SU_DEVCODE.Text + "' and st_statuscode='AUDITED'", "select");
                if (dt.Rows.Count == 0)
                {
                    MessageBox.Show("编号" + SU_DEVCODE.Text + "不存在或者未审核");
                }
                if (dt.Rows.Count > 0)
                {
                    string st_kind = dt.Rows[0]["st_kind"].ToString();
                    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(st_kind + "编号" + SU_DEVCODE.Text + "已报废");
                    }
                }
            }
        }

        private void SU_DEVCODE1_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            {
                SU_DEVCODE1.Text = SU_DEVCODE1.Text.Replace(" ", "");
                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'", "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'", "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;
                    }
                }

            }
        }

        private bool CheckTension()
        {
            DataTable dt = (DataTable)dh.ExecuteSql($"select * from stencil where st_code = '{SU_DEVCODE1.Text.Trim()}' and st_kind = '刮刀'", "select");
            if (dt.Rows.Count > 0) return false;

            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);

            dt = (DataTable)dh.ExecuteSql($"SELECT st_tension_min min,st_tension_max max FROM stencil WHERE st_statuscode = 'AUDITED' AND st_code = '{SU_DEVCODE1.Text.Trim()}'", "select");
            if (dt.Rows.Count == 0)
            {
                MessageBox.Show("钢网编号" + SU_DEVCODE1.Text + "不存在或者未审核");
                return true;
            }
            if(string.IsNullOrEmpty(dt.Rows[0]["MIN"].ToString()) || string.IsNullOrEmpty(dt.Rows[0]["MAX"].ToString()))
            {
                MessageBox.Show($"钢网{SU_DEVCODE1.Text} 未维护张力范围");
                return true;
            }
            foreach (string item in Num)
            {
                if (string.IsNullOrEmpty(item))
                {
                    MessageBox.Show("请填写张力值");
                    return true;
                }
                if (Convert.ToInt32(item) < Convert.ToInt32(dt.Rows[0]["MIN"].ToString()))
                {
                    MessageBox.Show($"张力值: {item}小于最小张力值: {dt.Rows[0]["MIN"].ToString()}");
                    return true;
                }
                if (Convert.ToInt32(item) > Convert.ToInt32(dt.Rows[0]["MAX"].ToString()))
                {
                    MessageBox.Show($"张力值: {item}大于最大张力值: {dt.Rows[0]["MAX"].ToString()}");
                    return true;
                }
            }
            return 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 <= 55)
                            {
                                CheckCount = CheckCount + 1;
                            }
                        }
                        else
                        {
                            if (Range > 30 && Range <= 55)
                            {
                                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'", "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();
            }
        }
    }
}