/// <summary>
/// B003 取消住院登记（扩展函数）cancelInpatientRegister
/// </summary>
/// <param name="rateType"></param>
/// <param name="insuranceNo"></param>
/// <returns></returns>
public virtual string cancelInpatientRegister(string rateType, string centerCodeEx, string insuranceNo)
{
string outParm;
using (OracleConnection dbCon = OracleConnect.Connect())
{
OracleTransaction dbTran = dbCon.BeginTransaction();
CreateDBTransaction(dbCon, dbTran);
try
{
RuralResiDAL ruralResiDal = new RuralResiDAL();
if (ruralResiDal.cancelInpatientRegister(rateType, centerCodeEx, insuranceNo, out outParm) < 0)
{
dbTran.Rollback();
return("error:" + outParm);
}
dbTran.Commit();
}
catch (Exception ex)
{
dbTran.Rollback();
return("error:" + ex.Message);
}
}
return("success:" + outParm);
}
public virtual string inpatientUpdate(string rateType, string centerCodeEx, string insuranceNo, string residenceNo, string diagnosisCode, string diagnosisCode2, string treatCode, string admissionDept, string admissionTime, string registType, string admissionCondition, string doctor, string bedNo, string ward, string turnCode)
{
string outParm;
using (OracleConnection dbCon = OracleConnect.Connect())
{
OracleTransaction dbTran = dbCon.BeginTransaction();
CreateDBTransaction(dbCon, dbTran);
try
{
RuralResiDAL ruralResiDal = new RuralResiDAL();
if (ruralResiDal.inpatientUpdate(rateType, centerCodeEx, insuranceNo, residenceNo, diagnosisCode,
diagnosisCode2, treatCode, admissionDept, admissionTime, registType,
admissionCondition, doctor, bedNo, ward, turnCode, out outParm) < 0)
{
dbTran.Rollback();
return("error:" + outParm);
}
dbTran.Commit();
}
catch (Exception ex)
{
dbTran.Rollback();
return("error:" + ex.Message);
}
}
return("success:" + outParm);
}
/// <summary>
/// B012 住院兑付（扩展函数）inpatientPay
/// </summary>
/// <param name="rateType"></param>
/// <param name="insuranceNo"></param>
/// <param name="redeemNo"></param>
/// <param name="phoneNo"></param>
/// <returns></returns>
public virtual string inpatientPay(string rateType, string centerCodeEx, string insuranceNo, string redeemNo, string phoneNo,
string obligateOne, string obligateTwo, string obligateThree,
string obligateFour, string obligateFive)
{
string outParm;
using (OracleConnection dbCon = OracleConnect.Connect())
{
OracleTransaction dbTran = dbCon.BeginTransaction();
CreateDBTransaction(dbCon, dbTran);
try
{
RuralResiDAL ruralResiDal = new RuralResiDAL();
if (ruralResiDal.inpatientPay(rateType, centerCodeEx, insuranceNo, redeemNo, phoneNo,
obligateOne, obligateTwo, obligateThree, obligateFour, obligateFive, out outParm) < 0)
{
dbTran.Rollback();
return("error:" + outParm);
}
dbTran.Commit();
}
catch (Exception ex)
{
dbTran.Rollback();
return("error:" + ex.Message);
}
}
return("success:" + outParm);
}
/// <summary>
/// B008 出院登记（扩展函数）leaveInpatientRegister
/// </summary>
/// <param name="rateType"></param>
/// <param name="insuranceNo"></param>
/// <param name="dischargeTime"></param>
/// <param name="outDept"></param>
/// <param name="diseaseStatus"></param>
/// <param name="diagnosisCode"></param>
/// <returns></returns>
public virtual string leaveInpatientRegister(string rateType, string centerCodeEx, string insuranceNo, string dischargeTime,
string outDept, string doctorName, string doctorId,
string diseaseStatus, string diagnosisCode, string treatCode, string turnCode)
{
string outParm;
using (OracleConnection dbCon = OracleConnect.Connect())
{
OracleTransaction dbTran = dbCon.BeginTransaction();
CreateDBTransaction(dbCon, dbTran);
try
{
RuralResiDAL ruralResiDal = new RuralResiDAL();
if (ruralResiDal.leaveInpatientRegister(rateType, centerCodeEx, insuranceNo, dischargeTime,
outDept, doctorName, doctorId,
diseaseStatus, diagnosisCode, treatCode, turnCode, out outParm) < 0)
{
dbTran.Rollback();
return("error:" + outParm);
}
dbTran.Commit();
}
catch (Exception ex)
{
dbTran.Rollback();
return("error:" + ex.Message);
}
}
return("success:" + outParm);
}
/// <summary>
/// B007 住院批量费用明细录入函数（扩展函数）uploadInpatientDetails
/// </summary>
/// <param name="rateType"></param>
/// <param name="sickId"></param>
/// <param name="residenceNo"></param>
/// <param name="rowCount"></param>
/// <param name="xmlDetails"></param>
/// <returns></returns>
public virtual string uploadInpatientDetails(string rateType, string centerCodeEx, string sickId, string residenceNo, string rowCount, string xmlDetails)
{
string outParm;
using (OracleConnection dbCon = OracleConnect.Connect())
{
OracleTransaction dbTran = dbCon.BeginTransaction();
CreateDBTransaction(dbCon, dbTran);
try
{
RuralResiDAL ruralResiDal = new RuralResiDAL();
if (ruralResiDal.uploadInpatientDetails(rateType, centerCodeEx, sickId, residenceNo, rowCount, xmlDetails, out outParm) < 0)
{
dbTran.Rollback();
return("error:" + outParm);
}
dbTran.Commit();
}
catch (Exception ex)
{
dbTran.Rollback();
return("error:" + ex.Message);
}
}
return("success:" + outParm);
}
/// <summary>
/// B005 住院费用明细录入函数inpDetailInput
/// </summary>
/// <param name="rateType"></param>
/// <param name="insuranceNo"></param>
/// <param name="applyNo"></param>
/// <param name="hiscode"></param>
/// <param name="insureId"></param>
/// <param name="classId"></param>
/// <param name="name"></param>
/// <param name="spec"></param>
/// <param name="unit"></param>
/// <param name="conf"></param>
/// <param name="price"></param>
/// <param name="quantity"></param>
/// <param name="money"></param>
/// <param name="factMoney"></param>
/// <param name="useDate"></param>
/// <returns></returns>
public virtual string inpDetailInput(string rateType, string centerCodeEx, string insuranceNo, string applyNo, string hiscode, string insureId, string classId, string name, string spec, string unit, string conf, string price, string quantity, string money, string factMoney, string useDate)
{
string outParm;
using (OracleConnection dbCon = OracleConnect.Connect())
{
OracleTransaction dbTran = dbCon.BeginTransaction();
CreateDBTransaction(dbCon, dbTran);
try
{
RuralResiDAL ruralResiDal = new RuralResiDAL();
if (ruralResiDal.inpDetailInput(rateType, centerCodeEx, insuranceNo, applyNo, hiscode, insureId,
classId, name, spec, unit, conf, price, quantity,
money, factMoney, useDate, out outParm) < 0)
{
dbTran.Rollback();
return("error:" + outParm);
}
dbTran.Commit();
}
catch (Exception ex)
{
dbTran.Rollback();
return("error:" + ex.Message);
}
}
return("success:" + outParm);
}
