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;
}
}
}
}
}
