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;
            for (int i = WaitRejectList.Items.Count - 1; i >= 0; i--)
            {
                if (WaitRejectList.Items[i].Checked)
                {
                    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--)
                {
                    ChoosedRejectList.Items.Add((ListViewItem)WaitRejectList.Items[i].Clone());
                    WaitRejectList.Items[i].Remove();
                }
            }
        }

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

        private void ms_code_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            {
                if (ms_sncode.Text.Trim() != "" && ma_code.Text != "")
                {
                    string ErrorMessage = "";
                    bool ifFirst;
                    if (LogicHandler.CheckCurrentStepAndIfFirst(ms_sncode.Text, ma_code.Text, User.UserSourceCode, Tag.ToString(), out ifFirst, out ErrorMessage))
                    {
                        //如果采集为良品则不再允许采集
                        if (GoodProduct.Checked)
                        {
                            dt = (DataTable)dh.ExecuteSql("select ms_nextstepcode,ms_stepcode,ms_status from makeserial where ms_sncode='" + ms_sncode.Text + "' and ms_makecode='" + ma_code.Text + "'", "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 (nextstepcode != User.CurrentStepCode && stepcode == User.CurrentStepCode && (status == "1" || status == "2"))
                            {
                                OperateResult.AppendText(">>该序列号已执行过" + User.CurrentStepCode + "工序,采集结果为良品\n", Color.Red);
                                return;
                            }
                        }
                        SetCollectResult();
                    }
                    else
                        OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red);
                    if (!Reject.Checked)
                        ms_sncode.Text = "";
                }
                else if (ma_code.Text == "")
                {
                    sql.Clear();
                    sql.Append("select ma_code,ma_qty,ma_prodcode,mcd_inqty,ma_qty-mcd_inqty mcd_remainqty,pr_detail from make left join makeserial on ");
                    sql.Append("ma_code=ms_makecode left join product on ms_prodcode=pr_code left join makecraftdetail on  ");
                    sql.Append("mcd_macode=ms_makecode where ms_sncode='" + ms_sncode.Text + "' and mcd_stepcode='" + User.CurrentStepCode + "'");
                    dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
                    if (dt.Rows.Count > 0)
                    {
                        BaseUtil.SetFormValue(Controls, dt);
                        SetCollectResult();
                    }
                    else
                    {
                        OperateResult.AppendText(">>序列号" + ms_sncode.Text + "不存在或不对应当前工序\n", Color.Red);
                        return;
                    }
                }
            }
        }

        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 + "'");
            dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
            if (dt.Rows.Count > 0)
            {
                //设置Combox的下拉值
                bc_groupcode.DataSource = dt;
                bc_groupcode.DisplayMember = "pb_badgroup";
                bc_groupcode.ValueMember = "pb_badgroup";
            }
        }

        /// <summary>
        /// 加载不良代码的ListView的信息
        /// </summary>
        private void LoadBadCodeListView()
        {
            sql.Clear();
            sql.Append("select bc_code,bc_name  from badgroup left join badcode on bc_groupcode=bg_code where bc_groupcode='" + bc_groupcode.Text + "'");
            dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
            bc_code.DataSource = dt;
            bc_code.DisplayMember = "bc_name";
            bc_code.ValueMember = "bc_code";
            //往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();
        }

        /// <summary>
        /// 设置良品或者不良品的采集结果
        /// </summary>
        private void SetCollectResult()
        {
            string ErrorMessage = "";
            //如果勾选的是不良品
            if (Reject.Checked)
            {
                //加载不良信息
                LoadBadGroupData();
            }
            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.UserName, "检测合格", out ErrorMessage))
                    {
                        OperateResult.AppendText(">>" + ms_sncode.Text + "已采集为良品\n", Color.Green);
                        ms_sncode.Text = "";
                    }
                    else
                        OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red);
                }
            }
            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)
        {
            string ErrorMessage = "";
            if (ChoosedRejectList.Items.Count == 0 && bc_code.Text == "")
                OperateResult.AppendText(">>不良品必须选择不良原因和不良代码!\n", Color.Red);
            else
            {
                //判断不良原因代码是否重复，不良原因保存表（makebad）
                //保存前台传送的不良信息保存至makebad 表。(判断不良原因是否重复)
                //新建不良代码和备注的变量
                //不良品的输入
                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];
                //如果长度不相等表示用户自行填写了
                if (bccode.Length != RejectCount)
                {
                    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))
                    {
                        //获取所有的不良代码
                        bccode[i] = ChoosedRejectList.Items[bc_code.Text == "" ? i : i - 1].SubItems[1].Text;
                        //获取所有的不良备注
                        bcremark[i] = ChoosedRejectList.Items[bc_code.Text == "" ? i : i - 1].SubItems[2].Text;
                    }
                }
                //不良信息采集
                if (LogicHandler.SetTestNGDetail(ms_sncode.Text, ma_code.Text, User.UserName, User.UserSourceCode, "检查未通过", bccode, bcremark, out ErrorMessage))
                {
                    OperateResult.AppendText(">>" + ms_sncode.Text + "已采集为不良\n", Color.Green);
                    //清除不良信息
                    bc_groupcode.DataSource = null;
                    bc_groupcode.Text = "";
                    bc_code.DataSource = null;
                    bc_code.Text = "";
                    WaitRejectList.Items.Clear();
                    ChoosedRejectList.Items.Clear();
                    ms_sncode.Text = "";
                }
                else
                    OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red);
            }
        }
    }
}