//获取医生 public object GetDoctorList() { List<CheckModelExt> list = new List<CheckModelExt>(); StringBuilder sb = new StringBuilder(); sb.Append(@"select 编码,姓名 from TPerson where 是否有效 = 1 and 类型编码 = 4 "); DataSet ds = SqlHelper.ExecuteDataSet(SqlHelper.AttemperConnectionString, CommandType.Text, sb.ToString(), null); if (ds.Tables[0].Rows.Count > 0) { foreach (DataRow dr in ds.Tables[0].Rows) { CheckModelExt info = new CheckModelExt(); info.ID = dr["编码"].ToString(); info.Name = dr["姓名"].ToString(); list.Add(info); } } return list; }
//获取车辆编码 public object GetAmbulanceCodeList() { List<CheckModelExt> list = new List<CheckModelExt>(); StringBuilder sb = new StringBuilder(); sb.Append(@"select 车辆编码,实际标识 from TAmbulance where 是否有效 = 1 "); DataSet ds = SqlHelper.ExecuteDataSet(SqlHelper.AttemperConnectionString, CommandType.Text, sb.ToString(), null); if (ds.Tables[0].Rows.Count > 0) { foreach (DataRow dr in ds.Tables[0].Rows) { CheckModelExt info = new CheckModelExt(); info.ID = dr["车辆编码"].ToString(); info.Name = dr["实际标识"].ToString(); list.Add(info); } } return list; }
//获取担架员 public object GetStretcherList() { List <CheckModelExt> list = new List <CheckModelExt>(); StringBuilder sb = new StringBuilder(); sb.Append(@"select 编码,姓名 from TPerson where 是否有效 = 1 and 类型编码 = 6 "); DataSet ds = SqlHelper.ExecuteDataSet(SqlHelper.AttemperConnectionString, CommandType.Text, sb.ToString(), null); if (ds.Tables[0].Rows.Count > 0) { foreach (DataRow dr in ds.Tables[0].Rows) { CheckModelExt info = new CheckModelExt(); info.ID = dr["编码"].ToString(); info.Name = dr["姓名"].ToString(); list.Add(info); } } return(list); }
//获取车辆编码 public object GetAmbulanceCodeList() { List <CheckModelExt> list = new List <CheckModelExt>(); StringBuilder sb = new StringBuilder(); sb.Append(@"select 车辆编码,实际标识 from TAmbulance where 是否有效 = 1 "); DataSet ds = SqlHelper.ExecuteDataSet(SqlHelper.AttemperConnectionString, CommandType.Text, sb.ToString(), null); if (ds.Tables[0].Rows.Count > 0) { foreach (DataRow dr in ds.Tables[0].Rows) { CheckModelExt info = new CheckModelExt(); info.ID = dr["车辆编码"].ToString(); info.Name = dr["实际标识"].ToString(); list.Add(info); } } return(list); }
//获取要车性质(事件类型) public object GetAlarmEventType() { StringBuilder sb = new StringBuilder(); sb.Append(@" select 编码,名称 from TZAlarmEventType where 是否有效=1 "); DataSet ds = (SqlHelper.ExecuteDataSet(SqlHelper.AttemperConnectionString, CommandType.Text, sb.ToString(), null)); List<CheckModelExt> list = new List<CheckModelExt>(); if (ds.Tables[0].Rows.Count > 0) { CheckModelExt info = new CheckModelExt(); foreach (DataRow dr in ds.Tables[0].Rows) { info = new CheckModelExt(); info.ID = Convert.ToString(dr["编码"]); info.Name = dr["名称"].ToString(); list.Add(info); } } return list; }
public List<CheckModelExt> GetTDictionaryIDByParentID(string ParentID) { List<CheckModelExt> listM = new List<CheckModelExt>(); StringBuilder sb = new StringBuilder(); sb.Append(@" select ID from TDictionary where ParentID = '" + ParentID + @"' and IsActive=1 "); SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.MainConnectionString, CommandType.Text, sb.ToString(), null); while (dr.Read()) { CheckModelExt cm = new CheckModelExt(); cm.ID = dr.GetString(0); listM.Add(cm); } return listM; }
public List<CheckModelExt> GetStationCodeByCenter(string selfCenterID) { List<CheckModelExt> listM = new List<CheckModelExt>(); StringBuilder sb = new StringBuilder(); sb.Append(@" select 编码 from TStation where 中心编码= '" + selfCenterID + @"' and 是否有效=1 "); SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.AttemperConnectionString, CommandType.Text, sb.ToString(), null); while (dr.Read()) { CheckModelExt cm = new CheckModelExt(); cm.ID = dr.GetString(0); listM.Add(cm); } return listM; }
//根据人员工号取分站编码(TAmbulancePersonSign 最后一次操作的车辆所属的分站) public string GetstaionCodeByWorkCodeTAmbulance(string workCode) { StringBuilder sb = new StringBuilder(); sb.Append(@" select ta.分站编码 from TAmbulance ta where 车辆编码 = ( select top 1 aps.[车辆编码] from TAmbulancePersonSign aps where aps.[人员编码]=(select p.编码 from TPerson p where p.工号='" + workCode + @"') order by aps.上次操作时刻 ) "); SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.AttemperConnectionString, CommandType.Text, sb.ToString(), null); string stationresult = ""; while (dr.Read()) { CheckModelExt cm = new CheckModelExt(); cm.ID = dr.GetString(0); string stationCode = cm.ID; stationresult = stationCode; } return stationresult; }
public object GetIllnessForecast() { StringBuilder sb = new StringBuilder(); sb.Append(@" select ID,Name from M_Dictionary where IsActive = 1 and TypeID = 'IllStateReport' "); DataSet ds = SqlHelper.ExecuteDataSet(SqlHelper.MainConnectionString, CommandType.Text, sb.ToString(), null); List<CheckModelExt> list = new List<CheckModelExt>(); if (ds.Tables[0].Rows.Count > 0) { CheckModelExt info = new CheckModelExt(); foreach (DataRow dr in ds.Tables[0].Rows) { info = new CheckModelExt(); info.ID = Convert.ToString(dr["ID"]); info.Name = dr["Name"].ToString(); list.Add(info); } } return list; }
//取病种类型 public object GetDiseasesClassifications() { StringBuilder sb = new StringBuilder(); sb.Append(@" select ID,Name from M_ZCaseTemplate where IsActive =1 "); DataSet ds = SqlHelper.ExecuteDataSet(SqlHelper.MainConnectionString, CommandType.Text, sb.ToString(), null); List<CheckModelExt> list = new List<CheckModelExt>(); if (ds.Tables[0].Rows.Count > 0) { CheckModelExt info = new CheckModelExt(); foreach (DataRow dr in ds.Tables[0].Rows) { info = new CheckModelExt(); info.ID = Convert.ToString(dr["ID"]); info.Name = dr["Name"].ToString(); list.Add(info); } } return list; }
public object GetCarState() { StringBuilder sb = new StringBuilder(); sb.Append(@" select 名称 into #temp from TZAmbulanceState where 是否有效=1 insert into #temp values('完成') insert into #temp values('未出车') select 名称 from #temp drop table #temp "); DataSet ds = (SqlHelper.ExecuteDataSet(SqlHelper.AttemperConnectionString, CommandType.Text, sb.ToString(), null)); List<CheckModelExt> list = new List<CheckModelExt>(); if (ds.Tables[0].Rows.Count > 0) { CheckModelExt info = new CheckModelExt(); foreach (DataRow dr in ds.Tables[0].Rows) { info = new CheckModelExt(); // info.ID = Convert.ToString(dr["编码"]); info.Name = dr["名称"].ToString(); list.Add(info); } } return list; }