public AlarmEventInfo GetAlarmEventInfoByCode(string EventCode) { AlarmEventInfo aeInfo = new AlarmEventInfo(); StringBuilder strSQL = new StringBuilder(); strSQL.Append(@"SELECT 事件编码,首次呼救电话,首次受理时刻,事件名称=(现场地址+患者姓名), 首次调度员编码,受理次数,区域,执行任务总数,当前执行任务数,等车地址, 是否挂起,TZET.名称 as 事件类型,TZEO.名称 as 事件来源 ,TZAT.名称 as 事故类型,TZAL.名称 as 事故等级,TP.姓名 as 首次调度员, 首次调度员工号=tp.工号,TAE.是否测试 ,TAE.中心编码,中心名称=tc.名称 FROM TAlarmEvent TAE left join TZAlarmEventType TZET on TZET.编码 = TAE.事件类型编码 left join TZAlarmEventOrigin TZEO on TZEO.编码 =TAE.事件来源编码 left join TZAccidentType TZAT on TZAT.编码 = TAE.事故类型编码 left join TZAccidentLevel TZAL on TZAL.编码 =TAE.事故等级编码 left join TPerson TP on TP.编码=TAE.首次调度员编码 left join TCenter tc on tc.编码=TAE.中心编码 where tae.事件编码 = '" + EventCode + @"'"); using (SqlDataReader sdr = SqlHelper.ExecuteReader(SqlHelper.AttemperConnectionString, CommandType.Text, strSQL.ToString(), null)) { if (sdr.Read()) { aeInfo.EventCode = sdr["事件编码"].ToString(); aeInfo.FirstAlarmCall = sdr["首次呼救电话"].ToString(); aeInfo.EvetnName = sdr["事件名称"].ToString(); aeInfo.FirstAcceptTime = DBConvert.ConvertNullableToNullableTime(sdr["首次受理时刻"].ToString()); // aeInfo.FirstDisptcher = sdr["首次调度员编码"].ToString(); aeInfo.FirstDisptcherWorkID = sdr["首次调度员工号"].ToString();//2013.04.11 刘爱青 add aeInfo.AcceptCount = Convert.ToInt32(sdr["受理次数"]); // aeInfo.FirstSendAmbTime = DBConvert.ConvertNullableToNullableTime(sdr["首次派车时刻"].ToString()); aeInfo.Area = sdr["区域"].ToString(); aeInfo.TransactTaskCount = Convert.ToInt32(sdr["执行任务总数"]); aeInfo.NonceTransactTaskCount = Convert.ToInt32(sdr["当前执行任务数"]); aeInfo.IsHangUp = Convert.ToBoolean(sdr["是否挂起"]); aeInfo.EventType = sdr["事件类型"].ToString(); // aeInfo.EventTypeCode = Convert.ToInt32(sdr["事件类型编码"]); aeInfo.EventSource = sdr["事件来源"].ToString(); // aeInfo.EventSourceCode = Convert.ToInt32(sdr["事件来源编码"]); aeInfo.AccidentType = sdr["事故类型"].ToString(); // aeInfo.AccidentTypeCode = Convert.ToInt32(sdr["事故类型编码"]); aeInfo.AccidentLevel = sdr["事故等级"].ToString(); // aeInfo.AccidentLevelCode = Convert.ToInt32(sdr["事故等级编码"]); aeInfo.FirstDisptcherName = sdr["首次调度员"].ToString(); aeInfo.IsTest = Convert.ToBoolean(sdr["是否测试"]); aeInfo.CenterCode = Convert.ToInt32(sdr["中心编码"]); aeInfo.CenterName = sdr["中心名称"].ToString(); } } return(aeInfo); }
public AlarmEventInfo GetAlarmEventInfoByCode(string EventCode) { AlarmEventInfo aeInfo = new AlarmEventInfo(); StringBuilder strSQL = new StringBuilder(); strSQL.Append(@"SELECT 事件编码,首次呼救电话,首次受理时刻,事件名称=(现场地址+患者姓名), 首次调度员编码,受理次数,区域,执行任务总数,当前执行任务数,等车地址, 是否挂起,TZET.名称 as 事件类型,TZEO.名称 as 事件来源 ,TZAT.名称 as 事故类型,TZAL.名称 as 事故等级,TP.姓名 as 首次调度员, 首次调度员工号=tp.工号,TAE.是否测试 ,TAE.中心编码,中心名称=tc.名称 FROM TAlarmEvent TAE left join TZAlarmEventType TZET on TZET.编码 = TAE.事件类型编码 left join TZAlarmEventOrigin TZEO on TZEO.编码 =TAE.事件来源编码 left join TZAccidentType TZAT on TZAT.编码 = TAE.事故类型编码 left join TZAccidentLevel TZAL on TZAL.编码 =TAE.事故等级编码 left join TPerson TP on TP.编码=TAE.首次调度员编码 left join TCenter tc on tc.编码=TAE.中心编码 where tae.事件编码 = '" + EventCode + @"'"); using (SqlDataReader sdr = SqlHelper.ExecuteReader(SqlHelper.AttemperConnectionString, CommandType.Text, strSQL.ToString(), null)) { if (sdr.Read()) { aeInfo.EventCode = sdr["事件编码"].ToString(); aeInfo.FirstAlarmCall = sdr["首次呼救电话"].ToString(); aeInfo.EvetnName = sdr["事件名称"].ToString(); aeInfo.FirstAcceptTime = DBConvert.ConvertNullableToNullableTime(sdr["首次受理时刻"].ToString()); // aeInfo.FirstDisptcher = sdr["首次调度员编码"].ToString(); aeInfo.FirstDisptcherWorkID = sdr["首次调度员工号"].ToString();//2013.04.11 刘爱青 add aeInfo.AcceptCount = Convert.ToInt32(sdr["受理次数"]); // aeInfo.FirstSendAmbTime = DBConvert.ConvertNullableToNullableTime(sdr["首次派车时刻"].ToString()); aeInfo.Area = sdr["区域"].ToString(); aeInfo.TransactTaskCount = Convert.ToInt32(sdr["执行任务总数"]); aeInfo.NonceTransactTaskCount = Convert.ToInt32(sdr["当前执行任务数"]); aeInfo.IsHangUp = Convert.ToBoolean(sdr["是否挂起"]); aeInfo.EventType = sdr["事件类型"].ToString(); // aeInfo.EventTypeCode = Convert.ToInt32(sdr["事件类型编码"]); aeInfo.EventSource = sdr["事件来源"].ToString(); // aeInfo.EventSourceCode = Convert.ToInt32(sdr["事件来源编码"]); aeInfo.AccidentType = sdr["事故类型"].ToString(); // aeInfo.AccidentTypeCode = Convert.ToInt32(sdr["事故类型编码"]); aeInfo.AccidentLevel = sdr["事故等级"].ToString(); // aeInfo.AccidentLevelCode = Convert.ToInt32(sdr["事故等级编码"]); aeInfo.FirstDisptcherName = sdr["首次调度员"].ToString(); aeInfo.IsTest = Convert.ToBoolean(sdr["是否测试"]); aeInfo.CenterCode = Convert.ToInt32(sdr["中心编码"]); aeInfo.CenterName = sdr["中心名称"].ToString(); } } return aeInfo; }
/// <summary> /// Executes a Reset action on the Alarm with the Id provided. The result /// will generate a new AlarmEvent based on the information contained in the /// newEvent parameter. /// Restrictions apply based on the TransitionModel of the Alarm. /// </summary> /// <param name='operations'> /// The operations group for this extension method. /// </param> /// <param name='id'> /// Id of the Alarm to be Acknowledged. Must be double URL encoded. /// </param> /// <param name='newEvent'> /// Information to describe the generated AlarmEvent. /// </param> /// <param name='cancellationToken'> /// The cancellation token. /// </param> public static async Task <AlarmModel> ResetAsync(this IAlarms operations, string id, AlarmEventInfo newEvent, CancellationToken cancellationToken = default(CancellationToken)) { using (var _result = await operations.ResetWithHttpMessagesAsync(id, newEvent, null, cancellationToken).ConfigureAwait(false)) { return(_result.Body); } }
/// <summary> /// Executes a Reset action on the Alarm with the Id provided. The result /// will generate a new AlarmEvent based on the information contained in the /// newEvent parameter. /// Restrictions apply based on the TransitionModel of the Alarm. /// </summary> /// <param name='operations'> /// The operations group for this extension method. /// </param> /// <param name='id'> /// Id of the Alarm to be Acknowledged. Must be double URL encoded. /// </param> /// <param name='newEvent'> /// Information to describe the generated AlarmEvent. /// </param> public static AlarmModel Reset(this IAlarms operations, string id, AlarmEventInfo newEvent) { return(Task.Factory.StartNew(s => ((IAlarms)s).ResetAsync(id, newEvent), operations, CancellationToken.None, TaskCreationOptions.None, TaskScheduler.Default).Unwrap().GetAwaiter().GetResult()); }