// GetUserInfoByUserId ZAM 2014-11-26 public static CacheSysList GetUserInfoByUserId(DataConnection pclsCache, string UserId) { //DataTable list = new DataTable(); //list.Columns.Add(new DataColumn("UserId", typeof(string))); //list.Columns.Add(new DataColumn("UserName", typeof(string))); //list.Columns.Add(new DataColumn("Password", typeof(string))); //list.Columns.Add(new DataColumn("Class", typeof(string))); //list.Columns.Add(new DataColumn("StartDate", typeof(string))); //list.Columns.Add(new DataColumn("EndDate", typeof(string))); try { CacheSysList CacheList = new InterSystems.Data.CacheTypes.CacheSysList(System.Text.Encoding.Unicode, true, true); if (!pclsCache.Connect()) { return null; } CacheList = Cm.MstUser.GetUserInfoByUserId(pclsCache.CacheConnectionObject, UserId); return CacheList; } catch (Exception ex) { //MessageBox.Show(ex.ToString(), "获取名称失败!"); HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "CmMstUser.GetUserInfoByUserId", "数据库操作异常! error information : " + ex.Message + Environment.NewLine + ex.StackTrace); return null; } finally { pclsCache.DisConnect(); } }
//GetExecutingPlan 获取正在执行的计划 LS 2015-03-30 public static CacheSysList GetExecutingPlan(DataConnection pclsCache, string PatientId) { try { CacheSysList CacheList = new InterSystems.Data.CacheTypes.CacheSysList(System.Text.Encoding.Unicode, true, true); if (!pclsCache.Connect()) { return null; } CacheList = Ps.Plan.GetExecutingPlan(pclsCache.CacheConnectionObject, PatientId); return CacheList; } catch (Exception ex) { HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "PsPlan.GetExecutingPlan", "数据库操作异常! error information : " + ex.Message + Environment.NewLine + ex.StackTrace); return null; } finally { pclsCache.DisConnect(); } }
//GetDoctorDetailInfo TDY 2015-01-12 public static CacheSysList GetDoctorDetailInfo(DataConnection pclsCache, string UserId) { try { CacheSysList CacheList = new InterSystems.Data.CacheTypes.CacheSysList(System.Text.Encoding.Unicode, true, true); if (!pclsCache.Connect()) { return null; } CacheList = Ps.DoctorInfoDetail.GetDoctorDetailInfo(pclsCache.CacheConnectionObject, UserId); return CacheList; } catch (Exception ex) { //MessageBox.Show(ex.ToString(), "获取名称失败!"); HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "PsDoctorInfoDetail.GetDoctorDetailInfo", "数据库操作异常! error information : " + ex.Message + Environment.NewLine + ex.StackTrace); return null; } finally { pclsCache.DisConnect(); } }
// GetWnMstPersonalAlert GL 2014-12-01 获取最新一条警告 public static CacheSysList GetWnMstPersonalAlert(DataConnection pclsCache, string UserId, string AlertItemCode, int CheckDate) { try { CacheSysList AlertList = new InterSystems.Data.CacheTypes.CacheSysList(System.Text.Encoding.Unicode, true, true); if (!pclsCache.Connect()) { return null; } AlertList = Wn.MstPersonalAlert.GetWnMstPersonalAlert(pclsCache.CacheConnectionObject, UserId, AlertItemCode, CheckDate); return AlertList; } catch (Exception ex) { //MessageBox.Show(ex.ToString(), "获取名称失败!"); HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "WnMstPersonalAlert.GetWnMstPersonalAlert", "数据库操作异常! error information : " + ex.Message + Environment.NewLine + ex.StackTrace); return null; } finally { pclsCache.DisConnect(); } }
//GetTargetById TDY 2015-04-07 public static CacheSysList GetTargetById(DataConnection pclsCache, string Plan, string Id) { CacheSysList ret = new InterSystems.Data.CacheTypes.CacheSysList(System.Text.Encoding.Unicode, true, true); try { if (!pclsCache.Connect()) { return ret; } ret = Ps.Target.GetTargetById(pclsCache.CacheConnectionObject, Plan, Id); return ret; } catch (Exception ex) { HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "Ps.Target.GetTargetById", "数据库操作异常! error information : " + ex.Message + Environment.NewLine + ex.StackTrace); return ret; } finally { pclsCache.DisConnect(); } }
// GetDoctorInfoWithMod, 返回包含模块信息的医生信息 ZYF 2014-12-4 public static DataTable GetDoctorInfoWithMod(DataConnection pclsCache, string DoctorId) { DataTable list = new DataTable(); list.Columns.Add(new DataColumn("DoctorId", typeof(string))); list.Columns.Add(new DataColumn("DoctorName", typeof(string))); list.Columns.Add(new DataColumn("Birthday", typeof(int))); list.Columns.Add(new DataColumn("Gender", typeof(int))); list.Columns.Add(new DataColumn("IDNo", typeof(string))); list.Columns.Add(new DataColumn("InvalidFlag", typeof(int))); list.Columns.Add(new DataColumn("ModuleString", typeof(string))); string strMod = ""; DataTable DTMod = new DataTable(); try { CacheSysList CacheList = new InterSystems.Data.CacheTypes.CacheSysList(System.Text.Encoding.Unicode, true, true); if (!pclsCache.Connect()) { return null; } CacheList = Ps.DoctorInfo.GetDoctorInfo(pclsCache.CacheConnectionObject, DoctorId); DTMod = GetDoctorModuleList(pclsCache, DoctorId); foreach (DataRow dr in DTMod.Rows) { if (dr["Value"] != null) { if (dr["Value"].ToString() == "0") { if (strMod == "") { strMod = strMod + dr["CategoryName"].ToString(); } else { strMod = strMod + "," + dr["CategoryName"].ToString(); } } } } if (CacheList != null) //value check ZAM 2015-1-7 { list.Rows.Add(CacheList[0].ToString(), CacheList[1].ToString(), CacheList[2].ToString(), CacheList[3].ToString(), CacheList[4], CacheList[5], strMod); } //list.Rows.Add(CacheList[0].ToString(), CacheList[1].ToString(), CacheList[2].ToString(), CacheList[3].ToString(), CacheList[4], CacheList[5], strMod); return list; } catch (Exception ex) { //MessageBox.Show(ex.ToString(), "获取名称失败!"); HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "PsDoctorInfo.GetDoctorInfoWithMod", "数据库操作异常! error information : " + ex.Message + Environment.NewLine + ex.StackTrace); return null; } finally { pclsCache.DisConnect(); } }
// GetDoctorInfo返回医生基本信息 ZYF 2014-12-4 public static DataTable GetDoctorInfo(DataConnection pclsCache, string DoctorId) { DataTable list = new DataTable(); list.Columns.Add(new DataColumn("DoctorId", typeof(string))); list.Columns.Add(new DataColumn("DoctorName", typeof(string))); list.Columns.Add(new DataColumn("Birthday", typeof(int))); list.Columns.Add(new DataColumn("Gender", typeof(int))); list.Columns.Add(new DataColumn("IDNo", typeof(string))); list.Columns.Add(new DataColumn("InvalidFlag", typeof(int))); try { CacheSysList CacheList = new InterSystems.Data.CacheTypes.CacheSysList(System.Text.Encoding.Unicode, true, true); if (!pclsCache.Connect()) { return null; } CacheList = Ps.DoctorInfo.GetDoctorInfo(pclsCache.CacheConnectionObject, DoctorId); //DataCheck ZAM 2015-1-7 if (CacheList != null) { list.Rows.Add(CacheList[0].ToString(), CacheList[1].ToString(), CacheList[2].ToString(), CacheList[3].ToString(), CacheList[4], CacheList[5]); } // //list.Rows.Add(CacheList[0].ToString(), CacheList[1].ToString(), CacheList[2].ToString(), CacheList[3].ToString(), CacheList[4], CacheList[5]); return list; } catch (Exception ex) { //MessageBox.Show(ex.ToString(), "获取名称失败!"); HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "PsDoctorInfo.GetDoctorInfo", "数据库操作异常! error information : " + ex.Message + Environment.NewLine + ex.StackTrace); return null; } finally { pclsCache.DisConnect(); } }
//WF 20150514 public static DataTable GetAll(DataConnection pclsCache, string Module, string HealthId) { DataTable list = new DataTable(); list.Columns.Add(new DataColumn("Module", typeof(string))); list.Columns.Add(new DataColumn("HealthId", typeof(string))); list.Columns.Add(new DataColumn("Type", typeof(int))); list.Columns.Add(new DataColumn("TypeName", typeof(string))); list.Columns.Add(new DataColumn("FileName", typeof(string))); list.Columns.Add(new DataColumn("Path", typeof(string))); list.Columns.Add(new DataColumn("Introduction", typeof(string))); list.Columns.Add(new DataColumn("Redundance", typeof(string))); list.Columns.Add(new DataColumn("ReUserId", typeof(string))); list.Columns.Add(new DataColumn("ReUserName", typeof(string))); try { CacheSysList CacheList = new InterSystems.Data.CacheTypes.CacheSysList(System.Text.Encoding.Unicode, true, true); if (!pclsCache.Connect()) { return null; } CacheList = Cm.MstHealthEducation.GetAll(pclsCache.CacheConnectionObject, Module, HealthId); if (CacheList != null) { list.Rows.Add(CacheList[0].ToString(), CacheList[1].ToString(), CacheList[2], CacheList[3].ToString(), CacheList[4].ToString(), CacheList[5].ToString(), CacheList[6].ToString(), CacheList[7].ToString(), CacheList[8].ToString(), CacheList[9].ToString()); } return list; } catch (Exception ex) { //MessageBox.Show(ex.ToString(), "获取名称失败!"); HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "Cm.MstHealthEducation.GetAll", "数据库操作异常! error information : " + ex.Message + Environment.NewLine + ex.StackTrace); return null; } finally { pclsCache.DisConnect(); } }
public static CacheSysList GetCmTaskItemInfo(DataConnection pclsCache, string CategoryCode, string Code) { try { CacheSysList CacheList = new InterSystems.Data.CacheTypes.CacheSysList(System.Text.Encoding.Unicode, true, true); if (!pclsCache.Connect()) { return null; } CacheList = Cm.MstTask.GetCmTaskItemInfo(pclsCache.CacheConnectionObject, CategoryCode, Code); return CacheList; } catch (Exception ex) { HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "CmMstTask.GetCmTaskItemInfo", "数据库操作异常! error information : " + ex.Message + Environment.NewLine + ex.StackTrace); return null; } finally { pclsCache.DisConnect(); } }
// GetPatientVitalSignsAndThreshold LS 2014-12-4 public static DataTable GetPatientVitalSignsAndThreshold(DataConnection pclsCache, string UserId, string ItemType, string ItemCode) { DataTable list = new DataTable(); list.Columns.Add(new DataColumn("RecordDate", typeof(int))); list.Columns.Add(new DataColumn("RecordTime", typeof(int))); list.Columns.Add(new DataColumn("Value", typeof(string))); list.Columns.Add(new DataColumn("Unit", typeof(string))); list.Columns.Add(new DataColumn("ThreholdMin", typeof(decimal))); list.Columns.Add(new DataColumn("ThreholdMax", typeof(decimal))); CacheCommand cmd = null; CacheDataReader cdr = null; try { if (!pclsCache.Connect()) { return(null); } cmd = new CacheCommand(); cmd = Ps.VitalSigns.GetPatientVitalSigns(pclsCache.CacheConnectionObject); cmd.Parameters.Add("piUserId", CacheDbType.NVarChar).Value = UserId; cmd.Parameters.Add("piItemType", CacheDbType.NVarChar).Value = ItemType; cmd.Parameters.Add("piItemCode", CacheDbType.NVarChar).Value = ItemCode; cdr = cmd.ExecuteReader(); while (cdr.Read()) { int RecordDate = Convert.ToInt32(cdr["RecordDate"]); int RecordTime = Convert.ToInt32(cdr["RecordTime"]); string Value = cdr["Value"].ToString(); string Unit = cdr["Unit"].ToString(); InterSystems.Data.CacheTypes.CacheSysList Threholdlist = new InterSystems.Data.CacheTypes.CacheSysList(System.Text.Encoding.Unicode, true, true); Threholdlist = Wn.MstPersonalAlert.GetWnMstPersonalAlert(pclsCache.CacheConnectionObject, UserId, ItemCode, RecordDate); //ZAM 2015-1-12 //if (Threholdlist == null) if ((Threholdlist == null) || (Threholdlist.Count == 0)) { Threholdlist = Wn.MstBasicAlert.GetWnMstBasicAlert(pclsCache.CacheConnectionObject, ItemCode); } if (Threholdlist != null) { list.Rows.Add(RecordDate, RecordTime, Value, Unit, Threholdlist[1], Threholdlist[2]); } // //if (Threholdlist == null) //{ // Threholdlist = Wn.MstBasicAlert.GetWnMstBasicAlert(pclsCache.CacheConnectionObject, ItemCode); //} //list.Rows.Add(RecordDate, RecordTime, Value, Unit, Threholdlist[1], Threholdlist[2]); // } return(list); } catch (Exception ex) { HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "PsVitalSigns.GetPatientVitalSignsAndThreshold", "数据库操作异常! 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(); } }
//GetSignByDay TDY 2015-04-07 public static CacheSysList GetSignByDay(DataConnection pclsCache, string UserId, string ItemType, string ItemCode, int RecordDate) { CacheSysList ret = new InterSystems.Data.CacheTypes.CacheSysList(System.Text.Encoding.Unicode, true, true); try { if (!pclsCache.Connect()) { return ret; } ret = Ps.VitalSigns.GetSignByDay(pclsCache.CacheConnectionObject, UserId, ItemType, ItemCode, RecordDate); return ret; } catch (Exception ex) { HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "Ps.VitalSigns.GetSignByDay", "数据库操作异常! error information : " + ex.Message + Environment.NewLine + ex.StackTrace); return ret; } finally { pclsCache.DisConnect(); } }
// GetPatientVitalSignsAndThreshold LS 2014-12-4 public static DataTable GetPatientVitalSignsAndThreshold(DataConnection pclsCache, string UserId, string ItemType, string ItemCode) { DataTable list = new DataTable(); list.Columns.Add(new DataColumn("RecordDate", typeof(int))); list.Columns.Add(new DataColumn("RecordTime", typeof(int))); list.Columns.Add(new DataColumn("Value", typeof(string))); list.Columns.Add(new DataColumn("Unit", typeof(string))); list.Columns.Add(new DataColumn("ThreholdMin", typeof(decimal))); list.Columns.Add(new DataColumn("ThreholdMax", typeof(decimal))); CacheCommand cmd = null; CacheDataReader cdr = null; try { if (!pclsCache.Connect()) { return null; } cmd = new CacheCommand(); cmd = Ps.VitalSigns.GetPatientVitalSigns(pclsCache.CacheConnectionObject); cmd.Parameters.Add("piUserId", CacheDbType.NVarChar).Value = UserId; cmd.Parameters.Add("piItemType", CacheDbType.NVarChar).Value = ItemType; cmd.Parameters.Add("piItemCode", CacheDbType.NVarChar).Value = ItemCode; cdr = cmd.ExecuteReader(); while (cdr.Read()) { int RecordDate = Convert.ToInt32(cdr["RecordDate"]); int RecordTime = Convert.ToInt32(cdr["RecordTime"]); string Value = cdr["Value"].ToString(); string Unit = cdr["Unit"].ToString(); InterSystems.Data.CacheTypes.CacheSysList Threholdlist = new InterSystems.Data.CacheTypes.CacheSysList(System.Text.Encoding.Unicode, true, true); Threholdlist = Wn.MstPersonalAlert.GetWnMstPersonalAlert(pclsCache.CacheConnectionObject, UserId, ItemCode, RecordDate); //ZAM 2015-1-12 //if (Threholdlist == null) if ((Threholdlist == null) || (Threholdlist.Count == 0)) { Threholdlist = Wn.MstBasicAlert.GetWnMstBasicAlert(pclsCache.CacheConnectionObject, ItemCode); } if (Threholdlist != null) { list.Rows.Add(RecordDate, RecordTime, Value, Unit, Threholdlist[1], Threholdlist[2]); } // //if (Threholdlist == null) //{ // Threholdlist = Wn.MstBasicAlert.GetWnMstBasicAlert(pclsCache.CacheConnectionObject, ItemCode); //} //list.Rows.Add(RecordDate, RecordTime, Value, Unit, Threholdlist[1], Threholdlist[2]); // } return list; } catch (Exception ex) { HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "PsVitalSigns.GetPatientVitalSignsAndThreshold", "数据库操作异常! 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(); } }