// 2014.10.17 MadhuVenkat K Modified SQL statement for CR#65002-Changing From Site in Shipment Processing. // 2014.10.18 MadhuVenkat K Modified SQL statement for CR#64905-App crashes when we process multi BOL // 2014.11.25 MadhuVenkat K Modified SQL statement for CR#65604 - Application is updating null for Supplier Code/ Supply Point in the BOLHdr for shipments created from iPAD app. /// <summary> /// Function to return list of BOL item /// </summary> /// <param name="customerID">Customer ID</param> /// <param name="sysTrxNo">SysTrxNo</param> /// <param name="sysTrxLine">sysTrxLine</param> /// <param name="session">session object</param> /// <returns>list of BOL item</returns> public static List <DAL.BOLItemRow> GetUpdatedBolItem(String customerID, Decimal sysTrxNo, Int32 sysTrxLine, ISession session, String VersionNo = "") { BOLItemTableAdapter ta = new BOLItemTableAdapter(); ta.CurrentConnection = session; return(ta.GetUpdatedData(customerID, sysTrxNo, sysTrxLine).ToList()); }
/// <summary> /// UpdateBolItem /// Function to update the BOL item records /// </summary> /// <param name="shipDocSysTrxNo">Shipment doc system transaction number</param> /// <param name="shipDocSysTrxLine">Shipment doc system transaction line</param> /// <param name="id">Id</param> /// <param name="session">Session object</param> public static void UpdateBolItem(Decimal?shipDocSysTrxNo, Int32?shipDocSysTrxLine, Guid id, ISession session, String VersionNo = "") { BOLItemTableAdapter ta = new BOLItemTableAdapter(); ta.CurrentConnection = session; // 2014.03.31 Ramesh M Added modified SQL statement to support multi line item of ship doc ta.UpdateQuery(shipDocSysTrxNo, shipDocSysTrxLine, id); }