//private void SaveGridMenuPermission(DataGrid Dtgrid, string rateName)
//{
// if (Dtgrid.ItemsSource != null)
// {
// foreach (object obj in Dtgrid.ItemsSource)
// {
// //T_SYS_ENTITYMENU menu = new T_SYS_ENTITYMENU();
// if (Dtgrid.Columns[0].GetCellContent(obj) != null)
// {
// //menu = Dtgrid.Columns[0].GetCellContent(obj).DataContext as T_SYS_ENTITYMENU;
// //tmpAllList += menu.T_SYS_ENTITYMENU2.ENTITYMENUID + ",";
// string StrMenuID = ""; //菜单ID
// menu = Dtgrid.Columns[0].GetCellContent(obj).DataContext as T_SYS_ENTITYMENU;
// StrMenuID = menu.ENTITYMENUID;
// string StrPermissionID = "";//权限ID
// int PermCount = 0;
// PermCount = tmpPermission.Count;
// int IndexCount = 1;
// //IndexCount = PermCount
// bool IsCheckRange = false;//是否选择了权限范围
// for (int i = 1; i < PermCount + 1; i++)
// {
// IndexCount = IndexCount + i;
// if (Dtgrid.Columns[i].GetCellContent(obj) != null)
// {
// string NewDataRange = "";
// /*
// * 首先根据菜单ID和角色ID获取 角色菜单表的记录 存在则获取ROLEENTITYID
// * 然后再根据 ROLEENTITYID和权限ID 获取角色菜单权限表中的记录，取得对应的权限和现在的权限值比较
// * 如果相同则不处理 不同则处理
// */
// StrPermissionID = tmpPermission[i - 1].PERMISSIONID; //权限ID
// var q = from a in EntityPermissionInfosList//权限视图集合
// where a.EntityRole.T_SYS_ENTITYMENU.ENTITYMENUID == StrMenuID
// && a.EntityRole.T_SYS_ROLE.ROLEID == tmprole.ROLEID
// select a;
// string RoleEntityID = "";
// if (q.Count() > 0)
// {
// RoleEntityID = q.ToList().FirstOrDefault().EntityRole.ROLEENTITYMENUID.ToString(); //获取角色菜单ID
// }
// //var m = from a in EntityPermissionInfosList
// var k = from b in EntityPermissionInfosList//权限视图集合
// where b.RoleMenuPermission.T_SYS_PERMISSION.PERMISSIONID == StrPermissionID && b.RoleMenuPermission.T_SYS_ROLEENTITYMENU.ROLEENTITYMENUID == RoleEntityID
// select b;
// string OldRangeValue = ""; //获取数据库中 权限对应的值
// if (k.Count() > 0)
// {
// OldRangeValue = k.ToList().FirstOrDefault().RoleMenuPermission.DATARANGE.ToString();
// }
// //Rating hrrate = DaGrHR.Columns[i].GetCellContent(obj).FindName("HRrating") as Rating;
// Button hrrate = Dtgrid.Columns[i].GetCellContent(obj).FindName(rateName) as Button;
// switch (hrrate.Content.ToString())
// {
// case "★"://员工 0.2 ×10
// NewDataRange = "4";
// break;
// case "★★"://岗位 0.4×10
// NewDataRange = "3";
// break;
// case "★★★"://部门 0.6*10
// NewDataRange = "2";
// break;
// case "★★★★"://公司 0.8*10
// NewDataRange = "1";
// break;
// //case "★★★★★"://集团 1.0*10
// // NewDataRange = "0";
// // break;
// case ""://权限
// NewDataRange = "";
// break;
// }
// if (OldRangeValue != NewDataRange)
// {
// tmpAllList += NewDataRange + ",";
// tmpAllList += tmpPermission[i - 1].PERMISSIONID + ";";
// IsCheckRange = true;
// }
// }
// }
// if (IsCheckRange)
// {
// tmpAllList += "@" + StrMenuID + "," + "";
// tmpAllList += "#";
// }
// }
// }
// if (IsAdd)
// {
// if (string.IsNullOrEmpty(tmpAllList))
// {
// ComfirmWindow.ConfirmationBox(Utility.GetResourceStr("CONFIRMINFO"), "请先设置权限", Utility.GetResourceStr("CONFIRMBUTTON"));
// return;
// }
// }
// }
//}
private void SaveGridMenuPermission(DataGrid Dtgrid, string rateName)
{
if (Dtgrid.ItemsSource != null)
{
foreach (object obj in Dtgrid.ItemsSource)
{
//T_SYS_ENTITYMENU menu = new T_SYS_ENTITYMENU();
if (Dtgrid.Columns[0].GetCellContent(obj) != null)
{
//menu = Dtgrid.Columns[0].GetCellContent(obj).DataContext as T_SYS_ENTITYMENU;
//tmpAllList += menu.T_SYS_ENTITYMENU2.ENTITYMENUID + ",";
string StrMenuID = ""; //菜单ID
menu = Dtgrid.Columns[0].GetCellContent(obj).DataContext as V_MenuSetRole;
StrMenuID = menu.ENTITYMENUID;
string StrPermissionID = "";//权限ID
int PermCount = 0;
PermCount = tmpPermission.Count;
int IndexCount = 1;
//IndexCount = PermCount
bool IsCheckRange = false;//是否选择了权限范围
for (int i = 1; i < PermCount + 1; i++)
{
IndexCount = IndexCount + i;
if (Dtgrid.Columns[i].GetCellContent(obj) != null)
{
string NewDataRange = "";
/*
* 首先根据菜单ID和角色ID获取 角色菜单表的记录 存在则获取ROLEENTITYID
* 然后再根据 ROLEENTITYID和权限ID 获取角色菜单权限表中的记录，取得对应的权限和现在的权限值比较
* 如果相同则不处理 不同则处理
*/
StrPermissionID = tmpPermission[i - 1].PERMISSIONID; //权限ID
//var q = from a in EntityPermissionInfosList//权限视图集合
// where a.EntityRole.T_SYS_ENTITYMENU.ENTITYMENUID == StrMenuID
// && a.EntityRole.T_SYS_ROLE.ROLEID == tmprole.ROLEID
// select a;
var q = from a in EntityPermissionInfosListSecond//权限视图集合
where a.EntityMenuID == StrMenuID
&& a.RoleID == tmprole.ROLEID
select a;
string RoleEntityID = "";
if (q.Count() > 0)
{
RoleEntityID = q.ToList().FirstOrDefault().RoleEntityMenuID.ToString(); //获取角色菜单ID
}
//var m = from a in EntityPermissionInfosList
//var k = from b in EntityPermissionInfosList//权限视图集合
// where b.RoleMenuPermission.T_SYS_PERMISSION.PERMISSIONID == StrPermissionID && b.RoleMenuPermission.T_SYS_ROLEENTITYMENU.ROLEENTITYMENUID == RoleEntityID
// select b;
var k = from b in EntityPermissionInfosListSecond//权限视图集合
where b.PermissionID == StrPermissionID && b.RoleEntityMenuID == RoleEntityID
select b;
string OldRangeValue = ""; //获取数据库中 权限对应的值
if (k.Count() > 0)
{
OldRangeValue = k.ToList().FirstOrDefault().PermissionDataRange.ToString();
}
//Rating hrrate = DaGrHR.Columns[i].GetCellContent(obj).FindName("HRrating") as Rating;
Button hrrate = Dtgrid.Columns[i].GetCellContent(obj).FindName(rateName) as Button;
switch (hrrate.Content.ToString())
{
case "★"://员工 0.2 ×10
NewDataRange = "4";
break;
case "★★"://岗位 0.4×10
NewDataRange = "3";
break;
case "★★★"://部门 0.6*10
NewDataRange = "2";
break;
case "★★★★"://公司 0.8*10
NewDataRange = "1";
break;
//case "★★★★★"://集团 1.0*10
// NewDataRange = "0";
// break;
case ""://权限
NewDataRange = "";
break;
}
if (OldRangeValue != NewDataRange)
{
tmpAllList += NewDataRange + ",";
tmpAllList += tmpPermission[i - 1].PERMISSIONID + ";";
IsCheckRange = true;
}
}
}
if (IsCheckRange)
{
tmpAllList += "@" + StrMenuID + "," + "";
tmpAllList += "#";
}
}
}
if (IsAdd)
{
if (string.IsNullOrEmpty(tmpAllList))
{
ComfirmWindow.ConfirmationBox(Utility.GetResourceStr("CONFIRMINFO"), "请先设置权限", Utility.GetResourceStr("CONFIRMBUTTON"));
RefreshUI(RefreshedTypes.HideProgressBar);
return;
}
}
}
}
//private void SaveGridMenuPermission(DataGrid Dtgrid, string rateName)
//{
// if (Dtgrid.ItemsSource != null)
// {
// foreach (object obj in Dtgrid.ItemsSource)
// {
// //T_SYS_ENTITYMENU menu = new T_SYS_ENTITYMENU();
// if (Dtgrid.Columns[0].GetCellContent(obj) != null)
// {
// //menu = Dtgrid.Columns[0].GetCellContent(obj).DataContext as T_SYS_ENTITYMENU;
// //tmpAllList += menu.T_SYS_ENTITYMENU2.ENTITYMENUID + ",";
// string StrMenuID = ""; //菜单ID
// menu = Dtgrid.Columns[0].GetCellContent(obj).DataContext as T_SYS_ENTITYMENU;
// StrMenuID = menu.ENTITYMENUID;
// string StrPermissionID = "";//权限ID
// int PermCount = 0;
// PermCount = tmpPermission.Count;
// int IndexCount = 1;
// //IndexCount = PermCount
// bool IsCheckRange = false;//是否选择了权限范围
// for (int i = 1; i < PermCount + 1; i++)
// {
// IndexCount = IndexCount + i;
// if (Dtgrid.Columns[i].GetCellContent(obj) != null)
// {
// string NewDataRange = "";
// /*
// * 首先根据菜单ID和角色ID获取 角色菜单表的记录 存在则获取ROLEENTITYID
// * 然后再根据 ROLEENTITYID和权限ID 获取角色菜单权限表中的记录，取得对应的权限和现在的权限值比较
// * 如果相同则不处理 不同则处理
// */
// StrPermissionID = tmpPermission[i - 1].PERMISSIONID; //权限ID
// var q = from a in EntityPermissionInfosList//权限视图集合
// where a.EntityRole.T_SYS_ENTITYMENU.ENTITYMENUID == StrMenuID
// && a.EntityRole.T_SYS_ROLE.ROLEID == tmprole.ROLEID
// select a;
// string RoleEntityID = "";
// if (q.Count() > 0)
// {
// RoleEntityID = q.ToList().FirstOrDefault().EntityRole.ROLEENTITYMENUID.ToString(); //获取角色菜单ID
// }
// //var m = from a in EntityPermissionInfosList
// var k = from b in EntityPermissionInfosList//权限视图集合
// where b.RoleMenuPermission.T_SYS_PERMISSION.PERMISSIONID == StrPermissionID && b.RoleMenuPermission.T_SYS_ROLEENTITYMENU.ROLEENTITYMENUID == RoleEntityID
// select b;
// string OldRangeValue = ""; //获取数据库中 权限对应的值
// if (k.Count() > 0)
// {
// OldRangeValue = k.ToList().FirstOrDefault().RoleMenuPermission.DATARANGE.ToString();
// }
// //Rating hrrate = DaGrHR.Columns[i].GetCellContent(obj).FindName("HRrating") as Rating;
// Button hrrate = Dtgrid.Columns[i].GetCellContent(obj).FindName(rateName) as Button;
// switch (hrrate.Content.ToString())
// {
// case "★"://员工 0.2 ×10
// NewDataRange = "4";
// break;
// case "★★"://岗位 0.4×10
// NewDataRange = "3";
// break;
// case "★★★"://部门 0.6*10
// NewDataRange = "2";
// break;
// case "★★★★"://公司 0.8*10
// NewDataRange = "1";
// break;
// //case "★★★★★"://集团 1.0*10
// // NewDataRange = "0";
// // break;
// case ""://权限
// NewDataRange = "";
// break;
// }
// if (OldRangeValue != NewDataRange)
// {
// tmpAllList += NewDataRange + ",";
// tmpAllList += tmpPermission[i - 1].PERMISSIONID + ";";
// IsCheckRange = true;
// }
// }
// }
// if (IsCheckRange)
// {
// tmpAllList += "@" + StrMenuID + "," + "";
// tmpAllList += "#";
// }
// }
// }
// if (IsAdd)
// {
// if (string.IsNullOrEmpty(tmpAllList))
// {
// ComfirmWindow.ConfirmationBox(Utility.GetResourceStr("CONFIRMINFO"), "请先设置权限", Utility.GetResourceStr("CONFIRMBUTTON"));
// return;
// }
// }
// }
//}
private void SaveGridMenuPermission(DataGrid Dtgrid, string rateName)
{
if (Dtgrid.ItemsSource != null)
{
foreach (object obj in Dtgrid.ItemsSource)
{
//T_SYS_ENTITYMENU menu = new T_SYS_ENTITYMENU();
if (Dtgrid.Columns[0].GetCellContent(obj) != null)
{
//menu = Dtgrid.Columns[0].GetCellContent(obj).DataContext as T_SYS_ENTITYMENU;
//tmpAllList += menu.T_SYS_ENTITYMENU2.ENTITYMENUID + ",";
string StrMenuID = ""; //菜单ID
menu = Dtgrid.Columns[0].GetCellContent(obj).DataContext as V_MenuSetRole;
StrMenuID = menu.ENTITYMENUID;
string StrPermissionID = "";//权限ID
int PermCount = 0;
PermCount = tmpPermission.Count;
int IndexCount = 1;
//IndexCount = PermCount
bool IsCheckRange = false;//是否选择了权限范围
for (int i = 1; i < PermCount + 1; i++)
{
IndexCount = IndexCount + i;
if (Dtgrid.Columns[i].GetCellContent(obj) != null)
{
string NewDataRange = "";
/*
* 首先根据菜单ID和角色ID获取 角色菜单表的记录 存在则获取ROLEENTITYID
* 然后再根据 ROLEENTITYID和权限ID 获取角色菜单权限表中的记录，取得对应的权限和现在的权限值比较
* 如果相同则不处理 不同则处理
*/
StrPermissionID = tmpPermission[i - 1].PERMISSIONID; //权限ID
//var q = from a in EntityPermissionInfosList//权限视图集合
// where a.EntityRole.T_SYS_ENTITYMENU.ENTITYMENUID == StrMenuID
// && a.EntityRole.T_SYS_ROLE.ROLEID == tmprole.ROLEID
// select a;
var q = from a in EntityPermissionInfosListSecond//权限视图集合
where a.EntityMenuID == StrMenuID &&
a.RoleID == tmprole.ROLEID
select a;
string RoleEntityID = "";
if (q.Count() > 0)
{
RoleEntityID = q.ToList().FirstOrDefault().RoleEntityMenuID.ToString(); //获取角色菜单ID
}
//var m = from a in EntityPermissionInfosList
//var k = from b in EntityPermissionInfosList//权限视图集合
// where b.RoleMenuPermission.T_SYS_PERMISSION.PERMISSIONID == StrPermissionID && b.RoleMenuPermission.T_SYS_ROLEENTITYMENU.ROLEENTITYMENUID == RoleEntityID
// select b;
var k = from b in EntityPermissionInfosListSecond//权限视图集合
where b.PermissionID == StrPermissionID && b.RoleEntityMenuID == RoleEntityID
select b;
string OldRangeValue = ""; //获取数据库中 权限对应的值
if (k.Count() > 0)
{
OldRangeValue = k.ToList().FirstOrDefault().PermissionDataRange.ToString();
}
//Rating hrrate = DaGrHR.Columns[i].GetCellContent(obj).FindName("HRrating") as Rating;
Button hrrate = Dtgrid.Columns[i].GetCellContent(obj).FindName(rateName) as Button;
switch (hrrate.Content.ToString())
{
case "★": //员工 0.2 ×10
NewDataRange = "4";
break;
case "★★": //岗位 0.4×10
NewDataRange = "3";
break;
case "★★★": //部门 0.6*10
NewDataRange = "2";
break;
case "★★★★": //公司 0.8*10
NewDataRange = "1";
break;
//case "★★★★★"://集团 1.0*10
// NewDataRange = "0";
// break;
case "": //权限
NewDataRange = "";
break;
}
if (OldRangeValue != NewDataRange)
{
tmpAllList += NewDataRange + ",";
tmpAllList += tmpPermission[i - 1].PERMISSIONID + ";";
IsCheckRange = true;
}
}
}
if (IsCheckRange)
{
tmpAllList += "@" + StrMenuID + "," + "";
tmpAllList += "#";
}
}
}
if (IsAdd)
{
if (string.IsNullOrEmpty(tmpAllList))
{
ComfirmWindow.ConfirmationBox(Utility.GetResourceStr("CONFIRMINFO"), "请先设置权限", Utility.GetResourceStr("CONFIRMBUTTON"));
RefreshUI(RefreshedTypes.HideProgressBar);
return;
}
}
}
}