public static int SetData(DataConnection pclsCache, string UserId, string VisitId, int SortNo, string ExamType, string ExamDate, string ItemCode, string ExamPara, string Description, string Impression, string Recommendation, int IsAbnormal, string Status, string ReportDate, string ImageURL, string DeptCode, string revUserId, string TerminalName, string TerminalIP, int DeviceType)
{
int ret = 0;
try
{
if (!pclsCache.Connect())
{
return(ret);
}
DateTime Exam_Date = Convert.ToDateTime(ExamDate);
DateTime Report_Date = new DateTime();
if (ReportDate != "")
{
Report_Date = Convert.ToDateTime(ReportDate);
}
else
{
Report_Date = Convert.ToDateTime("1900/01/01 0:00:00");
}
ret = (int)Ps.Examination.SetData(pclsCache.CacheConnectionObject, UserId, VisitId, SortNo, ExamType, Exam_Date, ItemCode, ExamPara, Description, Impression, Recommendation, IsAbnormal, Status, Report_Date, ImageURL, DeptCode, revUserId, TerminalName, TerminalIP, DeviceType);
return(ret);
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "Ps.Examination.SetData", "数据库操作异常！ error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
return(ret);
}
finally
{
pclsCache.DisConnect();
}
}
//GetMaxCode YDS 2014-12-22
public static string GetMaxCode(DataConnection pclsCache, string Type)
{
string ret = string.Empty;
try
{
if (!pclsCache.Connect())
{
//MessageBox.Show("Cache数据库连接失败");
return(ret);
}
ret = Cm.MstTreatment.GetMaxCode(pclsCache.CacheConnectionObject, Type);
return(ret);
}
catch (Exception ex)
{
//MessageBox.Show(ex.ToString(), "保存失败！");
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "CmMstTreatment.GetMaxCode", "数据库操作异常！ error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
return(ret);
}
finally
{
pclsCache.DisConnect();
}
}
//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();
}
}
//CheckPhoneNumber WF 2014-12-2 TDY 2015-1-14
public static int CheckPatientPhoneNumber(DataConnection pclsCache, string UserId, string piPhoneNumber)
{
int ret = 0;
try
{
if (!pclsCache.Connect())
{
//MessageBox.Show("Cache数据库连接失败");
return(ret);
}
ret = (int)Ps.BasicInfoDetail.CheckPatientPhoneNumber(pclsCache.CacheConnectionObject, UserId, piPhoneNumber);
return(ret);
}
catch (Exception ex)
{
//MessageBox.Show(ex.ToString(), "保存失败！");
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "PsBasicInfoDetail.CheckPatientPhoneNumber", "数据库操作异常！ error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
return(ret);
}
finally
{
pclsCache.DisConnect();
}
}
//DeleteData YDS 2014-12-01
public static int DeleteData(DataConnection pclsCache, string Type, string Code)
{
int ret = 0;
try
{
if (!pclsCache.Connect())
{
//MessageBox.Show("Cache数据库连接失败");
return(ret);
}
ret = (int)Cm.MstTreatment.DeleteData(pclsCache.CacheConnectionObject, Type, Code);
return(ret);
}
catch (Exception ex)
{
//MessageBox.Show(ex.ToString(), "删除失败！");
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "CmMstTreatment.DeleteData", "数据库操作异常！ error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
return(ret);
}
finally
{
pclsCache.DisConnect();
}
}
//public CmMstInfoItem Get(string CategoryCode, string Code, int StartDate)
//{
// List<CmMstInfoItem> CmMstInfoItemList = new List<CmMstInfoItem>();
// GetCmMstInfoItem(CmMstInfoItemList);
// return CmMstInfoItemList.Find(p => p.CategoryCode == CategoryCode && p.Code == Code && p.StartDate == StartDate);
//}
public int Remove(string CategoryCode, string Code, int StartDate)
{
int ret = 3;
try
{
if (!pclsCache.Connect())
{
//MessageBox.Show("Cache数据库连接失败");
return(ret);
}
ret = (int)Cm.MstInfoItem.DeleteData(pclsCache.CacheConnectionObject, CategoryCode, Code);
return(ret);
}
catch (Exception ex)
{
//MessageBox.Show(ex.ToString(), "保存失败！");
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "CmMstInfoItem.DeleteData", "数据库操作异常！ error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
return(ret);
}
finally
{
pclsCache.DisConnect();
}
}
//GetExamDetails 获取患者某次检查的所有详细信息 ZC 2014-12-2
//CSQ 2015-1-21
public static DataTable GetExamDetails(DataConnection pclsCache, string UserId, string VisitId, string SortNo, string ItemCode)
{
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.ExamDetails.GetExamDetails(pclsCache.CacheConnectionObject);
cmd.Parameters.Add("UserId", CacheDbType.NVarChar).Value = UserId;
cmd.Parameters.Add("VisitId", CacheDbType.NVarChar).Value = VisitId;
cmd.Parameters.Add("SortNo", CacheDbType.Int).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, "PsExamDetails.GetExamDetails", "数据库操作异常！ 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();
}
}
//
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.DrugCmp.Delete(pclsCache.CacheConnectionObject, HospitalCode, HZCode);
//if (flag == 1)
//{
// IsSaved = true;
//}
return(IsSaved);
}
catch (Exception ex)
{
//MessageBox.Show(ex.ToString(), "获取名称失败！");
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "MpDrugCmp.Delete", "数据库操作异常！ error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
return(IsSaved);
}
finally
{
pclsCache.DisConnect();
}
}
//GetMaxItemSeq LS 2014-12-1
public static int GetMaxItemSeq(DataConnection pclsCache, string DoctorId, string CategoryCode, string ItemCode)
{
int ret = 0;
try
{
if (!pclsCache.Connect())
{
//MessageBox.Show("Cache数据库连接失败");
return(ret);
}
ret = (int)Ps.DoctorInfoDetail.GetMaxItemSeq(pclsCache.CacheConnectionObject, DoctorId, CategoryCode, ItemCode);
return(ret);
}
catch (Exception ex)
{
//MessageBox.Show(ex.ToString(), "保存失败！");
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "PsDoctorInfoDetail.GetMaxItemSeq", "数据库操作异常！ error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
return(ret);
}
finally
{
pclsCache.DisConnect();
}
}
/// <summary>
/// 获取病人最新体征情况 GL 2015-10-10
/// </summary>
/// <param name="UserId"></param>
/// <param name="ItemType"></param>
/// <param name="ItemCode"></param>
/// <returns></returns>
public ValueTime GetLatestPatientVitalSigns(DataConnection pclsCache, string UserId, string ItemType, string ItemCode)
{
ValueTime item = new ValueTime();
try
{
if (!pclsCache.Connect())
{
return(item);
}
InterSystems.Data.CacheTypes.CacheSysList list = null;
list = Ps.VitalSigns.GetLatestPatientVitalSigns(pclsCache.CacheConnectionObject, UserId, ItemType, ItemCode);
if (list != null)
{
item.Value = list[0];
item.RecordDate = list[1];
item.RecordTime = list[2];
}
return(item);
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "VitalInfoMethod.GetLatestPatientVitalSigns", "数据库操作异常！ error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
return(item);
}
finally
{
pclsCache.DisConnect();
}
}
/// <summary>
/// 获取某日期之后的有数据的起止时间 GL 2015-10-10
/// </summary>
/// <param name="UserId"></param>
/// <param name="date"></param>
/// <param name="Num"></param>
/// <returns></returns>
public VitalInfo GetVitalSignDates(DataConnection pclsCache, string UserId, int date, int Num)
{
try
{
VitalInfo item = new VitalInfo();
InterSystems.Data.CacheTypes.CacheSysList list = null;
if (!pclsCache.Connect())
{
return(null);
}
list = Ps.VitalSigns.GetVitalSignDates(pclsCache.CacheConnectionObject, UserId, date, Num);
if (list != null)
{
item.StartDate = list[0];
item.EndDate = list[1];
}
return(item);
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "VitalInfoMethod.GetVitalSignDates", "数据库操作异常！ error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
return(null);
}
finally
{
pclsCache.DisConnect();
}
}
public static int checkverification(string mobile, string smsType, string verification) //Verification是前端传进来的验证码
{
try
{
var Client = new RedisClient("127.0.0.1", 6379);
var verify = Client.Get <string>(mobile + smsType);
if (verify != null)
{
if (verify == verification)
{
return(1);//验证码正确
}
else
{
return(2);//验证码错误
}
}
else
{
return(0);//没有验证码或验证码已过期
}
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "匹配验证码功能错误", "WebService调用异常！ error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
return(3);
throw (ex);
}
}
//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();
}
}
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.OperationDict.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.OperationDict.ChangeStatus", "数据库操作异常！ error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
return(IsSaved);
}
finally
{
pclsCache.DisConnect();
}
}
// GetRole ZAM 2014-12-02
public static DataTable GetRole(DataConnection pclsCache)
{
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("SortNo", typeof(int)));
list.Columns.Add(new DataColumn("Redundance", typeof(string)));
list.Columns.Add(new DataColumn("InvalidFlag", typeof(int)));
CacheCommand cmd = null;
CacheDataReader cdr = null;
try
{
if (!pclsCache.Connect())
{
//MessageBox.Show("Cache数据库连接失败");
return(null);
}
cmd = new CacheCommand();
cmd = Cm.MstRole.GetRole(pclsCache.CacheConnectionObject);
//cmd.Parameters.Add("Category", CacheDbType.NVarChar).Value = Category;
//cmd.Parameters.Add("InvalidFlag", CacheDbType.Int).Value = InvalidFlag;
cdr = cmd.ExecuteReader();
while (cdr.Read())
{
int InvalidFlag = 0; //value check ZAM 2014-1-7
if (cdr["InvalidFlag"].ToString() != "")
{
InvalidFlag = Convert.ToInt32(cdr["InvalidFlag"]);
}
list.Rows.Add(cdr["Code"].ToString(), cdr["Name"].ToString(), cdr["SortNo"], cdr["Redundance"].ToString(), InvalidFlag);
}
return(list);
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "CmMstRole.GetRole", "数据库操作异常！ 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();
}
}
//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();
}
}
private bool SetData(CmMstInfoItem item)
{
bool IsSaved = false;
try
{
if (!pclsCache.Connect())
{
//MessageBox.Show("Cache数据库连接失败");
return(IsSaved);
}
int flag = (int)Cm.MstInfoItem.SetData(pclsCache.CacheConnectionObject, item.CategoryCode, item.Code, item.Name, item.ParentCode, item.SortNo, item.StartDate, item.EndDate, item.GroupHeaderFlag, item.ControlType, item.OptionCategory, item.RevUserId, item.TerminalName, item.TerminalIP, item.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();
}
}
//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();
}
}
//SetData ZC 2014-12-2
public static bool SetData(DataConnection pclsCache, string UserId, string VisitId, int 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 Exam = UserId + "||" + VisitId + "||" + SortNo.ToString();
int flag = (int)Ps.ExamDetails.SetData(pclsCache.CacheConnectionObject, Exam, Code, Value, IsAbnormal, Unit, revUserId, TerminalName, TerminalIP, DeviceType);
if (flag == 1)
{
IsSaved = true;
}
return(IsSaved);
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "PsExamDetails.SetData", "数据库操作异常！ error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
return(IsSaved);
}
finally
{
pclsCache.DisConnect();
}
}
//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();
}
}
//SetData WF 2014-12-2
public static bool SetData(DataConnection pclsCache, string Patient, string CategoryCode, string ItemCode, int ItemSeq, string Value, string Description, int SortNo, string revUserId, string TerminalName, string TerminalIP, int DeviceType)
{
bool IsSaved = false;
try
{
if (!pclsCache.Connect())
{
//MessageBox.Show("Cache数据库连接失败");
return(IsSaved);
}
int flag = (int)Ps.BasicInfoDetail.SetData(pclsCache.CacheConnectionObject, Patient, CategoryCode, ItemCode, ItemSeq, Value, Description, SortNo, revUserId, TerminalName, TerminalIP, DeviceType);
if (flag == 1)
{
IsSaved = true;
}
return(IsSaved);
}
catch (Exception ex)
{
//MessageBox.Show(ex.ToString(), "保存失败！");
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "PsBasicInfoDetail.SetData", "数据库操作异常！ error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
return(IsSaved);
}
finally
{
pclsCache.DisConnect();
}
}
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.VitalSignsCmp.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, "Mp.VitalSignsCmp.SetData", "数据库操作异常！ error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
return(IsSaved);
}
finally
{
pclsCache.DisConnect();
}
}
// 获取需要知道的项目的值 SYF 20150423
public static string GetValue(DataConnection pclsCache, string UserId, string CategoryCode, string ItemCode, int ItemSeq)
{
string ret = "";
try
{
if (!pclsCache.Connect())
{
//MessageBox.Show("Cache数据库连接失败");
return(ret);
}
ret = (string)Ps.BasicInfoDetail.GetValue(pclsCache.CacheConnectionObject, UserId, CategoryCode, ItemCode, ItemSeq);
return(ret);
}
catch (Exception ex)
{
//MessageBox.Show(ex.ToString(), "保存失败！");
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "PsBasicInfoDetail.GetValue", "数据库操作异常！ error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
return(ret);
}
finally
{
pclsCache.DisConnect();
}
}
public List <CmMstInfoItem> GetCmMstInfoItem(DataConnection pclsCache)
{
List <CmMstInfoItem> CmMstInfoItemList = new List <CmMstInfoItem>();
CacheCommand cmd = null;
CacheDataReader cdr = null;
try
{
if (!pclsCache.Connect())
{
return(null);
}
//cmd = new CacheCommand();
cmd = Cm.MstInfoItem.GetInfoItem(pclsCache.CacheConnectionObject);
cdr = cmd.ExecuteReader();
while (cdr.Read())
{
CmMstInfoItemList.Add(new CmMstInfoItem
{
CategoryCode = cdr["CategoryCode"].ToString(),
Code = cdr["Code"].ToString(),
Name = cdr["Name"].ToString(),
ParentCode = cdr["ParentCode"].ToString(),
SortNo = Convert.ToInt32(cdr["SortNo"].ToString()),
StartDate = Convert.ToInt32(cdr["StartDate"].ToString()),
EndDate = Convert.ToInt32(cdr["EndDate"].ToString()),
GroupHeaderFlag = Convert.ToInt32(cdr["GroupHeaderFlag"].ToString()),
ControlType = cdr["ControlType"].ToString(),
OptionCategory = cdr["OptionCategory"].ToString(),
RevUserId = "",
TerminalName = "",
TerminalIP = "",
DeviceType = 0
});
}
return(CmMstInfoItemList);
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "CmMstInfoItem.GetInfoItem", "数据库操作异常！ 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();
}
}
//SetData YDS 2014-12-01
public static bool SetData(DataConnection pclsCache, string Type, string Code, string TypeName, string Name, string InputCode, int SortNo, string Redundance, int InvalidFlag)
{
bool IsSaved = false;
try
{
if (!pclsCache.Connect())
{
//MessageBox.Show("Cache数据库连接失败");
return(IsSaved);
}
int flag = (int)Cm.MstTreatment.SetData(pclsCache.CacheConnectionObject, Type, Code, TypeName, Name, InputCode, SortNo, Redundance, InvalidFlag);
if (flag == 1)
{
IsSaved = true;
}
return(IsSaved);
}
catch (Exception ex)
{
//MessageBox.Show(ex.ToString(), "保存失败！");
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "CmMstTreatment.SetData", "数据库操作异常！ error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
return(IsSaved);
}
finally
{
pclsCache.DisConnect();
}
}
//SetPushFlag GL 2014-12-01 推送状态置位
public static bool SetPushFlag(DataConnection pclsCache, string UserId, int SortNo, string revUserId, string pTerminalName, string pTerminalIP, int pDeviceType)
{
bool IsOk = false;
try
{
if (!pclsCache.Connect())
{
//MessageBox.Show("Cache数据库连接失败");
return(IsOk);
}
int flag = (int)Wn.TrnAlertRecord.SetPushFlag(pclsCache.CacheConnectionObject, UserId, SortNo, revUserId, pTerminalIP, pTerminalName, pDeviceType);
if (flag == 1)
{
IsOk = true;
}
return(IsOk);
}
catch (Exception ex)
{
//MessageBox.Show(ex.ToString(), "保存失败！");
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "WnTrnAlertRecord.SetPushFlag", "数据库操作异常！ error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
return(IsOk);
}
finally
{
pclsCache.DisConnect();
}
}
public static int DeleteAll(DataConnection pclsCache, string piUserId, string piVisitId)
{
int ret = 0;
try
{
if (!pclsCache.Connect())
{
return(ret);
}
ret = (int)Ps.Examination.DeleteAll(pclsCache.CacheConnectionObject, piUserId, piVisitId);
return(ret);
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "Ps.Examination.DeleteAll", "数据库操作异常！ error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
return(ret);
}
finally
{
pclsCache.DisConnect();
}
}
//WF 20150514
public static DataTable GetAddressByType(DataConnection pclsCache, string Module, int Type)
{
DataTable list = new DataTable();
list.Columns.Add(new DataColumn("Module", typeof(string)));
list.Columns.Add(new DataColumn("ModuleName", 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("Author", typeof(string)));
list.Columns.Add(new DataColumn("AuthorName", typeof(string)));
CacheCommand cmd = null;
CacheDataReader cdr = null;
try
{
if (!pclsCache.Connect())
{
return(null);
}
cmd = new CacheCommand();
cmd = Cm.MstHealthEducation.GetAddressByType(pclsCache.CacheConnectionObject);
cmd.Parameters.Add("Module", CacheDbType.NVarChar).Value = Module;
cmd.Parameters.Add("Type", CacheDbType.Int).Value = Type;
cdr = cmd.ExecuteReader();
while (cdr.Read())
{
list.Rows.Add(cdr["Module"].ToString(), cdr["ModuleName"].ToString(), cdr["HealthId"].ToString(), cdr["Type"], cdr["TypeName"].ToString(), cdr["FileName"].ToString(), cdr["Path"].ToString(), cdr["Introduction"].ToString(), cdr["Redundance"].ToString(), cdr["Author"].ToString(), cdr["AuthorName"].ToString());
}
return(list);
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "Cm.MstHealthEducation.GetAddressByType", "数据库操作异常！ 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();
}
}
/// <summary>
/// 计算某段时间的总依从率 syf 2015-10-10
/// </summary>
/// <param name="pclsCache"></param>
/// <param name="PatientId"></param>
/// <param name="PlanNo"></param>
/// <param name="StartDate"></param>
/// <param name="EndDate"></param>
/// <returns></returns>
public string GetCompliacneRate(DataConnection pclsCache, string PatientId, string PlanNo, int StartDate, int EndDate)
{
string compliacneRate = "";
CacheCommand cmd = null;
CacheDataReader cdr = null;
try
{
if (!pclsCache.Connect())
{
return(null);
}
cmd = new CacheCommand();
cmd = Ps.Compliance.GetComplianceListByPeriod(pclsCache.CacheConnectionObject);
cmd.Parameters.Add("PatientId", CacheDbType.NVarChar).Value = PatientId;
cmd.Parameters.Add("PlanNo", CacheDbType.NVarChar).Value = PlanNo;
cmd.Parameters.Add("StartDate", CacheDbType.NVarChar).Value = StartDate;
cmd.Parameters.Add("EndDate", CacheDbType.NVarChar).Value = EndDate;
cdr = cmd.ExecuteReader();
double sum = 0;
int count = 0;
while (cdr.Read())
{
sum += Convert.ToDouble(cdr["Compliance"]);
count++;
}
if (count != 0)
{
compliacneRate = (Math.Round(sum / count, 2, MidpointRounding.AwayFromZero) * 100).ToString(); //保留整数
}
return(compliacneRate);
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "PlanInfoMethod.GetCompliacneRate", "数据库操作异常！ 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();
}
}
// GetListByStatus WF 2015-07-07
public static DataTable GetListByStatus(DataConnection pclsCache, int Status)
{
DataTable list = new DataTable();
list.Columns.Add(new DataColumn("HospitalCode", typeof(string)));
list.Columns.Add(new DataColumn("HospitalName", typeof(string)));
list.Columns.Add(new DataColumn("Type", typeof(string)));
list.Columns.Add(new DataColumn("Code", typeof(string)));
list.Columns.Add(new DataColumn("TypeName", typeof(string)));
list.Columns.Add(new DataColumn("Name", typeof(string)));
list.Columns.Add(new DataColumn("InputCode", typeof(string)));
list.Columns.Add(new DataColumn("Description", typeof(string)));
list.Columns.Add(new DataColumn("Status", typeof(int)));
CacheCommand cmd = null;
CacheDataReader cdr = null;
try
{
if (!pclsCache.Connect())
{
//MessageBox.Show("Cache数据库连接失败");
return(null);
}
cmd = new CacheCommand();
cmd = Tmp.DivisionDict.GetListByStatus(pclsCache.CacheConnectionObject);
cmd.Parameters.Add("Status", CacheDbType.Int).Value = Status;
//cmd.Parameters.Add("InvalidFlag", CacheDbType.Int).Value = InvalidFlag;
cdr = cmd.ExecuteReader();
while (cdr.Read())
{
list.Rows.Add(cdr["HospitalCode"].ToString(), cdr["HospitalName"].ToString(), cdr["Type"].ToString(), cdr["Code"].ToString(), cdr["TypeName"].ToString(), cdr["Name"].ToString(), cdr["InputCode"].ToString(), cdr["Description"].ToString(), cdr["Status"]);
}
return(list);
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "Tmp.DivisionDict.GetListByStatus", "数据库操作异常！ 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();
}
}