/// <summary> /// 获取分类信息 疾病 和手术分类 /// </summary> /// <param name="beginDate"></param> /// <param name="EndDate"></param> /// <returns></returns> public ArrayList GetInfoClassify(string beginDate, string EndDate, Neusoft.HISFC.Models.HealthRecord.EnumServer.ReportIndexs type) { string strSql = ""; ArrayList list = new ArrayList(); try { switch (type) { case ReportIndexs.OperationClassisy: if (this.Sql.GetSql("Case.CaseReport.GetInfoIndex.OperationClassisy", ref strSql) == -1) { return(null); } break; case ReportIndexs.DiseaseClassify: if (this.Sql.GetSql("Case.CaseReport.GetInfoIndex.DiseaseClassify", ref strSql) == -1) { return(null); } break; } strSql = string.Format(strSql, beginDate, EndDate); this.ExecQuery(strSql); Neusoft.FrameWork.Models.NeuObject obj = null; while (this.Reader.Read()) { obj = new Neusoft.FrameWork.Models.NeuObject(); obj.ID = this.Reader[0].ToString(); //编码 obj.Name = this.Reader[1].ToString(); // 名称 obj.User01 = this.Reader[2].ToString(); //住院号 list.Add(obj); } this.Reader.Close(); } catch (Exception ex) { if (!this.Reader.IsClosed) { this.Reader.Close(); } this.Err = ex.Message; return(null); } return(list); }
/// <summary> /// 根据条件 获取信息 /// </summary> /// <returns></returns> public string GetInfoIndex(string beginDate, string EndDate, System.Data.DataSet ds, Neusoft.HISFC.Models.HealthRecord.EnumServer.ReportIndexs type, string deptList) { string strSql = ""; //Neusoft.HISFC.Management.Manager.Constant con = new Neusoft.HISFC.Management.Manager.Constant(); try { switch (type) { case ReportIndexs.NameIndex: //姓名索引卡 if (this.Sql.GetSql("Case.CaseReport.GetInfoIndex.NameIndex", ref strSql) == -1) { return(null); } strSql = string.Format(strSql, beginDate, EndDate); break; case ReportIndexs.DeathIndex: //死亡索引卡 if (this.Sql.GetSql("Case.CaseReport.GetInfoIndex.DeathIndex", ref strSql) == -1) { return(null); } strSql = string.Format(strSql, beginDate, EndDate, deptList); break; case ReportIndexs.DepartDept: //出院分科登记表 if (this.Sql.GetSql("Case.CaseReport.GetInfoIndex.DepartDept", ref strSql) == -1) { return(null); } strSql = string.Format(strSql, beginDate, EndDate, deptList); break; case ReportIndexs.Zhidaoban: //职道病人问卷调查表 if (this.Sql.GetSql("Case.CaseReport.GetInfoIndex.Zhidaoban", ref strSql) == -1) { return(null); } strSql = string.Format(strSql, beginDate, EndDate); break; case ReportIndexs.BeforeODept: //科室术前平均住院日统计 if (this.Sql.GetSql("Case.CaseReport.GetInfoIndex.BeforeODept", ref strSql) == -1) { return(null); } strSql = string.Format(strSql, beginDate, EndDate); break; case ReportIndexs.AfterODept: //科室术后平均住院日统计 if (this.Sql.GetSql("Case.CaseReport.GetInfoIndex.AfterODept", ref strSql) == -1) { return(null); } strSql = string.Format(strSql, beginDate, EndDate); break; case ReportIndexs.BeforeOperation: //手术种手术率统计表 if (this.Sql.GetSql("Case.CaseReport.GetInfoIndex.BeforeOperation", ref strSql) == -1) { return(null); } strSql = string.Format(strSql, beginDate, EndDate); break; case ReportIndexs.ComeBackInWeek: //一周内复入院 if (this.Sql.GetSql("Case.CaseReport.GetInfoIndex.ComeBackInWeek", ref strSql) == -1) { return(null); } strSql = string.Format(strSql, beginDate, EndDate); break; case ReportIndexs.Infection: // 传染病疫情报告 if (this.Sql.GetSql("Case.CaseReport.GetInfoIndex.Infection", ref strSql) == -1) { return(null); } strSql = string.Format(strSql, beginDate, EndDate); break; case ReportIndexs.CaseUserfrequence: // 病案使用频率统计表 if (this.Sql.GetSql("Case.CaseReport.GetInfoIndex.CaseUserfrequence", ref strSql) == -1) { return(null); } strSql = string.Format(strSql, beginDate, EndDate); break; case ReportIndexs.DoctorUserfrequence: // 医师使用频率统计表 if (this.Sql.GetSql("Case.CaseReport.GetInfoIndex.DoctorUserfrequence", ref strSql) == -1) { return(null); } strSql = string.Format(strSql, beginDate, EndDate); break; case ReportIndexs.InputPerson: // 录入人员频率统计表 if (this.Sql.GetSql("Case.CaseReport.GetInfoIndex.InputPerson", ref strSql) == -1) { return(null); } strSql = string.Format(strSql, beginDate, EndDate); break; case ReportIndexs.ICDDiagPerson: // 诊断编码人员工作量统计 if (this.Sql.GetSql("Case.CaseReport.GetInfoIndex.ICDDiagPerson", ref strSql) == -1) { return(null); } strSql = string.Format(strSql, beginDate, EndDate); break; case ReportIndexs.DiseaseAndOutState: // 病种发病率转归统计表 if (this.Sql.GetSql("Manager.Constant.UpdateComHospitalinfoDate", ref strSql) == -1) { return(null); } strSql = string.Format(strSql, beginDate, EndDate); if (this.ExecNoQuery(strSql) != 1) { this.Err = "更新com_hospitalinfo失败"; return(null); } if (this.Sql.GetSql("Case.CaseReport.GetInfoIndex.DiseaseAndOutState", ref strSql) == -1) { return(null); } break; case ReportIndexs.TumourDiseaseAndOutState: // 恶性肿瘤转归统计表 if (this.Sql.GetSql("Manager.Constant.UpdateComHospitalinfoDate", ref strSql) == -1) { return(null); } strSql = string.Format(strSql, beginDate, EndDate); if (this.ExecNoQuery(strSql) != 1) { this.Err = "更新com_hospitalinfo失败"; return(null); } if (this.Sql.GetSql("Case.CaseReport.GetInfoIndex.TumourDiseaseAndOutState", ref strSql) == -1) { return(null); } break; case ReportIndexs.BorrowCase: // 诊断编码人员工作量统计 if (this.Sql.GetSql("Case.CaseReport.GetInfoIndex.BorrowCase", ref strSql) == -1) { return(null); } strSql = string.Format(strSql, beginDate, EndDate); break; case ReportIndexs.BackUpCase: // 病案整理员工作量统计 if (this.Sql.GetSql("Case.CaseReport.GetInfoIndex.BorrowCase", ref strSql) == -1) { return(null); } strSql = string.Format(strSql, beginDate, EndDate); break; case ReportIndexs.OperationCoding1: // 手术编码人员工作量统计 1 if (this.Sql.GetSql("Case.CaseReport.GetInfoIndex.OperationCoding1", ref strSql) == -1) { return(null); } strSql = string.Format(strSql, beginDate, EndDate); break; case ReportIndexs.OperationCoding2: // 手术编码人员工作量统计 2 if (this.Sql.GetSql("Case.CaseReport.GetInfoIndex.OperationCoding2", ref strSql) == -1) { return(null); } strSql = string.Format(strSql, beginDate, EndDate); break; case ReportIndexs.DiagCoding: // 诊断编码人员工作量统计表 2 if (this.Sql.GetSql("Case.CaseReport.GetInfoIndex.DiagCoding", ref strSql) == -1) { return(null); } strSql = string.Format(strSql, beginDate, EndDate); break; } this.ExecQuery(strSql, ref ds); } catch (Exception ex) { this.Err = ex.Message; return(null); } return(strSql); }