Esempio n. 1
0
 /// <summary>
 /// 登记新的患者诊断
 /// </summary>
 /// <param name="Diagnose"></param>
 /// <returns></returns>
 public int CreatePatientDiagnose(Neusoft.HISFC.Models.HealthRecord.DiagnoseBase Diagnose)
 {
     #region "接口说明"
     //接口名称 RADT.Diagnose.CreatePatientDiagnose.1
     // 0  --住院流水号, 1 --发生序号      2   --病历号   ,     3   --诊断类别  ,4   --诊断编码
     // 5  --诊断名称,   6   --诊断时间   ,7   --诊断医生编码  ,8   --医生名称 , 9   --是否有效
     // 10 --诊断科室ID 11   --是否主诊断 12   --备注          13   --操作员    14   --操作时间
     #endregion
     string strSql = "";
     if (this.Sql.GetSql("RADT.Diagnose.CreatePatientDiagnose.1", ref strSql) == -1)
     {
         return(-1);
     }
     string[] s = new string[16];
     s[0]  = Diagnose.Patient.ID.ToString();                        // --患者住院流水号
     s[1]  = Diagnose.HappenNo.ToString();                          //  --发生序号
     s[2]  = Diagnose.Patient.PID.CardNO;                           // --就诊卡号
     s[3]  = Diagnose.DiagType.ID.ToString();                       //  --诊断类别
     s[4]  = Diagnose.ID.ToString();                                // --诊断编码
     s[5]  = Diagnose.Name;                                         //.Replace("'","''") ;//--诊断名称
     s[6]  = Diagnose.DiagDate.ToString();                          //  --诊断时间
     s[7]  = Diagnose.Doctor.ID.ToString();                         //    --诊断医生
     s[8]  = Diagnose.Doctor.Name;                                  //    --诊断医生
     s[9]  = (System.Convert.ToInt16(Diagnose.IsValid)).ToString(); //    --是否有效
     s[10] = Diagnose.Dept.ID.ToString();                           //  --诊断科室
     s[11] = (System.Convert.ToInt16(Diagnose.IsMain)).ToString();  //  --是否主诊断
     s[12] = Diagnose.Memo;                                         //    --备注
     s[13] = this.Operator.ID.ToString();                           //    --操作人
     s[14] = this.GetSysDateTime().ToString();                      //    --操作人
     s[15] = Diagnose.OperationNo;                                  //手术序号
     return(this.ExecNoQuery(strSql, s));
 }
Esempio n. 2
0
        //私有函数,查询患者基本信息
        private ArrayList myPatientQuery(string SQLPatient)
        {
            ArrayList al = new ArrayList();

            Neusoft.HISFC.Models.HealthRecord.DiagnoseBase Diagnose;
            this.ProgressBarText  = "正在查询患者诊断...";
            this.ProgressBarValue = 0;

            this.ExecQuery(SQLPatient);
            try
            {
                while (this.Reader.Read())
                {
                    Diagnose            = new Neusoft.HISFC.Models.HealthRecord.DiagnoseBase();
                    Diagnose.Patient.ID = this.Reader[0].ToString();                                            // 住院流水号

                    Diagnose.HappenNo = Neusoft.FrameWork.Function.NConvert.ToInt32(this.Reader[1].ToString()); //  发生序号

                    Diagnose.Patient.PID.CardNO = this.Reader[2].ToString();                                    //病历号

                    Diagnose.DiagType.ID = this.Reader[3].ToString();                                           //诊断类别
                    //Neusoft.HISFC.Models.HealthRecord.DiagnoseType diagnosetype = new Neusoft.HISFC.Models.HealthRecord.DiagnoseType();
                    //diagnosetype.ID = Diagnose.DiagType.ID;
                    //Diagnose.DiagType.Name = diagnosetype.Name;//获得诊断名称 zjy

                    Diagnose.ID         = this.Reader[4].ToString();    //诊断代码
                    Diagnose.ICD10.ID   = this.Reader[4].ToString();
                    Diagnose.Name       = this.Reader[5].ToString();    //诊断名称
                    Diagnose.ICD10.Name = this.Reader[5].ToString();

                    Diagnose.DiagDate = Neusoft.FrameWork.Function.NConvert.ToDateTime(this.Reader[6].ToString());

                    Diagnose.Doctor.ID = this.Reader[7].ToString();

                    Diagnose.Doctor.Name = this.Reader[8].ToString();

                    Diagnose.IsValid = Neusoft.FrameWork.Function.NConvert.ToBoolean(this.Reader[9]);

                    Diagnose.Dept.ID = this.Reader[10].ToString();

                    Diagnose.IsMain = Neusoft.FrameWork.Function.NConvert.ToBoolean(this.Reader[11]);

                    Diagnose.Memo = this.Reader[12].ToString();

                    Diagnose.User01 = this.Reader[13].ToString();
                    Diagnose.User02 = this.Reader[14].ToString();

                    //手术序号
                    Diagnose.OperationNo = this.Reader[15].ToString();

                    al.Add(Diagnose);
                }
            }
            catch (Exception ex)
            {
                this.Err     = "获得患者诊断信息出错!" + ex.Message;
                this.ErrCode = "-1";
                this.WriteErr();
                return(null);
            }
            this.Reader.Close();

            this.ProgressBarValue = -1;
            return(al);
        }
Esempio n. 3
0
        /// <summary>
        /// 更新患者诊断信息
        /// </summary>
        /// <param name="Diagnose"></param>
        /// <returns></returns>
        public int UpdatePatientDiagnose(Neusoft.HISFC.Models.HealthRecord.DiagnoseBase Diagnose)
        {
            #region "接口说明"
            //接口名称 RADT.Diagnose.UpdatePatientDiagnose.1
            // 0  --住院流水号, 1 --发生序号      2   --病历号   ,     3   --诊断类别  ,4   --诊断编码
            // 5  --诊断名称,   6   --诊断时间   ,7   --诊断医生编码  ,8   --医生名称 , 9   --是否有效
            // 10 --诊断科室ID 11   --是否主诊断 12   --备注          13   --操作员    14   --操作时间
            #endregion
            string strSql = "";
            if (this.Sql.GetSql("RADT.Diagnose.UpdatePatientDiagnose.1", ref strSql) == -1)
            {
                return(-1);
            }

            try
            {
                string[] s = new string[15];
                try
                {
                    s[0] = Diagnose.Patient.ID.ToString();// --诊断编码
                }
                catch (Exception ex)
                {
                    this.Err = ex.Message;
                    this.WriteErr();
                }
                try
                {
                    s[1] = Diagnose.HappenNo.ToString();//  --发生序号
                }
                catch (Exception ex)
                {
                    this.Err = ex.Message;
                    this.WriteErr();
                }
                try
                {
                    s[2] = Diagnose.Patient.PID.CardNO;// --诊断编码
                }
                catch (Exception ex)
                {
                    this.Err = ex.Message;
                    this.WriteErr();
                }
                try
                {
                    s[3] = Diagnose.DiagType.ID.ToString();//  --诊断类别
                }
                catch (Exception ex)
                {
                    this.Err = ex.Message;
                    this.WriteErr();
                }
                try
                {
                    s[4] = Diagnose.ID.ToString();// --诊断编码
                }
                catch (Exception ex)
                {
                    this.Err = ex.Message;
                    this.WriteErr();
                }
                try
                {
                    s[5] = Diagnose.Name;//.Replace("'","''");//--诊断名称
                }
                catch (Exception ex)
                {
                    this.Err = ex.Message;
                    this.WriteErr();
                }
                try
                {
                    s[6] = Diagnose.DiagDate.ToString();//  --诊断时间
                }
                catch (Exception ex)
                {
                    this.Err = ex.Message;
                    this.WriteErr();
                }
                try
                {
                    s[7] = Diagnose.Doctor.ID.ToString();//    --诊断医生
                }
                catch (Exception ex)
                {
                    this.Err = ex.Message;
                    this.WriteErr();
                }
                try
                {
                    s[8] = Diagnose.Doctor.Name;//    --诊断医生
                }
                catch (Exception ex)
                {
                    this.Err = ex.Message;
                    this.WriteErr();
                }
                try
                {
                    s[9] = (System.Convert.ToInt16(Diagnose.IsValid)).ToString();//    --是否有效
                }
                catch (Exception ex)
                {
                    this.Err = ex.Message;
                    this.WriteErr();
                }
                try
                {
                    s[10] = Diagnose.Dept.ID.ToString();//  --诊断科室
                }
                catch (Exception ex)
                {
                    this.Err = ex.Message;
                    this.WriteErr();
                }
                try
                {
                    s[11] = (System.Convert.ToInt16(Diagnose.IsMain)).ToString();//  --是否主诊断
                }
                catch (Exception ex)
                {
                    this.Err = ex.Message;
                    this.WriteErr();
                }

                try
                {
                    s[12] = Diagnose.Memo;//    --备注
                }
                catch (Exception ex)
                {
                    this.Err = ex.Message;
                    this.WriteErr();
                }
                try
                {
                    s[13] = this.Operator.ID.ToString();//    --操作人
                }
                catch (Exception ex)
                {
                    this.Err = ex.Message;
                    this.WriteErr();
                }
                try
                {
                    s[14] = this.GetSysDateTime().ToString();//    --操作人
                }
                catch (Exception ex)
                {
                    this.Err = ex.Message;
                    this.WriteErr();
                }
                //				strSql=string.Format(strSql,s);
                return(this.ExecNoQuery(strSql, s));
            }
            catch (Exception ex)
            {
                this.Err = "赋值时候出错!" + ex.Message;
                this.WriteErr();
                return(-1);
            }
        }