public void UpdateSYS_Right(SYS_Right sys_right) { DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString); conn.Open(); try { List <DbParameter> para = new List <DbParameter>(); para.Add(_DbHelper.CreateParameter(FIELD_ID, sys_right.ID, false)); para.Add(_DbHelper.CreateParameter(FIELD_FUNCNAME, sys_right.FuncName, false)); para.Add(_DbHelper.CreateParameter(FIELD_TAG, sys_right.Tag, false)); para.Add(_DbHelper.CreateParameter(FIELD_MODULEID, sys_right.ModuleID, false)); //para.Add(_DbHelper.CreateParameter(FIELD_MODULEID, sys_right.ModuleID, false)); para.Add(_DbHelper.CreateParameter(FIELD_FuncID, sys_right.FuncId, false)); _DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_Right_Update]", para.ToArray()); } catch (Exception ex) { throw new Exception(String.Format("SYS_RightDataAccess.Update: {0}", ex.Message)); } finally { conn.Close(); } }
protected void grvSys_Right_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e) { SYS_Right sysRight = new SYS_Right(); try { //if (CheckName(e.NewValues["FuncName"].ToString()) && CheckID(e.NewValues["FuncId"].ToString())) if (CheckName(e.NewValues["FuncName"].ToString())) { int lstRight = sys_right.SelectMaxFuncID(); int i = lstRight + 1; sysRight.FuncName = e.NewValues["FuncName"].ToString(); sysRight.FuncId = i.ToString(); sysRight.Tag = i.ToString(); sysRight.ModuleID = (int)e.NewValues["ModuleID"]; sys_right.InsertSYS_Right(sysRight); _DataBind(); e.Cancel = true; grvSys_Right.CancelEdit(); } else { throw new Exception("Trùng tên ! Vui lòng nhập lại"); } } catch (Exception ex) { throw new Exception(string.Format("Trùng tên! Vui lòng nhập lại")); } }
protected void btnThemQuyen_Click(object sender, EventArgs e) { SYS_RightOfUser rightOfUser = null; List <SYS_RightOfUser> sysRightOfUsers = new List <SYS_RightOfUser>(); if (grvChonChucNang.Selection.Count == 0) { pcChonChucNang.ShowOnPageLoad = false; return; } List <Object> keyvalues = grvChonChucNang.GetSelectedFieldValues("ID"); int UserID = (int)GridUser.GetRowValues(GridUser.FocusedRowIndex, "ID"); foreach (int key in keyvalues) { rightOfUser = new SYS_RightOfUser(); rightOfUser.Approve = true; rightOfUser.Create = true; rightOfUser.Delete = true; rightOfUser.Update = true; rightOfUser.RightId = key; rightOfUser.UserId = UserID; sysRightOfUsers.Add(rightOfUser); } _ISYS_RightUserService.InsertSYS_RightOfUser(sysRightOfUsers); GridUser_CustomCallback(null, null); grvChonChucNang.Selection.UnselectAll(); pcChonChucNang.ShowOnPageLoad = false; }
protected void Grd_HtmlCommandCellPrepared(object sender, DevExpress.Web.ASPxGridViewTableCommandCellEventArgs e) { if (e.CommandCellType == GridViewTableCommandCellType.Data) { SYS_Right right = (SYS_Right)Session["Right"]; if (right == null) { return; } for (int i = 0; i < e.Cell.Controls.Count; i++) { if (!right.IsCreate) { btnThem.Visible = false; //e.Cell.Controls[1].Visible = false; } if (!right.IsUpdate) { e.Cell.Controls[0].Visible = false; } if (!right.IsDelete) { e.Cell.Controls[1].Visible = false; } } } }
protected void grvSys_Right_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e) { SYS_Right sysRight = new SYS_Right(); try { sysRight.ID = (int)e.Keys["ID"]; sysRight.FuncName = e.NewValues["FuncName"].ToString(); SYS_Right right = sys_right.SelectSYS_Right(sysRight.ID); sysRight.FuncId = right.FuncId; sysRight.ModuleID = (int)e.NewValues["ModuleID"]; if (e.NewValues["FuncName"].ToString().ToLower() != e.OldValues["FuncName"].ToString().ToLower()) { if (!CheckName(e.NewValues["FuncName"].ToString())) { throw new Exception("Trùng tên ! Vui lòng nhập lại"); } } //if (e.NewValues["FuncId"].ToString().ToLower() != e.OldValues["FuncId"].ToString().ToLower()) //{ // if (!CheckID(e.NewValues["FuncId"].ToString())) // { // throw new Exception("Trùng mã ! Vui lòng nhập lại"); // } //} sys_right.UpdateSYS_Right(sysRight); _DataBind(); e.Cancel = true; grvSys_Right.CancelEdit(); } catch (Exception ex) { throw new Exception(string.Format("Trùng tên vui lòng nhập lại.")); } }
protected void Page_Load(object sender, EventArgs e) { SYS_Session session = (SYS_Session)Session["SYS_Session"]; if (session == null || session.User.USERNAME == "Guest") { session.CurrentPage = Request.AppRelativeCurrentExecutionFilePath; Response.Redirect("~\\Login.aspx"); } else { List <SYS_Right> right = session.User.Rights; foreach (SYS_Right sysRight in right) { if (sysRight.FuncId == funcid) { rightOfUser = sysRight; Session["Right"] = sysRight; Session["UserId"] = session.User.IDUSER; Session["FunctionId"] = sysRight.FuncId; break; } } if (rightOfUser == null) { Session["Status"] = "0"; Response.Redirect("~\\HeThong\\Default.aspx"); } } Session["SYS_Session"] = session; _DataBind(); }
public SYS_Right SelectSYS_Right(int ID) { DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString); conn.Open(); SYS_Right sys_right = new SYS_Right(); DbDataReader reader = null; try { List <DbParameter> para = new List <DbParameter>(); para.Add(_DbHelper.CreateParameter(FIELD_ID, ID, false)); reader = _DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_Right_GetByID]", para.ToArray()); if (reader.HasRows && reader.Read()) { SYS_RightDataAccess.SetSYS_RightInfo(reader, ref sys_right); } return(sys_right); } catch (Exception ex) { throw new Exception(String.Format("SYS_RightDataAccess.SelectById: {0}", ex.Message)); } finally { if (reader != null) { reader.Close(); } conn.Close(); } }
public int InsertSYS_Right(SYS_Right sys_right) { DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString); conn.Open(); try { List <DbParameter> para = new List <DbParameter>(); DbParameter ouput = _DbHelper.CreateParameter(FIELD_ID, DbType.Int32, true); para.Add(_DbHelper.CreateParameter(FIELD_FUNCNAME, sys_right.FuncName, false)); para.Add(_DbHelper.CreateParameter(FIELD_TAG, sys_right.Tag, false)); para.Add(_DbHelper.CreateParameter(FIELD_MODULEID, sys_right.ModuleID, false)); para.Add(_DbHelper.CreateParameter(FIELD_FuncID, sys_right.FuncId, false)); para.Add(ouput); _DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_Right_Insert]", para.ToArray()); return((int)ouput.Value); } catch (Exception ex) { throw new Exception(String.Format("SYS_RightDataAccess.Insert: {0}", ex.Message)); } finally { conn.Close(); } }
private static void SetSYS_RightInfo(DbDataReader reader, ref SYS_Right sys_right) { sys_right.ID = int.Parse("0" + reader[FIELD_ID]); sys_right.FuncName = "" + reader[FIELD_FUNCNAME]; sys_right.Tag = "" + reader[FIELD_TAG]; sys_right.ModuleID = int.Parse("0" + reader[FIELD_MODULEID]); sys_right.FuncId = "" + reader[FIELD_FuncID]; }
protected void Page_Load(object sender, EventArgs e) { SYS_Session session = (SYS_Session)Session["SYS_Session"]; session.FuncID = funcid; if (!IsPostBack) { if (session == null || session.User.USERNAME == "Guest") { session.CurrentPage = Request.AppRelativeCurrentExecutionFilePath; Response.Redirect("~\\Login.aspx"); } else { if (Request.Cookies["IDUSER"].Value != "1") { List <SYS_Right> right = session.User.Rights; foreach (SYS_Right sysRight in right) { if (sysRight.FuncId == funcid) { rightOfUser = sysRight; if (!rightOfUser.IsCreate) { btnAdd.Enabled = false; } if (!rightOfUser.IsDelete) { btnRemove.Enabled = false; } if (!rightOfUser.IsUpdate) { btnSubmit.Enabled = false; } Session["UserId"] = session.User.IDUSER; Session["FunctionId"] = sysRight.FuncId; break; } } if (rightOfUser == null) { Session["Status"] = "0"; Response.Redirect("~\\HeThong\\Default.aspx"); } session.CurrentPage = Request.AppRelativeCurrentExecutionFilePath; } } Session["SYS_Session"] = session; _DataBind(); } else { grdRightOfRoles.DataSource = Session["ListRight"]; grdRightNotRoles.DataSource = Session["ListLeft"]; } }
private static void SetListSYS_RightInfo(ref DbDataReader reader, ref List <SYS_Right> sys_rights) { SYS_Right sys_right = null; while (reader.Read()) { sys_right = new SYS_Right(); SYS_RightDataAccess.SetSYS_RightInfo(reader, ref sys_right); sys_rights.Add(sys_right); } }
protected void btnAdd_Click(object sender, EventArgs e) { _lstRight = (List <SYS_Right>)Session["ListLeft"]; _lstRight1 = (List <SYS_Right>)Session["ListRight"]; if (grdRightNotRoles.Selection.Count == 0) { return; } List <Object> keyvalues = grdRightNotRoles.GetSelectedFieldValues("ID"); SYS_Right Right; foreach (object key in keyvalues) { Right = new SYS_Right(); // fix Right.ModuleID = 1; Right.SysModun = _lstRight[0].SysModun; Right.FuncId = grdRightNotRoles.GetRowValuesByKeyValue(key, "FuncId").ToString(); Right.FuncName = grdRightNotRoles.GetRowValuesByKeyValue(key, "FuncName").ToString(); Right.ID = int.Parse(key.ToString()); Right.Tag = key.ToString(); Right.ModuleName = grdRightNotRoles.GetRowValuesByKeyValue(key, "ModuleName").ToString(); //_lstRight.Remove(Right); for (int i = 0; i < _lstRight.Count; i++) { if (_lstRight[i].ID == Right.ID) { _lstRight.RemoveAt(i); } } Right.IsApprove = true; Right.IsCreate = true; Right.IsDelete = true; Right.IsUpdate = true; _lstRight1.Add(Right); //WriteLog("Insert " + Right.FuncName,Action.Create); } Session["ListLeft"] = _lstRight; grdRightNotRoles.DataSource = _lstRight; grdRightNotRoles.DataBind(); Session["ListRight"] = _lstRight1; grdRightOfRoles.DataSource = _lstRight1; grdRightOfRoles.DataBind(); grdRightOfRoles.Selection.UnselectAll(); grdRightNotRoles.Selection.UnselectAll(); }
public List <SYS_Right> GetRightsByRole(SYS_Roles roles) { DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString); conn.Open(); List <SYS_Right> result = new List <SYS_Right>(); DbDataReader reader = null; try { List <DbParameter> para = new List <DbParameter>(); para.Add(_DbHelper.CreateParameter("RoleID", roles.ID, false)); reader = _DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_Role_GetRightsByRole]", para.ToArray()); if (reader.HasRows) { SYS_ModunDataAccess modunDataAccess = new SYS_ModunDataAccess(); while (reader.Read()) { SYS_Right temp = new SYS_Right(); SetSYS_RightInfo(reader, ref temp); temp.IsApprove = Boolean.Parse(reader[FIELD_APPROVE].ToString()); temp.IsDelete = Boolean.Parse(reader[FIELD_DELETE].ToString()); temp.IsCreate = Boolean.Parse(reader[FIELD_CREATE].ToString()); temp.IsUpdate = Boolean.Parse(reader[FIELD_UPDATE].ToString()); temp.SysModun = modunDataAccess.SelectSYS_ModunTest(temp.ModuleID); if (temp.SysModun != null) { temp.ModuleName = temp.SysModun.Name; } result.Add(temp); } } return(result); } catch (Exception ex) { throw new Exception(String.Format("SYS_RightDataAccess.GetRightsByRole: {0}", ex.Message)); } finally { if (reader != null) { reader.Close(); } conn.Close(); } }
private static void SetListSYS_RightInfoModulName(ref DbDataReader reader, ref List <SYS_Right> sys_rights) { SYS_Right sys_right = null; SYS_ModunDataAccess isysModunDataAccess = new SYS_ModunDataAccess(); SYS_Modun sysModun = new SYS_Modun(); while (reader.Read()) { sys_right = new SYS_Right(); SYS_RightDataAccess.SetSYS_RightInfo(reader, ref sys_right); sysModun = isysModunDataAccess.SelectSYS_Modun(sys_right.ModuleID); sys_right.ModuleName = sysModun.Name; sys_rights.Add(sys_right); } }
public List <SYS_Right> GetRightsByNotUser(SYS_User user) { DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString); conn.Open(); List <SYS_Right> result = new List <SYS_Right>(); DbDataReader reader = null; try { List <DbParameter> para = new List <DbParameter>(); para.Add(_DbHelper.CreateParameter("UserID", user.ID, false)); reader = _DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_Right_GetByNotUser]", para.ToArray()); if (reader.HasRows) { SYS_ModunDataAccess modunDataAccess = new SYS_ModunDataAccess(); while (reader.Read()) { SYS_Right temp = new SYS_Right(); SetSYS_RightInfo(reader, ref temp); temp.IsApprove = false; temp.IsDelete = false; temp.IsCreate = false; temp.IsUpdate = false; temp.SysModun = modunDataAccess.SelectSYS_Modun(temp.ModuleID, conn); temp.ModuleName = temp.SysModun.Name; result.Add(temp); } } return(result); } catch (Exception ex) { throw new Exception(String.Format("SYS_RightDataAccess.GetRightsByNotUser: {0}", ex.Message)); } finally { if (reader != null) { reader.Close(); } conn.Close(); } }
public void UpdateSYS_Right(DbTransaction transaction, SYS_Right sys_right) { try { List <DbParameter> para = new List <DbParameter>(); para.Add(_DbHelper.CreateParameter(FIELD_ID, sys_right.ID, false)); para.Add(_DbHelper.CreateParameter(FIELD_FUNCNAME, sys_right.FuncName, false)); para.Add(_DbHelper.CreateParameter(FIELD_TAG, sys_right.Tag, false)); para.Add(_DbHelper.CreateParameter(FIELD_MODULEID, sys_right.ModuleID, false)); _DbHelper.ExecuteNonQuery(transaction, Common.DatabaseSchema + "[SYS_Right_Update]", para.ToArray()); } catch (Exception ex) { throw new Exception(String.Format("SYS_RightDataAccess.Update: {0}", ex.Message)); } }
protected void grvSys_Right_RowDeleting(object sender, DevExpress.Web.Data.ASPxDataDeletingEventArgs e) { SYS_Right objSys_right = new SYS_Right { ID = (int)e.Keys["ID"] }; try { sys_right.DeleteSYS_Right(objSys_right); _DataBind(); e.Cancel = true; } catch (Exception ex) { throw new Exception(string.Format("grvSys_Right_RowDeleting DeleteSYS_Right:")); } }
public List <SYS_Right> GetAllRightsByUser(SYS_User user, string connect) { List <SYS_Right> result = new List <SYS_Right>(); DbDataReader reader = null; SYS_ConfigConnectionDataAccess connectionDataAccess = new SYS_ConfigConnectionDataAccess(); connect = connectionDataAccess.DecryptSYS_ConfigConnection(connect); DbConnection dbConnection = Common.CreateConnection(connect); dbConnection.Open(); try { List <DbParameter> para = new List <DbParameter>(); para.Add(_DbHelper.CreateParameter("UserName", user.UserName, false)); reader = _DbHelper.ExecuteReader(dbConnection, Common.DatabaseSchema + "[SYS_ALLRight_GetByUser]", para.ToArray()); if (reader.HasRows) { while (reader.Read()) { SYS_Right temp = new SYS_Right(); SetSYS_RightInfo(reader, ref temp); temp.IsApprove = Boolean.Parse(reader[FIELD_APPROVE].ToString()); temp.IsDelete = Boolean.Parse(reader[FIELD_DELETE].ToString()); temp.IsCreate = Boolean.Parse(reader[FIELD_CREATE].ToString()); temp.IsUpdate = Boolean.Parse(reader[FIELD_UPDATE].ToString()); temp.ModuleID = int.Parse(reader[FIELD_MODULEID] + ""); result.Add(temp); } } return(result); } catch (Exception ex) { throw new Exception(String.Format("SYS_RightDataAccess.GetRightsByUser: {0}", ex.Message)); } finally { if (reader != null) { reader.Close(); } dbConnection.Close(); } }
protected void Page_Load(object sender, EventArgs e) { #region PhanQuyen MTCSYT.SYS_Session session = (MTCSYT.SYS_Session)Session["SYS_Session"]; if (session == null || session.User.USERNAME == "Guest") { Response.Redirect("~\\Login.aspx"); } else { if (Request.Cookies["IDUSER"].Value != "1") { List <SYS_Right> right = session.User.Rights; foreach (SYS_Right sysRight in right) { if (sysRight.FuncId == funcid) { rightOfUser = sysRight; Session["Right"] = sysRight; Session["UserId"] = session.User.IDUSER; Session["FunctionId"] = sysRight.FuncId; break; } } if (rightOfUser == null) { Session["Status"] = "0"; Response.Redirect("~\\HeThong\\Default.aspx"); } } } Session["SYS_Session"] = session; #endregion if (!IsPostBack) { cmbThang.Value = DateTime.Now.Month; cmbNam.Value = DateTime.Now.Year; } loadDanhMuc(); //if (!IsCallback) // _DataBind(); }
protected void btnDelete_Click(object sender, EventArgs e) { List <SYS_RightOfUser> lst = new List <SYS_RightOfUser>(); SYS_RightOfUser rightOfUser = null; List <Object> keyvalues = grdRightOfRoles.GetSelectedFieldValues("ID"); int UserID = (int)GridUser.GetRowValues(GridUser.FocusedRowIndex, "ID"); foreach (Object key in keyvalues) { rightOfUser = new SYS_RightOfUser(); rightOfUser.RightId = (int)key; rightOfUser.UserId = UserID; lst.Add(rightOfUser); } _ISYS_RightUserService.DeleteSYS_RightOfUser_ByUser(lst); //_DataBind(); GridUser_CustomCallback(null, null); grdRightOfRoles.Selection.UnselectAll(); }
protected void GrdLog_HtmlCommandCellPrepared(object sender, DevExpress.Web.ASPxGridViewTableCommandCellEventArgs e) { if (e.CommandCellType == DevExpress.Web.GridViewTableCommandCellType.Data) { SYS_Right right = (SYS_Right)Session["Right"]; if (right != null) { for (int i = 0; i < e.Cell.Controls.Count; i++) { if (!right.IsDelete && i == 0) { btnDeleteLog.Visible = false; e.Cell.Controls[0].Visible = false; } } // Edit =0; New = 1;Delete =2 } } }
protected void Page_Load(object sender, EventArgs e) { //#region [Phân quyền] SYS_Session session = (SYS_Session)Session["SYS_Session"]; if (session == null || session.User.USERNAME == "Guest") { session.CurrentPage = Request.AppRelativeCurrentExecutionFilePath; Response.Redirect("~\\Login.aspx"); } else { List <SYS_Right> right = session.User.Rights; foreach (SYS_Right sysRight in right) { if (sysRight.FuncId == funcid) { rightOfUser = sysRight; Session["Right"] = sysRight; Session["UserId"] = session.User.IDUSER; Session["FunctionId"] = sysRight.FuncId; break; } } if (rightOfUser == null) { Session["Status"] = "0"; Response.Redirect("~\\HeThong\\Default.aspx"); } } Session["SYS_Session"] = session; //#endregion _BindGrdRegion(); grdRegionOrganization_CustomCallback(null, null); if (IsCallback) { BinhGrdProvince(); } }
public void DeleteSYS_Right(SYS_Right sys_right) { DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString); conn.Open(); try { List <DbParameter> para = new List <DbParameter>(); para.Add(_DbHelper.CreateParameter(FIELD_ID, sys_right.ID, false)); _DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_Right_Delete]", para.ToArray()); } catch (Exception) { throw; } finally { conn.Close(); } }
public int InsertSYS_Right(DbTransaction transaction, SYS_Right sys_right) { try { List <DbParameter> para = new List <DbParameter>(); DbParameter ouput = _DbHelper.CreateParameter(FIELD_ID, DbType.Int32, true); para.Add(_DbHelper.CreateParameter(FIELD_FUNCNAME, sys_right.FuncName, false)); para.Add(_DbHelper.CreateParameter(FIELD_TAG, sys_right.Tag, false)); para.Add(_DbHelper.CreateParameter(FIELD_MODULEID, sys_right.ModuleID, false)); para.Add(ouput); _DbHelper.ExecuteNonQuery(transaction, Common.DatabaseSchema + "[SYS_Right_Insert]", para.ToArray()); return((int)ouput.Value); } catch (Exception ex) { throw new Exception(String.Format("SYS_RightDataAccess.Insert: {0}", ex.Message)); } }
protected void Page_Load(object sender, EventArgs e) { ScriptManager ScriptMan = ScriptManager.GetCurrent(this); //ScriptManager1.RegisterPostBackControl(btnOk); if (ScriptMan != null) { ScriptMan.RegisterPostBackControl(btnDownload); } var session = (SYS_Session)Session["SYS_Session"]; session.FuncID = funcid; if (session == null || session.User.USERNAME == "Guest") { session.CurrentPage = Request.AppRelativeCurrentExecutionFilePath; Response.Redirect("~\\Login.aspx"); } else { List <SYS_Right> right = session.User.Rights; foreach (SYS_Right sysRight in right) { if (sysRight.FuncId == funcid) { rightOfUser = sysRight; Session["Right"] = sysRight; Session["UserId"] = session.User.IDUSER; Session["FunctionId"] = sysRight.FuncId; break; } } if (rightOfUser == null) { Session["Status"] = "0"; Response.Redirect("~\\HeThong\\Default.aspx"); } } Session["SYS_Session"] = session; }
private static void SetSYS_LogInfo(DbDataReader reader, ref SYS_Log sys_log) { sys_log.ID = int.Parse("0" + reader[FIELD_ID]); sys_log.UserId = int.Parse("0" + reader[FIELD_USERID]); sys_log.FunctionId = int.Parse("0" + reader[FIELD_FUNCTIONID]); sys_log.Action = int.Parse("0" + reader[FIELD_ACTION]); sys_log.Description = "" + reader[FIELD_DESCRIPTION]; DateTime Time = (DateTime)reader[FIELD_TIME]; sys_log.Time = Time != null ? (DateTime)Time : DateTime.Now; sys_log.IDBC = int.Parse("0" + reader[FIELD_IDBC]); sys_log.PhanLoai = int.Parse("0" + reader[FIELD_PHANLOAI]); SYS_UserDataAccess sysUserDataAccess = new SYS_UserDataAccess(); SYS_User sysUser = sysUserDataAccess.SelectSYS_User(sys_log.UserId); sys_log.Username = sysUser.Name; SYS_RightDataAccess sysRightDataAccess = new SYS_RightDataAccess(); SYS_Right sysRight = sysRightDataAccess.SelectSYS_Right(sys_log.FunctionId); sys_log.FuncName = sysRight.FuncName; }
public int InsertSYS_Right(SYS_Right sys_right) { return(_sys_rightDataAccess.InsertSYS_Right(sys_right)); }
public void UpdateSYS_Right(SYS_Right sys_right) { _sys_rightDataAccess.UpdateSYS_Right(sys_right); }
public void DeleteSYS_Right(SYS_Right sys_rights) { _sys_rightDataAccess.DeleteSYS_Right(sys_rights); }