private void gridPalletizedView_ShownEditor(object sender, EventArgs e)
{
DataRow dr = gridPalletizedView.GetFocusedDataRow();
// check if the item is consolidable
PalletLocation pll = new PalletLocation();
DateTime? dt = null;
if (dr["Expiry Date"] != DBNull.Value)
{
dt = Convert.ToDateTime(dr["Expiry Date"]);
}
pll.LoadConsolidationOption(Convert.ToInt32(dr["ID"]), dt, Convert.ToInt32(dr["BoxLevel"]),
Convert.ToInt32(lkAccounts.EditValue));
//DataRowView drv = pll.DefaultView.AddNew();
//drv["Label"] = "New Pallet";
//drv["ID"] = 0;
GridView view = sender as GridView;
if (view.FocusedColumn == columnPalletNumber)
{
try
{
LookUpEdit lke = (LookUpEdit)view.ActiveEditor;
lke.EditValue = null;
lke.Properties.DataSource = pll.DefaultView;
}
catch
{
}
}
}
private void PalletizeRecievedItems()
{
if (_dtPalletizedItemList == null)
{
_dtPalletizedItemList = _dtRecGrid.Clone();
_dtPalletizedItemList.Columns.Add("PalletNumber");
_dtPalletizedItemList.Columns.Add("Multiplier");
_dtPalletizedItemList.Columns.Add("Volume");
_dtPalletizedItemList.Columns.Add("BoxSizeDisplay");
_dtPalletizedItemList.Columns.Add("Consolidate", typeof(bool));
_dtPalletizedItemList.Columns.Add("CanConsolidate", typeof(bool));
_dtPalletizedItemList.Columns.Add("PutAwayLocation", typeof(bool));
_dtPalletizedItemList.Columns.Add("IsStoredInFreeStorageType", typeof(bool));
_dtPalletizedItemList.Columns.Add("Index", typeof(int));
//_dtPalletizedItemList.Columns.Add("GUID", typeof(string));
_dtNonPalletizedItemList = _dtRecGrid.Clone();
_dtNonPalletizedItemList.Columns.Add("Volume");
_dtNonPalletizedItemList.Columns.Add("StorageTypeID");
//_dtNonPalletizedItemList.Columns.Add("GUID", typeof(string));
_dtNonPalletizedItemList.Columns.Add("Index", typeof(int));
_dtNonPalletizedItemList.Columns.Add("Multiplier");
_dtNonPalletizedItemList.Columns.Add("BoxSizeDisplay");
// dtNonPalletizedItemList.Columns.Add("IsDamaged", typeof(bool));
}
else
{
_dtPalletizedItemList.Clear();
_dtNonPalletizedItemList.Clear();
}
BLL.Item item = new Item();
int lastPalletId = Pallet.GetLastPanelNumber();
DateTime lastExpireDate = new DateTime();
int previousProductId = 0;
_dtRecGrid.DefaultView.Sort = "Ordering, ID, Expiry Date";
int i = 0;
DataRow r, rw;
foreach (DataRowView drv in _dtRecGrid.DefaultView)
{
r = drv.Row;
item.LoadByPrimaryKey(Convert.ToInt32(r["ID"]));
int productID = 0;
if (Convert.ToString(item.StorageTypeID) == StorageType.BulkStore &&
(r["IsDamaged"] != DBNull.Value && !Convert.ToBoolean(r["IsDamaged"])))
{
DataTable dtbl = r["PC"] as DataTable;
foreach (DataRow rr in dtbl.Rows)
{
//if (Convert.ToInt32(rr["Qty"]) == 0)
// continue;
_dtPalletizedItemList.ImportRow(r);
productID = Convert.ToInt32(r["ID"]);
rw = _dtPalletizedItemList.Rows[_dtPalletizedItemList.Rows.Count - 1];
rw["Pack Qty"] = rr["Qty"];
rw["BoxLevel"] = rr["BSize"];
rw["BoxSizeDisplay"] = rr["BoxSize"];
rw["Multiplier"] = rr["SKUM"];
int bs = Convert.ToInt32(rr["BSize"]);
// check if the item is consolidable
PalletLocation pll = new PalletLocation();
DateTime expiry = DateTime.MaxValue;
if (r["Expiry Date"] != DBNull.Value)
{
expiry = Convert.ToDateTime(r["Expiry Date"]);
}
pll.LoadConsolidationOption(productID, expiry, bs, Convert.ToInt32(lkAccounts.EditValue));
bool consolidate = false;
if (pll.RowCount > 0)
{
rw["CanConsolidate"] = true;
consolidate = true;
}
else
{
rw["CanConsolidate"] = false;
}
rw["Consolidate"] = false;
if (consolidate)
{
}
else if (r["Expiry Date"] != DBNull.Value && previousProductId == productID &&
lastExpireDate.Subtract(Convert.ToDateTime(r["Expiry Date"])).Days == 0)
{
rw["PalletNumber"] = lastPalletId;
}
else
{
lastPalletId++;
rw["PalletNumber"] = lastPalletId;
lastExpireDate = DateTime.MaxValue;
if (r["Expiry Date"] != DBNull.Value)
{
lastExpireDate = Convert.ToDateTime(r["Expiry Date"]);
}
productID = Convert.ToInt32(r["ID"]);
previousProductId = productID;
}
rw["Index"] = i;
}
}
else
{
// Put it in the putaway list
DataTable dtbl = r["PC"] as DataTable;
if (dtbl != null)
{
foreach (DataRow rr in dtbl.Rows)
{
if (Convert.ToInt32(rr["Qty"]) == 0)
continue;
_dtNonPalletizedItemList.ImportRow(r);
productID = Convert.ToInt32(r["ID"]);
rw = _dtNonPalletizedItemList.Rows[_dtNonPalletizedItemList.Rows.Count - 1];
rw["Pack Qty"] = rr["Qty"];
rw["BoxLevel"] = rr["BSize"];
rw["BoxSizeDisplay"] = rr["BoxSize"];
rw["Multiplier"] = rr["SKUM"];
rw["Index"] = i;
}
}
}
i++;
previousProductId = Convert.ToInt32(r["ID"]);
lastExpireDate = DateTime.MaxValue;
if (r["Expiry Date"] != DBNull.Value)
{
lastExpireDate = Convert.ToDateTime(r["Expiry Date"]);
}
}
// now palletize the Damaged
DataView dvShortage = grdViewShortageOrDamaged.DataSource as DataView;
if (dvShortage != null && dvShortage.ToTable().Rows.Count > 0)
{
dvShortage.RowFilter = string.Format("[ShortageReasonID]={0}", ShortageReasons.Constants.DAMAGED);
foreach (DataRow drDamages in dvShortage.ToTable().Rows)
{
_dtNonPalletizedItemList.ImportRow(drDamages);
//productID = Convert.ToInt32(drDamages["ID"]);
rw = _dtNonPalletizedItemList.Rows[_dtNonPalletizedItemList.Rows.Count - 1];
rw["BoxLevel"] = 0;
rw["BoxSizeDisplay"] = 1;
BLL.ItemUnit iu = new ItemUnit();
iu.LoadByPrimaryKey(Convert.ToInt32(drDamages["UnitID"]));
rw["ID"] = iu.ItemID;
rw["Manufacturer"] = drDamages["Manufacturer"];
rw["Multiplier"] = iu.QtyPerUnit;
rw["IsDamaged"] = true;
rw["Index"] = i++;
}
dvShortage.RowFilter = null;
}
PalletizedGrid.DataSource = _dtPalletizedItemList;
gridNonPalletized.DataSource = _dtNonPalletizedItemList;
CalculateVolumes();
}
private void repoPalletNo_DoubleClick(object sender, EventArgs e)
{
DataRow dr = gridPalletizedView.GetFocusedDataRow();
// check if the item is consolidable
PalletLocation pll = new PalletLocation();
pll.LoadConsolidationOption(Convert.ToInt32(dr["ID"]), Convert.ToDateTime(dr["Expiry Date"]),
Convert.ToInt32(dr["BoxLevel"]), Convert.ToInt32(lkAccounts.EditValue));
if (pll.RowCount > 0)
{
dr["PalletNumber"] = DBNull.Value;
dr["CanConsolidate"] = true;
}
else
{
dr["CanConsolidate"] = false;
}
dr["Consolidate"] = false;
dr.EndEdit();
gridPalletizedView.RefreshData();
//btnNextStep3.Focus();
}
private void btnConsolidate_Click(object sender, EventArgs e)
{
DataRow dr = gridPalletizedView.GetFocusedDataRow();
dr.ClearErrors();
//// check if the item is consolidable
PalletLocation pll = new PalletLocation();
DateTime? dt = null;
if (dr["Expiry Date"] != DBNull.Value)
{
dt = Convert.ToDateTime(dr["Expiry Date"]);
}
pll.LoadConsolidationOption(Convert.ToInt32(dr["ID"]), dt, Convert.ToInt32(dr["BoxLevel"]),
Convert.ToInt32(lkAccounts.EditValue));
if (Convert.ToBoolean(dr["CanConsolidate"]))
{
dr["CanConsolidate"] = false;
dr["Consolidate"] = false;
dr.EndEdit();
}
else
{
if (pll.RowCount > 0)
{
dr["PalletNumber"] = DBNull.Value;
dr["CanConsolidate"] = true;
}
else
{
dr["CanConsolidate"] = false;
}
dr["Consolidate"] = false;
dr.EndEdit();
}
gridPalletizedView.InvalidateRow(gridPalletizedView.FocusedRowHandle);
}
