本帖最后由 gan8281 于 2016-12-5 11:56 编辑
1、我删除了两张表对应的记录,再添加上去,共3条。
2、“--初始化组织结构---------------------------------------------------------------------------------
insert into SA_OPOrg (sID, sName, sCode, sLongName, sFName, sFCode, sFID, sOrgKindID, sSequence, sValidState, sParent, sLevel, sPhone, sFax, sAddress, sZip, sDescription, version)
values ('ORG01', '起步软件', 'JUSTEP', '北京起步科技有限公司', '/起步软件', '/JUSTEP', '/ORG01.ogn', 'ogn', '/001', 1, null, 1, '59798677', '010-67678151', '北京方庄芳群园四区22号金城中心10层', '100078', '北京起步科技有限公司', 0);
insert into SA_OPPerson (sID, sName, sCode, sNumb, sLoginName, sPassword, sMainOrgID, sSafeLevelID, sSequence, sValidState, sDescription, sSex, sBirthday, sJoinDate, sHomePlace, sDegree, sGraduateSchool, sSpeciality, sSchoolLength, sTitle, sMarriage, sCardNO, sCardKind, sFamilyAddress, sZip, sMsn, sQQ, sMail, sMobilePhone, sFamilyPhone, sOfficePhone, version, sPhoto)
values ('PSN01', 'system', 'SYSTEM', 1, 'SYSTEM', 'F3D3A7EF80A1E7BDA2511A3A0B7E6CF8', 'ORG01', null, 1, 1, null, '男', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 0, null);
insert into SA_OPOrg (sID, sName, sCode, sLongName, sFName, sFCode, sFID, sOrgKindID, sSequence, sValidState, sParent, sLevel, sPhone, sFax, sAddress, sZip, sDescription, sPersonID, version, sNodeKind)
values ('PSN01@ORG01', 'system', 'SYSTEM', null, '/起步软件/system', '/JUSTEP/SYSTEM', '/ORG01.ogn/PSN01@ORG01.psm', 'psm', '/001/001', 1, 'ORG01', 1, null, null, null, null, null, 'PSN01', 0, 'nkLeaf');”
3、但我现在用system登陆后,组织权限只有个人委托代理。而且原来帅哥头像,变成一个大叔 |