private void btnUpdate_Click(object sender, EventArgs e)
{
if (tbRoleName.Text.Trim() == "")
{
WinInfoHelper.ShowInfoWindow(this, "角色名称不能为空！");
return;
}
if (_selectRow != null && dgvData.Rows.Contains(_selectRow))
{
Maticsoft.Model.SMT_ROLE_INFO role = (Maticsoft.Model.SMT_ROLE_INFO)_selectRow.Tag;
role.ROLE_NAME = tbRoleName.Text.Trim();
role.ROLE_DESC = tbRoleDesc.Text.Trim();
CtrlWaiting waiting = new CtrlWaiting(() =>
{
try
{
Maticsoft.BLL.SMT_ROLE_INFO roleBll = new Maticsoft.BLL.SMT_ROLE_INFO();
roleBll.Update(role);
SmtLog.InfoFormat("用户", "更新角色：ID={0}，名称={1}", role.ID, role.ROLE_NAME);
this.Invoke(new Action(() =>
{
_selectRow.Cells[0].Value = role.ROLE_NAME;
_selectRow.Cells[1].Value = role.ROLE_DESC;
}));
}
catch (Exception ex)
{
log.Error("更新角色异常：", ex);
WinInfoHelper.ShowInfoWindow(this, "更新角色异常：" + ex.Message);
}
});
waiting.Show(this);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public decimal Add(Maticsoft.Model.SMT_ROLE_INFO model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into SMT_ROLE_INFO(");
strSql.Append("ROLE_NAME,ROLE_DESC)");
strSql.Append(" values (");
strSql.Append("@ROLE_NAME,@ROLE_DESC)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@ROLE_NAME", SqlDbType.NVarChar, 50),
new SqlParameter("@ROLE_DESC", SqlDbType.NVarChar, 200)
};
parameters[0].Value = model.ROLE_NAME;
parameters[1].Value = model.ROLE_DESC;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToDecimal(obj));
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
if (tbRoleName.Text.Trim() == "")
{
WinInfoHelper.ShowInfoWindow(this, "角色名称不能为空！");
return;
}
Maticsoft.Model.SMT_ROLE_INFO role = new Maticsoft.Model.SMT_ROLE_INFO();
role.ROLE_NAME = tbRoleName.Text.Trim();
role.ROLE_DESC = tbRoleName.Text.Trim();
CtrlWaiting waiting = new CtrlWaiting(() =>
{
try
{
Maticsoft.BLL.SMT_ROLE_INFO roleBll = new Maticsoft.BLL.SMT_ROLE_INFO();
role.ID = roleBll.Add(role);
SmtLog.InfoFormat("用户", "添加角色：ID={0}，名称={1}", role.ID, role.ROLE_NAME);
this.Invoke(new Action(() =>
{
AddModel(role);
}));
}
catch (Exception ex)
{
log.Error("添加角色异常：", ex);
WinInfoHelper.ShowInfoWindow(this, "添加角色异常：" + ex.Message);
}
});
waiting.Show(this);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.SMT_ROLE_INFO model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update SMT_ROLE_INFO set ");
strSql.Append("ROLE_NAME=@ROLE_NAME,");
strSql.Append("ROLE_DESC=@ROLE_DESC");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ROLE_NAME", SqlDbType.NVarChar, 50),
new SqlParameter("@ROLE_DESC", SqlDbType.NVarChar, 200),
new SqlParameter("@ID", SqlDbType.Decimal, 9)
};
parameters[0].Value = model.ROLE_NAME;
parameters[1].Value = model.ROLE_DESC;
parameters[2].Value = model.ID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
private void dgvRoleInfos_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex >= 0 && e.ColumnIndex >= 0)
{
if (dgvRoleInfos.Columns[e.ColumnIndex].Name == "ColDelete")
{
if (MessageBox.Show("确定删除选择角色？", "提示", MessageBoxButtons.OKCancel) == DialogResult.OK)
{
var orgInfo = GetSelectOrg();
Maticsoft.Model.SMT_ROLE_INFO role = (Maticsoft.Model.SMT_ROLE_INFO)dgvRoleInfos.Rows[e.RowIndex].Tag;
CtrlWaiting waiting = new CtrlWaiting(() =>
{
try
{
Maticsoft.DBUtility.DbHelperSQL.ExecuteSql("delete from SMT_ROLE_FUN where FUN_ID=" + orgInfo.ID + " and ROLE_TYPE=2 and ROLE_ID=" + role.ID);
this.Invoke(new Action(() =>
{
dgvRoleInfos.Rows.RemoveAt(e.RowIndex);
}));
}
catch (System.Exception ex)
{
WinInfoHelper.ShowInfoWindow(this, "删除角色异常：" + ex.Message);
log.Error("删除角色异常", ex);
}
});
waiting.Show(this);
}
}
}
}
private void dgvRoleInfos_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex >= 0 && e.ColumnIndex >= 0)
{
if (dgvRoleInfos.Columns[e.ColumnIndex].Name != "ColDelete")
{
Maticsoft.Model.SMT_ROLE_INFO role = (Maticsoft.Model.SMT_ROLE_INFO)dgvRoleInfos.Rows[e.RowIndex].Tag;
CtrlWaiting waiting = new CtrlWaiting(() =>
{
try
{
Maticsoft.BLL.SMT_USER_INFO userBll = new Maticsoft.BLL.SMT_USER_INFO();
var list = userBll.GetModelListByPageEx("ROLE_ID=" + role.ID + " and IS_DELETE=0 and IS_ENABLE=1", "USER_NAME", 0, 100);
this.Invoke(new Action(() =>
{
DoShowUsersToGrid2(list);
}));
}
catch (Exception ex)
{
WinInfoHelper.ShowInfoWindow(this, "加载权限操作人错误：" + ex.Message);
log.Error("加载权限操作人错误：", ex);
}
});
waiting.Show(dgvRoleInfos);
}
}
}
private void btnOk_Click(object sender, EventArgs e)
{
if (advRoleTree.SelectedNode == null)
{
WinInfoHelper.ShowInfoWindow(this, "请选择一个角色！");
return;
}
SELECT_ROLE = (Maticsoft.Model.SMT_ROLE_INFO)advRoleTree.SelectedNode.Tag;
DoSave();
}
private void DoSetPrivate()
{
if (_selectRow != null)
{
Maticsoft.Model.SMT_ROLE_INFO role = (Maticsoft.Model.SMT_ROLE_INFO)_selectRow.Tag;
FrmRoleFunSelector frmSelector = new FrmRoleFunSelector(role);
if (frmSelector.ShowDialog(this) == DialogResult.OK)
{
}
}
}
public FrmRoleFunSelector(Maticsoft.Model.SMT_ROLE_INFO role)
{
InitializeComponent();
superTabControl1.SelectedTab = superTabItem1;
_roleInfo = role;
deptTree.Tree.CheckBoxVisible = true;
deptTree.TreeLoaded += deptTree_TreeLoaded;
doorTree.Tree.CheckBoxVisible = true;
doorTree.LoadEnded += doorTree_LoadEnded;
faceDevTree.CheckBoxVisible = true;
faceDevTree.LoadEnded += faceDevTree_LoadEnded;
}
private void AddModel(Maticsoft.Model.SMT_ROLE_INFO role)
{
DataGridViewRow row = new DataGridViewRow();
row.CreateCells(dgvData,
role.ROLE_NAME,
role.ROLE_DESC,
"设置/修改权限",
"删除"
);
row.Tag = role;
dgvData.Rows.Add(row);
}
private void dgvData_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex >= 0)
{
DataGridViewRow row = dgvData.Rows[e.RowIndex];
_selectRow = row;
Maticsoft.Model.SMT_ROLE_INFO role = (Maticsoft.Model.SMT_ROLE_INFO)row.Tag;
tbRoleName.Text = role.ROLE_NAME;
tbRoleDesc.Text = role.ROLE_DESC;
if (e.ColumnIndex >= 0)
{
if (dgvData.Columns[e.ColumnIndex].Name == "ColPrivate")
{
DoSetPrivate();
}
else if (dgvData.Columns[e.ColumnIndex].Name == "ColDelete")
{
if (MessageBox.Show("确定删除该角色？", "提示", MessageBoxButtons.OKCancel) == DialogResult.OK)
{
CtrlWaiting waiting = new CtrlWaiting(() =>
{
try
{
Maticsoft.DBUtility.DbHelperSQL.ExecuteSql("delete from SMT_ROLE_FUN where ROLE_ID=" + role.ID);
Maticsoft.BLL.SMT_ROLE_INFO roleInfo = new Maticsoft.BLL.SMT_ROLE_INFO();
roleInfo.Delete(role.ID);
SmtLog.InfoFormat("用户", "删除角色：ID={0},名称={1}", role.ID, role.ROLE_NAME);
this.Invoke(new Action(() =>
{
dgvData.Rows.Remove(row);
_selectRow = null;
tbRoleName.Text = "";
tbRoleDesc.Text = "";
}));
}
catch (Exception ex)
{
log.Error("删除角色异常：", ex);
WinInfoHelper.ShowInfoWindow(this, "删除角色异常：" + ex.Message);
}
});
waiting.Show(this);
}
}
}
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.SMT_ROLE_INFO DataRowToModel(DataRow row)
{
Maticsoft.Model.SMT_ROLE_INFO model = new Maticsoft.Model.SMT_ROLE_INFO();
if (row != null)
{
if (row["ID"] != null && row["ID"].ToString() != "")
{
model.ID = decimal.Parse(row["ID"].ToString());
}
if (row["ROLE_NAME"] != null)
{
model.ROLE_NAME = row["ROLE_NAME"].ToString();
}
if (row["ROLE_DESC"] != null)
{
model.ROLE_DESC = row["ROLE_DESC"].ToString();
}
}
return(model);
}
private void btnSelectRole_Click(object sender, EventArgs e)
{
var orgInfo = GetSelectOrg();
if (orgInfo == null)
{
WinInfoHelper.ShowInfoWindow(this, "请选择一个授权的节点！");
return;
}
List <decimal> ids = new List <decimal>();
foreach (DataGridViewRow row in dgvRoleInfos.Rows)
{
Maticsoft.Model.SMT_ROLE_INFO role = (Maticsoft.Model.SMT_ROLE_INFO)row.Tag;
ids.Add(role.ID);
}
FrmRolesSelector s = new FrmRolesSelector(ids, orgInfo.ID);
if (s.ShowDialog(this) == DialogResult.OK)
{
DoShowRolesToGrid(s.SelectRoles);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.SMT_ROLE_INFO GetModel(decimal ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,ROLE_NAME,ROLE_DESC from SMT_ROLE_INFO ");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Decimal)
};
parameters[0].Value = ID;
Maticsoft.Model.SMT_ROLE_INFO model = new Maticsoft.Model.SMT_ROLE_INFO();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
private void advRoleTree_NodeDoubleClick(object sender, TreeNodeMouseEventArgs e)
{
SELECT_ROLE = (Maticsoft.Model.SMT_ROLE_INFO)e.Node.Tag;
DoSave();
}
private void btnOk_Click(object sender, EventArgs e)
{
if (tbUserName.Text.Trim() == "")
{
MessageBox.Show("用户名不能为空！");
return;
}
if (_userInfo == null)
{
_userInfo = new Maticsoft.Model.SMT_USER_INFO();
_userInfo.ID = -1;
}
string oldUser = _userInfo.USER_NAME;
_userInfo.USER_NAME = tbUserName.Text.Trim();
_userInfo.PASS_WORD = tbPwd.Text;
if (_userInfo.PASS_WORD == "123456")
{
_userInfo.PASS_WORD = "e10adc3949ba59abbe56e057f20f883e";
}
_userInfo.REAL_NAME = tbRealName.Text.Trim();
_userInfo.IS_ENABLE = cbEnable.Checked;
_userInfo.TELEPHONE = tbTel.Text.Trim();
_userInfo.ADDRESS = tbAddress.Text.Trim();
_userInfo.EMAIL = tbEmail.Text.Trim();
_userInfo.QQ = tbQQ.Text.Trim();
_userInfo.KEY_VAL = "";
_userInfo.IS_DELETE = false;
if (cboRole.SelectedItem != null)
{
ComboItem cboItem = (ComboItem)cboRole.SelectedItem;
Maticsoft.Model.SMT_ROLE_INFO roleInfo = (Maticsoft.Model.SMT_ROLE_INFO)cboItem.Tag;
_userInfo.ROLE_ID = roleInfo.ID;
_userInfo.ROLE_NAME = roleInfo.ROLE_NAME;
}
else
{
_userInfo.ROLE_ID = -1;
}
if (cbtDept.SelectedNode != null)
{
Maticsoft.Model.SMT_ORG_INFO orgInfo = (Maticsoft.Model.SMT_ORG_INFO)cbtDept.SelectedNode.Tag;
_userInfo.ORG_ID = orgInfo.ID;
_userInfo.DEPT_NAME = orgInfo.ORG_NAME;
}
else
{
_userInfo.ORG_ID = -1;
}
CtrlWaiting waiting = new CtrlWaiting(() =>
{
try
{
Maticsoft.BLL.SMT_USER_INFO userBll = new Maticsoft.BLL.SMT_USER_INFO();
if (_userInfo.ID == -1)
{
userBll.Add(_userInfo);
SmtLog.InfoFormat("用户", "添加用户：用户名={0}，状态={1}", _userInfo.USER_NAME, _userInfo.IS_ENABLE);
}
else
{
userBll.Update(_userInfo);
SmtLog.InfoFormat("用户", "更新用户：用户名={0}，状态={1},原始用户名={2}", _userInfo.USER_NAME, _userInfo.IS_ENABLE, oldUser);
}
this.BeginInvoke(new Action(() =>
{
this.DialogResult = DialogResult.OK;
this.Close();
}));
}
catch (Exception ex)
{
WinInfoHelper.ShowInfoWindow(this, "保存用户异常：" + ex.Message);
log.Error("保存用户异常：", ex);
}
});
waiting.Show(this);
}
