/// <summary>
/// 修改角色
/// </summary>
/// <param name="Roles"></param>
/// <returns></returns>
public Result EdtRole(TB_Role Roles)
{
Result result = new Result();
if (Roles.role_id == 0)
{
result.Code = "400";
result.Msg = "要修改的ID不能为空!";
}
else
{
if (LoadEntities(s => s.role_id == Roles.role_id).Any())
{
Roles.modifytime = DateTime.Now;
UpdateEntity(Roles);
result.Code = "200";
result.Msg = "修改成功!";
}
else
{
result.Code = "400";
result.Msg = "该角色不存在!";
}
}
return(result);
}
/// <summary>
/// 编辑角色信息
/// </summary>
/// <param name="tb_Role"></param>
/// <param name="lstDormAreaID"></param>
/// <returns></returns>
public string Edit(TB_Role tb_Role, List <int> lstModuleID)
{
string strErrMsg = string.Empty;
TB_Role mTB_Role = null;
mTB_Role = _mTB_RoleDAL.GetTable(tb_Role.Name, tb_Role.SiteID);
//编辑
if (tb_Role.ID > 0)
{
if (mTB_Role != null && mTB_Role.ID != tb_Role.ID)
{
strErrMsg = "该角色已存在！";
return(strErrMsg);
}
this.Update(tb_Role, lstModuleID);
}
//添加
else
{
if (mTB_Role != null)
{
strErrMsg = "该角色已存在！";
return(strErrMsg);
}
this.Add(tb_Role, lstModuleID);
}
return(strErrMsg);
}
/// <summary>
/// 删除角色
/// </summary>
/// <param name="Roles"></param>
/// <returns></returns>
public Result DelRole(TB_Role Roles)
{
Result result = new Result();
if (Roles.role_id == 0)
{
result.Code = "400";
result.Msg = "要删除的ID不能为空!";
}
else
{
if (LoadEntities(s => s.role_id == Roles.role_id).Any())
{
DeleteEntity(Roles);
result.Code = "200";
result.Msg = "删除成功!";
}
else
{
result.Code = "400";
result.Msg = "该角色不存在!";
}
}
return(result);
}
/// <summary>
/// 事务更新
/// </summary>
/// <param name="info"></param>
/// <param name="tran"></param>
/// <param name="db"></param>
/// <returns></returns>
public int Edit(TB_Role info, DbTransaction tran, Database db)
{
DbCommand dbCommandWrapper = null;
string strUpdateSql = @"UPDATE TB_Role SET Name=@Name WHERE ID=@ID";
try
{
dbCommandWrapper = db.GetSqlStringCommand(strUpdateSql);
#region Add parameters
db.AddInParameter(dbCommandWrapper, "@ID", DbType.Int32, info.ID);
db.AddInParameter(dbCommandWrapper, "@Name", DbType.String, info.Name);
#endregion
if (tran == null)
{
return(db.ExecuteNonQuery(dbCommandWrapper));
}
else
{
return(db.ExecuteNonQuery(dbCommandWrapper, tran));
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (dbCommandWrapper != null)
{
dbCommandWrapper = null;
}
}
}
private void InitPageData()
{
string strUserID = Request.QueryString["id"];
TB_DormArea mTB_DormArea = new TB_DormArea();
DormAreaBLL mDormAreaBLL = new DormAreaBLL();
TB_User mTB_User = null;
UserBLL mUserBLL = new UserBLL();
RoleBLL mRoleBLL = new RoleBLL();
TB_Role mTB_Role = new TB_Role()
{
SiteID = (base.UserInfo == null ? base.SystemAdminInfo.SiteID : base.UserInfo.SiteID),
};
Pager pager = null;
this.ddlRole.DataTextField = TB_Role.col_Name;
this.ddlRole.DataValueField = TB_Role.col_ID;
this.ddlRole.DataSource = mRoleBLL.GetPagerData(mTB_Role, ref pager);
this.ddlRole.DataBind();
this.ddlRole.Items.Insert(0, new ListItem()
{
Value = "0", Text = "--请选择--"
});
mTB_DormArea.SiteID = (base.UserInfo == null ? base.SystemAdminInfo.SiteID : base.UserInfo.SiteID);
DataTable dtLeft = mDormAreaBLL.GetTable(mTB_DormArea, ref pager);
DataTable dtRight = null;
if (null != strUserID && !string.IsNullOrEmpty(strUserID))
{
mTB_User = mUserBLL.Get(Convert.ToInt32(strUserID));
this.txtADAccount.Text = mTB_User.ADAccount;
this.txtEmployeeNo.Text = mTB_User.EmployeeNo;
this.txtCName.Text = mTB_User.CName;
this.txtEName.Text = mTB_User.EName;
this.ddlRole.SelectedValue = mTB_User.RoleID.ToString();
dtRight = mDormAreaBLL.GetTableByUserID(Convert.ToInt32(strUserID));
DataRow[] drFilter = null;
for (int i = dtLeft.Rows.Count - 1; i >= 0; i--)
{
drFilter = dtRight.Select("ID=" + dtLeft.Rows[i][TB_DormArea.col_ID] + "");
if (drFilter.Length > 0)
{
dtLeft.Rows.Remove(dtLeft.Rows[i]);
}
}
}
ViewState["dtLeft"] = dtLeft;
gdvLeft.DataSource = dtLeft;
gdvLeft.DataBind();
ViewState["dtRight"] = dtRight;
gdvRight.DataSource = dtRight;
gdvRight.DataBind();
}
/// <summary>
/// 更新
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public int Edit(TB_Role info)
{
try
{
Database db = DBO.CreateDatabase();
return(this.Edit(info, (DbTransaction)null, db));
}
catch (Exception ex)
{
throw ex;
}
}
protected void Update(TB_Role role)
{
RoleInstance.Update(f => f.id == role.id, action =>
{
action.Delete = role.Delete;
action.Description = role.Description;
action.IsAdministrator = role.IsAdministrator;
action.IsDefault = role.IsDefault;
action.Name = role.Name;
action.Permission = role.Permission;
});
}
private void InitPageData()
{
int intRoleID;
ModuleBLL mModuleBLL = new ModuleBLL();
RoleBLL mRoleBLL = new RoleBLL();
TB_Role tbRole = null;
Int32.TryParse(Request.QueryString["id"], out intRoleID);
mModuleBLL.LoadTreeModule(this.treAuthority, intRoleID);
tbRole = mRoleBLL.GetByID(intRoleID);
if (null != tbRole)
{
this.txtRoleName.Text = tbRole.Name;
}
}
public DataTable GetTable(TB_Role tb_Role, ref Pager pager)
{
DataTable dt = null;
DbCommand dbCommandWrapper = null;
try
{
string strSQL = @"SELECT * FROM [TB_Role] where 1=1";
StringBuilder strBuilder = new StringBuilder(strSQL);
Database db = DBO.GetInstance();
dbCommandWrapper = db.DbProviderFactory.CreateCommand();
dbCommandWrapper.CommandType = CommandType.Text;
strBuilder.AppendLine(" AND SiteID = @SiteID");
db.AddInParameter(dbCommandWrapper, "@SiteID", DbType.Int32, tb_Role.SiteID);
if (!string.IsNullOrEmpty(tb_Role.Name))
{
strBuilder.AppendLine(" AND Name like @Name");
db.AddInParameter(dbCommandWrapper, "@Name", DbType.String, "%" + tb_Role.Name + "%");
}
if (pager != null && !pager.IsNull)
{
strSQL = pager.GetPagerSql4Count(strBuilder.ToString());
dbCommandWrapper.CommandText = strSQL;
dt = db.ExecuteDataSet(dbCommandWrapper).Tables[0];
pager.TotalRecord = Convert.ToInt32(dt.Rows[0][0]);
dbCommandWrapper.CommandText = pager.GetPagerSql4Data(strBuilder.ToString(), DataBaseTypeEnum.sqlserver);
}
else
{
dbCommandWrapper.CommandText = strBuilder.ToString();
}
dt = db.ExecuteDataSet(dbCommandWrapper).Tables[0];
return(dt);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (dbCommandWrapper != null)
{
dbCommandWrapper = null;
}
}
}
/// <summary>
/// 将datatable转换成list
/// </summary>
/// <param name="dt"></param>
/// <returns></returns>
private List <TB_Role> ConvertTableToList(DataTable dt)
{
TB_Role mTB_Role = null;
List <TB_Role> lstTB_Role = new List <TB_Role>();
foreach (DataRow dr in dt.Rows)
{
mTB_Role = new TB_Role()
{
ID = Convert.ToInt32(dr[TB_Role.col_ID]),
Name = dr[TB_Role.col_Name].ToString(),
SiteID = Convert.ToInt32(dr[TB_Role.col_SiteID]),
};
lstTB_Role.Add(mTB_Role);
}
return(lstTB_Role);
}
/// <summary>
/// 添加角色
/// </summary>
/// <param name="Roles"></param>
/// <returns></returns>
public Result AddRole(TB_Role Roles)
{
Result result = new Result();
if (LoadEntities(s => s.role_name == Roles.role_name).Any())
{
result.Code = "400";
result.Msg = "该名称已存在!";
}
else
{
Roles.createtime = DateTime.Now;
result.Data = AddEntity(Roles);
result.Code = "200";
result.Msg = "添加成功!";
}
return(result);
}
protected void btnSave_Click(object sender, EventArgs e)
{
List <int> lstModuleID = new List <int>();
RoleBLL mRoleBLL = new RoleBLL();
string strErrorMsg = string.Empty;
TB_Role mTB_Role = new TB_Role()
{
ID = Request.QueryString["id"] == null ? 0 : Convert.ToInt32(Request.QueryString["id"]),
SiteID = (base.UserInfo == null ? base.SystemAdminInfo.SiteID : base.UserInfo.SiteID),
Name = this.txtRoleName.Text,
};
foreach (TreeNode pNode in this.treAuthority.CheckedNodes)
{
if (pNode.Parent != null)
{
if (!lstModuleID.Contains(Convert.ToInt32(pNode.Parent.Value)))
{
lstModuleID.Add(Convert.ToInt32(pNode.Parent.Value));
lstModuleID.Add(Convert.ToInt32(pNode.Value));
}
else
{
lstModuleID.Add(Convert.ToInt32(pNode.Value));
}
}
else
{
lstModuleID.Add(Convert.ToInt32(pNode.Value));
}
}
strErrorMsg = mRoleBLL.Edit(mTB_Role, lstModuleID);
if (string.IsNullOrEmpty(strErrorMsg))
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "complete", "<script>saveComplete();</script>");
}
else
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "complete", "<script>alert('" + strErrorMsg + "')</script>");
}
}
/// <summary>
/// 添加角色信息
/// </summary>
/// <param name="tb_Role"></param>
/// <param name="lstModuleID"></param>
/// <returns></returns>
private int Add(TB_Role tb_Role, List <int> lstModuleID)
{
TB_RoleConnectModule mTB_RoleConnectModule = null;
int intRoleID = 0;
//启用事务
_db = DBO.CreateDatabase();
_connection = _db.CreateConnection();
_connection.Open();
_tran = _connection.BeginTransaction();
try
{
//添加角色信息
intRoleID = _mTB_RoleDAL.Create(tb_Role, _tran, _db);
//添加角色关联模块信息
foreach (var item in lstModuleID)
{
mTB_RoleConnectModule = new TB_RoleConnectModule()
{
RoleID = intRoleID,
ModuleID = item,
};
_mTB_RoleConnectModuleDAL.Create(mTB_RoleConnectModule, _tran, _db);
}
//提交事务
_tran.Commit();
}
catch
{
//回滚事务
_tran.Rollback();
}
finally
{
//关闭连接
_connection.Close();
}
return(intRoleID);
}
/// <summary>
/// 更新角色信息
/// </summary>
/// <param name="tb_Role"></param>
/// <param name="lstModuleID"></param>
private void Update(TB_Role tb_Role, List <int> lstModuleID)
{
TB_RoleConnectModule mTB_RoleConnectModule = null;
//启用事务
_db = DBO.CreateDatabase();
_connection = _db.CreateConnection();
_connection.Open();
_tran = _connection.BeginTransaction();
try
{
//更新角色信息
_mTB_RoleDAL.Edit(tb_Role, _tran, _db);
//删除角色关联模块信息
_mTB_RoleConnectModuleDAL.Delete(tb_Role.ID, _tran, _db);
//添加角色关联模块信息
foreach (var item in lstModuleID)
{
mTB_RoleConnectModule = new TB_RoleConnectModule()
{
RoleID = tb_Role.ID,
ModuleID = item,
};
_mTB_RoleConnectModuleDAL.Create(mTB_RoleConnectModule, _tran, _db);
}
//提交事务
_tran.Commit();
}
catch
{
//回滚事务
_tran.Rollback();
}
finally
{
//关闭连接
_connection.Close();
}
}
private void Bind(int intCurrentIndex)
{
TB_Role mTB_Role = new TB_Role();
RoleBLL mRoleBLL = new RoleBLL();
Pager pager = new Pager();
DataTable dtSource = null;
pager.CurrentPageIndex = intCurrentIndex;
pager.srcOrder = " ID desc";
mTB_Role.SiteID = (base.UserInfo == null ? base.SystemAdminInfo.SiteID : base.UserInfo.SiteID);
mTB_Role.Name = this.txtRoleName.Text.Trim();
dtSource = mRoleBLL.GetPagerData(mTB_Role, ref pager);
GridView1.DataSource = dtSource;
GridView1.DataBind();
this.Pager1.ItemCount = pager.TotalRecord;
this.Pager1.PageCount = pager.TotalPage;
this.Pager1.CurrentIndex = pager.CurrentPageIndex;
this.Pager1.PageSize = pager.PageSize;
}
private void NewRole()
{
var role = new TB_Role();
role.AddTime = DateTime.Now;
role.Description = txtDescription.Value.Trim();
role.IsAdministrator = cbIsAdmin.Checked;
role.IsDefault = cbIsDefault.Checked;
role.Name = txtName.Value.Trim();
role.Delete = false;
role.Permission = PermissionInstance.GetDefaultMenus();
RoleInstance.Add(role);
// 记录历史
var his = new TB_AccountHistory();
his.Account = Account.id;
his.ActionId = ActionInstance.Find(f => f.Name.Equals("AddRole")).id;
his.Ip = Utility.GetClientIP(this.Context);
his.ObjectA = "[id=" + role.id + "] " + role.Name;
SaveHistory(his);
ShowNotification("./role_list.aspx", "Success: You added a new role.", true);
}
/// <summary>
/// 事务添加
/// </summary>
/// <param name="info"></param>
/// <param name="tran"></param>
/// <param name="db"></param>
/// <returns></returns>
public int Create(TB_Role info, DbTransaction tran, Database db)
{
DbCommand dbCommandWrapper = null;
int intId;
string strInsertSql = "INSERT INTO TB_Role(SiteID,Name) VALUES(@SiteID,@Name)";
string strSelectIdSql = ";SELECT SCOPE_IDENTITY()";
try
{
dbCommandWrapper = db.GetSqlStringCommand(strInsertSql + strSelectIdSql);
#region Add parameters
db.AddInParameter(dbCommandWrapper, "@SiteID", DbType.Int32, info.SiteID);
db.AddInParameter(dbCommandWrapper, "@Name", DbType.String, info.Name);
#endregion
if (tran == null)
{
intId = Convert.ToInt32(db.ExecuteScalar(dbCommandWrapper));
}
else
{
intId = Convert.ToInt32(db.ExecuteScalar(dbCommandWrapper, tran));
}
return(intId);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (dbCommandWrapper != null)
{
dbCommandWrapper = null;
}
}
}
/// <summary>
/// 获取分页数据
/// </summary>
/// <param name="tb_Role"></param>
/// <param name="pager"></param>
/// <returns></returns>
public DataTable GetPagerData(TB_Role tb_Role, ref Pager pager)
{
return(_mTB_RoleDAL.GetTable(tb_Role, ref pager));
}
