/// <summary>
/// 用户权限
/// </summary>
/// <param name="UserID"></param>
private void QueryMenu(string UserID)
{
string strWhere = string.Format(@"dmm.UserID='{0}'", UserID);
DataTable dt = BLL_SysDatUserMenuMap.Select(strWhere);
dgv_Menu.DataSource = dt;
//dgv_Material.ClearSelection();
}
/// <summary>
/// 删除
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btn_del_Click(object sender, EventArgs e)
{
string strWhere = string.Empty;
int iSelectedRow = 0;
bool b_DelOK = false;//是否删除过
DialogResult result = MsgBox.Question("确认删除？");
if (result == DialogResult.Cancel)
{
return;
}
int Count = 0;
foreach (DataGridViewRow row in dgv_User.Rows)
{
if (row.Cells[CHK.Name].EditedFormattedValue.ToString() == "True")
{
if (strWhere == string.Empty)
{
strWhere += string.Format("WHERE {0} in ('{1}'", UserID.Name, row.Cells[UserID.Name].Value.ToString());
}
else
{
strWhere += string.Format(",'{0}'", row.Cells[UserID.Name].Value.ToString());
}
Count++;
iSelectedRow++;
if (Count == 20)
{
strWhere += ")";
BLL_SysDatUser.Delete(strWhere);
BLL_SysDatUserMenuMap.Delete(strWhere);
strWhere = string.Empty;
Count = 0;
b_DelOK = true;
}
}
}
if (strWhere != string.Empty)
{
strWhere += ")";
BLL_SysDatUser.Delete(strWhere);
BLL_SysDatUserMenuMap.Delete(strWhere);
b_DelOK = true;
}
if (iSelectedRow == 0)
{
MsgBox.Error("请先选中行！");
return;
}
if (b_DelOK)
{
Query();
new PubUtils().ShowNoteOKMsg("删除成功！");
string MaterialCode = string.Empty;
}
}
/// <summary>
/// 保存
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btn_ok_Click(object sender, EventArgs e)
{
txt_UserID.Focus();
if (!CheckData())
{
return;
}
bool isSucess = false;
if (_Action_Type == false)
{
//1、保存用户信息
BLL_SysDatUser.Insert(txt_UserID.Text.Trim(), txt_UserName.Text.Trim(), txt_Password.Text.Trim());
//2、用户菜单信息
foreach (DataRow dr in dt_Menu.Rows)
{
if (dr["flag"].ToString() == "2")//新增
{
BLL_SysDatUserMenuMap.Insert(dr[MenuCode.Name].ToString(), txt_UserID.Text.Trim());
}
}
isSucess = true;
}
else
{
//1、保存用户信息
BLL_SysDatUser.UpdateUserName(txt_UserID.Text.Trim(), txt_UserName.Text.Trim());
//2、用户菜单信息
foreach (DataRow dr in dt_Menu.Rows)
{
if (dr["flag"].ToString() == "2")//新增
{
BLL.BLL_SysDatUserMenuMap.Insert(dr[MenuCode.Name].ToString(), txt_UserID.Text.Trim());
}
else if (dr["flag"].ToString() == "3")//删除
{
BLL.BLL_SysDatUserMenuMap.Delete(string.Format(@" WHERE MenuCode='{0}' AND UserID='{1}'", dr[MenuCode.Name].ToString(), txt_UserID.Text.Trim()));
}
}
isSucess = true;
}
if (isSucess)
{
new PubUtils().ShowNoteOKMsg("保存成功！");
this.result = DialogResult.OK;
this.Close();
}
}
