| | |
|---|
| | | "AND appe_time <= #{endTime}") |
|---|
| | | Long sumCostTimeByWrkSts(@Param("startTime") Date startTime, @Param("endTime") Date endTime, @Param("wrkSts") Integer wrkSts); |
|---|
| | | |
|---|
| | | @Select("SELECT COUNT(1) " + |
|---|
| | | "FROM asr_wrk_mast_log " + |
|---|
| | | "WHERE wrk_sts = 5 " + |
|---|
| | | "AND source_sta_no = #{sourceStaNo} " + |
|---|
| | | "AND appe_time >= #{startTime} " + |
|---|
| | | "AND appe_time <= #{endTime}") |
|---|
| | | Long countInboundHistoryBySourceStaNo(@Param("startTime") Date startTime, @Param("endTime") Date endTime, @Param("sourceStaNo") Integer sourceStaNo); |
|---|
| | | |
|---|
| | | /** |
|---|
| | | * 查询库存移动流水记录 |
|---|
| | | */ |
|---|
