using ComponentFactory.Krypton.Toolkit; using NXWMS.Client.Code.Extends; using NXWMS.Client.Model.AppModels.Condition; using NXWMS.Client.Model.AppModels.Condition.Base; using NXWMS.Client.Model.AppModels.Condition.Common; using NXWMS.Client.Model.AppModels.Condition.Instock; using NXWMS.Client.Model.AppModels.Result; using NXWMS.Client.Model.AppModels.Result.Base; using NXWMS.Client.Model.AppModels.Result.Common; using NXWMS.Client.Model.AppModels.Result.Instock; using NXWMS.Client.Model.CoreModels; using NXWMS.Commons; using NXWMS.Forms.Instock.frmInstockChild; 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; namespace NXWMS.Forms.Instock { /// /// 收货单窗体 /// public partial class frmWmsInReceipt : KryptonForm { /// /// 窗体构造函数 /// public frmWmsInReceipt() { InitializeComponent(); // 获取窗体的全类名 _CrrentClassName = System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.FullName; } #region 全局变量 /// /// 客户端字段排序列表(收货单主表) /// private List _clientFieldOrderList; /// /// 客户端字段排序列表(收货单单明细表) /// private List _clientFieldOrderDtlList; /// /// 当前窗体类名 /// private string _CrrentClassName; /// /// 收货单主键ID,用于记录主表选中行的主键信息。 /// 目前由于 加载控件不能传递具有参数的函数,所以临时使用全局变量。 /// ToDo:后续修改优化加载控件的实现方式,支持传递具有参数的函数。 /// 孙亚龙 舍弃于2020年9月7日 /// //string ReceiptId = string.Empty; /// /// 用于控制明细表数据的加载时机。 /// 由于主表DataGridView数据加载时,会默认触发选中项更改事件。这时候加载明细表数据会发生异常。 /// 使用全局变量,控制明细表的数据的加载时机,只能在主表数据全部初始化完成后,并且选中了一行主表数据的时候。 /// bool isControlReceiptDtlShow = false; /// /// 定义委托 /// 用于执行刷新页面数据的函数 /// public delegate void dlgRefreshFrmHost(); /// /// 定义委托变量 /// 用于绑定刷新页面数据的函数 /// public static dlgRefreshFrmHost RefreshFrmHost; #endregion #region 初始化数据 /// /// 窗体加载事件 /// /// /// private void frmWmsInReceipt_Load(object sender, EventArgs e) { #region 获取主、明细表的显示列信息 //获取收货单主表数据源配置 var result = ConfigServices.configService.GetDataViewOrderList(new ClientFieldOrderCondition { SourceCode = $"{_CrrentClassName}" }); if (result.Status == OperateStatus.Success) { _clientFieldOrderList = result.Data; } //获取收货单明细表表数据源配置 var resultDtl = ConfigServices.configService.GetDataViewOrderList(new ClientFieldOrderCondition { SourceCode = $"{_CrrentClassName}_Dtl" }); if (resultDtl.Status == OperateStatus.Success) { _clientFieldOrderDtlList = resultDtl.Data; } #endregion InitComboBoxItemData(); kdtp_startCreateTime.Value = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd 00:00:00")); kdtp_endCreateTime.Value = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd 23:59:59")); kdtp_startCreateTime.Checked = false; kdtp_endCreateTime.Checked = false; kdtp_startProcudtTime.Value = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd 00:00:00")); kdtp_endProcudtTime.Value = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd 23:59:59")); kdtp_startProcudtTime.Checked = false; kdtp_endProcudtTime.Checked = false; kdtp_startExpTime.Value = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd 00:00:00")); kdtp_endExptTime.Value = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd 23:59:59")); kdtp_startExpTime.Checked = false; kdtp_endExptTime.Checked = false; RefreshFrmHost = new dlgRefreshFrmHost(RefreshReceiptSearchData); } /// /// 初始化下拉列表数据 /// private void InitComboBoxItemData() { /* ToDo:后续把下拉列表转为 后台获取数据,目前是写死的。1:WMS人工创建;2:到货通知单导入;3:手持端创建;4:接口导入;5:Excel导入。 */ List results = new List(); #region 单据类型 results = BasDictionaryUtil.basDictionaryResultLst.FindAll(x => x.DICTIONARY_CODE == "ReceiptTypeDesc"); if (results.Count > 0) { kcmb_receiptType.Items.Clear(); kcmb_receiptType.Items.Add(new ListItem { Value = "", Text = "请选择", }); foreach (var item in results) { kcmb_receiptType.Items.Add(new ListItem { Value = item.DICTIONARY_ITEM_CODE, Text = item.DICTIONARY_ITEM_NAME, }); } kcmb_receiptType.SelectedIndex = 0; } else { KryptonMessageBox.Show("未找到收货单类型的字典项数据!"); } #endregion #region 单据状态 results = BasDictionaryUtil.basDictionaryResultLst.FindAll(x => x.DICTIONARY_CODE == "ReceiptOrderStatusDesc"); if (results.Count > 0) { kcmb_receiptStatus.Items.Clear(); kcmb_receiptStatus.Items.Add(new ListItem { Value = "", Text = "请选择", }); foreach (var item in results) { kcmb_receiptStatus.Items.Add(new ListItem { Value = item.DICTIONARY_ITEM_CODE, Text = item.DICTIONARY_ITEM_NAME, }); } kcmb_receiptStatus.SelectedIndex = 0; } else { KryptonMessageBox.Show("未找到收货单状态的字典项数据!"); } #endregion #region 供应商信息 var result = BaseServices.supplierService.GetList(new SupplierSearchCondition { IsUsed = true, PageIndex = 1, PageSize = 10000 }); if (result.Status == OperateStatus.Success) { kcmb_supplierMsg.Items.Clear(); kcmb_supplierMsg.Items.Add(new ListItem { Value = "", Text = "请选择", }); foreach (SupplierResult item in result.Data.RowData.ToList()) { kcmb_supplierMsg.Items.Add(new ListItem { Value = item.SUPPLIER_CODE, Text = item.SUPPLIER_NAME, }); } kcmb_supplierMsg.SelectedIndex = 0; } else { kcmb_supplierMsg.Items.Clear(); KryptonMessageBox.Show(result.Message); } #endregion } #endregion #region 查询收货单数据 /// /// 查询收货单数据 /// /// /// private void kbtnSearch_Click(object sender, EventArgs e) { var loadfrm = new frmLoading(); loadfrm.Show(); var message = loadfrm.EventCalExec(LoadWmsInReceiptData); } /// /// 刷新到货通知单的查询数据 /// private void RefreshReceiptSearchData() { var loadfrm = new frmLoading(); loadfrm.Show(); var message = loadfrm.EventCalExec(LoadWmsInReceiptData); if (!string.IsNullOrWhiteSpace(message)) { KryptonMessageBox.Show($"查询失败!\r\n{message}", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information); } } /// /// 调用服务端接口,请求收货单主表数据 /// /// private string LoadWmsInReceiptData() { var result = WmsInstockService.wmsInReceiptService.GetWmsInReceiptListForPage(new WmsInReceiptSearchMd { ReceiptNoMsg = ktb_receiptNo.Text, ArrivalNoMsg = ktb_arrivalNo.Text, ReceipterMsg = ktb_receipterMsg.Text, MaterielMsg = ktb_materialMsg.Text, BatchNoMsg = ktb_batchNoMsg.Text, ReceiptType = ((ListItem)kcmb_receiptType.SelectedItem).Value, ReceiptStatus = ((ListItem)kcmb_receiptStatus.SelectedItem).Value, SupplierMsg = ((ListItem)kcmb_supplierMsg.SelectedItem).Value, StartCreateTime = kdtp_startCreateTime.Checked ? kdtp_startCreateTime.Value.ToString() : null, EndCreateTime = kdtp_endCreateTime.Checked ? kdtp_endCreateTime.Value.ToString() : null, StartProductTime = kdtp_startProcudtTime.Checked ? kdtp_startProcudtTime.Value.ToString() : null, EndProductTime = kdtp_endProcudtTime.Checked ? kdtp_endProcudtTime.Value.ToString() : null, StartExpTime = kdtp_startExpTime.Checked ? kdtp_startExpTime.Value.ToString() : null, EndExpTime = kdtp_endExptTime.Checked ? kdtp_endExptTime.Value.ToString() : null, PageNum = pageToolbar1.PageIndex, EveryPageQty = pageToolbar1.PageSize }); if (result.Status == OperateStatus.Success) { kdgv_WmsInReceipt.Columns.Clear(); kdgv_WmsInReceiptDtl.DataSource = null; //ReceiptId = string.Empty; isControlReceiptDtlShow = false; kdgv_WmsInReceipt.DataSource = result.Data; kdgv_WmsInReceipt.BuildDataGridView(_clientFieldOrderList.GetFieldOrderDic()); kdgv_WmsInReceipt.ClearSelection(); isControlReceiptDtlShow = true; SetStatusCellBackColor(kdgv_WmsInReceipt, "RECEIPT_STATUS_NAME"); #region 分页赋值 pageToolbar1.DataCount = result.DataCount; #endregion ktb_receiptNo.Focus(); return string.Empty; } else { ktb_receiptNo.Focus(); return result.Message; } } #endregion #region 查询收货单明细表数据 /// /// 收货单主表选中行事件 /// /// /// private void kdgv_WmsInReceipt_SelectionChanged(object sender, EventArgs e) { if (kdgv_WmsInReceipt.SelectedRows.Count > 0 && isControlReceiptDtlShow) { //ReceiptId = kdgv_WmsInReceipt.SelectedRows[0].Cells[1].Value.ToString(); int mainTableId = Convert.ToInt32(kdgv_WmsInReceipt.SelectedRows[0].Cells[1].Value); var loadfrm = new frmLoading(); loadfrm.Show(); var message = loadfrm.EventCalExecExt1(LoadWmsInReceiptDtlData, mainTableId); if (!string.IsNullOrWhiteSpace(message)) { KryptonMessageBox.Show($"查询失败!\r\n{message}", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } /// /// 调用服务端接口,请求到货通知单明细表数据 /// /// private string LoadWmsInReceiptDtlData(int mainTableId) { //if (string.IsNullOrEmpty(ReceiptId)) //{ // return "请选择记录!"; //} var result = WmsInstockService.wmsInReceiptService.GetWmsInReceiptDtlListForId(new WmsInReceiptResult { RECEIPT_ID = Convert.ToInt32(mainTableId), REMARKS1 = "查询已删除明细数据" }); if (result.Status == OperateStatus.Success) { kdgv_WmsInReceiptDtl.Columns.Clear(); kdgv_WmsInReceiptDtl.DataSource = result.Data.WmsInReceiptDtlList; kdgv_WmsInReceiptDtl.BuildDataGridView(_clientFieldOrderDtlList.GetFieldOrderDic(), true, false); kdgv_WmsInReceiptDtl.ClearSelection(); SetStatusCellBackColor(kdgv_WmsInReceiptDtl, "RECEIPT_DTL_STATUS_NAME"); return string.Empty; } else { return result.Message; } } #endregion #region 收货单增、删、改、强制完成、收货组盘、重置条件操作 /// /// 新增收货单 /// /// /// private void kbtnAdd_Click(object sender, EventArgs e) { frmChildAddWmsInReceipt frm = new frmChildAddWmsInReceipt(); frm.ShowDialog(); } /// /// 编辑收货单 /// /// /// private void kbtnEdit_Click(object sender, EventArgs e) { int rowsSelectedNum = 0; string receiptId = string.Empty; int rowSelectIndex = 0; foreach (DataGridViewRow item in kdgv_WmsInReceipt.Rows) { DataGridViewCheckBoxCell checkCell = (DataGridViewCheckBoxCell)item.Cells[0]; object obj = checkCell.EditedFormattedValue; if (Convert.ToBoolean(obj)) { rowsSelectedNum++; receiptId = item.Cells[1].Value.ToString(); rowSelectIndex = item.Index; } } if (rowsSelectedNum > 0) { if (rowsSelectedNum == 1) { int receiptStatus = Convert.ToInt32(kdgv_WmsInReceipt.Rows[rowSelectIndex].Cells["RECEIPT_STATUS"].Value); string arrivalNo = kdgv_WmsInReceipt.Rows[rowSelectIndex].Cells["ARRIVAL_NO"].Value == null ? null : kdgv_WmsInReceipt.Rows[rowSelectIndex].Cells["ARRIVAL_NO"].Value.ToString(); if (receiptStatus == (int)ReceiptStatus.初始创建) { frmChildEditWmsInReceipt frm = new frmChildEditWmsInReceipt(); frm.ReceiptId = receiptId; frm.ArrivalNo = arrivalNo; frm.ShowDialog(); } else if (receiptStatus < (int)ReceiptStatus.收货完成) { KryptonMessageBox.Show($"第【{rowSelectIndex + 1}】行的收货单不处于【初始创建】状态,无法再次进行编辑!"); } else if (receiptStatus == (int)ReceiptStatus.强制完成) { KryptonMessageBox.Show($"第【{rowSelectIndex + 1}】行的收货单已被【强制完成】,无法再次进行编辑!"); } else if (receiptStatus == (int)ReceiptStatus.已删除) { KryptonMessageBox.Show($"第【{rowSelectIndex + 1}】行的收货单【已被删除】,无法再次进行编辑!"); } else if (receiptStatus == (int)ReceiptStatus.收货完成) { KryptonMessageBox.Show($"第【{rowSelectIndex + 1}】行的收货单【已完成】,无法再次进行编辑!"); } else { KryptonMessageBox.Show($"第【{rowSelectIndex + 1}】行的收货单状态【{receiptStatus}】是未知的,无法进行编辑!"); } } else { KryptonMessageBox.Show("不能对勾选的多行数据进行编辑,请重新勾选一行数据!"); } } else { KryptonMessageBox.Show("请勾选要编辑的数据行!"); } } /// /// 删除收货单 /// /// /// private void kbtnRemove_Click(object sender, EventArgs e) { int rowsSelected = 0; string receiptId = string.Empty; Dictionary dic_IndexAndArrivalStatus = new Dictionary(); foreach (DataGridViewRow item in kdgv_WmsInReceipt.Rows) { DataGridViewCheckBoxCell checkCell = (DataGridViewCheckBoxCell)item.Cells[0]; object obj = checkCell.EditedFormattedValue; if (Convert.ToBoolean(obj)) { rowsSelected++; receiptId += item.Cells[1].Value.ToString() + ","; int receiptStatus = Convert.ToInt32(item.Cells["RECEIPT_STATUS"].Value); dic_IndexAndArrivalStatus.Add(item.Index, receiptStatus); } } if (rowsSelected > 0) { DialogResult dr = KryptonMessageBox.Show("确定要删除所勾选的收货单数据吗?", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question); if (dr == DialogResult.OK) { foreach (var item in dic_IndexAndArrivalStatus) { if (item.Value == (int)ArrivalStatus.初始创建) { } else if (item.Value < (int)ArrivalStatus.已完成) { KryptonMessageBox.Show($"不能对第【{item.Key + 1}】行不处于【初始创建】状态的收货单,执行删除操作!"); return; } else if (item.Value == (int)ArrivalStatus.强制完成) { KryptonMessageBox.Show($"不能对第【{item.Key + 1}】行处于【强制完成】状态的收货单,执行删除操作!"); return; } else if (item.Value == (int)ArrivalStatus.已删除) { KryptonMessageBox.Show($"不能对第【{item.Key + 1}】行处于【已删除】状态的收货单,执行删除操作!"); return; } else if (item.Value == (int)ArrivalStatus.已完成) { KryptonMessageBox.Show($"不能对第【{item.Key + 1}】行处于【已完成】状态的收货单,执行删除操作!"); return; } else { KryptonMessageBox.Show($"不能对第【{item.Key + 1}】行处于未知状态【{item.Value}】的收货单,执行删除操作!"); return; } } receiptId = receiptId.Substring(0, receiptId.Length - 1); var result = WmsInstockService.wmsInReceiptService.DeleteWmsInReceiptData(new WmsInReceiptResult { RECEIPT_NO = receiptId, UPDATE_BY = AppConfig.UserLoginResult.UserInfo.UserId }); if (result.Status == OperateStatus.Success) { KryptonMessageBox.Show(result.Message); RefreshReceiptSearchData(); } else { KryptonMessageBox.Show(result.Message); } } } else { KryptonMessageBox.Show("请勾选要删除的收货单数据行!"); } } /// /// 收货组盘 /// /// /// private void kbtn_ReceiptTray_Click(object sender, EventArgs e) { int rowsSelectedNum = 0; string receiptId = string.Empty; string receiptNo = string.Empty; int rowSelectIndex = 0; foreach (DataGridViewRow item in kdgv_WmsInReceipt.Rows) { DataGridViewCheckBoxCell checkCell = (DataGridViewCheckBoxCell)item.Cells[0]; object obj = checkCell.EditedFormattedValue; if (Convert.ToBoolean(obj)) { rowsSelectedNum++; receiptId = item.Cells[1].Value.ToString(); receiptNo = item.Cells["RECEIPT_NO"].Value.ToString(); rowSelectIndex = item.Index; } } if (rowsSelectedNum > 0) { if (rowsSelectedNum == 1) { int receiptStatus = Convert.ToInt32(kdgv_WmsInReceipt.Rows[rowSelectIndex].Cells["RECEIPT_STATUS"].Value); if (receiptStatus < (int)ReceiptStatus.收货完成) { frmChildReceiptTray frm = new frmChildReceiptTray(); frm.ReceiptId = receiptId; frm.ReceiptNo = receiptNo; frm.ShowDialog(); } else if (receiptStatus == (int)ReceiptStatus.强制完成) { KryptonMessageBox.Show($"第【{rowSelectIndex + 1}】行的收货单已被【强制完成】,无法再次进行收货组盘!"); } else if (receiptStatus == (int)ReceiptStatus.已删除) { KryptonMessageBox.Show($"第【{rowSelectIndex + 1}】行的收货单【已被删除】,无法再次进行收货组盘!"); } else if (receiptStatus == (int)ReceiptStatus.收货完成) { KryptonMessageBox.Show($"第【{rowSelectIndex + 1}】行的收货单【已完成】,无法再次进行收货组盘!"); } else { KryptonMessageBox.Show($"第【{rowSelectIndex + 1}】行的收货单状态【{receiptStatus}】是未知的,无法进行收货组盘!"); } } else { KryptonMessageBox.Show("不能对勾选的多行数据进行收货组盘,请重新勾选一行数据!"); } } else { KryptonMessageBox.Show("请勾选要收货组盘的数据行!"); } } /// /// 强制完成收货单 /// /// /// private void kbtn_ForceFinish_Click(object sender, EventArgs e) { } #endregion #region 导入、导出、打印收货单数据 /// /// 重置收货单查询条件 /// /// /// private void kbtnReset_Click(object sender, EventArgs e) { ktb_receiptNo.Text = ""; ktb_arrivalNo.Text = ""; ktb_materialMsg.Text = ""; ktb_batchNoMsg.Text = ""; ktb_receipterMsg.Text = ""; kcmb_receiptType.SelectedIndex = 0; kcmb_receiptStatus.SelectedIndex = 0; kcmb_supplierMsg.SelectedIndex = 0; kdtp_startCreateTime.Value = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd 00:00:00")); kdtp_startCreateTime.Checked = false; kdtp_endCreateTime.Value = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd 23:59:59")); kdtp_endCreateTime.Checked = false; kdtp_startProcudtTime.Value = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd 00:00:00")); kdtp_startProcudtTime.Checked = false; kdtp_endProcudtTime.Value = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd 23:59:59")); kdtp_endProcudtTime.Checked = false; kdtp_startExpTime.Value = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd 00:00:00")); kdtp_startExpTime.Checked = false; kdtp_endExptTime.Value = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd 23:59:59")); kdtp_endExptTime.Checked = false; } /// /// 导出收货单数据 /// /// /// private void kbtnExport_Click(object sender, EventArgs e) { List receiptIdList = new List(); foreach (DataGridViewRow item in kdgv_WmsInReceipt.Rows) { DataGridViewCheckBoxCell checkCell = (DataGridViewCheckBoxCell)item.Cells[0]; object obj = checkCell.EditedFormattedValue; if (Convert.ToBoolean(obj)) { receiptIdList.Add(item.Cells[1].Value.ToString()); } } if (receiptIdList.Count > 0) { List wmsInReceiptList = new List(); foreach (string item in receiptIdList) { var result = WmsInstockService.wmsInReceiptService.GetWmsInReceiptDtlListForId(new WmsInReceiptResult { RECEIPT_ID = Convert.ToInt32(item) }); if (result.Status == OperateStatus.Success) { wmsInReceiptList.Add(result.Data); } } NxExcelHelper.ExportToExcel(GetWmsReceiptExportExcelData(wmsInReceiptList), "收货单数据"); } else { KryptonMessageBox.Show("请勾选要导出的数据行!"); } } private DataTable GetWmsReceiptExportExcelData(List wmsInReceiptList) { DataTable dt = new DataTable(); #region 准备导出列名 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("物料类型编码"); 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("规格"); 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("收货组盘数量"); 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("供应商名称"); 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("物品状态"); dt.Columns.Add(dc); #endregion foreach (WmsInReceiptResult receiptMd in wmsInReceiptList) { foreach (WmsInReceiptDtlResult receiptDtlMd in receiptMd.WmsInReceiptDtlList) { DataRow dr = dt.NewRow(); dr["收货单号"] = receiptMd.RECEIPT_NO; dr["到货通知单号"] = receiptMd.ARRIVAL_NO; dr["单据类型"] = receiptMd.RECEIPT_TYPE_NAME; dr["收货人"] = receiptMd.RECEIPTER; dr["收货时间"] = receiptMd.RECEIPT_TIME; dr["物料类型编码"] = receiptDtlMd.MATERIEL_TYPE_CODE; dr["物料类型名称"] = receiptDtlMd.MATERIEL_TYPE_NAME; dr["物料编码"] = receiptDtlMd.MATERIEL_CODE; dr["物料名称"] = receiptDtlMd.MATERIEL_NAME; dr["物料条码"] = receiptDtlMd.MATERIEL_BARCODE; dr["规格"] = receiptDtlMd.MATERIEL_SPEC; dr["单位"] = receiptDtlMd.UNIT_CODE; dr["批次号"] = receiptDtlMd.BATCH_NO; dr["到货数量"] = receiptDtlMd.ARRIVAL_QTY; dr["收货单明细数量"] = receiptDtlMd.RECEIPT_DTL_QTY; dr["收货组盘数量"] = receiptDtlMd.RECEIPT_TRAY_QTY; dr["上架数量"] = receiptDtlMd.PUTAWAY_QTY; dr["拒收数量"] = receiptDtlMd.REJECT_QTY; dr["拒收原因"] = receiptDtlMd.REJECT_REASON; dr["供应商编码"] = receiptDtlMd.SUPPLIER_CODE; dr["供应商名称"] = receiptDtlMd.SUPPLIER_NAME; dr["生产日期"] = receiptDtlMd.PRODUCT_DATE; dr["失效日期"] = receiptDtlMd.EXP_DATE; dr["明细状态"] = receiptDtlMd.RECEIPT_DTL_STATUS_NAME; dr["质检状态"] = receiptDtlMd.INSPECTION_RESULT_NAME; dr["物品状态"] = receiptDtlMd.ITEM_STATUS_NAME; dt.Rows.Add(dr); } } return dt; } /// /// Excel导入收货单数据 /// /// /// private void kbtnImport_Click(object sender, EventArgs e) { } /// /// 打印收货单 /// /// /// private void kbtnPrint_Click(object sender, EventArgs e) { int rowsSelectedNum = 0; string receiptId = string.Empty; int rowSelectIndex = 0; foreach (DataGridViewRow item in kdgv_WmsInReceipt.Rows) { DataGridViewCheckBoxCell checkCell = (DataGridViewCheckBoxCell)item.Cells[0]; object obj = checkCell.EditedFormattedValue; if (Convert.ToBoolean(obj)) { rowsSelectedNum++; receiptId = item.Cells[1].Value.ToString(); rowSelectIndex = item.Index; } } if (rowsSelectedNum > 0) { if (rowsSelectedNum == 1) { int receiptStatus = Convert.ToInt32(kdgv_WmsInReceipt.Rows[rowSelectIndex].Cells["RECEIPT_STATUS"].Value); if (receiptStatus > (int)ReceiptStatus.收货完成) { KryptonMessageBox.Show($"收货单的状态,无法进行标签打印操作!"); } else { frmChildPrintMaterialLabelCode frm = new frmChildPrintMaterialLabelCode(); frm.ReceiptId = receiptId; frm.ShowDialog(); } } else { KryptonMessageBox.Show("不能对勾选的多行收货单进行标签打印,请重新勾选一行收货单数据!"); } } else { KryptonMessageBox.Show("请勾选要进行打印的收货单数据行!"); } } #endregion #region DatatGridView 事件 /// /// 设置DatatGridView的第一列复选框的背景色 /// /// /// private void kdgv_WmsInReceipt_CellContentClick(object sender, DataGridViewCellEventArgs e) { if (e.ColumnIndex == 0) { DataGridViewCheckBoxCell checkCell = (DataGridViewCheckBoxCell)kdgv_WmsInReceipt.CurrentCell; if (Convert.ToBoolean(checkCell.EditedFormattedValue)) { kdgv_WmsInReceipt.CurrentCell.Style.BackColor = Color.FromArgb(51, 153, 255); } else { kdgv_WmsInReceipt.CurrentCell.Style.BackColor = Color.Transparent; } } } /// /// 设置状态列的背景色 /// /// dataGridView控件 /// 状态列的列名称 private void SetStatusCellBackColor(KryptonDataGridView dataGridView, string columnName) { foreach (DataGridViewRow item in dataGridView.Rows) { string arrivalDtlStatus = item.Cells[columnName].Value.ToString(); switch (Enum.Parse(typeof(ReceiptStatus), arrivalDtlStatus)) { case ReceiptStatus.初始创建: //item.Cells[columnName].Style.ForeColor = Color.White; item.Cells[columnName].Style.BackColor = Color.FromArgb(214, 228, 243); break; case ReceiptStatus.收货审核: //item.Cells[columnName].Style.ForeColor = Color.White; item.Cells[columnName].Style.BackColor = Color.LightYellow; break; case ReceiptStatus.收货中: //item.Cells[columnName].Style.ForeColor = Color.White; item.Cells[columnName].Style.BackColor = Color.LightGreen; break; case ReceiptStatus.收货完成: //item.Cells[columnName].Style.ForeColor = Color.White; item.Cells[columnName].Style.BackColor = Color.LightGray; break; case ReceiptStatus.强制完成: //item.Cells[columnName].Style.ForeColor = Color.White; item.Cells[columnName].Style.BackColor = Color.DarkGray; break; case ReceiptStatus.已删除: //item.Cells[columnName].Style.ForeColor = Color.White; item.Cells[columnName].Style.BackColor = Color.FromArgb(255, 69, 0); break; default: break; } } } private void kdgv_WmsInReceipt_DataError(object sender, DataGridViewDataErrorEventArgs e) { } private void kdgv_WmsInReceiptDtl_DataError(object sender, DataGridViewDataErrorEventArgs e) { } #endregion #region 鼠标右键单击事件 /// /// 刷新明细表数据 /// /// /// private void 刷新ToolStripMenuItem1_Click(object sender, EventArgs e) { if (kdgv_WmsInReceiptDtl.Rows.Count > 0) { if (kdgv_WmsInReceipt.SelectedRows.Count > 0 && isControlReceiptDtlShow) { //ReceiptId = kdgv_WmsInReceipt.SelectedRows[0].Cells[1].Value.ToString(); int mainTableId = Convert.ToInt32(kdgv_WmsInReceipt.SelectedRows[0].Cells[1].Value); var loadfrm = new frmLoading(); loadfrm.Show(); var message = loadfrm.EventCalExecExt1(LoadWmsInReceiptDtlData, mainTableId); if (!string.IsNullOrWhiteSpace(message)) { KryptonMessageBox.Show($"查询失败!\r\n{message}", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } } /// /// 刷新主表数据 /// /// /// private void 刷新ToolStripMenuItem_Click(object sender, EventArgs e) { if (kdgv_WmsInReceipt.Rows.Count > 0) { RefreshReceiptSearchData(); } } #endregion private void pageToolbar1_OnPageChange(int PageIndex, int PageSzie) { this.kbtnSearch_Click(null, null); } private void button1_Click(object sender, EventArgs e) { FrmBarCode.ShowBarCode("22223"); } } }