[{"branch":"0","branchmc":"standard","button":"[]","catalog":"ChaXun","chart":"[]","code":"queryBQLYDCXYPHZDYPXX","column":"[{\"filter_name\":\"substrb(trim(C.YPMC00) || '/' || trim(C.YPGG00), 1, 220)\",\"hidden\":false,\"LAY_TABLE_INDEX\":0,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"药品名称\",\"align\":\"left\",\"ellipsis\":true,\"sequence\":0,\"ora_name\":\"YPMC00\",\"headerAlign\":\"center\",\"field\":\"YPMC00\",\"sortType\":\"asc\",\"width\":\"300\",\"fixed\":\"\",\"render\":\"\",\"key\":\"YPMC00\",\"_VCUID\":\"row_327\"},{\"filter_name\":\"substr(SF_YF_YPSLZH(sum(C.CKSL00)*C.ZHL000,C.YPNM00,3),1,50)\",\"hidden\":false,\"LAY_TABLE_INDEX\":1,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"数量\",\"align\":\"right\",\"ellipsis\":true,\"sequence\":1,\"ora_name\":\"YPZSL1\",\"headerAlign\":\"center\",\"field\":\"YPZSL1\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"render\":\"\",\"key\":\"YPZSL1\",\"_VCUID\":\"row_328\"},{\"filter_name\":\"C.LSDJ00\",\"hidden\":false,\"LAY_TABLE_INDEX\":2,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"单价\",\"align\":\"right\",\"ellipsis\":true,\"sequence\":2,\"ora_name\":\"LSDJ00\",\"headerAlign\":\"center\",\"field\":\"LSDJ00\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"render\":\"\",\"key\":\"LSDJ00\",\"_VCUID\":\"row_329\"},{\"filter_name\":\"TO_CHAR(LSDJ00 * CKSL00, 'FM9999999999990.00')\",\"hidden\":false,\"isTotal\":\"true\",\"LAY_TABLE_INDEX\":3,\"totalType\":\"${JE0000,2}\",\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"金额\",\"align\":\"right\",\"ellipsis\":true,\"sequence\":3,\"ora_name\":\"JE0000\",\"headerAlign\":\"center\",\"field\":\"JE0000\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"render\":\"\",\"key\":\"JE0000\",\"_VCUID\":\"row_330\"},{\"filter_name\":\"C.YPNM00\",\"hidden\":true,\"LAY_TABLE_INDEX\":4,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"药品内码\",\"align\":\"left\",\"ellipsis\":true,\"sequence\":4,\"ora_name\":\"YPNM00\",\"headerAlign\":\"center\",\"field\":\"YPNM00\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"render\":\"\",\"key\":\"YPNM00\",\"_VCUID\":\"row_331\"}]","condition":"[]","createTime":1620724068000,"entityVersion":0,"id":"queryBQLYDCXYPHZDYPXX","isLaypage":"0","module":"yf","name":"queryBQLYDCXYPHZDYPXX","pageSql":"SELECT k.*, substrb(trim(K.YPMC00)||'/'||trim(k.YPGG00),1,220) as YPMC00,K.CKSL00||K.QLDW00 LYSL00,TO_CHAR(K.LSDJ00*K.CKSL00,'FM9999999999990.00') JE0000 FROM \n( SELECT C.YPGG00,C.YPMC00,\n    C.LSDJ00,SUM(C.YPZSL0) CKSL00,\n    D.DXSYBZ,D.JXBH00,D.YLBH00,\n    nvl((select X.GZDJ00 from YF_YPKCXX X where C.YPNM00=X.YPNM00\n      AND  X.YFBMBH=${YFBMBH}),D.GZDJ00) GZDJ00 ,\n    C.CKDH00,C.YPNM00,\n    D.YPBM00,C.QLDW00,\n substr(SF_YF_YPSLZH(sum(C.YPZSL0)*C.ZHL000,C.YPNM00,3),1,50) YPZSL1\nFROM YF_YZYPSQ C,BM_YD0000 D\nWHERE C.CKDH00='${CKDH00}'\n      AND  C.YPNM00=D.YPNM00\nGROUP BY C.CKDH00,C.YPNM00,YPBM00,C.YPMC00,C.YPGG00,GZDJ00,LSDJ00,DXSYBZ,JXBH00,YLBH00,C.QLDW00,C.ZHL000 )  k ORDER BY GZDJ00,DXSYBZ,YPBM00\n","procedureCommit":0,"procedureParameter":"[]","remark":"药房-查询-单据查询-病区领药单查询药品汇总药品单信息","system":"his","updateTime":1755486307000,"version":0}]