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");
}
}
}