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; }
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); } } }
public DS_TypeRef.DListDataTable GetListValueByID(int tid) { DListTableAdapter adp = new DListTableAdapter(); return adp.GetListByID(tid); }
public DS_TypeRef.DListDataTable GetAllListValue(string listClass) { DListTableAdapter adp = new DListTableAdapter(); return adp.GetList(listClass); }