/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromGlsfsetups(ref DataRow row, Glsfsetups entity) { row.SetField("conoSelect", entity.conoSelect); row.SetField("conoSummary", entity.conoSummary); row.SetField("conoFrom", entity.conoFrom); row.SetField("conoTo", entity.conoTo); row.SetField("divnoSelect", entity.divnoSelect); row.SetField("divnoSummary", entity.divnoSummary); row.SetField("divnoFrom", entity.divnoFrom); row.SetField("divnoTo", entity.divnoTo); row.SetField("deptnoSelect", entity.deptnoSelect); row.SetField("deptnoSummary", entity.deptnoSummary); row.SetField("deptnoFrom", entity.deptnoFrom); row.SetField("deptnoTo", entity.deptnoTo); row.SetField("subnoSummary", entity.subnoSummary); row.SetField("sortOrder", entity.sortOrder); row.SetField("comment", entity.comment); row.SetField("userfield", entity.userfield); }
public static Glsfsetups BuildGlsfsetupsFromRow(DataRow row) { Glsfsetups entity = new Glsfsetups(); entity.conoSelect = row.IsNull("conoSelect") ? string.Empty : row.Field <string>("conoSelect"); entity.conoSummary = row.IsNull("conoSummary") ? string.Empty : row.Field <string>("conoSummary"); entity.conoFrom = row.IsNull("conoFrom") ? 0 : row.Field <int>("conoFrom"); entity.conoTo = row.IsNull("conoTo") ? 0 : row.Field <int>("conoTo"); entity.divnoSelect = row.IsNull("divnoSelect") ? string.Empty : row.Field <string>("divnoSelect"); entity.divnoSummary = row.IsNull("divnoSummary") ? string.Empty : row.Field <string>("divnoSummary"); entity.divnoFrom = row.IsNull("divnoFrom") ? 0 : row.Field <int>("divnoFrom"); entity.divnoTo = row.IsNull("divnoTo") ? 0 : row.Field <int>("divnoTo"); entity.deptnoSelect = row.IsNull("deptnoSelect") ? string.Empty : row.Field <string>("deptnoSelect"); entity.deptnoSummary = row.IsNull("deptnoSummary") ? string.Empty : row.Field <string>("deptnoSummary"); entity.deptnoFrom = row.IsNull("deptnoFrom") ? 0 : row.Field <int>("deptnoFrom"); entity.deptnoTo = row.IsNull("deptnoTo") ? 0 : row.Field <int>("deptnoTo"); entity.subnoSummary = row.IsNull("subnoSummary") ? string.Empty : row.Field <string>("subnoSummary"); entity.sortOrder = row.IsNull("sortOrder") ? 0 : row.Field <int>("sortOrder"); entity.comment = row.IsNull("comment") ? string.Empty : row.Field <string>("comment"); entity.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield"); return(entity); }