public static OrderLine Load(string Id) { bool success = false; OrderLine result = new OrderLine (); { QueryBuilder qb = new QueryBuilder (QueryBuilderType.Select); qb.Table ("ordlinie"); qb.Columns ( "sidstrettet", "varenummer", "linienr", "antal", "pris", "belxb", "tekst", "enhed", "oprettet" ); qb.AddWhere ("lxbenummer like '"+ Id +"'"); Query query = Runtime.DBConnection.Query (qb.QueryString); if (query.Success) { if (query.NextRow ()) { result._id = Id; result._createtimestamp = SNDK.Date.DateTimeToTimestamp (query.GetDateTime (qb.ColumnPos ("oprettet"))); result._productid = query.GetString (qb.ColumnPos ("varenummer")); result._sort = query.GetDecimal (qb.ColumnPos ("linienr")); result._amount = query.GetDecimal (qb.ColumnPos ("antal")); result._price = query.GetDecimal (qb.ColumnPos ("pris")); result._total = query.GetDecimal (qb.ColumnPos ("belxb")); result._text = query.GetString (qb.ColumnPos ("tekst")); result._unit = query.GetString (qb.ColumnPos ("enhed")); result._updatetimestamp = SNDK.Date.DateTimeToTimestamp (query.GetDateTime (qb.ColumnPos ("sidstrettet"))); success = true; } } query.Dispose (); query = null; qb = null; if (!success) { // Exception: Exception.OrderLineLoadId throw new Exception (string.Format (Strings.Exception.OrderLineLoadId, Id)); } } // Load notes. { QueryBuilder qb = new QueryBuilder (QueryBuilderType.Select); qb.Table ("notat"); qb.Columns ( "tekst" ); qb.AddWhere ("notatrecid = '"+ Id +"'"); qb.OrderBy ("linienummer", QueryBuilderOrder.Accending); Query query = Runtime.DBConnection.Query (qb.QueryString); if (query.Success) { while (query.NextRow ()) { result._notes += query.GetString (qb.ColumnPos ("tekst")) +"\n"; } } query.Dispose (); query = null; qb = null; result._notes = result._notes.TrimEnd ("\n".ToCharArray ()); } // TEMP1 result._temp1 = false; return result; }
public void AddLine(string ProductId, string Text, DateTime PeriodBegin, DateTime PeriodEnd, string Unit, decimal Amount, decimal Price, decimal Total, string Notes) { OrderLine line = new OrderLine (this); line.ProductId = ProductId; line.Sort = this._orderlines.Count; line.Text = Text; line.PeriodBegin = PeriodBegin; line.PeriodEnd = PeriodEnd; line.Unit = Unit; line.Amount = Amount; line.Price = Price; line.Total = Total; line.Notes = Notes; this._orderlines.Add (line); }