/// <summary>
/// インポートデータの値のチェックを行います
/// </summary>
private static List <CheckImportSheetsResult> CheckImportSheetValue(DataSet _importSheets)
{
List <CheckImportSheetsResult> result = new List <CheckImportSheetsResult>();
DataTable sheet = UtilLib.ConvertTableFirstRowAsColumnName(_importSheets.Tables[SHEET_NAME]);
foreach (DataRow row in sheet.Rows)
{
string dueDate = Convert.ToString(row[COLUMN_NAME_DUE_DATE]);
string statusName = Convert.ToString(row[COLUMN_NAME_STATUS_NAME]);
string subject = Convert.ToString(row[COLUMN_NAME_SUBJECT]);
DateTime tempDateTime;
if (!(DateTime.TryParse(dueDate, out tempDateTime)))
{
result.Add(CheckImportSheetsResult.COLUMN_DUE_DATE_INVALID_DATETIME);
}
if (!(StatusCode.HasName(statusName)))
{
result.Add(CheckImportSheetsResult.COLUMN_STATUS_NAME_INVALID_CODE_NAME);
}
if (string.IsNullOrEmpty(subject))
{
result.Add(CheckImportSheetsResult.COLUMN_SUBJECT_BLANK);
}
}
return(result);
}
public void Test0040()
{
Assert.IsFalse(StatusCode.HasName(string.Empty));
Assert.IsFalse(StatusCode.HasName(StatusCode.CODE_NOT_YET));
Assert.IsFalse(StatusCode.HasName(StatusCode.CODE_FINISHED));
Assert.IsTrue(StatusCode.HasName(StatusCode.NAME_NOT_YET));
Assert.IsTrue(StatusCode.HasName(StatusCode.NAME_FINISHED));
}
