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_lngAddReportGroup(System.Security.Principal.IPrincipal p_objPrincipal, ref clsReportGroup_VO objReportGroupVO)
{
long lngRes = 0;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsCheckGroupSvc", "m_lngAddReportGroup");
if (lngRes < 0)
{
return(-1);
}
string strSQL = @"INSERT INTO t_aid_lis_report_group
(report_group_id_chr, report_group_name_vchr, py_code_chr,
print_title_vchr, wb_code_chr, assist_code01_chr,
assist_code02_chr, print_category_id_chr
)
VALUES (?, ?, ?, ?, ?, ?, ?, ?)" ;
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
System.Data.IDataParameter[] objReportGroupArr = null;
objHRPSvc.CreateDatabaseParameter(8, out objReportGroupArr);
if (objReportGroupVO.strReportGroupID == null)
{
objReportGroupVO.strReportGroupID = objHRPSvc.m_strGetNewID("t_aid_lis_report_group", "REPORT_GROUP_ID_CHR", 6);
}
objReportGroupArr[0].Value = objReportGroupVO.strReportGroupID;
objReportGroupArr[1].Value = objReportGroupVO.strReportGroupName;
objReportGroupArr[2].Value = objReportGroupVO.strPYCode;
objReportGroupArr[3].Value = objReportGroupVO.strPrintTitle;
objReportGroupArr[4].Value = objReportGroupVO.strWBCode;
objReportGroupArr[5].Value = objReportGroupVO.strAssistCode01;
objReportGroupArr[6].Value = objReportGroupVO.strAssistCode02;
objReportGroupArr[7].Value = objReportGroupVO.strPrintCategoryID;
long lngRecEff = -1;
lngRes = objHRPSvc.lngExecuteParameterSQL(strSQL, ref lngRecEff, objReportGroupArr);
objHRPSvc.Dispose();
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_lngAddApplUnit(System.Security.Principal.IPrincipal p_objPrincipal, ref clsApplUnit_VO objApplUnitVO)
{
long lngRes = 0;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsApplyUnitSvc", "m_lngAddApplyUnit");
if (lngRes < 0)
{
return(-1);
}
string strSQL = @"INSERT INTO t_aid_lis_apply_unit
(apply_unit_id_chr, apply_unit_name_vchr, other_name_vchr,
py_code_chr, assist_code01_chr, wb_code_chr, assist_code02_chr,
check_category_id_chr, is_no_food_required_chr,
is_physical_exam_required_chr,is_reservation_required_chr,
PRICE_NUM,COST_NUM,SAMPLE_TYPE_ID_CHR,SUMMARY_VCHR,OUTER_CHECK_FLAG_NUM, REPORTHOUR, SamplingInstr
)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,?,?,?, ?, ?)" ;
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
System.Data.IDataParameter[] objApplUnitArr = null;
objHRPSvc.CreateDatabaseParameter(18, out objApplUnitArr);
if (objApplUnitVO.strApplUnitID == null)
{
objApplUnitVO.strApplUnitID = objHRPSvc.m_strGetNewID("t_aid_lis_apply_unit", "apply_unit_id_chr", 6);
}
objApplUnitArr[0].Value = objApplUnitVO.strApplUnitID;
objApplUnitArr[1].Value = objApplUnitVO.strApplUnitName;
objApplUnitArr[2].Value = objApplUnitVO.strOtherName;
objApplUnitArr[3].Value = objApplUnitVO.strPYCode;
objApplUnitArr[4].Value = objApplUnitVO.strAssistCode01;
objApplUnitArr[5].Value = objApplUnitVO.strWBCode;
objApplUnitArr[6].Value = objApplUnitVO.strAssistCode02;
objApplUnitArr[7].Value = objApplUnitVO.strCheckCategoryID;
objApplUnitArr[8].Value = objApplUnitVO.strIsNoFoodRequired;
objApplUnitArr[9].Value = objApplUnitVO.strIsPhysicsExamRequired;
objApplUnitArr[10].Value = objApplUnitVO.strIsReservationRequired;
objApplUnitArr[11].Value = objApplUnitVO.strPrice;
objApplUnitArr[12].Value = objApplUnitVO.strCost;
objApplUnitArr[13].Value = objApplUnitVO.strSampleTypeID;
objApplUnitArr[14].Value = objApplUnitVO.strSummary;
objApplUnitArr[15].Value = objApplUnitVO.strOutCheckFlag;
objApplUnitArr[16].Value = objApplUnitVO.ReportHour;
objApplUnitArr[17].Value = objApplUnitVO.SamplingInstr;
long lngRecEff = -1;
lngRes = objHRPSvc.lngExecuteParameterSQL(strSQL, ref lngRecEff, objApplUnitArr);
objHRPSvc.Dispose();
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
