private void loadInit() throws Exception {
KDBizPromptBox kdtEntries_accountView_PromptBox = new KDBizPromptBox();
kdtEntries_accountView_PromptBox
.setQueryInfo("com.kingdee.eas.basedata.org.app.AdminOrgUnitQuery");
EntityViewInfo evi1 = new EntityViewInfo();
FilterInfo filterInfo1 = new FilterInfo();
OrgUnitInfo Org = SysContext.getSysContext().getCurrentOrgUnit();
String strControlUnitID = Org.getId().toString();
filterInfo1
.getFilterItems()
.add(
new FilterItemInfo(
"id",
"select FID from T_ORG_ADMIN where fiscompanyorgunit=0 ",
CompareType.INNER));
evi1.setFilter(filterInfo1);
kdtEntries_accountView_PromptBox.setEntityViewInfo(evi1);
KDTDefaultCellEditor kdtEntries_accountView_CellEditor = new KDTDefaultCellEditor(
kdtEntries_accountView_PromptBox);
if ((getOprtState().equals(OprtState.ADDNEW))
|| (getOprtState().equals(OprtState.EDIT))) {
this.pkBizDate.setValue(new Date());
String fempid = "";
String fposid = "";
String fdeptid = "";
String fcompid = "";
String fcostcenterid = "";
this.prmtCreator.setValue(SysContext.getSysContext()
.getCurrentUserInfo());
String strSql = "";
strSql = "select a.FID as fempid, c.FID as fposid, d.FID as fdeptid, d.FControlUnitID as fcompid from T_BD_Person a left join T_ORG_PositionMember b on a.FID = b.FPersonID left join T_ORG_Position c on b.FPositionID = c.FID left join T_ORG_Admin d on c.FAdminOrgUnitID = d.FID left join T_PM_User e on a.FID = e.FPersonId where e.FNumber = '"
+
this.prmtCreator.getValue().toString() + "' and d.FControlUnitID='"+strControlUnitID+"' ";
IRowSet rs = SQLExecutorFactory.getRemoteInstance(strSql)
.executeSQL();
while (rs.next()) {
fempid = rs.getString("fempid");
fposid = rs.getString("fposid");
fdeptid = rs.getString("fdeptid");
fcompid = rs.getString("fcompid");
IPerson iEmp = PersonFactory.getRemoteInstance();
IPosition iPos = PositionFactory.getRemoteInstance();
IAdminOrgUnit iDept = AdminOrgUnitFactory.getRemoteInstance();
IAdminOrgUnit iComp = AdminOrgUnitFactory.getRemoteInstance();
ICostCenterOrgUnit iCostCenter = CostCenterOrgUnitFactory
.getRemoteInstance();
if (!fempid.equals("")) {
ObjectUuidPK pk = new ObjectUuidPK(BOSUuid.read(fempid));
this.prmtAPPEmp.setValue(iEmp.getValue(pk));
EntityViewInfo evi = new EntityViewInfo();
FilterInfo filterInfo = new FilterInfo();
filterInfo
.getFilterItems()
.add(
new FilterItemInfo(
"id",
"select c.FID from T_BD_Person a left join T_ORG_PositionMember b on a.FID = b.FPersonID left join T_ORG_Position c on b.FPositionID = c.FID left join T_ORG_Admin d on c.FAdminOrgUnitID = d.FID left join T_PM_User e on a.FID = e.FPersonId where e.FNumber = '"
+
this.prmtCreator.getValue()
.toString() + "' ",
CompareType.INNER));
evi.setFilter(filterInfo);
this.prmtAPPDuty.setEntityViewInfo(evi);
}
if (!fposid.equals("")) {
ObjectUuidPK pk = new ObjectUuidPK(BOSUuid.read(fposid));
this.prmtAPPDuty.setValue(iPos.getValue(pk));
EntityViewInfo evi = new EntityViewInfo();
FilterInfo filterInfo = new FilterInfo();
filterInfo
.getFilterItems()
.add(
new FilterItemInfo(
"id",
"select d.FID from T_BD_Person a left join T_ORG_PositionMember b on a.FID = b.FPersonID left join T_ORG_Position c on b.FPositionID = c.FID left join T_ORG_Admin d on c.FAdminOrgUnitID = d.FID left join T_PM_User e on a.FID = e.FPersonId where e.FNumber = '"
+
this.prmtCreator.getValue()
.toString() + "' ",
CompareType.INNER));
evi.setFilter(filterInfo);
this.prmtAPPDept.setEntityViewInfo(evi);
}
if (!fdeptid.equals("")) {
ObjectUuidPK pk = new ObjectUuidPK(BOSUuid.read(fdeptid));
this.prmtAPPDept.setValue(iDept.getValue(pk));
EntityViewInfo evi = new EntityViewInfo();
FilterInfo filterInfo = new FilterInfo();
filterInfo
.getFilterItems()
.add(
new FilterItemInfo(
"id",
"select d.FControlUnitID from T_BD_Person a left join T_ORG_PositionMember b on a.FID = b.FPersonID left join T_ORG_Position c on b.FPositionID = c.FID left join T_ORG_Admin d on c.FAdminOrgUnitID = d.FID left join T_PM_User e on a.FID = e.FPersonId where e.FNumber = '"
+
this.prmtCreator.getValue()
.toString() + "' ",
CompareType.INNER));
evi.setFilter(filterInfo);
this.prmtAPPCompany.setEntityViewInfo(evi);
}
if (!fcompid.equals("")) {
ObjectUuidPK pk = new ObjectUuidPK(BOSUuid.read(fcompid));
this.prmtAPPCompany.setValue(iComp.getValue(pk));
}
}
}
}