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