/// <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();
}
}
// Will pass the select query to CacheCommand
public DataTable readQuery(string sql)
{
DataTable dataTable = new DataTable();
// set the global sql statement so our views can read them
CacheCommand Command = new CacheCommand(sql, _cacheConnect);
CacheDataReader reader = Command.ExecuteReader();
int record = 0;
while (reader.Read())
{
// Get the column number
int fields = reader.VisibleFieldCount;
var tableRow = dataTable.NewRow();
// We only do this once to get column names
if (record == 0) {
// Get name based off ordinal position
for (int i = 0; i < fields; i++) {
var sname = reader.GetName(i);
dataTable.Columns.Add(sname);
}
}
// Now get values
for (int i = 0; i < fields; i++)
{
tableRow[reader.GetName(i)] = reader.GetValue(i);
}
dataTable.Rows.Add(tableRow);
record++;
}
return dataTable;
}
//GetLabTestDetails 获取患者某次化验的所有详细信息 ZC 2014-12-2
//CSQ 2015-06-25
public static DataTable GetLabTestDetails(DataConnection pclsCache, string UserId, string VisitId, string SortNo)
{
DataTable list = new DataTable();
list.Columns.Add(new DataColumn("Code", typeof(string)));
list.Columns.Add(new DataColumn("Name", typeof(string)));
list.Columns.Add(new DataColumn("Value", typeof(string)));
list.Columns.Add(new DataColumn("IsAbnormalCode", typeof(int)));
list.Columns.Add(new DataColumn("IsAbnormal", typeof(string)));
list.Columns.Add(new DataColumn("UnitCode", typeof(string)));
list.Columns.Add(new DataColumn("Unit", typeof(string)));
list.Columns.Add(new DataColumn("Creator", typeof(string)));
CacheCommand cmd = null;
CacheDataReader cdr = null;
try
{
if (!pclsCache.Connect())
{
return null;
}
cmd = new CacheCommand();
cmd = Ps.LabTestDetails.GetLabTestDetails(pclsCache.CacheConnectionObject);
cmd.Parameters.Add("UserId", CacheDbType.NVarChar).Value = UserId;
cmd.Parameters.Add("VisitId", CacheDbType.NVarChar).Value = VisitId;
cmd.Parameters.Add("SortNo", CacheDbType.NVarChar).Value = SortNo;
//cmd.Parameters.Add("ItemCode", CacheDbType.NVarChar).Value = ItemCode;
cdr = cmd.ExecuteReader();
while (cdr.Read())
{
list.Rows.Add(cdr["Code"].ToString(), cdr["Name"].ToString(), cdr["Value"].ToString(),
Convert.ToInt32(cdr["IsAbnormalCode"].ToString()), cdr["IsAbnormal"].ToString(),
cdr["UnitCode"].ToString(), cdr["Unit"].ToString(), cdr["Creator"].ToString());
}
return list;
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "PsLabTestDetails.GetLabTestDetails", "数据库操作异常！ error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
return null;
}
finally
{
if ((cdr != null))
{
cdr.Close();
cdr.Dispose(true);
cdr = null;
}
if ((cmd != null))
{
cmd.Parameters.Clear();
cmd.Dispose();
cmd = null;
}
pclsCache.DisConnect();
}
}
//ZAM 20150422 获取健康专员负责的所有患者列表
public static DataTable GetPatientsPlanByDoctorId(DataConnection pclsCache, string DoctorId, string Module)
{
DataTable list = new DataTable();
list.Columns.Add(new DataColumn("PatientId", typeof(string)));
list.Columns.Add(new DataColumn("PlanNo", typeof(string)));
list.Columns.Add(new DataColumn("StartDate", typeof(string)));
list.Columns.Add(new DataColumn("EndDate", typeof(string)));
list.Columns.Add(new DataColumn("TotalDays", typeof(string)));
list.Columns.Add(new DataColumn("RemainingDays", typeof(string)));
list.Columns.Add(new DataColumn("Status", typeof(string)));
CacheCommand cmd = null;
CacheDataReader cdr = null;
try
{
if (!pclsCache.Connect())
{
return null;
}
cmd = new CacheCommand();
cmd = Ps.Plan.GetPatientsPlanByDoctorId(pclsCache.CacheConnectionObject);
cmd.Parameters.Add("DoctorId", CacheDbType.NVarChar).Value = DoctorId;
cmd.Parameters.Add("Module", CacheDbType.NVarChar).Value = Module;
cdr = cmd.ExecuteReader();
while (cdr.Read())
{
//DataCheck ZAM 2015-4-16
if (cdr["PatientId"].ToString() == string.Empty)
{
continue;
}
list.Rows.Add(cdr["PatientId"].ToString(), cdr["PlanNo"].ToString(), cdr["StartDate"].ToString(), cdr["EndDate"].ToString(), cdr["TotalDays"].ToString(), cdr["RemainingDays"].ToString(), cdr["Status"].ToString());
}
return list;
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "Ps.Plan.GetPatientsPlanByDoctorId", "数据库操作异常！ 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();
}
}
// 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();
}
}
// 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.DiagnosisDict.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["Code"].ToString(), cdr["Name"].ToString(), cdr["InputCode"].ToString(), cdr["Description"].ToString(), cdr["Status"]);
}
return list;
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "Tmp.DiagnosisDict.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();
}
}
//CSQ 2015-1-21
public static DataTable GetInfobyId(DataConnection pclsCache, string UserId)
{
DataTable list = new DataTable();
list.Columns.Add(new DataColumn("VisitId", typeof(string)));
list.Columns.Add(new DataColumn("SortNo", typeof(string)));
list.Columns.Add(new DataColumn("AdmissionDate", typeof(string)));
list.Columns.Add(new DataColumn("DischargeDate", typeof(string)));
list.Columns.Add(new DataColumn("HospitalCode", typeof(string)));
list.Columns.Add(new DataColumn("HospitalName", typeof(string)));
list.Columns.Add(new DataColumn("Department", typeof(string)));
list.Columns.Add(new DataColumn("DepartmentName", typeof(string)));
list.Columns.Add(new DataColumn("Doctor", 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.InPatientInfo.GetInfobyId(pclsCache.CacheConnectionObject);
cmd.Parameters.Add("UserId", CacheDbType.NVarChar).Value = UserId;
//cmd.Parameters.Add("InvalidFlag", CacheDbType.Int).Value = InvalidFlag;
cdr = cmd.ExecuteReader();
while (cdr.Read())
{
list.Rows.Add(cdr["VisitId"].ToString(), cdr["SortNo"].ToString(), cdr["AdmissionDate"].ToString(), cdr["DischargeDate"].ToString(), cdr["HospitalCode"].ToString(), cdr["HospitalName"].ToString(), cdr["Department"].ToString(), cdr["DepartmentName"].ToString(), cdr["Doctor"].ToString(), cdr["Creator"].ToString());
}
return list;
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "PsInPatientInfo.GetInfobyId", "数据库操作异常！ 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 List<VitalInfo> GetAllSignsByPeriod(DataConnection pclsCache, string UserId, int StartDate, int EndDate)
{
{
List<VitalInfo> items = new List<VitalInfo>();
CacheCommand cmd = null;
CacheDataReader cdr = null;
try
{
if (!pclsCache.Connect())
{
return null;
}
cmd = new CacheCommand();
cmd = Ps.VitalSigns.GetAllSignsByPeriod(pclsCache.CacheConnectionObject);
cmd.Parameters.Add("UserId", CacheDbType.NVarChar).Value = UserId;
cmd.Parameters.Add("StartDate", CacheDbType.NVarChar).Value = StartDate;
cmd.Parameters.Add("EndDate", CacheDbType.NVarChar).Value = EndDate;
cdr = cmd.ExecuteReader();
while (cdr.Read())
{
VitalInfo item = new VitalInfo();
item.RecordDate = cdr["RecordDate"].ToString();
item.RecordTime = cdr["RecordTime"].ToString();
item.ItemType = cdr["ItemType"].ToString();
item.ItemCode = cdr["ItemCode"].ToString();
item.Value = cdr["Value"].ToString();
item.Unit = cdr["Unit"].ToString();
item.Name = cdr["VitalName"].ToString();
items.Add(item);
}
return items;
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "VitalInfoMethod.GetAllSignsByPeriod", "数据库操作异常！ 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 DataTable GetDrugDetail(DataConnection pclsCache, string Module)
{
DataTable list = new DataTable();
list.Columns.Add(new DataColumn("DrugCode", typeof(string)));
list.Columns.Add(new DataColumn("DrugName", typeof(string)));
list.Columns.Add(new DataColumn("DrugSpec", typeof(string)));
list.Columns.Add(new DataColumn("Units", typeof(string)));
list.Columns.Add(new DataColumn("DrugIndicator", typeof(string)));
list.Columns.Add(new DataColumn("CurativeEffect", typeof(string)));
list.Columns.Add(new DataColumn("SideEffect", typeof(string)));
list.Columns.Add(new DataColumn("Instruction", typeof(string)));
list.Columns.Add(new DataColumn("HealthEffect", typeof(string)));
list.Columns.Add(new DataColumn("Unit", typeof(string)));
list.Columns.Add(new DataColumn("Redundance", typeof(string)));
CacheCommand cmd = null;
CacheDataReader cdr = null;
try
{
if (!pclsCache.Connect())
{
return null;
}
cmd = new CacheCommand();
cmd = Cm.MstDrugDetail.GetDrugDetail(pclsCache.CacheConnectionObject);
cmd.Parameters.Add("Module", CacheDbType.NVarChar).Value = Module;
cdr = cmd.ExecuteReader();
while (cdr.Read())
{
list.Rows.Add(cdr["DrugCode"].ToString(), cdr["DrugName"].ToString(), cdr["DrugSpec"].ToString(), cdr["Units"].ToString(), cdr["DrugIndicator"].ToString(), cdr["CurativeEffect"].ToString(), cdr["SideEffect"].ToString(), cdr["Instruction"].ToString(), cdr["HealthEffect"].ToString(), cdr["Unit"].ToString(), cdr["Redundance"].ToString());
}
return list;
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "Cm.MstDrugDetail.GetDrugDetail", "数据库操作异常！ 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();
}
}
//CSQ 2015-1-21
public static DataTable GetSymptomsList(DataConnection pclsCache, string UserId, string VisitId)
{
DataTable list = new DataTable();
list.Columns.Add(new DataColumn("VisitId", typeof(string)));
list.Columns.Add(new DataColumn("SynptomsNo", typeof(string)));
list.Columns.Add(new DataColumn("SymptomsType", typeof(string)));
list.Columns.Add(new DataColumn("SymptomsTypeName", typeof(string)));
list.Columns.Add(new DataColumn("SymptomsCode", typeof(string)));
list.Columns.Add(new DataColumn("SymptomsName", typeof(string)));
list.Columns.Add(new DataColumn("Description", typeof(string)));
list.Columns.Add(new DataColumn("RecordDate", typeof(string)));
list.Columns.Add(new DataColumn("RecordTime", 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.Symptoms.GetSymptomsList(pclsCache.CacheConnectionObject);
cmd.Parameters.Add("UserId", CacheDbType.NVarChar).Value = UserId;
cmd.Parameters.Add("VisitId", CacheDbType.NVarChar).Value = VisitId;
cdr = cmd.ExecuteReader();
while (cdr.Read())
{
list.Rows.Add(cdr["VisitId"].ToString(), cdr["SynptomsNo"].ToString(), cdr["SymptomsType"].ToString(), cdr["SymptomsTypeName"].ToString(), cdr["SymptomsCode"].ToString(), cdr["SymptomsName"].ToString(), cdr["Description"].ToString(), cdr["RecordDate"].ToString(), cdr["RecordTime"].ToString(), cdr["Creator"].ToString());
}
return list;
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "Ps.Symptoms.GetSymptomsList", "数据库操作异常！ 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();
}
}
// GetVitalSigns 获取体征信息列表 lpf 20150709
public static DataTable GetMpVitalSignsCmp(DataConnection pclsCache)
{
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("TypeName", typeof(string)));
list.Columns.Add(new DataColumn("Code", typeof(string)));
list.Columns.Add(new DataColumn("Name", typeof(string)));
list.Columns.Add(new DataColumn("HZCode", typeof(string)));
list.Columns.Add(new DataColumn("HZName", typeof(string)));
list.Columns.Add(new DataColumn("Redundance", typeof(string)));
CacheCommand cmd = null;
CacheDataReader cdr = null;
try
{
if (!pclsCache.Connect())
{
//MessageBox.Show("Cache数据库连接失败");
return null;
}
cmd = new CacheCommand();
cmd = Mp.VitalSignsCmp.GetMpVitalSignsCmp(pclsCache.CacheConnectionObject);
cdr = cmd.ExecuteReader();
while (cdr.Read())
{
list.Rows.Add(cdr["HospitalCode"].ToString(), cdr["HospitalName"].ToString(), cdr["Type"].ToString(), cdr["TypeName"].ToString(), cdr["Code"].ToString(), cdr["Name"].ToString(), cdr["HZCode"].ToString(), cdr["HZName"].ToString(), cdr["Redundance"].ToString());
}
return list;
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "MpVitalSignsCmp.GetMpVitalSignsCmp", "数据库操作异常！ 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();
}
}
private static AccountInfo AccountCurrentGet()
{
HttpCookie cookie = AccountCookieGet();
if (string.IsNullOrEmpty(cookie.Value))
{
return null;
}
CacheCommand<AccountInfo> cache = new CacheCommand<AccountInfo>(cookie.Value);
return cache.Get();
}
public List<Parameters> GetParameters(DataConnection pclsCache, string Indicators)
{
List<Parameters> list = new List<Parameters>();
CacheCommand cmd = null;
CacheDataReader cdr = null;
try
{
if (!pclsCache.Connect())
{
return null;
}
cmd = new CacheCommand();
cmd = Ps.Parameters.GetParameters(pclsCache.CacheConnectionObject);
cmd.Parameters.Add("Indicators", CacheDbType.NVarChar).Value = Indicators;
cdr = cmd.ExecuteReader();
while (cdr.Read())
{
list.Add(new Parameters
{
Id = cdr["Id"].ToString(),
Name = cdr["Name"].ToString(),
Value = cdr["Value"].ToString(),
Unit = cdr["Unit"].ToString()
});
}
return list;
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "RiskInfoMethod.GetParameters", "数据库操作异常！ 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();
}
}
// GetParameters ZAM 2014-12-4
public static DataTable GetParameters(DataConnection pclsCache, string Indicators)
{
DataTable list = new DataTable();
list.Columns.Add(new DataColumn("Id", typeof(string)));
list.Columns.Add(new DataColumn("Name", typeof(string)));
list.Columns.Add(new DataColumn("Value", typeof(string)));
list.Columns.Add(new DataColumn("Unit", typeof(string)));
CacheCommand cmd = null;
CacheDataReader cdr = null;
try
{
if (!pclsCache.Connect())
{
//MessageBox.Show("Cache数据库连接失败");
return null;
}
cmd = new CacheCommand();
cmd = Ps.Parameters.GetParameters(pclsCache.CacheConnectionObject);
cmd.Parameters.Add("Indicators", CacheDbType.NVarChar).Value = Indicators;
//cmd.Parameters.Add("InvalidFlag", CacheDbType.Int).Value = InvalidFlag;
cdr = cmd.ExecuteReader();
while (cdr.Read())
{
list.Rows.Add(cdr["Id"].ToString(), cdr["Name"].ToString(), cdr["Value"].ToString(), cdr["Unit"].ToString());
}
return list;
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "PsParameters.GetParameters", "数据库操作异常！ 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();
}
}
//GetDoctorList LS LS 2014-12-1
public static DataTable GetDoctorList(DataConnection pclsCache)
{
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)));
CacheCommand cmd = null;
CacheDataReader cdr = null;
try
{
if (!pclsCache.Connect())
{
//MessageBox.Show("Cache数据库连接失败");
return null;
}
cmd = new CacheCommand();
cmd = Ps.DoctorInfo.GetDoctorList(pclsCache.CacheConnectionObject);
cdr = cmd.ExecuteReader();
while (cdr.Read())
{
list.Rows.Add(cdr["DoctorId"].ToString(), cdr["DoctorName"].ToString(), Convert.ToInt32(cdr["Birthday"]), Convert.ToInt32(cdr["Gender"]), cdr["IDNo"].ToString(), Convert.ToInt32(cdr["InvalidFlag"]));
}
return list;
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "PsDoctorInfo.GetDoctorList", "数据库操作异常！ 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();
}
}
// GetDrugNameList 获取所有药品名称列表 CSQ 2015-05-12
public static DataTable GetDrugNameList(DataConnection pclsCache)
{
DataTable list = new DataTable();
list.Columns.Add(new DataColumn("DrugCode", typeof(string)));
list.Columns.Add(new DataColumn("DrugName", typeof(string)));
list.Columns.Add(new DataColumn("DrugSpec", typeof(string)));
list.Columns.Add(new DataColumn("Units", typeof(string)));
list.Columns.Add(new DataColumn("InputCode", typeof(string)));
CacheCommand cmd = null;
CacheDataReader cdr = null;
try
{
if (!pclsCache.Connect())
{
//MessageBox.Show("Cache数据库连接失败");
return null;
}
cmd = new CacheCommand();
cmd = Cm.MstDrug.GetNameListByCode(pclsCache.CacheConnectionObject);
cdr = cmd.ExecuteReader();
while (cdr.Read())
{
list.Rows.Add(cdr["DRUGCODE"].ToString(), cdr["DRUGNAME"].ToString(), cdr["DRUGSPEC"].ToString(), cdr["UNITS"].ToString(), cdr["INPUTCODE"].ToString());
}
return list;
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "CmMstDrug.GetDrugNameList", "数据库操作异常！ 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 DataTable GetListbyDay(DataConnection pclsCache, string PatientId, int StartDate, int StartTime)
{
DataTable list = new DataTable();
list.Columns.Add(new DataColumn("ReminderNo", typeof(string)));
list.Columns.Add(new DataColumn("TaskDate", typeof(string)));
list.Columns.Add(new DataColumn("TaskTime", typeof(string)));
list.Columns.Add(new DataColumn("IsDone", typeof(string)));
list.Columns.Add(new DataColumn("Description", typeof(string)));
CacheCommand cmd = null;
CacheDataReader cdr = null;
try
{
if (!pclsCache.Connect())
{
return null;
}
cmd = new CacheCommand();
cmd = Ps.TaskList.GetListbyDay(pclsCache.CacheConnectionObject);
cmd.Parameters.Add("PatientId", CacheDbType.NVarChar).Value = PatientId;
cmd.Parameters.Add("StartDate", CacheDbType.NVarChar).Value = StartDate;
cmd.Parameters.Add("StartTime", CacheDbType.NVarChar).Value = StartTime;
cdr = cmd.ExecuteReader();
while (cdr.Read())
{
list.Rows.Add(cdr["ReminderNo"].ToString(), cdr["TaskDate"].ToString(), cdr["TaskTime"].ToString(), cdr["IsDone"].ToString(), cdr["Description"].ToString());
}
return list;
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "Ps.TaskList.GetListbyDay", "数据库操作异常！ 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();
}
}
//GetEndingPlan 获取某模块已经结束的计划 LS 2015-06-24
public static DataTable GetEndingPlan(DataConnection pclsCache, string PatientId, string Module)
{
DataTable list = new DataTable();
list.Columns.Add(new DataColumn("PlanNo", typeof(string)));
list.Columns.Add(new DataColumn("StartDate", typeof(int)));
list.Columns.Add(new DataColumn("EndDate", typeof(int)));
//list.Columns.Add(new DataColumn("Module", typeof(string)));
//list.Columns.Add(new DataColumn("Status", typeof(string)));
// list.Columns.Add(new DataColumn("DoctorId", typeof(string)));
CacheCommand cmd = null;
CacheDataReader cdr = null;
try
{
if (!pclsCache.Connect())
{
return null;
}
cmd = new CacheCommand();
cmd = Ps.Plan.GetPlanList4ByM(pclsCache.CacheConnectionObject);
cmd.Parameters.Add("PatientId", CacheDbType.NVarChar).Value = PatientId;
cmd.Parameters.Add("Module", CacheDbType.NVarChar).Value = Module;
cdr = cmd.ExecuteReader();
while (cdr.Read())
{
list.Rows.Add(cdr["PlanNo"].ToString(), Convert.ToInt32(cdr["StartDate"]), Convert.ToInt32(cdr["EndDate"]));
}
return list;
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "Ps.Plan.GetEndingPlan", "数据库操作异常！ 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();
}
}
//GetTaskList 获取某计划下的所有任务 LS 2015-4-22
public static DataTable GetTaskList(DataConnection pclsCache, string PlanNo)
{
DataTable list = new DataTable();
list.Columns.Add(new DataColumn("Id", typeof(string)));
list.Columns.Add(new DataColumn("Type", typeof(string)));
list.Columns.Add(new DataColumn("Code", typeof(string)));
list.Columns.Add(new DataColumn("CodeName", typeof(string)));
list.Columns.Add(new DataColumn("Instruction", typeof(string)));
CacheCommand cmd = null;
CacheDataReader cdr = null;
try
{
if (!pclsCache.Connect())
{
return(null);
}
cmd = new CacheCommand();
cmd = Ps.Task.GetPsTask(pclsCache.CacheConnectionObject);
cmd.Parameters.Add("piUserId", CacheDbType.NVarChar).Value = PlanNo;
cdr = cmd.ExecuteReader();
while (cdr.Read())
{
list.Rows.Add(cdr["Id"].ToString(), cdr["Type"].ToString(), cdr["Code"].ToString(), cdr["CodeName"].ToString(), cdr["Instruction"].ToString());
}
return(list);
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "PsTask.GetTaskList", "数据库操作异常！ 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();
}
}
//GetPatientVitalSigns 获取患者某项生理参数的所有数据 ZC 2014-12-2
public static DataTable GetPatientVitalSigns(DataConnection pclsCache, string UserId, string ItemType, string ItemCode)
{
DataTable list = new DataTable();
list.Columns.Add(new DataColumn("RecordDate", typeof(string)));
list.Columns.Add(new DataColumn("RecordTime", typeof(string)));
list.Columns.Add(new DataColumn("Value", typeof(string)));
list.Columns.Add(new DataColumn("Unit", typeof(string)));
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())
{
list.Rows.Add(cdr["RecordDate"].ToString(), cdr["RecordTime"].ToString(), cdr["Value"].ToString(), cdr["Unit"].ToString());
}
return list;
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "PsVitalSigns.GetPatientVitalSigns", "数据库操作异常！ 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();
}
}
//获取血压表全部信息 2015-05-29 GL
public static DataTable GetBloodPressureList(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("Description", typeof(string)));
list.Columns.Add(new DataColumn("SBP", typeof(string)));
list.Columns.Add(new DataColumn("DBP", typeof(string)));
list.Columns.Add(new DataColumn("PatientClass", typeof(string)));
list.Columns.Add(new DataColumn("Redundance", typeof(string)));
CacheCommand cmd = null;
CacheDataReader cdr = null;
try
{
if (!pclsCache.Connect())
{
return null;
}
cmd = new CacheCommand();
cmd = Cm.MstBloodPressure.GetBPGrades(pclsCache.CacheConnectionObject);
cdr = cmd.ExecuteReader();
while (cdr.Read())
{
list.Rows.Add(cdr["Code"].ToString(), cdr["Name"].ToString(), cdr["Description"].ToString(), cdr["SBP"].ToString(), cdr["DBP"].ToString(), cdr["PatientClass"].ToString(), cdr["Redundance"].ToString());
}
return list;
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "Cm.MstBloodPressure.GetBPGrades", "数据库操作异常！ 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();
}
}
// GetNameListByType 根据Type，获取对应名称列表 CSQ 2014-12-01
public static DataTable GetNameListByType(DataConnection pclsCache, string Type)
{
DataTable list = new DataTable();
list.Columns.Add(new DataColumn("Code", typeof(string)));
list.Columns.Add(new DataColumn("Name", typeof(string)));
CacheCommand cmd = null;
CacheDataReader cdr = null;
try
{
if (!pclsCache.Connect())
{
//MessageBox.Show("Cache数据库连接失败");
return(null);
}
cmd = new CacheCommand();
cmd = Cm.MstExaminationItem.GetNameListByType(pclsCache.CacheConnectionObject);
cmd.Parameters.Add("Type", CacheDbType.NVarChar).Value = Type;
cdr = cmd.ExecuteReader();
while (cdr.Read())
{
list.Rows.Add(cdr["Code"].ToString(), cdr["Name"].ToString());
}
return(list);
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "CmMstExaminationItem.GetNameListByType", "数据库操作异常！ 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();
}
}
//GetNewLabTestForM3 SYF 20150930
public static DataTable GetNewLabTestForM3(DataConnection pclsCache, string UserId)
{
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("Date", typeof(DateTime)));
CacheCommand cmd = null;
CacheDataReader cdr = null;
try
{
if (!pclsCache.Connect())
{
return(null);
}
cmd = new CacheCommand();
cmd = Ps.LabTestDetails.GetNewLabTestForM3(pclsCache.CacheConnectionObject);
cmd.Parameters.Add("UserId", CacheDbType.NVarChar).Value = UserId;
cdr = cmd.ExecuteReader();
while (cdr.Read())
{
list.Rows.Add(cdr["Code"].ToString(), cdr["Name"].ToString(), cdr["Value"].ToString(), Convert.ToDateTime(cdr["Date"]));
}
return(list);
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "Ps.LabTestDetails.GetNewLabTestForM3", "数据库操作异常！ 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>
/// GetModulesByPID LS 2014-12-4 //SYF20151109
/// </summary>
/// <param name="pclsCache"></param>
/// <param name="PatientId"></param>
/// <returns></returns>
public List<ModulesByPID> GetModulesByPID(DataConnection pclsCache, string PatientId)
{
List<ModulesByPID> list = new List<ModulesByPID>();
CacheCommand cmd = null;
CacheDataReader cdr = null;
try
{
if (!pclsCache.Connect())
{
//MessageBox.Show("Cache数据库连接失败");
return null;
}
cmd = new CacheCommand();
cmd = Ps.BasicInfoDetail.GetModulesByPID(pclsCache.CacheConnectionObject);
cmd.Parameters.Add("PatientId", CacheDbType.NVarChar).Value = PatientId;
cdr = cmd.ExecuteReader();
while (cdr.Read())
{
ModulesByPID NewLine = new ModulesByPID();
NewLine.CategoryCode = cdr["CategoryCode"].ToString();
NewLine.Modules = cdr["Modules"].ToString();
list.Add(NewLine);
}
return list;
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "UsersMethod.GetModulesByPID", "数据库操作异常！ 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();
}
}
// 施宇帆 2015-04-08 获取某计划下某任务的某段时间(包括端点)的依从状态列表
public static DataTable GetComplianceDetailByPeriod(DataConnection pclsCache, string PatientId, string PlanNo, int StartDate, int EndDate, int Id)
{
DataTable list = new DataTable();
list.Columns.Add(new DataColumn("Date", typeof(string)));
list.Columns.Add(new DataColumn("Status", typeof(string)));
CacheCommand cmd = null;
CacheDataReader cdr = null;
try
{
if (!pclsCache.Connect())
{
return null;
}
cmd = new CacheCommand();
cmd = Ps.ComplianceDetail.GetComplianceDetailByPeriod(pclsCache.CacheConnectionObject);
cmd.Parameters.Add("PatientId", CacheDbType.NVarChar).Value = PatientId;
cmd.Parameters.Add("PlanNo", CacheDbType.NVarChar).Value = PlanNo;
cmd.Parameters.Add("StartDate", CacheDbType.Int).Value = StartDate;
cmd.Parameters.Add("EndDate", CacheDbType.Int).Value = EndDate;
cmd.Parameters.Add("Id", CacheDbType.Int).Value = Id;
cdr = cmd.ExecuteReader();
while (cdr.Read())
{
list.Rows.Add(cdr["Date"].ToString(), cdr["Status"].ToString());
}
return list;
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "Ps.ComplianceDetail.GetComplianceDetailByPeriod", "数据库操作异常！ 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();
}
}
//GetModulesByPID LS 2014-12-4
public static DataTable GetModulesByPID(DataConnection pclsCache, string PatientId)
{
DataTable list = new DataTable();
list.Columns.Add(new DataColumn("CategoryCode", typeof(string)));
list.Columns.Add(new DataColumn("Modules", typeof(string)));
CacheCommand cmd = null;
CacheDataReader cdr = null;
try
{
if (!pclsCache.Connect())
{
//MessageBox.Show("Cache数据库连接失败");
return(null);
}
cmd = new CacheCommand();
cmd = Ps.BasicInfoDetail.GetModulesByPID(pclsCache.CacheConnectionObject);
cmd.Parameters.Add("PatientId", CacheDbType.NVarChar).Value = PatientId;
cdr = cmd.ExecuteReader();
while (cdr.Read())
{
list.Rows.Add(cdr["CategoryCode"].ToString(), cdr["Modules"].ToString());
}
return(list);
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "PsBasicInfoDetail.GetModulesByPID", "数据库操作异常！ 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>
/// 获取某个分类的类别 CSQ 20151010
/// </summary>
/// <param name="pclsCache"></param>
/// <param name="Category"></param>
/// <returns></returns>
public List <TypeAndName> CmMstTypeGetTypeList(DataConnection pclsCache, string Category)
{
List <TypeAndName> list = new List <TypeAndName>();
CacheCommand cmd = null;
CacheDataReader cdr = null;
try
{
if (!pclsCache.Connect())
{
//MessageBox.Show("Cache数据库连接失败");
return(null);
}
cmd = new CacheCommand();
cmd = Cm.MstType.GetTypeList(pclsCache.CacheConnectionObject);
cmd.Parameters.Add("Category", CacheDbType.NVarChar).Value = Category;
cdr = cmd.ExecuteReader();
while (cdr.Read())
{
list.Add(new TypeAndName {
Type = cdr["Type"].ToString(), Name = cdr["Name"].ToString()
});
}
return(list);
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "DictMethod.GetTypeList", "数据库操作异常！ 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>
/// GetInsurance CSQ 20151010
/// </summary>
/// <param name="pclsCache"></param>
/// <returns></returns>
public List <Insurance> GetInsurance(DataConnection pclsCache)
{
List <Insurance> list = new List <Insurance>();
CacheCommand cmd = null;
CacheDataReader cdr = null;
try
{
if (!pclsCache.Connect())
{
return(null);
}
cmd = new CacheCommand();
cmd = Cm.MstInsurance.GetInsuranceType(pclsCache.CacheConnectionObject);
cdr = cmd.ExecuteReader();
while (cdr.Read())
{
list.Add(new Insurance
{
Code = cdr["Code"].ToString(),
Name = cdr["Name"].ToString(),
InputCode = cdr["InputCode"].ToString(),
Redundance = cdr["Redundance"].ToString()
});
}
return(list);
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "DictMethod.GetInsurance", "数据库操作异常！ 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>
/// 获取消息联系人列表 GL 2015-10-10
/// </summary>
/// <param name="DoctorId"></param>
/// <param name="CategoryCode"></param>
/// <returns></returns>
public List <Message> GetSMSList(DataConnection pclsCache, string DoctorId, string CategoryCode)
{
List <Message> items = new List <Message>();
CacheCommand cmd = null;
CacheDataReader cdr = null;
try
{
if (!pclsCache.Connect())
{
return(null);
}
cmd = Mb.MessageRecord.GetSMSList(pclsCache.CacheConnectionObject);
cmd.Parameters.Add("DoctorId", CacheDbType.NVarChar).Value = DoctorId;
cmd.Parameters.Add("CategoryCode", CacheDbType.NVarChar).Value = CategoryCode;
cdr = cmd.ExecuteReader();
while (cdr.Read())
{
//PatientId, PatientName, Count, Content, SendDateTime
Message item = new Message();
item.SendBy = cdr["PatientId"].ToString();
item.SendByName = cdr["PatientName"].ToString();
item.Count = cdr["Count"].ToString();
item.Content = cdr["Content"].ToString();
item.SendDateTime = cdr["SendDateTime"].ToString();
items.Add(item);
}
return(items);
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "MessageMethod.GetSMSDialogue", "数据库操作异常！ 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();
}
}
// GetTypeList 返回所有类型代码及名称 CSQ 20151010
public List<TypeAndName> CmMstHypertensionDrugGetTypeList(DataConnection pclsCache)
{
List<TypeAndName> list = new List<TypeAndName>();
CacheCommand cmd = null;
CacheDataReader cdr = null;
try
{
if (!pclsCache.Connect())
{
return null;
}
cmd = new CacheCommand();
cmd = Cm.MstHypertensionDrug.GetTypeList(pclsCache.CacheConnectionObject);
cdr = cmd.ExecuteReader();
while (cdr.Read())
{
list.Add(new TypeAndName
{
Type = cdr["Type"].ToString(),
Name = cdr["TypeName"].ToString()
});
}
return list;
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "CmMstHypertensionDrug.GetTypeList", "数据库操作异常！ 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 void AddApplication()
{
try
{
using (Cmd = new CacheCommand("INSERT HICL.Application VALUES('RW','TS','" + Helper.GetHash("supplier") + "', null,null,'002' )", GetConnection()))
{
Cmd.ExecuteNonQuery();
}
}
finally
{
CacheConnect.Close();
}
}
public static void LogInfo()
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("Running Cmd is : {0}\n", RunningList.Count);
for (int i = 0; i < RunningList.Count; ++i)
{
CacheCommand cmd = RunningList[i];
sb.AppendFormat("Each is :{0} State :{1} ID:{2}\n", cmd, cmd.RunningState, cmd.UID);
}
sb.Append("=-----Over----=");
LogMgr.Log(sb.ToString());
}
public void AddOrganization()
{
try
{
using (Cmd = new CacheCommand("INSERT HICL.Organization VALUES('001','Dr. Prouse','CLIENT')", GetConnection()))
{
Cmd.ExecuteNonQuery();
}
}
finally
{
CacheConnect.Close();
}
}
//WF 20150408
public static DataTable GetPsTaskByType(DataConnection pclsCache, string PlanNo, string Type)
{
DataTable list = new DataTable();
list.Columns.Add(new DataColumn("Id", typeof(string)));
list.Columns.Add(new DataColumn("Code", typeof(string)));
list.Columns.Add(new DataColumn("CodeName", typeof(string)));
list.Columns.Add(new DataColumn("Instruction", typeof(string)));
CacheCommand cmd = null;
CacheDataReader cdr = null;
try
{
if (!pclsCache.Connect())
{
return null;
}
cmd = new CacheCommand();
cmd = Ps.Task.GetPsTaskByType(pclsCache.CacheConnectionObject);
cmd.Parameters.Add("PlanNo", CacheDbType.NVarChar).Value = PlanNo;
cmd.Parameters.Add("Type", CacheDbType.NVarChar).Value = Type;
cdr = cmd.ExecuteReader();
while (cdr.Read())
{
list.Rows.Add(cdr["Id"].ToString(), cdr["Code"].ToString(), cdr["CodeName"].ToString(), cdr["Instruction"].ToString());
}
return list;
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "Ps.Task.GetPsTaskByType", "数据库操作异常！ 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();
}
}
//GetInsurance WF 2015-11-27
public static DataTable GetInsurance(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("InputCode", typeof(string)));
list.Columns.Add(new DataColumn("Redundance", typeof(string)));
list.Columns.Add(new DataColumn("InvalidFlag", typeof(Int32)));
CacheCommand cmd = null;
CacheDataReader cdr = null;
try
{
if (!pclsCache.Connect())
{
return(null);
}
cmd = new CacheCommand();
cmd = Cm.MstInsurance.GetInsurance(pclsCache.CacheConnectionObject);
cdr = cmd.ExecuteReader();
while (cdr.Read())
{
list.Rows.Add(cdr["Code"].ToString(), cdr["Name"].ToString(), cdr["InputCode"].ToString(), cdr["Redundance"].ToString(), cdr["InvalidFlag"]);
}
return(list);
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "CmMstInsurance.GetInsuranceType", "数据库操作异常！ 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();
}
}
// GetTypeList 返回所有类型代码及名称 CSQ 20151010
public List <TypeAndName> CmMstHypertensionDrugGetTypeList(DataConnection pclsCache)
{
List <TypeAndName> list = new List <TypeAndName>();
CacheCommand cmd = null;
CacheDataReader cdr = null;
try
{
if (!pclsCache.Connect())
{
return(null);
}
cmd = new CacheCommand();
cmd = Cm.MstHypertensionDrug.GetTypeList(pclsCache.CacheConnectionObject);
cdr = cmd.ExecuteReader();
while (cdr.Read())
{
list.Add(new TypeAndName
{
Type = cdr["Type"].ToString(),
Name = cdr["TypeName"].ToString()
});
}
return(list);
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "CmMstHypertensionDrug.GetTypeList", "数据库操作异常！ 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();
}
}
//WF 20150408
public static DataTable GetTextAddress(DataConnection pclsCache, string Module)
{
DataTable list = new DataTable();
list.Columns.Add(new DataColumn("FileName", typeof(string)));
list.Columns.Add(new DataColumn("Path", typeof(string)));
list.Columns.Add(new DataColumn("Introduction", typeof(string)));
CacheCommand cmd = null;
CacheDataReader cdr = null;
try
{
if (!pclsCache.Connect())
{
return(null);
}
cmd = new CacheCommand();
cmd = Cm.MstHealthEducation.GetTextAddress(pclsCache.CacheConnectionObject);
cmd.Parameters.Add("Module", CacheDbType.NVarChar).Value = Module;
cdr = cmd.ExecuteReader();
while (cdr.Read())
{
list.Rows.Add(cdr["FileName"].ToString(), cdr["Path"].ToString(), cdr["Introduction"].ToString());
}
return(list);
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "Cm.MstHealthEducation.GetTextAddress", "数据库操作异常！ 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>
/// 获取某个分类的类别 CSQ 20151010
/// </summary>
/// <param name="pclsCache"></param>
/// <param name="Category"></param>
/// <returns></returns>
public List<TypeAndName> CmMstTypeGetTypeList(DataConnection pclsCache, string Category)
{
List<TypeAndName> list = new List<TypeAndName>();
CacheCommand cmd = null;
CacheDataReader cdr = null;
try
{
if (!pclsCache.Connect())
{
//MessageBox.Show("Cache数据库连接失败");
return null;
}
cmd = new CacheCommand();
cmd = Cm.MstType.GetTypeList(pclsCache.CacheConnectionObject);
cmd.Parameters.Add("Category", CacheDbType.NVarChar).Value = Category;
cdr = cmd.ExecuteReader();
while (cdr.Read())
{
list.Add(new TypeAndName { Type = cdr["Type"].ToString(), Name = cdr["Name"].ToString() });
}
return list;
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "DictMethod.GetTypeList", "数据库操作异常！ 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 List <QAModel> GetQAModel(string OEORI_RowId)
{
List <QAModel> results = new List <QAModel>();
using (var con = new CacheConnection(conString))
{
con.Open();
using (var cmd = new CacheCommand(QueryString.GetQuesAns(OEORI_RowId), con))
{
using (var reader = cmd.ExecuteReader())
{
string type = string.Empty;
while (reader.Read())
{
QAModel qam = new QAModel();
string[] spilts = reader["QUES_Code"].ToString().Split('_');
if (Regex.IsMatch(reader["QUES_Desc"].ToString(), @"<[^>]*>"))
{
type = spilts.Length > 2 ? spilts[2] : "";
qam.QUES_Code = reader["QUES_Code"].ToString();
qam.QUES_Desc = reader["QUES_Desc"].ToString();
qam.QA_Answer = reader["QA_Answer"].ToString();
qam.QUES_ControlType = reader["QUES_ControlType"].ToString();
qam.QUES_Type = type;
results.Add(qam);
}
else
{
if (!string.IsNullOrEmpty(reader["QA_Answer"].ToString()))
{
qam.QUES_Code = reader["QUES_Code"].ToString();
qam.QUES_Desc = reader["QUES_Desc"].ToString();
qam.QA_Answer = reader["QA_Answer"].ToString();
qam.QUES_ControlType = reader["QUES_ControlType"].ToString();
qam.QUES_Type = type;
results.Add(qam);
}
}
}
}
}
}
return(results);
}
/// <summary>
/// 获取消息对话 GL 2015-10-10
/// </summary>
/// <param name="Reciever"></param>
/// <param name="SendBy"></param>
/// <returns></returns>
public List <Message> GetSMSDialogue(DataConnection pclsCache, string Reciever, string SendBy)
{
List <Message> items = new List <Message>();
CacheCommand cmd = null;
CacheDataReader cdr = null;
try
{
if (!pclsCache.Connect())
{
return(null);
}
cmd = Mb.MessageRecord.GetSMSDialogue(pclsCache.CacheConnectionObject);
cmd.Parameters.Add("Reciever", CacheDbType.NVarChar).Value = Reciever;
cmd.Parameters.Add("SendBy", CacheDbType.NVarChar).Value = SendBy;
cdr = cmd.ExecuteReader();
while (cdr.Read())
{
Message item = new Message();
item.Time = cdr["Time"].ToString();
item.Content = cdr["Content"].ToString();
item.IDFlag = cdr["IDFlag"].ToString();
item.SendDateTime = cdr["SendDateTime"].ToString().Replace("-", "/");
items.Add(item);
}
return(items);
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "MessageMethod.GetSMSDialogue", "数据库操作异常！ 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 string BindDataCommand(string cmdString, string conString)
{
string result = string.Empty;
using(var con = new CacheConnection(conString))
{
con.Open();
using(var cmd = new CacheCommand(cmdString, con))
{
result = cmd.ExecuteScalar().ToString();
}
}
return result;
}
public void OnEntryRemoved(string key)
{
var command = new CacheCommand
{
Type = CacheCommandType.Remove,
Entries = new[] {
new CacheEntry {
Key = key
}
}
};
// When an entry is removed let all subscribers know
_context.Connection.Broadcast(command);
}
public static string ExecuteScalarBindDataCommand(string cmdString, string connectionString)
{
string result = string.Empty;
using (var con = new CacheConnection(connectionString))
{
using (var cmd = new CacheCommand(cmdString, con))
{
con.Open();
result = Convert.ToString(cmd.ExecuteScalar());
}
}
return(result);
}
private List <string> GetExistingTables(CacheConnection connection)
{
var tables = new List <string>();
using (var command = new CacheCommand(ExistingTablesQuery, connection))
using (var tablesReader = command.ExecuteReader())
{
while (tablesReader.Read())
{
tables.Add(tablesReader[0].ToString());
}
}
return(tables);
}
//通过PID得到模块 LY 2015-10-10
public List <TypeAndName> PsBasicInfoDetailGetModulesByPID(DataConnection pclsCache, string PatientId)
{
List <TypeAndName> list = new List <TypeAndName>();
CacheCommand cmd = null;
CacheDataReader cdr = null;
try
{
if (!pclsCache.Connect())
{
return(null);
}
cmd = new CacheCommand();
cmd = Ps.BasicInfoDetail.GetModulesByPID(pclsCache.CacheConnectionObject);
cmd.Parameters.Add("PatientId", CacheDbType.NVarChar).Value = PatientId;
cdr = cmd.ExecuteReader();
while (cdr.Read())
{
TypeAndName NewLine = new TypeAndName();
NewLine.Type = cdr["CategoryCode"].ToString();
NewLine.Name = cdr["Modules"].ToString();
list.Add(NewLine);
}
return(list);
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "ModuleInfoMethod.PsBasicInfoDetailGetModulesByPID", "数据库操作异常！ 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();
}
}
protected void CloseAtIndex(GameUI gameui, int index, bool force = false, AbstractParams p = null)
{
if (!removeList.Contains(gameui))
{
//check children
GameUI[] childrenUI = gameui.GetComponentsInChildren <GameUI>();
for (int i = 0; i < childrenUI.Length; ++i)
{
if (childrenUI[i] != gameui)
{
for (int j = 0; j < uicontainer.Count; ++j)
{
if (uicontainer[j] == childrenUI[i])
{
CloseAtIndex(uicontainer[j], j, force);
}
}
}
}
ScriptCommand cmd = ScriptCommand.Create((int)FrameWorkCmdDefine.UICallExit);
if (p != null)
{
cmd.CallParams = p;
}
cmd.target = ScriptTarget.Sharp;
cmd.CallParams.InsertObject(0, gameui);
cmd.Excute();
if (p != null)
{
p.Release();
}
CacheCommand.CanCelAllBy(gameui);
if (force)
{
gameui.DestorySelf();
}
else
{
DestroyUI(gameui);
}
removeList.Add(gameui);
}
}
public static List <Appointment> GetApptConsult(string epi, CacheADOConnection con)
{
var apps = new List <Appointment>();
var query = QueryString.GetApptConsult(epi);
try
{
using (var cmd = new CacheCommand(query.Item1, con))
{
foreach (var pair in query.Item2)
{
cmd.AddInputParameters(new { key = pair.Value });
}
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
var appDatetime = string.IsNullOrEmpty(reader["AS_Date"].ToString()) ? new Tuple <string, string>("", "") : new Tuple <string, string>(reader["AS_Date"].ToString(), reader["AS_SessStartTime"].ToString());
var appDate = string.IsNullOrEmpty(appDatetime.Item1) ? "" : DateTime.Parse(appDatetime.Item1).ToString("dd/MM/yyyy");
var appTime = string.IsNullOrEmpty(appDatetime.Item2) ? "" : DateTime.Parse(appDatetime.Item2).ToString("HH:mm");
var app = new Appointment()
{
AS_Date = appDate,
AS_SessStartTime = appTime,
APPT_Status = reader["APPT_Status"].ToString(),
PAADM_VisitStatus = reader["PAADM_VisitStatus"].ToString(),
CTLOC_Code = reader["CTLOC_Code"].ToString(),
CTLOC_Desc = reader["CTLOC_Desc"].ToString(),
CTPCP_Desc = reader["CTPCP_Desc"].ToString(),
SER_Desc = reader["SER_Desc"].ToString()
};
apps.Add(app);
}
}
}
apps = apps.OrderBy(a => string.IsNullOrEmpty(a.AS_Date) ? (DateTime?)null : DateTime.ParseExact(a.AS_Date, "dd/MM/yyyy", null))
.ThenBy(a => string.IsNullOrEmpty(a.AS_SessStartTime) ? (DateTime?)null : DateTime.ParseExact(a.AS_SessStartTime, "HH:mm", null)).ToList();
}
catch (Exception)
{
return(apps);
}
return(apps);
}
//WF 20150408
public static DataTable GetVedioAddress(DataConnection pclsCache, string Module)
{
DataTable list = new DataTable();
list.Columns.Add(new DataColumn("FileName", typeof(string)));
list.Columns.Add(new DataColumn("Path", typeof(string)));
list.Columns.Add(new DataColumn("Introduction", typeof(string)));
CacheCommand cmd = null;
CacheDataReader cdr = null;
try
{
if (!pclsCache.Connect())
{
return null;
}
cmd = new CacheCommand();
cmd = Cm.MstHealthEducation.GetVedioAddress(pclsCache.CacheConnectionObject);
cmd.Parameters.Add("Module", CacheDbType.NVarChar).Value = Module;
cdr = cmd.ExecuteReader();
while (cdr.Read())
{
list.Rows.Add(cdr["FileName"].ToString(), cdr["Path"].ToString(), cdr["Introduction"].ToString());
}
return list;
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "Cm.MstHealthEducation.GetVedioAddress", "数据库操作异常！ 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();
}
}
// GetAllRoleMatch LS 2015-03-26
public static DataTable GetAllRoleMatch(DataConnection pclsCache, string UserID)
{
DataTable list = new DataTable();
list.Columns.Add(new DataColumn("RoleClass", typeof(string)));
CacheCommand cmd = null;
CacheDataReader cdr = null;
try
{
if (!pclsCache.Connect())
{
return(null);
}
cmd = new CacheCommand();
cmd = Ps.RoleMatch.GetAllRoleMatch(pclsCache.CacheConnectionObject);
cmd.Parameters.Add("UserID", CacheDbType.NVarChar).Value = UserID;
cdr = cmd.ExecuteReader();
while (cdr.Read())
{
list.Rows.Add(cdr["RoleClass"].ToString());
}
return(list);
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "PsRoleMatch.GetAllRoleMatch", "数据库操作异常！ 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 override void Resume()
{
CacheCommand nextCmd = this.Next;
while (nextCmd != null)
{
nextCmd.Resume();
nextCmd = nextCmd.Next;
}
base.Resume();
if (this.isDone)
{
this.TryBatch();
}
}
// GetAllRoleMatch LS 2015-03-26
public static DataTable GetAllRoleMatch(DataConnection pclsCache, string UserID)
{
DataTable list = new DataTable();
list.Columns.Add(new DataColumn("RoleClass", typeof(string)));
CacheCommand cmd = null;
CacheDataReader cdr = null;
try
{
if (!pclsCache.Connect())
{
return null;
}
cmd = new CacheCommand();
cmd = Ps.RoleMatch.GetAllRoleMatch(pclsCache.CacheConnectionObject);
cmd.Parameters.Add("UserID", CacheDbType.NVarChar).Value = UserID;
cdr = cmd.ExecuteReader();
while (cdr.Read())
{
list.Rows.Add(cdr["RoleClass"].ToString());
}
return list;
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "PsRoleMatch.GetAllRoleMatch", "数据库操作异常！ 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 void AddLog(String AppId, String recordType, String eventData)
{
try
{
string strQuery = "INSERT HICL.AuditLog(AppId,actDate,eventData,recordType ) VALUES('" + AppId + "','" + DateTime.Now.ToString("yyyyMMdd HH:mm:ss") + "','" + eventData + "','" + recordType + "')";
Cmd = new CacheCommand(strQuery, GetConnection());
//Cmd.Parameters.Add("@AppId", AppId);
//Cmd.Parameters.Add("@actDate", );
//Cmd.Parameters.Add("@eventData", eventData);
//Cmd.Parameters.Add("@recordType", recordType);
Cmd.ExecuteNonQuery();
}
finally
{
CacheConnect.Close();
}
}
protected void _Remove(CacheCommand cmd)
{
CacheCommand previous = null;
CacheCommand next = this;
while (next.Next != null)
{
if (next == cmd)
{
previous.Next = next.Next;
next.Release(true);
break;
}
previous = next;
next = next.Next;
}
}
public DataTable GetOrganization()
{
DataTable dt = new DataTable();
try
{
using (Cmd = new CacheCommand("select * from HICL.Organization", GetConnection()))
{
dt.Load(Cmd.ExecuteReader());
}
}
finally
{
CacheConnect.Close();
}
return(dt);
}
private static void AccountCookieSet(AccountInfo account)
{
HttpCookie cookie = AccountCookieGet();
cookie.Value = GetCryptographyString(string.Format("{0}|{1}|{2}|{3}", Context.Request.UserHostName, account.UserName, account.Id, DateTime.Now.Ticks));
CacheCommand<AccountInfo> cache = new CacheCommand<AccountInfo>(cookie.Value);
cache.Set(account, cookie.Expires);
if (Context.Request.Cookies.Get(cookie.Name) == null)
{
Context.Response.Cookies.Add(cookie);
}
else
{
Context.Response.Cookies.Set(cookie);
}
}
public static Tuple <User, string> GetUser(string username, string password)
{
var model = new User();
string message = string.Empty;
var query = TrakCareQuery.GetUser(username);
using (CacheConnection con = new CacheConnection(Constants.Cache))
{
con.Open();
using (CacheCommand cmd = new CacheCommand(query.Item1, con))
{
foreach (KeyValuePair <string, string> pair in query.Item2)
{
var key = pair.Key;
cmd.AddInputParameters(new { key = pair.Value });
}
using (var reader = cmd.ExecuteReader())
{
if (reader.Read())
{
User user = new User()
{
SSUSR_Initials = reader["SSUSR_Initials"].ToString(),
SSUSR_Name = reader["SSUSR_Name"].ToString(),
SSUSR_Password = reader["SSUSR_Password"].ToString()
};
if (Helper.CheckPassword(user, password))
{
model = user;
message = "Login Success.";
}
else
{
message = "Login fail.";
}
}
}
}
}
return(new Tuple <User, string>(model, message));
}
private void CreateIndexesIfNotExist(CacheConnection connection)
{
using (CacheCommand checkUserIndex = new CacheCommand(CheckUserNameIndexQuery, connection),
checkRoleIndex = new CacheCommand(CheckRoleNameIndexQuery, connection))
{
if ((int)checkUserIndex.ExecuteScalar() == 0)
{
using (var createUserIndex = new CacheCommand(UserNameIndexQuery, connection))
createUserIndex.ExecuteNonQuery();
}
if ((int)checkRoleIndex.ExecuteScalar() == 0)
{
using (var createRoleIndex = new CacheCommand(RoleNameIndexQuery, connection))
createRoleIndex.ExecuteNonQuery();
}
}
}
public Task DeleteAsync(string key)
{
var command = new CacheCommand
{
Type = CacheCommandType.Remove,
Entries = new[] {
new CacheEntry {
Key = key
}
}
};
// Execute local delete
object value;
_cache.TryRemove(key, out value);
return(SendCommand(command));
}
//CSQ 2015-3-11
public static DataTable GetLabTestList(DataConnection pclsCache, string piUserId, string piVisitId)
{
DataTable list = new DataTable();
list.Columns.Add(new DataColumn("VisitId", typeof(string)));
list.Columns.Add(new DataColumn("SortNo", typeof(string)));
list.Columns.Add(new DataColumn("LabItemType", typeof(string)));
list.Columns.Add(new DataColumn("LabItemTypeName", typeof(string)));
list.Columns.Add(new DataColumn("LabItemCode", typeof(string)));
list.Columns.Add(new DataColumn("LabItemName", typeof(string)));
list.Columns.Add(new DataColumn("LabTestDate", typeof(string)));
list.Columns.Add(new DataColumn("StatusCode", typeof(string)));
list.Columns.Add(new DataColumn("Status", typeof(string)));
list.Columns.Add(new DataColumn("ReportDate", typeof(string)));
list.Columns.Add(new DataColumn("DeptCode", typeof(string)));
list.Columns.Add(new DataColumn("DeptName", typeof(string)));
//list.Columns.Add(new DataColumn("LabTestDateShow", typeof(string)));
//list.Columns.Add(new DataColumn("ReportDateShow", typeof(string)));
list.Columns.Add(new DataColumn("Creator", typeof(string)));
list.Columns.Add(new DataColumn("LabTestDateCom", typeof(string))); //20150709 LS
CacheCommand cmd = null;
CacheDataReader cdr = null;
try
{
if (!pclsCache.Connect())
{
return null;
}
cmd = new CacheCommand();
cmd = Ps.LabTest.GetLabTestList(pclsCache.CacheConnectionObject);
cmd.Parameters.Add("piUserId", CacheDbType.NVarChar).Value = piUserId;
cmd.Parameters.Add("piVisitId", CacheDbType.NVarChar).Value = piVisitId;
cdr = cmd.ExecuteReader();
while (cdr.Read())
{
//string LabTestDateShow = "", ReportDateShow = "";
//string str = cdr["LabTestDate"].ToString();
//if (str != "0")
//{
// LabTestDateShow = str.Substring(0, 4) + "-" + str.Substring(4, 2) + "-" + str.Substring(6, 2);
//}
//string str1 = cdr["ReportDate"].ToString();
//if (str1 != "0")
//{
// ReportDateShow = str1.Substring(0, 4) + "-" + str1.Substring(4, 2) + "-" + str1.Substring(6, 2);
//}
string ReportDateShow = "";
if (cdr["ReportDate"].ToString() == "9999/1/1 0:00:00")
{
ReportDateShow = "";
}
else
{
ReportDateShow = cdr["ReportDate"].ToString();
}
list.Rows.Add(cdr["VisitId"].ToString(), cdr["SortNo"].ToString(), cdr["LabItemType"].ToString(), cdr["LabItemTypeName"].ToString(), cdr["LabItemCode"].ToString(), cdr["LabItemName"].ToString(), cdr["LabTestDate"].ToString(), cdr["StatusCode"].ToString(), cdr["Status"].ToString(), ReportDateShow, cdr["DeptCode"].ToString(), cdr["DeptName"].ToString(), cdr["Creator"].ToString(), Convert.ToDateTime(cdr["LabTestDate"]).ToString("yyyy-MM-dd HH:mm:ss"));
}
return list;
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "Ps.LabTest.GetLabTestList", "数据库操作异常！ 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();
}
}
//GetTasksComByPeriod 其他任务的依从情况（不包括生理测量） LS 2010505 文本集中在ballon web暂用
public static List<CompliacneDetailByD> GetTasksComByPeriodWeb(DataConnection pclsCache, string PatientId, string PlanNo, int StartDate, int EndDate)
{
List<CompliacneDetailByD> resultList = new List<CompliacneDetailByD>();
DataTable list = new DataTable();
list.Columns.Add(new DataColumn("Date", typeof(string)));
list.Columns.Add(new DataColumn("ComplianceValue", typeof(double)));
list.Columns.Add(new DataColumn("TaskType", typeof(string)));
list.Columns.Add(new DataColumn("TaskId", typeof(string)));
list.Columns.Add(new DataColumn("TaskName", typeof(string)));
list.Columns.Add(new DataColumn("Status", typeof(int)));
CacheCommand cmd = null;
CacheDataReader cdr = null;
try
{
if (!pclsCache.Connect())
{
return null;
}
cmd = new CacheCommand();
cmd = Ps.Compliance.GetTasksComByPeriod(pclsCache.CacheConnectionObject);
cmd.Parameters.Add("PatientId", CacheDbType.NVarChar).Value = PatientId;
cmd.Parameters.Add("PlanNo", CacheDbType.NVarChar).Value = PlanNo;
cmd.Parameters.Add("StartDate", CacheDbType.Int).Value = StartDate;
cmd.Parameters.Add("EndDate", CacheDbType.Int).Value = EndDate;
cdr = cmd.ExecuteReader();
while (cdr.Read())
{
if (cdr["TaskType"].ToString() != "体征测量")
{
list.Rows.Add(cdr["Date"].ToString(), Convert.ToDouble(cdr["ComplianceValue"]), cdr["TaskType"].ToString(), cdr["TaskId"].ToString(), cdr["TaskName"].ToString(), Convert.ToInt32(cdr["Status"]));
}
}
//确保排序
DataView dv = list.DefaultView;
dv.Sort = "Date Asc, TaskType Asc, Status Asc";
DataTable list_sort = dv.ToTable();
list_sort.Rows.Add("end", 0, "", "", "", 0); //用于最后一天输出
if (list_sort.Rows.Count > 1)
{
string temp_date = list_sort.Rows[0]["Date"].ToString();
string temp_type = list_sort.Rows[0]["TaskType"].ToString();
string temp_str = "";
temp_str += "该天依从率：" + list_sort.Rows[0]["ComplianceValue"].ToString() + "<br>";
if (list_sort.Rows[0]["TaskType"].ToString() == "生活方式")
{ }
temp_str += "<b><span style='font-size:14px;'>" + list_sort.Rows[0]["TaskType"].ToString() + "：</span></b>";
CompliacneDetailByD CompliacneDetailByD = new CompliacneDetailByD();
CompliacneDetailByD.Date = list_sort.Rows[0]["Date"].ToString();
// CompliacneDetailByD.ComplianceValue = list_sort.Rows[0]["ComplianceValue"].ToString();
if (Convert.ToDouble(list_sort.Rows[0]["ComplianceValue"]) == 0) //某天依从率
{
CompliacneDetailByD.drugBullet = "";
CompliacneDetailByD.drugColor = "#DADADA";
}
else if (Convert.ToDouble(list_sort.Rows[0]["ComplianceValue"]) == 1)
{
CompliacneDetailByD.drugBullet = "";
CompliacneDetailByD.drugColor = "#777777";
}
else
{
CompliacneDetailByD.drugBullet = "amcharts-images/drug.png";
CompliacneDetailByD.drugColor = "";
}
if (Convert.ToInt32(list_sort.Rows[0]["Status"]) == 1) //某天某项任务的完成情况
{
temp_str += list_sort.Rows[0]["TaskName"].ToString() + "complete ";
}
else
{
//temp_str += list_sort.Rows[0]["TaskName"].ToString() + "noncomplete ";
temp_str += "<b><span style='font-size:14px;color:red;'>" + list_sort.Rows[0]["TaskName"].ToString() + "noncomplete " + "</span></b>";
}
//只有一条数据
if (list_sort.Rows.Count == 2)
{
CompliacneDetailByD.Events = temp_str;
resultList.Add(CompliacneDetailByD);
}
//＞一条数据
if (list_sort.Rows.Count > 2)
{
for (int i = 1; i <= list_sort.Rows.Count - 1; i++)
{
if (temp_date == list_sort.Rows[i]["Date"].ToString()) //同一天
{
if (temp_type == list_sort.Rows[i]["TaskType"].ToString()) //同天同任务类型
{
if (Convert.ToInt32(list_sort.Rows[i]["Status"]) == 1) //某天某项任务的完成情况
{
temp_str += list_sort.Rows[i]["TaskName"].ToString() + "complete ";
}
else
{
//temp_str += list_sort.Rows[i]["TaskName"].ToString() + "noncomplete ";
temp_str += "<b><span style='font-size:14px;color:red;'>" + list_sort.Rows[i]["TaskName"].ToString() + "noncomplete " + "</span></b>";
}
}
else //同天不同任务类型
{
temp_str += "<br>";
temp_str += "<b><span style='font-size:14px;'>" + list_sort.Rows[i]["TaskType"].ToString() + "：</span></b>";
if (Convert.ToInt32(list_sort.Rows[i]["Status"]) == 1) //某天某项任务的完成情况
{
temp_str += list_sort.Rows[i]["TaskName"].ToString() + "complete ";
}
else
{
//temp_str += list_sort.Rows[i]["TaskName"].ToString() + "noncomplete ";
temp_str += "<b><span style='font-size:14px;color:red;'>" + list_sort.Rows[i]["TaskName"].ToString() + "noncomplete </span></b>";
}
temp_type = list_sort.Rows[i]["TaskType"].ToString();
}
}
else //不同天
{
//上一天输出
CompliacneDetailByD.Events = temp_str;
resultList.Add(CompliacneDetailByD);
if (list_sort.Rows[i]["Date"].ToString() != "end")
{
//获取新一天
CompliacneDetailByD = new CompliacneDetailByD();
CompliacneDetailByD.Date = list_sort.Rows[i]["Date"].ToString();
//CompliacneDetailByD.ComplianceValue = list_sort.Rows[i]["ComplianceValue"].ToString();
if (Convert.ToDouble(list_sort.Rows[i]["ComplianceValue"]) == 0) //某天依从率
{
CompliacneDetailByD.drugBullet = "";
CompliacneDetailByD.drugColor = "#DADADA";
}
else if (Convert.ToDouble(list_sort.Rows[i]["ComplianceValue"]) == 1)
{
CompliacneDetailByD.drugBullet = "";
CompliacneDetailByD.drugColor = "#777777";
}
else
{
CompliacneDetailByD.drugBullet = "amcharts-images/drug.png";
CompliacneDetailByD.drugColor = "";
}
temp_str = "";
temp_str += "该天依从率：" + list_sort.Rows[i]["ComplianceValue"].ToString() + "<br>";
temp_str += "<b><span style='font-size:14px;'>" + list_sort.Rows[i]["TaskType"].ToString() + "：</span></b>";
if (Convert.ToInt32(list_sort.Rows[i]["Status"]) == 1) //某天某项任务的完成情况
{
temp_str += list_sort.Rows[i]["TaskName"].ToString() + "complete ";
}
else
{
//temp_str += list_sort.Rows[i]["TaskName"].ToString() + "noncomplete ";
temp_str += "<b><span style='font-size:14px;color:red;'>" + list_sort.Rows[i]["TaskName"].ToString() + "noncomplete </span></b>";
}
temp_date = list_sort.Rows[i]["Date"].ToString();
temp_type = list_sort.Rows[i]["TaskType"].ToString();
}
}
}
}
}
return resultList;
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "Ps.Compliance.GetTasksComByPeriod", "数据库操作异常！ 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();
}
}
