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