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();
}