/// <summary> /// Build a minimal row from a class (key fields only) /// </summary> public static void BuildMinimalRow(ref DataRow row, OeelbBase entity) { row.SetField("lineno", entity.lineno); row.SetField("cono", entity.cono); row.SetField("batchnm", entity.batchnm); row.SetField("seqno", entity.seqno); row.SetField("oeelbRowID", entity.rowID.ToByteArray()); }
/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromOeelbBase(ref DataRow row, OeelbBase entity) { row.SetField("lineno", entity.lineno); row.SetField("qtyord", entity.qtyord); row.SetField("cono", entity.cono); row.SetField("proddesc", entity.proddesc); row.SetField("unit", entity.unit); row.SetField("price", entity.price); row.SetField("transdt", entity.transdt); row.SetField("enterdt", entity.enterdt); row.SetField("operinit", entity.operinit); row.SetField("reqshipdt", entity.reqshipdt); row.SetField("discamt", entity.discamt); row.SetField("shipprod", entity.shipprod); row.SetField("transtm", entity.transtm); row.SetField("prodcost", entity.prodcost); row.SetField("prodcat", entity.prodcat); row.SetField("prodline", entity.prodline); row.SetField("vendno", entity.vendno); row.SetField("usagefl", entity.usagefl); row.SetField("ordertype", entity.ordertype); row.SetField("botype", entity.botype); row.SetField("netamt", entity.netamt); row.SetField("corechgty", entity.corechgty); row.SetField("specnstype", entity.specnstype); row.SetField("user1", entity.user1); row.SetField("user2", entity.user2); row.SetField("leadtm", entity.leadtm); row.SetField("proddesc2", entity.proddesc2); row.SetField("pricetype", entity.pricetype); row.SetField("priceoverfl", entity.priceoverfl); row.SetField("xrefprodty", entity.xrefprodty); row.SetField("reqprod", entity.reqprod); row.SetField("bplineno", entity.bplineno); row.SetField("commentfl", entity.commentfl); row.SetField("rushfl", entity.rushfl); row.SetField("user3", entity.user3); row.SetField("user4", entity.user4); row.SetField("user5", entity.user5); row.SetField("chrgqty", entity.chrgqty); row.SetField("user6", entity.user6); row.SetField("user7", entity.user7); row.SetField("user8", entity.user8); row.SetField("user9", entity.user9); row.SetField("returnfl", entity.returnfl); row.SetField("taxablefl", entity.taxablefl); row.SetField("disctype", entity.disctype); row.SetField("corecharge", entity.corecharge); row.SetField("reasunavty", entity.reasunavty); row.SetField("datccost", entity.datccost); row.SetField("stkqtyord", entity.stkqtyord); row.SetField("slsrepin", entity.slsrepin); row.SetField("slsrepout", entity.slsrepout); row.SetField("jobno", entity.jobno); row.SetField("commtype", entity.commtype); row.SetField("printpricefl", entity.printpricefl); row.SetField("subtotalfl", entity.subtotalfl); row.SetField("costoverfl", entity.costoverfl); row.SetField("crreasonty", entity.crreasonty); row.SetField("taxgroup", entity.taxgroup); row.SetField("nontaxtype", entity.nontaxtype); row.SetField("termspct", entity.termspct); row.SetField("gststatus", entity.gststatus); row.SetField("qtyunavail", entity.qtyunavail); row.SetField("batchnm", entity.batchnm); row.SetField("seqno", entity.seqno); row.SetField("restockamt", entity.restockamt); row.SetField("promisedt", entity.promisedt); row.SetField("jitpickfl", entity.jitpickfl); row.SetField("cataddfl", entity.cataddfl); row.SetField("shipfmno", entity.shipfmno); row.SetField("arpprodline", entity.arpprodline); row.SetField("arpvendno", entity.arpvendno); row.SetField("icspecrecno", entity.icspecrecno); row.SetField("transproc", entity.transproc); row.SetField("restktaxgrp", entity.restktaxgrp); 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("quoteshipviaty", entity.quoteshipviaty); row.SetField("oeelbRowID", entity.rowID.ToByteArray()); }