public virtual bool AddRBACPrivilege(RBACPrivilegeInfo entity)
{
string SqlAdd = null;
DataTable DtAdd = null;
DataRow DrAdd = null;
SqlAdd = "SELECT TOP 0 * FROM RBAC_Privilege";
DtAdd = DBHelper.Query(SqlAdd);
DrAdd = DtAdd.NewRow();
//DrAdd["RBAC_Privilege_ID"] = entity.RBAC_Privilege_ID;
DrAdd["RBAC_Privilege_ResourceID"] = entity.RBAC_Privilege_ResourceID;
DrAdd["RBAC_Privilege_Name"] = entity.RBAC_Privilege_Name;
DrAdd["RBAC_Privilege_IsActive"] = entity.RBAC_Privilege_IsActive;
DrAdd["RBAC_Privilege_Addtime"] = entity.RBAC_Privilege_Addtime;
DtAdd.Rows.Add(DrAdd);
try
{
DBHelper.SaveChanges(SqlAdd, DtAdd);
return(true);
}
catch (Exception ex)
{
throw ex;
}
finally
{
DtAdd.Dispose();
}
}
public virtual RBACPrivilegeInfo GetRBACPrivilegeByID(string ID)
{
RBACPrivilegeInfo entity = null;
SqlDataReader RdrList = null;
try
{
string SqlList;
SqlList = "SELECT * FROM RBAC_Privilege WHERE RBAC_Privilege_ID = '" + ID + "'";
RdrList = DBHelper.ExecuteReader(SqlList);
if (RdrList.Read())
{
entity = new RBACPrivilegeInfo();
entity.RBAC_Privilege_ID = Tools.NullStr(RdrList["RBAC_Privilege_ID"]);
entity.RBAC_Privilege_ResourceID = Tools.NullInt(RdrList["RBAC_Privilege_ResourceID"]);
entity.RBAC_Privilege_Name = Tools.NullStr(RdrList["RBAC_Privilege_Name"]);
entity.RBAC_Privilege_IsActive = Tools.NullInt(RdrList["RBAC_Privilege_IsActive"]);
entity.RBAC_Privilege_Addtime = Tools.NullDate(RdrList["RBAC_Privilege_Addtime"]);
}
return(entity);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (RdrList != null)
{
RdrList.Close();
RdrList = null;
}
}
}
public virtual IList <RBACPrivilegeInfo> GetPrivilegeListByRole(int Role_ID)
{
IList <RBACPrivilegeInfo> entitys = null;
RBACPrivilegeInfo entity = null;
string SqlList = "SELECT A.RBAC_Privilege_ID, A.RBAC_Privilege_ResourceID, A.RBAC_Privilege_Name";
SqlList += " FROM RBAC_Privilege AS A INNER JOIN RBAC_RolePrivilege AS B ON A.RBAC_Privilege_ID = B.RBAC_RolePrivilege_PrivilegeID";
SqlList += " WHERE B.RBAC_RolePrivilege_RoleID =" + Role_ID;
DataTable Dt = DBHelper.Query(SqlList);
if (Dt.Rows.Count > 0)
{
entitys = new List <RBACPrivilegeInfo>();
foreach (DataRow dr in Dt.Rows)
{
entity = new RBACPrivilegeInfo();
entity.RBAC_Privilege_ID = Tools.NullStr(dr["RBAC_Privilege_ID"]);
entity.RBAC_Privilege_ResourceID = Tools.NullInt(dr["RBAC_Privilege_ResourceID"]);
entity.RBAC_Privilege_Name = Tools.NullStr(dr["RBAC_Privilege_Name"]);
entitys.Add(entity);
entity = null;
}
}
return(entitys);
}
public void EditRBACPrivilege()
{
string RBAC_Privilege_ID = tools.CheckStr(Request.Form["RBAC_Privilege_ID"]);
int RBAC_Privilege_ResourceID = tools.CheckInt(Request.Form["RBAC_Privilege_ResourceID"]);
string RBAC_Privilege_Name = tools.CheckStr(Request.Form["RBAC_Privilege_Name"]);
int RBAC_Privilege_IsActive = tools.CheckInt(Request.Form["RBAC_Privilege_IsActive"]);
RBACPrivilegeInfo entity = GetRBACPrivilegeByID(RBAC_Privilege_ID);
if (entity != null)
{
entity.RBAC_Privilege_ID = RBAC_Privilege_ID;
entity.RBAC_Privilege_ResourceID = RBAC_Privilege_ResourceID;
entity.RBAC_Privilege_Name = RBAC_Privilege_Name;
if (MyBLL.EditRBACPrivilege(entity, Public.GetUserPrivilege()))
{
Public.Msg("positive", "操作成功", "操作成功", true, "privilege_list.aspx");
}
else
{
Public.Msg("error", "错误信息", "操作失败，请稍后重试", false, "{back}");
}
}
else
{
Public.Msg("error", "错误信息", "操作失败，请稍后重试", false, "{back}");
}
}
public virtual bool EditRBACPrivilege(RBACPrivilegeInfo entity, RBACUserInfo UserPrivilege)
{
if (RBAC.CheckPrivilege(UserPrivilege, "51be7b46-e0f7-46dd-b0b2-a462fcb907ae"))
{
return(MyDAL.EditRBACPrivilege(entity));
}
else
{
throw new TradePrivilegeException("没有权限，权限代码：51be7b46-e0f7-46dd-b0b2-a462fcb907ae错误");
}
}
public virtual bool AddRBACPrivilege(RBACPrivilegeInfo entity, RBACUserInfo UserPrivilege)
{
if (RBAC.CheckPrivilege(UserPrivilege, "df7e7e2e-bbe2-48b0-976c-17a74c4a45e6"))
{
return(MyDAL.AddRBACPrivilege(entity));
}
else
{
throw new TradePrivilegeException("没有权限，权限代码：df7e7e2e-bbe2-48b0-976c-17a74c4a45e6错误");
}
}
public virtual IList <RBACPrivilegeInfo> GetRBACPrivileges(QueryInfo Query)
{
int PageSize;
int CurrentPage;
IList <RBACPrivilegeInfo> entitys = null;
RBACPrivilegeInfo entity = null;
string SqlList, SqlField, SqlOrder, SqlParam, SqlTable;
SqlDataReader RdrList = null;
try
{
CurrentPage = Query.CurrentPage;
PageSize = Query.PageSize;
SqlTable = "RBAC_Privilege";
SqlField = "*";
SqlParam = DBHelper.GetSqlParam(Query.ParamInfos);
SqlOrder = DBHelper.GetSqlOrder(Query.OrderInfos);
SqlList = DBHelper.GetSqlPage(SqlTable, SqlField, SqlParam, SqlOrder, CurrentPage, PageSize);
RdrList = DBHelper.ExecuteReader(SqlList);
if (RdrList.HasRows)
{
entitys = new List <RBACPrivilegeInfo>();
while (RdrList.Read())
{
entity = new RBACPrivilegeInfo();
entity.RBAC_Privilege_ID = Tools.NullStr(RdrList["RBAC_Privilege_ID"]);
entity.RBAC_Privilege_ResourceID = Tools.NullInt(RdrList["RBAC_Privilege_ResourceID"]);
entity.RBAC_Privilege_Name = Tools.NullStr(RdrList["RBAC_Privilege_Name"]);
entity.RBAC_Privilege_IsActive = Tools.NullInt(RdrList["RBAC_Privilege_IsActive"]);
entity.RBAC_Privilege_Addtime = Tools.NullDate(RdrList["RBAC_Privilege_Addtime"]);
entitys.Add(entity);
entity = null;
}
}
return(entitys);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (RdrList != null)
{
RdrList.Close();
RdrList = null;
}
}
}
public void AddRBACRole()
{
int RBAC_Role_ID = tools.CheckInt(Request.Form["RBAC_Role_ID"]);
string RBAC_Role_Name = tools.CheckStr(Request.Form["RBAC_Role_Name"]);
string RBAC_Role_Description = tools.CheckStr(Request.Form["RBAC_Role_Description"]);
int RBAC_Role_IsSystem = tools.CheckInt(Request.Form["RBAC_Role_IsSystem"]);
string[] strPrivilege = tools.CheckStr(Request.Form["privilege_id"]).Split(',');
IList <RBACPrivilegeInfo> privilegeList = new List <RBACPrivilegeInfo>();
RBACPrivilegeInfo privilege;
foreach (string privilege_id in strPrivilege)
{
if (privilege_id != "")
{
privilege = new RBACPrivilegeInfo();
privilege.RBAC_Privilege_ID = privilege_id;
privilegeList.Add(privilege);
privilege = null;
}
}
RBACRoleInfo entity = new RBACRoleInfo();
entity.RBAC_Role_ID = RBAC_Role_ID;
entity.RBAC_Role_Name = RBAC_Role_Name;
entity.RBAC_Role_Description = RBAC_Role_Description;
entity.RBAC_Role_IsSystem = RBAC_Role_IsSystem;
entity.RBAC_Role_Site = "CN";
entity.RBACPrivilegeInfos = privilegeList;
privilegeList = null;
if (MyBLL.AddRBACRole(entity, Public.GetUserPrivilege()))
{
Public.Msg("positive", "操作成功", "操作成功", true, "RBAC_Role_add.aspx");
}
else
{
Public.Msg("error", "错误信息", "操作失败，请稍后重试", false, "{back}");
}
}
public void AddRBACPrivilege()
{
int RBAC_Privilege_ResourceID = tools.CheckInt(Request.Form["RBAC_Privilege_ResourceID"]);
string RBAC_Privilege_Name = tools.CheckStr(Request.Form["RBAC_Privilege_Name"]);
int RBAC_Privilege_IsActive = tools.CheckInt(Request.Form["RBAC_Privilege_IsActive"]);
RBACPrivilegeInfo entity = new RBACPrivilegeInfo();
entity.RBAC_Privilege_ID = "0";
entity.RBAC_Privilege_ResourceID = RBAC_Privilege_ResourceID;
entity.RBAC_Privilege_Name = RBAC_Privilege_Name;
entity.RBAC_Privilege_IsActive = 1;
entity.RBAC_Privilege_Addtime = DateTime.Now;
if (MyBLL.AddRBACPrivilege(entity, Public.GetUserPrivilege()))
{
Public.Msg("positive", "操作成功", "操作成功", true, "privilege_list.aspx");
}
else
{
Public.Msg("error", "错误信息", "操作失败，请稍后重试", false, "{back}");
}
}
public virtual bool EditRBACPrivilege(RBACPrivilegeInfo entity)
{
string SqlAdd = null;
DataTable DtAdd = null;
DataRow DrAdd = null;
SqlAdd = "SELECT * FROM RBAC_Privilege WHERE RBAC_Privilege_ID = '" + entity.RBAC_Privilege_ID + "'";
DtAdd = DBHelper.Query(SqlAdd);
try
{
if (DtAdd.Rows.Count > 0)
{
DrAdd = DtAdd.Rows[0];
DrAdd["RBAC_Privilege_ID"] = entity.RBAC_Privilege_ID;
DrAdd["RBAC_Privilege_ResourceID"] = entity.RBAC_Privilege_ResourceID;
DrAdd["RBAC_Privilege_Name"] = entity.RBAC_Privilege_Name;
DrAdd["RBAC_Privilege_IsActive"] = entity.RBAC_Privilege_IsActive;
DrAdd["RBAC_Privilege_Addtime"] = entity.RBAC_Privilege_Addtime;
DBHelper.SaveChanges(SqlAdd, DtAdd);
}
else
{
return(false);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
DtAdd.Dispose();
}
return(true);
}
