public static Icwarehouseglfetchresults BuildIcwarehouseglfetchresultsFromRow(DataRow row) { Icwarehouseglfetchresults entity = new Icwarehouseglfetchresults(); entity.whse = row.IsNull("whse") ? string.Empty : row.Field <string>("whse"); entity.icaddonexpglacct = row.IsNull("icaddonexpglacct") ? string.Empty : row.Field <string>("icaddonexpglacct"); entity.icaddonexpglacctdesc = row.IsNull("icaddonexpglacctdesc") ? string.Empty : row.Field <string>("icaddonexpglacctdesc"); entity.icaddonrevglacct = row.IsNull("icaddonrevglacct") ? string.Empty : row.Field <string>("icaddonrevglacct"); entity.icaddonrevglacctdesc = row.IsNull("icaddonrevglacctdesc") ? string.Empty : row.Field <string>("icaddonrevglacctdesc"); entity.icinvintransitglacct = row.IsNull("icinvintransitglacct") ? string.Empty : row.Field <string>("icinvintransitglacct"); entity.icinvintransitglacctdesc = row.IsNull("icinvintransitglacctdesc") ? string.Empty : row.Field <string>("icinvintransitglacctdesc"); entity.icaddonintransitglacct = row.IsNull("icaddonintransitglacct") ? string.Empty : row.Field <string>("icaddonintransitglacct"); entity.icaddonintransitglacctdesc = row.IsNull("icaddonintransitglacctdesc") ? string.Empty : row.Field <string>("icaddonintransitglacctdesc"); entity.icinterdivisionalglacct = row.IsNull("icinterdivisionalglacct") ? string.Empty : row.Field <string>("icinterdivisionalglacct"); entity.icinterdivisionalglacctdesc = row.IsNull("icinterdivisionalglacctdesc") ? string.Empty : row.Field <string>("icinterdivisionalglacctdesc"); 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.rowidIcsd = row.Field <byte[]>("rowid-icsd").ToStringEncoded(); return(entity); }
/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromIcwarehouseglfetchresults(ref DataRow row, Icwarehouseglfetchresults entity) { row.SetField("whse", entity.whse); row.SetField("icaddonexpglacct", entity.icaddonexpglacct); row.SetField("icaddonexpglacctdesc", entity.icaddonexpglacctdesc); row.SetField("icaddonrevglacct", entity.icaddonrevglacct); row.SetField("icaddonrevglacctdesc", entity.icaddonrevglacctdesc); row.SetField("icinvintransitglacct", entity.icinvintransitglacct); row.SetField("icinvintransitglacctdesc", entity.icinvintransitglacctdesc); row.SetField("icaddonintransitglacct", entity.icaddonintransitglacct); row.SetField("icaddonintransitglacctdesc", entity.icaddonintransitglacctdesc); row.SetField("icinterdivisionalglacct", entity.icinterdivisionalglacct); row.SetField("icinterdivisionalglacctdesc", entity.icinterdivisionalglacctdesc); 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("rowid-icsd", entity.rowidIcsd.ToByteArray()); }