public ClsApplication GetApplication(ClsGetApplication app)
{
DataTable dt = new DataTable();
ClsApplication ap = null;
try
{
using (Cmd = new CacheCommand("select * from HICL.Application where appId='" + app.appId + "'", GetConnection()))
{
//Cmd.Parameters.Add("@appId", app.appId);
dt.Load(Cmd.ExecuteReader());
var query = from p in dt.AsEnumerable()
select new ClsApplication
{
appId = p.Field <string>("appId"),
orgId = p.Field <string>("orgId"),
clientSecret = p.Field <string>("clientSecret"),
accessLevel = p.Field <string>("accessLevel"),
ipAddress = p.Field <string>("ipAddress"),
lastAccessed = p.Field <string>("lastAccessed")
};
ap = query.FirstOrDefault();
}
}
finally
{
CacheConnect.Close();
}
return(ap);
}
public static DataTable GetAllPatientPharCollect(string listHn)
{
var dt = new DataTable();
var query = QueryString.GetPharCollect(listHn);
using (var con = ConnectCache.DBUtils.GetDBConnection())
{
try
{
con.Open();
using (var cmd = new CacheCommand(query.Item1, con))
{
using (var reader = cmd.ExecuteReader())
{
dt.Load(reader);
}
}
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
finally
{
con.Close();
con.Dispose();
}
}
return(dt);
}
public static Patient GetPatient(string epiRowId)
{
Patient pt = new Patient();
using (var con = new CacheConnection(conString))
{
con.Open();
using (var cmd = new CacheCommand(QueryString.GetPatient(epiRowId), con))
{
using (var reader = cmd.ExecuteReader())
{
if (reader.Read())
{
string hn = reader["PAPMI_No"].ToString();
pt.HN = hn;
pt.Name = string.IsNullOrEmpty(reader["TTL_Desc"].ToString()) ? reader["PAPMI_Name"].ToString() + " " + reader["PAPMI_Name2"].ToString() : reader["TTL_Desc"].ToString() + reader["PAPMI_Name"].ToString() + " " + reader["PAPMI_Name2"].ToString();
pt.Gender = reader["CTSEX_Desc"].ToString();
DateTime dt = Convert.ToDateTime(reader["PAPMI_DOB"].ToString());
pt.DOB = dt.ToString("dd/MM/") + dt.Year.ToString();
pt.EpisodeNo = reader["PAADM_ADMNo"].ToString();
pt.Age = reader["PAPER_AgeYr"].ToString();
pt.Allergys = _ICPOERepository.GetAllergys(hn);
}
}
}
}
return(pt);
}
public static List <QuestionAnswer> GetQuestionAnswer(string OEORI_RowId)
{
List <QuestionAnswer> listQuestionAnswer = new List <QuestionAnswer>();
using (var con = new CacheConnection(conString))
{
con.Open();
using (var cmd = new CacheCommand(QueryString.GetQuesAns(OEORI_RowId), con))
{
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
QuestionAnswer qa = new QuestionAnswer();
string item = reader["QUES_Code"].ToString();
string[] items = item.Split('_');
qa.OrdItemType = items.Length > 1 ? items[1].ToString() : "";
qa.QUES = items.Length > 2 ? items[2].ToString() : "";
qa.QUES_Desc = reader["QUES_Desc"].ToString();
qa.QA_Answer = reader["QA_Answer"].ToString();
listQuestionAnswer.Add(qa);
}
}
}
}
return(listQuestionAnswer);
}
public List <string> searchbyname(string name)
{
CacheCommand cc;
idlist.Clear();
List <string> anamelist = new List <string>();
try
{
cc = new CacheCommand("Select AID, ANAME from ADBK WHERE ANAME %startswith ?", adbksrc.conn);
CacheParameter cp = new CacheParameter("Name", CacheDbType.NVarChar);
cp.Value = name;
cc.Parameters.Add(cp);
CacheDataReader reader = cc.ExecuteReader();
while (reader.Read())
{
string id = reader[reader.GetOrdinal("AID")].ToString();
string aname = reader[reader.GetOrdinal("ANAME")].ToString();
anamelist.Add(aname);
idlist.Add(id);
}
return(anamelist);
}
catch (Exception err)
{
MessageBox.Show("searchbynameエラー " + err.Message);
return(anamelist);
}
//return anamelist;
}
//GetExamDetails 获取患者某次检查的所有详细信息 ZC 2014-12-2
//CSQ 2015-1-21
public static DataTable GetExamDetails(DataConnection pclsCache, string UserId, string VisitId, int SortNo, string ItemCode)
{
DataTable list = new DataTable();
list.Columns.Add(new DataColumn("Code", typeof(string)));
list.Columns.Add(new DataColumn("Name", typeof(string)));
list.Columns.Add(new DataColumn("Value", typeof(string)));
list.Columns.Add(new DataColumn("IsAbnormalCode", typeof(int)));
list.Columns.Add(new DataColumn("IsAbnormal", typeof(string)));
list.Columns.Add(new DataColumn("UnitCode", typeof(string)));
list.Columns.Add(new DataColumn("Unit", typeof(string)));
list.Columns.Add(new DataColumn("Creator", typeof(string)));
CacheCommand cmd = null;
CacheDataReader cdr = null;
try
{
if (!pclsCache.Connect())
{
return(null);
}
cmd = new CacheCommand();
cmd = Ps.ExamDetails.GetExamDetails(pclsCache.CacheConnectionObject);
cmd.Parameters.Add("UserId", CacheDbType.NVarChar).Value = UserId;
cmd.Parameters.Add("VisitId", CacheDbType.NVarChar).Value = VisitId;
cmd.Parameters.Add("SortNo", CacheDbType.Int).Value = SortNo;
cmd.Parameters.Add("ItemCode", CacheDbType.NVarChar).Value = ItemCode;
cdr = cmd.ExecuteReader();
while (cdr.Read())
{
list.Rows.Add(cdr["Code"].ToString(), cdr["Name"].ToString(), cdr["Value"].ToString(),
Convert.ToInt32(cdr["IsAbnormalCode"].ToString()), cdr["IsAbnormal"].ToString(),
cdr["UnitCode"].ToString(), cdr["Unit"].ToString(), cdr["Creator"].ToString());
}
return(list);
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "PsExamDetails.GetExamDetails", "数据库操作异常！ error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
return(null);
}
finally
{
if ((cdr != null))
{
cdr.Close();
cdr.Dispose(true);
cdr = null;
}
if ((cmd != null))
{
cmd.Parameters.Clear();
cmd.Dispose();
cmd = null;
}
pclsCache.DisConnect();
}
}
// 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();
}
}
//public void AddResult()
//{
// try
// {
// string strQuery = "INSERT Results.Results(Client,OrderCode,OrderId,ResultBinaryStream,ResultType,ResultName,ResultDate ) VALUES(@Client,@OrderCode,@OrderId,@ResultBinaryStream ,@ResultType,@ResultName,@ResultDate )";
// Cmd = new CacheCommand(strQuery, GetConnection());
// Cmd.Parameters.Add("@Client", "test5");
// Cmd.Parameters.Add("@OrderCode", "test5");
// Cmd.Parameters.Add("@OrderId", "test5");
// //Cmd.Parameters.Add("@ResultBinaryFile", "N");
// Cmd.Parameters.Add("@ResultType", "F");
// Cmd.Parameters.Add("@ResultName", "test5");
// Cmd.Parameters.Add("@ResultDate", DateTime.Now.ToString("yyyyMMdd"));
// // Now insert two files from disk as streams
// // Open binary file and read into byte[]
// FileStream fbs = new System.IO.FileStream("test.pdf", System.IO.FileMode.Open, System.IO.FileAccess.Read, System.IO.FileShare.ReadWrite);
// int filebLen = (int)fbs.Length;
// byte[] filebData = new byte[filebLen];
// fbs.Read(filebData, 0, (int)filebLen);
// fbs.Close();
// //Cmd.Parameters.Add()
// CacheParameter para = new CacheParameter("@ResultBinaryStream", filebData);
// para.Size = filebLen;
// Cmd.Parameters.Add(para);
// Cmd.ExecuteNonQuery();
// }
// catch(Exception e)
// {
// }
// finally
// {
// CacheConnect.Close();
// }
//}
public ClsResultFile GetResultFile(ClsGetResultFile GetResult)
{
DataTable dt = new DataTable();
//byte[] file = null;
ClsResultFile result = new ClsResultFile();
try
{
//Add Log
//AddLog(GetResult.appId, "GetResultFile", "RemoteIP" + GetResult.remoteIP + " OrderId " + GetResult.orderId + " OrderCode " + GetResult.test);
AddLog(GetResult.appId, "GetResultFile", " OrderId " + GetResult.orderId + " OrderCode " + GetResult.test);
using (Cmd = new CacheCommand("select ResultBinaryStream,FileName from Results.Results where orderId='" + GetResult.orderId + "' and OrderCode = '" +
GetResult.test + "' and locationId= '" + GetResult.locationId + "' and ResultName='" + GetResult.resultName + "'", GetConnection()))
{
//Cmd.Parameters.Add("@orderId", GetResult.orderId);
//Cmd.Parameters.Add("@orderCode", GetResult.test);
CacheDataReader reader = Cmd.ExecuteReader();
while (reader.Read())
{
result.resultBinaryStream = reader[0] as byte[];
result.fileName = reader[1] as string;
}
}
}
finally
{
CacheConnect.Close();
}
return(result);
}
public IList <ClsTest> GetTestList()
{
DataTable dt = new DataTable();
IList <ClsTest> list = null;
try
{
using (Cmd = new CacheCommand("select * from Orders.Tests", GetConnection()))
{
dt.Load(Cmd.ExecuteReader());
var query = from p in dt.AsEnumerable()
select new ClsTest
{
test = p.Field <string>("ordercode"),
testName = p.Field <string>("testName"),
testPrice = p.Field <object>("testPrice")
};
list = query.ToList();
}
}
finally
{
CacheConnect.Close();
}
return(list);
}
// 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();
}
}
//WF 2015-1-22
public static DataTable GetTreatmentList(DataConnection pclsCache, string piUserId)
{
DataTable list = new DataTable();
list.Columns.Add(new DataColumn("SortNo", typeof(string)));
list.Columns.Add(new DataColumn("TreatmentGoal", typeof(string)));
list.Columns.Add(new DataColumn("TreatmentGoalName", typeof(string)));
list.Columns.Add(new DataColumn("TreatmentAction", typeof(string)));
list.Columns.Add(new DataColumn("TreatmentActionName", typeof(string)));
list.Columns.Add(new DataColumn("Group", typeof(string)));
list.Columns.Add(new DataColumn("GroupName", typeof(string)));
list.Columns.Add(new DataColumn("TreatmentPlan", typeof(string)));
list.Columns.Add(new DataColumn("Description", typeof(string)));
list.Columns.Add(new DataColumn("TreatTime", typeof(string)));
list.Columns.Add(new DataColumn("Duration", typeof(string)));
list.Columns.Add(new DataColumn("DurationName", typeof(string)));
list.Columns.Add(new DataColumn("ReInUserId", typeof(string)));
CacheCommand cmd = null;
CacheDataReader cdr = null;
try
{
if (!pclsCache.Connect())
{
return(null);
}
cmd = new CacheCommand();
cmd = Ps.Treatment.GetTreatmentList(pclsCache.CacheConnectionObject);
cmd.Parameters.Add("piUserId", CacheDbType.NVarChar).Value = piUserId;
cdr = cmd.ExecuteReader();
while (cdr.Read())
{
list.Rows.Add(cdr["SortNo"].ToString(), cdr["TreatmentGoal"].ToString(), cdr["TreatmentGoalName"].ToString(), cdr["TreatmentAction"].ToString(), cdr["TreatmentActionName"].ToString(), cdr["Group"].ToString(), cdr["GroupName"].ToString(), cdr["TreatmentPlan"].ToString(), cdr["Description"].ToString(), cdr["TreatTime"].ToString(), cdr["Duration"].ToString(), cdr["DurationName"].ToString(), cdr["ReInUserId"].ToString());
}
return(list);
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "Ps.Treatment.GetTreatmentList", "数据库操作异常！ 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 DTBindProcedure(string procedureName, string conString, Dictionary <string, object> para)
{
dt = new DataTable();
using (var con = new CacheConnection(conString))
{
con.Open();
using (var cmd = new CacheCommand(procedureName, con))
{
cmd.CommandType = CommandType.StoredProcedure;
foreach (KeyValuePair <string, object> kvp in para)
{
cmd.Parameters.Add(kvp.Key, kvp.Value);
}
if (para != null)
{
using (CacheDataReader dr = cmd.ExecuteReader())
{
dt.Load(dr);
return(dt);
}
}
}
}
return(dt);
}
public List <CmMstInfoItem> GetCmMstInfoItem(DataConnection pclsCache)
{
List <CmMstInfoItem> CmMstInfoItemList = new List <CmMstInfoItem>();
CacheCommand cmd = null;
CacheDataReader cdr = null;
try
{
if (!pclsCache.Connect())
{
return(null);
}
//cmd = new CacheCommand();
cmd = Cm.MstInfoItem.GetInfoItem(pclsCache.CacheConnectionObject);
cdr = cmd.ExecuteReader();
while (cdr.Read())
{
CmMstInfoItemList.Add(new CmMstInfoItem
{
CategoryCode = cdr["CategoryCode"].ToString(),
Code = cdr["Code"].ToString(),
Name = cdr["Name"].ToString(),
ParentCode = cdr["ParentCode"].ToString(),
SortNo = Convert.ToInt32(cdr["SortNo"].ToString()),
StartDate = Convert.ToInt32(cdr["StartDate"].ToString()),
EndDate = Convert.ToInt32(cdr["EndDate"].ToString()),
GroupHeaderFlag = Convert.ToInt32(cdr["GroupHeaderFlag"].ToString()),
ControlType = cdr["ControlType"].ToString(),
OptionCategory = cdr["OptionCategory"].ToString(),
RevUserId = "",
TerminalName = "",
TerminalIP = "",
DeviceType = 0
});
}
return(CmMstInfoItemList);
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "CmMstInfoItem.GetInfoItem", "数据库操作异常！ error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
return(null);
}
finally
{
if ((cdr != null))
{
cdr.Close();
cdr.Dispose(true);
cdr = null;
}
if ((cmd != null))
{
cmd.Parameters.Clear();
cmd.Dispose();
cmd = null;
}
pclsCache.DisConnect();
}
}
//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();
}
}
//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 <DutyDoctorInfo> getDutyDoctorInfoList(DataConnection pclsCache, string id)
{
List <DutyDoctorInfo> dutyDoctorInfoList = new List <DutyDoctorInfo>();
CacheCommand cmd = null;
CacheDataReader cdr = null;
try
{
if (!pclsCache.Connect())
{
//MessageBox.Show("Cache数据库连接失败");
return(null);
}
cmd = new CacheCommand();
cmd = Vs.MstSchedule.GetDutyDoctorInfoList(pclsCache.CacheConnectionObject);
cmd.Parameters.Add("DeckId", CacheDbType.NVarChar).Value = id;
cdr = cmd.ExecuteReader();
while (cdr.Read())
{
DutyDoctorInfo dutyDoctorInfo = new DutyDoctorInfo();
dutyDoctorInfo.DeckId = cdr["DeckId"].ToString();
dutyDoctorInfo.DeckSectionId = cdr["DeckSectionId"].ToString();
dutyDoctorInfo.DoctorId = cdr["DoctorId"].ToString();
dutyDoctorInfo.SortNo = cdr["SortNo"].ToString();
dutyDoctorInfo.Time1 = cdr["Time1"].ToString();
dutyDoctorInfo.Time2 = cdr["Time2"].ToString();
dutyDoctorInfo.DoctorName = cdr["UserName"].ToString();
dutyDoctorInfo.Affiliation = cdr["Affiliation"].ToString();
dutyDoctorInfoList.Add(dutyDoctorInfo);
}
return(dutyDoctorInfoList);
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "DeckInfoMethod.getDutyDoctorInfoList", "数据库操作异常！ 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();
}
}
//GetPatientsMatchByDoctorId CSQ 20160114
public static DataTable GetPatientsMatchByDoctorId(DataConnection pclsCache, string DoctorId, string CategoryCode)
{
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("PatientId", typeof(string)));
list.Columns.Add(new DataColumn("PatientName", typeof(string)));
list.Columns.Add(new DataColumn("HUserId", typeof(string)));
list.Columns.Add(new DataColumn("HospitalCode", typeof(string)));
list.Columns.Add(new DataColumn("HospitalName", 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.DoctorInfoDetail.GetPatientsMatchByDoctorId(pclsCache.CacheConnectionObject);
cmd.Parameters.Add("DoctorId", CacheDbType.NVarChar).Value = DoctorId;
cmd.Parameters.Add("CategoryCode", CacheDbType.NVarChar).Value = CategoryCode;
cdr = cmd.ExecuteReader();
while (cdr.Read())
{
list.Rows.Add(cdr["DoctorId"].ToString(), cdr["DoctorName"].ToString(),
cdr["PatientId"].ToString(), cdr["PatientName"].ToString(), cdr["HUserId"].ToString(), cdr["HospitalCode"].ToString(), cdr["HospitalName"].ToString(), cdr["Description"].ToString());
}
return(list);
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "Ps.DoctorInfoDetail.GetPatientsMatchByDoctorId", "数据库操作异常！ error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
return(null);
}
finally
{
if ((cdr != null))
{
cdr.Close();
cdr.Dispose(true);
cdr = null;
}
if ((cmd != null))
{
cmd.Parameters.Clear();
cmd.Dispose();
cmd = null;
}
pclsCache.DisConnect();
}
}
/// <summary>
/// 计算某段时间的总依从率 syf 2015-10-10
/// </summary>
/// <param name="pclsCache"></param>
/// <param name="PatientId"></param>
/// <param name="PlanNo"></param>
/// <param name="StartDate"></param>
/// <param name="EndDate"></param>
/// <returns></returns>
public string GetCompliacneRate(DataConnection pclsCache, string PatientId, string PlanNo, int StartDate, int EndDate)
{
string compliacneRate = "";
CacheCommand cmd = null;
CacheDataReader cdr = null;
try
{
if (!pclsCache.Connect())
{
return(null);
}
cmd = new CacheCommand();
cmd = Ps.Compliance.GetComplianceListByPeriod(pclsCache.CacheConnectionObject);
cmd.Parameters.Add("PatientId", CacheDbType.NVarChar).Value = PatientId;
cmd.Parameters.Add("PlanNo", CacheDbType.NVarChar).Value = PlanNo;
cmd.Parameters.Add("StartDate", CacheDbType.NVarChar).Value = StartDate;
cmd.Parameters.Add("EndDate", CacheDbType.NVarChar).Value = EndDate;
cdr = cmd.ExecuteReader();
double sum = 0;
int count = 0;
while (cdr.Read())
{
sum += Convert.ToDouble(cdr["Compliance"]);
count++;
}
if (count != 0)
{
compliacneRate = (Math.Round(sum / count, 2, MidpointRounding.AwayFromZero) * 100).ToString(); //保留整数
}
return(compliacneRate);
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "PlanInfoMethod.GetCompliacneRate", "数据库操作异常！ error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
return(null);
}
finally
{
if ((cdr != null))
{
cdr.Close();
cdr.Dispose(true);
cdr = null;
}
if ((cmd != null))
{
cmd.Parameters.Clear();
cmd.Dispose();
cmd = null;
}
pclsCache.DisConnect();
}
}
//WF 20150514
public static DataTable GetAddressByType(DataConnection pclsCache, string Module, int Type)
{
DataTable list = new DataTable();
list.Columns.Add(new DataColumn("Module", typeof(string)));
list.Columns.Add(new DataColumn("ModuleName", typeof(string)));
list.Columns.Add(new DataColumn("HealthId", typeof(string)));
list.Columns.Add(new DataColumn("Type", typeof(int)));
list.Columns.Add(new DataColumn("TypeName", typeof(string)));
list.Columns.Add(new DataColumn("FileName", typeof(string)));
list.Columns.Add(new DataColumn("Path", typeof(string)));
list.Columns.Add(new DataColumn("Introduction", typeof(string)));
list.Columns.Add(new DataColumn("Redundance", typeof(string)));
list.Columns.Add(new DataColumn("Author", typeof(string)));
list.Columns.Add(new DataColumn("AuthorName", typeof(string)));
CacheCommand cmd = null;
CacheDataReader cdr = null;
try
{
if (!pclsCache.Connect())
{
return(null);
}
cmd = new CacheCommand();
cmd = Cm.MstHealthEducation.GetAddressByType(pclsCache.CacheConnectionObject);
cmd.Parameters.Add("Module", CacheDbType.NVarChar).Value = Module;
cmd.Parameters.Add("Type", CacheDbType.Int).Value = Type;
cdr = cmd.ExecuteReader();
while (cdr.Read())
{
list.Rows.Add(cdr["Module"].ToString(), cdr["ModuleName"].ToString(), cdr["HealthId"].ToString(), cdr["Type"], cdr["TypeName"].ToString(), cdr["FileName"].ToString(), cdr["Path"].ToString(), cdr["Introduction"].ToString(), cdr["Redundance"].ToString(), cdr["Author"].ToString(), cdr["AuthorName"].ToString());
}
return(list);
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "Cm.MstHealthEducation.GetAddressByType", "数据库操作异常！ error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
return(null);
}
finally
{
if ((cdr != null))
{
cdr.Close();
cdr.Dispose(true);
cdr = null;
}
if ((cmd != null))
{
cmd.Parameters.Clear();
cmd.Dispose();
cmd = null;
}
pclsCache.DisConnect();
}
}
// 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.DivisionDict.GetListByStatus(pclsCache.CacheConnectionObject);
cmd.Parameters.Add("Status", CacheDbType.Int).Value = Status;
//cmd.Parameters.Add("InvalidFlag", CacheDbType.Int).Value = InvalidFlag;
cdr = cmd.ExecuteReader();
while (cdr.Read())
{
list.Rows.Add(cdr["HospitalCode"].ToString(), cdr["HospitalName"].ToString(), cdr["Type"].ToString(), cdr["Code"].ToString(), cdr["TypeName"].ToString(), cdr["Name"].ToString(), cdr["InputCode"].ToString(), cdr["Description"].ToString(), cdr["Status"]);
}
return(list);
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "Tmp.DivisionDict.GetListByStatus", "数据库操作异常！ error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
return(null);
}
finally
{
if ((cdr != null))
{
cdr.Close();
cdr.Dispose(true);
cdr = null;
}
if ((cmd != null))
{
cmd.Parameters.Clear();
cmd.Dispose();
cmd = null;
}
pclsCache.DisConnect();
}
}
//ZC 2015-1-21
public static DataTable GetReminderbyDay(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("ReminderType", typeof(string)));
list.Columns.Add(new DataColumn("ReminderTypeName", typeof(string)));
list.Columns.Add(new DataColumn("Content", typeof(string)));
list.Columns.Add(new DataColumn("AlertMode", typeof(string)));
list.Columns.Add(new DataColumn("AlertModeName", typeof(string)));
list.Columns.Add(new DataColumn("StartDateTime", typeof(string)));
list.Columns.Add(new DataColumn("NextDate", typeof(string)));
list.Columns.Add(new DataColumn("NextTime", typeof(string)));
CacheCommand cmd = null;
CacheDataReader cdr = null;
try
{
if (!pclsCache.Connect())
{
return(null);
}
cmd = new CacheCommand();
cmd = Ps.Reminder.GetReminderbyDay(pclsCache.CacheConnectionObject);
cmd.Parameters.Add("PatientId", CacheDbType.NVarChar).Value = PatientId;
cmd.Parameters.Add("StartDate", CacheDbType.Int).Value = StartDate;
cmd.Parameters.Add("StartTime", CacheDbType.Int).Value = StartTime;
cdr = cmd.ExecuteReader();
while (cdr.Read())
{
list.Rows.Add(cdr["ReminderNo"].ToString(), cdr["ReminderType"].ToString(), cdr["ReminderTypeName"].ToString(), cdr["Content"].ToString(), cdr["AlertMode"].ToString(), cdr["AlertModeName"].ToString(), cdr["StartDateTime"].ToString(), cdr["NextDate"].ToString(), cdr["NextTime"].ToString());
}
return(list);
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "Ps.Reminder.GetReminderbyDay", "数据库操作异常！ 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 WY 2015-07-10
public static DataTable GetMpDrugCmp(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("DrugCode", typeof(string)));
list.Columns.Add(new DataColumn("DrugName", typeof(string)));
list.Columns.Add(new DataColumn("DrugSpec", 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.DrugCmp.GetMpDrugCmp(pclsCache.CacheConnectionObject);
//cmd.Parameters.Add("InvalidFlag", CacheDbType.Int).Value = InvalidFlag;
cdr = cmd.ExecuteReader();
while (cdr.Read())
{
list.Rows.Add(cdr["HospitalCode"].ToString(), cdr["HospitalName"].ToString(), cdr["DrugCode"], cdr["DrugName"].ToString(), cdr["DrugSpec"].ToString(), cdr["HZCode"].ToString(), cdr["HZName"].ToString(), cdr["Redundance"].ToString());
}
return(list);
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "MpDrugCmp.GetMpDrugCmp", "数据库操作异常！ 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();
}
}
/// <summary>
/// 通过Ps.Compliance中的date获取当天某项生理参数值，形成系列 DataTable 形式syf 2015-10-10
/// </summary>
/// <param name="pclsCache"></param>
/// <param name="PatientId"></param>
/// <param name="PlanNo"></param>
/// <param name="ItemType"></param>
/// <param name="ItemCode"></param>
/// <param name="StartDate"></param>
/// <param name="EndDate"></param>
/// <returns></returns>
public List <SignDetailByPeriod> GetSignDetailByPeriod(DataConnection pclsCache, string PatientId, string PlanNo, string ItemType, string ItemCode, int StartDate, int EndDate)
{
List <SignDetailByPeriod> list = new List <SignDetailByPeriod>();
CacheCommand cmd = null;
CacheDataReader cdr = null;
try
{
if (!pclsCache.Connect())
{
return(null);
}
cmd = new CacheCommand();
cmd = Ps.ComplianceDetail.GetSignDetailByPeriod(pclsCache.CacheConnectionObject);
cmd.Parameters.Add("PatientId", CacheDbType.NVarChar).Value = PatientId;
cmd.Parameters.Add("PlanNo", CacheDbType.NVarChar).Value = PlanNo;
cmd.Parameters.Add("ItemType", CacheDbType.NVarChar).Value = ItemType;
cmd.Parameters.Add("ItemCode", CacheDbType.NVarChar).Value = ItemCode;
cmd.Parameters.Add("StartDate", CacheDbType.NVarChar).Value = StartDate;
cmd.Parameters.Add("EndDate", CacheDbType.NVarChar).Value = EndDate;
cdr = cmd.ExecuteReader();
while (cdr.Read())
{
SignDetailByPeriod NewLine = new SignDetailByPeriod();
NewLine.RecordDate = cdr["RecordDate"].ToString();
NewLine.RecordTime = cdr["RecordTime"].ToString();
NewLine.Value = cdr["Value"].ToString();
NewLine.Unit = cdr["Unit"].ToString();
}
return(list);
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "PlanInfoMethod.GetSignDetailByPeriod", "数据库操作异常！ 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 <CmMstTask> GetMstTaskByParentCode(DataConnection pclsCache, string ParentCode)
{
List <CmMstTask> list = new List <CmMstTask>();
CacheCommand cmd = null;
CacheDataReader cdr = null;
try
{
if (!pclsCache.Connect())
{
return(null);
}
cmd = new CacheCommand();
cmd = Cm.MstTask.GetMstTaskByParentCode(pclsCache.CacheConnectionObject);
cmd.Parameters.Add("DoctorId", CacheDbType.NVarChar).Value = ParentCode;
cdr = cmd.ExecuteReader();
while (cdr.Read())
{
list.Add(new CmMstTask
{
CategoryCode = cdr["CategoryCode"].ToString(),
Code = cdr["Code"].ToString(),
Name = cdr["Name"].ToString(),
ParentCode = cdr["ParentCode"].ToString(),
Description = cdr["Description"].ToString(),
StartDate = Convert.ToInt32(cdr["StartDate"]),
EndDate = Convert.ToInt32(cdr["EndDate"]),
GroupHeaderFlag = Convert.ToInt32(cdr["GroupHeaderFlag"]),
ControlType = Convert.ToInt32(cdr["ControlType"]),
OptionCategory = cdr["OptionCategory"].ToString(),
});
}
return(list);
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "UsersMethod.GetMstTaskByParentCode", "数据库操作异常！ 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();
}
}
// 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();
}
}
// GetTrnAlertRecordList GL 2014-12-26 根据PatientId获取警报列表 (ZAM 12-26: + SortNo )
public static DataTable GetTrnAlertRecordList(DataConnection pclsCache, string PatientId)
{
DataTable AlertRecordList = new DataTable();
AlertRecordList.Columns.Add(new DataColumn("AlertType", typeof(string)));
AlertRecordList.Columns.Add(new DataColumn("AlertTypeName", typeof(string)));
AlertRecordList.Columns.Add(new DataColumn("AlertItemCode", typeof(string)));
AlertRecordList.Columns.Add(new DataColumn("AlertItem", typeof(string)));
AlertRecordList.Columns.Add(new DataColumn("AlertDateTime", typeof(string)));
AlertRecordList.Columns.Add(new DataColumn("PushFlag", typeof(string)));
AlertRecordList.Columns.Add(new DataColumn("ProcessFlag", typeof(string)));
AlertRecordList.Columns.Add(new DataColumn("SortNo", typeof(string)));
CacheCommand cmd = null;
CacheDataReader cdr = null;
try
{
if (!pclsCache.Connect())
{
//MessageBox.Show("Cache数据库连接失败");
return(null);
}
cmd = new CacheCommand();
cmd = Wn.TrnAlertRecord.GetTrnAlertRecordList(pclsCache.CacheConnectionObject);
cmd.Parameters.Add("PatientId", CacheDbType.NVarChar).Value = PatientId;
cdr = cmd.ExecuteReader();
while (cdr.Read())
{
AlertRecordList.Rows.Add(cdr["AlertType"].ToString(), cdr["AlertTypeName"].ToString(), cdr["AlertItemCode"].ToString(), cdr["AlertItem"].ToString(), cdr["AlertDateTime"].ToString(), cdr["PushFlag"].ToString(), cdr["ProcessFlag"].ToString(), cdr["SortNo"].ToString());
}
return(AlertRecordList);
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "WnTrnAlertRecord.GetTrnAlertRecordList", "数据库操作异常！ 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 <BedInfo> getBedInfoList(DataConnection pclsCache, string id)
{
List <BedInfo> bedInfoList = new List <BedInfo>();
CacheCommand cmd = null;
CacheDataReader cdr = null;
try
{
if (!pclsCache.Connect())
{
//MessageBox.Show("Cache数据库连接失败");
return(null);
}
cmd = new CacheCommand();
cmd = Vs.DeckBed.GetBedInfoList(pclsCache.CacheConnectionObject);
//cmd = Vs.MstDeckInfo.SetData(pclsCache.CacheConnectionObject);
cmd.Parameters.Add("DeckId", CacheDbType.NVarChar).Value = id;
cdr = cmd.ExecuteReader();
while (cdr.Read())
{
BedInfo bedInfo = new BedInfo();
bedInfo.DeckId = cdr["DeckId"].ToString();
bedInfo.DeckSectionId = cdr["DeckSectionId"].ToString();
bedInfo.WardCode = cdr["WardCode"].ToString();
bedInfo.RoomCode = cdr["RoomCode"].ToString();
bedInfo.BedCode = cdr["BedCode"].ToString();
bedInfo.Status = Convert.ToInt32(cdr["Status"]);
bedInfo.PatientName = cdr["PatientId"].ToString();
bedInfoList.Add(bedInfo);
}
return(bedInfoList);
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "DeckInfoMethod.getBedInfoList", "数据库操作异常！ 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();
}
}
// GetUserList ZAM 2014-12-03
public static DataTable GetUserList(DataConnection pclsCache)
{
DataTable list = new DataTable();
list.Columns.Add(new DataColumn("UserId", typeof(string)));
list.Columns.Add(new DataColumn("UserName", typeof(string)));
list.Columns.Add(new DataColumn("Password", typeof(string)));
list.Columns.Add(new DataColumn("Class", typeof(string)));
list.Columns.Add(new DataColumn("ClassName", typeof(string)));
list.Columns.Add(new DataColumn("StartDate", typeof(int)));
list.Columns.Add(new DataColumn("EndDate", typeof(int)));
CacheCommand cmd = null;
CacheDataReader cdr = null;
try
{
if (!pclsCache.Connect())
{
//MessageBox.Show("Cache数据库连接失败");
return(null);
}
cmd = new CacheCommand();
cmd = Cm.MstUser.GetUserList(pclsCache.CacheConnectionObject);
//cmd.Parameters.Add("Category", CacheDbType.NVarChar).Value = Category;
//cmd.Parameters.Add("InvalidFlag", CacheDbType.Int).Value = InvalidFlag;
cdr = cmd.ExecuteReader();
while (cdr.Read())
{
list.Rows.Add(cdr["UserId"].ToString(), cdr["UserName"].ToString(), cdr["Password"].ToString(), cdr["Class"].ToString(), cdr["ClassName"].ToString(), cdr["StartDate"], cdr["EndDate"]);
}
return(list);
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "CmMstUser.GetUserList", "数据库操作异常！ error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
return(null);
}
finally
{
if ((cdr != null))
{
cdr.Close();
cdr.Dispose(true);
cdr = null;
}
if ((cmd != null))
{
cmd.Parameters.Clear();
cmd.Dispose();
cmd = null;
}
pclsCache.DisConnect();
}
}
/// <summary>
/// SYF 20151010 获取健康专员负责的所有患者列表
/// </summary>
/// <param name="pclsCache"></param>
/// <param name="DoctorId"></param>
/// <param name="Module"></param>
/// <returns></returns>
public List <PatientPlan> GetPatientsPlanByDoctorId(DataConnection pclsCache, string DoctorId, string Module)
{
List <PatientPlan> list = new List <PatientPlan>();
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())
{
if (cdr["PatientId"].ToString() == string.Empty)
{
continue;
}
PatientPlan NewLine = new PatientPlan();
NewLine.PatientId = cdr["PatientId"].ToString();
NewLine.PlanNo = cdr["PlanNo"].ToString();
NewLine.StartDate = cdr["StartDate"].ToString();
NewLine.EndDate = cdr["EndDate"].ToString();
NewLine.TotalDays = cdr["TotalDays"].ToString();
NewLine.RemainingDays = cdr["RemainingDays"].ToString();
NewLine.Status = cdr["Status"].ToString();
}
return(list);
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "PlanInfoMethod.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();
}
}
// GetReceiveList GL 2015-01-28 获取已收到的消息列表
public static DataTable GetReceiveList(DataConnection pclsCache, string UserId)
{
DataTable ReceiveList = new DataTable();
ReceiveList.Columns.Add(new DataColumn("MessageNo", typeof(string)));
ReceiveList.Columns.Add(new DataColumn("SendBy", typeof(string)));
ReceiveList.Columns.Add(new DataColumn("SendByName", typeof(string)));
ReceiveList.Columns.Add(new DataColumn("Title", typeof(string)));
ReceiveList.Columns.Add(new DataColumn("SendDateTime", typeof(string)));
ReceiveList.Columns.Add(new DataColumn("Content", typeof(string)));
ReceiveList.Columns.Add(new DataColumn("ReadStatus", typeof(int)));
ReceiveList.Columns.Add(new DataColumn("Flag", typeof(int)));
CacheCommand cmd = null;
CacheDataReader cdr = null;
try
{
if (!pclsCache.Connect())
{
//MessageBox.Show("Cache数据库连接失败");
return(null);
}
cmd = new CacheCommand();
cmd = Mb.MessageRecord.GetReceiveList(pclsCache.CacheConnectionObject);
cmd.Parameters.Add("UserId", CacheDbType.NVarChar).Value = UserId;
cdr = cmd.ExecuteReader();
while (cdr.Read())
{
ReceiveList.Rows.Add(cdr["MessageNo"].ToString(), cdr["SendBy"].ToString(), cdr["SendByName"].ToString(), cdr["Title"].ToString(), cdr["SendDateTime"].ToString(), cdr["Content"].ToString(), Convert.ToInt32(cdr["ReadStatus"]), Convert.ToInt32(cdr["Flag"]));
}
return(ReceiveList);
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "MbMessageRecord.GetReceiveList", "数据库操作异常！ 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>
/// 获取病人住院信息 施宇帆 2016-04-28
/// </summary>
/// <param name="pclsCache"></param>
/// <param name="PatientId"></param>
/// <returns></returns>
public List <PsTrnInpatient> GetInPByPID(DataConnection pclsCache, string PatientId)
{
List <PsTrnInpatient> items = new List <PsTrnInpatient>();
CacheCommand cmd = null;
CacheDataReader cdr = null;
try
{
if (!pclsCache.Connect())
{
return(null);
}
cmd = Ps.TrnInpatient.GetInPByPID(pclsCache.CacheConnectionObject);
cmd.Parameters.Add("PatientId", CacheDbType.NVarChar).Value = PatientId;
cdr = cmd.ExecuteReader();
while (cdr.Read())
{
PsTrnInpatient item = new PsTrnInpatient();
item.AdmissionDate = cdr["AdmissionDate"].ToString();
item.AdDays = Convert.ToInt32(cdr["AdDays"]);
item.DoctorName = cdr["DoctorName"].ToString();
item.NurseName = cdr["NurseName"].ToString();
item.RoomName = cdr["RoomName"].ToString();
item.BedName = cdr["BedName"].ToString();
item.WardName = cdr["WardName"].ToString();
item.Diagnosis = cdr["Diagnosis"].ToString();
items.Add(item);
}
return(items);
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "PsTrnOutpatientMethod.GetInPByPID", "数据库操作异常！ 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();
}
}
// 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();
}
}
//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();
}
}
//输出一段时间中记录的所有体征信息
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 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();
}
}
//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();
}
}
// 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();
}
}
// 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();
}
}
//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();
}
}
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();
}
}
/// <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();
}
}
//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();
}
}
// 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 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();
}
}
/// <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();
}
}
//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();
}
}
//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();
}
}
//GetTasksComByPeriod 某段时间所有任务的依从情况 DataTable数据库形式 LS 2010703
public static DataTable GetTasksComByPeriodDT(DataConnection pclsCache, string PatientId, string PlanNo, int StartDate, int EndDate)
{
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)));
list.Columns.Add(new DataColumn("Type", typeof(string))); //英文
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())
{
list.Rows.Add(cdr["Date"].ToString(), Convert.ToDouble(cdr["ComplianceValue"]), cdr["TaskType"].ToString(), cdr["TaskId"].ToString(), cdr["TaskName"].ToString(), Convert.ToInt32(cdr["Status"]), cdr["Type"].ToString());
}
return list;
}
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();
}
}
//以下是任务完成情况用到的函数
//GetCompliacneRate 计算某段时间的总依从率 LS 2015-03-27
public static 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 = ((int)((sum / count) * 100)).ToString();
compliacneRate = (Math.Round(sum / count, 2, MidpointRounding.AwayFromZero) * 100).ToString(); //保留整数
}
return compliacneRate;
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "PsCompliacne.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();
}
}
//GetBasicAlert 获得字典表全部信息 YDS 2014-12-09
public static DataTable GetBasicAlert(DataConnection pclsCache)
{
DataTable list = new DataTable();
list.Columns.Add(new DataColumn("AlertItemCode", typeof(string)));
list.Columns.Add(new DataColumn("AlertItemName", typeof(string)));
list.Columns.Add(new DataColumn("Min", typeof(decimal)));
list.Columns.Add(new DataColumn("Max", typeof(decimal)));
list.Columns.Add(new DataColumn("Units", typeof(string)));
list.Columns.Add(new DataColumn("Remarks", typeof(string)));
CacheCommand cmd = null;
CacheDataReader cdr = null;
try
{
if (!pclsCache.Connect())
{
//MessageBox.Show("Cache数据库连接失败");
return null;
}
cmd = new CacheCommand();
cmd = Wn.MstBasicAlert.GetBasicAlert(pclsCache.CacheConnectionObject);
cdr = cmd.ExecuteReader();
while (cdr.Read())
{
decimal Min = 0;
decimal Max = 0;
if (cdr["Min"].ToString() != "")
{
Min = Convert.ToDecimal(cdr["Min"]);
}
if (cdr["Max"].ToString() != "")
{
Max = Convert.ToDecimal(cdr["Max"]);
}
list.Rows.Add(cdr["AlertItemCode"].ToString(), cdr["AlertItemName"].ToString(), Min, Max, cdr["Units"].ToString(), cdr["Remarks"].ToString());
}
return list;
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "WnMstBasicAlert.GetBasicAlert", "数据库操作异常！ 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>
/// 从数据库拿出相关数据 并增加type字段 区别收缩压、舒张压、脉率 用于phone 体征详细时刻表 GL 2015-10-10
/// </summary>
/// <param name="UserId"></param>
/// <param name="ItemType"></param>
/// <param name="ItemCode"></param>
/// <param name="StartDate"></param>
/// <param name="EndDate"></param>
/// <returns></returns>
public List<VitalInfo> GetTypedSignDetailByPeriod(DataConnection pclsCache, string UserId, string ItemType, string ItemCode, 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.GetSignDetailByPeriod(pclsCache.CacheConnectionObject);
cmd.Parameters.Add("UserId", CacheDbType.NVarChar).Value = UserId;
cmd.Parameters.Add("ItemType", CacheDbType.NVarChar).Value = ItemType;
cmd.Parameters.Add("ItemCode", CacheDbType.NVarChar).Value = ItemCode;
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();
string RecordDate = cdr["RecordDate"].ToString();
RecordDate = RecordDate.Substring(0, 4) + "-" + RecordDate.Substring(4, 2) + "-" + RecordDate.Substring(6, 2);
string SignType = "";
if (ItemCode == "Bloodpressure_1") //收缩压
{
SignType = "1";
}
else if (ItemCode == "Bloodpressure_2") //舒张压
{
SignType = "2";
}
else //脉率"Pulserate_1"
{
SignType = "3";
}
item.SignType = SignType;
item.RecordDate = RecordDate;
item.RecordTime = new CommonFunction().TransTime(cdr["RecordTime"].ToString());
item.Value = cdr["Value"].ToString();
item.Unit = cdr["Unit"].ToString();
items.Add(item);
}
return items;
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "VitalInfoMethod.GetTypedSignDetailByPeriod", "数据库操作异常！ 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();
}
}
}
