/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromIcamumassupdate(ref DataRow row, Icamumassupdate entity) { row.SetField("cStatustype", entity.cStatustype); row.SetField("tbStatusType", entity.tbStatusType); row.SetField("cFrozenDate", entity.cFrozenDate); row.SetField("tbFrozenDate", entity.tbFrozenDate); row.SetField("cPriceType", entity.cPriceType); row.SetField("tbPriceType", entity.tbPriceType); row.SetField("cFrozentype", entity.cFrozentype); row.SetField("tbFrozenType", entity.tbFrozenType); row.SetField("iFrozenMonths", entity.iFrozenMonths); row.SetField("tbFrozenMonths", entity.tbFrozenMonths); row.SetField("dtAcquiredt", entity.dtAcquiredt); row.SetField("tbAcquireDt", entity.tbAcquireDt); row.SetField("cArptype", entity.cArptype); row.SetField("tbArpType", entity.tbArpType); row.SetField("cArpPushFl", entity.cArpPushFl); row.SetField("tbArpPushFl", entity.tbArpPushFl); row.SetField("dArpVendorNo", entity.dArpVendorNo); row.SetField("txtArpVendorNo", entity.txtArpVendorNo); row.SetField("cArpVendorNotesfl", entity.cArpVendorNotesfl); row.SetField("tbArpVendorNo", entity.tbArpVendorNo); row.SetField("dUsageRate", entity.dUsageRate); row.SetField("tbUsageRate", entity.tbUsageRate); row.SetField("cArpWhse", entity.cArpWhse); row.SetField("tbArpWhse", entity.tbArpWhse); row.SetField("cWhseRank", entity.cWhseRank); row.SetField("tbWhseRank", entity.tbWhseRank); row.SetField("iUsageMonths", entity.iUsageMonths); row.SetField("tbUsageMonths", entity.tbUsageMonths); row.SetField("cArpProdLine", entity.cArpProdLine); row.SetField("tbArpProdLine", entity.tbArpProdLine); row.SetField("tbRankFreezeEntered", entity.tbRankFreezeEntered); row.SetField("tbRankFreeze", entity.tbRankFreeze); row.SetField("cVendorProd", entity.cVendorProd); row.SetField("tbVendorProd", entity.tbVendorProd); row.SetField("tbUsMthsFrzEntered", entity.tbUsMthsFrzEntered); row.SetField("tbUsMthsFrz", entity.tbUsMthsFrz); row.SetField("cFamilyGroup", entity.cFamilyGroup); row.SetField("tbFamilyGroup", entity.tbFamilyGroup); row.SetField("cUsagectrl", entity.cUsagectrl); row.SetField("tbUsageCtrl", entity.tbUsageCtrl); row.SetField("cSurplusTy", entity.cSurplusTy); row.SetField("tbSurplusTy", entity.tbSurplusTy); row.SetField("cClass", entity.cClass); row.SetField("tbClass", entity.tbClass); row.SetField("iLeadTime", entity.iLeadTime); row.SetField("tbLeadTime", entity.tbLeadTime); row.SetField("cSafeAllType", entity.cSafeAllType); row.SetField("dSafeAllAmt", entity.dSafeAllAmt); row.SetField("tbSafeAllAmt", entity.tbSafeAllAmt); row.SetField("cRebateTy", entity.cRebateTy); row.SetField("tbRebateTy", entity.tbRebateTy); row.SetField("cRebSubTy", entity.cRebSubTy); row.SetField("tbRebSubTy", entity.tbRebSubTy); row.SetField("iFrozenLeadTimeType", entity.iFrozenLeadTimeType); row.SetField("tbFrozenLeadTimeType", entity.tbFrozenLeadTimeType); row.SetField("tbFrozenClass", entity.tbFrozenClass); row.SetField("tbFrozenClassEntered", entity.tbFrozenClassEntered); row.SetField("cBuyingUnit", entity.cBuyingUnit); row.SetField("tbBuyingUnit", entity.tbBuyingUnit); row.SetField("cStndUnit", entity.cStndUnit); row.SetField("tbStndUnit", entity.tbStndUnit); row.SetField("iSeasBegMM", entity.iSeasBegMM); row.SetField("tbSeasBegMM", entity.tbSeasBegMM); row.SetField("iSeasEndMM", entity.iSeasEndMM); row.SetField("tbSeasEndMM", entity.tbSeasEndMM); row.SetField("cTransferUnit", entity.cTransferUnit); row.SetField("tbTransferUnit", entity.tbTransferUnit); row.SetField("iOrdQtyOut", entity.iOrdQtyOut); row.SetField("tbOrdQtyOut", entity.tbOrdQtyOut); row.SetField("cOverreasout", entity.cOverreasout); row.SetField("tbOverReasOut", entity.tbOverReasOut); row.SetField("iOrderPoint", entity.iOrderPoint); row.SetField("tbOrderPoint", entity.tbOrderPoint); row.SetField("iOrdQtyIn", entity.iOrdQtyIn); row.SetField("tbOrdQtyIn", entity.tbOrdQtyIn); row.SetField("iLinePoint", entity.iLinePoint); row.SetField("tbLinePoint", entity.tbLinePoint); row.SetField("tbRollOANUsagefl", entity.tbRollOANUsagefl); row.SetField("tbRollOANUsageUpdatefl", entity.tbRollOANUsageUpdatefl); row.SetField("cRollOANUsageLbl", entity.cRollOANUsageLbl); row.SetField("dSeasTrendMin", entity.dSeasTrendMin); row.SetField("tbSeasTrendMin", entity.tbSeasTrendMin); row.SetField("cOrdcalcty", entity.cOrdcalcty); row.SetField("tbOrdCalcTy", entity.tbOrdCalcTy); row.SetField("cOverreasin", entity.cOverreasin); row.SetField("tbOverReasIn", entity.tbOverReasIn); row.SetField("dSeasTrendMax", entity.dSeasTrendMax); row.SetField("tbSeasTrendMax", entity.tbSeasTrendMax); row.SetField("dtSeasTrendExpDt", entity.dtSeasTrendExpDt); row.SetField("tbSeasTrendExpDt", entity.tbSeasTrendExpDt); row.SetField("cThreshRefer", entity.cThreshRefer); row.SetField("tbThreshRefer", entity.tbThreshRefer); row.SetField("iSeasTrendLyu", entity.iSeasTrendLyu); row.SetField("tbSeasTrendLYU", entity.tbSeasTrendLYU); row.SetField("dtMinThreshExpDt", entity.dtMinThreshExpDt); row.SetField("tbMinThreshExpDt", entity.tbMinThreshExpDt); row.SetField("dMinThreshold", entity.dMinThreshold); row.SetField("tbMinThreshold", entity.tbMinThreshold); row.SetField("iSeasTrendTYU", entity.iSeasTrendTYU); row.SetField("tbSeasTrendTYU", entity.tbSeasTrendTYU); row.SetField("dASQDiff", entity.dASQDiff); row.SetField("tbASQDiff", entity.tbASQDiff); row.SetField("tbAsqFlEntered", entity.tbAsqFlEntered); row.SetField("tbAsqFl", entity.tbAsqFl); row.SetField("tbAsqDiffFlEntered", entity.tbAsqDiffFlEntered); row.SetField("tbAsqDiffFl", entity.tbAsqDiffFl); row.SetField("dHi5Diff", entity.dHi5Diff); row.SetField("tbHi5Diff", entity.tbHi5Diff); row.SetField("tbHi5FlEntered", entity.tbHi5FlEntered); row.SetField("tbHi5Fl", entity.tbHi5Fl); row.SetField("tbHi5DiffFlEntered", entity.tbHi5DiffFlEntered); row.SetField("tbHi5DiffFl", entity.tbHi5DiffFl); row.SetField("cReserveTy", entity.cReserveTy); row.SetField("tbReserveTy", entity.tbReserveTy); row.SetField("iReserveDays", entity.iReserveDays); row.SetField("tbReserveDays", entity.tbReserveDays); row.SetField("cNCNR", entity.cNCNR); row.SetField("tbNCNR", entity.tbNCNR); row.SetField("statusmess", entity.statusmess); row.SetField("countryoforigin", entity.countryoforigin); row.SetField("tbCountryofOrigin", entity.tbCountryofOrigin); row.SetField("tariffcd", entity.tariffcd); row.SetField("tbTariffCd", entity.tbTariffCd); row.SetField("cProdPreference", entity.cProdPreference); row.SetField("tbProdPreference", entity.tbProdPreference); row.SetField("userfield", entity.userfield); }
public static Icamumassupdate BuildIcamumassupdateFromRow(DataRow row) { Icamumassupdate entity = new Icamumassupdate(); entity.cStatustype = row.IsNull("cStatustype") ? string.Empty : row.Field <string>("cStatustype"); entity.tbStatusType = row.Field <bool>("tbStatusType"); entity.cFrozenDate = row.IsNull("cFrozenDate") ? string.Empty : row.Field <string>("cFrozenDate"); entity.tbFrozenDate = row.Field <bool>("tbFrozenDate"); entity.cPriceType = row.IsNull("cPriceType") ? string.Empty : row.Field <string>("cPriceType"); entity.tbPriceType = row.Field <bool>("tbPriceType"); entity.cFrozentype = row.IsNull("cFrozentype") ? string.Empty : row.Field <string>("cFrozentype"); entity.tbFrozenType = row.Field <bool>("tbFrozenType"); entity.iFrozenMonths = row.IsNull("iFrozenMonths") ? 0 : row.Field <int>("iFrozenMonths"); entity.tbFrozenMonths = row.Field <bool>("tbFrozenMonths"); entity.dtAcquiredt = row.Field <DateTime?>("dtAcquiredt"); entity.tbAcquireDt = row.Field <bool>("tbAcquireDt"); entity.cArptype = row.IsNull("cArptype") ? string.Empty : row.Field <string>("cArptype"); entity.tbArpType = row.Field <bool>("tbArpType"); entity.cArpPushFl = row.IsNull("cArpPushFl") ? string.Empty : row.Field <string>("cArpPushFl"); entity.tbArpPushFl = row.Field <bool>("tbArpPushFl"); entity.dArpVendorNo = row.IsNull("dArpVendorNo") ? decimal.Zero : row.Field <decimal>("dArpVendorNo"); entity.txtArpVendorNo = row.IsNull("txtArpVendorNo") ? string.Empty : row.Field <string>("txtArpVendorNo"); entity.cArpVendorNotesfl = row.IsNull("cArpVendorNotesfl") ? string.Empty : row.Field <string>("cArpVendorNotesfl"); entity.tbArpVendorNo = row.Field <bool>("tbArpVendorNo"); entity.dUsageRate = row.IsNull("dUsageRate") ? decimal.Zero : row.Field <decimal>("dUsageRate"); entity.tbUsageRate = row.Field <bool>("tbUsageRate"); entity.cArpWhse = row.IsNull("cArpWhse") ? string.Empty : row.Field <string>("cArpWhse"); entity.tbArpWhse = row.Field <bool>("tbArpWhse"); entity.cWhseRank = row.IsNull("cWhseRank") ? string.Empty : row.Field <string>("cWhseRank"); entity.tbWhseRank = row.Field <bool>("tbWhseRank"); entity.iUsageMonths = row.IsNull("iUsageMonths") ? 0 : row.Field <int>("iUsageMonths"); entity.tbUsageMonths = row.Field <bool>("tbUsageMonths"); entity.cArpProdLine = row.IsNull("cArpProdLine") ? string.Empty : row.Field <string>("cArpProdLine"); entity.tbArpProdLine = row.Field <bool>("tbArpProdLine"); entity.tbRankFreezeEntered = row.Field <bool>("tbRankFreezeEntered"); entity.tbRankFreeze = row.Field <bool>("tbRankFreeze"); entity.cVendorProd = row.IsNull("cVendorProd") ? string.Empty : row.Field <string>("cVendorProd"); entity.tbVendorProd = row.Field <bool>("tbVendorProd"); entity.tbUsMthsFrzEntered = row.Field <bool>("tbUsMthsFrzEntered"); entity.tbUsMthsFrz = row.Field <bool>("tbUsMthsFrz"); entity.cFamilyGroup = row.IsNull("cFamilyGroup") ? string.Empty : row.Field <string>("cFamilyGroup"); entity.tbFamilyGroup = row.Field <bool>("tbFamilyGroup"); entity.cUsagectrl = row.IsNull("cUsagectrl") ? string.Empty : row.Field <string>("cUsagectrl"); entity.tbUsageCtrl = row.Field <bool>("tbUsageCtrl"); entity.cSurplusTy = row.IsNull("cSurplusTy") ? string.Empty : row.Field <string>("cSurplusTy"); entity.tbSurplusTy = row.Field <bool>("tbSurplusTy"); entity.cClass = row.IsNull("cClass") ? string.Empty : row.Field <string>("cClass"); entity.tbClass = row.Field <bool>("tbClass"); entity.iLeadTime = row.IsNull("iLeadTime") ? 0 : row.Field <int>("iLeadTime"); entity.tbLeadTime = row.Field <bool>("tbLeadTime"); entity.cSafeAllType = row.IsNull("cSafeAllType") ? string.Empty : row.Field <string>("cSafeAllType"); entity.dSafeAllAmt = row.IsNull("dSafeAllAmt") ? decimal.Zero : row.Field <decimal>("dSafeAllAmt"); entity.tbSafeAllAmt = row.Field <bool>("tbSafeAllAmt"); entity.cRebateTy = row.IsNull("cRebateTy") ? string.Empty : row.Field <string>("cRebateTy"); entity.tbRebateTy = row.Field <bool>("tbRebateTy"); entity.cRebSubTy = row.IsNull("cRebSubTy") ? string.Empty : row.Field <string>("cRebSubTy"); entity.tbRebSubTy = row.Field <bool>("tbRebSubTy"); entity.iFrozenLeadTimeType = row.IsNull("iFrozenLeadTimeType") ? 0 : row.Field <int>("iFrozenLeadTimeType"); entity.tbFrozenLeadTimeType = row.Field <bool>("tbFrozenLeadTimeType"); entity.tbFrozenClass = row.Field <bool>("tbFrozenClass"); entity.tbFrozenClassEntered = row.Field <bool>("tbFrozenClassEntered"); entity.cBuyingUnit = row.IsNull("cBuyingUnit") ? string.Empty : row.Field <string>("cBuyingUnit"); entity.tbBuyingUnit = row.Field <bool>("tbBuyingUnit"); entity.cStndUnit = row.IsNull("cStndUnit") ? string.Empty : row.Field <string>("cStndUnit"); entity.tbStndUnit = row.Field <bool>("tbStndUnit"); entity.iSeasBegMM = row.IsNull("iSeasBegMM") ? 0 : row.Field <int>("iSeasBegMM"); entity.tbSeasBegMM = row.Field <bool>("tbSeasBegMM"); entity.iSeasEndMM = row.IsNull("iSeasEndMM") ? 0 : row.Field <int>("iSeasEndMM"); entity.tbSeasEndMM = row.Field <bool>("tbSeasEndMM"); entity.cTransferUnit = row.IsNull("cTransferUnit") ? string.Empty : row.Field <string>("cTransferUnit"); entity.tbTransferUnit = row.Field <bool>("tbTransferUnit"); entity.iOrdQtyOut = row.IsNull("iOrdQtyOut") ? 0 : row.Field <int>("iOrdQtyOut"); entity.tbOrdQtyOut = row.Field <bool>("tbOrdQtyOut"); entity.cOverreasout = row.IsNull("cOverreasout") ? string.Empty : row.Field <string>("cOverreasout"); entity.tbOverReasOut = row.Field <bool>("tbOverReasOut"); entity.iOrderPoint = row.IsNull("iOrderPoint") ? 0 : row.Field <int>("iOrderPoint"); entity.tbOrderPoint = row.Field <bool>("tbOrderPoint"); entity.iOrdQtyIn = row.IsNull("iOrdQtyIn") ? 0 : row.Field <int>("iOrdQtyIn"); entity.tbOrdQtyIn = row.Field <bool>("tbOrdQtyIn"); entity.iLinePoint = row.IsNull("iLinePoint") ? 0 : row.Field <int>("iLinePoint"); entity.tbLinePoint = row.Field <bool>("tbLinePoint"); entity.tbRollOANUsagefl = row.Field <bool>("tbRollOANUsagefl"); entity.tbRollOANUsageUpdatefl = row.Field <bool>("tbRollOANUsageUpdatefl"); entity.cRollOANUsageLbl = row.IsNull("cRollOANUsageLbl") ? string.Empty : row.Field <string>("cRollOANUsageLbl"); entity.dSeasTrendMin = row.IsNull("dSeasTrendMin") ? decimal.Zero : row.Field <decimal>("dSeasTrendMin"); entity.tbSeasTrendMin = row.Field <bool>("tbSeasTrendMin"); entity.cOrdcalcty = row.IsNull("cOrdcalcty") ? string.Empty : row.Field <string>("cOrdcalcty"); entity.tbOrdCalcTy = row.Field <bool>("tbOrdCalcTy"); entity.cOverreasin = row.IsNull("cOverreasin") ? string.Empty : row.Field <string>("cOverreasin"); entity.tbOverReasIn = row.Field <bool>("tbOverReasIn"); entity.dSeasTrendMax = row.IsNull("dSeasTrendMax") ? decimal.Zero : row.Field <decimal>("dSeasTrendMax"); entity.tbSeasTrendMax = row.Field <bool>("tbSeasTrendMax"); entity.dtSeasTrendExpDt = row.Field <DateTime?>("dtSeasTrendExpDt"); entity.tbSeasTrendExpDt = row.Field <bool>("tbSeasTrendExpDt"); entity.cThreshRefer = row.IsNull("cThreshRefer") ? string.Empty : row.Field <string>("cThreshRefer"); entity.tbThreshRefer = row.Field <bool>("tbThreshRefer"); entity.iSeasTrendLyu = row.IsNull("iSeasTrendLyu") ? 0 : row.Field <int>("iSeasTrendLyu"); entity.tbSeasTrendLYU = row.Field <bool>("tbSeasTrendLYU"); entity.dtMinThreshExpDt = row.Field <DateTime?>("dtMinThreshExpDt"); entity.tbMinThreshExpDt = row.Field <bool>("tbMinThreshExpDt"); entity.dMinThreshold = row.IsNull("dMinThreshold") ? decimal.Zero : row.Field <decimal>("dMinThreshold"); entity.tbMinThreshold = row.Field <bool>("tbMinThreshold"); entity.iSeasTrendTYU = row.IsNull("iSeasTrendTYU") ? 0 : row.Field <int>("iSeasTrendTYU"); entity.tbSeasTrendTYU = row.Field <bool>("tbSeasTrendTYU"); entity.dASQDiff = row.IsNull("dASQDiff") ? decimal.Zero : row.Field <decimal>("dASQDiff"); entity.tbASQDiff = row.Field <bool>("tbASQDiff"); entity.tbAsqFlEntered = row.Field <bool>("tbAsqFlEntered"); entity.tbAsqFl = row.Field <bool>("tbAsqFl"); entity.tbAsqDiffFlEntered = row.Field <bool>("tbAsqDiffFlEntered"); entity.tbAsqDiffFl = row.Field <bool>("tbAsqDiffFl"); entity.dHi5Diff = row.IsNull("dHi5Diff") ? decimal.Zero : row.Field <decimal>("dHi5Diff"); entity.tbHi5Diff = row.Field <bool>("tbHi5Diff"); entity.tbHi5FlEntered = row.Field <bool>("tbHi5FlEntered"); entity.tbHi5Fl = row.Field <bool>("tbHi5Fl"); entity.tbHi5DiffFlEntered = row.Field <bool>("tbHi5DiffFlEntered"); entity.tbHi5DiffFl = row.Field <bool>("tbHi5DiffFl"); entity.cReserveTy = row.IsNull("cReserveTy") ? string.Empty : row.Field <string>("cReserveTy"); entity.tbReserveTy = row.Field <bool>("tbReserveTy"); entity.iReserveDays = row.IsNull("iReserveDays") ? 0 : row.Field <int>("iReserveDays"); entity.tbReserveDays = row.Field <bool>("tbReserveDays"); entity.cNCNR = row.IsNull("cNCNR") ? string.Empty : row.Field <string>("cNCNR"); entity.tbNCNR = row.Field <bool>("tbNCNR"); entity.statusmess = row.IsNull("statusmess") ? string.Empty : row.Field <string>("statusmess"); entity.countryoforigin = row.IsNull("countryoforigin") ? string.Empty : row.Field <string>("countryoforigin"); entity.tbCountryofOrigin = row.Field <bool>("tbCountryofOrigin"); entity.tariffcd = row.IsNull("tariffcd") ? string.Empty : row.Field <string>("tariffcd"); entity.tbTariffCd = row.Field <bool>("tbTariffCd"); entity.cProdPreference = row.IsNull("cProdPreference") ? string.Empty : row.Field <string>("cProdPreference"); entity.tbProdPreference = row.Field <bool>("tbProdPreference"); entity.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield"); return(entity); }