/// <summary>
/// 删除优惠套餐表的数据
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public int DeleteEcoformula(Neusoft.HISFC.Models.Fee.Useless.EcoFormula info)
{
string strSql = "";
// delete fin_com_ecoformula where ECO_FLAG ='{0}' and CLINIC_CODE ='{1}' and CARD_NO ='{2}' and PARENT_CODE = '[父级编码]' and CURRENT_CODE ='[本级编码]'
if (this.Sql.GetSql("Management.Fee.DeleteEcoformula", ref strSql) == -1)
{
return(-1);
}
try
{
strSql = string.Format(strSql, info.EcoFlag, info.ClinicCode);
}
catch (Exception ee)
{
this.Err = ee.Message;
return(-1);
}
return(this.ExecNoQuery(strSql));
}
/// <summary>
/// 更新优惠套餐表的数据
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public int UpdateEcoformula(Neusoft.HISFC.Models.Fee.Useless.EcoFormula info)
{
string strSql = "";
//update fin_com_ecoformula set PACTCODE_FLAG= '{2}' ,ICDCODE_FLAG='{3}' ,DATE_FLAG='{4}',ECOREAL_FLAG='{5}',SPECIL_FORMULA='{6}' where ECO_FLAG= '{0}' and CLINIC_CODE='{1}'and PARENT_CODE = '[父级编码]' and CURRENT_CODE ='[本级编码]'
if (this.Sql.GetSql("Management.Fee.UpdateEcoformula", ref strSql) == -1)
{
return(-1);
}
try
{
strSql = string.Format(strSql, info.EcoFlag, info.ClinicCode, info.PactcodeFlag, info.IcdcodeFlag, info.DateFlag, info.EcorealFlag);
}
catch (Exception ee)
{
this.Err = ee.Message;
return(-1);
}
return(this.ExecNoQuery(strSql));
}
/// <summary>
/// 插入 优惠套餐表的数据
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public int InsertEcoformula(Neusoft.HISFC.Models.Fee.Useless.EcoFormula info)
{
string strSql = "";
//insert into fin_com_ecoformula (PARENT_CODE,CURRENT_CODE,ECO_FLAG ,CLINIC_CODE ,PACTCODE_FLAG ,ICDCODE_FLAG,DATE_FLAG ,ECOREAL_FLAG,OPER_CODE,OPER_DATE ) values('[父级编码]','[本级编码]','{0}','{1}','{2}','{3}','{4}','{5}','{6}',,sysdate)
if (this.Sql.GetSql("Management.Fee.InsertEcoformula", ref strSql) == -1)
{
return(-1);
}
try
{
string OperCode = this.Operator.ID;
strSql = string.Format(strSql, info.EcoFlag, info.ClinicCode, info.PactcodeFlag, info.IcdcodeFlag, info.DateFlag, info.EcorealFlag, OperCode);
}
catch (Exception ee)
{
this.Err = ee.Message;
return(-1);
}
return(this.ExecNoQuery(strSql));
}
// ECO_FLAG VARCHAR2(1) 优惠准则标志 0 对人 1 对就诊记录
// CLINIC_CODE VARCHAR2(14) 'AAAA' 就诊记录
// CARD_NO VARCHAR2(10) 就诊卡号
// PACTCODE_FLAG VARCHAR2(1) Y 合同单位
// ICDCODE_FLAG VARCHAR2(1) Y 单病种标志
// DATE_FLAG VARCHAR2(1) Y 时段标志
// ECOREAL_FLAG VARCHAR2(1) Y 优惠原则关系 0 取最大优惠 1 取并优惠
// SPECIL_FORMULA VARCHAR2(2000) Y 特殊规则公式
/// <summary>
/// 查询优惠套餐表的数据
/// </summary>
/// <param name="ecoflag"></param>
/// <param name="clinic"></param>
/// <returns></returns>
public ArrayList GetEcoformulaInfo(string ecoflag, string clinic)
{
ArrayList List = new ArrayList();
string strSql = "";
//select ECO_FLAG ,CLINIC_CODE ,PACTCODE_FLAG ,ICDCODE_FLAG,DATE_FLAG ,ECOREAL_FLAG from fin_com_ecoformula where PARENT_CODE = '[父级编码]' and CURRENT_CODE ='[本级编码]' and ECO_FLAG ='{0}' and CLINIC_CODE = '{1}'
if (this.Sql.GetSql("Management.Fee.GetEcoformulaInfo", ref strSql) == -1)
{
return(null);
}
try
{
Neusoft.HISFC.Models.Fee.Useless.EcoFormula info;
strSql = string.Format(strSql, ecoflag, clinic);
this.ExecQuery(strSql);
while (this.Reader.Read())
{
info = new Neusoft.HISFC.Models.Fee.Useless.EcoFormula();
info.EcoFlag = Reader[0].ToString();
info.ClinicCode = Reader[1].ToString();
info.PactcodeFlag = Reader[2].ToString();
info.IcdcodeFlag = Reader[3].ToString();
info.DateFlag = Reader[4].ToString();
info.EcorealFlag = Reader[5].ToString();
List.Add(info);
info = null;
}
this.Reader.Close();
}
catch (Exception ee)
{
this.Err = ee.Message;
List = null;
}
return(List);
}
