public static Inventorylistresults BuildInventorylistresultsFromRow(DataRow row) { Inventorylistresults entity = new Inventorylistresults(); entity.coNum = row.IsNull("co_num") ? string.Empty : row.Field <string>("co_num"); entity.whNum = row.IsNull("wh_num") ? string.Empty : row.Field <string>("wh_num"); entity.absNum = row.IsNull("abs_num") ? string.Empty : row.Field <string>("abs_num"); entity.totalQty = row.IsNull("total_qty") ? decimal.Zero : row.Field <decimal>("total_qty"); entity.binNum = row.IsNull("bin_num") ? string.Empty : row.Field <string>("bin_num"); entity.palletId = row.IsNull("pallet_id") ? string.Empty : row.Field <string>("pallet_id"); entity.stockStat = row.IsNull("stock_stat") ? string.Empty : row.Field <string>("stock_stat"); entity.dateTime = row.IsNull("date_time") ? string.Empty : row.Field <string>("date_time"); entity.lot = row.IsNull("lot") ? string.Empty : row.Field <string>("lot"); entity.expiration = row.Field <DateTime?>("expiration"); entity.caseQuantity = row.IsNull("case_quantity") ? decimal.Zero : row.Field <decimal>("case_quantity"); entity.cycleFlag = row.Field <bool>("cycle_flag"); entity.descrip = row.IsNull("descrip") ? string.Empty : row.Field <string>("descrip"); entity.descrip2 = row.IsNull("descrip2") ? string.Empty : row.Field <string>("descrip2"); entity.attributes = row.IsNull("attributes") ? string.Empty : row.Field <string>("attributes"); entity.cargoControl = row.IsNull("cargo_control") ? string.Empty : row.Field <string>("cargo_control"); entity.countryCode = row.IsNull("country_code") ? string.Empty : row.Field <string>("country_code"); entity.crossDockOrder = row.IsNull("cross_dock_order") ? string.Empty : row.Field <string>("cross_dock_order"); entity.crossDockOrderSuffix = row.IsNull("cross_dock_order_suffix") ? string.Empty : row.Field <string>("cross_dock_order_suffix"); entity.customData1 = row.IsNull("custom_data1") ? string.Empty : row.Field <string>("custom_data1"); entity.customData2 = row.IsNull("custom_data2") ? string.Empty : row.Field <string>("custom_data2"); entity.customData3 = row.IsNull("custom_data3") ? string.Empty : row.Field <string>("custom_data3"); entity.customData4 = row.IsNull("custom_data4") ? string.Empty : row.Field <string>("custom_data4"); entity.customData5 = row.IsNull("custom_data5") ? string.Empty : row.Field <string>("custom_data5"); entity.cycleEmpNum = row.IsNull("cycle_emp_num") ? string.Empty : row.Field <string>("cycle_emp_num"); entity.cycleId = row.IsNull("cycle_id") ? 0 : row.Field <int>("cycle_id"); entity.cycleLevel = row.IsNull("cycle_level") ? string.Empty : row.Field <string>("cycle_level"); entity.empNum = row.IsNull("emp_num") ? string.Empty : row.Field <string>("emp_num"); entity.id = row.IsNull("id") ? 0 : row.Field <int>("id"); entity.nsComment = row.IsNull("ns_comment") ? string.Empty : row.Field <string>("ns_comment"); entity.order = row.IsNull("order") ? string.Empty : row.Field <string>("order"); entity.orderSuffix = row.IsNull("order_suffix") ? string.Empty : row.Field <string>("order_suffix"); entity.poNumber = row.IsNull("po_number") ? string.Empty : row.Field <string>("po_number"); entity.poSuffix = row.IsNull("po_suffix") ? string.Empty : row.Field <string>("po_suffix"); entity.reservedQty = row.IsNull("reserved_qty") ? decimal.Zero : row.Field <decimal>("reserved_qty"); entity.rtnCategory = row.IsNull("rtn_category") ? string.Empty : row.Field <string>("rtn_category"); entity.rtnPalletFull = row.Field <bool>("rtn_pallet_full"); entity.suggestedBin = row.IsNull("suggested_bin") ? string.Empty : row.Field <string>("suggested_bin"); entity.taskId = row.IsNull("task_id") ? 0 : row.Field <int>("task_id"); entity.transDate = row.IsNull("trans_date") ? string.Empty : row.Field <string>("trans_date"); entity.transProc = row.IsNull("trans_proc") ? string.Empty : row.Field <string>("trans_proc"); entity.transUser = row.IsNull("trans_user") ? string.Empty : row.Field <string>("trans_user"); entity.truckId = row.IsNull("truck_id") ? string.Empty : row.Field <string>("truck_id"); entity.uom = row.IsNull("uom") ? string.Empty : row.Field <string>("uom"); entity.vendorId = row.IsNull("vendor_id") ? string.Empty : row.Field <string>("vendor_id"); entity.whZone = row.IsNull("wh_zone") ? string.Empty : row.Field <string>("wh_zone"); entity.reserved = row.IsNull("reserved") ? decimal.Zero : row.Field <decimal>("reserved"); entity.availQty = row.IsNull("avail_qty") ? decimal.Zero : row.Field <decimal>("avail_qty"); entity.itemRowID = row.Field <byte[]>("itemRowID").ToStringEncoded(); entity.binmstRowID = row.Field <byte[]>("binmstRowID").ToStringEncoded(); entity.inventoryRowID = row.Field <byte[]>("inventoryRowID").ToStringEncoded(); entity.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield"); return(entity); }