Sp_Manufacture_InsertMftPlanSlave (procedure)
生产计划从：插入计划（Sp_Manufacture_InsertMftPlan调用）
- Type: PROCEDURE
- Deterministic: NO
- SQL data access: CONTAINS SQL
Parameters
| # | Mode | Name | Type |
|---|---|---|---|
| 1 | IN | p_sMachineStyle |
varchar(255) |
| 2 | IN | p_dPlateQty |
decimal(18,6) |
| 3 | IN | p_dGiveQty |
decimal(18,6) |
| 4 | IN | p_sColorSerial |
varchar(255) |
| 5 | IN | p_dMachineQty |
decimal(18,6) |
| 6 | IN | p_iPlate |
int |
| 7 | IN | p_iFor |
int |
| 8 | IN | p_ConstTie |
varchar(50) |
| 9 | IN | p_iStick |
int |
| 10 | IN | p_iFace |
int |
| 11 | IN | p_iPrintMode |
decimal(18,6) |
| 12 | IN | p_dPrintFaceQty |
decimal(18,6) |
| 13 | IN | p_uPlanSlaveGuid |
varchar(50) |
| 14 | IN | sBrId |
varchar(50) |
| 15 | IN | sSuId |
varchar(50) |
| 16 | IN | p_tCreateDate |
datetime |
| 17 | IN | sLoginId |
varchar(50) |
| 18 | IN | p_sType |
varchar(10) |
| 19 | IN | p_sWorkOrderMaterialsTbId |
varchar(50) |
| 20 | IN | p_sMaterialsId |
varchar(50) |
| 21 | IN | p_sMaterialsStyle |
varchar(50) |
| 22 | IN | p_dAuxiliaryQty |
decimal(18,6) |
| 23 | IN | p_sTjMachineId |
varchar(50) |
| 24 | IN | p_sTjAPSMemo |
longtext |
| 25 | IN | p_uWorkOrderProcessGuid |
varchar(50) |
| 26 | IN | p_uPlanGuid |
varchar(50) |
| 27 | IN | p_uCustomerGuid |
varchar(50) |
| 28 | IN | p_sManualNo |
varchar(50) |
| 29 | IN | p_sCustomerOrderNo |
varchar(50) |
| 30 | IN | p_uProductGuid |
varchar(50) |
| 31 | IN | p_uProcessGuid |
varchar(50) |
| 32 | IN | p_dProductQty |
decimal(18,6) |
| 33 | IN | p_uControlGuid |
varchar(50) |
| 34 | IN | p_sPartsName |
varchar(255) |
| 35 | IN | p_uMachineGuid |
varchar(50) |
| 36 | IN | p_dProductionReportQty |
decimal(18,6) |
| 37 | IN | p_dQuotationHour |
decimal(18,6) |
| 38 | IN | p_tStartDate |
datetime |
| 39 | IN | p_tPlanDate |
datetime |
| 40 | IN | p_uTeamGuid |
varchar(50) |
| 41 | IN | p_sMaterialsNameTmp |
varchar(100) |
| 42 | IN | p_sProcessMemo |
varchar(250) |
| 43 | IN | p_sWorkOrderId |
varchar(50) |
| 44 | IN | p_sWorkOrderNo |
varchar(50) |
| 45 | IN | p_dNoArrangeQty |
decimal(18,6) |
| 46 | IN | p_dProductPQty |
decimal(18,6) |
| 47 | IN | p_sSrcSlaveMemo |
longtext |
| 48 | IN | p_sWebOrderNo |
varchar(50) |
| 49 | IN | p_sWebOrderId |
varchar(50) |
| 50 | IN | p_sOrderId |
varchar(50) |
| 51 | IN | p_sOrderNo |
varchar(50) |
| 52 | IN | p_sWorkOrderSlaveId |
varchar(50) |
| 53 | IN | p_sSReserve1 |
varchar(50) |
| 54 | IN | p_sSReserve2 |
varchar(50) |
| 55 | IN | p_sSReserve3 |
varchar(50) |
| 56 | IN | p_sSReserve4 |
varchar(50) |
| 57 | IN | p_sSReserve5 |
varchar(50) |
| 58 | IN | p_sSReserve6 |
varchar(50) |
| 59 | IN | p_dSReserve1 |
decimal(18,6) |
| 60 | IN | p_dSReserve2 |
decimal(18,6) |
| 61 | IN | p_dSReserve3 |
decimal(18,6) |
| 62 | IN | p_iSReserve1 |
int |
| 63 | IN | p_iSReserve2 |
int |
| 64 | IN | p_iSReserve3 |
int |
| 65 | IN | p_tSReserve1 |
datetime |
| 66 | IN | p_tSReserve2 |
datetime |
| 67 | IN | p_sCReserve1 |
varchar(255) |
| 68 | IN | p_sMReserve1 |
varchar(255) |
| 69 | IN | p_sMReserve2 |
varchar(255) |
| 70 | IN | p_sState |
varchar(5) |
| 71 | IN | p_sFormId |
varchar(50) |
| 72 | IN | p_sColorSerialMemo |
longtext |
| 73 | IN | p_sAfterProcess |
longtext |
| 74 | IN | p_sProcessRequire |
longtext |
| 75 | IN | p_tDeliverDate |
datetime |
| 76 | IN | p_iArrangeSrcValue |
int |
| 77 | IN | p_sPReserve2 |
longtext |
| 78 | IN | p_dSinglePQty |
decimal(18,6) |
| 79 | IN | p_sReportParams |
longtext |
| 80 | IN | p_sWorkCenterId |
varchar(255) |
| 81 | IN | p_sControlFaceName |
longtext |
| 82 | IN | p_sPositiveColor |
longtext |
| 83 | IN | p_sOppositeColor |
longtext |
| 84 | OUT | sCode |
int |
| 85 | OUT | sReturn |
longtext |
Body
Body is not pre-cached. To inspect: mysql --defaults-file=~/.my.cnf -e 'SHOW CREATE PROCEDURESpManufacture_InsertMftPlanSlave'._
Narrative
Business context: 生产管理 → 生产计划管理 — the row-level workhorse that materialises a single 机台计划 (MftProductionPlanSlave) row from a single work-order process. The auto-catalog header is explicit: "生产计划从：插入计划（Sp_Manufacture_InsertMftPlan调用）". Takes the full per-row context (machine, process, plates, qty, colour, materials, reserves, control-face, dual-side colour) and writes one slave row.
What it does: Validates the inputs, DELETE FROM MftProductionPlanSlave for any stale row at p_uPlanSlaveGuid, CALL Sp_CalcPlan_dHour to compute the planned duration, CALL Sp_Create_sControlFaceNameTable to expand the control-face metadata, then INSERT INTO MftProductionPlanSlave with the full denormalised row (work-order denorms, order denorms, customer denorms, colour fields, ~20 reserve columns). Final UPDATE MftProductionPlanSlave pass fixes derived columns.
Invocation: Chained — called from Sp_Manufacture_InsertMftPlan, Sp_Manufacture_InsertMftPlanProcess, Sp_Manufacture_InsertMftPlanToErp, and the dynamic sp_btn_action dispatcher. Not bound to any form-master or gdsmodule hook directly. Install: xly-src script/标版/30100101/schedule/Sp_Manufacture_InsertMftPlanSlave.sql.