private void txtLPN_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
if (string.IsNullOrEmpty(this.txtLPN.Text.Trim()))
{
MsgBox.DialogWarning("Please scan lpn");
this.txtLPN.Focus();
this.txtLPN.SelectAll();
return;
}
else
{
try
{
var LpnDetailResult = Calbee.WMS.Services.Inventory.InventoryServiceProxy.WS.GetInventorys(Calbee.Infra.Common.Constants.WConstants.wareHouseDDL, string.Empty, string.Empty, this.txtLPN.Text.Trim(), string.Empty, string.Empty);
if (LpnDetailResult != null)
{
if (LpnDetailResult.Count() > 0)
{
// เอาข้อมูลมาใส่ Gridview Production
CreateTableDetailOnGridView();
DataTable dtTempProduction = ConvertObject.ToTable(LpnDetailResult);
if (dtTempProduction != null)
{
if (dtTempProduction.Rows.Count > 0)
{
//Add to datagrid.
DataRow AddAll;
foreach (DataRow item in dtTempProduction.Rows)
{
AddAll = dtDetail.NewRow();
AddAll["Quantity"] = Convert.ToString(item["Quantity"]).Trim();
AddAll["ItemStatus"] = Convert.ToString(item["StatusName"]).Trim();
AddAll["UOM"] = Convert.ToString(item["UOM"]).Trim();
AddAll["ReceiveDate"] = Convert.ToString(item["ReceiveDate"]).Trim();
dtDetail.Rows.Add(AddAll);
}
dtDetail.TableName = "Detail";
dgvChangeStatusDetail.DataSource = dtDetail;
}
}
this.txtLocation.Text = string.IsNullOrEmpty(LpnDetailResult.FirstOrDefault().LocationCode) ? string.Empty : LpnDetailResult.FirstOrDefault().LocationCode;
this.txtLocation.ReadOnly = true;
this.txtItemNumber.Text = string.IsNullOrEmpty(LpnDetailResult.FirstOrDefault().ItemNumber) ? string.Empty : LpnDetailResult.FirstOrDefault().ItemNumber;
this.txtItemNumber.ReadOnly = true;
this.txtDescription.Text = string.IsNullOrEmpty(LpnDetailResult.FirstOrDefault().ItemName) ? string.Empty : LpnDetailResult.FirstOrDefault().ItemName;
this.txtDescription.ReadOnly = true;
this.txtLotNumber.Text = string.IsNullOrEmpty(LpnDetailResult.FirstOrDefault().LotNumber) ? string.Empty : LpnDetailResult.FirstOrDefault().LotNumber;
this.txtLotNumber.ReadOnly = true;
if (LpnDetailResult.FirstOrDefault().ExpiryDate != null)
{
this.dtpExpiryDate.Value = LpnDetailResult.FirstOrDefault().ExpiryDate.Value;
}
else
{
this.dtpExpiryDate.Value = AppContext.GetDateTimeServer();
}
this.toLpn = LpnDetailResult.FirstOrDefault().Lpn;
this.UOM = LpnDetailResult.FirstOrDefault().UOM;
this.expiryDateControl = LpnDetailResult.FirstOrDefault().ExpiryDateControl;
this.dtpExpiryDate.Enabled = false;
this.txtQuantity.Text = LpnDetailResult.FirstOrDefault().Quantity.ToString();
List <string> _listItemStatus = new List <string>();
foreach (var item in LpnDetailResult)
{
_listItemStatus.Add(item.StatusName);
}
ComboBoxBinding.BindLStringToCombobox(_listItemStatus, this.cmbItemStatus);
this.txtQuantity.Focus();
}
}
else
{
MsgBox.DialogWarning("Not found lpn : " + this.txtLPN.Text);
this.txtItemNumber.Focus();
this.txtItemNumber.SelectAll();
return;
}
}
catch (Exception ex)
{
if (ex.InnerException != null)
{
MsgBox.DialogError(ex.InnerException.Message.ToString());
}
else
{
if (Calbee.Infra.Common.Constants.IConstants.CatchFlag.Equals("Y"))
{
// Show error description detail
MsgBox.DialogError(ex.GetBaseException().ToString());
}
else
{
// Show message error
MsgBox.DialogError(ex.Message.ToString());
}
}
}
}
}
}
private void RefreshOutboundPickingListDetail(string pickingListNo, string locationCode, string lpn, string itemNumber, string lotNumber)
{
try
{
this.dgvPickItem.DataSource = null;
CreateTableOnGridView();
var outboundPickListResult = Calbee.WMS.Services.Outbound.OutboundServiceProxy.WS.GetOutboundPickingListDetails(string.Empty, pickingListNo, locationCode, string.Empty, lpn, itemNumber, lotNumber, string.Empty, string.Empty);
if (outboundPickListResult != null)
{
// เอาข้อมูลมาใส่ Gridview Production
DataTable dtTempPickList = ConvertObject.ToTable(outboundPickListResult);
if (dtTempPickList != null)
{
// Sum pick qty
this.lblResultPickQty.Text = outboundPickListResult.Select(q => q.QuantityPick).Sum().ToString();
if (dtTempPickList.Rows.Count > 0)
{
//Add to datagrid.
DataRow AddAll;
foreach (DataRow item in dtTempPickList.Rows)
{
AddAll = dt.NewRow();
AddAll["PickStatus"] = Convert.ToString(item["PickStatus"]).Trim();
AddAll["Lpn"] = Convert.ToString(item["Lpn"]).Trim();
AddAll["ItemNumber"] = Convert.ToString(item["ItemNumber"]).Trim();
AddAll["ItemName"] = Convert.ToString(item["ItemName"]).Trim();
AddAll["QuantityPlan"] = Convert.ToString(item["QuantityPlan"]).Trim();
AddAll["QuantityPick"] = Convert.ToString(item["QuantityPick"]).Trim();
AddAll["UOM"] = Convert.ToString(item["UOM"]).Trim();
AddAll["LocationPlan"] = Convert.ToString(item["LocationPlan"]).Trim();
AddAll["LotNumber"] = Convert.ToString(item["LotNumber"]).Trim();
AddAll["ExpiryDate"] = string.IsNullOrEmpty(item["ExpiryDate"].ToString()) ? DateTime.Now : Convert.ToDateTime(item["ExpiryDate"]);
dt.Rows.Add(AddAll);
}
dt.TableName = "PickItems";
dgvPickItem.DataSource = dt;
}
}
}
}
catch (Exception ex)
{
if (ex.InnerException != null)
{
MsgBox.DialogError(ex.InnerException.Message.ToString());
}
else
{
if (Calbee.Infra.Common.Constants.IConstants.CatchFlag.Equals("Y"))
{
// Show error description detail
MsgBox.DialogError(ex.GetBaseException().ToString());
}
else
{
// Show message error
MsgBox.DialogError(ex.Message.ToString());
}
}
}
}
private void btnRefresh_Click(object sender, EventArgs e)
{
try
{
if (!DoValidate())
{
return;
}
else
{
dgvInventory.DataSource = null;
CreateTableOnGridView();
string lotNumber = string.Empty;
if (cmbLotNumber.DataSource != null)
{
lotNumber = string.IsNullOrEmpty(this.cmbLotNumber.SelectedValue.ToString()) ? string.Empty : this.cmbLotNumber.SelectedValue.ToString();
}
else
{
lotNumber = string.Empty;
}
var inventoryResult = Calbee.WMS.Services.Inventory.InventoryServiceProxy.WS.GetInventorys(Calbee.Infra.Common.Constants.WConstants.wareHouseDDL, this.txtLocation.Text.Trim(), string.Empty, string.Empty, this.txtItemNumber.Text.Trim(), lotNumber).OrderBy(s => s.Lpn);
if (inventoryResult != null)
{
// Count
this.lblResultCountLPN.Text = inventoryResult.Select(q => q.Lpn).Count().ToString();
// Sum
if (!string.IsNullOrEmpty(lotNumber))
{
this.lblResultCountBox.Text = inventoryResult.Where(i => i.LotNumber == lotNumber).Select(q => q.Quantity).Sum().ToString();
}
else
{
this.lblResultCountBox.Text = inventoryResult.Select(q => q.Quantity).Sum().ToString();
}
DataTable dtIventory = ConvertObject.ToTable(inventoryResult);
if (dtIventory != null)
{
if (dtIventory.Rows.Count > 0)
{
//Add to datagrid.
DataRow AddAll;
foreach (DataRow item in dtIventory.Rows)
{
AddAll = dt.NewRow();
AddAll["LPN"] = Convert.ToString(item["LPN"]).Trim();
AddAll["ItemNumber"] = Convert.ToString(item["ItemNumber"]).Trim();
AddAll["ItemName"] = Convert.ToString(item["ItemName"]).Trim();
AddAll["Quantity"] = Convert.ToString(item["Quantity"]).Trim();
AddAll["UOM"] = Convert.ToString(item["UOM"]).Trim();
AddAll["LocationCode"] = Convert.ToString(item["LocationCode"]).Trim();
AddAll["LotNumber"] = Convert.ToString(item["LotNumber"]).Trim();
AddAll["ExpiryDate"] = Convert.ToString(item["ExpiryDate"]).Trim();
AddAll["StatusName"] = Convert.ToString(item["StatusName"]).Trim();
AddAll["ReceiveDate"] = Convert.ToString(item["ReceiveDate"]).Trim();
dt.Rows.Add(AddAll);
}
dt.TableName = "Inventory";
dgvInventory.DataSource = dt;
}
}
}
}
}
catch (Exception ex)
{
if (ex.InnerException != null)
{
MsgBox.DialogError(ex.InnerException.Message.ToString());
}
else
{
if (Calbee.Infra.Common.Constants.IConstants.CatchFlag.Equals("Y"))
{
// Show error description detail
MsgBox.DialogError(ex.GetBaseException().ToString());
}
else
{
// Show message error
MsgBox.DialogError(ex.Message.ToString());
}
}
}
}