コード例 #1
0
        //GetNo 自动编号 YDS 2014-12-01
        public static string GetNo(DataConnection pclsCache, int NumberingType, string TargetDate)
        {
            string number = "";
            try
            {
                if (!pclsCache.Connect())
                {
                    //MessageBox.Show("Cache数据库连接失败");
                    return number;

                }
                number = Cm.MstNumbering.GetNo(pclsCache.CacheConnectionObject, NumberingType, TargetDate);
                return number;
            }
            catch (Exception ex)
            {
                //MessageBox.Show(ex.ToString(), "获取编号失败!");
                HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "CmMstNumbering.GetNo", "数据库操作异常! error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
                return number;
            }
            finally
            {
                pclsCache.DisConnect();
            }
        }
コード例 #2
0
ファイル: CmMstDivision.cs プロジェクト: luyao2211/WebService
        //SetData TDY 2014-12-1 WF 2015-07-07
        public static bool SetData(DataConnection pclsCache, int piType, string piCode, string piTypeName, string piName, string piInputCode, string piDescription, string revUserId, string TerminalName, string TerminalIP, int DeviceType)
        {
            bool IsSaved = false;
            try
            {
                if (!pclsCache.Connect())
                {
                    //MessageBox.Show("Cache数据库连接失败");
                    return IsSaved;

                }
                int flag = (int)Cm.MstDivision.SetData(pclsCache.CacheConnectionObject, piType, piCode,  piTypeName, piName, piInputCode, piDescription, revUserId, TerminalName, TerminalIP, DeviceType);
                if (flag == 1)
                {
                    IsSaved = true;
                }
                return IsSaved;
            }
            catch (Exception ex)
            {
                //MessageBox.Show(ex.ToString(), "保存失败!");
                HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "CmMstDivision.SetData", "数据库操作异常! error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
                return IsSaved;
            }
            finally
            {
                pclsCache.DisConnect();
            }
        }
コード例 #3
0
        //DeleteData YDS 2014-12-01
        public static int DeleteData(DataConnection pclsCache, string AlertItemCode)
        {
            int ret = 0;
            try
            {
                if (!pclsCache.Connect())
                {
                    //MessageBox.Show("Cache数据库连接失败");
                    return ret;

                }
                ret = (int)Wn.MstBasicAlert.DeleteData(pclsCache.CacheConnectionObject, AlertItemCode);
                return ret;
            }
            catch (Exception ex)
            {
                //MessageBox.Show(ex.ToString(), "删除失败!");
                HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "WnMstBasicAlert.DeleteData", "数据库操作异常! error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
                return ret;
            }
            finally
            {
                pclsCache.DisConnect();
            }
        }
コード例 #4
0
        //SetData TDY 2014-12-1
        public static bool SetData(DataConnection pclsCache, string UserId, int SortNo, string AssessmentType, string AssessmentName, DateTime AssessmentTime, string Result, string revUserId, string TerminalName, string TerminalIP, int DeviceType)
        {
            bool IsSaved = false;
            try
            {
                if (!pclsCache.Connect())
                {
                    //MessageBox.Show("Cache数据库连接失败");
                    return IsSaved;

                }
                int flag = (int)Ps.TreatmentIndicators.SetData(pclsCache.CacheConnectionObject, UserId, SortNo, AssessmentType, AssessmentName, AssessmentTime, Result, revUserId, TerminalName, TerminalIP, DeviceType);
                if (flag == 1)
                {
                    IsSaved = true;
                }
                return IsSaved;
            }
            catch (Exception ex)
            {
                //MessageBox.Show(ex.ToString(), "保存失败!");
                HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "PsTreatmentIndicators.SetData", "数据库操作异常! error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
                return IsSaved;
            }
            finally
            {
                pclsCache.DisConnect();
            }
        }
コード例 #5
0
        //GetResult SYF 2015-07-07 
        public static string GetResult(DataConnection pclsCache, string UserId, int SortNo)
        {
            string Result = "";
            try
            {
                if (!pclsCache.Connect())
                {
                    //MessageBox.Show("Cache数据库连接失败");
                    return "";

                }
                Result = Ps.TreatmentIndicators.GetResult(pclsCache.CacheConnectionObject, UserId, SortNo);
                return Result;
            }
            catch (Exception ex)
            {
                //MessageBox.Show(ex.ToString(), "保存失败!");
                HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "PsTreatmentIndicators.GetResult", "数据库操作异常! error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
                return Result;
            }
            finally
            {
                pclsCache.DisConnect();
            }
        }
コード例 #6
0
ファイル: PsSpecialList.cs プロジェクト: luyao2211/WebService
        //GetCareLevel 根据模块编码和患者ID获取关注等级 YDS 2014-12-01 ZAM 更新ModuleType类型int改为string 与2014-12-08
        public static int GetCareLevel(DataConnection pclsCache, string ModuleType, string PatientId)
        {
            int Level = 1;  //ZAM 2015-1-13 "尚未关注"
            try
            {
                if (!pclsCache.Connect())
                {
                    //MessageBox.Show("Cache数据库连接失败");
                    return Level;

                }
                Level = (int)Ps.SpecialList.GetCareLevel(pclsCache.CacheConnectionObject, ModuleType, PatientId);
                return Level;
            }
            catch (Exception ex)
            {
                //MessageBox.Show(ex.ToString(), "保存失败!");
                HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "PsSpecialList.GetCareLevel", "数据库操作异常! error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
                return Level;
            }
            finally
            {
                pclsCache.DisConnect();
            }
        }
コード例 #7
0
        //DeleteData CSQ 2015-01-06
        public static int DeleteData(DataConnection pclsCache, string DoctorId, string CategoryCode, string Value)
        {
            int ret = 0;
            try
            {
                if (!pclsCache.Connect())
                {
                    //MessageBox.Show("Cache数据库连接失败");
                    return ret;

                }
                ret = (int)Ps.DoctorInfoDetail.DeleteData(pclsCache.CacheConnectionObject, DoctorId, CategoryCode, Value);
                return ret;
            }
            catch (Exception ex)
            {
                //MessageBox.Show(ex.ToString(), "保存失败!");
                HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "PsDoctorInfoDetail.DeleteData", "数据库操作异常! error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
                return ret;
            }
            finally
            {
                pclsCache.DisConnect();
            }
        }
コード例 #8
0
        //SetData  LS 2014-12-1
        public static bool SetData(DataConnection pclsCache, string Doctor, string CategoryCode, string ItemCode, int ItemSeq, string Value, string Description, int SortNo, string piUserId, string piTerminalName, string piTerminalIP, int piDeviceType)
        {
            bool IsSaved = false;
            try
            {
                if (!pclsCache.Connect())
                {
                    //MessageBox.Show("Cache数据库连接失败");
                    return IsSaved;

                }
                int flag = (int)Ps.DoctorInfoDetail.SetData(pclsCache.CacheConnectionObject, Doctor, CategoryCode, ItemCode, ItemSeq, Value, Description, SortNo, piUserId, piTerminalName, piTerminalIP, piDeviceType);
                if (flag == 1)
                {
                    IsSaved = true;
                }
                return IsSaved;
            }
            catch (Exception ex)
            {
                //MessageBox.Show(ex.ToString(), "保存失败!");
                HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "PsDoctorInfoDetail.SetData", "数据库操作异常! error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
                return IsSaved;
            }
            finally
            {
                pclsCache.DisConnect();
            }
        }
コード例 #9
0
        public static bool SetData(DataConnection pclsCache, string UserId, string VisitId, DateTime ClinicDate, string HospitalCode, string Department, string Doctor, string piUserId, string piTerminalName, string piTerminalIP, int piDeviceType)
        {
            bool IsSaved = false;
            int ret = 0;
            try
            {
                if (!pclsCache.Connect())
                {
                    return IsSaved;
                }

                ret = (int)Ps.OutPatientInfo.SetData(pclsCache.CacheConnectionObject, UserId, VisitId, ClinicDate, HospitalCode, Department, Doctor, piUserId, piTerminalName, piTerminalIP, piDeviceType);
                if (ret == 1)
                {
                    IsSaved = true;
                }
                return IsSaved;
            }
            catch (Exception ex)
            {
                HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "Ps.OutPatientInfo.SetData", "数据库操作异常! error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
                return IsSaved;
            }
            finally
            {
                pclsCache.DisConnect();
            }
        }
コード例 #10
0
        //GetCategoryName WF 2014-12-2 
        public static string GetCategoryName(DataConnection pclsCache,string Code)
        {
            string ret = null;
            try
            {
                if (!pclsCache.Connect())
                {
                    //MessageBox.Show("Cache数据库连接失败");
                    return ret;

                }
                ret = (Cm.MstInfoItemCategory.GetCategoryName(pclsCache.CacheConnectionObject, Code)).ToString();
                return ret;
            }
            catch (Exception ex)
            {
                //MessageBox.Show(ex.ToString(), "保存失败!");
                HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "CmMstInfoItemCategory.GetCategoryName", "数据库操作异常! error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
                return ret;
            }
            finally
            {
                pclsCache.DisConnect();
            }
        }
コード例 #11
0
ファイル: CmMstUser.cs プロジェクト: luyao2211/WebService
        //SetData ZAM 2014-11-26
        public static bool SetData(DataConnection pclsCache, string UserId, string UserName, string Password, string Class, string PatientClass, int DoctorClass, int StartDate, int EndDate, DateTime LastLoginDateTime, string revUserId, string TerminalName, string TerminalIP, int DeviceType)
        {
            bool IsSaved = false;
            try
            {
                if (!pclsCache.Connect())
                {
                    //MessageBox.Show("Cache数据库连接失败");
                    return IsSaved;

                }
                int flag = (int)Cm.MstUser.SetData(pclsCache.CacheConnectionObject, UserId, UserName, Password, Class, PatientClass, DoctorClass, StartDate, EndDate, LastLoginDateTime, revUserId, TerminalName, TerminalIP, DeviceType);
                if (flag == 1)
                {
                    IsSaved = true;
                }
                return IsSaved;
            }
            catch (Exception ex)
            {
                //MessageBox.Show(ex.ToString(), "保存失败!");
                HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "CmMstUser.SetData", "数据库操作异常! error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
                return IsSaved;
            }
            finally
            {
                pclsCache.DisConnect();
            }


        }
コード例 #12
0
        //SetData  LS 2014-12-1
        public static bool SetData(DataConnection pclsCache, string UserId, int VisitId, int VisitType, int AdmissionDate, int DischargeDate, string HospitalCode, string Department, string piUserId, string piTerminalName, string piTerminalIP, int piDeviceType)
        {
            bool IsSaved = false;
            try
            {
                if (!pclsCache.Connect())
                {
                    //MessageBox.Show("Cache数据库连接失败");
                    return IsSaved;

                }
                int flag = (int)Ps.ClinicalInfo.SetData(pclsCache.CacheConnectionObject, UserId, VisitId, VisitType, AdmissionDate, DischargeDate, HospitalCode, Department, piUserId, piTerminalName, piTerminalIP, piDeviceType);
                if (flag == 1)
                {
                    IsSaved = true;
                }
                return IsSaved;
            }
            catch (Exception ex)
            {
                //MessageBox.Show(ex.ToString(), "保存失败!");
                HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "PsClinicalInfo.SetData", "数据库操作异常! error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
                return IsSaved;
            }
            finally
            {
                pclsCache.DisConnect();
            }
        }
コード例 #13
0
ファイル: PsVitalSigns.cs プロジェクト: luyao2211/WebService
 //SetData ZC 2014-12-2
 public static bool SetData(DataConnection pclsCache, string UserId, int RecordDate, int RecordTime, string ItemType, string ItemCode, string Value, string Unit, string revUserId, string TerminalName, string TerminalIP, int DeviceType)
 {
     bool IsSaved = false;
     try
     {
         if (!pclsCache.Connect())
         {
             return IsSaved;
         }
         int flag = (int)Ps.VitalSigns.SetData(pclsCache.CacheConnectionObject, UserId, RecordDate, RecordTime, ItemType, ItemCode, Value, Unit, revUserId, TerminalName, TerminalIP, DeviceType);
         if (flag == 1)
         {
             IsSaved = true;
         }
         return IsSaved;
     }
     catch (Exception ex)
     {
         HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "PsVitalSigns.SetData", "数据库操作异常! error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
         return IsSaved;
     }
     finally
     {
         pclsCache.DisConnect();
     }
 }
コード例 #14
0
ファイル: PsRoleMatch.cs プロジェクト: luyao2211/WebService
        //DeleteData WF 2015-07-01
        public static int DeleteData(DataConnection pclsCache, string PatientId, string RoleClass)
        {
            int Ret = 0;
            try
            {
                if (!pclsCache.Connect())
                {
                    //MessageBox.Show("Cache数据库连接失败");
                    return Ret;

                }
                Ret = (int)Ps.RoleMatch.DeleteData(pclsCache.CacheConnectionObject, PatientId, RoleClass);
                return Ret;
            }
            catch (Exception ex)
            {
                //MessageBox.Show(ex.ToString(), "保存失败!");
                HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "Ps.RoleMatch.DeleteData", "数据库操作异常! error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
                return Ret;
            }
            finally
            {
                pclsCache.DisConnect();
            }
        }
コード例 #15
0
ファイル: CmMstHospital.cs プロジェクト: luyao2211/WebService
        //DeleteData 删数据 ZYF 2014-12-01
        public static int DeleteData(DataConnection pclsCache, string Code)
        {
            int flag = 0;
            try
            {
                if (!pclsCache.Connect())
                {
                    //MessageBox.Show("Cache数据库连接失败");
                    return flag;

                }
                flag = (int)Cm.MstHospital.DeleteData(pclsCache.CacheConnectionObject, Code);

                return flag;
            }
            catch (Exception ex)
            {
                //MessageBox.Show(ex.ToString(), "保存失败!");
                HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "CmMstHospital.DeleteData", "数据库操作异常! error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
                return flag;
            }
            finally
            {
                pclsCache.DisConnect();
            }
        }
コード例 #16
0
ファイル: PsPatient2VS.cs プロジェクト: luyao2211/WebService
        //DeletePatient2VSInfo   LS 2014-12-1
        public static int DeletePatient2VSInfo(DataConnection pclsCache, string UserId, string VitalSignsType, string VitalSignsCode, string revUserId, string TerminalName, string TerminalIP, int DeviceType)
        {
            int ret = 0;
            try
            {
                if (!pclsCache.Connect())
                {
                    //MessageBox.Show("Cache数据库连接失败");
                    return ret;

                }
                ret = (int)Ps.Patient2VS.DeletePatient2VSInfo(pclsCache.CacheConnectionObject, UserId, VitalSignsType, VitalSignsCode, revUserId, TerminalName, TerminalIP, DeviceType);
                return ret;
            }
            catch (Exception ex)
            {
                //MessageBox.Show(ex.ToString(), "保存失败!");
                HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "PsPatient2VS.DeletePatient2VSInfo", "数据库操作异常! error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
                return ret;
            }
            finally
            {
                pclsCache.DisConnect();
            }
        }
コード例 #17
0
ファイル: PsSpecialList.cs プロジェクト: luyao2211/WebService
        //SetData YDS 2014-12-01 ZAM 更新ModuleType类型int改为string 与2014-12-08
        public static bool SetData(DataConnection pclsCache, string ModuleType, string PatientId, string DoctorId, int Level, string revUserId, string TerminalName, string TerminalIP, int DeviceType)
        {
            bool IsSaved = false;
            try
            {
                if (!pclsCache.Connect())
                {
                    //MessageBox.Show("Cache数据库连接失败");
                    return IsSaved;

                }
                int flag = (int)Ps.SpecialList.SetData(pclsCache.CacheConnectionObject, ModuleType, PatientId, DoctorId, Level, revUserId, TerminalName, TerminalIP, DeviceType);
                if (flag == 1)
                {
                    IsSaved = true;
                }
                return IsSaved;
            }
            catch (Exception ex)
            {
                //MessageBox.Show(ex.ToString(), "保存失败!");
                HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "PsSpecialList.SetData", "数据库操作异常! error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
                return IsSaved;
            }
            finally
            {
                pclsCache.DisConnect();
            }
        }
コード例 #18
0
 public static bool DeleteData(DataConnection pclsCache, string Code)
 {
     bool IsSaved = false;
     try
     {
         if (!pclsCache.Connect())
         {
             return IsSaved;
         }
         int flag = (int)Cm.MstInsurance.DeleteData(pclsCache.CacheConnectionObject, Code);
         if (flag == 1)
         {
             IsSaved = true;
         }
         return IsSaved;
     }
     catch (Exception ex)
     {
         HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "CmMstInsurance.DeleteData", "数据库操作异常! error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
         return IsSaved;
     }
     finally
     {
         pclsCache.DisConnect();
     }
 }
コード例 #19
0
        //CheckDoctorPhoneNumber TDY 2015-1-14
        public static int CheckDoctorPhoneNumber(DataConnection pclsCache, string UserId, string piPhoneNumber)
        {
            int ret = 0;
            try
            {
                if (!pclsCache.Connect())
                {
                    //MessageBox.Show("Cache数据库连接失败");
                    return ret;

                }
                ret = (int)Ps.DoctorInfoDetail.CheckDoctorPhoneNumber(pclsCache.CacheConnectionObject, UserId, piPhoneNumber);
                return ret;
            }
            catch (Exception ex)
            {
                //MessageBox.Show(ex.ToString(), "保存失败!");
                HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "PsDoctorInfoDetail.CheckDoctorPhoneNumber", "数据库操作异常! error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
                return ret;
            }
            finally
            {
                pclsCache.DisConnect();
            }
        }
コード例 #20
0
 //SetData ZC 2014-12-2
 public static bool SetData(DataConnection pclsCache, string UserId, string VisitId, string SortNo, string Code, string Value, int IsAbnormal, string Unit, string revUserId, string TerminalName, string TerminalIP, int DeviceType)
 {
     bool IsSaved = false;
     try
     {
         if (!pclsCache.Connect())
         {
             return IsSaved;
         }
         string LabTest = UserId + "||" + VisitId + "||" + SortNo.ToString();
         int flag = (int)Ps.LabTestDetails.SetData(pclsCache.CacheConnectionObject, LabTest, Code, Value, IsAbnormal, Unit, revUserId, TerminalName, TerminalIP, DeviceType);
         if (flag == 1)
         {
             IsSaved = true;
         }
         return IsSaved;
     }
     catch (Exception ex)
     {
         HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "PsLabTestDetails.SetData", "数据库操作异常! error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
         return IsSaved;
     }
     finally
     {
         pclsCache.DisConnect();
     }
 }
コード例 #21
0
ファイル: CmMstInfoItem.cs プロジェクト: luyao2211/WebService
        //SetData WF 2014-12-2 
        public static bool SetData(DataConnection pclsCache, string CategoryCode, string Code, string Name, string ParentCode, int SortNo, int StartDate, int EndDate, int GroupHeaderFlag, string ControlType, string OptionCategory, string revUserId, string TerminalName, string TerminalIP, int DeviceType)
        {
            bool IsSaved = false;
            try
            {
                if (!pclsCache.Connect())
                {
                    //MessageBox.Show("Cache数据库连接失败");
                    return IsSaved;

                }
                int flag = (int)Cm.MstInfoItem.SetData(pclsCache.CacheConnectionObject, CategoryCode, Code, Name, ParentCode, SortNo, StartDate, EndDate, GroupHeaderFlag, ControlType, OptionCategory, revUserId, TerminalName, TerminalIP, DeviceType);
                if (flag == 1)
                {
                    IsSaved = true;
                }
                return IsSaved;
            }
            catch (Exception ex)
            {
                //MessageBox.Show(ex.ToString(), "保存失败!");
                HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "CmMstInfoItem.SetData", "数据库操作异常! error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
                return IsSaved;
            }
            finally
            {
                pclsCache.DisConnect();
            }


        }
コード例 #22
0
        //GetLabTestDetails 获取患者某次化验的所有详细信息 ZC 2014-12-2
        //CSQ 2015-06-25
        public static DataTable GetLabTestDetails(DataConnection pclsCache, string UserId, string VisitId, string SortNo)
        {
            DataTable list = new DataTable();
            list.Columns.Add(new DataColumn("Code", typeof(string)));
            list.Columns.Add(new DataColumn("Name", typeof(string)));
            list.Columns.Add(new DataColumn("Value", typeof(string)));
            list.Columns.Add(new DataColumn("IsAbnormalCode", typeof(int)));
            list.Columns.Add(new DataColumn("IsAbnormal", typeof(string)));
            list.Columns.Add(new DataColumn("UnitCode", typeof(string)));
            list.Columns.Add(new DataColumn("Unit", typeof(string)));
            list.Columns.Add(new DataColumn("Creator", typeof(string)));


            CacheCommand cmd = null;
            CacheDataReader cdr = null;

            try
            {
                if (!pclsCache.Connect())
                {
                    return null;
                }
                cmd = new CacheCommand();
                cmd = Ps.LabTestDetails.GetLabTestDetails(pclsCache.CacheConnectionObject);
                cmd.Parameters.Add("UserId", CacheDbType.NVarChar).Value = UserId;
                cmd.Parameters.Add("VisitId", CacheDbType.NVarChar).Value = VisitId;
                cmd.Parameters.Add("SortNo", CacheDbType.NVarChar).Value = SortNo;
                //cmd.Parameters.Add("ItemCode", CacheDbType.NVarChar).Value = ItemCode;
                cdr = cmd.ExecuteReader();

                while (cdr.Read())
                {
                    list.Rows.Add(cdr["Code"].ToString(), cdr["Name"].ToString(), cdr["Value"].ToString(),
                        Convert.ToInt32(cdr["IsAbnormalCode"].ToString()), cdr["IsAbnormal"].ToString(),
                        cdr["UnitCode"].ToString(), cdr["Unit"].ToString(), cdr["Creator"].ToString());
                }
                return list;
            }
            catch (Exception ex)
            {
                HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "PsLabTestDetails.GetLabTestDetails", "数据库操作异常! error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
                return null;
            }
            finally
            {
                if ((cdr != null))
                {
                    cdr.Close();
                    cdr.Dispose(true);
                    cdr = null;
                }
                if ((cmd != null))
                {
                    cmd.Parameters.Clear();
                    cmd.Dispose();
                    cmd = null;
                }
                pclsCache.DisConnect();
            }
        }        
コード例 #23
0
        //GetMaxSortNo SYF 2015-07-06 
        public static int GetMaxSortNo(DataConnection pclsCache, string UserId)
        {
            int ret = 0;
            try
            {
                if (!pclsCache.Connect())
                {
                    //MessageBox.Show("Cache数据库连接失败");
                    return ret;

                }
                ret = (int)Ps.TreatmentIndicators.GetMaxSortNo(pclsCache.CacheConnectionObject, UserId);
                return ret;
            }
            catch (Exception ex)
            {
                //MessageBox.Show(ex.ToString(), "保存失败!");
                HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "PsTreatmentIndicators.GetMaxSortNo", "数据库操作异常! error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
                return ret;
            }
            finally
            {
                pclsCache.DisConnect();
            }
        }
コード例 #24
0
        //SetData WY 2015-07-10
        public static bool SetData(DataConnection pclsCache, string HospitalCode, string HZCode, string Type, string Code, string Redundance, string revUserId, string TerminalName, string TerminalIP, int DeviceType)
        {
            bool IsSaved = false;
            try
            {
                if (!pclsCache.Connect())
                {
                    //MessageBox.Show("Cache数据库连接失败");
                    return IsSaved;

                }
                int flag = (int)Mp.LabTestItemsCmp.SetData(pclsCache.CacheConnectionObject, HospitalCode, HZCode, Type, Code, Redundance, revUserId, TerminalName, TerminalIP, DeviceType);
                if (flag == 1)
                {
                    IsSaved = true;
                }
                return IsSaved;
            }
            catch (Exception ex)
            {
                //MessageBox.Show(ex.ToString(), "保存失败!");
                HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "LabTestItemsCmp.SetData", "数据库操作异常! error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
                return IsSaved;
            }
            finally
            {
                pclsCache.DisConnect();
            }
        }
コード例 #25
0
ファイル: PsDoctorInfo.cs プロジェクト: luyao2211/WebService
        //SetData  LS 2014-12-1
        public static bool SetData(DataConnection pclsCache, string UserId, string UserName, int Birthday, int Gender, string IDNo, int InvalidFlag, string piUserId, string piTerminalName, string piTerminalIP, int piDeviceType)
        {
            bool IsSaved = false;
            try
            {
                if (!pclsCache.Connect())
                {
                    //MessageBox.Show("Cache数据库连接失败");
                    return IsSaved;

                }
                int flag = (int)Ps.DoctorInfo.SetData(pclsCache.CacheConnectionObject, UserId, UserName, Birthday, Gender, IDNo, InvalidFlag, piUserId, piTerminalName, piTerminalIP, piDeviceType);
                if (flag == 1)
                {
                    IsSaved = true;
                }
                return IsSaved;
            }
            catch (Exception ex)
            {
                //MessageBox.Show(ex.ToString(), "保存失败!");
                HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "PsDoctorInfo.SetData", "数据库操作异常! error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
                return IsSaved;
            }
            finally
            {
                pclsCache.DisConnect();
            }
        }
コード例 #26
0
 // ChangeStatus WY 2015-07-10
 public static bool Delete(DataConnection pclsCache, string HospitalCode, string HZCode)
 {
     bool IsSaved = false;
     try
     {
         //if (!pclsCache.Connect())
         //{
         //    //MessageBox.Show("Cache数据库连接失败");
         //    return IsSaved;
         //}
         //int flag = (int)Mp.LabTestItemsCmp.Delete(pclsCache.CacheConnectionObject, HospitalCode, HZCode);
         //if (flag == 1)
         //{
         //    IsSaved = true;
         //}
         return IsSaved;
     }
     catch (Exception ex)
     {
         //MessageBox.Show(ex.ToString(), "获取名称失败!");
         HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "LabTestItemsCmp.Delete", "数据库操作异常! error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
         return IsSaved;
     }
     finally
     {
         pclsCache.DisConnect();
     }
 }
コード例 #27
0
        //SetData YDS 2014-12-01
        public static bool SetData(DataConnection pclsCache, string AlertItemCode, string AlertItemName, decimal Min, decimal Max, string Units, string Remarks, string revUserId, string TerminalName, string TerminalIP, int DeviceType)
        {
            bool IsSaved = false;
            try
            {
                if (!pclsCache.Connect())
                {
                    //MessageBox.Show("Cache数据库连接失败");
                    return IsSaved;

                }
                int flag = (int)Wn.MstBasicAlert.SetData(pclsCache.CacheConnectionObject, AlertItemCode, AlertItemName, Min, Max, Units, Remarks, revUserId, TerminalName, TerminalIP, DeviceType);
                if (flag == 1)
                {
                    IsSaved = true;
                }
                return IsSaved;
            }
            catch (Exception ex)
            {
                //MessageBox.Show(ex.ToString(), "保存失败!");
                HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "WnMstBasicAlert.SetData", "数据库操作异常! error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
                return IsSaved;
            }
            finally
            {
                pclsCache.DisConnect();
            }
        }
コード例 #28
0
ファイル: TmpExamDict.cs プロジェクト: luyao2211/WebService
 // ChangeStatus WY 2015-07-13
 public static bool ChangeStatus(DataConnection pclsCache, string HospitalCode, string Code, int Status)
 {
     bool IsSaved = false;
     try
     {
         if (!pclsCache.Connect())
         {
             //MessageBox.Show("Cache数据库连接失败");
             return IsSaved;
         }
         int flag = (int)Tmp.ExamDict.ChangeStatus(pclsCache.CacheConnectionObject, HospitalCode, Code, Status);
         if (flag == 1)
         {
             IsSaved = true;
         }
         return IsSaved;
     }
     catch (Exception ex)
     {
         //MessageBox.Show(ex.ToString(), "获取名称失败!");
         HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "Tmp.ExamDict.ChangeStatus", "数据库操作异常! error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
         return IsSaved;
     }
     finally
     {
         pclsCache.DisConnect();
     }
 }
コード例 #29
0
ファイル: CmMstRole.cs プロジェクト: luyao2211/WebService
        //SetData ZAM 2014-11-26
        public static bool SetData(DataConnection pclsCache, string Code, string Name, int SortNo, string Redundance, int InvalidFlag)
        {
            bool IsSaved = false;
            try
            {
                if (!pclsCache.Connect())
                {
                    //MessageBox.Show("Cache数据库连接失败");
                    return IsSaved;

                }
                int flag = (int)Cm.MstRole.SetData(pclsCache.CacheConnectionObject, Code, Name, SortNo, Redundance, InvalidFlag);
                if (flag == 1)
                {
                    IsSaved = true;
                }
                return IsSaved;
            }
            catch (Exception ex)
            {
                //MessageBox.Show(ex.ToString(), "保存失败!");
                HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "CmMstRole.SetData", "数据库操作异常! error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
                return IsSaved;
            }
            finally
            {
                pclsCache.DisConnect();
            }


        }
コード例 #30
0
        //GetUntreatedAlertAmount GL 2014-12-01 根据用户ID,获取患者未处理警报数
        public static int GetUntreatedAlertAmount(DataConnection pclsCache, string PatientId)
        {
            int UntreatedAlertAmount = 0;
            try
            {
                if (!pclsCache.Connect())
                {
                    //MessageBox.Show("Cache数据库连接失败");
                    return UntreatedAlertAmount;

                }
                UntreatedAlertAmount = (int)Wn.TrnAlertRecord.GetUntreatedAlertAmount(pclsCache.CacheConnectionObject, PatientId);
                return UntreatedAlertAmount;
            }
            catch (Exception ex)
            {
                //MessageBox.Show(ex.ToString(), "保存失败!");
                HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "WnTrnAlertRecord.GetUntreatedAlertAmount", "数据库操作异常! error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
                return UntreatedAlertAmount;
            }
            finally
            {
                pclsCache.DisConnect();
            }
        }