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