private DataTable addColumon_Actzhgkrlxhl_FCDS(DataTable dt, CafcService.FuelCAFCDetails[] detailData)
{
var unionResult = (from d in dt.AsEnumerable()
join l in detailData
on d.Field <string>("CLXH") equals l.Clxh into detail
from dl in detail.DefaultIfEmpty()
select new
{
VIN = d.Field <string>("VIN"),
CLXH = d.Field <string>("CLXH"),
TYMC = d.Field <string>("TYMC"),
TGTZHGKRLXHL = dl == null ? "" : dl.TgtZhgkrlxhl.ToString(),
FCDS_HHDL_ZHGKRLXHL = d.Field <string>("FCDS_HHDL_ZHGKRLXHL"),
ZCZBZL = d.Field <string>("ZCZBZL"),
ZWPS = d.Field <string>("ZWPS"),
RLLX = d.Field <string>("RLLX"),
FCDS_HHDL_BSQXS = d.Field <string>("FCDS_HHDL_BSQXS"),
QCSCQY = d.Field <string>("QCSCQY"),
JKQCZJXS = d.Field <string>("JKQCZJXS"),
JYJGMC = d.Field <string>("JYJGMC"),
JYBGBH = d.Field <string>("JYBGBH"),
CLZZRQ = d.Field <DateTime>("CLZZRQ").ToString("yyyy/MM/dd"),
CLZL = d.Field <string>("CLZL"),
YYC = d.Field <string>("YYC"),
QDXS = d.Field <string>("QDXS"),
ZDSJZZL = d.Field <string>("ZDSJZZL"),
ZGCS = d.Field <string>("ZGCS"),
EDZK = d.Field <string>("EDZK"),
LTGG = d.Field <string>("LTGG"),
LJ = d.Field <string>("LJ"),
ZJ = d.Field <string>("ZJ"),
FCDS_HHDL_HHDLJGXS = d.Field <string>("FCDS_HHDL_HHDLJGXS"),
FCDS_HHDL_XSMSSDXZGN = d.Field <string>("FCDS_HHDL_XSMSSDXZGN"),
FCDS_HHDL_DLXDCZZL = d.Field <string>("FCDS_HHDL_DLXDCZZL"),
FCDS_HHDL_DLXDCZZNL = d.Field <string>("FCDS_HHDL_DLXDCZZNL"),
FCDS_HHDL_DLXDCBNL = d.Field <string>("FCDS_HHDL_DLXDCBNL"),
FCDS_HHDL_CDDMSXZHGKXSLC = d.Field <string>("FCDS_HHDL_CDDMSXZHGKXSLC"),
FCDS_HHDL_CDDMSXZGCS = d.Field <string>("FCDS_HHDL_CDDMSXZGCS"),
FCDS_HHDL_DLXDCZBCDY = d.Field <string>("FCDS_HHDL_DLXDCZBCDY"),
FCDS_HHDL_QDDJLX = d.Field <string>("FCDS_HHDL_QDDJLX"),
FCDS_HHDL_HHDLZDDGLB = d.Field <string>("FCDS_HHDL_HHDLZDDGLB"),
FCDS_HHDL_QDDJFZNJ = d.Field <string>("FCDS_HHDL_QDDJFZNJ"),
FCDS_HHDL_QDDJEDGL = d.Field <string>("FCDS_HHDL_QDDJEDGL"),
FCDS_HHDL_SQGKRLXHL = d.Field <string>("FCDS_HHDL_SQGKRLXHL"),
FCDS_HHDL_SJGKRLXHL = d.Field <string>("FCDS_HHDL_SJGKRLXHL"),
FCDS_HHDL_ZHKGCO2PL = d.Field <string>("FCDS_HHDL_ZHKGCO2PL"),
FCDS_HHDL_FDJXH = d.Field <string>("FCDS_HHDL_FDJXH"),
FCDS_HHDL_QGS = d.Field <string>("FCDS_HHDL_QGS"),
FCDS_HHDL_PL = d.Field <string>("FCDS_HHDL_PL"),
FCDS_HHDL_EDGL = d.Field <string>("FCDS_HHDL_EDGL"),
FCDS_HHDL_JGL = d.Field <string>("FCDS_HHDL_JGL"),
FCDS_HHDL_BSQDWS = d.Field <string>("FCDS_HHDL_BSQDWS"),
}).ToList();
return(ObjectReflect.ToDataTable(unionResult));
}
private DataTable addColumon_Actzhgkrlxhl_CTNY(DataTable dt, CafcService.FuelCAFCDetails[] detailData)
{
var unionResult = (from d in dt.AsEnumerable()
join l in detailData
on d.Field <string>("CLXH") equals l.Clxh into detail
from dl in detail.DefaultIfEmpty()
select new
{
VIN = d.Field <string>("VIN"),
CLXH = d.Field <string>("CLXH"),
TYMC = d.Field <string>("TYMC"),
TGTZHGKRLXHL = dl == null ? "" : dl.TgtZhgkrlxhl.ToString(),
CT_ZHGKRLXHL = d.Field <string>("CT_ZHGKRLXHL"),
ZCZBZL = d.Field <string>("ZCZBZL"),
ZWPS = d.Field <string>("ZWPS"),
RLLX = d.Field <string>("RLLX"),
CT_BSQXS = d.Field <string>("CT_BSQXS"),
QCSCQY = d.Field <string>("QCSCQY"),
JKQCZJXS = d.Field <string>("JKQCZJXS"),
JYJGMC = d.Field <string>("JYJGMC"),
JYBGBH = d.Field <string>("JYBGBH"),
CLZZRQ = d.Field <DateTime>("CLZZRQ").ToString("yyyy/MM/dd"),
CLZL = d.Field <string>("CLZL"),
YYC = d.Field <string>("YYC"),
QDXS = d.Field <string>("QDXS"),
ZDSJZZL = d.Field <string>("ZDSJZZL"),
ZGCS = d.Field <string>("ZGCS"),
EDZK = d.Field <string>("EDZK"),
LTGG = d.Field <string>("LTGG"),
LJ = d.Field <string>("LJ"),
ZJ = d.Field <string>("ZJ"),
CT_FDJXH = d.Field <string>("CT_FDJXH"),
CT_QGS = d.Field <string>("CT_QGS"),
CT_PL = d.Field <string>("CT_PL"),
CT_EDGL = d.Field <string>("CT_EDGL"),
CT_JGL = d.Field <string>("CT_JGL"),
CT_BSQDWS = d.Field <string>("CT_BSQDWS"),
CT_SQGKRLXHL = d.Field <string>("CT_SQGKRLXHL"),
CT_SJGKRLXHL = d.Field <string>("CT_SJGKRLXHL"),
CT_ZHGKCO2PFL = d.Field <string>("CT_ZHGKCO2PFL"),
}).ToList();
return(ObjectReflect.ToDataTable(unionResult));
}
/// <summary>
/// 读取Excel并合并到DataTable返回到系统
/// </summary>
/// <param name="filePath">Excel路径</param>
/// <param name="tableName">燃料类型</param>
/// <returns></returns>
public DataTable ReadBackToSYS(string filePath, string tableName)
{
DataSet ds = SwitchColumnName(ReadExcel(filePath));
// STEP1：导入系统，拼接数据
if (tableName.Equals("传统能源"))
{
var CT = from CLJBXX in ds.Tables["基本信息"].AsEnumerable()
join RLLXPARAM in ds.Tables["传统能源"].AsEnumerable()
on CLJBXX.Field <string>("VIN") equals RLLXPARAM.Field <string>("VIN")
select new
{
VIN = CLJBXX.Field <string>("VIN"),
CLZZRQ = CLJBXX.Field <string>("CLZZRQ") ?? string.Empty,
HGSPBM = CLJBXX.Field <string>("HGSPBM") ?? string.Empty,
QTXX = CLJBXX.Field <string>("QTXX") ?? string.Empty,
CLXH = CLJBXX.Field <string>("CLXH") ?? string.Empty,
CLZL = CLJBXX.Field <string>("CLZL") ?? string.Empty,
EDZK = CLJBXX.Field <string>("EDZK") ?? string.Empty,
JKQCZJXS = CLJBXX.Field <string>("JKQCZJXS") ?? string.Empty,
JYBGBH = (string)CLJBXX.Field <string>("JYBGBH") ?? string.Empty,
JYJGMC = CLJBXX.Field <string>("JYJGMC") ?? string.Empty,
LJ = (string)CLJBXX.Field <string>("LJ") ?? string.Empty,
LTGG = CLJBXX.Field <string>("LTGG") ?? string.Empty,
QCSCQY = CLJBXX.Field <string>("QCSCQY") ?? string.Empty,
QDXS = CLJBXX.Field <string>("QDXS") ?? string.Empty,
RLLX = CLJBXX.Field <string>("RLLX") ?? string.Empty,
USER_ID = CLJBXX.Field <string>("USER_ID") ?? string.Empty,
TYMC = (string)CLJBXX.Field <string>("TYMC") ?? string.Empty,
YYC = CLJBXX.Field <string>("YYC") ?? string.Empty,
ZCZBZL = CLJBXX.Field <string>("ZCZBZL") ?? string.Empty,
ZDSJZZL = CLJBXX.Field <string>("ZDSJZZL") ?? string.Empty,
ZGCS = CLJBXX.Field <string>("ZGCS") ?? string.Empty,
ZJ = CLJBXX.Field <string>("ZJ") ?? string.Empty,
ZWPS = CLJBXX.Field <string>("ZWPS") ?? string.Empty,
CT_BSQDWS = RLLXPARAM.Field <string>("CT_BSQDWS") ?? string.Empty,
CT_BSQXS = (string)RLLXPARAM.Field <string>("CT_BSQXS") ?? string.Empty,
CT_EDGL = RLLXPARAM.Field <string>("CT_EDGL") ?? string.Empty,
CT_FDJXH = RLLXPARAM.Field <string>("CT_FDJXH") ?? string.Empty,
CT_JGL = RLLXPARAM.Field <string>("CT_JGL") ?? string.Empty,
CT_PL = RLLXPARAM.Field <string>("CT_PL") ?? string.Empty,
CT_QCJNJS = RLLXPARAM.Field <string>("CT_QCJNJS") ?? string.Empty,
CT_QGS = RLLXPARAM.Field <string>("CT_QGS") ?? string.Empty,
CT_QTXX = RLLXPARAM.Field <string>("CT_QTXX") ?? string.Empty,
CT_SJGKRLXHL = RLLXPARAM.Field <string>("CT_SJGKRLXHL") ?? string.Empty,
CT_SQGKRLXHL = RLLXPARAM.Field <string>("CT_SQGKRLXHL") ?? string.Empty,
CT_ZHGKCO2PFL = RLLXPARAM.Field <string>("CT_ZHGKCO2PFL") ?? string.Empty,
CT_ZHGKRLXHL = RLLXPARAM.Field <string>("CT_ZHGKRLXHL") ?? string.Empty,
};
return(ObjectReflect.ToDataTable(CT));
}
if (tableName.Equals("非插电式混合动力"))
{
var FCDS_HHDL = from CLJBXX in ds.Tables["基本信息"].AsEnumerable()
join RLLXPARAM in ds.Tables["非插电式混合动力"].AsEnumerable()
on CLJBXX.Field <string>("VIN") equals RLLXPARAM.Field <string>("VIN")
select new
{
VIN = CLJBXX.Field <string>("VIN"),
CLZZRQ = CLJBXX.Field <string>("CLZZRQ") ?? string.Empty,
HGSPBM = CLJBXX.Field <string>("HGSPBM") ?? string.Empty,
QTXX = CLJBXX.Field <string>("QTXX") ?? string.Empty,
CLXH = CLJBXX.Field <string>("CLXH") ?? string.Empty,
CLZL = CLJBXX.Field <string>("CLZL") ?? string.Empty,
EDZK = CLJBXX.Field <string>("EDZK") ?? string.Empty,
JKQCZJXS = CLJBXX.Field <string>("JKQCZJXS") ?? string.Empty,
JYBGBH = CLJBXX.Field <string>("JYBGBH") ?? string.Empty,
JYJGMC = CLJBXX.Field <string>("JYJGMC") ?? string.Empty,
LJ = CLJBXX.Field <string>("LJ") ?? string.Empty,
LTGG = CLJBXX.Field <string>("LTGG") ?? string.Empty,
QCSCQY = CLJBXX.Field <string>("QCSCQY") ?? string.Empty,
QDXS = CLJBXX.Field <string>("QDXS") ?? string.Empty,
RLLX = CLJBXX.Field <string>("RLLX") ?? string.Empty,
USER_ID = CLJBXX.Field <string>("USER_ID") ?? string.Empty,
TYMC = CLJBXX.Field <string>("TYMC") ?? string.Empty,
YYC = CLJBXX.Field <string>("YYC") ?? string.Empty,
ZCZBZL = CLJBXX.Field <string>("ZCZBZL") ?? string.Empty,
ZDSJZZL = CLJBXX.Field <string>("ZDSJZZL") ?? string.Empty,
ZGCS = CLJBXX.Field <string>("ZGCS") ?? string.Empty,
ZJ = CLJBXX.Field <string>("ZJ") ?? string.Empty,
ZWPS = CLJBXX.Field <string>("ZWPS") ?? string.Empty,
FCDS_HHDL_BSQDWS = RLLXPARAM.Field <string>("FCDS_HHDL_BSQDWS") ?? string.Empty,
FCDS_HHDL_BSQXS = RLLXPARAM.Field <string>("FCDS_HHDL_BSQXS") ?? string.Empty,
FCDS_HHDL_CDDMSXZGCS = RLLXPARAM.Field <string>("FCDS_HHDL_CDDMSXZGCS") ?? string.Empty,
FCDS_HHDL_CDDMSXZHGKXSLC = RLLXPARAM.Field <string>("FCDS_HHDL_CDDMSXZHGKXSLC") ?? string.Empty,
FCDS_HHDL_DLXDCBNL = RLLXPARAM.Field <string>("FCDS_HHDL_DLXDCBNL") ?? string.Empty,
FCDS_HHDL_DLXDCZBCDY = RLLXPARAM.Field <string>("FCDS_HHDL_DLXDCZBCDY") ?? string.Empty,
FCDS_HHDL_DLXDCZZL = RLLXPARAM.Field <string>("FCDS_HHDL_DLXDCZZL") ?? string.Empty,
FCDS_HHDL_DLXDCZZNL = RLLXPARAM.Field <string>("FCDS_HHDL_DLXDCZZNL") ?? string.Empty,
FCDS_HHDL_EDGL = RLLXPARAM.Field <string>("FCDS_HHDL_EDGL") ?? string.Empty,
FCDS_HHDL_FDJXH = RLLXPARAM.Field <string>("FCDS_HHDL_FDJXH") ?? string.Empty,
FCDS_HHDL_HHDLJGXS = RLLXPARAM.Field <string>("FCDS_HHDL_HHDLJGXS") ?? string.Empty,
FCDS_HHDL_HHDLZDDGLB = RLLXPARAM.Field <string>("FCDS_HHDL_HHDLZDDGLB") ?? string.Empty,
FCDS_HHDL_JGL = RLLXPARAM.Field <string>("FCDS_HHDL_JGL") ?? string.Empty,
FCDS_HHDL_PL = RLLXPARAM.Field <string>("FCDS_HHDL_PL") ?? string.Empty,
FCDS_HHDL_QCJNJS = RLLXPARAM.Field <string>("FCDS_HHDL_QCJNJS") ?? string.Empty,
FCDS_HHDL_QDDJEDGL = RLLXPARAM.Field <string>("FCDS_HHDL_QDDJEDGL") ?? string.Empty,
FCDS_HHDL_QDDJFZNJ = RLLXPARAM.Field <string>("FCDS_HHDL_QDDJFZNJ") ?? string.Empty,
FCDS_HHDL_QDDJLX = RLLXPARAM.Field <string>("FCDS_HHDL_QDDJLX") ?? string.Empty,
FCDS_HHDL_QGS = RLLXPARAM.Field <string>("FCDS_HHDL_QGS") ?? string.Empty,
FCDS_HHDL_SJGKRLXHL = RLLXPARAM.Field <string>("FCDS_HHDL_SJGKRLXHL") ?? string.Empty,
FCDS_HHDL_SQGKRLXHL = RLLXPARAM.Field <string>("FCDS_HHDL_SQGKRLXHL") ?? string.Empty,
FCDS_HHDL_XSMSSDXZGN = RLLXPARAM.Field <string>("FCDS_HHDL_XSMSSDXZGN") ?? string.Empty,
FCDS_HHDL_ZHGKRLXHL = RLLXPARAM.Field <string>("FCDS_HHDL_ZHGKRLXHL") ?? string.Empty,
FCDS_HHDL_ZHKGCO2PL = RLLXPARAM.Field <string>("FCDS_HHDL_ZHKGCO2PL") ?? string.Empty,
};
return(ObjectReflect.ToDataTable(FCDS_HHDL));
}
if (tableName.Equals("插电式混合动力"))
{
var CDS_HHDL = from CLJBXX in ds.Tables["基本信息"].AsEnumerable()
join RLLXPARAM in ds.Tables["插电式混合动力"].AsEnumerable()
on CLJBXX.Field <string>("VIN") equals RLLXPARAM.Field <string>("VIN")
select new
{
VIN = CLJBXX.Field <string>("VIN"),
CLZZRQ = CLJBXX.Field <string>("CLZZRQ") ?? string.Empty,
HGSPBM = CLJBXX.Field <string>("HGSPBM") ?? string.Empty,
QTXX = CLJBXX.Field <string>("QTXX") ?? string.Empty,
CLXH = CLJBXX.Field <string>("CLXH") ?? string.Empty,
CLZL = CLJBXX.Field <string>("CLZL") ?? string.Empty,
EDZK = CLJBXX.Field <string>("EDZK").ToString() ?? string.Empty,
JKQCZJXS = CLJBXX.Field <string>("JKQCZJXS") ?? string.Empty,
JYBGBH = CLJBXX.Field <string>("JYBGBH") ?? string.Empty,
JYJGMC = CLJBXX.Field <string>("JYJGMC") ?? string.Empty,
LJ = CLJBXX.Field <string>("LJ") ?? string.Empty,
LTGG = CLJBXX.Field <string>("LTGG") ?? string.Empty,
QCSCQY = CLJBXX.Field <string>("QCSCQY") ?? string.Empty,
QDXS = CLJBXX.Field <string>("QDXS") ?? string.Empty,
RLLX = CLJBXX.Field <string>("RLLX") ?? string.Empty,
USER_ID = CLJBXX.Field <string>("USER_ID") ?? string.Empty,
TYMC = CLJBXX.Field <string>("TYMC") ?? string.Empty,
YYC = CLJBXX.Field <string>("YYC") ?? string.Empty,
ZCZBZL = CLJBXX.Field <string>("ZCZBZL") ?? string.Empty,
ZDSJZZL = CLJBXX.Field <string>("ZDSJZZL") ?? string.Empty,
ZGCS = CLJBXX.Field <string>("ZGCS") ?? string.Empty,
ZJ = CLJBXX.Field <string>("ZJ") ?? string.Empty,
ZWPS = CLJBXX.Field <string>("ZWPS") ?? string.Empty,
CDS_HHDL_BSQDWS = RLLXPARAM.Field <string>("CDS_HHDL_BSQDWS") ?? string.Empty,
CDS_HHDL_BSQXS = RLLXPARAM.Field <string>("CDS_HHDL_BSQXS") ?? string.Empty,
CDS_HHDL_CDDMSXZGCS = RLLXPARAM.Field <string>("CDS_HHDL_CDDMSXZGCS") ?? string.Empty,
CDS_HHDL_CDDMSXZHGKXSLC = RLLXPARAM.Field <string>("CDS_HHDL_CDDMSXZHGKXSLC") ?? string.Empty,
CDS_HHDL_DLXDCBNL = RLLXPARAM.Field <string>("CDS_HHDL_DLXDCBNL") ?? string.Empty,
CDS_HHDL_DLXDCZBCDY = RLLXPARAM.Field <string>("CDS_HHDL_DLXDCZBCDY") ?? string.Empty,
CDS_HHDL_DLXDCZZL = RLLXPARAM.Field <string>("CDS_HHDL_DLXDCZZL") ?? string.Empty,
CDS_HHDL_DLXDCZZNL = RLLXPARAM.Field <string>("CDS_HHDL_DLXDCZZNL") ?? string.Empty,
CDS_HHDL_EDGL = RLLXPARAM.Field <string>("CDS_HHDL_EDGL") ?? string.Empty,
CDS_HHDL_FDJXH = RLLXPARAM.Field <string>("CDS_HHDL_FDJXH") ?? string.Empty,
CDS_HHDL_HHDLJGXS = RLLXPARAM.Field <string>("CDS_HHDL_HHDLJGXS") ?? string.Empty,
CDS_HHDL_HHDLZDDGLB = RLLXPARAM.Field <string>("CDS_HHDL_HHDLZDDGLB") ?? string.Empty,
CDS_HHDL_JGL = RLLXPARAM.Field <string>("CDS_HHDL_JGL") ?? string.Empty,
CDS_HHDL_PL = RLLXPARAM.Field <string>("CDS_HHDL_PL") ?? string.Empty,
CDS_HHDL_QDDJEDGL = RLLXPARAM.Field <string>("CDS_HHDL_QDDJEDGL") ?? string.Empty,
CDS_HHDL_QDDJFZNJ = RLLXPARAM.Field <string>("CDS_HHDL_QDDJFZNJ") ?? string.Empty,
CDS_HHDL_QDDJLX = RLLXPARAM.Field <string>("CDS_HHDL_QDDJLX") ?? string.Empty,
CDS_HHDL_QGS = RLLXPARAM.Field <string>("CDS_HHDL_QGS") ?? string.Empty,
CDS_HHDL_SJGKRLXHL = RLLXPARAM.Field <string>("CDS_HHDL_SJGKRLXHL") ?? string.Empty,
CDS_HHDL_SQGKRLXHL = RLLXPARAM.Field <string>("CDS_HHDL_SQGKRLXHL") ?? string.Empty,
CDS_HHDL_XSMSSDXZGN = RLLXPARAM.Field <string>("CDS_HHDL_XSMSSDXZGN") ?? string.Empty,
CDS_HHDL_ZHGKDNXHL = RLLXPARAM.Field <string>("CDS_HHDL_ZHGKDNXHL") ?? string.Empty,
CDS_HHDL_ZHGKRLXHL = RLLXPARAM.Field <string>("CDS_HHDL_ZHGKRLXHL") ?? string.Empty,
CDS_HHDL_ZHKGCO2PL = RLLXPARAM.Field <string>("CDS_HHDL_ZHKGCO2PL") ?? string.Empty,
};
return(ObjectReflect.ToDataTable(CDS_HHDL));
}
if (tableName.Equals("纯电动"))
{
var CDD = from CLJBXX in ds.Tables["基本信息"].AsEnumerable()
join RLLXPARAM in ds.Tables["纯电动"].AsEnumerable()
on CLJBXX.Field <string>("VIN") equals RLLXPARAM.Field <string>("VIN")
select new
{
VIN = CLJBXX.Field <string>("VIN"),
CLZZRQ = CLJBXX.Field <string>("CLZZRQ") ?? string.Empty,
HGSPBM = CLJBXX.Field <string>("HGSPBM") ?? string.Empty,
QTXX = CLJBXX.Field <string>("QTXX") ?? string.Empty,
CLXH = CLJBXX.Field <string>("CLXH") ?? string.Empty,
CLZL = CLJBXX.Field <string>("CLZL") ?? string.Empty,
EDZK = CLJBXX.Field <string>("EDZK") ?? string.Empty,
JKQCZJXS = CLJBXX.Field <string>("JKQCZJXS") ?? string.Empty,
JYBGBH = CLJBXX.Field <string>("JYBGBH") ?? string.Empty,
JYJGMC = CLJBXX.Field <string>("JYJGMC") ?? string.Empty,
LJ = CLJBXX.Field <string>("LJ") ?? string.Empty,
LTGG = CLJBXX.Field <string>("LTGG") ?? string.Empty,
QCSCQY = CLJBXX.Field <string>("QCSCQY") ?? string.Empty,
QDXS = CLJBXX.Field <string>("QDXS") ?? string.Empty,
RLLX = CLJBXX.Field <string>("RLLX") ?? string.Empty,
USER_ID = CLJBXX.Field <string>("USER_ID") ?? string.Empty,
TYMC = CLJBXX.Field <string>("TYMC") ?? string.Empty,
YYC = CLJBXX.Field <string>("YYC") ?? string.Empty,
ZCZBZL = CLJBXX.Field <string>("ZCZBZL") ?? string.Empty,
ZDSJZZL = CLJBXX.Field <string>("ZDSJZZL") ?? string.Empty,
ZGCS = CLJBXX.Field <string>("ZGCS") ?? string.Empty,
ZJ = CLJBXX.Field <string>("ZJ") ?? string.Empty,
ZWPS = CLJBXX.Field <string>("ZWPS") ?? string.Empty,
CDD_DDQC30FZZGCS = RLLXPARAM.Field <string>("CDD_DDQC30FZZGCS") ?? string.Empty,
CDD_DDXDCZZLYZCZBZLDBZ = RLLXPARAM.Field <string>("CDD_DDXDCZZLYZCZBZLDBZ") ?? string.Empty,
CDD_DLXDCBNL = RLLXPARAM.Field <string>("CDD_DLXDCBNL") ?? string.Empty,
CDD_DLXDCZBCDY = RLLXPARAM.Field <string>("CDD_DLXDCZBCDY") ?? string.Empty,
CDD_DLXDCZEDNL = RLLXPARAM.Field <string>("CDD_DLXDCZEDNL") ?? string.Empty,
CDD_DLXDCZZL = RLLXPARAM.Field <string>("CDD_DLXDCZZL") ?? string.Empty,
CDD_QDDJEDGL = RLLXPARAM.Field <string>("CDD_QDDJEDGL") ?? string.Empty,
CDD_QDDJFZNJ = RLLXPARAM.Field <string>("CDD_QDDJFZNJ") ?? string.Empty,
CDD_QDDJLX = RLLXPARAM.Field <string>("CDD_QDDJLX") ?? string.Empty,
CDD_ZHGKDNXHL = RLLXPARAM.Field <string>("CDD_ZHGKDNXHL") ?? string.Empty,
CDD_ZHGKXSLC = RLLXPARAM.Field <string>("CDD_ZHGKXSLC") ?? string.Empty,
};
return(ObjectReflect.ToDataTable(CDD));
}
if (tableName.Equals("燃料电池"))
{
var RLDC = from CLJBXX in ds.Tables["基本信息"].AsEnumerable()
join RLLXPARAM in ds.Tables["燃料电池"].AsEnumerable()
on CLJBXX.Field <string>("VIN") equals RLLXPARAM.Field <string>("VIN")
select new
{
VIN = CLJBXX.Field <string>("VIN"),
CLZZRQ = CLJBXX.Field <string>("CLZZRQ") ?? string.Empty,
HGSPBM = CLJBXX.Field <string>("HGSPBM") ?? string.Empty,
QTXX = CLJBXX.Field <string>("QTXX") ?? string.Empty,
CLXH = CLJBXX.Field <string>("CLXH") ?? string.Empty,
CLZL = CLJBXX.Field <string>("CLZL") ?? string.Empty,
EDZK = CLJBXX.Field <string>("EDZK") ?? string.Empty,
JKQCZJXS = CLJBXX.Field <string>("JKQCZJXS") ?? string.Empty,
JYBGBH = CLJBXX.Field <string>("JYBGBH") ?? string.Empty,
JYJGMC = CLJBXX.Field <string>("JYJGMC") ?? string.Empty,
LJ = CLJBXX.Field <string>("LJ") ?? string.Empty,
LTGG = CLJBXX.Field <string>("LTGG") ?? string.Empty,
QCSCQY = CLJBXX.Field <string>("QCSCQY") ?? string.Empty,
QDXS = CLJBXX.Field <string>("QDXS") ?? string.Empty,
RLLX = CLJBXX.Field <string>("RLLX") ?? string.Empty,
USER_ID = CLJBXX.Field <string>("USER_ID") ?? string.Empty,
TYMC = CLJBXX.Field <string>("TYMC") ?? string.Empty,
YYC = CLJBXX.Field <string>("YYC") ?? string.Empty,
ZCZBZL = CLJBXX.Field <string>("ZCZBZL") ?? string.Empty,
ZDSJZZL = CLJBXX.Field <string>("ZDSJZZL") ?? string.Empty,
ZGCS = CLJBXX.Field <string>("ZGCS") ?? string.Empty,
ZJ = CLJBXX.Field <string>("ZJ") ?? string.Empty,
ZWPS = CLJBXX.Field <string>("ZWPS") ?? string.Empty,
RLDC_CDDMSXZGXSCS = RLLXPARAM.Field <string>("RLDC_CDDMSXZGXSCS") ?? string.Empty,
RLDC_CQPBCGZYL = RLLXPARAM.Field <string>("RLDC_CQPBCGZYL") ?? string.Empty,
RLDC_CQPLX = RLLXPARAM.Field <string>("RLDC_CQPLX") ?? string.Empty,
RLDC_CQPRJ = RLLXPARAM.Field <string>("RLDC_CQPRJ") ?? string.Empty,
RLDC_DDGLMD = RLLXPARAM.Field <string>("RLDC_DDGLMD") ?? string.Empty,
RLDC_DDHHJSTJXXDCZBNL = RLLXPARAM.Field <string>("RLDC_DDHHJSTJXXDCZBNL") ?? string.Empty,
RLDC_DLXDCZZL = RLLXPARAM.Field <string>("RLDC_DLXDCZZL") ?? string.Empty,
RLDC_QDDJEDGL = RLLXPARAM.Field <string>("RLDC_QDDJEDGL") ?? string.Empty,
RLDC_QDDJFZNJ = RLLXPARAM.Field <string>("RLDC_QDDJFZNJ") ?? string.Empty,
RLDC_QDDJLX = RLLXPARAM.Field <string>("RLDC_QDDJLX") ?? string.Empty,
RLDC_RLLX = RLLXPARAM.Field <string>("RLDC_RLLX") ?? string.Empty,
RLDC_ZHGKHQL = RLLXPARAM.Field <string>("RLDC_ZHGKHQL") ?? string.Empty,
RLDC_ZHGKXSLC = RLLXPARAM.Field <string>("RLDC_ZHGKXSLC") ?? string.Empty,
};
return(ObjectReflect.ToDataTable(RLDC));
}
return(null);
}