/// <summary> /// 删除一级类目 /// </summary> /// <returns></returns> public bool TopClassDelete(int 类目ID) { //int rows; //rows = DataSql.ExecuteSql("delete 一级类目 where 类目ID = " + 类目ID); //if (rows > 0) //{ // return true; //} //else //{ // return false; //} ArrayList SqlList = new ArrayList(); SqlList.Add("delete from 角色权限 where 一级类目ID = " + 类目ID); SqlList.Add("delete from 一级类目 where 类目ID = " + 类目ID); try { DataSql.ExecuteSqlTran(SqlList); return(true); } catch { return(false); } }
/// <summary> /// 删除全宗 /// </summary> /// <returns></returns> public bool DeptDelete(int 全宗ID) { //int rows; //rows = DataSql.ExecuteSql("delete 全宗 where 全宗ID = " + 全宗ID); //if (rows > 0) //{ // return true; //} //else //{ // return false; //} ArrayList SqlList = new ArrayList(); SqlList.Add("delete from 角色权限 where 全宗ID = " + 全宗ID); SqlList.Add("delete from 全宗 where 全宗ID = " + 全宗ID); try { DataSql.ExecuteSqlTran(SqlList); return(true); } catch { return(false); } }
/// <summary> /// 删除角色信息 /// </summary> /// <param name="RoleID"></param> /// <returns></returns> public bool RoleDelete(int RoleID) { ArrayList SqlList = new ArrayList(); SqlList.Add("delete from 用户角色 where 角色ID = " + RoleID); SqlList.Add("delete from 角色权限 where 角色ID = " + RoleID); SqlList.Add("delete from 角色 where 角色ID =" + RoleID); try { DataSql.ExecuteSqlTran(SqlList); return(true); } catch { return(false); } }
/// <summary> /// 删除用户 /// </summary> /// <returns></returns> public bool UserDelete(int UserID) { //先判断用户是否拥有角色 StringBuilder strSelect = new StringBuilder(); strSelect.Append("SELECT COUNT(*) FROM 用户角色 "); strSelect.Append(" WHERE 用户ID = " + UserID); bool cmdresult = DataSql.Exists(strSelect.ToString()); if (!cmdresult) { //rows = DataSql.ExecuteSql("delete 用户 where 用户ID = " + UserID); ArrayList SqlList = new ArrayList(); SqlList.Add("delete from 用户角色 where 用户ID = " + UserID); SqlList.Add("delete from 用户 where 用户ID = " + UserID); try { DataSql.ExecuteSqlTran(SqlList); return(true); } catch { return(false); } } else { //rows = 0; MessageBox.Show("不允许删除拥有角色的用户!", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return(false); } //if (rows > 0) //{ // return true; //} //else //{ // return false; //} }