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