public void GetDMSInfo(long value)
{
ADODB.Recordset rs = DMSConnection.GetInstance().Recordset("SELECT * FROM [dbo.itemloc] WHERE [itm_num]=" + value.ToString());
rs.Each(r =>
{
DCLocation temp = new DCLocation(r.Fields["location"].Value.ToString());
temp.QtyOH = (int)r.Fields["qty_on_hand"].Value;
temp.PickZone = (short)r.Fields["pic_zone"].Value;
temp.StorageFunction = (byte)r.Fields["stg_fnc_code"].Value;
if (temp.LocationType == "Forward")
{
_forward = temp;
_totOH += _forward.QtyOH;
}
else
{
if (temp.PickZone < 900)
{
_reserves.Add(temp);
_totOH += temp.QtyOH;
}
}
});
rs.Close();
rs = null;
}
public static ICollection <IPO> GetPOsFromList(this ADODB.Recordset rs, int position = 0)
{
HashSet <IPO> pos = new HashSet <IPO>();
rs.Each(e =>
{
pos.Add(new PO((long)rs.Fields[position].Value));
});
return(pos);
}
