private List<cls_Module_Authority_Employee> getList(DataTable dt, short moduleId)
{
try
{
List<cls_Module_Authority_Employee> list = new List<cls_Module_Authority_Employee>();
cls_Module_Authority_Employee aEmp = new cls_Module_Authority_Employee();
aEmp.EmployeeId = Convert.ToInt32(Session["UserId"]);
DataTable dtAuthority = aEmp.GetByModuleCode(ConfigurationSettings.AppSettings["Emp_Module"]);
for (int i = 0; i < dtAuthority.Rows.Count; i++)
{
aEmp = new cls_Module_Authority_Employee();
aEmp.Company = "";
aEmp.Department = "";
DataRow[] _Row = dt.Select("AuthorityId=" + dtAuthority.Rows[i]["Id"].ToString());
for (int j = 0; j < _Row.Count(); j++)
{
aEmp.Company += _Row[j]["CompanyId"].ToString() + ";";
aEmp.Department += _Row[j]["DepartmentId"].ToString() + ";";
}
aEmp.Company = aEmp.Company.Substring(0, aEmp.Company.Length - 1);
aEmp.Department = aEmp.Department.Substring(0, aEmp.Department.Length - 1);
if (aEmp.Company == "0") aEmp.Company = "";
if (aEmp.Department == "0") aEmp.Department = "";
aEmp.AuthorityId = Convert.ToInt16(_Row[0]["AuthorityId"]);
aEmp.AuthorityName = _Row[0]["AuthorityName"].ToString();
aEmp.ModuleId = moduleId;
aEmp.IsUse = Convert.ToInt16(_Row[0]["IsUse"]);
aEmp.UseDepartment = Convert.ToInt16(_Row[0]["UseDepartment"]);
list.Add(aEmp);
}
return list;
}
catch (Exception ex)
{
return null;
}
}
private void bindPermissionList()
{
try
{
// --- BIND CAC NHOM DA DUOC PHAN QUYEN ---
// --- LAY DANH SACH CAC QUYEN CUA NGUOI DUNG HIEN TAI DUOC PHAN ---
cls_Module_Authority_Employee aEmp = new cls_Module_Authority_Employee();
aEmp.EmployeeId = Convert.ToInt32(Session["UserId"]);
DataTable dtAuthority = aEmp.GetByModuleCode(ConfigurationSettings.AppSettings["Emp_Module"]);
StringBuilder sb = new StringBuilder();
sb.Append(" <table class=\"basic-table\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\">" +
" <tbody><tr>" +
" <td>" +
" <table class=\"form-table\" border=\"0\" cellpadding=\"4\"><tbody>" +
" <tr class=\"gray\">" +
" <td colspan=\"" + dtAuthority.Rows.Count.ToString() + "\">PHÂN QUYỀN NHÓM NGƯỜI DÙNG</td>" +
" <td align=\"right\" colspan=\"2\"><a href=\"Permission.aspx?P_action=2\">+Bổ sung</a></td>" +
" </tr>" +
" <tr bgcolor=\"whitesmoke\">" +
" <td class=\"Normal\" width=\"180px\"> <u>Nhóm đã phân quyền </u></td>");
for (int i = 0; i < dtAuthority.Rows.Count; i++)
{
sb.Append(" <td class=\"NormalBold\" align=\"center\">Quyền " + dtAuthority.Rows[i]["AuthorityName"].ToString() + "</td>");
}
sb.Append(" <td class=\"normal\">Cập nhật</td>" +
" </tr>");
cls_Module_Authority_Group aGroup = new cls_Module_Authority_Group();
aGroup.CompanyId = Convert.ToInt16(ddlCompany.SelectedValue);
DataTable dtGroup = aGroup.SelectGroupByCompany(ConfigurationSettings.AppSettings["Emp_Module"]);
if (dtGroup.Rows.Count > 0)
{
DataTable dtGAuthority = aGroup.SelectByCompany(ConfigurationSettings.AppSettings["Emp_Module"], Convert.ToInt32(Session["UserId"]));
for (int i = 0; i < dtGroup.Rows.Count; i++)
{
DataRow[] _Row = dtGAuthority.Select("GroupId=" + dtGroup.Rows[i]["GroupId"].ToString(), "AuthorityCode asc");
sb.Append("<tr>" +
" <td class=\"NormalBold\"><img src=\"../images/Message/user-group.png\" /> " + _Row[0]["GroupName"].ToString() + "</td>");
for (int j = 0; j < _Row.Count(); j++)
{
if (_Row[j]["IsUse"].ToString() == "1")
sb.Append(" <Td class=\"normal\" align=\"center\"><img src=\"../images/Update.gif\" align=\"absmiddle\"> </td>");
else
sb.Append(" <Td class=\"normal\" align=\"center\"> </td>");
}
sb.Append(" <td class=\"normal\" align=\"center\"><a href=\"Permission.aspx?P_action=2&G_Id=" + dtGroup.Rows[i]["GroupId"].ToString() + "\">Sửa</a></td>" +
"</tr>");
}
}
else
{
sb.Append("<tr><td class=\"NormalBold\" align=\"center\" colspan=\"" + (dtAuthority.Rows.Count + 2).ToString() + "\"><i>Hiện chưa có nhóm nào được phân quyền.</i></td></tr>");
}
sb.Append(" </tbody>" +
" </table>" +
" </td>" +
" </tr>" +
"</tbody></table>");
ltlListGroup.Text = sb.ToString();
// --- BIND CAC NGUOI DUNG DA DUOC PHAN QUYEN ---
sb = new StringBuilder();
sb.Append(" <table class=\"basic-table\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\">" +
" <tbody><tr>" +
" <td>" +
" <table class=\"form-table\" border=\"0\" cellpadding=\"4\"><tbody>" +
" <tr class=\"gray\">" +
" <td colspan=\"" + dtAuthority.Rows.Count.ToString() + "\">PHÂN QUYỀN NGƯỜI DÙNG</td>" +
" <td align=\"right\" colspan=\"2\"><a href=\"Permission.aspx?P_action=3\">+Bổ sung</a></td>" +
" </tr>" +
" <tr bgcolor=\"whitesmoke\">" +
" <td class=\"Normal\" width=\"180px\"><u>Người dùng đã phân quyền </u></td>");
for (int i = 0; i < dtAuthority.Rows.Count; i++)
{
sb.Append(" <td class=\"NormalBold\" align=\"center\">Quyền " + dtAuthority.Rows[i]["AuthorityName"].ToString() + "</td>");
}
sb.Append(" <td class=\"normal\">Cập nhật</td>" +
" </tr>");
aEmp = new cls_Module_Authority_Employee();
aEmp.EmployeeId = Convert.ToInt32(Session["UserId"]);
aEmp.CompanyId = Convert.ToInt16(ddlCompany.SelectedValue);
DataTable dtEmp = aEmp.SelectEmpByCompany(ConfigurationSettings.AppSettings["Emp_Module"]);
if (dtEmp.Rows.Count > 0)
{
DataTable dtEAuthority = aEmp.SelectByCompany(ConfigurationSettings.AppSettings["Emp_Module"]);
for (int i = 0; i < dtEmp.Rows.Count; i++)
{
DataRow[] _Row = dtEAuthority.Select("EmployeeId=" + dtEmp.Rows[i]["EmployeeId"].ToString(), "AuthorityCode asc");
sb.Append("<tr>" +
" <td class=\"NormalBold\"><img src=\"../images/MRoom/user.gif\" /> " + _Row[0]["EmployName"].ToString() + "</td>");
for (int j = 0; j < _Row.Count(); j++)
{
if (_Row[j]["IsUse"].ToString() == "1")
sb.Append(" <Td class=\"normal\" align=\"center\"><img src=\"../images/Update.gif\" align=\"absmiddle\"> </td>");
else
sb.Append(" <Td class=\"normal\" align=\"center\"> </td>");
}
sb.Append(" <td class=\"normal\" align=\"center\"><a href=\"Permission.aspx?P_action=3&E_Id=" + dtEmp.Rows[i]["EmployeeId"].ToString() + "\">Sửa</a></td>" +
"</tr>");
}
}
else
{
sb.Append("<tr><td class=\"NormalBold\" align=\"center\" colspan=\"" + (dtAuthority.Rows.Count + 2).ToString() + "\"><i>Hiện chưa có người dùng nào được phân quyền.</i></td></tr>");
}
sb.Append(" </tbody>" +
" </table>" +
" </td>" +
" </tr>" +
"</tbody></table>");
ltlListEmployee.Text = sb.ToString();
}
catch (Exception ex)
{
}
}
