public AcceptEventInfo GetEventNode(string code) { StringBuilder sb = new StringBuilder(); sb.Append(@" select A.事件编码,受理序号 from TAcceptEvent A where A.事件编码='" + code + @"' order by 受理序号 "); using (SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.AttemperConnectionString, CommandType.Text, sb.ToString(), null)) { // DataSet ds = SqlHelper.ExecuteDataSet(SqlHelper.AttemperConnectionString, CommandType.Text, sb.ToString(), null); AcceptEventInfo ENinfo = new AcceptEventInfo(); if (dr.Read()) { ENinfo.EventCode = DBConvert.ConvertStringToString(dr["事件编码"]); ENinfo.AcceptOrder = Convert.ToInt32(dr["受理序号"]); } return(ENinfo); } }
public AcceptEventInfo GetAcceptEventInfoByCode(string code, int orderNum) { AcceptEventInfo AEinfo; StringBuilder sb = new StringBuilder(); sb.Append(@"SELECT 事件编码=tae.事件编码,受理序号=tae.受理序号,受理类型编码,受理类型子编码,责任受理人编码,呼救电话=tae.呼救电话 ,电话振铃时刻=tae.电话振铃时刻,开始受理时刻=tae.开始受理时刻,结束受理时刻=tae.结束受理时刻,发送指令时刻,现场地址,等车地址 ,送往地点,往救地点类型编码,送往地点类型编码,联系人,联系电话,分机,患者姓名,性别 ,年龄,国籍,主诉,病种判断,病情编码=tale.病情编码,是否需要担架,伤亡人数,特殊要求,是否标注 ,X坐标,Y坐标,派车列表, 备注=tale.备注,TZET.名称 as 受理类型,TP.姓名 as 责任受理人,病情=tzis.名称 ,往救地点类型=tzlat.名称,送往地点类型=tzsat.名称,责任受理人工号=tp.工号 FROM TAcceptEvent TAE inner join TZAcceptEventType TZET on TZET.编码 = TAE.受理类型编码 inner join TPerson TP on TP.编码 = TAE.责任受理人编码 left join TAlarmEvent tale on tae.事件编码= tale.事件编码 left join TZIllState tzis on tzis.编码 = tale.病情编码 left join TZLocalAddrType tzlat on tzlat.编码 = tale.往救地点类型编码 left join TZSendAddrType tzsat on tzsat.编码 = tale.送往地点类型编码 left join TTask tk on tae.事件编码 =tk.事件编码 where tae.事件编码 = '" + code + @"' and tae.受理序号='" + orderNum + @"'"); using (SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.AttemperConnectionString, CommandType.Text, sb.ToString(), null)) { AEinfo = new AcceptEventInfo(); if (dr.Read()) { AEinfo.EventCode = DBConvert.ConvertStringToString(dr["事件编码"]); AEinfo.AcceptOrder = Convert.ToInt32(dr["受理序号"]); AEinfo.TypeId = Convert.ToInt32(dr["受理类型编码"]); AEinfo.DetailReasonId = Convert.ToInt32(dr["受理类型子编码"]); AEinfo.AcceptPersonCode = DBConvert.ConvertStringToString(dr["责任受理人编码"]); AEinfo.AcceptPersonWorkID = DBConvert.ConvertStringToString(dr["责任受理人工号"]); AEinfo.AlarmTel = DBConvert.ConvertStringToString(dr["呼救电话"]); // AEinfo.HangUpTime = DBConvert.ConvertNullableToNullableTime(dr["挂起时刻"].ToString()); AEinfo.RingTime = DBConvert.ConvertNullableToNullableTime(dr["电话振铃时刻"].ToString()); AEinfo.AcceptBeginTime = DBConvert.ConvertNullableToNullableTime(dr["开始受理时刻"].ToString()); AEinfo.AcceptEndTime = DBConvert.ConvertNullableToNullableTime(dr["结束受理时刻"].ToString()); AEinfo.CommandTime = DBConvert.ConvertNullableToNullableTime(dr["发送指令时刻"].ToString()); AEinfo.LocalAddr = DBConvert.ConvertStringToString(dr["现场地址"]); AEinfo.WaitAddr = DBConvert.ConvertStringToString(dr["等车地址"]); AEinfo.SendAddr = DBConvert.ConvertStringToString(dr["送往地点"]); AEinfo.LocalAddrTypeId = Convert.ToInt32(dr["往救地点类型编码"]); AEinfo.SendAddrTypeId = Convert.ToInt32(dr["送往地点类型编码"]); AEinfo.LinkMan = DBConvert.ConvertStringToString(dr["联系人"]); AEinfo.LinkTel = DBConvert.ConvertStringToString(dr["联系电话"]); AEinfo.Extension = DBConvert.ConvertStringToString(dr["分机"]); AEinfo.PatientName = DBConvert.ConvertStringToString(dr["患者姓名"]); AEinfo.Sex = DBConvert.ConvertStringToString(dr["性别"]); AEinfo.Age = DBConvert.ConvertStringToString(dr["年龄"]); // AEinfo.Folk = DBConvert.ConvertStringToString(dr["民族"]); AEinfo.National = DBConvert.ConvertStringToString(dr["国籍"]); AEinfo.AlarmReason = DBConvert.ConvertStringToString(dr["主诉"]); AEinfo.Judge = DBConvert.ConvertStringToString(dr["病种判断"]); AEinfo.IllStateId = Convert.ToInt32(dr["病情编码"]); AEinfo.IsNeedLitter = Convert.ToBoolean(dr["是否需要担架"]); AEinfo.PatientCount = Convert.ToInt32(dr["伤亡人数"]); AEinfo.SpecialNeed = DBConvert.ConvertStringToString(dr["特殊要求"]); AEinfo.IsLabeled = Convert.ToBoolean(dr["是否标注"]); AEinfo.X = Convert.ToDouble(dr["X坐标"]); AEinfo.Y = Convert.ToDouble(dr["Y坐标"]); AEinfo.AmbulanceList = DBConvert.ConvertStringToString(dr["派车列表"]); AEinfo.Remark = DBConvert.ConvertStringToString(dr["备注"]); AEinfo.AcceptType = DBConvert.ConvertStringToString(dr["受理类型"]); AEinfo.Dispatcher = DBConvert.ConvertStringToString(dr["责任受理人"]); AEinfo.IllState = DBConvert.ConvertStringToString(dr["病情"]); AEinfo.LocalAddrType = DBConvert.ConvertStringToString(dr["往救地点类型"]); AEinfo.SendAddrType = DBConvert.ConvertStringToString(dr["送往地点类型"]); //AEinfo.AcceptPersonWorkID = DBConvert.ConvertStringToString(dr["责任受理人工号"]); // AEinfo.BackUpOne = DBConvert.ConvertStringToString(dr["保留字段1"]); //AEinfo.BackUpTwo = DBConvert.ConvertStringToString(dr["保留字段2"]); // AEinfo.HangUpTime = DBConvert.ConvertNullableToNullableTime(dr["挂起时刻"].ToString()); } return(AEinfo); } }