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