public DataTable GetParentChildrenStaffs(string organizeId)
{
string[] organizeIds = null;
PiOrganizeManager organizeManager = new PiOrganizeManager(this.DBProvider, this.UserInfo);
string organizeCode = organizeManager.GetCodeById(organizeId);
organizeIds = organizeManager.GetChildrensIdByCode(PiOrganizeTable.FieldCode, organizeCode);
return(this.GetDTByOrganizes(organizeIds));
}
public DataTable GetChildrenUsers(string organizeId)
{
string[] organizeIds = null;
var organizeManager = new PiOrganizeManager(this.DBProvider, this.UserInfo);
switch (DBProvider.CurrentDbType)
{
case CurrentDbType.Access:
case CurrentDbType.SqlServer:
var organizeCode = this.GetCodeById(organizeId);
organizeIds = organizeManager.GetChildrensIdByCode(PiOrganizeTable.FieldCode, organizeCode);
break;
case CurrentDbType.Oracle:
organizeIds = organizeManager.GetChildrensId(PiOrganizeTable.FieldId, organizeId, PiOrganizeTable.FieldParentId);
break;
}
return(this.GetDTByOrganizes(organizeIds));
}
public List <PiUserEntity> GetChildrenUserList(string organizeId)
{
string[] organizeIds = null;
var manager = new PiOrganizeManager(base.DBProvider, base.UserInfo);
switch (base.DBProvider.CurrentDbType)
{
case CurrentDbType.Oracle:
organizeIds = manager.GetChildrensId(PiOrganizeTable.FieldId, organizeId, PiOrganizeTable.FieldParentId);
break;
case CurrentDbType.SqlServer:
case CurrentDbType.Access:
{
string codeById = manager.GetCodeById(organizeId);
organizeIds = manager.GetChildrensIdByCode(PiOrganizeTable.FieldCode, codeById);
break;
}
}
return(this.GetListByOrganizes(organizeIds));
}
public DataTable GetChildrenStaffs(string organizeId)
{
PiOrganizeManager organizeManager = new PiOrganizeManager(this.DBProvider, this.UserInfo);
string[] organizeIds = null;
switch (DBProvider.CurrentDbType)
{
case CurrentDbType.Access:
case CurrentDbType.SqlServer:
string organizeCode = DbCommonLibary.GetProperty(dbProvider, PiOrganizeTable.TableName, PiOrganizeTable.FieldId, organizeId, PiOrganizeTable.FieldCode); //this.GetCodeById(organizeId);
organizeIds = organizeManager.GetChildrensIdByCode(PiOrganizeTable.FieldCode, organizeCode);
break;
case CurrentDbType.Oracle:
organizeIds = organizeManager.GetChildrensId(PiOrganizeTable.FieldId, organizeId, PiOrganizeTable.FieldParentId);
break;
case CurrentDbType.MySql:
organizeIds = organizeManager.GetMySqlChildrensId(PiOrganizeTable.FieldId, organizeId, PiOrganizeTable.FieldParentId);
break;
}
return(this.GetDTByOrganizes(organizeIds));
}