/// <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();
}
