/// <summary>
/// ²éѯ¸ú×ټǼ
/// </summary>
/// <param name="caseID">²¡ÀúºÅ</param>
/// <returns>nullʧ°Ü</returns>
public List <Neusoft.HISFC.Models.HealthRecord.Case.CaseTrack> QueryTrackRecordByCaseID(string caseID)
{
if (caseID == null || caseID == string.Empty)
{
this.Err = "²¡ÀúºÅΪ¿Õ";
return(null);
}
string strsql = "";
if (this.Sql.GetSql("CaseManager.Track.SelectByCaseID", ref strsql) == -1)
{
this.Err = "»ñÈ¡ CaseManager.Track.SelectByCaseID ʧ°Ü";
return(null);
}
try
{
strsql = string.Format(strsql, caseID);
}
catch (Exception ex)
{
this.Err = "QueryTrackRecordByCaseID ×é×Ö·û»¼Ê§°Ü" + ex.Message;
return(null);
}
if (this.ExecQuery(strsql) == -1)
{
this.Err = "Ö´ÐÐ QueryTrackRecordByCaseID ʧ°Ü";
return(null);
}
List <Neusoft.HISFC.Models.HealthRecord.Case.CaseTrack> listTrack = new List <Neusoft.HISFC.Models.HealthRecord.Case.CaseTrack>();
while (this.Reader.Read())
{
Neusoft.HISFC.Models.HealthRecord.Case.CaseTrack track = new Neusoft.HISFC.Models.HealthRecord.Case.CaseTrack();
track.ID = this.Reader.IsDBNull(0) ? "" : this.Reader[0].ToString();
track.PatientCase.ID = this.Reader.IsDBNull(1) ? "" : this.Reader[1].ToString();
track.UseCaseEnv.ID = this.Reader.IsDBNull(2) ? "" : this.Reader[2].ToString(); //ʹÓÃÈ˱àºÅ
track.UseCaseEnv.Name = this.Reader.IsDBNull(3) ? "" : this.Reader[3].ToString(); //ÐÕÃû
track.UseCaseEnv.Dept.ID = this.Reader.IsDBNull(4) ? "" : this.Reader[4].ToString(); //ʹÓÿÆÊÒ±àºÅ
track.UseCaseEnv.Dept.Name = this.Reader.IsDBNull(5) ? "" : this.Reader[5].ToString(); //ʹÓÿÆÊÒÃû³Æ
track.UseCaseEnv.OperTime = this.Reader.IsDBNull(6) ? DateTime.MinValue : Neusoft.FrameWork.Function.NConvert.ToDateTime(this.Reader[6].ToString()); //ʹÓÃʱ¼ä
track.UseCaseEnv.User01 = this.Reader.IsDBNull(7) ? "" : this.Reader[7].ToString(); //²¡ÀúʹÓÃÀàÐͱàÂë
track.UseCaseEnv.User02 = this.Reader.IsDBNull(8) ? "" : this.Reader[8].ToString(); //²¡ÀúʹÓÃÀàÐÍÃû³Æ
listTrack.Add(track);
}
this.Reader.Close();
return(listTrack);
}
private void FillTrackRecord(Neusoft.HISFC.Models.HealthRecord.Case.CaseTrack track)
{
this.neuSpread1_Sheet1.Rows.Add(this.neuSpread1_Sheet1.Rows.Count, 1);
int rowIndex = this.neuSpread1_Sheet1.Rows.Count;
this.neuSpread1_Sheet1.SetText(rowIndex, 0, track.ID);
this.neuSpread1_Sheet1.SetText(rowIndex, 1, track.PatientCase.ID);
this.neuSpread1_Sheet1.SetText(rowIndex, 2, track.UseCaseEnv.ID);
this.neuSpread1_Sheet1.SetText(rowIndex, 3, track.UseCaseEnv.Name);
this.neuSpread1_Sheet1.SetText(rowIndex, 4, track.UseCaseEnv.Dept.ID);
this.neuSpread1_Sheet1.SetText(rowIndex, 5, track.UseCaseEnv.Dept.Name);
this.neuSpread1_Sheet1.SetText(rowIndex, 6, track.UseCaseEnv.OperTime.ToString());
this.neuSpread1_Sheet1.SetText(rowIndex, 7, track.User01);
this.neuSpread1_Sheet1.SetText(rowIndex, 8, track.User02);
this.neuSpread1_Sheet1.Rows[rowIndex].Tag = track;
}
/// <summary>
/// 入库确认创建病历跟踪
/// </summary>
/// <param name="caseBill">病历单据</param>
/// <param name="useType">使用类型</param>
/// <returns>－1－失败，1－成功</returns>
public int InsertCaseTrackAfterInConfirm(Neusoft.HISFC.Models.HealthRecord.Case.CaseBill caseBill, string useType)
{
if (caseBill.CaseBillState != Neusoft.HISFC.Models.HealthRecord.Case.EnumCaseBillState.InConfirm)
{
this.Err = "病历状态不正确，必须是入库确认状态";
return(-1);
}
Neusoft.HISFC.Models.HealthRecord.Case.CaseTrack caseTrack = new Neusoft.HISFC.Models.HealthRecord.Case.CaseTrack();
caseTrack.PatientCase = caseBill.CaseInfo;
caseTrack.UseCaseEnv.ID = caseBill.InConfirmOper.ID;
caseTrack.UseCaseEnv.OperTime = caseBill.InConfirmOper.OperTime;
caseTrack.UseCaseEnv.Dept.ID = this.GetDept();
caseTrack.User01 = useType;
return(1);
}
/// <summary>
/// ²åÈë¸ú×ټǼ
/// </summary>
/// <param name="caseTrack">²¡Àú¸ú×ÙʵÌå</param>
/// <returns>-1ʧ°Ü£¬1³É¹¦</returns>
public int InsertTrackRecord(Neusoft.HISFC.Models.HealthRecord.Case.CaseTrack caseTrack, EnumTrackType trackType)
{
if (caseTrack == null)
{
this.Err = "²¡Àú¸ú×ÙʵÌåΪ¿Õ";
return(-1);
}
string strsql = "";
if (this.Sql.GetSql("CaseManager.Track.InsertTrackInfo", ref strsql) == -1)
{
this.Err = "»ñÈ¡ CaseManager.Track.InsertTrackInfo ʧ°Ü";
return(-1);
}
switch (trackType)
{
case EnumTrackType.CLINIC_CURE:
caseTrack.User01 = "01";
break;
case EnumTrackType.INPATIENT_CURE:
caseTrack.User01 = "02";
break;
case EnumTrackType.CASE_LEND:
caseTrack.User01 = "03";
break;
case EnumTrackType.CASE_CHECK:
caseTrack.User01 = "04";
break;
case EnumTrackType.CASE_QUALITY:
caseTrack.User01 = "05";
break;
case EnumTrackType.FANGLIAO:
caseTrack.User01 = "06";
break;
case EnumTrackType.CASE_VISIT:
caseTrack.User01 = "07";
break;
default:
caseTrack.User01 = "03";
break;
}
try
{
strsql = string.Format(strsql, /*caseTrack.ID*/ this.GetTrackID(),
caseTrack.PatientCase.ID,
caseTrack.UseCaseEnv.OperTime.ToString(),
caseTrack.UseCaseEnv.ID,
caseTrack.UseCaseEnv.Dept.ID,
caseTrack.User01);
}
catch (Exception ex)
{
this.Err = "InsertTrackRecord ×é×Ö·û»¼Ê§°Ü" + ex.Message;
return(-1);
}
if (this.ExecNoQuery(strsql) <= 0)
{
this.Err = "InsertTrackRecord Ö´ÐÐʧ°Ü";
return(-1);
}
return(1);
}
/// <summary>
/// 插入病历跟踪记录
/// </summary>
/// <param name="track">病历跟踪实体</param>
/// <returns>-1失败；1成功</returns>
public int InsertTrackRecord(Neusoft.HISFC.Models.HealthRecord.Case.CaseTrack track, Neusoft.HISFC.BizLogic.HealthRecord.Case.EnumTrackType type)
{
this.SetDB(trackManager);
return(trackManager.InsertTrackRecord(track, type));
}