public CmMonitorMethod GetMonitorMethodData(DataConnection pclsCache, string Type, string Code)
{
try
{
CmMonitorMethod item = new CmMonitorMethod();
if (!pclsCache.Connect())
{
return(null);
}
InterSystems.Data.CacheTypes.CacheSysList list = null;
list = Cm.MonitorMethod.GetData(pclsCache.CacheConnectionObject, Type, Code);
if (list != null)
{
item.TypeName = list[0];
item.Name = list[1];
item.Method = list[2];
item.Description = list[3];
item.SortNo = Convert.ToInt32(list[4]);
item.Redundance = list[5];
}
return(item);
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "DictMethod.GetMonitorMethodData", "数据库操作异常！ error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
return(null);
}
finally
{
pclsCache.DisConnect();
}
}
/// <summary>
/// 得到所有试剂类型
/// </summary>
/// <param name="pclsCache"></param>
/// <returns></returns>
public List <TypeAndName> MstReagentTypeGetAll(DataConnection pclsCache)
{
List <TypeAndName> list = new List <TypeAndName>();
try
{
if (!pclsCache.Connect())
{
return(list);
}
InterSystems.Data.CacheTypes.CacheSysList Result = Cm.MstReagentType.GetAll(pclsCache.CacheConnectionObject);
int count = Result.Count;
int i = 1;
while (i < count)
{
string[] ret = Result[i].Split('|');
TypeAndName info = new TypeAndName();
info.Type = ret[0];
info.Name = ret[1];
list.Add(info);
i++;
}
return(list);
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "UserInfoMethod.MstReagentTypeGetAll", "数据库操作异常！ error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
return(list);
}
finally
{
pclsCache.DisConnect();
}
}
/// <summary>
/// 获取患者某项生理参数的RecordDate前的最近一条数据 GL 2015-10-10
/// </summary>
/// <param name="UserId"></param>
/// <param name="ItemType"></param>
/// <param name="ItemCode"></param>
/// <param name="RecordDate"></param>
/// <returns></returns>
public VitalInfo GetLatestVitalSignsByDate(DataConnection pclsCache, string UserId, string ItemType, string ItemCode, int RecordDate)
{
try
{
VitalInfo item = new VitalInfo();
InterSystems.Data.CacheTypes.CacheSysList list = null;
list = Ps.VitalSigns.GetLatestVitalSignsByDate(pclsCache.CacheConnectionObject, UserId, ItemType, ItemCode, RecordDate);
if (list != null)
{
item.RecordDate = list[0];
item.RecordTime = list[1];
item.Value = list[2];
item.Unit = list[3];
}
return(item);
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "VitalInfoMethod.GetLatestVitalSignsByDate", "数据库操作异常！ error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
return(null);
}
finally
{
pclsCache.DisConnect();
}
}
/// <summary>
/// 获取正在执行的计划 SYF 2015-10-10
/// </summary>
/// <param name="pclsCache"></param>
/// <param name="PatientId"></param>
/// <returns></returns>
public GPlanInfo GetExecutingPlan(DataConnection pclsCache, string PatientId)
{
try
{
GPlanInfo ret = new GPlanInfo();
if (!pclsCache.Connect())
{
return(null);
}
InterSystems.Data.CacheTypes.CacheSysList list = null;
list = Ps.Plan.GetExecutingPlan(pclsCache.CacheConnectionObject, PatientId);
if (list != null)
{
ret.PlanNo = list[0];
ret.PatientId = list[1];
ret.StartDate = list[2];
ret.EndDate = list[3];
ret.Module = list[4];
ret.Status = list[5];
ret.DoctorId = list[6];
}
return(ret);
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "PlanInfoMethod.GetExecutingPlan", "数据库操作异常！ error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
return(null);
}
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();
}
}
/// <summary>
/// 获取某计划的相关信息 SYF 2015-10-10
/// </summary>
/// <param name="pclsCache"></param>
/// <param name="PlanStartDate"></param>
/// <returns></returns>
public Period GetWeekPeriod(DataConnection pclsCache, int PlanStartDate)
{
try
{
Period ret = new Period();
if (!pclsCache.Connect())
{
return(null);
}
InterSystems.Data.CacheTypes.CacheSysList list = null;
list = Ps.Plan.GetWeekPeriod(pclsCache.CacheConnectionObject, PlanStartDate);
if (list != null)
{
ret.StartDate = list[0];
ret.EndDate = list[1];
ret.DayCount = list[2];
}
return(ret);
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "PlanInfoMethod.GetWeekPeriod", "数据库操作异常！ error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
return(null);
}
finally
{
pclsCache.DisConnect();
}
}
/// <summary>
/// 得到医生详细信息 LY 2015-10-10
/// </summary>
/// <param name="pclsCache"></param>
/// <param name="UserId"></param>
/// <returns></returns>
public DocInfoDetail PsDoctorInfoDetailGetDoctorInfoDetail(DataConnection pclsCache, string UserId)
{
try
{
DocInfoDetail ret = new DocInfoDetail();
if (!pclsCache.Connect())
{
return(null);
}
InterSystems.Data.CacheTypes.CacheSysList list = null;
list = Ps.DoctorInfoDetail.GetDoctorInfoDetail(pclsCache.CacheConnectionObject, UserId);
if (list != null)
{
ret.IDNo = list[0];
ret.PhotoAddress = list[1];
ret.UnitName = list[2];
ret.JobTitle = list[3];
ret.Level = list[4];
ret.Dept = list[5];
ret.ActivatePhotoAddr = list[6];
ret.DeptName = list[7];
}
return(ret);
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "ModuleInfoMethod.PsDoctorInfoDetailGetDoctorInfoDetail", "数据库操作异常！ error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
return(null);
}
finally
{
pclsCache.DisConnect();
}
}
/// <summary>
/// 得到专员信息 LY 2015-10-10
/// </summary>
/// <param name="pclsCache"></param>
/// <param name="PatientId"></param>
/// <returns></returns>
public TypeAndName PsBasicInfoDetailGetSDoctor(DataConnection pclsCache, string PatientId)
{
TypeAndName ret = new TypeAndName();
try
{
if (!pclsCache.Connect())
{
return(ret);
}
InterSystems.Data.CacheTypes.CacheSysList list = null;
list = Ps.BasicInfoDetail.GetSDoctor(pclsCache.CacheConnectionObject, PatientId);
if (list != null)
{
ret.Type = list[0];
ret.Name = list[1];
}
return(ret);
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "ModuleInfoMethod.PsBasicInfoDetailGetSDoctor", "数据库操作异常！ error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
return(ret);
}
finally
{
pclsCache.DisConnect();
}
}
/// <summary>
/// 获取某计划的进度和剩余天数 SYF 2015-10-10
/// </summary>
/// <param name="pclsCache"></param>
/// <param name="PlanNo"></param>
/// <returns></returns>
public Progressrate GetProgressRate(DataConnection pclsCache, string PlanNo)
{
try
{
Progressrate ret = new Progressrate();
if (!pclsCache.Connect())
{
return(null);
}
InterSystems.Data.CacheTypes.CacheSysList list = null;
list = Ps.Plan.GetProgressRate(pclsCache.CacheConnectionObject, PlanNo);
if (list != null)
{
ret.RemainingDays = list[0];
ret.ProgressRate = list[1];
}
return(ret);
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "PlanInfoMethod.GetProgressRate", "数据库操作异常！ error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
return(null);
}
finally
{
pclsCache.DisConnect();
}
}
/// <summary>
/// 施宇帆 2016-04-28 基本信息新增了门诊表的信息
/// </summary>
/// <param name="pclsCache"></param>
/// <param name="PatientId"></param>
/// <returns></returns>
public CmTrnPatient GetPatientInfoNew(DataConnection pclsCache, string PatientId)
{
CmTrnPatient info = new CmTrnPatient();
try
{
if (!pclsCache.Connect())
{
return(null);
}
InterSystems.Data.CacheTypes.CacheSysList list = null;
list = Cm.TrnPatient.GetPatientInfoNew(pclsCache.CacheConnectionObject, PatientId);
if (list != null)
{
info.PatientName = list[0];
info.Age = list[1];
info.Sex = list[2];
info.Blood = list[3];
info.ClinicDate = Convert.ToInt32(list[4]);
info.DepartmentName = list[5];
info.DoctorName = list[6];
}
return(info);
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "PsTrnOutpatientMethod.GetPatientInfoNew", "数据库操作异常！ error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
return(null);
}
finally
{
pclsCache.DisConnect();
}
}
/// <summary>
/// 根据任何筛选条件得到故障们的信息
/// </summary>
/// <param name="pclsCache"></param>
/// <param name="BreakId"></param>
/// <param name="BreakTimeS"></param>
/// <param name="BreakTimeE"></param>
/// <param name="BreakEquip"></param>
/// <param name="BreakPara"></param>
/// <param name="BreakValue"></param>
/// <param name="BreakReason"></param>
/// <param name="ResponseTimeS"></param>
/// <param name="ResponseTimeE"></param>
/// <param name="GetBreakTime"></param>
/// <param name="GetBreakEquip"></param>
/// <param name="GetBreakPara"></param>
/// <param name="GetBreakValue"></param>
/// <param name="GetBreakReason"></param>
/// <param name="GetResponseTime"></param>
/// <returns></returns>
public List <BreakDown> BreakDownGetBreakDownsByAnyProperty(DataConnection pclsCache, string BreakId, string BreakTimeS, string BreakTimeE, string BreakEquip, string BreakPara, string BreakValue, string BreakReason, string ResponseTimeS, string ResponseTimeE, int GetBreakTime, int GetBreakEquip, int GetBreakPara, int GetBreakValue, int GetBreakReason, int GetResponseTime)
{
List <BreakDown> list = new List <BreakDown>();
try
{
if (!pclsCache.Connect())
{
return(list);
}
InterSystems.Data.CacheTypes.CacheSysList Result = Rs.BreakDown.GetBreakDownsByAnyProperty(pclsCache.CacheConnectionObject, BreakId, BreakTimeS, BreakTimeE, BreakEquip, BreakPara, BreakValue, BreakReason, ResponseTimeS, ResponseTimeE, GetBreakTime, GetBreakEquip, GetBreakPara, GetBreakValue, GetBreakReason, GetResponseTime);
int count = Result.Count;
int i = 1;
while (i < count)
{
string[] ret = Result[i].Split('|');
BreakDown breakDown = new BreakDown();
if (ret[0] != "")
{
breakDown.BreakId = ret[0];
}
if (ret[1] != "")
{
breakDown.BreakTime = Convert.ToDateTime(ret[1]);
}
if (ret[2] != "")
{
breakDown.BreakEquip = ret[2];
}
if (ret[3] != "")
{
breakDown.BreakPara = ret[3];
}
if (ret[4] != "")
{
breakDown.BreakValue = ret[4];
}
if (ret[5] != "")
{
breakDown.BreakReason = ret[5];
}
if (ret[6] != "")
{
breakDown.ResponseTime = Convert.ToDateTime(ret[6]);
}
list.Add(breakDown);
i++;
}
return(list);
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "ResultMethod.BreakDownGetBreakDownsByAnyProperty", "数据库操作异常！ error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
return(list);
}
finally
{
pclsCache.DisConnect();
}
}
/// <summary>
/// 得到最新的隔离器环境参数
/// </summary>
/// <param name="pclsCache"></param>
/// <param name="IsolatorId"></param>
/// <param name="CabinId"></param>
/// <returns></returns>
public List <string> EnvIsolatorGetNewIsolatorEnv(DataConnection pclsCache, string IsolatorId, string CabinId)
{
List <string> list = new List <string>();
try
{
if (!pclsCache.Connect())
{
return(list);
}
InterSystems.Data.CacheTypes.CacheSysList Result = It.EnvIsolator.GetNewIsolatorEnv(pclsCache.CacheConnectionObject, IsolatorId, CabinId);
int count = Result.Count;
int i = 1;
while (i < count)
{
list.Add(Result[i]);
i++;
}
return(list);
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "ItemInfoMethod.EnvIsolatorGetNewIsolatorEnv", "数据库操作异常！ error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
return(list);
}
finally
{
pclsCache.DisConnect();
}
}
/// <summary>
/// 得到流程的下一步
/// </summary>
/// <param name="pclsCache"></param>
/// <param name="OrderId"></param>
/// <returns></returns>
public List <string> GetNextStep(DataConnection pclsCache, string OrderId)
{
List <string> list = new List <string>();
try
{
if (!pclsCache.Connect())
{
return(list);
}
InterSystems.Data.CacheTypes.CacheSysList Result = Cm.MstOperationOrder.GetNextStep(pclsCache.CacheConnectionObject, OrderId);
int count = Result.Count;
int i = 0;
while (i < count)
{
list.Add(Result[i]);
i++;
}
return(list);
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "OperationMethod.GetNextStep", "数据库操作异常！ error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
return(list);
}
finally
{
pclsCache.DisConnect();
}
}
/// <summary>
/// 新建样品
/// </summary>
/// <param name="pclsCache"></param>
/// <param name="ObjCompany"></param>
/// <param name="ObjectName"></param>
/// <param name="ObjectType"></param>
/// <param name="SamplingPeople"></param>
/// <param name="SamplingTime"></param>
/// <param name="Warning"></param>
/// <param name="TerminalIP"></param>
/// <param name="TerminalName"></param>
/// <param name="revUserId"></param>
/// <returns></returns>
public List <string> ItemSampleCreateNewSample(DataConnection pclsCache, string ObjCompany, string ObjectName, string ObjectType, string SamplingPeople, DateTime SamplingTime, string Warning, string TerminalIP, string TerminalName, string revUserId)
{
List <string> Result = new List <string>();
Result.Add("-2");
try
{
if (!pclsCache.Connect())
{
return(Result);
}
InterSystems.Data.CacheTypes.CacheSysList list = It.ItemSample.CreateNewSample(pclsCache.CacheConnectionObject, ObjCompany, ObjectName, ObjectType, SamplingPeople, SamplingTime, Warning, TerminalIP, TerminalName, revUserId);
int count = list.Count;
int i = 0;
Result = new List <string>();
while (i < count)
{
Result.Add(list[i]);
i++;
}
return(Result);
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "ItemInfoMethod.ItemSampleCreateNewSample", "数据库操作异常！ error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
return(Result);
}
finally
{
pclsCache.DisConnect();
}
}
/// <summary>
/// 根据任何筛选条件得到机器视觉检测们的信息
/// </summary>
/// <param name="pclsCache"></param>
/// <param name="TestId"></param>
/// <param name="TubeNo"></param>
/// <param name="PictureId"></param>
/// <param name="CameraTimeS"></param>
/// <param name="CameraTimeE"></param>
/// <param name="ImageAddress"></param>
/// <param name="AnalResult"></param>
/// <param name="GetCameraTime"></param>
/// <param name="GetImageAddress"></param>
/// <param name="GetAnalResult"></param>
/// <returns></returns>
public List <ResTestPicture> ResTestPictureGetTestPicturesByAnyProperty(DataConnection pclsCache, string TestId, string TubeNo, string PictureId, string CameraTimeS, string CameraTimeE, string ImageAddress, string AnalResult, int GetCameraTime, int GetImageAddress, int GetAnalResult)
{
List <ResTestPicture> list = new List <ResTestPicture>();
try
{
if (!pclsCache.Connect())
{
return(list);
}
InterSystems.Data.CacheTypes.CacheSysList Result = Rs.ResTestPicture.GetTestPicturesByAnyProperty(pclsCache.CacheConnectionObject, TestId, TubeNo, PictureId, CameraTimeS, CameraTimeE, ImageAddress, AnalResult, GetCameraTime, GetImageAddress, GetAnalResult);
int count = Result.Count;
int i = 1;
while (i < count)
{
string[] ret = Result[i].Split('|');
ResTestPicture resTestPicture = new ResTestPicture();
if (ret[0] != "")
{
resTestPicture.TestId = ret[0];
}
if (ret[1] != "")
{
resTestPicture.TubeNo = ret[1];
}
if (ret[2] != "")
{
resTestPicture.PictureId = ret[2];
}
if (ret[3] != "")
{
resTestPicture.CameraTime = Convert.ToDateTime(ret[3]);
}
if (ret[4] != "")
{
resTestPicture.ImageAddress = ret[4];
}
if (ret[5] != "")
{
resTestPicture.AnalResult = ret[5];
}
list.Add(resTestPicture);
i++;
}
return(list);
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "ResultMethod.ResTestPictureGetTestPicturesByAnyProperty", "数据库操作异常！ error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
return(list);
}
finally
{
pclsCache.DisConnect();
}
}
/// <summary>
/// 获取病人门诊信息详情 最新一条数据 施宇帆 2016-04-28 15
/// </summary>
/// <param name="pclsCache"></param>
/// <param name="PatientId"></param>
/// <returns></returns>
public ResponseResult GetOutDetailsByPID(DataConnection pclsCache, string PatientId)
{
ResponseResult Result = new ResponseResult();
OutpatientDetails info = new OutpatientDetails();
try
{
if (!pclsCache.Connect())
{
return(null);
}
InterSystems.Data.CacheTypes.CacheSysList list = null;
list = Ps.TrnOutpatient.GetOutDetailsByPID(pclsCache.CacheConnectionObject, PatientId);
if (list != null)
{
info.PatientId = list[0];
info.PatientName = list[1];
info.PatientSexName = list[2];
info.PatientAge = list[3];
info.PatientBloodName = list[4];
info.ConsultationType = list[5];
info.ClinicType = list[6];
info.MedicalStatus = list[7];
info.RegisterTime = list[8];
info.ClinicTime = list[9];
info.DepartmentName = list[10];
info.DoctorName = list[11];
info.DiseaseName = list[12];
info.Number = list[13];
}
Result.data = info;
Result.code = Code(info);
Result.msg = "病人门诊信息详情" + MSG(info);
return(Result);
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "PsTrnOutpatientMethod.GetOutDetailsByPID", "数据库操作异常！ error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
return(null);
}
finally
{
pclsCache.DisConnect();
}
}
/// <summary>
/// 基本操作条件查询 GY 2017-11-23
/// </summary>
/// <param name="pclsCache"></param>
/// <param name="OperationId"></param>
/// <param name="OperationName"></param>
/// <param name="OutputCode"></param>
/// <param name="GetOperationName"></param>
/// <param name="GetOutputCode"></param>
/// <returns></returns>
public List <MstOperationInfo> GetOperationInfoByAnyProperty(DataConnection pclsCache, string OperationId, string OperationName, string OutputCode, int GetOperationName, int GetOutputCode)
{
List <MstOperationInfo> list = new List <MstOperationInfo>();
try
{
if (!pclsCache.Connect())
{
return(list);
}
InterSystems.Data.CacheTypes.CacheSysList Result = Cm.MstOperation.GetOperationInfoByAnyProperty(pclsCache.CacheConnectionObject, OperationId, OperationName, OutputCode, GetOperationName, GetOutputCode);
int count = Result.Count;
int i = 1;
while (i < count)
{
string[] ret = Result[i].Split('|');
MstOperationInfo opInfo = new MstOperationInfo();
if (ret[0] != "")
{
opInfo.OperationId = ret[0];
}
if (ret[1] != "")
{
opInfo.OperationName = ret[1];
}
if (ret[2] != "")
{
opInfo.OutputCode = ret[2];
}
list.Add(opInfo);
i++;
}
return(list);
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "OperationMethod.MstUserGetUsersInfoByAnyProperty", "数据库操作异常！ error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
return(list);
}
finally
{
pclsCache.DisConnect();
}
}
/// <summary>
/// 得到病人详细信息 LY 2015-10-10
/// </summary>
/// <param name="pclsCache"></param>
/// <param name="UserId"></param>
/// <returns></returns>
public PatDetailInfo PsBasicInfoDetailGetPatientDetailInfo(DataConnection pclsCache, string UserId)
{
PatDetailInfo ret = new PatDetailInfo();
try
{
if (!pclsCache.Connect())
{
return(ret);
}
InterSystems.Data.CacheTypes.CacheSysList list = null;
list = Ps.BasicInfoDetail.GetPatientDetailInfo(pclsCache.CacheConnectionObject, UserId);
if (list != null)
{
ret.PhoneNumber = list[0];
ret.HomeAddress = list[1];
ret.Occupation = list[2];
ret.Nationality = list[3];
ret.EmergencyContact = list[4];
ret.EmergencyContactPhoneNumber = list[5];
ret.PhotoAddress = list[6];
ret.IDNo = list[7];
ret.Height = list[8];
ret.Weight = list[9];
}
return(ret);
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "ModuleInfoMethod.PsBasicInfoDetailGetPatientDetailInfo", "数据库操作异常！ error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
return(ret);
}
finally
{
pclsCache.DisConnect();
}
}
/// <summary>
/// 根据任何筛选条件得到无菌隔离器们的信息
/// </summary>
/// <param name="pclsCache"></param>
/// <param name="IsolatorId"></param>
/// <param name="ProductDayS"></param>
/// <param name="ProductDayE"></param>
/// <param name="EquipPro"></param>
/// <param name="InsDescription"></param>
/// <param name="ReDateTimeS"></param>
/// <param name="ReDateTimeE"></param>
/// <param name="ReTerminalIP"></param>
/// <param name="ReTerminalName"></param>
/// <param name="ReUserId"></param>
/// <param name="ReIdentify"></param>
/// <param name="GetProductDay"></param>
/// <param name="GetEquipPro"></param>
/// <param name="GetInsDescription"></param>
/// <param name="GetRevisionInfo"></param>
/// <returns></returns>
public List <GetIsolatorInfo> ItemIsolatorGetIsolatorsInfoByAnyProperty(DataConnection pclsCache, string IsolatorId, string ProductDayS, string ProductDayE, string EquipPro, string InsDescription, string ReDateTimeS, string ReDateTimeE, string ReTerminalIP, string ReTerminalName, string ReUserId, string ReIdentify, int GetProductDay, int GetEquipPro, int GetInsDescription, int GetRevisionInfo)
{
List <GetIsolatorInfo> list = new List <GetIsolatorInfo>();
try
{
if (!pclsCache.Connect())
{
return(list);
}
InterSystems.Data.CacheTypes.CacheSysList Result = It.ItemIsolator.GetIsolatorsInfoByAnyProperty(pclsCache.CacheConnectionObject, IsolatorId, ProductDayS, ProductDayE, EquipPro, InsDescription, ReDateTimeS, ReDateTimeE, ReTerminalIP, ReTerminalName, ReUserId, ReIdentify, GetProductDay, GetEquipPro, GetInsDescription, GetRevisionInfo);
int count = Result.Count;
int i = 1;
while (i < count)
{
string[] ret = Result[i].Split('|');
GetIsolatorInfo isolatorInfo = new GetIsolatorInfo();
if (ret[0] != "")
{
isolatorInfo.IsolatorId = ret[0];
}
if (ret[1] != "")
{
isolatorInfo.ProductDay = Convert.ToDateTime(ret[1]);
}
if (ret[2] != "")
{
isolatorInfo.EquipPro = ret[2];
}
if (ret[3] != "")
{
isolatorInfo.InsDescription = ret[3];
}
if (ret[4] != "")
{
isolatorInfo.revDateTime = Convert.ToDateTime(ret[4]);
}
if (ret[5] != "")
{
isolatorInfo.TerminalIP = ret[5];
}
if (ret[6] != "")
{
isolatorInfo.TerminalName = ret[6];
}
if (ret[7] != "")
{
isolatorInfo.revUserId = ret[7];
}
if (ret[8] != "")
{
isolatorInfo.revIdentify = ret[8];
}
list.Add(isolatorInfo);
i++;
}
return(list);
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "ItemInfoMethod.ItemIsolatorGetIsolatorsInfoByAnyProperty", "数据库操作异常！ error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
return(list);
}
finally
{
pclsCache.DisConnect();
}
}
/// <summary>
/// 根据任何筛选条件得到检测结果们的信息
/// </summary>
/// <param name="pclsCache"></param>
/// <param name="TestId"></param>
/// <param name="ObjectNo"></param>
/// <param name="ObjCompany"></param>
/// <param name="ObjIncuSeq"></param>
/// <param name="TestType"></param>
/// <param name="TestStand"></param>
/// <param name="TestEquip"></param>
/// <param name="TestEquip2"></param>
/// <param name="Description"></param>
/// <param name="ProcessStartS"></param>
/// <param name="ProcessStartE"></param>
/// <param name="ProcessEndS"></param>
/// <param name="ProcessEndE"></param>
/// <param name="CollectStartS"></param>
/// <param name="CollectStartE"></param>
/// <param name="CollectEndS"></param>
/// <param name="CollectEndE"></param>
/// <param name="TestTimeS"></param>
/// <param name="TestTimeE"></param>
/// <param name="TestResult"></param>
/// <param name="TestPeople"></param>
/// <param name="TestPeople2"></param>
/// <param name="ReStatus"></param>
/// <param name="RePeople"></param>
/// <param name="ReTimeS"></param>
/// <param name="ReTimeE"></param>
/// <param name="ReDateTimeS"></param>
/// <param name="ReDateTimeE"></param>
/// <param name="ReTerminalIP"></param>
/// <param name="ReTerminalName"></param>
/// <param name="ReUserId"></param>
/// <param name="ReIdentify"></param>
/// <param name="FormerStep"></param>
/// <param name="NowStep"></param>
/// <param name="LaterStep"></param>
/// <param name="GetObjectNo"></param>
/// <param name="GetObjCompany"></param>
/// <param name="GetObjIncuSeq"></param>
/// <param name="GetTestType"></param>
/// <param name="GetTestStand"></param>
/// <param name="GetTestEquip"></param>
/// <param name="GetTestEquip2"></param>
/// <param name="GetDescription"></param>
/// <param name="GetProcessStart"></param>
/// <param name="GetProcessEnd"></param>
/// <param name="GetCollectStart"></param>
/// <param name="GetCollectEnd"></param>
/// <param name="GetTestTime"></param>
/// <param name="GetTestResult"></param>
/// <param name="GetTestPeople"></param>
/// <param name="GetTestPeople2"></param>
/// <param name="GetReStatus"></param>
/// <param name="GetRePeople"></param>
/// <param name="GetReTime"></param>
/// <param name="GetRevisionInfo"></param>
/// <param name="GetFormerStep"></param>
/// <param name="GetNowStep"></param>
/// <param name="GetLaterStep"></param>
/// <returns></returns>
public List <GetTestResultInfo> ResTestResultGetResultInfosByAnyProperty(DataConnection pclsCache, string TestId, string ObjectNo, string ObjCompany, string ObjIncuSeq, string TestType, string TestStand, string TestEquip, string TestEquip2, string Description, string ProcessStartS, string ProcessStartE, string ProcessEndS, string ProcessEndE, string CollectStartS, string CollectStartE, string CollectEndS, string CollectEndE, string TestTimeS, string TestTimeE, string TestResult, string TestPeople, string TestPeople2, string ReStatus, string RePeople, string ReTimeS, string ReTimeE, string ReDateTimeS, string ReDateTimeE, string ReTerminalIP, string ReTerminalName, string ReUserId, string ReIdentify, string FormerStep, string NowStep, string LaterStep, int GetObjectNo, int GetObjCompany, int GetObjIncuSeq, int GetTestType, int GetTestStand, int GetTestEquip, int GetTestEquip2, int GetDescription, int GetProcessStart, int GetProcessEnd, int GetCollectStart, int GetCollectEnd, int GetTestTime, int GetTestResult, int GetTestPeople, int GetTestPeople2, int GetReStatus, int GetRePeople, int GetReTime, int GetRevisionInfo, int GetFormerStep, int GetNowStep, int GetLaterStep)
{
List <GetTestResultInfo> list = new List <GetTestResultInfo>();
try
{
if (!pclsCache.Connect())
{
return(list);
}
InterSystems.Data.CacheTypes.CacheSysList Result = Rs.ResTestResult.GetResultInfosByAnyProperty(pclsCache.CacheConnectionObject, TestId, ObjectNo, ObjCompany, ObjIncuSeq, TestType, TestStand, TestEquip, TestEquip2, Description, ProcessStartS, ProcessStartE, ProcessEndS, ProcessEndE, CollectStartS, CollectStartE, CollectEndS, CollectEndE, TestTimeS, TestTimeE, TestResult, TestPeople, TestPeople2, ReStatus, RePeople, ReTimeS, ReTimeE, ReDateTimeS, ReDateTimeE, ReTerminalIP, ReTerminalName, ReUserId, ReIdentify, FormerStep, NowStep, LaterStep, GetObjectNo, GetObjCompany, GetObjIncuSeq, GetTestType, GetTestStand, GetTestEquip, GetTestEquip2, GetDescription, GetProcessStart, GetProcessEnd, GetCollectStart, GetCollectEnd, GetTestTime, GetTestResult, GetTestPeople, GetTestPeople2, GetReStatus, GetRePeople, GetReTime, GetRevisionInfo, GetFormerStep, GetNowStep, GetLaterStep);
int count = Result.Count;
int i = 1;
while (i < count)
{
string[] ret = Result[i].Split('|');
GetTestResultInfo testResultInfo = new GetTestResultInfo();
if (ret[0] != "")
{
testResultInfo.TestId = ret[0];
}
if (ret[1] != "")
{
testResultInfo.ObjectNo = ret[1];
}
if (ret[2] != "")
{
testResultInfo.ObjCompany = ret[2];
}
if (ret[3] != "")
{
testResultInfo.ObjIncuSeq = ret[3];
}
if (ret[4] != "")
{
testResultInfo.TestType = ret[4];
}
if (ret[5] != "")
{
testResultInfo.TestStand = ret[5];
}
if (ret[6] != "")
{
testResultInfo.TestEquip = ret[6];
}
if (ret[7] != "")
{
testResultInfo.TestEquip2 = ret[7];
}
if (ret[8] != "")
{
testResultInfo.Description = ret[8];
}
if (ret[9] != "")
{
testResultInfo.ProcessStart = Convert.ToDateTime(ret[9]);
}
if (ret[10] != "")
{
testResultInfo.ProcessEnd = Convert.ToDateTime(ret[10]);
}
if (ret[11] != "")
{
testResultInfo.CollectStart = Convert.ToDateTime(ret[11]);
}
if (ret[12] != "")
{
testResultInfo.CollectEnd = Convert.ToDateTime(ret[12]);
}
if (ret[13] != "")
{
testResultInfo.TestTime = Convert.ToDateTime(ret[13]);
}
if (ret[14] != "")
{
testResultInfo.TestResult = ret[14];
}
if (ret[15] != "")
{
testResultInfo.TestPeople = ret[15];
}
if (ret[16] != "")
{
testResultInfo.TestPeople2 = ret[16];
}
if (ret[17] != "")
{
testResultInfo.ReStatus = Convert.ToInt32(ret[17]);
}
if (ret[18] != "")
{
testResultInfo.RePeople = ret[18];
}
if (ret[19] != "")
{
testResultInfo.ReTime = ret[19];
}
if (ret[20] != "")
{
testResultInfo.revDateTime = Convert.ToDateTime(ret[20]);
}
if (ret[21] != "")
{
testResultInfo.TerminalIP = ret[21];
}
if (ret[22] != "")
{
testResultInfo.TerminalName = ret[22];
}
if (ret[23] != "")
{
testResultInfo.revUserId = ret[23];
}
if (ret[24] != "")
{
testResultInfo.revIdentify = ret[24];
}
if (ret[25] != "")
{
testResultInfo.FormerStep = ret[25];
}
if (ret[26] != "")
{
testResultInfo.NowStep = ret[26];
}
if (ret[27] != "")
{
testResultInfo.LaterStep = ret[27];
}
if (ret[28] != "")
{
testResultInfo.ObjectName = ret[28];
}
if (ret[29] != "" && ret[30] != "0")
{
testResultInfo.JinDu = Convert.ToInt32(ret[29]) * 100 / Convert.ToInt32(ret[30]);
}
if (ret[31] != "" && ret[31] != "0000-00-00 00:00:00")
{
testResultInfo.EndTime = Convert.ToDateTime(ret[31]);
}
list.Add(testResultInfo);
i++;
}
return(list);
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "ResultMethod.ResTestResultGetResultInfosByAnyProperty", "数据库操作异常！ error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
return(list);
}
finally
{
pclsCache.DisConnect();
}
}
/// <summary>
/// 根据任何筛选条件得到样品培养记录们的信息
/// </summary>
/// <param name="pclsCache"></param>
/// <param name="TestId"></param>
/// <param name="TubeNo"></param>
/// <param name="CultureId"></param>
/// <param name="BacterId"></param>
/// <param name="OtherRea"></param>
/// <param name="IncubatorId"></param>
/// <param name="Place"></param>
/// <param name="StartTimeS"></param>
/// <param name="StartTimeE"></param>
/// <param name="EndTimeS"></param>
/// <param name="EndTimeE"></param>
/// <param name="AnalResult"></param>
/// <param name="PutinPeople"></param>
/// <param name="PutoutPeople"></param>
/// <param name="PutoutTimeS"></param>
/// <param name="PutoutTimeE"></param>
/// <param name="GetCultureId"></param>
/// <param name="GetBacterId"></param>
/// <param name="GetOtherRea"></param>
/// <param name="GetIncubatorId"></param>
/// <param name="GetPlace"></param>
/// <param name="GetStartTime"></param>
/// <param name="GetEndTime"></param>
/// <param name="GetAnalResult"></param>
/// <param name="GetPutinPeople"></param>
/// <param name="GetPutoutPeople"></param>
/// <param name="GetPutoutTime"></param>
/// <returns></returns>
public List <ResIncubator> ResIncubatorGetResultTubesByAnyProperty(DataConnection pclsCache, string TestId, string TubeNo, string CultureId, string BacterId, string OtherRea, string IncubatorId, string Place, string StartTimeS, string StartTimeE, string EndTimeS, string EndTimeE, string AnalResult, string PutinPeople, string PutoutPeople, string PutoutTimeS, string PutoutTimeE, int GetCultureId, int GetBacterId, int GetOtherRea, int GetIncubatorId, int GetPlace, int GetStartTime, int GetEndTime, int GetAnalResult, int GetPutinPeople, int GetPutoutPeople, int GetPutoutTime)
{
List <ResIncubator> list = new List <ResIncubator>();
try
{
if (!pclsCache.Connect())
{
return(list);
}
InterSystems.Data.CacheTypes.CacheSysList Result = Rs.ResIncubator.GetResultTubesByAnyProperty(pclsCache.CacheConnectionObject, TestId, TubeNo, CultureId, BacterId, OtherRea, IncubatorId, Place, StartTimeS, StartTimeE, EndTimeS, EndTimeE, AnalResult, PutinPeople, PutoutPeople, PutoutTimeS, PutoutTimeE, GetCultureId, GetBacterId, GetOtherRea, GetIncubatorId, GetPlace, GetStartTime, GetEndTime, GetAnalResult, GetPutinPeople, GetPutoutPeople, GetPutoutTime);
int count = Result.Count;
int i = 1;
while (i < count)
{
string[] ret = Result[i].Split('|');
ResIncubator resIncubator = new ResIncubator();
if (ret[0] != "")
{
resIncubator.TestId = ret[0];
}
if (ret[1] != "")
{
resIncubator.TubeNo = ret[1];
}
if (ret[2] != "")
{
resIncubator.CultureId = ret[2];
}
if (ret[3] != "")
{
resIncubator.BacterId = ret[3];
}
if (ret[4] != "")
{
resIncubator.OtherRea = ret[4];
}
if (ret[5] != "")
{
resIncubator.IncubatorId = ret[5];
}
if (ret[6] != "")
{
resIncubator.Place = ret[6];
}
if (ret[7] != "")
{
resIncubator.StartTime = ret[7];
}
if (ret[8] != "")
{
resIncubator.EndTime = ret[8];
}
if (ret[9] != "")
{
resIncubator.AnalResult = ret[9];
}
if (ret[10] != "")
{
resIncubator.PutinPeople = ret[10];
}
if (ret[11] != "")
{
resIncubator.PutoutPeople = ret[11];
}
if (ret[12] != "")
{
resIncubator.PutoutTime = Convert.ToDateTime(ret[12]);
}
list.Add(resIncubator);
i++;
}
return(list);
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "ResultMethod.ResIncubatorGetResultTubesByAnyProperty", "数据库操作异常！ error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
return(list);
}
finally
{
pclsCache.DisConnect();
}
}
/// <summary>
/// 根据任何筛选条件得到用户们的信息
/// </summary>
/// <param name="pclsCache"></param>
/// <param name="UserId"></param>
/// <param name="Identify"></param>
/// <param name="PhoneNo"></param>
/// <param name="UserName"></param>
/// <param name="Role"></param>
/// <param name="Password"></param>
/// <param name="LastLoginTimeS"></param>
/// <param name="LastLoginTimeE"></param>
/// <param name="ReDateTimeS"></param>
/// <param name="ReDateTimeE"></param>
/// <param name="ReTerminalIP"></param>
/// <param name="ReTerminalName"></param>
/// <param name="ReUserId"></param>
/// <param name="ReIdentify"></param>
/// <param name="GetIdentify"></param>
/// <param name="GetPhoneNo"></param>
/// <param name="GetUserName"></param>
/// <param name="GetRole"></param>
/// <param name="GetPassword"></param>
/// <param name="GetLastLoginTime"></param>
/// <param name="GetRevisionInfo"></param>
/// <returns></returns>
public List <GetUserInfo> MstUserGetUsersInfoByAnyProperty(DataConnection pclsCache, string UserId, string Identify, string PhoneNo, string UserName, string Role, string Password, string LastLoginTimeS, string LastLoginTimeE, string Token, string LastLogoutTimeS, string LastLogoutTimeE, string ReDateTimeS, string ReDateTimeE, string ReTerminalIP, string ReTerminalName, string ReUserId, string ReIdentify, int GetIdentify, int GetPhoneNo, int GetUserName, int GetRole, int GetPassword, int GetLastLoginTime, int GetToken, int GetLastLogoutTime, int GetRevisionInfo)
{
List <GetUserInfo> list = new List <GetUserInfo>();
try
{
if (!pclsCache.Connect())
{
return(list);
}
InterSystems.Data.CacheTypes.CacheSysList Result = Cm.MstUser.GetUsersInfoByAnyProperty(pclsCache.CacheConnectionObject, UserId, Identify, PhoneNo, UserName, Role, Password, LastLoginTimeS, LastLoginTimeE, Token, LastLogoutTimeS, LastLogoutTimeE, ReDateTimeS, ReDateTimeE, ReTerminalIP, ReTerminalName, ReUserId, ReIdentify, GetIdentify, GetPhoneNo, GetUserName, GetRole, GetPassword, GetLastLoginTime, GetToken, GetLastLogoutTime, GetRevisionInfo);
int count = Result.Count;
int i = 1;
while (i < count)
{
string[] ret = Result[i].Split('|');
GetUserInfo userInfo = new GetUserInfo();
if (ret[0] != "")
{
userInfo.UserId = ret[0];
}
if (ret[1] != "")
{
userInfo.Identify = ret[1];
}
if (ret[2] != "")
{
userInfo.PhoneNo = Convert.ToInt64(ret[2]);
}
if (ret[3] != "")
{
userInfo.UserName = ret[3];
}
if (ret[4] != "")
{
userInfo.Role = ret[4];
}
if (ret[5] != "")
{
userInfo.Password = ret[5];
}
if (ret[6] != "")
{
userInfo.LastLoginTime = Convert.ToDateTime(ret[6]);
}
if (ret[7] != "")
{
userInfo.Token = ret[7];
}
if (ret[8] != "")
{
userInfo.LastLogoutTime = Convert.ToDateTime(ret[8]);
}
if (ret[9] != "")
{
userInfo.revDateTime = Convert.ToDateTime(ret[9]);
}
if (ret[10] != "")
{
userInfo.TerminalIP = ret[10];
}
if (ret[11] != "")
{
userInfo.TerminalName = ret[11];
}
if (ret[12] != "")
{
userInfo.revUserId = ret[12];
}
if (ret[13] != "")
{
userInfo.revIdentify = ret[13];
}
list.Add(userInfo);
i++;
}
return(list);
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "UserInfoMethod.MstUserGetUsersInfoByAnyProperty", "数据库操作异常！ error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
return(list);
}
finally
{
pclsCache.DisConnect();
}
}
/// <summary>
/// 根据任何筛选条件得到隔离器环境记录们的信息
/// </summary>
/// <param name="pclsCache"></param>
/// <param name="IsolatorId"></param>
/// <param name="CabinId"></param>
/// <param name="MeaTimeS"></param>
/// <param name="MeaTimeE"></param>
/// <param name="IsoCode"></param>
/// <param name="IsoValue"></param>
/// <param name="ReDateTimeS"></param>
/// <param name="ReDateTimeE"></param>
/// <param name="ReTerminalIP"></param>
/// <param name="ReTerminalName"></param>
/// <param name="ReUserId"></param>
/// <param name="ReIdentify"></param>
/// <param name="GetIsoValue"></param>
/// <param name="GetRevisionInfo"></param>
/// <returns></returns>
public List <GetIsolatorEnv> EnvIsolatorGetIsolatorEnvsByAnyProperty(DataConnection pclsCache, string IsolatorId, string CabinId, string MeaTimeS, string MeaTimeE, string IsoCode, string IsoValue, string ReDateTimeS, string ReDateTimeE, string ReTerminalIP, string ReTerminalName, string ReUserId, string ReIdentify, int GetIsoValue, int GetRevisionInfo)
{
List <GetIsolatorEnv> list = new List <GetIsolatorEnv>();
try
{
if (!pclsCache.Connect())
{
return(list);
}
InterSystems.Data.CacheTypes.CacheSysList Result = It.EnvIsolator.GetIsolatorEnvsByAnyProperty(pclsCache.CacheConnectionObject, IsolatorId, CabinId, MeaTimeS, MeaTimeE, IsoCode, IsoValue, ReDateTimeS, ReDateTimeE, ReTerminalIP, ReTerminalName, ReUserId, ReIdentify, GetIsoValue, GetRevisionInfo);
int count = Result.Count;
int i = 1;
while (i < count)
{
string[] ret = Result[i].Split('|');
GetIsolatorEnv isolatorEnv = new GetIsolatorEnv();
if (ret[0] != "")
{
isolatorEnv.IsolatorId = ret[0];
}
if (ret[1] != "")
{
isolatorEnv.CabinId = ret[1];
}
if (ret[2] != "")
{
isolatorEnv.MeaTime = Convert.ToDateTime(ret[2]);
}
if (ret[3] != "")
{
isolatorEnv.IsoCode = ret[3];
}
if (ret[4] != "")
{
isolatorEnv.IsoValue = ret[4];
}
if (ret[5] != "")
{
isolatorEnv.revDateTime = Convert.ToDateTime(ret[5]);
}
if (ret[6] != "")
{
isolatorEnv.TerminalIP = ret[6];
}
if (ret[7] != "")
{
isolatorEnv.TerminalName = ret[7];
}
if (ret[8] != "")
{
isolatorEnv.revUserId = ret[8];
}
if (ret[9] != "")
{
isolatorEnv.revIdentify = ret[9];
}
list.Add(isolatorEnv);
i++;
}
return(list);
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "ItemInfoMethod.EnvIsolatorGetIsolatorEnvsByAnyProperty", "数据库操作异常！ error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
return(list);
}
finally
{
pclsCache.DisConnect();
}
}
/// <summary>
/// 根据任何筛选条件得到仪器操作记录们的信息
/// </summary>
/// <param name="pclsCache"></param>
/// <param name="EquipmentId"></param>
/// <param name="OperationNo"></param>
/// <param name="OperationTimeS"></param>
/// <param name="OperationTimeE"></param>
/// <param name="OperationCode"></param>
/// <param name="OperationValue"></param>
/// <param name="OperationResult"></param>
/// <param name="ReDateTimeS"></param>
/// <param name="ReDateTimeE"></param>
/// <param name="ReTerminalIP"></param>
/// <param name="ReTerminalName"></param>
/// <param name="ReUserId"></param>
/// <param name="ReIdentify"></param>
/// <param name="GetOperationTime"></param>
/// <param name="GetOperationCode"></param>
/// <param name="GetOperationValue"></param>
/// <param name="GetOperationResult"></param>
/// <param name="GetRevisionInfo"></param>
/// <returns></returns>
public List <GetOperationInfo> OpEquipmentGetEquipmentOpsByAnyProperty(DataConnection pclsCache, string EquipmentId, string OperationTimeS, string OperationTimeE, string OperationCode, string OperationValue, string OperationResult, string ReDateTimeS, string ReDateTimeE, string ReTerminalIP, string ReTerminalName, string ReUserId, string ReIdentify, int GetOperationCode, int GetOperationValue, int GetOperationResult, int GetRevisionInfo)
{
List <GetOperationInfo> list = new List <GetOperationInfo>();
try
{
if (!pclsCache.Connect())
{
return(list);
}
InterSystems.Data.CacheTypes.CacheSysList Result = Op.OpEquipment.GetEquipmentOpsByAnyProperty(pclsCache.CacheConnectionObject, EquipmentId, OperationTimeS, OperationTimeE, OperationCode, OperationValue, OperationResult, ReDateTimeS, ReDateTimeE, ReTerminalIP, ReTerminalName, ReUserId, ReIdentify, GetOperationCode, GetOperationValue, GetOperationResult, GetRevisionInfo);
int count = Result.Count;
int i = 1;
while (i < count)
{
string[] ret = Result[i].Split('|');
GetOperationInfo operationInfo = new GetOperationInfo();
if (ret[0] != "")
{
operationInfo.EquipmentId = ret[0];
}
if (ret[1] != "")
{
operationInfo.OperationTime = Convert.ToDateTime(ret[1]);
}
if (ret[2] != "")
{
operationInfo.OperationCode = ret[2];
}
if (ret[3] != "")
{
operationInfo.OperationValue = ret[3];
}
if (ret[4] != "")
{
operationInfo.OperationResult = ret[4];
}
if (ret[5] != "")
{
operationInfo.revDateTime = Convert.ToDateTime(ret[5]);
}
if (ret[6] != "")
{
operationInfo.TerminalIP = ret[6];
}
if (ret[7] != "")
{
operationInfo.TerminalName = ret[7];
}
if (ret[8] != "")
{
operationInfo.revUserId = ret[8];
}
if (ret[9] != "")
{
operationInfo.revIdentify = ret[9];
}
list.Add(operationInfo);
i++;
}
return(list);
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "OperationMethod.OpEquipmentGetEquipmentOpsByAnyProperty", "数据库操作异常！ error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
return(list);
}
finally
{
pclsCache.DisConnect();
}
}
//GetGuidesByCode LS 2015-06-28 输出用于图形的分级区域
public static GraphGuide GetGuidesByCode(DataConnection pclsCache, string PlanNo, string Code, List <MstBloodPressure> Reference)
{
GraphGuide GraphGuide = new GraphGuide(); //输出
List <Guide> GuideList = new List <Guide>();
try
{
if ((Code == "Bloodpressure|Bloodpressure_1") && (Reference != null))
{
#region 收缩压
GraphGuide.minimum = Convert.ToDouble(Reference[0].SBP);
GraphGuide.maximum = Convert.ToDouble(Reference[Reference.Count - 1].SBP);
InterSystems.Data.CacheTypes.CacheSysList SysTarget = null;
SysTarget = PsTarget.GetTargetByCode(pclsCache, PlanNo, "Bloodpressure", "Bloodpressure_1");
if (SysTarget != null)
{
//初始值
Guide originalGuide = new Guide();
originalGuide.value = SysTarget[4].ToString(); //值或起始值
originalGuide.toValue = "#CC0000"; //终值或""
originalGuide.label = ""; //中文定义 目标线、偏低、偏高等
//originalGuide.label = "起始" + "：" + originalGuide.value;
originalGuide.lineColor = "#FF5151"; //直线颜色 目标线 初始线
originalGuide.lineAlpha = "1"; //直线透明度 0全透~1
originalGuide.dashLength = "8"; //虚线密度 4 8
originalGuide.color = "#CC0000"; //字体颜色
originalGuide.fontSize = "8"; //字体大小 默认14
originalGuide.position = "right"; //字体位置 right left
originalGuide.inside = ""; //坐标系的内或外 false
originalGuide.fillAlpha = "";
originalGuide.fillColor = "";
GuideList.Add(originalGuide);
GraphGuide.original = originalGuide.value + "mmHg";
//目标值
Guide tagetGuide = new Guide();
tagetGuide.value = SysTarget[3].ToString();
tagetGuide.toValue = "#CC0000";
tagetGuide.label = "";
//tagetGuide.label = "目标" + "：" + tagetGuide.value;
tagetGuide.lineColor = "#CC0000";
tagetGuide.lineAlpha = "1";
tagetGuide.dashLength = "4";
tagetGuide.color = "#CC0000";
tagetGuide.fontSize = "14";
tagetGuide.position = "right";
tagetGuide.inside = "";
tagetGuide.fillAlpha = "";
tagetGuide.fillColor = "";
GuideList.Add(tagetGuide);
GraphGuide.target = tagetGuide.value + "mmHg";
}
//风险范围
for (int i = 0; i <= Reference.Count - 2; i++)
{
//收缩压
Guide SysGuide = new Guide();
SysGuide.value = Reference[i].SBP.ToString(); //起始值
SysGuide.toValue = Reference[i + 1].SBP.ToString(); //终值
SysGuide.label = Reference[i].Name; //偏低、偏高等
SysGuide.lineColor = ""; //直线颜色 目标线 初始线
SysGuide.lineAlpha = ""; //直线透明度 0全透~1
SysGuide.dashLength = ""; //虚线密度 4 8
SysGuide.color = "#CC0000"; //字体颜色
SysGuide.fontSize = "14"; //字体大小 默认14
SysGuide.position = "right"; //字体位置 right left
SysGuide.inside = "true"; //坐标系的内或外 false
SysGuide.fillAlpha = "0.1";
SysGuide.fillColor = CmMstBloodPressure.GetBPColor(SysGuide.label, "fill"); //GetFillColor
GuideList.Add(SysGuide);
}
//一般线
for (int i = 0; i <= Reference.Count - 1; i++)
{
//收缩压
Guide SysGuide = new Guide();
SysGuide.value = Reference[i].SBP.ToString();
SysGuide.toValue = "#CC0000";
SysGuide.label = Reference[i].SBP.ToString();
SysGuide.lineColor = "#CC0000";
SysGuide.lineAlpha = "0.15";
SysGuide.dashLength = "";
SysGuide.color = "#CC0000";
SysGuide.fontSize = "8";
SysGuide.position = "left";
SysGuide.inside = "";
SysGuide.fillAlpha = "";
SysGuide.fillColor = "";
GuideList.Add(SysGuide);
}
#endregion
}
else if ((Code == "Bloodpressure|Bloodpressure_2") && (Reference != null))
{
#region 舒张压
GraphGuide.minimum = Convert.ToDouble(Reference[0].DBP);
GraphGuide.maximum = Convert.ToDouble(Reference[Reference.Count - 1].DBP);
InterSystems.Data.CacheTypes.CacheSysList DiaTarget = null;
DiaTarget = PsTarget.GetTargetByCode(pclsCache, PlanNo, "Bloodpressure", "Bloodpressure_2");
if (DiaTarget != null)
{
//初始值
Guide originalGuide = new Guide();
originalGuide.value = DiaTarget[4].ToString(); //值或起始值
originalGuide.toValue = "#CC0000"; //终值或""
originalGuide.label = ""; //中文定义 目标线、偏低、偏高等
//originalGuide.label = "起始" + "：" + originalGuide.value;
originalGuide.lineColor = "#FF5151"; //直线颜色 目标线 初始线
originalGuide.lineAlpha = "1"; //直线透明度 0全透~1
originalGuide.dashLength = "8"; //虚线密度 4 8
originalGuide.color = "#CC0000"; //字体颜色
originalGuide.fontSize = "8"; //字体大小 默认14
originalGuide.position = "right"; //字体位置 right left
originalGuide.inside = ""; //坐标系的内或外 false
originalGuide.fillAlpha = "";
originalGuide.fillColor = "";
GuideList.Add(originalGuide);
GraphGuide.original = originalGuide.value + "mmHg";
//目标值
Guide tagetGuide = new Guide();
tagetGuide.value = DiaTarget[3].ToString();
tagetGuide.toValue = "#CC0000";
tagetGuide.label = "";
//tagetGuide.label = "目标" + "：" + tagetGuide.value;
tagetGuide.lineColor = "#CC0000";
tagetGuide.lineAlpha = "1";
tagetGuide.dashLength = "4";
tagetGuide.color = "#CC0000";
tagetGuide.fontSize = "14";
tagetGuide.position = "right";
tagetGuide.inside = "";
tagetGuide.fillColor = "";
tagetGuide.fillAlpha = "";
GuideList.Add(tagetGuide);
GraphGuide.target = tagetGuide.value + "mmHg";
}
//风险范围
for (int i = 0; i <= Reference.Count - 2; i++)
{
//舒张压
Guide DiaGuide = new Guide();
DiaGuide.value = Reference[i].DBP.ToString();
DiaGuide.toValue = Reference[i + 1].DBP.ToString();
DiaGuide.label = Reference[i].Name;
DiaGuide.lineColor = "";
DiaGuide.lineAlpha = "";
DiaGuide.dashLength = "";
DiaGuide.color = "#CC0000";
DiaGuide.fontSize = "14";
DiaGuide.position = "right";
DiaGuide.inside = "true";
DiaGuide.fillAlpha = "0.1";
DiaGuide.fillColor = CmMstBloodPressure.GetBPColor(DiaGuide.label, "fill");
GuideList.Add(DiaGuide);
}
//一般线
for (int i = 0; i <= Reference.Count - 1; i++)
{
//舒张压
Guide DiaGuide = new Guide();
DiaGuide.value = Reference[i].DBP.ToString();
DiaGuide.toValue = "#CC0000";
DiaGuide.label = Reference[i].DBP.ToString();
DiaGuide.lineColor = "#CC0000";
DiaGuide.lineAlpha = "0.15";
DiaGuide.dashLength = "";
DiaGuide.color = "#CC0000";
DiaGuide.fontSize = "8";
DiaGuide.position = "left";
DiaGuide.inside = "";
DiaGuide.fillAlpha = "";
DiaGuide.fillColor = "";
GuideList.Add(DiaGuide);
}
#endregion
}
else if (Code == "Pulserate|Pulserate_1") //脉率没有 初始值和目标值
{
#region 率
GraphGuide.minimum = 30;
GraphGuide.maximum = 150;
////初始值
//Guide originalGuide = new Guide();
//originalGuide.value =""; //值或起始值
//originalGuide.toValue = "#CC0000"; //终值或""
//originalGuide.label = ""; //中文定义 目标线、偏低、偏高等
////originalGuide.label = "起始" + "：" + originalGuide.value;
//originalGuide.lineColor = "#FF5151"; //直线颜色 目标线 初始线
//originalGuide.lineAlpha = "1";//直线透明度 0全透~1
//originalGuide.dashLength = "8"; //虚线密度 4 8
//originalGuide.color = "#CC0000"; //字体颜色
//originalGuide.fontSize = "8"; //字体大小 默认14
//originalGuide.position = "right"; //字体位置 right left
//originalGuide.inside = "";//坐标系的内或外 false
//originalGuide.fillAlpha = "";
//originalGuide.fillColor = "";
//GuideList.Add(originalGuide);
//GraphGuide.original = originalGuide.value;
////目标值
//Guide tagetGuide = new Guide();
//tagetGuide.value = "";
//tagetGuide.toValue = "#CC0000";
//tagetGuide.label = "";
////tagetGuide.label = "目标" + "：" + tagetGuide.value;
//tagetGuide.lineColor = "#CC0000";
//tagetGuide.lineAlpha = "1";
//tagetGuide.dashLength = "4";
//tagetGuide.color = "#CC0000";
//tagetGuide.fontSize = "14";
//tagetGuide.position = "right";
//tagetGuide.inside = "";
//tagetGuide.fillColor = "";
//tagetGuide.fillAlpha = "";
//风险范围
//正常
Guide PulseGuide = new Guide();
PulseGuide.value = "60";
PulseGuide.toValue = "100";
PulseGuide.label = "正常";
PulseGuide.lineColor = "";
PulseGuide.lineAlpha = "";
PulseGuide.dashLength = "";
PulseGuide.color = "#00DB00"; //字的颜色
PulseGuide.fontSize = "14";
PulseGuide.position = "right";
PulseGuide.inside = "true";
PulseGuide.fillAlpha = "0.1";
PulseGuide.fillColor = "#2894FF"; //区域颜色
GuideList.Add(PulseGuide);
//偏高 #CC0000
PulseGuide = new Guide();
PulseGuide.value = "100";
PulseGuide.toValue = "150";
PulseGuide.label = "偏高";
PulseGuide.lineColor = "";
PulseGuide.lineAlpha = "";
PulseGuide.dashLength = "";
PulseGuide.color = "#FF60AF";
PulseGuide.fontSize = "14";
PulseGuide.position = "right";
PulseGuide.inside = "true";
PulseGuide.fillAlpha = "0.1";
PulseGuide.fillColor = "#CC0000";
GuideList.Add(PulseGuide);
//偏低
PulseGuide = new Guide();
PulseGuide.value = "30";
PulseGuide.toValue = "60";
PulseGuide.label = "偏低";
PulseGuide.lineColor = "";
PulseGuide.lineAlpha = "";
PulseGuide.dashLength = "";
PulseGuide.color = "#8080C0";
PulseGuide.fontSize = "14";
PulseGuide.position = "right";
PulseGuide.inside = "true";
PulseGuide.fillAlpha = "0.1";
PulseGuide.fillColor = "#FFC78E";
GuideList.Add(PulseGuide);
//一般线
//30
PulseGuide = new Guide();
PulseGuide.value = "30";
PulseGuide.toValue = "#CC0000";
PulseGuide.label = "30";
PulseGuide.lineColor = "#CC0000";
PulseGuide.lineAlpha = "0.15";
PulseGuide.dashLength = "";
PulseGuide.color = "#CC0000";
PulseGuide.fontSize = "8";
PulseGuide.position = "left";
PulseGuide.inside = "";
PulseGuide.fillAlpha = "";
PulseGuide.fillColor = "";
GuideList.Add(PulseGuide);
//60
PulseGuide = new Guide();
PulseGuide.value = "60";
PulseGuide.toValue = "#CC0000";
PulseGuide.label = "60";
PulseGuide.lineColor = "#CC0000";
PulseGuide.lineAlpha = "0.15";
PulseGuide.dashLength = "";
PulseGuide.color = "#CC0000";
PulseGuide.fontSize = "8";
PulseGuide.position = "left";
PulseGuide.inside = "";
PulseGuide.fillAlpha = "";
PulseGuide.fillColor = "";
GuideList.Add(PulseGuide);
//100
PulseGuide = new Guide();
PulseGuide.value = "100";
PulseGuide.toValue = "#CC0000";
PulseGuide.label = "100";
PulseGuide.lineColor = "#CC0000";
PulseGuide.lineAlpha = "0.15";
PulseGuide.dashLength = "";
PulseGuide.color = "#CC0000";
PulseGuide.fontSize = "8";
PulseGuide.position = "left";
PulseGuide.inside = "";
PulseGuide.fillAlpha = "";
PulseGuide.fillColor = "";
GuideList.Add(PulseGuide);
#endregion
}
GraphGuide.GuideList = GuideList;
return(GraphGuide);
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "CmMstBloodPressure.GetGuidesByCode", "数据库操作异常！ error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
return(null);
}
finally
{
}
}
/// <summary>
/// 根据任何筛选条件得到样品们的信息
/// </summary>
/// <param name="pclsCache"></param>
/// <param name="ObjectNo"></param>
/// <param name="ObjCompany"></param>
/// <param name="ObjIncuSeq"></param>
/// <param name="ObjectName"></param>
/// <param name="ObjectType"></param>
/// <param name="SamplingPeople"></param>
/// <param name="SamplingTimeS"></param>
/// <param name="SamplingTimeE"></param>
/// <param name="Warning"></param>
/// <param name="ReDateTimeS"></param>
/// <param name="ReDateTimeE"></param>
/// <param name="ReTerminalIP"></param>
/// <param name="ReTerminalName"></param>
/// <param name="ReUserId"></param>
/// <param name="ReIdentify"></param>
/// <param name="GetObjectName"></param>
/// <param name="GetObjectType"></param>
/// <param name="GetSamplingPeople"></param>
/// <param name="GetSamplingTime"></param>
/// <param name="GetWarning"></param>
/// <param name="GetRevisionInfo"></param>
/// <returns></returns>
public List <GetSampleInfo> ItemSampleGetSamplesInfoByAnyProperty(DataConnection pclsCache, string ObjectNo, string ObjCompany, string ObjIncuSeq, string ObjectName, string ObjectType, string SamplingPeople, string SamplingTimeS, string SamplingTimeE, string Warning, string Status, string ReDateTimeS, string ReDateTimeE, string ReTerminalIP, string ReTerminalName, string ReUserId, string ReIdentify, int GetObjectName, int GetObjectType, int GetSamplingPeople, int GetSamplingTime, int GetWarning, int GetStatus, int GetRevisionInfo)
{
List <GetSampleInfo> list = new List <GetSampleInfo>();
try
{
if (!pclsCache.Connect())
{
return(list);
}
InterSystems.Data.CacheTypes.CacheSysList Result = It.ItemSample.GetSamplesInfoByAnyProperty(pclsCache.CacheConnectionObject, ObjectNo, ObjCompany, ObjIncuSeq, ObjectName, ObjectType, SamplingPeople, SamplingTimeS, SamplingTimeE, Warning, Status, ReDateTimeS, ReDateTimeE, ReTerminalIP, ReTerminalName, ReUserId, ReIdentify, GetObjectName, GetObjectType, GetSamplingPeople, GetSamplingTime, GetWarning, GetStatus, GetRevisionInfo);
int count = Result.Count;
int i = 1;
while (i < count)
{
string[] ret = Result[i].Split('|');
GetSampleInfo sampleInfo = new GetSampleInfo();
if (ret[0] != "")
{
sampleInfo.ObjectNo = ret[0];
}
if (ret[1] != "")
{
sampleInfo.ObjCompany = ret[1];
}
if (ret[2] != "")
{
sampleInfo.ObjIncuSeq = ret[2];
}
if (ret[3] != "")
{
sampleInfo.ObjectName = ret[3];
}
if (ret[4] != "")
{
sampleInfo.ObjectType = ret[4];
}
if (ret[5] != "")
{
sampleInfo.SamplingPeople = ret[5];
}
if (ret[6] != "")
{
sampleInfo.SamplingTime = Convert.ToDateTime(ret[6]);
}
if (ret[7] != "")
{
sampleInfo.Warning = ret[7];
}
if (ret[8] != "")
{
sampleInfo.Status = ret[8];
}
if (ret[9] != "")
{
sampleInfo.revDateTime = Convert.ToDateTime(ret[9]);
}
if (ret[10] != "")
{
sampleInfo.TerminalIP = ret[10];
}
if (ret[11] != "")
{
sampleInfo.TerminalName = ret[11];
}
if (ret[12] != "")
{
sampleInfo.revUserId = ret[12];
}
if (ret[13] != "")
{
sampleInfo.revIdentify = ret[13];
}
list.Add(sampleInfo);
i++;
}
return(list);
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "ItemInfoMethod.ItemSampleGetSamplesInfoByAnyProperty", "数据库操作异常！ error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
return(list);
}
finally
{
pclsCache.DisConnect();
}
}
