/// <summary> /// Build a minimal row from a class (key fields only) /// </summary> public static void BuildMinimalRow(ref DataRow row, PvWtlnBase entity) { row.SetField("pv_wtlnRowID", entity.rowID.ToByteArray()); }
/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromPvWtlnBase(ref DataRow row, PvWtlnBase entity) { row.SetField("wtno", entity.wtno); row.SetField("wtsuf", entity.wtsuf); row.SetField("lineno", entity.lineno); row.SetField("filler-1", entity.filler1); row.SetField("filler-2", entity.filler2); row.SetField("cubes", entity.cubes); row.SetField("duedt", entity.duedt); row.SetField("nonstockty", entity.nonstockty); row.SetField("prod", entity.prod); row.SetField("prodcati", entity.prodcati); row.SetField("proddesc", entity.proddesc); row.SetField("qtyord", entity.qtyord); row.SetField("stkqtyord", entity.stkqtyord); row.SetField("unit", entity.unit); row.SetField("weight", entity.weight); row.SetField("filler-3", entity.filler3); row.SetField("commentfl", entity.commentfl); row.SetField("unitconv", entity.unitconv); row.SetField("idwtel", entity.idwtel); row.SetField("idicsp", entity.idicsp); row.SetField("idicsw", entity.idicsw); row.SetField("linefl", entity.linefl); row.SetField("maint-l", entity.maintL); row.SetField("nosnlots", entity.nosnlots); row.SetField("filler-4", entity.filler4); row.SetField("speccostty", entity.speccostty); row.SetField("csunperstk", entity.csunperstk); row.SetField("specconv", entity.specconv); row.SetField("prccostper", entity.prccostper); row.SetField("icspecrecno", entity.icspecrecno); row.SetField("serlottype", entity.serlottype); row.SetField("netavail", entity.netavail); row.SetField("proddesc1", entity.proddesc1); row.SetField("netamt", entity.netamt); row.SetField("proddesc2", entity.proddesc2); row.SetField("wtelrecid", entity.wtelrecid); row.SetField("wtelrowid", entity.wtelrowid); row.SetField("stkunit", entity.stkunit); 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("prodinrcvfl", entity.prodinrcvfl); row.SetField("prodcost", entity.prodcost); row.SetField("approvety", entity.approvety); row.SetField("usagefl", entity.usagefl); row.SetField("bofl", entity.bofl); row.SetField("ordertype", entity.ordertype); row.SetField("orderaltno", entity.orderaltno); row.SetField("stkqtyship", entity.stkqtyship); row.SetField("qtyship", entity.qtyship); row.SetField("vendno", entity.vendno); row.SetField("prodline", entity.prodline); row.SetField("prodcato", entity.prodcato); row.SetField("arpwhse", entity.arpwhse); row.SetField("reqprod", entity.reqprod); row.SetField("xrefprodty", entity.xrefprodty); row.SetField("orgweight", entity.orgweight); row.SetField("orgcubes", entity.orgcubes); row.SetField("orgnetamt", entity.orgnetamt); row.SetField("orgcatwtfl", entity.orgcatwtfl); row.SetField("orgnetord", entity.orgnetord); row.SetField("orgnosnlots", entity.orgnosnlots); row.SetField("orgnonstockty", entity.orgnonstockty); row.SetField("orgprod", entity.orgprod); row.SetField("orgstkqtyord", entity.orgstkqtyord); row.SetField("orgunit", entity.orgunit); row.SetField("orgidicsp", entity.orgidicsp); row.SetField("orgidicsw", entity.orgidicsw); row.SetField("orgidicsp2", entity.orgidicsp2); row.SetField("orgidicsw2", entity.orgidicsw2); row.SetField("orgprodcati", entity.orgprodcati); row.SetField("orgprodcato", entity.orgprodcato); row.SetField("orgqtyord", entity.orgqtyord); row.SetField("orgprodcost", entity.orgprodcost); row.SetField("orgstkqtyship", entity.orgstkqtyship); row.SetField("orgqtyship", entity.orgqtyship); row.SetField("orgtotqtyship", entity.orgtotqtyship); row.SetField("orgtotqtyord", entity.orgtotqtyord); row.SetField("idicsp2", entity.idicsp2); row.SetField("idicsw2", entity.idicsw2); row.SetField("orgapprovety", entity.orgapprovety); row.SetField("orgbofl", entity.orgbofl); row.SetField("orgunitchg", entity.orgunitchg); row.SetField("crprod", entity.crprod); row.SetField("firstsuperwarnfl", entity.firstsuperwarnfl); row.SetField("reasunavty", entity.reasunavty); row.SetField("qtyunavail", entity.qtyunavail); row.SetField("delayresrvfl", entity.delayresrvfl); row.SetField("userchr1", entity.userchr1); row.SetField("userchr2", entity.userchr2); row.SetField("userchr3", entity.userchr3); row.SetField("userchr4", entity.userchr4); row.SetField("userdec1", entity.userdec1); row.SetField("userdec2", entity.userdec2); row.SetField("userdt1", entity.userdt1); row.SetField("userdt2", entity.userdt2); 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("pv_wtlnRowID", entity.rowID.ToByteArray()); }