Sp_GetOrder_Process (procedure)

@author: qmj

    @date:20210714  封存

    @describe :     以工单号关联，各阶段插入一条数据，显示各阶段是否完成
                            订单-> 工单-> 工序-> 上报-> 成品入库-> 送货-> 收款
                                         发外-> 发外入库

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

Parameters

#	Mode	Name	Type
1	IN	sBillNo	varchar(100)
2	IN	sLoginId	varchar(100)
3	OUT	sReturn	varchar(100)
4	IN	sBrId	varchar(100)
5	IN	sSuId	varchar(100)
6	OUT	sCode	int
7	IN	bFilter	varchar(5000)
8	IN	pageNum	int
9	IN	pageSize	int
10	OUT	totalCount	int
11	IN	countCloumn	varchar(5000)
12	OUT	countMapJson	longtext
13	IN	sFilterOrderBy	varchar(5000)
14	IN	sGroupby_select_sql	varchar(5000)
15	IN	sGroupby_group_sql	varchar(5000)

Body

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

Narrative

No human-written narrative yet.