/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromAriccreatetransresults(ref DataRow row, Ariccreatetransresults 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("arexrate", entity.arexrate); 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("custno", entity.custno); row.SetField("discamt", entity.discamt); row.SetField("discdt", entity.discdt); 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("lbxautofl", entity.lbxautofl); row.SetField("location", entity.location); row.SetField("module", entity.module); row.SetField("nextseqno", entity.nextseqno); row.SetField("nostmts", entity.nostmts); 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("pymttranscd", entity.pymttranscd); row.SetField("pymttransno", entity.pymttransno); row.SetField("refer", entity.refer); row.SetField("salesexrate", entity.salesexrate); 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("sxextractdt", entity.sxextractdt); row.SetField("termsdisconpst", entity.termsdisconpst); row.SetField("termstype", entity.termstype); row.SetField("transcd", entity.transcd); row.SetField("transdt", entity.transdt); row.SetField("transproc", entity.transproc); 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("rowid-aret", entity.rowidAret.ToByteArray()); row.SetField("damount", entity.damount); row.SetField("custnotesfl", entity.custnotesfl); row.SetField("custpo", entity.custpo); row.SetField("npclaimno", entity.npclaimno); row.SetField("userfield", entity.userfield); }
public static Ariccreatetransresults BuildAriccreatetransresultsFromRow(DataRow row) { Ariccreatetransresults entity = new Ariccreatetransresults(); 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.arexrate = row.IsNull("arexrate") ? decimal.Zero : row.Field <decimal>("arexrate"); 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.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.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.lbxautofl = row.Field <bool>("lbxautofl"); 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.nostmts = row.IsNull("nostmts") ? 0 : row.Field <int>("nostmts"); 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.pymttranscd = row.IsNull("pymttranscd") ? string.Empty : row.Field <string>("pymttranscd"); entity.pymttransno = row.IsNull("pymttransno") ? string.Empty : row.Field <string>("pymttransno"); entity.refer = row.IsNull("refer") ? string.Empty : row.Field <string>("refer"); entity.salesexrate = row.IsNull("salesexrate") ? decimal.Zero : row.Field <decimal>("salesexrate"); 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.sxextractdt = row.Field <DateTime?>("sxextractdt"); entity.termsdisconpst = row.IsNull("termsdisconpst") ? decimal.Zero : row.Field <decimal>("termsdisconpst"); 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.transproc = row.IsNull("transproc") ? string.Empty : row.Field <string>("transproc"); 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.rowidAret = row.Field <byte[]>("rowid-aret").ToStringEncoded(); entity.damount = row.IsNull("damount") ? decimal.Zero : row.Field <decimal>("damount"); entity.custnotesfl = row.IsNull("custnotesfl") ? string.Empty : row.Field <string>("custnotesfl"); entity.custpo = row.IsNull("custpo") ? string.Empty : row.Field <string>("custpo"); entity.npclaimno = row.IsNull("npclaimno") ? string.Empty : row.Field <string>("npclaimno"); entity.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield"); return(entity); }