public DataSet get_devices_all_by_param_ds(string jy_room, string pages, string p_rows)
{
string sql = "select top " + p_rows + " r.* from " + "(select top 100 percent row_number() over(order by m.m_id asc ) as 序号," +
"m.machinename as 设备名称, m.status as 设备工作状态, m.usingstatus as 启用状态, pr.Pspnum as 处方号,SUBSTRING(isnull(pr.name,''),1,1)+'**' as 患者姓名," +
"(case when pr.curstate='开始煎药' then '正在煎药' when pr.curstate='开始包装' then '正在包装' else pr.curstate end) as 处方状态," +
"ti.starttime as 开始时间,(case when pr.curstate='开始煎药' or pr.curstate='煎药完成' then ti.endtime when pr.curstate='开始包装' or pr.curstate='包装完成' then pa.pactime else pa.pactime end ) as 结束时间, isnull(ti.tisaneman,'') as 操作人"
+ " from machine m left join prescription pr " +
"on m.pid=pr.id left join tisaneinfo ti on ti.pid =m.pid left join packing pa on pa.DecoctingNum=pr.id" +
" where m.mark in('0','1') " + " and m.roomnum='" + jy_room.Trim() + "'" +
"order by m.m_id asc) r " +
"where r.序号>(" + pages.Trim() + "-1)*" + p_rows.Trim();
return(db.Get_DataSet(sql));
}
