/// <summary> /// Build a minimal row from a class (key fields only) /// </summary> public static void BuildMinimalRow(ref DataRow row, VaesBase entity) { row.SetField("cono", entity.cono); row.SetField("vano", entity.vano); row.SetField("vasuf", entity.vasuf); row.SetField("seqno", entity.seqno); row.SetField("vaesRowID", entity.rowID.ToByteArray()); row.SetField("rowpointer", entity.rowpointer); }
/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromVaesBase(ref DataRow row, VaesBase entity) { row.SetField("cono", entity.cono); row.SetField("vano", entity.vano); row.SetField("vasuf", entity.vasuf); row.SetField("seqno", entity.seqno); row.SetField("sctntype", entity.sctntype); row.SetField("sctncode", entity.sctncode); row.SetField("destvendno", entity.destvendno); row.SetField("stagearea", entity.stagearea); row.SetField("destwhse", entity.destwhse); row.SetField("destshipfmno", entity.destshipfmno); row.SetField("destname", entity.destname); row.SetField("destaddr1", entity.destaddr1); row.SetField("destaddr2", entity.destaddr2); row.SetField("destcity", entity.destcity); row.SetField("deststate", entity.deststate); row.SetField("destzipcd", entity.destzipcd); row.SetField("shipinstr", entity.shipinstr); row.SetField("refer", entity.refer); row.SetField("shipviaty", entity.shipviaty); row.SetField("reqshipdt", entity.reqshipdt); row.SetField("promisedt", entity.promisedt); row.SetField("extrvendno", entity.extrvendno); row.SetField("extrshipfmno", entity.extrshipfmno); row.SetField("intrwhse", entity.intrwhse); row.SetField("goalprod", entity.goalprod); row.SetField("goaldesc", entity.goaldesc); row.SetField("goalqtyord", entity.goalqtyord); row.SetField("goalstkqtyord", entity.goalstkqtyord); row.SetField("goalunit", entity.goalunit); row.SetField("goalunitconv", entity.goalunitconv); row.SetField("user1", entity.user1); row.SetField("user2", entity.user2); row.SetField("user3", entity.user3); row.SetField("user4", entity.user4); row.SetField("rowpointer", entity.rowpointer); 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("wletsetno", entity.wletsetno); row.SetField("norushln", entity.norushln); row.SetField("borelfl", entity.borelfl); row.SetField("transdt", entity.transdt); row.SetField("transtm", entity.transtm); row.SetField("operinit", entity.operinit); row.SetField("specdata", entity.specdata); row.SetField("specprtty", entity.specprtty); row.SetField("stagecd", entity.stagecd); row.SetField("addonno1", entity.addonno1); row.SetField("addonno2", entity.addonno2); row.SetField("addonno3", entity.addonno3); row.SetField("addonno4", entity.addonno4); row.SetField("addonamt1", entity.addonamt1); row.SetField("addonamt2", entity.addonamt2); row.SetField("addonamt3", entity.addonamt3); row.SetField("addonamt4", entity.addonamt4); row.SetField("desttype", entity.desttype); row.SetField("jrnlno", entity.jrnlno); row.SetField("duedt", entity.duedt); row.SetField("specprtfl", entity.specprtfl); row.SetField("setno", entity.setno); row.SetField("route", entity.route); row.SetField("pickcnt", entity.pickcnt); row.SetField("pickeddt", entity.pickeddt); row.SetField("pickedtm", entity.pickedtm); row.SetField("pickinit", entity.pickinit); row.SetField("printpckfl", entity.printpckfl); row.SetField("shipdt", entity.shipdt); row.SetField("shiptm", entity.shiptm); row.SetField("completefl", entity.completefl); row.SetField("processfl", entity.processfl); row.SetField("processinit", entity.processinit); row.SetField("processproc", entity.processproc); row.SetField("notesfl", entity.notesfl); row.SetField("orderdisp", entity.orderdisp); row.SetField("zone", entity.zone); row.SetField("shippingpt", entity.shippingpt); row.SetField("nopackages", entity.nopackages); row.SetField("pkglabel", entity.pkglabel); row.SetField("manzonefl", entity.manzonefl); row.SetField("totweight", entity.totweight); row.SetField("actfreight", entity.actfreight); row.SetField("transproc", entity.transproc); row.SetField("destaddr3", entity.destaddr3); row.SetField("vacfgfl", entity.vacfgfl); row.SetField("transdttmz", entity.transdttmz); row.SetField("vaesRowID", entity.rowID.ToByteArray()); }