/// <summary> /// Build a minimal row from a class (key fields only) /// </summary> public static void BuildMinimalRow(ref DataRow row, IcspBase entity) { row.SetField("cono", entity.cono); row.SetField("prod", entity.prod); row.SetField("icspRowID", entity.rowID.ToByteArray()); row.SetField("rowpointer", entity.rowpointer); }
/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromIcspBase(ref DataRow row, IcspBase entity) { row.SetField("cono", entity.cono); row.SetField("prod", entity.prod); row.SetField("lookupnm", entity.lookupnm); row.SetField("prodcat", entity.prodcat); row.SetField("transdt", entity.transdt); row.SetField("transtm", entity.transtm); row.SetField("operinit", entity.operinit); row.SetField("unitsell", entity.unitsell); row.SetField("unitcnt", entity.unitcnt); row.SetField("unitstock", entity.unitstock); row.SetField("weight", entity.weight); row.SetField("cubes", entity.cubes); row.SetField("corecharge", entity.corecharge); row.SetField("msdsfl", entity.msdsfl); row.SetField("msdschgdt", entity.msdschgdt); row.SetField("webpageext", entity.webpageext); row.SetField("webpage", entity.webpage); row.SetField("warrlength", entity.warrlength); row.SetField("warrtype", entity.warrtype); row.SetField("unitconvfl", entity.unitconvfl); row.SetField("descrip1", entity.descrip1); row.SetField("descrip2", entity.descrip2); row.SetField("enterdt", entity.enterdt); row.SetField("statustype", entity.statustype); row.SetField("notesfl", entity.notesfl); row.SetField("kittype", entity.kittype); row.SetField("kitrollty", entity.kitrollty); row.SetField("exponinvfl", entity.exponinvfl); row.SetField("nospecrecno", entity.nospecrecno); row.SetField("lifocat", entity.lifocat); row.SetField("msdssheetno", entity.msdssheetno); row.SetField("pbseqno", entity.pbseqno); row.SetField("sellmult", entity.sellmult); row.SetField("seqno", entity.seqno); row.SetField("length", entity.length); row.SetField("termsdiscfl", entity.termsdiscfl); row.SetField("termspct", entity.termspct); row.SetField("user1", entity.user1); row.SetField("user2", entity.user2); row.SetField("tiedcompprt", entity.tiedcompprt); row.SetField("bolclass", entity.bolclass); row.SetField("edicd", entity.edicd); row.SetField("slgroup", entity.slgroup); row.SetField("priceonty", entity.priceonty); row.SetField("icspecrecno", entity.icspecrecno); row.SetField("width", entity.width); row.SetField("oespecrecno", entity.oespecrecno); row.SetField("height", entity.height); row.SetField("kitnsreqfl", entity.kitnsreqfl); row.SetField("user3", entity.user3); row.SetField("user4", entity.user4); row.SetField("user5", entity.user5); row.SetField("user6", entity.user6); row.SetField("user7", entity.user7); row.SetField("user8", entity.user8); row.SetField("user9", entity.user9); row.SetField("autoupcd", entity.autoupcd); row.SetField("transproc", entity.transproc); row.SetField("reqbundleidfl", entity.reqbundleidfl); row.SetField("randommixfl", entity.randommixfl); row.SetField("memomixfl", entity.memomixfl); row.SetField("implyqty", entity.implyqty); row.SetField("bodtransferty", entity.bodtransferty); row.SetField("prodtype", entity.prodtype); row.SetField("impliedcoreprod", entity.impliedcoreprod); row.SetField("dirtycoreprod", entity.dirtycoreprod); row.SetField("vendcoregrcfl", entity.vendcoregrcfl); row.SetField("custcoregrcfl", entity.custcoregrcfl); row.SetField("vendgraceper", entity.vendgraceper); row.SetField("custgraceper", entity.custgraceper); row.SetField("certifiedtype", entity.certifiedtype); row.SetField("volinfofl", entity.volinfofl); row.SetField("slchgdt", entity.slchgdt); row.SetField("tallyunit", entity.tallyunit); row.SetField("user10", entity.user10); row.SetField("user11", entity.user11); row.SetField("user12", entity.user12); row.SetField("user13", entity.user13); row.SetField("user14", entity.user14); row.SetField("user15", entity.user15); row.SetField("user16", entity.user16); row.SetField("user17", entity.user17); row.SetField("user18", entity.user18); row.SetField("user19", entity.user19); row.SetField("user20", entity.user20); row.SetField("user21", entity.user21); row.SetField("user22", entity.user22); row.SetField("user23", entity.user23); row.SetField("user24", entity.user24); row.SetField("cfgkitfl", entity.cfgkitfl); row.SetField("cfgruleset", entity.cfgruleset); row.SetField("cfgapplicationid", entity.cfgapplicationid); row.SetField("cfgnamespace", entity.cfgnamespace); row.SetField("cutnumparts", entity.cutnumparts); row.SetField("cutparttype1", entity.cutparttype1); row.SetField("cutpartunit1", entity.cutpartunit1); row.SetField("cutparttype2", entity.cutparttype2); row.SetField("cutpartunit2", entity.cutpartunit2); row.SetField("cutpartincr2", entity.cutpartincr2); row.SetField("descrip3", entity.descrip3); row.SetField("rowpointer", entity.rowpointer); row.SetField("commoditycd", entity.commoditycd); row.SetField("netmassamt", entity.netmassamt); row.SetField("usesuppunits", entity.usesuppunits); row.SetField("mfgprod", entity.mfgprod); row.SetField("brandcode", entity.brandcode); row.SetField("vaassemblyty", entity.vaassemblyty); row.SetField("vacutofflength", entity.vacutofflength); row.SetField("unitvaassembly", entity.unitvaassembly); row.SetField("ncnr", entity.ncnr); row.SetField("countryoforigin", entity.countryoforigin); row.SetField("eccnclasscd", entity.eccnclasscd); row.SetField("esbactioncode", entity.esbactioncode); row.SetField("tariffcd", entity.tariffcd); row.SetField("prodtier", entity.prodtier); row.SetField("altprodgrp", entity.altprodgrp); row.SetField("unspsc", entity.unspsc); row.SetField("altprodprccd", entity.altprodprccd); row.SetField("cuttype", entity.cuttype); row.SetField("dimlengthparts", entity.dimlengthparts); row.SetField("dimlengthty1", entity.dimlengthty1); row.SetField("dimlengthty2", entity.dimlengthty2); row.SetField("dimlengthunit1", entity.dimlengthunit1); row.SetField("dimlengthunit2", entity.dimlengthunit2); row.SetField("dimlengthincr", entity.dimlengthincr); row.SetField("dimwidthparts", entity.dimwidthparts); row.SetField("dimwidthty1", entity.dimwidthty1); row.SetField("dimwidthty2", entity.dimwidthty2); row.SetField("dimwidthunit1", entity.dimwidthunit1); row.SetField("dimwidthunit2", entity.dimwidthunit2); row.SetField("dimwidthincr", entity.dimwidthincr); row.SetField("prodtiergrp", entity.prodtiergrp); row.SetField("prodpreference", entity.prodpreference); row.SetField("transdttmz", entity.transdttmz); row.SetField("rentprodcat", entity.rentprodcat); row.SetField("modelcode", entity.modelcode); row.SetField("taxweight", entity.taxweight); row.SetField("icspRowID", entity.rowID.ToByteArray()); }