//获取医生
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;
}
