/// <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;
//}
}
