/// <summary> /// Build a minimal row from a class (key fields only) /// </summary> public static void BuildMinimalRow(ref DataRow row, WtelBase entity) { row.SetField("wtno", entity.wtno); row.SetField("wtsuf", entity.wtsuf); row.SetField("lineno", entity.lineno); row.SetField("wtelRowID", entity.rowID.ToByteArray()); row.SetField("rowpointer", entity.rowpointer); }
/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromWtelBase(ref DataRow row, WtelBase entity) { row.SetField("wtno", entity.wtno); row.SetField("wtsuf", entity.wtsuf); row.SetField("shipfmwhse", entity.shipfmwhse); row.SetField("transtype", entity.transtype); row.SetField("lineno", entity.lineno); row.SetField("qtyord", entity.qtyord); row.SetField("cono", entity.cono); row.SetField("unit", entity.unit); row.SetField("transdt", entity.transdt); row.SetField("enterdt", entity.enterdt); row.SetField("operinit", entity.operinit); row.SetField("shipprod", entity.shipprod); row.SetField("transtm", entity.transtm); row.SetField("stkqtyship", entity.stkqtyship); row.SetField("prodcost", entity.prodcost); row.SetField("prodcati", entity.prodcati); row.SetField("usagefl", entity.usagefl); row.SetField("ordertype", entity.ordertype); row.SetField("weight", entity.weight); row.SetField("cubes", entity.cubes); row.SetField("qtyfmrcvs", entity.qtyfmrcvs); row.SetField("ostkqtyship", entity.ostkqtyship); row.SetField("qtyactship", entity.qtyactship); row.SetField("notimeschg", entity.notimeschg); row.SetField("statustype", entity.statustype); row.SetField("proddesc2", entity.proddesc2); row.SetField("leadoverty", entity.leadoverty); row.SetField("icspecrecno", entity.icspecrecno); row.SetField("printfl", entity.printfl); row.SetField("chrgqtyi", entity.chrgqtyi); row.SetField("bono", entity.bono); row.SetField("costoverfl", entity.costoverfl); row.SetField("user3", entity.user3); row.SetField("user4", entity.user4); row.SetField("user5", entity.user5); row.SetField("user6", entity.user6); row.SetField("nosnlotsi", entity.nosnlotsi); row.SetField("user7", entity.user7); row.SetField("user8", entity.user8); row.SetField("user9", entity.user9); row.SetField("prevqtyshp", entity.prevqtyshp); row.SetField("commentfl", entity.commentfl); row.SetField("catwtfli", entity.catwtfli); row.SetField("bofl", entity.bofl); row.SetField("qtyship", entity.qtyship); row.SetField("duedt", entity.duedt); row.SetField("arpoverfl", entity.arpoverfl); row.SetField("cono2", entity.cono2); row.SetField("shiptowhse", entity.shiptowhse); row.SetField("netamt", entity.netamt); row.SetField("proddesc", entity.proddesc); row.SetField("stkqtyord", entity.stkqtyord); row.SetField("approvety", entity.approvety); row.SetField("approvedt", entity.approvedt); row.SetField("approveinit", entity.approveinit); row.SetField("chrgqtyo", entity.chrgqtyo); row.SetField("netrcv", entity.netrcv); row.SetField("prodcato", entity.prodcato); row.SetField("qtyrcv", entity.qtyrcv); row.SetField("stkqtyrcv", entity.stkqtyrcv); row.SetField("catwtflo", entity.catwtflo); row.SetField("linealtno", entity.linealtno); row.SetField("orderaltno", entity.orderaltno); row.SetField("nosnlotso", entity.nosnlotso); row.SetField("nonstockty", entity.nonstockty); row.SetField("binloc", entity.binloc); row.SetField("reqprod", entity.reqprod); row.SetField("xrefprodty", entity.xrefprodty); row.SetField("vendno", entity.vendno); row.SetField("prodline", entity.prodline); row.SetField("prodinrcvfl", entity.prodinrcvfl); row.SetField("netord", entity.netord); row.SetField("qtyunavail", entity.qtyunavail); row.SetField("reasunavty", entity.reasunavty); row.SetField("delayresrvfl", entity.delayresrvfl); row.SetField("glcostrcv", entity.glcostrcv); row.SetField("lastbofl", entity.lastbofl); row.SetField("glcostexc", entity.glcostexc); row.SetField("user1", entity.user1); row.SetField("user2", entity.user2); row.SetField("addonamt", entity.addonamt); row.SetField("wmqtyship", entity.wmqtyship); row.SetField("wmqtyrcv", entity.wmqtyrcv); row.SetField("unitconv", entity.unitconv); row.SetField("transproc", entity.transproc); 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("custstkqtyshp", entity.custstkqtyshp); row.SetField("custprodcost", entity.custprodcost); row.SetField("cutfl", entity.cutfl); row.SetField("cutlossamt", entity.cutlossamt); row.SetField("scraplossamt", entity.scraplossamt); row.SetField("rowpointer", entity.rowpointer); row.SetField("transdttmz", entity.transdttmz); row.SetField("wtelRowID", entity.rowID.ToByteArray()); }