/// <summary> /// 获取所有出院患者清单 /// </summary> /// <param name="deptid">科室ID</param> /// <returns>所有出院患者清单数据表</returns> public DataTable listPatient_Left(long deptid) { try { int lastMonthNum = OP_Config.GetValue("006"); if (lastMonthNum == -1) { lastMonthNum = 6; } dt.Clear(); str = ""; str = @"select a.patlistid patlistid,b.name 病人科室,date(a.outdate) 出院日期,'出院时间' 出院时间,a.bedcode 床号,a.cureno 住院号,a.patid 病人ID,c.patname 姓名,c.patsex 性别, " + "case a.out_flag when 0 then '治愈' when 1 then '好转' when 2 then '未愈' when 3 then '死亡' else '其他' end 出院方式," + //出院状态:0治愈,1好转,2未愈,3死亡,4其他 "case a.pattype when '3' then '出院未结算' when '4' then '出院结算' when '5' then '出院欠费结算' else '其他' end 目前状态 " + "from ZY_PATLIST a " + //住院登记信息表 "left join BASE_DEPT_PROPERTY b " + //科室信息表 "on a.currdeptcode=cast(b.dept_id as char(20)) " + "left join PATIENTINFO c " + //患者信息表 "on a.patid=c.patid " + "where (a.pattype='3' or a.pattype='4' or a.pattype='5')" + //1.新入院2.在床3.出院未结算4.出院结算5.出院欠费结算6.取消入院7.定义出院 " and a.currdeptcode='" + deptid.ToString() + "'" + //只获取当前科室出院患者清单 " and a.outdate>='" + XcDate.ServerDateTime.Date.AddMonths(-lastMonthNum) + "'" + " order by a.outdate desc"; //只显示最近半年的出院患者 dt = oleDb.GetDataTable(str); return(dt); } catch (Exception e) { throw new Exception(e.Message); } }
/// <summary> /// 实例化医嘱打印类 /// </summary> /// <param name="patlistid">患者住院ID</param> /// <param name="ordertype">医嘱类型0长嘱1临嘱</param> public OrderPrt(int patlistid, int ordertype) { int longorder_width = OP_Config.GetValue("003"); if (longorder_width == -1) { longorder_width = 16; } int tmporder_width = OP_Config.GetValue("004"); if (tmporder_width == -1) { tmporder_width = 20; } _rowsperpage = OP_Config.GetValue("005"); if (_rowsperpage == -1) { _rowsperpage = 30; } string str = @"call SP_HS_ORDERPRT(" + patlistid + "," + longorder_width + "," + tmporder_width + "," + _rowsperpage + "," + HIS.SYSTEM.Core.EntityConfig.WorkID + ")";//SP_HS_ORDERPRT(V_PATLISTID,V_LORDERCONTENT_WIDTH,V_TORDERCONTENT_WIDTH,V_ROWS_PER_PAGE,WORKID) oleDb.DoCommand(str); if (ordertype == 0) { str = @"select PATLISTID, BABYID, PAGENO, ROWNO, PAGE_STATUS, ROW_STATUS, " + " NEWLINE, GROUP_STATUS, PRT_STATUS, ORDER_ID, GROUP_ID, " + " ORDER_BDATE as ORDER_BDATETIME, ITEM_TYPE, ORDER_CONTENT, AMOUNT, PRES_AMOUNT, " + " UNIT, ORDER_SPEC, ORDER_USAGE, FREQUENCY, ORDER_DOC, " + " TRANS_NURSE, CHECK_NURSE, ORDER_EDATE as ORDER_EDATETIME, ORDER_EDOC, " + " ORDER_ETSNURSE, ORDER_ECHKNURSE, PRINTER, WORKID, MEMO " + " from ZY_NURSE_LORDERPRT where PATLISTID=" + patlistid + " and WORKID=" + HIS.SYSTEM.Core.EntityConfig.WorkID + " order by pageno,rowno"; } else { str = @"select PATLISTID, BABYID, PAGENO, ROWNO, PAGE_STATUS, ROW_STATUS, " + " NEWLINE, GROUP_STATUS, PRT_STATUS, ORDER_ID, GROUP_ID, " + " ORDER_BDATE as ORDER_BDATETIME, ITEM_TYPE, ORDER_CONTENT, AMOUNT, PRES_AMOUNT, " + " UNIT, ORDER_SPEC, ORDER_USAGE, FREQUENCY, ORDER_DOC, " + " TRANS_NURSE, CHECK_NURSE, EXEDATE, EXECUTOR, PRINTER, WORKID, MEMO " + " from ZY_NURSE_TORDERPRT where PATLISTID=" + patlistid + " and WORKID=" + HIS.SYSTEM.Core.EntityConfig.WorkID + " order by pageno,rowno"; } _orderlist = oleDb.GetDataTable(str); OriginalOrderList = _orderlist.Clone(); }