/// <summary> /// 根据当前科室编码、申请日期获取等待入库确认的单据 /// </summary> /// <param name="caseBillList">病历出库单数组</param> /// <param name="deptCode">科室编码</param> /// <param name="fromDate">起始时间</param> /// <param name="caseBillState">病历出库单状态</param> /// <returns>-1-失败,1-成功</returns> public int QueryWaitConfirm(ref List <HISFC.Models.HealthRecord.Case.CaseBill> caseBillList, string deptCode, DateTime fromDate, HISFC.Models.HealthRecord.Case.EnumCaseBillState caseBillState) { string whereSql = string.Empty; intReturn = this.Sql.GetSql("Neusoft.HISFC.Management.HealthRecord.Case.CaseBill.QueryWaitConfirm", ref whereSql); if (this.intReturn < 0) { this.Err = "查询等待入库确认的病历出库单失败" + this.Err; return(-1); } try { whereSql = string.Format(whereSql, deptCode, fromDate.ToString(), ((int)caseBillState).ToString()); } catch (Exception exception) { this.Err = "查询等待入库确认的病历出库单失败" + exception.Message; return(-1); } return(this.Select(caseBillList, whereSql)); }
/// <summary> /// 根据当前科室编码、申请日期获取等待入库确认的单据树结点 /// </summary> /// <param name="caseBillList">单据树结点</param> /// <param name="deptCode">科室编码</param> /// <param name="fromDate">起始时间</param> /// <param name="caseBillState">病历出库单状态</param> /// <returns>-1-失败,1-成功</returns> public int QueryWaitConfirmTreeNode(ref List <Neusoft.FrameWork.Models.NeuObject> caseBillList, string deptCode, DateTime fromDate, HISFC.Models.HealthRecord.Case.EnumCaseBillState caseBillState) { string whereSql = string.Empty; intReturn = this.Sql.GetSql("Neusoft.HISFC.Management.HealthRecord.Case.CaseBill.QueryWaitConfirmTreeNode", ref whereSql); if (this.intReturn < 0) { this.Err = "查询等待入库确认的病历出库单失败" + this.Err; return(-1); } try { whereSql = string.Format(whereSql, ((int)caseBillState).ToString(), deptCode, fromDate.ToString()); this.intReturn = this.ExecQuery(whereSql); if (this.intReturn == -1) { this.Err = "查询等待入库确认的病历出库单失败" + this.Err; return(-1); } while (this.Reader.Read()) { Neusoft.FrameWork.Models.NeuObject node = new Neusoft.FrameWork.Models.NeuObject(); // 出库单号码 node.ID = this.Reader [0].ToString(); // 包含病历个数 node.Name = this.Reader [1].ToString(); caseBillList.Add(node); } } catch (Exception exception) { this.Err = "查询已经申请入库的病历出库单失败" + exception.Message; return(-1); } return(1); }