private void m_mthSaveFunciton(string p_strmaxid, TreeNode p_node) { string SQL = "insert into T_ROLEDETAIL(ROLE_ID,PURVIEW_ID,ROLE_TYPE,ROLE_VALUES) values (" + p_strmaxid + "," + ((DataRow)p_node.Tag)["PURVIEW_ID"].ToString() + ",0,'')"; 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_lngSaveIllnessSymptom(SQL); }
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(); }