/// <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);
}
