/// <summary> /// Build a minimal row from a class (key fields only) /// </summary> public static void BuildMinimalRow(ref DataRow row, TransactionsBase entity) { row.SetField("transactionsRowID", entity.rowID.ToByteArray()); }
/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromTransactionsBase(ref DataRow row, TransactionsBase entity) { row.SetField("trans_num", entity.transNum); row.SetField("transmission", entity.transmission); row.SetField("memo", entity.memo); row.SetField("co_num", entity.coNum); row.SetField("wh_num", entity.whNum); row.SetField("task_id", entity.taskId); row.SetField("pallet_id", entity.palletId); row.SetField("pallet_id_from", entity.palletIdFrom); row.SetField("carton_id", entity.cartonId); row.SetField("date_time", entity.dateTime); row.SetField("trans_sec_time", entity.transSecTime); row.SetField("trans_type", entity.transType); row.SetField("emp_num", entity.empNum); row.SetField("abs_num", entity.absNum); row.SetField("ns_comment", entity.nsComment); row.SetField("exp_abs", entity.expAbs); row.SetField("serial_num", entity.serialNum); row.SetField("item_num", entity.itemNum); row.SetField("item_qty", entity.itemQty); row.SetField("sugg_qty", entity.suggQty); row.SetField("bin_num", entity.binNum); row.SetField("bin_from", entity.binFrom); row.SetField("bin_to", entity.binTo); row.SetField("cc_type", entity.ccType); row.SetField("cc_string", entity.ccString); row.SetField("shf_num", entity.shfNum); row.SetField("adj_code", entity.adjCode); row.SetField("item_type", entity.itemType); row.SetField("uom", entity.uom); row.SetField("stock_stat", entity.stockStat); row.SetField("old_stock_stat", entity.oldStockStat); row.SetField("lot", entity.lot); row.SetField("dept_num", entity.deptNum); row.SetField("mach_type", entity.machType); row.SetField("rt_num", entity.rtNum); row.SetField("po_number", entity.poNumber); row.SetField("po_suffix", entity.poSuffix); row.SetField("po_line", entity.poLine); row.SetField("line_sequence", entity.lineSequence); row.SetField("packer", entity.packer); row.SetField("action_code", entity.actionCode); row.SetField("result_code", entity.resultCode); row.SetField("result_msg", entity.resultMsg); row.SetField("trans_link", entity.transLink); row.SetField("record_type", entity.recordType); row.SetField("comments", entity.comments); row.SetField("proc_created", entity.procCreated); row.SetField("truck_id", entity.truckId); row.SetField("batch", entity.batch); row.SetField("cargo_control", entity.cargoControl); row.SetField("release_id", entity.releaseId); row.SetField("doc_id", entity.docId); 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("lot_chg_type", entity.lotChgType); row.SetField("case_quantity", entity.caseQuantity); row.SetField("cc_id", entity.ccId); row.SetField("order", entity.order); row.SetField("order_suffix", entity.orderSuffix); row.SetField("order_type", entity.orderType); row.SetField("trans_user", entity.transUser); row.SetField("trans_date", entity.transDate); row.SetField("trans_proc", entity.transProc); row.SetField("printer", entity.printer); row.SetField("lot_before", entity.lotBefore); row.SetField("transactionsRowID", entity.rowID.ToByteArray()); }