public String expandBody(MssCFGenContext genContext) {
final String S_ProcName = "CFAccMssCFBindVendorUnitTenantId.expandBody() ";
if (genContext == null) {
throw CFLib.getDefaultExceptionFactory()
.newNullArgumentException(getClass(), "expandBody", 1, "genContext");
}
ICFLibAnyObj genDef = genContext.getGenDef();
if (genDef == null) {
throw CFLib.getDefaultExceptionFactory()
.newNullArgumentException(getClass(), "expandBody", 1, "genContext.getGenDef()");
}
String ret;
if (genDef instanceof ICFAccVendorUnitObj) {
long tenantId = ((ICFAccVendorUnitObj) genDef).getRequiredTenantId();
ret = Long.toString(tenantId);
} else {
throw CFLib.getDefaultExceptionFactory()
.newUnsupportedClassException(
getClass(), "expandBody", "genContext.getGenDef()", genDef, "ICFAccVendorUnitObj");
}
return (ret);
}
public CFSecurityCursor openFeeDetailCursorByFeeIdx(
CFSecurityAuthorization Authorization, long TenantId, long FeeId) {
String sql =
getSqlSelectFeeDetailBuff()
+ "WHERE "
+ "fedt.tenantid = "
+ Long.toString(TenantId)
+ " "
+ "AND "
+ "fedt.feeid = "
+ Long.toString(FeeId)
+ " "
+ "ORDER BY "
+ "fedt.TenantId ASC"
+ ", "
+ "fedt.FeeDetailId ASC";
CFAccCursor cursor = new CFAccSybaseCursor(Authorization, schema, sql);
return (cursor);
}
public CFSecurityCursor openMemoDataCursorByMemoDataCtcIdx(
CFSecurityAuthorization Authorization, long TenantId, long ContactId) {
String sql =
getSqlSelectMemoDataBuff()
+ " WHERE "
+ "mmod.tenantid = "
+ Long.toString(TenantId)
+ " "
+ "AND "
+ "mmod.contactid = "
+ Long.toString(ContactId)
+ " "
+ "ORDER BY "
+ "mmod.TenantId ASC"
+ ", "
+ "mmod.MemoId ASC";
CFCrmCursor cursor = new CFCrmMSSqlCursor(Authorization, schema, sql);
return (cursor);
}
public CFSecurityCursor openTSecGroupCursorByTenantIdx(
CFSecurityAuthorization Authorization, long TenantId) {
String sql =
getSqlSelectTSecGroupBuff()
+ "WHERE "
+ "tgrp.tenantid = "
+ Long.toString(TenantId)
+ " "
+ "ORDER BY "
+ "tgrp.TenantId ASC"
+ ", "
+ "tgrp.TSecGroupId ASC";
CFCrmCursor cursor = new CFCrmSybaseCursor(Authorization, schema, sql);
return (cursor);
}
public CFSecurityCursor openTSecGroupCursorByTenantVisIdx(
CFSecurityAuthorization Authorization, long TenantId, boolean IsVisible) {
String sql =
getSqlSelectTSecGroupBuff()
+ "WHERE "
+ "tgrp.tenantid = "
+ Long.toString(TenantId)
+ " "
+ "AND "
+ (IsVisible ? "tgrp.isvisible = 'Y' " : "tgrp.isvisible = 'N' ")
+ "ORDER BY "
+ "tgrp.TenantId ASC"
+ ", "
+ "tgrp.TSecGroupId ASC";
CFCrmCursor cursor = new CFCrmSybaseCursor(Authorization, schema, sql);
return (cursor);
}
public CFSecurityCursor openContactListCursorByTenantIdx(
CFSecurityAuthorization Authorization, long TenantId) {
String sql =
getSqlSelectContactListBuff()
+ "WHERE "
+ "ctl.TenantId = "
+ Long.toString(TenantId)
+ " "
+ ((schema.isSystemUser(Authorization))
? ""
: (" AND ctl.TenantId = " + Authorization.getSecTenantId()))
+ "ORDER BY "
+ "ctl.TenantId ASC"
+ ", "
+ "ctl.ContactListId ASC";
CFCrmCursor cursor = new CFCrmPgSqlCursor(Authorization, schema, sql);
return (cursor);
}