/// <summary> /// Build a minimal row from a class (key fields only) /// </summary> public static void BuildMinimalRow(ref DataRow row, WlemBase entity) { row.SetField("cono", entity.cono); row.SetField("whse", entity.whse); row.SetField("field1", entity.field1); row.SetField("field2", entity.field2); row.SetField("setno", entity.setno); row.SetField("wlemRowID", entity.rowID.ToByteArray()); }
/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromWlemBase(ref DataRow row, WlemBase entity) { row.SetField("cono", entity.cono); row.SetField("whse", entity.whse); row.SetField("prod", entity.prod); row.SetField("operinit", entity.operinit); row.SetField("transdt", entity.transdt); row.SetField("transtm", entity.transtm); row.SetField("user1", entity.user1); row.SetField("user2", entity.user2); row.SetField("user3", entity.user3); row.SetField("user4", entity.user4); 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("function", entity.function); row.SetField("field1", entity.field1); row.SetField("field2", entity.field2); row.SetField("name", entity.name); row.SetField("addr1", entity.addr1); row.SetField("addr2", entity.addr2); row.SetField("city", entity.city); row.SetField("state", entity.state); row.SetField("zipcd", entity.zipcd); row.SetField("unitstock", entity.unitstock); row.SetField("icswstattype", entity.icswstattype); row.SetField("kittype", entity.kittype); row.SetField("msdsfl", entity.msdsfl); row.SetField("cubes", entity.cubes); row.SetField("weight", entity.weight); row.SetField("height", entity.height); row.SetField("width", entity.width); row.SetField("length", entity.length); row.SetField("serlottype", entity.serlottype); row.SetField("binloc1", entity.binloc1); row.SetField("binloc2", entity.binloc2); row.SetField("specnstype", entity.specnstype); row.SetField("adjusttype", entity.adjusttype); row.SetField("expectqty", entity.expectqty); row.SetField("actualqty", entity.actualqty); row.SetField("adjustreas", entity.adjustreas); row.SetField("statustype", entity.statustype); row.SetField("errormsg", entity.errormsg); row.SetField("updtype", entity.updtype); row.SetField("setno", entity.setno); row.SetField("whzone", entity.whzone); row.SetField("boxqty", entity.boxqty); row.SetField("abc", entity.abc); row.SetField("rotate", entity.rotate); row.SetField("pilferfl", entity.pilferfl); row.SetField("country", entity.country); row.SetField("descrip", entity.descrip); row.SetField("upcno", entity.upcno); row.SetField("vendprod", entity.vendprod); row.SetField("bincntr", entity.bincntr); row.SetField("kitbuild", entity.kitbuild); row.SetField("icspstattype", entity.icspstattype); row.SetField("adjlotstat", entity.adjlotstat); row.SetField("adjlottype", entity.adjlottype); row.SetField("oreasunavty", entity.oreasunavty); row.SetField("prodcat", entity.prodcat); row.SetField("msdssheetno", entity.msdssheetno); row.SetField("adjlotqty", entity.adjlotqty); row.SetField("icsouqty", entity.icsouqty); row.SetField("transid", entity.transid); row.SetField("entrydt", entity.entrydt); row.SetField("runno", entity.runno); row.SetField("reasunavty", entity.reasunavty); row.SetField("reply", entity.reply); row.SetField("binloc1updfl", entity.binloc1updfl); row.SetField("binloc2updfl", entity.binloc2updfl); row.SetField("bincntrupdfl", entity.bincntrupdfl); row.SetField("processty", entity.processty); row.SetField("errorno", entity.errorno); row.SetField("vendno", entity.vendno); row.SetField("shipfmno", entity.shipfmno); row.SetField("contact", entity.contact); row.SetField("phoneno", entity.phoneno); row.SetField("faxphoneno", entity.faxphoneno); row.SetField("edicode", entity.edicode); row.SetField("dunsno", entity.dunsno); row.SetField("transproc", entity.transproc); row.SetField("descrip2", entity.descrip2); row.SetField("memo", entity.memo); row.SetField("casequantity", entity.casequantity); row.SetField("palletquantity", entity.palletquantity); row.SetField("addr3", entity.addr3); row.SetField("wlemRowID", entity.rowID.ToByteArray()); }