//-------------------------------------------------------------------//
private static object ExcelDateArray2QDateTime(Array a)
{
var dim1 = a.GetLength(0);
if (a.Rank == 1)
{
var res = new QDateTime[dim1];
for (var i = 0; i < dim1; i++)
{
res[i] = (QDateTime)ExcelDate2QDateTime(a.GetValue(i));
}
return(res);
}
var dim2 = a.GetLength(1);
var r = new object[dim2]; //two dimensional array
for (var i = 0; i < dim2; i++)
{
var elem = new QDateTime[dim1];
for (var j = 0; j < dim1; j++)
{
elem[j] = (QDateTime)ExcelDate2QDateTime(a.GetValue(j, i));
}
r[i] = elem;
}
return(r);
}
public void testQDateTimeFromString()
{
Assert.AreEqual(new QDateTime(-364.0000115).Value, QDateTime.FromString("1999.01.01T23:59:59.000").Value,
0.001);
Assert.AreEqual(new QDateTime(0.0).Value, QDateTime.FromString("2000.01.01T00:00:00.000").Value, 0.001);
Assert.AreEqual(new QDateTime(2008.0833218).Value, QDateTime.FromString("2005.07.01T01:59:59.000").Value,
0.001);
Assert.AreEqual(new QDateTime(3653.599792).Value, QDateTime.FromString("2010.01.01T14:23:42.000").Value,
0.001);
Assert.AreEqual(new QDateTime(double.NaN), QDateTime.FromString(null));
Assert.AreEqual(new QDateTime(double.NaN), QDateTime.FromString(""));
Assert.AreEqual(new QDateTime(double.NaN), QDateTime.FromString("0Nz"));
}
private PmsHeadH GetResultPmsHeadH(string description, string item, string valueFrom, string valueTo, PmsHeadH pmsHeadH)
{
PmsHeadH resultPmsHeadH = new PmsHeadH();
description = description.Replace("#DateTime#", QDateTime.FormatLongDate(pmsHeadH.Maintaindate));
description = description.Replace("#User#", pmsHeadH.Maintainuser);
description = description.Replace("#Item#", item);
description = description.Replace("#ValueFrom#", valueFrom);
description = description.Replace("#ValueTo#", valueTo);
if (item == "Due Date")
{
description = description + " for " + pmsHeadH.ReasonType + " (" + pmsHeadH.Reason + ")";
}
resultPmsHeadH.Description = description;
return(resultPmsHeadH);
}
