mes-client/UAS-MES/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;
using UAS_MES.DataOperate;
using UAS_MES.Entity;
using UAS_MES.PublicMethod;

namespace UAS_MES.Make
{
    public partial class Make_SMTStencil : Form
    {

        DataTable Dbfind;

        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_ENSIONA.Enabled = false;
            ST_ENSIONB.Enabled = false;
            ST_ENSIONC.Enabled = false;
            ST_ENSIOND.Enabled = false;
            ST_ENSIONE.Enabled = false;
            st_table.Enabled = false;
            su_singlepringqty1.Enabled = false;
            Receive.Enabled = false;
            Return.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.Condition = "ma_statuscode='STARTED'";
            ma_code.DbChange += Ma_code_DbChange;

            li_code.TableName = "Line";
            li_code.SelectField = "li_code # 线别编号,li_name # 线别名称";
            li_code.FormName = Name;
            li_code.SetValueField = new string[] { "li_code", "li_name" };
            li_code.DbChange += Li_code_DbChange;
        }

        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 = (DataTable)dh.ExecuteSql("select ST_USESTATUS from Stencil where st_code='" + SU_DEVCODE.Text + "'", "select");
            if (dt.Rows.Count > 0)
            {
                string status = dt.Rows[0]["ST_USESTATUS"].ToString();
                if (status == "借出" || status == "报废")
                {
                    MessageBox.Show("当前钢网" + SU_DEVCODE.Text + "处于" + status + "状态,无法再次领用");
                    return;
                }
            }
            else
            {
                MessageBox.Show("钢网编号" + SU_DEVCODE.Text + "不存在");
            }
            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;
            }
            sql.Clear();
            sql.Append("insert into StencilUse(su_id,SU_USEPRODCODE,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_id,'" + li_code.Text + "','" + SU_DEVCODE.Text + "',sysdate,'" + User.UserName + "','" + User.UserCode + "','" + 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");
            dh.ExecuteSql("update Stencil set ST_USESTATUS='借出' where st_code='" + SU_DEVCODE.Text + "'", "update");
            MessageBox.Show("领用成功");
            st_table.SelectedItem = null;
            SU_DEVCODE.Text = "";
            Receive.Enabled = false;
            LoadGridData();
        }

        private void Return_Click(object sender, EventArgs e)
        {
            if (ST_ENSIONA.Text != "" && ST_ENSIONB.Text != "" && ST_ENSIONC.Text != "" && ST_ENSIOND.Text != "" && ST_ENSIONE.Text != "")
            {
                if (SU_RETURNIFCLEAN.Checked)
                {
                    DataTable dt = (DataTable)dh.ExecuteSql("select ST_USESTATUS,St_USECOUNT from Stencil where st_code='" + SU_DEVCODE1.Text + "'", "select");
                    if (dt.Rows.Count > 0)
                    {
                        string status = dt.Rows[0]["ST_USESTATUS"].ToString();
                        if (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();
                    sql.Clear();
                    sql.Append("update StencilUse set SU_BACKDATE=sysdate,SU_ENSIONA='" + ST_ENSIONA.Text + "',SU_ENSIONB='" + ST_ENSIONB.Text + "',SU_ENSIONC='" + ST_ENSIONC.Text + "',SU_ENSIOND='" + ST_ENSIOND.Text + "',");
                    sql.Append("SU_ENSIONE='" + ST_ENSIONE.Text + "',SU_THISUSETIMES='" + 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 + "')");
                    dh.ExecuteSql(sql.ToString(), "update");
                    sql.Clear();
                    sql.Append("update Stencil set St_USECOUNT=nvl(St_USECOUNT,0)+" + st_combinenumber.Text + ",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(), "update");
                    MessageBox.Show("钢网" + SU_DEVCODE1.Text + "退回成功！");
                    SU_DEVCODE1.Text = "";
                    st_combinenumber.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("请确认是否清洗钢网");
                }
            }
            else
            {
                MessageBox.Show("请维护完成的测试参数");
            }
        }

        Make_StencilScrapReason form;
        private void Scrap_Click(object sender, EventArgs e)
        {
            DataTable dt = (DataTable)dh.ExecuteSql("select st_usestatus from stencil where st_code='" + SU_DEVCODE1.Text + "'", "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();
            }
        }

        private void Make_SMTStencil_Click(object sender, EventArgs e)
        {
            string Code = "";
            string scrapreason = form.Controls["Reason"].Text;
            if (scrapreason == "")
            {
                MessageBox.Show("报废原因不能为空");
                return;
            }
            DataTable dt = (DataTable)dh.ExecuteSql("select St_USECOUNT from stencil where st_code='" + SU_DEVCODE1.Text + "'", "select");
            string St_USECOUNT = dt.Rows[0]["St_USECOUNT"].ToString();
            sql.Clear();
            sql.Append("update StencilUse set SU_IFSCRAPOLD=-1,SU_THISUSETIMES='" + 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 + "')");
            dh.ExecuteSql(sql.ToString(), "update");
            sql.Clear();
            sql.Append("update STENCIL set ST_SCRAPREASON='" + scrapreason + "',ST_USESTATUS='报废' 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 + "已报废");
            }
            form.Close();
            Scrap.Enabled = false;
        }

        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;
                        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;
                        ST_ENSIONA.Enabled = true;
                        ST_ENSIONB.Enabled = true;
                        ST_ENSIONC.Enabled = true;
                        ST_ENSIOND.Enabled = true;
                        ST_ENSIONE.Enabled = true;
                        SU_DEVCODE.Enabled = false;
                        st_table.Enabled = false;
                        su_singlepringqty1.Enabled = false;
                        Receive.Enabled = false;
                        Receive.Enabled = false;
                    }
                    break;
                default:
                    break;
            }
        }

        //默认范围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))
                    {
                        if (Range >= 39 && Range <= 55)
                        {
                            CheckCount = CheckCount + 1;
                        }
                    }
                }
            }
            if (FillCount == 5)
            {
                if (CheckCount == 5)
                {
                    Return.Enabled = true;
                    Scrap.Enabled = false;
                }
                else
                {
                    Return.Enabled = false;
                    Scrap.Enabled = true;
                }
            }
        }

        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 + "'", "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 + "'", "select");
                if (dt.Rows.Count > 0)
                {
                    st_combinenumber.Text = (int.Parse(ma_qty.Text) / int.Parse(dt.Rows[0][0].ToString())).ToString();
                }
                else
                {
                    MessageBox.Show("钢网编号" + SU_DEVCODE1.Text + "不存在");
                }
            }
        }

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