/// <summary> /// Build a minimal row from a class (key fields only) /// </summary> public static void BuildMinimalRow(ref DataRow row, PvShoplistBase entity) { row.SetField("cono", entity.cono); row.SetField("oper2", entity.oper2); row.SetField("prod", entity.prod); row.SetField("pv_shoplistRowID", entity.rowID.ToByteArray()); }
/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromPvShoplistBase(ref DataRow row, PvShoplistBase entity) { row.SetField("cono", entity.cono); row.SetField("oper2", entity.oper2); row.SetField("prod", entity.prod); row.SetField("dsplprod", entity.dsplprod); row.SetField("addswoptprodfl", entity.addswoptprodfl); row.SetField("chrg", entity.chrg); row.SetField("cubes", entity.cubes); row.SetField("descrip", entity.descrip); row.SetField("descrip2", entity.descrip2); row.SetField("icspecrecno", entity.icspecrecno); row.SetField("speccostty", entity.speccostty); row.SetField("csunperstk", entity.csunperstk); row.SetField("prccostper", entity.prccostper); row.SetField("discamt", entity.discamt); row.SetField("discoverfl", entity.discoverfl); row.SetField("disctype", entity.disctype); row.SetField("extra-1", entity.extra1); row.SetField("extra-2", entity.extra2); row.SetField("lastpurdt", entity.lastpurdt); row.SetField("lastprice", entity.lastprice); row.SetField("lookupnm", entity.lookupnm); row.SetField("marginamt", entity.marginamt); row.SetField("marginpct", entity.marginpct); row.SetField("netord", entity.netord); row.SetField("netrecommend", entity.netrecommend); row.SetField("notesfl", entity.notesfl); row.SetField("pdrecno", entity.pdrecno); row.SetField("pdsvfl", entity.pdsvfl); row.SetField("arpprodline", entity.arpprodline); row.SetField("price", entity.price); row.SetField("priceoverfl", entity.priceoverfl); row.SetField("prodcat", entity.prodcat); row.SetField("prodcost", entity.prodcost); row.SetField("qtyavail", entity.qtyavail); row.SetField("qtybreakty", entity.qtybreakty); row.SetField("qtyord", entity.qtyord); row.SetField("qtyrecommend", entity.qtyrecommend); row.SetField("seasontype", entity.seasontype); row.SetField("specnstype", entity.specnstype); row.SetField("specconv", entity.specconv); row.SetField("statmessage", entity.statmessage); row.SetField("stkqtyord", entity.stkqtyord); row.SetField("stkqtyrecommend", entity.stkqtyrecommend); row.SetField("totalstkqty", entity.totalstkqty); row.SetField("unit", entity.unit); row.SetField("unitconv", entity.unitconv); row.SetField("weight", entity.weight); row.SetField("whse", entity.whse); row.SetField("seqno", entity.seqno); row.SetField("optionalwords", entity.optionalwords); row.SetField("arpvendno", entity.arpvendno); row.SetField("transdt", entity.transdt); row.SetField("transtm", entity.transtm); row.SetField("transproc", entity.transproc); row.SetField("operinit", entity.operinit); 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("contractno", entity.contractno); row.SetField("pdsvcrecno", entity.pdsvcrecno); row.SetField("dsplqtyavail", entity.dsplqtyavail); row.SetField("custreservefoundfl", entity.custreservefoundfl); row.SetField("pv_shoplistRowID", entity.rowID.ToByteArray()); }