public static Option<DataRow> orderLookup(string orderNumber, GetSqlServer getSqlServer) { return getSqlServer.FilledRowOption("select TOP 1 * FROM [ordered] where ordernumber like '" + orderNumber + "' ORDER BY ID DESC"); }
/// <summary> /// use the DB to generate a the next orderNumber /// </summary> /// <returns></returns> /// <remarks></remarks> public static string getNewOrderNumber(GetSqlServer getSqlServer) { TruncateOrderNumbersOnDateChange(getSqlServer); DataRow q = getSqlServer.FilledRowOption("insert into ordernumber (OrderLast,Ordernumber) select TOP 1 OrderLast+1, ordernumber+1 FROM ordernumber ORDER BY OrderLast DESC; select TOP 1 OrderLast, Ordernumber FROM ordernumber ORDER BY OrderLast DESC;").get; string neworernumber = q["Ordernumber"].ToString(); if (neworernumber.Length > 4) { string letters = Strings.Left(neworernumber, 2); string ordernums = Strings.Right(neworernumber, 3); neworernumber = Strings.Chr(int.Parse(letters)) + ordernums; } return date2ordernumber(System.DateTime.Now) + neworernumber.PadLeft(4, '0'); }