/// <summary>
/// 获得医保非药品项目列表
/// </summary>
/// <returns></returns>
public ArrayList GetSIUndrugList()
{
string sql = "select item_code ," + "'F" + "'" + " as sys_class, item_name,STAT_TYPE as fee_code, " +
"MT_FLAG as ITEM_TYPE, SELF_SCALE from view_item";
if (this.ExecQuery(sql) == -1)
{
this.ErrCode = "-1";
this.Err = "查询医保非药品目录失败!";
return(null);
}
if (!Reader.HasRows)
{
this.ErrCode = "-1";
this.Err = "没有非药品信息";
return(null);
}
ArrayList al = new ArrayList();
Neusoft.HISFC.Models.SIInterface.Item item = null;
// Neusoft.HISFC.Models.Base.SpellCode sp = null;
// Neusoft.HISFC.Management.Manager.Spell spell = new Neusoft.HISFC.Management.Manager.Spell();
try
{
while (Reader.Read())
{
item = new Neusoft.HISFC.Models.SIInterface.Item();
item.ID = Reader[0].ToString();
item.SysClass = Reader[1].ToString();
item.Name = Reader[2].ToString();
// sp = (Neusoft.HISFC.Models.Base.SpellCode)spell.Get(item.Name);
// if(sp != null)
// {
// item.SpellCode = sp.SpellCode.Length > 9 ? sp.SpellCode.Substring(0,10) : sp.SpellCode;
// }
item.FeeCode = Reader[3].ToString();
item.ItemType = Reader[4].ToString();
item.Rate = Neusoft.FrameWork.Function.NConvert.ToDecimal(Reader[5].ToString());
if (item.Rate == 0)
{
item.ItemGrade = "1";
}
else if (item.Rate == 1)
{
item.ItemGrade = "3";
}
else
{
item.ItemGrade = "2";
}
al.Add(item);
}
Reader.Close();
return(al);
}
catch (Exception ex)
{
this.Err = ex.Message;
if (!Reader.IsClosed)
{
Reader.Close();
}
return(null);
}
}
/// <summary>
/// 获得医保药品项目列表
/// </summary>
/// <returns></returns>
public ArrayList GetSIDrugList()
{
string sql = "select MEDI_CODE,MEDI_ITEM_TYPE,MEDI_NAME,MODEL,CODE_PY,STAT_TYPE,MT_FLAG,STAPLE_FLAG,isnull(SELF_SCALE,0) "
+ "from view_medi" +
" where VALID_FLAG = '1'";
if (this.ExecQuery(sql) == -1)
{
this.ErrCode = "-1";
this.Err = "查询医保药品目录失败!";
return(null);
}
if (!Reader.HasRows)
{
this.ErrCode = "-1";
this.Err = "没有药品信息";
return(null);
}
ArrayList al = new ArrayList();
Neusoft.HISFC.Models.SIInterface.Item item = null;
string sysClass = "";
try
{
while (Reader.Read())
{
item = new Neusoft.HISFC.Models.SIInterface.Item();
item.ID = Reader[0].ToString();
if (Reader[1].ToString() == "1")
{
sysClass = "X";
}
else
{
sysClass = "Z";
}
item.SysClass = sysClass;
item.Name = Reader[2].ToString();
item.DoseCode = Reader[3].ToString();
item.SpellCode = (Reader[4].ToString()).Length > 9 ? (Reader[4].ToString()).Substring(0, 10): Reader[4].ToString();
item.FeeCode = Reader[5].ToString();
item.ItemType = Reader[6].ToString();
item.ItemGrade = Reader[7].ToString();
if (item.ItemGrade == "9")
{
item.ItemGrade = "3";
}
item.Rate = Neusoft.FrameWork.Function.NConvert.ToDecimal(Reader[8].ToString());
al.Add(item);
}
Reader.Close();
return(al);
}
catch (Exception ex)
{
this.Err = ex.Message;
if (!Reader.IsClosed)
{
Reader.Close();
}
return(null);
}
}
