mes-client/UAS_MES_WEIP/FunctionCode/Make/Make_PreFeedingCollection.cs

using System;
using System.Data;
using System.Text;
using System.Windows.Forms;
using UAS_MES_NEW.CustomControl.TextBoxWithIcon;
using UAS_MES_NEW.DataOperate;
using UAS_MES_NEW.Entity;
using UAS_MES_NEW.PublicMethod;
using System.Drawing;
using System.Text.RegularExpressions;
using System.Collections.Generic;
using UAS_MES_NEW.PublicForm;

namespace UAS_MES_NEW.Make
{
    public partial class Make_PreFeedingCollection : Form
    {
        //MakeSerial表主键
        string ms_id;
        //制造单号                                                                             
        string make_code;
        //产品编号
        string make_prodcode;
        //工序编号
        string nextstepcode;
        //完工状态
        string ms_status;
        //工艺路线编号
        //Bom版本
        string mabomversion;
        string ErrorMessage = "";

        List<string> TSN = new List<string>();

        Dictionary<string, string> CheckBarcode = new Dictionary<string, string>();

        //用于提醒的序列B
        string[] RemainList = new string[0];
        //提醒序列的索引
        int RemainIndex = 0;

        string oMakeCode = "";
        string oMsid = "";

        string ms_firstsn = "";

        DataHelper dh;
        LogStringBuilder sql = new LogStringBuilder();
        DataTable DBFind;
        DataTable dt;
        //保存ListB中的数据
        DataTable dt1;

        AutoSizeFormClass asc = new AutoSizeFormClass();

        List<string> CollectData = new List<string>();

        List<string> CollectDataSonCode = new List<string>();

        List<string> SPID = new List<string>();

        int CollectCount = 0;

        public Make_PreFeedingCollection()
        {
            InitializeComponent();
        }

        private void Make_FeedingCollection_Load(object sender, EventArgs e)
        {
            asc.controllInitializeSize(this);
            string cachenum = BaseUtil.GetCacheData("ProdCodeNum").ToString();
            ProdNum.Value = decimal.Parse(cachenum == "" ? "1" : cachenum);
            LockMakeCode.GetMakeCodeCtl(ma_code);
            ma_code.SetLockCheckBox(LockMakeCode);
            //工单号放大镜配置
            ma_code.TableName = "make left join product on ma_prodcode=pr_code";
            ma_code.SelectField = "ma_code # 工单号,ma_prodcode # 产品编号,ma_qty # 工单数量,ma_craftcode # 途程编号,pr_spec # 产品名称,ma_bomversion # Bom版本,ma_softversion # 软件版本,ma_ecncode # ECN号";
            ma_code.FormName = Name;
            ma_code.DBTitle = "工单查询";
            ma_code.SetValueField = new string[] { "ma_code", "ma_prodcode", "ma_qty", "pr_spec", "ma_craftcode", "ma_bomversion", "ma_softversion", "ma_ecncode" };
            ma_code.Condition = "ma_statuscode='STARTED'";
            ma_code.DbChange += Ma_code_DBChange;
            code.Focus();
            dh = SystemInf.dh;
            StepCount.StepCode = User.CurrentStepCode;
            StepCount.Source = User.UserSourceCode;
            StepCount.LineCode = User.UserLineCode;
            StepCount.Dh = dh;
            StepCount.Start();
        }

        private void Ma_code_DBChange(object sender, EventArgs e)
        {
            DBFind = ma_code.ReturnData;
            BaseUtil.SetFormValue(this.Controls, DBFind);
            GetItem();
        }

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

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

        private void Confirm_Click(object sender, EventArgs e)
        {
            KeyEventArgs e2 = new KeyEventArgs(Keys.Enter);
            code_KeyDown(sender, e2);
        }

        private void code_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            {
                if (LogicHandler.CheckStepAttribute(Tag.ToString(), User.UserSourceCode, out ErrorMessage))
                {
                    if (Loading.Checked)
                    {
                        if (code.Text.Replace(" ", "") == "")
                        {
                            OperateResult.AppendText(">>采集数据不可为空\n", Color.Red);
                            return;
                        }
                        else
                        {
                            if (mainbarcode.Text == "")
                            {
                                mainbarcode.Text = code.Text;
                                GetItem();
                                code.Clear();
                                return;
                            }
                            string sp_soncode = "";
                            string sp_fsoncode = "";
                            string sp_prefix = "";
                            string sp_regex = "";
                            string length = "";
                            string sp_id = "";
                            string sp_ifrepeat = "";
                            string sp_ifforsn = "";
                            string sp_barcoderule = "";
                            string sp_checkbarcode = "";
                            string sp_checksalecode = "";
                            for (int i = 0; i < LabelDataGridView.Rows.Count; i++)
                            {
                                object value = LabelDataGridView.Rows[i].Cells["BarCode"].Value;
                                if (value == null || (value != null && value.ToString() == ""))
                                {
                                    RemainIndex = i;
                                    sp_soncode = dt1.Rows[i]["sp_soncode"].ToString();
                                    sp_fsoncode = dt1.Rows[i]["sp_fsoncode"].ToString();
                                    sp_prefix = dt1.Rows[i]["sp_prefix"].ToString();
                                    sp_regex = dt1.Rows[i]["sp_regex"].ToString();
                                    length = dt1.Rows[i]["sp_length"].ToString();
                                    sp_id = dt1.Rows[i]["sp_id"].ToString();
                                    sp_ifrepeat = dt1.Rows[i]["sp_ifrepeat"].ToString();
                                    sp_ifforsn = dt1.Rows[i]["sp_ifforsn"].ToString();
                                    sp_barcoderule = dt1.Rows[i]["sp_barcoderule"].ToString();
                                    sp_checkbarcode = dt1.Rows[i]["sp_checkbarcode"].ToString();
                                    sp_checksalecode = dt1.Rows[i]["sp_checksalecode"].ToString();
                                    break;
                                }
                            }
                            if (LogicHandler.CheckSNBeforeLoad(ma_code.Text, code.Text, sp_fsoncode, sp_soncode, sp_barcoderule, sp_prefix, length, sp_ifrepeat, sp_checksalecode, out ErrorMessage))
                            {
                                //查询条码是否存在预加工列表
                                if (dh.CheckExist("BEFOREHANDPROCESS", "bhp_barcode='" + code.Text + "'"))
                                {
                                    OperateResult.AppendText(">> 条码" + code.Text + "已经上料\n", Color.Red, code);
                                    return;
                                }
                                LabelDataGridView.Rows[RemainIndex].Cells["BarCode"].Value = code.Text;
                                string maincode = LabelDataGridView.Rows[0].Cells["BarCode"].Value.ToString();
                                sql.Clear();
                                sql.Append("insert into BEFOREHANDPROCESS(bhp_id,bhp_maincode,bhp_barcode,bhp_prodcode,bhp_indate,bhp_inman)");
                                sql.Append("values(BEFOREHANDPROCESS_seq.nextval,'" + maincode + "','" + code.Text + "','" + sp_fsoncode + "',sysdate,'" + User.UserCode + "')");
                                dh.ExecuteSql(sql.GetString(), "insert");
                                OperateResult.AppendText(">> 条码" + code.Text + "上料成功\n", Color.Green, code);
                                code.Clear();
                                CollectCount = CollectCount + 1;
                                if (CollectCount == ProdNum.Value)
                                {
                                    mainbarcode.Text = "";
                                    CollectCount = 0;
                                    SetCheck set = new SetCheck("OK", Color.Green);
                                    BaseUtil.SetFormCenter(set);
                                    set.ShowDialog();
                                }
                            }
                            else
                            {
                                OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red, code);
                                SetCheck set = new SetCheck("NG", Color.Red);
                                BaseUtil.SetFormCenter(set);
                                set.ShowDialog();
                            }
                        }
                    }
                    else if (UnLoading.Checked)
                    {
                        bool finddata = false;
                        for (int i = 0; i < LabelDataGridView.Rows.Count; i++)
                        {
                            object value = LabelDataGridView.Rows[i].Cells["BarCode"].Value;
                            if (value != null && value.ToString() != "")
                            {
                                if (code.Text == value.ToString())
                                {
                                    finddata = true;
                                    //拆解主物料，全部解绑
                                    if (i == 0)
                                    {
                                        string yes_or_no = MessageBox.Show(this.ParentForm, "是否解绑所有物料", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question).ToString();
                                        if (yes_or_no == "Yes")
                                        {
                                            sql.Clear();
                                            sql.Append("delete from BEFOREHANDPROCESS where bhp_maincode='" + code.Text + "'");
                                            dh.ExecuteSql(sql.GetString(), "delete");
                                            mainbarcode.Text = "";
                                            GetItem();
                                        }
                                    }
                                    else
                                    {
                                        sql.Clear();
                                        sql.Append("delete from BEFOREHANDPROCESS where bhp_barcode='" + code.Text + "'");
                                        dh.ExecuteSql(sql.GetString(), "delete");
                                        LabelDataGridView.Rows[i].Cells["BarCode"].Value = "";
                                    }
                                    OperateResult.AppendText(">> 条码" + code.Text + "下料成功\n", Color.Green, code);
                                }
                            }
                        }
                        if (!finddata)
                        {
                            OperateResult.AppendText(">>条码" + code.Text + "未上料\n", Color.Red, code);
                        }
                    }
                }
                else OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red, code);
            }
        }

        private void SaveData()
        {
            List<string> pr_code = new List<string>();
            List<string> barcode = new List<string>();
        }

        private void GetItem()
        {
            //单独用一个DataTable存储一个
            dt1 = new DataTable();
            if (mainbarcode.Text == "")
            {
                sql.Clear();
                sql.Append("select max(sp_id)sp_id,max(sp_detno)sp_detno,min(sp_ifrepeat)sp_ifrepeat,max(sp_checkbarcode)sp_checkbarcode,min(sp_checksalecode)sp_checksalecode,");
                sql.Append("sp_fsoncode,max(sp_barcoderule)sp_barcoderule,wm_concat(sp_soncode) sp_soncode,max(sp_ifuseregex)sp_ifuseregex,max(sp_ifforsn)");
                sql.Append("sp_ifforsn,max(sp_length)sp_length,max(sp_type)sp_type,replace(wm_concat(sp_prefix),',','|')sp_prefix,max(sp_regex)");
                sql.Append("sp_regex,max(substr(pr_spec,0,20))pr_detail from stepproduct left join stepbom on sb_bomversion=sp_bomversion ");
                sql.Append("left join product on pr_code=sp_fsoncode  where ");
                sql.Append("sp_mothercode ='" + ma_prodcode.Text + "' and sp_tracekind=1 and sp_ifbeforhandle=-1  group by sp_fsoncode order by SP_DETNO asc");
            }
            else
            {
                sql.Clear();
                sql.Append("select max(sp_id)sp_id,max(sp_detno)sp_detno,min(sp_ifrepeat)sp_ifrepeat,max(sp_checkbarcode)sp_checkbarcode,min(sp_checksalecode)sp_checksalecode,");
                sql.Append("sp_fsoncode,max(sp_barcoderule)sp_barcoderule,wm_concat(sp_soncode) sp_soncode,max(sp_ifuseregex)sp_ifuseregex,max(sp_ifforsn)");
                sql.Append("sp_ifforsn,max(sp_length)sp_length,max(sp_type)sp_type,replace(wm_concat(sp_prefix),',','|')sp_prefix,max(sp_regex)");
                sql.Append("sp_regex,max(substr(pr_spec,0,20))pr_detail,max(bhp_barcode)bhp_barcode from stepproduct left join stepbom on sb_bomversion=sp_bomversion ");
                sql.Append("left join product on pr_code=sp_fsoncode left join (select * from BEFOREHANDPROCESS where bhp_maincode='" + mainbarcode.Text + "') on bhp_prodcode=sp_fsoncode where ");
                sql.Append("sp_mothercode ='" + ma_prodcode.Text + "' and sp_tracekind=1 and sp_ifbeforhandle=-1 and (bhp_maincode='" + mainbarcode.Text + "' or bhp_maincode is null)  group by sp_fsoncode order by SP_DETNO asc");
            }
            dt1 = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
            BaseUtil.FillDgvWithDataTable(LabelDataGridView, dt1);
        }

        private void ma_code_UserControlTextChanged(object sender, EventArgs e)
        {
            if (ma_code.Text.Length > 5)
            {
                string ErrMessage = "";
                if (LogicHandler.CheckMakeStatus(ma_code.Text, out ErrMessage))
                {
                    mcd_inqty.Text = "";
                    mcd_remainqty.Text = "";
                    sql.Clear();
                    sql.Append("select mcd_inqty,ma_qty-mcd_inqty mcd_remainqty ");
                    sql.Append("from make left join makecraftdetail on mcd_macode=ma_code where ");
                    sql.Append("ma_code='" + ma_code.Text + "' and mcd_stepcode='" + User.CurrentStepCode + "'");
                    DataTable dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
                    if (dt.Rows.Count > 0)
                        BaseUtil.SetFormValue(Controls, dt);
                }
            }
        }

        private void ClearSn_code_Click(object sender, EventArgs e)
        {
            mainbarcode.Clear();
            code.Clear();
            if (dt1 != null)
                BaseUtil.CleanDataTableData(dt1);
            RemainIndex = 0;
            BaseUtil.CleanDGVData(LabelDataGridView);
            OperateResult.AppendText(">>请采集条码\n", Color.Black);
            GetItem();
        }

        private void numericUpDown1_ValueChanged(object sender, EventArgs e)
        {
            BaseUtil.SetCacheData("ProdCodeNum", ProdNum.Value.ToString());
        }
    }
}