mes-client/UAS-MES/FunctionCode/OQC/OQC_Inspection.cs

using System;
using System.Collections.Generic;
using System.Data;
using System.Text;
using System.Drawing;
using System.Windows.Forms;
using UAS_MES.CustomControl.DataGrid_View;
using UAS_MES.DataOperate;
using UAS_MES.Entity;
using UAS_MES.PublicMethod;

namespace UAS_MES.OQC
{
    public partial class OQC_Inspection : Form
    {
        AutoSizeFormClass asc = new AutoSizeFormClass();
        DataHelper dh;
        LogStringBuilder sql = new LogStringBuilder();
        DataTable dt;
        //用来存放已打开过的行
        List<DataGridViewRow> dgvr = new List<DataGridViewRow>();
        public OQC_Inspection()
        {
            InitializeComponent();
        }

        private void 生成送检批_Load(object sender, EventArgs e)
        {
            asc.controllInitializeSize(this);
            dh = new DataHelper();
            //工单号放大镜配置
            ma_code.TableName = "make";
            ma_code.SelectField = "ma_code # 工单号,ma_prodcode # 产品编号";
            ma_code.FormName = Name;
            ma_code.SetValueField = new string[] { "ma_code", "ma_prodcode" };
            ma_code.Condition = "ma_statuscode='STARTED'";
        }

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

        private void NewBatch_Click(object sender, EventArgs e)
        {
            string ob_id = dh.GetSEQ("OQCBatch_SEQ");
            string checkno = dh.GetSerialNumberByCaller("OQC!Inspection");
            sql.Append("insert into OQCBatch (ob_id, ob_checkno ,ob_status, ob_source,ob_indate,ob_checkman) ");
            sql.Append("values( '" + ob_id + "','" + checkno + "', 'ENTERING', '新增', sysdate, '" + User.UserName + "')");
            dh.ExecuteSql(sql.GetString(), "insert");
            sql.Clear();
            //记录操作日志
            LogicHandler.InsertMessageLog(User.UserName, "生成新批", "成功", "", "");
            //生成成功，将批次号，以及批次状态写入页面
            BaseUtil.SetFormValue(Controls, dh.getFieldsDataByCondition("OQCBatch", new string[] { "ob_checkno", "ob_status" }, "ob_id='" + ob_id + "'"));
        }

        private void 生成送检批_SizeChanged(object sender, EventArgs e)
        {
            asc.controlAutoSize(this);
        }

        private void bi_outboxcode_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            {
                //只允许用户操作在录入状态的箱号
                if (ob_status.Text == "在录入")
                {
                    //如果勾选了撤销
                    if (WithDraw.Checked)
                    {
                        dt = (DataTable)dh.ExecuteSql("select obd_obid from OQCBatchDetail where obd_outboxcode='" + pa_outboxcode.Text + "'", "select");
                        if (dt.Rows.Count > 0)
                        {
                            dh.ExecuteSql("delete from OQCBatchDetail where obd_outboxcode='" + pa_outboxcode.Text + "'", "delete");
                            dh.UpdateByCondition("OQCBatch", "ob_batchqty =(select count(1) from OQCBatchDetail where obd_obid=" + dt.Rows[0]["obd_obid"] + ")", "ob_id=" + dt.Rows[0]["obd_obid"]);
                            dh.UpdateByCondition("OQCBatch", "ob_prodcode=''", "ob_batchqty=0");
                            GetBatch.PerformClick();
                            OperateResult.AppendText(">>箱号已从送检批中移除\n", Color.Green);
                        }
                        else
                            OperateResult.AppendText(">>箱号不在抽检明细中\n", Color.Red);
                    }
                    //未勾选撤销
                    else
                    {
                        dt = (DataTable)dh.ExecuteSql("select pa_prodcode from package where pa_outboxcode='" + pa_outboxcode.Text + "'", "select");
                        if (dt.Rows.Count > 0)
                        {
                            string pa_prodcode = dt.Rows[0]["pa_prodcode"].ToString();
                            if (dt.Rows[0]["pa_prodcode"].ToString() == ma_prodcode.Text || ma_prodcode.Text == "")
                            {
                                dt = dh.getFieldsDataByCondition("OQCBatchDetail", new string[] { "obd_checkno" }, "obd_outboxcode='" + pa_outboxcode.Text + "'");
                                //如果不存在送检批中
                                if (dt.Rows.Count == 0)
                                {
                                    if (ma_prodcode.Text == "")
                                    {
                                        dh.UpdateByCondition("Oqcbatch", "ob_prodcode='" + pa_prodcode + "'", "ob_checkno='" + ob_checkno.Text + "'");
                                    }
                                    sql.Clear();
                                    sql.Append("insert into OQCBatchDetail (obd_id,obd_obid,obd_checkno, obd_sncode,obd_outboxcode,");
                                    sql.Append("obd_makecode, obd_builddate) select OQCBatchDetail_seq.nextval,(select ob_id from OQCBatch where ob_checkno='" + ob_checkno.Text + "'),'" + ob_checkno.Text + "',v_barcode");
                                    sql.Append(",v_outboxcode,v_makecode,sysdate from MES_PACKAGE_VIEW where v_outboxcode='" + pa_outboxcode.Text + "'");
                                    dh.ExecuteSql(sql.GetString(), "insert");
                                    string obd_id = dh.getFieldDataByCondition("OQCBatchDetail", "obd_id", "obd_outboxcode='" + pa_outboxcode.Text + "'").ToString();
                                    dh.UpdateByCondition("OQCBatch", "ob_batchqty =(select count(1) from OQCBatchDetail where obd_obid=" + obd_id + ")", "ob_id=" + obd_id);
                                    dh.UpdateByCondition("makeserial", "ms_checkno='" + ob_checkno.Text + "'", "exists (select 1 from OQCBatchDetail where obd_obid ='" + obd_id + "' and obd_makecode = ms_makecode and  ms_sncode = obd_sncode)");
                                    GetBatch.PerformClick();
                                    OperateResult.AppendText(">>箱号成功维护到送检批\n", Color.Green);
                                }
                                //存在则进行提示
                                else
                                    OperateResult.AppendText(">>箱号已存在送检批" + dt.Rows[0]["obd_checkno"] + "中\n", Color.Red);
                            }
                            else if (ma_prodcode.Text == "")
                            {
                            }
                            else
                                OperateResult.AppendText(">>箱内产品与抽检批次产品不一致\n", Color.Red);
                        }
                        else
                            OperateResult.AppendText(">>箱号" + pa_outboxcode.Text + "不存在\n", Color.Red);
                    }
                }
                else
                    OperateResult.AppendText(">>只允许在录入状态的抽检批才允许操作\n", Color.Red);
            }
        }

        private void GetBatch_Click(object sender, EventArgs e)
        {
            string ErrorMessage = "";
            DataTable[] dt = LogicHandler.GetOQCBatch(ms_sncode.Text, obd_outboxcode.Text, ob_checkno.Text, "OQCSendCheck", out ErrorMessage);
            if (ErrorMessage == "")
            {
                BaseUtil.SetFormValue(Controls, dt[0]);
                BaseUtil.FillExpandDgvWithDataTable(CheckBatchDGV, dt[1], true);
            }
            else
                OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red);
        }

        private void dataGridViewExpand1_DataError(object sender, DataGridViewDataErrorEventArgs e)
        {

        }

        private void CheckBatchDGV_RowHeaderMouseClick(object sender, DataGridViewCellMouseEventArgs e)
        {
            if (!dgvr.Contains(CheckBatchDGV.Rows[e.RowIndex]))
            {
                string obd_outboxcode = CheckBatchDGV.Rows[e.RowIndex].Cells["obd_outboxcode_dgv"].Value.ToString();
                DataTable dt = (DataTable)dh.ExecuteSql("select obd_sncode from OQCBatchDetail where obd_checkno='" + ob_checkno.Text + "' and obd_outboxcode='" + obd_outboxcode + "'", "select");

                DataGridViewRow headerRow = new DataGridViewRow();

                DataGridViewTextBoxCell cell = new DataGridViewTextBoxCell();
                cell.Value = "";
                headerRow.Cells.Add(cell);

                cell = new DataGridViewTextBoxCell();
                cell.Value = "产品序列号";
                headerRow.Cells.Add(cell);
                CollapseDataGridViewRow cl = (CollapseDataGridViewRow)(CheckBatchDGV.Rows[e.RowIndex]);
                cl.Rows.Add(headerRow);

                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    DataGridViewRow dataRow = new DataGridViewRow();
                    DataGridViewCheckBoxCell checkcell = new DataGridViewCheckBoxCell();
                    dataRow.Cells.Add(checkcell);
                    DataGridViewTextBoxCell textcell = new DataGridViewTextBoxCell();
                    textcell.Value = dt.Rows[i]["obd_sncode"].ToString();
                    dataRow.Cells.Add(textcell);
                    cl.Rows.Add(dataRow);
                }
                dgvr.Add(CheckBatchDGV.Rows[e.RowIndex]);
            }
        }
        /// <summary>
        /// 勾选了之后默认勾选上所有的明细
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void CheckBatchDGV_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
            if (e.ColumnIndex == 0 && e.RowIndex >= 0)
            {
                if (CheckBatchDGV.Rows[e.RowIndex] is CollapseDataGridViewRow)
                {
                    int CollapseRowCount = (CheckBatchDGV.Rows[e.RowIndex] as CollapseDataGridViewRow).Rows.Count;
                    if (CollapseRowCount > 0)
                    {
                        for (int i = (e.RowIndex + 2); i < (e.RowIndex + 1 + CollapseRowCount); i++)
                        {
                            CheckBatchDGV.Rows[i].Cells[0].Value = CheckBatchDGV.Rows[e.RowIndex].Cells[0].EditedFormattedValue;
                        }
                    }
                }
            }
        }
        /// <summary>
        /// 全选Grid中的数据，对展开时包含明细也进行了判断
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ChooseAll_Click(object sender, EventArgs e)
        {
            for (int i = 0; i < CheckBatchDGV.Rows.Count; i++)
            {
                if (CheckBatchDGV.Rows[i].Cells[0] is DataGridViewCheckBoxCell)
                {
                    if (CheckBatchDGV.Rows[i].Cells[0].Value == null || (bool)CheckBatchDGV.Rows[i].Cells[0].Value == false)
                    {
                        CheckBatchDGV.Rows[i].Cells[0].Value = true;
                    }
                    else
                    {
                        CheckBatchDGV.Rows[i].Cells[0].Value = false;
                    }
                }
            }
        }

        private void RemoveAll_Click(object sender, EventArgs e)
        {
            DataTable dt = (DataTable)dh.ExecuteSql("select ob_status,ob_source from OQCBatch where ob_checkno='" + ob_checkno.Text + "'", "select");
            if (dt.Rows.Count > 0)
            {
                if (dt.Rows[0]["ob_status"].ToString() == "ENTERING")
                {
                    List<string> DeleteID = new List<string>();
                    //判断有多少勾选了
                    for (int i = 0; i < CheckBatchDGV.Rows.Count; i++)
                    {
                        DeleteID.Add(CheckBatchDGV.Rows[i].Cells["obd_id"].Value.ToString());
                    }
                    if (DeleteID.Count > 0)
                    {
                        //删除全部明细
                        dh.DeleteDataByID("OQCBatchDetail", "obd_id", DeleteID.ToArray());
                        dh.UpdateByCondition("OQCBatch", "ob_batchqty=0，ob_prodcode=''", "ob_checkno='" + ob_checkno.Text + "'");
                        GetBatch.PerformClick();
                        OperateResult.AppendText(">>已全部移除\n", Color.Green);
                    }
                }
                else OperateResult.AppendText(">>只允许移除在录入状态的抽检品的单号\n", Color.Red);
            }
            else OperateResult.AppendText(">>抽检批次号不存在\n", Color.Red);
        }

        /// <summary>
        /// 删除当前的单据
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void Delete_Click(object sender, EventArgs e)
        {
            if (dh.CheckExist("OQCBatch", "ob_checkno='" + ob_checkno.Text + "'") && ob_status.Text == "在录入")
            {
                dh.ExecuteSql("delete from OQCBatch where ob_checkno='" + ob_checkno.Text + "'", "delete");
                dh.ExecuteSql("delete from OQCBatchDetail where obd_checkno='" + ob_checkno.Text + "'", "delete");
                OperateResult.AppendText(">>抽检批次" + ob_checkno.Text + "已删除\n", Color.Green);
                BaseUtil.CleanForm(this);
            }
            else
                OperateResult.AppendText(">>抽检批次不存在或者单据状态不是在录入\n", Color.Red);
        }

        /// <summary>
        /// 送检按钮
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void SendOQC_Click(object sender, EventArgs e)
        {
            if (dh.CheckExist("OQCBatch", "ob_checkno='" + ob_checkno.Text + "'") && ob_status.Text == "在录入")
                dh.UpdateByCondition("OQCBatch", "ob_status='UNCHECK'", "ob_checkno='" + ob_checkno.Text + "'");
        }

        private void ob_checkno_TextChanged(object sender, EventArgs e)
        {
            if (ob_checkno.Text != "")
                SendOQC.Enabled = true;
        }

        private void ob_checkno_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
                GetBatch.PerformClick();
        }

        private void obd_outboxcode_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
                GetBatch.PerformClick();
        }
    }
}