//获取总金额
private decimal GetZyTotalMoney(int _ID, int _HospitalID, AsynDbHelper dbhelper)
{
string strsql = @"SELECT SUM(TotalPrice) TotalPrice FROM hisdb..Data_InPatientCost WHERE PatientID=" + _ID;
return(GreatRHIS.BLL.Admin.Tools.ToDecimal(dbhelper.ExecuteScalar(strsql)));
}
//获取医保报销金额
private decimal GetPolicyMoney(int _ID, int _HospitalID, AsynDbHelper dbhelper)
{
//System.Threading.Thread.Sleep(1000);
return(0);
}
//获取预交金
private decimal GetZyPrepaidMoney(int _ID, int _HospitalID, AsynDbHelper dbhelper)
{
string strsql = @"SELECT SUM(CostMoney) CostMoney FROM hisdb..Data_PayWayCost WHERE PatientID=" + _ID;
return(GreatRHIS.BLL.Admin.Tools.ToDecimal(dbhelper.ExecuteScalar(strsql)));
}