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