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_table.Enabled = false;
            su_singlepringqty1.Enabled = false;
            Receive.Enabled = false;
            Return.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;
        }

        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,st_version from Stencil where st_code='" + SU_DEVCODE.Text + "' and st_statuscode='AUDITED'", "select");
            string status = "";
            string version = "";
            if (dt.Rows.Count > 0)
            {
                status = dt.Rows[0]["ST_USESTATUS"].ToString();
                version = dt.Rows[0]["st_version"].ToString();
                if (status == "在线" || 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;
            }
            //一条线只能在线一个钢网
            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
            {
                dt = (DataTable)dh.ExecuteSql("select em_name from employee where em_code='" + em_code.Text + "'", "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_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,'" + 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");
                    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("人员编号" + em_code.Text + "不存在");
                }
            }
        }

        private void Return_Click(object sender, EventArgs e)
        {
            if (SU_RETURNIFCLEAN.Checked)
            {
                DataTable dt = (DataTable)dh.ExecuteSql("select 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();
                    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();
                dt = (DataTable)dh.ExecuteSql("select em_name from employee where em_code='" + em_code1.Text + "'", "select");
                if (dt.Rows.Count > 0)
                {
                    sql.Clear();
                    sql.Append("update StencilUse set SU_BACKDATE=sysdate,su_returnmancode='" + em_code1.Text + "',");
                    sql.Append("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 + "' and su_status='在线')");
                    dh.ExecuteSql(sql.ToString(), "update");
                    sql.Clear();
                    sql.Append("update Stencil set St_USECOUNT=nvl(St_USECOUNT,0)+" + st_combinenumber.Text + ",ST_USESTATUS='借出' 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;
                    Confirm.PerformClick();
                }
                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)
            {
                DataTable dt = (DataTable)dh.ExecuteSql("select 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)
                {
                    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'", "select");
                if (dt.Rows.Count > 0)
                {
                    try
                    {
                        st_combinenumber.Text = (int.Parse(ma_qty.Text) / int.Parse(dt.Rows[0][0].ToString())).ToString();
                    }
                    catch (Exception)
                    {

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

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