/// <summary>
/// 根据手术序号获得手术诊断信息列表
/// </summary>
/// <param name="OperatorNo">手术申请单对象</param>
/// <returns>患者的手术诊断对象数组</returns>
public override ArrayList GetIcdFromApp(Neusoft.HISFC.Models.Operation.OperationAppllication opsApp)
{
ArrayList IcdAl = new ArrayList();
ArrayList rtnAl = new ArrayList();
//患者住院流水号strInPatientNo
switch (opsApp.PatientSouce)
{
case "1": //门诊手术
break;
case "2": //住院手术
string strInPatientNo = string.Empty; //患者住院流水号
strInPatientNo = opsApp.PatientInfo.ID.ToString();
try
{
//TODO:病案业务层
IcdAl = diagMgr.QueryOpsDiagnose(strInPatientNo, "7"); //"7"为术前诊断类型
foreach (Neusoft.HISFC.Models.HealthRecord.DiagnoseBase diag in IcdAl)
{
if (diag.OperationNo == opsApp.ID)
{
rtnAl.Add(diag);
}
}
}
catch
{
return(rtnAl);
}
break;
}
return(rtnAl);
}
/// <summary>
/// 更新麻醉登记信息
/// </summary>
/// <param name="AnaeRecord">麻醉登记实体对象</param>
/// <returns>0 success -1 fail</returns>
public int UpdateAnaeRecord(Neusoft.HISFC.Models.Operation.AnaeRecord AnaeRecord)
{
string strSql = string.Empty;
#region 获取患者基本信息
//--------------------------------------------------------
//局部变量定义
string ls_ClinicCode = string.Empty; //住院流水号/门诊号
string ls_PatientNo = string.Empty; //病案号/病历号
string ls_Name = string.Empty; //患者姓名
string ls_Sex = string.Empty; //性别
Neusoft.HISFC.Models.Operation.OperationAppllication OpsApp = new Neusoft.HISFC.Models.Operation.OperationAppllication();
OpsApp = AnaeRecord.OperationApplication;
ls_ClinicCode = OpsApp.PatientInfo.ID;
ls_PatientNo = OpsApp.PatientInfo.PID.ID;
ls_Name = OpsApp.PatientInfo.Name;
ls_Sex = OpsApp.PatientInfo.Sex.ID.ToString();
//--------------------------------------------------------
#endregion
//bool标志值转换
string strIsPACU = Neusoft.FrameWork.Function.NConvert.ToInt32(AnaeRecord.IsPACU).ToString();
string strDemulcent = Neusoft.FrameWork.Function.NConvert.ToInt32(AnaeRecord.IsDemulcent).ToString();
string strChargeFlag = Neusoft.FrameWork.Function.NConvert.ToInt32(AnaeRecord.IsCharged).ToString();
if (this.Sql.GetSql("Operator.AnaeRecord.UpdateAnaeRecord.1", ref strSql) == -1)
{
return(-1);
}
try
{
//手术登记表中增加记录
//每行5个参数
strSql = string.Format(strSql, OpsApp.ID, ls_ClinicCode, ls_PatientNo, ls_Name, ls_Sex, OpsApp.PatientSouce,
OpsApp.AnesType.ID.ToString(), AnaeRecord.AnaeDate.ToString(), "", "", AnaeRecord.AnaeResult.ID.ToString(),
strIsPACU, AnaeRecord.InPacuDate.ToString(), AnaeRecord.InPacuStatus.ID.ToString(), AnaeRecord.OutPacuDate.ToString(), AnaeRecord.OutPacuStatus.ID.ToString(),
AnaeRecord.Memo, strDemulcent, AnaeRecord.DemulcentType.ID.ToString(), AnaeRecord.DemulcentModel.ID.ToString(), AnaeRecord.DemulcentDays.ToString(),
AnaeRecord.PullOutDate.ToString(), AnaeRecord.PullOutOperator.ID.ToString(), AnaeRecord.DemulcentEffect.ID.ToString(), strChargeFlag, this.Operator.ID.ToString(),
AnaeRecord.ExecDept.ID.ToString());
}
catch (Exception ex)
{
this.Err = ex.Message;
this.ErrCode = ex.Message;
return(-1);
}
if (strSql == null)
{
return(-1);
}
if (this.ExecNoQuery(strSql) == -1)
{
return(-1);
}
return(0);
}
public static int GetPatientInfomation(Neusoft.HISFC.Models.Operation.OperationAppllication operationAppllication)
{
operationAppllication.PatientInfo = RadtManager.GetPatientInfomation(operationAppllication.PatientInfo.ID);
return(0);
}
public frmChangeOpsRoom(Neusoft.HISFC.Models.Operation.OperationAppllication apply)
{
InitializeComponent();
m_objOpsApp = apply;
}
/// <summary>
/// 更新手术登记
/// </summary>
/// <param name="OpsRecord">手术登记单对象</param>
/// <returns>0 success -1 fail</returns>
public int UpdateOperatorRecord(Neusoft.HISFC.Models.Operation.OperationRecord OpsRecord)
{
string strSql = string.Empty;
#region 获取患者基本信息
//--------------------------------------------------------
//局部变量定义
string ls_ClinicCode = string.Empty; //住院流水号/门诊号
string ls_PatientNo = string.Empty; //病案号/病历号
string ls_Name = string.Empty; //患者姓名
string ls_Sex = string.Empty; //性别
DateTime ldt_Birthday = DateTime.MinValue; //生日
string ls_DeptCode = string.Empty; //住院科室
string ls_BedNo = string.Empty; //床位号
string ls_BloodCode = string.Empty; //患者血型
string ls_SickRoom = string.Empty; //病房号
Neusoft.HISFC.Models.Operation.OperationAppllication OpsApp = new Neusoft.HISFC.Models.Operation.OperationAppllication();
OpsApp = OpsRecord.OperationAppllication;
ls_ClinicCode = OpsApp.PatientInfo.ID;
ls_PatientNo = OpsApp.PatientInfo.PID.ID;
ls_Name = OpsApp.PatientInfo.Name;
ls_Sex = OpsApp.PatientInfo.Sex.ID.ToString();
ldt_Birthday = OpsApp.PatientInfo.Birthday;
ls_DeptCode = OpsApp.PatientInfo.PVisit.PatientLocation.Dept.ID.ToString();
ls_BedNo = OpsApp.PatientInfo.PVisit.PatientLocation.Bed.ID.ToString();
ls_BloodCode = OpsApp.PatientInfo.BloodType.ID.ToString();
ls_SickRoom = OpsApp.PatientInfo.PVisit.PatientLocation.Room;
//--------------------------------------------------------
#endregion
//OpsApp.ExeDept = OpsApp.OperateRoom;//执行科室(对于需要填申请单的手术来说，手术室即执行科室)
//bool标志值转换
string strGerm = Neusoft.FrameWork.Function.NConvert.ToInt32(OpsApp.IsGermCarrying).ToString();
string strFinished = Neusoft.FrameWork.Function.NConvert.ToInt32(OpsApp.IsFinished).ToString();
string strAnesth = Neusoft.FrameWork.Function.NConvert.ToInt32(OpsApp.IsAnesth).ToString();
string strUrgent = Neusoft.FrameWork.Function.NConvert.ToInt32(OpsApp.IsUrgent).ToString();
string strChange = Neusoft.FrameWork.Function.NConvert.ToInt32(OpsApp.IsChange).ToString();
string strHeavy = Neusoft.FrameWork.Function.NConvert.ToInt32(OpsApp.IsHeavy).ToString();
string strSpecial = Neusoft.FrameWork.Function.NConvert.ToInt32(OpsApp.IsSpecial).ToString();
string strValid = Neusoft.FrameWork.Function.NConvert.ToInt32(OpsApp.IsValid).ToString();
string strUnite = Neusoft.FrameWork.Function.NConvert.ToInt32(OpsApp.IsUnite).ToString();
string strNeedAcco = Neusoft.FrameWork.Function.NConvert.ToInt32(OpsApp.IsAccoNurse).ToString();
string strNeedPrep = Neusoft.FrameWork.Function.NConvert.ToInt32(OpsApp.IsPrepNurse).ToString();
string strForeSober = Neusoft.FrameWork.Function.NConvert.ToInt32(OpsRecord.IsSoberIn).ToString();
string strStepSober = Neusoft.FrameWork.Function.NConvert.ToInt32(OpsRecord.IsSoberOut).ToString();
string strToolExam = Neusoft.FrameWork.Function.NConvert.ToInt32(OpsRecord.bToolExam).ToString();
string strSeperate = Neusoft.FrameWork.Function.NConvert.ToInt32(OpsRecord.IsSeperated).ToString();
if (OpsRecord.OperationAppllication.IsHeavy || OpsRecord.OperationAppllication.IsChange)
{
OpsRecord.IsDangerous = true;
}
else
{
OpsRecord.IsDangerous = false;
}
string strDanger = Neusoft.FrameWork.Function.NConvert.ToInt32(OpsRecord.IsDangerous).ToString();
string strQues = Neusoft.FrameWork.Function.NConvert.ToInt32(OpsRecord.IsMistaken).ToString();
string strI_Infection = Neusoft.FrameWork.Function.NConvert.ToInt32(OpsRecord.IsInfected).ToString();
string strDie = Neusoft.FrameWork.Function.NConvert.ToInt32(OpsRecord.IsDead).ToString();
string strFee = Neusoft.FrameWork.Function.NConvert.ToInt32(OpsRecord.IsCharged).ToString();
if (OpsRecord.OperationAppllication.PatientInfo.Weight == "")
{
OpsRecord.OperationAppllication.PatientInfo.Weight = "0";
}
//by zlw
string docDept = OpsRecord.OperationAppllication.OperationDoctor.Dept.ID;
if (this.Sql.GetSql("Operator.OpsRecord.UpdateOperatorRecord.1", ref strSql) == -1)
{
return(-1);
}
try
{
//手术登记表中增加记录
//每行5个参数
string [] str = new string[] {
OpsApp.ID, ls_ClinicCode, ls_PatientNo, OpsApp.PatientSouce, ls_Name,
ls_DeptCode, ls_BedNo, ls_Sex, ldt_Birthday.ToString(), ls_BloodCode,
OpsApp.OperateKind, OpsApp.OperationDoctor.ID.ToString(), OpsApp.GuideDoctor.ID.ToString(), OpsApp.PreDate.ToString(), OpsApp.Duration.ToString(),
OpsApp.AnesType.ID.ToString(), OpsApp.HelperAl.Count.ToString(), "0", "0", "0",
OpsApp.TableType, OpsApp.ExeDept.ID.ToString(), OpsApp.OpsTable.ID.ToString(), OpsApp.ApplyDoctor.ID.ToString(), OpsApp.ApplyDate.ToString(),
OpsApp.ApproveDoctor.ID.ToString(), OpsApp.OperationType.ID.ToString(), strGerm, OpsApp.InciType.ID.ToString(), OpsApp.ScreenUp,
OpsRecord.OpsDate.ToString(), OpsRecord.AcceptDate.ToString(), OpsRecord.Memo, OpsApp.BloodType.ID.ToString(), OpsApp.BloodNum.ToString(),
OpsApp.BloodUnit, OpsRecord.EnterDate.ToString(), OpsRecord.OutDate.ToString(), OpsRecord.Duration.ToString(), strForeSober,
strStepSober, "" /*OpsRecord.ForePress add by huangxw*/, OpsRecord.StepPress, OpsRecord.ForePulse.ToString(), OpsRecord.StepPulse.ToString(),
OpsRecord.BedsoreCount.ToString(), OpsRecord.TransfusionQuantity.ToString(), OpsRecord.SampleCount.ToString(), OpsRecord.EduceFlowTubeCount.ToString(), OpsRecord.BeforeReady.ID.ToString(),
strToolExam, strSeperate, strDanger, OpsRecord.PhlebotmomizeTimes.ToString(), OpsRecord.VeinInjectionTimes.ToString(),
OpsRecord.MuscleInjectionTimes.ToString(), OpsRecord.TransfusionTimes.ToString(), OpsRecord.TransoxygenTimes.ToString(), OpsRecord.ExportUrineTimes.ToString(), strQues,
strI_Infection, strDie, OpsRecord.ExtraMemo, "1", strFee,
OpsRecord.OperationAppllication.PatientInfo.Weight, this.Operator.ID.ToString(), OpsRecord.OperationAppllication.RoomID, docDept, OpsRecord.BloodPressureIn
};
// strSql = string.Format(strSql,OpsApp.OperationNo,ls_ClinicCode,ls_PatientNo,OpsApp.Pasource,ls_Name,
// ls_DeptCode,ls_BedNo,ls_Sex,ldt_Birthday.ToString(),ls_BloodCode,
// OpsApp.OperateKind,OpsApp.Ops_docd.ID.ToString(),OpsApp.Gui_docd.ID.ToString(),OpsApp.Pre_Date.ToString(),OpsApp.Duration.ToString(),
// OpsApp.Anes_type.ID.ToString(),OpsApp.HelperAl.Count,0,0,0,
// OpsApp.TableType,OpsApp.ExeDept.ID.ToString(),OpsApp.OpsTable.ID.ToString(),OpsApp.Apply_Doct.ID.ToString(),OpsApp.Apply_Date.ToString(),
// OpsApp.ApprDocd.ID.ToString(),OpsApp.OperateType.ID.ToString(),strGerm,OpsApp.InciType.ID.ToString(),OpsApp.ScreenUp,
// OpsRecord.OpsDate.ToString(),OpsRecord.ReceptDate.ToString(),OpsRecord.Remark,OpsApp.BloodType.ID.ToString(),OpsApp.BloodNum.ToString(),
// OpsApp.BloodUnit,OpsRecord.EnterDate.ToString(),OpsRecord.OutDate.ToString(),OpsRecord.RealDuation.ToString(),strForeSober,
// strStepSober,""/*OpsRecord.ForePress add by huangxw*/,OpsRecord.StepPress,OpsRecord.ForePulse.ToString(),OpsRecord.StepPulse.ToString(),
// OpsRecord.ScarNum.ToString(),OpsRecord.TransFusionQty.ToString(),OpsRecord.SampleQty.ToString(),OpsRecord.GuidtubeNum.ToString(),OpsRecord.BeforeReady.ID.ToString(),
// strToolExam,strSeperate,strDanger,OpsRecord.LetBlood.ToString(),OpsRecord.MainLine.ToString(),
// OpsRecord.MusleLine.ToString(),OpsRecord.TransFusion.ToString(),OpsRecord.TransOxyen.ToString(),OpsRecord.Stale.ToString(),strQues,
// strI_Infection,strDie,OpsRecord.SpecialComment,"1",strFee,
// OpsRecord.m_objOpsApp.PatientInfo.Weight,this.Operation.ID.ToString(),OpsRecord.m_objOpsApp.RoomID);
if (this.ExecNoQuery(strSql, str) == -1)
{
return(-1);
}
}
catch (Exception ex)
{
this.Err = ex.Message;
this.ErrCode = ex.Message;
return(-1);
}
// if (strSql == null) return -1;
//
// if(this.ExecNoQuery(strSql) == -1) return -1;
return(0);
}