//-------------------------------------------------------------------//
private static object ExcelDateArray2QSecond(Array a)
{
var dim1 = a.GetLength(0);
if (a.Rank == 1)
{
var res = new QSecond[dim1];
for (var i = 0; i < dim1; i++)
{
res[i] = (QSecond)ExcelDate2QSecond(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 QSecond[dim1];
for (var j = 0; j < dim1; j++)
{
elem[j] = (QSecond)ExcelDate2QSecond(a.GetValue(j, i));
}
r[i] = elem;
}
return(r);
}
public void testQSecondFromString()
{
Assert.AreEqual(new QSecond(0), QSecond.FromString("00:00:00"));
Assert.AreEqual(new QSecond(48613), QSecond.FromString("13:30:13"));
Assert.AreEqual(new QSecond(86399), QSecond.FromString("23:59:59"));
Assert.AreEqual(new QSecond(186399), QSecond.FromString("51:46:39"));
Assert.AreEqual(new QSecond(-86399), QSecond.FromString("-23:59:59"));
Assert.AreEqual(new QSecond(int.MinValue), QSecond.FromString(null));
Assert.AreEqual(new QSecond(int.MinValue), QSecond.FromString(""));
Assert.AreEqual(new QSecond(int.MinValue), QSecond.FromString("0Nv"));
}
