mes-client/UAS_MES_XMW/FunctionCode/Make/Make_MakeDown.cs

using HslCommunication.Profinet.Knx;
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.DataOperate;
using UAS_MES_NEW.Entity;
using UAS_MES_NEW.PublicMethod;

namespace UAS_MES_NEW.Make
{
    public partial class Make_MakeDown : Form
    {
        AutoSizeFormClass asc = new AutoSizeFormClass();

        DataTable dt;

        DataTable dt1;

        DataTable dtbar;

        LogStringBuilder sql = new LogStringBuilder();

        DataHelper dh;

        //页面Caller
        string caller;

        //事件号变量
        string _macode;

        //数量记录
        int count;

        //记录当前序列号ms_id
        string ms_id;

        DataTable Dbfind;

        public Make_MakeDown()
        {
            InitializeComponent();
            caller = "MakeDown";
            count = 0;
            _macode = "";
        }

        private void Make_MakeDown_Load(object sender, EventArgs e)
        {
            asc.controllInitializeSize(this);
            dh = SystemInf.dh;
            sn_code.Focus();
            make_count.Text = count.ToString();
            string[] param = new string[] { caller, make_count.Text, _macode };
            dh.CallProcedure("SP_GETMAXNUMBER", ref param);
            mdcode.Text = param[2];

            cr_code.FormName = Name;
            cr_code.TableName = "craft";
            cr_code.SelectField = "cr_name # 工艺名称,cr_code # 工艺编号,cr_prodcode # 物料编号";
            cr_code.SetValueField = new string[] { "cr_code" };
            cr_code.DBTitle = "工艺";
            cr_code.DbChange += Cr_code_DbChange;

            cd_stepcode.FormName = Name;
            cd_stepcode.TableName = "craftdetail left join step on st_code=cd_stepcode left join craft on cd_crid=cr_id";
            cd_stepcode.SetValueField = new string[] { "cd_stepcode" };
            cd_stepcode.SelectField = "cd_stepname # 工序名称 ,cd_stepcode # 工序编号,cd_stepno # 执行顺序";
            cd_stepcode.DBTitle = "拦截工序";
            cd_stepcode.DbChange += Cd_stepcode_DbChange;
        }

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

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

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

        private void sn_code_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            {
                if (inputreson.Text.Trim() != "")
                {
                    sql.Clear();
                    sql.Append("select max(ms_id) from makeserial where ms_sncode='" + sn_code.Text + "' or ms_imei1='" + sn_code.Text + "' or ms_imei2='" + sn_code.Text + "' or ms_imei3='" + md_sncode.HeaderText + "'");
                    dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
                    ms_id = dt.Rows[0][0].ToString();
                    if (ms_id != "")
                    {
                        //界面赋值
                        dtbar = (DataTable)dh.ExecuteSql("select ms_makecode,ms_sncode,pr_code,pr_detail from makeserial left join product on MS_PRODCODE=pr_code where ms_id='" + ms_id + "'", "select");
                        sn_code.Text = dtbar.Rows[0]["ms_sncode"].ToString();
                        BaseUtil.SetFormValue(this.Controls, dtbar);
                        sql.Clear();
                        sql.Append("select ms_outboxcode,ms_craftcode, ms_downstatus,ms_outno,nvl(ms_iostatus,0) ms_iostatus,ms_prodcode from makeserial where ms_id ='" + ms_id + "' ");
                        dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
                        string ms_downstatus = dt.Rows[0]["ms_downstatus"].ToString();
                        string ms_outboxcode = dt.Rows[0]["ms_outboxcode"].ToString();
                        string ms_prodcode = dt.Rows[0]["ms_prodcode"].ToString();
                        string ms_iostatus = dt.Rows[0]["ms_iostatus"].ToString();
                        string ms_outno = dt.Rows[0]["ms_outno"].ToString();
                        cr_code.Text = dt.Rows[0]["ms_craftcode"].ToString(); ;
                        cd_stepcode.Condition = "ST_STATUSCODE='AUDITED' and cr_code='" + cr_code.Text + "' and cr_prodcode='" + ms_prodcode + "' order by cd_stepno";

                        if (ms_downstatus == "0")
                        {
                            if (ms_outno == "" && ms_iostatus == "0")
                            {
                                if (ms_outboxcode == null || ms_outboxcode == "")
                                {
                                    //进行下地操作，插入下地记录
                                    sql.Clear();
                                    sql.Append("INSERT INTO MAKEDOWN (MD_ID,MD_LINECODE,MD_SCCODE,MD_STEPCODE,");
                                    sql.Append("MD_SNCODE,MD_PRODCODE,MD_MACODE, MD_DOWNREASON, MD_CODE,");
                                    sql.Append("MD_DOWNDATE,MD_DOWNMAN,MD_STATUS) values (MAKEDOWN_seq.nextval,'" + User.UserLineCode + "','" + User.UserSourceCode + "',");
                                    sql.Append("'" + User.CurrentStepCode + "','" + sn_code.Text + "','" + pr_code.Text + "','" + ms_makecode.Text + "','" + inputreson.Text + "','" + mdcode.Text + "',sysdate,'" + User.UserCode + "','-1')");
                                    //执行
                                    dh.ExecuteSql(sql.GetString(), "insert");
                                    //更新序列号状态为下地
                                    dh.UpdateByCondition("makeserial", "ms_downstatus='-1'", "ms_id='" + ms_id + "'");
                                    OperateResult.AppendText(">>>序列号" + sn_code.Text + "下地成功\n", Color.Green);
                                    cd_stepcode.Enabled = true;
                                    //更新数量
                                    LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, ms_makecode.Text, User.UserLineCode, User.UserSourceCode, "下地操作", "序列号" + sn_code.Text + "下地成功", sn_code.Text, "");
                                    count++;
                                    make_count.Text = count + "";
                                    sn_code.Text = "";
                                    loadGrid();
                                }
                                else
                                {
                                    OperateResult.AppendText(">>>序列号" + sn_code.Text + "已装箱:" + ms_outboxcode + ",不允许下地，如需下地请先解除装箱\n", Color.Red, sn_code);
                                    sn_code.Focus();
                                    return;
                                }
                            }
                            else
                            {
                                OperateResult.AppendText(">>>序列号" + sn_code.Text + "已进行出入库操作，不允许下地\n", Color.Red, sn_code);
                                sn_code.Focus();
                                return;
                            }
                        }
                        else
                        {
                            OperateResult.AppendText(">>>序列号" + sn_code.Text + "目前已经是下地状态，无需重复下地\n", Color.Red, sn_code);
                            sn_code.Focus();
                            return;
                        }

                    }
                    else
                    {
                        ms_id = null;
                        OperateResult.AppendText(">>>序列号" + sn_code.Text + "不存在\n", Color.Red, sn_code);
                        sn_code.Focus();
                    }
                }
                else
                {
                    OperateResult.AppendText(">>>序列号" + sn_code.Text + "未输入下地原因\n", Color.Red, sn_code);
                    sn_code.Focus();
                    return;
                }
            }
        }

        private void loadGrid()
        {
            sql.Clear();
            sql.Append("select md_macode,md_sncode,md_prodcode,pr_detail from makedown left join product on pr_code = md_prodcode where md_code = '" + mdcode.Text + "'");
            dt1 = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
            BaseUtil.FillDgvWithDataTable(LabelDataGridView, dt1);
        }

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

        private void cd_stepcode_UserControlTextChanged(object sender, EventArgs e)
        {
            dh.ExecuteSql("update makedown set md_stopstepcode='" + cd_stepcode.Text + "' where MD_CODE='" + mdcode.Text + "'", "update");
            OperateResult.AppendText(">>>设置拦截工序成功\n", Color.Green);
        }
    }
}