/// <summary>
/// 根据用户ID查数据
/// </summary>
private void btnUpdateUser()
{
if (Common.UserID > 0 || Common.RoleID > 0)
{
Expression <Func <PermissionsInfo, bool> > funPermissionsInfo = n => n.Permissions_UserId == Common.UserID || n.Permissions_Role_Id == Common.RoleID;
var permissionsInfo = PermissionsInfoDAL.Query(funPermissionsInfo);//根据用户ID查出菜单ID
if (permissionsInfo == null)
{
return; //没有数据跳出方法
}
foreach (var m in permissionsInfo)
{
if (m.Permissions_Menu_ID.Value > 0)
{
UpdateSelectRole(m.Permissions_Menu_ID.Value);
}
}
}
}
/// <summary>
/// 删除
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void tsbtnDel_delete()
{
try
{
int j = 0;
string Log_Content = "";
if (lvwUserList.SelectedRows.Count > 0)//选中删除
{
if (MessageBox.Show("确定要删除吗？", "系统提示", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
//选中数量
int count = lvwUserList.SelectedRows.Count;
//string id = "";
//遍历
for (int i = 0; i < count; i++)
{
Expression <Func <View_UserInfo_D_R_d, bool> > funviewuserinfo = n => n.Role_Name == lvwUserList.SelectedRows[i].Cells["Role_Name"].Value.ToString();
if (UserInfoDAL.Query(funviewuserinfo).Count() > 0)
{
MessageBox.Show("删除的用户角色中有角色正在使用，不能删除！", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
Expression <Func <RoleInfo, bool> > funuserinfo = n => n.Role_Id.ToString() == lvwUserList.SelectedRows[i].Cells["Role_Id"].Value.ToString();
if (!RoleInfoDAL.DeleteToMany(funuserinfo))
{
j++;
}
else
{
Log_Content += lvwUserList.SelectedRows[i].Cells["Role_Id"].Value.ToString() + " ";
}
if (lvwUserList.SelectedRows[i].Cells["Role_Id"].Value != null)
{
//删除角色的所有权限
Expression <Func <PermissionsInfo, bool> > funmenuinfo = n => n.Permissions_Role_Id == Common.GetInt(lvwUserList.SelectedRows[i].Cells["Role_Id"].Value.ToString());
if (!PermissionsInfoDAL.DeleteToMany(funmenuinfo))//用户权限菜单是否删除失败
{
j++;
}
}
}
if (j == 0)
{
MessageBox.Show("成功删除", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("删除失败", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
Common.WriteLogData("删除", "删除角色" + Log_Content, Common.NAME);//操作日志
}
}
else//没有选中
{
MessageBox.Show("请选择要删除的行！", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch (Exception ex)
{
Common.WriteTextLog("角色管理 tsbtnDel_delete()" + ex.Message.ToString());
}
finally
{
page = new PageControl();
page.PageMaxCount = tscbxPageSize2.SelectedItem.ToString();
LoadData();
}
}
private void btnUpdate_Click()
{
try
{
arraylist.Clear();//清空动态数组内的成员
add();
int j = 0;
bool Menu_Enabled = true;
bool Menu_Visible = true;
if (!chb_Menu_Visible.Checked)
{
Menu_Visible = false;
}
if (!chb_Menu_Enabled.Checked)
{
Menu_Enabled = false;
}
if (YesNoBoolRoleUser)
{
//删除用户的所有权限
if (Common.UserID <= 0)
{
return;
}
Expression <Func <PermissionsInfo, bool> > funmenuinfo = n => n.Permissions_UserId == Common.UserID;
if (!PermissionsInfoDAL.DeleteToMany(funmenuinfo))//用户权限菜单是否删除失败
{
j++;
}
for (int i = 0; i < arraylist.Count; i++)
{
var permissionsInfo = new PermissionsInfo
{
Permissions_Menu_ID = Common.GetInt(arraylist[i].ToString()),
Permissions_Dictionary_ID = DictionaryDAL.GetDictionaryID("启动"),
Permissions_Visible = Menu_Visible,
Permissions_Enabled = Menu_Enabled,
Permissions_UserId = Common.UserID
};
if (!PermissionsInfoDAL.InsertOneQCRecord(permissionsInfo))//是否添加失败
{
j++;
}
}
}
else
{
//删除用户的所有权限
Expression <Func <PermissionsInfo, bool> > funmenuinfo = n => n.Permissions_Role_Id == Common.RoleID;
if (!PermissionsInfoDAL.DeleteToMany(funmenuinfo))//用户权限菜单是否删除失败
{
j++;
}
for (int i = 0; i < arraylist.Count; i++)
{
var permissionsInfo = new PermissionsInfo
{
Permissions_Menu_ID = Common.GetInt(arraylist[i].ToString()),
Permissions_Dictionary_ID = DictionaryDAL.GetDictionaryID("启动"),
Permissions_Visible = Menu_Visible,
Permissions_Enabled = Menu_Enabled,
Permissions_Role_Id = Common.RoleID
};
if (!PermissionsInfoDAL.InsertOneQCRecord(permissionsInfo))//是否添加失败
{
j++;
}
}
}
if (j == 0)
{
MessageBox.Show("添加成功", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("添加失败", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch (Exception ex)
{
MessageBox.Show("添加成功", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
Common.WriteTextLog("UserRoleADD.btnUpdate_Click()" + ex.Message.ToString());
}
finally
{
this.Close();
}
//try
//{
// arraylist.Clear();//清空动态数组内的成员
// add();
// Common.arraylist = arraylist;
//}
//catch (Exception ex)
//{
// Common.WriteTextLog("UserRoleADD.btnUpdate_Click()" + ex.Message.ToString());
//}
//finally
//{
// this.Close();
//}
}
private void btnUpdate_Click()
{
try
{
arraylist.Clear();//清空动态数组内的成员
add();
int j = 0;
bool Menu_Enabled = true;
bool Menu_Visible = true;
if (!chb_Menu_Visible.Checked)
{
Menu_Visible = false;
}
if (!chb_Menu_Enabled.Checked)
{
Menu_Enabled = false;
}
if (CommonalityEntity.YesNoBoolRoleUser)
{
//删除用户权限，只能删除我拥有的，已经配置的权限
if (CommonalityEntity.UserID <= 0)
{
return;
}
DataTable dt = LinQBaseDao.Query("select Permissions_ID from View_MenuInfo_P where Menu_Type=1 and Permissions_UserId=" + CommonalityEntity.UserID + "").Tables[0];
string pids = "";
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
pids += dt.Rows[i][0].ToString() + ",";
}
LinQBaseDao.Query("delete PermissionsInfo where Permissions_ID in (" + pids.TrimEnd(',') + ")");
}
for (int i = 0; i < arraylist.Count; i++)
{
var permissionsInfo = new PermissionsInfo
{
Permissions_Menu_ID = CommonalityEntity.GetInt(arraylist[i].ToString()),
Permissions_Visible = Menu_Visible,
Permissions_Enabled = Menu_Enabled,
Permissions_Type = 1,//1为winfrom程序菜单
Permissions_UserId = CommonalityEntity.UserID
};
if (!PermissionsInfoDAL.InsertOneQCRecord(permissionsInfo))//是否添加失败
{
j++;
}
}
}
else
{
//删除用户的所有权限
Expression <Func <PermissionsInfo, bool> > funmenuinfo = n => n.Permissions_Role_Id == CommonalityEntity.RoleID;
if (!PermissionsInfoDAL.DeleteToMany(funmenuinfo))//用户权限菜单是否删除失败
{
j++;
}
for (int i = 0; i < arraylist.Count; i++)
{
var permissionsInfo = new PermissionsInfo
{
Permissions_Menu_ID = CommonalityEntity.GetInt(arraylist[i].ToString()),
//Dictionary_State = DictionaryDAL.GetDictionaryID("启动"),
Permissions_Visible = Menu_Visible,
Permissions_Enabled = Menu_Enabled,
Permissions_Type = 1,
Permissions_Role_Id = CommonalityEntity.RoleID
};
if (!PermissionsInfoDAL.InsertOneQCRecord(permissionsInfo))//是否添加失败
{
j++;
}
}
}
if (j == 0)
{
MessageBox.Show("添加成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
CommonalityEntity.WriteLogData("新增", "新增角色编号为：" + CommonalityEntity.RoleID + "权限的信息", CommonalityEntity.USERNAME);
}
else
{
MessageBox.Show("添加失败", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch
{
MessageBox.Show("添加失败", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
CommonalityEntity.WriteTextLog("UserRoleADD.btnUpdate_Click()");
}
finally
{
this.Close();
}
try
{
arraylist.Clear();//清空动态数组内的成员
add();
CommonalityEntity.arraylist = arraylist;
}
catch
{
CommonalityEntity.WriteTextLog("UserRoleADD.btnUpdate_Click()");
}
finally
{
this.Close();
}
}
