/// <summary> /// Build a minimal row from a class (key fields only) /// </summary> public static void BuildMinimalRow(ref DataRow row, OrddtlBase entity) { row.SetField("id", entity.id); row.SetField("line", entity.line); row.SetField("lineSequence", entity.lineSequence); row.SetField("orddtlRowID", entity.rowID.ToByteArray()); }
/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromOrddtlBase(ref DataRow row, OrddtlBase entity) { row.SetField("id", entity.id); row.SetField("co_num", entity.coNum); row.SetField("wh_num", entity.whNum); row.SetField("work_center", entity.workCenter); row.SetField("line", entity.line); row.SetField("line_sequence", entity.lineSequence); row.SetField("pick_line", entity.pickLine); row.SetField("abs_num", entity.absNum); row.SetField("stock_stat", entity.stockStat); row.SetField("lot", entity.lot); row.SetField("same_lot", entity.sameLot); row.SetField("serial_num", entity.serialNum); row.SetField("bin_num", entity.binNum); row.SetField("fl_zone", entity.flZone); row.SetField("ordered_qty", entity.orderedQty); row.SetField("orig_req_qty", entity.origReqQty); row.SetField("req_qty", entity.reqQty); row.SetField("act_qty", entity.actQty); row.SetField("ret_qty", entity.retQty); row.SetField("discount", entity.discount); row.SetField("tax", entity.tax); row.SetField("charges", entity.charges); row.SetField("comment", entity.comment); row.SetField("assigned", entity.assigned); row.SetField("msds_required", entity.msdsRequired); row.SetField("msds_packed", entity.msdsPacked); row.SetField("msds_employee", entity.msdsEmployee); row.SetField("msds_sheet", entity.msdsSheet); row.SetField("order_alt_num", entity.orderAltNum); row.SetField("order_alt_suf", entity.orderAltSuf); row.SetField("line_alt_number", entity.lineAltNumber); row.SetField("orig_weight", entity.origWeight); row.SetField("drop_weight", entity.dropWeight); row.SetField("ship_weight", entity.shipWeight); row.SetField("orig_cube", entity.origCube); row.SetField("drop_cube", entity.dropCube); row.SetField("ship_cube", entity.shipCube); row.SetField("rt_num", entity.rtNum); row.SetField("vendor_id", entity.vendorId); row.SetField("po_number", entity.poNumber); row.SetField("po_suffix", entity.poSuffix); row.SetField("po_line", entity.poLine); row.SetField("po_line_sequence", entity.poLineSequence); row.SetField("package_code", entity.packageCode); 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("line_status", entity.lineStatus); row.SetField("sale_uom", entity.saleUom); row.SetField("sale_uom_conv", entity.saleUomConv); row.SetField("kit_required", entity.kitRequired); row.SetField("trans_user", entity.transUser); row.SetField("trans_date", entity.transDate); row.SetField("trans_proc", entity.transProc); row.SetField("wlpicktype", entity.wlpicktype); row.SetField("origvaseqno", entity.origvaseqno); row.SetField("origvalineno", entity.origvalineno); row.SetField("lostbusty", entity.lostbusty); row.SetField("altwhse", entity.altwhse); row.SetField("shipcompfl", entity.shipcompfl); row.SetField("orddtlRowID", entity.rowID.ToByteArray()); }