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.Runtime.InteropServices;
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
    {
        [DllImport("user32.dll")]
        public static extern bool ReleaseCapture();

        [DllImport("user32.dll")]
        public static extern bool SendMessage(IntPtr hwnd, int wMsg, int wParam, int lParam);

        [DllImport("user32.dll", EntryPoint = "GetWindowLong", CharSet = CharSet.Auto)]
        public static extern int GetWindowLong(HandleRef hWnd, int nIndex);

        [DllImport("user32.dll", EntryPoint = "SetWindowLong", CharSet = CharSet.Auto)]
        public static extern IntPtr SetWindowLong(HandleRef hWnd, int nIndex, int dwNewLong);

        public const int WM_SYSCOMMAND = 0x0112;
        public const int SC_MOVE = 0xF010;
        public const int HTCAPTION = 0x0002;
        /// <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)
        {
            this.headBar1.MouseDown += new MouseEventHandler(this.headBar_MouseDown);
            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 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||':'||bg_name 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 headBar_MouseDown(object sender, MouseEventArgs e)
        {
            ReleaseCapture();
            SendMessage(this.Handle, WM_SYSCOMMAND, SC_MOVE + HTCAPTION, 0);
        }

        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[3].Text == WaitRejectList.Items[i].SubItems[3].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[3].Text == WaitRejectList.Items[i].SubItems[3].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)
        {
            if (ms_sncode.Text == "" || ms_makecode.Text == "")
            {
                MessageBox.Show("序列号和工单号不允许为空");
                return;
            }
            int RejectCount = ChoosedRejectList.Items.Count;
            List<string> bccode = new List<string>();
            List<string> bcname = new List<string>();
            List<string> bcremark = new List<string>();
            List<string> bgcode = new List<string>();
            List<string> id = new List<string>();
            string ErrorMessage = "";
            if (ChoosedRejectList.Items.Count == 0)
                MessageBox.Show("不良品必须选择不良原因和不良代码!");
            else
            {
                //用户未填写不良代码一切按照正常逻辑，填写了从index=1开始执行
                for (int i = 0; i < RejectCount; i++)
                {
                    bgcode.Add(ChoosedRejectList.Items[i].SubItems[1].Text);
                    //获取不良代码的名称
                    bcname.Add(ChoosedRejectList.Items[i].SubItems[4].Text);
                    //获取所有的不良代码
                    bccode.Add(ChoosedRejectList.Items[i].SubItems[3].Text);
                    //获取所有的不良备注
                    bcremark.Add(ChoosedRejectList.Items[i].SubItems[5].Text);
                    id.Add(dh.GetSEQ("MakeBad_seq"));
                }
            }
            dt = (DataTable)dh.ExecuteSql("select mb_badcode from makebad where mb_sncode='" + sncode + "'", "select");
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                for (int j = 0; j < bgcode.Count; j++)
                {
                    if (dt.Rows[i][0].ToString() == bccode[j])
                    {
                        ErrorMessage += " " + bcname[j] + " ";
                        bgcode.Remove(bgcode[j]);
                        bccode.Remove(bccode[j]);
                        bcremark.Remove(bcremark[j]);
                        id.Remove(id[j]);
                    }
                }
            }
            if (ErrorMessage != "")
            {
                ErrorMessage += "重复";
                MessageBox.Show(ErrorMessage);
            }
            if (bgcode.Count > 0)
            {
                sql.Clear();
                sql.Append("insert 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 makebad_seq.nextval,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[] { "bc_code", "bg_code", "bc_remark" }, bccode.ToArray(), bgcode.ToArray(), bcremark.ToArray());
                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,bg_name,bc_code,bc_name,bc_note from badcode left join badgroup on bc_groupcode=bg_code where bc_groupcode='" + badgroup.Text.Split(':')[0] + "' 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();
        }
    }
}