Sp_Manufacture_sSodPurchareMaterials (procedure)

根据销售订单采购物料

• Type: PROCEDURE
• Deterministic: NO
• SQL data access: CONTAINS SQL
• Created: 2026-04-27 19:10:37
• Last altered: 2026-04-27 19:10:37

Parameters

#	Mode	Name	Type
1	IN	sId_s	varchar(4000)
2	IN	sStyle_s	varchar(4000)
3	IN	sWorkId_s	varchar(4000)
4	IN	sLoginId	varchar(100)
5	IN	sWorkOrderNo_s	varchar(255)
6	IN	sCustomerName_s	varchar(255)
7	IN	sProductName_s	varchar(255)
8	IN	iPurchase_s	int
9	IN	bViewAll_s	int
10	IN	bSlaveAll_s	int
11	OUT	sCode	int
12	OUT	sReturn	varchar(5000)
13	IN	sBrId	varchar(255)
14	IN	sSuId	varchar(255)
15	IN	bFilter	varchar(5000)
16	IN	sUnTaskFormId	varchar(100)
17	IN	pageNum	int
18	IN	pageSize	int
19	OUT	totalCount	int
20	IN	countCloumn	varchar(5000)
21	OUT	countMapJson	longtext
22	IN	sFilterOrderBy	varchar(5000)
23	IN	sGroupby_select_sql	varchar(5000)
24	IN	sGroupby_group_sql	varchar(5000)

Body

Body is not pre-cached. To inspect: mysql --defaults-file=~/.my.cnf -e 'SHOW CREATE PROCEDURESpManufacture_sSodPurchareMaterials'._

Narrative

No human-written narrative yet.