Wms_Winform/NXWMS/Forms/Instock/frmInstockChild/frmChildRetreatTray.cs

using ComponentFactory.Krypton.Toolkit;
using NXWMS.Client.FrmCustom;
using NXWMS.Client.Model.AppModels.Result.Balance;
using NXWMS.Client.Model.AppModels.Result.Common;
using NXWMS.Client.Model.AppModels.Result.Instock;
using NXWMS.Client.Model.CoreModels;
using NXWMS.Services;
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.Text.RegularExpressions;
using System.Web.UI.WebControls;
using System.Windows.Forms;
using static NXWMS.Client.FrmCustom.CustomEventMsg;

namespace NXWMS.Forms.Instock.frmInstockChild
{
    /// <summary>
    /// 退料组盘操作窗体
    /// </summary>
    public partial class frmChildRetreatTray : KryptonForm
    {
        /// <summary>
        /// 窗体构造函数
        /// </summary>
        public frmChildRetreatTray()
        {
            InitializeComponent();
        }

        #region 全局变量
        /// <summary>
        /// 退料单主键ID
        /// </summary>
        public string RetreatId { get; set; }
        /// <summary>
        /// 退料单号
        /// </summary>
        public string RetreatNo { get; set; }
        /// <summary>
        /// 数据库中的退料单所有数据（包括主、明细表）。
        /// </summary>
        private WmsInRetreatResult RetreatDataNotEdit = new WmsInRetreatResult();
        [DllImport("user32.dll")]
        public static extern int MessageBoxTimeoutA(IntPtr hWnd, string msg, string Caps, int type, int Id, int time);//引用DLL
        #endregion


        #region 初始化数据
        /// <summary>
        /// 窗体加载事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void frmChildRetreatTray_Load(object sender, EventArgs e)
        {
            ktb_RetreatNo.Text = RetreatNo;
            ktb_RetreatNo.Enabled = false;
            InitDataGridViewColumn();
            ktb_PalletNo.Focus();
        }
        /// <summary> 
        /// 初始化DataGridView列信息
        /// </summary>
        private void InitDataGridViewColumn()
        {
            DataGridViewColumn column1 = new KryptonDataGridViewTextBoxColumn();
            column1.HeaderText = "序号";
            column1.Width = 50;
            column1.ReadOnly = true;
            kdgv_RetreatTrayDtlData.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_RetreatTrayDtlData.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_RetreatTrayDtlData.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_RetreatTrayDtlData.Columns.Add(column);

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

            column1 = new KryptonDataGridViewTextBoxColumn();
            column1.HeaderText = "退料单明细未组盘数量";
            column1.Width = 130;
            kdgv_RetreatTrayDtlData.Columns.Add(column1);

            column1 = new KryptonDataGridViewTextBoxColumn();
            column1.HeaderText = "组盘明细数量";
            column1.Width = 100;
            kdgv_RetreatTrayDtlData.Columns.Add(column1);

            DataGridViewComboBoxColumn cmb_Unit = new DataGridViewComboBoxColumn();
            cmb_Unit.HeaderText = "单位";
            cmb_Unit.Width = 70;
            //目前写死下拉列表的数据项，后续改为后台获取
            cmb_Unit.Items.AddRange(new ListItem[]
            {
                new ListItem{ Value = "kg",Text = "千克"},
                new ListItem{ Value = "ge",Text = "个"},
                new ListItem{ Value = "pkg",Text = "箱"}
            });
            cmb_Unit.DisplayStyle = DataGridViewComboBoxDisplayStyle.Nothing;
            kdgv_RetreatTrayDtlData.Columns.Add(cmb_Unit);

            DataGridViewComboBoxColumn cmb_Supplier = new DataGridViewComboBoxColumn();
            cmb_Supplier.HeaderText = "供应商";
            cmb_Supplier.Width = 120;
            //目前写死下拉列表的数据项，后续改为后台获取
            cmb_Supplier.Items.AddRange(new ListItem[]
            {
                 new ListItem{ Value ="WX_NXZB_001" ,Text = "无锡南兴装备"},
                 new ListItem{ Value ="WX_NXZB_002" ,Text = "东莞南兴装备"}
            });
            cmb_Supplier.DisplayStyle = DataGridViewComboBoxDisplayStyle.Nothing;
            kdgv_RetreatTrayDtlData.Columns.Add(cmb_Supplier);

            column1 = new KryptonDataGridViewTextBoxColumn();
            column1.HeaderText = "包装";
            column1.Width = 80;
            kdgv_RetreatTrayDtlData.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_RetreatTrayDtlData.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_RetreatTrayDtlData.Columns.Add(column_ExpTime);

            column1 = new KryptonDataGridViewTextBoxColumn();
            column1.HeaderText = "";
            column1.Width = 30;
            column1.Visible = false;
            kdgv_RetreatTrayDtlData.Columns.Add(column1);

            column1 = new KryptonDataGridViewTextBoxColumn();
            column1.HeaderText = "退料明细数量";
            column1.Width = 30;
            column1.Visible = false;
            kdgv_RetreatTrayDtlData.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);
            if (string.IsNullOrEmpty(this.RetreatId))
            {
                var result = WmsInstockService.materielMsgForAddArrivalService.GetMaterielMsgForAddArrival();
                if (result.Status == OperateStatus.Success)
                {
                    foreach (MaterielMsgForAddArrivalResult item in result.Data)
                    {
                        DataRow dr = dt.NewRow();
                        dr["物料编码"] = item.MATERIEL_CODE;
                        dr["物料名称"] = item.MATERIEL_NAME;
                        dr["物料条码"] = item.MATERIEL_BARCODE;
                        dr["物料类型编码"] = item.MATERIEL_TYPE_CODE;
                        dr["物料类型名称"] = item.MATERIEL_TYPE_NAME;
                        dr["退料单明细ID"] = 0;
                        dt.Rows.Add(dr);
                    }
                    RetreatDataNotEdit = new WmsInRetreatResult();
                }
            }
            else
            {
                var result = WmsInstockService.wmsInRetreatService.GetWmsInRetreatDtlListForId(new WmsInRetreatResult { RETREAT_ID = Convert.ToInt32(this.RetreatId), REMARKS1 = "查询未组盘完成的退料单明细" });
                if (result.Status == OperateStatus.Success)
                {
                    foreach (WmsInRetreatDtlResult item in result.Data.WmsInRetreatDtlList)
                    {
                        DataRow dr = dt.NewRow();
                        dr["物料编码"] = item.MATERIEL_CODE;
                        dr["物料名称"] = item.MATERIEL_NAME;
                        dr["物料条码"] = item.MATERIEL_BARCODE;
                        dr["物料类型编码"] = item.MATERIEL_TYPE_CODE;
                        dr["物料类型名称"] = item.MATERIEL_TYPE_NAME;
                        dr["退料单明细ID"] = item.RETREAT_DTL_ID;
                        dt.Rows.Add(dr);
                    }
                    RetreatDataNotEdit = result.Data;
                }
            }
            return dt;
        }
        #endregion

        #region 按钮事件
        /// <summary>
        /// 取消按钮事件
        /// 关闭窗体
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnCancel_Click(object sender, EventArgs e)
        {
            this.Close();
        }
        /// <summary>
        /// 确认按钮事件
        /// 提交组盘数据
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnConfirm_Click(object sender, EventArgs e)
        {
            /*
             * ToDo：后续增加验证托盘号是否合法的代码。
             */

            if(string.IsNullOrEmpty(ktb_PalletNo.Text))
            {
                KryptonMessageBox.Show("请输入或扫描托盘号！");
                return;
            }
            WmsStkTrayResult wmsStkTrayResult = new WmsStkTrayResult();
            wmsStkTrayResult.PALLET_CODE = ktb_PalletNo.Text.Trim();
            wmsStkTrayResult.TRAYS_TYPE = 2;
            wmsStkTrayResult.TRAY_LOADED_TYPE = 1;
            wmsStkTrayResult.TRAY_STATUS = 0;
            wmsStkTrayResult.CREATE_BY = AppConfig.UserLoginResult.UserInfo.UserId;
            wmsStkTrayResult.UPDATE_BY = AppConfig.UserLoginResult.UserInfo.UserId;
            List<WmsStkTrayDtlResult> wmsStkTrayDtlList = new List<WmsStkTrayDtlResult>();
            if (kdgv_RetreatTrayDtlData.Rows.Count > 0 && !kdgv_RetreatTrayDtlData.Rows[0].IsNewRow)
            {
                foreach (DataGridViewRow dvr in kdgv_RetreatTrayDtlData.Rows)
                {
                    if (!dvr.IsNewRow)
                    {
                        #region 校验每一行数据的完整性
                        string RowCheckMsg = string.Empty;
                        if (!CheckDataGridViewRowFormat(dvr, ref RowCheckMsg))
                        {
                            KryptonMessageBox.Show(RowCheckMsg);
                            return;
                        }
                        #endregion
                        int retreatDtlId = Convert.ToInt32(dvr.Cells[12].Value);

                        WmsStkTrayDtlResult trayDtlMd = new WmsStkTrayDtlResult();
                        WmsStkTrayDtlExtResult trayDtlExtMd = new WmsStkTrayDtlExtResult();
                        WmsInRetreatRecordResult retreatRecordMd = new WmsInRetreatRecordResult();
                        WmsInRetreatDtlResult retreatDtlMd = RetreatDataNotEdit.WmsInRetreatDtlList.Find(x => x.RETREAT_DTL_ID == retreatDtlId);

                        string materielCode = dvr.Cells[1].Value.ToString();
                        string materielName = dvr.Cells[2].Value.ToString();
                        string materielBarcode = dvr.Cells[3].Value == null ? null : dvr.Cells[3].Value.ToString();
                        string batchNo = dvr.Cells[4].Value == null ? null : dvr.Cells[4].Value.ToString();
                        decimal retreatDtlQty = dvr.Cells[13].Value == null ? 0 : Convert.ToDecimal(dvr.Cells[13].Value.ToString());
                        decimal trayDtlQty = Convert.ToDecimal(dvr.Cells[6].Value);
                        string unitCode = GetComboBoxItem((DataGridViewComboBoxCell)dvr.Cells[7]).Value;
                        string supplierCode = GetComboBoxItem((DataGridViewComboBoxCell)dvr.Cells[8]).Value;
                        string supplierName = GetComboBoxItem((DataGridViewComboBoxCell)dvr.Cells[8]).Text;
                        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);

                        trayDtlMd.MATERIEL_CODE = materielCode;
                        trayDtlMd.MATERIEL_NAME = materielName;
                        trayDtlMd.MATERIEL_BARCODE = materielBarcode;
                        trayDtlMd.QTY = trayDtlQty;
                        trayDtlMd.TRAY_DTL_STATUS = 0;
                        trayDtlMd.CREATE_BY = AppConfig.UserLoginResult.UserInfo.UserId;
                        trayDtlMd.UPDATE_BY = AppConfig.UserLoginResult.UserInfo.UserId;

                        trayDtlExtMd.MATERIEL_SPEC = retreatDtlMd.MATERIEL_SPEC;
                        trayDtlExtMd.PACKAGE_CODE = packageCode;
                        trayDtlExtMd.UNIT_CODE = unitCode;
                        trayDtlExtMd.BATCH_NO = batchNo;
                        trayDtlExtMd.SUPPLIER_CODE = supplierCode;
                        trayDtlExtMd.SUPPLIER_NAME = supplierName;
                        trayDtlExtMd.PRODUCT_DATE = productTime;
                        trayDtlExtMd.EXP_DATE = expTime;
                        trayDtlExtMd.INSPECTION_RESULT = retreatDtlMd.INSPECTION_RESULT;
                        trayDtlExtMd.LOCK_FLAG = 0;
                        trayDtlExtMd.MIN_PKG_QTY = 0;
                        trayDtlExtMd.ECTEND_TIME_LEN = 0;
                        trayDtlExtMd.ITEM_STATUS = retreatDtlMd.ITEM_STATUS;
                        trayDtlExtMd.CREATE_BY = AppConfig.UserLoginResult.UserInfo.UserId;
                        trayDtlExtMd.UPDATE_BY = AppConfig.UserLoginResult.UserInfo.UserId;

                        retreatRecordMd.RETREAT_DTL_ID = retreatDtlMd.RETREAT_DTL_ID;
                        retreatRecordMd.RETREAT_ID = Convert.ToInt32(RetreatId);
                        retreatRecordMd.RETREAT_NO = RetreatNo;
                        retreatRecordMd.SOURCE_NO = RetreatDataNotEdit.SOUCE_NO;
                        retreatRecordMd.REGION_CODE = "";
                        retreatRecordMd.REGION_NAME = "";
                        retreatRecordMd.BIN_CODE = "";
                        retreatRecordMd.BIN_NAME = "";
                        retreatRecordMd.PALLET_CODE = ktb_PalletNo.Text.Trim();
                        retreatRecordMd.RETREAT_TIME = RetreatDataNotEdit.RETREAT_TIME;
                        retreatRecordMd.RETREATER = RetreatDataNotEdit.RETREATER;
                        retreatRecordMd.MATERIEL_CODE = materielCode;
                        retreatRecordMd.MATERIEL_NAME = materielName;
                        retreatRecordMd.MATERIEL_BARCODE = materielBarcode;
                        retreatRecordMd.MATERIEL_SPEC = retreatDtlMd.MATERIEL_SPEC;
                        retreatRecordMd.SUPPLIER_CODE = supplierCode;
                        retreatRecordMd.SUPPLIER_NAME = supplierName;
                        retreatRecordMd.PACKAGE_CODE = packageCode;
                        retreatRecordMd.UNIT_CODE = unitCode;
                        retreatRecordMd.BATCH_NO = batchNo;
                        retreatRecordMd.PRODUCT_DATE = productTime;
                        retreatRecordMd.EXP_DATE = expTime;
                        retreatRecordMd.INSPECTION_RESULT = retreatDtlMd.INSPECTION_RESULT;
                        retreatRecordMd.ITEM_STATUS = retreatDtlMd.ITEM_STATUS;
                        retreatRecordMd.RETREAT_QTY = trayDtlQty;
                        retreatRecordMd.RETREAT_RECORD_STATUS = 0;
                        retreatRecordMd.CREATE_BY = AppConfig.UserLoginResult.UserInfo.UserId;
                        retreatRecordMd.UPDATE_BY = AppConfig.UserLoginResult.UserInfo.UserId;

                        trayDtlMd.WmsStkTrayDtlExtMd = trayDtlExtMd;
                        trayDtlMd.WmsInRetreatRecord = retreatRecordMd;
                        wmsStkTrayDtlList.Add(trayDtlMd);
                    }
                }
                wmsStkTrayResult.WmsStkTrayDtlList = wmsStkTrayDtlList;
                #region 校验明细行 不能存在相同批次、物料条码的数据行
                var strList = wmsStkTrayDtlList.GroupBy(x => new { x.MATERIEL_CODE, x.WmsStkTrayDtlExtMd.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
                var result = WmsInstockService.wmsInRetreatService.AddWmsInRetreatTrayData(wmsStkTrayResult);
                if (result.Status == OperateStatus.Success)
                {
                    MessageBoxTimeoutA(this.Handle, result.Message, "提示", 0, 0, 1000);
                    frmWmsInRetreat.RefreshFrmHost();
                    kdgv_RetreatTrayDtlData.Columns.Clear();
                    InitDataGridViewColumn();
                    ktb_PalletNo.Text = "";
                }
                else
                {
                    KryptonMessageBox.Show(result.Message);
                }
            }
            else
            {
                KryptonMessageBox.Show("请添加退料组盘明细数据！");
            }
        }
        /// <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[6].Value == null)
            {
                OutMssg = $"第【{dvr.Index + 1}】行未输入退料明细数量！";
                return false;
            }
            else
            {
                if (!Regex.IsMatch(dvr.Cells[6].Value.ToString(), @"([1-9]\d*(\.\d*[1-9])?)"))
                {
                    OutMssg = $"第【{dvr.Index + 1}】行输入的组盘明细数量不是合法的数字类型，请检查！";
                    return false;
                }
                else
                {
                    if (!string.IsNullOrEmpty(ktb_RetreatNo.Text))
                    {
                        decimal trayDtlQty = Convert.ToDecimal(dvr.Cells[6].Value);
                        decimal rexeiptDtlQty_NoTray = Convert.ToDecimal(dvr.Cells[5].Value);
                        if (trayDtlQty > rexeiptDtlQty_NoTray)
                        {
                            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;
        }
        private ListItem GetComboBoxItem(DataGridViewComboBoxCell dataGridViewComboBoxCell, string value)
        {
            foreach (var item in dataGridViewComboBoxCell.Items)
            {
                if (((ListItem)item).Value == value)
                {
                    return (ListItem)item;
                }
            }
            return new ListItem();
        }

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

        #region DataGridView 相关事件
        /// <summary>
        /// 编辑单元格控件时触发的事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void kdgv_RetreatTrayDtlData_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>
        /// 悬浮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;
                WmsInRetreatDtlResult mdRecDtl = new WmsInRetreatDtlResult();
                int retreatDtlId = Convert.ToInt32(dataRow["退料单明细ID"].ToString().Trim());
                mdRecDtl = RetreatDataNotEdit.WmsInRetreatDtlList.Find(x => x.RETREAT_DTL_ID == retreatDtlId);
                kdgv_RetreatTrayDtlData.Rows[e.RowIndex].Cells[1].Value = dataRow["物料编码"].ToString().Trim();
                kdgv_RetreatTrayDtlData.Rows[e.RowIndex].Cells[2].Value = dataRow["物料名称"].ToString().Trim();
                kdgv_RetreatTrayDtlData.Rows[e.RowIndex].Cells[3].Value = dataRow["物料条码"].ToString().Trim();
                kdgv_RetreatTrayDtlData.Rows[e.RowIndex].Cells[4].Value = mdRecDtl.BATCH_NO;
                kdgv_RetreatTrayDtlData.Rows[e.RowIndex].Cells[5].Value = mdRecDtl.RETREAT_QTY - mdRecDtl.RETREAT_TRAY_QTY;
                ListItem unitLstItm = GetComboBoxItem((DataGridViewComboBoxCell)kdgv_RetreatTrayDtlData.Rows[e.RowIndex].Cells[7], mdRecDtl.UNIT_CODE);
                kdgv_RetreatTrayDtlData.Rows[e.RowIndex].Cells[7].Value = unitLstItm;
                ListItem supplierLstItm = GetComboBoxItem((DataGridViewComboBoxCell)kdgv_RetreatTrayDtlData.Rows[e.RowIndex].Cells[8], mdRecDtl.SUPPLIER_CODE);
                kdgv_RetreatTrayDtlData.Rows[e.RowIndex].Cells[8].Value = supplierLstItm;
                kdgv_RetreatTrayDtlData.Rows[e.RowIndex].Cells[9].Value = mdRecDtl.PACKAGE_CODE;
                kdgv_RetreatTrayDtlData.Rows[e.RowIndex].Cells[10].Value = mdRecDtl.PRODUCT_DATE;
                kdgv_RetreatTrayDtlData.Rows[e.RowIndex].Cells[11].Value = mdRecDtl.EXP_DATE;
                kdgv_RetreatTrayDtlData.Rows[e.RowIndex].Cells[13].Value = mdRecDtl.RETREAT_QTY;
                kdgv_RetreatTrayDtlData.Rows[e.RowIndex].Cells[12].Value = dataRow["退料单明细ID"].ToString().Trim();
                kdgv_RetreatTrayDtlData.CurrentCell = this.kdgv_RetreatTrayDtlData[e.ColumnIndex, e.RowIndex + 1];
            }
            catch (Exception ex)
            {
                KryptonMessageBox.Show(ex.Message);
            }
        }
        private ListItem GetComboBoxItem(DataGridViewComboBoxCell dataGridViewComboBoxCell)
        {
            foreach (var item in dataGridViewComboBoxCell.Items)
            {
                if (((ListItem)item).Text == dataGridViewComboBoxCell.Value.ToString())
                {
                    return (ListItem)item;
                }
            }
            return new ListItem();
        }

        private void kdgv_RetreatTrayDtlData_DataError(object sender, DataGridViewDataErrorEventArgs e)
        {

        }

        #endregion

        #region 鼠标右键单击事件
        private void 删除选中行ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            if (!kdgv_RetreatTrayDtlData.CurrentRow.IsNewRow)
            {
                DataGridViewRow item = kdgv_RetreatTrayDtlData.CurrentCell.OwningRow;
                decimal currCellTrayQty = item.Cells[6].Value == null ? 0 : Convert.ToDecimal(item.Cells[6].Value);
                int currCellRecDtlId = item.Cells[13].Value == null ? 0 : Convert.ToInt32(item.Cells[13].Value);
                if (currCellTrayQty > 0)
                {
                    WmsInRetreatDtlResult recDtlMd = RetreatDataNotEdit.WmsInRetreatDtlList.Find(x => x.RETREAT_DTL_ID == currCellRecDtlId);
                    RetreatDataNotEdit.WmsInRetreatDtlList.Find(x => x.RETREAT_DTL_ID == currCellRecDtlId).RETREAT_TRAY_QTY = recDtlMd.RETREAT_TRAY_QTY - currCellTrayQty;
                }
                kdgv_RetreatTrayDtlData.Rows.Remove(kdgv_RetreatTrayDtlData.CurrentCell.OwningRow);
                foreach (DataGridViewRow item1 in kdgv_RetreatTrayDtlData.Rows)
                {
                    int index = item1.Index;
                    kdgv_RetreatTrayDtlData.Rows[index].Cells[0].Value = index + 1;
                }
            }
        }

        private void 全部删除ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            foreach (DataGridViewRow item in kdgv_RetreatTrayDtlData.Rows)
            {
                decimal currCellTrayQty = item.Cells[6].Value == null ? 0 : Convert.ToDecimal(item.Cells[6].Value);
                int currCellRecDtlId = item.Cells[13].Value == null ? 0 : Convert.ToInt32(item.Cells[13].Value);
                if (currCellTrayQty > 0)
                {
                    WmsInRetreatDtlResult recDtlMd = RetreatDataNotEdit.WmsInRetreatDtlList.Find(x => x.RETREAT_DTL_ID == currCellRecDtlId);
                    RetreatDataNotEdit.WmsInRetreatDtlList.Find(x => x.RETREAT_DTL_ID == currCellRecDtlId).RETREAT_TRAY_QTY = recDtlMd.RETREAT_TRAY_QTY - currCellTrayQty;
                }
            }
            kdgv_RetreatTrayDtlData.Rows.Clear();
        }
        #endregion
    }
}