Exemplo n.º 1
0
 /// <summary>
 /// Update a database row from a class
 /// </summary>
 public static void UpdateRowFromArelecheckdtl(ref DataRow row, Arelecheckdtl entity)
 {
     row.SetField("batch", entity.batch);
     row.SetField("custno", entity.custno);
     row.SetField("checkno", entity.checkno);
     row.SetField("lbxinvno", entity.lbxinvno);
     row.SetField("lbxamt", entity.lbxamt);
     row.SetField("aretid", entity.aretid);
     row.SetField("invno", entity.invno);
     row.SetField("invsuf", entity.invsuf);
     row.SetField("seqno", entity.seqno);
     row.SetField("invamt", entity.invamt);
     row.SetField("duedt", entity.duedt);
     row.SetField("trancd", entity.trancd);
     row.SetField("piffl", entity.piffl);
     row.SetField("applyamt", entity.applyamt);
     row.SetField("discamt", entity.discamt);
     row.SetField("invcustno", entity.invcustno);
     row.SetField("aretnffl", entity.aretnffl);
     row.SetField("statfl", entity.statfl);
     row.SetField("refer", entity.refer);
     row.SetField("prefix", entity.prefix);
     row.SetField("cbinvno", entity.cbinvno);
     row.SetField("adddata1", entity.adddata1);
     row.SetField("adddata2", entity.adddata2);
     row.SetField("adddata3", entity.adddata3);
     row.SetField("adddata4", entity.adddata4);
     row.SetField("adddata5", entity.adddata5);
     row.SetField("adddata6", entity.adddata6);
     row.SetField("adddata7", entity.adddata7);
     row.SetField("adddata8", entity.adddata8);
     row.SetField("adddata9", entity.adddata9);
     row.SetField("adddata10", entity.adddata10);
     row.SetField("autopostfl", entity.autopostfl);
     row.SetField("transdt", entity.transdt);
     row.SetField("transtm", entity.transtm);
     row.SetField("operinit", entity.operinit);
     row.SetField("Chgfl", entity.chgfl);
     row.SetField("dWOAmt", entity.dWOAmt);
     row.SetField("lRanWOFl", entity.lRanWOFl);
     row.SetField("arbclid", entity.arbclid);
     row.SetField("arbchid", entity.arbchid.ToByteArray());
     row.SetField("dtlerror", entity.dtlerror);
     row.SetField("deletefl", entity.deletefl);
     row.SetField("dtlrowid", entity.dtlrowid.ToByteArray());
     row.SetField("dMaxAmt", entity.dMaxAmt);
     row.SetField("dMinAmt", entity.dMinAmt);
     row.SetField("lCheckChgFl", entity.lCheckChgFl);
     row.SetField("lNSFFl", entity.lNSFFl);
     row.SetField("rarbchid", entity.rarbchid);
     row.SetField("trancddesc", entity.trancddesc);
     row.SetField("WOProof", entity.wOProof);
     row.SetField("arbclrowid", entity.arbclrowid.ToByteArray());
     row.SetField("aretrowid", entity.aretrowid.ToByteArray());
     row.SetField("discamtenable", entity.discamtenable);
     row.SetField("dtlfieldsenable", entity.dtlfieldsenable);
     row.SetField("pifflenable", entity.pifflenable);
     row.SetField("origapplyamt", entity.origapplyamt);
     row.SetField("origaretid", entity.origaretid);
     row.SetField("origaretnffl", entity.origaretnffl);
     row.SetField("origcbinvno", entity.origcbinvno);
     row.SetField("origcustno", entity.origcustno);
     row.SetField("origdiscamt", entity.origdiscamt);
     row.SetField("origduedt", entity.origduedt);
     row.SetField("origdWOAmt", entity.origdWOAmt);
     row.SetField("originvamt", entity.originvamt);
     row.SetField("originvcustno", entity.originvcustno);
     row.SetField("originvno", entity.originvno);
     row.SetField("originvsuf", entity.originvsuf);
     row.SetField("origlbxinvno", entity.origlbxinvno);
     row.SetField("origlbxamt", entity.origlbxamt);
     row.SetField("origlRanWOFl", entity.origlRanWOFl);
     row.SetField("origoperinit", entity.origoperinit);
     row.SetField("origpiffl", entity.origpiffl);
     row.SetField("origprefix", entity.origprefix);
     row.SetField("origrefer", entity.origrefer);
     row.SetField("origseqno", entity.origseqno);
     row.SetField("origstatfl", entity.origstatfl);
     row.SetField("origtrancd", entity.origtrancd);
     row.SetField("origtrancddesc", entity.origtrancddesc);
     row.SetField("userfield", entity.userfield);
 }
Exemplo n.º 2
0
        public static Arelecheckdtl BuildArelecheckdtlFromRow(DataRow row)
        {
            Arelecheckdtl entity = new Arelecheckdtl();

            entity.batch           = row.IsNull("batch") ? string.Empty : row.Field <string>("batch");
            entity.custno          = row.IsNull("custno") ? decimal.Zero : row.Field <decimal>("custno");
            entity.checkno         = row.IsNull("checkno") ? 0 : row.Field <int>("checkno");
            entity.lbxinvno        = row.IsNull("lbxinvno") ? string.Empty : row.Field <string>("lbxinvno");
            entity.lbxamt          = row.IsNull("lbxamt") ? decimal.Zero : row.Field <decimal>("lbxamt");
            entity.aretid          = row.IsNull("aretid") ? 0 : row.Field <long>("aretid");
            entity.invno           = row.IsNull("invno") ? 0 : row.Field <int>("invno");
            entity.invsuf          = row.IsNull("invsuf") ? 0 : row.Field <int>("invsuf");
            entity.seqno           = row.IsNull("seqno") ? 0 : row.Field <int>("seqno");
            entity.invamt          = row.IsNull("invamt") ? decimal.Zero : row.Field <decimal>("invamt");
            entity.duedt           = row.Field <DateTime?>("duedt");
            entity.trancd          = row.IsNull("trancd") ? string.Empty : row.Field <string>("trancd");
            entity.piffl           = row.Field <bool>("piffl");
            entity.applyamt        = row.IsNull("applyamt") ? decimal.Zero : row.Field <decimal>("applyamt");
            entity.discamt         = row.IsNull("discamt") ? decimal.Zero : row.Field <decimal>("discamt");
            entity.invcustno       = row.IsNull("invcustno") ? decimal.Zero : row.Field <decimal>("invcustno");
            entity.aretnffl        = row.Field <bool>("aretnffl");
            entity.statfl          = row.Field <bool>("statfl");
            entity.refer           = row.IsNull("refer") ? string.Empty : row.Field <string>("refer");
            entity.prefix          = row.IsNull("prefix") ? 0 : row.Field <int>("prefix");
            entity.cbinvno         = row.IsNull("cbinvno") ? 0 : row.Field <int>("cbinvno");
            entity.adddata1        = row.IsNull("adddata1") ? string.Empty : row.Field <string>("adddata1");
            entity.adddata2        = row.IsNull("adddata2") ? string.Empty : row.Field <string>("adddata2");
            entity.adddata3        = row.IsNull("adddata3") ? string.Empty : row.Field <string>("adddata3");
            entity.adddata4        = row.IsNull("adddata4") ? string.Empty : row.Field <string>("adddata4");
            entity.adddata5        = row.IsNull("adddata5") ? string.Empty : row.Field <string>("adddata5");
            entity.adddata6        = row.IsNull("adddata6") ? string.Empty : row.Field <string>("adddata6");
            entity.adddata7        = row.IsNull("adddata7") ? string.Empty : row.Field <string>("adddata7");
            entity.adddata8        = row.IsNull("adddata8") ? string.Empty : row.Field <string>("adddata8");
            entity.adddata9        = row.IsNull("adddata9") ? string.Empty : row.Field <string>("adddata9");
            entity.adddata10       = row.IsNull("adddata10") ? string.Empty : row.Field <string>("adddata10");
            entity.autopostfl      = row.Field <bool>("autopostfl");
            entity.transdt         = row.Field <DateTime?>("transdt");
            entity.transtm         = row.IsNull("transtm") ? string.Empty : row.Field <string>("transtm");
            entity.operinit        = row.IsNull("operinit") ? string.Empty : row.Field <string>("operinit");
            entity.chgfl           = row.Field <bool>("Chgfl");
            entity.dWOAmt          = row.IsNull("dWOAmt") ? decimal.Zero : row.Field <decimal>("dWOAmt");
            entity.lRanWOFl        = row.Field <bool>("lRanWOFl");
            entity.arbclid         = row.IsNull("arbclid") ? 0 : row.Field <long>("arbclid");
            entity.arbchid         = row.Field <byte[]>("arbchid").ToStringEncoded();
            entity.dtlerror        = row.IsNull("dtlerror") ? string.Empty : row.Field <string>("dtlerror");
            entity.deletefl        = row.Field <bool>("deletefl");
            entity.dtlrowid        = row.Field <byte[]>("dtlrowid").ToStringEncoded();
            entity.dMaxAmt         = row.IsNull("dMaxAmt") ? decimal.Zero : row.Field <decimal>("dMaxAmt");
            entity.dMinAmt         = row.IsNull("dMinAmt") ? decimal.Zero : row.Field <decimal>("dMinAmt");
            entity.lCheckChgFl     = row.Field <bool>("lCheckChgFl");
            entity.lNSFFl          = row.Field <bool>("lNSFFl");
            entity.rarbchid        = row.IsNull("rarbchid") ? 0 : row.Field <long>("rarbchid");
            entity.trancddesc      = row.IsNull("trancddesc") ? string.Empty : row.Field <string>("trancddesc");
            entity.wOProof         = row.IsNull("WOProof") ? decimal.Zero : row.Field <decimal>("WOProof");
            entity.arbclrowid      = row.Field <byte[]>("arbclrowid").ToStringEncoded();
            entity.aretrowid       = row.Field <byte[]>("aretrowid").ToStringEncoded();
            entity.discamtenable   = row.Field <bool>("discamtenable");
            entity.dtlfieldsenable = row.Field <bool>("dtlfieldsenable");
            entity.pifflenable     = row.Field <bool>("pifflenable");
            entity.origapplyamt    = row.IsNull("origapplyamt") ? decimal.Zero : row.Field <decimal>("origapplyamt");
            entity.origaretid      = row.IsNull("origaretid") ? 0 : row.Field <long>("origaretid");
            entity.origaretnffl    = row.Field <bool>("origaretnffl");
            entity.origcbinvno     = row.IsNull("origcbinvno") ? 0 : row.Field <int>("origcbinvno");
            entity.origcustno      = row.IsNull("origcustno") ? decimal.Zero : row.Field <decimal>("origcustno");
            entity.origdiscamt     = row.IsNull("origdiscamt") ? decimal.Zero : row.Field <decimal>("origdiscamt");
            entity.origduedt       = row.Field <DateTime?>("origduedt");
            entity.origdWOAmt      = row.IsNull("origdWOAmt") ? decimal.Zero : row.Field <decimal>("origdWOAmt");
            entity.originvamt      = row.IsNull("originvamt") ? decimal.Zero : row.Field <decimal>("originvamt");
            entity.originvcustno   = row.IsNull("originvcustno") ? decimal.Zero : row.Field <decimal>("originvcustno");
            entity.originvno       = row.IsNull("originvno") ? 0 : row.Field <int>("originvno");
            entity.originvsuf      = row.IsNull("originvsuf") ? 0 : row.Field <int>("originvsuf");
            entity.origlbxinvno    = row.IsNull("origlbxinvno") ? string.Empty : row.Field <string>("origlbxinvno");
            entity.origlbxamt      = row.IsNull("origlbxamt") ? decimal.Zero : row.Field <decimal>("origlbxamt");
            entity.origlRanWOFl    = row.Field <bool>("origlRanWOFl");
            entity.origoperinit    = row.IsNull("origoperinit") ? string.Empty : row.Field <string>("origoperinit");
            entity.origpiffl       = row.Field <bool>("origpiffl");
            entity.origprefix      = row.IsNull("origprefix") ? 0 : row.Field <int>("origprefix");
            entity.origrefer       = row.IsNull("origrefer") ? string.Empty : row.Field <string>("origrefer");
            entity.origseqno       = row.IsNull("origseqno") ? 0 : row.Field <int>("origseqno");
            entity.origstatfl      = row.Field <bool>("origstatfl");
            entity.origtrancd      = row.IsNull("origtrancd") ? string.Empty : row.Field <string>("origtrancd");
            entity.origtrancddesc  = row.IsNull("origtrancddesc") ? string.Empty : row.Field <string>("origtrancddesc");
            entity.userfield       = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield");
            return(entity);
        }