Exemple #1
0
 /// <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);
 }
Exemple #2
0
        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);
        }