Example #1
0
    protected string ShowPositions(object employeeID)
    {
        if (employeeID == null) return string.Empty;
        int eid = (int)employeeID;
        if (eid == 0) return string.Empty;

        if (userRolesTable == null)
        {
            userRoleTableAdapter adp = new userRoleTableAdapter();
            userRolesTable = adp.GetUserRoles();
        }
        if (positionsTable == null)
        {
            DListTableAdapter adp = new DListTableAdapter();
            positionsTable = adp.GetValidList("Position");
        }

        DataRow[] rows = userRolesTable.Select("roleType=2 and employeeID=" + eid.ToString());
        if (rows.Length > 0)
        {
            System.Text.StringBuilder sb = new System.Text.StringBuilder();
            foreach (DS_Employee.userRoleRow row in rows)
            {
                DataRow[] rr = positionsTable.Select("listValue='" + row.roleID.ToString() + "'");
                if (rr.Length > 0)
                {
                    sb.Append(rr[0]["listTitle"].ToString());
                    sb.Append(",");
                }
            }
            return sb.ToString();
        }
        else
            return string.Empty;
    }
Example #2
0
    protected void Page_PreRender(object sender, EventArgs e)
    {
        //����б���û�����ݣ������
        if (clTypes.Items.Count == 0 && _listClass!=null && _listClass!="")
        {
            DListTableAdapter adp = new DListTableAdapter();
            DS_TypeRef.DListDataTable dt = adp.GetValidList(_listClass);
            foreach (DS_TypeRef.DListRow row in dt.Rows)
            {
                ListItem item = new ListItem(row.listTitle, row.listValue);
                clTypes.Items.Add(item);
            }
        }

        //ѡ��SelectedValue�е���Ŀ
        if (_isChanged && _selectedValue != null && _selectedValue != "" && clTypes.Items.Count > 0)
        {
            string[] valList = _selectedValue.Split(',');
            for (int i = 0; i < clTypes.Items.Count; i++)
            {
                clTypes.Items[i].Selected = ValInList(clTypes.Items[i].Value, valList);
            }
        }
    }
Example #3
0
 public DS_TypeRef.DListDataTable GetListValueByID(int tid)
 {
     DListTableAdapter adp = new DListTableAdapter();
     return adp.GetListByID(tid);
 }
Example #4
0
 public DS_TypeRef.DListDataTable GetAllListValue(string listClass)
 {
     DListTableAdapter adp = new DListTableAdapter();
     return adp.GetList(listClass);
 }