Beispiel #1
0
 /// <summary>
 /// Update a database row from a class
 /// </summary>
 public static void UpdateRowFromGlifdetailbrowserresults(ref DataRow row, Glifdetailbrowserresults entity)
 {
     row.SetField("yr", entity.yr);
     row.SetField("columnno", entity.columnno);
     row.SetField("glno", entity.glno);
     row.SetField("notesfl", entity.notesfl);
     row.SetField("glsarid", entity.glsarid.ToByteArray());
     row.SetField("lookupnm", entity.lookupnm);
     row.SetField("ptd", entity.ptd);
     row.SetField("bptd", entity.bptd);
     row.SetField("ptdpctchg", entity.ptdpctchg);
     row.SetField("ptdpctbdgt", entity.ptdpctbdgt);
     row.SetField("ptdpctcomp", entity.ptdpctcomp);
     row.SetField("ytd", entity.ytd);
     row.SetField("bytd", entity.bytd);
     row.SetField("ytdpctchg", entity.ytdpctchg);
     row.SetField("ytdpctbdgt", entity.ytdpctbdgt);
     row.SetField("ytdpctcomp", entity.ytdpctcomp);
     row.SetField("baltype", entity.baltype);
     row.SetField("accttype", entity.accttype);
 }
Beispiel #2
0
        public static Glifdetailbrowserresults BuildGlifdetailbrowserresultsFromRow(DataRow row)
        {
            Glifdetailbrowserresults entity = new Glifdetailbrowserresults();

            entity.yr         = row.IsNull("yr") ? 0 : row.Field <int>("yr");
            entity.columnno   = row.IsNull("columnno") ? 0 : row.Field <int>("columnno");
            entity.glno       = row.IsNull("glno") ? string.Empty : row.Field <string>("glno");
            entity.notesfl    = row.IsNull("notesfl") ? string.Empty : row.Field <string>("notesfl");
            entity.glsarid    = row.Field <byte[]>("glsarid").ToStringEncoded();
            entity.lookupnm   = row.IsNull("lookupnm") ? string.Empty : row.Field <string>("lookupnm");
            entity.ptd        = row.IsNull("ptd") ? decimal.Zero : row.Field <decimal>("ptd");
            entity.bptd       = row.IsNull("bptd") ? decimal.Zero : row.Field <decimal>("bptd");
            entity.ptdpctchg  = row.IsNull("ptdpctchg") ? decimal.Zero : row.Field <decimal>("ptdpctchg");
            entity.ptdpctbdgt = row.IsNull("ptdpctbdgt") ? decimal.Zero : row.Field <decimal>("ptdpctbdgt");
            entity.ptdpctcomp = row.IsNull("ptdpctcomp") ? decimal.Zero : row.Field <decimal>("ptdpctcomp");
            entity.ytd        = row.IsNull("ytd") ? decimal.Zero : row.Field <decimal>("ytd");
            entity.bytd       = row.IsNull("bytd") ? decimal.Zero : row.Field <decimal>("bytd");
            entity.ytdpctchg  = row.IsNull("ytdpctchg") ? decimal.Zero : row.Field <decimal>("ytdpctchg");
            entity.ytdpctbdgt = row.IsNull("ytdpctbdgt") ? decimal.Zero : row.Field <decimal>("ytdpctbdgt");
            entity.ytdpctcomp = row.IsNull("ytdpctcomp") ? decimal.Zero : row.Field <decimal>("ytdpctcomp");
            entity.baltype    = row.Field <bool>("baltype");
            entity.accttype   = row.IsNull("accttype") ? string.Empty : row.Field <string>("accttype");
            return(entity);
        }