public DataSetInfo GetDataSetInfo(int aDesPID) { DataRow[] vRows = emrMSDB.DB.DataSetDT.Select(string.Format("ID = {0}", aDesPID)); if (vRows.Length > 0) { DataSetInfo Result = new DataSetInfo(); Result.ID = int.Parse(vRows[0]["ID"].ToString());//id, pid, Name, Class, Type Result.PID = int.Parse(vRows[0]["pid"].ToString()); Result.GroupName = vRows[0]["Name"].ToString(); Result.GroupClass = int.Parse(vRows[0]["Class"].ToString()); Result.GroupType = int.Parse(vRows[0]["Type"].ToString()); return(Result); } return(null); }
private void TvRecord_BeforeExpand(object sender, TreeViewCancelEventArgs e) { if (e.Node.Nodes[0].Text == "正在加载...") { DataTable dt = emrMSDB.DB.GetData(string.Format(emrMSDB.Sql_GetInchRecordList, (e.Node.Tag as PatientInfo).PatID, (e.Node.Tag as PatientInfo).VisitID)); tvRecord.BeginUpdate(); try { int vDesPID = 0; TreeNode vNode = null; for (int i = 0; i < dt.Rows.Count; i++) { if (vDesPID.ToString() != dt.Rows[i]["desPID"].ToString()) { vDesPID = int.Parse(dt.Rows[i]["desPID"].ToString()); RecordDataSetInfo vRecordDataSetInfo = new RecordDataSetInfo(); vRecordDataSetInfo.DesPID = vDesPID; DataSetInfo vDataSetInfo = emrMSDB.DB.GetDataSetInfo(vDesPID); vNode = e.Node.Nodes.Add(vDataSetInfo.GroupName); vNode.Tag = vRecordDataSetInfo; } RecordInfo vRecordInfo = new RecordInfo(); vRecordInfo.ID = int.Parse(dt.Rows[i]["ID"].ToString()); vRecordInfo.DesID = int.Parse(dt.Rows[i]["desID"].ToString()); vRecordInfo.RecName = dt.Rows[i]["name"].ToString(); vRecordInfo.LastDT = DateTime.Parse(dt.Rows[i]["LastDT"].ToString()); TreeNode vRecNode = vNode.Nodes.Add(vRecordInfo.RecName + "(" + string.Format("{0:yyyy-MM-dd HH:mm}", vRecordInfo.LastDT) + ")"); vRecNode.Tag = vRecordInfo; } if ((e.Node.GetNodeCount(false) > 0) && (e.Node.Nodes[0].Text == "正在加载...")) { e.Node.Nodes.RemoveAt(0); } } finally { tvRecord.EndUpdate(); } } }
private void GetPatientRecordListUI() { tvRecord.Nodes.Clear(); // 本次住院节点 TreeNode vPatNode = tvRecord.Nodes.Add("第" + PatientInfo.VisitID.ToString() + "次 " + PatientInfo.BedNo + "床 " + PatientInfo.Name + " " + string.Format("{0:yyyy-MM-dd}", PatientInfo.InDeptDateTime)); DataTable dt = emrMSDB.DB.GetData(string.Format(emrMSDB.Sql_GetInchRecordList, PatientInfo.PatID, PatientInfo.VisitID)); tvRecord.BeginUpdate(); try { int vDesPID = 0; TreeNode vNode = vPatNode; for (int i = 0; i < dt.Rows.Count; i++) { if (vDesPID.ToString() != dt.Rows[i]["desPID"].ToString()) { vDesPID = int.Parse(dt.Rows[i]["desPID"].ToString()); RecordDataSetInfo vRecordDataSetInfo = new RecordDataSetInfo(); vRecordDataSetInfo.DesPID = vDesPID; DataSetInfo vDataSetInfo = GetDataSetInfo(vDesPID); vNode = vPatNode.Nodes.Add(vDataSetInfo.GroupName); vNode.Tag = vRecordDataSetInfo; } RecordInfo vRecordInfo = new RecordInfo(); vRecordInfo.ID = int.Parse(dt.Rows[i]["ID"].ToString()); vRecordInfo.DesID = int.Parse(dt.Rows[i]["desID"].ToString()); vRecordInfo.RecName = dt.Rows[i]["name"].ToString(); vRecordInfo.LastDT = DateTime.Parse(dt.Rows[i]["LastDT"].ToString()); TreeNode vRecNode = vNode.Nodes.Add(vRecordInfo.RecName + "(" + string.Format("{0:yyyy-MM-dd HH:mm}", vRecordInfo.LastDT) + ")"); vRecNode.Tag = vRecordInfo; } } finally { tvRecord.EndUpdate(); } }
private void ShowTemplateDeSet() { tvTemplate.Nodes.Clear(); DataTable dt = emrMSDB.DB.GetData(emrMSDB.Sql_GetTemplate); tvTemplate.BeginUpdate(); try { for (int i = 0; i < dt.Rows.Count; i++) { DataSetInfo vDataSetInfo = new DataSetInfo(); vDataSetInfo.ID = (int)dt.Rows[i]["id"]; vDataSetInfo.PID = (int)dt.Rows[i]["pid"]; vDataSetInfo.GroupClass = (int)dt.Rows[i]["class"]; vDataSetInfo.GroupType = (int)dt.Rows[i]["type"]; vDataSetInfo.GroupName = dt.Rows[i]["name"].ToString(); TreeNode vNode = null; if (vDataSetInfo.PID != 0) { vNode = GetParentNode(vDataSetInfo.PID).Nodes.Add(dt.Rows[i]["name"].ToString()); } else { vNode = tvTemplate.Nodes.Add(dt.Rows[i]["name"].ToString()); } vNode.Tag = vDataSetInfo; } for (int i = 0; i < tvTemplate.Nodes.Count; i++) { SetParentNodeState(tvTemplate.Nodes[i]); } } finally { tvTemplate.EndUpdate(); } }
private void GetTemplateGroup() { tvTemplate.Nodes.Clear(); DataTable dt = emrMSDB.DB.GetData(emrMSDB.Sql_GetDataSet); tvTemplate.BeginUpdate(); try { int vUseRang = -1, vInOrOut = -1; for (int i = 0; i < dt.Rows.Count; i++) { if (!int.TryParse(dt.Rows[i]["UseRang"].ToString(), out vUseRang)) { return; } if (!int.TryParse(dt.Rows[i]["InOrOut"].ToString(), out vInOrOut)) { return; } if (((vUseRang == DataSetInfo.USERANG_CLINIC) || (vUseRang == DataSetInfo.USERANG_CLINICANDNURSE)) && ((vInOrOut == DataSetInfo.INOROUT_IN) || (vInOrOut == DataSetInfo.INOROUT_INOUT)) ) { TreeNode vNode = null; int vPID = (int)dt.Rows[i]["pid"]; if (vPID != 0) { vNode = GetParentNode(vPID); if (vNode == null) { continue; } } DataSetInfo vDataSetInfo = new DataSetInfo(); vDataSetInfo.ID = (int)dt.Rows[i]["id"]; vDataSetInfo.PID = (int)dt.Rows[i]["pid"]; vDataSetInfo.GroupClass = (int)dt.Rows[i]["class"]; vDataSetInfo.GroupType = (int)dt.Rows[i]["type"]; vDataSetInfo.GroupName = dt.Rows[i]["name"].ToString(); vDataSetInfo.UseRang = vUseRang; vDataSetInfo.InOrOut = vInOrOut; if (vNode != null) { vNode = vNode.Nodes.Add(dt.Rows[i]["name"].ToString()); } else { vNode = tvTemplate.Nodes.Add(dt.Rows[i]["name"].ToString()); } vNode.Tag = vDataSetInfo; } } } finally { tvTemplate.EndUpdate(); } }