mes-client/UAS_MES_JH/FunctionCode/Make/Make_GetReMakeSN.cs

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

namespace UAS_MES_NEW.Make
{
    public partial class Make_GetReMakeSN : Form
    {
        //打印进程
        ApplicationClass lbl;
        //初始化打印进程
        Thread InitPrint;

        LogStringBuilder sql = new LogStringBuilder();

        AutoSizeFormClass asc = new AutoSizeFormClass();

        DataHelper dh;

        DataTable dt;

        Document doc;

        private System.DateTime[] indate;

        string ErrMessage;

        public Make_GetReMakeSN()
        {
            InitializeComponent();
        }

        private void InPrint()
        {
            try
            {
                lbl = new ApplicationClass();
                BaseUtil.WriteLbl();
            }
            catch (Exception ex)
            {
                OperateResult.AppendText("未正确安装CodeSoft软件\n", Color.Red);
            }
        }

        private void Make_GetReMakeSN_Load(object sender, EventArgs e)
        {
            ma_code.TableName = "make left join product on ma_prodcode=pr_code";
            ma_code.SelectField = "ma_code # 工单号,pr_code # 产品编号,ma_qty # 工单数量,pr_detail # 产品名称,pr_spec # 产品规格,ma_craftcode # 途程编号";
            ma_code.FormName = Name;
            ma_code.SetValueField = new string[] { "ma_code", "pr_code", "ma_qty", "pr_detail", "pr_spec", "ma_craftcode" };
            ma_code.Condition = "ma_kind='返工' and ma_statuscode='STARTED'";
            ma_code.DbChange += Ma_code_DbChange;

            ma_code.SetLockCheckBox(LockCheckBox);
            LockCheckBox.GetMakeCodeCtl(ma_code);
            OperateResult.AppendText(">>请输入返工工单号\n", Color.Black);

            asc.controllInitializeSize(this);
            InitPrint = new Thread(InPrint);
            SetLoadingWindow stw = new SetLoadingWindow(InitPrint, "初始化打印程序");
            BaseUtil.SetFormCenter(stw);
            stw.ShowDialog();
            sn_code.Focus();
            dh = SystemInf.dh;
        }

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

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

        private void pr_code_TextChanged(object sender, EventArgs e)
        {
            DataTable _dt = (DataTable)dh.ExecuteSql("select la_id,la_url,la_isdefault from label where la_prodcode='" + pr_code.Text + "' and la_templatetype='SN标签' and la_statuscode='AUDITED' order by la_isdefault", "select");
            PrintLabel.DataSource = _dt;
            PrintLabel.DisplayMember = "la_url";
            PrintLabel.ValueMember = "la_id";
        }

        private void sn_code_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            {
                if (ma_code.Text != "")
                {
                    //判断是否是途程第一道工序
                    sql.Clear();
                    sql.Append("select cd_id from craft left join craftdetail on cd_crid=cr_id where cr_code='" + ma_craftcode.Text + "' ");
                    sql.Append("and cr_prodcode='" + pr_code.Text + "' and nvl(cd_firststep,0)<>0 and cd_stepcode='" + User.CurrentStepCode + "'");
                    dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
                    if (dt.Rows.Count > 0)
                    {
                        if (sn_code.Text != "")
                        {
                            //判断序列号是否有效
                            string Msid = dh.getFieldDataByCondition("makeserial ", "max(ms_id)", "ms_sncode='" + sn_code.Text + "' and ms_makecode<>'" + ma_code.Text + "'").ToString();
                            if (Msid != "")
                            {
                                //序列号信息
                                sql.Clear();
                                sql.Append("select ms_beforesn,ms_status,ms_makecode,ms_firstsn,ms_outboxcode,ms_nextmacode,ms_prodcode,ms_salecode,");
                                sql.Append("MS_IMEI1,MS_MAC,MS_NETCODE,MS_MEID,ms_imei2,ms_imei3,ms_othid1,ms_othid2,ms_othid3");
                                sql.Append(",MS_OTHCODE3,MS_OTHCODE2,MS_OTHCODE1,ms_bt from makeserial where ms_id='" + Msid + "'");
                                DataTable SnInf = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
                                string ms_prodcode = SnInf.Rows[0]["ms_prodcode"].ToString();
                                string ms_salecode = SnInf.Rows[0]["ms_salecode"].ToString();
                                string ms_beforesn = SnInf.Rows[0]["ms_beforesn"].ToString();
                                string ms_makecode = SnInf.Rows[0]["ms_makecode"].ToString();
                                string ms_status = SnInf.Rows[0]["ms_status"].ToString();
                                string ms_outboxcode = SnInf.Rows[0]["ms_outboxcode"].ToString();
                                //判断序列号是否已经被使用
                                if (SnInf.Rows[0]["ms_nextmacode"].ToString() != "")
                                {
                                    OperateResult.AppendText(">>序列号已经被工单号:" + SnInf.Rows[0]["ms_nextmacode"].ToString() + "使用\n", Color.Red, sn_code);
                                    return;
                                }
                                //工单信息
                                sql.Clear();
                                sql.Append("select ma_salecode,nvl(ma_checksacode,0)ma_checksacode,ma_prodcode,ma_craftname,ma_inqty,ma_craftcode,ma_qty,nvl(ma_inqty,0) ma_inqty,");
                                sql.Append("nvl(ma_scrapqty,0)ma_scrapqty,ma_id,nvl(ma_unlimitin,0) ma_unlimitin,ma_wccode,NVL(re_autodecom,0)");
                                sql.Append("re_autodecom,nvl(re_ifsnok,0)re_ifsnok,re_code from make left join rework on ma_screcode=re_code where ");
                                sql.Append("ma_code='" + ma_code.Text + "'and ma_kind='返工' and  ma_statuscode='STARTED'");
                                DataTable MaInf = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
                                string ma_prodcode = MaInf.Rows[0]["ma_prodcode"].ToString();
                                string ma_salecode = MaInf.Rows[0]["ma_salecode"].ToString();
                                string re_autodecom = MaInf.Rows[0]["re_autodecom"].ToString();
                                string re_ifsnok = MaInf.Rows[0]["re_ifsnok"].ToString();
                                string ma_checksacode = MaInf.Rows[0]["ma_checksacode"].ToString();
                                string re_code = MaInf.Rows[0]["re_code"].ToString();
                                int ma_unlimitin = int.Parse(MaInf.Rows[0]["ma_unlimitin"].ToString());
                                int ma_inqty = int.Parse(MaInf.Rows[0]["ma_inqty"].ToString());
                                int ma_scrapqty = int.Parse(MaInf.Rows[0]["ma_scrapqty"].ToString());
                                int ma_qty = int.Parse(MaInf.Rows[0]["ma_qty"].ToString());
                                if (ma_prodcode != ms_prodcode)
                                {
                                    OperateResult.AppendText(">>序列号所属产品" + ms_prodcode + "与返工工单产品不一致\n", Color.Red, sn_code);
                                    return;
                                }
                                if (ma_checksacode != "0")
                                {
                                    if (ms_salecode != "" && ma_salecode != "" && ms_salecode != ma_salecode)
                                    {
                                        OperateResult.AppendText(">>序列号所属合同" + ms_salecode + "与返工工单合同不一致\n", Color.Red, sn_code);
                                        return;
                                    }
                                }
                                if (ma_unlimitin == 0 && ma_inqty - ma_scrapqty + 1 > ma_qty)
                                {
                                    OperateResult.AppendText(">>工单不允许超数投产\n", Color.Red, sn_code);
                                    return;
                                }
                                string Sn = sn_code.Text;
                                if (re_ifsnok != "0")
                                {
                                    if (ms_status == "3" && dh.CheckExist("makebad", "mb_sncode = '" + sn_code.Text + "'and mb_makecode = '" + ms_makecode + "' and mb_status = '0'"))
                                    {
                                        OperateResult.AppendText(">>序列号:" + sn_code.Text + "处于不良状态,完成维修后才能归属至返工工单\n", Color.Red, sn_code);
                                        return;
                                    }
                                }
                                //if (ReWorkAsRelateTSN.Checked)
                                //{
                                //    if (ms_beforesn != "")
                                //    {
                                //        Sn = ms_beforesn;
                                //    }
                                //    else
                                //    {
                                //        OperateResult.AppendText(">>序列号" + sn_code.Text + "不存在TSN\n", Color.Red, sn_code);
                                //        return;
                                //    }
                                //}
                                string netcode = "";
                                string imeid = "";
                                string imei1 = "";
                                string imei2 = "";
                                string imei3 = "";
                                string othid1 = "";
                                string othid2 = "";
                                string othid3 = "";
                                string mac = "";
                                string bt = "";
                                string othcode1 = "";
                                string othcode2 = "";
                                string othcode3 = "";
                                if (ma_saveimei.Checked)
                                {
                                    netcode = SnInf.Rows[0]["MS_NETCODE"].ToString();
                                    imeid = SnInf.Rows[0]["MS_MEID"].ToString();
                                    imei1 = SnInf.Rows[0]["MS_IMEI1"].ToString();
                                    imei2 = SnInf.Rows[0]["ms_imei2"].ToString();
                                    imei3 = SnInf.Rows[0]["ms_imei3"].ToString();
                                    othid1 = SnInf.Rows[0]["ms_othid1"].ToString();
                                    othid2 = SnInf.Rows[0]["ms_othid2"].ToString();
                                    othid3 = SnInf.Rows[0]["ms_othid3"].ToString();
                                }
                                if (ma_savemacbt.Checked)
                                {
                                    mac = SnInf.Rows[0]["ms_mac"].ToString();
                                    bt = SnInf.Rows[0]["ms_bt"].ToString();
                                    othcode1 = SnInf.Rows[0]["MS_OTHCODE1"].ToString();
                                    othcode2 = SnInf.Rows[0]["MS_OTHCODE2"].ToString();
                                    othcode3 = SnInf.Rows[0]["MS_OTHCODE3"].ToString();
                                }
                                string craftcode = MaInf.Rows[0]["ma_craftcode"].ToString();
                                string craftname = MaInf.Rows[0]["ma_craftname"].ToString();
                                string firstsn = SnInf.Rows[0]["ms_firstsn"].ToString();
                                //工作中心为空的时候取工单的工作中心
                                string workcenter = User.WorkCenter;
                                if (workcenter == "")
                                    workcenter = MaInf.Rows[0]["ma_wccode"].ToString();
                                //工单合同为空的时候取序列号合同，更新合同回工单
                                string salecode = MaInf.Rows[0]["ma_salecode"].ToString();
                                List<string> SQLS = new List<string>();
                                if (salecode == "")
                                {
                                    salecode = SnInf.Rows[0]["ms_salecode"].ToString();
                                    SQLS.Add("update make set ma_salecode='" + salecode + "' where ma_id='" + ma_id.Text + "'");
                                }
                                //插入返工工单
                                sql.Clear();
                                sql.Append("insert into MakeSerial(ms_id,ms_code,ms_sncode,ms_prodcode,ms_indate,ms_wccode");
                                sql.Append(",ms_craftcode,ms_craftname,ms_nextstepcode,ms_status,ms_makecode,ms_linecode");
                                sql.Append(",ms_sourcecode,ms_maid,ms_firstsn,ms_salecode,ms_mac,ms_bt,ms_othcode1,ms_othcode2,");
                                sql.Append("ms_othcode3,ms_netcode,ms_imei1,ms_imei2,ms_imei3,ms_meid,ms_othid1,ms_othid2,ms_othid3)");
                                sql.Append("values(MakeSerial_seq.nextval,'" + Sn + "','" + Sn + "','" + pr_code.Text + "',");
                                sql.Append("sysdate,'" + workcenter + "','" + craftcode + "','" + craftname + "','" + User.CurrentStepCode + "',");
                                sql.Append("'0','" + ma_code.Text + "','" + User.UserLineCode + "','" + User.UserSourceCode + "','" + ma_id.Text + "',");
                                sql.Append("'" + firstsn + "','" + salecode + "','" + mac + "','" + bt + "','" + othcode1 + "','" + othcode2 + "','" + othcode3 + "',");
                                sql.Append("'" + netcode + "','" + imei1 + "','" + imei2 + "','" + imei3 + "','" + imeid + "','" + othid1 + "','" + othid2 + "','" + othid3 + "')");
                                SQLS.Add(sql.GetString());
                                //更新工单数量+1
                                SQLS.Add("update make set ma_inqty=nvl(ma_inqty,0)+1 where ma_id='" + ma_id.Text + "'");
                                //更新该序列号的所属工单为返工工单
                                SQLS.Add("update makeserial set ms_nextmacode='" + ma_code.Text + "' where ms_id='" + Msid + "'");
                                if (ms_outboxcode != "")
                                {
                                    string pamothercode = dh.getFieldDataByCondition("package", "pa_mothercode", "pa_outboxcode='" + ms_outboxcode + "'").ToString();
                                    //如果已装栈板从栈板解除
                                    if (pamothercode != "")
                                    {
                                        sql.Clear();
                                        sql.Append("insert into packagebackupdetail(pbd_id,pbd_paid,pbd_outboxcode,pbd_innerboxcode,pbd_barcode,pbd_innerqty,pbd_prodcode,pbd_makecode,pbd_buildate,pbd_ymd)");
                                        sql.Append("select pd_id,pd_paid,pd_outboxcode,pd_innerboxcode,pd_barcode,pd_innerqty,pd_prodcode,pd_makecode,pd_builddate,pd_ymd from packagedetail where ");
                                        sql.Append("pd_outboxcode='" + pamothercode + "' and pd_innerboxcode='" + ms_outboxcode + "'");
                                        SQLS.Add(sql.GetString());
                                        SQLS.Add("delete from packagedetail where pd_outboxcode='" + pamothercode + "' and pd_innerboxcode='" + ms_outboxcode + "'");
                                        DataTable dt = dh.getFieldsDatasByCondition("packagedetail left join package on pa_id=pd_paid", new string[] { "nvl(sum(pd_innerqty),0)", "count(1)" }, "pa_outboxcode='" + pamothercode + "'");
                                        string totalqty = dt.Rows[0][0].ToString();
                                        string currentqty = dt.Rows[0][1].ToString();
                                        SQLS.Add("update package set PA_TOTALQTY='" + totalqty + "',pa_packageqty='" + currentqty + "',pa_currentqty='" + currentqty + "' where pa_outboxcode='" + pamothercode + "'");
                                    }
                                    //备份和删除卡通箱明细
                                    sql.Clear();
                                    sql.Append("insert into packagebackup(pab_id,pab_prodcode,pab_outboxcode,pab_packdate,pab_level,pab_packageqty,pab_totalqty,pab_makecode,pab_status,pab_indate,pab_salecode,pab_printcount,pab_custcode,pab_type,");
                                    sql.Append("pab_weight,pab_currentqty,pab_standardqty,pab_packtype,pab_checkno,pab_downstatus,pab_sccode,pab_ymd,pab_mothercode,pab_currentstep,pab_nextstep,pab_outno,pab_iostatus,pab_remark) ");
                                    sql.Append("select pa_id,pa_prodcode,pa_outboxcode,pa_packdate,pa_level,pa_packageqty,pa_totalqty,pa_makecode,pa_status,pa_indate,pa_salecode,pa_printcount,pa_custcode,pa_type,pa_weight,pa_currentqty,");
                                    sql.Append("pa_standardqty,pa_packtype,pa_checkno,pa_downstatus,pa_sccode,pa_ymd,pa_mothercode,pa_currentstep,pa_nextstep,pa_outno,pa_iostatus,pa_remark from package where pa_outboxcode='" + ms_outboxcode + "'");
                                    SQLS.Add(sql.GetString());
                                    SQLS.Add("delete from package where pa_outboxcode='" + ms_outboxcode + "'");
                                    sql.Clear();
                                    sql.Append("insert into packagebackupdetail(pbd_id,pbd_paid,pbd_outboxcode,pbd_innerboxcode,pbd_barcode,pbd_innerqty,pbd_prodcode,pbd_makecode,pbd_buildate,pbd_ymd)");
                                    sql.Append("select pd_id,pd_paid,pd_outboxcode,pd_innerboxcode,pd_barcode,pd_innerqty,pd_prodcode,pd_makecode,pd_builddate,pd_ymd from packagedetail where ");
                                    sql.Append("pd_outboxcode='" + ms_outboxcode + "'");
                                    SQLS.Add(sql.GetString());
                                    SQLS.Add("delete from packagedetail where pd_outboxcode='" + ms_outboxcode + "' ");
                                }
                                sql.Clear();
                                sql.Append("update makebad set mb_makecode='" + ms_makecode + "' where mb_sncode ='" + sn_code.Text + "' and mb_status=0");
                                SQLS.Add(sql.GetString());
                                if (re_autodecom != "0")
                                {
                                    //sql.Clear();
                                    //sql.Append("select cm_makecode,cm_soncode,cm_barcode from craftmaterial left join makeserial on ms_makecode=");
                                    //sql.Append("cm_makecode and ms_sncode=cm_sncode and ms_prodcode=cm_maprodcode where ms_id='" + Msid + "'");
                                    //DataTable dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
                                    //string cm_makecode = "";
                                    //string cm_soncode = "";
                                    //string cm_barcode = "";
                                    //if (dt.Rows.Count > 0)
                                    //{
                                    //    cm_makecode = dt.Rows[0]["cm_makecode"].ToString();
                                    //    cm_soncode = dt.Rows[0]["cm_soncode"].ToString();
                                    //    cm_barcode = dt.Rows[0]["cm_barcode"].ToString();
                                    //}
                                    sql.Clear();
                                    sql.Append("update craftmaterial set cm_status=-1,cm_dropcode='" + re_code + "',cm_dropman='" + User.UserCode + "',cm_dropdate=sysdate where ");
                                    sql.Append("cm_firstsn='" + firstsn + "' and  nvl(cm_status,0)=0 and exists (select 1 from makesndecompose ");
                                    sql.Append("where msd_recode='" + re_code + "' and msd_fsoncode=cm_fsoncode and msd_stepcode=cm_stepcode)");
                                    SQLS.Add(sql.GetString());
                                    //TSN失效
                                    //sql.Clear();
                                    //sql.Append("update makeserial set ms_nextmacode='' where ms_nextmacode='" + cm_makecode + "'");
                                    //sql.Append(" and ms_sncode='" + cm_barcode + "' and ms_prodcode='" + cm_soncode + "' ");
                                    sql.Clear();
                                    sql.Append("update makeserial set ms_nextmacode='' where ms_id in (select a.ms_id from makeserial B INNER JOIN CRAFTMATERIAL ON cm_firstsn=B.ms_firstsn");
                                    sql.Append("inner join makeserial a on cm_barcode=A.ms_sncode and cm_soncode=A.ms_prodcode  inner join makesndecompose on  msd_fsoncode=cm_fsoncode  and msd_stepcode=cm_stepcode ");
                                    sql.Append("AND A.MS_NEXTMACODE=cm_makecode where b.ms_id='" + Msid + "' and msd_recode='" + re_code + "')");
                                    SQLS.Add(sql.GetString());
                                }
                                dh.ExecuteSQLTran(SQLS.ToArray());
                                //if (ReWorkAsRelateTSN.Checked)
                                //{
                                //    dh.ExecuteSql("update makeserial set ms_nextmacode='" + ma_code.Text + "' where ms_sncode='" + ms_beforesn + "' and ms_nextmacode='" + ms_makecode + "'", "update");
                                //}
                                OperateResult.AppendText(">>序列号" + sn_code.Text + "归属工单" + ma_code.Text + "成功。\n", Color.Green);
                                LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, ma_code.Text, User.UserLineCode, User.UserSourceCode, "返工信息采集", "序列号归属成功", sn_code.Text, "");
                                getsnqty.Text = dh.getFieldDataByCondition("makeserial ", "count(1)", "ms_makecode='" + ma_code.Text + "'").ToString();
                                if (AutoPrint.Checked)
                                {
                                    if (PrintLabel.Items.Count != 0)
                                    {
                                        OperateResult.AppendText(">>打印序列号" + sn_code.Text + "\n", Color.Black);
                                        //doc = lbl.Documents.Open(PrintLabel.Text);
                                        if (!Print.CodeSoft(Tag.ToString(), ref lbl, PrintLabel.Text, PrintLabel.SelectedValue.ToString(), PrinterList.Text, sn_code.Text, int.Parse(PrintNum.Text), ma_code.Text, pr_code.Text, "SN标签", "0", out ErrMessage))
                                        {
                                            OperateResult.AppendText(ErrMessage + "\n", Color.Red);
                                            return;
                                        }
                                        dh.UpdateByCondition("makeserial", "ms_printcount=nvl(ms_printcount,0)+1", "ms_sncode='" + sn_code.Text + "'");
                                    }
                                    else OperateResult.AppendText(">>" + pr_code.Text + "未维护标签\n", Color.Black);
                                }
                                sn_code.Clear();
                            }
                            else OperateResult.AppendText(">>序列号" + sn_code.Text + "不存在或者已绑定工单\n", Color.Red, sn_code);
                        }
                        else OperateResult.AppendText(">>序列号不允许为空\n", Color.Red, sn_code);
                    }
                    else OperateResult.AppendText(">>该岗位资源对应的工序不是当前返工工单途程中的第一道工序，请切换资源编号\n", Color.Red, sn_code);
                }
                else OperateResult.AppendText(">>工单号不允许为空\n", Color.Red, sn_code);
            }
        }

        private void ma_code_UserControlTextChanged(object sender, EventArgs e)
        {
            if (ma_code.Text.Length >= 5)
            {
                if (dh.CheckExist("make", "ma_kind='返工' and ma_statuscode='STARTED' and ma_code='" + ma_code.Text + "'"))
                {
                    sql.Clear();
                    sql.Append("select ma_id,ma_craftcode,ma_code,pr_code,pr_detail,pr_spec,ma_qty,nvl(ma_savemacbt,0) ma_savemacbt,nvl(ma_saveimei, 0)");
                    sql.Append("ma_saveimei from make left join product on ma_prodcode=pr_code where ma_code='" + ma_code.Text + "'");
                    dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
                    BaseUtil.SetFormValue(this.Controls, dt);
                    if (dt.Rows[0]["ma_saveimei"].ToString() != "0")
                    {
                        ma_saveimei.Checked = true;
                    }
                    if (dt.Rows[0]["ma_savemacbt"].ToString() != "0")
                    {
                        ma_savemacbt.Checked = true;
                    }
                }
            }
        }

        private void PrintLabel_SelectedValueChanged(object sender, EventArgs e)
        {
            if (PrintLabel.SelectedValue != null && PrintLabel.SelectedValue.ToString() != "System.Data.DataRowView")
            {
                string PrintNums = dh.getFieldDataByCondition("label", "la_printnos", "la_id='" + PrintLabel.SelectedValue.ToString() + "'").ToString();
                PrintNum.Text = (PrintNums == "" ? "1" : PrintNums);
            }
        }
    }
}