Esempio n. 1
0
 /// <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);
 }
Esempio n. 2
0
 /// <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());
 }