/// <summary> /// Build a minimal row from a class (key fields only) /// </summary> public static void BuildMinimalRow(ref DataRow row, SastaBase entity) { row.SetField("cono", entity.cono); row.SetField("codeiden", entity.codeiden); row.SetField("codeval", entity.codeval); row.SetField("sastaRowID", entity.rowID.ToByteArray()); row.SetField("rowpointer", entity.rowpointer); }
/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromSastaBase(ref DataRow row, SastaBase entity) { row.SetField("cono", entity.cono); row.SetField("codeiden", entity.codeiden); row.SetField("codeval", entity.codeval); row.SetField("descrip", entity.descrip); row.SetField("unitconv", entity.unitconv); row.SetField("minmarpct", entity.minmarpct); row.SetField("maxmarpct", entity.maxmarpct); row.SetField("whse", entity.whse); row.SetField("editpcd", entity.editpcd); row.SetField("edidtcd", entity.edidtcd); row.SetField("ediunavty", entity.ediunavty); row.SetField("operinit", entity.operinit); row.SetField("transtm", entity.transtm); row.SetField("transdt", entity.transdt); row.SetField("termspct", entity.termspct); row.SetField("user1", entity.user1); row.SetField("discdays", entity.discdays); row.SetField("user2", entity.user2); row.SetField("duedays", entity.duedays); row.SetField("user3", entity.user3); row.SetField("proxcutday", entity.proxcutday); row.SetField("user4", entity.user4); row.SetField("nopaymts", entity.nopaymts); row.SetField("user5", entity.user5); row.SetField("termsfreq", entity.termsfreq); row.SetField("user6", entity.user6); row.SetField("pcatdiscfl", entity.pcatdiscfl); row.SetField("user7", entity.user7); row.SetField("lostbususagefl", entity.lostbususagefl); row.SetField("user8", entity.user8); row.SetField("user9", entity.user9); row.SetField("termslinefl", entity.termslinefl); row.SetField("termscodfl", entity.termscodfl); row.SetField("unitediuom", entity.unitediuom); row.SetField("returnty", entity.returnty); row.SetField("restockfl", entity.restockfl); row.SetField("restockamt", entity.restockamt); row.SetField("reqwarrfl", entity.reqwarrfl); row.SetField("reqauthfl", entity.reqauthfl); row.SetField("disctype", entity.disctype); row.SetField("duetype", entity.duetype); row.SetField("discdt", entity.discdt); row.SetField("duedt", entity.duedt); row.SetField("disccutday", entity.disccutday); row.SetField("dueproxday1", entity.dueproxday1); row.SetField("dueproxday2", entity.dueproxday2); row.SetField("discproxday1", entity.discproxday1); row.SetField("discproxday2", entity.discproxday2); row.SetField("splitfl", entity.splitfl); row.SetField("discsplitfl", entity.discsplitfl); row.SetField("proxmonths1", entity.proxmonths1); row.SetField("proxmonths2", entity.proxmonths2); row.SetField("duecutday", entity.duecutday); row.SetField("reasunavty", entity.reasunavty); row.SetField("reqinvfl", entity.reqinvfl); row.SetField("usagefl", entity.usagefl); row.SetField("warrexchgfl", entity.warrexchgfl); row.SetField("schedmm", entity.schedmm); row.SetField("scheddd", entity.scheddd); row.SetField("schedyy", entity.schedyy); row.SetField("schedwd", entity.schedwd); row.SetField("trmgrlang", entity.trmgrlang); row.SetField("transproc", entity.transproc); row.SetField("exclecomm", entity.exclecomm); row.SetField("restktaxgrp", entity.restktaxgrp); row.SetField("ptxfeeprod", entity.ptxfeeprod); row.SetField("ptxfeecat", entity.ptxfeecat); row.SetField("ptxfeeduration", entity.ptxfeeduration); row.SetField("ptxfeenodays", entity.ptxfeenodays); row.SetField("gldivno", entity.gldivno); row.SetField("gldeptno", entity.gldeptno); row.SetField("glacctno", entity.glacctno); row.SetField("glsubno", entity.glsubno); row.SetField("exclmdd", entity.exclmdd); row.SetField("vendprodgrouptype", entity.vendprodgrouptype); row.SetField("vendprodgroupref", entity.vendprodgroupref); row.SetField("vendprodgroupsubref", entity.vendprodgroupsubref); row.SetField("jmdescrip", entity.jmdescrip); row.SetField("jmunit", entity.jmunit); row.SetField("jmspeccostty", entity.jmspeccostty); row.SetField("jmcsunperstk", entity.jmcsunperstk); row.SetField("jmprccostper", entity.jmprccostper); row.SetField("cconlyfl", entity.cconlyfl); row.SetField("extdescrip", entity.extdescrip); row.SetField("rulesettings", entity.rulesettings); row.SetField("rowpointer", entity.rowpointer); row.SetField("categorylist", entity.categorylist); row.SetField("reporttovendorfl", entity.reporttovendorfl); row.SetField("securitysettings", entity.securitysettings); row.SetField("vendno", entity.vendno); row.SetField("edistkprccd", entity.edistkprccd); row.SetField("shipfmno", entity.shipfmno); row.SetField("edistkprcadj", entity.edistkprcadj); row.SetField("prodcat", entity.prodcat); row.SetField("prodline", entity.prodline); row.SetField("unavailtype", entity.unavailtype); row.SetField("pricetype", entity.pricetype); row.SetField("intracountrycd", entity.intracountrycd); row.SetField("intraeslrptfl", entity.intraeslrptfl); row.SetField("usesuppunitsfl", entity.usesuppunitsfl); row.SetField("billacctcd", entity.billacctcd); row.SetField("dnbiinterfacefl", entity.dnbiinterfacefl); row.SetField("dnbicredlim", entity.dnbicredlim); row.SetField("esbactioncode", entity.esbactioncode); row.SetField("reqinvcrfl", entity.reqinvcrfl); row.SetField("creditrebillfl", entity.creditrebillfl); row.SetField("crserialfl", entity.crserialfl); row.SetField("crrebatesfl", entity.crrebatesfl); row.SetField("transdttmz", entity.transdttmz); row.SetField("sastaRowID", entity.rowID.ToByteArray()); }