예제 #1
0
        public static Ariltransresults BuildAriltransresultsFromRow(DataRow row)
        {
            Ariltransresults entity = new Ariltransresults();

            entity.fibatch          = row.IsNull("fibatch") ? string.Empty : row.Field <string>("fibatch");
            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.writeoffsenabled = row.Field <bool>("writeoffsenabled");
            entity.custnotes        = row.IsNull("custnotes") ? string.Empty : row.Field <string>("custnotes");
            entity.userfield        = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield");
            return(entity);
        }
예제 #2
0
 /// <summary>
 /// Update a database row from a class
 /// </summary>
 public static void UpdateRowFromAriltransresults(ref DataRow row, Ariltransresults entity)
 {
     row.SetField("fibatch", entity.fibatch);
     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("writeoffsenabled", entity.writeoffsenabled);
     row.SetField("custnotes", entity.custnotes);
     row.SetField("userfield", entity.userfield);
 }