删除一条数据

 

/// <summary>
  /// 删除一条数据
  /// </summary>
        /// <param name="GroupID">分组ID</param>
        /// <returns></returns>
        public int DeleteGroup(int GroupID)
  {
            int ret = 0;
            string strSql1 = "Select RoleID from RGP_Roles where RoleGroupID=@GroupID"; //查看应组下是否存在角色
            string strSql2 = "Select UserID from Users where UserGroup=@GroupID";        //查看应组下是否存在用户
            string strSql3 = "delete RGP_Groups where GroupID=@GroupID";           

   SqlParameter[] parameters = {
     new SqlParameter("@GroupID", SqlDbType.Int,4)};
   parameters[0].Value = GroupID;

            if (!SqlServerHelper.Exists(strSql1.ToString(), parameters))
            {
                if (!SqlServerHelper.Exists(strSql2.ToString(), parameters))
                {
                    if (SqlServerHelper.ExecuteSql(strSql3.ToString(), parameters) >= 1)
                    {
                        ret = 1;//删除成功
                    }
                }
                else
                {
                    ret = 2;//有用户，不能删除
                }
            }
            else
            {
                ret = 3;//有角色，不能删除
            }

            return ret;
  }