/// <summary>
/// A003 补偿类别字典下载redeemTypeDownLoad
/// </summary>
/// <param name="rateType"></param>
/// <returns></returns>
public virtual string redeemTypeDownLoad(string rateType)
{
string outParm;
using (OracleConnection dbCon = OracleConnect.Connect())
{
OracleTransaction dbTran = dbCon.BeginTransaction();
CreateDBTransaction(dbCon, dbTran);
try
{
BasicInformationDAL basicInfoDAL = new BasicInformationDAL();
if (basicInfoDAL.redeemTypeDownLoad(rateType, out outParm) < 0)
{
dbTran.Rollback();
return("error:" + outParm);
}
dbTran.Commit();
}
catch (Exception ex)
{
dbTran.Rollback();
throw ex;
}
}
return("success:" + outParm);
}
/// <summary>
/// A113 获取病人信息函数 getPersonInfo_New
/// </summary>
/// <param name="rateType"></param>
/// <param name="outParm"></param>
/// <returns></returns>
public virtual string getPersonInfo_New(string rateType, string centerCode, string cardNo)
{
string outParm;
using (OracleConnection dbCon = OracleConnect.Connect())
{
OracleTransaction dbTran = dbCon.BeginTransaction();
CreateDBTransaction(dbCon, dbTran);
try
{
BasicInformationDAL basicInfoDAL = new BasicInformationDAL();
if (basicInfoDAL.getPersonInfo_New(rateType, centerCode, cardNo, out outParm) < 0)
{
dbTran.Rollback();
return("error:" + outParm);
}
dbTran.Commit();
}
catch (Exception ex)
{
dbTran.Rollback();
throw ex;
}
}
return("success:" + outParm);
}
/// <summary>
/// A008 转诊单信息查询 downloadReferralsheet
/// </summary>
/// <param name="rateType"></param>
/// <param name="operateType"></param>
/// <param name="turnCode"></param>
/// <param name="safetyNo"></param>
/// <returns></returns>
public virtual string downloadReferralsheet(string rateType, string inoutType, string turnCode, string safetyNo)
{
string outParm;
using (OracleConnection dbCon = OracleConnect.Connect())
{
OracleTransaction dbTran = dbCon.BeginTransaction();
CreateDBTransaction(dbCon, dbTran);
try
{
BasicInformationDAL basicInfoDAL = new BasicInformationDAL();
if (basicInfoDAL.downloadReferralsheet(rateType, inoutType, turnCode, safetyNo, out outParm) < 0)
{
dbTran.Rollback();
return("error:" + outParm);
}
dbTran.Commit();
}
catch (Exception ex)
{
dbTran.Rollback();
throw ex;
}
}
return("success:" + outParm);
}
/// <summary>
/// A102 药品匹配数据审核状态查询 matchSeek
/// </summary>
/// <param name="rateType"></param>
/// <param name="outParm"></param>
/// <returns></returns>
public virtual string matchSeek(string rateType, string insurancePriceItemCode, string itemCode)
{
string outParm;
using (OracleConnection dbCon = OracleConnect.Connect())
{
OracleTransaction dbTran = dbCon.BeginTransaction();
CreateDBTransaction(dbCon, dbTran);
try
{
BasicInformationDAL basicInfoDAL = new BasicInformationDAL();
if (basicInfoDAL.matchSeek(rateType, insurancePriceItemCode, itemCode, out outParm) < 0)
{
dbTran.Rollback();
return("error:" + outParm);
}
dbTran.Commit();
}
catch (Exception ex)
{
dbTran.Rollback();
throw ex;
}
}
return("success:" + outParm);
}
/// <summary>
/// A006 上传/修改转诊单信息 uploadReferralsheet
/// </summary>
/// <param name="rateType"></param>
/// <param name="infoType"></param>
/// <param name="turnCode"></param>
/// <param name="safetyNo"></param>
/// <param name="idCardNo"></param>
/// <param name="sickName"></param>
/// <param name="birthday"></param>
/// <param name="insurCardNo"></param>
/// <param name="turnType"></param>
/// <param name="icdCode"></param>
/// <param name="icdName"></param>
/// <param name="beginDate"></param>
/// <param name="cityType"></param>
/// <param name="remark"></param>
/// <returns></returns>
public virtual string uploadReferralsheet(string rateType, string infoType, string turnCode, string safetyNo,
string idCardNo, string sickName, string sexName, string birthday, string insurCardNo,
string phoneNo, string turnType, string icdCode, string icdName, string beginDate,
string fromHospCode, string fromHospName, string toHospCode, string toHospName,
string cityType, string toHospLevel,
string remark)
{
string outParm;
using (OracleConnection dbCon = OracleConnect.Connect())
{
OracleTransaction dbTran = dbCon.BeginTransaction();
CreateDBTransaction(dbCon, dbTran);
try
{
BasicInformationDAL basicInfoDAL = new BasicInformationDAL();
if (basicInfoDAL.uploadReferralsheet(rateType, infoType, turnCode, safetyNo, idCardNo, sickName,
sexName, birthday, insurCardNo, phoneNo, turnType, icdCode, icdName, beginDate,
fromHospCode, fromHospName, toHospCode, toHospName, cityType, toHospLevel,
remark, out outParm) < 0)
{
dbTran.Rollback();
return("error:" + outParm);
}
dbTran.Commit();
}
catch (Exception ex)
{
dbTran.Rollback();
throw ex;
}
}
return("success:" + outParm);
}
