public static Coreallocationresults BuildCoreallocationresultsFromRow(DataRow row) { Coreallocationresults entity = new Coreallocationresults(); entity.invoicefl = row.Field <bool>("invoicefl"); entity.shipdt = row.Field <DateTime?>("shipdt"); 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.coreduedt = row.Field <DateTime?>("coreduedt"); entity.qty = row.IsNull("qty") ? decimal.Zero : row.Field <decimal>("qty"); entity.qtyalloc = row.IsNull("qtyalloc") ? decimal.Zero : row.Field <decimal>("qtyalloc"); entity.oldalloc = row.IsNull("oldalloc") ? decimal.Zero : row.Field <decimal>("oldalloc"); entity.modifyfl = row.Field <bool>("modifyfl"); entity.whse = row.IsNull("whse") ? string.Empty : row.Field <string>("whse"); entity.prod = row.IsNull("prod") ? string.Empty : row.Field <string>("prod"); entity.custno = row.IsNull("custno") ? decimal.Zero : row.Field <decimal>("custno"); entity.shipto = row.IsNull("shipto") ? string.Empty : row.Field <string>("shipto"); entity.pricetype = row.IsNull("pricetype") ? string.Empty : row.Field <string>("pricetype"); entity.vendno = row.IsNull("vendno") ? decimal.Zero : row.Field <decimal>("vendno"); entity.custtype = row.IsNull("custtype") ? string.Empty : row.Field <string>("custtype"); entity.recno = row.IsNull("recno") ? 0 : row.Field <int>("recno"); entity.stagecd = row.IsNull("stagecd") ? 0 : row.Field <int>("stagecd"); 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 UpdateRowFromCoreallocationresults(ref DataRow row, Coreallocationresults entity) { row.SetField("invoicefl", entity.invoicefl); row.SetField("shipdt", entity.shipdt); row.SetField("orderno", entity.orderno); row.SetField("ordersuf", entity.ordersuf); row.SetField("lineno", entity.lineno); row.SetField("coreduedt", entity.coreduedt); row.SetField("qty", entity.qty); row.SetField("qtyalloc", entity.qtyalloc); row.SetField("oldalloc", entity.oldalloc); row.SetField("modifyfl", entity.modifyfl); row.SetField("whse", entity.whse); row.SetField("prod", entity.prod); row.SetField("custno", entity.custno); row.SetField("shipto", entity.shipto); row.SetField("pricetype", entity.pricetype); row.SetField("vendno", entity.vendno); row.SetField("custtype", entity.custtype); row.SetField("recno", entity.recno); row.SetField("stagecd", entity.stagecd); row.SetField("userfield", entity.userfield); }