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 lstPositions_RowDataBound(object sender, GridViewRowEventArgs e) { if (userRolesTable == null) { userRoleTableAdapter adp = new userRoleTableAdapter(); userRolesTable = adp.GetRolesByEmployeeID(PageTools.ParseInt(Request.QueryString["id"])); } GridViewRow row = e.Row; if (row.RowType == DataControlRowType.DataRow) { int roleID = PageTools.ParseInt(DataBinder.Eval(row.DataItem, "listValue").ToString()); if (roleID > 0 && userRolesTable.Rows.Count > 0) { DataRow[] rows = userRolesTable.Select("roleType=2 and roleID=" + roleID.ToString()); if (rows.Length > 0) { CheckBox cb = row.FindControl("CheckBox1") as CheckBox; if (cb != null) { cb.Checked = true; } } } } }