mes-client/UAS_MES_JH/FunctionCode/Special/Special_Oksn.cs

using System;
using System.Collections.Generic;
using System.Data;
using System.Drawing;
using System.Windows.Forms;
using UAS_MES_NEW.DataOperate;
using UAS_MES_NEW.Entity;
using UAS_MES_NEW.PublicMethod;

namespace UAS_MES_NEW.Special
{
    public partial class Special_Oksn : Form
    {

        DataHelper dh;

        LogStringBuilder sql = new LogStringBuilder();
        AutoSizeFormClass asc = new AutoSizeFormClass();

        DataTable Dbfind;
        public Special_Oksn()
        {
            InitializeComponent();
        }

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

        private void Clean_Click(object sender, EventArgs e)
        {
            OperateResult.Clear();
        }

        private void Special_CancelCollection_Load(object sender, EventArgs e)
        {
            dh = SystemInf.dh;
            // asc.controllInitializeSize(this);
            ma_code.TableName = "make left join product on ma_prodcode=pr_code";
            ma_code.SelectField = "ma_code # 工单号,ma_prodcode # 产品编号,ma_qty # 工单数量, pr_orispeccode # 型号, ma_wccode # 车间,ma_inqty # 投入数,pr_spec # 产品规格";
            ma_code.FormName = Name;
            ma_code.SetValueField = new string[] { "ma_code", "ma_prodcode", "ma_qty", "pr_orispeccode" };
            ma_code.Condition = "ma_statuscode='STARTED' order by ma_auditdate desc";
            ma_code.DbChange += Ma_code_DbChange;
            ma_code.SetLockCheckBox(Lock);
            Lock.GetMakeCodeCtl(ma_code);
        }


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

            getqty.Text =  dh.getFieldDataByCondition("makeserial", "count(1) cn ", "MS_LASTSTEP is not null and ms_makecode = '"+ma_code.Text+"' ").ToString();

        }



        private void sn_code_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            {
                if (!checkBox1.Checked)
                {
                    //获取序列号的途程
                    DataTable dt = (DataTable)dh.ExecuteSql("select ms_id,ms_nextstepcode,ms_outboxcode,ms_makecode,ms_status,ms_laststep,ms_craftcode,ms_prodcode,ms_stepcode from makeserial where ms_sncode='" + sn_code.Text + "' and ms_makecode = '"+ma_code.Text+"' order by ms_id desc", "select");
                    if (dt.Rows.Count > 0)
                    {
                        string pr_code = dt.Rows[0]["ms_prodcode"].ToString();
                        string cr_code = dt.Rows[0]["ms_craftcode"].ToString();
                        string ms_nextstepcode = dt.Rows[0]["ms_nextstepcode"].ToString();
                        string ms_makecode = dt.Rows[0]["ms_makecode"].ToString();
                        string ms_stepcode = dt.Rows[0]["ms_stepcode"].ToString();
                        string ms_laststep = dt.Rows[0]["ms_laststep"].ToString();
                        string ms_status = dt.Rows[0]["ms_status"].ToString();
                        string ms_outboxcode = dt.Rows[0]["ms_outboxcode"].ToString();
                        string ms_id = dt.Rows[0]["ms_id"].ToString();
                        if (ms_nextstepcode == "")
                        {
                            OperateResult.AppendText(">>序列号" + sn_code.Text + "非在制状态，无法采集\n", Color.Red, sn_code);
                            return;
                        }
                        if (ms_outboxcode != "")
                        {
                            OperateResult.AppendText(">>序列号" + sn_code.Text + "已装箱"+ms_outboxcode+"，无法采集\n", Color.Red, sn_code);
                            return;
                        }
                        //if (dh.CheckExist("step", "st_code = '" + ms_nextstepcode + "' and nvl(st_ifoqc,0) <> -1 and nvl(st_ifover,0) = -1 "))
                        //{
                        //    //if (dh.CheckExist("makedown", "md_msid = " + ms_id + " and md_status = 0"))
                        //    //{
                        //    //    OperateResult.AppendText(">>序列号" + sn_code.Text + "被锁定，无法采集\n", Color.Red, sn_code);
                        //    //    return;
                        //    //}
                            dh.ExecuteSql("update makeserial set ms_status = 2,ms_laststep = ms_nextstepcode,ms_nextstepcode = '' where ms_id = " + ms_id + " ", "update");
                            LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, ms_makecode, User.UserLineCode, User.UserSourceCode, "完工采集", "完工采集成功", sn_code.Text, "");
                            OperateResult.AppendText(">>序列号" + sn_code.Text + "采集成完工\n", Color.Green, sn_code);
                            getqty.Text = dh.getFieldDataByCondition("makeserial", "count(1) cn ", "MS_LASTSTEP is not null and ms_makecode = '" + ma_code.Text + "' ").ToString();
                        //}
                        //else
                        //{
                        //    OperateResult.AppendText(">>序列号" + sn_code.Text + "所处工序" + ms_nextstepcode + "，无法采集\n", Color.Red, sn_code);
                        //    return;
                        //}

                    }
                    else OperateResult.AppendText(">>序列号" + sn_code.Text + "不存在\n", Color.Red, sn_code);
                }
                else
                {
                    //获取序列号的途程
                    DataTable dt = (DataTable)dh.ExecuteSql("select ms_id,ms_nextstepcode,ms_currentstepcode,ms_makecode,ms_status,ms_laststep,ms_craftcode,ms_prodcode,ms_stepcode from makeserial where ms_sncode='" + sn_code.Text + "' and ms_makecode = '"+ma_code.Text+"' order by ms_id desc", "select");
                    if (dt.Rows.Count > 0)
                    {
                        string pr_code = dt.Rows[0]["ms_prodcode"].ToString();
                        string cr_code = dt.Rows[0]["ms_craftcode"].ToString();
                        string ms_nextstepcode = dt.Rows[0]["ms_nextstepcode"].ToString();
                        string ms_makecode = dt.Rows[0]["ms_makecode"].ToString();
                        string ms_stepcode = dt.Rows[0]["ms_stepcode"].ToString();
                        string ms_laststep = dt.Rows[0]["ms_laststep"].ToString();
                        string ms_status = dt.Rows[0]["ms_status"].ToString();
                        string ms_currentstepcode = dt.Rows[0]["ms_currentstepcode"].ToString();
                        string ms_id = dt.Rows[0]["ms_id"].ToString();
                        if (ms_status != "2")
                        {
                            OperateResult.AppendText(">>序列号" + sn_code.Text + "非完工，无法撤销\n", Color.Red, sn_code);
                            return;
                        }
                        if (ms_laststep == "")
                        {

                            OperateResult.AppendText(">>序列号" + sn_code.Text + "未采集过，无法撤销\n", Color.Red, sn_code);
                            return;
                        }
                        dh.ExecuteSql("update makeserial set ms_status = 1,ms_nextstepcode = ms_laststep,ms_laststep = '' where ms_id = " + ms_id + "", "update");
                        LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, ms_makecode, User.UserLineCode, User.UserSourceCode, "撤销完工采集", "撤销完工采集成功", sn_code.Text, "");
                        OperateResult.AppendText(">>序列号" + sn_code.Text + "撤销完工\n", Color.Green, sn_code);
                        getqty.Text = dh.getFieldDataByCondition("makeserial", "count(1) cn ", "MS_LASTSTEP is not null and ms_makecode = '" + ma_code.Text + "' ").ToString();
                    }
                    else OperateResult.AppendText(">>序列号" + sn_code.Text + "不存在\n", Color.Red, sn_code);
                }
            }
        }

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

        private void boxcode_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            {
                if (!checkBox2.Checked)
                {
                    //获取序列号的途程
                    DataTable dt = (DataTable)dh.ExecuteSql("select ms_id,ms_nextstepcode,ms_outboxcode,ms_makecode,ms_status,ms_laststep,ms_craftcode,ms_prodcode,ms_stepcode from makeserial where ms_outboxcode='" + boxcode.Text + "' order by ms_id desc", "select");
                    if (dt.Rows.Count > 0)
                    {
                        string pr_code = dt.Rows[0]["ms_prodcode"].ToString();
                        string cr_code = dt.Rows[0]["ms_craftcode"].ToString();
                        string ms_nextstepcode = dt.Rows[0]["ms_nextstepcode"].ToString();
                        string ms_makecode = dt.Rows[0]["ms_makecode"].ToString();
                        string ms_stepcode = dt.Rows[0]["ms_stepcode"].ToString();
                        string ms_laststep = dt.Rows[0]["ms_laststep"].ToString();
                        string ms_status = dt.Rows[0]["ms_status"].ToString();
                        string ms_outboxcode = dt.Rows[0]["ms_outboxcode"].ToString();
                        string ms_id = dt.Rows[0]["ms_id"].ToString();
                        if (ms_nextstepcode == "")
                        {
                            OperateResult.AppendText(">>箱号" + boxcode.Text + "非在制状态，无法采集\n", Color.Red, boxcode);
                            return;
                        }
                        if(dh.CheckExist("package","pa_outboxcode = '"+boxcode.Text+"' and pa_mothercode is not null"))
                        {
                            OperateResult.AppendText(">>箱号" + boxcode.Text + "有栈板记录，无法采集\n", Color.Red, boxcode);
                            return;
                        }
                        dh.ExecuteSql("update makeserial set ms_status = 2,ms_laststep = ms_nextstepcode,ms_nextstepcode = '' where ms_outboxcode = '" + boxcode.Text + "' ", "update");
                            LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, ms_makecode, User.UserLineCode, User.UserSourceCode, "完工采集", "完工采集成功", boxcode.Text, "");
                            OperateResult.AppendText(">>箱号" + boxcode.Text + "采集成完工\n", Color.Green, boxcode);
                            getqty.Text = dh.getFieldDataByCondition("makeserial", "count(1) cn ", "MS_LASTSTEP is not null and ms_makecode = '" + ma_code.Text + "' ").ToString();
                    }
                    else OperateResult.AppendText(">>箱号" + boxcode.Text + "不存在SN\n", Color.Red, boxcode);
                }
                else
                {
                    //获取序列号的途程
                    DataTable dt = (DataTable)dh.ExecuteSql("select ms_id,ms_nextstepcode,ms_currentstepcode,ms_makecode,ms_status,ms_laststep,ms_craftcode,ms_prodcode,ms_stepcode from makeserial where ms_outboxcode='" + boxcode.Text + "' order by ms_id desc", "select");
                    if (dt.Rows.Count > 0)
                    {
                        string pr_code = dt.Rows[0]["ms_prodcode"].ToString();
                        string cr_code = dt.Rows[0]["ms_craftcode"].ToString();
                        string ms_nextstepcode = dt.Rows[0]["ms_nextstepcode"].ToString();
                        string ms_makecode = dt.Rows[0]["ms_makecode"].ToString();
                        string ms_stepcode = dt.Rows[0]["ms_stepcode"].ToString();
                        string ms_laststep = dt.Rows[0]["ms_laststep"].ToString();
                        string ms_status = dt.Rows[0]["ms_status"].ToString();
                        string ms_currentstepcode = dt.Rows[0]["ms_currentstepcode"].ToString();
                        string ms_id = dt.Rows[0]["ms_id"].ToString();
                        if (ms_status != "2")
                        {
                            OperateResult.AppendText(">>箱号" + boxcode.Text + "非完工，无法撤销\n", Color.Red, boxcode);
                            return;
                        }
                        if (ms_laststep == "")
                        {
                            OperateResult.AppendText(">>箱号" + boxcode.Text + "未采集过，无法撤销\n", Color.Red, boxcode);
                            return;
                        }
                        dh.ExecuteSql("update makeserial set ms_status = 1,ms_nextstepcode = ms_laststep,ms_laststep = '' where ms_outboxcode = '" + boxcode.Text + "' ", "update");
                        LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, ms_makecode, User.UserLineCode, User.UserSourceCode, "撤销完工采集", "撤销完工采集成功", boxcode.Text, "");
                        OperateResult.AppendText(">>序列号" + boxcode.Text + "撤销完工\n", Color.Green, boxcode);
                        getqty.Text = dh.getFieldDataByCondition("makeserial", "count(1) cn ", "MS_LASTSTEP is not null and ms_makecode = '" + ma_code.Text + "' ").ToString();
                    }
                    else OperateResult.AppendText(">>箱号" + boxcode.Text + "不存在SN\n", Color.Red, boxcode);
                }
            }
        }
    }
}