예제 #1
0
 /// <summary>
 /// Update a database row from a class
 /// </summary>
 public static void UpdateRowFromGlacctloaddataresults(ref DataRow row, Glacctloaddataresults entity)
 {
     row.SetField("period1", entity.period1);
     row.SetField("period2", entity.period2);
     row.SetField("period3", entity.period3);
     row.SetField("period4", entity.period4);
     row.SetField("period5", entity.period5);
     row.SetField("period6", entity.period6);
     row.SetField("period7", entity.period7);
     row.SetField("period8", entity.period8);
     row.SetField("period9", entity.period9);
     row.SetField("period10", entity.period10);
     row.SetField("period11", entity.period11);
     row.SetField("period12", entity.period12);
     row.SetField("period13", entity.period13);
     row.SetField("ptd1", entity.ptd1);
     row.SetField("ptd2", entity.ptd2);
     row.SetField("ptd3", entity.ptd3);
     row.SetField("ptd4", entity.ptd4);
     row.SetField("ptd5", entity.ptd5);
     row.SetField("ptd6", entity.ptd6);
     row.SetField("ptd7", entity.ptd7);
     row.SetField("ptd8", entity.ptd8);
     row.SetField("ptd9", entity.ptd9);
     row.SetField("ptd10", entity.ptd10);
     row.SetField("ptd11", entity.ptd11);
     row.SetField("ptd12", entity.ptd12);
     row.SetField("ptd13", entity.ptd13);
     row.SetField("ytd1", entity.ytd1);
     row.SetField("ytd2", entity.ytd2);
     row.SetField("ytd3", entity.ytd3);
     row.SetField("ytd4", entity.ytd4);
     row.SetField("ytd5", entity.ytd5);
     row.SetField("ytd6", entity.ytd6);
     row.SetField("ytd7", entity.ytd7);
     row.SetField("ytd8", entity.ytd8);
     row.SetField("ytd9", entity.ytd9);
     row.SetField("ytd10", entity.ytd10);
     row.SetField("ytd11", entity.ytd11);
     row.SetField("ytd12", entity.ytd12);
     row.SetField("ytd13", entity.ytd13);
     row.SetField("fwdbal", entity.fwdbal);
     row.SetField("actty", entity.actty);
     row.SetField("balty", entity.balty);
     row.SetField("prtty", entity.prtty);
     row.SetField("label1", entity.label1);
     row.SetField("label2", entity.label2);
     row.SetField("rptgrp", entity.rptgrp);
     row.SetField("l13per", entity.l13per);
     row.SetField("glcono", entity.glcono);
     row.SetField("glyr", entity.glyr);
     row.SetField("glyear", entity.glyear);
     row.SetField("glno", entity.glno);
     row.SetField("glacctno", entity.glacctno);
     row.SetField("gldeptno", entity.gldeptno);
     row.SetField("gldivno", entity.gldivno);
     row.SetField("glsubno", entity.glsubno);
     row.SetField("notesfl", entity.notesfl);
     row.SetField("lookupnm", entity.lookupnm);
     row.SetField("gltitle", entity.gltitle);
     row.SetField("rowid-glsa", entity.rowidGlsa.ToByteArray());
     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("userfield", entity.userfield);
 }
예제 #2
0
        public static Glacctloaddataresults BuildGlacctloaddataresultsFromRow(DataRow row)
        {
            Glacctloaddataresults entity = new Glacctloaddataresults();

            entity.period1   = row.IsNull("period1") ? string.Empty : row.Field <string>("period1");
            entity.period2   = row.IsNull("period2") ? string.Empty : row.Field <string>("period2");
            entity.period3   = row.IsNull("period3") ? string.Empty : row.Field <string>("period3");
            entity.period4   = row.IsNull("period4") ? string.Empty : row.Field <string>("period4");
            entity.period5   = row.IsNull("period5") ? string.Empty : row.Field <string>("period5");
            entity.period6   = row.IsNull("period6") ? string.Empty : row.Field <string>("period6");
            entity.period7   = row.IsNull("period7") ? string.Empty : row.Field <string>("period7");
            entity.period8   = row.IsNull("period8") ? string.Empty : row.Field <string>("period8");
            entity.period9   = row.IsNull("period9") ? string.Empty : row.Field <string>("period9");
            entity.period10  = row.IsNull("period10") ? string.Empty : row.Field <string>("period10");
            entity.period11  = row.IsNull("period11") ? string.Empty : row.Field <string>("period11");
            entity.period12  = row.IsNull("period12") ? string.Empty : row.Field <string>("period12");
            entity.period13  = row.IsNull("period13") ? string.Empty : row.Field <string>("period13");
            entity.ptd1      = row.IsNull("ptd1") ? decimal.Zero : row.Field <decimal>("ptd1");
            entity.ptd2      = row.IsNull("ptd2") ? decimal.Zero : row.Field <decimal>("ptd2");
            entity.ptd3      = row.IsNull("ptd3") ? decimal.Zero : row.Field <decimal>("ptd3");
            entity.ptd4      = row.IsNull("ptd4") ? decimal.Zero : row.Field <decimal>("ptd4");
            entity.ptd5      = row.IsNull("ptd5") ? decimal.Zero : row.Field <decimal>("ptd5");
            entity.ptd6      = row.IsNull("ptd6") ? decimal.Zero : row.Field <decimal>("ptd6");
            entity.ptd7      = row.IsNull("ptd7") ? decimal.Zero : row.Field <decimal>("ptd7");
            entity.ptd8      = row.IsNull("ptd8") ? decimal.Zero : row.Field <decimal>("ptd8");
            entity.ptd9      = row.IsNull("ptd9") ? decimal.Zero : row.Field <decimal>("ptd9");
            entity.ptd10     = row.IsNull("ptd10") ? decimal.Zero : row.Field <decimal>("ptd10");
            entity.ptd11     = row.IsNull("ptd11") ? decimal.Zero : row.Field <decimal>("ptd11");
            entity.ptd12     = row.IsNull("ptd12") ? decimal.Zero : row.Field <decimal>("ptd12");
            entity.ptd13     = row.IsNull("ptd13") ? decimal.Zero : row.Field <decimal>("ptd13");
            entity.ytd1      = row.IsNull("ytd1") ? decimal.Zero : row.Field <decimal>("ytd1");
            entity.ytd2      = row.IsNull("ytd2") ? decimal.Zero : row.Field <decimal>("ytd2");
            entity.ytd3      = row.IsNull("ytd3") ? decimal.Zero : row.Field <decimal>("ytd3");
            entity.ytd4      = row.IsNull("ytd4") ? decimal.Zero : row.Field <decimal>("ytd4");
            entity.ytd5      = row.IsNull("ytd5") ? decimal.Zero : row.Field <decimal>("ytd5");
            entity.ytd6      = row.IsNull("ytd6") ? decimal.Zero : row.Field <decimal>("ytd6");
            entity.ytd7      = row.IsNull("ytd7") ? decimal.Zero : row.Field <decimal>("ytd7");
            entity.ytd8      = row.IsNull("ytd8") ? decimal.Zero : row.Field <decimal>("ytd8");
            entity.ytd9      = row.IsNull("ytd9") ? decimal.Zero : row.Field <decimal>("ytd9");
            entity.ytd10     = row.IsNull("ytd10") ? decimal.Zero : row.Field <decimal>("ytd10");
            entity.ytd11     = row.IsNull("ytd11") ? decimal.Zero : row.Field <decimal>("ytd11");
            entity.ytd12     = row.IsNull("ytd12") ? decimal.Zero : row.Field <decimal>("ytd12");
            entity.ytd13     = row.IsNull("ytd13") ? decimal.Zero : row.Field <decimal>("ytd13");
            entity.fwdbal    = row.IsNull("fwdbal") ? decimal.Zero : row.Field <decimal>("fwdbal");
            entity.actty     = row.IsNull("actty") ? string.Empty : row.Field <string>("actty");
            entity.balty     = row.Field <bool>("balty");
            entity.prtty     = row.Field <bool>("prtty");
            entity.label1    = row.IsNull("label1") ? string.Empty : row.Field <string>("label1");
            entity.label2    = row.IsNull("label2") ? string.Empty : row.Field <string>("label2");
            entity.rptgrp    = row.IsNull("rptgrp") ? string.Empty : row.Field <string>("rptgrp");
            entity.l13per    = row.Field <bool>("l13per");
            entity.glcono    = row.IsNull("glcono") ? 0 : row.Field <int>("glcono");
            entity.glyr      = row.IsNull("glyr") ? 0 : row.Field <int>("glyr");
            entity.glyear    = row.IsNull("glyear") ? 0 : row.Field <int>("glyear");
            entity.glno      = row.IsNull("glno") ? string.Empty : row.Field <string>("glno");
            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.notesfl   = row.IsNull("notesfl") ? string.Empty : row.Field <string>("notesfl");
            entity.lookupnm  = row.IsNull("lookupnm") ? string.Empty : row.Field <string>("lookupnm");
            entity.gltitle   = row.IsNull("gltitle") ? string.Empty : row.Field <string>("gltitle");
            entity.rowidGlsa = row.Field <byte[]>("rowid-glsa").ToStringEncoded();
            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.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield");
            return(entity);
        }