Example #1
0
 /// <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);
 }
Example #2
0
 /// <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());
 }