mes-client/UAS-MES/FunctionCode/Make/Make_TestCollection.cs

using System;
using System.Data;
using System.Text;
using System.Threading;
using System.Drawing;
using System.Windows.Forms;
using UAS_MES.DataOperate;
using UAS_MES.Entity;
using UAS_MES.PublicMethod;

namespace UAS_MES.Make
{
    public partial class Make_TestCollection : Form
    {
        DataHelper dh = null;
        DataTable dt = null;
        //是否获取过参数，获取过参数则设置为true,在序号值变化的时候设置为false
        //当前工序的编号
        string ms_nextstepcode;
        //当前工序的名称
        string ms_stepname;
        //下一工序编号
        //string ms_nextstepcode;
        //工序编号
        string ma_craftcode;
        //制造单号
        string ms_macode;

        //用于保存是否之前输入的ma_code

        //用于保存是否之前输入的ms_sncode
        string ms_sncode1;

        LogStringBuilder sql = new LogStringBuilder();

        AutoSizeFormClass asc = new AutoSizeFormClass();

        public Make_TestCollection()
        {
            InitializeComponent();
        }

        private void TestCollection_Load(object sender, EventArgs e)
        {
            dh = new DataHelper();
            GoodProduct.Checked = true;
            ms_sncode.Focus();
            asc.controllInitializeSize(this);

            //设置锁定工单
            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 # 工单数量,pr_detail # 产品名称";
            ma_code.FormName = Name;
            ma_code.SetValueField = new string[] { "ma_code", "ma_prodcode", "ma_qty", "pr_detail" };
            ma_code.Condition = "ma_statuscode='STARTED'";
        }

        /// <summary>
        /// 将已选不良移动到待选不良
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void WaitReject_Click(object sender, EventArgs e)
        {
            int CheckedNum = 0;
            //已存在在ListView中的Item是不能添加到其他ListView中的，需要调用其克隆的方法
            for (int i = ChoosedRejectList.Items.Count - 1; i >= 0; i--)
            {
                if (ChoosedRejectList.Items[i].Checked)
                {
                    WaitRejectList.Items.Add((ListViewItem)ChoosedRejectList.Items[i].Clone());
                    ChoosedRejectList.Items[i].Remove();
                    CheckedNum++;
                }
            }
            if (CheckedNum == 0)
            {
                for (int i = ChoosedRejectList.Items.Count - 1; i >= 0; i--)
                {
                    WaitRejectList.Items.Add((ListViewItem)ChoosedRejectList.Items[i].Clone());
                    ChoosedRejectList.Items[i].Remove();
                }
            }
        }

        /// <summary>
        /// 将不良信息移动到已选不良
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ChooseedReject_Click(object sender, EventArgs e)
        {
            int CheckedNum = 0;
            //是否已经添加到不良
            bool AddToReject = false;
            for (int i = WaitRejectList.Items.Count - 1; i >= 0; i--)
            {
                if (WaitRejectList.Items[i].Checked)
                {
                    AddToReject = false;
                    for (int j = 0; j < ChoosedRejectList.Items.Count; j++)
                    {
                        if ((ChoosedRejectList.Items[j].SubItems[2].Text == WaitRejectList.Items[i].SubItems[2].Text))
                        {
                            AddToReject = true;
                            break;
                        }
                    }
                    //未添加则进行添加
                    if (!AddToReject)
                    {
                        ChoosedRejectList.Items.Add((ListViewItem)WaitRejectList.Items[i].Clone());
                        WaitRejectList.Items[i].Remove();
                        CheckedNum++;
                    }
                }
            }
            if (CheckedNum == 0)
            {
                for (int i = WaitRejectList.Items.Count - 1; i >= 0; i--)
                {
                    AddToReject = false;
                    for (int j = 0; j < ChoosedRejectList.Items.Count; j++)
                    {
                        if ((ChoosedRejectList.Items[j].SubItems[2].Text == WaitRejectList.Items[i].SubItems[2].Text))
                        {
                            AddToReject = true;
                            break;
                        }
                    }
                    if (!AddToReject)
                    {
                        ChoosedRejectList.Items.Add((ListViewItem)WaitRejectList.Items[i].Clone());
                        WaitRejectList.Items[i].Remove();
                        CheckedNum++;
                    }
                }
            }
        }

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

        private void ms_code_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            {
                string ErrorMessage = "";
                bool ifFirst;
                if (LogicHandler.CheckStepAttribute(Tag.ToString(), User.UserSourceCode, out ErrorMessage))
                {
                    string oMakeCode = "";
                    string oMSID = "";
                    if (LogicHandler.CheckStepSNAndMacode(ma_code.Text, User.UserSourceCode, ms_sncode.Text, User.UserCode, out oMakeCode, out oMSID, out ErrorMessage))
                    {
                        dt = (DataTable)dh.ExecuteSql("select ma_code,ma_prodcode,pr_detail,ma_qty from make left join product on ma_prodcode=pr_code where ma_code='"+oMakeCode+"'", "select");
                        if (dt.Rows.Count > 0) {
                            BaseUtil.SetFormValue(this.Controls, dt);
                            LockMakeCode.Checked = true;
                        }
                        if (GoodProduct.Checked)
                        {
                            dt = (DataTable)dh.ExecuteSql("select ms_nextstepcode,ms_stepcode,ms_status from makeserial where ms_id='" + oMSID + "'", "select");
                            string status = dt.Rows[0]["ms_status"].ToString();
                            string nextstepcode = dt.Rows[0]["ms_nextstepcode"].ToString();
                            string stepcode = dt.Rows[0]["ms_stepcode"].ToString();
                            if (stepcode == User.CurrentStepCode && (status == "1" || status == "2"))
                            {
                                OperateResult.AppendText(">>该序列号已执行过" + User.CurrentStepCode + "工序,采集结果为良品\n", Color.Red);
                                return;
                            }
                        }
                        SetCollectResult();
                    }
                    else
                        OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red);
                }
                else
                    OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red);
            }
        }

        private void bc_groupcode_SelectedIndexChanged(object sender, EventArgs e)
        {
            LoadBadCodeListView();
        }

        /// <summary>
        /// 填充不良组别信息
        /// </summary>
        private void LoadBadGroupData()
        {
            //如果ms_makecode的值修改过再去查询
            sql.Clear();
            sql.Append("select pb_badgroup from make left join product on pr_code=ma_prodcode left join ");
            sql.Append("productkind on pk_name=pr_kind left join productbadgroup on pk_code=PB_KINDCODE where ma_code='" + ma_code.Text + "' and pb_badgroup is not null");
            DataTable dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
            if (dt.Rows.Count == 0)
            {
                sql.Clear();
                sql.Append("select bg_code||':'||bg_name bg_name,bg_code from badgroup");
                dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
                bc_groupcode.DisplayMember = "bg_name";
                bc_groupcode.ValueMember = "bg_code";
                bc_groupcode.DataSource = dt;
                //设置Combox的下拉值
            }
            else
            {
                bc_groupcode.DataSource = dt;
                bc_groupcode.DisplayMember = "pb_badgroup";
                bc_groupcode.ValueMember = "pb_badgroup";
            }
        }

        /// <summary>
        /// 加载不良代码的ListView的信息
        /// </summary>
        private void LoadBadCodeListView()
        {
            sql.Clear();
            object bg_code = bc_groupcode.SelectedValue;
            sql.Append("select bg_code||':'||bg_name bg_code,bc_code,bc_note from badcode left join badgroup on bc_groupcode=bg_code where bc_groupcode='" + (bg_code != null ? bg_code.ToString() : "") + "' and bg_code is not null");
            dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
            //往listview中添加数据
            WaitRejectList.Items.Clear();
            WaitRejectList.BeginUpdate();
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                ListViewItem lvi = new ListViewItem();
                //第一列是勾选列，设置列头文本为空
                lvi.Text = "";
                for (int j = 0; j < dt.Columns.Count; j++)
                    lvi.SubItems.Add(dt.Rows[i][j].ToString());
                WaitRejectList.Items.Add(lvi);
            }
            WaitRejectList.EndUpdate();
            sql.Clear();
            sql.Append("select bg_code||':'||bg_name bg_code,bc_code,mb_badremark from makebad  ") ;
            sql.Append("left join badgroup on mb_bgcode=bg_code left join badcode on mb_badcode=bc_code ");
            sql.Append(" where mb_sncode='" + ms_sncode.Text + "' and mb_makecode='" + ma_code.Text + "'");
            dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
            ChoosedRejectList.Items.Clear();
            ChoosedRejectList.BeginUpdate();
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                ListViewItem lvi = new ListViewItem();
                //第一列是勾选列，设置列头文本为空
                lvi.Text = "";
                for (int j = 0; j < dt.Columns.Count; j++)
                    lvi.SubItems.Add(dt.Rows[i][j].ToString());
                ChoosedRejectList.Items.Add(lvi);
            }
            ChoosedRejectList.EndUpdate();
        }

        /// <summary>
        /// 设置良品或者不良品的采集结果
        /// </summary>
        private void SetCollectResult()
        {
            string ErrorMessage = "";
            //如果勾选的是不良品
            if (Reject.Checked)
            {
                //加载不良信息
                LoadBadGroupData();
                //勾选了自动产生代码
                if (AutoBadCode.Checked)
                {
                    Save_Click(new object(), new EventArgs());
                }
            }
            if (GoodProduct.Checked)
            {
                string RejectRecordNum = dh.getFieldDataByCondition("makeBad", "count(1) cn", "mb_sncode='" + ms_sncode.Text + "' and mb_status not in (1,-1)").ToString();
                //存在不良记录
                if (int.Parse(RejectRecordNum) > 0)
                    OperateResult.AppendText(">>" + ms_sncode.Text + "已经判为不良品，不允许修改!\n", Color.Red);
                else
                {
                    //良品信息采集
                    if (LogicHandler.UpdateMakeMessage(ms_sncode.Text, ma_code.Text, "良品采集", User.UserSourceCode, User.UserCode, "检测合格", out ErrorMessage))
                        OperateResult.AppendText(">>" + ms_sncode.Text + "已采集为良品\n", Color.Green);
                    else
                        OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red);
                }
                ms_sncode.Text = "";
            }
            dt = (DataTable)dh.ExecuteSql("select mcd_inqty,ma_qty-mcd_inqty mcd_remainqty from make left join makecraftdetail on mcd_macode=ma_code where ma_code='" + ma_code.Text + "' and mcd_stepcode='" + User.CurrentStepCode + "'", "select");
            BaseUtil.SetFormValue(Controls, dt);
        }

        private void 测试采集_SizeChanged(object sender, EventArgs e)
        {
            asc.controlAutoSize(this);
        }

        private void Save_Click(object sender, EventArgs e)
        {
            int RejectCount = ChoosedRejectList.Items.Count;
            string[] bccode = new string[bc_code.Text == "" ? RejectCount : RejectCount + 1];
            string[] bcremark = new string[bc_code.Text == "" ? RejectCount : RejectCount + 1];
            string[] bgcode = new string[bc_code.Text == "" ? RejectCount : RejectCount + 1];
            string ErrorMessage = "";
            if (AutoBadCode.Checked)
            {
                string defaultvalue = Properties.Settings.Default.DefaultCollectionValue;
                bccode = new string[] { defaultvalue };
                bcremark = new string[] { defaultvalue };
                bgcode = new string[] { defaultvalue };
            }
            else
            {
                if (ChoosedRejectList.Items.Count == 0 && bc_code.Text == "")
                    OperateResult.AppendText(">>不良品必须选择不良原因和不良代码!\n", Color.Red);
                else
                {
                    //判断不良原因代码是否重复，不良原因保存表（makebad）
                    //保存前台传送的不良信息保存至makebad 表。(判断不良原因是否重复)
                    //新建不良代码和备注的变量
                    //不良品的输入
                    //如果长度不相等表示用户自行填写了
                    if (bccode.Length != RejectCount)
                    {
                        bgcode[0] = bc_groupcode.SelectedValue.ToString();
                        bccode[0] = bc_code.Text;
                        bcremark[0] = bc_remark.Text;
                    }
                    //用户未填写不良代码一切按照正常逻辑，填写了从index=1开始执行
                    for (int i = (bc_code.Text == "" ? 0 : 1); i < (bc_code.Text == "" ? RejectCount : RejectCount + 1); i++)
                    {
                        if (!(bccode[0] == ChoosedRejectList.Items[bc_code.Text == "" ? i : i - 1].SubItems[1].Text))
                        {
                            //截取分号前面的内容
                            bgcode[i] = ChoosedRejectList.Items[bc_code.Text == "" ? i : i - 1].SubItems[1].Text.Split(':')[0];
                            //获取所有的不良代码
                            bccode[i] = ChoosedRejectList.Items[bc_code.Text == "" ? i : i - 1].SubItems[2].Text;
                            //获取所有的不良备注
                            bcremark[i] = ChoosedRejectList.Items[bc_code.Text == "" ? i : i - 1].SubItems[3].Text;
                        }
                    }
                }
            }
            //如果之前是良品的
            dt = dh.getFieldsDataByCondition("makeserial", new string[] { "ms_status", "ms_checkno" }, "ms_sncode='" + ms_sncode.Text + "' and ms_stepcode='" + User.CurrentStepCode + "'");
            if (dt.Rows.Count > 0)
            {
                string status = dt.Rows[0]["ms_status"].ToString();
                if (status == "1" || status == "2")
                    dh.UpdateByCondition("makecraftdetail", "mcd_okqty=mcd_okqty-1", "mcd_macode='" + ma_code.Text + "' and mcd_stepcode='" + User.CurrentStepCode + "'");
                string checkno = dt.Rows[0]["ms_checkno"].ToString();
                //存在抽检批次更新为空
                if (checkno != "")
                    dh.UpdateByCondition("makeserial", "ms_checkno=''", "ms_sncode='" + ms_sncode.Text + "' and ms_makecode='" + ma_code.Text + "'");
            }
            //不良信息采集
            dh.ExecuteSql("delete from makebad where mb_sncode='"+ms_sncode.Text+"' and mb_makecode='"+ma_code.Text+"'","delete");
            if (LogicHandler.SetTestNGDetail(ms_sncode.Text, ma_code.Text, User.UserName, User.UserSourceCode, "检查未通过", bgcode, bccode, bcremark, out ErrorMessage))
            {
                OperateResult.AppendText(">>" + ms_sncode.Text + "已采集为不良\n", Color.Green);
                //清除不良信息
                bc_groupcode.DataSource = null;
                bc_groupcode.Text = "";
                bc_code.Text = "";
                WaitRejectList.Items.Clear();
                ChoosedRejectList.Items.Clear();
                ms_sncode.Text = "";
            }
            else
                OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red);
        }

        private void bc_code_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            {
                DataTable dt = dh.getFieldsDataByCondition("badcode", new string[] { "bc_groupcode", "bc_code", "bc_note" }, "bc_code='" + bc_code.Text + "'");
                if (dt.Rows.Count > 0)
                {
                    for (int i = 0; i < ChoosedRejectList.Items.Count; i++)
                    {
                        if (ChoosedRejectList.Items[i].ListView.Items[0].SubItems[2].Text == bc_code.Text)
                        {
                            MessageBox.Show("已添加过不良代码" + bc_code.Text);
                            return;
                        }
                    }
                    ListViewItem lvi = new ListViewItem();
                    lvi.Text = "";
                    for (int j = 0; j < dt.Columns.Count; j++)
                        lvi.SubItems.Add(dt.Rows[0][j].ToString());
                    ChoosedRejectList.Items.Add(lvi);
                }
                else MessageBox.Show("不良代码不存在");
            }
        }
    }
}