Wms_Winform/NXWMS/Forms/Inspection/frmInspectionChild/frmChildEditWmsQaInspection.cs

using ComponentFactory.Krypton.Toolkit;
using NXWMS.Client.FrmCustom;
using NXWMS.Client.Model.AppModels.Condition.Common;
using NXWMS.Client.Model.AppModels.Result.Common;
using NXWMS.Client.Model.AppModels.Result.Inspection;
using NXWMS.Client.Model.AppModels.Result.Instock;
using NXWMS.Client.Model.CoreModels;
using NXWMS.Commons;
using NXWMS.Services;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Text.RegularExpressions;
using System.Web.UI.WebControls;
using System.Windows.Forms;
using static NXWMS.Client.FrmCustom.CustomEventMsg;

namespace NXWMS.Forms.Inspection.frmInspectionChild
{
    /// <summary>
    /// 编辑质检单窗体类
    /// </summary>
    public partial class frmChildEditWmsQaInspection : KryptonForm
    {
        /// <summary>
        /// 窗体构造函数
        /// </summary>
        public frmChildEditWmsQaInspection()
        {
            InitializeComponent();
        }

        #region 全局变量
        /// <summary>
        /// 质检单主键ID
        /// </summary>
        public string InspectionId { get; set; }
        /// <summary>
        /// 数据库中的质检单所有数据（包括主、明细表）。
        /// 未进行编辑过。
        /// </summary>
        private WmsQaInspectionResult InspectionDataNotEdit = new WmsQaInspectionResult();
        List<WmsInArrivalDtlResult> lstReceiptDtl = new List<WmsInArrivalDtlResult>();
        #endregion

        #region 初始化数据
        /// <summary>
        /// 窗体加载函数
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void frmChildEditWmsQaInspection_Load(object sender, EventArgs e)
        {
            InitComboBoxItemData();
            InitDataGridViewColumn();
            kdtp_InspectionTime.Checked = false;
            LoadWmsQaInspectionDtlData();
        }
        /// <summary>
        /// 初始化下拉列表数据
        /// </summary>
        private void InitComboBoxItemData()
        {
            /*
             ToDo：后续把下拉列表转为 后台获取数据，目前是写死的。
             */
            List<BasDictionaryResult> results = new List<BasDictionaryResult>();
            #region 质检单类型
            results = BasDictionaryUtil.basDictionaryResultLst.FindAll(x => x.DICTIONARY_CODE == "InspectionTypeDesc");
            if (results.Count > 0)
            {
                kcmb_InspectionType.Items.Clear();
                foreach (var item in results)
                {
                    kcmb_InspectionType.Items.Add(new ListItem
                    {
                        Value = item.DICTIONARY_ITEM_CODE,
                        Text = item.DICTIONARY_ITEM_NAME,
                    });
                }
                kcmb_InspectionType.SelectedIndex = 0;
            }
            else
            {
                KryptonMessageBox.Show("未找到质检单类型的字典项数据！");
            }
            #endregion

            #region 质检方式
            results = BasDictionaryUtil.basDictionaryResultLst.FindAll(x => x.DICTIONARY_CODE == "InspectionWayDesc");
            if (results.Count > 0)
            {
                kcmb_InspectionWay.Items.Clear();
                foreach (var item in results)
                {
                    kcmb_InspectionWay.Items.Add(new ListItem
                    {
                        Value = item.DICTIONARY_ITEM_CODE,
                        Text = item.DICTIONARY_ITEM_NAME,
                    });
                }
                kcmb_InspectionWay.SelectedIndex = 0;
            }
            else
            {
                KryptonMessageBox.Show("未找到质检方式的字典项数据！");
            }
            #endregion
        }
        /// <summary> 
        /// 初始化DataGridView列信息
        /// </summary>
        private void InitDataGridViewColumn()
        {
            DataGridViewColumn column1 = new KryptonDataGridViewTextBoxColumn();
            column1.HeaderText = "序号";
            column1.Width = 50;
            column1.ReadOnly = true;
            //column1.
            kdgv_InspectionDtlData.Columns.Add(column1);

            DataTable dt = CreateTable();

            DataGridViewColumn column = new DataGridViewDataWindowColumn();
            (column as DataGridViewDataWindowColumn).SDisplayField = "到货通知单号,物料编码,物料名称,物料条码,批次号";
            (column as DataGridViewDataWindowColumn).SDisplayMember = "到货通知单号";
            (column as DataGridViewDataWindowColumn).SKeyWords = "到货通知单号";
            (column as DataGridViewDataWindowColumn).DataSource = dt;
            column.Width = 150;
            column.HeaderText = "到货通知单号";
            kdgv_InspectionDtlData.Columns.Add(column);

            column = new DataGridViewDataWindowColumn();
            (column as DataGridViewDataWindowColumn).SDisplayField = "到货通知单号,物料编码,物料名称,物料条码,批次号";
            (column as DataGridViewDataWindowColumn).SDisplayMember = "物料编码";
            (column as DataGridViewDataWindowColumn).SKeyWords = "物料编码";
            (column as DataGridViewDataWindowColumn).DataSource = dt;
            column.HeaderText = "物料编码";
            column.Width = 200;
            kdgv_InspectionDtlData.Columns.Add(column);

            column = new DataGridViewDataWindowColumn();
            (column as DataGridViewDataWindowColumn).SDisplayField = "到货通知单号,物料编码,物料名称,物料条码,批次号";
            (column as DataGridViewDataWindowColumn).SDisplayMember = "物料名称";
            (column as DataGridViewDataWindowColumn).SKeyWords = "物料名称";
            (column as DataGridViewDataWindowColumn).DataSource = dt;
            column.HeaderText = "物料名称";
            column.Width = 200;
            kdgv_InspectionDtlData.Columns.Add(column);

            column = new DataGridViewDataWindowColumn();
            (column as DataGridViewDataWindowColumn).SDisplayField = "到货通知单号,物料编码,物料名称,物料条码,批次号";
            (column as DataGridViewDataWindowColumn).SDisplayMember = "物料条码";
            (column as DataGridViewDataWindowColumn).SKeyWords = "物料条码";
            (column as DataGridViewDataWindowColumn).DataSource = dt;
            column.HeaderText = "物料条码";
            column.Width = 150;
            kdgv_InspectionDtlData.Columns.Add(column);

            DataGridViewComboBoxColumn cmb_Unit = new DataGridViewComboBoxColumn();
            cmb_Unit.HeaderText = "质检结果";
            cmb_Unit.Width = 90;
            //目前写死下拉列表的数据项，后续改为后台获取
            cmb_Unit.Items.AddRange(new ListItem[]
            {
                new ListItem{ Value = "Wait",Text = "待检"},
                new ListItem{ Value = "OK",Text = "合格"},
                new ListItem{ Value = "NG",Text = "不合格"}
            });
            cmb_Unit.DisplayStyle = DataGridViewComboBoxDisplayStyle.Nothing;
            kdgv_InspectionDtlData.Columns.Add(cmb_Unit);

            column1 = new KryptonDataGridViewTextBoxColumn();
            column1.HeaderText = "批次号";
            column1.Width = 120;
            kdgv_InspectionDtlData.Columns.Add(column1);

            column1 = new KryptonDataGridViewTextBoxColumn();
            column1.HeaderText = "单位";
            column1.Width = 70;
            kdgv_InspectionDtlData.Columns.Add(column1);

            column1 = new KryptonDataGridViewTextBoxColumn();
            column1.HeaderText = "供应商";
            column1.Width = 120;
            kdgv_InspectionDtlData.Columns.Add(column1); 

            column1 = new KryptonDataGridViewTextBoxColumn();
            column1.HeaderText = "包装";
            column1.Width = 80;
            kdgv_InspectionDtlData.Columns.Add(column1);

            KryptonDataGridViewDateTimePickerColumn column_ProductTime = new KryptonDataGridViewDateTimePickerColumn();
            column_ProductTime.HeaderText = "生产日期";
            column_ProductTime.Width = 160;
            column_ProductTime.Format = DateTimePickerFormat.Custom;
            column_ProductTime.CustomFormat = "yyyy-MM-dd HH:mm:ss";
            kdgv_InspectionDtlData.Columns.Add(column_ProductTime);

            KryptonDataGridViewDateTimePickerColumn column_ExpTime = new KryptonDataGridViewDateTimePickerColumn();
            column_ExpTime.HeaderText = "失效日期";
            column_ExpTime.Width = 160;
            column_ExpTime.Format = DateTimePickerFormat.Custom;
            column_ExpTime.CustomFormat = "yyyy-MM-dd HH:mm:ss";
            kdgv_InspectionDtlData.Columns.Add(column_ExpTime);

            column1 = new KryptonDataGridViewTextBoxColumn();
            column1.HeaderText = "到货通知单明细ID";
            column1.Width = 30;
            column1.Visible = false;
            kdgv_InspectionDtlData.Columns.Add(column1);
        }
        /// <summary>
        /// 创建数据源表格
        /// </summary>
        /// <returns></returns>
        private DataTable CreateTable()
        {
            DataTable dt = new DataTable(); 
            DataColumn dc = new DataColumn("到货通知单号");
            dt.Columns.Add(dc);
            dc = new DataColumn("物料编码");
            dt.Columns.Add(dc);
            dc = new DataColumn("物料名称");
            dt.Columns.Add(dc);
            dc = new DataColumn("物料条码");
            dt.Columns.Add(dc);
            dc = new DataColumn("批次号");
            dt.Columns.Add(dc);
            dc = new DataColumn("到货通知单明细ID");
            dt.Columns.Add(dc);
            //var result = WmsInstockService.wmsInReceiptService.GetAllWaitForQaReceiptDtlData();
            var result = WmsInstockService.wmsInArrivalService.GetAllWaitForQaArrivalDtlData();
            if (result.Status == OperateStatus.Success)
            {
                foreach (WmsInArrivalDtlResult item in result.Data)
                {
                    DataRow dr = dt.NewRow();
                    dr["到货通知单号"] = item.ARRIVAL_NO;
                    dr["物料编码"] = item.MATERIEL_CODE;
                    dr["物料名称"] = item.MATERIEL_NAME;
                    dr["物料条码"] = item.MATERIEL_BARCODE;
                    dr["批次号"] = item.BATCH_NO;
                    dr["到货通知单明细ID"] = item.ARRIVAL_DTL_ID;
                    dt.Rows.Add(dr);
                }
                lstReceiptDtl = result.Data;
            }
            return dt;
        }
        /// <summary>
        /// 调用服务端接口，请求质检单明细表数据
        /// </summary>
        /// <returns></returns>
        private string LoadWmsQaInspectionDtlData()
        {
            var result = WmsInspectionService.wmsQaInspectionService.GetWmsQaInspectionDtlListForId(new WmsQaInspectionResult { INSPECTION_ID = Convert.ToInt32(this.InspectionId) });
            if (result.Status == OperateStatus.Success)
            {
                ktb_InspectionNo.Text = result.Data.INSPECTION_NO;
                ktb_InspectionNo.Enabled = false;
                ktb_InspectionUser.Text = result.Data.INSPECTION_USER;
                ktb_InspectionUser.Enabled = false;
                kcmb_InspectionType.Text = result.Data.INSPECTION_TYPE_NAME;
                kcmb_InspectionType.Enabled = false;
                kcmb_InspectionWay.Text = result.Data.INSPECTION_WAY_NAME;
                kcmb_InspectionWay.Enabled = false;
                ktb_Describe.Text = result.Data.DESCRIBE;
                if (result.Data.INSPECTION_TIME != new DateTime())
                {
                    kdtp_InspectionTime.Value = result.Data.INSPECTION_TIME;
                }
                InspectionDataNotEdit = result.Data;

                kdgv_InspectionDtlData.Rows.Clear();

                foreach (WmsQaInspectionDtlResult item in result.Data.WmsQaInspectionDtlList)
                {
                    int index = kdgv_InspectionDtlData.Rows.Add();
                    kdgv_InspectionDtlData.Rows[index].Cells[0].Value = index + 1;
                    kdgv_InspectionDtlData.Rows[index].Cells[1].Value = item.BILL_NO;
                    kdgv_InspectionDtlData.Rows[index].Cells[2].Value = item.MATERIEL_CODE;
                    kdgv_InspectionDtlData.Rows[index].Cells[3].Value = item.MATERIEL_NAME;
                    kdgv_InspectionDtlData.Rows[index].Cells[4].Value = item.MATERIEL_BARCODE;
                    ListItem inspectionResultLstItm = GetComboBoxItem((DataGridViewComboBoxCell)kdgv_InspectionDtlData.Rows[index].Cells[5], item.INSPECTION_RESULT);
                    kdgv_InspectionDtlData.Rows[index].Cells[5].Value = inspectionResultLstItm;
                    kdgv_InspectionDtlData.Rows[index].Cells[6].Value = item.BATCH_NO;
                    kdgv_InspectionDtlData.Rows[index].Cells[7].Value = item.UNIT_CODE;
                    kdgv_InspectionDtlData.Rows[index].Cells[8].Value = item.SUPPLIER_NAME;
                    kdgv_InspectionDtlData.Rows[index].Cells[9].Value = item.PACKAGE_CODE;
                    kdgv_InspectionDtlData.Rows[index].Cells[10].Value = item.PRODUCT_DATE;
                    kdgv_InspectionDtlData.Rows[index].Cells[11].Value = item.EXP_DATE;
                    kdgv_InspectionDtlData.Rows[index].Cells[12].Value = item.BILL_DTL_ID;
                }
                return string.Empty;
            }
            else
            {
                return result.Message;
            }
        }
        #endregion

        #region 按钮事件
        /// <summary>
        /// 确认按钮事件
        /// 提交编辑完成的质检单数据
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnConfirm_Click(object sender, EventArgs e)
        {
            WmsQaInspectionResult mdInspection = new WmsQaInspectionResult();
            mdInspection.INSPECTION_ID = InspectionDataNotEdit.INSPECTION_ID;
            mdInspection.INSPECTION_NO = InspectionDataNotEdit.INSPECTION_NO;
            mdInspection.INSPECTION_TYPE = Convert.ToInt32(((ListItem)kcmb_InspectionType.SelectedItem).Value);
            mdInspection.INSPECTION_USER = ktb_InspectionUser.Text;
            mdInspection.INSPECTION_WAY = Convert.ToInt32(((ListItem)kcmb_InspectionType.SelectedItem).Value);
            if (kdtp_InspectionTime.Checked)
            {
                mdInspection.INSPECTION_TIME = kdtp_InspectionTime.Value;
            }
            else
            {
                mdInspection.INSPECTION_TIME = new DateTime();
            }
            mdInspection.INSPECTION_STATUS = InspectionDataNotEdit.INSPECTION_STATUS;
            mdInspection.DESCRIBE = ktb_Describe.Text.Trim();
            mdInspection.CREATE_BY = AppConfig.UserLoginResult.UserInfo.UserId;
            mdInspection.UPDATE_BY = AppConfig.UserLoginResult.UserInfo.UserId;
            List<WmsQaInspectionDtlResult> mdInspectionDtlList = new List<WmsQaInspectionDtlResult>();
            if (kdgv_InspectionDtlData.Rows.Count > 0 && !kdgv_InspectionDtlData.Rows[0].IsNewRow)
            {
                foreach (DataGridViewRow dvr in kdgv_InspectionDtlData.Rows)
                {
                    if (!dvr.IsNewRow)
                    {
                        #region 校验每一行数据的完整性
                        string RowCheckMsg = string.Empty;
                        if (!CheckDataGridViewRowFormat(dvr, ref RowCheckMsg))
                        {
                            KryptonMessageBox.Show(RowCheckMsg);
                            return;
                        }
                        #endregion
                        string receiptNo = dvr.Cells[1].Value.ToString();
                        string materielCode = dvr.Cells[2].Value.ToString();
                        string materielName = dvr.Cells[3].Value.ToString();
                        string materielBarcode = dvr.Cells[4].Value == null ? null : dvr.Cells[4].Value.ToString(); 
                        string inspectionResult = GetComboBoxItem((DataGridViewComboBoxCell)dvr.Cells[5]).Value;
                        string batchNo = dvr.Cells[6].Value == null ? null : dvr.Cells[6].Value.ToString();
                        string unitCode = dvr.Cells[7].Value == null ? null : dvr.Cells[7].Value.ToString();
                        string supplierCode = dvr.Cells[8].Value == null ? null : dvr.Cells[8].Value.ToString();
                        string packageCode = dvr.Cells[9].Value == null ? null : dvr.Cells[9].Value.ToString();
                        DateTime productTime = Convert.ToDateTime(dvr.Cells[10].Value);
                        DateTime expTime = Convert.ToDateTime(dvr.Cells[11].Value);
                        int billDtlId = dvr.Cells[12].Value == null ? 0 : Convert.ToInt32(dvr.Cells[12].Value);
                        WmsInArrivalDtlResult mdResult = lstReceiptDtl.Find(x => x.ARRIVAL_DTL_ID == billDtlId);
                        WmsQaInspectionDtlResult mdQaResult = InspectionDataNotEdit.WmsQaInspectionDtlList.Find(y => y.BILL_DTL_ID == billDtlId);
                        mdInspectionDtlList.Add(new WmsQaInspectionDtlResult
                        {
                            BILL_NO = mdResult.ARRIVAL_NO,
                            BILL_DTL_ID = billDtlId,
                            MATERIEL_CODE = materielCode,
                            MATERIEL_NAME = materielName,
                            MATERIEL_BARCODE = materielBarcode,
                            BATCH_NO = batchNo,
                            UNIT_CODE = unitCode,
                            SUPPLIER_CODE = mdResult.SUPPLIER_CODE,
                            SUPPLIER_NAME = mdResult.SUPPLIER_NAME,
                            PACKAGE_CODE = packageCode,
                            PRODUCT_DATE = productTime,
                            EXP_DATE = expTime,
                            INSPECTION_RESULT = inspectionResult,
                            ITEM_STATUS = mdResult.ITEM_STATUS,
                            INSPECTION_DTL_STATUS = mdQaResult.INSPECTION_DTL_STATUS,
                            CREATE_BY = AppConfig.UserLoginResult.UserInfo.UserId,
                            UPDATE_BY = AppConfig.UserLoginResult.UserInfo.UserId,
                            DESCRIBE = null
                        });
                    }
                }

                #region 校验明细行 不能存在相同批次、物料条码的数据行
                var strList = mdInspectionDtlList.GroupBy(x => new { x.MATERIEL_CODE, x.BATCH_NO }).Select(x => new { Key = x.Count(), MATERIEL_CODE = x.Key.MATERIEL_CODE, BATCH_NO = x.Key.BATCH_NO }).ToList();
                foreach (var item in strList)
                {
                    if (item.Key > 1)
                    {
                        KryptonMessageBox.Show($"相同的物料：【{item.MATERIEL_CODE}】,批次号：【{item.BATCH_NO}】只能添加一行数据，请修正输入数据行！");
                        return;
                    }
                }
                #endregion

                List<WmsQaInspectionDtlResult> finalInspectionDtlList = new List<WmsQaInspectionDtlResult>();
                foreach (WmsQaInspectionDtlResult itemOld in InspectionDataNotEdit.WmsQaInspectionDtlList)
                {
                    WmsQaInspectionDtlResult arrDtlNew = mdInspectionDtlList.Find(x => x.BILL_DTL_ID == itemOld.BILL_DTL_ID);
                    if (arrDtlNew != null)
                    {
                        arrDtlNew.INSPECTION_DTL_STATUS = itemOld.INSPECTION_DTL_STATUS;
                        arrDtlNew.REMARKS1 = "更新";

                        finalInspectionDtlList.Add(arrDtlNew);
                    }
                    else
                    {
                        itemOld.INSPECTION_DTL_STATUS = (int)InspectionStatus.已删除;
                        itemOld.REMARKS1 = "删除";
                        finalInspectionDtlList.Add(itemOld);
                    }
                }
                foreach (WmsQaInspectionDtlResult itemNew in mdInspectionDtlList)
                {
                    WmsQaInspectionDtlResult qaDtlOld= InspectionDataNotEdit.WmsQaInspectionDtlList.Find(x => x.BILL_DTL_ID == itemNew.BILL_DTL_ID);

                    if (qaDtlOld == null)
                    {
                        itemNew.REMARKS1 = "添加";
                        finalInspectionDtlList.Add(itemNew);
                    }
                }
                mdInspection.WmsQaInspectionDtlList = finalInspectionDtlList;
                var result = WmsInspectionService.wmsQaInspectionService.EditWmsQaInspectionData(mdInspection);
                if (result.Status == OperateStatus.Success)
                {
                    KryptonMessageBox.Show(result.Message);
                    frmWmsQaInspection.RefreshFrmHost();
                    this.Close();
                }
                else
                {
                    KryptonMessageBox.Show(result.Message);
                }
            }
            else
            {
                DialogResult dr = KryptonMessageBox.Show("由于明细为空，确定要删除质检单所有数据吗？", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
                if (dr == DialogResult.OK)
                {
                    var result = WmsInspectionService.wmsQaInspectionService.DeleteWmsQaInspectionData(new WmsQaInspectionResult { INSPECTION_NO = InspectionDataNotEdit.INSPECTION_ID.ToString(), UPDATE_BY = AppConfig.UserLoginResult.UserInfo.UserId });
                    if (result.Status == OperateStatus.Success)
                    {
                        KryptonMessageBox.Show(result.Message);
                        frmWmsQaInspection.RefreshFrmHost();
                        this.Close();
                    }
                    else
                    {
                        KryptonMessageBox.Show(result.Message);
                    }
                }
            }
        }
        /// <summary>
        /// 校验DataGridView输入行数据的正确性
        /// </summary>
        /// <param name="dvr">DataGridView输入行</param>
        /// <param name="OutMssg">校验结果信息</param>
        /// <returns></returns>
        private bool CheckDataGridViewRowFormat(DataGridViewRow dvr, ref string OutMssg)
        {
            if (dvr.Cells[1].Value == null)
            {
                OutMssg = $"第【{dvr.Index + 1}】行未输入物料编码！";
                return false;
            }
            if (dvr.Cells[2].Value == null)
            {
                OutMssg = $"第【{dvr.Index + 1}】行未输入物料编码！";
                return false;
            }
            if (dvr.Cells[3].Value == null)
            {
                OutMssg = $"第【{dvr.Index + 1}】行未输入物料名称！";
                return false;
            }
            if (dvr.Cells[5].Value == null)
            {
                OutMssg = $"第【{dvr.Index + 1}】行未选择质检结果！";
                return false;
            }
            if (dvr.Cells[7].Value == null)
            {
                OutMssg = $"第【{dvr.Index + 1}】行未选择单位信息！";
                return false;
            }
            if (dvr.Cells[8].Value == null)
            {
                OutMssg = $"第【{dvr.Index + 1}】行未选择供应商信息！";
                return false;
            }
            if (dvr.Cells[10].Value == null)
            {
                OutMssg = $"第【{dvr.Index + 1}】行未输入生产日期！";
                return false;
            }
            if (dvr.Cells[11].Value == null)
            {
                OutMssg = $"第【{dvr.Index + 1}】行未输入失效日期！";
                return false;
            }
            if (DateTime.Compare(Convert.ToDateTime(dvr.Cells[10].Value), Convert.ToDateTime(dvr.Cells[11].Value)) >= 0)
            {
                OutMssg = $"第【{dvr.Index + 1}】行未输入的生产日期大于失效日期，不符合实际情况，请重新输入！";
                return false;
            }
            OutMssg = "校验成功！";
            return true;
        }
        /// <summary>
        /// 取消按钮事件
        /// 退出编辑页面
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnCancel_Click(object sender, EventArgs e)
        {
            this.Close();
        }
        private ListItem GetComboBoxItem(DataGridViewComboBoxCell dataGridViewComboBoxCell)
        {
            foreach (var item in dataGridViewComboBoxCell.Items)
            {
                if (dataGridViewComboBoxCell.Value == null)
                {
                    return (ListItem)item;
                }
                if (((ListItem)item).Text == dataGridViewComboBoxCell.Value.ToString())
                {
                    return (ListItem)item;
                }
            }
            return new ListItem();
        }
        private ListItem GetComboBoxItem(DataGridViewComboBoxCell dataGridViewComboBoxCell, string value)
        {
            foreach (var item in dataGridViewComboBoxCell.Items)
            {
                if (((ListItem)item).Value == value)
                {
                    return (ListItem)item;
                }
            }
            return new ListItem();
        }
        #endregion

        #region DataGridView相关事件
        /// <summary>
        /// 编辑单元格控件时触发的事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void kdgv_InspectionDtlData_EditingControlShowing(object sender, DataGridViewEditingControlShowingEventArgs e)
        {
            if (e.Control is DataGridViewOfComoBoxCustom)
            {
                (e.Control as DataGridViewOfComoBoxCustom).AfterSelector -= new AfterSelectorEventHandler(SalePageAddOrEditForm_AfterSelector);
                (e.Control as DataGridViewOfComoBoxCustom).AfterSelector += new AfterSelectorEventHandler(SalePageAddOrEditForm_AfterSelector);
            }

        }
        /// <summary>
        /// 针对ComboBox下拉列表的DataGridView数据列单元格。
        /// 由于DataGridView的ComboBox列的Item至使用的是KeyValue形式的ListItem，
        /// 并且单元格刚开始进入编辑的时候，value值为null。如果后续不选择下拉列表的值，就切换编辑的单元格，就会触发DataError事件，警告数据格式错误。
        /// 所以单元格刚开始进入编辑的时候。需要设定一个默认值。默认值的类型为ListItem。一般设定为下拉列表值集合的第一个值。
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void kdgv_InspectionDtlData_CellBeginEdit(object sender, DataGridViewCellCancelEventArgs e)
        {
            int rowIndex = e.RowIndex;
            int columnIndex = e.ColumnIndex;
            if (kdgv_InspectionDtlData.Rows[rowIndex].Cells[columnIndex] is DataGridViewComboBoxCell)
            {
                if (kdgv_InspectionDtlData.Rows[rowIndex].Cells[columnIndex].Value == null)
                {
                    DataGridViewComboBoxCell dataGridViewComboBoxCell = (DataGridViewComboBoxCell)kdgv_InspectionDtlData.Rows[rowIndex].Cells[columnIndex];
                    ListItem tstlst = (ListItem)dataGridViewComboBoxCell.Items[0];
                    kdgv_InspectionDtlData.Rows[rowIndex].Cells[columnIndex].Value = tstlst;
                }
            }
        }
        /// <summary>
        /// 针对ComboBox下拉列表的DataGridView数据列单元格。
        /// 由于DataGridView的ComboBox列的Item至使用的是KeyValue形式的ListItem，
        /// 所以单元格结束编辑的时候。需要给单元格设定一个类型为ListItem的值。
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void kdgv_InspectionDtlData_CellEndEdit(object sender, DataGridViewCellEventArgs e)
        {
            int rowIndex = e.RowIndex;
            int columnIndex = e.ColumnIndex;
            if (kdgv_InspectionDtlData.Rows[rowIndex].Cells[columnIndex] is DataGridViewComboBoxCell)
            {
                ListItem tstlst = GetComboBoxItem((DataGridViewComboBoxCell)kdgv_InspectionDtlData.Rows[rowIndex].Cells[columnIndex]);
                kdgv_InspectionDtlData.Rows[rowIndex].Cells[columnIndex].Value = tstlst;
            }
        }
        /// <summary>
        /// 悬浮datagridview数据窗体，行选择后事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void SalePageAddOrEditForm_AfterSelector(object sender, AfterSelectorEventArgs e)
        {
            try
            {
                DataGridViewRow row = e.Value as DataGridViewRow;
                DataRowView dataRow = row.DataBoundItem as DataRowView;
                int receiptDtlId = Convert.ToInt32(dataRow["到货通知单明细ID"].ToString().Trim());
                WmsInArrivalDtlResult receiptDtlResult = lstReceiptDtl.Find(x => x.ARRIVAL_DTL_ID == receiptDtlId);
                kdgv_InspectionDtlData.Rows[e.RowIndex].Cells[1].Value = dataRow["到货通知单号"].ToString().Trim();
                kdgv_InspectionDtlData.Rows[e.RowIndex].Cells[2].Value = dataRow["物料编码"].ToString().Trim();
                kdgv_InspectionDtlData.Rows[e.RowIndex].Cells[3].Value = dataRow["物料名称"].ToString().Trim();
                kdgv_InspectionDtlData.Rows[e.RowIndex].Cells[4].Value = dataRow["物料条码"].ToString().Trim();
                ListItem inspectionResultLstItm = GetComboBoxItem((DataGridViewComboBoxCell)kdgv_InspectionDtlData.Rows[e.RowIndex].Cells[5], receiptDtlResult.INSPECTION_RESULT);
                kdgv_InspectionDtlData.Rows[e.RowIndex].Cells[6].Value = receiptDtlResult.BATCH_NO;
                kdgv_InspectionDtlData.Rows[e.RowIndex].Cells[7].Value = receiptDtlResult.UNIT_CODE;
                kdgv_InspectionDtlData.Rows[e.RowIndex].Cells[8].Value = receiptDtlResult.SUPPLIER_NAME;
                kdgv_InspectionDtlData.Rows[e.RowIndex].Cells[9].Value = receiptDtlResult.PACKAGE_CODE;
                kdgv_InspectionDtlData.Rows[e.RowIndex].Cells[10].Value = receiptDtlResult.PRODUCT_DATE;
                kdgv_InspectionDtlData.Rows[e.RowIndex].Cells[11].Value = receiptDtlResult.EXP_DATE;
                kdgv_InspectionDtlData.Rows[e.RowIndex].Cells[12].Value = receiptDtlResult.ARRIVAL_DTL_ID;
                kdgv_InspectionDtlData.CurrentCell = this.kdgv_InspectionDtlData[e.ColumnIndex, e.RowIndex + 1];
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
        private void kdgv_InspectionDtlData_DataError(object sender, DataGridViewDataErrorEventArgs e)
        {

        }

        private void kdgv_InspectionDtlData_RowsAdded(object sender, DataGridViewRowsAddedEventArgs e)
        {
            int index = kdgv_InspectionDtlData.Rows.Count;
            kdgv_InspectionDtlData.Rows[index - 1].Cells[0].Value = index;
        }
        #endregion

        #region 鼠标右键单击事件
        /// <summary>
        /// 删除选中行事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void 删除选中行ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            kdgv_InspectionDtlData.Rows.Remove(kdgv_InspectionDtlData.CurrentCell.OwningRow);
            foreach (DataGridViewRow item in kdgv_InspectionDtlData.Rows)
            {
                int index = item.Index;
                kdgv_InspectionDtlData.Rows[index].Cells[0].Value = index + 1;
            }
        }
        /// <summary>
        /// 删除全部行事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void 全部删除ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            kdgv_InspectionDtlData.Rows.Clear();
        }
        /// <summary>
        /// 重新加载正在编辑的质检单明细数据
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void 重新加载ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            var loadfrm = new frmLoading();
            loadfrm.Show();
            var message = loadfrm.EventCalExec(LoadWmsQaInspectionDtlData);
            if (!string.IsNullOrWhiteSpace(message))
            {
                KryptonMessageBox.Show($"查询失败!\r\n{message}", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
        }
        #endregion

    }
}