/// <summary>
/// 插入 费用减免表 fin_com_derate 一条新的记录
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public int InsertDerate(Neusoft.HISFC.Models.Fee.Rate info)
{
string strSql = "";
//INSERT INTO FIN_COM_DERATE ( PARENT_CODE ,CURRENT_CODE,CLINIC_NO ,HAPPEN_NO ,DERATE_KIND ,RECIPE_NO ,SEQUENCE_NO ,DERATE_TYPE ,FEE_CODE, DERATE_COST,DERATE_CAUSE,CONFIRM_OPERCODE,CONFIRM_NAME,DEPT_CODE,OPER_CODE ,OPER_DATE ) VALUES ('[父级编码]','[本级编码]','{0}',(select max(happen_no)+1 from fin_com_derate where parent_code ='[父级编码]' and current_code ='[本级编码]'),'{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}',sysdate)
if (this.Sql.GetSql("Management.Fee.InsertDerate", ref strSql) == -1)
{
return(-1);
}
try
{
string OperCode = this.Operator.ID;
int sequenceNo = 0;
try
{
sequenceNo = Convert.ToInt32(info.sequenceNo);
}
catch (Exception)
{
sequenceNo = 0;
}
info.happenNo = GetHappenNO(info.clinicNo);
strSql = string.Format(strSql, info.clinicNo, info.happenNo, info.derateKind, info.recipeNo, sequenceNo, info.derateType, info.FeeCode, info.derate_Cost, info.derate_cause, info.confirmOpercode, info.confirmName, info.deptCode, info.balanceState, OperCode);
}
catch (Exception ee)
{
this.Err = ee.Message;
}
return(this.ExecNoQuery(strSql));
}
/// <summary>
/// 删除 费用减免表 fin_com_derate一条记录
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public int DeleteDerate(Neusoft.HISFC.Models.Fee.Rate info)
{
string strSql = "";
// DELETE FIN_COM_DERATE WHERE CLINIC_NO ='{0}',HAPPEN_NO ='{1}' and PARENT_CODE = '[父级编码]' and CURRENT_CODE ='[本级编码]'
if (this.Sql.GetSql("Management.Fee.DeleteDerate", ref strSql) == -1)
{
return(-1);
}
try
{
strSql = string.Format(strSql, info.clinicNo, info.happenNo);
}
catch (Exception ee)
{
this.Err = ee.Message;
}
return(this.ExecNoQuery(strSql));
}
/// <summary>
/// 更新 费用减免表 fin_com_derate 一条记录
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public int UpdateDerate(Neusoft.HISFC.Models.Fee.Rate info)
{
string strSql = "";
//UPDATE FIN_COM_DERATE SET DERATE_KIND = '{2}' ,RECIPE_NO ='{3}' ,SEQUENCE_NO='{4}',DERATE_TYPE ='{5}',FEE_CODE ='{6}',DERATE_COST ='{7}',CONFIRM_OPERCODE ='{8}', CONFIRM_NAME='{9}',DEPT_CODE ='{10}' ,OPER_CODE ='{11}',OPER_DATE = sysdate WHERE CLINIC_NO= '{0}' AND HAPPEN_NO ='{1}'AND PARENT_CODE = '[父级编码]' AND CURRENT_CODE ='[本级编码]'
if (this.Sql.GetSql("Management.Fee.UpdateDerate", ref strSql) == -1)
{
return(-1);
}
try
{
string OperCode = this.Operator.ID;
strSql = string.Format(strSql, info.clinicNo, info.happenNo, info.derateKind, info.recipeNo, info.sequenceNo, info.derateType, info.FeeCode, info.derate_Cost, info.confirmOpercode, info.confirmName, info.deptCode, OperCode);
}
catch (Exception ee)
{
this.Err = ee.Message;
}
return(this.ExecNoQuery(strSql));
}
/// <summary>
/// 根据住院流水号和结算序号查讯 费用减免记录
/// </summary>
/// <param name="Clinic"></param>
/// <param name="BalanceNo"></param>
/// <returns></returns>
public ArrayList GetDerateByClinicAndBalance(string Clinic, int BalanceNo)
{
ArrayList List = null;
string strSql = "";
//SELECT CLINIC_NO ,HAPPEN_NO,DERATE_KIND,RECIPE_NO,SEQUENCE_NO,DERATE_TYPE,FEE_CODE,DERATE_COST,DERATE_CAUSE,CONFIRM_OPERCODE,CONFIRM_NAME,DEPT_CODE ,BALANCE_NO ,BALANCE_STATE FROM FIN_COM_DERATE WHERE CLINIC_NO = '{0}' and BALANCE_NO = '{1}' and PARENT_CODE = '[父级编码]' and CURRENT_CODE ='[本级编码]'
if (this.Sql.GetSql("Management.Fee.GetDerateByClinicAndBalance", ref strSql) == -1)
{
return(null);
}
try
{
strSql = string.Format(strSql, Clinic, BalanceNo);
this.ExecQuery(strSql);
Neusoft.HISFC.Models.Fee.Rate info = null;
List = new ArrayList();
while (this.Reader.Read())
{
info = new Neusoft.HISFC.Models.Fee.Rate();
if (Reader[0] != DBNull.Value)
{
info.clinicNo = Reader[0].ToString(); //住院流水号
}
if (Reader[1] != DBNull.Value)
{
try
{
info.happenNo = Convert.ToInt32(Reader[1]); //发生序号
}
catch (Exception ee)
{
this.Err = ee.Message;
}
}
if (Reader[2] != DBNull.Value)
{
info.derateKind = Reader[2].ToString(); //减免种类
}
if (Reader[3] != DBNull.Value)
{
info.recipeNo = Reader[3].ToString(); //处方号
}
if (Reader[4] != DBNull.Value)
{
info.sequenceNo = Convert.ToInt32(Reader[4]); //处方内项目流水号
}
else
{
info.sequenceNo = 0;
}
if (Reader[5] != DBNull.Value)
{
info.derateType = Reader[5].ToString(); //减免类型
}
if (Reader[6] != DBNull.Value)
{
info.FeeCode = Reader[6].ToString(); //最小费用
}
if (Reader[7] != DBNull.Value)
{
try
{
info.derate_Cost = Convert.ToDecimal(Reader[7]); //减免金额
}
catch (Exception ee)
{
string Error = ee.Message;
}
}
//DERATE_COST,DERATE_CAUSE,CONFIRM_OPERCODE,CONFIRM_NAME,DEPT_CODE ,BALANCE_NO ,BALANCE_STATE,OPER_CODE,OPER_DATE
if (Reader[8] != DBNull.Value)
{
info.derate_cause = Reader[8].ToString(); //减免原因
}
if (Reader[9] != DBNull.Value)
{
info.confirmOpercode = Reader[9].ToString(); //批准人
}
if (Reader[10] != DBNull.Value)
{
info.confirmName = Reader[10].ToString(); // 批准人编码
}
if (Reader[11] != DBNull.Value)
{
info.deptCode = Reader[11].ToString(); // 科室
}
if (Reader[12] != DBNull.Value)
{
info.balanceState = Reader[12].ToString(); // 结算状态
}
if (Reader[13] != DBNull.Value)
{
info.opercode = Reader[13].ToString(); // 操作员
}
if (Reader[14] != DBNull.Value)
{
info.operdate = Convert.ToDateTime(Reader[14]); // 操作时间
}
List.Add(info);
info = null;
}
this.Reader.Close(); //关闭reader
}
catch (Exception ee)
{
this.Err = ee.Message;
List = null;
}
return(List);
}
