/// <summary>
/// 非药品组套明细表
/// </summary>
/// <param name="packageCode"></param>
/// <returns></returns>
public ArrayList QueryUndrugPackagesBypackageCode(string packageCode)
{
ArrayList List = null;
string strSql = "";
if (this.Sql.GetSql("Fee.undrugzt.GetUndrugztinfo", ref strSql) == -1)
{
return(null);
}
try
{
if (packageCode != "")
{
List = new ArrayList();
// select package_code ,decode (substr(fee_code,1,1),'F',(select item_name from fin_com_undruginfo where parent_code = '[父级编码]' and current_code ='[本级编码]' and item_code =fin_com_undrugztinfo.ITEM_CODE),'Y', (select trade_name from pha_com_baseinfo t where parent_code = '[父级编码]' and current_code ='[本级编码]' and t.drug_code = fin_com_undrugztinfo.ITEM_CODE )) ,item_code ,sort_id from fin_com_undrugztinfo where package_code ='{0}'and parent_code = '[父级编码]' and current_code ='[本级编码]'
strSql = string.Format(strSql, packageCode);
this.ExecQuery(strSql);
Neusoft.HISFC.Object.Fee.Undrugztinfo info = null;
while (this.Reader.Read())
{
info = new Neusoft.HISFC.Object.Fee.Undrugztinfo();
info.ID = Reader[0].ToString(); //组套编码
info.itemName = Reader[1].ToString(); //非药品名称
info.itemCode = Reader[2].ToString(); //非药品编码
if (Reader[3] != DBNull.Value)
{
info.sortId = Convert.ToInt32(Reader[3]); //顺序号
}
else
{
info.sortId = 0;
}
info.SpellCode = Reader[4].ToString(); //取拼音码
info.WbCode = Reader[5].ToString(); //取五笔码
info.InputCode = Reader[6].ToString(); //输入码
info.User01 = Reader[7].ToString(); //标志
info.User02 = Reader[8].ToString(); // 是否特殊医疗项目 0 否 1 是
info.Qty = Neusoft.NFC.Function.NConvert.ToDecimal(Reader[9].ToString()); //数量
List.Add(info);
info = null;
}
this.Reader.Close();
}
}
catch (Exception ee)
{
this.Err = ee.Message;
List = null;
}
return(List);
}
/// <summary>
/// 删除一条新的记录
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public int DeleteUndrugztinfo(Neusoft.HISFC.Object.Fee.Undrugztinfo info)
{
string strSql = "";
if (this.Sql.GetSql("Fee.undrugzt.DeleteUndrugztinfo", ref strSql) == -1)
{
return(-1);
}
try
{
// delete fin_com_undrugztinfo where PACKAGE_CODE = '{0}' and ITEM_CODE ='{1}' and parent_code = '[父级编码]' and current_code ='[本级编码]'
strSql = string.Format(strSql, info.ID, info.itemCode);
}
catch (Exception ee)
{
this.Err = ee.Message;
return(-1);
}
return(this.ExecNoQuery(strSql));
}
/// <summary>
/// 更新一条记录
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public int UpdateUndrugztinfo(Neusoft.HISFC.Object.Fee.Undrugztinfo info)
{
string strSql = "";
if (this.Sql.GetSql("Fee.undrugzt.UpdateUndrugztinfo", ref strSql) == -1)
{
return(-1);
}
try
{
// update fin_com_undrugztinfo set SORT_ID='{2}' where PACKAGE_CODE ='{0}'and ITEM_CODE ='{1}' and parent_code = '[父级编码]' and current_code ='[本级编码]'
strSql = string.Format(strSql, info.ID, info.itemCode, info.sortId, info.SpellCode, info.WbCode, info.InputCode, info.User01, info.Qty);
}
catch (Exception ee)
{
this.Err = ee.Message;
return(-1);
}
return(this.ExecNoQuery(strSql));
}
/// <summary>
/// 插入一条新的记录
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public int InsertUndruaztinfo(Neusoft.HISFC.Object.Fee.Undrugztinfo info)
{
string strSql = "";
if (this.Sql.GetSql("Fee.undrugzt.InsertUndruaztinfo", ref strSql) == -1)
{
return(-1);
}
try
{
string OperId = this.Operator.ID;
// insert into fin_com_undrugztinfo (PACKAGE_CODE,ITEM_CODE,SORT_ID,OPER_CODE,OPER_DATE) values ('{0},'{1}','{2}','{3}',sysdate)
strSql = string.Format(strSql, info.ID, info.itemCode, info.sortId, OperId, info.SpellCode, info.WbCode, info.InputCode, info.User01, info.Qty);
}
catch (Exception ee)
{
this.Err = ee.Message;
return(-1);
}
return(this.ExecNoQuery(strSql));
}
