/// <summary>
/// 根据查询语句获得住院流水号
/// </summary>
/// <param name="strSql"></param>
/// <returns></returns>
public ArrayList GetInpatientNoList(string strSql, Neusoft.HISFC.Models.HealthRecord.EnumServer.TablesName type)
{
ArrayList arrList = new ArrayList();
try
{
this.ExecQuery(strSql);
Neusoft.FrameWork.Models.NeuObject info = null;
while (this.Reader.Read())
{
info = new Neusoft.FrameWork.Models.NeuObject();
if (type == TablesName.BASE)
{
info.ID = this.Reader[0].ToString(); //住院流水号
info.User01 = this.Reader[1].ToString(); //住院号
}
else
{
info.ID = this.Reader[0].ToString();
}
arrList.Add(info);
}
this.Reader.Close();
}
catch (Exception ex)
{
if (!this.Reader.IsClosed)
{
this.Reader.Close();
}
this.Err = ex.Message;
arrList = null;
}
return(arrList);
}
/// <summary>
/// 获取查询的ｓｑｌ语句
/// </summary>
/// <param name="type"></param>
/// <returns></returns>
public string GetSelectSql(Neusoft.HISFC.Models.HealthRecord.EnumServer.TablesName type)
{
string strSql = "";
switch (type)
{
case TablesName.BASE:
if (this.Sql.GetSql("Case.SearchManager.GetSelectSql.BASE", ref strSql) == -1)
{
return(null);
}
break;
case TablesName.DIAG:
if (this.Sql.GetSql("Case.SearchManager.GetSelectSql.DIAG", ref strSql) == -1)
{
return(null);
}
break;
case TablesName.OPERATION:
if (this.Sql.GetSql("Case.SearchManager.GetSelectSql.OPERATION", ref strSql) == -1)
{
return(null);
}
break;
case TablesName.BASEANDDIAG:
if (this.Sql.GetSql("Case.SearchManager.GetSelectSql.BASEANDDIAG", ref strSql) == -1)
{
return(null);
}
break;
case TablesName.BASEANDOPERATION:
if (this.Sql.GetSql("Case.SearchManager.GetSelectSql.BASEANDOPERATION", ref strSql) == -1)
{
return(null);
}
break;
case TablesName.DIAGANDOPERATION:
if (this.Sql.GetSql("Case.SearchManager.GetSelectSql.DIAGANDOPERATION", ref strSql) == -1)
{
return(null);
}
break;
case TablesName.BASEANDDIAGANDOPERATION:
if (this.Sql.GetSql("Case.SearchManager.GetSelectSql.BASEANDDIAGANDOPERATION", ref strSql) == -1)
{
return(null);
}
break;
case TablesName.BASESUB: //非同一次入院 中根据住院流水号获取住院号 再查询住院号相同的住院流水号
if (this.Sql.GetSql("Case.SearchManager.GetSelectSql.BASESUB", ref strSql) == -1)
{
return(null);
}
break;
case TablesName.DIAGSINGLE: //单诊断
if (this.Sql.GetSql("Case.SearchManager.GetSelectSql.DIAGSINGLE", ref strSql) == -1)
{
return(null);
}
break;
case TablesName.OPERATIONSINGLE: //单手术
if (this.Sql.GetSql("Case.SearchManager.GetSelectSql.OPERATIONSINGLE", ref strSql) == -1)
{
return(null);
}
break;
}
return(strSql);
}
