/// <summary>
/// Update a database row from a class
/// </summary>
public static void UpdateRowFromArettrans(ref DataRow row, Arettrans entity)
{
row.SetField("addonamt1", entity.addonamt1);
row.SetField("addonamt2", entity.addonamt2);
row.SetField("addonamt3", entity.addonamt3);
row.SetField("addonamt4", entity.addonamt4);
row.SetField("amount", entity.amount);
row.SetField("appinvdt", entity.appinvdt);
row.SetField("appinvno", entity.appinvno);
row.SetField("appinvsuf", entity.appinvsuf);
row.SetField("apptranscd", entity.apptranscd);
row.SetField("checkno", entity.checkno);
row.SetField("checknopaid", entity.checknopaid);
row.SetField("codcollamt", entity.codcollamt);
row.SetField("cono", entity.cono);
row.SetField("crjrnlno", entity.crjrnlno);
row.SetField("crsetno", entity.crsetno);
row.SetField("cTransType", entity.cTransType);
row.SetField("custno", entity.custno);
row.SetField("discamt", entity.discamt);
row.SetField("discdt", entity.discdt);
row.SetField("DispSeq", entity.dispSeq);
row.SetField("disputefl", entity.disputefl);
row.SetField("divno", entity.divno);
row.SetField("duedt", entity.duedt);
row.SetField("exchgrate1", entity.exchgrate1);
row.SetField("exchgrate2", entity.exchgrate2);
row.SetField("glacctno", entity.glacctno);
row.SetField("gldeptno", entity.gldeptno);
row.SetField("gldivno", entity.gldivno);
row.SetField("glsubno", entity.glsubno);
row.SetField("invdt", entity.invdt);
row.SetField("invno", entity.invno);
row.SetField("invsuf", entity.invsuf);
row.SetField("jrnlamt", entity.jrnlamt);
row.SetField("jrnlno", entity.jrnlno);
row.SetField("location", entity.location);
row.SetField("module", entity.module);
row.SetField("nextseqno", entity.nextseqno);
row.SetField("notesfl", entity.notesfl);
row.SetField("operinit", entity.operinit);
row.SetField("origdisc", entity.origdisc);
row.SetField("origseqno", entity.origseqno);
row.SetField("paymtamt", entity.paymtamt);
row.SetField("paymtcd", entity.paymtcd);
row.SetField("paymtdt", entity.paymtdt);
row.SetField("percal", entity.percal);
row.SetField("perfisc", entity.perfisc);
row.SetField("period", entity.period);
row.SetField("pifamt", entity.pifamt);
row.SetField("postdt", entity.postdt);
row.SetField("refer", entity.refer);
row.SetField("seqno", entity.seqno);
row.SetField("setno", entity.setno);
row.SetField("shipto", entity.shipto);
row.SetField("slsytdfl", entity.slsytdfl);
row.SetField("sourcecd", entity.sourcecd);
row.SetField("statustype", entity.statustype);
row.SetField("stmtfl1", entity.stmtfl1);
row.SetField("stmtfl2", entity.stmtfl2);
row.SetField("termstype", entity.termstype);
row.SetField("transcd", entity.transcd);
row.SetField("transdt", entity.transdt);
row.SetField("transtm", entity.transtm);
row.SetField("urecno", entity.urecno);
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("arscid", entity.arscid.ToByteArray());
row.SetField("rarscid", entity.rarscid);
row.SetField("caddondesc1", entity.caddondesc1);
row.SetField("caddondesc2", entity.caddondesc2);
row.SetField("currencyty", entity.currencyty);
row.SetField("dmaxcredit", entity.dmaxcredit);
row.SetField("fieldfocus", entity.fieldfocus);
row.SetField("istep", entity.istep);
row.SetField("lauthpt1", entity.lauthpt1);
row.SetField("lautofl", entity.lautofl);
row.SetField("ldivfl", entity.ldivfl);
row.SetField("forinvno", entity.forinvno);
row.SetField("forinvsuf", entity.forinvsuf);
row.SetField("forseqno", entity.forseqno);
row.SetField("fortranscd", entity.fortranscd);
row.SetField("s-exchrate", entity.sExchrate);
row.SetField("secdivno", entity.secdivno);
row.SetField("termsfl", entity.termsfl);
row.SetField("updglarty", entity.updglarty);
row.SetField("carettime", entity.carettime);
row.SetField("daretdate", entity.daretdate);
row.SetField("aretid", entity.aretid.ToByteArray());
row.SetField("raretid", entity.raretid);
row.SetField("xa-termstype", entity.xaTermstype);
row.SetField("xt-discdt", entity.xtDiscdt);
row.SetField("xt-duedt", entity.xtDuedt);
row.SetField("xt-discdays", entity.xtDiscdays);
row.SetField("xt-duedays", entity.xtDuedays);
row.SetField("xt-nopays", entity.xtNopays);
row.SetField("xt-freqdays", entity.xtFreqdays);
row.SetField("xt-discamt", entity.xtDiscamt);
row.SetField("xt-discpct", entity.xtDiscpct);
row.SetField("xv-termsfl", entity.xvTermsfl);
row.SetField("xv-manamtfl", entity.xvManamtfl);
row.SetField("xv-manduefl", entity.xvManduefl);
row.SetField("xv-mandiscfl", entity.xvMandiscfl);
row.SetField("xv-addon1", entity.xvAddon1);
row.SetField("xv-addon2", entity.xvAddon2);
row.SetField("xv-addon3", entity.xvAddon3);
row.SetField("xv-addon4", entity.xvAddon4);
row.SetField("xv-addon5", entity.xvAddon5);
row.SetField("xv-addon6", entity.xvAddon6);
row.SetField("xv-addon7", entity.xvAddon7);
row.SetField("xv-addon8", entity.xvAddon8);
row.SetField("xt-addon1", entity.xtAddon1);
row.SetField("xt-addon2", entity.xtAddon2);
row.SetField("xv-addondist", entity.xvAddondist);
row.SetField("xv-grossnetfl", entity.xvGrossnetfl);
row.SetField("xv-immedpyfl", entity.xvImmedpyfl);
row.SetField("xv-expaddfl", entity.xvExpaddfl);
row.SetField("xlInclAddonsFl", entity.xlInclAddonsFl);
row.SetField("origamount", entity.origamount);
row.SetField("origdivno", entity.origdivno);
row.SetField("originvno", entity.originvno);
row.SetField("originvsuf", entity.originvsuf);
row.SetField("origtermstype", entity.origtermstype);
row.SetField("amountenabled", entity.amountenabled);
row.SetField("custnoenabled", entity.custnoenabled);
row.SetField("disputeflenabled", entity.disputeflenabled);
row.SetField("divnoenabled", entity.divnoenabled);
row.SetField("forinvnoenabled", entity.forinvnoenabled);
row.SetField("forseqnoenabled", entity.forseqnoenabled);
row.SetField("fortranscdenabled", entity.fortranscdenabled);
row.SetField("invdtenabled", entity.invdtenabled);
row.SetField("invnoenabled", entity.invnoenabled);
row.SetField("invsufenabled", entity.invsufenabled);
row.SetField("referenabled", entity.referenabled);
row.SetField("shiptoenabled", entity.shiptoenabled);
row.SetField("slsytdflenabled", entity.slsytdflenabled);
row.SetField("termstypeenabled", entity.termstypeenabled);
row.SetField("transcdenabled", entity.transcdenabled);
row.SetField("fortranscdhidden", entity.fortranscdhidden);
row.SetField("forinvnohidden", entity.forinvnohidden);
row.SetField("forseqnohidden", entity.forseqnohidden);
row.SetField("custnotesfl", entity.custnotesfl);
row.SetField("shiptonotesfl", entity.shiptonotesfl);
row.SetField("forinvnotesfl", entity.forinvnotesfl);
row.SetField("userfield", entity.userfield);
}
public static Arettrans BuildArettransFromRow(DataRow row)
{
Arettrans entity = new Arettrans();
entity.addonamt1 = row.IsNull("addonamt1") ? decimal.Zero : row.Field <decimal>("addonamt1");
entity.addonamt2 = row.IsNull("addonamt2") ? decimal.Zero : row.Field <decimal>("addonamt2");
entity.addonamt3 = row.IsNull("addonamt3") ? decimal.Zero : row.Field <decimal>("addonamt3");
entity.addonamt4 = row.IsNull("addonamt4") ? decimal.Zero : row.Field <decimal>("addonamt4");
entity.amount = row.IsNull("amount") ? decimal.Zero : row.Field <decimal>("amount");
entity.appinvdt = row.Field <DateTime?>("appinvdt");
entity.appinvno = row.IsNull("appinvno") ? 0 : row.Field <int>("appinvno");
entity.appinvsuf = row.IsNull("appinvsuf") ? 0 : row.Field <int>("appinvsuf");
entity.apptranscd = row.IsNull("apptranscd") ? 0 : row.Field <int>("apptranscd");
entity.checkno = row.IsNull("checkno") ? decimal.Zero : row.Field <decimal>("checkno");
entity.checknopaid = row.IsNull("checknopaid") ? decimal.Zero : row.Field <decimal>("checknopaid");
entity.codcollamt = row.IsNull("codcollamt") ? decimal.Zero : row.Field <decimal>("codcollamt");
entity.cono = row.IsNull("cono") ? 0 : row.Field <int>("cono");
entity.crjrnlno = row.IsNull("crjrnlno") ? 0 : row.Field <int>("crjrnlno");
entity.crsetno = row.IsNull("crsetno") ? 0 : row.Field <int>("crsetno");
entity.cTransType = row.IsNull("cTransType") ? string.Empty : row.Field <string>("cTransType");
entity.custno = row.IsNull("custno") ? decimal.Zero : row.Field <decimal>("custno");
entity.discamt = row.IsNull("discamt") ? decimal.Zero : row.Field <decimal>("discamt");
entity.discdt = row.Field <DateTime?>("discdt");
entity.dispSeq = row.IsNull("DispSeq") ? 0 : row.Field <int>("DispSeq");
entity.disputefl = row.Field <bool>("disputefl");
entity.divno = row.IsNull("divno") ? 0 : row.Field <int>("divno");
entity.duedt = row.Field <DateTime?>("duedt");
entity.exchgrate1 = row.IsNull("exchgrate1") ? decimal.Zero : row.Field <decimal>("exchgrate1");
entity.exchgrate2 = row.IsNull("exchgrate2") ? decimal.Zero : row.Field <decimal>("exchgrate2");
entity.glacctno = row.IsNull("glacctno") ? 0 : row.Field <int>("glacctno");
entity.gldeptno = row.IsNull("gldeptno") ? 0 : row.Field <int>("gldeptno");
entity.gldivno = row.IsNull("gldivno") ? 0 : row.Field <int>("gldivno");
entity.glsubno = row.IsNull("glsubno") ? 0 : row.Field <int>("glsubno");
entity.invdt = row.Field <DateTime?>("invdt");
entity.invno = row.IsNull("invno") ? 0 : row.Field <int>("invno");
entity.invsuf = row.IsNull("invsuf") ? 0 : row.Field <int>("invsuf");
entity.jrnlamt = row.IsNull("jrnlamt") ? decimal.Zero : row.Field <decimal>("jrnlamt");
entity.jrnlno = row.IsNull("jrnlno") ? 0 : row.Field <int>("jrnlno");
entity.location = row.IsNull("location") ? string.Empty : row.Field <string>("location");
entity.module = row.IsNull("module") ? string.Empty : row.Field <string>("module");
entity.nextseqno = row.IsNull("nextseqno") ? 0 : row.Field <int>("nextseqno");
entity.notesfl = row.IsNull("notesfl") ? string.Empty : row.Field <string>("notesfl");
entity.operinit = row.IsNull("operinit") ? string.Empty : row.Field <string>("operinit");
entity.origdisc = row.IsNull("origdisc") ? decimal.Zero : row.Field <decimal>("origdisc");
entity.origseqno = row.IsNull("origseqno") ? 0 : row.Field <int>("origseqno");
entity.paymtamt = row.IsNull("paymtamt") ? decimal.Zero : row.Field <decimal>("paymtamt");
entity.paymtcd = row.IsNull("paymtcd") ? 0 : row.Field <int>("paymtcd");
entity.paymtdt = row.Field <DateTime?>("paymtdt");
entity.percal = row.IsNull("percal") ? 0 : row.Field <int>("percal");
entity.perfisc = row.IsNull("perfisc") ? 0 : row.Field <int>("perfisc");
entity.period = row.IsNull("period") ? 0 : row.Field <int>("period");
entity.pifamt = row.IsNull("pifamt") ? decimal.Zero : row.Field <decimal>("pifamt");
entity.postdt = row.Field <DateTime?>("postdt");
entity.refer = row.IsNull("refer") ? string.Empty : row.Field <string>("refer");
entity.seqno = row.IsNull("seqno") ? 0 : row.Field <int>("seqno");
entity.setno = row.IsNull("setno") ? 0 : row.Field <int>("setno");
entity.shipto = row.IsNull("shipto") ? string.Empty : row.Field <string>("shipto");
entity.slsytdfl = row.Field <bool>("slsytdfl");
entity.sourcecd = row.IsNull("sourcecd") ? 0 : row.Field <int>("sourcecd");
entity.statustype = row.Field <bool>("statustype");
entity.stmtfl1 = row.Field <bool>("stmtfl1");
entity.stmtfl2 = row.Field <bool>("stmtfl2");
entity.termstype = row.IsNull("termstype") ? string.Empty : row.Field <string>("termstype");
entity.transcd = row.IsNull("transcd") ? 0 : row.Field <int>("transcd");
entity.transdt = row.Field <DateTime?>("transdt");
entity.transtm = row.IsNull("transtm") ? string.Empty : row.Field <string>("transtm");
entity.urecno = row.IsNull("urecno") ? decimal.Zero : row.Field <decimal>("urecno");
entity.user1 = row.IsNull("user1") ? string.Empty : row.Field <string>("user1");
entity.user2 = row.IsNull("user2") ? string.Empty : row.Field <string>("user2");
entity.user3 = row.IsNull("user3") ? string.Empty : row.Field <string>("user3");
entity.user4 = row.IsNull("user4") ? string.Empty : row.Field <string>("user4");
entity.user5 = row.IsNull("user5") ? string.Empty : row.Field <string>("user5");
entity.user6 = row.Field <decimal?>("user6");
entity.user7 = row.Field <decimal?>("user7");
entity.user8 = row.Field <DateTime?>("user8");
entity.user9 = row.Field <DateTime?>("user9");
entity.arscid = row.Field <byte[]>("arscid").ToStringEncoded();
entity.rarscid = row.IsNull("rarscid") ? 0 : row.Field <long>("rarscid");
entity.caddondesc1 = row.IsNull("caddondesc1") ? string.Empty : row.Field <string>("caddondesc1");
entity.caddondesc2 = row.IsNull("caddondesc2") ? string.Empty : row.Field <string>("caddondesc2");
entity.currencyty = row.IsNull("currencyty") ? string.Empty : row.Field <string>("currencyty");
entity.dmaxcredit = row.IsNull("dmaxcredit") ? decimal.Zero : row.Field <decimal>("dmaxcredit");
entity.fieldfocus = row.IsNull("fieldfocus") ? string.Empty : row.Field <string>("fieldfocus");
entity.istep = row.IsNull("istep") ? 0 : row.Field <int>("istep");
entity.lauthpt1 = row.Field <bool>("lauthpt1");
entity.lautofl = row.Field <bool>("lautofl");
entity.ldivfl = row.Field <bool>("ldivfl");
entity.forinvno = row.IsNull("forinvno") ? 0 : row.Field <int>("forinvno");
entity.forinvsuf = row.IsNull("forinvsuf") ? 0 : row.Field <int>("forinvsuf");
entity.forseqno = row.IsNull("forseqno") ? 0 : row.Field <int>("forseqno");
entity.fortranscd = row.IsNull("fortranscd") ? 0 : row.Field <int>("fortranscd");
entity.sExchrate = row.IsNull("s-exchrate") ? decimal.Zero : row.Field <decimal>("s-exchrate");
entity.secdivno = row.IsNull("secdivno") ? 0 : row.Field <int>("secdivno");
entity.termsfl = row.Field <bool>("termsfl");
entity.updglarty = row.IsNull("updglarty") ? string.Empty : row.Field <string>("updglarty");
entity.carettime = row.IsNull("carettime") ? string.Empty : row.Field <string>("carettime");
entity.daretdate = row.Field <DateTime?>("daretdate");
entity.aretid = row.Field <byte[]>("aretid").ToStringEncoded();
entity.raretid = row.IsNull("raretid") ? 0 : row.Field <long>("raretid");
entity.xaTermstype = row.IsNull("xa-termstype") ? string.Empty : row.Field <string>("xa-termstype");
entity.xtDiscdt = row.Field <DateTime?>("xt-discdt");
entity.xtDuedt = row.Field <DateTime?>("xt-duedt");
entity.xtDiscdays = row.IsNull("xt-discdays") ? 0 : row.Field <int>("xt-discdays");
entity.xtDuedays = row.IsNull("xt-duedays") ? 0 : row.Field <int>("xt-duedays");
entity.xtNopays = row.IsNull("xt-nopays") ? 0 : row.Field <int>("xt-nopays");
entity.xtFreqdays = row.IsNull("xt-freqdays") ? 0 : row.Field <int>("xt-freqdays");
entity.xtDiscamt = row.IsNull("xt-discamt") ? decimal.Zero : row.Field <decimal>("xt-discamt");
entity.xtDiscpct = row.IsNull("xt-discpct") ? decimal.Zero : row.Field <decimal>("xt-discpct");
entity.xvTermsfl = row.Field <bool>("xv-termsfl");
entity.xvManamtfl = row.Field <bool>("xv-manamtfl");
entity.xvManduefl = row.Field <bool>("xv-manduefl");
entity.xvMandiscfl = row.Field <bool>("xv-mandiscfl");
entity.xvAddon1 = row.IsNull("xv-addon1") ? 0 : row.Field <int>("xv-addon1");
entity.xvAddon2 = row.IsNull("xv-addon2") ? 0 : row.Field <int>("xv-addon2");
entity.xvAddon3 = row.IsNull("xv-addon3") ? 0 : row.Field <int>("xv-addon3");
entity.xvAddon4 = row.IsNull("xv-addon4") ? 0 : row.Field <int>("xv-addon4");
entity.xvAddon5 = row.IsNull("xv-addon5") ? 0 : row.Field <int>("xv-addon5");
entity.xvAddon6 = row.IsNull("xv-addon6") ? 0 : row.Field <int>("xv-addon6");
entity.xvAddon7 = row.IsNull("xv-addon7") ? 0 : row.Field <int>("xv-addon7");
entity.xvAddon8 = row.IsNull("xv-addon8") ? 0 : row.Field <int>("xv-addon8");
entity.xtAddon1 = row.IsNull("xt-addon1") ? decimal.Zero : row.Field <decimal>("xt-addon1");
entity.xtAddon2 = row.IsNull("xt-addon2") ? decimal.Zero : row.Field <decimal>("xt-addon2");
entity.xvAddondist = row.IsNull("xv-addondist") ? decimal.Zero : row.Field <decimal>("xv-addondist");
entity.xvGrossnetfl = row.Field <bool>("xv-grossnetfl");
entity.xvImmedpyfl = row.Field <bool>("xv-immedpyfl");
entity.xvExpaddfl = row.Field <bool>("xv-expaddfl");
entity.xlInclAddonsFl = row.Field <bool>("xlInclAddonsFl");
entity.origamount = row.IsNull("origamount") ? decimal.Zero : row.Field <decimal>("origamount");
entity.origdivno = row.IsNull("origdivno") ? 0 : row.Field <int>("origdivno");
entity.originvno = row.IsNull("originvno") ? 0 : row.Field <int>("originvno");
entity.originvsuf = row.IsNull("originvsuf") ? 0 : row.Field <int>("originvsuf");
entity.origtermstype = row.IsNull("origtermstype") ? string.Empty : row.Field <string>("origtermstype");
entity.amountenabled = row.Field <bool>("amountenabled");
entity.custnoenabled = row.Field <bool>("custnoenabled");
entity.disputeflenabled = row.Field <bool>("disputeflenabled");
entity.divnoenabled = row.Field <bool>("divnoenabled");
entity.forinvnoenabled = row.Field <bool>("forinvnoenabled");
entity.forseqnoenabled = row.Field <bool>("forseqnoenabled");
entity.fortranscdenabled = row.Field <bool>("fortranscdenabled");
entity.invdtenabled = row.Field <bool>("invdtenabled");
entity.invnoenabled = row.Field <bool>("invnoenabled");
entity.invsufenabled = row.Field <bool>("invsufenabled");
entity.referenabled = row.Field <bool>("referenabled");
entity.shiptoenabled = row.Field <bool>("shiptoenabled");
entity.slsytdflenabled = row.Field <bool>("slsytdflenabled");
entity.termstypeenabled = row.Field <bool>("termstypeenabled");
entity.transcdenabled = row.Field <bool>("transcdenabled");
entity.fortranscdhidden = row.Field <bool>("fortranscdhidden");
entity.forinvnohidden = row.Field <bool>("forinvnohidden");
entity.forseqnohidden = row.Field <bool>("forseqnohidden");
entity.custnotesfl = row.IsNull("custnotesfl") ? string.Empty : row.Field <string>("custnotesfl");
entity.shiptonotesfl = row.IsNull("shiptonotesfl") ? string.Empty : row.Field <string>("shiptonotesfl");
entity.forinvnotesfl = row.IsNull("forinvnotesfl") ? string.Empty : row.Field <string>("forinvnotesfl");
entity.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield");
return(entity);
}
