/// <summary> /// Build a minimal row from a class (key fields only) /// </summary> public static void BuildMinimalRow(ref DataRow row, BinmstBase entity) { row.SetField("coNum", entity.coNum); row.SetField("whNum", entity.whNum); row.SetField("binNum", entity.binNum); row.SetField("binmstRowID", entity.rowID.ToByteArray()); }
/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromBinmstBase(ref DataRow row, BinmstBase entity) { row.SetField("co_num", entity.coNum); row.SetField("wh_num", entity.whNum); row.SetField("bin_num", entity.binNum); row.SetField("wh_zone", entity.whZone); row.SetField("aisle", entity.aisle); row.SetField("loc_type", entity.locType); row.SetField("prim_pick", entity.primPick); row.SetField("prim_pick_type", entity.primPickType); row.SetField("abs_num", entity.absNum); row.SetField("min_lvl", entity.minLvl); row.SetField("max_lvl", entity.maxLvl); row.SetField("rep_qty", entity.repQty); row.SetField("rep_unit", entity.repUnit); row.SetField("max_pal", entity.maxPal); row.SetField("max_weight", entity.maxWeight); row.SetField("height", entity.height); row.SetField("width", entity.width); row.SetField("depth", entity.depth); row.SetField("cube", entity.cube); row.SetField("pallet_footprint", entity.palletFootprint); row.SetField("stack_height", entity.stackHeight); row.SetField("bin_hits", entity.binHits); row.SetField("inboundstgfl", entity.inboundstgfl); row.SetField("physical", entity.physical); row.SetField("abc", entity.abc); row.SetField("check_qty", entity.checkQty); row.SetField("last_count", entity.lastCount); 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("row_status", entity.rowStatus); row.SetField("cycle_flag", entity.cycleFlag); row.SetField("pick_sequence", entity.pickSequence); row.SetField("trans_user", entity.transUser); row.SetField("abc_pending", entity.abcPending); row.SetField("trans_date", entity.transDate); row.SetField("trans_proc", entity.transProc); row.SetField("putaway_group", entity.putawayGroup); row.SetField("binmstRowID", entity.rowID.ToByteArray()); }