/// <summary>
///
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public bool UpdateOrInsertChangeCost(Neusoft.HISFC.Models.Fee.TransferFee info)
{
bool Result = true;;
int temp = 0;
temp = IsAlreadyInChangeCost(info.MinFee.ID, info.Type.ID, info.ID);
if (temp > 0)
{
//更新
if (UpdateChangeCost(info) <= 0)
{
Result = false; //更新失败
}
}
else if (temp == 0)
{
//插入
if (InsertChangeCost(info) <= 0)
{
Result = false; //插入失败
}
}
else
{
//出错了。
Result = false;
}
return(Result);
}
/// <summary>
///
/// </summary>
/// <param name="ClinicNo"></param>
/// <returns></returns>
public Neusoft.HISFC.Models.Fee.TransferFee SumTotCost(string ClinicNo)
{
Neusoft.HISFC.Models.Fee.TransferFee cost = null;
string strSql = "";
//select sum( TOT_COST ),sum(OWN_COST),sum(PAY_COST),sum(PUB_COST),sum(ECO_COST) from fin_com_changecost where clinic_no ='{0}' and change_code ='[本级编码]' and PARENT_CODE ='[父级编码]' and CURRENT_CODE ='[本级编码]'AND BALANCE_STATE ='0'
if (this.Sql.GetSql("Fee.TransferFee.SumTotCost", ref strSql) == -1)
{
return(null);
}
try
{
strSql = string.Format(strSql, ClinicNo);
this.ExecQuery(strSql);
while (this.Reader.Read())
{
cost = new Neusoft.HISFC.Models.Fee.TransferFee();
if (Reader[0] != DBNull.Value)
{
cost.FT.TotCost = Convert.ToDecimal(Reader[0]);
}
if (Reader[1] != DBNull.Value)
{
cost.FT.OwnCost = Convert.ToDecimal(Reader[1]);
}
if (Reader[2] != DBNull.Value)
{
cost.FT.PayCost = Convert.ToDecimal(Reader[2]);
}
if (Reader[3] != DBNull.Value)
{
cost.FT.PubCost = Convert.ToDecimal(Reader[3]);
}
if (Reader[4] != DBNull.Value)
{
cost.FT.RebateCost = Convert.ToDecimal(Reader[4]);
}
}
}
catch (Exception ee)
{
this.Err = ee.Message;
}
return(cost);
}
/// <summary>
///
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public int DeleteChangeCost(Neusoft.HISFC.Models.Fee.TransferFee info)
{
string strSql = "";
if (this.Sql.GetSql("Fee.TransferFee.DeleteChangeCost", ref strSql) == -1)
{
return(-1);
}
try
{
string OperCode = this.Operator.ID;
//DELETE FIN_COM_CHANGECOST WHERE CHANGE_CODE ='[本级编码]' AND FEE_CODE ='{0}' AND CLINIC_NO ='{1}'AND parent_code = '[父级编码]' AND current_code ='[本级编码]'
strSql = string.Format(strSql, info.MinFee.ID, info.ID);
}
catch (Exception ee)
{
string Error = ee.Message;
}
return(this.ExecNoQuery(strSql));
}
/// <summary>
///
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public int InsertChangeCost(Neusoft.HISFC.Models.Fee.TransferFee info)
{
string strSql = "";
if (this.Sql.GetSql("Fee.TransferFee.InsertChangeCost", ref strSql) == -1)
{
return(-1);
}
try
{
string OperCode = this.Operator.ID;
//insert into fin_com_changecost values ('[父级编码]', '[本级编码]', '[本级编码]', '{0}', '{1}', '{2}', '{3}','{4}', '{5}', {6}, {7}, {8}, {9}, {10}, '{11}', SYSDATE,'','{12}','{13}', SYSDATE)
strSql = string.Format(strSql, info.MinFee.ID, info.Type.ID, info.ID, info.Name, info.Pact.PayKind.ID, info.Pact.ID, info.FT.TotCost, info.FT.OwnCost, info.FT.PayCost, info.FT.PubCost, info.FT.RebateCost, OperCode, info.BalanceState, OperCode);
}
catch (Exception ee)
{
string Error = ee.Message;
}
return(this.ExecNoQuery(strSql));
}
/// <summary>
///
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public int UpdateChangeCost(Neusoft.HISFC.Models.Fee.TransferFee info)
{
string strSql = "";
if (this.Sql.GetSql("Fee.TransferFee.UpdateChangeCost", ref strSql) == -1)
{
return(-1);
}
try
{
string OperCode = this.Operator.ID;
//update fin_com_changecost set tot_cost ={0}, own_cost ={1}, pay_cost ={2}, pub_cost ={3},eco_cost ={4} where clinic_no ='{5}' and change_type ='{6}' and fee_code ='{7}'and CHANGE_CODE ='[本级编码]' AND parent_code = '[父级编码]' AND current_code ='[本级编码]'
strSql = string.Format(strSql, info.FT.TotCost, info.FT.OwnCost, info.FT.PayCost, info.FT.PubCost, info.FT.RebateCost, info.ID, info.Type.ID, info.MinFee.ID);
}
catch (Exception ee)
{
string Error = ee.Message;
return(-1);
}
return(this.ExecNoQuery(strSql));
}
// CHANGE_CODE VARCHAR2(14) 'ROOT' 转入医疗机构编码
// FEE_CODE VARCHAR2(3) 最小费用代码 如果为 all 话为全部费用
// CHANGE_TYPE VARCHAR2(1) 转入类型,1 门诊转入，2 住院转入 3 分院转入
// CLINIC_NO VARCHAR2(14) 医疗流水号
/// <summary>
///
/// </summary>
/// <param name="changeType"></param>
/// <param name="ClinicNo"></param>
/// <returns></returns>
public ArrayList GetChangeCost(string changeType, string ClinicNo)
{
ArrayList List = null;
string strSql = "";
//SELECT TOT_COST,OWN_COST,PAY_COST,PUB_COST,ECO_COST ,CHANGE_TYPE ,FEE_CODE FROM FIN_COM_CHANGECOST WHERE PARENT_CODE ='[父级编码]' and CURRENT_CODE ='[本级编码]'AND change_code ='[本级编码]' AND CLINIC_NO ='{0}' AND CHANGE_TYPE ='{1}';
Neusoft.HISFC.Models.Fee.TransferFee cost = null;
if (this.Sql.GetSql("Management.Fee.GetChangeCost", ref strSql) == -1)
{
return(null);
}
try
{
strSql = string.Format(strSql, ClinicNo, changeType);
this.ExecQuery(strSql);
List = new ArrayList();
while (this.Reader.Read())
{
cost = new Neusoft.HISFC.Models.Fee.TransferFee();
try
{
cost.FT.TotCost = Convert.ToDecimal(Reader[0]);
}
catch (Exception) { cost.FT.TotCost = 0; }
try
{
cost.FT.OwnCost = Convert.ToDecimal(Reader[1]);
}
catch (Exception) { cost.FT.OwnCost = 0; }
try
{
cost.FT.PayCost = Convert.ToDecimal(Reader[2]);
}
catch (Exception) { cost.FT.PayCost = 0; }
try
{
cost.FT.PubCost = Convert.ToDecimal(Reader[3]);
}
catch (Exception) { cost.FT.PubCost = 0; }
try
{
cost.FT.RebateCost = Convert.ToDecimal(Reader[4]);
}
catch (Exception) { cost.FT.RebateCost = 0; }
try
{
cost.Type.ID = Reader[5].ToString();
}
catch (Exception ee) { string Error = ee.Message; }
try
{
cost.MinFee.ID = Reader[6].ToString();
}
catch (Exception ee) { string Error = ee.Message; }
List.Add(cost);
cost = null;
}
}
catch (Exception ee)
{
this.Err = ee.Message;
}
return(List);
}
