/// <summary> /// Build a minimal row from a class (key fields only) /// </summary> public static void BuildMinimalRow(ref DataRow row, PoelBase entity) { row.SetField("pono", entity.pono); row.SetField("posuf", entity.posuf); row.SetField("lineno", entity.lineno); row.SetField("cono", entity.cono); row.SetField("poelRowID", entity.rowID.ToByteArray()); row.SetField("rowpointer", entity.rowpointer); }
/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromPoelBase(ref DataRow row, PoelBase entity) { row.SetField("pono", entity.pono); row.SetField("posuf", entity.posuf); row.SetField("whse", entity.whse); row.SetField("transtype", entity.transtype); row.SetField("lineno", entity.lineno); row.SetField("stkqtyord", entity.stkqtyord); row.SetField("cono", entity.cono); row.SetField("proddesc", entity.proddesc); row.SetField("unit", entity.unit); row.SetField("buyer", entity.buyer); row.SetField("transdt", entity.transdt); row.SetField("enterdt", entity.enterdt); row.SetField("operinit", entity.operinit); row.SetField("shipprod", entity.shipprod); row.SetField("transtm", entity.transtm); row.SetField("stkqtyrcv", entity.stkqtyrcv); row.SetField("price", entity.price); row.SetField("prodline", entity.prodline); row.SetField("vendno", entity.vendno); row.SetField("botype", entity.botype); row.SetField("netamt", entity.netamt); row.SetField("reqprod", entity.reqprod); row.SetField("weight", entity.weight); row.SetField("cubes", entity.cubes); row.SetField("origcubes", entity.origcubes); row.SetField("origweight", entity.origweight); row.SetField("notimeschg", entity.notimeschg); row.SetField("statustype", entity.statustype); row.SetField("leadoverty", entity.leadoverty); row.SetField("icspecrecno", entity.icspecrecno); row.SetField("printfl", entity.printfl); row.SetField("sxextractdt", entity.sxextractdt); row.SetField("chrgqty", entity.chrgqty); row.SetField("origduedt", entity.origduedt); row.SetField("expshipdt", entity.expshipdt); row.SetField("bono", entity.bono); row.SetField("vafakeprodfl", entity.vafakeprodfl); row.SetField("user3", entity.user3); row.SetField("user4", entity.user4); row.SetField("user5", entity.user5); row.SetField("user6", entity.user6); row.SetField("nosnlots", entity.nosnlots); row.SetField("user7", entity.user7); row.SetField("user8", entity.user8); row.SetField("user9", entity.user9); row.SetField("prevqtyord", entity.prevqtyord); row.SetField("commentfl", entity.commentfl); row.SetField("duedt", entity.duedt); row.SetField("invcost", entity.invcost); row.SetField("unitoverfl", entity.unitoverfl); row.SetField("priceoverfl", entity.priceoverfl); row.SetField("stkqtyoverfl", entity.stkqtyoverfl); row.SetField("qtyord", entity.qtyord); row.SetField("qtyrcv", entity.qtyrcv); row.SetField("shipfmno", entity.shipfmno); row.SetField("qtyrel", entity.qtyrel); row.SetField("costoverfl", entity.costoverfl); row.SetField("nonstockty", entity.nonstockty); row.SetField("rcvcost", entity.rcvcost); row.SetField("qtyunavail", entity.qtyunavail); row.SetField("reasunavty", entity.reasunavty); row.SetField("eachfl", entity.eachfl); row.SetField("proddesc2", entity.proddesc2); row.SetField("prodcat", entity.prodcat); row.SetField("tallyfl", entity.tallyfl); row.SetField("glcostrcv", entity.glcostrcv); row.SetField("glcostinv", entity.glcostinv); row.SetField("wodiscamt", entity.wodiscamt); row.SetField("catwtfl", entity.catwtfl); row.SetField("netrcv", entity.netrcv); row.SetField("exlatefl", entity.exlatefl); row.SetField("tariffamt", entity.tariffamt); row.SetField("domrcvcost", entity.domrcvcost); row.SetField("dominvcost", entity.dominvcost); row.SetField("landedcost", entity.landedcost); row.SetField("addonamt1", entity.addonamt1); row.SetField("addonamt2", entity.addonamt2); row.SetField("addonamt3", entity.addonamt3); row.SetField("addonamt4", entity.addonamt4); row.SetField("user1", entity.user1); row.SetField("user2", entity.user2); row.SetField("costeachfl", entity.costeachfl); row.SetField("wmqtyrcv", entity.wmqtyrcv); row.SetField("taxabletyau", entity.taxabletyau); row.SetField("taxoverideau", entity.taxoverideau); row.SetField("taxgroup", entity.taxgroup); row.SetField("taxrateau", entity.taxrateau); row.SetField("taxamt", entity.taxamt); row.SetField("unitchgfl", entity.unitchgfl); row.SetField("reqshipdt", entity.reqshipdt); row.SetField("qtycosted", entity.qtycosted); row.SetField("stkqtybilled", entity.stkqtybilled); row.SetField("origtrf", entity.origtrf); row.SetField("unitconv", entity.unitconv); row.SetField("transproc", entity.transproc); row.SetField("ignoreltfl", entity.ignoreltfl); row.SetField("rcvsafety", entity.rcvsafety); row.SetField("rcvnetavl", entity.rcvnetavl); row.SetField("leadtime", entity.leadtime); row.SetField("recvaddfl", entity.recvaddfl); row.SetField("contno", entity.contno); row.SetField("usetrackfl", entity.usetrackfl); row.SetField("trackno", entity.trackno); row.SetField("tracklineno", entity.tracklineno); row.SetField("orgpono", entity.orgpono); row.SetField("orgposuf", entity.orgposuf); row.SetField("warrantyfl", entity.warrantyfl); row.SetField("correctionty", entity.correctionty); row.SetField("countrycd", entity.countrycd); 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("contractno", entity.contractno); row.SetField("pdsvcrecno", entity.pdsvcrecno); row.SetField("ackdt", entity.ackdt); row.SetField("ackrsn", entity.ackrsn); row.SetField("rowpointer", entity.rowpointer); row.SetField("ncnr", entity.ncnr); row.SetField("countryoforigin", entity.countryoforigin); row.SetField("tariffcd", entity.tariffcd); row.SetField("vendretauth", entity.vendretauth); row.SetField("transdttmz", entity.transdttmz); row.SetField("upcid", entity.upcid); row.SetField("poelRowID", entity.rowID.ToByteArray()); }