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

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using UAS_MES.DataOperate;
using UAS_MES.Entity;
using UAS_MES.PublicMethod;

namespace UAS_MES.Make
{
    public partial class Make_NewBadCode : Form
    {
        /// <summary>
        /// 序列号
        /// </summary>
        string sncode = "";
        /// <summary>
        /// 工单号
        /// </summary>
        string macode = "";

        DataHelper dh;

        DataTable dt;

        LogStringBuilder sql = new LogStringBuilder();

        public Make_NewBadCode(string iSnCode, string iMakeCode)
        {
            InitializeComponent();
            sncode = iSnCode;
            macode = iMakeCode;
        }

        private void Make_NewBadCode_Load(object sender, EventArgs e)
        {
            dh = new DataHelper();
            ms_makecode.Text = macode;
            ms_sncode.Text = sncode;
            string pr_code = dh.getFieldDataByCondition("makeserial", "ms_prodcode", "ms_sncode='" + sncode + "' and ms_makecode='" + macode + "'").ToString();
            sql.Clear();
            sql.Append("select bg_code,bg_name from product left join productkind  on pr_kind =pk_name ");
            sql.Append("left join productbadgroup  on  pb_kindcode= pk_code left join badgroup on ");
            sql.Append("bg_code=pb_badgroup  where pr_code='" + pr_code + "' and nvl(pb_kindcode,'')<>''");
            dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
            //如果未查询到数据则获取全部的不良组别
            if (dt.Rows.Count == 0)
            {
                sql.Clear();
                sql.Append("select bg_code from badgroup where bg_statuscode='AUDITED'");
                dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
                badgroup.DataSource = dt;
                badgroup.DisplayMember = "bg_code";
                badgroup.ValueMember = "bg_code";
            }
            else
            {
                badgroup.DataSource = dt;
                badgroup.DisplayMember = "bg_code";
                badgroup.ValueMember = "bg_code";
                int rowCount = dt.Rows.Count;
                string bg_code = "";
                for (int i = 0; i < rowCount; i++)
                {
                    if (i == rowCount - 1)
                        bg_code += "'" + dt.Rows[i]["bg_code"] + "'";
                    else
                        bg_code += "'" + dt.Rows[i]["bg_code"] + "',";
                }
                dt = (DataTable)dh.ExecuteSql("select bc_groupcode,bc_code,bc_name from badcode where bc_groupcode in(" + (bg_code == "" ? "''" : bg_code) + ")", "select");
            }
        }

        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 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();
                }
            }
        }

        private void Cancel_Click(object sender, EventArgs e)
        {
            Close();
        }

        private void Save_Click(object sender, EventArgs e)
        {
            int RejectCount = ChoosedRejectList.Items.Count;
            string[] bccode = new string[RejectCount];
            string[] bcremark = new string[RejectCount];
            string[] bgcode = new string[RejectCount];
            string[] id = new string[RejectCount];
            string ErrorMessage = "";
            if (ChoosedRejectList.Items.Count == 0)
                MessageBox.Show("不良品必须选择不良原因和不良代码!");
            else
            {
                //用户未填写不良代码一切按照正常逻辑，填写了从index=1开始执行
                for (int i = 0; i < RejectCount; i++)
                {
                    bgcode[i] = ChoosedRejectList.Items[i].SubItems[1].Text;
                    //获取所有的不良代码
                    bccode[i] = ChoosedRejectList.Items[i].SubItems[2].Text;
                    //获取所有的不良备注
                    bcremark[i] = ChoosedRejectList.Items[i].SubItems[3].Text;
                    id[i] = dh.GetSEQ("MakeBad_seq");
                }
            }
            sql.Clear();
            sql.Append("insert when (not exists(select 1 from makebad where mb_sncode='" + sncode + "' and mb_badcode=:bc_code)) then ");
            sql.Append("into makebad(mb_id,mb_makecode,mb_mscode,mb_sncode,mb_inman,");
            sql.Append("mb_indate,mb_stepcode,mb_sourcecode,mb_badcode,mb_bgcode,mb_badtable,mb_soncode,mb_status,mb_badremark)");
            sql.Append("select :id,ma_code,ms_code,ms_sncode,'" + User.UserName + "',sysdate,'" + User.CurrentStepCode + "',ms_sourcecode,:bc_code,:bg_code,'',");
            sql.Append("sp_soncode,'0',:bc_remark from make left join makeSerial on ms_makecode=ma_code left join stepProduct on ");
            sql.Append("sp_mothercode=ma_prodcode and sp_stepcode=ms_nextstepcode where ms_sncode='" + sncode + "'");
            dh.BatchInsert(sql.GetString(), new string[] { "bg_code","id", "bg_code", "bc_code", "bc_remark" }, bgcode, id, bgcode, bccode, bcremark);
            MessageBox.Show("保存成功");
            Close();
        }

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

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