internal static void FetchDetails(TransHed transHed, IConnection conn) { IPreparedStatement ps = conn.PrepareStatement(@" SELECT rtrans_det.id, rtrans_det.htrn_id, rtrans_det.dtrn_num, rtrans_det.item_id, rtrans_det.qty1, rtrans_det.unit_price, rtrans_det.disc_line1, rtrans_det.net_value, rtrans_det.vat_value, ritems.item_cod, ritems.item_desc, ritems.item_vat FROM rtrans_det JOIN ritems ON ritems.id = rtrans_det.item_id WHERE htrn_id = :htrn_id ORDER BY rtrans_det.id"); ps.Set("htrn_id", transHed.HtrnId); IResultSet result = ps.ExecuteQuery(); if (transHed.TransDetList == null) { transHed.TransDetList = new TransDetList(); } while (result.Next()) { TransDet d = new TransDet(); d.Fetch(result); transHed.TransDetList.Add(d); } result.Close(); ps.Close(); }
public void MarkDetailDeleted(TransDet d) { d.IsDeleted = true; if (d.IsNew) { TransDetList.Remove(d); } else { if (TransDetListDeleted == null) { TransDetListDeleted = new TransDetList(); } TransDetListDeleted.Add(d); } TransDetList.RefreshNumbers(); }