public static Loadoelinesettings BuildLoadoelinesettingsFromRow(DataRow row) { Loadoelinesettings entity = new Loadoelinesettings(); entity.lAllowExpandedProduct = row.Field <bool>("lAllowExpandedProduct"); entity.cCurrSymbol = row.IsNull("cCurrSymbol") ? string.Empty : row.Field <string>("cCurrSymbol"); entity.cDefaultOEFrzRebTy = row.IsNull("cDefaultOEFrzRebTy") ? string.Empty : row.Field <string>("cDefaultOEFrzRebTy"); entity.lForceSerLot = row.Field <bool>("lForceSerLot"); entity.lForceSerLotKit = row.Field <bool>("lForceSerLotKit"); entity.lGeocdfl = row.Field <bool>("lGeocdfl"); entity.cGeoindxty = row.IsNull("cGeoindxty") ? string.Empty : row.Field <string>("cGeoindxty"); entity.lGeotxrgfl = row.Field <bool>("lGeotxrgfl"); entity.cICDATCLabel = row.IsNull("cICDATCLabel") ? string.Empty : row.Field <string>("cICDATCLabel"); entity.lModVTfl = row.Field <bool>("lModVTfl"); entity.lNonStockEntry = row.Field <bool>("lNonStockEntry"); entity.cNSCrtOanTy = row.IsNull("cNSCrtOanTy") ? string.Empty : row.Field <string>("cNSCrtOanTy"); entity.cOECostOverTy = row.IsNull("cOECostOverTy") ? string.Empty : row.Field <string>("cOECostOverTy"); entity.cOELotEntTy = row.IsNull("cOELotEntTy") ? string.Empty : row.Field <string>("cOELotEntTy"); entity.cOENSQtyShpTy = row.IsNull("cOENSQtyShpTy") ? string.Empty : row.Field <string>("cOENSQtyShpTy"); entity.cOEQtyShipTy = row.IsNull("cOEQtyShipTy") ? string.Empty : row.Field <string>("cOEQtyShipTy"); entity.cOESerialEntTy = row.IsNull("cOESerialEntTy") ? string.Empty : row.Field <string>("cOESerialEntTy"); entity.cOETieType = row.IsNull("cOETieType") ? string.Empty : row.Field <string>("cOETieType"); entity.lSlsRepInFl = row.Field <bool>("lSlsRepInFl"); entity.lSlsRepOutFl = row.Field <bool>("lSlsRepOutFl"); entity.cStorefrontURL = row.IsNull("cStorefrontURL") ? string.Empty : row.Field <string>("cStorefrontURL"); entity.cStorefrontUserID = row.IsNull("cStorefrontUserID") ? string.Empty : row.Field <string>("cStorefrontUserID"); entity.cTaxInterfaceTy = row.IsNull("cTaxInterfaceTy") ? string.Empty : row.Field <string>("cTaxInterfaceTy"); entity.cTaxMethodTy = row.IsNull("cTaxMethodTy") ? string.Empty : row.Field <string>("cTaxMethodTy"); entity.lCfgInstalled = row.Field <bool>("lCfgInstalled"); entity.lCCInstalled = row.Field <bool>("lCCInstalled"); entity.cSupplierAccessHttpServerName = row.IsNull("cSupplierAccessHttpServerName") ? string.Empty : row.Field <string>("cSupplierAccessHttpServerName"); entity.iSupplierAccessHttpServerPortNum = row.IsNull("iSupplierAccessHttpServerPortNum") ? 0 : row.Field <int>("iSupplierAccessHttpServerPortNum"); entity.iSupplierAccessPauseSeconds = row.IsNull("iSupplierAccessPauseSeconds") ? 0 : row.Field <int>("iSupplierAccessPauseSeconds"); entity.iSupplierAccessPauseTimes = row.IsNull("iSupplierAccessPauseTimes") ? 0 : row.Field <int>("iSupplierAccessPauseTimes"); entity.cDefaultSpecNSType = row.IsNull("cDefaultSpecNSType") ? string.Empty : row.Field <string>("cDefaultSpecNSType"); entity.cVaWorkFlow = row.IsNull("cVaWorkFlow") ? string.Empty : row.Field <string>("cVaWorkFlow"); entity.lValProd = row.Field <bool>("lValProd"); entity.lValQtyOrd = row.Field <bool>("lValQtyOrd"); entity.lValUnit = row.Field <bool>("lValUnit"); entity.lValPrice = row.Field <bool>("lValPrice"); entity.lValDiscAmt = row.Field <bool>("lValDiscAmt"); entity.lValQtyShip = row.Field <bool>("lValQtyShip"); entity.cAltProdWF = row.IsNull("cAltProdWF") ? string.Empty : row.Field <string>("cAltProdWF"); entity.cSuperWF = row.IsNull("cSuperWF") ? string.Empty : row.Field <string>("cSuperWF"); entity.lICSNPOFl = row.Field <bool>("lICSNPOFl"); entity.cICLotRcptType = row.IsNull("cICLotRcptType") ? string.Empty : row.Field <string>("cICLotRcptType"); entity.lQtyShipEnabled = row.Field <bool>("lQtyShipEnabled"); entity.cICNSProdCat = row.IsNull("cICNSProdCat") ? string.Empty : row.Field <string>("cICNSProdCat"); entity.lNsCommfl = row.Field <bool>("lNsCommfl"); entity.lUsePrevNsFl = row.Field <bool>("lUsePrevNsFl"); entity.lICCatStockFl = row.Field <bool>("lICCatStockFl"); entity.lLostBusReasonFl = row.Field <bool>("lLostBusReasonFl"); entity.lNCNREntryfl = row.Field <bool>("lNCNREntryfl"); entity.cPromoPrcDflt = row.IsNull("cPromoPrcDflt") ? string.Empty : row.Field <string>("cPromoPrcDflt"); entity.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield"); return(entity); }
/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromLoadoelinesettings(ref DataRow row, Loadoelinesettings entity) { row.SetField("lAllowExpandedProduct", entity.lAllowExpandedProduct); row.SetField("cCurrSymbol", entity.cCurrSymbol); row.SetField("cDefaultOEFrzRebTy", entity.cDefaultOEFrzRebTy); row.SetField("lForceSerLot", entity.lForceSerLot); row.SetField("lForceSerLotKit", entity.lForceSerLotKit); row.SetField("lGeocdfl", entity.lGeocdfl); row.SetField("cGeoindxty", entity.cGeoindxty); row.SetField("lGeotxrgfl", entity.lGeotxrgfl); row.SetField("cICDATCLabel", entity.cICDATCLabel); row.SetField("lModVTfl", entity.lModVTfl); row.SetField("lNonStockEntry", entity.lNonStockEntry); row.SetField("cNSCrtOanTy", entity.cNSCrtOanTy); row.SetField("cOECostOverTy", entity.cOECostOverTy); row.SetField("cOELotEntTy", entity.cOELotEntTy); row.SetField("cOENSQtyShpTy", entity.cOENSQtyShpTy); row.SetField("cOEQtyShipTy", entity.cOEQtyShipTy); row.SetField("cOESerialEntTy", entity.cOESerialEntTy); row.SetField("cOETieType", entity.cOETieType); row.SetField("lSlsRepInFl", entity.lSlsRepInFl); row.SetField("lSlsRepOutFl", entity.lSlsRepOutFl); row.SetField("cStorefrontURL", entity.cStorefrontURL); row.SetField("cStorefrontUserID", entity.cStorefrontUserID); row.SetField("cTaxInterfaceTy", entity.cTaxInterfaceTy); row.SetField("cTaxMethodTy", entity.cTaxMethodTy); row.SetField("lCfgInstalled", entity.lCfgInstalled); row.SetField("lCCInstalled", entity.lCCInstalled); row.SetField("cSupplierAccessHttpServerName", entity.cSupplierAccessHttpServerName); row.SetField("iSupplierAccessHttpServerPortNum", entity.iSupplierAccessHttpServerPortNum); row.SetField("iSupplierAccessPauseSeconds", entity.iSupplierAccessPauseSeconds); row.SetField("iSupplierAccessPauseTimes", entity.iSupplierAccessPauseTimes); row.SetField("cDefaultSpecNSType", entity.cDefaultSpecNSType); row.SetField("cVaWorkFlow", entity.cVaWorkFlow); row.SetField("lValProd", entity.lValProd); row.SetField("lValQtyOrd", entity.lValQtyOrd); row.SetField("lValUnit", entity.lValUnit); row.SetField("lValPrice", entity.lValPrice); row.SetField("lValDiscAmt", entity.lValDiscAmt); row.SetField("lValQtyShip", entity.lValQtyShip); row.SetField("cAltProdWF", entity.cAltProdWF); row.SetField("cSuperWF", entity.cSuperWF); row.SetField("lICSNPOFl", entity.lICSNPOFl); row.SetField("cICLotRcptType", entity.cICLotRcptType); row.SetField("lQtyShipEnabled", entity.lQtyShipEnabled); row.SetField("cICNSProdCat", entity.cICNSProdCat); row.SetField("lNsCommfl", entity.lNsCommfl); row.SetField("lUsePrevNsFl", entity.lUsePrevNsFl); row.SetField("lICCatStockFl", entity.lICCatStockFl); row.SetField("lLostBusReasonFl", entity.lLostBusReasonFl); row.SetField("lNCNREntryfl", entity.lNCNREntryfl); row.SetField("cPromoPrcDflt", entity.cPromoPrcDflt); row.SetField("userfield", entity.userfield); }