public static Varollcstprccriteria BuildVarollcstprccriteriaFromRow(DataRow row) { Varollcstprccriteria entity = new Varollcstprccriteria(); entity.ourproc = row.IsNull("ourproc") ? string.Empty : row.Field <string>("ourproc"); entity.orderno = row.IsNull("orderno") ? 0 : row.Field <int>("orderno"); entity.ordersuf = row.IsNull("ordersuf") ? 0 : row.Field <int>("ordersuf"); entity.lineno = row.IsNull("lineno") ? 0 : row.Field <int>("lineno"); entity.prod = row.IsNull("prod") ? string.Empty : row.Field <string>("prod"); entity.whse = row.IsNull("whse") ? string.Empty : row.Field <string>("whse"); entity.qty = row.IsNull("qty") ? decimal.Zero : row.Field <decimal>("qty"); entity.unit = row.IsNull("unit") ? string.Empty : row.Field <string>("unit"); entity.custno = row.IsNull("custno") ? decimal.Zero : row.Field <decimal>("custno"); entity.shipto = row.IsNull("shipto") ? string.Empty : row.Field <string>("shipto"); entity.varollfl = row.Field <bool>("varollfl"); entity.vamarkupfl = row.Field <bool>("vamarkupfl"); entity.vaintmarkup = row.IsNull("vaintmarkup") ? decimal.Zero : row.Field <decimal>("vaintmarkup"); entity.vaextmarkup = row.IsNull("vaextmarkup") ? decimal.Zero : row.Field <decimal>("vaextmarkup"); entity.vanonstkmarkup = row.IsNull("vanonstkmarkup") ? decimal.Zero : row.Field <decimal>("vanonstkmarkup"); entity.vacalcdfltty = row.IsNull("vacalcdfltty") ? string.Empty : row.Field <string>("vacalcdfltty"); entity.vainvmarkupfl = row.Field <bool>("vainvmarkupfl"); entity.vainvmarkup = row.IsNull("vainvmarkup") ? decimal.Zero : row.Field <decimal>("vainvmarkup"); entity.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield"); return(entity); }
/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromVarollcstprccriteria(ref DataRow row, Varollcstprccriteria entity) { row.SetField("ourproc", entity.ourproc); row.SetField("orderno", entity.orderno); row.SetField("ordersuf", entity.ordersuf); row.SetField("lineno", entity.lineno); row.SetField("prod", entity.prod); row.SetField("whse", entity.whse); row.SetField("qty", entity.qty); row.SetField("unit", entity.unit); row.SetField("custno", entity.custno); row.SetField("shipto", entity.shipto); row.SetField("varollfl", entity.varollfl); row.SetField("vamarkupfl", entity.vamarkupfl); row.SetField("vaintmarkup", entity.vaintmarkup); row.SetField("vaextmarkup", entity.vaextmarkup); row.SetField("vanonstkmarkup", entity.vanonstkmarkup); row.SetField("vacalcdfltty", entity.vacalcdfltty); row.SetField("vainvmarkupfl", entity.vainvmarkupfl); row.SetField("vainvmarkup", entity.vainvmarkup); row.SetField("userfield", entity.userfield); }