/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromInventorydetail(ref DataRow row, Inventorydetail entity) { row.SetField("co_num", entity.coNum); row.SetField("wh_num", entity.whNum); row.SetField("abs_num", entity.absNum); row.SetField("attributes", entity.attributes); row.SetField("bin_num", entity.binNum); row.SetField("cargo_control", entity.cargoControl); row.SetField("case_quantity", entity.caseQuantity); row.SetField("country_code", entity.countryCode); row.SetField("cross_dock_order", entity.crossDockOrder); row.SetField("cross_dock_order_suffix", entity.crossDockOrderSuffix); row.SetField("custom_data1", entity.customData1); row.SetField("custom_data2", entity.customData2); row.SetField("custom_data3", entity.customData3); row.SetField("custom_data4", entity.customData4); row.SetField("custom_data5", entity.customData5); row.SetField("cycle_emp_num", entity.cycleEmpNum); row.SetField("cycle_flag", entity.cycleFlag); row.SetField("cycle_id", entity.cycleId); row.SetField("cycle_level", entity.cycleLevel); row.SetField("date_time_rec", entity.dateTimeRec); row.SetField("emp_num", entity.empNum); row.SetField("date_expiration", entity.dateExpiration); row.SetField("id", entity.id); row.SetField("item_cost", entity.itemCost); row.SetField("item_desc", entity.itemDesc); row.SetField("lot", entity.lot); row.SetField("ns_comment", entity.nsComment); row.SetField("order", entity.order); row.SetField("order_suffix", entity.orderSuffix); row.SetField("pallet_id", entity.palletId); row.SetField("po_number", entity.poNumber); row.SetField("po_suffix", entity.poSuffix); row.SetField("reserved_qty", entity.reservedQty); row.SetField("rtn_category", entity.rtnCategory); row.SetField("rtn_pallet_full", entity.rtnPalletFull); row.SetField("stock_stat", entity.stockStat); row.SetField("suggested_bin", entity.suggestedBin); row.SetField("task_id", entity.taskId); row.SetField("total_qty", entity.totalQty); row.SetField("trans_date", entity.transDate); row.SetField("trans_proc", entity.transProc); row.SetField("trans_user", entity.transUser); row.SetField("truck_id", entity.truckId); row.SetField("uom", entity.uom); row.SetField("vendor_id", entity.vendorId); row.SetField("wh_zone", entity.whZone); row.SetField("is_trans_enabled", entity.isTransEnabled); row.SetField("is_moves_enabled", entity.isMovesEnabled); row.SetField("is_repls_enabled", entity.isReplsEnabled); row.SetField("is_picks_enabled", entity.isPicksEnabled); row.SetField("is_serial_enabled", entity.isSerialEnabled); row.SetField("itemRowID", entity.itemRowID.ToByteArray()); row.SetField("binmstRowID", entity.binmstRowID.ToByteArray()); row.SetField("inventoryRowID", entity.inventoryRowID.ToByteArray()); row.SetField("userfield", entity.userfield); }
public static Inventorydetail BuildInventorydetailFromRow(DataRow row) { Inventorydetail entity = new Inventorydetail(); 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.attributes = row.IsNull("attributes") ? string.Empty : row.Field <string>("attributes"); entity.binNum = row.IsNull("bin_num") ? string.Empty : row.Field <string>("bin_num"); entity.cargoControl = row.IsNull("cargo_control") ? string.Empty : row.Field <string>("cargo_control"); entity.caseQuantity = row.IsNull("case_quantity") ? decimal.Zero : row.Field <decimal>("case_quantity"); 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.cycleFlag = row.Field <bool>("cycle_flag"); 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.dateTimeRec = row.IsNull("date_time_rec") ? string.Empty : row.Field <string>("date_time_rec"); entity.empNum = row.IsNull("emp_num") ? string.Empty : row.Field <string>("emp_num"); entity.dateExpiration = row.Field <DateTime?>("date_expiration"); entity.id = row.IsNull("id") ? 0 : row.Field <int>("id"); entity.itemCost = row.IsNull("item_cost") ? decimal.Zero : row.Field <decimal>("item_cost"); entity.itemDesc = row.IsNull("item_desc") ? string.Empty : row.Field <string>("item_desc"); entity.lot = row.IsNull("lot") ? string.Empty : row.Field <string>("lot"); 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.palletId = row.IsNull("pallet_id") ? string.Empty : row.Field <string>("pallet_id"); 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.stockStat = row.IsNull("stock_stat") ? string.Empty : row.Field <string>("stock_stat"); 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.totalQty = row.IsNull("total_qty") ? decimal.Zero : row.Field <decimal>("total_qty"); 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.isTransEnabled = row.Field <bool>("is_trans_enabled"); entity.isMovesEnabled = row.Field <bool>("is_moves_enabled"); entity.isReplsEnabled = row.Field <bool>("is_repls_enabled"); entity.isPicksEnabled = row.Field <bool>("is_picks_enabled"); entity.isSerialEnabled = row.Field <bool>("is_serial_enabled"); 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); }