/// <summary> /// 给移动终端用的任务数据 /// </summary> /// <param name="personCode"></param> /// <returns></returns> public List <MobileTaskInfo> GetMobileTaskListBy(string userCode, string taskCode, ref string errorMsg) { try { StringBuilder sbSQL = new StringBuilder();//sql语句 sbSQL.Append("declare @taskCode char(22) "); sbSQL.Append("set @taskCode='" + taskCode + "' "); sbSQL.Append("declare @UserCode varchar(50) "); sbSQL.Append("set @UserCode=(select 编码 from TPerson where 工号='" + userCode + "') "); string sqlStr = @" select top 20 tt.任务编码, tt.用户流水号, case when pr.LocalAddress is null then tae.现场地址 else pr.LocalAddress end as '现场地址', tt.到达现场时刻, case when pr.[Name] is null then tae.患者姓名 else pr.Name end as '患者姓名', tae.事件类型编码, case when pr.PatientVersion is null then tzaet.名称 else pr.PatientVersion end as '事件类型', 司机=isnull(dbo.GetStr(tt.任务编码,3),''), 医生=isnull(dbo.GetStr(tt.任务编码,4),''), 护士=isnull(dbo.GetStr(tt.任务编码,5),''), case when pr.[TaskCode] is null then '未填' else '已填' end as '状态' from TTask tt LEFT JOIN TAlarmEvent tae on tae.事件编码= tt.事件编码 LEFT JOIN TZAlarmEventType tzaet on tae.事件类型编码 = tzaet.编码 LEFT JOIN dbo.TTaskPersonLink tpl on tpl.任务编码=tt.任务编码 left join [AKSHManage].[dbo].[M_PatientRecord] pr on pr.[TaskCode]=tt.任务编码 where "; sbSQL.Append(sqlStr); if (taskCode != "") { sbSQL.Append(" tt.任务编码<@taskCode And"); } sbSQL.Append(" tpl.人员编码=@UserCode "); sbSQL.Append(" order by tt.任务编码 desc"); DataSet ds = SqlHelper.ExecuteDataSet(SqlHelper.AttemperConnectionString, CommandType.Text, sbSQL.ToString(), null); List <MobileTaskInfo> list = new List <MobileTaskInfo>(); if (ds.Tables[0].Rows.Count > 0) { foreach (DataRow dr in ds.Tables[0].Rows) { MobileTaskInfo info = new MobileTaskInfo(); info.RenWuBianMa = dr["任务编码"].ToString(); info.YongHuLiuShuiHao = dr["用户流水号"].ToString(); info.XianChangDiZhi = dr["现场地址"].ToString(); info.DaoDaXianChangShiKe = dr["到达现场时刻"].ToString(); info.HuanZheXingMing = dr["患者姓名"].ToString(); info.EventType = dr["事件类型编码"].ToString(); info.EventTypeName = dr["事件类型"].ToString(); info.SiJi = dr["司机"].ToString(); info.YiSheng = dr["医生"].ToString(); info.HuShi = dr["护士"].ToString(); info.State = dr["状态"].ToString(); list.Add(info); } } return(list); } catch (Exception ex) { List <MobileTaskInfo> listError = null; errorMsg = "系统错误:" + ex.Message; return(listError); } }
/// <summary> /// 给移动终端用的任务数据 /// </summary> /// <param name="personCode"></param> /// <returns></returns> public List <MobileTaskInfo> getMobileTaskListBy(string userCode) { DateTime BeginTime = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day); DateTime EndTime = BeginTime.AddDays(1); StringBuilder sbSQL = new StringBuilder();//sql语句 sbSQL.Append("declare @BeginTime datetime "); sbSQL.Append("declare @EndTime datetime "); sbSQL.Append("declare @UserCode varchar(50) "); sbSQL.Append("set @BeginTime='" + BeginTime + "' "); sbSQL.Append("set @EndTime='" + EndTime + "' "); sbSQL.Append("set @UserCode='" + userCode + "' "); sbSQL.Append("declare @TaskCodeB char(22) "); sbSQL.Append("declare @TaskCodeE char(22) "); sbSQL.Append("set @TaskCodeB = convert(char(8),@BeginTime,112)+'00000000000000' "); sbSQL.Append("set @TaskCodeE = convert(char(8),dateadd(day,1,@EndTime),112)+'00000000000000' "); string sqlStr = @" select * from (select tt.用户流水号, tae.现场地址, tt.到达现场时刻, tae.患者姓名, 司机编码= sj.人员编码, 司机=sj.姓名, 医生编码= isnull(ys.人员编码,''), 医生=isnull(ys.姓名,''), 护士编码= isnull(hs.人员编码,''), 护士=isnull(hs.姓名,'') from TTask tt left join TAlarmEvent tae on tae.事件编码= tt.事件编码 Left join TTaskPersonLink sj on sj.任务编码 = tt.任务编码 and sj.人员类型编码=3 Left join TTaskPersonLink ys on ys.任务编码 = tt.任务编码 and ys.人员类型编码=4 Left join TTaskPersonLink hs on hs.任务编码 = tt.任务编码 and hs.人员类型编码=5 where tt.任务编码>@TaskCodeB and tt.任务编码<=@TaskCodeE ) temp1 where temp1.司机编码=@UserCode or temp1.护士编码=@UserCode or temp1.医生编码=@UserCode "; sbSQL.Append(sqlStr); DataSet ds = SqlHelper.ExecuteDataSet(SqlHelper.AttemperConnectionString, CommandType.Text, sbSQL.ToString(), null); List <MobileTaskInfo> list = new List <MobileTaskInfo>(); if (ds.Tables[0].Rows.Count > 0) { foreach (DataRow dr in ds.Tables[0].Rows) { MobileTaskInfo info = new MobileTaskInfo(); info.YongHuLiuShuiHao = dr["用户流水号"].ToString(); info.XianChangDiZhi = dr["现场地址"].ToString(); info.DaoDaXianChangShiKe = dr["到达现场时刻"].ToString(); info.HuanZheXingMing = dr["患者姓名"].ToString(); info.SiJi = dr["司机"].ToString(); info.YiSheng = dr["医生"].ToString(); info.HuShi = dr["护士"].ToString(); list.Add(info); } } return(list); }