本文整理汇总了C#中OfficeOpenXml.ExcelWorksheet.HasValue方法的典型用法代码示例。如果您正苦于以下问题：C# ExcelWorksheet.HasValue方法的具体用法？C# ExcelWorksheet.HasValue怎么用？C# ExcelWorksheet.HasValue使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类OfficeOpenXml.ExcelWorksheet的用法示例。
在下文中一共展示了ExcelWorksheet.HasValue方法的1个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: GetProductVariant
private static ProductVariantImportDataTransferObject GetProductVariant(Dictionary<string, List<string>> parseErrors, ExcelWorksheet worksheet,
int rowId, string handle)
{
var productVariant = new ProductVariantImportDataTransferObject
{
Name = worksheet.GetValue<string>(rowId, 11)
};
if (!GeneralHelper.IsValidInput<decimal>(worksheet.GetValue<string>(rowId, 12)))
parseErrors[handle].Add("Price value is not a valid decimal number.");
else if (worksheet.GetValue<string>(rowId, 12).HasValue())
productVariant.Price =
GeneralHelper.GetValue<decimal>(worksheet.GetValue<string>(rowId, 12));
else
parseErrors[handle].Add("Price is required.");
if (!GeneralHelper.IsValidInput<decimal>(worksheet.GetValue<string>(rowId, 13)))
parseErrors[handle].Add(
"Previous Price value is not a valid decimal number.");
else
productVariant.PreviousPrice =
GeneralHelper.GetValue<decimal>(worksheet.GetValue<string>(rowId, 13));
if (!GeneralHelper.IsValidInput<int>(worksheet.GetValue<string>(rowId, 14)))
parseErrors[handle].Add("Tax Rate Id value is not a valid number.");
else
productVariant.TaxRate =
GeneralHelper.GetValue<int>(worksheet.GetValue<string>(rowId, 14));
if (!GeneralHelper.IsValidInput<decimal>(worksheet.GetValue<string>(rowId, 15)))
parseErrors[handle].Add("Weight value is not a valid decimal number.");
else
productVariant.Weight =
GeneralHelper.GetValue<decimal>(worksheet.GetValue<string>(rowId, 15));
if (!GeneralHelper.IsValidInput<int>(worksheet.GetValue<string>(rowId, 16)))
parseErrors[handle].Add("Stock value is not a valid decimal number.");
else
productVariant.Stock = worksheet.HasValue(rowId, 16)
? GeneralHelper.GetValue<int>(
worksheet.GetValue<string>(rowId, 16))
: (int?) null;
if (!worksheet.GetValue<string>(rowId, 17).HasValue() ||
(worksheet.GetValue<string>(rowId, 17) != "Track" &&
worksheet.GetValue<string>(rowId, 17) != "DontTrack"))
parseErrors[handle].Add(
"Tracking Policy must have either 'Track' or 'DontTrack' value.");
else
{
productVariant.TrackingPolicy = worksheet.GetValue<string>(rowId, 17) == "Track"
? TrackingPolicy.Track
: TrackingPolicy.DontTrack;
}
if (worksheet.GetValue<string>(rowId, 18).HasValue())
productVariant.SKU = worksheet.GetValue<string>(rowId, 18);
else
parseErrors[handle].Add("SKU is required.");
productVariant.Barcode = worksheet.GetValue<string>(rowId, 19);
productVariant.ManufacturerPartNumber = worksheet.GetValue<string>(rowId, 20);
productVariant.ETag = worksheet.GetValue<string>(rowId, 33);
return productVariant;
}