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