private void AddShortPickBoxGrid(ShortPickBoxInfo item)
{
Invoke(new Action(() => {
if (item.SHORTQTY > 0)
{
gridShort.Rows.Insert(0, item.HU, item.PICK_TASK, item.ZSATNR, item.ZCOLSN, item.ZSIZTX, item.QTY, item.RQTY, item.SHORTQTY, item.ISLAST);
gridShort.Rows[0].Tag = item;
gridShort.Rows[0].DefaultCellStyle.BackColor = Color.OrangeRed;
}
else
{
gridShort.Rows.Add(item.HU, item.PICK_TASK, item.ZSATNR, item.ZCOLSN, item.ZSIZTX, item.QTY, item.RQTY, item.SHORTQTY, item.ISLAST);
gridShort.Rows[gridShort.Rows.Count - 1].Tag = item;
}
}));
}
private void btnQueryShortPick_Click(object sender, EventArgs e)
{
//清空列表
this.Invoke(new Action(() => {
gridShort.Rows.Clear();
}));
if (string.IsNullOrWhiteSpace(txtShortHU.Text.Trim()))
{
MetroMessageBox.Show(this, "箱码不能为空", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
Thread thread = new Thread(new ThreadStart(() => {
try
{
ShowLoading("正在下载短拣信息...");
DataSet ds = LocalDataService.GetShortPickHuInfo(txtShortHU.Text.Trim());
if (ds != null && ds.Tables.Count == 2)
{
DataTable dt1 = ds.Tables[0];
DataTable dt2 = ds.Tables[1];
List <ShortPickBoxInfo> list = new List <ShortPickBoxInfo>();
if (dt2.Rows.Count <= 0 || dt1.Rows.Count <= 0)
{
HideLoading();
Invoke(new Action(() =>
{
MetroMessageBox.Show(this, "该箱没有短拣信息", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}));
return;
}
if (dt1.Rows.Count > 0)
{
foreach (DataRow row in dt1.Rows)
{
ShortPickBoxInfo item = new ShortPickBoxInfo();
item.HU = row["HU"] != null ? row["HU"].ToString() : "";
item.PICK_TASK = row["PICK_TASK"] != null ? row["PICK_TASK"].ToString() : "";
item.PICK_TASK_ITEM = row["PICK_TASK_ITEM"] != null ? row["PICK_TASK_ITEM"].ToString() : "";
item.MATNR = row["PRODUCTNO"] != null ? row["PRODUCTNO"].ToString() : "";
item.QTY = row["QTY"] != null ? int.Parse(row["QTY"].ToString()) : 0;
var temp = list.FirstOrDefault(o => o.PICK_TASK == item.PICK_TASK);
if (temp == null)
{
item.ISLAST = LocalDataService.CountUnScanDeliverBox(item.PICK_TASK) == 1 ? "是" : "否";
}
else
{
item.ISLAST = temp.ISLAST;
}
//MaterialInfo mi = materialList.FirstOrDefault(i => i.MATNR == item.MATNR);
MaterialInfo mi = getMatInfo(item.MATNR);
item.ZCOLSN = mi != null ? mi.ZCOLSN : "";
item.ZSATNR = mi != null ? mi.ZSATNR : "";
item.ZSIZTX = mi != null ? mi.ZSIZTX : "";
list.Add(item);
}
}
//start edit by wuxw 统计实发数量，一箱存在多下架单，且不同下架单有相同MATNR，先填满尾箱，再填非尾箱
list = list.OrderByDescending(o => o.ISLAST).ThenBy(o => o.PICK_TASK).ThenBy(o => o.MATNR).ThenBy(o => o.QTY).ToList();
if (dt2.Rows.Count > 0)
{
foreach (DataRow row in dt2.Rows)
{
string matnr = row["MATNR"] != null ? row["MATNR"].ToString() : "";
int isAdd = row["IsAdd"] != null ? int.Parse(row["IsAdd"].ToString()) : 0;
if (isAdd != 1)
{
//判断所属产品编码是否有属于尾箱且实发数量小于应发数量的记录
var item = list.FirstOrDefault(o => o.MATNR == matnr && o.ISLAST == "是" && o.RQTY < o.QTY);
if (item != null)
{
item.RQTY++;
if (string.IsNullOrEmpty(item.ZCOLSN))
{
item.ZCOLSN = row["ZCOLSN"] != null ? row["ZCOLSN"].ToString() : "";
item.ZSATNR = row["ZSATNR"] != null ? row["ZSATNR"].ToString() : "";
item.ZSIZTX = row["ZSIZTX"] != null ? row["ZSIZTX"].ToString() : "";
}
}
else
{
//判断所属产品编码是否有不是尾箱且实发数量小于应发数量的记录
var tItem = list.FirstOrDefault(o => o.MATNR == matnr && o.ISLAST == "否" && o.RQTY < o.QTY);
if (tItem != null)
{
tItem.RQTY++;
if (string.IsNullOrEmpty(tItem.ZCOLSN))
{
tItem.ZCOLSN = row["ZCOLSN"] != null ? row["ZCOLSN"].ToString() : "";
tItem.ZSATNR = row["ZSATNR"] != null ? row["ZSATNR"].ToString() : "";
tItem.ZSIZTX = row["ZSIZTX"] != null ? row["ZSIZTX"].ToString() : "";
}
}
else
{
//获取所属产品编码最后一条记录，看是否存在
var lastItem = list.LastOrDefault(o => o.MATNR == matnr);
if (lastItem != null)
{
lastItem.RQTY++;
if (string.IsNullOrEmpty(lastItem.ZCOLSN))
{
lastItem.ZCOLSN = row["ZCOLSN"] != null ? row["ZCOLSN"].ToString() : "";
lastItem.ZSATNR = row["ZSATNR"] != null ? row["ZSATNR"].ToString() : "";
lastItem.ZSIZTX = row["ZSIZTX"] != null ? row["ZSIZTX"].ToString() : "";
}
}
else
{
//找不到任何数据，本身就有问题，不应该短拣，不显示
}
}
}
}
else
{
//判断所属产品编码是否有属于尾箱且实发数量小于应发数量的记录
var item = list.FirstOrDefault(o => o.MATNR == matnr && o.ISLAST == "是" && o.Add_RQTY < o.QTY);
if (item != null)
{
item.Add_RQTY++;
if (string.IsNullOrEmpty(item.ZCOLSN))
{
item.ZCOLSN = row["ZCOLSN"] != null ? row["ZCOLSN"].ToString() : "";
item.ZSATNR = row["ZSATNR"] != null ? row["ZSATNR"].ToString() : "";
item.ZSIZTX = row["ZSIZTX"] != null ? row["ZSIZTX"].ToString() : "";
}
}
else
{
//判断所属产品编码是否有不是尾箱且实发数量小于应发数量的记录
var tItem = list.FirstOrDefault(o => o.MATNR == matnr && o.ISLAST == "否" && o.Add_RQTY < o.QTY);
if (tItem != null)
{
tItem.Add_RQTY++;
if (string.IsNullOrEmpty(tItem.ZCOLSN))
{
tItem.ZCOLSN = row["ZCOLSN"] != null ? row["ZCOLSN"].ToString() : "";
tItem.ZSATNR = row["ZSATNR"] != null ? row["ZSATNR"].ToString() : "";
tItem.ZSIZTX = row["ZSIZTX"] != null ? row["ZSIZTX"].ToString() : "";
}
}
else
{
//获取所属产品编码最后一条记录，看是否存在
var lastItem = list.LastOrDefault(o => o.MATNR == matnr);
if (lastItem != null)
{
lastItem.Add_RQTY++;
if (string.IsNullOrEmpty(lastItem.ZCOLSN))
{
lastItem.ZCOLSN = row["ZCOLSN"] != null ? row["ZCOLSN"].ToString() : "";
lastItem.ZSATNR = row["ZSATNR"] != null ? row["ZSATNR"].ToString() : "";
lastItem.ZSIZTX = row["ZSIZTX"] != null ? row["ZSIZTX"].ToString() : "";
}
}
else
{
//找不到任何数据，本身就有问题，不应该短拣，不显示
}
}
}
}
}
}
//判断主副条码是否一致
if (list.Count(o => o.Add_RQTY > 0 && o.RQTY != o.Add_RQTY) > 0)
{
HideLoading();
Invoke(new Action(() =>
{
MetroMessageBox.Show(this, "主辅条码不一致，不允许短拣", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}));
return;
}
//end edit
int faCount = 0;
int saoCount = 0;
foreach (ShortPickBoxInfo item in list)
{
//实发数量和短拣数量都不为0的不显示
if (item.RQTY == 0 && item.SHORTQTY == 0)
{
continue;
}
faCount += item.QTY;
saoCount += item.RQTY;
AddShortPickBoxGrid(item);
}
Invoke(new Action(() =>
{
faTotalBoxNum.Text = faCount.ToString();
saoTotalNum.Text = saoCount.ToString();
}));
}
else
{
HideLoading();
Invoke(new Action(() => {
MetroMessageBox.Show(this, "该箱没有短拣信息", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}));
}
}
catch (Exception ex)
{
LogHelper.WriteLine(ex.Message + "\r\n" + ex.StackTrace);
}
HideLoading();
}));
thread.IsBackground = true;
thread.Start();
}