| | |
| | | new SugarParameter("V_WORK_ORDER_NO", workOrderNo), |
| | | new SugarParameter("V_MACHINE_NO", machineNo), |
| | | new SugarParameter("V_TOOL_NO", toolNo), |
| | | new SugarParameter("V_TYPE", type), // string 类型 |
| | | new SugarParameter("V_TYPE", type), |
| | | new SugarParameter("V_USE_LIMIT", useLimit ?? (object)DBNull.Value) |
| | | }; |
| | | try |
| | | { |
| | | var result = Db.Ado.SqlQuery<object>( |
| | | "EXEC PROC_TOOL_ACTION @V_WORK_ORDER_NO, @V_MACHINE_NO, @V_TOOL_NO, @V_TYPE, @V_USE_LIMIT", parameters); |
| | | "CALL PROC_TOOL_ACTION(:V_WORK_ORDER_NO, :V_MACHINE_NO, :V_TOOL_NO, :V_TYPE, :V_USE_LIMIT)", parameters); |
| | | return result; |
| | | } |
| | | catch (Exception ex) |