/// <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);
}
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);
}
