首页 > 解决方案 > 如果列为空,csvHelper 切换到另一个列名

问题描述

Map(m => m.Invoice_Amount).Name("Invoice Amount");

目前我正在通过上述映射提取发票金额。映射时有没有办法检测映射字段是否为空,然后将其切换到另一列,例如“发票到期金额”?

        public InvoiceMap()
    {

        Map(m => m.Invoice_Number).Name("Invoice Number");
        Map(m => m.Hierarchy_Invoice_Number).Name("Hierarchy Invoice Number");
        Map(m => m.Account_Number).Name("Account Number");
        Map(m => m.Invoice_Amount).Name("Invoice Amount");
        Map(m => m.Hierarchy_Account_Number).Name("Hierarchy Account Number");
    }

这是我对 csvHelper 的映射。

例如,我想做的是:

if(Map(m => m.Hierarchy_Account_Number).Name("Hierarchy Account Number") ==  null){
//if the Hierarchy account is null then use the below Invoice_Amount
    Map(m => m.Invoice_Amount).Name("Invoice Due Amount");

}else{
//Otherwise use this mapping
    Map(m => m.Invoice_Amount).Name("Invoice Amount");
}

标签: c#csvhelper

解决方案


推荐阅读