private void m_mthGetData(string p_strRoleID) { string SQL = "select * from T_ROLE where ROLE_ID=" + p_strRoleID + ""; DataTable dtRecords = null; com.digitalwave.common.ICD10.Midtier.clsIllnessSymptomServ objServ = (com.digitalwave.common.ICD10.Midtier.clsIllnessSymptomServ)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(com.digitalwave.common.ICD10.Midtier.clsIllnessSymptomServ)); objServ.m_lngGetMaxID(SQL, ref dtRecords); if (dtRecords != null) { m_txtName.Text = dtRecords.Rows[0]["ROLE_NAME"].ToString(); m_txtDesc.Text = dtRecords.Rows[0]["ROLE_DESC"].ToString(); } dtRecords.Clear(); dtRecords = null; SQL = "select * from T_ROLEDETAIL where ROLE_ID=" + p_strRoleID + ""; objServ.m_lngGetMaxID(SQL, ref m_dtFunction); }
private void m_cmdOK_Click(object sender, System.EventArgs e) { string SQL = ""; string strMaxID = ""; DataTable dtRecords = null; com.digitalwave.common.ICD10.Midtier.clsIllnessSymptomServ objServ = (com.digitalwave.common.ICD10.Midtier.clsIllnessSymptomServ)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(com.digitalwave.common.ICD10.Midtier.clsIllnessSymptomServ)); if (m_strMode == "Edit") { SQL = "update T_ROLE set ROLE_NAME='" + m_txtName.Text.Replace("'", "''") + "',ROLE_DESC='" + m_txtDesc.Text.Replace("'", "''") + "' where ROLE_ID=" + m_RoleID + ""; objServ.m_lngSaveIllnessSymptom(SQL); SQL = "delete from T_ROLEDETAIL where ROLE_ID=" + m_RoleID + ""; objServ.m_lngSaveIllnessSymptom(SQL); for (int i = 0; i < m_trvFunctionByFrom.Nodes.Count; i++) { if (m_trvFunctionByFrom.Nodes[i].Checked) { SQL = "insert into T_ROLEDETAIL(ROLE_ID,PURVIEW_ID,ROLE_TYPE,ROLE_VALUES) values (" + m_RoleID + "," + ((DataRow)m_trvFunctionByFrom.Nodes[i].Tag)["PURVIEW_ID"].ToString() + ",0,'')"; objServ.m_lngSaveIllnessSymptom(SQL); } m_mthSeachNode(m_trvFunctionByFrom.Nodes[i], m_RoleID); } } else if (m_strMode == "Add") { if (com.digitalwave.Emr.StaticObject.clsEMR_StaticObject.s_StrCurrentHospitalNO == "440104001") { SQL = "select isnull(max(ROLE_ID),0)+1 from T_ROLE"; } else { SQL = "select nvl(max(ROLE_ID),0)+1 from T_ROLE"; } objServ.m_lngGetMaxID(SQL, ref dtRecords); if (dtRecords != null) { strMaxID = dtRecords.Rows[0][0].ToString(); } dtRecords.Clear(); dtRecords = null; SQL = "insert into T_ROLE (ROLE_ID,ROLE_NAME,ROLE_DESC) values (" + strMaxID + ",'" + m_txtName.Text.Replace("'", "''") + "','" + m_txtDesc.Text.Replace("'", "''") + "')"; objServ.m_lngSaveIllnessSymptom(SQL); for (int i = 0; i < m_trvFunctionByFrom.Nodes.Count; i++) { if (m_trvFunctionByFrom.Nodes[i].Checked) { SQL = "insert into T_ROLEDETAIL(ROLE_ID,PURVIEW_ID,ROLE_TYPE,ROLE_VALUES) values (" + strMaxID + "," + ((DataRow)m_trvFunctionByFrom.Nodes[i].Tag)["PURVIEW_ID"].ToString() + ",0,'')"; objServ.m_lngSaveIllnessSymptom(SQL); } m_mthSeachNode(m_trvFunctionByFrom.Nodes[i], strMaxID); } } this.Close(); }
private void m_mthGetAllFunctionByFrom() { string SQL = ""; // TreeNode pNode=null; ArrayList NoteArry = new ArrayList(); com.digitalwave.common.ICD10.Midtier.clsIllnessSymptomServ objServ = (com.digitalwave.common.ICD10.Midtier.clsIllnessSymptomServ)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(com.digitalwave.common.ICD10.Midtier.clsIllnessSymptomServ)); if (com.digitalwave.Emr.StaticObject.clsEMR_StaticObject.s_StrCurrentHospitalNO == "440104001") { #region sqlserver 2000 SQL = "select * from t_purviewdefine "; objServ.m_lngGetMaxID(SQL, ref dtRecords0); if (dtRecords0 != null) { //调用递归函数完成树形结构 AddTree(-1, (TreeNode)null); } #endregion } else { #region oracle SQL = "select * from t_purviewdefine start with PURVIEW_pID is null and (purview_type=0 or purview_type=1) connect by prior PURVIEW_ID=PURVIEW_pID"; objServ.m_lngGetMaxID(SQL, ref dtRecords0); if (dtRecords0 != null) { for (int i = 0; i < dtRecords0.Rows.Count; i++) { if (dtRecords0.Rows[i]["PURVIEW_pID"].ToString().Trim().Length == 0) { //根节点 TreeNode tNode = m_trvFunctionByFrom.Nodes.Add(dtRecords0.Rows[i]["PURVIEW_CNAME"].ToString()); tNode.Tag = dtRecords0.Rows[i]; if (dtRecords0.Rows[i]["PURVIEW_FUNCTION"].ToString().Trim().Length != 0) { tNode.ForeColor = Color.Blue; } if (m_strMode == "Edit") { if (m_dtFunction != null) { for (int k = 0; k < m_dtFunction.Rows.Count; k++) { if (dtRecords0.Rows[i]["PURVIEW_ID"].ToString() == m_dtFunction.Rows[k]["PURVIEW_ID"].ToString()) { tNode.Checked = true; break; } } } } NoteArry.Add(tNode); } else { for (int j = 0; j < NoteArry.Count; j++) { if (((DataRow)((TreeNode)NoteArry[j]).Tag)["PURVIEW_ID"].ToString().Trim() == dtRecords0.Rows[i]["PURVIEW_pID"].ToString().Trim()) { TreeNode tpNode = ((TreeNode)NoteArry[j]).Nodes.Add(dtRecords0.Rows[i]["PURVIEW_CNAME"].ToString()); tpNode.Tag = dtRecords0.Rows[i]; if (dtRecords0.Rows[i]["PURVIEW_FUNCTION"].ToString().Trim().Length != 0) { tpNode.ForeColor = Color.Blue; } if (m_strMode == "Edit") { if (m_dtFunction != null) { for (int k = 0; k < m_dtFunction.Rows.Count; k++) { if (dtRecords0.Rows[i]["PURVIEW_ID"].ToString() == m_dtFunction.Rows[k]["PURVIEW_ID"].ToString()) { tpNode.Checked = true; break; } } } } NoteArry.Add(tpNode); break; } } } } } #endregion oracle } #region old // if (dtRecords!=null) // { // for (int i=0;i<dtRecords.Rows.Count;i++) // { // if (dtRecords.Rows[i]["PURVIEW_pID"].ToString().Trim().Length==0) // { // TreeNode tNode=m_trvFunctionByFrom.Nodes.Add(dtRecords.Rows[i]["PURVIEW_CNAME"].ToString()); // tNode.Tag=dtRecords.Rows[i]; // if (m_strMode=="Edit") // { // if (m_dtFunction!=null) // { // for (int k=0;k<m_dtFunction.Rows.Count;k++) // { // if (dtRecords.Rows[i]["PURVIEW_ID"].ToString()==m_dtFunction.Rows[k]["PURVIEW_ID"].ToString()) // { // tNode.Checked=true; // break; // } // } // } // } // pNode=tNode; // } // else // { // if (pNode!=null) // { // TreeNode tNode=pNode.Nodes.Add(dtRecords.Rows[i]["PURVIEW_CNAME"].ToString()); // tNode.Tag=dtRecords.Rows[i]; // if (m_strMode=="Edit") // { // if (m_dtFunction!=null) // { // for (int k=0;k<m_dtFunction.Rows.Count;k++) // { // if (dtRecords.Rows[i]["PURVIEW_ID"].ToString()==m_dtFunction.Rows[k]["PURVIEW_ID"].ToString()) // { // tNode.Checked=true; // break; // } // } // } // } // } // } // // } // } #endregion old }