Sp_Manufacture_SalSalesChecking (procedure)

工单到采购计划

• Type: PROCEDURE
• Deterministic: NO
• SQL data access: CONTAINS SQL

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_SalSalesChecking'._

Narrative

No human-written narrative yet.