/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromGeocodelookupcriteria(ref DataRow row, Geocodelookupcriteria entity) { row.SetField("tablename", entity.tablename); row.SetField("custno", entity.custno); row.SetField("shipto", entity.shipto); row.SetField("groupnm", entity.groupnm); row.SetField("vendno", entity.vendno); row.SetField("shipfmno", entity.shipfmno); row.SetField("slsrep", entity.slsrep); row.SetField("groupid", entity.groupid); row.SetField("whse", entity.whse); row.SetField("orderno", entity.orderno); row.SetField("ordersuf", entity.ordersuf); row.SetField("pono", entity.pono); row.SetField("posuf", entity.posuf); row.SetField("reportno", entity.reportno); row.SetField("sasccono", entity.sasccono); row.SetField("city", entity.city); row.SetField("country", entity.country); row.SetField("outofcityfl", entity.outofcityfl); row.SetField("state", entity.state); row.SetField("streetaddr", entity.streetaddr); row.SetField("zipcd", entity.zipcd); row.SetField("geocd", entity.geocd); }
public static Geocodelookupcriteria BuildGeocodelookupcriteriaFromRow(DataRow row) { Geocodelookupcriteria entity = new Geocodelookupcriteria(); entity.tablename = row.IsNull("tablename") ? string.Empty : row.Field <string>("tablename"); entity.custno = row.IsNull("custno") ? decimal.Zero : row.Field <decimal>("custno"); entity.shipto = row.IsNull("shipto") ? string.Empty : row.Field <string>("shipto"); entity.groupnm = row.IsNull("groupnm") ? string.Empty : row.Field <string>("groupnm"); entity.vendno = row.IsNull("vendno") ? decimal.Zero : row.Field <decimal>("vendno"); entity.shipfmno = row.IsNull("shipfmno") ? 0 : row.Field <int>("shipfmno"); entity.slsrep = row.IsNull("slsrep") ? string.Empty : row.Field <string>("slsrep"); entity.groupid = row.IsNull("groupid") ? string.Empty : row.Field <string>("groupid"); entity.whse = row.IsNull("whse") ? string.Empty : row.Field <string>("whse"); entity.orderno = row.IsNull("orderno") ? 0 : row.Field <int>("orderno"); entity.ordersuf = row.IsNull("ordersuf") ? 0 : row.Field <int>("ordersuf"); entity.pono = row.IsNull("pono") ? 0 : row.Field <int>("pono"); entity.posuf = row.IsNull("posuf") ? 0 : row.Field <int>("posuf"); entity.reportno = row.IsNull("reportno") ? 0 : row.Field <int>("reportno"); entity.sasccono = row.IsNull("sasccono") ? 0 : row.Field <int>("sasccono"); entity.city = row.IsNull("city") ? string.Empty : row.Field <string>("city"); entity.country = row.IsNull("country") ? string.Empty : row.Field <string>("country"); entity.outofcityfl = row.Field <bool>("outofcityfl"); entity.state = row.IsNull("state") ? string.Empty : row.Field <string>("state"); entity.streetaddr = row.IsNull("streetaddr") ? string.Empty : row.Field <string>("streetaddr"); entity.zipcd = row.IsNull("zipcd") ? string.Empty : row.Field <string>("zipcd"); entity.geocd = row.IsNull("geocd") ? 0 : row.Field <int>("geocd"); return(entity); }