/// <summary>
/// 读取人员隶属组
/// </summary>
/// <param name="employeeId"></param>
/// <returns></returns>
public DataTable get_Employee_GetGroups(int employeeId)
{
string strWhere_1 = Tables.base_user.EMPLOYEE_ID + OleDB.EuqalTo( ) + employeeId.ToString( );
string childtable_1 = OleDB.ChildTable(Tables.BASE_USER, "", strWhere_1, Tables.base_user.USER_ID);
string strWhere_2 = Tables.base_group_user.USER_ID + OleDB.In( ) + childtable_1;
string childtable_2 = OleDB.ChildTable(Tables.BASE_GROUP_USER, "", strWhere_2, Tables.base_group_user.GROUP_ID);
string strWhere_3 = Tables.base_group.GROUP_ID + OleDB.In( ) + childtable_2;
string strsql = OleDB.Table(Tables.BASE_GROUP, "", strWhere_3, Tables.base_group.GROUP_ID, Tables.base_group.NAME);
//string sql = "select group_id,name from base_group where group_id in ( select group_id from base_group_user where user_id in (select user_id from base_user where employee_id=" + employeeId + "))";
return(GetDataTable(strsql));
}
