protected ArrayList _execConditionSelect(string sql)
{
if (this.ExecQuery(sql) == -1)
{
return(null);
}
ArrayList al = new ArrayList();
while (this.Reader.Read())
{
try
{
Neusoft.HISFC.Models.EPR.QCConditions qc = new Neusoft.HISFC.Models.EPR.QCConditions();
qc.ID = this.Reader[0].ToString();
qc.Name = this.Reader[1].ToString();
qc.Memo = this.Reader[2].ToString();
qc.Conditions = this.Reader[3].ToString();
qc.Acion.Name = this.Reader[4].ToString();
qc.User01 = this.Reader[5].ToString();
qc.User02 = this.Reader[6].ToString();
al.Add(qc);
}
catch (Exception ex) {
this.Err = ex.Message;
this.WriteErr();
return(null);
}
}
this.Reader.Close();
return(al);
}
public ucQCRuleSet(Neusoft.HISFC.Models.EPR.QCConditions conditions)
{
// 该调用是 Windows.Forms 窗体设计器所必需的。
InitializeComponent();
this.conditions = conditions;
// TODO: 在 InitializeComponent 调用后添加任何初始化
}
/// <summary>
/// 更新质量控制条件信息
/// </summary>
/// <param name="qc"></param>
/// <returns></returns>
public int UpdateQCCondition(Neusoft.HISFC.Models.EPR.QCConditions qc)
{
string strSql = "";
if (this.Sql.GetSql("EPR.QC.UpdateQCCondition", ref strSql) == -1)
{
return(-1);
}
return(this.ExecNoQuery(strSql, qc.ID, qc.Name, qc.Memo, qc.Conditions, qc.Acion.Name, this.Operator.ID));
}
QC QCManager = new QC(); //质控病历管理层
//private ArrayList alConditions =null; //条件
/// <summary>
/// 执行质控信息 -
/// </summary>
/// <param name="inpatientNo"></param>
/// <param name="iSql"></param>
/// <param name="QC"></param>
/// <returns></returns>
public bool ExecQCInfo(string inpatientNo, Neusoft.FrameWork.Management.Interface iSql, Neusoft.HISFC.Models.EPR.QCConditions QC)
{
int i = 0;
if (myInpatientNo != inpatientNo) //没有变更患者不更新患者的信息
{
myInpatientNo = inpatientNo;
//更新常用变量
i = iSql.GetPosition("[HIS_INPATIENT_NO]");
if (i == -1)
{
this.Err = "没有找到[HIS_INPATIENT_NO]";
return(false);
}
iSql.SetValue("[HIS_INPATIENT_NO]", inpatientNo);
iSql.RefreshVariant(Neusoft.FrameWork.Models.NeuInfo.infoType.Temp, i);
}
ArrayList alInputs = this.QCManager.GetQCInputCondition(inpatientNo); //输入数值
for (i = 0; i < QC.AlConditions.Count; i++) //查找每条质控条件-编写
{
Neusoft.HISFC.Models.EPR.QCCondition condition = QC.AlConditions[i] as Neusoft.HISFC.Models.EPR.QCCondition; //条件
if (condition == null || condition.InfoName == "" || condition.InfoCondition == "")
{
this.Err = "质控基础数据有问题！";
this.WriteErr();
return(false);
}
// "若输入 \'信息\'，符合\'条件\'", 0
// "若HIS\'信息\'，符合\'条件\'", 1
// "若病历 \'名称\'，已经\'建立\'", 2
// "若病历-\'名称\'，已经\'签名\'", 3
// "若病历+\'名称\'，建立时间,不在\'时间\'内", 4
// "若控件 \'名称\'，符合\'条件\'" 5
string sTemp = condition.InfoName + " " + condition.InfoCondition;
Neusoft.FrameWork.Management.Caculation caculation = new Neusoft.FrameWork.Management.Caculation();
bool bResult = false;
Neusoft.HISFC.Models.EPR.QC data = null;
bool bOld = false;
bool bNew = false;
string a = "", b = "";
ArrayList al = null;
switch (condition.ID)
{
case "0": //输入的控件结点
//a = EMRManager.GetNodeValue("datastore_emr",inpatientNo,condition.InfoName);
#region 输入控件节点
a = "-1";
foreach (Neusoft.FrameWork.Models.NeuObject obj in alInputs)
{
if (obj.Name.Trim() == condition.InfoName.Trim())
{
a = obj.User01;
break;
}
}
if (a == "-1" || a == "")
{
a = "";
}
sTemp = a + " " + condition.InfoCondition;
if (condition.InfoCondition.ToLower() == "true") //只是有数值
{
if (a.Trim() != "")
{
bResult = true;
}
else
{
bResult = false;
}
}
else
{
sTemp = iSql.TransSql(sTemp);
bResult = caculation._condition(sTemp);
}
#endregion
break;
case "1": //his
sTemp = iSql.TransSql(sTemp);
bResult = caculation._condition(sTemp);
break;
case "2": //病历 建立
al = QCManager.GetQCData(inpatientNo, condition.InfoName);
if (condition.InfoCondition == "建立" || condition.InfoCondition.ToUpper() == "TRUE")
{
bNew = true;
}
if (al != null && al.Count > 0)
{
data = al[0] as Neusoft.HISFC.Models.EPR.QC;
if (data != null)
{
if (data.QCData.Creater.ID == "")
{
bOld = false;
}
else
{
bOld = true;
}
sTemp = data.QCData.Saver.ID;
}
else
{
bOld = false;
}
}
else
{
bOld = false;
}
if (bNew == bOld)
{
bResult = true;
}
else
{
bResult = false;
}
sTemp = sTemp + bOld.ToString() + "&" + bNew.ToString();
break;
case "3": //病历 签名
al = QCManager.GetQCData(inpatientNo, condition.InfoName);
if (condition.InfoCondition == "签名" || condition.InfoCondition.ToUpper() == "TRUE")
{
bNew = true;
}
if (al != null && al.Count > 0)
{
data = al[0] as Neusoft.HISFC.Models.EPR.QC;
if (data != null)
{
if (data.QCData.Saver.ID == "")
{
bOld = false;
}
else
{
bOld = true;
}
sTemp = data.QCData.Saver.ID;
}
else
{
bOld = false;
}
}
else
{
bOld = false;
}
if (bNew == bOld)
{
bResult = true;
}
else
{
bResult = false;
}
sTemp = sTemp + bOld.ToString() + "&" + bNew.ToString();
break;
case "4": //病历建立时间
al = QCManager.GetQCData(inpatientNo, condition.InfoName);
sTemp = "{0} - {1} <= {2}";
string[] sconditions = condition.InfoCondition.Split(',');
if (al == null)
{
return(false);
}
//病程记录等需要连续记录的
if (sconditions.Length > 1)
{
for (int iCondtitions = 0; iCondtitions < sconditions.Length; iCondtitions++)
{
foreach (Neusoft.HISFC.Models.EPR.QC data1 in al)
{
if (data1 != null)
{
sTemp = string.Format(sTemp, data1.QCData.Creater.Memo, caculation.f_cal(sconditions[iCondtitions]), 24);
sTemp = iSql.TransSql(sTemp);
bResult = caculation._condition(sTemp);
if (bResult) //成功
{
break;
}
}
else
{
bResult = false;
}
}
if (bResult == false)
{
break;
}
}
}
else //时间在上一个条件内
{
if (i >= 1)
{
sTemp = "{0} - {1} <= {2}";
//a = EMRManager.GetNodeValue(DataStoreEMR, inpatientNo, ((Neusoft.HISFC.Models.EPR.QCCondition)QC.AlConditions[i - 1]).InfoName);
//b = EMRManager.GetNodeValue(DataStoreEMR, inpatientNo, condition.InfoName);
if (a == "-1")
{
a = "";
}
if (b == "-1")
{
b = "";
}
sTemp = string.Format(sTemp, a, b, condition.InfoCondition);
bResult = caculation._condition(sTemp);
}
else
{
sTemp = "[NOW] - {0} <= {1}";
//a = EMRManager.GetNodeValue(DataStoreEMR, inpatientNo, condition.InfoName);
if (a == "-1")
{
a = "";
}
a = a + condition.InfoCondition;
sTemp = string.Format(sTemp, a, condition.InfoCondition);
bResult = caculation._condition(sTemp);
}
}
break;
case "5": //控件结点符合
//a = EMRManager.GetNodeValue(DataStoreEMR, inpatientNo, condition.InfoName);
if (a == "-1")
{
a = "";
}
sTemp = a + condition.InfoCondition;
bResult = caculation._condition(sTemp);
break;
default:
break;
}
if (bResult == false)
{
condition.Memo = sTemp + "结果：" + bResult;
return(false);
}
condition.Memo = sTemp + "结果：" + bResult;
}
return(true);
}
/// <summary>
/// 更新质量控制条件信息
/// </summary>
/// <param name="qc"></param>
/// <returns></returns>
public int UpdateQCPatientData(Neusoft.HISFC.Models.RADT.PatientInfo patient, Neusoft.HISFC.Models.EPR.QCConditions qc)
{
if (this.DeleteQCPatientData(patient.ID, qc.ID) == -1)
{
return(-1);
}
return(this.InsertQCPatientData(patient, qc));
}
/// <summary>
/// 插入一条质控信息
/// </summary>
/// <returns></returns>
public int InsertQCPatientData(Neusoft.HISFC.Models.RADT.PatientInfo patient, Neusoft.HISFC.Models.EPR.QCConditions qc)
{
string strSql = "";
if (this.Sql.GetSql("EPR.QC.Inpatient.Insert", ref strSql) == -1)
{
return(-1);
}
return(this.ExecNoQuery(strSql,
patient.ID,
patient.Name,
patient.PVisit.PatientLocation.Dept.ID,
patient.PVisit.PatientLocation.Dept.Name,
patient.PVisit.AdmittingDoctor.ID,
patient.PVisit.AdmittingDoctor.Name,
patient.PVisit.OutTime.ToString(),
patient.Memo,
qc.ID,
qc.Name,
qc.Memo,
this.Operator.ID
));
}
public bool ExecQCInfo(string inpatientNo, Neusoft.FrameWork.Management.Interface ISql, Neusoft.HISFC.Models.EPR.QCConditions condition)
{
Neusoft.HISFC.BizLogic.EPR.QCInfo manager = new Neusoft.HISFC.BizLogic.EPR.QCInfo();
this.SetDB(manager);
return(manager.ExecQCInfo(inpatientNo, ISql, condition));
}
public int UpdateQCCondition(Neusoft.HISFC.Models.EPR.QCConditions conditions)
{
Neusoft.HISFC.BizLogic.EPR.QC manager = new Neusoft.HISFC.BizLogic.EPR.QC();
this.SetDB(manager);
return(manager.UpdateQCCondition(conditions));
}