/// <summary> /// Build a minimal row from a class (key fields only) /// </summary> public static void BuildMinimalRow(ref DataRow row, IcslBase entity) { row.SetField("cono", entity.cono); row.SetField("vendno", entity.vendno); row.SetField("prodline", entity.prodline); row.SetField("whse", entity.whse); row.SetField("icslRowID", entity.rowID.ToByteArray()); row.SetField("rowpointer", entity.rowpointer); }
/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromIcslBase(ref DataRow row, IcslBase entity) { row.SetField("cono", entity.cono); row.SetField("vendno", entity.vendno); row.SetField("prodline", entity.prodline); row.SetField("descrip", entity.descrip); row.SetField("shipfmno", entity.shipfmno); row.SetField("minbuy", entity.minbuy); row.SetField("minbuytype", entity.minbuytype); row.SetField("tarbuytype", entity.tarbuytype); row.SetField("tarlevel", entity.tarlevel); row.SetField("operinit", entity.operinit); row.SetField("transdt", entity.transdt); row.SetField("transtm", entity.transtm); row.SetField("discmult1", entity.discmult1); row.SetField("discmult2", entity.discmult2); row.SetField("discmult3", entity.discmult3); row.SetField("discmult4", entity.discmult4); row.SetField("discmult5", entity.discmult5); row.SetField("discmult6", entity.discmult6); row.SetField("discmult7", entity.discmult7); row.SetField("discmult8", entity.discmult8); row.SetField("discmult9", entity.discmult9); row.SetField("whse", entity.whse); row.SetField("buyer", entity.buyer); row.SetField("revcyclin", entity.revcyclin); row.SetField("revcyclout", entity.revcyclout); row.SetField("frozenfl", entity.frozenfl); row.SetField("lastpowtdt", entity.lastpowtdt); row.SetField("rcvtolpct", entity.rcvtolpct); row.SetField("tarbuyamt1", entity.tarbuyamt1); row.SetField("tarbuyamt2", entity.tarbuyamt2); row.SetField("tarbuyamt3", entity.tarbuyamt3); row.SetField("tarbuyamt4", entity.tarbuyamt4); row.SetField("tarbuyamt5", entity.tarbuyamt5); row.SetField("tarbuyamt6", entity.tarbuyamt6); row.SetField("tarbuyamt7", entity.tarbuyamt7); row.SetField("tarbuyamt8", entity.tarbuyamt8); row.SetField("tarbuyamt9", entity.tarbuyamt9); row.SetField("seasbegmm", entity.seasbegmm); row.SetField("seasendmm", entity.seasendmm); row.SetField("class", entity.@class); row.SetField("frozenmos", entity.frozenmos); row.SetField("frozentype", entity.frozentype); row.SetField("nodaysseas", entity.nodaysseas); row.SetField("icrcost", entity.icrcost); row.SetField("ordcalcty", entity.ordcalcty); row.SetField("trendpct", entity.trendpct); row.SetField("orderpt", entity.orderpt); row.SetField("ordqtyin", entity.ordqtyin); row.SetField("ordqtyout", entity.ordqtyout); row.SetField("overreasin", entity.overreasin); row.SetField("frtconsldtcd", entity.frtconsldtcd); row.SetField("overreasout", entity.overreasout); row.SetField("unitwt", entity.unitwt); row.SetField("safeallamt", entity.safeallamt); row.SetField("updtsrc", entity.updtsrc); row.SetField("troqfl", entity.troqfl); row.SetField("vminwks", entity.vminwks); row.SetField("unitbuy", entity.unitbuy); row.SetField("vmaxwks", entity.vmaxwks); row.SetField("unitstnd", entity.unitstnd); row.SetField("linept", entity.linept); row.SetField("leadtmavg", entity.leadtmavg); row.SetField("usgmths", entity.usgmths); row.SetField("vroqfl", entity.vroqfl); row.SetField("safeallpct", entity.safeallpct); row.SetField("automrgfl", entity.automrgfl); row.SetField("termsdiscfl", entity.termsdiscfl); row.SetField("user1", entity.user1); row.SetField("termspct", entity.termspct); row.SetField("user2", entity.user2); row.SetField("warrlength", entity.warrlength); row.SetField("user3", entity.user3); row.SetField("warrtype", entity.warrtype); row.SetField("user4", entity.user4); row.SetField("arptype", entity.arptype); row.SetField("user5", entity.user5); row.SetField("arppushfl", entity.arppushfl); row.SetField("user6", entity.user6); row.SetField("nontaxtype", entity.nontaxtype); row.SetField("user7", entity.user7); row.SetField("tariffcd", entity.tariffcd); row.SetField("user8", entity.user8); row.SetField("taxablety", entity.taxablety); row.SetField("user9", entity.user9); row.SetField("taxgroup", entity.taxgroup); row.SetField("taxtype", entity.taxtype); row.SetField("arpwhse", entity.arpwhse); row.SetField("conslinefl", entity.conslinefl); row.SetField("conswhsefl", entity.conswhsefl); row.SetField("transproc", entity.transproc); row.SetField("safeallty", entity.safeallty); row.SetField("vendcorechgfl", entity.vendcorechgfl); row.SetField("zerocstcorefl", entity.zerocstcorefl); row.SetField("zerocstgldivno", entity.zerocstgldivno); row.SetField("zerocstgldeptno", entity.zerocstgldeptno); row.SetField("zerocstglacctno", entity.zerocstglacctno); row.SetField("zerocstglsubno", entity.zerocstglsubno); row.SetField("esourcety", entity.esourcety); row.SetField("esspecnsty", entity.esspecnsty); row.SetField("rrarunitrnd", entity.rrarunitrnd); row.SetField("ickcost", entity.ickcost); row.SetField("wtrcost", entity.wtrcost); row.SetField("wtkcost", entity.wtkcost); row.SetField("rolloanusagefl", entity.rolloanusagefl); row.SetField("tminwks", entity.tminwks); row.SetField("tmaxwks", entity.tmaxwks); row.SetField("wtrevcycle", entity.wtrevcycle); row.SetField("usagerate", entity.usagerate); row.SetField("belowlpfl", entity.belowlpfl); row.SetField("freightexpectedty", entity.freightexpectedty); row.SetField("surplusty", entity.surplusty); row.SetField("countryoforigin", entity.countryoforigin); row.SetField("rowpointer", entity.rowpointer); row.SetField("usagectrl", entity.usagectrl); row.SetField("prodpreference", entity.prodpreference); row.SetField("transdttmz", entity.transdttmz); row.SetField("icslRowID", entity.rowID.ToByteArray()); }