public long m_lngAddApplUserGroupAndDetailRelation(ref clsApplUserGroup_VO objApplUserGroupVO, ref clsApplUserGroupDetail_VO[] objApplUserGroupDetailVOList,
ref clsApplUserGroupRelation_VO[] objApplUserGroupRelationVOList, clsApplUserGroupRelation_VO p_objParentRelation)
{
long lngRes = 0;
com.digitalwave.iCare.middletier.LIS.clsAppGroupSvc objAppGroupSvc = (com.digitalwave.iCare.middletier.LIS.clsAppGroupSvc)
com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(com.digitalwave.iCare.middletier.LIS.clsAppGroupSvc));
lngRes = objAppGroupSvc.m_lngAddApplUserGroupAndDetail(objPrincipal, ref objApplUserGroupVO, ref objApplUserGroupDetailVOList,
ref objApplUserGroupRelationVOList, p_objParentRelation);
// objAppGroupSvc.Dispose();
return(lngRes);
}
private string m_strGenerateGroupPathString(TreeNode p_trnNode)
{
StringBuilder sb = new StringBuilder();
while (p_trnNode.Parent != null && p_trnNode.Parent.Tag != null && p_trnNode.Parent.Tag.GetType().Name == typeof(clsApplUserGroup_VO).Name)
{
clsApplUserGroup_VO objUserGroupVO = (clsApplUserGroup_VO)p_trnNode.Parent.Tag;
sb.Insert(0, objUserGroupVO.strUserGroupID + ">>");
p_trnNode = p_trnNode.Parent;
}
return(sb.ToString());
}
private void ConstructApplUserGroupVO(System.Data.DataRow objRow, ref clsApplUserGroup_VO objApplUserGroupVO)
{
objApplUserGroupVO.strUserGroupID = objRow["USER_GROUP_ID_CHR"].ToString().Trim();
objApplUserGroupVO.strUserGroupName = objRow["USER_GROUP_NAME_VCHR"].ToString().Trim();
objApplUserGroupVO.strHasChildGroup = objRow["HAS_CHILD_GROUP"].ToString().Trim();
objApplUserGroupVO.strPYCode = objRow["PY_CODE_CHR"].ToString().Trim();
objApplUserGroupVO.strWBCode = objRow["WB_CODE_CHR"].ToString().Trim();
objApplUserGroupVO.strAssistCode01 = objRow["ASSIST_CODE01_CHR"].ToString().Trim();
objApplUserGroupVO.strAssistCode02 = objRow["ASSIST_CODE02_CHR"].ToString().Trim();
objApplUserGroupVO.strGroupFlag = objRow["GROUP_FLAG_CHR"].ToString().Trim();
objApplUserGroupVO.strOperatorID = objRow["OPERATOR_ID_CHR"].ToString().Trim();
objApplUserGroupVO.strSummary = objRow["SUMMARY_VCHR"].ToString().Trim();
}
public long m_lngGetChildGroupByUserGroupID(System.Security.Principal.IPrincipal p_objPrincipal, string strUserGroupID, out clsApplUserGroup_VO[] objAppUserGroupVOList)
{
long lngRes = 0;
objAppUserGroupVOList = null;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsCheckGroupSvc", "m_lngGetChildGroupByUserGroupID");
if (lngRes < 0)
{
return(-1);
}
string strSQL = @"SELECT t1.*
FROM t_aid_lis_appuser_group t1, t_aid_lis_appuser_group_relate t2
WHERE t1.user_group_id_chr = t2.child_user_group_id_chr
AND t2.user_group_id_chr = '" + strUserGroupID + "'";
DataTable dtbAppUser = null;
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
lngRes = objHRPSvc.lngGetDataTableWithoutParameters(strSQL, ref dtbAppUser);
if (lngRes > 0 && dtbAppUser != null)
{
if (dtbAppUser.Rows.Count > 0)
{
objAppUserGroupVOList = new clsApplUserGroup_VO[dtbAppUser.Rows.Count];
for (int i = 0; i < dtbAppUser.Rows.Count; i++)
{
objAppUserGroupVOList[i] = new clsApplUserGroup_VO();
ConstructApplUserGroupVO(dtbAppUser.Rows[i], ref objAppUserGroupVOList[i]);
}
}
}
objHRPSvc.Dispose();
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_lngAddAppUserGroup(System.Security.Principal.IPrincipal p_objPrincipal, ref clsApplUserGroup_VO objApplUserGroup)
{
long lngRes = 0;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsAppGroupSvc", "m_lngAddAppUserGroup");
if (lngRes < 0)
{
return(-1);
}
string strSQL = @"INSERT INTO t_aid_lis_appuser_group
(user_group_id_chr, user_group_name_vchr, has_child_group,
py_code_chr, assist_code01_chr, wb_code_chr, assist_code02_chr,
group_flag_chr, operator_id_chr,summary_vchr
)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?,?)" ;
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
System.Data.IDataParameter[] objApplUserGroupArr = null;
objHRPSvc.CreateDatabaseParameter(10, out objApplUserGroupArr);
if (objApplUserGroup.strUserGroupID == null)
{
objApplUserGroup.strUserGroupID = objHRPSvc.m_strGetNewID("t_aid_lis_appuser_group", "user_group_id_chr", 6);
}
objApplUserGroupArr[0].Value = objApplUserGroup.strUserGroupID;
objApplUserGroupArr[1].Value = objApplUserGroup.strUserGroupName;
objApplUserGroupArr[2].Value = objApplUserGroup.strHasChildGroup;
objApplUserGroupArr[3].Value = objApplUserGroup.strPYCode;
objApplUserGroupArr[4].Value = objApplUserGroup.strAssistCode01;
objApplUserGroupArr[5].Value = objApplUserGroup.strWBCode;
objApplUserGroupArr[6].Value = objApplUserGroup.strAssistCode02;
objApplUserGroupArr[7].Value = objApplUserGroup.strGroupFlag;
objApplUserGroupArr[8].Value = objApplUserGroup.strOperatorID;
objApplUserGroupArr[9].Value = objApplUserGroup.strSummary;
long lngRecEff = -1;
lngRes = objHRPSvc.lngExecuteParameterSQL(strSQL, ref lngRecEff, objApplUserGroupArr);
objHRPSvc.Dispose();
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_lngAddApplUserGroupAndDetail(System.Security.Principal.IPrincipal p_objPrincipal, ref clsApplUserGroup_VO objApplUserGroupVO,
ref clsApplUserGroupDetail_VO[] objApplUserGroupDetailList, ref clsApplUserGroupRelation_VO[] objApplUserGroupRelation,
clsApplUserGroupRelation_VO p_objParentRelation)
{
long lngRes = 0;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsAppGroupSvc", "m_lngAddApplUserRelation");
if (lngRes < 0)
{
return(-1);
}
if (objApplUserGroupVO.strUserGroupID == null)
{
lngRes = m_lngAddAppUserGroup(p_objPrincipal, ref objApplUserGroupVO);
}
else
{
lngRes = m_lngSetApplUserGroup(p_objPrincipal, ref objApplUserGroupVO);
}
if (lngRes > 0)
{
if (objApplUserGroupDetailList != null)
{
for (int i = 0; i < objApplUserGroupDetailList.Length; i++)
{
objApplUserGroupDetailList[i].strUserGroupID = objApplUserGroupVO.strUserGroupID;
lngRes = m_lngAddApplUserGroupDetail(p_objPrincipal, ref objApplUserGroupDetailList[i]);
}
}
if (lngRes > 0)
{
if (objApplUserGroupRelation != null)
{
for (int i = 0; i < objApplUserGroupRelation.Length; i++)
{
objApplUserGroupRelation[i].strUserGroupID = objApplUserGroupVO.strUserGroupID;
lngRes = m_lngAddApplUserRelation(p_objPrincipal, ref objApplUserGroupRelation[i]);
}
}
}
if (lngRes > 0)
{
if (p_objParentRelation != null)
{
p_objParentRelation.strChildUserGroupID = objApplUserGroupVO.strUserGroupID;
lngRes = m_lngAddApplUserRelation(p_objPrincipal, ref p_objParentRelation);
if (lngRes > 0)
{
lngRes = m_lngUpdApplUserGroup(p_objPrincipal, "1", p_objParentRelation.strUserGroupID);
}
}
}
}
return(lngRes);
}
public long m_lngSetApplUserGroup(System.Security.Principal.IPrincipal p_objPrincipal, ref clsApplUserGroup_VO objApplUserGroupVO)
{
long lngRes = 0;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsAppGroupSvc", "m_lngSetApplUserGroup");
if (lngRes < 0)
{
return(-1);
}
string strSQL = @"UPDATE t_aid_lis_appuser_group
SET user_group_name_vchr = '" + objApplUserGroupVO.strUserGroupName + @"',
has_child_group = '" + objApplUserGroupVO.strHasChildGroup + @"',
py_code_chr = '" + objApplUserGroupVO.strPYCode + @"',
assist_code01_chr = '" + objApplUserGroupVO.strAssistCode01 + @"',
wb_code_chr = '" + objApplUserGroupVO.strWBCode + @"',
assist_code02_chr = '" + objApplUserGroupVO.strAssistCode02 + @"',
group_flag_chr = '" + objApplUserGroupVO.strGroupFlag + @"',
operator_id_chr = '" + objApplUserGroupVO.strOperatorID + @"',
summary_vchr = '" + objApplUserGroupVO.strSummary + @"'
WHERE user_group_id_chr = '" + objApplUserGroupVO.strUserGroupID + @"'";
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
lngRes = objHRPSvc.DoExcute(strSQL);
objHRPSvc.Dispose();
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
